Tables and Views
dim_perp_markets
Reference table of all perpetual futures markets listed on Hyperliquid, including leverage
limits, margin configurati…
dim_spot_markets
Reference table of all HIP-1 spot tokens deployed on HyperCore, enriched with token details
including supply, deploye…
ez_perp_asset_snapshots
Periodic snapshots of perpetual market state including open interest, oracle prices, mark
prices, and impact prices. …
ez_perp_candles
OHLCV (Open, High, Low, Close, Volume) candlestick data for perpetual markets, enriched with
market metadata. Candle …
ez_perp_fills
Single-sided perpetual trade fills, split by maker/taker. Each double-sided trade becomes two
fill rows. Comparable t…
ez_perp_funding_payments
Per-user funding payments on perpetual positions, enriched with market metadata. Funding is
exchanged between long an…
ez_perp_funding_rates
Historical hourly funding rates for perpetual markets, enriched with market metadata. Positive
funding rate means lon…
ez_perp_l2_book
Level 2 order book depth snapshots for perpetual markets, showing price levels, sizes, and order
counts at each level…
ez_perp_liquidations
Perpetual market liquidation events from the liquidated user’s perspective, with counterparty
information. Comparable…
ez_perp_predicted_fundings
Predicted next funding rates from multiple venues, enriched with market metadata. Provides
forward-looking funding ra…
ez_perp_trades
Perpetual futures trades enriched with market metadata from
dim_perp_markets. Filters
fact_trades to perp market …ez_spot_asset_snapshots
Periodic snapshots of spot token market state, enriched with token metadata from
dim_spot_markets. Includes volume,…ez_spot_trades
Spot token trades enriched with token metadata from
dim_spot_markets. Filters fact_trades to
spot market type onl…fact_ledger_events
On-chain ledger actions including deposits, withdrawals, internal transfers, vault operations,
spot transfers, and su…
fact_mid_prices
Point-in-time mid-market prices (average of best bid and ask) for all listed assets on
Hyperliquid. Snapshot data col…
fact_staking_events
HYPE token staking activity including delegations to validators, staking deposits (CDeposit),
and staking withdrawals…
fact_trades
Core fact table recording every matched trade on Hyperliquid across all market types (perpetual
futures, spot, and pr…
fact_validator_rewards
Per-block validator reward distributions on the Hyperliquid L1. Rewards are accrued every minute
and distributed dail…
fact_vault_snapshots
Periodic snapshots of Hyperliquid vault state including total value locked, APR, lockup periods,
and follower relatio…