अवलोकन

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)	हाँ
block_number	UInt64	हाँ
indexed_at	DateTime64(3, 'UTC')	नहीं
नाम	String	नहीं
snapshot_time	DateTime64(6, 'UTC')	नहीं
user	FixedString(42)	नहीं
valid_until	String	नहीं

hyperliquid_asset_transfers

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

Column	Type	Sort Key
मात्रा	Nullable(Decimal(38, 18))	नहीं
block_number	UInt64	हाँ
block_time	DateTime64(6, 'UTC')	नहीं
destination	Nullable(FixedString(42))	नहीं
fee	Nullable(Decimal(38, 18))	नहीं
indexed_at	DateTime64(3, 'UTC')	नहीं
n एक	Nullable(UInt64)	नहीं
time	DateTime64(6, 'UTC')	नहीं
टोकन	Nullable(String)	नहीं
transfer_type	LowCardinality(String)	नहीं
tx_hash	FixedString(66)	हाँ
usdc_amount	Nullable(Decimal(38, 18))	नहीं
user	FixedString(42)	हाँ

hyperliquid_blocks

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

Column	Type	Sort Key
block_number	UInt64	हाँ
block_time	DateTime64(6, 'UTC')	नहीं
book_diffs_count	UInt32	नहीं
fills_count	UInt32	नहीं
indexed_at	DateTime64(3, 'UTC')	नहीं
misc_events_count	UInt32	नहीं
orders_count	UInt32	नहीं
twap_statuses_count	UInt32	नहीं
writer_actions_count	UInt32	नहीं

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	नहीं
block_number	UInt64	हाँ
bridge_type	LowCardinality(String)	हाँ
eth_block_number	UInt64	हाँ
event_time	String	नहीं
indexed_at	DateTime64(3, 'UTC')	नहीं
n एक	UInt64	हाँ
snapshot_time	DateTime64(6, 'UTC')	नहीं
tx_hash	String	हाँ
user	FixedString(42)	हाँ

hyperliquid_builder_fills

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

Column	Type	Sort Key
block_number	UInt64	नहीं
block_time	DateTime64(6, 'UTC')	नहीं
builder_address	Nullable(FixedString(42))	हाँ
builder_fee	Nullable(Decimal(38, 18))	नहीं
cloid	Nullable(String)	नहीं
closed_pnl	Decimal(38, 18)	नहीं
सिक्का	LowCardinality(String)	नहीं
created_at	DateTime64(6, 'UTC')	नहीं
crossed	UInt8	नहीं
dir	LowCardinality(String)	नहीं
fee	Decimal(38, 18)	नहीं
हैश	FixedString(66)	नहीं
indexed_at	DateTime64(3, 'UTC')	नहीं
is_liquidation	UInt8	नहीं
liquidated_user	Nullable(FixedString(42))	नहीं
liquidation_mark_price	Nullable(Decimal(38, 18))	नहीं
liquidation_method	Nullable(String)	नहीं
oid	UInt64	नहीं
कीमत	Decimal(38, 18)	नहीं
ओर	Enum8('B' = 1, 'A' = 2)	नहीं
आकार	Decimal(38, 18)	नहीं
start_position	Decimal(38, 18)	नहीं
tid	UInt64	हाँ
TIMESTAMP	DateTime64(3, 'UTC')	हाँ
twap_id	Nullable(UInt64)	नहीं
अपडेट किया गया_पर	DateTime64(6, 'UTC')	नहीं
user	FixedString(42)	नहीं

hyperliquid_builder_transactions

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

Column	Type	Sort Key
action_type	LowCardinality(String)	नहीं
block_number	UInt64	हाँ
block_time	DateTime64(6, 'UTC')	नहीं
builder	String	नहीं
builder_fee	Nullable(Decimal(38, 18))	नहीं
सिक्का	Nullable(String)	नहीं
हैश	String	हाँ
indexed_at	DateTime64(3, 'UTC')	नहीं
is_success	UInt8	नहीं
user	String	हाँ

hyperliquid_clearinghouse_states

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

Column	Type	Sort Key
asset_idx	UInt16	हाँ
block_number	UInt64	हाँ
clearinghouse	UInt8	हाँ
सिक्का	LowCardinality(String)	नहीं
entry_notional	UInt64	नहीं
funding_alltime	Int64	नहीं
funding_since_change	Int64	नहीं
funding_since_open	Int64	नहीं
indexed_at	DateTime64(3, 'UTC')	नहीं
margin	UInt64	नहीं
आकार	Int64	नहीं
snapshot_time	DateTime64(6, 'UTC')	नहीं
usdc_balance	Int64	नहीं
user	FixedString(42)	हाँ

hyperliquid_delegator_rewards

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

Column	Type	Sort Key
block_number	UInt64	हाँ
c	UInt64	नहीं
commission_bps	UInt16	नहीं
delegator	FixedString(42)	हाँ
e	UInt64	नहीं
indexed_at	DateTime64(3, 'UTC')	नहीं
m	UInt64	नहीं
reward	Decimal(38, 8)	नहीं
reward_wei	UInt64	नहीं
snapshot_time	DateTime64(6, 'UTC')	नहीं
source	LowCardinality(String)	नहीं
validator	FixedString(42)	हाँ
validator_total_delegated	UInt64	नहीं

hyperliquid_dex_trades

Sort Keys: ⚡ none | Partition: none

Column	Type	Sort Key
block_number	UInt64	नहीं
block_time	DateTime64(6, 'UTC')	नहीं
buyer_address	FixedString(42)	नहीं
buyer_builder_address	Nullable(FixedString(42))	नहीं
buyer_builder_fee	Nullable(Decimal(38, 18))	नहीं
buyer_closed_pnl	Decimal(38, 18)	नहीं
buyer_crossed	UInt8	नहीं
buyer_dir	LowCardinality(String)	नहीं
buyer_fee	Decimal(38, 18)	नहीं
buyer_order_id	UInt64	नहीं
buyer_start_position	Decimal(38, 18)	नहीं
buyer_twap_id	Nullable(UInt64)	नहीं
सिक्का	LowCardinality(String)	नहीं
शुल्क_टोकन	LowCardinality(String)	नहीं
indexed_at	DateTime64(3, 'UTC')	नहीं
liquidated_user	Nullable(FixedString(42))	नहीं
liquidation_mark_price	Nullable(Decimal(38, 18))	नहीं
liquidation_method	Nullable(String)	नहीं
market_type	String	नहीं
कीमत	Decimal(38, 18)	नहीं
seller_address	FixedString(42)	नहीं
seller_builder_address	Nullable(FixedString(42))	नहीं
seller_builder_fee	Nullable(Decimal(38, 18))	नहीं
seller_closed_pnl	Decimal(38, 18)	नहीं
seller_crossed	UInt8	नहीं
seller_dir	LowCardinality(String)	नहीं
seller_fee	Decimal(38, 18)	नहीं
seller_order_id	UInt64	नहीं
seller_start_position	Decimal(38, 18)	नहीं
seller_twap_id	Nullable(UInt64)	नहीं
ओर	Enum8('B' = 1, 'A' = 2)	नहीं
आकार	Decimal(38, 18)	नहीं
TIMESTAMP	DateTime64(3, 'UTC')	नहीं
total_builder_fee	Nullable(Decimal(38, 18))	नहीं
trade_id	UInt64	नहीं
transaction_hash	FixedString(66)	नहीं
unique_id	String	नहीं
usd_amount	Decimal(38, 18)	नहीं

hyperliquid_display_names

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

Column	Type	Sort Key
block_number	UInt64	हाँ
display_name	String	नहीं
indexed_at	DateTime64(3, 'UTC')	नहीं
snapshot_time	DateTime64(6, 'UTC')	नहीं
user	FixedString(42)	हाँ

hyperliquid_fills

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

Column	Type	Sort Key
block_number	UInt64	हाँ
block_time	DateTime64(6, 'UTC')	नहीं
builder	Nullable(FixedString(42))	नहीं
builder_fee	Nullable(Decimal(38, 18))	नहीं
cloid	Nullable(String)	नहीं
closed_pnl	Decimal(38, 18)	नहीं
सिक्का	LowCardinality(String)	नहीं
crossed	UInt8	नहीं
deployer_fee	Nullable(Decimal(38, 18))	नहीं
dir	LowCardinality(String)	नहीं
fee	Decimal(38, 18)	नहीं
शुल्क_टोकन	LowCardinality(String)	नहीं
हैश	FixedString(66)	नहीं
indexed_at	DateTime64(3, 'UTC')	नहीं
is_liquidation	UInt8	नहीं
liquidated_user	Nullable(FixedString(42))	नहीं
liquidation_mark_price	Nullable(Decimal(38, 18))	नहीं
liquidation_method	Nullable(String)	नहीं
oid	UInt64	नहीं
कीमत	Decimal(38, 18)	नहीं
priority_gas	Nullable(Decimal(38, 18))	नहीं
ओर	Enum8('B' = 1, 'A' = 2)	नहीं
आकार	Decimal(38, 18)	नहीं
start_position	Decimal(38, 18)	नहीं
tid	UInt64	हाँ
time	DateTime64(3, 'UTC')	नहीं
twap_id	Nullable(UInt64)	नहीं
user	FixedString(42)	हाँ

hyperliquid_funding

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

Column	Type	Sort Key
block_number	UInt64	हाँ
block_time	DateTime64(6, 'UTC')	नहीं
सिक्का	LowCardinality(String)	हाँ
funding_amount	Decimal(38, 18)	नहीं
funding_rate	Decimal(38, 18)	नहीं
हैश	FixedString(66)	नहीं
indexed_at	DateTime64(3, 'UTC')	नहीं
szi	Decimal(38, 18)	नहीं
time	DateTime64(6, 'UTC')	हाँ
user	FixedString(42)	हाँ

hyperliquid_funding_summary_hourly

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

Column	Type	Sort Key
avg_funding_rate	SimpleAggregateFunction(any, Float64)	नहीं
सिक्का	LowCardinality(String)	हाँ
hour	DateTime('UTC')	हाँ
total_funding	SimpleAggregateFunction(sum, Decimal(38, 18))	नहीं
unique_users	SimpleAggregateFunction(max, UInt64)	नहीं

hyperliquid_ledger_updates

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

Column	Type	Sort Key
account_value	Nullable(Decimal(38, 18))	नहीं
मात्रा	Nullable(Decimal(38, 18))	नहीं
basis	Nullable(Decimal(38, 18))	नहीं
block_number	UInt64	हाँ
block_time	DateTime64(6, 'UTC')	नहीं
closing_cost	Nullable(Decimal(38, 18))	नहीं
commission	Nullable(Decimal(38, 18))	नहीं
delta_type	LowCardinality(String)	नहीं
destination	Nullable(FixedString(42))	नहीं
destination_dex	Nullable(String)	नहीं
dex	Nullable(String)	नहीं
fee	Nullable(Decimal(38, 18))	नहीं
शुल्क_टोकन	Nullable(String)	नहीं
हैश	FixedString(66)	हाँ
indexed_at	DateTime64(3, 'UTC')	नहीं
interest_amount	Nullable(Decimal(38, 18))	नहीं
is_deposit	Nullable(UInt8)	नहीं
leverage_type	Nullable(String)	नहीं
liquidated_ntl_pos	Nullable(Decimal(38, 18))	नहीं
liquidated_positions	Nullable(String)	नहीं
native_token_fee	Nullable(Decimal(38, 18))	नहीं
net_withdrawn_usd	Nullable(Decimal(38, 18))	नहीं
n एक	Nullable(UInt64)	नहीं
operation	Nullable(String)	नहीं
requested_usd	Nullable(Decimal(38, 18))	नहीं
secondary_user	Nullable(FixedString(42))	नहीं
source_dex	Nullable(String)	नहीं
time	DateTime64(6, 'UTC')	हाँ
to_perp	Nullable(UInt8)	नहीं
टोकन	Nullable(String)	नहीं
usdc_amount	Nullable(Decimal(38, 18))	नहीं
usdc_value	Nullable(Decimal(38, 18))	नहीं
user	FixedString(42)	हाँ
vault	Nullable(FixedString(42))	नहीं

hyperliquid_liquidations_hourly

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

Column	Type	Sort Key
सिक्का	LowCardinality(String)	हाँ
hour	DateTime	हाँ
liquidated_volume	SimpleAggregateFunction(sum, Decimal(38, 18))	नहीं
liquidation_count	SimpleAggregateFunction(sum, UInt64)	नहीं
unique_liquidated_users	SimpleAggregateFunction(max, UInt64)	नहीं

hyperliquid_market_volume_hourly

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

Column	Type	Sort Key
close	SimpleAggregateFunction(anyLast, Decimal(38, 18))	नहीं
सिक्का	LowCardinality(String)	हाँ
high	SimpleAggregateFunction(max, Decimal(38, 18))	नहीं
hour	DateTime('UTC')	हाँ
low	SimpleAggregateFunction(min, Decimal(38, 18))	नहीं
खुला	SimpleAggregateFunction(any, Decimal(38, 18))	नहीं
trade_count	SimpleAggregateFunction(sum, UInt64)	नहीं
आयतन	SimpleAggregateFunction(sum, Decimal(38, 18))	नहीं

hyperliquid_metrics_dex_overview

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

Column	Type	Sort Key
सिक्का	LowCardinality(String)	हाँ
day	तारीख	हाँ
fees	SimpleAggregateFunction(sum, Decimal(38, 18))	नहीं
fill_count	SimpleAggregateFunction(sum, UInt64)	नहीं
high_price	SimpleAggregateFunction(max, Decimal(38, 18))	नहीं
liquidations	SimpleAggregateFunction(sum, UInt64)	नहीं
low_price	SimpleAggregateFunction(min, Decimal(38, 18))	नहीं
unique_traders	SimpleAggregateFunction(max, UInt64)	नहीं
volume_usd	SimpleAggregateFunction(sum, Decimal(38, 18))	नहीं

hyperliquid_metrics_overview

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

Column	Type	Sort Key
active_traders	SimpleAggregateFunction(max, UInt64)	नहीं
builder_fill_count	SimpleAggregateFunction(sum, UInt64)	नहीं
coins_traded	SimpleAggregateFunction(max, UInt64)	नहीं
day	तारीख	हाँ
liquidation_count	SimpleAggregateFunction(sum, UInt64)	नहीं
liquidation_volume_usd	SimpleAggregateFunction(sum, Decimal(38, 18))	नहीं
total_builder_fees	SimpleAggregateFunction(sum, Decimal(38, 18))	नहीं
total_fees	SimpleAggregateFunction(sum, Decimal(38, 18))	नहीं
total_fills	SimpleAggregateFunction(sum, UInt64)	नहीं
total_volume_usd	SimpleAggregateFunction(sum, Decimal(38, 18))	नहीं

hyperliquid_oracle_prices

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

Column	Type	Sort Key
asset_idx	UInt16	हाँ
block_number	UInt64	हाँ
clearinghouse	UInt8	हाँ
सिक्का	LowCardinality(String)	नहीं
daily_px	String	नहीं
indexed_at	DateTime64(3, 'UTC')	नहीं
mark_px	String	नहीं
snapshot_time	DateTime64(6, 'UTC')	नहीं

hyperliquid_order_book_diffs

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

Column	Type	Sort Key
block_number	UInt64	हाँ
block_time	DateTime64(6, 'UTC')	नहीं
सिक्का	LowCardinality(String)	हाँ
diff_type	LowCardinality(String)	नहीं
indexed_at	DateTime64(3, 'UTC')	नहीं
new_size	Nullable(Decimal(38, 18))	नहीं
oid	UInt64	हाँ
orig_size	Nullable(Decimal(38, 18))	नहीं
कीमत	Decimal(38, 18)	नहीं
ओर	Enum8('B' = 1, 'A' = 2)	हाँ
आकार	Nullable(Decimal(38, 18))	नहीं
user	FixedString(42)	नहीं

hyperliquid_orders

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

Column	Type	Sort Key
block_number	UInt64	हाँ
block_time	DateTime64(6, 'UTC')	नहीं
builder	Nullable(String)	नहीं
children	Nullable(String)	नहीं
cloid	Nullable(String)	नहीं
सिक्का	LowCardinality(String)	नहीं
हैश	Nullable(FixedString(66))	नहीं
indexed_at	DateTime64(3, 'UTC')	नहीं
is_position_tpsl	UInt8	नहीं
is_trigger	UInt8	नहीं
limit_price	Decimal(38, 18)	नहीं
oid	UInt64	हाँ
order_timestamp	DateTime64(3, 'UTC')	नहीं
order_type	LowCardinality(String)	नहीं
orig_size	Decimal(38, 18)	नहीं
reduce_only	UInt8	नहीं
ओर	Enum8('B' = 1, 'A' = 2)	नहीं
आकार	Decimal(38, 18)	नहीं
स्थिति	LowCardinality(String)	नहीं
status_time	DateTime64(6, 'UTC')	हाँ
tif	LowCardinality(String)	नहीं
trigger_condition	Nullable(String)	नहीं
trigger_price	Nullable(Decimal(38, 18))	नहीं
unique_id	String	नहीं
user	FixedString(42)	नहीं

hyperliquid_outcome_markets

Sort Keys: ⚡ none | Partition: none

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

hyperliquid_outcome_meta

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

Column	Type	Sort Key
block_number	UInt64	हाँ
deploy_gas_auction_json	String	नहीं
description	String	नहीं
expiry	String	नहीं
fee_share	Float64	नहीं
indexed_at	DateTime64(3, 'UTC')	नहीं
locked	UInt8	नहीं
नाम	LowCardinality(String)	नहीं
ndo	UInt64	नहीं
nou	UInt64	नहीं
nqu	UInt64	नहीं
outcome_class	LowCardinality(String)	नहीं
outcome_id	UInt64	हाँ
period	LowCardinality(String)	नहीं
quote_raw	Nullable(UInt64)	नहीं
raw_spec_json	String	नहीं
side_count	UInt16	नहीं
snapshot_time	DateTime64(6, 'UTC')	नहीं
target_price	String	नहीं
underlying	LowCardinality(String)	नहीं

hyperliquid_outcome_question_members

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

Column	Type	Sort Key
block_number	UInt64	हाँ
indexed_at	DateTime64(3, 'UTC')	नहीं
is_fallback	UInt8	नहीं
is_settled	UInt8	नहीं
outcome_id	UInt64	हाँ
question_id	UInt64	हाँ
snapshot_time	DateTime64(6, 'UTC')	नहीं
source	LowCardinality(String)	नहीं

hyperliquid_outcome_questions

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

Column	Type	Sort Key
block_number	UInt64	हाँ
description	String	नहीं
fallback_outcome	Nullable(UInt64)	नहीं
indexed_at	DateTime64(3, 'UTC')	नहीं
नाम	String	नहीं
named_outcomes_json	String	नहीं
question_id	UInt64	हाँ
raw_question_json	String	नहीं
settled_named_outcomes_json	String	नहीं
snapshot_time	DateTime64(6, 'UTC')	नहीं

hyperliquid_outcome_sides

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

Column	Type	Sort Key
base_token_idx	Nullable(UInt64)	नहीं
block_number	UInt64	हाँ
सिक्का	Nullable(String)	नहीं
indexed_at	DateTime64(3, 'UTC')	नहीं
outcome_id	UInt64	हाँ
quote_token_idx	Nullable(UInt64)	नहीं
quote_token_name	Nullable(String)	नहीं
raw_side_json	String	नहीं
side_index	UInt8	हाँ
side_m_raw	String	नहीं
side_m_value	Nullable(Int64)	नहीं
side_name	LowCardinality(String)	नहीं
snapshot_time	DateTime64(6, 'UTC')	नहीं
spot_index	Nullable(UInt64)	नहीं
spot_indices_json	String	नहीं
spot_resolution	LowCardinality(String)	नहीं
token_idx	Nullable(UInt64)	नहीं
token_name	Nullable(String)	नहीं

hyperliquid_perpetual_market_contexts

Sort Keys: ⚡ none | Partition: none

Column	Type	Sort Key
सिक्का	LowCardinality(String)	नहीं
day_base_vlm	Decimal(38, 18)	नहीं
day_ntl_vlm	Decimal(38, 18)	नहीं
funding	Decimal(38, 18)	नहीं
impact_ask	Nullable(Decimal(38, 18))	नहीं
impact_bid	Nullable(Decimal(38, 18))	नहीं
mark_px	Decimal(38, 18)	नहीं
mid_px	Decimal(38, 18)	नहीं
open_interest	Decimal(38, 18)	नहीं
oracle_px	Decimal(38, 18)	नहीं
polled_at	DateTime64(6, 'UTC')	नहीं
premium	Decimal(38, 18)	नहीं
prev_day_px	Decimal(38, 18)	नहीं

hyperliquid_perpetual_markets

Sort Keys: ⚡ coin | Partition: none

Column	Type	Sort Key
सिक्का	LowCardinality(String)	हाँ
indexed_at	DateTime64(3, 'UTC')	नहीं
margin_table_id	Nullable(UInt16)	नहीं
market_index	UInt16	नहीं
max_leverage	UInt16	नहीं
only_isolated	UInt8	नहीं
sz_decimals	UInt8	नहीं

hyperliquid_perpetual_positions

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

Column	Type	Sort Key
asset_idx	UInt16	हाँ
block_number	UInt64	हाँ
clearinghouse	UInt8	हाँ
सिक्का	String	नहीं
entry_notional	UInt64	नहीं
funding_alltime	Int64	नहीं
funding_since_change	Int64	नहीं
funding_since_open	Int64	नहीं
indexed_at	DateTime64(3, 'UTC')	नहीं
margin	UInt64	नहीं
आकार	Int64	नहीं
snapshot_time	DateTime64(6, 'UTC')	नहीं
usdc_balance	Int64	नहीं
user	String	हाँ

hyperliquid_quote_token_meta

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

Column	Type	Sort Key
aligned_quote_info_json	String	नहीं
block_number	UInt64	हाँ
first_enabled_as_quote	String	नहीं
indexed_at	DateTime64(3, 'UTC')	नहीं
is_liquid_base	UInt8	नहीं
is_liquid_quote	UInt8	नहीं
snapshot_time	DateTime64(6, 'UTC')	नहीं
स्थिति	LowCardinality(String)	नहीं
token_idx	UInt64	हाँ
token_name	LowCardinality(String)	नहीं

hyperliquid_register_referral

Sort Keys: ⚡ referral_code, user | Partition: none

Column	Type	Sort Key
block_time	DateTime64(6, 'UTC')	नहीं
गलती	Nullable(String)	नहीं
indexed_at	DateTime64(3, 'UTC')	नहीं
is_success	UInt8	नहीं
referral_code	String	हाँ
round	UInt64	नहीं
tx_hash	String	नहीं
user	String	हाँ

hyperliquid_set_referrer

Sort Keys: ⚡ referral_code, user | Partition: none

Column	Type	Sort Key
block_time	DateTime64(6, 'UTC')	नहीं
गलती	Nullable(String)	नहीं
indexed_at	DateTime64(3, 'UTC')	नहीं
is_success	UInt8	नहीं
referral_code	String	हाँ
round	UInt64	नहीं
tx_hash	String	नहीं
user	String	हाँ

hyperliquid_spot_balances

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

Column	Type	Sort Key
block_number	UInt64	हाँ
escrowed	Int64	नहीं
indexed_at	DateTime64(3, 'UTC')	नहीं
snapshot_time	DateTime64(6, 'UTC')	नहीं
टोकन	String	नहीं
token_idx	UInt16	हाँ
कुल	Int64	नहीं
user	String	हाँ

hyperliquid_spot_clearinghouse_states

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

Column	Type	Sort Key
block_number	UInt64	हाँ
escrowed	Int64	नहीं
indexed_at	DateTime64(3, 'UTC')	नहीं
snapshot_time	DateTime64(6, 'UTC')	नहीं
टोकन	LowCardinality(String)	नहीं
token_idx	UInt16	हाँ
कुल	Int64	नहीं
user	FixedString(42)	हाँ

hyperliquid_spot_markets

Sort Keys: ⚡ token_index | Partition: none

Column	Type	Sort Key
deployer_trading_fee_share	Nullable(String)	नहीं
evm_contract	Nullable(String)	नहीं
full_name	Nullable(String)	नहीं
indexed_at	DateTime64(3, 'UTC')	नहीं
is_canonical	UInt8	नहीं
pair_index	Nullable(UInt16)	नहीं
pair_name	Nullable(String)	नहीं
sz_decimals	UInt8	नहीं
टोकन	LowCardinality(String)	नहीं
token_id	String	नहीं
token_index	UInt16	हाँ
wei_decimals	UInt8	नहीं

hyperliquid_spot_pairs

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

Column	Type	Sort Key
base_token_idx	UInt64	नहीं
base_token_name	LowCardinality(String)	नहीं
block_number	UInt64	हाँ
deploy_time	String	नहीं
indexed_at	DateTime64(3, 'UTC')	नहीं
pair_name	String	नहीं
quote_token_idx	UInt64	नहीं
quote_token_name	LowCardinality(String)	नहीं
raw_spot_info_json	String	नहीं
snapshot_time	DateTime64(6, 'UTC')	नहीं
spot_index	UInt64	हाँ

hyperliquid_staking_events

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

Column	Type	Sort Key
मात्रा	Decimal(38, 18)	नहीं
block_number	UInt64	हाँ
block_time	DateTime64(6, 'UTC')	नहीं
event_type	Enum8('CDeposit' = 1, 'CWithdrawal' = 2, 'Delegation' = 3)	नहीं
हैश	FixedString(66)	हाँ
indexed_at	DateTime64(3, 'UTC')	नहीं
is_finalized	Nullable(UInt8)	नहीं
is_undelegate	Nullable(UInt8)	नहीं
time	DateTime64(6, 'UTC')	नहीं
user	FixedString(42)	नहीं
validator	Nullable(FixedString(42))	नहीं

hyperliquid_sub_accounts

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

Column	Type	Sort Key
block_number	UInt64	हाँ
indexed_at	DateTime64(3, 'UTC')	नहीं
master_account	FixedString(42)	नहीं
नाम	Nullable(String)	नहीं
snapshot_time	DateTime64(6, 'UTC')	नहीं
sub_account	FixedString(42)	हाँ

hyperliquid_summaries

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

Column	Type	Sort Key
cross_maintenance_margin_used	Decimal(38, 18)	नहीं
cross_margin_account_value	Decimal(38, 18)	नहीं
cross_margin_total_margin_used	Decimal(38, 18)	नहीं
cross_margin_total_natl_pos	Decimal(38, 18)	नहीं
cross_margin_total_raw_usd	Decimal(38, 18)	नहीं
indexed_at	DateTime64(3, 'UTC')	नहीं
margin_account_value	Decimal(38, 18)	नहीं
margin_total_margin_used	Decimal(38, 18)	नहीं
margin_total_natl_pos	Decimal(38, 18)	नहीं
margin_total_raw_usd	Decimal(38, 18)	नहीं
polled_at	DateTime64(3, 'UTC')	हाँ
user	String	हाँ
withdrawable	Decimal(38, 18)	नहीं

hyperliquid_system_actions

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

Column	Type	Sort Key
कार्रवाई	String	नहीं
action_type	LowCardinality(String)	नहीं
agent_address	Nullable(FixedString(42))	नहीं
agent_name	Nullable(String)	नहीं
block_number	UInt64	हाँ
block_time	DateTime64(6, 'UTC')	नहीं
destination	Nullable(FixedString(42))	नहीं
destination_dex_or_spot	Nullable(UInt8)	नहीं
evm_tx_hash	FixedString(66)	हाँ
from_sub_account	Nullable(UInt8)	नहीं
hyperliquid_chain	Nullable(String)	नहीं
indexed_at	DateTime64(3, 'UTC')	नहीं
is_mint	Nullable(UInt8)	नहीं
is_undelegate	Nullable(UInt8)	नहीं
n एक	UInt64	हाँ
ntl	Nullable(Decimal(38, 18))	नहीं
order_grouping	Nullable(String)	नहीं
signature_chain_id	Nullable(String)	नहीं
source_dex_or_spot	Nullable(UInt8)	नहीं
to_perp	Nullable(UInt8)	नहीं
टोकन	Nullable(UInt16)	नहीं
user	FixedString(42)	नहीं
validator	Nullable(FixedString(42))	नहीं
wei	Nullable(UInt256)	नहीं

hyperliquid_token_usdc_prices

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

Column	Type	Sort Key
approx_usdc_px	Decimal(38, 18)	नहीं
approx_usdc_px_float_1e6	Float64	नहीं
approx_usdc_px_raw	UInt64	नहीं
block_number	UInt64	हाँ
indexed_at	DateTime64(3, 'UTC')	नहीं
raw_pair_json	String	नहीं
snapshot_time	DateTime64(6, 'UTC')	नहीं
token_idx	UInt64	हाँ
token_name	LowCardinality(String)	नहीं

hyperliquid_trades

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

Column	Type	Sort Key
block_number	UInt64	हाँ
block_time	DateTime64(6, 'UTC')	नहीं
buyer_address	FixedString(42)	नहीं
buyer_builder_address	Nullable(FixedString(42))	नहीं
buyer_builder_fee	Nullable(Decimal(38, 18))	नहीं
buyer_closed_pnl	Decimal(38, 18)	नहीं
buyer_crossed	UInt8	नहीं
buyer_deployer_fee	Nullable(Decimal(38, 18))	नहीं
buyer_dir	LowCardinality(String)	नहीं
buyer_fee	Decimal(38, 18)	नहीं
buyer_order_id	UInt64	नहीं
buyer_priority_gas	Nullable(Decimal(38, 18))	नहीं
buyer_start_position	Decimal(38, 18)	नहीं
buyer_twap_id	Nullable(UInt64)	नहीं
सिक्का	LowCardinality(String)	नहीं
शुल्क_टोकन	LowCardinality(String)	नहीं
indexed_at	DateTime64(3, 'UTC')	नहीं
liquidated_user	Nullable(FixedString(42))	नहीं
liquidation_mark_price	Nullable(Decimal(38, 18))	नहीं
liquidation_method	Nullable(String)	नहीं
कीमत	Decimal(38, 18)	नहीं
seller_address	FixedString(42)	नहीं
seller_builder_address	Nullable(FixedString(42))	नहीं
seller_builder_fee	Nullable(Decimal(38, 18))	नहीं
seller_closed_pnl	Decimal(38, 18)	नहीं
seller_crossed	UInt8	नहीं
seller_deployer_fee	Nullable(Decimal(38, 18))	नहीं
seller_dir	LowCardinality(String)	नहीं
seller_fee	Decimal(38, 18)	नहीं
seller_order_id	UInt64	नहीं
seller_priority_gas	Nullable(Decimal(38, 18))	नहीं
seller_start_position	Decimal(38, 18)	नहीं
seller_twap_id	Nullable(UInt64)	नहीं
ओर	Enum8('B' = 1, 'A' = 2)	नहीं
आकार	Decimal(38, 18)	नहीं
TIMESTAMP	DateTime64(3, 'UTC')	नहीं
total_builder_fee	Nullable(Decimal(38, 18))	नहीं
trade_id	UInt64	हाँ
transaction_hash	FixedString(66)	नहीं
unique_id	String	नहीं

hyperliquid_transactions

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

Column	Type	Sort Key
कार्रवाई	JSON	नहीं
action_type	LowCardinality(String)	नहीं
block_time	DateTime64(6, 'UTC')	नहीं
गलती	Nullable(String)	नहीं
indexed_at	DateTime64(3, 'UTC')	नहीं
is_success	UInt8	नहीं
n एक	UInt64	हाँ
proposer	Nullable(String)	नहीं
round	UInt64	हाँ
tx_hash	String	हाँ
user	Nullable(String)	नहीं
vault_address	Nullable(String)	नहीं

hyperliquid_twap_statuses

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

Column	Type	Sort Key
block_number	UInt64	हाँ
block_time	DateTime64(6, 'UTC')	नहीं
सिक्का	LowCardinality(String)	नहीं
executed_ntl	Decimal(38, 18)	नहीं
executed_size	Decimal(38, 18)	नहीं
indexed_at	DateTime64(3, 'UTC')	नहीं
minutes	UInt16	नहीं
randomize	UInt8	नहीं
reduce_only	UInt8	नहीं
ओर	Enum8('B' = 1, 'A' = 2)	नहीं
आकार	Decimal(38, 18)	नहीं
स्थिति	LowCardinality(String)	नहीं
time	DateTime64(6, 'UTC')	हाँ
TIMESTAMP	DateTime64(3, 'UTC')	नहीं
twap_id	UInt64	हाँ
user	FixedString(42)	नहीं

hyperliquid_validator_rewards

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

Column	Type	Sort Key
block_number	UInt64	हाँ
block_time	DateTime64(6, 'UTC')	नहीं
हैश	FixedString(66)	नहीं
indexed_at	DateTime64(3, 'UTC')	नहीं
reward	Decimal(38, 18)	नहीं
time	DateTime64(6, 'UTC')	हाँ
validator	FixedString(42)	हाँ

hyperliquid_vault_equities

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

Column	Type	Sort Key
block_number	UInt64	हाँ
depositor	FixedString(42)	हाँ
indexed_at	DateTime64(3, 'UTC')	नहीं
leader	FixedString(42)	नहीं
leader_commission	Float64	नहीं
net_deposits	Int64	नहीं
ownership_fraction	Float64	नहीं
snapshot_time	DateTime64(6, 'UTC')	नहीं
vault_address	FixedString(42)	हाँ
vault_name	String	नहीं

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"

प्रतिस्थापित करें 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.

Build Web3 Plugin

For AI agents and LLM applications, install the Build Web3 plugin so your agent can build on SQL Explorer, with full knowledge of its schemas and of every other Quicknode product. In Claude Code:

/plugin marketplace add quicknode/agent-plugins

Using Schema in Your Agent

When building custom AI agents or LLM applications:

1. Fetch the schema via the API endpoint above or download the plain text schema optimized for LLM context windows
2. Include it in your prompt context when generating SQL queries
3. Reference sort keys for optimal query performance
4. 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]