hyperliquid.metrics.overview table provides comprehensive daily metrics for the Hyperliquid network, including trading volume, fees, open interest, liquidations, bridge flows, and HIP-3 permissionless perpetual activity. This table is updated daily.
Table Details
| Property | Value |
|---|---|
| Table Name | hyperliquid.metrics.overview |
| Table Status | Production-Ready |
| Unique Key | activity_date |
Table Columns
General
| Column Name | Data Type | Description |
|---|---|---|
| activity_date | TIMESTAMP_NTZ(9) | The date of the activity. |
| project | VARCHAR(16777216) | The project of the activity (Hyperliquid). |
| token_price_usd | FLOAT | The price of the token in USD. |
| market_cap_usd | FLOAT | The market cap of the project in USD. |
| total_trade_count | NUMBER(38,0) | Daily total number of trades. |
| total_volume_usd | FLOAT | Daily total trade volume in USD. |
| median_volume_usd | FLOAT | Daily median trade size in USD. |
| avg_volume_usd | FLOAT | Daily average trade size in USD. |
| perpetual_volume_usd | FLOAT | Daily perpetual trade volume in USD. |
| btc_perpetual_volume_usd | FLOAT | Daily BTC perpetual trade volume in USD. |
| eth_perpetual_volume_usd | FLOAT | Daily ETH perpetual trade volume in USD. |
| sol_perpetual_volume_usd | FLOAT | Daily SOL perpetual trade volume in USD. |
| hype_perpetual_volume_usd | FLOAT | Daily HYPE perpetual trade volume in USD. |
| perpetual_trade_count | NUMBER(38,0) | Daily number of perpetual trades. |
| spot_volume_usd | FLOAT | Daily spot trade volume in USD. |
| spot_trade_count | NUMBER(38,0) | Daily number of spot trades. |
| active_buyers | NUMBER(38,0) | Daily number of unique buyers. |
| active_sellers | NUMBER(38,0) | Daily number of unique sellers. |
| unique_perp_markets_traded | NUMBER(38,0) | The daily number of unique perpetual markets traded. |
| unique_spot_markets_traded | NUMBER(38,0) | The daily number of unique spot markets traded. |
| hip3_volume_usd | FLOAT | The daily volume of HIP-3 permissionless perpetual trades in USD. |
| hip3_trade_count | NUMBER(38,0) | The daily number of HIP-3 permissionless perpetual trades. |
| hip3_active_dexes | NUMBER(38,0) | The daily number of unique HIP-3 DEXes with trading activity. |
| hip3_active_deployers | NUMBER(38,0) | The daily number of unique HIP-3 deployers with trading activity. |
| hip3_active_users | NUMBER(38,0) | The daily number of unique users trading on HIP-3 markets. |
| hip3_trading_fees_usd | FLOAT | The daily total trading fees in USD from HIP-3 permissionless perpetual trades. |
| hip3_deployer_fees_usd | FLOAT | The daily total deployer fees in USD from HIP-3 permissionless perpetual trades. Subset of hip3_trading_fees_usd representing the portion that goes to HIP-3 deployers. |
| high_leverage_volume_usd | FLOAT | The daily volume of trades on markets with 20x+ max leverage. |
| medium_leverage_volume_usd | FLOAT | The daily volume of trades on markets with 10-19x max leverage. |
| low_leverage_volume_usd | FLOAT | The daily volume of trades on markets with less than 10x max leverage. |
| liquidations_count | NUMBER(38,0) | Daily total number of liquidations. |
| liquidated_users_count | NUMBER(38,0) | Daily number of unique users liquidated. |
| liquidations_volume_usd | FLOAT | Daily total liquidation volume in USD. |
| total_trading_fees_usd | FLOAT | Daily total trading fees in USD (buyer and seller, perpetual and spot). |
| perpetual_trading_fees_usd | FLOAT | Daily perpetual trading fees in USD (buyer and seller). |
| spot_trading_fees_usd | FLOAT | Daily spot trading fees in USD (buyer and seller). |
| total_builder_fees_usd | FLOAT | Daily total builder fees in USD. |
| total_open_interest_usd | FLOAT | Daily average open interest in USD across perpetual markets. |
| btc_open_interest_usd | FLOAT | Daily average BTC open interest in USD. |
| eth_open_interest_usd | FLOAT | Daily average ETH open interest in USD. |
| sol_open_interest_usd | FLOAT | Daily average SOL open interest in USD. |
| hype_open_interest_usd | FLOAT | Daily average HYPE open interest in USD. |
| bridge_tvl_usd | FLOAT | The daily total value locked in USD from Arbitrum-Hyperliquid bridge. |
| bridge_netflow_usd | FLOAT | The daily total netflow in USD from Arbitrum-Hyperliquid bridge. |
| bridge_inflow_usd | FLOAT | The daily total inflow in USD from Arbitrum-Hyperliquid bridge. |
| bridge_inflow_users | NUMBER(38,0) | The daily total number of unique users who deposited from Arbitrum-Hyperliquid bridge. |
| bridge_inflow_tx_count | NUMBER(38,0) | The daily total number of transactions from Arbitrum-Hyperliquid bridge. |
| bridge_outflow_usd | FLOAT | The daily total outflow in USD from Arbitrum-Hyperliquid bridge. |
| bridge_outflow_users | NUMBER(38,0) | The daily total number of unique users who withdrew from Arbitrum-Hyperliquid bridge. |
| bridge_outflow_tx_count | NUMBER(38,0) | The daily total number of transactions from Arbitrum-Hyperliquid bridge. |
| bridge_total_transactions | NUMBER(38,0) | The daily total number of transactions from Arbitrum-Hyperliquid bridge. Includes both inflow and outflow. |
| active_users | NUMBER(38,0) | Daily number of unique users who transacted. |
| total_transactions | NUMBER(38,0) | Daily total number of transactions. |
| failed_transactions | NUMBER(38,0) | Daily number of failed transactions. |
| success_transactions | NUMBER(38,0) | Daily number of successful transactions. |
| _created_at | TIMESTAMP_NTZ(9) | Row creation timestamp. |
| _updated_at | TIMESTAMP_NTZ(9) | Row last update timestamp. |
| _changed_since_full_refresh | BOOLEAN | Change-tracking flag for row updates. |
Trading Volume
| Column Name | Description | |
|---|---|---|
| total_volume_usd | Daily total trade volume in USD. | Total trading volume in USD on this day across all markets and trade types. |
| total_trade_count | Daily total number of trades. | Total number of trades executed on this day across all trade types. |
| median_volume_usd | Daily median trade size in USD. | Median trade size in USD on this day. |
| avg_volume_usd | Daily average trade size in USD. | Average trade size in USD on this day. |
| perpetual_volume_usd | Daily perpetual trade volume in USD. | Total perpetual trading volume in USD on this day (all trade types). |
| btc_perpetual_volume_usd | Daily BTC perpetual trade volume in USD. | The daily perpetual trading volume in USD for BTC, aggregated from hyperliquid.dex.trades. |
| eth_perpetual_volume_usd | Daily ETH perpetual trade volume in USD. | The daily perpetual trading volume in USD for ETH, aggregated from hyperliquid.dex.trades. |
| sol_perpetual_volume_usd | Daily SOL perpetual trade volume in USD. | The daily perpetual trading volume in USD for SOL, aggregated from hyperliquid.dex.trades. |
| hype_perpetual_volume_usd | Daily HYPE perpetual trade volume in USD. | The daily perpetual trading volume in USD for HYPE, aggregated from hyperliquid.dex.trades. |
| perpetual_trade_count | Daily number of perpetual trades. | Number of perpetual trades executed on this day. |
| spot_volume_usd | Daily spot trade volume in USD. | Total spot trading volume in USD on this day (all trade types). |
| spot_trade_count | Daily number of spot trades. | Number of spot trades executed on this day. |
Trading Fees
| Column Name | Description | |
|---|---|---|
| total_trading_fees_usd | Daily total trading fees in USD (buyer and seller, perpetual and spot). | Total trading fees collected in USD on this day (maker + taker, all markets). |
| perpetual_trading_fees_usd | Daily perpetual trading fees in USD (buyer and seller). | Total trading fees collected from perpetual trades in USD on this day. |
| spot_trading_fees_usd | Daily spot trading fees in USD (buyer and seller). | Total trading fees collected from spot trades in USD on this day. |
| total_builder_fees_usd | Daily total builder fees in USD. | The daily total builder fees in USD, aggregated from hyperliquid.dex.trades. |
Users & Markets
| Column Name | Description | |
|---|---|---|
| active_buyers | Daily number of unique buyers. | Number of unique buyer addresses that executed at least one trade on this day. |
| active_sellers | Daily number of unique sellers. | Number of unique seller addresses that executed at least one trade on this day. |
| unique_perp_markets_traded | The daily number of unique perpetual markets traded. | Number of distinct perpetual markets that had at least one trade on this day. |
| unique_spot_markets_traded | The daily number of unique spot markets traded. | Number of distinct spot markets that had at least one trade on this day. |
HIP-3 Permissionless Perpetuals
| Column Name | Description | |
|---|---|---|
| hip3_volume_usd | The daily volume of HIP-3 permissionless perpetual trades in USD. | The daily volume of HIP-3 permissionless perpetual trades in USD. |
| hip3_trade_count | The daily number of HIP-3 permissionless perpetual trades. | The daily number of HIP-3 permissionless perpetual trades. |
| hip3_active_dexes | The daily number of unique HIP-3 DEXes with trading activity. | The daily number of unique HIP-3 DEXes with trading activity. |
| hip3_active_deployers | The daily number of unique HIP-3 deployers with trading activity. | The daily number of unique HIP-3 deployers with trading activity. |
| hip3_active_users | The daily number of unique users trading on HIP-3 markets. | The daily number of unique users trading on HIP-3 markets. |
| hip3_trading_fees_usd | The daily total trading fees in USD from HIP-3 permissionless perpetual trades. | The daily total trading fees in USD from HIP-3 permissionless perpetual trades. |
| hip3_deployer_fees_usd | The daily total deployer fees in USD from HIP-3 permissionless perpetual trades. Subset of hip3_trading_fees_usd representing the portion that goes to HIP-3 deployers. | The daily total deployer fees in USD from HIP-3 permissionless perpetual trades. This is a subset of hip3_trading_fees_usd representing the portion that goes to HIP-3 deployers. |
Leverage Breakdown
| Column Name | Description | |
|---|---|---|
| high_leverage_volume_usd | The daily volume of trades on markets with 20x+ max leverage. | Trading volume on markets with 20x or higher maximum leverage on this day. |
| medium_leverage_volume_usd | The daily volume of trades on markets with 10-19x max leverage. | Trading volume on markets with 10-19x maximum leverage on this day. |
| low_leverage_volume_usd | The daily volume of trades on markets with less than 10x max leverage. | Trading volume on markets with less than 10x maximum leverage on this day. |
Liquidations
| Column Name | Description | |
|---|---|---|
| liquidations_count | Daily total number of liquidations. | Number of liquidation events on this day. |
| liquidated_users_count | Daily number of unique users liquidated. | Number of unique accounts that were liquidated on this day. |
| liquidations_volume_usd | Daily total liquidation volume in USD. | Total liquidation volume in USD on this day. |
Open Interest
| Column Name | Description | |
|---|---|---|
| total_open_interest_usd | Daily average open interest in USD across perpetual markets. | Sum across perpetual coins of each coin’s daily-average USD open interest (native and HIP-3). Single-sided base-coin open interest valued at oracle price. Not HIP-4 prediction-market open interest. |
| btc_open_interest_usd | Daily average BTC open interest in USD. | Daily average USD open interest for BTC perpetuals. Single-sided base-coin open interest valued at oracle price, averaged over the day. |
| eth_open_interest_usd | Daily average ETH open interest in USD. | Daily average USD open interest for ETH perpetuals. Single-sided base-coin open interest valued at oracle price, averaged over the day. |
| sol_open_interest_usd | Daily average SOL open interest in USD. | Daily average USD open interest for SOL perpetuals. Single-sided base-coin open interest valued at oracle price, averaged over the day. |
| hype_open_interest_usd | Daily average HYPE open interest in USD. | Daily average USD open interest for HYPE perpetuals. Single-sided base-coin open interest valued at oracle price, averaged over the day. |
Bridge Activity
| Column Name | Description | |
|---|---|---|
| bridge_tvl_usd | The daily total value locked in USD from Arbitrum-Hyperliquid bridge. | The daily total value locked in USD from Arbitrum-Hyperliquid bridge. |
| bridge_netflow_usd | The daily total netflow in USD from Arbitrum-Hyperliquid bridge. | The daily total netflow in USD from Arbitrum-Hyperliquid bridge. |
| bridge_inflow_usd | The daily total inflow in USD from Arbitrum-Hyperliquid bridge. | The daily total inflow in USD from Arbitrum-Hyperliquid bridge. |
| bridge_inflow_users | The daily total number of unique users who deposited from Arbitrum-Hyperliquid bridge. | The daily total number of unique users who deposited from Arbitrum-Hyperliquid bridge. |
| bridge_inflow_tx_count | The daily total number of transactions from Arbitrum-Hyperliquid bridge. | The daily total number of transactions from Arbitrum-Hyperliquid bridge. |
| bridge_outflow_usd | The daily total outflow in USD from Arbitrum-Hyperliquid bridge. | The daily total outflow in USD from Arbitrum-Hyperliquid bridge. |
| bridge_outflow_users | The daily total number of unique users who withdrew from Arbitrum-Hyperliquid bridge. | The daily total number of unique users who withdrew from Arbitrum-Hyperliquid bridge. |
| bridge_outflow_tx_count | The daily total number of transactions from Arbitrum-Hyperliquid bridge. | The daily total number of transactions from Arbitrum-Hyperliquid bridge. |
| bridge_total_transactions | The daily total number of transactions from Arbitrum-Hyperliquid bridge. Includes both inflow and outflow. | The daily total number of transactions from Arbitrum-Hyperliquid bridge. Includes both inflow and outflow. |
Transactions
| Column Name | Description | |
|---|---|---|
| total_transactions | Daily total number of transactions. | Total number of transactions processed in this aggregated time period or entity scope. |
| active_users | Daily number of unique users who transacted. | Number of unique users (buyers + sellers, deduplicated) that traded on this day. |
| failed_transactions | Daily number of failed transactions. | Number of transactions that reverted or failed (receipt_status = 0) on this date. |
| success_transactions | Daily number of successful transactions. | Number of transactions that executed successfully (receipt_status = 1) on this date. |
Lineage
| Column Name | Description | |
|---|---|---|
| _created_at | Row creation timestamp. | Timestamp (UTC) when this row was first written to the Allium platform. Set once on insert and never changed. |
| _updated_at | Row last update timestamp. | Timestamp (UTC) of the most recent update to this row in the Allium platform. Advances when the row is reprocessed or enriched (e.g. USD price hydration). |
| _changed_since_full_refresh | Change-tracking flag for row updates. | Flag indicating whether this row was created or modified after the last full refresh of the model. Useful for identifying recently added or updated records in incremental processing. Same concept as _change_since_full_refresh — the column name varies by model generation. |