Question Metadata - Allium Documentation Hub

The hyperliquid.raw.question_metadata table contains snapshots of Hyperliquid HIP-4 questions. A question groups two or more named outcomes plus a fallback outcome (“Other”). Recurring price-binary outcomes are not grouped under a question.

Table Details

Property	Value
Table Name	`hyperliquid.raw.question_metadata`
Table Status	Production-Ready
Unique Key	`timestamp`, `question`
Clustering Key(s)	`to_date("timestamp")`
Search Optimization	`question`

Table Columns

Column Name	Data Type	Description
timestamp	TIMESTAMP_NTZ(9)	UTC timestamp of the snapshot.
question	NUMBER(38,0)	The question ID (numeric). Groups outcomes via `named_outcomes` and `fallback_outcome`.
name	VARCHAR(16777216)	Question display name.
description	VARCHAR(16777216)	Question description.
fallback_outcome	NUMBER(38,0)	The outcome ID representing the fallback / “Other” choice for this question.
named_outcomes	VARIANT	VARIANT array of outcome IDs that are explicitly named under this question.
settled_named_outcomes	VARIANT	VARIANT array of outcome IDs that have settled. Empty until the question resolves.
_created_at	TIMESTAMP_NTZ(9)	Row creation timestamp.
_updated_at	TIMESTAMP_NTZ(9)	Row last update timestamp.

Sample Query

SELECT
  timestamp,
  question,
  name,
  fallback_outcome,
  named_outcomes,
  settled_named_outcomes
FROM hyperliquid.raw.question_metadata
WHERE TO_DATE(timestamp) >= CURRENT_DATE - 7
ORDER BY timestamp DESC, question
LIMIT 100