Table Details
| Property | Value |
|---|---|
| Table Name | celo.dex.token_prices_hourly |
| Table Status | Production-Ready |
| Unique Key | timestamp, address |
| Clustering Key(s) | timestamp::date |
Table Columns
| Column Name | Data Type | Description |
|---|---|---|
| chain | VARCHAR(134217728) | Blockchain network (e.g., ‘ethereum’, ‘arbitrum’) |
| timestamp | TIMESTAMP_NTZ(9) | Start of the hourly period |
| address | VARCHAR(42) | Token contract address |
| symbol | VARCHAR(134217728) | Token symbol |
| name | VARCHAR(134217728) | Token name |
| decimals | NUMBER(38,0) | Number of decimal places for the token |
| price | FLOAT | Volume-weighted average price for the hour |
| median_price | FLOAT | Median price from all trades in the hour |
| median_safe_price | FLOAT | Filtered median price by filtering swaps > 100 usd in volume |
| usd_trading_volume | FLOAT | Total USD volume traded in the hour |
| traders | NUMBER(38,0) | Number of distinct traders that swapped the token for the hour by counting distinct transaction_from_address. |
| trade_count | NUMBER(38,0) | Total number of swaps executed |
| _created_at | TIMESTAMP_NTZ(9) | Timestamp of entry creation |
| _updated_at | TIMESTAMP_NTZ(9) | Timestamp of entry update |