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

# Metrics Daily

> Hyperliquid HIP-4 daily activity, fee, user, and open interest metrics.

The `hyperliquid.predictions.metrics_daily` table provides daily activity, fee, user, and open interest metrics for Hyperliquid HIP-4 prediction markets. One row per (day, category, sub\_category).

<Info>
  HIP-4 categories: `price_binary` (Recurring auto-generated price markets), `categorical` (named outcomes under a question), `binary` (orphan named outcomes). `sub_category` is the Recurring underlying asset (e.g. 'BTC'); 'none' for non-Recurring categories.
</Info>

## Table Columns

### Identifiers

| Column Name   | Description                                                                                  |
| ------------- | -------------------------------------------------------------------------------------------- |
| project       | Top-level project namespace (`hyperliquid`).                                                 |
| protocol      | Protocol within the project (`hyperliquid_hip4`).                                            |
| chain         | The blockchain network (`hyperliquid`).                                                      |
| day           | Date bucket (UTC).                                                                           |
| category      | Market type. One of 'price\_binary', 'categorical', 'binary'.                                |
| sub\_category | Underlying asset for Recurring categories (e.g. 'BTC'). 'none' for non-Recurring categories. |

### Volume & Trade Counts

| Column Name              | Description                                                                                                                                                                               |
| ------------------------ | ----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- |
| trading\_volume\_usd     | USD trade volume for the day.                                                                                                                                                             |
| notional\_volume         | Trade volume in HL contract units (1 contract = \$1 of collateral locked at mint). Different scale from share-based platforms; prefer `trading_volume_usd` for cross-platform comparison. |
| trade\_count             | Trade count for the day.                                                                                                                                                                  |
| avg\_trade\_size\_usd    | Average trade size in USD for the day.                                                                                                                                                    |
| median\_trade\_size\_usd | Median trade size in USD for the day.                                                                                                                                                     |

### Fees

| Column Name              | Description                           |
| ------------------------ | ------------------------------------- |
| total\_fee\_usd          | Total transaction fee revenue in USD. |
| total\_buyer\_fee\_usd   | Buyer-side fee revenue in USD.        |
| total\_seller\_fee\_usd  | Seller-side fee revenue in USD.       |
| total\_builder\_fee\_usd | Total builder fee revenue in USD.     |

### Synthetic Mints

| Column Name                  | Description                       |
| ---------------------------- | --------------------------------- |
| synthetic\_mint\_volume\_usd | USD volume of synthetic mints.    |
| synthetic\_mint\_count       | Synthetic mint count for the day. |

### Market Coverage

| Column Name      | Description                                                          |
| ---------------- | -------------------------------------------------------------------- |
| markets\_traded  | Distinct events traded (multi-outcome questions count as one event). |
| outcomes\_traded | Distinct outcomes traded.                                            |
| coins\_traded    | Distinct side-tokens traded.                                         |

### Users

| Column Name    | Description                                                                                             |
| -------------- | ------------------------------------------------------------------------------------------------------- |
| active\_users  | Distinct addresses across maker and taker roles. An address acting as both in the same day counts once. |
| active\_makers | Distinct maker addresses.                                                                               |
| active\_takers | Distinct taker addresses.                                                                               |

### Open Interest

| Column Name                | Description                                    |
| -------------------------- | ---------------------------------------------- |
| total\_open\_interest\_usd | Total open interest in USD for the day.        |
| markets\_with\_oi          | Distinct events with open interest on the day. |

### Cumulative

| Column Name                      | Description                                                                                |
| -------------------------------- | ------------------------------------------------------------------------------------------ |
| cumulative\_trading\_volume\_usd | All-time USD volume up to and including the day, scoped to (category, sub\_category).      |
| cumulative\_notional\_volume     | All-time notional volume up to and including the day, scoped to (category, sub\_category). |
| cumulative\_trade\_count         | All-time trade count up to and including the day, scoped to (category, sub\_category).     |

### Lineage

| Column Name   | Description                              |
| ------------- | ---------------------------------------- |
| unique\_id    | Deterministic unique identifier per row. |
| \_created\_at | Row creation timestamp.                  |
| \_updated\_at | Row last update timestamp.               |

## Sample Query

```sql theme={null}
SELECT
  day,
  category,
  sub_category,
  trading_volume_usd,
  trade_count,
  active_users,
  total_open_interest_usd,
  markets_with_oi
FROM hyperliquid.predictions.metrics_daily
WHERE day >= CURRENT_DATE - 30
ORDER BY day DESC, category, sub_category
```