Documentation Index
Fetch the complete documentation index at: https://docs.allium.so/llms.txt
Use this file to discover all available pages before exploring further.
Table Details
| Property | Value |
|---|---|
| Table Name | vana.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) | The blockchain the token resides on |
| timestamp | TIMESTAMP_NTZ(9) | The start of the 5-minute bucket (UTC) |
| address | VARCHAR(42) | Contract address of the token |
| symbol | VARCHAR(16777216) | Token symbol |
| name | VARCHAR(16777216) | Token name |
| decimals | NUMBER(38,0) | Decimal precision of the token |
| price | FLOAT | Volume-weighted average USD price across trades in the bucket |
| median_price | FLOAT | Median USD price across trades in the bucket |
| median_safe_price | FLOAT | Median USD price filtered to trades that pass sanity / wash-trade checks |
| usd_trading_volume | FLOAT | Total USD-denominated trading volume in the bucket |
| traders | NUMBER(38,0) | Distinct number of trader addresses in the bucket |
| trade_count | NUMBER(38,0) | Total number of trades in the bucket |
| _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. |