dex.token_prices_hourly table contains hourly price data of tokens computed from the dex.trades table. This table also provides metrics for the swap volumes, traders and trade counts of assets swapped onchain at the hourly basis.
Table Details
| Property | Value |
|---|---|
| Table Name | hyperevm.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(16777216) | Blockchain network (e.g., ‘ethereum’, ‘arbitrum’) |
| timestamp | TIMESTAMP_NTZ(9) | Start of the hourly period |
| address | VARCHAR(42) | Token contract address |
| symbol | VARCHAR(16777216) | Token symbol |
| name | VARCHAR(16777216) | 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 |