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

# Overview

> Perpetual futures data across Hyperliquid, Lighter, Kalshi, Jupiter, GMX, and Variational.

Perpetual futures are derivatives that track an underlying with no expiry. Allium provides perpetual futures data across on-chain and centralized venues: trades, funding, open interest, liquidations, positions, and protocol metrics.

<Note>
  Definitions of funding, open interest, mark and index price, positions, and liquidations are on [Concepts](/historical-data/perpetuals/concepts).
</Note>

### Supported Protocols

| Protocol                                                           | Type          | Platform                                    | Data Coverage                                                                             |
| ------------------------------------------------------------------ | ------------- | ------------------------------------------- | ----------------------------------------------------------------------------------------- |
| [Hyperliquid](/historical-data/perpetuals/hyperliquid)             | Decentralized | Hyperliquid                                 | Trades, positions, markets, funding, liquidations (daily metrics + misc\_events), metrics |
| [Lighter](/historical-data/perpetuals/lighter)                     | Decentralized | Lighter                                     | Trades, liquidations, order books, funding, market stats, metrics                         |
| [Lighter Robinhood](/historical-data/perpetuals/lighter-robinhood) | Decentralized | Lighter Robinhood                           | Trades, liquidations, order books, funding, market stats, metrics                         |
| [Kalshi](/historical-data/perpetuals/kalshi)                       | Centralized   | Kalshi                                      | Trades, candlesticks, markets, orderbook, funding                                         |
| [Jupiter Perpetuals](/historical-data/perpetuals/jupiter)          | Decentralized | Solana                                      | Trades, liquidations, daily metrics                                                       |
| [GMX](/historical-data/perpetuals/gmx)                             | Decentralized | Arbitrum, Avalanche (v1 / v2); MegaETH (v2) | Trades, liquidations, fees, daily metrics                                                 |
| [Variational Omni](/historical-data/perpetuals/variational)        | Decentralized | Arbitrum                                    | Settlement pools, user actions, funding, market snapshots, daily metrics                  |

### Available Tables

| Project                                                            | [Trades](/historical-data/perpetuals/trades) | [Funding](/historical-data/perpetuals/funding) | [Liquidations](/historical-data/perpetuals/liquidations) | [Order books](/historical-data/perpetuals/order-books) | [Markets](/historical-data/perpetuals/markets) | [Daily metrics](/historical-data/perpetuals/markets) |               Fees              |
| ------------------------------------------------------------------ | :------------------------------------------: | :--------------------------------------------: | :------------------------------------------------------: | :----------------------------------------------------: | :--------------------------------------------: | :--------------------------------------------------: | :-----------------------------: |
| [Hyperliquid](/historical-data/perpetuals/hyperliquid)             |        <Icon icon="check" size={16} />       |         <Icon icon="check" size={16} />        |              <Icon icon="check" size={16} />             |             <Icon icon="check" size={16} />            |         <Icon icon="check" size={16} />        |            <Icon icon="check" size={16} />           |                                 |
| [Lighter](/historical-data/perpetuals/lighter)                     |        <Icon icon="check" size={16} />       |         <Icon icon="check" size={16} />        |              <Icon icon="check" size={16} />             |             <Icon icon="check" size={16} />            |         <Icon icon="check" size={16} />        |            <Icon icon="check" size={16} />           |                                 |
| [Lighter Robinhood](/historical-data/perpetuals/lighter-robinhood) |        <Icon icon="check" size={16} />       |         <Icon icon="check" size={16} />        |              <Icon icon="check" size={16} />             |             <Icon icon="check" size={16} />            |         <Icon icon="check" size={16} />        |            <Icon icon="check" size={16} />           |                                 |
| [Kalshi](/historical-data/perpetuals/kalshi)                       |        <Icon icon="check" size={16} />       |         <Icon icon="check" size={16} />        |                                                          |             <Icon icon="check" size={16} />            |         <Icon icon="check" size={16} />        |                                                      |                                 |
| [Jupiter](/historical-data/perpetuals/jupiter)                     |        <Icon icon="check" size={16} />       |                                                |              <Icon icon="check" size={16} />             |                                                        |                                                |            <Icon icon="check" size={16} />           |                                 |
| [GMX](/historical-data/perpetuals/gmx)                             |        <Icon icon="check" size={16} />       |                                                |              <Icon icon="check" size={16} />             |                                                        |                                                |            <Icon icon="check" size={16} />           | <Icon icon="check" size={16} /> |
| [Variational](/historical-data/perpetuals/variational)             |                                              |         <Icon icon="check" size={16} />        |                                                          |                                                        |         <Icon icon="check" size={16} />        |            <Icon icon="check" size={16} />           |                                 |

***

### Sample Queries

<Tabs>
  <Tab title="Hyperliquid Trades">
    Query Hyperliquid perpetual trades in the last 30 days.

    ```sql theme={null}
    select
      timestamp,
      coin,
      market_type,
      amount,
      price,
      usd_amount,
      buyer_address,
      seller_address
    from hyperliquid.dex.trades
    where timestamp::date >= current_date - 30
      and market_type = 'perpetuals'
    order by timestamp desc
    limit 100
    ```
  </Tab>

  <Tab title="Lighter Trades">
    Query Lighter trades in the last 7 days.

    ```sql theme={null}
    select
      timestamp,
      coin,
      trade_type,
      amount,
      price,
      usd_amount,
      buyer,
      seller
    from lighter.dex.trades
    where timestamp::date >= current_date - 7
      and market_type = 'perpetuals'
    order by timestamp desc
    limit 100
    ```
  </Tab>

  <Tab title="Kalshi Trades">
    Query Kalshi perp trades in the last 7 days.

    ```sql theme={null}
    select
      trade_id,
      ticker,
      created_time,
      num_contracts,
      price,
      contract_size,
      underlying_price,
      taker_side
    from common.perpetuals.kalshi_trades
    where partition_date >= current_date - 7
    order by created_time desc
    limit 100
    ```
  </Tab>

  <Tab title="Jupiter Trades">
    Query Jupiter Perpetuals position-change events.

    ```sql theme={null}
    select
      block_timestamp,
      project,
      protocol,
      trader,
      market_symbol,
      side,
      action,
      size_usd,
      price_usd,
      collateral_usd,
      pnl_usd,
      fee_usd,
      txn_id
    from solana.perpetuals.trades
    where block_date >= current_date - 30
    order by block_timestamp desc
    limit 100
    ```
  </Tab>

  <Tab title="GMX Trades">
    Query GMX position-change events on Arbitrum.

    ```sql theme={null}
    select
      block_timestamp,
      project,
      protocol,
      version,
      trader,
      market_symbol,
      side,
      action,
      size_usd,
      price_usd,
      collateral_usd,
      pnl_usd,
      fee_usd,
      transaction_hash
    from arbitrum.perpetuals.trades
    where block_date >= current_date - 30
      and project = 'gmx'
    order by block_timestamp desc
    limit 100
    ```
  </Tab>
</Tabs>