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.
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).
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.
Table Columns
Identifiers
| Column Name | Description |
|---|
| project | Always ‘hyperliquid’. |
| protocol | Always ‘hyperliquid_hip4’. |
| chain | Always ‘hyperliquid’. |
| day | Date bucket (UTC). |
| category | 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 | USDH-denominated trade volume for the day. |
| notional_volume | Trade volume in HL contract units (1 contract = $1 USDH 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 | USDH-denominated buyer-side fee revenue. |
| total_seller_fee_usd | USDH-denominated seller-side fee revenue. |
| 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
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
