Skip to main content
3 tables in this category.

​
Tables

View NameDatabaseSourceORDER BY
agent.hyperliquid_market_dataagenthyperliquid.market_datacoin, snapshot_time
agent.hyperliquid_funding_ratesagenthyperliquid.funding_ratescoin, time
agent.hyperliquid_perp_metaagenthyperliquid.perp_metacoin
  • agent.hyperevm_dex_trades

​
Sample Queries

​
1. Get recent Transfer events for USDC

SELECT *
FROM ethereum.event_logs
WHERE topics[1] = '0xddf252ad1be2c89b69c2b068fc378daa952ba7f163c4a11628f55a4df523b3ef'
  AND address = '0xa0b86991c6218b36c1d19d4a2e9eb0ce3606eb48'
ORDER BY block_number DESC
LIMIT 10

​
2. Count transactions per day for the last week

SELECT block_date, count() AS tx_count
FROM ethereum.transactions
WHERE block_date >= today() - 7
GROUP BY block_date
ORDER BY block_date

​
Table Schemas

​
agent.hyperliquid_market_data

Hourly perpetual futures market snapshots from Hyperliquid Info API. Includes funding rates, open interest, prices (oracle, mark, mid), 24h volume, and premium for all listed perpetual contracts. ReplacingMergeTree — use FINAL. Engine: ReplacingMergeTree | Partition: toYYYYMM(snapshot_date) | ORDER BY: coin, snapshot_time
ColumnTypeDescription
snapshot_timeDateTime64(3)Hourly snapshot timestamp (DateTime64).
coinStringPerpetual contract ticker (e.g., ‘BTC’, ‘ETH’, ‘SOL’). Links to perp_meta.
fundingFloat64Current predicted funding rate (per-hour). Positive = longs pay shorts.
open_interestFloat64Total open interest in contract units (not USD).
prev_day_pxFloat64Previous day’s closing price.
day_ntl_vlmFloat6424-hour notional volume in USD.
premiumNullable(Float64)Basis premium (mark - oracle). Nullable.
oracle_pxFloat64Oracle price (external reference, typically Pyth/Chainlink).
mark_pxFloat64Mark price (used for margin and liquidation calculations).
mid_pxNullable(Float64)Mid price of the order book. Nullable.
impact_bid_pxNullable(Float64)Price for a standard-size market sell. Nullable — indicates depth.
impact_ask_pxNullable(Float64)Price for a standard-size market buy. Nullable — indicates depth.
snapshot_dateDateDate of the snapshot (partition key).
  • Use FINAL when querying — this is a ReplacingMergeTree table
  • snapshot_time is hourly — one snapshot per (coin, hour)
  • day_ntl_vlm is 24h notional volume in USD at snapshot time
  • funding is the current predicted funding rate (annualize by multiplying by 8760)
  • open_interest is in contract units, not USD — multiply by mark_px for USD OI
  • Hourly snapshots only — no tick-level or trade-level data
  • ReplacingMergeTree — always use FINAL for consistent reads
  • OI is in contract units, not USD — requires multiplication by price
  • Not all fields are always populated (mid_px, impact_bid/ask_px can be null)

​
agent.hyperliquid_funding_rates

Historical funding rate settlements for Hyperliquid perpetual contracts. Every 1-hour funding event is recorded with the settlement rate and premium. ReplacingMergeTree — use FINAL. Engine: ReplacingMergeTree | Partition: toYYYYMM(funding_date) | ORDER BY: coin, time
ColumnTypeDescription
timeDateTime64(3)Settlement timestamp (DateTime64).
coinStringPerpetual contract ticker (e.g., ‘BTC’, ‘ETH’). Links to perp_meta.
funding_rateFloat64Settlement funding rate. Positive = longs pay shorts.
premiumFloat64Mark-to-oracle premium at settlement time.
funding_dateDateDate of the funding settlement (partition key).
  • Use FINAL when querying — ReplacingMergeTree table
  • funding_rate is per-settlement-period (hourly). Annualize: rate * 8760
  • premium tracks the basis between mark and oracle price at settlement
  • For average daily funding: avg(funding_rate) grouped by funding_date and coin
  • ReplacingMergeTree — use FINAL for deduplication
  • Funding rates are per-hour settlements — not continuous
  • Historical backfill depth depends on when the pipeline was started

​
agent.hyperliquid_perp_meta

Perpetual contract metadata for all listed Hyperliquid perps. Small dimension table with coin name, size decimals, and maximum leverage. Updated on each market data ingestion run. Engine: ReplacingMergeTree | ORDER BY: coin
ColumnTypeDescription
coinStringPerpetual contract ticker (e.g., ‘BTC’, ‘ETH’, ‘SOL’). Primary key.
sz_decimalsUInt8Number of decimal places for position/order sizing.
max_leverageUInt16Maximum leverage allowed for this contract.
updated_atDateTime64(3)Last metadata refresh timestamp.
  • Small table (~229 rows) — safe to SELECT * or use in subqueries without filtering
  • JOIN with market_data or funding_rates ON coin for enrichment
  • sz_decimals determines the minimum trade size increment for each contract
  • Only covers perpetual contracts — no spot or options metadata
  • Max leverage may change over time — only current value is stored