Hourly token prices derived from DEX trades.
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.
Column Name | Type | Description |
---|---|---|
chain | VARCHAR | Blockchain network (e.g., ‘ethereum’, ‘arbitrum’) |
timestamp | TIMESTAMP_NTZ(9) | Start of the hourly period |
address | VARCHAR | Token contract address |
symbol | VARCHAR | Token symbol |
name | VARCHAR | Token name |
decimals | INTEGER | 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 | A more reliable price metric that only considers trades worth $100+ USD, filtering out potentially misleading small transactions. For major tokens, it typically stays within 5% of the regular median price, though smaller tokens may show larger variations due to lower liquidity. |
usd_trading_volume | FLOAT | Total USD volume traded in the hour |
traders | INTEGER | Number of distinct traders that swapped the token for the hour by counting distinct transaction_from_address. |
trade_count | INTEGER | Total number of swaps executed |
_created_at | TIMESTAMP_NTZ(9) | Timestamp of entry creation |
_updated_at | TIMESTAMP_NTZ(9) | Timestamp of entry update |