# Hyperliquid (HyperCore) Database Schema
# Cluster ID: hyperliquid-core-mainnet
# Total Tables: 37


================================================================================
TABLE: hyperliquid_agents
SORT KEYS: block_number, agent
PARTITION: toYYYYMM(snapshot_time)
TOTAL ROWS: 71,742,930
================================================================================
  - block_number: UInt64 [SK]
  - snapshot_time: DateTime64(6, 'UTC')
  - agent: FixedString(42) [SK]
  - user: FixedString(42)
  - name: String
  - valid_until: String
  - indexed_at: DateTime64(3, 'UTC')

================================================================================
TABLE: hyperliquid_asset_transfers
SORT KEYS: block_number, tx_hash, user
PARTITION: toYYYYMM(block_time)
TOTAL ROWS: 9,275,503
================================================================================
  - block_number: UInt64 [SK]
  - block_time: DateTime64(6, 'UTC')
  - time: DateTime64(6, 'UTC')
  - tx_hash: FixedString(66) [SK]
  - transfer_type: LowCardinality(String)
  - user: FixedString(42) [SK]
  - destination: Nullable(FixedString(42))
  - token: Nullable(String)
  - amount: Nullable(Decimal(38, 18))
  - usdc_amount: Nullable(Decimal(38, 18))
  - fee: Nullable(Decimal(38, 18))
  - nonce: Nullable(UInt64)
  - indexed_at: DateTime64(3, 'UTC')

================================================================================
TABLE: hyperliquid_blocks
SORT KEYS: block_number
PARTITION: toYYYYMM(block_time)
TOTAL ROWS: 253,279,695
================================================================================
  - block_number: UInt64 [SK]
  - block_time: DateTime64(6, 'UTC')
  - fills_count: UInt32
  - orders_count: UInt32
  - misc_events_count: UInt32
  - book_diffs_count: UInt32
  - twap_statuses_count: UInt32
  - writer_actions_count: UInt32
  - indexed_at: DateTime64(3, 'UTC')

================================================================================
TABLE: hyperliquid_bridge
SORT KEYS: block_number, bridge_type, user, nonce, eth_block_number, tx_hash
PARTITION: toYYYYMM(snapshot_time)
TOTAL ROWS: 13,553,514
================================================================================
  - block_number: UInt64 [SK]
  - snapshot_time: DateTime64(6, 'UTC')
  - bridge_type: LowCardinality(String) [SK]
  - user: FixedString(42) [SK]
  - amount_wei: UInt64
  - eth_block_number: UInt64 [SK]
  - tx_hash: String [SK]
  - nonce: UInt64 [SK]
  - event_time: String
  - indexed_at: DateTime64(3, 'UTC')

================================================================================
TABLE: hyperliquid_builder_fills
SORT KEYS: builder_address, timestamp, tid
PARTITION: toYYYYMM(block_time)
TOTAL ROWS: 156,743,892
================================================================================
  - block_number: UInt64
  - block_time: DateTime64(6, 'UTC')
  - timestamp: DateTime64(3, 'UTC') [SK]
  - created_at: DateTime64(6, 'UTC')
  - updated_at: DateTime64(6, 'UTC')
  - builder_address: Nullable(FixedString(42)) [SK]
  - builder_fee: Nullable(Decimal(38, 18))
  - user: FixedString(42)
  - closed_pnl: Decimal(38, 18)
  - coin: LowCardinality(String)
  - crossed: UInt8
  - price: Decimal(38, 18)
  - side: Enum8('B' = 1, 'A' = 2)
  - size: Decimal(38, 18)
  - twap_id: Nullable(UInt64)
  - dir: LowCardinality(String)
  - fee: Decimal(38, 18)
  - start_position: Decimal(38, 18)
  - cloid: Nullable(String)
  - is_liquidation: UInt8
  - liquidated_user: Nullable(FixedString(42))
  - liquidation_mark_price: Nullable(Decimal(38, 18))
  - liquidation_method: Nullable(String)
  - tid: UInt64 [SK]
  - oid: UInt64
  - hash: FixedString(66)
  - indexed_at: DateTime64(3, 'UTC')

================================================================================
TABLE: hyperliquid_builder_labels
SORT KEYS: builder_address
PARTITION: none
TOTAL ROWS: 295
================================================================================
  - builder_address: String [SK]
  - builder_name: String
  - builder_category: Nullable(String)
  - indexed_at: DateTime64(3, 'UTC')

================================================================================
TABLE: hyperliquid_builder_transactions
SORT KEYS: block_number, hash, user
PARTITION: toYYYYMM(block_time)
TOTAL ROWS: 111,867,110
================================================================================
  - block_number: UInt64 [SK]
  - block_time: DateTime64(6, 'UTC')
  - hash: String [SK]
  - user: String [SK]
  - builder: String
  - builder_fee: Nullable(Decimal(38, 18))
  - action_type: LowCardinality(String)
  - coin: Nullable(String)
  - is_success: UInt8
  - indexed_at: DateTime64(3, 'UTC')

================================================================================
TABLE: hyperliquid_clearinghouse_states
SORT KEYS: block_number, clearinghouse, user, asset_idx
PARTITION: toYYYYMM(snapshot_time)
TOTAL ROWS: 78,401,625
================================================================================
  - block_number: UInt64 [SK]
  - snapshot_time: DateTime64(6, 'UTC')
  - clearinghouse: UInt8 [SK]
  - user: FixedString(42) [SK]
  - asset_idx: UInt16 [SK]
  - coin: LowCardinality(String)
  - size: Int64
  - entry_notional: UInt64
  - margin: UInt64
  - funding_alltime: Int64
  - funding_since_open: Int64
  - funding_since_change: Int64
  - usdc_balance: Int64
  - indexed_at: DateTime64(3, 'UTC')

================================================================================
TABLE: hyperliquid_delegator_rewards
SORT KEYS: block_number, validator, delegator
PARTITION: toYYYYMM(snapshot_time)
TOTAL ROWS: 60,702,488
================================================================================
  - block_number: UInt64 [SK]
  - snapshot_time: DateTime64(6, 'UTC')
  - validator: FixedString(42) [SK]
  - delegator: FixedString(42) [SK]
  - c: UInt64
  - m: UInt64
  - reward_wei: UInt64
  - reward: Decimal(38, 8)
  - validator_total_delegated: UInt64
  - commission_bps: UInt16
  - indexed_at: DateTime64(3, 'UTC')
  - source: LowCardinality(String)
  - reward_timestamp: DateTime64(6, 'UTC')

================================================================================
TABLE: hyperliquid_dex_trades
SORT KEYS: none
PARTITION: none
TOTAL ROWS: 0
================================================================================
  - coin: LowCardinality(String)
  - market_type: String
  - price: Decimal(38, 18)
  - size: Decimal(38, 18)
  - usd_amount: Decimal(38, 36)
  - side: Enum8('B' = 1, 'A' = 2)
  - buyer_address: FixedString(42)
  - seller_address: FixedString(42)
  - trade_id: UInt64
  - timestamp: DateTime64(3, 'UTC')
  - transaction_hash: FixedString(66)
  - block_number: UInt64
  - block_time: DateTime64(6, 'UTC')
  - buyer_order_id: UInt64
  - seller_order_id: UInt64
  - buyer_fee: Decimal(38, 18)
  - seller_fee: Decimal(38, 18)
  - fee_token: LowCardinality(String)
  - buyer_closed_pnl: Decimal(38, 18)
  - seller_closed_pnl: Decimal(38, 18)
  - buyer_start_position: Decimal(38, 18)
  - seller_start_position: Decimal(38, 18)
  - buyer_crossed: UInt8
  - seller_crossed: UInt8
  - buyer_dir: LowCardinality(String)
  - seller_dir: LowCardinality(String)
  - buyer_twap_id: Nullable(UInt64)
  - seller_twap_id: Nullable(UInt64)
  - buyer_builder_address: Nullable(FixedString(42))
  - seller_builder_address: Nullable(FixedString(42))
  - buyer_builder_fee: Nullable(Decimal(38, 18))
  - seller_builder_fee: Nullable(Decimal(38, 18))
  - total_builder_fee: Nullable(Decimal(38, 18))
  - liquidated_user: Nullable(FixedString(42))
  - liquidation_mark_price: Nullable(Decimal(38, 18))
  - liquidation_method: Nullable(String)
  - unique_id: String
  - indexed_at: DateTime64(3, 'UTC')

================================================================================
TABLE: hyperliquid_display_names
SORT KEYS: block_number, user
PARTITION: toYYYYMM(snapshot_time)
TOTAL ROWS: 626,439
================================================================================
  - block_number: UInt64 [SK]
  - snapshot_time: DateTime64(6, 'UTC')
  - user: FixedString(42) [SK]
  - display_name: String
  - indexed_at: DateTime64(3, 'UTC')

================================================================================
TABLE: hyperliquid_fills
SORT KEYS: block_number, tid, user
PARTITION: toYYYYMM(block_time)
TOTAL ROWS: 2,240,495,212
================================================================================
  - block_number: UInt64 [SK]
  - block_time: DateTime64(6, 'UTC')
  - user: FixedString(42) [SK]
  - tid: UInt64 [SK]
  - oid: UInt64
  - coin: LowCardinality(String)
  - side: Enum8('B' = 1, 'A' = 2)
  - price: Decimal(38, 18)
  - size: Decimal(38, 18)
  - time: DateTime64(3, 'UTC')
  - dir: LowCardinality(String)
  - crossed: UInt8
  - fee: Decimal(38, 18)
  - fee_token: LowCardinality(String)
  - closed_pnl: Decimal(38, 18)
  - start_position: Decimal(38, 18)
  - hash: FixedString(66)
  - twap_id: Nullable(UInt64)
  - builder: Nullable(FixedString(42))
  - builder_fee: Nullable(Decimal(38, 18))
  - cloid: Nullable(String)
  - is_liquidation: UInt8
  - liquidated_user: Nullable(FixedString(42))
  - liquidation_mark_price: Nullable(Decimal(38, 18))
  - liquidation_method: Nullable(String)
  - indexed_at: DateTime64(3, 'UTC')

================================================================================
TABLE: hyperliquid_funding
SORT KEYS: block_number, user, coin, time
PARTITION: toYYYYMM(block_time)
TOTAL ROWS: 931,057,129
================================================================================
  - block_number: UInt64 [SK]
  - block_time: DateTime64(6, 'UTC')
  - time: DateTime64(6, 'UTC') [SK]
  - hash: FixedString(66)
  - user: FixedString(42) [SK]
  - coin: LowCardinality(String) [SK]
  - funding_amount: Decimal(38, 18)
  - funding_rate: Decimal(38, 18)
  - szi: Decimal(38, 18)
  - indexed_at: DateTime64(3, 'UTC')

================================================================================
TABLE: hyperliquid_funding_summary_hourly
SORT KEYS: coin, hour
PARTITION: toYYYYMM(hour)
TOTAL ROWS: 1,024,488
================================================================================
  - coin: LowCardinality(String) [SK]
  - hour: DateTime('UTC') [SK]
  - avg_funding_rate: Float64
  - total_funding: Decimal(38, 18)
  - unique_users: UInt64

================================================================================
TABLE: hyperliquid_ledger_updates
SORT KEYS: block_number, user, time, hash
PARTITION: toYYYYMM(block_time)
TOTAL ROWS: 11,863,496
================================================================================
  - block_number: UInt64 [SK]
  - block_time: DateTime64(6, 'UTC')
  - time: DateTime64(6, 'UTC') [SK]
  - hash: FixedString(66) [SK]
  - delta_type: LowCardinality(String)
  - user: FixedString(42) [SK]
  - usdc_amount: Nullable(Decimal(38, 18))
  - token: Nullable(String)
  - amount: Nullable(Decimal(38, 18))
  - destination: Nullable(FixedString(42))
  - fee: Nullable(Decimal(38, 18))
  - fee_token: Nullable(String)
  - native_token_fee: Nullable(Decimal(38, 18))
  - nonce: Nullable(UInt64)
  - usdc_value: Nullable(Decimal(38, 18))
  - source_dex: Nullable(String)
  - destination_dex: Nullable(String)
  - account_value: Nullable(Decimal(38, 18))
  - leverage_type: Nullable(String)
  - liquidated_ntl_pos: Nullable(Decimal(38, 18))
  - liquidated_positions: Nullable(String)
  - vault: Nullable(FixedString(42))
  - requested_usd: Nullable(Decimal(38, 18))
  - net_withdrawn_usd: Nullable(Decimal(38, 18))
  - basis: Nullable(Decimal(38, 18))
  - closing_cost: Nullable(Decimal(38, 18))
  - commission: Nullable(Decimal(38, 18))
  - to_perp: Nullable(UInt8)
  - is_deposit: Nullable(UInt8)
  - operation: Nullable(String)
  - interest_amount: Nullable(Decimal(38, 18))
  - dex: Nullable(String)
  - secondary_user: Nullable(FixedString(42))
  - indexed_at: DateTime64(3, 'UTC')

================================================================================
TABLE: hyperliquid_liquidations_hourly
SORT KEYS: hour, coin
PARTITION: toYYYYMM(hour)
TOTAL ROWS: 79,801
================================================================================
  - hour: DateTime [SK]
  - coin: LowCardinality(String) [SK]
  - liquidation_count: UInt64
  - liquidated_volume: Decimal(38, 36)
  - unique_liquidated_users: UInt64

================================================================================
TABLE: hyperliquid_market_volume_hourly
SORT KEYS: coin, hour
PARTITION: toYYYYMM(hour)
TOTAL ROWS: 1,876,779
================================================================================
  - coin: LowCardinality(String) [SK]
  - hour: DateTime('UTC') [SK]
  - volume: Decimal(38, 36)
  - trade_count: UInt64
  - high: Decimal(38, 18)
  - low: Decimal(38, 18)
  - open: Decimal(38, 18)
  - close: Decimal(38, 18)

================================================================================
TABLE: hyperliquid_metrics_dex_overview
SORT KEYS: day, coin
PARTITION: toYYYYMM(day)
TOTAL ROWS: 108,538
================================================================================
  - day: Date [SK]
  - coin: LowCardinality(String) [SK]
  - volume_usd: Decimal(38, 36)
  - fill_count: UInt64
  - unique_traders: UInt64
  - fees: Decimal(38, 18)
  - liquidations: UInt64
  - high_price: Decimal(38, 18)
  - low_price: Decimal(38, 18)

================================================================================
TABLE: hyperliquid_metrics_overview
SORT KEYS: day
PARTITION: toYYYYMM(day)
TOTAL ROWS: 376
================================================================================
  - day: Date [SK]
  - total_volume_usd: Decimal(38, 36)
  - total_fills: UInt64
  - active_traders: UInt64
  - total_fees: Decimal(38, 18)
  - liquidation_count: UInt64
  - liquidation_volume_usd: Decimal(38, 36)
  - coins_traded: UInt64
  - total_builder_fees: Nullable(Decimal(38, 18))
  - builder_fill_count: UInt64

================================================================================
TABLE: hyperliquid_oracle_prices
SORT KEYS: block_number, clearinghouse, asset_idx
PARTITION: toYYYYMM(snapshot_time)
TOTAL ROWS: 128,060
================================================================================
  - block_number: UInt64 [SK]
  - snapshot_time: DateTime64(6, 'UTC')
  - clearinghouse: UInt8 [SK]
  - asset_idx: UInt16 [SK]
  - coin: LowCardinality(String)
  - mark_px: String
  - daily_px: String
  - indexed_at: DateTime64(3, 'UTC')

================================================================================
TABLE: hyperliquid_order_book_diffs
SORT KEYS: coin, side, block_number, oid
PARTITION: toYYYYMM(block_time)
TOTAL ROWS: 73,644,087,693
================================================================================
  - block_number: UInt64 [SK]
  - block_time: DateTime64(6, 'UTC')
  - user: FixedString(42)
  - oid: UInt64 [SK]
  - coin: LowCardinality(String) [SK]
  - side: Enum8('B' = 1, 'A' = 2) [SK]
  - price: Decimal(38, 18)
  - diff_type: LowCardinality(String)
  - size: Nullable(Decimal(38, 18))
  - orig_size: Nullable(Decimal(38, 18))
  - new_size: Nullable(Decimal(38, 18))
  - indexed_at: DateTime64(3, 'UTC')

================================================================================
TABLE: hyperliquid_orders
SORT KEYS: block_number, oid, status_time
PARTITION: toYYYYMM(block_time)
TOTAL ROWS: 162,937,440,906
================================================================================
  - block_number: UInt64 [SK]
  - block_time: DateTime64(6, 'UTC')
  - oid: UInt64 [SK]
  - user: FixedString(42)
  - coin: LowCardinality(String)
  - side: Enum8('B' = 1, 'A' = 2)
  - status: LowCardinality(String)
  - order_type: LowCardinality(String)
  - limit_price: Decimal(38, 18)
  - size: Decimal(38, 18)
  - orig_size: Decimal(38, 18)
  - tif: LowCardinality(String)
  - is_trigger: UInt8
  - trigger_price: Nullable(Decimal(38, 18))
  - trigger_condition: Nullable(String)
  - reduce_only: UInt8
  - is_position_tpsl: UInt8
  - children: Nullable(String)
  - cloid: Nullable(String)
  - hash: Nullable(FixedString(66))
  - builder: Nullable(String)
  - order_timestamp: DateTime64(3, 'UTC')
  - status_time: DateTime64(6, 'UTC') [SK]
  - unique_id: String
  - indexed_at: DateTime64(3, 'UTC')

================================================================================
TABLE: hyperliquid_perpetual_market_contexts
SORT KEYS: coin, polled_at
PARTITION: toYYYYMM(polled_at)
TOTAL ROWS: 224,867,901
================================================================================
  - polled_at: DateTime64(3, 'UTC') [SK]
  - coin: LowCardinality(String) [SK]
  - funding: Decimal(38, 18)
  - open_interest: Decimal(38, 18)
  - day_ntl_vlm: Decimal(38, 18)
  - day_base_vlm: Decimal(38, 18)
  - premium: Decimal(38, 18)
  - oracle_px: Decimal(38, 18)
  - mark_px: Decimal(38, 18)
  - mid_px: Decimal(38, 18)
  - prev_day_px: Decimal(38, 18)
  - impact_bid: Nullable(Decimal(38, 18))
  - impact_ask: Nullable(Decimal(38, 18))
  - indexed_at: DateTime64(3, 'UTC')

================================================================================
TABLE: hyperliquid_perpetual_markets
SORT KEYS: coin
PARTITION: none
TOTAL ROWS: 229
================================================================================
  - market_index: UInt16
  - coin: LowCardinality(String) [SK]
  - max_leverage: UInt16
  - sz_decimals: UInt8
  - margin_table_id: Nullable(UInt16)
  - only_isolated: UInt8
  - indexed_at: DateTime64(3, 'UTC')

================================================================================
TABLE: hyperliquid_register_referral
SORT KEYS: referral_code, user
PARTITION: none
TOTAL ROWS: 32,961
================================================================================
  - round: UInt64
  - block_time: DateTime64(6, 'UTC')
  - tx_hash: String
  - user: String [SK]
  - referral_code: String [SK]
  - is_success: UInt8
  - error: Nullable(String)
  - indexed_at: DateTime64(3, 'UTC')

================================================================================
TABLE: hyperliquid_set_referrer
SORT KEYS: referral_code, user
PARTITION: none
TOTAL ROWS: 544,288
================================================================================
  - round: UInt64
  - block_time: DateTime64(6, 'UTC')
  - tx_hash: String
  - user: String [SK]
  - referral_code: String [SK]
  - is_success: UInt8
  - error: Nullable(String)
  - indexed_at: DateTime64(3, 'UTC')

================================================================================
TABLE: hyperliquid_spot_clearinghouse_states
SORT KEYS: block_number, user, token_idx
PARTITION: toYYYYMM(snapshot_time)
TOTAL ROWS: 616,173,913
================================================================================
  - block_number: UInt64 [SK]
  - snapshot_time: DateTime64(6, 'UTC')
  - user: FixedString(42) [SK]
  - token_idx: UInt16 [SK]
  - token: LowCardinality(String)
  - total: Int64
  - escrowed: Int64
  - indexed_at: DateTime64(3, 'UTC')

================================================================================
TABLE: hyperliquid_spot_markets
SORT KEYS: token_index
PARTITION: none
TOTAL ROWS: 901
================================================================================
  - token_index: UInt16 [SK]
  - token: LowCardinality(String)
  - token_id: String
  - sz_decimals: UInt8
  - wei_decimals: UInt8
  - is_canonical: UInt8
  - evm_contract: Nullable(String)
  - full_name: Nullable(String)
  - deployer_trading_fee_share: Nullable(String)
  - pair_index: Nullable(UInt16)
  - pair_name: Nullable(String)
  - indexed_at: DateTime64(3, 'UTC')

================================================================================
TABLE: hyperliquid_staking_events
SORT KEYS: block_number, hash
PARTITION: toYYYYMM(block_time)
TOTAL ROWS: 213,129
================================================================================
  - block_number: UInt64 [SK]
  - block_time: DateTime64(6, 'UTC')
  - time: DateTime64(6, 'UTC')
  - hash: FixedString(66) [SK]
  - event_type: Enum8('CDeposit' = 1, 'CWithdrawal' = 2, 'Delegation' = 3)
  - user: FixedString(42)
  - amount: Decimal(38, 18)
  - is_finalized: Nullable(UInt8)
  - validator: Nullable(FixedString(42))
  - is_undelegate: Nullable(UInt8)
  - indexed_at: DateTime64(3, 'UTC')

================================================================================
TABLE: hyperliquid_sub_accounts
SORT KEYS: block_number, sub_account
PARTITION: toYYYYMM(snapshot_time)
TOTAL ROWS: 11,149,386
================================================================================
  - block_number: UInt64 [SK]
  - snapshot_time: DateTime64(6, 'UTC')
  - sub_account: FixedString(42) [SK]
  - master_account: FixedString(42)
  - name: Nullable(String)
  - indexed_at: DateTime64(3, 'UTC')

================================================================================
TABLE: hyperliquid_summaries
SORT KEYS: user, polled_at
PARTITION: toYYYYMM(polled_at)
TOTAL ROWS: 1,209,385
================================================================================
  - polled_at: DateTime64(3, 'UTC') [SK]
  - user: String [SK]
  - 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)
  - 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)
  - withdrawable: Decimal(38, 18)
  - indexed_at: DateTime64(3, 'UTC')

================================================================================
TABLE: hyperliquid_system_actions
SORT KEYS: block_number, evm_tx_hash, nonce
PARTITION: toYYYYMM(block_time)
TOTAL ROWS: 840,536
================================================================================
  - block_number: UInt64 [SK]
  - block_time: DateTime64(6, 'UTC')
  - user: FixedString(42)
  - nonce: UInt64 [SK]
  - evm_tx_hash: FixedString(66) [SK]
  - action_type: LowCardinality(String)
  - action: String
  - destination: Nullable(FixedString(42))
  - token: Nullable(UInt16)
  - wei: Nullable(UInt256)
  - from_sub_account: Nullable(UInt8)
  - source_dex_or_spot: Nullable(UInt8)
  - destination_dex_or_spot: Nullable(UInt8)
  - validator: Nullable(FixedString(42))
  - is_undelegate: Nullable(UInt8)
  - signature_chain_id: Nullable(String)
  - hyperliquid_chain: Nullable(String)
  - ntl: Nullable(Decimal(38, 18))
  - to_perp: Nullable(UInt8)
  - order_grouping: Nullable(String)
  - agent_address: Nullable(FixedString(42))
  - agent_name: Nullable(String)
  - is_mint: Nullable(UInt8)
  - indexed_at: DateTime64(3, 'UTC')

================================================================================
TABLE: hyperliquid_trades
SORT KEYS: block_number, trade_id
PARTITION: toYYYYMM(block_time)
TOTAL ROWS: 903,301,726
================================================================================
  - block_number: UInt64 [SK]
  - block_time: DateTime64(6, 'UTC')
  - trade_id: UInt64 [SK]
  - coin: LowCardinality(String)
  - timestamp: DateTime64(3, 'UTC')
  - transaction_hash: FixedString(66)
  - price: Decimal(38, 18)
  - size: Decimal(38, 18)
  - side: Enum8('B' = 1, 'A' = 2)
  - buyer_address: FixedString(42)
  - buyer_order_id: UInt64
  - buyer_fee: Decimal(38, 18)
  - buyer_closed_pnl: Decimal(38, 18)
  - buyer_start_position: Decimal(38, 18)
  - buyer_crossed: UInt8
  - buyer_dir: LowCardinality(String)
  - buyer_twap_id: Nullable(UInt64)
  - buyer_builder_address: Nullable(FixedString(42))
  - buyer_builder_fee: Nullable(Decimal(38, 18))
  - seller_address: FixedString(42)
  - seller_order_id: UInt64
  - seller_fee: Decimal(38, 18)
  - seller_closed_pnl: Decimal(38, 18)
  - seller_start_position: Decimal(38, 18)
  - seller_crossed: UInt8
  - seller_dir: LowCardinality(String)
  - seller_twap_id: Nullable(UInt64)
  - seller_builder_address: Nullable(FixedString(42))
  - seller_builder_fee: Nullable(Decimal(38, 18))
  - fee_token: LowCardinality(String)
  - total_builder_fee: Nullable(Decimal(38, 18))
  - liquidated_user: Nullable(FixedString(42))
  - liquidation_mark_price: Nullable(Decimal(38, 18))
  - liquidation_method: Nullable(String)
  - unique_id: String
  - indexed_at: DateTime64(3, 'UTC')

================================================================================
TABLE: hyperliquid_transactions
SORT KEYS: round, tx_hash, nonce
PARTITION: toYYYYMM(block_time)
TOTAL ROWS: 139,395,524,297
================================================================================
  - round: UInt64 [SK]
  - block_time: DateTime64(6, 'UTC')
  - proposer: Nullable(String)
  - tx_hash: String [SK]
  - user: Nullable(String)
  - action_type: LowCardinality(String)
  - action: JSON
  - error: Nullable(String)
  - is_success: UInt8
  - nonce: UInt64 [SK]
  - vault_address: Nullable(String)
  - indexed_at: DateTime64(3, 'UTC')

================================================================================
TABLE: hyperliquid_twap_statuses
SORT KEYS: block_number, twap_id, time
PARTITION: toYYYYMM(block_time)
TOTAL ROWS: 774,809
================================================================================
  - block_number: UInt64 [SK]
  - block_time: DateTime64(6, 'UTC')
  - time: DateTime64(6, 'UTC') [SK]
  - twap_id: UInt64 [SK]
  - status: LowCardinality(String)
  - user: FixedString(42)
  - coin: LowCardinality(String)
  - side: Enum8('B' = 1, 'A' = 2)
  - size: Decimal(38, 18)
  - executed_size: Decimal(38, 18)
  - executed_ntl: Decimal(38, 18)
  - minutes: UInt16
  - randomize: UInt8
  - reduce_only: UInt8
  - timestamp: DateTime64(3, 'UTC')
  - indexed_at: DateTime64(3, 'UTC')

================================================================================
TABLE: hyperliquid_validator_rewards
SORT KEYS: block_number, validator, time
PARTITION: toYYYYMM(block_time)
TOTAL ROWS: 7,794,820
================================================================================
  - block_number: UInt64 [SK]
  - block_time: DateTime64(6, 'UTC')
  - time: DateTime64(6, 'UTC') [SK]
  - hash: FixedString(66)
  - validator: FixedString(42) [SK]
  - reward: Decimal(38, 18)
  - indexed_at: DateTime64(3, 'UTC')

================================================================================
TABLE: hyperliquid_vault_equities
SORT KEYS: block_number, vault_address, depositor
PARTITION: toYYYYMM(snapshot_time)
TOTAL ROWS: 47,459,738
================================================================================
  - block_number: UInt64 [SK]
  - snapshot_time: DateTime64(6, 'UTC')
  - vault_address: FixedString(42) [SK]
  - vault_name: String
  - leader: FixedString(42)
  - depositor: FixedString(42) [SK]
  - ownership_fraction: Float64
  - net_deposits: Int64
  - leader_commission: Float64
  - indexed_at: DateTime64(3, 'UTC')