| Table Name | Description |
|---|---|
hyperliquid.raw.fills | Raw Hyperliquid fills data for all trade that is executed. |
hyperliquid.raw.trades | Raw Hyperliquid fills data for all trades the trades. Two fills make a trade. |
hyperliquid.raw.orders | Raw Hyperliquid orders data. |
hyperliquid.raw.blocks | Blocks level metadata, including block height, hash, timestamp, and proposer. |
hyperliquid.raw.transactions | Transactions data for each block on Hyperliquid. |
hyperliquid.raw.tokens | List of tokens that are traded on Hyperliquid DEX, with token metadata such as token name and symbol. Currently only includes spot tokens. |
hyperliquid.raw.perpetual_market_asset_contexts | Perpetual market asset context data. This coin volume, open interest, funding, premium, mid price. |
Builder-related Data Schemas
| Table Name | Description |
|---|---|
hyperliquid.raw.builder_fills | Fills completed builders only, including builder fees and the builder address. ie the trade was facilitated by an order placed by that builder. Data is available from 2024-10-27. |
hyperliquid.raw.builder_transactions | Successfully completed transactions with builder address and fee, built incrementally from hyperliquid.raw.transactions |
hyperliquid.raw.builder_labels | Buildet address and builder identity mapping, source from publicly available data. |
Referral-related Data Schemas
| Table Name | Description |
|---|---|
hyperliquid.raw.register_referral | Successfull referral registration filetered from hyperliquid.raw.transactions. Contains the referral code used e.g. PURS and the address of the user registering the referral. |
hyperliquid.raw.set_referrer | Sucessful registration of a referrer filtered from hyperliquid.raw.transactions. Contains the referral code used e.g. PURS and the address of the user settingt the referrer. |
Schemas
| Column Name | Description |
|---|---|
| coin | A unique identifier for the asset being traded: • The coin for perpetuals is the standard token symbol, e.g. HYPE • The coin for spot tokens is an ID representing a pair of tokens based on Hyperliquid’s metadata, e.g. @4 (coin) represents token 5/token 0, which corresponds to JEFF/USDC The metadata is available from the info endpoint of Hyperliquid’s API |
| price | Price of the coin at the time of the trade |
| side | B = Buy (spot) / Long (perpetuals) A = Sell (spot) / Short (perpetuals) |
| size | Units of the coin that were traded |
| users | An array of 2 users that were involved in the trade |
| transaction_hash | The transaction hash for the trade. *See notes for Null Transaction hash. |
| trade_id | An identifier for the trade. Some historical trades share a tid of 0 |
| timestamp | The UTC timestamp of when the trade was executed |
| unique_id | A unique identifier for each trade |
| extra_fields | Additional information for each trade. See notes for more details. |