ton.prices_daily

TON daily token price aggregates — historical pricing data for Toncoin and Jetton tokens.

Table Description

The ton.prices_daily table 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

Column	type	Description
blockchain	varchar	Blockchain for the token (Equals to ton)
token_address	varchar	Token (Jetton) address in raw format
timestamp	timestamp	Start of the day in UTC
price_ton	double precision	Jetton price in TON (ignoring decimals)
price_usd	double precision	Jetton price in USD (ignoring decimals)
asset_type	varchar	Asset 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.