Fees 🌱 - Allium Documentation Hub

Table Details

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

arbitrum.perpetuals.fees contains one row per fee event or execution-spread component. fee_type identifies position, liquidation, swap, mint, and redeem fees, while revenue_usd reports the protocol-retained share. Current coverage includes GMX v1 and v2 and Ostium v1. Ostium fee_usd can be negative when funding is a rebate. Ostium revenue_usd includes opening developer fees, oracle fees (refunds are negative), and execution spread from 2026-04-28 00:00 UTC. Before that timestamp, spread revenue_usd is 0. Close, builder, vault, rollover, funding, and liquidation components contribute 0. trades.fee_usd already includes execution spread.

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 Ostium and GMX fees without a specific market contract.
market_symbol	VARCHAR(16777216)	GMX index-token symbol or Ostium market pair.
asset_address	VARCHAR(42)	Address of the token the fee is denominated in. Ostium: USDC.
fee_type	VARCHAR(16777216)	Fee category: position, liquidation, swap, mint, or redeem. Ostium: position or liquidation.
fee_usd	NUMBER(38,6)	Fee amount in USD. Refunds and signed funding adjustments can be negative.
revenue_usd	NUMBER(38,6)	Protocol-retained share in USD. For Ostium: opening developer fees, oracle fees (refunds are negative), and execution spread from 2026-04-28 00:00 UTC. Close, builder, vault, rollover, funding, and liquidation components contribute zero.
extra_fields	VARIANT	Protocol-specific fee components, identifiers, raw amounts, and transaction context.
_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 arbitrum.perpetuals.fees
WHERE project = 'ostium'
LIMIT 10;

​Table Details

​Table Columns

​Sample Query

Table Details

Table Columns

Sample Query