Metrics

megaeth.perpetuals.overview contains daily protocol metrics for on-chain perpetual futures protocols on MegaETH, with one row per activity_date, project, protocol, and version. It reports trading volume, open interest split by side, fees, revenue, and activity counts. Current coverage includes GMX (v2). Universal metrics are top-level columns; protocol-specific metrics are in extra_fields. A metric a protocol does not report is left null.

Table Columns

Column Name	Description	Type	Example
project	The perpetuals project.	varchar	gmx
protocol	The specific protocol within the project.	varchar	gmx
version	Protocol version.	varchar	v2
chain	Blockchain network.	varchar	megaeth
activity_date	Calendar date of the metrics (UTC).	date	2026-07-23
unique_id	Unique identifier for the row.	varchar	project-gmx_protocol-gmx_version-v2_activity_date-2026-07-23
total_tvl_usd	Total value locked in USD on the day.	number
total_volume_usd	Total trading volume in USD on the day.	number	3988.454143
total_volume_24h_usd	Reported trailing 24-hour trading volume in USD.	number
cumulative_volume_usd	All-time trading volume in USD up to and including the day.	number	26666968.302262
total_open_interest_usd	Total open interest in USD at the end of the day.	number	23538.273187
long_open_interest_usd	Open interest held in long positions in USD.	number	11099.482460
short_open_interest_usd	Open interest held in short positions in USD.	number	12438.790730
total_revenue_usd	Protocol revenue in USD on the day.	number	1.999215
cumulative_revenue_usd	All-time protocol revenue in USD up to and including the day.	number	8258.038846
total_fees_usd	Total fees in USD on the day.	number	4.021226
cumulative_fees_usd	All-time fees in USD up to and including the day.	number	26841.922913
trade_count	Number of trades on the day.	number	3
liquidations_count	Number of liquidations on the day.	number	0
deposit_count	Number of user deposits on the day.	number
deposit_usd	Total user deposit value in USD on the day.	number
withdrawal_count	Number of user withdrawals on the day.	number
withdrawal_usd	Total user withdrawal value in USD on the day.	number
active_users	Number of distinct active users on the day.	number	3
extra_fields	VARIANT column with protocol-specific daily metrics.	variant

Sample Query

SELECT *
FROM megaeth.perpetuals.overview
WHERE activity_date = '2026-07-23'
ORDER BY total_volume_usd DESC;

Overview

Data Verticals

Solana

Hyperliquid

Lighter

Bitcoin Ecosystem

EVM

Cosmos Ecosystem

Move Ecosystem

Other Ecosystems

Table Columns

Sample Query

​Table Columns

​Sample Query

Table Columns

Sample Query