rwa_hyperliquid.perp_metrics_daily

rwa_hyperliquid.perp_metrics_daily is the daily rollup of perp_metrics_hourly. Grain: one row per market per day, keyed on (block_month, block_date, perp_dex, coin). This is the right table for trend charts, day-over-day comparisons, and market league tables.

Table schema

Column	Type	Description
`block_month`	`DATE`	Partition column
`block_date`	`DATE`	Day bucket, UTC
`blockchain`	`VARCHAR`	Always `hyperliquid`
`perp_dex`	`VARCHAR`	Builder DEX short code
`market_symbol`	`VARCHAR`	Market ticker within the builder DEX
`coin`	`VARCHAR`	Full market id in `dex:SYMBOL` form
`asset_id`	`INTEGER`	HIP-3 asset id
`asset_class`	`VARCHAR`	RWA classification: `rates`, `equities`, `credit`, `fx`, `commodities`, `private_funds`, `real_estate`
`asset_type`	`VARCHAR`	Finer classification within `asset_class`
`underlying_ticker`	`VARCHAR`	Ticker of the referenced real-world instrument
`builder_name`	`VARCHAR`	Builder DEX full name
`trades_count`	`BIGINT`	Taker fills in the day
`volume_usd`	`DOUBLE`	Taker-leg notional volume in USD. Matches Hyperliquid’s reported `dayNtlVlm`
`volume_units`	`DOUBLE`	Volume in contract units
`buy_volume_usd`	`DOUBLE`	Taker buy volume
`sell_volume_usd`	`DOUBLE`	Taker sell volume
`unique_takers`	`BIGINT`	Distinct taker addresses in the day
`vwap`	`DOUBLE`	Volume-weighted average fill price
`open_interest_units`	`DOUBLE`	End-of-day open interest in contract units, both sides summed
`open_interest_usd`	`DOUBLE`	End-of-day open interest valued in USD
`open_positions`	`BIGINT`	Count of open positions at end of day
`funding_rate`	`DOUBLE`	Funding rate for the day
`funding_rate_annualized`	`DOUBLE`	Funding rate annualized
`_updated_at`	`TIMESTAMP`	When this row was last written by the pipeline

Flow versus stock

Two different kinds of measure share this table, and they aggregate differently:

Flows — volume_usd, volume_units, buy_volume_usd, sell_volume_usd, trades_count. Sum these across days.
Stocks — open_interest_units, open_interest_usd, open_positions. These are point-in-time end-of-day snapshots. Take the last value or an average; never sum them across days.

unique_takers is a distinct count within each day, so summing it across days double-counts anyone who traded on more than one day.

Open interest is both-sides

open_interest_units and open_interest_usd sum longs and shorts to match the Hyperliquid UI. One-sided open interest, the convention most traditional venues report, is half:

open_interest_units / 2 AS one_sided_open_interest

The current day is always partial

Today’s row is incomplete until the day closes. Filter it out for trend work:

WHERE block_date < current_date

Example query

-- Market league table over the last 30 complete days
SELECT
  market_symbol,
  builder_name,
  asset_class,
  SUM(volume_usd) AS volume_usd_30d,
  SUM(trades_count) AS fills_30d,
  MAX_BY(open_interest_usd, block_date) AS latest_open_interest_usd
FROM rwa_hyperliquid.perp_metrics_daily
WHERE block_date >= current_date - INTERVAL '30' day
  AND block_date < current_date
GROUP BY 1, 2, 3
ORDER BY 4 DESC
LIMIT 30

Asset class trend, tokenized versus synthetic comparison starting point:

SELECT
  block_date,
  asset_class,
  SUM(volume_usd) AS volume_usd,
  SUM(open_interest_usd) AS open_interest_usd
FROM rwa_hyperliquid.perp_metrics_daily
WHERE block_date >= current_date - INTERVAL '90' day
  AND block_date < current_date
GROUP BY 1, 2
ORDER BY 1 DESC, 3 DESC

Note that summing open_interest_usd across markets within one day is valid — those are distinct positions at the same instant. Summing it across days is not.

Curated Data

Solana

Hyperliquid

Non-EVM Networks

Protocols

EVM Networks

Partner Data

Dune Index

rwa_hyperliquid.perp_metrics_daily

Table schema

Flow versus stock

Open interest is both-sides

The current day is always partial

Example query

​Table schema

​Flow versus stock

​Open interest is both-sides

​The current day is always partial

​Example query

Table schema

Flow versus stock

Open interest is both-sides

The current day is always partial

Example query