> ## 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 EOD (Unhydrated)

> End-of-day Hyperliquid perpetual position snapshots.

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

```sql theme={null}
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
```