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 |