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.
The hyperliquid.unhydrated.perpetual_positions_eod table contains end-of-day perpetual position snapshots for every (user, type, coin) on Hyperliquid. One row per day, keeping the last snapshot of the day.
Table Columns
Identifiers
| Column Name | Description |
|---|
| block_date | Calendar date of the position snapshot. |
| user | User wallet address. |
| type | Position type. Currently always ‘oneWay’. |
| coin | Coin of the position. |
| timestamp | Timestamp of the last snapshot taken on this day. |
| _created_at | Row creation timestamp. |
| _updated_at | Row last update timestamp. |
Position
| Column Name | Description |
|---|
| szi | Size of the position. |
| leverage_type | Type of leverage used (e.g. ‘cross’, ‘isolated’). |
| leverage_value | Leverage multiplier. |
| entry_px | Entry price. |
| position_value | Position value. |
| unrealized_pnl | Unrealized PnL. |
| return_on_equity | Return on equity. |
| liquidation_price | Price that would trigger liquidation. |
| margin_used | Margin used to maintain the position. |
| max_leverage | Maximum leverage allowed for this position. |
Funding
| Column Name | Description |
|---|
| cumulative_funding_all_time | Cumulative funding paid / received all time. |
| cumulative_funding_since_open | Cumulative funding paid / received since the position was opened. |
| cumulative_funding_since_change | Cumulative funding paid / received since the last position change. |
Sample Query
SELECT
block_date,
user,
coin,
szi,
entry_px,
position_value,
unrealized_pnl
FROM hyperliquid.unhydrated.perpetual_positions_eod
WHERE block_date >= CURRENT_DATE - 7
ORDER BY block_date DESC, ABS(position_value) DESC
LIMIT 100
