Trades

arbitrum.perpetuals.trades contains one row per position-change event for GMX perpetual futures on Arbitrum. action distinguishes an increase, a decrease, or a liquidation. Liquidations are also available on their own in Liquidations. Current coverage includes GMX v1 and v2. market_symbol and price_usd may be null for some synthetic markets.

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	arbitrum
block_timestamp	Block timestamp of the event.	timestamp_ntz	2026-07-23 14:10:28
block_date	Calendar date of the event (UTC).	date	2026-07-23
block_number	Block number containing the event.	number	486,898,144
transaction_hash	Transaction hash.	varchar	0xd496a6b5a84803326c9a7a89717ae45f2bcefd9f366d38cb2163037ba8365c83
log_index	Position of the event log within the block.	number	44
unique_id	Unique identifier for the row.	varchar	txn-0xd496a6b5…_log_index-44
trader	Wallet address that owns the position.	varchar	0x8dd867135e5b57c22f6c482795fc0b89f0a2a6d2
market_address	GMX market address.	varchar	0x47c031236e19d024b42f8ae6780e44a573170703
market_symbol	Symbol of the market’s index token.	varchar	BTC
asset_address	Address of the index (traded) token.	varchar	0x47904963fc8b2340414262125af798b9655e58cd
side	Position side: long or short.	varchar	long
action	Event type: increase, decrease, or liquidation.	varchar	increase
size_usd	Notional size in USD: the size change on an increase or decrease, and the full position size closed on a liquidation.	number	14831.856577
price_usd	Index token price in USD at the event.	number	64901.777687
collateral_usd	Collateral added on an increase or returned on a decrease, in USD.	number	370.773842
pnl_usd	Realized profit or loss in USD. Null on increases.	number
fee_usd	Total fee charged to the trader for the event, in USD.	number	8.899113
extra_fields	VARIANT column with protocol-specific detail.	variant

Sample Query

SELECT *
FROM arbitrum.perpetuals.trades
WHERE block_date = '2026-07-23'
LIMIT 100;

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