Table Details
| Property | Value |
|---|---|
| Table Name | solana.dex.token_prices_5min |
| Table Status | Production-Ready |
| Unique Key | timestamp, address |
| Clustering Key(s) | timestamp::date |
Table Columns
| Column Name | Data Type | Description |
|---|---|---|
| chain | VARCHAR(16777216) | Slug identifying the blockchain this record belongs to (e.g. ethereum, base, avalanche, solana). In per-chain tables this is always the same value; in cross-chain tables it identifies which chain the row came from. |
| timestamp | TIMESTAMP_NTZ(9) | Timestamp (UTC) of this record. Alias for block_timestamp used in tables where the column is named timestamp rather than block_timestamp. |
| address | VARCHAR(16777216) | Wallet or contract address of the account. On EVM chains, a 42-character hex string (0x-prefixed). On other chains, the native address format applies. |
| symbol | VARCHAR(16777216) | Ticker symbol of this token or asset. Short alias for token_symbol used in tables that preserve the original blockchain field naming convention. |
| name | VARCHAR(16777216) | Market display name. |
| decimals | NUMBER(38,0) | Number of decimal places for this token. Short alias for token_decimals used in tables that preserve the original blockchain field naming convention. |
| price | FLOAT | Price per unit of the asset at the time of this event, in USD or in the quote token’s units depending on context. |
| median_price | FLOAT | Median price per token unit across all trades in this aggregated period, in USD. Median is used rather than mean to reduce the impact of outlier trades. |
| median_safe_price | FLOAT | Median price with outlier trades removed — excludes trades with extremely low liquidity or anomalous pricing that could distort the median_price. |
| usd_trading_volume | FLOAT | Total USD value of tokens traded in this aggregated period. |
| traders | NUMBER(38,0) | Number of distinct trader addresses that executed swaps in this aggregated record. |
| trade_count | NUMBER(38,0) | Number of trades on the day. NULL when the venue does not expose a trade count. |
| _created_at | TIMESTAMP_NTZ(9) | Timestamp of when the entry was created in the database. |
| _updated_at | TIMESTAMP_NTZ(9) | Timestamp of when the entry was last updated in the database. |