概要
This page provides a complete schema reference for all tables available in SQL Explorer. Each table includes column names, data types, sort keys, and partition strategies.
Hyperliquid (HyperCore)
SQL Explorer provides comprehensive coverage of Hyperliquid HyperCore with billions of rows of indexed data across multiple tables.
Cluster ID: hyperliquid-core-mainnet
Use this cluster ID when making API requests to query Hyperliquid data via the REST API.
How to Use This Reference
- Sort Keys (⚡): Columns marked as sort keys are indexed for fast queries. Include these in WHERE clauses for best performance.
- Partition Strategy: Tables are partitioned by time (usually
toYYYYMM(block_time)). Filter on time ranges to scan fewer partitions. - Column Types: Data types are shown exactly as stored (e.g.,
UInt64,Decimal(38, 18),DateTime64(6, 'UTC')).
▶ Complete Schema for All Tables (Click to expand)
Detailed schema for all Hyperliquid tables including column names, data types, sort keys (⚡), and partition strategies.
hyperliquid_agents
Sort Keys: ⚡ block_number, agent | Partition: toYYYYMM(snapshot_time)
| Column | 種類 | Sort Key |
|---|---|---|
| agent | FixedString(42) | はい |
| block_number | UInt64 | はい |
| indexed_at | DateTime64(3, 'UTC') | いいえ |
| 名前 | String | いいえ |
| snapshot_time | DateTime64(6, 'UTC') | いいえ |
| user | FixedString(42) | いいえ |
| valid_until | String | いいえ |
hyperliquid_asset_transfers
Sort Keys: ⚡ block_number, tx_hash, user | Partition: toYYYYMM(block_time)
| Column | 種類 | Sort Key |
|---|---|---|
| 金額 | Nullable(Decimal(38, 18)) | いいえ |
| block_number | UInt64 | はい |
| block_time | DateTime64(6, 'UTC') | いいえ |
| destination | Nullable(FixedString(42)) | いいえ |
| 手数料 | Nullable(Decimal(38, 18)) | いいえ |
| indexed_at | DateTime64(3, 'UTC') | いいえ |
| nonce | Nullable(UInt64) | いいえ |
| 時間 | DateTime64(6, 'UTC') | いいえ |
| token | Nullable(String) | いいえ |
| transfer_type | LowCardinality(String) | いいえ |
| tx_hash | FixedString(66) | はい |
| usdc_amount | Nullable(Decimal(38, 18)) | いいえ |
| user | FixedString(42) | はい |
hyperliquid_blocks
Sort Keys: ⚡ block_number | Partition: toYYYYMM(block_time)
| Column | 種類 | Sort Key |
|---|---|---|
| block_number | UInt64 | はい |
| block_time | DateTime64(6, 'UTC') | いいえ |
| book_diffs_count | UInt32 | いいえ |
| fills_count | UInt32 | いいえ |
| indexed_at | DateTime64(3, 'UTC') | いいえ |
| misc_events_count | UInt32 | いいえ |
| orders_count | UInt32 | いいえ |
| twap_statuses_count | UInt32 | いいえ |
| writer_actions_count | UInt32 | いいえ |
hyperliquid_bridge
Sort Keys: ⚡ block_number, bridge_type, user, nonce, eth_block_number, tx_hash | Partition: toYYYYMM(snapshot_time)
| Column | 種類 | Sort Key |
|---|---|---|
| amount_wei | UInt64 | いいえ |
| block_number | UInt64 | はい |
| bridge_type | LowCardinality(String) | はい |
| eth_block_number | UInt64 | はい |
| event_time | String | いいえ |
| indexed_at | DateTime64(3, 'UTC') | いいえ |
| nonce | UInt64 | はい |
| snapshot_time | DateTime64(6, 'UTC') | いいえ |
| tx_hash | String | はい |
| user | FixedString(42) | はい |
hyperliquid_builder_fills
Sort Keys: ⚡ builder_address, timestamp, tid | Partition: toYYYYMM(block_time)
| Column | 種類 | Sort Key |
|---|---|---|
| block_number | UInt64 | いいえ |
| block_time | DateTime64(6, 'UTC') | いいえ |
| builder_address | Nullable(FixedString(42)) | はい |
| builder_fee | Nullable(Decimal(38, 18)) | いいえ |
| cloid | Nullable(String) | いいえ |
| closed_pnl | Decimal(38, 18) | いいえ |
| コイン | LowCardinality(String) | いいえ |
| created_at | DateTime64(6, 'UTC') | いいえ |
| crossed | UInt8 | いいえ |
| dir | LowCardinality(String) | いいえ |
| 手数料 | Decimal(38, 18) | いいえ |
| ハッシュ | FixedString(66) | いいえ |
| indexed_at | DateTime64(3, 'UTC') | いいえ |
| is_liquidation | UInt8 | いいえ |
| liquidated_user | Nullable(FixedString(42)) | いいえ |
| liquidation_mark_price | Nullable(Decimal(38, 18)) | いいえ |
| liquidation_method | Nullable(String) | いいえ |
| oid | UInt64 | いいえ |
| price | Decimal(38, 18) | いいえ |
| side | Enum8('B' = 1, 'A' = 2) | いいえ |
| size | Decimal(38, 18) | いいえ |
| start_position | Decimal(38, 18) | いいえ |
| tid | UInt64 | はい |
| タイムスタンプ | DateTime64(3, 'UTC') | はい |
| twap_id | Nullable(UInt64) | いいえ |
| 更新日時 | DateTime64(6, 'UTC') | いいえ |
| user | FixedString(42) | いいえ |
hyperliquid_builder_transactions
Sort Keys: ⚡ block_number, hash, user | Partition: toYYYYMM(block_time)
| Column | 種類 | Sort Key |
|---|---|---|
| action_type | LowCardinality(String) | いいえ |
| block_number | UInt64 | はい |
| block_time | DateTime64(6, 'UTC') | いいえ |
| builder | String | いいえ |
| builder_fee | Nullable(Decimal(38, 18)) | いいえ |
| コイン | Nullable(String) | いいえ |
| ハッシュ | String | はい |
| indexed_at | DateTime64(3, 'UTC') | いいえ |
| is_success | UInt8 | いいえ |
| user | String | はい |
hyperliquid_clearinghouse_states
Sort Keys: ⚡ block_number, clearinghouse, user, asset_idx | Partition: toYYYYMM(snapshot_time)
| Column | 種類 | Sort Key |
|---|---|---|
| asset_idx | UInt16 | はい |
| block_number | UInt64 | はい |
| clearinghouse | UInt8 | はい |
| コイン | LowCardinality(String) | いいえ |
| entry_notional | UInt64 | いいえ |
| funding_alltime | Int64 | いいえ |
| funding_since_change | Int64 | いいえ |
| funding_since_open | Int64 | いいえ |
| indexed_at | DateTime64(3, 'UTC') | いいえ |
| margin | UInt64 | いいえ |
| size | Int64 | いいえ |
| snapshot_time | DateTime64(6, 'UTC') | いいえ |
| usdc_balance | Int64 | いいえ |
| user | FixedString(42) | はい |
hyperliquid_delegator_rewards
Sort Keys: ⚡ block_number, validator, delegator | Partition: toYYYYMM(snapshot_time)
| Column | 種類 | Sort Key |
|---|---|---|
| block_number | UInt64 | はい |
| c | UInt64 | いいえ |
| commission_bps | UInt16 | いいえ |
| delegator | FixedString(42) | はい |
| e | UInt64 | いいえ |
| indexed_at | DateTime64(3, 'UTC') | いいえ |
| m | UInt64 | いいえ |
| reward | Decimal(38, 8) | いいえ |
| reward_wei | UInt64 | いいえ |
| snapshot_time | DateTime64(6, 'UTC') | いいえ |
| source | LowCardinality(String) | いいえ |
| validator | FixedString(42) | はい |
| validator_total_delegated | UInt64 | いいえ |
hyperliquid_dex_trades
Sort Keys: ⚡ none | Partition: none
| Column | 種類 | Sort Key |
|---|---|---|
| block_number | UInt64 | いいえ |
| block_time | DateTime64(6, 'UTC') | いいえ |
| buyer_address | FixedString(42) | いいえ |
| buyer_builder_address | Nullable(FixedString(42)) | いいえ |
| buyer_builder_fee | Nullable(Decimal(38, 18)) | いいえ |
| buyer_closed_pnl | Decimal(38, 18) | いいえ |
| buyer_crossed | UInt8 | いいえ |
| buyer_dir | LowCardinality(String) | いいえ |
| buyer_fee | Decimal(38, 18) | いいえ |
| buyer_order_id | UInt64 | いいえ |
| buyer_start_position | Decimal(38, 18) | いいえ |
| buyer_twap_id | Nullable(UInt64) | いいえ |
| コイン | LowCardinality(String) | いいえ |
| fee_token | LowCardinality(String) | いいえ |
| indexed_at | DateTime64(3, 'UTC') | いいえ |
| liquidated_user | Nullable(FixedString(42)) | いいえ |
| liquidation_mark_price | Nullable(Decimal(38, 18)) | いいえ |
| liquidation_method | Nullable(String) | いいえ |
| market_type | String | いいえ |
| price | Decimal(38, 18) | いいえ |
| seller_address | FixedString(42) | いいえ |
| seller_builder_address | Nullable(FixedString(42)) | いいえ |
| seller_builder_fee | Nullable(Decimal(38, 18)) | いいえ |
| seller_closed_pnl | Decimal(38, 18) | いいえ |
| seller_crossed | UInt8 | いいえ |
| seller_dir | LowCardinality(String) | いいえ |
| seller_fee | Decimal(38, 18) | いいえ |
| seller_order_id | UInt64 | いいえ |
| seller_start_position | Decimal(38, 18) | いいえ |
| seller_twap_id | Nullable(UInt64) | いいえ |
| side | Enum8('B' = 1, 'A' = 2) | いいえ |
| size | Decimal(38, 18) | いいえ |
| タイムスタンプ | DateTime64(3, 'UTC') | いいえ |
| total_builder_fee | Nullable(Decimal(38, 18)) | いいえ |
| trade_id | UInt64 | いいえ |
| transaction_hash | FixedString(66) | いいえ |
| unique_id | String | いいえ |
| usd_amount | Decimal(38, 18) | いいえ |
hyperliquid_display_names
Sort Keys: ⚡ block_number, user | Partition: toYYYYMM(snapshot_time)
| Column | 種類 | Sort Key |
|---|---|---|
| block_number | UInt64 | はい |
| display_name | String | いいえ |
| indexed_at | DateTime64(3, 'UTC') | いいえ |
| snapshot_time | DateTime64(6, 'UTC') | いいえ |
| user | FixedString(42) | はい |
hyperliquid_fills
Sort Keys: ⚡ block_number, tid, user | Partition: toYYYYMM(block_time)
| Column | 種類 | Sort Key |
|---|---|---|
| block_number | UInt64 | はい |
| block_time | DateTime64(6, 'UTC') | いいえ |
| builder | Nullable(FixedString(42)) | いいえ |
| builder_fee | Nullable(Decimal(38, 18)) | いいえ |
| cloid | Nullable(String) | いいえ |
| closed_pnl | Decimal(38, 18) | いいえ |
| コイン | LowCardinality(String) | いいえ |
| crossed | UInt8 | いいえ |
| deployer_fee | Nullable(Decimal(38, 18)) | いいえ |
| dir | LowCardinality(String) | いいえ |
| 手数料 | Decimal(38, 18) | いいえ |
| fee_token | LowCardinality(String) | いいえ |
| ハッシュ | FixedString(66) | いいえ |
| indexed_at | DateTime64(3, 'UTC') | いいえ |
| is_liquidation | UInt8 | いいえ |
| liquidated_user | Nullable(FixedString(42)) | いいえ |
| liquidation_mark_price | Nullable(Decimal(38, 18)) | いいえ |
| liquidation_method | Nullable(String) | いいえ |
| oid | UInt64 | いいえ |
| price | Decimal(38, 18) | いいえ |
| priority_gas | Nullable(Decimal(38, 18)) | いいえ |
| side | Enum8('B' = 1, 'A' = 2) | いいえ |
| size | Decimal(38, 18) | いいえ |
| start_position | Decimal(38, 18) | いいえ |
| tid | UInt64 | はい |
| 時間 | DateTime64(3, 'UTC') | いいえ |
| twap_id | Nullable(UInt64) | いいえ |
| user | FixedString(42) | はい |
hyperliquid_funding
Sort Keys: ⚡ block_number, user, coin, time | Partition: toYYYYMM(block_time)
| Column | 種類 | Sort Key |
|---|---|---|
| block_number | UInt64 | はい |
| block_time | DateTime64(6, 'UTC') | いいえ |
| コイン | LowCardinality(String) | はい |
| funding_amount | Decimal(38, 18) | いいえ |
| funding_rate | Decimal(38, 18) | いいえ |
| ハッシュ | FixedString(66) | いいえ |
| indexed_at | DateTime64(3, 'UTC') | いいえ |
| szi | Decimal(38, 18) | いいえ |
| 時間 | DateTime64(6, 'UTC') | はい |
| user | FixedString(42) | はい |
hyperliquid_funding_summary_hourly
Sort Keys: ⚡ coin, hour | Partition: toYYYYMM(hour)
| Column | 種類 | Sort Key |
|---|---|---|
| avg_funding_rate | SimpleAggregateFunction(any, Float64) | いいえ |
| コイン | LowCardinality(String) | はい |
| hour | DateTime('UTC') | はい |
| total_funding | SimpleAggregateFunction(sum, Decimal(38, 18)) | いいえ |
| unique_users | SimpleAggregateFunction(max, UInt64) | いいえ |
hyperliquid_ledger_updates
Sort Keys: ⚡ block_number, user, time, hash | Partition: toYYYYMM(block_time)
| Column | 種類 | Sort Key |
|---|---|---|
| account_value | Nullable(Decimal(38, 18)) | いいえ |
| 金額 | Nullable(Decimal(38, 18)) | いいえ |
| basis | Nullable(Decimal(38, 18)) | いいえ |
| block_number | UInt64 | はい |
| block_time | DateTime64(6, 'UTC') | いいえ |
| closing_cost | Nullable(Decimal(38, 18)) | いいえ |
| commission | Nullable(Decimal(38, 18)) | いいえ |
| delta_type | LowCardinality(String) | いいえ |
| destination | Nullable(FixedString(42)) | いいえ |
| destination_dex | Nullable(String) | いいえ |
| dex | Nullable(String) | いいえ |
| 手数料 | Nullable(Decimal(38, 18)) | いいえ |
| fee_token | Nullable(String) | いいえ |
| ハッシュ | FixedString(66) | はい |
| indexed_at | DateTime64(3, 'UTC') | いいえ |
| interest_amount | Nullable(Decimal(38, 18)) | いいえ |
| is_deposit | Nullable(UInt8) | いいえ |
| leverage_type | Nullable(String) | いいえ |
| liquidated_ntl_pos | Nullable(Decimal(38, 18)) | いいえ |
| liquidated_positions | Nullable(String) | いいえ |
| native_token_fee | Nullable(Decimal(38, 18)) | いいえ |
| net_withdrawn_usd | Nullable(Decimal(38, 18)) | いいえ |
| nonce | Nullable(UInt64) | いいえ |
| operation | Nullable(String) | いいえ |
| requested_usd | Nullable(Decimal(38, 18)) | いいえ |
| secondary_user | Nullable(FixedString(42)) | いいえ |
| source_dex | Nullable(String) | いいえ |
| 時間 | DateTime64(6, 'UTC') | はい |
| to_perp | Nullable(UInt8) | いいえ |
| token | Nullable(String) | いいえ |
| usdc_amount | Nullable(Decimal(38, 18)) | いいえ |
| usdc_value | Nullable(Decimal(38, 18)) | いいえ |
| user | FixedString(42) | はい |
| vault | Nullable(FixedString(42)) | いいえ |
hyperliquid_liquidations_hourly
Sort Keys: ⚡ hour, coin | Partition: toYYYYMM(hour)
| Column | 種類 | Sort Key |
|---|---|---|
| コイン | LowCardinality(String) | はい |
| hour | DateTime | はい |
| liquidated_volume | SimpleAggregateFunction(sum, Decimal(38, 18)) | いいえ |
| liquidation_count | SimpleAggregateFunction(sum, UInt64) | いいえ |
| unique_liquidated_users | SimpleAggregateFunction(max, UInt64) | いいえ |
hyperliquid_market_volume_hourly
Sort Keys: ⚡ coin, hour | Partition: toYYYYMM(hour)
| Column | 種類 | Sort Key |
|---|---|---|
| close | SimpleAggregateFunction(anyLast, Decimal(38, 18)) | いいえ |
| コイン | LowCardinality(String) | はい |
| high | SimpleAggregateFunction(max, Decimal(38, 18)) | いいえ |
| hour | DateTime('UTC') | はい |
| low | SimpleAggregateFunction(min, Decimal(38, 18)) | いいえ |
| open | SimpleAggregateFunction(any, Decimal(38, 18)) | いいえ |
| trade_count | SimpleAggregateFunction(sum, UInt64) | いいえ |
| ボリューム | SimpleAggregateFunction(sum, Decimal(38, 18)) | いいえ |
hyperliquid_metrics_dex_overview
Sort Keys: ⚡ day, coin | Partition: toYYYYMM(day)
| Column | 種類 | Sort Key |
|---|---|---|
| コイン | LowCardinality(String) | はい |
| day | 日付 | はい |
| fees | SimpleAggregateFunction(sum, Decimal(38, 18)) | いいえ |
| fill_count | SimpleAggregateFunction(sum, UInt64) | いいえ |
| high_price | SimpleAggregateFunction(max, Decimal(38, 18)) | いいえ |
| liquidations | SimpleAggregateFunction(sum, UInt64) | いいえ |
| low_price | SimpleAggregateFunction(min, Decimal(38, 18)) | いいえ |
| unique_traders | SimpleAggregateFunction(max, UInt64) | いいえ |
| volume_usd | SimpleAggregateFunction(sum, Decimal(38, 18)) | いいえ |
hyperliquid_metrics_overview
Sort Keys: ⚡ day | Partition: toYYYYMM(day)
| Column | 種類 | Sort Key |
|---|---|---|
| active_traders | SimpleAggregateFunction(max, UInt64) | いいえ |
| builder_fill_count | SimpleAggregateFunction(sum, UInt64) | いいえ |
| coins_traded | SimpleAggregateFunction(max, UInt64) | いいえ |
| day | 日付 | はい |
| liquidation_count | SimpleAggregateFunction(sum, UInt64) | いいえ |
| liquidation_volume_usd | SimpleAggregateFunction(sum, Decimal(38, 18)) | いいえ |
| total_builder_fees | SimpleAggregateFunction(sum, Decimal(38, 18)) | いいえ |
| total_fees | SimpleAggregateFunction(sum, Decimal(38, 18)) | いいえ |
| total_fills | SimpleAggregateFunction(sum, UInt64) | いいえ |
| total_volume_usd | SimpleAggregateFunction(sum, Decimal(38, 18)) | いいえ |
hyperliquid_oracle_prices
Sort Keys: ⚡ block_number, clearinghouse, asset_idx | Partition: toYYYYMM(snapshot_time)
| Column | 種類 | Sort Key |
|---|---|---|
| asset_idx | UInt16 | はい |
| block_number | UInt64 | はい |
| clearinghouse | UInt8 | はい |
| コイン | LowCardinality(String) | いいえ |
| daily_px | String | いいえ |
| indexed_at | DateTime64(3, 'UTC') | いいえ |
| mark_px | String | いいえ |
| snapshot_time | DateTime64(6, 'UTC') | いいえ |
hyperliquid_order_book_diffs
Sort Keys: ⚡ coin, side, block_number, oid | Partition: toYYYYMM(block_time)
| Column | 種類 | Sort Key |
|---|---|---|
| block_number | UInt64 | はい |
| block_time | DateTime64(6, 'UTC') | いいえ |
| コイン | LowCardinality(String) | はい |
| diff_type | LowCardinality(String) | いいえ |
| indexed_at | DateTime64(3, 'UTC') | いいえ |
| new_size | Nullable(Decimal(38, 18)) | いいえ |
| oid | UInt64 | はい |
| orig_size | Nullable(Decimal(38, 18)) | いいえ |
| price | Decimal(38, 18) | いいえ |
| side | Enum8('B' = 1, 'A' = 2) | はい |
| size | Nullable(Decimal(38, 18)) | いいえ |
| user | FixedString(42) | いいえ |
hyperliquid_orders
Sort Keys: ⚡ block_number, oid, status_time | Partition: toYYYYMM(block_time)
| Column | 種類 | Sort Key |
|---|---|---|
| block_number | UInt64 | はい |
| block_time | DateTime64(6, 'UTC') | いいえ |
| builder | Nullable(String) | いいえ |
| children | Nullable(String) | いいえ |
| cloid | Nullable(String) | いいえ |
| コイン | LowCardinality(String) | いいえ |
| ハッシュ | Nullable(FixedString(66)) | いいえ |
| indexed_at | DateTime64(3, 'UTC') | いいえ |
| is_position_tpsl | UInt8 | いいえ |
| is_trigger | UInt8 | いいえ |
| limit_price | Decimal(38, 18) | いいえ |
| oid | UInt64 | はい |
| order_timestamp | DateTime64(3, 'UTC') | いいえ |
| order_type | LowCardinality(String) | いいえ |
| orig_size | Decimal(38, 18) | いいえ |
| reduce_only | UInt8 | いいえ |
| side | Enum8('B' = 1, 'A' = 2) | いいえ |
| size | Decimal(38, 18) | いいえ |
| ステータス | LowCardinality(String) | いいえ |
| status_time | DateTime64(6, 'UTC') | はい |
| tif | LowCardinality(String) | いいえ |
| trigger_condition | Nullable(String) | いいえ |
| trigger_price | Nullable(Decimal(38, 18)) | いいえ |
| unique_id | String | いいえ |
| user | FixedString(42) | いいえ |
hyperliquid_outcome_markets
Sort Keys: ⚡ none | Partition: none
| Column | 種類 | Sort Key |
|---|---|---|
| base_token_idx | Nullable(UInt64) | いいえ |
| block_number | UInt64 | いいえ |
| コイン | Nullable(String) | いいえ |
| 説明 | String | いいえ |
| expiry | String | いいえ |
| fee_share | Float64 | いいえ |
| first_enabled_as_quote | String | いいえ |
| indexed_at | DateTime64(3, 'UTC') | いいえ |
| is_liquid_base | UInt8 | いいえ |
| is_liquid_quote | UInt8 | いいえ |
| locked | UInt8 | いいえ |
| 名前 | LowCardinality(String) | いいえ |
| ndo | UInt64 | いいえ |
| nou | UInt64 | いいえ |
| nqu | UInt64 | いいえ |
| outcome_class | LowCardinality(String) | いいえ |
| outcome_id | UInt64 | いいえ |
| pair_name | String | いいえ |
| period | LowCardinality(String) | いいえ |
| quote_raw | Nullable(UInt64) | いいえ |
| quote_token_idx | Nullable(UInt64) | いいえ |
| quote_token_name | Nullable(String) | いいえ |
| quote_token_status | LowCardinality(String) | いいえ |
| quote_token_usdc_px | Decimal(38, 18) | いいえ |
| quote_token_usdc_px_raw | UInt64 | いいえ |
| raw_side_json | String | いいえ |
| raw_spec_json | String | いいえ |
| side_count | UInt16 | いいえ |
| side_index | UInt8 | いいえ |
| side_name | LowCardinality(String) | いいえ |
| snapshot_time | DateTime64(6, 'UTC') | いいえ |
| spot_deploy_time | String | いいえ |
| spot_index | Nullable(UInt64) | いいえ |
| spot_resolution | LowCardinality(String) | いいえ |
| target_price | String | いいえ |
| token_idx | Nullable(UInt64) | いいえ |
| token_name | Nullable(String) | いいえ |
| underlying | LowCardinality(String) | いいえ |
hyperliquid_outcome_meta
Sort Keys: ⚡ block_number, outcome_id | Partition: toYYYYMM(snapshot_time)
| Column | 種類 | Sort Key |
|---|---|---|
| block_number | UInt64 | はい |
| deploy_gas_auction_json | String | いいえ |
| 説明 | String | いいえ |
| expiry | String | いいえ |
| fee_share | Float64 | いいえ |
| indexed_at | DateTime64(3, 'UTC') | いいえ |
| locked | UInt8 | いいえ |
| 名前 | LowCardinality(String) | いいえ |
| ndo | UInt64 | いいえ |
| nou | UInt64 | いいえ |
| nqu | UInt64 | いいえ |
| outcome_class | LowCardinality(String) | いいえ |
| outcome_id | UInt64 | はい |
| period | LowCardinality(String) | いいえ |
| quote_raw | Nullable(UInt64) | いいえ |
| raw_spec_json | String | いいえ |
| side_count | UInt16 | いいえ |
| snapshot_time | DateTime64(6, 'UTC') | いいえ |
| target_price | String | いいえ |
| underlying | LowCardinality(String) | いいえ |
hyperliquid_outcome_question_members
Sort Keys: ⚡ block_number, question_id, outcome_id | Partition: toYYYYMM(snapshot_time)
| Column | 種類 | Sort Key |
|---|---|---|
| block_number | UInt64 | はい |
| indexed_at | DateTime64(3, 'UTC') | いいえ |
| is_fallback | UInt8 | いいえ |
| is_settled | UInt8 | いいえ |
| outcome_id | UInt64 | はい |
| question_id | UInt64 | はい |
| snapshot_time | DateTime64(6, 'UTC') | いいえ |
| source | LowCardinality(String) | いいえ |
hyperliquid_outcome_questions
Sort Keys: ⚡ block_number, question_id | Partition: toYYYYMM(snapshot_time)
| Column | 種類 | Sort Key |
|---|---|---|
| block_number | UInt64 | はい |
| 説明 | String | いいえ |
| fallback_outcome | Nullable(UInt64) | いいえ |
| indexed_at | DateTime64(3, 'UTC') | いいえ |
| 名前 | String | いいえ |
| named_outcomes_json | String | いいえ |
| question_id | UInt64 | はい |
| raw_question_json | String | いいえ |
| settled_named_outcomes_json | String | いいえ |
| snapshot_time | DateTime64(6, 'UTC') | いいえ |
hyperliquid_outcome_sides
Sort Keys: ⚡ block_number, outcome_id, side_index | Partition: toYYYYMM(snapshot_time)
| Column | 種類 | Sort Key |
|---|---|---|
| base_token_idx | Nullable(UInt64) | いいえ |
| block_number | UInt64 | はい |
| コイン | Nullable(String) | いいえ |
| indexed_at | DateTime64(3, 'UTC') | いいえ |
| outcome_id | UInt64 | はい |
| quote_token_idx | Nullable(UInt64) | いいえ |
| quote_token_name | Nullable(String) | いいえ |
| raw_side_json | String | いいえ |
| side_index | UInt8 | はい |
| side_m_raw | String | いいえ |
| side_m_value | Nullable(Int64) | いいえ |
| side_name | LowCardinality(String) | いいえ |
| snapshot_time | DateTime64(6, 'UTC') | いいえ |
| spot_index | Nullable(UInt64) | いいえ |
| spot_indices_json | String | いいえ |
| spot_resolution | LowCardinality(String) | いいえ |
| token_idx | Nullable(UInt64) | いいえ |
| token_name | Nullable(String) | いいえ |
hyperliquid_perpetual_market_contexts
Sort Keys: ⚡ none | Partition: none
| Column | 種類 | Sort Key |
|---|---|---|
| コイン | LowCardinality(String) | いいえ |
| day_base_vlm | Decimal(38, 18) | いいえ |
| day_ntl_vlm | Decimal(38, 18) | いいえ |
| funding | Decimal(38, 18) | いいえ |
| impact_ask | Nullable(Decimal(38, 18)) | いいえ |
| impact_bid | Nullable(Decimal(38, 18)) | いいえ |
| mark_px | Decimal(38, 18) | いいえ |
| mid_px | Decimal(38, 18) | いいえ |
| open_interest | Decimal(38, 18) | いいえ |
| oracle_px | Decimal(38, 18) | いいえ |
| polled_at | DateTime64(6, 'UTC') | いいえ |
| premium | Decimal(38, 18) | いいえ |
| prev_day_px | Decimal(38, 18) | いいえ |
hyperliquid_perpetual_markets
Sort Keys: ⚡ coin | Partition: none
| Column | 種類 | Sort Key |
|---|---|---|
| コイン | LowCardinality(String) | はい |
| indexed_at | DateTime64(3, 'UTC') | いいえ |
| margin_table_id | Nullable(UInt16) | いいえ |
| market_index | UInt16 | いいえ |
| max_leverage | UInt16 | いいえ |
| only_isolated | UInt8 | いいえ |
| sz_decimals | UInt8 | いいえ |
hyperliquid_perpetual_positions
Sort Keys: ⚡ block_number, clearinghouse, user, asset_idx | Partition: toYYYYMM(snapshot_time)
| Column | 種類 | Sort Key |
|---|---|---|
| asset_idx | UInt16 | はい |
| block_number | UInt64 | はい |
| clearinghouse | UInt8 | はい |
| コイン | String | いいえ |
| entry_notional | UInt64 | いいえ |
| funding_alltime | Int64 | いいえ |
| funding_since_change | Int64 | いいえ |
| funding_since_open | Int64 | いいえ |
| indexed_at | DateTime64(3, 'UTC') | いいえ |
| margin | UInt64 | いいえ |
| size | Int64 | いいえ |
| snapshot_time | DateTime64(6, 'UTC') | いいえ |
| usdc_balance | Int64 | いいえ |
| user | String | はい |
hyperliquid_quote_token_meta
Sort Keys: ⚡ block_number, token_idx | Partition: toYYYYMM(snapshot_time)
| Column | 種類 | Sort Key |
|---|---|---|
| aligned_quote_info_json | String | いいえ |
| block_number | UInt64 | はい |
| first_enabled_as_quote | String | いいえ |
| indexed_at | DateTime64(3, 'UTC') | いいえ |
| is_liquid_base | UInt8 | いいえ |
| is_liquid_quote | UInt8 | いいえ |
| snapshot_time | DateTime64(6, 'UTC') | いいえ |
| ステータス | LowCardinality(String) | いいえ |
| token_idx | UInt64 | はい |
| token_name | LowCardinality(String) | いいえ |
hyperliquid_register_referral
Sort Keys: ⚡ referral_code, user | Partition: none
| Column | 種類 | Sort Key |
|---|---|---|
| block_time | DateTime64(6, 'UTC') | いいえ |
| error | Nullable(String) | いいえ |
| indexed_at | DateTime64(3, 'UTC') | いいえ |
| is_success | UInt8 | いいえ |
| referral_code | String | はい |
| round | UInt64 | いいえ |
| tx_hash | String | いいえ |
| user | String | はい |
hyperliquid_set_referrer
Sort Keys: ⚡ referral_code, user | Partition: none
| Column | 種類 | Sort Key |
|---|---|---|
| block_time | DateTime64(6, 'UTC') | いいえ |
| error | Nullable(String) | いいえ |
| indexed_at | DateTime64(3, 'UTC') | いいえ |
| is_success | UInt8 | いいえ |
| referral_code | String | はい |
| round | UInt64 | いいえ |
| tx_hash | String | いいえ |
| user | String | はい |
hyperliquid_spot_balances
Sort Keys: ⚡ block_number, user, token_idx | Partition: toYYYYMM(snapshot_time)
| Column | 種類 | Sort Key |
|---|---|---|
| block_number | UInt64 | はい |
| escrowed | Int64 | いいえ |
| indexed_at | DateTime64(3, 'UTC') | いいえ |
| snapshot_time | DateTime64(6, 'UTC') | いいえ |
| token | String | いいえ |
| token_idx | UInt16 | はい |
| total | Int64 | いいえ |
| user | String | はい |
hyperliquid_spot_clearinghouse_states
Sort Keys: ⚡ block_number, user, token_idx | Partition: toYYYYMM(snapshot_time)
| Column | 種類 | Sort Key |
|---|---|---|
| block_number | UInt64 | はい |
| escrowed | Int64 | いいえ |
| indexed_at | DateTime64(3, 'UTC') | いいえ |
| snapshot_time | DateTime64(6, 'UTC') | いいえ |
| token | LowCardinality(String) | いいえ |
| token_idx | UInt16 | はい |
| total | Int64 | いいえ |
| user | FixedString(42) | はい |
hyperliquid_spot_markets
Sort Keys: ⚡ token_index | Partition: none
| Column | 種類 | Sort Key |
|---|---|---|
| deployer_trading_fee_share | Nullable(String) | いいえ |
| evm_contract | Nullable(String) | いいえ |
| full_name | Nullable(String) | いいえ |
| indexed_at | DateTime64(3, 'UTC') | いいえ |
| is_canonical | UInt8 | いいえ |
| pair_index | Nullable(UInt16) | いいえ |
| pair_name | Nullable(String) | いいえ |
| sz_decimals | UInt8 | いいえ |
| token | LowCardinality(String) | いいえ |
| token_id | String | いいえ |
| token_index | UInt16 | はい |
| wei_decimals | UInt8 | いいえ |
hyperliquid_spot_pairs
Sort Keys: ⚡ block_number, spot_index | Partition: toYYYYMM(snapshot_time)
| Column | 種類 | Sort Key |
|---|---|---|
| base_token_idx | UInt64 | いいえ |
| base_token_name | LowCardinality(String) | いいえ |
| block_number | UInt64 | はい |
| deploy_time | String | いいえ |
| indexed_at | DateTime64(3, 'UTC') | いいえ |
| pair_name | String | いいえ |
| quote_token_idx | UInt64 | いいえ |
| quote_token_name | LowCardinality(String) | いいえ |
| raw_spot_info_json | String | いいえ |
| snapshot_time | DateTime64(6, 'UTC') | いいえ |
| spot_index | UInt64 | はい |
hyperliquid_staking_events
Sort Keys: ⚡ block_number, hash | Partition: toYYYYMM(block_time)
| Column | 種類 | Sort Key |
|---|---|---|
| 金額 | Decimal(38, 18) | いいえ |
| block_number | UInt64 | はい |
| block_time | DateTime64(6, 'UTC') | いいえ |
| event_type | Enum8('CDeposit' = 1, 'CWithdrawal' = 2, 'Delegation' = 3) | いいえ |
| ハッシュ | FixedString(66) | はい |
| indexed_at | DateTime64(3, 'UTC') | いいえ |
| is_finalized | Nullable(UInt8) | いいえ |
| is_undelegate | Nullable(UInt8) | いいえ |
| 時間 | DateTime64(6, 'UTC') | いいえ |
| user | FixedString(42) | いいえ |
| validator | Nullable(FixedString(42)) | いいえ |
hyperliquid_sub_accounts
Sort Keys: ⚡ block_number, sub_account | Partition: toYYYYMM(snapshot_time)
| Column | 種類 | Sort Key |
|---|---|---|
| block_number | UInt64 | はい |
| indexed_at | DateTime64(3, 'UTC') | いいえ |
| master_account | FixedString(42) | いいえ |
| 名前 | Nullable(String) | いいえ |
| snapshot_time | DateTime64(6, 'UTC') | いいえ |
| sub_account | FixedString(42) | はい |
hyperliquid_summaries
Sort Keys: ⚡ user, polled_at | Partition: toYYYYMM(polled_at)
| Column | 種類 | Sort Key |
|---|---|---|
| cross_maintenance_margin_used | Decimal(38, 18) | いいえ |
| cross_margin_account_value | Decimal(38, 18) | いいえ |
| cross_margin_total_margin_used | Decimal(38, 18) | いいえ |
| cross_margin_total_natl_pos | Decimal(38, 18) | いいえ |
| cross_margin_total_raw_usd | Decimal(38, 18) | いいえ |
| indexed_at | DateTime64(3, 'UTC') | いいえ |
| margin_account_value | Decimal(38, 18) | いいえ |
| margin_total_margin_used | Decimal(38, 18) | いいえ |
| margin_total_natl_pos | Decimal(38, 18) | いいえ |
| margin_total_raw_usd | Decimal(38, 18) | いいえ |
| polled_at | DateTime64(3, 'UTC') | はい |
| user | String | はい |
| 引き出し可能 | Decimal(38, 18) | いいえ |
hyperliquid_system_actions
Sort Keys: ⚡ block_number, evm_tx_hash, nonce | Partition: toYYYYMM(block_time)
| Column | 種類 | Sort Key |
|---|---|---|
| action | String | いいえ |
| action_type | LowCardinality(String) | いいえ |
| agent_address | Nullable(FixedString(42)) | いいえ |
| agent_name | Nullable(String) | いいえ |
| block_number | UInt64 | はい |
| block_time | DateTime64(6, 'UTC') | いいえ |
| destination | Nullable(FixedString(42)) | いいえ |
| destination_dex_or_spot | Nullable(UInt8) | いいえ |
| evm_tx_hash | FixedString(66) | はい |
| from_sub_account | Nullable(UInt8) | いいえ |
| hyperliquid_chain | Nullable(String) | いいえ |
| indexed_at | DateTime64(3, 'UTC') | いいえ |
| is_mint | Nullable(UInt8) | いいえ |
| is_undelegate | Nullable(UInt8) | いいえ |
| nonce | UInt64 | はい |
| ntl | Nullable(Decimal(38, 18)) | いいえ |
| order_grouping | Nullable(String) | いいえ |
| signature_chain_id | Nullable(String) | いいえ |
| source_dex_or_spot | Nullable(UInt8) | いいえ |
| to_perp | Nullable(UInt8) | いいえ |
| token | Nullable(UInt16) | いいえ |
| user | FixedString(42) | いいえ |
| validator | Nullable(FixedString(42)) | いいえ |
| wei | Nullable(UInt256) | いいえ |
hyperliquid_token_usdc_prices
Sort Keys: ⚡ block_number, token_idx | Partition: toYYYYMM(snapshot_time)
| Column | 種類 | Sort Key |
|---|---|---|
| approx_usdc_px | Decimal(38, 18) | いいえ |
| approx_usdc_px_float_1e6 | Float64 | いいえ |
| approx_usdc_px_raw | UInt64 | いいえ |
| block_number | UInt64 | はい |
| indexed_at | DateTime64(3, 'UTC') | いいえ |
| raw_pair_json | String | いいえ |
| snapshot_time | DateTime64(6, 'UTC') | いいえ |
| token_idx | UInt64 | はい |
| token_name | LowCardinality(String) | いいえ |
hyperliquid_trades
Sort Keys: ⚡ block_number, trade_id | Partition: toYYYYMM(block_time)
| Column | 種類 | Sort Key |
|---|---|---|
| block_number | UInt64 | はい |
| block_time | DateTime64(6, 'UTC') | いいえ |
| buyer_address | FixedString(42) | いいえ |
| buyer_builder_address | Nullable(FixedString(42)) | いいえ |
| buyer_builder_fee | Nullable(Decimal(38, 18)) | いいえ |
| buyer_closed_pnl | Decimal(38, 18) | いいえ |
| buyer_crossed | UInt8 | いいえ |
| buyer_deployer_fee | Nullable(Decimal(38, 18)) | いいえ |
| buyer_dir | LowCardinality(String) | いいえ |
| buyer_fee | Decimal(38, 18) | いいえ |
| buyer_order_id | UInt64 | いいえ |
| buyer_priority_gas | Nullable(Decimal(38, 18)) | いいえ |
| buyer_start_position | Decimal(38, 18) | いいえ |
| buyer_twap_id | Nullable(UInt64) | いいえ |
| コイン | LowCardinality(String) | いいえ |
| fee_token | LowCardinality(String) | いいえ |
| indexed_at | DateTime64(3, 'UTC') | いいえ |
| liquidated_user | Nullable(FixedString(42)) | いいえ |
| liquidation_mark_price | Nullable(Decimal(38, 18)) | いいえ |
| liquidation_method | Nullable(String) | いいえ |
| price | Decimal(38, 18) | いいえ |
| seller_address | FixedString(42) | いいえ |
| seller_builder_address | Nullable(FixedString(42)) | いいえ |
| seller_builder_fee | Nullable(Decimal(38, 18)) | いいえ |
| seller_closed_pnl | Decimal(38, 18) | いいえ |
| seller_crossed | UInt8 | いいえ |
| seller_deployer_fee | Nullable(Decimal(38, 18)) | いいえ |
| seller_dir | LowCardinality(String) | いいえ |
| seller_fee | Decimal(38, 18) | いいえ |
| seller_order_id | UInt64 | いいえ |
| seller_priority_gas | Nullable(Decimal(38, 18)) | いいえ |
| seller_start_position | Decimal(38, 18) | いいえ |
| seller_twap_id | Nullable(UInt64) | いいえ |
| side | Enum8('B' = 1, 'A' = 2) | いいえ |
| size | Decimal(38, 18) | いいえ |
| タイムスタンプ | DateTime64(3, 'UTC') | いいえ |
| total_builder_fee | Nullable(Decimal(38, 18)) | いいえ |
| trade_id | UInt64 | はい |
| transaction_hash | FixedString(66) | いいえ |
| unique_id | String | いいえ |
hyperliquid_transactions
Sort Keys: ⚡ round, tx_hash, nonce | Partition: toYYYYMM(block_time)
| Column | 種類 | Sort Key |
|---|---|---|
| action | JSON | いいえ |
| action_type | LowCardinality(String) | いいえ |
| block_time | DateTime64(6, 'UTC') | いいえ |
| error | Nullable(String) | いいえ |
| indexed_at | DateTime64(3, 'UTC') | いいえ |
| is_success | UInt8 | いいえ |
| nonce | UInt64 | はい |
| proposer | Nullable(String) | いいえ |
| round | UInt64 | はい |
| tx_hash | String | はい |
| user | Nullable(String) | いいえ |
| vault_address | Nullable(String) | いいえ |
hyperliquid_twap_statuses
Sort Keys: ⚡ block_number, twap_id, time | Partition: toYYYYMM(block_time)
| Column | 種類 | Sort Key |
|---|---|---|
| block_number | UInt64 | はい |
| block_time | DateTime64(6, 'UTC') | いいえ |
| コイン | LowCardinality(String) | いいえ |
| executed_ntl | Decimal(38, 18) | いいえ |
| executed_size | Decimal(38, 18) | いいえ |
| indexed_at | DateTime64(3, 'UTC') | いいえ |
| minutes | UInt16 | いいえ |
| randomize | UInt8 | いいえ |
| reduce_only | UInt8 | いいえ |
| side | Enum8('B' = 1, 'A' = 2) | いいえ |
| size | Decimal(38, 18) | いいえ |
| ステータス | LowCardinality(String) | いいえ |
| 時間 | DateTime64(6, 'UTC') | はい |
| タイムスタンプ | DateTime64(3, 'UTC') | いいえ |
| twap_id | UInt64 | はい |
| user | FixedString(42) | いいえ |
hyperliquid_validator_rewards
Sort Keys: ⚡ block_number, validator, time | Partition: toYYYYMM(block_time)
| Column | 種類 | Sort Key |
|---|---|---|
| block_number | UInt64 | はい |
| block_time | DateTime64(6, 'UTC') | いいえ |
| ハッシュ | FixedString(66) | いいえ |
| indexed_at | DateTime64(3, 'UTC') | いいえ |
| reward | Decimal(38, 18) | いいえ |
| 時間 | DateTime64(6, 'UTC') | はい |
| validator | FixedString(42) | はい |
hyperliquid_vault_equities
Sort Keys: ⚡ block_number, vault_address, depositor | Partition: toYYYYMM(snapshot_time)
| Column | 種類 | Sort Key |
|---|---|---|
| block_number | UInt64 | はい |
| depositor | FixedString(42) | はい |
| indexed_at | DateTime64(3, 'UTC') | いいえ |
| leader | FixedString(42) | いいえ |
| leader_commission | Float64 | いいえ |
| net_deposits | Int64 | いいえ |
| ownership_fraction | Float64 | いいえ |
| snapshot_time | DateTime64(6, 'UTC') | いいえ |
| vault_address | FixedString(42) | はい |
| vault_name | String | いいえ |
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.
Build Web3 Plugin
For AI agents and LLM applications, install the Build Web3 plugin so your agent can build on SQL Explorer, with full knowledge of its schemas and of every other Quicknode product. In Claude Code:
/plugin marketplace add quicknode/agent-plugins
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]