Trades 🌱 - Allium Documentation Hub

Table Details

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

monad.perpetuals.trades has one row per position-change event: open, increase, decrease, close, liquidation, and auto-deleveraging. Both sides of a match are rows (maker and taker), so use total_volume_usd on overview for volume rather than summing size_usd. A fill that flips a position from long to short (or back) is two rows: a decrease that closes the old side and an increase that opens the new side. 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 whose position changed.
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)	Collateral token address (AUSD, `0x00000000efe302beaa2b3e6e1b18d08d69a9012a`).
side	VARCHAR(16777216)	Position side: long or short.
action	VARCHAR(16777216)	Position action: increase, decrease, or liquidation.
size_usd	NUMBER(38,6)	Notional size of the position change in USD. For a liquidation, the size liquidated at the liquidation price.
price_usd	NUMBER(38,6)	Execution price in USD. For a liquidation, the liquidation price.
collateral_usd	NUMBER(38,6)	Collateral held by the position after the event, in USD.
pnl_usd	NUMBER(38,6)	Realized profit or loss in USD on decreases, closes, inversions, liquidations, and auto-deleveraging. Null on increases.
fee_usd	NUMBER(38,6)	Trading fee paid on the event in USD. On opens and increases, the exchange splits this same fee between its insurance fund and the protocol; the split is in `extra_fields` and is not an additional charge.
extra_fields	VARIANT	Protocol-specific detail: event name, perpetual and account ids, maker or taker role, order id, leverage, funding, the insurance, protocol, and builder fee split, lot sizes and deposits before and after the event, close reason, inversion leg, and liquidation amounts.
_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_timestamp, trader, market_symbol, side, action, size_usd, price_usd, pnl_usd, fee_usd, transaction_hash
FROM monad.perpetuals.trades
WHERE block_timestamp >= current_date - 7
  AND project = 'perpl'
ORDER BY block_timestamp DESC
LIMIT 100;

EVM

​Table Details

​Table Columns

​Sample Query

Table Details

Table Columns

Sample Query