Skip to main content
The hyperliquid.dex.token_prices_5min table contains 5-minute 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 5-minute interval.
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 NameDescription
chainAlways ‘hyperliquid’.
timestampStart of the 5-minute interval (UTC).
market_typeThe type of market — ‘spot’ or ‘perpetuals’.
token_symbolThe token symbol.
token_indexHyperliquid numeric token index.
evm_token_addressThe corresponding HyperEVM token address, when available.
dex_nameThe DEX the price is sourced from.
pairThe trading pair (e.g. HYPE/USDC).
quote_symbolThe quote token symbol used for pricing.
decimalsToken decimal places.
priceVolume-weighted average price over the interval.
median_priceMedian trade price over the interval.
median_safe_priceMedian price after filtering outlier trades.
usd_trading_volumeTotal USD swap volume over the interval.
tradersNumber of distinct traders over the interval.
trade_countNumber of trades over the interval.
_created_atRow creation timestamp.
_updated_atRow last update timestamp.

​
Sample Query

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