अवलोकन
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 |
| नाम | 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 |
|---|---|---|
| मात्रा | 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 |
| n एक | Nullable(UInt64) | No |
| time | DateTime64(6, 'UTC') | No |
| टोकन | 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 |
| n एक | 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 |
| सिक्का | LowCardinality(String) | No |
| बनाया गया_पर | DateTime64(6, 'UTC') | No |
| crossed | UInt8 | No |
| dir | LowCardinality(String) | No |
| fee | Decimal(38, 18) | No |
| हैश | 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 |
| कीमत | Decimal(38, 18) | No |
| ओर | Enum8('B' = 1, 'A' = 2) | No |
| आकार | 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 |
| सिक्का | Nullable(String) | No |
| हैश | 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 |
| सिक्का | 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 |
| आकार | 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 |
| सिक्का | LowCardinality(String) | No |
| शुल्क_टोकन | 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 |
| कीमत | 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 |
| ओर | Enum8('B' = 1, 'A' = 2) | No |
| आकार | 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 |
| सिक्का | LowCardinality(String) | No |
| crossed | UInt8 | No |
| deployer_fee | Nullable(Decimal(38, 18)) | No |
| dir | LowCardinality(String) | No |
| fee | Decimal(38, 18) | No |
| शुल्क_टोकन | LowCardinality(String) | No |
| हैश | 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 |
| कीमत | Decimal(38, 18) | No |
| priority_gas | Nullable(Decimal(38, 18)) | No |
| ओर | Enum8('B' = 1, 'A' = 2) | No |
| आकार | 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 |
| सिक्का | LowCardinality(String) | Yes |
| funding_amount | Decimal(38, 18) | No |
| funding_rate | Decimal(38, 18) | No |
| हैश | 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 |
| सिक्का | 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 |
| मात्रा | 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 |
| शुल्क_टोकन | Nullable(String) | No |
| हैश | 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 |
| n एक | 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 |
| टोकन | 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 |
|---|---|---|
| सिक्का | 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 |
| सिक्का | 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 |
|---|---|---|
| सिक्का | 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 |
| वॉल्यूम_यूएसडी | 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 |
| सिक्का | 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 |
| सिक्का | 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 |
| कीमत | Decimal(38, 18) | No |
| ओर | Enum8('B' = 1, 'A' = 2) | Yes |
| आकार | Nullable(Decimal(38, 18)) | No |
| user | FixedString(42) | No |
हाइपरलिक्विड_ऑर्डर
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 |
| सिक्का | LowCardinality(String) | No |
| हैश | 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 |
| ओर | Enum8('B' = 1, 'A' = 2) | No |
| आकार | Decimal(38, 18) | No |
| स्थिति | 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 |
हाइपरलिक्विड_आउटकम_मार्केट्स
Sort Keys: ⚡ none | Partition: none
| Column | Type | Sort Key |
|---|---|---|
| base_token_idx | Nullable(UInt64) | No |
| block_number | UInt64 | No |
| सिक्का | Nullable(String) | No |
| विवरण | 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 |
| नाम | 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 |
| विवरण | String | No |
| expiry | String | No |
| fee_share | Float64 | No |
| indexed_at | DateTime64(3, 'UTC') | No |
| locked | UInt8 | No |
| नाम | 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 |
| विवरण | String | No |
| fallback_outcome | Nullable(UInt64) | No |
| indexed_at | DateTime64(3, 'UTC') | No |
| नाम | 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 |
| सिक्का | 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 |
|---|---|---|
| सिक्का | 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 |
|---|---|---|
| सिक्का | 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 |
| सिक्का | 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 |
| आकार | 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 |
| स्थिति | 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 |
| गलती | 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 |
| गलती | 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 |
| टोकन | 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 |
| टोकन | 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 |
| पूरा नाम | 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 |
| टोकन | 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 |
|---|---|---|
| मात्रा | Decimal(38, 18) | No |
| block_number | UInt64 | Yes |
| block_time | DateTime64(6, 'UTC') | No |
| event_type | Enum8('CDeposit' = 1, 'CWithdrawal' = 2, 'Delegation' = 3) | No |
| हैश | 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 |
| नाम | 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 |
| n एक | 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 |
| टोकन | 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 |
हाइपरलिक्विड_ट्रेड्स
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 |
| सिक्का | LowCardinality(String) | No |
| शुल्क_टोकन | 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 |
| कीमत | 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 |
| ओर | Enum8('B' = 1, 'A' = 2) | No |
| आकार | 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 |
| गलती | Nullable(String) | No |
| indexed_at | DateTime64(3, 'UTC') | No |
| is_success | UInt8 | No |
| n एक | 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 |
| सिक्का | 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 |
| ओर | Enum8('B' = 1, 'A' = 2) | No |
| आकार | Decimal(38, 18) | No |
| स्थिति | 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 |
| हैश | 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]
हमें आपकी प्रतिक्रिया बहुत पसंद है!
यदि इस दस्तावेज़ के बारे में आपके कोई सुझाव या प्रश्न हैं, तो कृपया हमें बताएं । हमें आपकी प्रतिक्रिया जानकर खुशी होगी!