Token Prices Daily

The hyperliquid.predictions.token_prices_daily table contains a daily price for every Hyperliquid HIP-4 side-token. One row per (day, coin). Settled outcomes are excluded from the settlement day onward.

Table Columns

Column Name	Description
project	Top-level project namespace (`hyperliquid`).
protocol	Protocol within the project (`hyperliquid_hip4`).
chain	The blockchain network (`hyperliquid`).
day	Date bucket (UTC).
coin	HL-native side-token identifier (e.g. ‘#54760’).
outcome_id	HIP-4 outcome identifier (shared by both token sides).
token_side	Which side of the outcome’s YES/NO pair the row represents (0 or 1).
side_label	Display label for this row’s token_side (e.g. ‘Yes’, ‘No’).
last_price	Last observed price for the coin as a 0..1 probability. Resolves to 0 or 1 post-settlement.
vwap_price	Volume-weighted price across the day.
trade_count	Number of trades in the day.
unique_id	Deterministic unique identifier per row.
_created_at	Row creation timestamp.
_updated_at	Row last update timestamp.

Sample Query

SELECT
  day,
  coin,
  side_label,
  last_price,
  vwap_price,
  trade_count
FROM hyperliquid.predictions.token_prices_daily
WHERE day >= CURRENT_DATE - 30
ORDER BY day DESC, coin
LIMIT 200

Token Prices Hourly Metrics Daily

⌘I

Overview

Data Verticals

Solana

Hyperliquid

Lighter

Bitcoin Ecosystem

EVM

Cosmos Ecosystem

Move Ecosystem

Other Ecosystems

Table Columns

Sample Query

​Table Columns

​Sample Query

Table Columns

Sample Query