Trades

solana.perpetuals.trades contains one row per position-change event across perpetual futures protocols on the Solana network. action distinguishes an increase, a decrease, or a liquidation. Liquidations are also available on their own in Liquidations. Current coverage includes Jupiter Perpetuals. JLP pool swaps are not perpetual positions and are available in DEX Trades.

Table Columns

Column Name	Description	Type	Example
project	The perpetuals project.	varchar	jupiter
protocol	The specific protocol within the project.	varchar	jupiter_perpetual
version	Protocol version.	varchar	v1
chain	Blockchain network.	varchar	solana
block_timestamp	Block timestamp of the event.	timestamp_ntz	2025-10-03 00:05:16
block_date	Calendar date of the event (UTC).	date	2025-10-03
block_slot	Solana block slot of the event.	number	370,803,166
txn_id	Transaction signature.	varchar	Y7H5Bv317NZjPSA17APBrx3n1UPEzxrrWg7qbpCpQwKx
unique_id	Unique identifier for the row.	varchar	txn_id-Y7H5Bv3…_i_index-4_ii_index-1
trader	Wallet address that owns the position.	varchar	5ve4GVLRz848vzNJZgb1di1wqiW8UpmmnVUYcoyEuKoQ
market_symbol	Symbol of the underlying market asset.	varchar	SOL
asset_mint	Mint address of the underlying market asset.	varchar	So11111111111111111111111111111111111111112
side	Position side: long or short.	varchar	short
action	Event type: increase, decrease, or liquidation.	varchar	increase
size_usd	Notional size change of the position in USD. For a liquidation, the position size closed.	number	299540.587699
price_usd	Underlying asset price in USD at the event.	number	233.720000
collateral_usd	Collateral added on an increase or returned on a decrease, in USD. Null on liquidations.	number	24966.935947
pnl_usd	Realized profit or loss in USD. Null on increases.	number	-7.939954
fee_usd	Total fee for the event in USD.	number	239.681462
extra_fields	VARIANT column with protocol-specific detail, including the fee breakdown, position and custody keys, and collateral flows.	variant	`{"event_name": "InstantIncreasePositionEvent", "position_fee_usd": 209.678412, "funding_fee_usd": 0.048991, "price_impact_fee_usd": 29.954059}`

Sample Query

SELECT *
FROM solana.perpetuals.trades
WHERE block_date = '2026-07-01'
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