hyperliquid.metrics.overview_by_coin table provides daily Hyperliquid trading metrics broken out per coin and market type. Each row is one (activity_date, coin, market_type) combination, covering native perpetuals, spot, and HIP-3 permissionless perpetual markets. It is the per-coin cut of hyperliquid.metrics.overview. This table is updated daily.
Table Columns
General
| Column Name | Description |
|---|---|
| activity_date | The date of the activity. |
| coin | The coin / market symbol (e.g. BTC, ETH, HYPE). |
| market_type | The market type for this row: perpetuals or spot. |
| is_hip3 | Whether this is a HIP-3 permissionless perpetual market. |
| perp_dex | The HIP-3 builder DEX name for this market. NULL for native main-dex perpetuals and spot. |
Trading Volume
| Column Name | Description |
|---|---|
| volume_usd | Daily trading volume in USD for this coin and market type. |
| trade_count | Daily number of trades for this coin and market type. |
Users
| Column Name | Description |
|---|---|
| active_buyers | Daily number of unique buyers for this coin and market type. |
| active_sellers | Daily number of unique sellers for this coin and market type. |
Open Interest
| Column Name | Description |
|---|---|
| open_interest_usd | Daily average open interest in USD for this coin. Populated for perpetuals rows only; NULL for spot. |
| avg_oracle_price | Daily average oracle price of this coin. Populated for perpetuals rows only; NULL for spot. |
Lineage
| Column Name | Description |
|---|---|
| _created_at | Row creation timestamp. |
| _updated_at | Row last update timestamp. |
| _changed_since_full_refresh | Change-tracking flag for row updates. |