Overview by Coin

The 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.

Overview

Data Verticals

Solana

Hyperliquid

Lighter

Bitcoin Ecosystem

EVM

Cosmos Ecosystem

Move Ecosystem

Other Ecosystems

Table Columns

General

Trading Volume

Users

Open Interest

Lineage

​Table Columns

​General

​Trading Volume

​Users

​Open Interest

​Lineage

Table Columns

General

Trading Volume

Users

Open Interest

Lineage