prices

Prices

Centralized exchanges price feeds

Market tables exist for all supported currencies (STX, BTC, MIA, and DIKO):

• prices.stx_usd

• prices.btc_usd

• prices.mia_usd

• prices.diko_usd

All market tables have the same schema:

Column	Type	Description
ts	time
timeframe	text	HOUR or DAY
open	numeric
high	numeric
low	numeric
close	numeric
volume	numeric

Decentralized exchanges (DEX) token price tables

prices.dex_coins_direct

Column	Type	Description
contract_id	text	Swap pool contract_id
token_x	text	Asset identifier of token on left side
token_y	text	Asset identifier of token on right side
block_height	integer	Block number
price	numeric	token_y price in token_x denomination

Decentralized exchanges (DEX) pool token price tables

prices.dex_pool_tokens

Column	Type	Description
contract_id	text	Swap pool contract_id
token_x	text	Asset identifier of token on left side
token_y	text	Asset identifier of token on right side
block_height	integer	Block number
price	numeric	token_y price in token_x denomination

prices.dex_tokens_15m, dex_tokens_1h, dex_tokens_1d

Column	Type	Description
ts	timestamp	time of the price point
contract_id	text	Swap pool contract_id
token_x	text	Asset identifier of token on left side
token_y	text	Asset identifier of token on right side
price	numeric	average token_y price in token_x denomination

prices.dex_tokens_stx

Prices extracted from distributed exchanges nominated in STX

Column	Type	Description
timeframe	text	'15M', 'HOUR', 'DAY'
ts	timestamp with time zone	time of the price point
token	text	Asset identifier of token
price	numeric	average token's price in STX

prices.swap_balances

Balances extracted from selected swap pools

Column	Type	Description
block_height	text
contract_id	text	short contract name
token_x	text	Asset identifier of the base token
token_y	text	Asset identifier of the target token
balance_x	numeric	The balance of token_x in the pool
balance_y	numeric	The balance of token_y in the pool