Table Details
| Property | Value |
|---|---|
| Table Name | solana.prices.dex_token_info |
| Table Status | Production-Ready |
| Unique Key | token_mint |
| Clustering Key(s) | token_mint |
| Search Optimization | token_mint |
Table Columns
| Column Name | Data Type | Description |
|---|---|---|
| token_mint | VARCHAR(16777216) | Address of the token mint. |
| last_timestamp | TIMESTAMP_NTZ(9) | Timestamp of the most recent price observation for this token in the DEX price feed. |
| last_median_price | FLOAT | Median DEX price of the token at the most recent price observation (last_timestamp). |
| last_price | FLOAT | Last trade price, forward-filled. Resolves to 0 / 1 post-settlement. |
| total_usd_trading_volume | FLOAT | Cumulative USD trading volume for this token across all DEX trades in the observation window. |
| coingecko_id | VARCHAR(16777216) | CoinGecko token identifier, joined from the CoinGecko ID map. Null when no CoinGecko listing is known for this token. |