Fees 🌱 - Allium Documentation Hub

Table Details

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

monad.perpetuals.fees has one row per fee: one row per maker or taker fill with a non-zero fee, plus the insurance fund and protocol shares of each liquidation. Each fill fee is counted once. revenue_usd is the share the protocol keeps after the builder fee and the insurance fund share. Maker rebates and referral rewards are paid to accounts separately and are not netted out of revenue_usd. Coverage is Perpl (project = 'perpl', protocol = 'perpl', version = 'v1'). See Perpl for venue notes.

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 event.
block_date	DATE	Calendar date of the 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 transaction.
unique_id	VARCHAR(16777216)	Unique identifier for the row.
trader	VARCHAR(42)	Address of the account charged the fee. Null for order expiry (recycle) fees.
market_address	VARCHAR(42)	Null. Perpl markets are numbered markets on one exchange contract, not separate contracts.
market_symbol	VARCHAR(16777216)	Market symbol as base-USD, for example BTC-USD. A relisted market keeps its symbol and has a new `pair_index`.
asset_address	VARCHAR(42)	Address of the fee token (AUSD, `0x00000000efe302beaa2b3e6e1b18d08d69a9012a`).
fee_type	VARCHAR(16777216)	Fee family: `position` for trading fees and order expiry (recycle) fees, `liquidation` for the insurance and protocol shares of a liquidated position’s remaining margin.
fee_usd	NUMBER(38,6)	Fee amount in USD.
revenue_usd	NUMBER(38,6)	Share of `fee_usd` retained by the protocol, in USD: the trading fee net of the builder fee and the insurance fund share, and the protocol share of liquidations and order expiry fees.
extra_fields	VARIANT	Protocol-specific fee detail: fee component, maker or taker role, perpetual and account ids, builder id, builder fee, and insurance fund share.
_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 block_date, fee_type, sum(fee_usd) AS fees_usd, sum(revenue_usd) AS revenue_usd
FROM monad.perpetuals.fees
WHERE block_timestamp >= current_date - 30
  AND project = 'perpl'
GROUP BY 1, 2
ORDER BY 1 DESC, 2;

EVM

​Table Details

​Table Columns

​Sample Query

Table Details

Table Columns

Sample Query