Table Columns
Unique Key:timestamp, address
| Column Name | Data Type | Description |
|---|---|---|
| chain | VARCHAR | The blockchain the token resides on |
| timestamp | TIMESTAMP_NTZ(9) | The start of the 5-minute bucket (UTC) |
| address | VARCHAR | Contract address of the token |
| symbol | VARCHAR | Token symbol |
| name | VARCHAR | Token name |
| decimals | INTEGER | 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 | INTEGER | Distinct number of trader addresses in the bucket |
| trade_count | INTEGER | Total number of trades in the bucket |