ton.defi Table: fact_dex_trades Type: Base Table
What
Contains DEX and launchpad trading data, capturing swap events across different decentralized exchanges and launchpad platforms in the TON ecosystem.Columns
| Column Name | Data Type | Description |
|---|---|---|
| BLOCK_TIMESTAMP | TIMESTAMP_NTZ | BLOCK_TIMESTAMP column |
| EVENT_TYPE | TEXT | EVENT_TYPE column |
| TX_HASH | TEXT | TX_HASH column |
| PROJECT_TYPE | TEXT | PROJECT_TYPE column |
| PROJECT | TEXT | PROJECT column |
| POOL_ADDRESS | TEXT | POOL_ADDRESS column |
| VERSION | NUMBER | VERSION column |
| TRADER_ADDRESS | TEXT | TRADER_ADDRESS column |
| TOKEN_BOUGHT_ADDRESS | TEXT | TOKEN_BOUGHT_ADDRESS column |
| TOKEN_SOLD_ADDRESS | TEXT | TOKEN_SOLD_ADDRESS column |
| AMOUNT_BOUGHT_RAW | NUMBER | AMOUNT_BOUGHT_RAW column |
| AMOUNT_SOLD_RAW | NUMBER | AMOUNT_SOLD_RAW column |
| ROUTER_ADDRESS | TEXT | ROUTER_ADDRESS column |
| VOLUME_TON | NUMBER | VOLUME_TON column |
| VOLUME_USD | NUMBER | VOLUME_USD column |
| REFERRAL_ADDRESS | TEXT | REFERRAL_ADDRESS column |
| PLATFORM_TAG | TEXT | PLATFORM_TAG column |
| TRACE_ID | TEXT | TRACE_ID column |
| QUERY_ID | NUMBER | QUERY_ID column |
| EVENT_TIME | NUMBER | EVENT_TIME column |
| FACT_DEX_TRADES_ID | TEXT | FACT_DEX_TRADES_ID column |
| INSERTED_TIMESTAMP | TIMESTAMP_NTZ | INSERTED_TIMESTAMP column |
| MODIFIED_TIMESTAMP | TIMESTAMP_NTZ | MODIFIED_TIMESTAMP column |