> ## 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.dex_trades

> TON DEX trades — swaps on DeDust, STON.fi, and other TON decentralized exchanges.

export const TableSample = ({tableName, tableSchema}) => <>
    <div className="hidden dark:block">
      <iframe src={`https://dune.com/embeds/3419983/5785629?table_schema_t6f0df=${tableSchema}&table_name_t6f0df=${tableName}&darkMode=true`} style={{
  width: '100%',
  height: '500px',
  border: 'none',
  marginTop: '10px'
}} />
    </div>
    <div className="dark:hidden">
      <iframe src={`https://dune.com/embeds/3419983/5785629?table_schema_t6f0df=${tableSchema}&table_name_t6f0df=${tableName}`} style={{
  width: '100%',
  height: '500px',
  border: 'none',
  marginTop: '10px'
}} />
    </div>
  </>;

## Table Description

The `ton.dex_trades` table records of all trades executed on decentralized exchanges within the TON ecosystem. This table is partitioned by block\_date.

## Column Descriptions

| **Column**                 | **Type**      | **Description**                                              |
| -------------------------- | ------------- | ------------------------------------------------------------ |
| **block\_time**            | timestamp     | Timestamp of when the block containing the trade was created |
| **block\_date**            | date          | Date of when the block containing the trade was created      |
| **tx\_hash**               | string        | Transaction hash of the trade                                |
| **trace\_id**              | string        | Trace identifier for trade tracking                          |
| **project\_type**          | string        | Type of DEX project                                          |
| **project**                | string        | Name of the DEX project                                      |
| **version**                | int           | Version of the DEX protocol                                  |
| **event\_time**            | int           | Unix timestamp of the trade event                            |
| **event\_type**            | string        | Type of the trade event                                      |
| **trader\_address**        | string        | Address of the trader                                        |
| **pool\_address**          | string        | Address of the liquidity pool                                |
| **router\_address**        | string        | Address of the DEX router                                    |
| **token\_sold\_address**   | string        | Address of the token sold                                    |
| **token\_bought\_address** | string        | Address of the token bought                                  |
| **amount\_sold\_raw**      | decimal(38,0) | Raw amount of tokens sold                                    |
| **amount\_bought\_raw**    | decimal(38,0) | Raw amount of tokens bought                                  |
| **referral\_address**      | string        | Address of the referral                                      |
| **platform\_tag**          | string        | Tag identifying the platform                                 |
| **query\_id**              | decimal(20,0) | Query identifier                                             |
| **volume\_usd**            | decimal(20,6) | Trade volume in USD                                          |
| **volume\_ton**            | decimal(20,9) | Trade volume in TON                                          |
| **updated\_at**            | timestamp     | Last time the record was updated                             |
| **ingested\_at**           | timestamp     | Time when the record was ingested                            |

## Table Sample

<TableSample tableSchema="ton" tableName="dex_trades" />