> ## Documentation Index
> Fetch the complete documentation index at: https://docs.flipsidecrypto.com/llms.txt
> Use this file to discover all available pages before exploring further.

# Core

> Tables and views in the hypercore.core schema

## Tables and Views

<CardGroup cols={2}>
  <Card title="dim_perp_markets" icon="table" href="./dim-perp-markets">
    Reference table of all perpetual futures markets listed on Hyperliquid, including leverage
    limits, margin configurati...
  </Card>

  <Card title="dim_spot_markets" icon="table" href="./dim-spot-markets">
    Reference table of all HIP-1 spot tokens deployed on HyperCore, enriched with token details
    including supply, deploye...
  </Card>

  <Card title="ez_perp_asset_snapshots" icon="table" href="./ez-perp-asset-snapshots">
    Periodic snapshots of perpetual market state including open interest, oracle prices, mark
    prices, and impact prices. ...
  </Card>

  <Card title="ez_perp_candles" icon="table" href="./ez-perp-candles">
    OHLCV (Open, High, Low, Close, Volume) candlestick data for perpetual markets, enriched with
    market metadata. Candle ...
  </Card>

  <Card title="ez_perp_fills" icon="table" href="./ez-perp-fills">
    Single-sided perpetual trade fills, split by maker/taker. Each double-sided trade becomes two
    fill rows. Comparable t...
  </Card>

  <Card title="ez_perp_funding_payments" icon="table" href="./ez-perp-funding-payments">
    Per-user funding payments on perpetual positions, enriched with market metadata. Funding is
    exchanged between long an...
  </Card>

  <Card title="ez_perp_funding_rates" icon="table" href="./ez-perp-funding-rates">
    Historical hourly funding rates for perpetual markets, enriched with market metadata. Positive
    funding rate means lon...
  </Card>

  <Card title="ez_perp_l2_book" icon="table" href="./ez-perp-l2-book">
    Level 2 order book depth snapshots for perpetual markets, showing price levels, sizes, and order
    counts at each level...
  </Card>

  <Card title="ez_perp_liquidations" icon="table" href="./ez-perp-liquidations">
    Perpetual market liquidation events from the liquidated user's perspective, with counterparty
    information. Comparable...
  </Card>

  <Card title="ez_perp_predicted_fundings" icon="table" href="./ez-perp-predicted-fundings">
    Predicted next funding rates from multiple venues, enriched with market metadata. Provides
    forward-looking funding ra...
  </Card>

  <Card title="ez_perp_trades" icon="table" href="./ez-perp-trades">
    Perpetual futures trades enriched with market metadata from `dim_perp_markets`. Filters
    `fact_trades` to perp market ...
  </Card>

  <Card title="ez_spot_asset_snapshots" icon="table" href="./ez-spot-asset-snapshots">
    Periodic snapshots of spot token market state, enriched with token metadata from
    `dim_spot_markets`. Includes volume,...
  </Card>

  <Card title="ez_spot_trades" icon="table" href="./ez-spot-trades">
    Spot token trades enriched with token metadata from `dim_spot_markets`. Filters `fact_trades` to
    spot market type onl...
  </Card>

  <Card title="fact_ledger_events" icon="table" href="./fact-ledger-events">
    On-chain ledger actions including deposits, withdrawals, internal transfers, vault operations,
    spot transfers, and su...
  </Card>

  <Card title="fact_mid_prices" icon="table" href="./fact-mid-prices">
    Point-in-time mid-market prices (average of best bid and ask) for all listed assets on
    Hyperliquid. Snapshot data col...
  </Card>

  <Card title="fact_staking_events" icon="table" href="./fact-staking-events">
    HYPE token staking activity including delegations to validators, staking deposits (CDeposit),
    and staking withdrawals...
  </Card>

  <Card title="fact_trades" icon="table" href="./fact-trades">
    Core fact table recording every matched trade on Hyperliquid across all market types (perpetual
    futures, spot, and pr...
  </Card>

  <Card title="fact_validator_rewards" icon="table" href="./fact-validator-rewards">
    Per-block validator reward distributions on the Hyperliquid L1. Rewards are accrued every minute
    and distributed dail...
  </Card>

  <Card title="fact_vault_snapshots" icon="table" href="./fact-vault-snapshots">
    Periodic snapshots of Hyperliquid vault state including total value locked, APR, lockup periods,
    and follower relatio...
  </Card>
</CardGroup>