Token Prices Hourly 🌱 - Allium Documentation Hub

The hyperliquid.predictions.token_prices_hourly table contains an hourly price for every Hyperliquid HIP-4 side-token. One row per (block_hour, coin). Settled outcomes are excluded from the settlement hour onward.

Table Details

Property	Value
Table Name	`hyperliquid.predictions.token_prices_hourly`
Table Status	Beta 🌱
Unique Key	`block_hour`, `coin`

Table Columns

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

Sample Query

SELECT
  block_hour,
  coin,
  side_label,
  last_price,
  vwap_price,
  trade_count
FROM hyperliquid.predictions.token_prices_hourly
WHERE block_hour >= CURRENT_DATE - 7
ORDER BY block_hour DESC, coin
LIMIT 200