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.
| Column | Type | Sort Key |
|---|---|---|
agent | FixedString(42) | Yes |
block_number | UInt64 | Yes |
indexed_at | DateTime64(3, 'UTC') | No |
name | String | No |
snapshot_time | DateTime64(6, 'UTC') | No |
user | FixedString(42) | No |
valid_until | String | No |
hyperliquid_asset_transfersAsset transfers recorded on HyperCore.
| Column | Type | Sort Key |
|---|---|---|
amount | Nullable(Decimal(38, 18)) | No |
block_number | UInt64 | Yes |
block_time | DateTime64(6, 'UTC') | No |
destination | Nullable(FixedString(42)) | No |
fee | Nullable(Decimal(38, 18)) | No |
indexed_at | DateTime64(3, 'UTC') | No |
nonce | Nullable(UInt64) | No |
time | DateTime64(6, 'UTC') | No |
token | Nullable(String) | No |
transfer_type | LowCardinality(String) | No |
tx_hash | FixedString(66) | Yes |
usdc_amount | Nullable(Decimal(38, 18)) | No |
user | FixedString(42) | Yes |
hyperliquid_blocksBlock-level HyperCore activity and counts.
| Column | Type | Sort Key |
|---|---|---|
block_number | UInt64 | Yes |
block_time | DateTime64(6, 'UTC') | No |
book_diffs_count | UInt32 | No |
fills_count | UInt32 | No |
indexed_at | DateTime64(3, 'UTC') | No |
misc_events_count | UInt32 | No |
orders_count | UInt32 | No |
twap_statuses_count | UInt32 | No |
writer_actions_count | UInt32 | No |
hyperliquid_bridgeBridge activity between Hyperliquid and Ethereum.
| Column | Type | Sort Key |
|---|---|---|
amount_wei | UInt64 | No |
block_number | UInt64 | Yes |
bridge_type | LowCardinality(String) | Yes |
eth_block_number | UInt64 | Yes |
event_time | String | No |
indexed_at | DateTime64(3, 'UTC') | No |
nonce | UInt64 | Yes |
snapshot_time | DateTime64(6, 'UTC') | No |
tx_hash | String | Yes |
user | FixedString(42) | Yes |
hyperliquid_builder_fillsTrade fills associated with builders.
| Column | Type | Sort Key |
|---|---|---|
block_number | UInt64 | No |
block_time | DateTime64(6, 'UTC') | No |
builder_address | Nullable(FixedString(42)) | Yes |
builder_fee | Nullable(Decimal(38, 18)) | No |
cloid | Nullable(String) | No |
closed_pnl | Decimal(38, 18) | No |
coin | LowCardinality(String) | No |
created_at | DateTime64(6, 'UTC') | No |
crossed | UInt8 | No |
dir | LowCardinality(String) | No |
fee | Decimal(38, 18) | No |
hash | FixedString(66) | No |
indexed_at | DateTime64(3, 'UTC') | No |
is_liquidation | UInt8 | No |
liquidated_user | Nullable(FixedString(42)) | No |
liquidation_mark_price | Nullable(Decimal(38, 18)) | No |
liquidation_method | Nullable(String) | No |
oid | UInt64 | No |
price | Decimal(38, 18) | No |
side | Enum8('B' = 1, 'A' = 2) | No |
size | Decimal(38, 18) | No |
start_position | Decimal(38, 18) | No |
tid | UInt64 | Yes |
timestamp | DateTime64(3, 'UTC') | Yes |
twap_id | Nullable(UInt64) | No |
updated_at | DateTime64(6, 'UTC') | No |
user | FixedString(42) | No |
hyperliquid_builder_transactionsTransactions and fees associated with builders.
| Column | Type | Sort Key |
|---|---|---|
action_type | LowCardinality(String) | No |
block_number | UInt64 | Yes |
block_time | DateTime64(6, 'UTC') | No |
builder | String | No |
builder_fee | Nullable(Decimal(38, 18)) | No |
coin | Nullable(String) | No |
hash | String | Yes |
indexed_at | DateTime64(3, 'UTC') | No |
is_success | UInt8 | No |
user | String | Yes |
hyperliquid_clearinghouse_statesClearinghouse account state snapshots.
| Column | Type | Sort Key |
|---|---|---|
asset_idx | UInt16 | Yes |
block_number | UInt64 | Yes |
clearinghouse | UInt8 | Yes |
coin | LowCardinality(String) | No |
entry_notional | UInt64 | No |
funding_alltime | Int64 | No |
funding_since_change | Int64 | No |
funding_since_open | Int64 | No |
indexed_at | DateTime64(3, 'UTC') | No |
margin | UInt64 | No |
size | Int64 | No |
snapshot_time | DateTime64(6, 'UTC') | No |
usdc_balance | Int64 | No |
user | FixedString(42) | Yes |
hyperliquid_delegator_rewardsRewards recorded for delegators.
| Column | Type | Sort Key |
|---|---|---|
block_number | UInt64 | Yes |
c | UInt64 | No |
commission_bps | UInt16 | No |
delegator | FixedString(42) | Yes |
e | UInt64 | No |
indexed_at | DateTime64(3, 'UTC') | No |
m | UInt64 | No |
reward | Decimal(38, 8) | No |
reward_wei | UInt64 | No |
snapshot_time | DateTime64(6, 'UTC') | No |
source | LowCardinality(String) | No |
validator | FixedString(42) | Yes |
validator_total_delegated | UInt64 | No |
hyperliquid_dex_tradesTrades across Hyperliquid DEX markets.
| Column | Type | Sort Key |
|---|---|---|
block_number | UInt64 | No |
block_time | DateTime64(6, 'UTC') | No |
buyer_address | FixedString(42) | No |
buyer_builder_address | Nullable(FixedString(42)) | No |
buyer_builder_fee | Nullable(Decimal(38, 18)) | No |
buyer_closed_pnl | Decimal(38, 18) | No |
buyer_crossed | UInt8 | No |
buyer_dir | LowCardinality(String) | No |
buyer_fee | Decimal(38, 18) | No |
buyer_order_id | UInt64 | No |
buyer_start_position | Decimal(38, 18) | No |
buyer_twap_id | Nullable(UInt64) | No |
coin | LowCardinality(String) | No |
fee_token | LowCardinality(String) | No |
indexed_at | DateTime64(3, 'UTC') | No |
liquidated_user | Nullable(FixedString(42)) | No |
liquidation_mark_price | Nullable(Decimal(38, 18)) | No |
liquidation_method | Nullable(String) | No |
market_type | String | No |
price | Decimal(38, 18) | No |
seller_address | FixedString(42) | No |
seller_builder_address | Nullable(FixedString(42)) | No |
seller_builder_fee | Nullable(Decimal(38, 18)) | No |
seller_closed_pnl | Decimal(38, 18) | No |
seller_crossed | UInt8 | No |
seller_dir | LowCardinality(String) | No |
seller_fee | Decimal(38, 18) | No |
seller_order_id | UInt64 | No |
seller_start_position | Decimal(38, 18) | No |
seller_twap_id | Nullable(UInt64) | No |
side | Enum8('B' = 1, 'A' = 2) | No |
size | Decimal(38, 18) | No |
timestamp | DateTime64(3, 'UTC') | No |
total_builder_fee | Nullable(Decimal(38, 18)) | No |
trade_id | UInt64 | No |
transaction_hash | FixedString(66) | No |
unique_id | String | No |
usd_amount | Decimal(38, 18) | No |
hyperliquid_display_namesUser display names recorded in snapshots.
| Column | Type | Sort Key |
|---|---|---|
block_number | UInt64 | Yes |
display_name | String | No |
indexed_at | DateTime64(3, 'UTC') | No |
snapshot_time | DateTime64(6, 'UTC') | No |
user | FixedString(42) | Yes |
hyperliquid_fillsOrder fills with execution details.
| Column | Type | Sort Key |
|---|---|---|
block_number | UInt64 | Yes |
block_time | DateTime64(6, 'UTC') | No |
builder | Nullable(FixedString(42)) | No |
builder_fee | Nullable(Decimal(38, 18)) | No |
cloid | Nullable(String) | No |
closed_pnl | Decimal(38, 18) | No |
coin | LowCardinality(String) | No |
crossed | UInt8 | No |
deployer_fee | Nullable(Decimal(38, 18)) | No |
dir | LowCardinality(String) | No |
fee | Decimal(38, 18) | No |
fee_token | LowCardinality(String) | No |
hash | FixedString(66) | No |
indexed_at | DateTime64(3, 'UTC') | No |
is_liquidation | UInt8 | No |
liquidated_user | Nullable(FixedString(42)) | No |
liquidation_mark_price | Nullable(Decimal(38, 18)) | No |
liquidation_method | Nullable(String) | No |
oid | UInt64 | No |
price | Decimal(38, 18) | No |
priority_gas | Nullable(Decimal(38, 18)) | No |
side | Enum8('B' = 1, 'A' = 2) | No |
size | Decimal(38, 18) | No |
start_position | Decimal(38, 18) | No |
tid | UInt64 | Yes |
time | DateTime64(3, 'UTC') | No |
twap_id | Nullable(UInt64) | No |
user | FixedString(42) | Yes |
hyperliquid_fundingFunding rate and payment records.
| Column | Type | Sort Key |
|---|---|---|
block_number | UInt64 | Yes |
block_time | DateTime64(6, 'UTC') | No |
coin | LowCardinality(String) | Yes |
funding_amount | Decimal(38, 18) | No |
funding_rate | Decimal(38, 18) | No |
hash | FixedString(66) | No |
indexed_at | DateTime64(3, 'UTC') | No |
szi | Decimal(38, 18) | No |
time | DateTime64(6, 'UTC') | Yes |
user | FixedString(42) | Yes |
hyperliquid_funding_summary_hourlyHourly funding aggregates by market.
| Column | Type | Sort Key |
|---|---|---|
avg_funding_rate | SimpleAggregateFunction(any, Float64) | No |
coin | LowCardinality(String) | Yes |
hour | DateTime('UTC') | Yes |
total_funding | SimpleAggregateFunction(sum, Decimal(38, 18)) | No |
unique_users | SimpleAggregateFunction(max, UInt64) | No |
hyperliquid_ledger_updatesAccount ledger changes and balance movements.
| Column | Type | Sort Key |
|---|---|---|
account_value | Nullable(Decimal(38, 18)) | No |
amount | Nullable(Decimal(38, 18)) | No |
basis | Nullable(Decimal(38, 18)) | No |
block_number | UInt64 | Yes |
block_time | DateTime64(6, 'UTC') | No |
closing_cost | Nullable(Decimal(38, 18)) | No |
commission | Nullable(Decimal(38, 18)) | No |
delta_type | LowCardinality(String) | No |
destination | Nullable(FixedString(42)) | No |
destination_dex | Nullable(String) | No |
dex | Nullable(String) | No |
fee | Nullable(Decimal(38, 18)) | No |
fee_token | Nullable(String) | No |
hash | FixedString(66) | Yes |
indexed_at | DateTime64(3, 'UTC') | No |
interest_amount | Nullable(Decimal(38, 18)) | No |
is_deposit | Nullable(UInt8) | No |
leverage_type | Nullable(String) | No |
liquidated_ntl_pos | Nullable(Decimal(38, 18)) | No |
liquidated_positions | Nullable(String) | No |
native_token_fee | Nullable(Decimal(38, 18)) | No |
net_withdrawn_usd | Nullable(Decimal(38, 18)) | No |
nonce | Nullable(UInt64) | No |
operation | Nullable(String) | No |
requested_usd | Nullable(Decimal(38, 18)) | No |
secondary_user | Nullable(FixedString(42)) | No |
source_dex | Nullable(String) | No |
time | DateTime64(6, 'UTC') | Yes |
to_perp | Nullable(UInt8) | No |
token | Nullable(String) | No |
usdc_amount | Nullable(Decimal(38, 18)) | No |
usdc_value | Nullable(Decimal(38, 18)) | No |
user | FixedString(42) | Yes |
vault | Nullable(FixedString(42)) | No |
hyperliquid_liquidations_hourlyHourly liquidation counts and volume.
| Column | Type | Sort Key |
|---|---|---|
coin | LowCardinality(String) | Yes |
hour | DateTime | Yes |
liquidated_volume | SimpleAggregateFunction(sum, Decimal(38, 18)) | No |
liquidation_count | SimpleAggregateFunction(sum, UInt64) | No |
unique_liquidated_users | SimpleAggregateFunction(max, UInt64) | No |
hyperliquid_market_volume_hourlyHourly market prices and trading volume.
| Column | Type | Sort Key |
|---|---|---|
close | SimpleAggregateFunction(anyLast, Decimal(38, 18)) | No |
coin | LowCardinality(String) | Yes |
high | SimpleAggregateFunction(max, Decimal(38, 18)) | No |
hour | DateTime('UTC') | Yes |
low | SimpleAggregateFunction(min, Decimal(38, 18)) | No |
open | SimpleAggregateFunction(any, Decimal(38, 18)) | No |
trade_count | SimpleAggregateFunction(sum, UInt64) | No |
volume | SimpleAggregateFunction(sum, Decimal(38, 18)) | No |
hyperliquid_metrics_dex_overviewDaily market activity metrics by DEX.
| Column | Type | Sort Key |
|---|---|---|
coin | LowCardinality(String) | Yes |
day | Date | Yes |
fees | SimpleAggregateFunction(sum, Decimal(38, 18)) | No |
fill_count | SimpleAggregateFunction(sum, UInt64) | No |
high_price | SimpleAggregateFunction(max, Decimal(38, 18)) | No |
liquidations | SimpleAggregateFunction(sum, UInt64) | No |
low_price | SimpleAggregateFunction(min, Decimal(38, 18)) | No |
unique_traders | SimpleAggregateFunction(max, UInt64) | No |
volume_usd | SimpleAggregateFunction(sum, Decimal(38, 18)) | No |
hyperliquid_metrics_overviewDaily Hyperliquid activity metrics.
| Column | Type | Sort Key |
|---|---|---|
active_traders | SimpleAggregateFunction(max, UInt64) | No |
builder_fill_count | SimpleAggregateFunction(sum, UInt64) | No |
coins_traded | SimpleAggregateFunction(max, UInt64) | No |
day | Date | Yes |
liquidation_count | SimpleAggregateFunction(sum, UInt64) | No |
liquidation_volume_usd | SimpleAggregateFunction(sum, Decimal(38, 18)) | No |
total_builder_fees | SimpleAggregateFunction(sum, Decimal(38, 18)) | No |
total_fees | SimpleAggregateFunction(sum, Decimal(38, 18)) | No |
total_fills | SimpleAggregateFunction(sum, UInt64) | No |
total_volume_usd | SimpleAggregateFunction(sum, Decimal(38, 18)) | No |
hyperliquid_oracle_pricesOracle price observations by asset.
| Column | Type | Sort Key |
|---|---|---|
asset_idx | UInt16 | Yes |
block_number | UInt64 | Yes |
clearinghouse | UInt8 | Yes |
coin | LowCardinality(String) | No |
daily_px | String | No |
indexed_at | DateTime64(3, 'UTC') | No |
mark_px | String | No |
snapshot_time | DateTime64(6, 'UTC') | No |
hyperliquid_order_book_diffsChanges to market order books.
| Column | Type | Sort Key |
|---|---|---|
block_number | UInt64 | Yes |
block_time | DateTime64(6, 'UTC') | No |
coin | LowCardinality(String) | Yes |
diff_type | LowCardinality(String) | No |
indexed_at | DateTime64(3, 'UTC') | No |
new_size | Nullable(Decimal(38, 18)) | No |
oid | UInt64 | Yes |
orig_size | Nullable(Decimal(38, 18)) | No |
price | Decimal(38, 18) | No |
side | Enum8('B' = 1, 'A' = 2) | Yes |
size | Nullable(Decimal(38, 18)) | No |
user | FixedString(42) | No |
hyperliquid_ordersOrder submissions and updates.
| Column | Type | Sort Key |
|---|---|---|
block_number | UInt64 | Yes |
block_time | DateTime64(6, 'UTC') | No |
builder | Nullable(String) | No |
children | Nullable(String) | No |
cloid | Nullable(String) | No |
coin | LowCardinality(String) | No |
hash | Nullable(FixedString(66)) | No |
indexed_at | DateTime64(3, 'UTC') | No |
is_position_tpsl | UInt8 | No |
is_trigger | UInt8 | No |
limit_price | Decimal(38, 18) | No |
oid | UInt64 | Yes |
order_timestamp | DateTime64(3, 'UTC') | No |
order_type | LowCardinality(String) | No |
orig_size | Decimal(38, 18) | No |
reduce_only | UInt8 | No |
side | Enum8('B' = 1, 'A' = 2) | No |
size | Decimal(38, 18) | No |
status | LowCardinality(String) | No |
status_time | DateTime64(6, 'UTC') | Yes |
tif | LowCardinality(String) | No |
trigger_condition | Nullable(String) | No |
trigger_price | Nullable(Decimal(38, 18)) | No |
unique_id | String | No |
user | FixedString(42) | No |
hyperliquid_outcome_marketsMarket records for outcome trading.
| Column | Type | Sort Key |
|---|---|---|
base_token_idx | Nullable(UInt64) | No |
block_number | UInt64 | No |
coin | Nullable(String) | No |
description | String | No |
expiry | String | No |
fee_share | Float64 | No |
first_enabled_as_quote | String | No |
indexed_at | DateTime64(3, 'UTC') | No |
is_liquid_base | UInt8 | No |
is_liquid_quote | UInt8 | No |
locked | UInt8 | No |
name | LowCardinality(String) | No |
ndo | UInt64 | No |
nou | UInt64 | No |
nqu | UInt64 | No |
outcome_class | LowCardinality(String) | No |
outcome_id | UInt64 | No |
pair_name | String | No |
period | LowCardinality(String) | No |
quote_raw | Nullable(UInt64) | No |
quote_token_idx | Nullable(UInt64) | No |
quote_token_name | Nullable(String) | No |
quote_token_status | LowCardinality(String) | No |
quote_token_usdc_px | Decimal(38, 18) | No |
quote_token_usdc_px_raw | UInt64 | No |
raw_side_json | String | No |
raw_spec_json | String | No |
side_count | UInt16 | No |
side_index | UInt8 | No |
side_name | LowCardinality(String) | No |
snapshot_time | DateTime64(6, 'UTC') | No |
spot_deploy_time | String | No |
spot_index | Nullable(UInt64) | No |
spot_resolution | LowCardinality(String) | No |
target_price | String | No |
token_idx | Nullable(UInt64) | No |
token_name | Nullable(String) | No |
underlying | LowCardinality(String) | No |
hyperliquid_outcome_metaMetadata for outcome trading markets.
| Column | Type | Sort Key |
|---|---|---|
block_number | UInt64 | Yes |
deploy_gas_auction_json | String | No |
description | String | No |
expiry | String | No |
fee_share | Float64 | No |
indexed_at | DateTime64(3, 'UTC') | No |
locked | UInt8 | No |
name | LowCardinality(String) | No |
ndo | UInt64 | No |
nou | UInt64 | No |
nqu | UInt64 | No |
outcome_class | LowCardinality(String) | No |
outcome_id | UInt64 | Yes |
period | LowCardinality(String) | No |
quote_raw | Nullable(UInt64) | No |
raw_spec_json | String | No |
side_count | UInt16 | No |
snapshot_time | DateTime64(6, 'UTC') | No |
target_price | String | No |
underlying | LowCardinality(String) | No |
hyperliquid_outcome_question_membersMembership records linking outcomes to questions.
| Column | Type | Sort Key |
|---|---|---|
block_number | UInt64 | Yes |
indexed_at | DateTime64(3, 'UTC') | No |
is_fallback | UInt8 | No |
is_settled | UInt8 | No |
outcome_id | UInt64 | Yes |
question_id | UInt64 | Yes |
snapshot_time | DateTime64(6, 'UTC') | No |
source | LowCardinality(String) | No |
hyperliquid_outcome_questionsQuestions associated with outcome trading markets.
| Column | Type | Sort Key |
|---|---|---|
block_number | UInt64 | Yes |
description | String | No |
fallback_outcome | Nullable(UInt64) | No |
indexed_at | DateTime64(3, 'UTC') | No |
name | String | No |
named_outcomes_json | String | No |
question_id | UInt64 | Yes |
raw_question_json | String | No |
settled_named_outcomes_json | String | No |
snapshot_time | DateTime64(6, 'UTC') | No |
hyperliquid_outcome_sidesSides and tokens in outcome trading markets.
| Column | Type | Sort Key |
|---|---|---|
base_token_idx | Nullable(UInt64) | No |
block_number | UInt64 | Yes |
coin | Nullable(String) | No |
indexed_at | DateTime64(3, 'UTC') | No |
outcome_id | UInt64 | Yes |
quote_token_idx | Nullable(UInt64) | No |
quote_token_name | Nullable(String) | No |
raw_side_json | String | No |
side_index | UInt8 | Yes |
side_m_raw | String | No |
side_m_value | Nullable(Int64) | No |
side_name | LowCardinality(String) | No |
snapshot_time | DateTime64(6, 'UTC') | No |
spot_index | Nullable(UInt64) | No |
spot_indices_json | String | No |
spot_resolution | LowCardinality(String) | No |
token_idx | Nullable(UInt64) | No |
token_name | Nullable(String) | No |
hyperliquid_perpetual_market_contextsCurrent context and statistics for perpetual markets.
| Column | Type | Sort Key |
|---|---|---|
coin | LowCardinality(String) | No |
day_base_vlm | Decimal(38, 18) | No |
day_ntl_vlm | Decimal(38, 18) | No |
funding | Decimal(38, 18) | No |
impact_ask | Nullable(Decimal(38, 18)) | No |
impact_bid | Nullable(Decimal(38, 18)) | No |
mark_px | Decimal(38, 18) | No |
mid_px | Decimal(38, 18) | No |
open_interest | Decimal(38, 18) | No |
oracle_px | Decimal(38, 18) | No |
polled_at | DateTime64(6, 'UTC') | No |
premium | Decimal(38, 18) | No |
prev_day_px | Decimal(38, 18) | No |
hyperliquid_perpetual_marketsPerpetual market definitions and settings.
| Column | Type | Sort Key |
|---|---|---|
coin | LowCardinality(String) | Yes |
indexed_at | DateTime64(3, 'UTC') | No |
margin_table_id | Nullable(UInt16) | No |
market_index | UInt16 | No |
max_leverage | UInt16 | No |
only_isolated | UInt8 | No |
sz_decimals | UInt8 | No |
hyperliquid_perpetual_positionsPerpetual position snapshots by account and asset.
| Column | Type | Sort Key |
|---|---|---|
asset_idx | UInt16 | Yes |
block_number | UInt64 | Yes |
clearinghouse | UInt8 | Yes |
coin | String | No |
entry_notional | UInt64 | No |
funding_alltime | Int64 | No |
funding_since_change | Int64 | No |
funding_since_open | Int64 | No |
indexed_at | DateTime64(3, 'UTC') | No |
margin | UInt64 | No |
size | Int64 | No |
snapshot_time | DateTime64(6, 'UTC') | No |
usdc_balance | Int64 | No |
user | String | Yes |
hyperliquid_quote_token_metaMetadata for quote tokens.
| Column | Type | Sort Key |
|---|---|---|
aligned_quote_info_json | String | No |
block_number | UInt64 | Yes |
first_enabled_as_quote | String | No |
indexed_at | DateTime64(3, 'UTC') | No |
is_liquid_base | UInt8 | No |
is_liquid_quote | UInt8 | No |
snapshot_time | DateTime64(6, 'UTC') | No |
status | LowCardinality(String) | No |
token_idx | UInt64 | Yes |
token_name | LowCardinality(String) | No |
hyperliquid_register_referralReferral registration actions and results.
| Column | Type | Sort Key |
|---|---|---|
block_time | DateTime64(6, 'UTC') | No |
error | Nullable(String) | No |
indexed_at | DateTime64(3, 'UTC') | No |
is_success | UInt8 | No |
referral_code | String | Yes |
round | UInt64 | No |
tx_hash | String | No |
user | String | Yes |
hyperliquid_set_referrerReferrer assignment actions and results.
| Column | Type | Sort Key |
|---|---|---|
block_time | DateTime64(6, 'UTC') | No |
error | Nullable(String) | No |
indexed_at | DateTime64(3, 'UTC') | No |
is_success | UInt8 | No |
referral_code | String | Yes |
round | UInt64 | No |
tx_hash | String | No |
user | String | Yes |
hyperliquid_spot_balancesSpot token balance snapshots by account.
| Column | Type | Sort Key |
|---|---|---|
block_number | UInt64 | Yes |
escrowed | Int64 | No |
indexed_at | DateTime64(3, 'UTC') | No |
snapshot_time | DateTime64(6, 'UTC') | No |
token | String | No |
token_idx | UInt16 | Yes |
total | Int64 | No |
user | String | Yes |
hyperliquid_spot_clearinghouse_statesSpot clearinghouse state snapshots.
| Column | Type | Sort Key |
|---|---|---|
block_number | UInt64 | Yes |
escrowed | Int64 | No |
indexed_at | DateTime64(3, 'UTC') | No |
snapshot_time | DateTime64(6, 'UTC') | No |
token | LowCardinality(String) | No |
token_idx | UInt16 | Yes |
total | Int64 | No |
user | FixedString(42) | Yes |
hyperliquid_spot_marketsSpot market definitions and settings.
| Column | Type | Sort Key |
|---|---|---|
deployer_trading_fee_share | Nullable(String) | No |
evm_contract | Nullable(String) | No |
full_name | Nullable(String) | No |
indexed_at | DateTime64(3, 'UTC') | No |
is_canonical | UInt8 | No |
pair_index | Nullable(UInt16) | No |
pair_name | Nullable(String) | No |
sz_decimals | UInt8 | No |
token | LowCardinality(String) | No |
token_id | String | No |
token_index | UInt16 | Yes |
wei_decimals | UInt8 | No |
hyperliquid_spot_pairsSpot trading pair definitions.
| Column | Type | Sort Key |
|---|---|---|
base_token_idx | UInt64 | No |
base_token_name | LowCardinality(String) | No |
block_number | UInt64 | Yes |
deploy_time | String | No |
indexed_at | DateTime64(3, 'UTC') | No |
pair_name | String | No |
quote_token_idx | UInt64 | No |
quote_token_name | LowCardinality(String) | No |
raw_spot_info_json | String | No |
snapshot_time | DateTime64(6, 'UTC') | No |
spot_index | UInt64 | Yes |
hyperliquid_staking_eventsStaking activity and reward events.
| Column | Type | Sort Key |
|---|---|---|
amount | Decimal(38, 18) | No |
block_number | UInt64 | Yes |
block_time | DateTime64(6, 'UTC') | No |
event_type | Enum8('CDeposit' = 1, 'CWithdrawal' = 2, 'Delegation' = 3) | No |
hash | FixedString(66) | Yes |
indexed_at | DateTime64(3, 'UTC') | No |
is_finalized | Nullable(UInt8) | No |
is_undelegate | Nullable(UInt8) | No |
time | DateTime64(6, 'UTC') | No |
user | FixedString(42) | No |
validator | Nullable(FixedString(42)) | No |
hyperliquid_sub_accountsSub-account relationships and names.
| Column | Type | Sort Key |
|---|---|---|
block_number | UInt64 | Yes |
indexed_at | DateTime64(3, 'UTC') | No |
master_account | FixedString(42) | No |
name | Nullable(String) | No |
snapshot_time | DateTime64(6, 'UTC') | No |
sub_account | FixedString(42) | Yes |
hyperliquid_summariesAccount margin and position summaries.
| Column | Type | Sort Key |
|---|---|---|
cross_maintenance_margin_used | Decimal(38, 18) | No |
cross_margin_account_value | Decimal(38, 18) | No |
cross_margin_total_margin_used | Decimal(38, 18) | No |
cross_margin_total_natl_pos | Decimal(38, 18) | No |
cross_margin_total_raw_usd | Decimal(38, 18) | No |
indexed_at | DateTime64(3, 'UTC') | No |
margin_account_value | Decimal(38, 18) | No |
margin_total_margin_used | Decimal(38, 18) | No |
margin_total_natl_pos | Decimal(38, 18) | No |
margin_total_raw_usd | Decimal(38, 18) | No |
polled_at | DateTime64(3, 'UTC') | Yes |
user | String | Yes |
withdrawable | Decimal(38, 18) | No |
hyperliquid_system_actionsSystem actions recorded on HyperCore.
| Column | Type | Sort Key |
|---|---|---|
action | String | No |
action_type | LowCardinality(String) | No |
agent_address | Nullable(FixedString(42)) | No |
agent_name | Nullable(String) | No |
block_number | UInt64 | Yes |
block_time | DateTime64(6, 'UTC') | No |
destination | Nullable(FixedString(42)) | No |
destination_dex_or_spot | Nullable(UInt8) | No |
evm_tx_hash | FixedString(66) | Yes |
from_sub_account | Nullable(UInt8) | No |
hyperliquid_chain | Nullable(String) | No |
indexed_at | DateTime64(3, 'UTC') | No |
is_mint | Nullable(UInt8) | No |
is_undelegate | Nullable(UInt8) | No |
nonce | UInt64 | Yes |
ntl | Nullable(Decimal(38, 18)) | No |
order_grouping | Nullable(String) | No |
signature_chain_id | Nullable(String) | No |
source_dex_or_spot | Nullable(UInt8) | No |
to_perp | Nullable(UInt8) | No |
token | Nullable(UInt16) | No |
user | FixedString(42) | No |
validator | Nullable(FixedString(42)) | No |
wei | Nullable(UInt256) | No |
hyperliquid_token_usdc_pricesToken prices expressed in USDC.
| Column | Type | Sort Key |
|---|---|---|
approx_usdc_px | Decimal(38, 18) | No |
approx_usdc_px_float_1e6 | Float64 | No |
approx_usdc_px_raw | UInt64 | No |
block_number | UInt64 | Yes |
indexed_at | DateTime64(3, 'UTC') | No |
raw_pair_json | String | No |
snapshot_time | DateTime64(6, 'UTC') | No |
token_idx | UInt64 | Yes |
token_name | LowCardinality(String) | No |
hyperliquid_tradesExecuted trades with buyer and seller details.
| Column | Type | Sort Key |
|---|---|---|
block_number | UInt64 | Yes |
block_time | DateTime64(6, 'UTC') | No |
buyer_address | FixedString(42) | No |
buyer_builder_address | Nullable(FixedString(42)) | No |
buyer_builder_fee | Nullable(Decimal(38, 18)) | No |
buyer_closed_pnl | Decimal(38, 18) | No |
buyer_crossed | UInt8 | No |
buyer_deployer_fee | Nullable(Decimal(38, 18)) | No |
buyer_dir | LowCardinality(String) | No |
buyer_fee | Decimal(38, 18) | No |
buyer_order_id | UInt64 | No |
buyer_priority_gas | Nullable(Decimal(38, 18)) | No |
buyer_start_position | Decimal(38, 18) | No |
buyer_twap_id | Nullable(UInt64) | No |
coin | LowCardinality(String) | No |
fee_token | LowCardinality(String) | No |
indexed_at | DateTime64(3, 'UTC') | No |
liquidated_user | Nullable(FixedString(42)) | No |
liquidation_mark_price | Nullable(Decimal(38, 18)) | No |
liquidation_method | Nullable(String) | No |
price | Decimal(38, 18) | No |
seller_address | FixedString(42) | No |
seller_builder_address | Nullable(FixedString(42)) | No |
seller_builder_fee | Nullable(Decimal(38, 18)) | No |
seller_closed_pnl | Decimal(38, 18) | No |
seller_crossed | UInt8 | No |
seller_deployer_fee | Nullable(Decimal(38, 18)) | No |
seller_dir | LowCardinality(String) | No |
seller_fee | Decimal(38, 18) | No |
seller_order_id | UInt64 | No |
seller_priority_gas | Nullable(Decimal(38, 18)) | No |
seller_start_position | Decimal(38, 18) | No |
seller_twap_id | Nullable(UInt64) | No |
side | Enum8('B' = 1, 'A' = 2) | No |
size | Decimal(38, 18) | No |
timestamp | DateTime64(3, 'UTC') | No |
total_builder_fee | Nullable(Decimal(38, 18)) | No |
trade_id | UInt64 | Yes |
transaction_hash | FixedString(66) | No |
unique_id | String | No |
hyperliquid_transactionsHyperCore transactions and action results.
| Column | Type | Sort Key |
|---|---|---|
action | JSON | No |
action_type | LowCardinality(String) | No |
block_time | DateTime64(6, 'UTC') | No |
error | Nullable(String) | No |
indexed_at | DateTime64(3, 'UTC') | No |
is_success | UInt8 | No |
nonce | UInt64 | Yes |
proposer | Nullable(String) | No |
round | UInt64 | Yes |
tx_hash | String | Yes |
user | Nullable(String) | No |
vault_address | Nullable(String) | No |
hyperliquid_twap_statusesExecution status for TWAP orders.
| Column | Type | Sort Key |
|---|---|---|
block_number | UInt64 | Yes |
block_time | DateTime64(6, 'UTC') | No |
coin | LowCardinality(String) | No |
executed_ntl | Decimal(38, 18) | No |
executed_size | Decimal(38, 18) | No |
indexed_at | DateTime64(3, 'UTC') | No |
minutes | UInt16 | No |
randomize | UInt8 | No |
reduce_only | UInt8 | No |
side | Enum8('B' = 1, 'A' = 2) | No |
size | Decimal(38, 18) | No |
status | LowCardinality(String) | No |
time | DateTime64(6, 'UTC') | Yes |
timestamp | DateTime64(3, 'UTC') | No |
twap_id | UInt64 | Yes |
user | FixedString(42) | No |
hyperliquid_validator_rewardsRewards recorded for validators.
| Column | Type | Sort Key |
|---|---|---|
block_number | UInt64 | Yes |
block_time | DateTime64(6, 'UTC') | No |
hash | FixedString(66) | No |
indexed_at | DateTime64(3, 'UTC') | No |
reward | Decimal(38, 18) | No |
time | DateTime64(6, 'UTC') | Yes |
validator | FixedString(42) | Yes |
hyperliquid_vault_equitiesVault equity snapshots by depositor.
| Column | Type | Sort Key |
|---|---|---|
block_number | UInt64 | Yes |
depositor | FixedString(42) | Yes |
indexed_at | DateTime64(3, 'UTC') | No |
leader | FixedString(42) | No |
leader_commission | Float64 | No |
net_deposits | Int64 | No |
ownership_fraction | Float64 | No |
snapshot_time | DateTime64(6, 'UTC') | No |
vault_address | FixedString(42) | Yes |
vault_name | String | No |