HyperCore data is live on Flipside

Hyperliquid’s core trading engine processes $200+ billion in monthly volume across 281 perp markets. It holds 70%+ of all decentralized perp open interest and has settled $2.1 trillion in cumulative trades. Until now, none of that data was queryable through standard blockchain indexing.

We built 19 curated tables for HyperCore: the native Rust-based engine powering Hyperliquid’s order book, perpetual futures, spot markets, liquidations, and margin system. Live now on Flipspace for Flipside subscribers and via private data share on the Snowflake Marketplace.

What you can do with it

Track liquidation cascades. ez_perp_liquidations captures every liquidation event with the liquidated address, counterparty, method, realized PnL, and notional value. Cross-reference with ez_perp_asset_snapshots to see how open interest shifted before and after major liquidation spikes.

Screen for funding rate arbitrage. ez_perp_funding_rates gives you hourly rates across every perp market. Positive funding means longs are paying shorts. Negative means the reverse. This table surfaces the markets with the most extreme annualized carry right now.

Research maker vs. taker dynamics. ez_perp_fills splits every trade into maker and taker sides with fee attribution, PnL, and builder fees. This is the microstructure data that most perp DEXs don’t expose.

Monitor capital flows. fact_ledger_events tracks deposits, withdrawals, internal transfers, and vault operations. Net flow direction is one of the clearest sentiment signals on any exchange.

Full table reference

All tables live under the hypercore database, core schema.

Perpetual futures (11 tables)

• dim_perp_markets — all 281 perp markets with leverage limits and margin config
• ez_perp_trades — enriched perp trades with market metadata
• ez_perp_fills — single-sided fills by maker/taker, with fees and PnL
• ez_perp_liquidations — liquidation events with counterparty details and realized loss
• ez_perp_funding_rates — hourly funding rates across all perp markets
• ez_perp_funding_payments — per-user funding payments on open positions
• ez_perp_predicted_fundings — forward-looking predicted funding rates
• ez_perp_candles — OHLCV candlestick data for all perp markets
• ez_perp_l2_book — Level 2 order book depth snapshots
• ez_perp_asset_snapshots — periodic snapshots of open interest, oracle/mark prices, funding

Spot markets (3 tables)

• dim_spot_markets — all 275 HIP-1 spot tokens
• ez_spot_trades — enriched spot trades with token metadata
• ez_spot_asset_snapshots — spot market state snapshots (volume, holders, supply)

Platform (5 tables)

• fact_trades — every matched trade across all market types (838M+ rows)
• fact_mid_prices — point-in-time mid-market prices for all assets
• fact_ledger_events — deposits, withdrawals, internal transfers, vault operations
• fact_staking_events — HYPE token staking, delegations, withdrawals
• fact_validator_rewards — per-block validator reward distributions (24 active validators)
• fact_vault_snapshots — vault state including TVL, APR, lockup, and follower data

Full schema reference on docs.

Flipside’s full Hyperliquid data offering

HyperCore is one half of the picture. Hyperliquid runs two execution environments on one L1, both secured by the same validators via HyperBFT consensus — and Flipside now covers both.

HyperCore (19 tables) is the native trading engine: perpetual futures, spot order book, margin calculations, liquidations, staking. Sub-second finality, up to 200,000 orders per second. Not EVM-based. Most of Hyperliquid’s volume lives here.

HyperEVM (21 tables) is the EVM-compatible smart contract layer for DeFi protocols, lending, bridges, and token contracts: blocks, transactions, decoded events, token transfers, prices, and labels. Read more in our HyperEVM launch post or browse the HyperEVM docs.

With 40 tables across both layers, Flipside has the most complete Hyperliquid data coverage available. Grayscale filed for a HYPE ETF last week, and institutional attention on Hyperliquid is growing. The data is here when the demand arrives.

Start querying

Copy any query from this post and run it on Flipspace. Or pick a different entry point:

• HyperCore docs — Full schema reference for all 19 HyperCore tables.
• HyperEVM docs — Full schema reference for all 21 HyperEVM tables.
• Snowflake Marketplace — Zero ETL. Live tables in your Snowflake account. HyperCore + HyperEVM included.
• Contact us — Enterprise access and custom datasets.