hyperliquid.raw.perpetual_positions table contains perpetual position data for users on Hyperliquid.
Table Details
| Property | Value |
|---|---|
| Table Name | hyperliquid.raw.perpetual_positions |
| Table Status | Production-Ready |
| Unique Key | timestamp, user, type, coin |
| Clustering Key(s) | to_date("timestamp") |
| Search Optimization | user, coin |
Table Columns
| Column Name | Data Type | Description |
|---|---|---|
| timestamp | TIMESTAMP_NTZ(9) | The UTC timestamp of the position snapshot |
| user | VARCHAR(16777216) | The address of the user |
| type | VARCHAR(16777216) | The position type (e.g., oneWay) |
| coin | VARCHAR(16777216) | The asset symbol |
| size | VARCHAR(16777216) | The position size |
| leverage_type | VARCHAR(16777216) | The type of leverage (e.g., cross, isolated) |
| leverage_value | NUMBER(38,0) | The leverage value |
| entry_px | VARCHAR(16777216) | Entry price |
| position_value | VARCHAR(16777216) | Current position value |
| unrealized_pnl | VARCHAR(16777216) | Unrealized profit and loss |
| return_on_equity | VARCHAR(16777216) | Return on equity |
| liquidation_price | VARCHAR(16777216) | Liquidation price |
| margin_used | VARCHAR(16777216) | Margin used for the position |
| max_leverage | NUMBER(38,0) | Maximum leverage allowed |
| cumulative_funding_all_time | VARCHAR(16777216) | Cumulative funding paid/received all time |
| cumulative_funding_since_open | VARCHAR(16777216) | Cumulative funding paid/received since position open |
| cumulative_funding_since_change | VARCHAR(16777216) | Cumulative funding paid/received since last change |
| _created_at | TIMESTAMP_NTZ(9) | Timestamp of when the entry was created in the database. |
| _updated_at | TIMESTAMP_NTZ(9) | Timestamp of when the entry was last updated in the database. |