Table Description

Contains daily prices for most popular assets. All prices are derived from onchain events, the following types of assets are supported:
  • Jettons with sufficient trading volume on DEXs
  • DEX LP tokens (based on ton.dex_pools TVL values)
  • StormTrade LP tokens
  • tsUSDe
This table is created using this SQL.

Column Descriptions

ColumntypeDescription
blockchainvarcharBlockchain for the token (Equals to ton)
token_addressvarcharToken (Jetton) address in raw format
timestamptimestampStart of the day in UTC
price_tondouble precisionJetton price in TON (ignoring decimals)
price_usddouble precisionJetton price in USD (ignoring decimals)
asset_typevarcharAsset type: Jetton (price is based on DEX trades), DEX LP, SLP (StormTrade LP token) or tsUSDe
Note: price_ton and price_usd values are already adjusted for token decimals, so multiplying token amounts by these prices will give the correct value without needing decimal conversion.

Table Sample

Table sample can be found here.