> ## 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

> Hyperliquid (HyperCore) is an L1 built to support an ecosystem of permisionless financial applications. The flagship native application is the Hyperliquid DEX, a fully onchain order book exchange.

Allium provides comprehensive realtime (datastreams) and historical data for Hyperliquid.
The data is indexed from our in-house nodes that we operate. We run three nodes concurrently to ensure high availability and data completeness.

We have included guides on how to navigate Hyperliquid data and FAQs on the data.

<Note>
  This section is for the Hyperliquid L1. [Click here if you are looking for the
  EVM-compatible blockchain
  HyperEVM](/historical-data/supported-blockchains/evm/hyperevm)
</Note>

## Data Delivery & Interfaces

We offer the following delivery methods for both historical and near realtime data for Hyperliquid.

<CardGroup cols="4">
  <Card title="Explorer" icon="crosshairs-simple" href="/app/overview">
    Via the Allium App or Explorer APIs (Historical Data)
  </Card>

  <Card title="Datashares" icon="server" href="/datashares/overview">
    Via Snowflake, Databricks, Google Cloud (Historical Data)
  </Card>

  <Card title="Datastreams" icon="arrow-progress" href="/historical-data/supported-blockchains/hyperliquid/streams">
    Via Kafka, Pub/Sub (Near Realtime Data)
  </Card>

  <Card title="Realtime APIs" icon="code" href="/api/developer/hyperliquid/overview">
    Via API Endpoints
  </Card>
</CardGroup>

<Note>
  **Historical Data Caveats**

  **Hyperliquid DEX Trades**

  * Hyperliquid DEX Trades are fully backfilled for every address, except for \~4,000
    traders (\~1% of traders) who had made more than 10k trades at the time of backfill
    in March 2025.
  * This is because the Hyperliquid API only makes the last 10k trades
    available, and there are no other ways to retrieve the missing historical data. This
    means the following data is available:
  * Pre-March 2025: all trades are available for all addresses, except for \~4,000 traders, where only the last 10k trades are available
  * March 2025 onwards: all trades are available for all addresses

  **Hyperliquid Orders**

  * Hyperliquid Orders cannot be backfilled. Data is available since we started running
    nodes in house. We minimise the possibility of missing out orders by running three
    nodes. Gaps may exist in the unexpected event of node failures.
</Note>

## Data Schemas

The following data schemas are available:

<Info>
  Using `hyperliquid.dex.trades` is recommended as it enriches the `raw.trades`
  table with relevant trade & token metadata, including HIP-3 permissionless perpetual details.
</Info>

| Table Name                                                                                | Description                                                                                                                            |
| ----------------------------------------------------------------------------------------- | -------------------------------------------------------------------------------------------------------------------------------------- |
| <code style={{whiteSpace: "nowrap"}}>hyperliquid.metrics.overview</code>                  | Daily overview metrics for Hyperliquid, including trading volume, fees, open interest, liquidations, bridge flows, and HIP-3 activity. |
| <code style={{whiteSpace: "nowrap"}}>hyperliquid.metrics.dex\_overview</code>             | Daily metrics per HIP-3 DEX (permissionless perpetual markets). Provides visibility into individual DEX performance on Hyperliquid.    |
| <code style={{whiteSpace: "nowrap"}}>hyperliquid.dex.trades</code>                        | Enriched DEX trades for spot and perpetual markets, including HIP-3 permissionless perpetuals, with granular fees, PnL, and positions. |
| <code style={{whiteSpace: "nowrap"}}>hyperliquid.assets.fungible\_token\_transfers</code> | **Recommended.** Comprehensive token transfers with full bridge history from 2023-12 plus 17 misc\_events types from 2025-05.          |
| <code style={{whiteSpace: "nowrap"}}>hyperliquid.stablecoins.transfers</code>             | Stablecoin transfers with activity\_type classification. Data starts 2025-05-25.                                                       |
| <code style={{whiteSpace: "nowrap"}}>hyperliquid.assets.transfers</code>                  | **To be deprecated.** Use `fungible_token_transfers` instead. Bridge deposits/withdrawals via Arbitrum only.                           |

### Raw Data Schemas

| Table Name                                                                                      | Description                                                                                                                                                                 |
| ----------------------------------------------------------------------------------------------- | --------------------------------------------------------------------------------------------------------------------------------------------------------------------------- |
| <code style={{whiteSpace: "nowrap"}}>hyperliquid.raw\.fills</code>                              | Raw Hyperliquid fills data.                                                                                                                                                 |
| <code style={{whiteSpace: "nowrap"}}>hyperliquid.raw\.orders</code>                             | Raw Hyperliquid orders data.                                                                                                                                                |
| <code style={{whiteSpace: "nowrap"}}>hyperliquid.raw\.blocks</code>                             | Block-level metadata, including block height, hash, timestamp, and proposer.                                                                                                |
| <code style={{whiteSpace: "nowrap"}}>hyperliquid.raw\.transactions</code>                       | Transaction data for each block on Hyperliquid.                                                                                                                             |
| <code style={{whiteSpace: "nowrap"}}>hyperliquid.raw\.tokens</code>                             | List of tokens traded on the Hyperliquid DEX, with token metadata such as name and symbol. Currently only includes spot tokens.                                             |
| <code style={{whiteSpace: "nowrap"}}>hyperliquid.raw\.spot\_coin\_pairs</code>                  | Spot coin pair metadata. Maps @index identifiers (e.g. @107) to symbol pairs (e.g. HYPE/USDC). Join to fills, trades, orders, twaps on `coin = name` to resolve spot pairs. |
| <code style={{whiteSpace: "nowrap"}}>hyperliquid.raw\.perpetual\_markets</code>                 | Perpetual markets metadata including HIP-3 permissionless perpetual DEXes, leverage settings, and market configuration.                                                     |
| <code style={{whiteSpace: "nowrap"}}>hyperliquid.raw\.builder\_fills</code>                     | Fills completed via builders, including builder fees and the builder address, from 2024-10-27.                                                                              |
| <code style={{whiteSpace: "nowrap"}}>hyperliquid.raw\.builder\_transactions</code>              | Successfully completed transactions with builder address and fee.                                                                                                           |
| <code style={{whiteSpace: "nowrap"}}>hyperliquid.raw\.builder\_labels</code>                    | Builder address and builder identity mapping, sourced from publicly available data.                                                                                         |
| <code style={{whiteSpace: "nowrap"}}>hyperliquid.raw\.misc\_events</code>                       | Miscellaneous on-chain events including funding, deposits, withdrawals, liquidations, vault events, staking, and delegations.                                               |
| <code style={{whiteSpace: "nowrap"}}>hyperliquid.raw\.perpetual\_positions</code>               | Perpetual position data for users on Hyperliquid.                                                                                                                           |
| <code style={{whiteSpace: "nowrap"}}>hyperliquid.raw\.spot\_balances</code>                     | Spot token balances for users on Hyperliquid.                                                                                                                               |
| <code style={{whiteSpace: "nowrap"}}>hyperliquid.raw\.summaries</code>                          | Summary data for Hyperliquid.                                                                                                                                               |
| <code style={{whiteSpace: "nowrap"}}>hyperliquid.raw\.twaps</code>                              | TWAP (Time-Weighted Average Price) order data on Hyperliquid.                                                                                                               |
| <code style={{whiteSpace: "nowrap"}}>hyperliquid.raw\.perpetual\_market\_asset\_contexts</code> | Perpetual market asset context: per-coin volume, open interest, funding, premium, and mid price.                                                                            |
| <code style={{whiteSpace: "nowrap"}}>hyperliquid.raw\.register\_referrer</code>                 | Referral code registration events. Contains the referral code registered (e.g. PURS) and the address of the registering user.                                               |
| <code style={{whiteSpace: "nowrap"}}>hyperliquid.raw\.set\_referrer</code>                      | Successful registration of a referrer. Contains the referral code used (e.g. PURS) and the address of the user setting the referrer.                                        |

## Data Characteristics

In this section, we explain some of the characteristics of Hyperliquid data.

<Tabs>
  <Tab title="Granular Trade Data">
    The `hyperliquid.dex.trades` table now includes granular columns for fees, PnL, positions, and liquidation details that were previously only available in the `extra_fields` JSON column of `raw.trades`. These include:

    * **Fees**: `fee_token`, `seller_fee`, `buyer_fee`, `seller_builder_fee`, `buyer_builder_fee`
    * **PnL & Positions**: `seller_closed_pnl`, `buyer_closed_pnl`, `seller_start_position`, `buyer_start_position`
    * **Trade Direction**: `seller_dir`, `buyer_dir`, `seller_crossed`, `buyer_crossed`
    * **Order IDs**: `seller_order_id`, `buyer_order_id`, `seller_twap_id`, `buyer_twap_id`
    * **Liquidation**: `liquidated_user`, `liquidation_mark_price`, `liquidation_method`
    * **HIP-3**: `perp_dex`, `perp_market_name`, `perp_dex_deployer`, `perp_dex_fee_recipient`, `is_hip3`
  </Tab>

  <Tab title="trade_id & unique_id">
    In most cases, the `trade_id` can be thought of as the unique identifier for a trade. However, there are cases where this isn't true:

    * **Before 24 Nov 2023:** For historical Hyperliquid trades before 24 Nov 2023, the `trade_id` for all trades was 0. For those trades, we construct a unique\_id from other values.
    * **After 24 Nov 2023:** There are a handful of trades where the Hyperliquid API returns the same `trade_id` for trades from different transactions. Because of this, we use the combination of `trade_id` and `transaction_hash` unique identifier for trades.
  </Tab>

  <Tab title="Null Transaction Hash">
    <Info>
      You can maybe find null transaction hashes, these are TWAPs
    </Info>

    ```
    0x0000000000000000000000000000000000000000000000000000000000000000
    ```

    See [Hyperliquid TWAP](https://hyperliquid.gitbook.io/hyperliquid-docs/trading/order-types#twap-details) for more details.

    A transaction with action "Place TWAP order" will look like the one linked in the; \[Hyperliquid Explorer]\([https://app.hyperliquid.xyz/explorer/tx/0xd6f17b6efa51bd1a1ff30420be17af02015400689f842aff45bb18a090bd8c44](https://app.hyperliquid.xyz/explorer/tx/0xd6f17b6efa51bd1a1ff30420be17af02015400689f842aff45bb18a090bd8c44\))

    Once such a transaction is sent multiple, orders will be placed within the specified time range, these will have a null transaction hash.
  </Tab>

  <Tab title="Open Status">
    The hyperliquid node currently does not save order statuses unless the order already exists. Therefore open is not saved into the file, that the node generates, which is the source of this data.\
    For all the statuses the orders currently have run:

    ```sql theme={null}
    SELECT DISTINCT status
    FROM hyperliquid.raw.orders
    ORDER BY status;
    ```
  </Tab>

  <Tab title="Trigger Orders">
    `is_trigger` field is either *true* or *false*.\
    In the case where `is_trigger` is *true* the field
  </Tab>

  <Tab title="Transaction Actions">
    <Info>
      Every transaction has an action.
    </Info>

    You can see all the different types of actions by running

    ```sql theme={null}
    SELECT DISTINCT action:type from hyperliquid.raw.transactions;
    ```

    <Warning>
      The above query can take a while to run
    </Warning>

    * for quicker query for a subset (may be missing some types)

    ```sql theme={null}
    SELECT DISTINCT action:type from (select * from hyperliquid.raw.transactions limit 100000000);
    ```
  </Tab>
</Tabs>