Positions Daily

Daily snapshot of open Solana perpetuals positions per trader and market (currently Jupiter Perpetuals).

Column Name	Data Type	Description
project	VARCHAR	The perpetuals project.
protocol	VARCHAR	The specific protocol within the project.
version	VARCHAR	Protocol version.
chain	VARCHAR	Blockchain network.
activity_date	DATE	Calendar date (UTC) of the snapshot.
trader	VARCHAR	Address of the trader.
market_index	INTEGER	Protocol market index.
market_symbol	VARCHAR	Market symbol (e.g. SOL-USD).
side	VARCHAR	Position side (`long` or `short`).
size_base	FLOAT	Position size in base-asset units.
price_usd	FLOAT	Mark or oracle price in USD used to value the position.
position_value_usd	FLOAT	Notional USD value of the position.
entry_px	FLOAT	Average entry price in USD.
liquidation_price	FLOAT	Estimated liquidation price in USD.
margin_used	FLOAT	Margin allocated to this position, in USD.
extra_fields	VARIANT	Protocol-specific fields not promoted to first-class columns.