[{"chain":"Hyperliquid (HyperCore)","cluster_id":"hyperliquid-core-mainnet","tables":[{"name":"hyperliquid_agents","engine":"SharedReplacingMergeTree","total_rows":4805167276,"sorting_key":["block_number","agent"],"partition_key":"toYYYYMM(snapshot_time)","columns":[{"name":"agent","type":"FixedString(42)"},{"name":"block_number","type":"UInt64"},{"name":"indexed_at","type":"DateTime64(3, 'UTC')"},{"name":"name","type":"String"},{"name":"snapshot_time","type":"DateTime64(6, 'UTC')"},{"name":"user","type":"FixedString(42)"},{"name":"valid_until","type":"String"}]},{"name":"hyperliquid_asset_transfers","engine":"SharedReplacingMergeTree","total_rows":15832630,"sorting_key":["block_number","tx_hash","user"],"partition_key":"toYYYYMM(block_time)","columns":[{"name":"amount","type":"Nullable(Decimal(38, 18))"},{"name":"block_number","type":"UInt64"},{"name":"block_time","type":"DateTime64(6, 'UTC')"},{"name":"destination","type":"Nullable(FixedString(42))"},{"name":"fee","type":"Nullable(Decimal(38, 18))"},{"name":"indexed_at","type":"DateTime64(3, 'UTC')"},{"name":"nonce","type":"Nullable(UInt64)"},{"name":"time","type":"DateTime64(6, 'UTC')"},{"name":"token","type":"Nullable(String)"},{"name":"transfer_type","type":"LowCardinality(String)"},{"name":"tx_hash","type":"FixedString(66)"},{"name":"usdc_amount","type":"Nullable(Decimal(38, 18))"},{"name":"user","type":"FixedString(42)"}]},{"name":"hyperliquid_blocks","engine":"SharedSummingMergeTree","total_rows":397283863,"sorting_key":["block_number"],"partition_key":"toYYYYMM(block_time)","columns":[{"name":"block_number","type":"UInt64"},{"name":"block_time","type":"DateTime64(6, 'UTC')"},{"name":"book_diffs_count","type":"UInt32"},{"name":"fills_count","type":"UInt32"},{"name":"indexed_at","type":"DateTime64(3, 'UTC')"},{"name":"misc_events_count","type":"UInt32"},{"name":"orders_count","type":"UInt32"},{"name":"twap_statuses_count","type":"UInt32"},{"name":"writer_actions_count","type":"UInt32"}]},{"name":"hyperliquid_bridge","engine":"SharedReplacingMergeTree","total_rows":450496434,"sorting_key":["block_number","bridge_type","user","nonce","eth_block_number","tx_hash"],"partition_key":"toYYYYMM(snapshot_time)","columns":[{"name":"amount_wei","type":"UInt64"},{"name":"block_number","type":"UInt64"},{"name":"bridge_type","type":"LowCardinality(String)"},{"name":"eth_block_number","type":"UInt64"},{"name":"event_time","type":"String"},{"name":"indexed_at","type":"DateTime64(3, 'UTC')"},{"name":"nonce","type":"UInt64"},{"name":"snapshot_time","type":"DateTime64(6, 'UTC')"},{"name":"tx_hash","type":"String"},{"name":"user","type":"FixedString(42)"}]},{"name":"hyperliquid_builder_fills","engine":"SharedReplacingMergeTree","total_rows":242085186,"sorting_key":["builder_address","timestamp","tid"],"partition_key":"toYYYYMM(block_time)","columns":[{"name":"block_number","type":"UInt64"},{"name":"block_time","type":"DateTime64(6, 'UTC')"},{"name":"builder_address","type":"Nullable(FixedString(42))"},{"name":"builder_fee","type":"Nullable(Decimal(38, 18))"},{"name":"cloid","type":"Nullable(String)"},{"name":"closed_pnl","type":"Decimal(38, 18)"},{"name":"coin","type":"LowCardinality(String)"},{"name":"created_at","type":"DateTime64(6, 'UTC')"},{"name":"crossed","type":"UInt8"},{"name":"dir","type":"LowCardinality(String)"},{"name":"fee","type":"Decimal(38, 18)"},{"name":"hash","type":"FixedString(66)"},{"name":"indexed_at","type":"DateTime64(3, 'UTC')"},{"name":"is_liquidation","type":"UInt8"},{"name":"liquidated_user","type":"Nullable(FixedString(42))"},{"name":"liquidation_mark_price","type":"Nullable(Decimal(38, 18))"},{"name":"liquidation_method","type":"Nullable(String)"},{"name":"oid","type":"UInt64"},{"name":"price","type":"Decimal(38, 18)"},{"name":"side","type":"Enum8('B' = 1, 'A' = 2)"},{"name":"size","type":"Decimal(38, 18)"},{"name":"start_position","type":"Decimal(38, 18)"},{"name":"tid","type":"UInt64"},{"name":"timestamp","type":"DateTime64(3, 'UTC')"},{"name":"twap_id","type":"Nullable(UInt64)"},{"name":"updated_at","type":"DateTime64(6, 'UTC')"},{"name":"user","type":"FixedString(42)"}]},{"name":"hyperliquid_builder_transactions","engine":"SharedReplacingMergeTree","total_rows":167936303,"sorting_key":["block_number","hash","user"],"partition_key":"toYYYYMM(block_time)","columns":[{"name":"action_type","type":"LowCardinality(String)"},{"name":"block_number","type":"UInt64"},{"name":"block_time","type":"DateTime64(6, 'UTC')"},{"name":"builder","type":"String"},{"name":"builder_fee","type":"Nullable(Decimal(38, 18))"},{"name":"coin","type":"Nullable(String)"},{"name":"hash","type":"String"},{"name":"indexed_at","type":"DateTime64(3, 'UTC')"},{"name":"is_success","type":"UInt8"},{"name":"user","type":"String"}]},{"name":"hyperliquid_clearinghouse_states","engine":"SharedReplacingMergeTree","total_rows":4290297558,"sorting_key":["block_number","clearinghouse","user","asset_idx"],"partition_key":"toYYYYMM(snapshot_time)","columns":[{"name":"asset_idx","type":"UInt16"},{"name":"block_number","type":"UInt64"},{"name":"clearinghouse","type":"UInt8"},{"name":"coin","type":"LowCardinality(String)"},{"name":"entry_notional","type":"UInt64"},{"name":"funding_alltime","type":"Int64"},{"name":"funding_since_change","type":"Int64"},{"name":"funding_since_open","type":"Int64"},{"name":"indexed_at","type":"DateTime64(3, 'UTC')"},{"name":"margin","type":"UInt64"},{"name":"size","type":"Int64"},{"name":"snapshot_time","type":"DateTime64(6, 'UTC')"},{"name":"usdc_balance","type":"Int64"},{"name":"user","type":"FixedString(42)"}]},{"name":"hyperliquid_delegator_rewards","engine":"SharedReplacingMergeTree","total_rows":1147120226,"sorting_key":["block_number","validator","delegator"],"partition_key":"toYYYYMM(snapshot_time)","columns":[{"name":"block_number","type":"UInt64"},{"name":"c","type":"UInt64"},{"name":"commission_bps","type":"UInt16"},{"name":"delegator","type":"FixedString(42)"},{"name":"e","type":"UInt64"},{"name":"indexed_at","type":"DateTime64(3, 'UTC')"},{"name":"m","type":"UInt64"},{"name":"reward","type":"Decimal(38, 8)"},{"name":"reward_wei","type":"UInt64"},{"name":"snapshot_time","type":"DateTime64(6, 'UTC')"},{"name":"source","type":"LowCardinality(String)"},{"name":"validator","type":"FixedString(42)"},{"name":"validator_total_delegated","type":"UInt64"}]},{"name":"hyperliquid_dex_trades","engine":"View","total_rows":0,"sorting_key":[],"partition_key":"","columns":[{"name":"block_number","type":"UInt64"},{"name":"block_time","type":"DateTime64(6, 'UTC')"},{"name":"buyer_address","type":"FixedString(42)"},{"name":"buyer_builder_address","type":"Nullable(FixedString(42))"},{"name":"buyer_builder_fee","type":"Nullable(Decimal(38, 18))"},{"name":"buyer_closed_pnl","type":"Decimal(38, 18)"},{"name":"buyer_crossed","type":"UInt8"},{"name":"buyer_dir","type":"LowCardinality(String)"},{"name":"buyer_fee","type":"Decimal(38, 18)"},{"name":"buyer_order_id","type":"UInt64"},{"name":"buyer_start_position","type":"Decimal(38, 18)"},{"name":"buyer_twap_id","type":"Nullable(UInt64)"},{"name":"coin","type":"LowCardinality(String)"},{"name":"fee_token","type":"LowCardinality(String)"},{"name":"indexed_at","type":"DateTime64(3, 'UTC')"},{"name":"liquidated_user","type":"Nullable(FixedString(42))"},{"name":"liquidation_mark_price","type":"Nullable(Decimal(38, 18))"},{"name":"liquidation_method","type":"Nullable(String)"},{"name":"market_type","type":"String"},{"name":"price","type":"Decimal(38, 18)"},{"name":"seller_address","type":"FixedString(42)"},{"name":"seller_builder_address","type":"Nullable(FixedString(42))"},{"name":"seller_builder_fee","type":"Nullable(Decimal(38, 18))"},{"name":"seller_closed_pnl","type":"Decimal(38, 18)"},{"name":"seller_crossed","type":"UInt8"},{"name":"seller_dir","type":"LowCardinality(String)"},{"name":"seller_fee","type":"Decimal(38, 18)"},{"name":"seller_order_id","type":"UInt64"},{"name":"seller_start_position","type":"Decimal(38, 18)"},{"name":"seller_twap_id","type":"Nullable(UInt64)"},{"name":"side","type":"Enum8('B' = 1, 'A' = 2)"},{"name":"size","type":"Decimal(38, 18)"},{"name":"timestamp","type":"DateTime64(3, 'UTC')"},{"name":"total_builder_fee","type":"Nullable(Decimal(38, 18))"},{"name":"trade_id","type":"UInt64"},{"name":"transaction_hash","type":"FixedString(66)"},{"name":"unique_id","type":"String"},{"name":"usd_amount","type":"Decimal(38, 18)"}]},{"name":"hyperliquid_display_names","engine":"SharedReplacingMergeTree","total_rows":36304130,"sorting_key":["block_number","user"],"partition_key":"toYYYYMM(snapshot_time)","columns":[{"name":"block_number","type":"UInt64"},{"name":"display_name","type":"String"},{"name":"indexed_at","type":"DateTime64(3, 'UTC')"},{"name":"snapshot_time","type":"DateTime64(6, 'UTC')"},{"name":"user","type":"FixedString(42)"}]},{"name":"hyperliquid_fills","engine":"SharedReplacingMergeTree","total_rows":3654458849,"sorting_key":["block_number","tid","user"],"partition_key":"toYYYYMM(block_time)","columns":[{"name":"block_number","type":"UInt64"},{"name":"block_time","type":"DateTime64(6, 'UTC')"},{"name":"builder","type":"Nullable(FixedString(42))"},{"name":"builder_fee","type":"Nullable(Decimal(38, 18))"},{"name":"cloid","type":"Nullable(String)"},{"name":"closed_pnl","type":"Decimal(38, 18)"},{"name":"coin","type":"LowCardinality(String)"},{"name":"crossed","type":"UInt8"},{"name":"deployer_fee","type":"Nullable(Decimal(38, 18))"},{"name":"dir","type":"LowCardinality(String)"},{"name":"fee","type":"Decimal(38, 18)"},{"name":"fee_token","type":"LowCardinality(String)"},{"name":"hash","type":"FixedString(66)"},{"name":"indexed_at","type":"DateTime64(3, 'UTC')"},{"name":"is_liquidation","type":"UInt8"},{"name":"liquidated_user","type":"Nullable(FixedString(42))"},{"name":"liquidation_mark_price","type":"Nullable(Decimal(38, 18))"},{"name":"liquidation_method","type":"Nullable(String)"},{"name":"oid","type":"UInt64"},{"name":"price","type":"Decimal(38, 18)"},{"name":"priority_gas","type":"Nullable(Decimal(38, 18))"},{"name":"side","type":"Enum8('B' = 1, 'A' = 2)"},{"name":"size","type":"Decimal(38, 18)"},{"name":"start_position","type":"Decimal(38, 18)"},{"name":"tid","type":"UInt64"},{"name":"time","type":"DateTime64(3, 'UTC')"},{"name":"twap_id","type":"Nullable(UInt64)"},{"name":"user","type":"FixedString(42)"}]},{"name":"hyperliquid_funding","engine":"SharedReplacingMergeTree","total_rows":1727257754,"sorting_key":["block_number","user","coin","time"],"partition_key":"toYYYYMM(block_time)","columns":[{"name":"block_number","type":"UInt64"},{"name":"block_time","type":"DateTime64(6, 'UTC')"},{"name":"coin","type":"LowCardinality(String)"},{"name":"funding_amount","type":"Decimal(38, 18)"},{"name":"funding_rate","type":"Decimal(38, 18)"},{"name":"hash","type":"FixedString(66)"},{"name":"indexed_at","type":"DateTime64(3, 'UTC')"},{"name":"szi","type":"Decimal(38, 18)"},{"name":"time","type":"DateTime64(6, 'UTC')"},{"name":"user","type":"FixedString(42)"}]},{"name":"hyperliquid_funding_summary_hourly","engine":"SharedAggregatingMergeTree","total_rows":1900086,"sorting_key":["coin","hour"],"partition_key":"toYYYYMM(hour)","columns":[{"name":"avg_funding_rate","type":"SimpleAggregateFunction(any, Float64)"},{"name":"coin","type":"LowCardinality(String)"},{"name":"hour","type":"DateTime('UTC')"},{"name":"total_funding","type":"SimpleAggregateFunction(sum, Decimal(38, 18))"},{"name":"unique_users","type":"SimpleAggregateFunction(max, UInt64)"}]},{"name":"hyperliquid_ledger_updates","engine":"SharedReplacingMergeTree","total_rows":19602366,"sorting_key":["block_number","user","time","hash"],"partition_key":"toYYYYMM(block_time)","columns":[{"name":"account_value","type":"Nullable(Decimal(38, 18))"},{"name":"amount","type":"Nullable(Decimal(38, 18))"},{"name":"basis","type":"Nullable(Decimal(38, 18))"},{"name":"block_number","type":"UInt64"},{"name":"block_time","type":"DateTime64(6, 'UTC')"},{"name":"closing_cost","type":"Nullable(Decimal(38, 18))"},{"name":"commission","type":"Nullable(Decimal(38, 18))"},{"name":"delta_type","type":"LowCardinality(String)"},{"name":"destination","type":"Nullable(FixedString(42))"},{"name":"destination_dex","type":"Nullable(String)"},{"name":"dex","type":"Nullable(String)"},{"name":"fee","type":"Nullable(Decimal(38, 18))"},{"name":"fee_token","type":"Nullable(String)"},{"name":"hash","type":"FixedString(66)"},{"name":"indexed_at","type":"DateTime64(3, 'UTC')"},{"name":"interest_amount","type":"Nullable(Decimal(38, 18))"},{"name":"is_deposit","type":"Nullable(UInt8)"},{"name":"leverage_type","type":"Nullable(String)"},{"name":"liquidated_ntl_pos","type":"Nullable(Decimal(38, 18))"},{"name":"liquidated_positions","type":"Nullable(String)"},{"name":"native_token_fee","type":"Nullable(Decimal(38, 18))"},{"name":"net_withdrawn_usd","type":"Nullable(Decimal(38, 18))"},{"name":"nonce","type":"Nullable(UInt64)"},{"name":"operation","type":"Nullable(String)"},{"name":"requested_usd","type":"Nullable(Decimal(38, 18))"},{"name":"secondary_user","type":"Nullable(FixedString(42))"},{"name":"source_dex","type":"Nullable(String)"},{"name":"time","type":"DateTime64(6, 'UTC')"},{"name":"to_perp","type":"Nullable(UInt8)"},{"name":"token","type":"Nullable(String)"},{"name":"usdc_amount","type":"Nullable(Decimal(38, 18))"},{"name":"usdc_value","type":"Nullable(Decimal(38, 18))"},{"name":"user","type":"FixedString(42)"},{"name":"vault","type":"Nullable(FixedString(42))"}]},{"name":"hyperliquid_liquidations_hourly","engine":"SharedAggregatingMergeTree","total_rows":130672,"sorting_key":["hour","coin"],"partition_key":"toYYYYMM(hour)","columns":[{"name":"coin","type":"LowCardinality(String)"},{"name":"hour","type":"DateTime"},{"name":"liquidated_volume","type":"SimpleAggregateFunction(sum, Decimal(38, 18))"},{"name":"liquidation_count","type":"SimpleAggregateFunction(sum, UInt64)"},{"name":"unique_liquidated_users","type":"SimpleAggregateFunction(max, UInt64)"}]},{"name":"hyperliquid_market_volume_hourly","engine":"SharedAggregatingMergeTree","total_rows":3296347,"sorting_key":["coin","hour"],"partition_key":"toYYYYMM(hour)","columns":[{"name":"close","type":"SimpleAggregateFunction(anyLast, Decimal(38, 18))"},{"name":"coin","type":"LowCardinality(String)"},{"name":"high","type":"SimpleAggregateFunction(max, Decimal(38, 18))"},{"name":"hour","type":"DateTime('UTC')"},{"name":"low","type":"SimpleAggregateFunction(min, Decimal(38, 18))"},{"name":"open","type":"SimpleAggregateFunction(any, Decimal(38, 18))"},{"name":"trade_count","type":"SimpleAggregateFunction(sum, UInt64)"},{"name":"volume","type":"SimpleAggregateFunction(sum, Decimal(38, 18))"}]},{"name":"hyperliquid_metrics_dex_overview","engine":"SharedAggregatingMergeTree","total_rows":178404,"sorting_key":["day","coin"],"partition_key":"toYYYYMM(day)","columns":[{"name":"coin","type":"LowCardinality(String)"},{"name":"day","type":"Date"},{"name":"fees","type":"SimpleAggregateFunction(sum, Decimal(38, 18))"},{"name":"fill_count","type":"SimpleAggregateFunction(sum, UInt64)"},{"name":"high_price","type":"SimpleAggregateFunction(max, Decimal(38, 18))"},{"name":"liquidations","type":"SimpleAggregateFunction(sum, UInt64)"},{"name":"low_price","type":"SimpleAggregateFunction(min, Decimal(38, 18))"},{"name":"unique_traders","type":"SimpleAggregateFunction(max, UInt64)"},{"name":"volume_usd","type":"SimpleAggregateFunction(sum, Decimal(38, 18))"}]},{"name":"hyperliquid_metrics_overview","engine":"SharedAggregatingMergeTree","total_rows":500,"sorting_key":["day"],"partition_key":"toYYYYMM(day)","columns":[{"name":"active_traders","type":"SimpleAggregateFunction(max, UInt64)"},{"name":"builder_fill_count","type":"SimpleAggregateFunction(sum, UInt64)"},{"name":"coins_traded","type":"SimpleAggregateFunction(max, UInt64)"},{"name":"day","type":"Date"},{"name":"liquidation_count","type":"SimpleAggregateFunction(sum, UInt64)"},{"name":"liquidation_volume_usd","type":"SimpleAggregateFunction(sum, Decimal(38, 18))"},{"name":"total_builder_fees","type":"SimpleAggregateFunction(sum, Decimal(38, 18))"},{"name":"total_fees","type":"SimpleAggregateFunction(sum, Decimal(38, 18))"},{"name":"total_fills","type":"SimpleAggregateFunction(sum, UInt64)"},{"name":"total_volume_usd","type":"SimpleAggregateFunction(sum, Decimal(38, 18))"}]},{"name":"hyperliquid_oracle_prices","engine":"SharedReplacingMergeTree","total_rows":6376413,"sorting_key":["block_number","clearinghouse","asset_idx"],"partition_key":"toYYYYMM(snapshot_time)","columns":[{"name":"asset_idx","type":"UInt16"},{"name":"block_number","type":"UInt64"},{"name":"clearinghouse","type":"UInt8"},{"name":"coin","type":"LowCardinality(String)"},{"name":"daily_px","type":"String"},{"name":"indexed_at","type":"DateTime64(3, 'UTC')"},{"name":"mark_px","type":"String"},{"name":"snapshot_time","type":"DateTime64(6, 'UTC')"}]},{"name":"hyperliquid_order_book_diffs","engine":"SharedReplacingMergeTree","total_rows":143174008337,"sorting_key":["coin","side","block_number","oid"],"partition_key":"toYYYYMM(block_time)","columns":[{"name":"block_number","type":"UInt64"},{"name":"block_time","type":"DateTime64(6, 'UTC')"},{"name":"coin","type":"LowCardinality(String)"},{"name":"diff_type","type":"LowCardinality(String)"},{"name":"indexed_at","type":"DateTime64(3, 'UTC')"},{"name":"new_size","type":"Nullable(Decimal(38, 18))"},{"name":"oid","type":"UInt64"},{"name":"orig_size","type":"Nullable(Decimal(38, 18))"},{"name":"price","type":"Decimal(38, 18)"},{"name":"side","type":"Enum8('B' = 1, 'A' = 2)"},{"name":"size","type":"Nullable(Decimal(38, 18))"},{"name":"user","type":"FixedString(42)"}]},{"name":"hyperliquid_orders","engine":"SharedReplacingMergeTree","total_rows":327868319577,"sorting_key":["block_number","oid","status_time"],"partition_key":"toYYYYMM(block_time)","columns":[{"name":"block_number","type":"UInt64"},{"name":"block_time","type":"DateTime64(6, 'UTC')"},{"name":"builder","type":"Nullable(String)"},{"name":"children","type":"Nullable(String)"},{"name":"cloid","type":"Nullable(String)"},{"name":"coin","type":"LowCardinality(String)"},{"name":"hash","type":"Nullable(FixedString(66))"},{"name":"indexed_at","type":"DateTime64(3, 'UTC')"},{"name":"is_position_tpsl","type":"UInt8"},{"name":"is_trigger","type":"UInt8"},{"name":"limit_price","type":"Decimal(38, 18)"},{"name":"oid","type":"UInt64"},{"name":"order_timestamp","type":"DateTime64(3, 'UTC')"},{"name":"order_type","type":"LowCardinality(String)"},{"name":"orig_size","type":"Decimal(38, 18)"},{"name":"reduce_only","type":"UInt8"},{"name":"side","type":"Enum8('B' = 1, 'A' = 2)"},{"name":"size","type":"Decimal(38, 18)"},{"name":"status","type":"LowCardinality(String)"},{"name":"status_time","type":"DateTime64(6, 'UTC')"},{"name":"tif","type":"LowCardinality(String)"},{"name":"trigger_condition","type":"Nullable(String)"},{"name":"trigger_price","type":"Nullable(Decimal(38, 18))"},{"name":"unique_id","type":"String"},{"name":"user","type":"FixedString(42)"}]},{"name":"hyperliquid_outcome_markets","engine":"View","total_rows":0,"sorting_key":[],"partition_key":"","columns":[{"name":"base_token_idx","type":"Nullable(UInt64)"},{"name":"block_number","type":"UInt64"},{"name":"coin","type":"Nullable(String)"},{"name":"description","type":"String"},{"name":"expiry","type":"String"},{"name":"fee_share","type":"Float64"},{"name":"first_enabled_as_quote","type":"String"},{"name":"indexed_at","type":"DateTime64(3, 'UTC')"},{"name":"is_liquid_base","type":"UInt8"},{"name":"is_liquid_quote","type":"UInt8"},{"name":"locked","type":"UInt8"},{"name":"name","type":"LowCardinality(String)"},{"name":"ndo","type":"UInt64"},{"name":"nou","type":"UInt64"},{"name":"nqu","type":"UInt64"},{"name":"outcome_class","type":"LowCardinality(String)"},{"name":"outcome_id","type":"UInt64"},{"name":"pair_name","type":"String"},{"name":"period","type":"LowCardinality(String)"},{"name":"quote_raw","type":"Nullable(UInt64)"},{"name":"quote_token_idx","type":"Nullable(UInt64)"},{"name":"quote_token_name","type":"Nullable(String)"},{"name":"quote_token_status","type":"LowCardinality(String)"},{"name":"quote_token_usdc_px","type":"Decimal(38, 18)"},{"name":"quote_token_usdc_px_raw","type":"UInt64"},{"name":"raw_side_json","type":"String"},{"name":"raw_spec_json","type":"String"},{"name":"side_count","type":"UInt16"},{"name":"side_index","type":"UInt8"},{"name":"side_name","type":"LowCardinality(String)"},{"name":"snapshot_time","type":"DateTime64(6, 'UTC')"},{"name":"spot_deploy_time","type":"String"},{"name":"spot_index","type":"Nullable(UInt64)"},{"name":"spot_resolution","type":"LowCardinality(String)"},{"name":"target_price","type":"String"},{"name":"token_idx","type":"Nullable(UInt64)"},{"name":"token_name","type":"Nullable(String)"},{"name":"underlying","type":"LowCardinality(String)"}]},{"name":"hyperliquid_outcome_meta","engine":"SharedReplacingMergeTree","total_rows":446213,"sorting_key":["block_number","outcome_id"],"partition_key":"toYYYYMM(snapshot_time)","columns":[{"name":"block_number","type":"UInt64"},{"name":"deploy_gas_auction_json","type":"String"},{"name":"description","type":"String"},{"name":"expiry","type":"String"},{"name":"fee_share","type":"Float64"},{"name":"indexed_at","type":"DateTime64(3, 'UTC')"},{"name":"locked","type":"UInt8"},{"name":"name","type":"LowCardinality(String)"},{"name":"ndo","type":"UInt64"},{"name":"nou","type":"UInt64"},{"name":"nqu","type":"UInt64"},{"name":"outcome_class","type":"LowCardinality(String)"},{"name":"outcome_id","type":"UInt64"},{"name":"period","type":"LowCardinality(String)"},{"name":"quote_raw","type":"Nullable(UInt64)"},{"name":"raw_spec_json","type":"String"},{"name":"side_count","type":"UInt16"},{"name":"snapshot_time","type":"DateTime64(6, 'UTC')"},{"name":"target_price","type":"String"},{"name":"underlying","type":"LowCardinality(String)"}]},{"name":"hyperliquid_outcome_question_members","engine":"SharedReplacingMergeTree","total_rows":396516,"sorting_key":["block_number","question_id","outcome_id"],"partition_key":"toYYYYMM(snapshot_time)","columns":[{"name":"block_number","type":"UInt64"},{"name":"indexed_at","type":"DateTime64(3, 'UTC')"},{"name":"is_fallback","type":"UInt8"},{"name":"is_settled","type":"UInt8"},{"name":"outcome_id","type":"UInt64"},{"name":"question_id","type":"UInt64"},{"name":"snapshot_time","type":"DateTime64(6, 'UTC')"},{"name":"source","type":"LowCardinality(String)"}]},{"name":"hyperliquid_outcome_questions","engine":"SharedReplacingMergeTree","total_rows":56844,"sorting_key":["block_number","question_id"],"partition_key":"toYYYYMM(snapshot_time)","columns":[{"name":"block_number","type":"UInt64"},{"name":"description","type":"String"},{"name":"fallback_outcome","type":"Nullable(UInt64)"},{"name":"indexed_at","type":"DateTime64(3, 'UTC')"},{"name":"name","type":"String"},{"name":"named_outcomes_json","type":"String"},{"name":"question_id","type":"UInt64"},{"name":"raw_question_json","type":"String"},{"name":"settled_named_outcomes_json","type":"String"},{"name":"snapshot_time","type":"DateTime64(6, 'UTC')"}]},{"name":"hyperliquid_outcome_sides","engine":"SharedReplacingMergeTree","total_rows":892424,"sorting_key":["block_number","outcome_id","side_index"],"partition_key":"toYYYYMM(snapshot_time)","columns":[{"name":"base_token_idx","type":"Nullable(UInt64)"},{"name":"block_number","type":"UInt64"},{"name":"coin","type":"Nullable(String)"},{"name":"indexed_at","type":"DateTime64(3, 'UTC')"},{"name":"outcome_id","type":"UInt64"},{"name":"quote_token_idx","type":"Nullable(UInt64)"},{"name":"quote_token_name","type":"Nullable(String)"},{"name":"raw_side_json","type":"String"},{"name":"side_index","type":"UInt8"},{"name":"side_m_raw","type":"String"},{"name":"side_m_value","type":"Nullable(Int64)"},{"name":"side_name","type":"LowCardinality(String)"},{"name":"snapshot_time","type":"DateTime64(6, 'UTC')"},{"name":"spot_index","type":"Nullable(UInt64)"},{"name":"spot_indices_json","type":"String"},{"name":"spot_resolution","type":"LowCardinality(String)"},{"name":"token_idx","type":"Nullable(UInt64)"},{"name":"token_name","type":"Nullable(String)"}]},{"name":"hyperliquid_perpetual_market_contexts","engine":"View","total_rows":0,"sorting_key":[],"partition_key":"","columns":[{"name":"coin","type":"LowCardinality(String)"},{"name":"day_base_vlm","type":"Decimal(38, 18)"},{"name":"day_ntl_vlm","type":"Decimal(38, 18)"},{"name":"funding","type":"Decimal(38, 18)"},{"name":"impact_ask","type":"Nullable(Decimal(38, 18))"},{"name":"impact_bid","type":"Nullable(Decimal(38, 18))"},{"name":"mark_px","type":"Decimal(38, 18)"},{"name":"mid_px","type":"Decimal(38, 18)"},{"name":"open_interest","type":"Decimal(38, 18)"},{"name":"oracle_px","type":"Decimal(38, 18)"},{"name":"polled_at","type":"DateTime64(6, 'UTC')"},{"name":"premium","type":"Decimal(38, 18)"},{"name":"prev_day_px","type":"Decimal(38, 18)"}]},{"name":"hyperliquid_perpetual_markets","engine":"SharedReplacingMergeTree","total_rows":1884,"sorting_key":["coin"],"partition_key":"","columns":[{"name":"coin","type":"LowCardinality(String)"},{"name":"indexed_at","type":"DateTime64(3, 'UTC')"},{"name":"margin_table_id","type":"Nullable(UInt16)"},{"name":"market_index","type":"UInt16"},{"name":"max_leverage","type":"UInt16"},{"name":"only_isolated","type":"UInt8"},{"name":"sz_decimals","type":"UInt8"}]},{"name":"hyperliquid_perpetual_positions","engine":"SharedReplacingMergeTree","total_rows":4279413933,"sorting_key":["block_number","clearinghouse","user","asset_idx"],"partition_key":"toYYYYMM(snapshot_time)","columns":[{"name":"asset_idx","type":"UInt16"},{"name":"block_number","type":"UInt64"},{"name":"clearinghouse","type":"UInt8"},{"name":"coin","type":"String"},{"name":"entry_notional","type":"UInt64"},{"name":"funding_alltime","type":"Int64"},{"name":"funding_since_change","type":"Int64"},{"name":"funding_since_open","type":"Int64"},{"name":"indexed_at","type":"DateTime64(3, 'UTC')"},{"name":"margin","type":"UInt64"},{"name":"size","type":"Int64"},{"name":"snapshot_time","type":"DateTime64(6, 'UTC')"},{"name":"usdc_balance","type":"Int64"},{"name":"user","type":"String"}]},{"name":"hyperliquid_quote_token_meta","engine":"SharedReplacingMergeTree","total_rows":115445,"sorting_key":["block_number","token_idx"],"partition_key":"toYYYYMM(snapshot_time)","columns":[{"name":"aligned_quote_info_json","type":"String"},{"name":"block_number","type":"UInt64"},{"name":"first_enabled_as_quote","type":"String"},{"name":"indexed_at","type":"DateTime64(3, 'UTC')"},{"name":"is_liquid_base","type":"UInt8"},{"name":"is_liquid_quote","type":"UInt8"},{"name":"snapshot_time","type":"DateTime64(6, 'UTC')"},{"name":"status","type":"LowCardinality(String)"},{"name":"token_idx","type":"UInt64"},{"name":"token_name","type":"LowCardinality(String)"}]},{"name":"hyperliquid_raw_blocks","engine":"SharedReplacingMergeTree","total_rows":8277046,"sorting_key":["block_number"],"partition_key":"toYYYYMM(block_time)","columns":[{"name":"block_number","type":"UInt64"},{"name":"block_time","type":"DateTime64(6, 'UTC')"},{"name":"indexed_at","type":"DateTime64(3, 'UTC')"},{"name":"raw","type":"String"},{"name":"round","type":"UInt64"}]},{"name":"hyperliquid_register_referral","engine":"SharedReplacingMergeTree","total_rows":40820,"sorting_key":["referral_code","user"],"partition_key":"","columns":[{"name":"block_time","type":"DateTime64(6, 'UTC')"},{"name":"error","type":"Nullable(String)"},{"name":"indexed_at","type":"DateTime64(3, 'UTC')"},{"name":"is_success","type":"UInt8"},{"name":"referral_code","type":"String"},{"name":"round","type":"UInt64"},{"name":"tx_hash","type":"String"},{"name":"user","type":"String"}]},{"name":"hyperliquid_set_referrer","engine":"SharedReplacingMergeTree","total_rows":858646,"sorting_key":["referral_code","user"],"partition_key":"","columns":[{"name":"block_time","type":"DateTime64(6, 'UTC')"},{"name":"error","type":"Nullable(String)"},{"name":"indexed_at","type":"DateTime64(3, 'UTC')"},{"name":"is_success","type":"UInt8"},{"name":"referral_code","type":"String"},{"name":"round","type":"UInt64"},{"name":"tx_hash","type":"String"},{"name":"user","type":"String"}]},{"name":"hyperliquid_spot_balances","engine":"SharedReplacingMergeTree","total_rows":28214976115,"sorting_key":["block_number","user","token_idx"],"partition_key":"toYYYYMM(snapshot_time)","columns":[{"name":"block_number","type":"UInt64"},{"name":"escrowed","type":"Int64"},{"name":"indexed_at","type":"DateTime64(3, 'UTC')"},{"name":"snapshot_time","type":"DateTime64(6, 'UTC')"},{"name":"token","type":"String"},{"name":"token_idx","type":"UInt16"},{"name":"total","type":"Int64"},{"name":"user","type":"String"}]},{"name":"hyperliquid_spot_clearinghouse_states","engine":"SharedReplacingMergeTree","total_rows":28041863654,"sorting_key":["block_number","user","token_idx"],"partition_key":"toYYYYMM(snapshot_time)","columns":[{"name":"block_number","type":"UInt64"},{"name":"escrowed","type":"Int64"},{"name":"indexed_at","type":"DateTime64(3, 'UTC')"},{"name":"snapshot_time","type":"DateTime64(6, 'UTC')"},{"name":"token","type":"LowCardinality(String)"},{"name":"token_idx","type":"UInt16"},{"name":"total","type":"Int64"},{"name":"user","type":"FixedString(42)"}]},{"name":"hyperliquid_spot_markets","engine":"SharedReplacingMergeTree","total_rows":3412,"sorting_key":["token_index"],"partition_key":"","columns":[{"name":"deployer_trading_fee_share","type":"Nullable(String)"},{"name":"evm_contract","type":"Nullable(String)"},{"name":"full_name","type":"Nullable(String)"},{"name":"indexed_at","type":"DateTime64(3, 'UTC')"},{"name":"is_canonical","type":"UInt8"},{"name":"pair_index","type":"Nullable(UInt16)"},{"name":"pair_name","type":"Nullable(String)"},{"name":"sz_decimals","type":"UInt8"},{"name":"token","type":"LowCardinality(String)"},{"name":"token_id","type":"String"},{"name":"token_index","type":"UInt16"},{"name":"wei_decimals","type":"UInt8"}]},{"name":"hyperliquid_spot_pairs","engine":"SharedReplacingMergeTree","total_rows":5715214,"sorting_key":["block_number","spot_index"],"partition_key":"toYYYYMM(snapshot_time)","columns":[{"name":"base_token_idx","type":"UInt64"},{"name":"base_token_name","type":"LowCardinality(String)"},{"name":"block_number","type":"UInt64"},{"name":"deploy_time","type":"String"},{"name":"indexed_at","type":"DateTime64(3, 'UTC')"},{"name":"pair_name","type":"String"},{"name":"quote_token_idx","type":"UInt64"},{"name":"quote_token_name","type":"LowCardinality(String)"},{"name":"raw_spot_info_json","type":"String"},{"name":"snapshot_time","type":"DateTime64(6, 'UTC')"},{"name":"spot_index","type":"UInt64"}]},{"name":"hyperliquid_staking_events","engine":"SharedReplacingMergeTree","total_rows":349979,"sorting_key":["block_number","hash"],"partition_key":"toYYYYMM(block_time)","columns":[{"name":"amount","type":"Decimal(38, 18)"},{"name":"block_number","type":"UInt64"},{"name":"block_time","type":"DateTime64(6, 'UTC')"},{"name":"event_type","type":"Enum8('CDeposit' = 1, 'CWithdrawal' = 2, 'Delegation' = 3)"},{"name":"hash","type":"FixedString(66)"},{"name":"indexed_at","type":"DateTime64(3, 'UTC')"},{"name":"is_finalized","type":"Nullable(UInt8)"},{"name":"is_undelegate","type":"Nullable(UInt8)"},{"name":"time","type":"DateTime64(6, 'UTC')"},{"name":"user","type":"FixedString(42)"},{"name":"validator","type":"Nullable(FixedString(42))"}]},{"name":"hyperliquid_sub_accounts","engine":"SharedReplacingMergeTree","total_rows":570840127,"sorting_key":["block_number","sub_account"],"partition_key":"toYYYYMM(snapshot_time)","columns":[{"name":"block_number","type":"UInt64"},{"name":"indexed_at","type":"DateTime64(3, 'UTC')"},{"name":"master_account","type":"FixedString(42)"},{"name":"name","type":"Nullable(String)"},{"name":"snapshot_time","type":"DateTime64(6, 'UTC')"},{"name":"sub_account","type":"FixedString(42)"}]},{"name":"hyperliquid_summaries","engine":"SharedReplacingMergeTree","total_rows":909631344,"sorting_key":["user","polled_at"],"partition_key":"toYYYYMM(polled_at)","columns":[{"name":"cross_maintenance_margin_used","type":"Decimal(38, 18)"},{"name":"cross_margin_account_value","type":"Decimal(38, 18)"},{"name":"cross_margin_total_margin_used","type":"Decimal(38, 18)"},{"name":"cross_margin_total_natl_pos","type":"Decimal(38, 18)"},{"name":"cross_margin_total_raw_usd","type":"Decimal(38, 18)"},{"name":"indexed_at","type":"DateTime64(3, 'UTC')"},{"name":"margin_account_value","type":"Decimal(38, 18)"},{"name":"margin_total_margin_used","type":"Decimal(38, 18)"},{"name":"margin_total_natl_pos","type":"Decimal(38, 18)"},{"name":"margin_total_raw_usd","type":"Decimal(38, 18)"},{"name":"polled_at","type":"DateTime64(3, 'UTC')"},{"name":"user","type":"String"},{"name":"withdrawable","type":"Decimal(38, 18)"}]},{"name":"hyperliquid_system_actions","engine":"SharedReplacingMergeTree","total_rows":2370227,"sorting_key":["block_number","evm_tx_hash","nonce"],"partition_key":"toYYYYMM(block_time)","columns":[{"name":"action","type":"String"},{"name":"action_type","type":"LowCardinality(String)"},{"name":"agent_address","type":"Nullable(FixedString(42))"},{"name":"agent_name","type":"Nullable(String)"},{"name":"block_number","type":"UInt64"},{"name":"block_time","type":"DateTime64(6, 'UTC')"},{"name":"destination","type":"Nullable(FixedString(42))"},{"name":"destination_dex_or_spot","type":"Nullable(UInt8)"},{"name":"evm_tx_hash","type":"FixedString(66)"},{"name":"from_sub_account","type":"Nullable(UInt8)"},{"name":"hyperliquid_chain","type":"Nullable(String)"},{"name":"indexed_at","type":"DateTime64(3, 'UTC')"},{"name":"is_mint","type":"Nullable(UInt8)"},{"name":"is_undelegate","type":"Nullable(UInt8)"},{"name":"nonce","type":"UInt64"},{"name":"ntl","type":"Nullable(Decimal(38, 18))"},{"name":"order_grouping","type":"Nullable(String)"},{"name":"signature_chain_id","type":"Nullable(String)"},{"name":"source_dex_or_spot","type":"Nullable(UInt8)"},{"name":"to_perp","type":"Nullable(UInt8)"},{"name":"token","type":"Nullable(UInt16)"},{"name":"user","type":"FixedString(42)"},{"name":"validator","type":"Nullable(FixedString(42))"},{"name":"wei","type":"Nullable(UInt256)"}]},{"name":"hyperliquid_token_usdc_prices","engine":"SharedReplacingMergeTree","total_rows":115456,"sorting_key":["block_number","token_idx"],"partition_key":"toYYYYMM(snapshot_time)","columns":[{"name":"approx_usdc_px","type":"Decimal(38, 18)"},{"name":"approx_usdc_px_float_1e6","type":"Float64"},{"name":"approx_usdc_px_raw","type":"UInt64"},{"name":"block_number","type":"UInt64"},{"name":"indexed_at","type":"DateTime64(3, 'UTC')"},{"name":"raw_pair_json","type":"String"},{"name":"snapshot_time","type":"DateTime64(6, 'UTC')"},{"name":"token_idx","type":"UInt64"},{"name":"token_name","type":"LowCardinality(String)"}]},{"name":"hyperliquid_trades","engine":"SharedReplacingMergeTree","total_rows":1428402935,"sorting_key":["block_number","trade_id"],"partition_key":"toYYYYMM(block_time)","columns":[{"name":"block_number","type":"UInt64"},{"name":"block_time","type":"DateTime64(6, 'UTC')"},{"name":"buyer_address","type":"FixedString(42)"},{"name":"buyer_builder_address","type":"Nullable(FixedString(42))"},{"name":"buyer_builder_fee","type":"Nullable(Decimal(38, 18))"},{"name":"buyer_closed_pnl","type":"Decimal(38, 18)"},{"name":"buyer_crossed","type":"UInt8"},{"name":"buyer_deployer_fee","type":"Nullable(Decimal(38, 18))"},{"name":"buyer_dir","type":"LowCardinality(String)"},{"name":"buyer_fee","type":"Decimal(38, 18)"},{"name":"buyer_order_id","type":"UInt64"},{"name":"buyer_priority_gas","type":"Nullable(Decimal(38, 18))"},{"name":"buyer_start_position","type":"Decimal(38, 18)"},{"name":"buyer_twap_id","type":"Nullable(UInt64)"},{"name":"coin","type":"LowCardinality(String)"},{"name":"fee_token","type":"LowCardinality(String)"},{"name":"indexed_at","type":"DateTime64(3, 'UTC')"},{"name":"liquidated_user","type":"Nullable(FixedString(42))"},{"name":"liquidation_mark_price","type":"Nullable(Decimal(38, 18))"},{"name":"liquidation_method","type":"Nullable(String)"},{"name":"price","type":"Decimal(38, 18)"},{"name":"seller_address","type":"FixedString(42)"},{"name":"seller_builder_address","type":"Nullable(FixedString(42))"},{"name":"seller_builder_fee","type":"Nullable(Decimal(38, 18))"},{"name":"seller_closed_pnl","type":"Decimal(38, 18)"},{"name":"seller_crossed","type":"UInt8"},{"name":"seller_deployer_fee","type":"Nullable(Decimal(38, 18))"},{"name":"seller_dir","type":"LowCardinality(String)"},{"name":"seller_fee","type":"Decimal(38, 18)"},{"name":"seller_order_id","type":"UInt64"},{"name":"seller_priority_gas","type":"Nullable(Decimal(38, 18))"},{"name":"seller_start_position","type":"Decimal(38, 18)"},{"name":"seller_twap_id","type":"Nullable(UInt64)"},{"name":"side","type":"Enum8('B' = 1, 'A' = 2)"},{"name":"size","type":"Decimal(38, 18)"},{"name":"timestamp","type":"DateTime64(3, 'UTC')"},{"name":"total_builder_fee","type":"Nullable(Decimal(38, 18))"},{"name":"trade_id","type":"UInt64"},{"name":"transaction_hash","type":"FixedString(66)"},{"name":"unique_id","type":"String"}]},{"name":"hyperliquid_transactions","engine":"SharedReplacingMergeTree","total_rows":225725281090,"sorting_key":["round","tx_hash","nonce"],"partition_key":"toYYYYMM(block_time)","columns":[{"name":"action","type":"JSON"},{"name":"action_type","type":"LowCardinality(String)"},{"name":"block_time","type":"DateTime64(6, 'UTC')"},{"name":"error","type":"Nullable(String)"},{"name":"indexed_at","type":"DateTime64(3, 'UTC')"},{"name":"is_success","type":"UInt8"},{"name":"nonce","type":"UInt64"},{"name":"proposer","type":"Nullable(String)"},{"name":"round","type":"UInt64"},{"name":"tx_hash","type":"String"},{"name":"user","type":"Nullable(String)"},{"name":"vault_address","type":"Nullable(String)"}]},{"name":"hyperliquid_transactions_tip","engine":"SharedReplacingMergeTree","total_rows":6470248844,"sorting_key":["block_number","action_seq"],"partition_key":"toYYYYMM(block_time)","columns":[{"name":"action","type":"JSON"},{"name":"action_seq","type":"UInt32"},{"name":"action_type","type":"LowCardinality(String)"},{"name":"block_number","type":"UInt64"},{"name":"block_time","type":"DateTime64(6, 'UTC')"},{"name":"broadcaster","type":"Nullable(String)"},{"name":"error","type":"Nullable(String)"},{"name":"indexed_at","type":"DateTime64(3, 'UTC')"},{"name":"is_success","type":"UInt8"},{"name":"nonce","type":"UInt64"},{"name":"proposer","type":"Nullable(String)"},{"name":"response","type":"JSON"},{"name":"round","type":"UInt64"},{"name":"tx_hash","type":"String"},{"name":"user","type":"Nullable(String)"},{"name":"vault_address","type":"Nullable(String)"}]},{"name":"hyperliquid_twap_statuses","engine":"SharedReplacingMergeTree","total_rows":1497996,"sorting_key":["block_number","twap_id","time"],"partition_key":"toYYYYMM(block_time)","columns":[{"name":"block_number","type":"UInt64"},{"name":"block_time","type":"DateTime64(6, 'UTC')"},{"name":"coin","type":"LowCardinality(String)"},{"name":"executed_ntl","type":"Decimal(38, 18)"},{"name":"executed_size","type":"Decimal(38, 18)"},{"name":"indexed_at","type":"DateTime64(3, 'UTC')"},{"name":"minutes","type":"UInt16"},{"name":"randomize","type":"UInt8"},{"name":"reduce_only","type":"UInt8"},{"name":"side","type":"Enum8('B' = 1, 'A' = 2)"},{"name":"size","type":"Decimal(38, 18)"},{"name":"status","type":"LowCardinality(String)"},{"name":"time","type":"DateTime64(6, 'UTC')"},{"name":"timestamp","type":"DateTime64(3, 'UTC')"},{"name":"twap_id","type":"UInt64"},{"name":"user","type":"FixedString(42)"}]},{"name":"hyperliquid_validator_rewards","engine":"SharedReplacingMergeTree","total_rows":13211557,"sorting_key":["block_number","validator","time"],"partition_key":"toYYYYMM(block_time)","columns":[{"name":"block_number","type":"UInt64"},{"name":"block_time","type":"DateTime64(6, 'UTC')"},{"name":"hash","type":"FixedString(66)"},{"name":"indexed_at","type":"DateTime64(3, 'UTC')"},{"name":"reward","type":"Decimal(38, 18)"},{"name":"time","type":"DateTime64(6, 'UTC')"},{"name":"validator","type":"FixedString(42)"}]},{"name":"hyperliquid_vault_equities","engine":"SharedReplacingMergeTree","total_rows":2259291925,"sorting_key":["block_number","vault_address","depositor"],"partition_key":"toYYYYMM(snapshot_time)","columns":[{"name":"block_number","type":"UInt64"},{"name":"depositor","type":"FixedString(42)"},{"name":"indexed_at","type":"DateTime64(3, 'UTC')"},{"name":"leader","type":"FixedString(42)"},{"name":"leader_commission","type":"Float64"},{"name":"net_deposits","type":"Int64"},{"name":"ownership_fraction","type":"Float64"},{"name":"snapshot_time","type":"DateTime64(6, 'UTC')"},{"name":"vault_address","type":"FixedString(42)"},{"name":"vault_name","type":"String"}]}]}]