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

> Daily per-coin Overview Metrics for Hyperliquid

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