> ## Documentation Index
> Fetch the complete documentation index at: https://docs.allium.so/llms.txt
> Use this file to discover all available pages before exploring further.

# Position Changes

One row per change to a Solana perpetuals position (increase, decrease, or liquidation). Currently Jupiter Perpetuals.

### Table Columns

| 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.           |