> ## Documentation Index
> Fetch the complete documentation index at: https://docs.dune.com/llms.txt
> Use this file to discover all available pages before exploring further.

# 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](https://github.com/duneanalytics/spellbook/blob/main/dbt_subprojects/daily_spellbook/models/ton/ton_jetton_price_daily.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](https://dune.com/queries/3419983/5785629?table_name_t6f0df=prices_daily\&table_schema_t6f0df=ton).