Fees 🌱 - Allium Documentation Hub

Table Details

Property	Value
Table Name	`megaeth.perpetuals.fees`
Table Status	Beta 🌱
Unique Key	`block_timestamp`, `unique_id`

megaeth.perpetuals.fees contains one row per GMX fee event on MegaETH. fee_type categorizes each event as a position, liquidation, or swap fee, and revenue_usd gives the protocol’s retained share. Current coverage includes GMX v2.

Table Columns

Column Name	Data Type	Description
project	VARCHAR(16777216)	The perpetuals project.
protocol	VARCHAR(16777216)	The specific protocol within the project.
version	VARCHAR(16777216)	Protocol version.
chain	VARCHAR(16777216)	Blockchain network.
block_timestamp	TIMESTAMP_NTZ(9)	Block timestamp of the fee event.
block_date	DATE	Calendar date of the fee event (UTC).
block_number	NUMBER(38,0)	Block number containing the event.
transaction_hash	VARCHAR(66)	Transaction hash.
log_index	NUMBER(38,0)	Position of the event log within the block.
unique_id	VARCHAR(16777216)	Unique identifier for the row.
trader	VARCHAR(42)	Wallet address charged the fee. Null for pool swap fees, which are not attributable to a single trader.
market_address	VARCHAR(42)	GMX market address. Null for swap fees, which are not tied to a single market.
market_symbol	VARCHAR(16777216)	Symbol of the market’s index token.
asset_address	VARCHAR(42)	Address of the token the fee is denominated in.
fee_type	VARCHAR(16777216)	Fee category: position, liquidation, or swap.
fee_usd	NUMBER(38,6)	Total fee for the event in USD.
revenue_usd	NUMBER(38,6)	Protocol’s retained share of the fee in USD.
extra_fields	VARIANT	VARIANT column with protocol-specific fee detail.
_created_at	TIMESTAMP_NTZ(9)	Timestamp of when the entry was created in the database.
_updated_at	TIMESTAMP_NTZ(9)	Timestamp of when the entry was last updated in the database.

Sample Query

SELECT *
FROM megaeth.perpetuals.fees
WHERE block_date = '2026-04-10'
LIMIT 100;