Metrics Daily

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

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

Overview

Data Verticals

Solana

Hyperliquid

Lighter

Bitcoin Ecosystem

EVM

Cosmos Ecosystem

Move Ecosystem

Other Ecosystems

Table Columns

Identifiers

Volume & Trade Counts

Fees

Synthetic Mints

Market Coverage

Users

Open Interest

Cumulative

Lineage

Sample Query

​Table Columns

​Identifiers

​Volume & Trade Counts

​Fees

​Synthetic Mints

​Market Coverage

​Users

​Open Interest

​Cumulative

​Lineage

​Sample Query

Table Columns

Identifiers

Volume & Trade Counts

Fees

Synthetic Mints

Market Coverage

Users

Open Interest

Cumulative

Lineage

Sample Query