跳转至主要内容

模式参考

更新于
Apr 02, 2026

概述​

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类型Sort Key
agentFixedString(42)是
block_numberUInt64是
indexed_atDateTime64(3, 'UTC')不
名称字符串不
snapshot_timeDateTime64(6, 'UTC')不
用户FixedString(42)不
valid_until字符串不

hyperliquid_asset_transfers

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

Column类型Sort Key
金额Nullable(Decimal(38, 18))不
block_numberUInt64是
block_timeDateTime64(6, 'UTC')不
destinationNullable(FixedString(42))不
费用Nullable(Decimal(38, 18))不
indexed_atDateTime64(3, 'UTC')不
非重复值Nullable(UInt64)不
时间DateTime64(6, 'UTC')不
tokenNullable(String)不
transfer_typeLowCardinality(String)不
tx_hashFixedString(66)是
usdc_amountNullable(Decimal(38, 18))不
用户FixedString(42)是

hyperliquid_blocks

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

Column类型Sort Key
block_numberUInt64是
block_timeDateTime64(6, 'UTC')不
book_diffs_countUInt32不
fills_countUInt32不
indexed_atDateTime64(3, 'UTC')不
misc_events_countUInt32不
orders_countUInt32不
twap_statuses_countUInt32不
writer_actions_countUInt32不

hyperliquid_bridge

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

Column类型Sort Key
amount_weiUInt64不
block_numberUInt64是
bridge_typeLowCardinality(String)是
eth_block_numberUInt64是
event_time字符串不
indexed_atDateTime64(3, 'UTC')不
非重复值UInt64是
snapshot_timeDateTime64(6, 'UTC')不
tx_hash字符串是
用户FixedString(42)是

hyperliquid_builder_fills

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

Column类型Sort Key
block_numberUInt64不
block_timeDateTime64(6, 'UTC')不
builder_addressNullable(FixedString(42))是
builder_feeNullable(Decimal(38, 18))不
cloidNullable(String)不
closed_pnlDecimal(38, 18)不
硬币LowCardinality(String)不
created_atDateTime64(6, 'UTC')不
crossedUInt8不
dirLowCardinality(String)不
费用Decimal(38, 18)不
哈希FixedString(66)不
indexed_atDateTime64(3, 'UTC')不
is_liquidationUInt8不
liquidated_userNullable(FixedString(42))不
liquidation_mark_priceNullable(Decimal(38, 18))不
liquidation_methodNullable(String)不
oidUInt64不
价格Decimal(38, 18)不
侧面Enum8('B' = 1, 'A' = 2)不
大小Decimal(38, 18)不
start_positionDecimal(38, 18)不
tidUInt64是
时间戳DateTime64(3, 'UTC')是
twap_idNullable(UInt64)不
updated_atDateTime64(6, 'UTC')不
用户FixedString(42)不

hyperliquid_builder_transactions

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

Column类型Sort Key
action_typeLowCardinality(String)不
block_numberUInt64是
block_timeDateTime64(6, 'UTC')不
builder字符串不
builder_feeNullable(Decimal(38, 18))不
硬币Nullable(String)不
哈希字符串是
indexed_atDateTime64(3, 'UTC')不
is_successUInt8不
用户字符串是

hyperliquid_clearinghouse_states

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

Column类型Sort Key
asset_idxUInt16是
block_numberUInt64是
clearinghouseUInt8是
硬币LowCardinality(String)不
entry_notionalUInt64不
funding_alltimeInt64不
funding_since_changeInt64不
funding_since_openInt64不
indexed_atDateTime64(3, 'UTC')不
marginUInt64不
大小Int64不
snapshot_timeDateTime64(6, 'UTC')不
usdc_balanceInt64不
用户FixedString(42)是

hyperliquid_delegator_rewards

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

Column类型Sort Key
block_numberUInt64是
cUInt64不
commission_bpsUInt16不
delegatorFixedString(42)是
eUInt64不
indexed_atDateTime64(3, 'UTC')不
mUInt64不
奖励Decimal(38, 8)不
reward_weiUInt64不
snapshot_timeDateTime64(6, 'UTC')不
sourceLowCardinality(String)不
验证器FixedString(42)是
validator_total_delegatedUInt64不

hyperliquid_dex_trades

Sort Keys: ⚡ none | Partition: none

Column类型Sort Key
block_numberUInt64不
block_timeDateTime64(6, 'UTC')不
buyer_addressFixedString(42)不
buyer_builder_addressNullable(FixedString(42))不
buyer_builder_feeNullable(Decimal(38, 18))不
buyer_closed_pnlDecimal(38, 18)不
buyer_crossedUInt8不
buyer_dirLowCardinality(String)不
buyer_feeDecimal(38, 18)不
buyer_order_idUInt64不
buyer_start_positionDecimal(38, 18)不
buyer_twap_idNullable(UInt64)不
硬币LowCardinality(String)不
fee_tokenLowCardinality(String)不
indexed_atDateTime64(3, 'UTC')不
liquidated_userNullable(FixedString(42))不
liquidation_mark_priceNullable(Decimal(38, 18))不
liquidation_methodNullable(String)不
market_type字符串不
价格Decimal(38, 18)不
seller_addressFixedString(42)不
seller_builder_addressNullable(FixedString(42))不
seller_builder_feeNullable(Decimal(38, 18))不
seller_closed_pnlDecimal(38, 18)不
seller_crossedUInt8不
seller_dirLowCardinality(String)不
seller_feeDecimal(38, 18)不
seller_order_idUInt64不
seller_start_positionDecimal(38, 18)不
seller_twap_idNullable(UInt64)不
侧面Enum8('B' = 1, 'A' = 2)不
大小Decimal(38, 18)不
时间戳DateTime64(3, 'UTC')不
total_builder_feeNullable(Decimal(38, 18))不
trade_idUInt64不
交易哈希FixedString(66)不
unique_id字符串不
usd_amountDecimal(38, 18)不

hyperliquid_display_names

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

Column类型Sort Key
block_numberUInt64是
display_name字符串不
indexed_atDateTime64(3, 'UTC')不
snapshot_timeDateTime64(6, 'UTC')不
用户FixedString(42)是

hyperliquid_fills

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

Column类型Sort Key
block_numberUInt64是
block_timeDateTime64(6, 'UTC')不
builderNullable(FixedString(42))不
builder_feeNullable(Decimal(38, 18))不
cloidNullable(String)不
closed_pnlDecimal(38, 18)不
硬币LowCardinality(String)不
crossedUInt8不
deployer_feeNullable(Decimal(38, 18))不
dirLowCardinality(String)不
费用Decimal(38, 18)不
fee_tokenLowCardinality(String)不
哈希FixedString(66)不
indexed_atDateTime64(3, 'UTC')不
is_liquidationUInt8不
liquidated_userNullable(FixedString(42))不
liquidation_mark_priceNullable(Decimal(38, 18))不
liquidation_methodNullable(String)不
oidUInt64不
价格Decimal(38, 18)不
priority_gasNullable(Decimal(38, 18))不
侧面Enum8('B' = 1, 'A' = 2)不
大小Decimal(38, 18)不
start_positionDecimal(38, 18)不
tidUInt64是
时间DateTime64(3, 'UTC')不
twap_idNullable(UInt64)不
用户FixedString(42)是

hyperliquid_funding

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

Column类型Sort Key
block_numberUInt64是
block_timeDateTime64(6, 'UTC')不
硬币LowCardinality(String)是
funding_amountDecimal(38, 18)不
funding_rateDecimal(38, 18)不
哈希FixedString(66)不
indexed_atDateTime64(3, 'UTC')不
sziDecimal(38, 18)不
时间DateTime64(6, 'UTC')是
用户FixedString(42)是

hyperliquid_funding_summary_hourly

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

Column类型Sort Key
avg_funding_rateSimpleAggregateFunction(any, Float64)不
硬币LowCardinality(String)是
hourDateTime('UTC')是
total_fundingSimpleAggregateFunction(sum, Decimal(38, 18))不
unique_usersSimpleAggregateFunction(max, UInt64)不

hyperliquid_ledger_updates

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

Column类型Sort Key
account_valueNullable(Decimal(38, 18))不
金额Nullable(Decimal(38, 18))不
basisNullable(Decimal(38, 18))不
block_numberUInt64是
block_timeDateTime64(6, 'UTC')不
closing_costNullable(Decimal(38, 18))不
commissionNullable(Decimal(38, 18))不
delta_typeLowCardinality(String)不
destinationNullable(FixedString(42))不
destination_dexNullable(String)不
dexNullable(String)不
费用Nullable(Decimal(38, 18))不
fee_tokenNullable(String)不
哈希FixedString(66)是
indexed_atDateTime64(3, 'UTC')不
interest_amountNullable(Decimal(38, 18))不
is_depositNullable(UInt8)不
leverage_typeNullable(String)不
liquidated_ntl_posNullable(Decimal(38, 18))不
liquidated_positionsNullable(String)不
native_token_feeNullable(Decimal(38, 18))不
net_withdrawn_usdNullable(Decimal(38, 18))不
非重复值Nullable(UInt64)不
operationNullable(String)不
requested_usdNullable(Decimal(38, 18))不
secondary_userNullable(FixedString(42))不
source_dexNullable(String)不
时间DateTime64(6, 'UTC')是
to_perpNullable(UInt8)不
tokenNullable(String)不
usdc_amountNullable(Decimal(38, 18))不
usdc_valueNullable(Decimal(38, 18))不
用户FixedString(42)是
vaultNullable(FixedString(42))不

hyperliquid_liquidations_hourly

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

Column类型Sort Key
硬币LowCardinality(String)是
hourDateTime是
liquidated_volumeSimpleAggregateFunction(sum, Decimal(38, 18))不
liquidation_countSimpleAggregateFunction(sum, UInt64)不
unique_liquidated_usersSimpleAggregateFunction(max, UInt64)不

hyperliquid_market_volume_hourly

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

Column类型Sort Key
closeSimpleAggregateFunction(anyLast, Decimal(38, 18))不
硬币LowCardinality(String)是
highSimpleAggregateFunction(max, Decimal(38, 18))不
hourDateTime('UTC')是
lowSimpleAggregateFunction(min, Decimal(38, 18))不
openSimpleAggregateFunction(any, Decimal(38, 18))不
trade_countSimpleAggregateFunction(sum, UInt64)不
volumeSimpleAggregateFunction(sum, Decimal(38, 18))不

hyperliquid_metrics_dex_overview

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

Column类型Sort Key
硬币LowCardinality(String)是
dayDate是
feesSimpleAggregateFunction(sum, Decimal(38, 18))不
fill_countSimpleAggregateFunction(sum, UInt64)不
high_priceSimpleAggregateFunction(max, Decimal(38, 18))不
liquidationsSimpleAggregateFunction(sum, UInt64)不
low_priceSimpleAggregateFunction(min, Decimal(38, 18))不
unique_tradersSimpleAggregateFunction(max, UInt64)不
volume_usdSimpleAggregateFunction(sum, Decimal(38, 18))不

hyperliquid_metrics_overview

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

Column类型Sort Key
active_tradersSimpleAggregateFunction(max, UInt64)不
builder_fill_countSimpleAggregateFunction(sum, UInt64)不
coins_tradedSimpleAggregateFunction(max, UInt64)不
dayDate是
liquidation_countSimpleAggregateFunction(sum, UInt64)不
liquidation_volume_usdSimpleAggregateFunction(sum, Decimal(38, 18))不
total_builder_feesSimpleAggregateFunction(sum, Decimal(38, 18))不
total_feesSimpleAggregateFunction(sum, Decimal(38, 18))不
total_fillsSimpleAggregateFunction(sum, UInt64)不
total_volume_usdSimpleAggregateFunction(sum, Decimal(38, 18))不

hyperliquid_oracle_prices

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

Column类型Sort Key
asset_idxUInt16是
block_numberUInt64是
clearinghouseUInt8是
硬币LowCardinality(String)不
daily_px字符串不
indexed_atDateTime64(3, 'UTC')不
mark_px字符串不
snapshot_timeDateTime64(6, 'UTC')不

hyperliquid_order_book_diffs

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

Column类型Sort Key
block_numberUInt64是
block_timeDateTime64(6, 'UTC')不
硬币LowCardinality(String)是
diff_typeLowCardinality(String)不
indexed_atDateTime64(3, 'UTC')不
new_sizeNullable(Decimal(38, 18))不
oidUInt64是
orig_sizeNullable(Decimal(38, 18))不
价格Decimal(38, 18)不
侧面Enum8('B' = 1, 'A' = 2)是
大小Nullable(Decimal(38, 18))不
用户FixedString(42)不

超流体_订单

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

Column类型Sort Key
block_numberUInt64是
block_timeDateTime64(6, 'UTC')不
builderNullable(String)不
childrenNullable(String)不
cloidNullable(String)不
硬币LowCardinality(String)不
哈希Nullable(FixedString(66))不
indexed_atDateTime64(3, 'UTC')不
is_position_tpslUInt8不
is_triggerUInt8不
limit_priceDecimal(38, 18)不
oidUInt64是
order_timestampDateTime64(3, 'UTC')不
order_typeLowCardinality(String)不
orig_sizeDecimal(38, 18)不
reduce_onlyUInt8不
侧面Enum8('B' = 1, 'A' = 2)不
大小Decimal(38, 18)不
状态LowCardinality(String)不
status_timeDateTime64(6, 'UTC')是
tifLowCardinality(String)不
trigger_conditionNullable(String)不
trigger_priceNullable(Decimal(38, 18))不
unique_id字符串不
用户FixedString(42)不

超流动性_结果_市场

Sort Keys: ⚡ none | Partition: none

Column类型Sort Key
base_token_idxNullable(UInt64)不
block_numberUInt64不
硬币Nullable(String)不
描述字符串不
expiry字符串不
fee_shareFloat64不
first_enabled_as_quote字符串不
indexed_atDateTime64(3, 'UTC')不
is_liquid_baseUInt8不
is_liquid_quoteUInt8不
lockedUInt8不
名称LowCardinality(String)不
ndoUInt64不
nouUInt64不
nquUInt64不
outcome_classLowCardinality(String)不
outcome_idUInt64不
pair_name字符串不
periodLowCardinality(String)不
quote_rawNullable(UInt64)不
quote_token_idxNullable(UInt64)不
quote_token_nameNullable(String)不
quote_token_statusLowCardinality(String)不
quote_token_usdc_pxDecimal(38, 18)不
quote_token_usdc_px_rawUInt64不
raw_side_json字符串不
raw_spec_json字符串不
side_countUInt16不
side_indexUInt8不
side_nameLowCardinality(String)不
snapshot_timeDateTime64(6, 'UTC')不
spot_deploy_time字符串不
spot_indexNullable(UInt64)不
spot_resolutionLowCardinality(String)不
target_price字符串不
token_idxNullable(UInt64)不
token_nameNullable(String)不
underlyingLowCardinality(String)不

hyperliquid_outcome_meta

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

Column类型Sort Key
block_numberUInt64是
deploy_gas_auction_json字符串不
描述字符串不
expiry字符串不
fee_shareFloat64不
indexed_atDateTime64(3, 'UTC')不
lockedUInt8不
名称LowCardinality(String)不
ndoUInt64不
nouUInt64不
nquUInt64不
outcome_classLowCardinality(String)不
outcome_idUInt64是
periodLowCardinality(String)不
quote_rawNullable(UInt64)不
raw_spec_json字符串不
side_countUInt16不
snapshot_timeDateTime64(6, 'UTC')不
target_price字符串不
underlyingLowCardinality(String)不

hyperliquid_outcome_question_members

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

Column类型Sort Key
block_numberUInt64是
indexed_atDateTime64(3, 'UTC')不
is_fallbackUInt8不
is_settledUInt8不
outcome_idUInt64是
question_idUInt64是
snapshot_timeDateTime64(6, 'UTC')不
sourceLowCardinality(String)不

hyperliquid_outcome_questions

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

Column类型Sort Key
block_numberUInt64是
描述字符串不
fallback_outcomeNullable(UInt64)不
indexed_atDateTime64(3, 'UTC')不
名称字符串不
named_outcomes_json字符串不
question_idUInt64是
raw_question_json字符串不
settled_named_outcomes_json字符串不
snapshot_timeDateTime64(6, 'UTC')不

hyperliquid_outcome_sides

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

Column类型Sort Key
base_token_idxNullable(UInt64)不
block_numberUInt64是
硬币Nullable(String)不
indexed_atDateTime64(3, 'UTC')不
outcome_idUInt64是
quote_token_idxNullable(UInt64)不
quote_token_nameNullable(String)不
raw_side_json字符串不
side_indexUInt8是
side_m_raw字符串不
side_m_valueNullable(Int64)不
side_nameLowCardinality(String)不
snapshot_timeDateTime64(6, 'UTC')不
spot_indexNullable(UInt64)不
spot_indices_json字符串不
spot_resolutionLowCardinality(String)不
token_idxNullable(UInt64)不
token_nameNullable(String)不

hyperliquid_perpetual_market_contexts

Sort Keys: ⚡ none | Partition: none

Column类型Sort Key
硬币LowCardinality(String)不
day_base_vlmDecimal(38, 18)不
day_ntl_vlmDecimal(38, 18)不
fundingDecimal(38, 18)不
impact_askNullable(Decimal(38, 18))不
impact_bidNullable(Decimal(38, 18))不
mark_pxDecimal(38, 18)不
mid_pxDecimal(38, 18)不
open_interestDecimal(38, 18)不
oracle_pxDecimal(38, 18)不
polled_atDateTime64(6, 'UTC')不
premiumDecimal(38, 18)不
prev_day_pxDecimal(38, 18)不

hyperliquid_perpetual_markets

Sort Keys: ⚡ coin | Partition: none

Column类型Sort Key
硬币LowCardinality(String)是
indexed_atDateTime64(3, 'UTC')不
margin_table_idNullable(UInt16)不
market_indexUInt16不
max_leverageUInt16不
only_isolatedUInt8不
sz_decimalsUInt8不

hyperliquid_perpetual_positions

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

Column类型Sort Key
asset_idxUInt16是
block_numberUInt64是
clearinghouseUInt8是
硬币字符串不
entry_notionalUInt64不
funding_alltimeInt64不
funding_since_changeInt64不
funding_since_openInt64不
indexed_atDateTime64(3, 'UTC')不
marginUInt64不
大小Int64不
snapshot_timeDateTime64(6, 'UTC')不
usdc_balanceInt64不
用户字符串是

hyperliquid_quote_token_meta

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

Column类型Sort Key
aligned_quote_info_json字符串不
block_numberUInt64是
first_enabled_as_quote字符串不
indexed_atDateTime64(3, 'UTC')不
is_liquid_baseUInt8不
is_liquid_quoteUInt8不
snapshot_timeDateTime64(6, 'UTC')不
状态LowCardinality(String)不
token_idxUInt64是
token_nameLowCardinality(String)不

hyperliquid_register_referral

Sort Keys: ⚡ referral_code, user | Partition: none

Column类型Sort Key
block_timeDateTime64(6, 'UTC')不
错误Nullable(String)不
indexed_atDateTime64(3, 'UTC')不
is_successUInt8不
referral_code字符串是
圆UInt64不
tx_hash字符串不
用户字符串是

hyperliquid_set_referrer

Sort Keys: ⚡ referral_code, user | Partition: none

Column类型Sort Key
block_timeDateTime64(6, 'UTC')不
错误Nullable(String)不
indexed_atDateTime64(3, 'UTC')不
is_successUInt8不
referral_code字符串是
圆UInt64不
tx_hash字符串不
用户字符串是

hyperliquid_spot_balances

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

Column类型Sort Key
block_numberUInt64是
escrowedInt64不
indexed_atDateTime64(3, 'UTC')不
snapshot_timeDateTime64(6, 'UTC')不
token字符串不
token_idxUInt16是
总计Int64不
用户字符串是

hyperliquid_spot_clearinghouse_states

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

Column类型Sort Key
block_numberUInt64是
escrowedInt64不
indexed_atDateTime64(3, 'UTC')不
snapshot_timeDateTime64(6, 'UTC')不
tokenLowCardinality(String)不
token_idxUInt16是
总计Int64不
用户FixedString(42)是

hyperliquid_spot_markets

Sort Keys: ⚡ token_index | Partition: none

Column类型Sort Key
deployer_trading_fee_shareNullable(String)不
evm_contractNullable(String)不
full_nameNullable(String)不
indexed_atDateTime64(3, 'UTC')不
is_canonicalUInt8不
pair_indexNullable(UInt16)不
pair_nameNullable(String)不
sz_decimalsUInt8不
tokenLowCardinality(String)不
token_id字符串不
token_indexUInt16是
wei_decimalsUInt8不

hyperliquid_spot_pairs

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

Column类型Sort Key
base_token_idxUInt64不
base_token_nameLowCardinality(String)不
block_numberUInt64是
deploy_time字符串不
indexed_atDateTime64(3, 'UTC')不
pair_name字符串不
quote_token_idxUInt64不
quote_token_nameLowCardinality(String)不
raw_spot_info_json字符串不
snapshot_timeDateTime64(6, 'UTC')不
spot_indexUInt64是

hyperliquid_staking_events

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

Column类型Sort Key
金额Decimal(38, 18)不
block_numberUInt64是
block_timeDateTime64(6, 'UTC')不
event_typeEnum8('CDeposit' = 1, 'CWithdrawal' = 2, 'Delegation' = 3)不
哈希FixedString(66)是
indexed_atDateTime64(3, 'UTC')不
is_finalizedNullable(UInt8)不
is_undelegateNullable(UInt8)不
时间DateTime64(6, 'UTC')不
用户FixedString(42)不
验证器Nullable(FixedString(42))不

hyperliquid_sub_accounts

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

Column类型Sort Key
block_numberUInt64是
indexed_atDateTime64(3, 'UTC')不
master_accountFixedString(42)不
名称Nullable(String)不
snapshot_timeDateTime64(6, 'UTC')不
sub_accountFixedString(42)是

hyperliquid_summaries

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

Column类型Sort Key
cross_maintenance_margin_usedDecimal(38, 18)不
cross_margin_account_valueDecimal(38, 18)不
cross_margin_total_margin_usedDecimal(38, 18)不
cross_margin_total_natl_posDecimal(38, 18)不
cross_margin_total_raw_usdDecimal(38, 18)不
indexed_atDateTime64(3, 'UTC')不
margin_account_valueDecimal(38, 18)不
margin_total_margin_usedDecimal(38, 18)不
margin_total_natl_posDecimal(38, 18)不
margin_total_raw_usdDecimal(38, 18)不
polled_atDateTime64(3, 'UTC')是
用户字符串是
可提取的Decimal(38, 18)不

hyperliquid_system_actions

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

Column类型Sort Key
动作字符串不
action_typeLowCardinality(String)不
agent_addressNullable(FixedString(42))不
agent_nameNullable(String)不
block_numberUInt64是
block_timeDateTime64(6, 'UTC')不
destinationNullable(FixedString(42))不
destination_dex_or_spotNullable(UInt8)不
evm_tx_hashFixedString(66)是
from_sub_accountNullable(UInt8)不
hyperliquid_chainNullable(String)不
indexed_atDateTime64(3, 'UTC')不
is_mintNullable(UInt8)不
is_undelegateNullable(UInt8)不
非重复值UInt64是
ntlNullable(Decimal(38, 18))不
order_groupingNullable(String)不
signature_chain_idNullable(String)不
source_dex_or_spotNullable(UInt8)不
to_perpNullable(UInt8)不
tokenNullable(UInt16)不
用户FixedString(42)不
验证器Nullable(FixedString(42))不
weiNullable(UInt256)不

hyperliquid_token_usdc_prices

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

Column类型Sort Key
approx_usdc_pxDecimal(38, 18)不
approx_usdc_px_float_1e6Float64不
approx_usdc_px_rawUInt64不
block_numberUInt64是
indexed_atDateTime64(3, 'UTC')不
raw_pair_json字符串不
snapshot_timeDateTime64(6, 'UTC')不
token_idxUInt64是
token_nameLowCardinality(String)不

hyperliquid_trades

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

Column类型Sort Key
block_numberUInt64是
block_timeDateTime64(6, 'UTC')不
buyer_addressFixedString(42)不
buyer_builder_addressNullable(FixedString(42))不
buyer_builder_feeNullable(Decimal(38, 18))不
buyer_closed_pnlDecimal(38, 18)不
buyer_crossedUInt8不
buyer_deployer_feeNullable(Decimal(38, 18))不
buyer_dirLowCardinality(String)不
buyer_feeDecimal(38, 18)不
buyer_order_idUInt64不
buyer_priority_gasNullable(Decimal(38, 18))不
buyer_start_positionDecimal(38, 18)不
buyer_twap_idNullable(UInt64)不
硬币LowCardinality(String)不
fee_tokenLowCardinality(String)不
indexed_atDateTime64(3, 'UTC')不
liquidated_userNullable(FixedString(42))不
liquidation_mark_priceNullable(Decimal(38, 18))不
liquidation_methodNullable(String)不
价格Decimal(38, 18)不
seller_addressFixedString(42)不
seller_builder_addressNullable(FixedString(42))不
seller_builder_feeNullable(Decimal(38, 18))不
seller_closed_pnlDecimal(38, 18)不
seller_crossedUInt8不
seller_deployer_feeNullable(Decimal(38, 18))不
seller_dirLowCardinality(String)不
seller_feeDecimal(38, 18)不
seller_order_idUInt64不
seller_priority_gasNullable(Decimal(38, 18))不
seller_start_positionDecimal(38, 18)不
seller_twap_idNullable(UInt64)不
侧面Enum8('B' = 1, 'A' = 2)不
大小Decimal(38, 18)不
时间戳DateTime64(3, 'UTC')不
total_builder_feeNullable(Decimal(38, 18))不
trade_idUInt64是
交易哈希FixedString(66)不
unique_id字符串不

hyperliquid_transactions

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

Column类型Sort Key
动作JSON不
action_typeLowCardinality(String)不
block_timeDateTime64(6, 'UTC')不
错误Nullable(String)不
indexed_atDateTime64(3, 'UTC')不
is_successUInt8不
非重复值UInt64是
提案人Nullable(String)不
圆UInt64是
tx_hash字符串是
用户Nullable(String)不
vault_addressNullable(String)不

hyperliquid_twap_statuses

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

Column类型Sort Key
block_numberUInt64是
block_timeDateTime64(6, 'UTC')不
硬币LowCardinality(String)不
executed_ntlDecimal(38, 18)不
executed_sizeDecimal(38, 18)不
indexed_atDateTime64(3, 'UTC')不
minutesUInt16不
randomizeUInt8不
reduce_onlyUInt8不
侧面Enum8('B' = 1, 'A' = 2)不
大小Decimal(38, 18)不
状态LowCardinality(String)不
时间DateTime64(6, 'UTC')是
时间戳DateTime64(3, 'UTC')不
twap_idUInt64是
用户FixedString(42)不

hyperliquid_validator_rewards

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

Column类型Sort Key
block_numberUInt64是
block_timeDateTime64(6, 'UTC')不
哈希FixedString(66)不
indexed_atDateTime64(3, 'UTC')不
奖励Decimal(38, 18)不
时间DateTime64(6, 'UTC')是
验证器FixedString(42)是

hyperliquid_vault_equities

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

Column类型Sort Key
block_numberUInt64是
depositorFixedString(42)是
indexed_atDateTime64(3, 'UTC')不
leaderFixedString(42)不
leader_commissionFloat64不
net_depositsInt64不
ownership_fractionFloat64不
snapshot_timeDateTime64(6, 'UTC')不
vault_addressFixedString(42)是
vault_name字符串不

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:


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: 您的API密钥"

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

示例回复：

[
  {
    "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 技能 添加 quiknode-labs/blockchain-skills

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]

我们 ❤️ 您的反馈！​

如果您对本文档有任何反馈或疑问，请告诉我们。我们非常期待您的反馈！

最后更新时间 在……上
分享此文档