Questions 🌱 - Allium Documentation Hub

The hyperliquid.predictions.questions table contains every Hyperliquid HIP-4 question at the question grain. A question groups two or more named outcomes plus a fallback “Other” outcome. Recurring price-binary outcomes do not appear here.

Table Details

Property	Value
Table Name	`hyperliquid.predictions.questions`
Table Status	Beta 🌱
Unique Key	`question_id`

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`).
question_id	NUMBER(38,0)	HIP-4 question ID. Primary key.
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 fallback / “Other” choice.
named_outcomes	VARIANT	VARIANT array of outcome IDs grouped under this question.
settled_named_outcomes	VARIANT	VARIANT array of outcome IDs that have settled (winning side).
named_outcomes_count	NUMBER(38,0)	Count of outcomes in `named_outcomes`.
is_settled	BOOLEAN	True once the question has resolved.
settled_at	TIMESTAMP_NTZ(9)	Settlement timestamp (UTC). NULL while unsettled.
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
  question_id,
  question_name,
  named_outcomes_count,
  is_settled,
  settled_at
FROM hyperliquid.predictions.questions
ORDER BY question_id DESC
LIMIT 100