Position Changes

One row per change to a Solana perpetuals position (increase, decrease, or liquidation). 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.
block_timestamp	TIMESTAMP_NTZ(9)	Block timestamp of the event.
block_date	DATE	Calendar date of the event (UTC).
block_slot	INTEGER	Solana block slot of the event.
txn_id	VARCHAR	Transaction signature.
unique_id	VARCHAR	Allium unique identifier for the row.
leg_id	VARCHAR	Identifier for this position leg within the transaction.
trader	VARCHAR	Address of the trader whose position changed.
market_symbol	VARCHAR	Market symbol (e.g. SOL-USD).
side	VARCHAR	Position side (`long` or `short`).
action	VARCHAR	Type of change: `increase`, `decrease`, or `liquidation`.
size_base	FLOAT	Absolute base-asset size of the change.
signed_base_delta	FLOAT	Signed change in base-asset position (positive opens/increases a long).
prev_base_amount	FLOAT	Base-asset position size before this change.
new_base_amount	FLOAT	Base-asset position size after this change.
size_usd	FLOAT	Notional USD size of the change.
price_usd	FLOAT	Execution price in USD.
fee_usd	FLOAT	Total fee paid for this change, in USD.
extra_fields	VARIANT	Protocol-specific fields not promoted to first-class columns.