Skip to main content

Hyperliquid Schema

Updated on
Nov 16, 2026

Hyperliquid Schema

The Hyperliquid HyperCore dataset contains trades, orders, funding, market data, and supporting tables. Use cluster ID hyperliquid-core-mainnet in SQL Explorer API requests. See Using the REST API for authentication and request format.

The table definitions below come from a schema snapshot. Check the schema endpoint for the current structure.

Download the JSON or text schema from the Schema Overview, or browse HL query examples.

Querying Hyperliquid Data​

Use each table's sort and partition keys to limit data scanned. Many tables are partitioned monthly by a time column, while some have no partition key. Check each table's strategy and filter accordingly. Data types are shown as stored, including UInt64, Decimal(38, 18), and DateTime64(6, 'UTC').

Complete Schema​

Select a table to view its fields, sort keys, and partition strategy.

hyperliquid_agentsAgent names and account permissions recorded in snapshots.
7 fields and storage details
Sort keys block_number, agentPartition toYYYYMM(snapshot_time)
ColumnTypeSort Key
agentFixedString(42)Yes
block_numberUInt64Yes
indexed_atDateTime64(3, 'UTC')No
nameStringNo
snapshot_timeDateTime64(6, 'UTC')No
userFixedString(42)No
valid_untilStringNo
hyperliquid_asset_transfersAsset transfers recorded on HyperCore.
13 fields and storage details
Sort keys block_number, tx_hash, userPartition toYYYYMM(block_time)
ColumnTypeSort Key
amountNullable(Decimal(38, 18))No
block_numberUInt64Yes
block_timeDateTime64(6, 'UTC')No
destinationNullable(FixedString(42))No
feeNullable(Decimal(38, 18))No
indexed_atDateTime64(3, 'UTC')No
nonceNullable(UInt64)No
timeDateTime64(6, 'UTC')No
tokenNullable(String)No
transfer_typeLowCardinality(String)No
tx_hashFixedString(66)Yes
usdc_amountNullable(Decimal(38, 18))No
userFixedString(42)Yes
hyperliquid_blocksBlock-level HyperCore activity and counts.
9 fields and storage details
Sort keys block_numberPartition toYYYYMM(block_time)
ColumnTypeSort Key
block_numberUInt64Yes
block_timeDateTime64(6, 'UTC')No
book_diffs_countUInt32No
fills_countUInt32No
indexed_atDateTime64(3, 'UTC')No
misc_events_countUInt32No
orders_countUInt32No
twap_statuses_countUInt32No
writer_actions_countUInt32No
hyperliquid_bridgeBridge activity between Hyperliquid and Ethereum.
10 fields and storage details
Sort keys block_number, bridge_type, user, nonce, eth_block_number, tx_hashPartition toYYYYMM(snapshot_time)
ColumnTypeSort Key
amount_weiUInt64No
block_numberUInt64Yes
bridge_typeLowCardinality(String)Yes
eth_block_numberUInt64Yes
event_timeStringNo
indexed_atDateTime64(3, 'UTC')No
nonceUInt64Yes
snapshot_timeDateTime64(6, 'UTC')No
tx_hashStringYes
userFixedString(42)Yes
hyperliquid_builder_fillsTrade fills associated with builders.
27 fields and storage details
Sort keys builder_address, timestamp, tidPartition toYYYYMM(block_time)
ColumnTypeSort Key
block_numberUInt64No
block_timeDateTime64(6, 'UTC')No
builder_addressNullable(FixedString(42))Yes
builder_feeNullable(Decimal(38, 18))No
cloidNullable(String)No
closed_pnlDecimal(38, 18)No
coinLowCardinality(String)No
created_atDateTime64(6, 'UTC')No
crossedUInt8No
dirLowCardinality(String)No
feeDecimal(38, 18)No
hashFixedString(66)No
indexed_atDateTime64(3, 'UTC')No
is_liquidationUInt8No
liquidated_userNullable(FixedString(42))No
liquidation_mark_priceNullable(Decimal(38, 18))No
liquidation_methodNullable(String)No
oidUInt64No
priceDecimal(38, 18)No
sideEnum8('B' = 1, 'A' = 2)No
sizeDecimal(38, 18)No
start_positionDecimal(38, 18)No
tidUInt64Yes
timestampDateTime64(3, 'UTC')Yes
twap_idNullable(UInt64)No
updated_atDateTime64(6, 'UTC')No
userFixedString(42)No
hyperliquid_builder_transactionsTransactions and fees associated with builders.
10 fields and storage details
Sort keys block_number, hash, userPartition toYYYYMM(block_time)
ColumnTypeSort Key
action_typeLowCardinality(String)No
block_numberUInt64Yes
block_timeDateTime64(6, 'UTC')No
builderStringNo
builder_feeNullable(Decimal(38, 18))No
coinNullable(String)No
hashStringYes
indexed_atDateTime64(3, 'UTC')No
is_successUInt8No
userStringYes
hyperliquid_clearinghouse_statesClearinghouse account state snapshots.
14 fields and storage details
Sort keys block_number, clearinghouse, user, asset_idxPartition toYYYYMM(snapshot_time)
ColumnTypeSort Key
asset_idxUInt16Yes
block_numberUInt64Yes
clearinghouseUInt8Yes
coinLowCardinality(String)No
entry_notionalUInt64No
funding_alltimeInt64No
funding_since_changeInt64No
funding_since_openInt64No
indexed_atDateTime64(3, 'UTC')No
marginUInt64No
sizeInt64No
snapshot_timeDateTime64(6, 'UTC')No
usdc_balanceInt64No
userFixedString(42)Yes
hyperliquid_delegator_rewardsRewards recorded for delegators.
13 fields and storage details
Sort keys block_number, validator, delegatorPartition toYYYYMM(snapshot_time)
ColumnTypeSort Key
block_numberUInt64Yes
cUInt64No
commission_bpsUInt16No
delegatorFixedString(42)Yes
eUInt64No
indexed_atDateTime64(3, 'UTC')No
mUInt64No
rewardDecimal(38, 8)No
reward_weiUInt64No
snapshot_timeDateTime64(6, 'UTC')No
sourceLowCardinality(String)No
validatorFixedString(42)Yes
validator_total_delegatedUInt64No
hyperliquid_dex_tradesTrades across Hyperliquid DEX markets.
38 fields and storage details
Sort keys NonePartition None
ColumnTypeSort Key
block_numberUInt64No
block_timeDateTime64(6, 'UTC')No
buyer_addressFixedString(42)No
buyer_builder_addressNullable(FixedString(42))No
buyer_builder_feeNullable(Decimal(38, 18))No
buyer_closed_pnlDecimal(38, 18)No
buyer_crossedUInt8No
buyer_dirLowCardinality(String)No
buyer_feeDecimal(38, 18)No
buyer_order_idUInt64No
buyer_start_positionDecimal(38, 18)No
buyer_twap_idNullable(UInt64)No
coinLowCardinality(String)No
fee_tokenLowCardinality(String)No
indexed_atDateTime64(3, 'UTC')No
liquidated_userNullable(FixedString(42))No
liquidation_mark_priceNullable(Decimal(38, 18))No
liquidation_methodNullable(String)No
market_typeStringNo
priceDecimal(38, 18)No
seller_addressFixedString(42)No
seller_builder_addressNullable(FixedString(42))No
seller_builder_feeNullable(Decimal(38, 18))No
seller_closed_pnlDecimal(38, 18)No
seller_crossedUInt8No
seller_dirLowCardinality(String)No
seller_feeDecimal(38, 18)No
seller_order_idUInt64No
seller_start_positionDecimal(38, 18)No
seller_twap_idNullable(UInt64)No
sideEnum8('B' = 1, 'A' = 2)No
sizeDecimal(38, 18)No
timestampDateTime64(3, 'UTC')No
total_builder_feeNullable(Decimal(38, 18))No
trade_idUInt64No
transaction_hashFixedString(66)No
unique_idStringNo
usd_amountDecimal(38, 18)No
hyperliquid_display_namesUser display names recorded in snapshots.
5 fields and storage details
Sort keys block_number, userPartition toYYYYMM(snapshot_time)
ColumnTypeSort Key
block_numberUInt64Yes
display_nameStringNo
indexed_atDateTime64(3, 'UTC')No
snapshot_timeDateTime64(6, 'UTC')No
userFixedString(42)Yes
hyperliquid_fillsOrder fills with execution details.
28 fields and storage details
Sort keys block_number, tid, userPartition toYYYYMM(block_time)
ColumnTypeSort Key
block_numberUInt64Yes
block_timeDateTime64(6, 'UTC')No
builderNullable(FixedString(42))No
builder_feeNullable(Decimal(38, 18))No
cloidNullable(String)No
closed_pnlDecimal(38, 18)No
coinLowCardinality(String)No
crossedUInt8No
deployer_feeNullable(Decimal(38, 18))No
dirLowCardinality(String)No
feeDecimal(38, 18)No
fee_tokenLowCardinality(String)No
hashFixedString(66)No
indexed_atDateTime64(3, 'UTC')No
is_liquidationUInt8No
liquidated_userNullable(FixedString(42))No
liquidation_mark_priceNullable(Decimal(38, 18))No
liquidation_methodNullable(String)No
oidUInt64No
priceDecimal(38, 18)No
priority_gasNullable(Decimal(38, 18))No
sideEnum8('B' = 1, 'A' = 2)No
sizeDecimal(38, 18)No
start_positionDecimal(38, 18)No
tidUInt64Yes
timeDateTime64(3, 'UTC')No
twap_idNullable(UInt64)No
userFixedString(42)Yes
hyperliquid_fundingFunding rate and payment records.
10 fields and storage details
Sort keys block_number, user, coin, timePartition toYYYYMM(block_time)
ColumnTypeSort Key
block_numberUInt64Yes
block_timeDateTime64(6, 'UTC')No
coinLowCardinality(String)Yes
funding_amountDecimal(38, 18)No
funding_rateDecimal(38, 18)No
hashFixedString(66)No
indexed_atDateTime64(3, 'UTC')No
sziDecimal(38, 18)No
timeDateTime64(6, 'UTC')Yes
userFixedString(42)Yes
hyperliquid_funding_summary_hourlyHourly funding aggregates by market.
5 fields and storage details
Sort keys coin, hourPartition toYYYYMM(hour)
ColumnTypeSort Key
avg_funding_rateSimpleAggregateFunction(any, Float64)No
coinLowCardinality(String)Yes
hourDateTime('UTC')Yes
total_fundingSimpleAggregateFunction(sum, Decimal(38, 18))No
unique_usersSimpleAggregateFunction(max, UInt64)No
hyperliquid_ledger_updatesAccount ledger changes and balance movements.
34 fields and storage details
Sort keys block_number, user, time, hashPartition toYYYYMM(block_time)
ColumnTypeSort Key
account_valueNullable(Decimal(38, 18))No
amountNullable(Decimal(38, 18))No
basisNullable(Decimal(38, 18))No
block_numberUInt64Yes
block_timeDateTime64(6, 'UTC')No
closing_costNullable(Decimal(38, 18))No
commissionNullable(Decimal(38, 18))No
delta_typeLowCardinality(String)No
destinationNullable(FixedString(42))No
destination_dexNullable(String)No
dexNullable(String)No
feeNullable(Decimal(38, 18))No
fee_tokenNullable(String)No
hashFixedString(66)Yes
indexed_atDateTime64(3, 'UTC')No
interest_amountNullable(Decimal(38, 18))No
is_depositNullable(UInt8)No
leverage_typeNullable(String)No
liquidated_ntl_posNullable(Decimal(38, 18))No
liquidated_positionsNullable(String)No
native_token_feeNullable(Decimal(38, 18))No
net_withdrawn_usdNullable(Decimal(38, 18))No
nonceNullable(UInt64)No
operationNullable(String)No
requested_usdNullable(Decimal(38, 18))No
secondary_userNullable(FixedString(42))No
source_dexNullable(String)No
timeDateTime64(6, 'UTC')Yes
to_perpNullable(UInt8)No
tokenNullable(String)No
usdc_amountNullable(Decimal(38, 18))No
usdc_valueNullable(Decimal(38, 18))No
userFixedString(42)Yes
vaultNullable(FixedString(42))No
hyperliquid_liquidations_hourlyHourly liquidation counts and volume.
5 fields and storage details
Sort keys hour, coinPartition toYYYYMM(hour)
ColumnTypeSort Key
coinLowCardinality(String)Yes
hourDateTimeYes
liquidated_volumeSimpleAggregateFunction(sum, Decimal(38, 18))No
liquidation_countSimpleAggregateFunction(sum, UInt64)No
unique_liquidated_usersSimpleAggregateFunction(max, UInt64)No
hyperliquid_market_volume_hourlyHourly market prices and trading volume.
8 fields and storage details
Sort keys coin, hourPartition toYYYYMM(hour)
ColumnTypeSort Key
closeSimpleAggregateFunction(anyLast, Decimal(38, 18))No
coinLowCardinality(String)Yes
highSimpleAggregateFunction(max, Decimal(38, 18))No
hourDateTime('UTC')Yes
lowSimpleAggregateFunction(min, Decimal(38, 18))No
openSimpleAggregateFunction(any, Decimal(38, 18))No
trade_countSimpleAggregateFunction(sum, UInt64)No
volumeSimpleAggregateFunction(sum, Decimal(38, 18))No
hyperliquid_metrics_dex_overviewDaily market activity metrics by DEX.
9 fields and storage details
Sort keys day, coinPartition toYYYYMM(day)
ColumnTypeSort Key
coinLowCardinality(String)Yes
dayDateYes
feesSimpleAggregateFunction(sum, Decimal(38, 18))No
fill_countSimpleAggregateFunction(sum, UInt64)No
high_priceSimpleAggregateFunction(max, Decimal(38, 18))No
liquidationsSimpleAggregateFunction(sum, UInt64)No
low_priceSimpleAggregateFunction(min, Decimal(38, 18))No
unique_tradersSimpleAggregateFunction(max, UInt64)No
volume_usdSimpleAggregateFunction(sum, Decimal(38, 18))No
hyperliquid_metrics_overviewDaily Hyperliquid activity metrics.
10 fields and storage details
Sort keys dayPartition toYYYYMM(day)
ColumnTypeSort Key
active_tradersSimpleAggregateFunction(max, UInt64)No
builder_fill_countSimpleAggregateFunction(sum, UInt64)No
coins_tradedSimpleAggregateFunction(max, UInt64)No
dayDateYes
liquidation_countSimpleAggregateFunction(sum, UInt64)No
liquidation_volume_usdSimpleAggregateFunction(sum, Decimal(38, 18))No
total_builder_feesSimpleAggregateFunction(sum, Decimal(38, 18))No
total_feesSimpleAggregateFunction(sum, Decimal(38, 18))No
total_fillsSimpleAggregateFunction(sum, UInt64)No
total_volume_usdSimpleAggregateFunction(sum, Decimal(38, 18))No
hyperliquid_oracle_pricesOracle price observations by asset.
8 fields and storage details
Sort keys block_number, clearinghouse, asset_idxPartition toYYYYMM(snapshot_time)
ColumnTypeSort Key
asset_idxUInt16Yes
block_numberUInt64Yes
clearinghouseUInt8Yes
coinLowCardinality(String)No
daily_pxStringNo
indexed_atDateTime64(3, 'UTC')No
mark_pxStringNo
snapshot_timeDateTime64(6, 'UTC')No
hyperliquid_order_book_diffsChanges to market order books.
12 fields and storage details
Sort keys coin, side, block_number, oidPartition toYYYYMM(block_time)
ColumnTypeSort Key
block_numberUInt64Yes
block_timeDateTime64(6, 'UTC')No
coinLowCardinality(String)Yes
diff_typeLowCardinality(String)No
indexed_atDateTime64(3, 'UTC')No
new_sizeNullable(Decimal(38, 18))No
oidUInt64Yes
orig_sizeNullable(Decimal(38, 18))No
priceDecimal(38, 18)No
sideEnum8('B' = 1, 'A' = 2)Yes
sizeNullable(Decimal(38, 18))No
userFixedString(42)No
hyperliquid_ordersOrder submissions and updates.
25 fields and storage details
Sort keys block_number, oid, status_timePartition toYYYYMM(block_time)
ColumnTypeSort Key
block_numberUInt64Yes
block_timeDateTime64(6, 'UTC')No
builderNullable(String)No
childrenNullable(String)No
cloidNullable(String)No
coinLowCardinality(String)No
hashNullable(FixedString(66))No
indexed_atDateTime64(3, 'UTC')No
is_position_tpslUInt8No
is_triggerUInt8No
limit_priceDecimal(38, 18)No
oidUInt64Yes
order_timestampDateTime64(3, 'UTC')No
order_typeLowCardinality(String)No
orig_sizeDecimal(38, 18)No
reduce_onlyUInt8No
sideEnum8('B' = 1, 'A' = 2)No
sizeDecimal(38, 18)No
statusLowCardinality(String)No
status_timeDateTime64(6, 'UTC')Yes
tifLowCardinality(String)No
trigger_conditionNullable(String)No
trigger_priceNullable(Decimal(38, 18))No
unique_idStringNo
userFixedString(42)No
hyperliquid_outcome_marketsMarket records for outcome trading.
38 fields and storage details
Sort keys NonePartition None
ColumnTypeSort Key
base_token_idxNullable(UInt64)No
block_numberUInt64No
coinNullable(String)No
descriptionStringNo
expiryStringNo
fee_shareFloat64No
first_enabled_as_quoteStringNo
indexed_atDateTime64(3, 'UTC')No
is_liquid_baseUInt8No
is_liquid_quoteUInt8No
lockedUInt8No
nameLowCardinality(String)No
ndoUInt64No
nouUInt64No
nquUInt64No
outcome_classLowCardinality(String)No
outcome_idUInt64No
pair_nameStringNo
periodLowCardinality(String)No
quote_rawNullable(UInt64)No
quote_token_idxNullable(UInt64)No
quote_token_nameNullable(String)No
quote_token_statusLowCardinality(String)No
quote_token_usdc_pxDecimal(38, 18)No
quote_token_usdc_px_rawUInt64No
raw_side_jsonStringNo
raw_spec_jsonStringNo
side_countUInt16No
side_indexUInt8No
side_nameLowCardinality(String)No
snapshot_timeDateTime64(6, 'UTC')No
spot_deploy_timeStringNo
spot_indexNullable(UInt64)No
spot_resolutionLowCardinality(String)No
target_priceStringNo
token_idxNullable(UInt64)No
token_nameNullable(String)No
underlyingLowCardinality(String)No
hyperliquid_outcome_metaMetadata for outcome trading markets.
20 fields and storage details
Sort keys block_number, outcome_idPartition toYYYYMM(snapshot_time)
ColumnTypeSort Key
block_numberUInt64Yes
deploy_gas_auction_jsonStringNo
descriptionStringNo
expiryStringNo
fee_shareFloat64No
indexed_atDateTime64(3, 'UTC')No
lockedUInt8No
nameLowCardinality(String)No
ndoUInt64No
nouUInt64No
nquUInt64No
outcome_classLowCardinality(String)No
outcome_idUInt64Yes
periodLowCardinality(String)No
quote_rawNullable(UInt64)No
raw_spec_jsonStringNo
side_countUInt16No
snapshot_timeDateTime64(6, 'UTC')No
target_priceStringNo
underlyingLowCardinality(String)No
hyperliquid_outcome_question_membersMembership records linking outcomes to questions.
8 fields and storage details
Sort keys block_number, question_id, outcome_idPartition toYYYYMM(snapshot_time)
ColumnTypeSort Key
block_numberUInt64Yes
indexed_atDateTime64(3, 'UTC')No
is_fallbackUInt8No
is_settledUInt8No
outcome_idUInt64Yes
question_idUInt64Yes
snapshot_timeDateTime64(6, 'UTC')No
sourceLowCardinality(String)No
hyperliquid_outcome_questionsQuestions associated with outcome trading markets.
10 fields and storage details
Sort keys block_number, question_idPartition toYYYYMM(snapshot_time)
ColumnTypeSort Key
block_numberUInt64Yes
descriptionStringNo
fallback_outcomeNullable(UInt64)No
indexed_atDateTime64(3, 'UTC')No
nameStringNo
named_outcomes_jsonStringNo
question_idUInt64Yes
raw_question_jsonStringNo
settled_named_outcomes_jsonStringNo
snapshot_timeDateTime64(6, 'UTC')No
hyperliquid_outcome_sidesSides and tokens in outcome trading markets.
18 fields and storage details
Sort keys block_number, outcome_id, side_indexPartition toYYYYMM(snapshot_time)
ColumnTypeSort Key
base_token_idxNullable(UInt64)No
block_numberUInt64Yes
coinNullable(String)No
indexed_atDateTime64(3, 'UTC')No
outcome_idUInt64Yes
quote_token_idxNullable(UInt64)No
quote_token_nameNullable(String)No
raw_side_jsonStringNo
side_indexUInt8Yes
side_m_rawStringNo
side_m_valueNullable(Int64)No
side_nameLowCardinality(String)No
snapshot_timeDateTime64(6, 'UTC')No
spot_indexNullable(UInt64)No
spot_indices_jsonStringNo
spot_resolutionLowCardinality(String)No
token_idxNullable(UInt64)No
token_nameNullable(String)No
hyperliquid_perpetual_market_contextsCurrent context and statistics for perpetual markets.
13 fields and storage details
Sort keys NonePartition None
ColumnTypeSort Key
coinLowCardinality(String)No
day_base_vlmDecimal(38, 18)No
day_ntl_vlmDecimal(38, 18)No
fundingDecimal(38, 18)No
impact_askNullable(Decimal(38, 18))No
impact_bidNullable(Decimal(38, 18))No
mark_pxDecimal(38, 18)No
mid_pxDecimal(38, 18)No
open_interestDecimal(38, 18)No
oracle_pxDecimal(38, 18)No
polled_atDateTime64(6, 'UTC')No
premiumDecimal(38, 18)No
prev_day_pxDecimal(38, 18)No
hyperliquid_perpetual_marketsPerpetual market definitions and settings.
7 fields and storage details
Sort keys coinPartition None
ColumnTypeSort Key
coinLowCardinality(String)Yes
indexed_atDateTime64(3, 'UTC')No
margin_table_idNullable(UInt16)No
market_indexUInt16No
max_leverageUInt16No
only_isolatedUInt8No
sz_decimalsUInt8No
hyperliquid_perpetual_positionsPerpetual position snapshots by account and asset.
14 fields and storage details
Sort keys block_number, clearinghouse, user, asset_idxPartition toYYYYMM(snapshot_time)
ColumnTypeSort Key
asset_idxUInt16Yes
block_numberUInt64Yes
clearinghouseUInt8Yes
coinStringNo
entry_notionalUInt64No
funding_alltimeInt64No
funding_since_changeInt64No
funding_since_openInt64No
indexed_atDateTime64(3, 'UTC')No
marginUInt64No
sizeInt64No
snapshot_timeDateTime64(6, 'UTC')No
usdc_balanceInt64No
userStringYes
hyperliquid_quote_token_metaMetadata for quote tokens.
10 fields and storage details
Sort keys block_number, token_idxPartition toYYYYMM(snapshot_time)
ColumnTypeSort Key
aligned_quote_info_jsonStringNo
block_numberUInt64Yes
first_enabled_as_quoteStringNo
indexed_atDateTime64(3, 'UTC')No
is_liquid_baseUInt8No
is_liquid_quoteUInt8No
snapshot_timeDateTime64(6, 'UTC')No
statusLowCardinality(String)No
token_idxUInt64Yes
token_nameLowCardinality(String)No
hyperliquid_register_referralReferral registration actions and results.
8 fields and storage details
Sort keys referral_code, userPartition None
ColumnTypeSort Key
block_timeDateTime64(6, 'UTC')No
errorNullable(String)No
indexed_atDateTime64(3, 'UTC')No
is_successUInt8No
referral_codeStringYes
roundUInt64No
tx_hashStringNo
userStringYes
hyperliquid_set_referrerReferrer assignment actions and results.
8 fields and storage details
Sort keys referral_code, userPartition None
ColumnTypeSort Key
block_timeDateTime64(6, 'UTC')No
errorNullable(String)No
indexed_atDateTime64(3, 'UTC')No
is_successUInt8No
referral_codeStringYes
roundUInt64No
tx_hashStringNo
userStringYes
hyperliquid_spot_balancesSpot token balance snapshots by account.
8 fields and storage details
Sort keys block_number, user, token_idxPartition toYYYYMM(snapshot_time)
ColumnTypeSort Key
block_numberUInt64Yes
escrowedInt64No
indexed_atDateTime64(3, 'UTC')No
snapshot_timeDateTime64(6, 'UTC')No
tokenStringNo
token_idxUInt16Yes
totalInt64No
userStringYes
hyperliquid_spot_clearinghouse_statesSpot clearinghouse state snapshots.
8 fields and storage details
Sort keys block_number, user, token_idxPartition toYYYYMM(snapshot_time)
ColumnTypeSort Key
block_numberUInt64Yes
escrowedInt64No
indexed_atDateTime64(3, 'UTC')No
snapshot_timeDateTime64(6, 'UTC')No
tokenLowCardinality(String)No
token_idxUInt16Yes
totalInt64No
userFixedString(42)Yes
hyperliquid_spot_marketsSpot market definitions and settings.
12 fields and storage details
Sort keys token_indexPartition None
ColumnTypeSort Key
deployer_trading_fee_shareNullable(String)No
evm_contractNullable(String)No
full_nameNullable(String)No
indexed_atDateTime64(3, 'UTC')No
is_canonicalUInt8No
pair_indexNullable(UInt16)No
pair_nameNullable(String)No
sz_decimalsUInt8No
tokenLowCardinality(String)No
token_idStringNo
token_indexUInt16Yes
wei_decimalsUInt8No
hyperliquid_spot_pairsSpot trading pair definitions.
11 fields and storage details
Sort keys block_number, spot_indexPartition toYYYYMM(snapshot_time)
ColumnTypeSort Key
base_token_idxUInt64No
base_token_nameLowCardinality(String)No
block_numberUInt64Yes
deploy_timeStringNo
indexed_atDateTime64(3, 'UTC')No
pair_nameStringNo
quote_token_idxUInt64No
quote_token_nameLowCardinality(String)No
raw_spot_info_jsonStringNo
snapshot_timeDateTime64(6, 'UTC')No
spot_indexUInt64Yes
hyperliquid_staking_eventsStaking activity and reward events.
11 fields and storage details
Sort keys block_number, hashPartition toYYYYMM(block_time)
ColumnTypeSort Key
amountDecimal(38, 18)No
block_numberUInt64Yes
block_timeDateTime64(6, 'UTC')No
event_typeEnum8('CDeposit' = 1, 'CWithdrawal' = 2, 'Delegation' = 3)No
hashFixedString(66)Yes
indexed_atDateTime64(3, 'UTC')No
is_finalizedNullable(UInt8)No
is_undelegateNullable(UInt8)No
timeDateTime64(6, 'UTC')No
userFixedString(42)No
validatorNullable(FixedString(42))No
hyperliquid_sub_accountsSub-account relationships and names.
6 fields and storage details
Sort keys block_number, sub_accountPartition toYYYYMM(snapshot_time)
ColumnTypeSort Key
block_numberUInt64Yes
indexed_atDateTime64(3, 'UTC')No
master_accountFixedString(42)No
nameNullable(String)No
snapshot_timeDateTime64(6, 'UTC')No
sub_accountFixedString(42)Yes
hyperliquid_summariesAccount margin and position summaries.
13 fields and storage details
Sort keys user, polled_atPartition toYYYYMM(polled_at)
ColumnTypeSort Key
cross_maintenance_margin_usedDecimal(38, 18)No
cross_margin_account_valueDecimal(38, 18)No
cross_margin_total_margin_usedDecimal(38, 18)No
cross_margin_total_natl_posDecimal(38, 18)No
cross_margin_total_raw_usdDecimal(38, 18)No
indexed_atDateTime64(3, 'UTC')No
margin_account_valueDecimal(38, 18)No
margin_total_margin_usedDecimal(38, 18)No
margin_total_natl_posDecimal(38, 18)No
margin_total_raw_usdDecimal(38, 18)No
polled_atDateTime64(3, 'UTC')Yes
userStringYes
withdrawableDecimal(38, 18)No
hyperliquid_system_actionsSystem actions recorded on HyperCore.
24 fields and storage details
Sort keys block_number, evm_tx_hash, noncePartition toYYYYMM(block_time)
ColumnTypeSort Key
actionStringNo
action_typeLowCardinality(String)No
agent_addressNullable(FixedString(42))No
agent_nameNullable(String)No
block_numberUInt64Yes
block_timeDateTime64(6, 'UTC')No
destinationNullable(FixedString(42))No
destination_dex_or_spotNullable(UInt8)No
evm_tx_hashFixedString(66)Yes
from_sub_accountNullable(UInt8)No
hyperliquid_chainNullable(String)No
indexed_atDateTime64(3, 'UTC')No
is_mintNullable(UInt8)No
is_undelegateNullable(UInt8)No
nonceUInt64Yes
ntlNullable(Decimal(38, 18))No
order_groupingNullable(String)No
signature_chain_idNullable(String)No
source_dex_or_spotNullable(UInt8)No
to_perpNullable(UInt8)No
tokenNullable(UInt16)No
userFixedString(42)No
validatorNullable(FixedString(42))No
weiNullable(UInt256)No
hyperliquid_token_usdc_pricesToken prices expressed in USDC.
9 fields and storage details
Sort keys block_number, token_idxPartition toYYYYMM(snapshot_time)
ColumnTypeSort Key
approx_usdc_pxDecimal(38, 18)No
approx_usdc_px_float_1e6Float64No
approx_usdc_px_rawUInt64No
block_numberUInt64Yes
indexed_atDateTime64(3, 'UTC')No
raw_pair_jsonStringNo
snapshot_timeDateTime64(6, 'UTC')No
token_idxUInt64Yes
token_nameLowCardinality(String)No
hyperliquid_tradesExecuted trades with buyer and seller details.
40 fields and storage details
Sort keys block_number, trade_idPartition toYYYYMM(block_time)
ColumnTypeSort Key
block_numberUInt64Yes
block_timeDateTime64(6, 'UTC')No
buyer_addressFixedString(42)No
buyer_builder_addressNullable(FixedString(42))No
buyer_builder_feeNullable(Decimal(38, 18))No
buyer_closed_pnlDecimal(38, 18)No
buyer_crossedUInt8No
buyer_deployer_feeNullable(Decimal(38, 18))No
buyer_dirLowCardinality(String)No
buyer_feeDecimal(38, 18)No
buyer_order_idUInt64No
buyer_priority_gasNullable(Decimal(38, 18))No
buyer_start_positionDecimal(38, 18)No
buyer_twap_idNullable(UInt64)No
coinLowCardinality(String)No
fee_tokenLowCardinality(String)No
indexed_atDateTime64(3, 'UTC')No
liquidated_userNullable(FixedString(42))No
liquidation_mark_priceNullable(Decimal(38, 18))No
liquidation_methodNullable(String)No
priceDecimal(38, 18)No
seller_addressFixedString(42)No
seller_builder_addressNullable(FixedString(42))No
seller_builder_feeNullable(Decimal(38, 18))No
seller_closed_pnlDecimal(38, 18)No
seller_crossedUInt8No
seller_deployer_feeNullable(Decimal(38, 18))No
seller_dirLowCardinality(String)No
seller_feeDecimal(38, 18)No
seller_order_idUInt64No
seller_priority_gasNullable(Decimal(38, 18))No
seller_start_positionDecimal(38, 18)No
seller_twap_idNullable(UInt64)No
sideEnum8('B' = 1, 'A' = 2)No
sizeDecimal(38, 18)No
timestampDateTime64(3, 'UTC')No
total_builder_feeNullable(Decimal(38, 18))No
trade_idUInt64Yes
transaction_hashFixedString(66)No
unique_idStringNo
hyperliquid_transactionsHyperCore transactions and action results.
12 fields and storage details
Sort keys round, tx_hash, noncePartition toYYYYMM(block_time)
ColumnTypeSort Key
actionJSONNo
action_typeLowCardinality(String)No
block_timeDateTime64(6, 'UTC')No
errorNullable(String)No
indexed_atDateTime64(3, 'UTC')No
is_successUInt8No
nonceUInt64Yes
proposerNullable(String)No
roundUInt64Yes
tx_hashStringYes
userNullable(String)No
vault_addressNullable(String)No
hyperliquid_twap_statusesExecution status for TWAP orders.
16 fields and storage details
Sort keys block_number, twap_id, timePartition toYYYYMM(block_time)
ColumnTypeSort Key
block_numberUInt64Yes
block_timeDateTime64(6, 'UTC')No
coinLowCardinality(String)No
executed_ntlDecimal(38, 18)No
executed_sizeDecimal(38, 18)No
indexed_atDateTime64(3, 'UTC')No
minutesUInt16No
randomizeUInt8No
reduce_onlyUInt8No
sideEnum8('B' = 1, 'A' = 2)No
sizeDecimal(38, 18)No
statusLowCardinality(String)No
timeDateTime64(6, 'UTC')Yes
timestampDateTime64(3, 'UTC')No
twap_idUInt64Yes
userFixedString(42)No
hyperliquid_validator_rewardsRewards recorded for validators.
7 fields and storage details
Sort keys block_number, validator, timePartition toYYYYMM(block_time)
ColumnTypeSort Key
block_numberUInt64Yes
block_timeDateTime64(6, 'UTC')No
hashFixedString(66)No
indexed_atDateTime64(3, 'UTC')No
rewardDecimal(38, 18)No
timeDateTime64(6, 'UTC')Yes
validatorFixedString(42)Yes
hyperliquid_vault_equitiesVault equity snapshots by depositor.
10 fields and storage details
Sort keys block_number, vault_address, depositorPartition toYYYYMM(snapshot_time)
ColumnTypeSort Key
block_numberUInt64Yes
depositorFixedString(42)Yes
indexed_atDateTime64(3, 'UTC')No
leaderFixedString(42)No
leader_commissionFloat64No
net_depositsInt64No
ownership_fractionFloat64No
snapshot_timeDateTime64(6, 'UTC')No
vault_addressFixedString(42)Yes
vault_nameStringNo