Schema Reference

Overzicht

This page provides a complete schema reference for all tables available in SQL Explorer. Each table includes column names, data types, sort keys, and partition strategies.

Hyperliquid (HyperCore)

SQL Explorer provides comprehensive coverage of Hyperliquid HyperCore with billions of rows of indexed data across multiple tables.

Cluster ID: hyperliquid-core-mainnet Use this cluster ID when making API requests to query Hyperliquid data via the REST API.

How to Use This Reference

Sort Keys (⚡): Columns marked as sort keys are indexed for fast queries. Include these in WHERE clauses for best performance.
Partition Strategy: Tables are partitioned by time (usually toYYYYMM(block_time)). Filter on time ranges to scan fewer partitions.
Column Types: Data types are shown exactly as stored (e.g., UInt64, Decimal(38, 18), DateTime64(6, 'UTC')).

▶ Complete Schema for All Tables (Click to expand)

Detailed schema for all Hyperliquid tables including column names, data types, sort keys (⚡), and partition strategies.

hyperliquid_agents

Sort Keys: ⚡ block_number, agent | Partition: toYYYYMM(snapshot_time)

Column	Type	Sort Key
agent	FixedString(42)	Ja
block_number	UInt64	Ja
indexed_at	DateTime64(3, 'UTC')	Nee
naam	String	Nee
snapshot_time	DateTime64(6, 'UTC')	Nee
user	FixedString(42)	Nee
valid_until	String	Nee

hyperliquid_asset_transfers

Sort Keys: ⚡ block_number, tx_hash, user | Partition: toYYYYMM(block_time)

Column	Type	Sort Key
amount	Nullable(Decimal(38, 18))	Nee
block_number	UInt64	Ja
block_time	DateTime64(6, 'UTC')	Nee
destination	Nullable(FixedString(42))	Nee
fee	Nullable(Decimal(38, 18))	Nee
indexed_at	DateTime64(3, 'UTC')	Nee
nonce	Nullable(UInt64)	Nee
tijd	DateTime64(6, 'UTC')	Nee
token	Nullable(String)	Nee
transfer_type	LowCardinality(String)	Nee
tx_hash	FixedString(66)	Ja
usdc_amount	Nullable(Decimal(38, 18))	Nee
user	FixedString(42)	Ja

hyperliquid_blocks

Sort Keys: ⚡ block_number | Partition: toYYYYMM(block_time)

Column	Type	Sort Key
block_number	UInt64	Ja
block_time	DateTime64(6, 'UTC')	Nee
book_diffs_count	UInt32	Nee
fills_count	UInt32	Nee
indexed_at	DateTime64(3, 'UTC')	Nee
misc_events_count	UInt32	Nee
orders_count	UInt32	Nee
twap_statuses_count	UInt32	Nee
writer_actions_count	UInt32	Nee

hyperliquid_bridge

Sort Keys: ⚡ block_number, bridge_type, user, nonce, eth_block_number, tx_hash | Partition: toYYYYMM(snapshot_time)

Column	Type	Sort Key
amount_wei	UInt64	Nee
block_number	UInt64	Ja
bridge_type	LowCardinality(String)	Ja
eth_block_number	UInt64	Ja
event_time	String	Nee
indexed_at	DateTime64(3, 'UTC')	Nee
nonce	UInt64	Ja
snapshot_time	DateTime64(6, 'UTC')	Nee
tx_hash	String	Ja
user	FixedString(42)	Ja

hyperliquid_builder_fills

Sort Keys: ⚡ builder_address, timestamp, tid | Partition: toYYYYMM(block_time)

Column	Type	Sort Key
block_number	UInt64	Nee
block_time	DateTime64(6, 'UTC')	Nee
builder_address	Nullable(FixedString(42))	Ja
builder_fee	Nullable(Decimal(38, 18))	Nee
cloid	Nullable(String)	Nee
closed_pnl	Decimal(38, 18)	Nee
munt	LowCardinality(String)	Nee
created_at	DateTime64(6, 'UTC')	Nee
crossed	UInt8	Nee
dir	LowCardinality(String)	Nee
fee	Decimal(38, 18)	Nee
hash	FixedString(66)	Nee
indexed_at	DateTime64(3, 'UTC')	Nee
is_liquidation	UInt8	Nee
liquidated_user	Nullable(FixedString(42))	Nee
liquidation_mark_price	Nullable(Decimal(38, 18))	Nee
liquidation_method	Nullable(String)	Nee
oid	UInt64	Nee
prijs	Decimal(38, 18)	Nee
zijde	Enum8('B' = 1, 'A' = 2)	Nee
grootte	Decimal(38, 18)	Nee
start_position	Decimal(38, 18)	Nee
tid	UInt64	Ja
tijdstempel	DateTime64(3, 'UTC')	Ja
twap_id	Nullable(UInt64)	Nee
updated_at	DateTime64(6, 'UTC')	Nee
user	FixedString(42)	Nee

hyperliquid_builder_transactions

Sort Keys: ⚡ block_number, hash, user | Partition: toYYYYMM(block_time)

Column	Type	Sort Key
action_type	LowCardinality(String)	Nee
block_number	UInt64	Ja
block_time	DateTime64(6, 'UTC')	Nee
builder	String	Nee
builder_fee	Nullable(Decimal(38, 18))	Nee
munt	Nullable(String)	Nee
hash	String	Ja
indexed_at	DateTime64(3, 'UTC')	Nee
is_success	UInt8	Nee
user	String	Ja

hyperliquid_clearinghouse_states

Sort Keys: ⚡ block_number, clearinghouse, user, asset_idx | Partition: toYYYYMM(snapshot_time)

Column	Type	Sort Key
asset_idx	UInt16	Ja
block_number	UInt64	Ja
clearinghouse	UInt8	Ja
munt	LowCardinality(String)	Nee
entry_notional	UInt64	Nee
funding_alltime	Int64	Nee
funding_since_change	Int64	Nee
funding_since_open	Int64	Nee
indexed_at	DateTime64(3, 'UTC')	Nee
margin	UInt64	Nee
grootte	Int64	Nee
snapshot_time	DateTime64(6, 'UTC')	Nee
usdc_balance	Int64	Nee
user	FixedString(42)	Ja

hyperliquid_delegator_rewards

Sort Keys: ⚡ block_number, validator, delegator | Partition: toYYYYMM(snapshot_time)

Column	Type	Sort Key
block_number	UInt64	Ja
c	UInt64	Nee
commission_bps	UInt16	Nee
delegator	FixedString(42)	Ja
e	UInt64	Nee
indexed_at	DateTime64(3, 'UTC')	Nee
m	UInt64	Nee
beloning	Decimal(38, 8)	Nee
reward_wei	UInt64	Nee
snapshot_time	DateTime64(6, 'UTC')	Nee
source	LowCardinality(String)	Nee
validator	FixedString(42)	Ja
validator_total_delegated	UInt64	Nee

hyperliquid_dex_trades

Sort Keys: ⚡ none | Partition: none

Column	Type	Sort Key
block_number	UInt64	Nee
block_time	DateTime64(6, 'UTC')	Nee
buyer_address	FixedString(42)	Nee
buyer_builder_address	Nullable(FixedString(42))	Nee
buyer_builder_fee	Nullable(Decimal(38, 18))	Nee
buyer_closed_pnl	Decimal(38, 18)	Nee
buyer_crossed	UInt8	Nee
buyer_dir	LowCardinality(String)	Nee
buyer_fee	Decimal(38, 18)	Nee
buyer_order_id	UInt64	Nee
buyer_start_position	Decimal(38, 18)	Nee
buyer_twap_id	Nullable(UInt64)	Nee
munt	LowCardinality(String)	Nee
fee_token	LowCardinality(String)	Nee
indexed_at	DateTime64(3, 'UTC')	Nee
liquidated_user	Nullable(FixedString(42))	Nee
liquidation_mark_price	Nullable(Decimal(38, 18))	Nee
liquidation_method	Nullable(String)	Nee
market_type	String	Nee
prijs	Decimal(38, 18)	Nee
seller_address	FixedString(42)	Nee
seller_builder_address	Nullable(FixedString(42))	Nee
seller_builder_fee	Nullable(Decimal(38, 18))	Nee
seller_closed_pnl	Decimal(38, 18)	Nee
seller_crossed	UInt8	Nee
seller_dir	LowCardinality(String)	Nee
seller_fee	Decimal(38, 18)	Nee
seller_order_id	UInt64	Nee
seller_start_position	Decimal(38, 18)	Nee
seller_twap_id	Nullable(UInt64)	Nee
zijde	Enum8('B' = 1, 'A' = 2)	Nee
grootte	Decimal(38, 18)	Nee
tijdstempel	DateTime64(3, 'UTC')	Nee
total_builder_fee	Nullable(Decimal(38, 18))	Nee
trade_id	UInt64	Nee
transaction_hash	FixedString(66)	Nee
unique_id	String	Nee
usd_amount	Decimal(38, 18)	Nee

hyperliquid_display_names

Sort Keys: ⚡ block_number, user | Partition: toYYYYMM(snapshot_time)

Column	Type	Sort Key
block_number	UInt64	Ja
display_name	String	Nee
indexed_at	DateTime64(3, 'UTC')	Nee
snapshot_time	DateTime64(6, 'UTC')	Nee
user	FixedString(42)	Ja

hyperliquid_fills

Sort Keys: ⚡ block_number, tid, user | Partition: toYYYYMM(block_time)

Column	Type	Sort Key
block_number	UInt64	Ja
block_time	DateTime64(6, 'UTC')	Nee
builder	Nullable(FixedString(42))	Nee
builder_fee	Nullable(Decimal(38, 18))	Nee
cloid	Nullable(String)	Nee
closed_pnl	Decimal(38, 18)	Nee
munt	LowCardinality(String)	Nee
crossed	UInt8	Nee
deployer_fee	Nullable(Decimal(38, 18))	Nee
dir	LowCardinality(String)	Nee
fee	Decimal(38, 18)	Nee
fee_token	LowCardinality(String)	Nee
hash	FixedString(66)	Nee
indexed_at	DateTime64(3, 'UTC')	Nee
is_liquidation	UInt8	Nee
liquidated_user	Nullable(FixedString(42))	Nee
liquidation_mark_price	Nullable(Decimal(38, 18))	Nee
liquidation_method	Nullable(String)	Nee
oid	UInt64	Nee
prijs	Decimal(38, 18)	Nee
priority_gas	Nullable(Decimal(38, 18))	Nee
zijde	Enum8('B' = 1, 'A' = 2)	Nee
grootte	Decimal(38, 18)	Nee
start_position	Decimal(38, 18)	Nee
tid	UInt64	Ja
tijd	DateTime64(3, 'UTC')	Nee
twap_id	Nullable(UInt64)	Nee
user	FixedString(42)	Ja

hyperliquid_funding

Sort Keys: ⚡ block_number, user, coin, time | Partition: toYYYYMM(block_time)

Column	Type	Sort Key
block_number	UInt64	Ja
block_time	DateTime64(6, 'UTC')	Nee
munt	LowCardinality(String)	Ja
funding_amount	Decimal(38, 18)	Nee
funding_rate	Decimal(38, 18)	Nee
hash	FixedString(66)	Nee
indexed_at	DateTime64(3, 'UTC')	Nee
szi	Decimal(38, 18)	Nee
tijd	DateTime64(6, 'UTC')	Ja
user	FixedString(42)	Ja

hyperliquid_funding_summary_hourly

Sort Keys: ⚡ coin, hour | Partition: toYYYYMM(hour)

Column	Type	Sort Key
avg_funding_rate	SimpleAggregateFunction(any, Float64)	Nee
munt	LowCardinality(String)	Ja
hour	DateTime('UTC')	Ja
total_funding	SimpleAggregateFunction(sum, Decimal(38, 18))	Nee
unique_users	SimpleAggregateFunction(max, UInt64)	Nee

hyperliquid_ledger_updates

Sort Keys: ⚡ block_number, user, time, hash | Partition: toYYYYMM(block_time)

Column	Type	Sort Key
account_value	Nullable(Decimal(38, 18))	Nee
amount	Nullable(Decimal(38, 18))	Nee
basis	Nullable(Decimal(38, 18))	Nee
block_number	UInt64	Ja
block_time	DateTime64(6, 'UTC')	Nee
closing_cost	Nullable(Decimal(38, 18))	Nee
commission	Nullable(Decimal(38, 18))	Nee
delta_type	LowCardinality(String)	Nee
destination	Nullable(FixedString(42))	Nee
destination_dex	Nullable(String)	Nee
dex	Nullable(String)	Nee
fee	Nullable(Decimal(38, 18))	Nee
fee_token	Nullable(String)	Nee
hash	FixedString(66)	Ja
indexed_at	DateTime64(3, 'UTC')	Nee
interest_amount	Nullable(Decimal(38, 18))	Nee
is_deposit	Nullable(UInt8)	Nee
leverage_type	Nullable(String)	Nee
liquidated_ntl_pos	Nullable(Decimal(38, 18))	Nee
liquidated_positions	Nullable(String)	Nee
native_token_fee	Nullable(Decimal(38, 18))	Nee
net_withdrawn_usd	Nullable(Decimal(38, 18))	Nee
nonce	Nullable(UInt64)	Nee
operation	Nullable(String)	Nee
requested_usd	Nullable(Decimal(38, 18))	Nee
secondary_user	Nullable(FixedString(42))	Nee
source_dex	Nullable(String)	Nee
tijd	DateTime64(6, 'UTC')	Ja
to_perp	Nullable(UInt8)	Nee
token	Nullable(String)	Nee
usdc_amount	Nullable(Decimal(38, 18))	Nee
usdc_value	Nullable(Decimal(38, 18))	Nee
user	FixedString(42)	Ja
vault	Nullable(FixedString(42))	Nee

hyperliquid_liquidations_hourly

Sort Keys: ⚡ hour, coin | Partition: toYYYYMM(hour)

Column	Type	Sort Key
munt	LowCardinality(String)	Ja
hour	DateTime	Ja
liquidated_volume	SimpleAggregateFunction(sum, Decimal(38, 18))	Nee
liquidation_count	SimpleAggregateFunction(sum, UInt64)	Nee
unique_liquidated_users	SimpleAggregateFunction(max, UInt64)	Nee

hyperliquid_market_volume_hourly

Sort Keys: ⚡ coin, hour | Partition: toYYYYMM(hour)

Column	Type	Sort Key
close	SimpleAggregateFunction(anyLast, Decimal(38, 18))	Nee
munt	LowCardinality(String)	Ja
high	SimpleAggregateFunction(max, Decimal(38, 18))	Nee
hour	DateTime('UTC')	Ja
low	SimpleAggregateFunction(min, Decimal(38, 18))	Nee
open	SimpleAggregateFunction(any, Decimal(38, 18))	Nee
trade_count	SimpleAggregateFunction(sum, UInt64)	Nee
volume	SimpleAggregateFunction(sum, Decimal(38, 18))	Nee

hyperliquid_metrics_dex_overview

Sort Keys: ⚡ day, coin | Partition: toYYYYMM(day)

Column	Type	Sort Key
munt	LowCardinality(String)	Ja
day	Date	Ja
fees	SimpleAggregateFunction(sum, Decimal(38, 18))	Nee
fill_count	SimpleAggregateFunction(sum, UInt64)	Nee
high_price	SimpleAggregateFunction(max, Decimal(38, 18))	Nee
liquidations	SimpleAggregateFunction(sum, UInt64)	Nee
low_price	SimpleAggregateFunction(min, Decimal(38, 18))	Nee
unique_traders	SimpleAggregateFunction(max, UInt64)	Nee
volume_usd	SimpleAggregateFunction(sum, Decimal(38, 18))	Nee

hyperliquid_metrics_overview

Sort Keys: ⚡ day | Partition: toYYYYMM(day)

Column	Type	Sort Key
active_traders	SimpleAggregateFunction(max, UInt64)	Nee
builder_fill_count	SimpleAggregateFunction(sum, UInt64)	Nee
coins_traded	SimpleAggregateFunction(max, UInt64)	Nee
day	Date	Ja
liquidation_count	SimpleAggregateFunction(sum, UInt64)	Nee
liquidation_volume_usd	SimpleAggregateFunction(sum, Decimal(38, 18))	Nee
total_builder_fees	SimpleAggregateFunction(sum, Decimal(38, 18))	Nee
total_fees	SimpleAggregateFunction(sum, Decimal(38, 18))	Nee
total_fills	SimpleAggregateFunction(sum, UInt64)	Nee
total_volume_usd	SimpleAggregateFunction(sum, Decimal(38, 18))	Nee

hyperliquid_oracle_prices

Sort Keys: ⚡ block_number, clearinghouse, asset_idx | Partition: toYYYYMM(snapshot_time)

Column	Type	Sort Key
asset_idx	UInt16	Ja
block_number	UInt64	Ja
clearinghouse	UInt8	Ja
munt	LowCardinality(String)	Nee
daily_px	String	Nee
indexed_at	DateTime64(3, 'UTC')	Nee
mark_px	String	Nee
snapshot_time	DateTime64(6, 'UTC')	Nee

hyperliquid_order_book_diffs

Sort Keys: ⚡ coin, side, block_number, oid | Partition: toYYYYMM(block_time)

Column	Type	Sort Key
block_number	UInt64	Ja
block_time	DateTime64(6, 'UTC')	Nee
munt	LowCardinality(String)	Ja
diff_type	LowCardinality(String)	Nee
indexed_at	DateTime64(3, 'UTC')	Nee
new_size	Nullable(Decimal(38, 18))	Nee
oid	UInt64	Ja
orig_size	Nullable(Decimal(38, 18))	Nee
prijs	Decimal(38, 18)	Nee
zijde	Enum8('B' = 1, 'A' = 2)	Ja
grootte	Nullable(Decimal(38, 18))	Nee
user	FixedString(42)	Nee

hyperliquid_orders

Sort Keys: ⚡ block_number, oid, status_time | Partition: toYYYYMM(block_time)

Column	Type	Sort Key
block_number	UInt64	Ja
block_time	DateTime64(6, 'UTC')	Nee
builder	Nullable(String)	Nee
children	Nullable(String)	Nee
cloid	Nullable(String)	Nee
munt	LowCardinality(String)	Nee
hash	Nullable(FixedString(66))	Nee
indexed_at	DateTime64(3, 'UTC')	Nee
is_position_tpsl	UInt8	Nee
is_trigger	UInt8	Nee
limit_price	Decimal(38, 18)	Nee
oid	UInt64	Ja
order_timestamp	DateTime64(3, 'UTC')	Nee
order_type	LowCardinality(String)	Nee
orig_size	Decimal(38, 18)	Nee
reduce_only	UInt8	Nee
zijde	Enum8('B' = 1, 'A' = 2)	Nee
grootte	Decimal(38, 18)	Nee
status	LowCardinality(String)	Nee
status_time	DateTime64(6, 'UTC')	Ja
tif	LowCardinality(String)	Nee
trigger_condition	Nullable(String)	Nee
trigger_price	Nullable(Decimal(38, 18))	Nee
unique_id	String	Nee
user	FixedString(42)	Nee

hyperliquid_outcome_markets

Sort Keys: ⚡ none | Partition: none

Column	Type	Sort Key
base_token_idx	Nullable(UInt64)	Nee
block_number	UInt64	Nee
munt	Nullable(String)	Nee
description	String	Nee
expiry	String	Nee
fee_share	Float64	Nee
first_enabled_as_quote	String	Nee
indexed_at	DateTime64(3, 'UTC')	Nee
is_liquid_base	UInt8	Nee
is_liquid_quote	UInt8	Nee
locked	UInt8	Nee
naam	LowCardinality(String)	Nee
ndo	UInt64	Nee
nou	UInt64	Nee
nqu	UInt64	Nee
outcome_class	LowCardinality(String)	Nee
outcome_id	UInt64	Nee
pair_name	String	Nee
period	LowCardinality(String)	Nee
quote_raw	Nullable(UInt64)	Nee
quote_token_idx	Nullable(UInt64)	Nee
quote_token_name	Nullable(String)	Nee
quote_token_status	LowCardinality(String)	Nee
quote_token_usdc_px	Decimal(38, 18)	Nee
quote_token_usdc_px_raw	UInt64	Nee
raw_side_json	String	Nee
raw_spec_json	String	Nee
side_count	UInt16	Nee
side_index	UInt8	Nee
side_name	LowCardinality(String)	Nee
snapshot_time	DateTime64(6, 'UTC')	Nee
spot_deploy_time	String	Nee
spot_index	Nullable(UInt64)	Nee
spot_resolution	LowCardinality(String)	Nee
target_price	String	Nee
token_idx	Nullable(UInt64)	Nee
token_name	Nullable(String)	Nee
underlying	LowCardinality(String)	Nee

hyperliquid_outcome_meta

Sort Keys: ⚡ block_number, outcome_id | Partition: toYYYYMM(snapshot_time)

Column	Type	Sort Key
block_number	UInt64	Ja
deploy_gas_auction_json	String	Nee
description	String	Nee
expiry	String	Nee
fee_share	Float64	Nee
indexed_at	DateTime64(3, 'UTC')	Nee
locked	UInt8	Nee
naam	LowCardinality(String)	Nee
ndo	UInt64	Nee
nou	UInt64	Nee
nqu	UInt64	Nee
outcome_class	LowCardinality(String)	Nee
outcome_id	UInt64	Ja
period	LowCardinality(String)	Nee
quote_raw	Nullable(UInt64)	Nee
raw_spec_json	String	Nee
side_count	UInt16	Nee
snapshot_time	DateTime64(6, 'UTC')	Nee
target_price	String	Nee
underlying	LowCardinality(String)	Nee

hyperliquid_outcome_question_members

Sort Keys: ⚡ block_number, question_id, outcome_id | Partition: toYYYYMM(snapshot_time)

Column	Type	Sort Key
block_number	UInt64	Ja
indexed_at	DateTime64(3, 'UTC')	Nee
is_fallback	UInt8	Nee
is_settled	UInt8	Nee
outcome_id	UInt64	Ja
question_id	UInt64	Ja
snapshot_time	DateTime64(6, 'UTC')	Nee
source	LowCardinality(String)	Nee

hyperliquid_outcome_questions

Sort Keys: ⚡ block_number, question_id | Partition: toYYYYMM(snapshot_time)

Column	Type	Sort Key
block_number	UInt64	Ja
description	String	Nee
fallback_outcome	Nullable(UInt64)	Nee
indexed_at	DateTime64(3, 'UTC')	Nee
naam	String	Nee
named_outcomes_json	String	Nee
question_id	UInt64	Ja
raw_question_json	String	Nee
settled_named_outcomes_json	String	Nee
snapshot_time	DateTime64(6, 'UTC')	Nee

hyperliquid_outcome_sides

Sort Keys: ⚡ block_number, outcome_id, side_index | Partition: toYYYYMM(snapshot_time)

Column	Type	Sort Key
base_token_idx	Nullable(UInt64)	Nee
block_number	UInt64	Ja
munt	Nullable(String)	Nee
indexed_at	DateTime64(3, 'UTC')	Nee
outcome_id	UInt64	Ja
quote_token_idx	Nullable(UInt64)	Nee
quote_token_name	Nullable(String)	Nee
raw_side_json	String	Nee
side_index	UInt8	Ja
side_m_raw	String	Nee
side_m_value	Nullable(Int64)	Nee
side_name	LowCardinality(String)	Nee
snapshot_time	DateTime64(6, 'UTC')	Nee
spot_index	Nullable(UInt64)	Nee
spot_indices_json	String	Nee
spot_resolution	LowCardinality(String)	Nee
token_idx	Nullable(UInt64)	Nee
token_name	Nullable(String)	Nee

hyperliquid_perpetual_market_contexts

Sort Keys: ⚡ none | Partition: none

Column	Type	Sort Key
munt	LowCardinality(String)	Nee
day_base_vlm	Decimal(38, 18)	Nee
day_ntl_vlm	Decimal(38, 18)	Nee
funding	Decimal(38, 18)	Nee
impact_ask	Nullable(Decimal(38, 18))	Nee
impact_bid	Nullable(Decimal(38, 18))	Nee
mark_px	Decimal(38, 18)	Nee
mid_px	Decimal(38, 18)	Nee
open_interest	Decimal(38, 18)	Nee
oracle_px	Decimal(38, 18)	Nee
polled_at	DateTime64(6, 'UTC')	Nee
premium	Decimal(38, 18)	Nee
prev_day_px	Decimal(38, 18)	Nee

hyperliquid_perpetual_markets

Sort Keys: ⚡ coin | Partition: none

Column	Type	Sort Key
munt	LowCardinality(String)	Ja
indexed_at	DateTime64(3, 'UTC')	Nee
margin_table_id	Nullable(UInt16)	Nee
market_index	UInt16	Nee
max_leverage	UInt16	Nee
only_isolated	UInt8	Nee
sz_decimals	UInt8	Nee

hyperliquid_perpetual_positions

Sort Keys: ⚡ block_number, clearinghouse, user, asset_idx | Partition: toYYYYMM(snapshot_time)

Column	Type	Sort Key
asset_idx	UInt16	Ja
block_number	UInt64	Ja
clearinghouse	UInt8	Ja
munt	String	Nee
entry_notional	UInt64	Nee
funding_alltime	Int64	Nee
funding_since_change	Int64	Nee
funding_since_open	Int64	Nee
indexed_at	DateTime64(3, 'UTC')	Nee
margin	UInt64	Nee
grootte	Int64	Nee
snapshot_time	DateTime64(6, 'UTC')	Nee
usdc_balance	Int64	Nee
user	String	Ja

hyperliquid_quote_token_meta

Sort Keys: ⚡ block_number, token_idx | Partition: toYYYYMM(snapshot_time)

Column	Type	Sort Key
aligned_quote_info_json	String	Nee
block_number	UInt64	Ja
first_enabled_as_quote	String	Nee
indexed_at	DateTime64(3, 'UTC')	Nee
is_liquid_base	UInt8	Nee
is_liquid_quote	UInt8	Nee
snapshot_time	DateTime64(6, 'UTC')	Nee
status	LowCardinality(String)	Nee
token_idx	UInt64	Ja
token_name	LowCardinality(String)	Nee

hyperliquid_register_referral

Sort Keys: ⚡ referral_code, user | Partition: none

Column	Type	Sort Key
block_time	DateTime64(6, 'UTC')	Nee
fout	Nullable(String)	Nee
indexed_at	DateTime64(3, 'UTC')	Nee
is_success	UInt8	Nee
referral_code	String	Ja
round	UInt64	Nee
tx_hash	String	Nee
user	String	Ja

hyperliquid_set_referrer

Sort Keys: ⚡ referral_code, user | Partition: none

Column	Type	Sort Key
block_time	DateTime64(6, 'UTC')	Nee
fout	Nullable(String)	Nee
indexed_at	DateTime64(3, 'UTC')	Nee
is_success	UInt8	Nee
referral_code	String	Ja
round	UInt64	Nee
tx_hash	String	Nee
user	String	Ja

hyperliquid_spot_balances

Sort Keys: ⚡ block_number, user, token_idx | Partition: toYYYYMM(snapshot_time)

Column	Type	Sort Key
block_number	UInt64	Ja
escrowed	Int64	Nee
indexed_at	DateTime64(3, 'UTC')	Nee
snapshot_time	DateTime64(6, 'UTC')	Nee
token	String	Nee
token_idx	UInt16	Ja
totaal	Int64	Nee
user	String	Ja

hyperliquid_spot_clearinghouse_states

Sort Keys: ⚡ block_number, user, token_idx | Partition: toYYYYMM(snapshot_time)

Column	Type	Sort Key
block_number	UInt64	Ja
escrowed	Int64	Nee
indexed_at	DateTime64(3, 'UTC')	Nee
snapshot_time	DateTime64(6, 'UTC')	Nee
token	LowCardinality(String)	Nee
token_idx	UInt16	Ja
totaal	Int64	Nee
user	FixedString(42)	Ja

hyperliquid_spot_markets

Sort Keys: ⚡ token_index | Partition: none

Column	Type	Sort Key
deployer_trading_fee_share	Nullable(String)	Nee
evm_contract	Nullable(String)	Nee
volledige_naam	Nullable(String)	Nee
indexed_at	DateTime64(3, 'UTC')	Nee
is_canonical	UInt8	Nee
pair_index	Nullable(UInt16)	Nee
pair_name	Nullable(String)	Nee
sz_decimals	UInt8	Nee
token	LowCardinality(String)	Nee
token_id	String	Nee
token_index	UInt16	Ja
wei_decimals	UInt8	Nee

hyperliquid_spot_pairs

Sort Keys: ⚡ block_number, spot_index | Partition: toYYYYMM(snapshot_time)

Column	Type	Sort Key
base_token_idx	UInt64	Nee
base_token_name	LowCardinality(String)	Nee
block_number	UInt64	Ja
deploy_time	String	Nee
indexed_at	DateTime64(3, 'UTC')	Nee
pair_name	String	Nee
quote_token_idx	UInt64	Nee
quote_token_name	LowCardinality(String)	Nee
raw_spot_info_json	String	Nee
snapshot_time	DateTime64(6, 'UTC')	Nee
spot_index	UInt64	Ja

hyperliquid_staking_events

Sort Keys: ⚡ block_number, hash | Partition: toYYYYMM(block_time)

Column	Type	Sort Key
amount	Decimal(38, 18)	Nee
block_number	UInt64	Ja
block_time	DateTime64(6, 'UTC')	Nee
event_type	Enum8('CDeposit' = 1, 'CWithdrawal' = 2, 'Delegation' = 3)	Nee
hash	FixedString(66)	Ja
indexed_at	DateTime64(3, 'UTC')	Nee
is_finalized	Nullable(UInt8)	Nee
is_undelegate	Nullable(UInt8)	Nee
tijd	DateTime64(6, 'UTC')	Nee
user	FixedString(42)	Nee
validator	Nullable(FixedString(42))	Nee

hyperliquid_sub_accounts

Sort Keys: ⚡ block_number, sub_account | Partition: toYYYYMM(snapshot_time)

Column	Type	Sort Key
block_number	UInt64	Ja
indexed_at	DateTime64(3, 'UTC')	Nee
master_account	FixedString(42)	Nee
naam	Nullable(String)	Nee
snapshot_time	DateTime64(6, 'UTC')	Nee
sub_account	FixedString(42)	Ja

hyperliquid_summaries

Sort Keys: ⚡ user, polled_at | Partition: toYYYYMM(polled_at)

Column	Type	Sort Key
cross_maintenance_margin_used	Decimal(38, 18)	Nee
cross_margin_account_value	Decimal(38, 18)	Nee
cross_margin_total_margin_used	Decimal(38, 18)	Nee
cross_margin_total_natl_pos	Decimal(38, 18)	Nee
cross_margin_total_raw_usd	Decimal(38, 18)	Nee
indexed_at	DateTime64(3, 'UTC')	Nee
margin_account_value	Decimal(38, 18)	Nee
margin_total_margin_used	Decimal(38, 18)	Nee
margin_total_natl_pos	Decimal(38, 18)	Nee
margin_total_raw_usd	Decimal(38, 18)	Nee
polled_at	DateTime64(3, 'UTC')	Ja
user	String	Ja
withdrawable	Decimal(38, 18)	Nee

hyperliquid_system_actions

Sort Keys: ⚡ block_number, evm_tx_hash, nonce | Partition: toYYYYMM(block_time)

Column	Type	Sort Key
actie	String	Nee
action_type	LowCardinality(String)	Nee
agent_address	Nullable(FixedString(42))	Nee
agent_name	Nullable(String)	Nee
block_number	UInt64	Ja
block_time	DateTime64(6, 'UTC')	Nee
destination	Nullable(FixedString(42))	Nee
destination_dex_or_spot	Nullable(UInt8)	Nee
evm_tx_hash	FixedString(66)	Ja
from_sub_account	Nullable(UInt8)	Nee
hyperliquid_chain	Nullable(String)	Nee
indexed_at	DateTime64(3, 'UTC')	Nee
is_mint	Nullable(UInt8)	Nee
is_undelegate	Nullable(UInt8)	Nee
nonce	UInt64	Ja
ntl	Nullable(Decimal(38, 18))	Nee
order_grouping	Nullable(String)	Nee
signature_chain_id	Nullable(String)	Nee
source_dex_or_spot	Nullable(UInt8)	Nee
to_perp	Nullable(UInt8)	Nee
token	Nullable(UInt16)	Nee
user	FixedString(42)	Nee
validator	Nullable(FixedString(42))	Nee
wei	Nullable(UInt256)	Nee

hyperliquid_token_usdc_prices

Sort Keys: ⚡ block_number, token_idx | Partition: toYYYYMM(snapshot_time)

Column	Type	Sort Key
approx_usdc_px	Decimal(38, 18)	Nee
approx_usdc_px_float_1e6	Float64	Nee
approx_usdc_px_raw	UInt64	Nee
block_number	UInt64	Ja
indexed_at	DateTime64(3, 'UTC')	Nee
raw_pair_json	String	Nee
snapshot_time	DateTime64(6, 'UTC')	Nee
token_idx	UInt64	Ja
token_name	LowCardinality(String)	Nee

hyperliquid_trades

Sort Keys: ⚡ block_number, trade_id | Partition: toYYYYMM(block_time)

Column	Type	Sort Key
block_number	UInt64	Ja
block_time	DateTime64(6, 'UTC')	Nee
buyer_address	FixedString(42)	Nee
buyer_builder_address	Nullable(FixedString(42))	Nee
buyer_builder_fee	Nullable(Decimal(38, 18))	Nee
buyer_closed_pnl	Decimal(38, 18)	Nee
buyer_crossed	UInt8	Nee
buyer_deployer_fee	Nullable(Decimal(38, 18))	Nee
buyer_dir	LowCardinality(String)	Nee
buyer_fee	Decimal(38, 18)	Nee
buyer_order_id	UInt64	Nee
buyer_priority_gas	Nullable(Decimal(38, 18))	Nee
buyer_start_position	Decimal(38, 18)	Nee
buyer_twap_id	Nullable(UInt64)	Nee
munt	LowCardinality(String)	Nee
fee_token	LowCardinality(String)	Nee
indexed_at	DateTime64(3, 'UTC')	Nee
liquidated_user	Nullable(FixedString(42))	Nee
liquidation_mark_price	Nullable(Decimal(38, 18))	Nee
liquidation_method	Nullable(String)	Nee
prijs	Decimal(38, 18)	Nee
seller_address	FixedString(42)	Nee
seller_builder_address	Nullable(FixedString(42))	Nee
seller_builder_fee	Nullable(Decimal(38, 18))	Nee
seller_closed_pnl	Decimal(38, 18)	Nee
seller_crossed	UInt8	Nee
seller_deployer_fee	Nullable(Decimal(38, 18))	Nee
seller_dir	LowCardinality(String)	Nee
seller_fee	Decimal(38, 18)	Nee
seller_order_id	UInt64	Nee
seller_priority_gas	Nullable(Decimal(38, 18))	Nee
seller_start_position	Decimal(38, 18)	Nee
seller_twap_id	Nullable(UInt64)	Nee
zijde	Enum8('B' = 1, 'A' = 2)	Nee
grootte	Decimal(38, 18)	Nee
tijdstempel	DateTime64(3, 'UTC')	Nee
total_builder_fee	Nullable(Decimal(38, 18))	Nee
trade_id	UInt64	Ja
transaction_hash	FixedString(66)	Nee
unique_id	String	Nee

hyperliquid_transactions

Sort Keys: ⚡ round, tx_hash, nonce | Partition: toYYYYMM(block_time)

Column	Type	Sort Key
actie	JSON	Nee
action_type	LowCardinality(String)	Nee
block_time	DateTime64(6, 'UTC')	Nee
fout	Nullable(String)	Nee
indexed_at	DateTime64(3, 'UTC')	Nee
is_success	UInt8	Nee
nonce	UInt64	Ja
proposer	Nullable(String)	Nee
round	UInt64	Ja
tx_hash	String	Ja
user	Nullable(String)	Nee
vault_address	Nullable(String)	Nee

hyperliquid_twap_statuses

Sort Keys: ⚡ block_number, twap_id, time | Partition: toYYYYMM(block_time)

Column	Type	Sort Key
block_number	UInt64	Ja
block_time	DateTime64(6, 'UTC')	Nee
munt	LowCardinality(String)	Nee
executed_ntl	Decimal(38, 18)	Nee
executed_size	Decimal(38, 18)	Nee
indexed_at	DateTime64(3, 'UTC')	Nee
minutes	UInt16	Nee
randomize	UInt8	Nee
reduce_only	UInt8	Nee
zijde	Enum8('B' = 1, 'A' = 2)	Nee
grootte	Decimal(38, 18)	Nee
status	LowCardinality(String)	Nee
tijd	DateTime64(6, 'UTC')	Ja
tijdstempel	DateTime64(3, 'UTC')	Nee
twap_id	UInt64	Ja
user	FixedString(42)	Nee

hyperliquid_validator_rewards

Sort Keys: ⚡ block_number, validator, time | Partition: toYYYYMM(block_time)

Column	Type	Sort Key
block_number	UInt64	Ja
block_time	DateTime64(6, 'UTC')	Nee
hash	FixedString(66)	Nee
indexed_at	DateTime64(3, 'UTC')	Nee
beloning	Decimal(38, 18)	Nee
tijd	DateTime64(6, 'UTC')	Ja
validator	FixedString(42)	Ja

hyperliquid_vault_equities

Sort Keys: ⚡ block_number, vault_address, depositor | Partition: toYYYYMM(snapshot_time)

Column	Type	Sort Key
block_number	UInt64	Ja
depositor	FixedString(42)	Ja
indexed_at	DateTime64(3, 'UTC')	Nee
leader	FixedString(42)	Nee
leader_commission	Float64	Nee
net_deposits	Int64	Nee
ownership_fraction	Float64	Nee
snapshot_time	DateTime64(6, 'UTC')	Nee
vault_address	FixedString(42)	Ja
vault_name	String	Nee

All tables are optimized with sort keys (marked ⚡ in the schema browser) and partition monthly by toYYYYMM(block_time) for efficient time-bounded queries. Data ingestion is near real-time with queries scanning across billions of rows in seconds.

Accessing the Schema

The schema can be accessed as static downloadable files or via the API endpoint.

Downloadable Files

These files are updated periodically:

JSON Format: hyperliquid_schema.json - Complete schema with all tables and columns
Plain Text Format: hyperliquid_schema.txt - Formatted for LLM context windows

Schema API

Fetch the current schema with real-time row counts and latest table structures. See the REST API Overview for API authentication details.

Request (Hyperliquid):

curl https://api.quicknode.com/sql/rest/v1/schema/hyperliquid-core-mainnet \
  -H "x-api-key: YOUR_API_KEY"

Vervangen hyperliquid-core-mainnet with the appropriate cluster ID for other supported chains.

Example Response:

[
  {
    "chain": "Hyperliquid (HyperCore)",
    "clusterId": "hyperliquid-core-mainnet",
    "tables": [
      {
        "name": "hyperliquid_agents",
        "engine": "SharedReplacingMergeTree",
        "totalRows": 55686595,
        "sortingKey": ["block_number", "agent"],
        "partitionKey": "toYYYYMM(snapshot_time)",
        "columns": [
          {
            "name": "block_number",
            "type": "UInt64"
          },
          {
            "name": "snapshot_time",
            "type": "DateTime64(6, 'UTC')"
          },
          {
            "name": "agent",
            "type": "FixedString(42)"
          }
          // ... more columns
        ]
      }
      // ... more tables
    ]
  }
]

The response includes table names, engines, column names and data types, sort keys for optimization, partition strategies, and current row counts.

For AI Agents & LLMs

This schema is specifically formatted for programmatic consumption.

Quicknode Skill

For AI agents and LLM applications, install the Quicknode Skill to give your agent full knowledge of SQL Explorer and all Quicknode products:

npx-vaardigheden toevoegen quiknode-labs/blockchain-skills

Using Schema in Your Agent

When building custom AI agents or LLM applications:

Fetch the schema via the API endpoint above or download the plain text schema optimized for LLM context windows
Include it in your prompt context when generating SQL queries
Reference sort keys for optimal query performance
Use partition keys to limit data scans

Example prompts for AI agents:

Example 1: Generate a SQL query to find the top 10 traders by volume in the last 24 hours.
Schema: [include JSON from schema API or plain text schema file]

Example 2: Create a query to analyze funding rate changes for the BTC perpetual market over the past week, grouped by hour.
Schema: [include JSON from schema API or plain text schema file]

Example 3: Write a SQL query to identify liquidation events larger than $100K in the last 30 days, showing the user, asset, and liquidation size.
Schema: [include JSON from schema API or plain text schema file]

We ❤️ feedback!

Mocht je opmerkingen of vragen hebben over deze documentatie, laat het ons dan weten. We horen graag van je!

Overzicht​

Hyperliquid (HyperCore)​

How to Use This Reference​

hyperliquid_agents

hyperliquid_asset_transfers

hyperliquid_blocks

hyperliquid_bridge

hyperliquid_builder_fills

hyperliquid_builder_transactions

hyperliquid_clearinghouse_states

hyperliquid_delegator_rewards

hyperliquid_dex_trades

hyperliquid_display_names

hyperliquid_fills

hyperliquid_funding

hyperliquid_funding_summary_hourly

hyperliquid_ledger_updates

hyperliquid_liquidations_hourly

hyperliquid_market_volume_hourly

hyperliquid_metrics_dex_overview

hyperliquid_metrics_overview

hyperliquid_oracle_prices

hyperliquid_order_book_diffs

hyperliquid_orders

hyperliquid_outcome_markets

hyperliquid_outcome_meta

hyperliquid_outcome_question_members

hyperliquid_outcome_questions

hyperliquid_outcome_sides

hyperliquid_perpetual_market_contexts

hyperliquid_perpetual_markets

hyperliquid_perpetual_positions

hyperliquid_quote_token_meta

hyperliquid_register_referral

hyperliquid_set_referrer

hyperliquid_spot_balances

hyperliquid_spot_clearinghouse_states

hyperliquid_spot_markets

hyperliquid_spot_pairs

hyperliquid_staking_events

hyperliquid_sub_accounts

hyperliquid_summaries

hyperliquid_system_actions

hyperliquid_token_usdc_prices

hyperliquid_trades

hyperliquid_transactions

hyperliquid_twap_statuses

hyperliquid_validator_rewards

hyperliquid_vault_equities

Accessing the Schema​

Downloadable Files​

Schema API​

For AI Agents & LLMs​

Quicknode Skill​

Using Schema in Your Agent​

We ❤️ feedback!​

Overzicht

Hyperliquid (HyperCore)

How to Use This Reference

Accessing the Schema

Downloadable Files

Schema API

For AI Agents & LLMs

Quicknode Skill

Using Schema in Your Agent

We ❤️ feedback!