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 | The daily trading volume in USD for this coin and market type, aggregated from hyperliquid.dex.trades. |
| trade_count | The daily number of trades for this coin and market type, aggregated from hyperliquid.dex.trades. |
Users
| Column Name | Description |
|---|---|
| active_buyers | The daily number of unique buyers for this coin and market type, aggregated from hyperliquid.dex.trades. |
| active_sellers | The daily number of unique sellers for this coin and market type, aggregated from hyperliquid.dex.trades. |
Open Interest
| Column Name | Description |
|---|---|
| open_interest_usd | The daily average open interest in USD for this coin, aggregated from hyperliquid.raw.perpetual. Populated for perpetuals rows only; NULL for spot. |
| avg_oracle_price | The daily average oracle price of this coin, from hyperliquid.raw.perpetual. Populated for perpetuals rows only; NULL for spot. |