Markets 🌱 - Allium Documentation Hub

The hyperliquid.predictions.markets table contains every Hyperliquid HIP-4 prediction-market outcome at the token-side grain. Each outcome has two rows, one per token in the YES/NO pair. The primary key is coin, the native side-token identifier (e.g. #54760).

Table Details

Property	Value
Table Name	`hyperliquid.predictions.markets`
Table Status	Beta 🌱
Unique Key	`coin`

HIP-4 has three market categories:

price_binary: auto-generated price-threshold outcomes (Recurring), parameterized by an underlying asset, a target price, an expiry, and a recurrence period.
categorical: outcomes that belong to a parent question with multiple named choices and a fallback “Other”.
binary: standalone named outcomes with no parent question.

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`).
market_title	VARCHAR(16777216)	Human-readable title for the row.
category	VARCHAR(16777216)	Market type. One of ‘price_binary’, ‘categorical’, ‘binary’.
sub_category	VARCHAR(16777216)	Underlying asset for Recurring outcomes (e.g. ‘BTC’). NULL otherwise.
coin	VARCHAR(16777216)	The HL-native side-token identifier (e.g. ‘#54760’). Primary key.
encoding	NUMBER(38,0)	HL-canonical numeric encoding for the side-token.
asset_id	NUMBER(38,0)	HL-canonical numeric identifier for the side-token.
token_name	VARCHAR(16777216)	The fee-token symbol form (e.g. ‘+5476’) used in `fee_token` for opens.
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’, or a categorical label).
outcome_id	NUMBER(38,0)	HIP-4 outcome identifier (shared by both token sides).
outcome_name	VARCHAR(16777216)	Outcome display name from the HL API. The literal string ‘Recurring’ marks HL’s auto-generated price-binary outcomes.
outcome_description	VARCHAR(16777216)	Outcome description string. For Recurring outcomes this is a structured pipe-separated payload (`class:…\
side_specs	VARIANT	VARIANT array with one entry per token side, each holding that side’s label.
is_recurring	BOOLEAN	True for HL’s auto-generated price-binary outcomes.
class	VARCHAR(16777216)	The market class for Recurring outcomes (e.g. ‘priceBinary’). NULL for non-Recurring outcomes.
underlying	VARCHAR(16777216)	The asset whose price the outcome resolves against (e.g. ‘HYPE’, ‘BTC’). NULL for non-Recurring outcomes.
target_price	VARCHAR(16777216)	The target price for Recurring outcomes. Stored as VARCHAR. token_side=0 resolves YES iff underlying price >= target_price at expiry; token_side=1 resolves YES iff price < target_price. NULL for non-Recurring outcomes.
period	VARCHAR(16777216)	The recurrence cadence (e.g. ‘15m’, ‘1h’, ‘1d’). NULL for non-Recurring outcomes.
expiry_ts	TIMESTAMP_NTZ(9)	Resolution timestamp (UTC). NULL for non-Recurring outcomes.
question_id	NUMBER(38,0)	Parent question ID. NULL for Recurring / orphan outcomes.
question_name	VARCHAR(16777216)	Question name from the HL API.
question_description	VARCHAR(16777216)	Question description from the HL API.
fallback_outcome	NUMBER(38,0)	The outcome ID representing the parent question’s fallback / “Other” choice.
named_outcomes	VARIANT	VARIANT array of outcome IDs grouped under the parent question.
settled_named_outcomes	VARIANT	VARIANT array of outcome IDs that have settled (winning side).
is_named	BOOLEAN	True when this outcome is one of the parent question’s named outcomes.
is_fallback	BOOLEAN	True when this outcome is the parent question’s fallback outcome.
event_ticker	VARCHAR(16777216)	Stable cross-side event identifier. Use for COUNT(DISTINCT) when reporting markets/events traded so a multi-outcome question counts as one event, not many token-side rows.
is_winner	BOOLEAN	True for the winning side of a settled outcome. NULL while unsettled.
is_settled	BOOLEAN	True once the outcome has been resolved on-chain.
settled_at	TIMESTAMP_NTZ(9)	Settlement timestamp (UTC). NULL while unsettled.
resolution_outcome	VARCHAR(16777216)	The winning side_label when `is_settled`.
market_status	VARCHAR(16777216)	One of ‘active’ (open), ‘closed’ (expired, awaiting settlement), ‘settled’ (resolved).
active	BOOLEAN	True when the market is currently open for trading.
closed	BOOLEAN	True when the market is no longer accepting new trades.
end_date	TIMESTAMP_NTZ(9)	Market end date (UTC).
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
  coin,
  category,
  sub_category,
  market_title,
  market_status,
  is_settled,
  expiry_ts
FROM hyperliquid.predictions.markets
WHERE category = 'price_binary'
  AND market_status = 'active'
ORDER BY expiry_ts ASC
LIMIT 100