Table Details
| Property | Value |
|---|---|
| Table Name | hyperevm.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 network identifier. |
| timestamp | TIMESTAMP_NTZ(9) | The timestamp of the 5-minute price interval. |
| address | VARCHAR(42) | The contract address of the token. |
| symbol | VARCHAR(16777216) | The ticker symbol of the token. |
| name | VARCHAR(16777216) | The human-readable name of the token. |
| decimals | NUMBER(38,0) | The number of decimal places for the token. |
| price | FLOAT | The volume-weighted average price in USD. |
| median_price | FLOAT | The median price in USD across trades in the interval. |
| median_safe_price | FLOAT | The median safe price with outlier trades removed. |
| usd_trading_volume | FLOAT | The total trading volume in USD during the interval. |
| traders | NUMBER(38,0) | The number of unique traders during the interval. |
| trade_count | NUMBER(38,0) | The number of trades during the interval. |
| _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. |