Token Prices Hourly - Allium Documentation Hub

The hyperliquid.dex.token_prices_hourly table contains hourly price data for tokens traded on Hyperliquid, computed from the hyperliquid.dex.trades table. Each row also carries swap-activity metrics — USD trading volume, trader counts, and trade counts — for the asset over the hour.

This table is clustered by timestamp::date. Always include a timestamp filter in your WHERE clause to avoid scanning the full table.

Table Columns

Column Name	Description
chain	Always ‘hyperliquid’.
timestamp	Start of the hourly interval (UTC).
market_type	The type of market — ‘spot’ or ‘perpetuals’.
token_symbol	The token symbol.
token_index	Hyperliquid numeric token index.
evm_token_address	The corresponding HyperEVM token address, when available.
dex_name	The DEX the price is sourced from.
pair	The trading pair (e.g. HYPE/USDC).
quote_symbol	The quote token symbol used for pricing.
decimals	Token decimal places.
price	Volume-weighted average price over the hour.
median_price	Median trade price over the hour.
median_safe_price	Median price after filtering outlier trades.
usd_trading_volume	Total USD swap volume over the hour.
traders	Number of distinct traders over the hour.
trade_count	Number of trades over the hour.
_created_at	Row creation timestamp.
_updated_at	Row last update timestamp.

Sample Query

SELECT
  timestamp,
  token_symbol,
  price,
  usd_trading_volume,
  trade_count
FROM hyperliquid.dex.token_prices_hourly
WHERE timestamp >= CURRENT_DATE - 7
  AND token_symbol = 'HYPE'
ORDER BY timestamp DESC

Trades Token Prices 5min

⌘I

​Table Columns

​Sample Query

Table Columns

Sample Query