Overview
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) | 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_transfers
Sort Keys: ⚡ block_number, tx_hash, user | Partition: toYYYYMM(block_time)
| 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_blocks
Sort Keys: ⚡ block_number | Partition: toYYYYMM(block_time)
| 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_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 | 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_fills
Sort Keys: ⚡ builder_address, timestamp, tid | Partition: toYYYYMM(block_time)
| 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_transactions
Sort Keys: ⚡ block_number, hash, user | Partition: toYYYYMM(block_time)
| 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_states
Sort Keys: ⚡ block_number, clearinghouse, user, asset_idx | Partition: toYYYYMM(snapshot_time)
| 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_rewards
Sort Keys: ⚡ block_number, validator, delegator | Partition: toYYYYMM(snapshot_time)
| 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_trades
Sort Keys: ⚡ none | Partition: none
| 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_names
Sort Keys: ⚡ block_number, user | Partition: toYYYYMM(snapshot_time)
| 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_fills
Sort Keys: ⚡ block_number, tid, user | Partition: toYYYYMM(block_time)
| 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_funding
Sort Keys: ⚡ block_number, user, coin, time | Partition: toYYYYMM(block_time)
| 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_hourly
Sort Keys: ⚡ coin, hour | Partition: toYYYYMM(hour)
| 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_updates
Sort Keys: ⚡ block_number, user, time, hash | Partition: toYYYYMM(block_time)
| 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_hourly
Sort Keys: ⚡ hour, coin | Partition: toYYYYMM(hour)
| 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_hourly
Sort Keys: ⚡ coin, hour | Partition: toYYYYMM(hour)
| 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_overview
Sort Keys: ⚡ day, coin | Partition: toYYYYMM(day)
| 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_overview
Sort Keys: ⚡ day | Partition: toYYYYMM(day)
| 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_prices
Sort Keys: ⚡ block_number, clearinghouse, asset_idx | Partition: toYYYYMM(snapshot_time)
| 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_diffs
Sort Keys: ⚡ coin, side, block_number, oid | Partition: toYYYYMM(block_time)
| 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_orders
Sort Keys: ⚡ block_number, oid, status_time | Partition: toYYYYMM(block_time)
| 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_markets
Sort Keys: ⚡ none | Partition: none
| 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_meta
Sort Keys: ⚡ block_number, outcome_id | Partition: toYYYYMM(snapshot_time)
| 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_members
Sort Keys: ⚡ block_number, question_id, outcome_id | Partition: toYYYYMM(snapshot_time)
| 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_questions
Sort Keys: ⚡ block_number, question_id | Partition: toYYYYMM(snapshot_time)
| 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_sides
Sort Keys: ⚡ block_number, outcome_id, side_index | Partition: toYYYYMM(snapshot_time)
| 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_contexts
Sort Keys: ⚡ none | Partition: none
| 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_markets
Sort Keys: ⚡ coin | Partition: none
| 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_positions
Sort Keys: ⚡ block_number, clearinghouse, user, asset_idx | Partition: toYYYYMM(snapshot_time)
| 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_meta
Sort Keys: ⚡ block_number, token_idx | Partition: toYYYYMM(snapshot_time)
| 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_referral
Sort Keys: ⚡ referral_code, user | Partition: none
| 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_referrer
Sort Keys: ⚡ referral_code, user | Partition: none
| 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_balances
Sort Keys: ⚡ block_number, user, token_idx | Partition: toYYYYMM(snapshot_time)
| 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_states
Sort Keys: ⚡ block_number, user, token_idx | Partition: toYYYYMM(snapshot_time)
| 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_markets
Sort Keys: ⚡ token_index | Partition: none
| 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_pairs
Sort Keys: ⚡ block_number, spot_index | Partition: toYYYYMM(snapshot_time)
| 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_events
Sort Keys: ⚡ block_number, hash | Partition: toYYYYMM(block_time)
| 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_accounts
Sort Keys: ⚡ block_number, sub_account | Partition: toYYYYMM(snapshot_time)
| 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_summaries
Sort Keys: ⚡ user, polled_at | Partition: toYYYYMM(polled_at)
| 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_actions
Sort Keys: ⚡ block_number, evm_tx_hash, nonce | Partition: toYYYYMM(block_time)
| 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_prices
Sort Keys: ⚡ block_number, token_idx | Partition: toYYYYMM(snapshot_time)
| 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_trades
Sort Keys: ⚡ block_number, trade_id | Partition: toYYYYMM(block_time)
| 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_transactions
Sort Keys: ⚡ round, tx_hash, nonce | Partition: toYYYYMM(block_time)
| 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_statuses
Sort Keys: ⚡ block_number, twap_id, time | Partition: toYYYYMM(block_time)
| 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_rewards
Sort Keys: ⚡ block_number, validator, time | Partition: toYYYYMM(block_time)
| 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_equities
Sort Keys: ⚡ block_number, vault_address, depositor | Partition: toYYYYMM(snapshot_time)
| 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 |
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"
Replace hyperliquid-core-mainnet with the appropriate cluster ID for other supported chains.
Example Response:
[
{
"chain": "Hyperliquid (HyperCore)",
"clusterId": "hyperliquid-core-mainnet",
"tables": [
{
"name": "hyperliquid_agents",
"engine": "SharedReplacingMergeTree",
"totalRows": 55686595,
"sortingKey": ["block_number", "agent"],
"partitionKey": "toYYYYMM(snapshot_time)",
"columns": [
{
"name": "block_number",
"type": "UInt64"
},
{
"name": "snapshot_time",
"type": "DateTime64(6, 'UTC')"
},
{
"name": "agent",
"type": "FixedString(42)"
}
// ... more columns
]
}
// ... more tables
]
}
]
The response includes table names, engines, column names and data types, sort keys for optimization, partition strategies, and current row counts.
For AI Agents & LLMs
This schema is specifically formatted for programmatic consumption.
Quicknode Skill
For AI agents and LLM applications, install the Quicknode Skill to give your agent full knowledge of SQL Explorer and all Quicknode products:
npx skills add quiknode-labs/blockchain-skills
Using Schema in Your Agent
When building custom AI agents or LLM applications:
- Fetch the schema via the API endpoint above or download the plain text schema optimized for LLM context windows
- Include it in your prompt context when generating SQL queries
- Reference sort keys for optimal query performance
- Use partition keys to limit data scans
Example prompts for AI agents:
Example 1: Generate a SQL query to find the top 10 traders by volume in the last 24 hours.
Schema: [include JSON from schema API or plain text schema file]
Example 2: Create a query to analyze funding rate changes for the BTC perpetual market over the past week, grouped by hour.
Schema: [include JSON from schema API or plain text schema file]
Example 3: Write a SQL query to identify liquidation events larger than $100K in the last 30 days, showing the user, asset, and liquidation size.
Schema: [include JSON from schema API or plain text schema file]
We ❤️ Feedback!
If you have any feedback or questions about this documentation, let us know. We'd love to hear from you!