Schema Reference

Übersicht

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	Typ	Sort Key
agent	FixedString(42)	Ja
block_number	UInt64	Ja
indexed_at	DateTime64(3, 'UTC')	Nein
Name	String	Nein
snapshot_time	DateTime64(6, 'UTC')	Nein
user	FixedString(42)	Nein
valid_until	String	Nein

hyperliquid_asset_transfers

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

Column	Typ	Sort Key
Betrag	Nullable(Decimal(38, 18))	Nein
block_number	UInt64	Ja
block_time	DateTime64(6, 'UTC')	Nein
destination	Nullable(FixedString(42))	Nein
Gebühr	Nullable(Decimal(38, 18))	Nein
indexed_at	DateTime64(3, 'UTC')	Nein
Nonce	Nullable(UInt64)	Nein
Zeit	DateTime64(6, 'UTC')	Nein
Token	Nullable(String)	Nein
transfer_type	LowCardinality(String)	Nein
tx_hash	FixedString(66)	Ja
usdc_amount	Nullable(Decimal(38, 18))	Nein
user	FixedString(42)	Ja

hyperliquid_blocks

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

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

hyperliquid_bridge

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

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

hyperliquid_builder_fills

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

Column	Typ	Sort Key
block_number	UInt64	Nein
block_time	DateTime64(6, 'UTC')	Nein
builder_address	Nullable(FixedString(42))	Ja
builder_fee	Nullable(Decimal(38, 18))	Nein
cloid	Nullable(String)	Nein
closed_pnl	Decimal(38, 18)	Nein
Münze	LowCardinality(String)	Nein
created_at	DateTime64(6, 'UTC')	Nein
crossed	UInt8	Nein
dir	LowCardinality(String)	Nein
Gebühr	Decimal(38, 18)	Nein
Hash	FixedString(66)	Nein
indexed_at	DateTime64(3, 'UTC')	Nein
is_liquidation	UInt8	Nein
liquidated_user	Nullable(FixedString(42))	Nein
liquidation_mark_price	Nullable(Decimal(38, 18))	Nein
liquidation_method	Nullable(String)	Nein
oid	UInt64	Nein
Preis	Decimal(38, 18)	Nein
Seite	Enum8('B' = 1, 'A' = 2)	Nein
Größe	Decimal(38, 18)	Nein
start_position	Decimal(38, 18)	Nein
tid	UInt64	Ja
Zeitstempel	DateTime64(3, 'UTC')	Ja
twap_id	Nullable(UInt64)	Nein
updated_at	DateTime64(6, 'UTC')	Nein
user	FixedString(42)	Nein

hyperliquid_builder_transactions

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

Column	Typ	Sort Key
action_type	LowCardinality(String)	Nein
block_number	UInt64	Ja
block_time	DateTime64(6, 'UTC')	Nein
builder	String	Nein
builder_fee	Nullable(Decimal(38, 18))	Nein
Münze	Nullable(String)	Nein
Hash	String	Ja
indexed_at	DateTime64(3, 'UTC')	Nein
is_success	UInt8	Nein
user	String	Ja

hyperliquid_clearinghouse_states

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

Column	Typ	Sort Key
asset_idx	UInt16	Ja
block_number	UInt64	Ja
clearinghouse	UInt8	Ja
Münze	LowCardinality(String)	Nein
entry_notional	UInt64	Nein
funding_alltime	Int64	Nein
funding_since_change	Int64	Nein
funding_since_open	Int64	Nein
indexed_at	DateTime64(3, 'UTC')	Nein
margin	UInt64	Nein
Größe	Int64	Nein
snapshot_time	DateTime64(6, 'UTC')	Nein
usdc_balance	Int64	Nein
user	FixedString(42)	Ja

hyperliquid_delegator_rewards

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

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

hyperliquid_dex_trades

Sort Keys: ⚡ none | Partition: none

Column	Typ	Sort Key
block_number	UInt64	Nein
block_time	DateTime64(6, 'UTC')	Nein
buyer_address	FixedString(42)	Nein
buyer_builder_address	Nullable(FixedString(42))	Nein
buyer_builder_fee	Nullable(Decimal(38, 18))	Nein
buyer_closed_pnl	Decimal(38, 18)	Nein
buyer_crossed	UInt8	Nein
buyer_dir	LowCardinality(String)	Nein
buyer_fee	Decimal(38, 18)	Nein
buyer_order_id	UInt64	Nein
buyer_start_position	Decimal(38, 18)	Nein
buyer_twap_id	Nullable(UInt64)	Nein
Münze	LowCardinality(String)	Nein
fee_token	LowCardinality(String)	Nein
indexed_at	DateTime64(3, 'UTC')	Nein
liquidated_user	Nullable(FixedString(42))	Nein
liquidation_mark_price	Nullable(Decimal(38, 18))	Nein
liquidation_method	Nullable(String)	Nein
market_type	String	Nein
Preis	Decimal(38, 18)	Nein
seller_address	FixedString(42)	Nein
seller_builder_address	Nullable(FixedString(42))	Nein
seller_builder_fee	Nullable(Decimal(38, 18))	Nein
seller_closed_pnl	Decimal(38, 18)	Nein
seller_crossed	UInt8	Nein
seller_dir	LowCardinality(String)	Nein
seller_fee	Decimal(38, 18)	Nein
seller_order_id	UInt64	Nein
seller_start_position	Decimal(38, 18)	Nein
seller_twap_id	Nullable(UInt64)	Nein
Seite	Enum8('B' = 1, 'A' = 2)	Nein
Größe	Decimal(38, 18)	Nein
Zeitstempel	DateTime64(3, 'UTC')	Nein
total_builder_fee	Nullable(Decimal(38, 18))	Nein
trade_id	UInt64	Nein
transaction_hash	FixedString(66)	Nein
unique_id	String	Nein
usd_amount	Decimal(38, 18)	Nein

hyperliquid_display_names

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

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

hyperliquid_fills

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

Column	Typ	Sort Key
block_number	UInt64	Ja
block_time	DateTime64(6, 'UTC')	Nein
builder	Nullable(FixedString(42))	Nein
builder_fee	Nullable(Decimal(38, 18))	Nein
cloid	Nullable(String)	Nein
closed_pnl	Decimal(38, 18)	Nein
Münze	LowCardinality(String)	Nein
crossed	UInt8	Nein
deployer_fee	Nullable(Decimal(38, 18))	Nein
dir	LowCardinality(String)	Nein
Gebühr	Decimal(38, 18)	Nein
fee_token	LowCardinality(String)	Nein
Hash	FixedString(66)	Nein
indexed_at	DateTime64(3, 'UTC')	Nein
is_liquidation	UInt8	Nein
liquidated_user	Nullable(FixedString(42))	Nein
liquidation_mark_price	Nullable(Decimal(38, 18))	Nein
liquidation_method	Nullable(String)	Nein
oid	UInt64	Nein
Preis	Decimal(38, 18)	Nein
priority_gas	Nullable(Decimal(38, 18))	Nein
Seite	Enum8('B' = 1, 'A' = 2)	Nein
Größe	Decimal(38, 18)	Nein
start_position	Decimal(38, 18)	Nein
tid	UInt64	Ja
Zeit	DateTime64(3, 'UTC')	Nein
twap_id	Nullable(UInt64)	Nein
user	FixedString(42)	Ja

hyperliquid_funding

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

Column	Typ	Sort Key
block_number	UInt64	Ja
block_time	DateTime64(6, 'UTC')	Nein
Münze	LowCardinality(String)	Ja
funding_amount	Decimal(38, 18)	Nein
funding_rate	Decimal(38, 18)	Nein
Hash	FixedString(66)	Nein
indexed_at	DateTime64(3, 'UTC')	Nein
szi	Decimal(38, 18)	Nein
Zeit	DateTime64(6, 'UTC')	Ja
user	FixedString(42)	Ja

hyperliquid_funding_summary_hourly

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

Column	Typ	Sort Key
avg_funding_rate	SimpleAggregateFunction(any, Float64)	Nein
Münze	LowCardinality(String)	Ja
hour	DateTime('UTC')	Ja
total_funding	SimpleAggregateFunction(sum, Decimal(38, 18))	Nein
unique_users	SimpleAggregateFunction(max, UInt64)	Nein

hyperliquid_ledger_updates

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

Column	Typ	Sort Key
account_value	Nullable(Decimal(38, 18))	Nein
Betrag	Nullable(Decimal(38, 18))	Nein
basis	Nullable(Decimal(38, 18))	Nein
block_number	UInt64	Ja
block_time	DateTime64(6, 'UTC')	Nein
closing_cost	Nullable(Decimal(38, 18))	Nein
commission	Nullable(Decimal(38, 18))	Nein
delta_type	LowCardinality(String)	Nein
destination	Nullable(FixedString(42))	Nein
destination_dex	Nullable(String)	Nein
dex	Nullable(String)	Nein
Gebühr	Nullable(Decimal(38, 18))	Nein
fee_token	Nullable(String)	Nein
Hash	FixedString(66)	Ja
indexed_at	DateTime64(3, 'UTC')	Nein
interest_amount	Nullable(Decimal(38, 18))	Nein
is_deposit	Nullable(UInt8)	Nein
leverage_type	Nullable(String)	Nein
liquidated_ntl_pos	Nullable(Decimal(38, 18))	Nein
liquidated_positions	Nullable(String)	Nein
native_token_fee	Nullable(Decimal(38, 18))	Nein
net_withdrawn_usd	Nullable(Decimal(38, 18))	Nein
Nonce	Nullable(UInt64)	Nein
operation	Nullable(String)	Nein
requested_usd	Nullable(Decimal(38, 18))	Nein
secondary_user	Nullable(FixedString(42))	Nein
source_dex	Nullable(String)	Nein
Zeit	DateTime64(6, 'UTC')	Ja
to_perp	Nullable(UInt8)	Nein
Token	Nullable(String)	Nein
usdc_amount	Nullable(Decimal(38, 18))	Nein
usdc_value	Nullable(Decimal(38, 18))	Nein
user	FixedString(42)	Ja
vault	Nullable(FixedString(42))	Nein

hyperliquid_liquidations_hourly

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

Column	Typ	Sort Key
Münze	LowCardinality(String)	Ja
hour	DateTime	Ja
liquidated_volume	SimpleAggregateFunction(sum, Decimal(38, 18))	Nein
liquidation_count	SimpleAggregateFunction(sum, UInt64)	Nein
unique_liquidated_users	SimpleAggregateFunction(max, UInt64)	Nein

hyperliquid_market_volume_hourly

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

Column	Typ	Sort Key
close	SimpleAggregateFunction(anyLast, Decimal(38, 18))	Nein
Münze	LowCardinality(String)	Ja
high	SimpleAggregateFunction(max, Decimal(38, 18))	Nein
hour	DateTime('UTC')	Ja
low	SimpleAggregateFunction(min, Decimal(38, 18))	Nein
open	SimpleAggregateFunction(any, Decimal(38, 18))	Nein
trade_count	SimpleAggregateFunction(sum, UInt64)	Nein
volume	SimpleAggregateFunction(sum, Decimal(38, 18))	Nein

hyperliquid_metrics_dex_overview

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

Column	Typ	Sort Key
Münze	LowCardinality(String)	Ja
day	Date	Ja
Gebühren	SimpleAggregateFunction(sum, Decimal(38, 18))	Nein
fill_count	SimpleAggregateFunction(sum, UInt64)	Nein
high_price	SimpleAggregateFunction(max, Decimal(38, 18))	Nein
liquidations	SimpleAggregateFunction(sum, UInt64)	Nein
low_price	SimpleAggregateFunction(min, Decimal(38, 18))	Nein
unique_traders	SimpleAggregateFunction(max, UInt64)	Nein
volume_usd	SimpleAggregateFunction(sum, Decimal(38, 18))	Nein

hyperliquid_metrics_overview

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

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

hyperliquid_oracle_prices

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

Column	Typ	Sort Key
asset_idx	UInt16	Ja
block_number	UInt64	Ja
clearinghouse	UInt8	Ja
Münze	LowCardinality(String)	Nein
daily_px	String	Nein
indexed_at	DateTime64(3, 'UTC')	Nein
mark_px	String	Nein
snapshot_time	DateTime64(6, 'UTC')	Nein

hyperliquid_order_book_diffs

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

Column	Typ	Sort Key
block_number	UInt64	Ja
block_time	DateTime64(6, 'UTC')	Nein
Münze	LowCardinality(String)	Ja
diff_type	LowCardinality(String)	Nein
indexed_at	DateTime64(3, 'UTC')	Nein
new_size	Nullable(Decimal(38, 18))	Nein
oid	UInt64	Ja
orig_size	Nullable(Decimal(38, 18))	Nein
Preis	Decimal(38, 18)	Nein
Seite	Enum8('B' = 1, 'A' = 2)	Ja
Größe	Nullable(Decimal(38, 18))	Nein
user	FixedString(42)	Nein

hyperliquid_orders

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

Column	Typ	Sort Key
block_number	UInt64	Ja
block_time	DateTime64(6, 'UTC')	Nein
builder	Nullable(String)	Nein
children	Nullable(String)	Nein
cloid	Nullable(String)	Nein
Münze	LowCardinality(String)	Nein
Hash	Nullable(FixedString(66))	Nein
indexed_at	DateTime64(3, 'UTC')	Nein
is_position_tpsl	UInt8	Nein
is_trigger	UInt8	Nein
limit_price	Decimal(38, 18)	Nein
oid	UInt64	Ja
order_timestamp	DateTime64(3, 'UTC')	Nein
order_type	LowCardinality(String)	Nein
orig_size	Decimal(38, 18)	Nein
reduce_only	UInt8	Nein
Seite	Enum8('B' = 1, 'A' = 2)	Nein
Größe	Decimal(38, 18)	Nein
Status	LowCardinality(String)	Nein
status_time	DateTime64(6, 'UTC')	Ja
tif	LowCardinality(String)	Nein
trigger_condition	Nullable(String)	Nein
trigger_price	Nullable(Decimal(38, 18))	Nein
unique_id	String	Nein
user	FixedString(42)	Nein

hyperliquid_outcome_markets

Sort Keys: ⚡ none | Partition: none

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

hyperliquid_outcome_meta

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

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

hyperliquid_outcome_question_members

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

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

hyperliquid_outcome_questions

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

Column	Typ	Sort Key
block_number	UInt64	Ja
Beschreibung	String	Nein
fallback_outcome	Nullable(UInt64)	Nein
indexed_at	DateTime64(3, 'UTC')	Nein
Name	String	Nein
named_outcomes_json	String	Nein
question_id	UInt64	Ja
raw_question_json	String	Nein
settled_named_outcomes_json	String	Nein
snapshot_time	DateTime64(6, 'UTC')	Nein

hyperliquid_outcome_sides

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

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

hyperliquid_perpetual_market_contexts

Sort Keys: ⚡ none | Partition: none

Column	Typ	Sort Key
Münze	LowCardinality(String)	Nein
day_base_vlm	Decimal(38, 18)	Nein
day_ntl_vlm	Decimal(38, 18)	Nein
funding	Decimal(38, 18)	Nein
impact_ask	Nullable(Decimal(38, 18))	Nein
impact_bid	Nullable(Decimal(38, 18))	Nein
mark_px	Decimal(38, 18)	Nein
mid_px	Decimal(38, 18)	Nein
open_interest	Decimal(38, 18)	Nein
oracle_px	Decimal(38, 18)	Nein
polled_at	DateTime64(6, 'UTC')	Nein
premium	Decimal(38, 18)	Nein
prev_day_px	Decimal(38, 18)	Nein

hyperliquid_perpetual_markets

Sort Keys: ⚡ coin | Partition: none

Column	Typ	Sort Key
Münze	LowCardinality(String)	Ja
indexed_at	DateTime64(3, 'UTC')	Nein
margin_table_id	Nullable(UInt16)	Nein
market_index	UInt16	Nein
max_leverage	UInt16	Nein
only_isolated	UInt8	Nein
sz_decimals	UInt8	Nein

hyperliquid_perpetual_positions

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

Column	Typ	Sort Key
asset_idx	UInt16	Ja
block_number	UInt64	Ja
clearinghouse	UInt8	Ja
Münze	String	Nein
entry_notional	UInt64	Nein
funding_alltime	Int64	Nein
funding_since_change	Int64	Nein
funding_since_open	Int64	Nein
indexed_at	DateTime64(3, 'UTC')	Nein
margin	UInt64	Nein
Größe	Int64	Nein
snapshot_time	DateTime64(6, 'UTC')	Nein
usdc_balance	Int64	Nein
user	String	Ja

hyperliquid_quote_token_meta

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

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

hyperliquid_register_referral

Sort Keys: ⚡ referral_code, user | Partition: none

Column	Typ	Sort Key
block_time	DateTime64(6, 'UTC')	Nein
Fehler	Nullable(String)	Nein
indexed_at	DateTime64(3, 'UTC')	Nein
is_success	UInt8	Nein
referral_code	String	Ja
rund	UInt64	Nein
tx_hash	String	Nein
user	String	Ja

hyperliquid_set_referrer

Sort Keys: ⚡ referral_code, user | Partition: none

Column	Typ	Sort Key
block_time	DateTime64(6, 'UTC')	Nein
Fehler	Nullable(String)	Nein
indexed_at	DateTime64(3, 'UTC')	Nein
is_success	UInt8	Nein
referral_code	String	Ja
rund	UInt64	Nein
tx_hash	String	Nein
user	String	Ja

hyperliquid_spot_balances

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

Column	Typ	Sort Key
block_number	UInt64	Ja
escrowed	Int64	Nein
indexed_at	DateTime64(3, 'UTC')	Nein
snapshot_time	DateTime64(6, 'UTC')	Nein
Token	String	Nein
token_idx	UInt16	Ja
insgesamt	Int64	Nein
user	String	Ja

hyperliquid_spot_clearinghouse_states

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

Column	Typ	Sort Key
block_number	UInt64	Ja
escrowed	Int64	Nein
indexed_at	DateTime64(3, 'UTC')	Nein
snapshot_time	DateTime64(6, 'UTC')	Nein
Token	LowCardinality(String)	Nein
token_idx	UInt16	Ja
insgesamt	Int64	Nein
user	FixedString(42)	Ja

hyperliquid_spot_markets

Sort Keys: ⚡ token_index | Partition: none

Column	Typ	Sort Key
deployer_trading_fee_share	Nullable(String)	Nein
evm_contract	Nullable(String)	Nein
vollständiger_Name	Nullable(String)	Nein
indexed_at	DateTime64(3, 'UTC')	Nein
is_canonical	UInt8	Nein
pair_index	Nullable(UInt16)	Nein
pair_name	Nullable(String)	Nein
sz_decimals	UInt8	Nein
Token	LowCardinality(String)	Nein
token_id	String	Nein
token_index	UInt16	Ja
wei_decimals	UInt8	Nein

hyperliquid_spot_pairs

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

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

hyperliquid_staking_events

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

Column	Typ	Sort Key
Betrag	Decimal(38, 18)	Nein
block_number	UInt64	Ja
block_time	DateTime64(6, 'UTC')	Nein
event_type	Enum8('CDeposit' = 1, 'CWithdrawal' = 2, 'Delegation' = 3)	Nein
Hash	FixedString(66)	Ja
indexed_at	DateTime64(3, 'UTC')	Nein
is_finalized	Nullable(UInt8)	Nein
is_undelegate	Nullable(UInt8)	Nein
Zeit	DateTime64(6, 'UTC')	Nein
user	FixedString(42)	Nein
Validator	Nullable(FixedString(42))	Nein

hyperliquid_sub_accounts

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

Column	Typ	Sort Key
block_number	UInt64	Ja
indexed_at	DateTime64(3, 'UTC')	Nein
master_account	FixedString(42)	Nein
Name	Nullable(String)	Nein
snapshot_time	DateTime64(6, 'UTC')	Nein
sub_account	FixedString(42)	Ja

hyperliquid_summaries

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

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

hyperliquid_system_actions

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

Column	Typ	Sort Key
Aktion	String	Nein
action_type	LowCardinality(String)	Nein
agent_address	Nullable(FixedString(42))	Nein
agent_name	Nullable(String)	Nein
block_number	UInt64	Ja
block_time	DateTime64(6, 'UTC')	Nein
destination	Nullable(FixedString(42))	Nein
destination_dex_or_spot	Nullable(UInt8)	Nein
evm_tx_hash	FixedString(66)	Ja
from_sub_account	Nullable(UInt8)	Nein
hyperliquid_chain	Nullable(String)	Nein
indexed_at	DateTime64(3, 'UTC')	Nein
is_mint	Nullable(UInt8)	Nein
is_undelegate	Nullable(UInt8)	Nein
Nonce	UInt64	Ja
ntl	Nullable(Decimal(38, 18))	Nein
order_grouping	Nullable(String)	Nein
signature_chain_id	Nullable(String)	Nein
source_dex_or_spot	Nullable(UInt8)	Nein
to_perp	Nullable(UInt8)	Nein
Token	Nullable(UInt16)	Nein
user	FixedString(42)	Nein
Validator	Nullable(FixedString(42))	Nein
wei	Nullable(UInt256)	Nein

hyperliquid_token_usdc_prices

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

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

hyperliquid_trades

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

Column	Typ	Sort Key
block_number	UInt64	Ja
block_time	DateTime64(6, 'UTC')	Nein
buyer_address	FixedString(42)	Nein
buyer_builder_address	Nullable(FixedString(42))	Nein
buyer_builder_fee	Nullable(Decimal(38, 18))	Nein
buyer_closed_pnl	Decimal(38, 18)	Nein
buyer_crossed	UInt8	Nein
buyer_deployer_fee	Nullable(Decimal(38, 18))	Nein
buyer_dir	LowCardinality(String)	Nein
buyer_fee	Decimal(38, 18)	Nein
buyer_order_id	UInt64	Nein
buyer_priority_gas	Nullable(Decimal(38, 18))	Nein
buyer_start_position	Decimal(38, 18)	Nein
buyer_twap_id	Nullable(UInt64)	Nein
Münze	LowCardinality(String)	Nein
fee_token	LowCardinality(String)	Nein
indexed_at	DateTime64(3, 'UTC')	Nein
liquidated_user	Nullable(FixedString(42))	Nein
liquidation_mark_price	Nullable(Decimal(38, 18))	Nein
liquidation_method	Nullable(String)	Nein
Preis	Decimal(38, 18)	Nein
seller_address	FixedString(42)	Nein
seller_builder_address	Nullable(FixedString(42))	Nein
seller_builder_fee	Nullable(Decimal(38, 18))	Nein
seller_closed_pnl	Decimal(38, 18)	Nein
seller_crossed	UInt8	Nein
seller_deployer_fee	Nullable(Decimal(38, 18))	Nein
seller_dir	LowCardinality(String)	Nein
seller_fee	Decimal(38, 18)	Nein
seller_order_id	UInt64	Nein
seller_priority_gas	Nullable(Decimal(38, 18))	Nein
seller_start_position	Decimal(38, 18)	Nein
seller_twap_id	Nullable(UInt64)	Nein
Seite	Enum8('B' = 1, 'A' = 2)	Nein
Größe	Decimal(38, 18)	Nein
Zeitstempel	DateTime64(3, 'UTC')	Nein
total_builder_fee	Nullable(Decimal(38, 18))	Nein
trade_id	UInt64	Ja
transaction_hash	FixedString(66)	Nein
unique_id	String	Nein

hyperliquid_transactions

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

Column	Typ	Sort Key
Aktion	JSON	Nein
action_type	LowCardinality(String)	Nein
block_time	DateTime64(6, 'UTC')	Nein
Fehler	Nullable(String)	Nein
indexed_at	DateTime64(3, 'UTC')	Nein
is_success	UInt8	Nein
Nonce	UInt64	Ja
Antragsteller	Nullable(String)	Nein
rund	UInt64	Ja
tx_hash	String	Ja
user	Nullable(String)	Nein
vault_address	Nullable(String)	Nein

hyperliquid_twap_statuses

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

Column	Typ	Sort Key
block_number	UInt64	Ja
block_time	DateTime64(6, 'UTC')	Nein
Münze	LowCardinality(String)	Nein
executed_ntl	Decimal(38, 18)	Nein
executed_size	Decimal(38, 18)	Nein
indexed_at	DateTime64(3, 'UTC')	Nein
minutes	UInt16	Nein
randomize	UInt8	Nein
reduce_only	UInt8	Nein
Seite	Enum8('B' = 1, 'A' = 2)	Nein
Größe	Decimal(38, 18)	Nein
Status	LowCardinality(String)	Nein
Zeit	DateTime64(6, 'UTC')	Ja
Zeitstempel	DateTime64(3, 'UTC')	Nein
twap_id	UInt64	Ja
user	FixedString(42)	Nein

hyperliquid_validator_rewards

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

Column	Typ	Sort Key
block_number	UInt64	Ja
block_time	DateTime64(6, 'UTC')	Nein
Hash	FixedString(66)	Nein
indexed_at	DateTime64(3, 'UTC')	Nein
reward	Decimal(38, 18)	Nein
Zeit	DateTime64(6, 'UTC')	Ja
Validator	FixedString(42)	Ja

hyperliquid_vault_equities

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

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

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"

Ersetzen 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 skills add 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]

Wir ❤️ Feedback!

Wenn Sie Anregungen oder Fragen zu dieser Dokumentation haben, teilen Sie uns diese bitte mit. Wir freuen uns auf Ihre Rückmeldung!

Übersicht​

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​

Wir ❤️ Feedback!​

Übersicht

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

Wir ❤️ Feedback!