================================================================================
Chain: Hyperliquid (HyperCore)
Cluster ID: hyperliquid-core-mainnet
================================================================================

--------------------------------------------------------------------------------
Table: hyperliquid_agents
Engine: SharedReplacingMergeTree
Total Rows: 1,404,858,152
Sorting Key: block_number, agent
Partition Key: toYYYYMM(snapshot_time)

Columns:
  - agent: FixedString(42)
  - block_number: UInt64
  - indexed_at: DateTime64(3, 'UTC')
  - name: String
  - snapshot_time: DateTime64(6, 'UTC')
  - user: FixedString(42)
  - valid_until: String

--------------------------------------------------------------------------------
Table: hyperliquid_asset_transfers
Engine: SharedReplacingMergeTree
Total Rows: 10,890,896
Sorting Key: block_number, tx_hash, user
Partition Key: toYYYYMM(block_time)

Columns:
  - amount: Nullable(Decimal(38, 18))
  - block_number: UInt64
  - block_time: DateTime64(6, 'UTC')
  - destination: Nullable(FixedString(42))
  - fee: Nullable(Decimal(38, 18))
  - indexed_at: DateTime64(3, 'UTC')
  - nonce: Nullable(UInt64)
  - time: DateTime64(6, 'UTC')
  - token: Nullable(String)
  - transfer_type: LowCardinality(String)
  - tx_hash: FixedString(66)
  - usdc_amount: Nullable(Decimal(38, 18))
  - user: FixedString(42)

--------------------------------------------------------------------------------
Table: hyperliquid_blocks
Engine: SharedSummingMergeTree
Total Rows: 299,454,747
Sorting Key: block_number
Partition Key: toYYYYMM(block_time)

Columns:
  - 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

--------------------------------------------------------------------------------
Table: hyperliquid_bridge
Engine: SharedReplacingMergeTree
Total Rows: 227,330,115
Sorting Key: block_number, bridge_type, user, nonce, eth_block_number, tx_hash
Partition Key: toYYYYMM(snapshot_time)

Columns:
  - 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)

--------------------------------------------------------------------------------
Table: hyperliquid_builder_fills
Engine: SharedReplacingMergeTree
Total Rows: 185,317,081
Sorting Key: builder_address, timestamp, tid
Partition Key: toYYYYMM(block_time)

Columns:
  - 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)
  - coin: LowCardinality(String)
  - created_at: DateTime64(6, 'UTC')
  - crossed: UInt8
  - dir: LowCardinality(String)
  - fee: Decimal(38, 18)
  - hash: 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
  - timestamp: DateTime64(3, 'UTC')
  - twap_id: Nullable(UInt64)
  - updated_at: DateTime64(6, 'UTC')
  - user: FixedString(42)

--------------------------------------------------------------------------------
Table: hyperliquid_builder_transactions
Engine: SharedReplacingMergeTree
Total Rows: 131,063,171
Sorting Key: block_number, hash, user
Partition Key: toYYYYMM(block_time)

Columns:
  - action_type: LowCardinality(String)
  - block_number: UInt64
  - block_time: DateTime64(6, 'UTC')
  - builder: String
  - builder_fee: Nullable(Decimal(38, 18))
  - coin: Nullable(String)
  - hash: String
  - indexed_at: DateTime64(3, 'UTC')
  - is_success: UInt8
  - user: String

--------------------------------------------------------------------------------
Table: hyperliquid_clearinghouse_states
Engine: SharedReplacingMergeTree
Total Rows: 1,267,433,440
Sorting Key: block_number, clearinghouse, user, asset_idx
Partition Key: toYYYYMM(snapshot_time)

Columns:
  - asset_idx: UInt16
  - block_number: UInt64
  - clearinghouse: UInt8
  - coin: 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)

--------------------------------------------------------------------------------
Table: hyperliquid_delegator_rewards
Engine: SharedReplacingMergeTree
Total Rows: 402,160,625
Sorting Key: block_number, validator, delegator
Partition Key: toYYYYMM(snapshot_time)

Columns:
  - 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

--------------------------------------------------------------------------------
Table: hyperliquid_dex_trades
Engine: View
Total Rows: 0
Sorting Key: 
Partition Key: 

Columns:
  - 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)
  - coin: 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)
  - timestamp: 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)

--------------------------------------------------------------------------------
Table: hyperliquid_display_names
Engine: SharedReplacingMergeTree
Total Rows: 10,918,909
Sorting Key: block_number, user
Partition Key: toYYYYMM(snapshot_time)

Columns:
  - block_number: UInt64
  - display_name: String
  - indexed_at: DateTime64(3, 'UTC')
  - snapshot_time: DateTime64(6, 'UTC')
  - user: FixedString(42)

--------------------------------------------------------------------------------
Table: hyperliquid_fills
Engine: SharedReplacingMergeTree
Total Rows: 2,534,263,644
Sorting Key: block_number, tid, user
Partition Key: toYYYYMM(block_time)

Columns:
  - 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)
  - coin: LowCardinality(String)
  - crossed: UInt8
  - deployer_fee: Nullable(Decimal(38, 18))
  - dir: LowCardinality(String)
  - fee: Decimal(38, 18)
  - fee_token: LowCardinality(String)
  - hash: 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
  - time: DateTime64(3, 'UTC')
  - twap_id: Nullable(UInt64)
  - user: FixedString(42)

--------------------------------------------------------------------------------
Table: hyperliquid_funding
Engine: SharedReplacingMergeTree
Total Rows: 1,143,838,871
Sorting Key: block_number, user, coin, time
Partition Key: toYYYYMM(block_time)

Columns:
  - block_number: UInt64
  - block_time: DateTime64(6, 'UTC')
  - coin: LowCardinality(String)
  - funding_amount: Decimal(38, 18)
  - funding_rate: Decimal(38, 18)
  - hash: FixedString(66)
  - indexed_at: DateTime64(3, 'UTC')
  - szi: Decimal(38, 18)
  - time: DateTime64(6, 'UTC')
  - user: FixedString(42)

--------------------------------------------------------------------------------
Table: hyperliquid_funding_summary_hourly
Engine: SharedAggregatingMergeTree
Total Rows: 1,288,918
Sorting Key: coin, hour
Partition Key: toYYYYMM(hour)

Columns:
  - avg_funding_rate: SimpleAggregateFunction(any, Float64)
  - coin: LowCardinality(String)
  - hour: DateTime('UTC')
  - total_funding: SimpleAggregateFunction(sum, Decimal(38, 18))
  - unique_users: SimpleAggregateFunction(max, UInt64)

--------------------------------------------------------------------------------
Table: hyperliquid_ledger_updates
Engine: SharedReplacingMergeTree
Total Rows: 13,930,096
Sorting Key: block_number, user, time, hash
Partition Key: toYYYYMM(block_time)

Columns:
  - account_value: Nullable(Decimal(38, 18))
  - amount: 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)
  - fee: Nullable(Decimal(38, 18))
  - fee_token: Nullable(String)
  - hash: 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)
  - time: 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))

--------------------------------------------------------------------------------
Table: hyperliquid_liquidations_hourly
Engine: SharedAggregatingMergeTree
Total Rows: 92,235
Sorting Key: hour, coin
Partition Key: toYYYYMM(hour)

Columns:
  - coin: LowCardinality(String)
  - hour: DateTime
  - liquidated_volume: SimpleAggregateFunction(sum, Decimal(38, 18))
  - liquidation_count: SimpleAggregateFunction(sum, UInt64)
  - unique_liquidated_users: SimpleAggregateFunction(max, UInt64)

--------------------------------------------------------------------------------
Table: hyperliquid_market_volume_hourly
Engine: SharedAggregatingMergeTree
Total Rows: 2,191,906
Sorting Key: coin, hour
Partition Key: toYYYYMM(hour)

Columns:
  - close: SimpleAggregateFunction(anyLast, Decimal(38, 18))
  - coin: 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)
  - volume: SimpleAggregateFunction(sum, Decimal(38, 18))

--------------------------------------------------------------------------------
Table: hyperliquid_metrics_dex_overview
Engine: SharedAggregatingMergeTree
Total Rows: 125,111
Sorting Key: day, coin
Partition Key: toYYYYMM(day)

Columns:
  - coin: LowCardinality(String)
  - day: Date
  - 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))

--------------------------------------------------------------------------------
Table: hyperliquid_metrics_overview
Engine: SharedAggregatingMergeTree
Total Rows: 410
Sorting Key: day
Partition Key: toYYYYMM(day)

Columns:
  - active_traders: SimpleAggregateFunction(max, UInt64)
  - builder_fill_count: SimpleAggregateFunction(sum, UInt64)
  - coins_traded: SimpleAggregateFunction(max, UInt64)
  - day: Date
  - 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))

--------------------------------------------------------------------------------
Table: hyperliquid_oracle_prices
Engine: SharedReplacingMergeTree
Total Rows: 1,894,670
Sorting Key: block_number, clearinghouse, asset_idx
Partition Key: toYYYYMM(snapshot_time)

Columns:
  - asset_idx: UInt16
  - block_number: UInt64
  - clearinghouse: UInt8
  - coin: LowCardinality(String)
  - daily_px: String
  - indexed_at: DateTime64(3, 'UTC')
  - mark_px: String
  - snapshot_time: DateTime64(6, 'UTC')

--------------------------------------------------------------------------------
Table: hyperliquid_order_book_diffs
Engine: SharedReplacingMergeTree
Total Rows: 92,786,536,208
Sorting Key: coin, side, block_number, oid
Partition Key: toYYYYMM(block_time)

Columns:
  - block_number: UInt64
  - block_time: DateTime64(6, 'UTC')
  - coin: 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)

--------------------------------------------------------------------------------
Table: hyperliquid_orders
Engine: SharedReplacingMergeTree
Total Rows: 220,048,681,809
Sorting Key: block_number, oid, status_time
Partition Key: toYYYYMM(block_time)

Columns:
  - block_number: UInt64
  - block_time: DateTime64(6, 'UTC')
  - builder: Nullable(String)
  - children: Nullable(String)
  - cloid: Nullable(String)
  - coin: LowCardinality(String)
  - hash: 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)
  - status: 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)

--------------------------------------------------------------------------------
Table: hyperliquid_outcome_markets
Engine: View
Total Rows: 0
Sorting Key: 
Partition Key: 

Columns:
  - base_token_idx: Nullable(UInt64)
  - block_number: UInt64
  - coin: Nullable(String)
  - description: 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
  - name: 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)

--------------------------------------------------------------------------------
Table: hyperliquid_outcome_meta
Engine: SharedReplacingMergeTree
Total Rows: 285
Sorting Key: block_number, outcome_id
Partition Key: toYYYYMM(snapshot_time)

Columns:
  - block_number: UInt64
  - deploy_gas_auction_json: String
  - description: String
  - expiry: String
  - fee_share: Float64
  - indexed_at: DateTime64(3, 'UTC')
  - locked: UInt8
  - name: 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)

--------------------------------------------------------------------------------
Table: hyperliquid_outcome_question_members
Engine: SharedReplacingMergeTree
Total Rows: 84
Sorting Key: block_number, question_id, outcome_id
Partition Key: toYYYYMM(snapshot_time)

Columns:
  - 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)

--------------------------------------------------------------------------------
Table: hyperliquid_outcome_questions
Engine: SharedReplacingMergeTree
Total Rows: 21
Sorting Key: block_number, question_id
Partition Key: toYYYYMM(snapshot_time)

Columns:
  - block_number: UInt64
  - description: String
  - fallback_outcome: Nullable(UInt64)
  - indexed_at: DateTime64(3, 'UTC')
  - name: String
  - named_outcomes_json: String
  - question_id: UInt64
  - raw_question_json: String
  - settled_named_outcomes_json: String
  - snapshot_time: DateTime64(6, 'UTC')

--------------------------------------------------------------------------------
Table: hyperliquid_outcome_sides
Engine: SharedReplacingMergeTree
Total Rows: 568
Sorting Key: block_number, outcome_id, side_index
Partition Key: toYYYYMM(snapshot_time)

Columns:
  - base_token_idx: Nullable(UInt64)
  - block_number: UInt64
  - coin: 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)

--------------------------------------------------------------------------------
Table: hyperliquid_perpetual_market_contexts
Engine: View
Total Rows: 0
Sorting Key: 
Partition Key: 

Columns:
  - coin: 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)

--------------------------------------------------------------------------------
Table: hyperliquid_perpetual_markets
Engine: SharedReplacingMergeTree
Total Rows: 403
Sorting Key: coin
Partition Key: 

Columns:
  - coin: LowCardinality(String)
  - indexed_at: DateTime64(3, 'UTC')
  - margin_table_id: Nullable(UInt16)
  - market_index: UInt16
  - max_leverage: UInt16
  - only_isolated: UInt8
  - sz_decimals: UInt8

--------------------------------------------------------------------------------
Table: hyperliquid_perpetual_positions
Engine: SharedReplacingMergeTree
Total Rows: 1,266,977,929
Sorting Key: block_number, clearinghouse, user, asset_idx
Partition Key: toYYYYMM(snapshot_time)

Columns:
  - asset_idx: UInt16
  - block_number: UInt64
  - clearinghouse: UInt8
  - coin: 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

--------------------------------------------------------------------------------
Table: hyperliquid_quote_token_meta
Engine: SharedReplacingMergeTree
Total Rows: 2,200
Sorting Key: block_number, token_idx
Partition Key: toYYYYMM(snapshot_time)

Columns:
  - 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')
  - status: LowCardinality(String)
  - token_idx: UInt64
  - token_name: LowCardinality(String)

--------------------------------------------------------------------------------
Table: hyperliquid_register_referral
Engine: SharedReplacingMergeTree
Total Rows: 36,269
Sorting Key: referral_code, user
Partition Key: 

Columns:
  - 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

--------------------------------------------------------------------------------
Table: hyperliquid_set_referrer
Engine: SharedReplacingMergeTree
Total Rows: 692,985
Sorting Key: referral_code, user
Partition Key: 

Columns:
  - 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

--------------------------------------------------------------------------------
Table: hyperliquid_spot_balances
Engine: SharedReplacingMergeTree
Total Rows: 8,492,551,316
Sorting Key: block_number, user, token_idx
Partition Key: toYYYYMM(snapshot_time)

Columns:
  - block_number: UInt64
  - escrowed: Int64
  - indexed_at: DateTime64(3, 'UTC')
  - snapshot_time: DateTime64(6, 'UTC')
  - token: String
  - token_idx: UInt16
  - total: Int64
  - user: String

--------------------------------------------------------------------------------
Table: hyperliquid_spot_clearinghouse_states
Engine: SharedReplacingMergeTree
Total Rows: 8,254,177,139
Sorting Key: block_number, user, token_idx
Partition Key: toYYYYMM(snapshot_time)

Columns:
  - 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)

--------------------------------------------------------------------------------
Table: hyperliquid_spot_markets
Engine: SharedReplacingMergeTree
Total Rows: 468
Sorting Key: token_index
Partition Key: 

Columns:
  - 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

--------------------------------------------------------------------------------
Table: hyperliquid_spot_pairs
Engine: SharedReplacingMergeTree
Total Rows: 63,081
Sorting Key: block_number, spot_index
Partition Key: toYYYYMM(snapshot_time)

Columns:
  - 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

--------------------------------------------------------------------------------
Table: hyperliquid_staking_events
Engine: SharedReplacingMergeTree
Total Rows: 247,155
Sorting Key: block_number, hash
Partition Key: toYYYYMM(block_time)

Columns:
  - amount: Decimal(38, 18)
  - block_number: UInt64
  - block_time: DateTime64(6, 'UTC')
  - event_type: Enum8('CDeposit' = 1, 'CWithdrawal' = 2, 'Delegation' = 3)
  - hash: FixedString(66)
  - indexed_at: DateTime64(3, 'UTC')
  - is_finalized: Nullable(UInt8)
  - is_undelegate: Nullable(UInt8)
  - time: DateTime64(6, 'UTC')
  - user: FixedString(42)
  - validator: Nullable(FixedString(42))

--------------------------------------------------------------------------------
Table: hyperliquid_sub_accounts
Engine: SharedReplacingMergeTree
Total Rows: 171,466,887
Sorting Key: block_number, sub_account
Partition Key: toYYYYMM(snapshot_time)

Columns:
  - block_number: UInt64
  - indexed_at: DateTime64(3, 'UTC')
  - master_account: FixedString(42)
  - name: Nullable(String)
  - snapshot_time: DateTime64(6, 'UTC')
  - sub_account: FixedString(42)

--------------------------------------------------------------------------------
Table: hyperliquid_summaries
Engine: SharedReplacingMergeTree
Total Rows: 151,467,987
Sorting Key: user, polled_at
Partition Key: toYYYYMM(polled_at)

Columns:
  - 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
  - withdrawable: Decimal(38, 18)

--------------------------------------------------------------------------------
Table: hyperliquid_system_actions
Engine: SharedReplacingMergeTree
Total Rows: 1,158,185
Sorting Key: block_number, evm_tx_hash, nonce
Partition Key: toYYYYMM(block_time)

Columns:
  - 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)

--------------------------------------------------------------------------------
Table: hyperliquid_token_usdc_prices
Engine: SharedReplacingMergeTree
Total Rows: 2,211
Sorting Key: block_number, token_idx
Partition Key: toYYYYMM(snapshot_time)

Columns:
  - 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)

--------------------------------------------------------------------------------
Table: hyperliquid_trades
Engine: SharedReplacingMergeTree
Total Rows: 1,050,090,040
Sorting Key: block_number, trade_id
Partition Key: toYYYYMM(block_time)

Columns:
  - 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)
  - coin: 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)
  - timestamp: DateTime64(3, 'UTC')
  - total_builder_fee: Nullable(Decimal(38, 18))
  - trade_id: UInt64
  - transaction_hash: FixedString(66)
  - unique_id: String

--------------------------------------------------------------------------------
Table: hyperliquid_transactions
Engine: SharedReplacingMergeTree
Total Rows: 180,979,650,636
Sorting Key: round, tx_hash, nonce
Partition Key: toYYYYMM(block_time)

Columns:
  - 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)

--------------------------------------------------------------------------------
Table: hyperliquid_twap_statuses
Engine: SharedReplacingMergeTree
Total Rows: 959,878
Sorting Key: block_number, twap_id, time
Partition Key: toYYYYMM(block_time)

Columns:
  - block_number: UInt64
  - block_time: DateTime64(6, 'UTC')
  - coin: 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)
  - status: LowCardinality(String)
  - time: DateTime64(6, 'UTC')
  - timestamp: DateTime64(3, 'UTC')
  - twap_id: UInt64
  - user: FixedString(42)

--------------------------------------------------------------------------------
Table: hyperliquid_validator_rewards
Engine: SharedReplacingMergeTree
Total Rows: 9,339,446
Sorting Key: block_number, validator, time
Partition Key: toYYYYMM(block_time)

Columns:
  - block_number: UInt64
  - block_time: DateTime64(6, 'UTC')
  - hash: FixedString(66)
  - indexed_at: DateTime64(3, 'UTC')
  - reward: Decimal(38, 18)
  - time: DateTime64(6, 'UTC')
  - validator: FixedString(42)

--------------------------------------------------------------------------------
Table: hyperliquid_vault_equities
Engine: SharedReplacingMergeTree
Total Rows: 723,029,601
Sorting Key: block_number, vault_address, depositor
Partition Key: toYYYYMM(snapshot_time)

Columns:
  - 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