Skip to main content

Documentation Index

Fetch the complete documentation index at: https://docs.allium.so/llms.txt

Use this file to discover all available pages before exploring further.

The hyperliquid.predictions.user_positions_daily table contains one row per (day, user, coin) for every user holding a non-zero balance on a Hyperliquid HIP-4 side-token. Settled outcomes are excluded from the settlement day onward.
For USD aggregates use open_interest_usd from Open Interest Daily.

​
Table Columns

Column NameDescription
projectAlways ‘hyperliquid’.
protocolAlways ‘hyperliquid_hip4’.
chainAlways ‘hyperliquid’.
dayDate bucket (UTC).
user_addressUser wallet address.
coinHL-native side-token identifier (e.g. ‘#54760’).
encodingHL-canonical numeric encoding for the side-token.
outcome_idHIP-4 outcome ID.
token_side0 or 1.
side_labelDisplay label for this row’s token_side (e.g. ‘Yes’, ‘No’).
token_balanceUser’s end-of-day balance in this side-token. Always positive.
outcome_nameOutcome display name from the HL API.
market_titleHuman-readable market title.
categoryOne of ‘price_binary’, ‘categorical’, ‘binary’.
sub_categoryUnderlying asset for Recurring outcomes (e.g. ‘BTC’). NULL otherwise.
is_recurringTrue for HL’s auto-generated price-binary outcomes.
question_idParent question ID. NULL for Recurring / orphan outcomes.
question_nameQuestion name from the HL API.
is_winnerTrue for the winning side of a settled outcome. NULL while unsettled.
expiry_tsResolution timestamp (UTC) for Recurring outcomes. NULL otherwise.
unique_idDeterministic unique identifier per row.
_created_atRow creation timestamp.
_updated_atRow last update timestamp.

​
Sample Query

SELECT
  day,
  user_address,
  coin,
  side_label,
  token_balance,
  market_title
FROM hyperliquid.predictions.user_positions_daily
WHERE day >= CURRENT_DATE - 7
  AND user_address = '<user_address_to_search>'
ORDER BY day DESC, coin
LIMIT 200