Liquidations

solana.perpetuals.liquidations contains perpetual position liquidations across perpetual futures protocols on the Solana network. Each row is a liquidation event and shares the same schema as Trades, with action always liquidation. Current coverage includes Jupiter Perpetuals.

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 liquidation.	timestamp_ntz	2026-07-03 00:30:09
block_date	Calendar date of the liquidation (UTC).	date	2026-07-03
block_slot	Solana block slot of the liquidation.	number	430,414,010
txn_id	Transaction signature.	varchar	4ZS6W7U9tZWn5zfsDhGE6gs6NEXqmwdWMxn7gy1Me37
unique_id	Unique identifier for the row.	varchar	txn_id-4ZS6W7U9…_i_index-4_ii_index-0
trader	Wallet address that owned the liquidated position.	varchar	DifWLCVuiSfBm1JXQBv6Pygjr5wsq9zPFaEsg6PpYWYq
market_symbol	Symbol of the underlying market asset.	varchar	ETH
asset_mint	Mint address of the underlying market asset.	varchar	7vfCXTUXx5WJV5JADk17DUJ4ksgau7utNKj4b963voxs
side	Position side: long or short.	varchar	long
action	Event type. Always liquidation for this table.	varchar	liquidation
size_usd	Position size closed by the liquidation, in USD.	number	5475.555500
price_usd	Underlying asset price in USD at the liquidation.	number	1695.243378
collateral_usd	Null for liquidations.	number	null
pnl_usd	Realized profit or loss in USD.	number	-7.939954
fee_usd	Total fee for the liquidation in USD.	number	15.324197
extra_fields	VARIANT column with protocol-specific detail, including the fee breakdown, position and custody keys, and the liquidation fee.	variant	`{"event_name": "LiquidateFullPositionEvent", "liquidation_fee_usd": 10.941852, "original_collateral_usd": 22.716596}`

Sample Query

SELECT *
FROM solana.perpetuals.liquidations
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