ton.defi Table: fact_dex_pools Type: Base Table
What
Contains history of DEX pools states including static information about pools, reserves, and estimated TVL values. Each state includes information about the jettons in the pool, fees, and liquidity metrics.Columns
| Column Name | Data Type | Description |
|---|---|---|
| BLOCK_TIMESTAMP_LAST_UPDATED | TIMESTAMP_NTZ | BLOCK_TIMESTAMP_LAST_UPDATED column |
| BLOCK_TIMESTAMP_DISCOVERED_AT | TIMESTAMP_NTZ | BLOCK_TIMESTAMP_DISCOVERED_AT column |
| PROJECT | TEXT | PROJECT column |
| POOL | TEXT | POOL column |
| VERSION | NUMBER | VERSION column |
| IS_LIQUID | BOOLEAN | IS_LIQUID column |
| RESERVES_RIGHT | NUMBER | RESERVES_RIGHT column |
| RESERVES_LEFT | NUMBER | RESERVES_LEFT column |
| JETTON_RIGHT | TEXT | JETTON_RIGHT column |
| JETTON_LEFT | TEXT | JETTON_LEFT column |
| TOTAL_SUPPLY | NUMBER | TOTAL_SUPPLY column |
| PROTOCOL_FEE | NUMBER | PROTOCOL_FEE column |
| REFERRAL_FEE | NUMBER | REFERRAL_FEE column |
| LP_FEE | NUMBER | LP_FEE column |
| TVL_TON | NUMBER | TVL_TON column |
| TVL_USD | NUMBER | TVL_USD column |
| LAST_UPDATED | NUMBER | LAST_UPDATED column |
| DISCOVERED_AT | NUMBER | DISCOVERED_AT column |
| FACT_DEX_POOLS_ID | TEXT | FACT_DEX_POOLS_ID column |
| INSERTED_TIMESTAMP | TIMESTAMP_NTZ | INSERTED_TIMESTAMP column |
| MODIFIED_TIMESTAMP | TIMESTAMP_NTZ | MODIFIED_TIMESTAMP column |