Hyperliquid

Hyperliquid Schema Description and Methodology

This schema contains comprehensive on-chain datasets for tracking Hyperliquid fundamental data across multiple metrics categories, including trading activity, fees, revenue streams, and token economics.

Available Tables

Hyperliquid data is available in two main tables:

• ez_metrics: Aggregated metrics for the entire Hyperliquid protocol with detailed token supply data
• ez_metrics_by_chain: Contains the same metrics as ez_metrics (where applicable), but broken down by blockchain. Use this table when you need to analyze performance across different chains.

Table Schema

Trading and Activity Metrics

Table Name	Column Name	Description
ez_metrics	perp_volume	The total trading volume on Hyperliquid’s perps exchange
ez_metrics	perp_dau	The number of unique traders on Hyperliquid’s perps exchange
ez_metrics	perp_txns	The total number of trades on Hyperliquid’s perps exchange
ez_metrics	spot_volume	The total volume on Hyperliquid’s spot exchange
ez_metrics	trading_volume	Combined total of perp_volume and spot_volume (legacy naming)
ez_metrics	unique_traders	Same as perp_dau - number of unique traders (legacy naming)
ez_metrics	txns	Same as perp_txns - total number of trades (legacy naming)
ez_metrics	num_stakers	Number of HYPE stakers
ez_metrics	staked_hype	Amount of HYPE tokens staked

Fee and Revenue Metrics

Table Name	Column Name	Description
ez_metrics	perp_fees	The fees generated by traders on Hyperliquid’s perps exchange
ez_metrics	spot_fees	The total amount of fees (in USD) on Hyperliquid’s spot exchange
ez_metrics	chain_fees	The total transaction fees paid on the HyperEVM
ez_metrics	ecosystem_revenue	Gross protocol revenue includes layer 1 transaction fees and trading fees, composed of spot fees, perp fees, and auction fees
ez_metrics	fees	Total trading fees (legacy naming)
ez_metrics	auction_fees	Fees generated from liquidation auctions
ez_metrics	revenue	Combined revenue from buybacks and burns (legacy naming)

Cash Flow Distribution Metrics

Table Name	Column Name	Description
ez_metrics	burned_cash_flow	The portion of protocol revenue that results in burns in USD. On Hyperliquid, all transaction fees paid on the L1 are burned
ez_metrics	burned_cash_flow_native	The portion of protocol revenue that results in burns in native tokens
ez_metrics	buyback_cash_flow	A portion of protocol revenue (97%) is allocated to the Assistance Fund (AF) for HYPE buybacks
ez_metrics	buybacks_native	The amount of tokens actually bought back by the protocol in native token units
ez_metrics	service_cash_flow	A portion of protocol revenue (3%) is allocated to the Hyperliquidity Provider (HLP)
ez_metrics	primary_supply_side_revenue	Revenue allocated to liquidity providers (3% of trading fees) (legacy naming)
ez_metrics	daily_burn	Amount of tokens burned daily (legacy naming)
ez_metrics	daily_buybacks_native	Amount of HYPE bought back daily in native tokens (legacy naming)

Market and Token Metrics

Table Name	Column Name	Description
ez_metrics	price	The price of HYPE in USD
ez_metrics	market_cap	The market cap of HYPE token in USD
ez_metrics	fdmc	The fully diluted market cap of HYPE token in USD
ez_metrics	token_volume	The trading volume of HYPE token in USD
ez_metrics	token_turnover_circulating	The turnover of HYPE based on circulating supply
ez_metrics	token_turnover_fdv	The turnover of HYPE based on fully diluted valuation

Token Supply Metrics

Table Name	Column Name	Description
ez_metrics	circulating_supply_native	The circulating supply of HYPE in native tokens
ez_metrics	net_supply_change_native	The net change in the circulating supply of HYPE in native tokens
ez_metrics	emissions_native	The amount of new HYPE tokens emitted
ez_metrics	premine_unlocks_native	The amount of native tokens unlocked from premine
ez_metrics	burns_native	The amount of HYPE tokens burned

Sample Queries

Trading Activity Analysis

-- Analyze Hyperliquid trading activity
SELECT
    date,
    perp_volume,
    spot_volume,
    perp_dau,
    perp_txns
FROM
    art_share.hyperliquid.ez_metrics
WHERE
    date >= DATEADD(month, -3, CURRENT_DATE())
ORDER BY
    date ASC

Revenue Stream Breakdown

-- Analyze Hyperliquid revenue streams
SELECT
    date,
    ecosystem_revenue,
    perp_fees,
    spot_fees,
    chain_fees
FROM
    art_share.hyperliquid.ez_metrics
WHERE
    date >= DATEADD(month, -3, CURRENT_DATE())
ORDER BY
    date ASC

Cash Flow Distribution

-- Track how Hyperliquid revenue is distributed
SELECT
    date,
    ecosystem_revenue,
    buyback_cash_flow,
    service_cash_flow,
    burned_cash_flow
FROM
    art_share.hyperliquid.ez_metrics
WHERE
    date >= DATEADD(month, -1, CURRENT_DATE())
ORDER BY
    date ASC

Token Economics Analysis

-- Track HYPE token supply changes
SELECT
    date,
    price,
    circulating_supply_native,
    emissions_native,
    premine_unlocks_native,
    burns_native,
    net_supply_change_native
FROM
    art_share.hyperliquid.ez_metrics
WHERE
    date >= '2023-06-01'
ORDER BY
    date ASC

Cross-Chain Comparison

-- Compare metrics across chains
SELECT
    date,
    chain,
    perp_volume,
    perp_dau,
    ecosystem_revenue,
    burned_cash_flow
FROM
    art_share.hyperliquid.ez_metrics_by_chain
WHERE
    date >= DATEADD(month, -1, CURRENT_DATE())
ORDER BY
    chain, date ASC