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

# Perpetual Positions

> Perpetual position data for users on Hyperliquid

The `hyperliquid.raw.perpetual_positions` table contains perpetual position data for users on Hyperliquid.

## Table Columns

| Column Name                        | Description                                          |
| ---------------------------------- | ---------------------------------------------------- |
| timestamp                          | The UTC timestamp of the position snapshot           |
| user                               | The address of the user                              |
| type                               | The position type (e.g., oneWay)                     |
| coin                               | The asset symbol                                     |
| size                               | The position size                                    |
| leverage\_type                     | The type of leverage (e.g., cross, isolated)         |
| leverage\_value                    | The leverage value                                   |
| max\_leverage                      | Maximum leverage allowed                             |
| entry\_px                          | Entry price                                          |
| position\_value                    | Current position value                               |
| unrealized\_pnl                    | Unrealized profit and loss                           |
| return\_on\_equity                 | Return on equity                                     |
| liquidation\_price                 | Liquidation price                                    |
| margin\_used                       | Margin used for the position                         |
| cumulative\_funding\_all\_time     | Cumulative funding paid/received all time            |
| cumulative\_funding\_since\_open   | Cumulative funding paid/received since position open |
| cumulative\_funding\_since\_change | Cumulative funding paid/received since last change   |