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

# Summaries EOD (Unhydrated)

> End-of-day Hyperliquid account summary snapshots.

The `hyperliquid.unhydrated.summaries_eod` table contains end-of-day account summary snapshots for every (user, dex) 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 summary snapshot.            |
| user          | User wallet address.                              |
| dex           | DEX deployer address associated with the user.    |
| timestamp     | Timestamp of the last snapshot taken on this day. |
| \_created\_at | Row creation timestamp.                           |
| \_updated\_at | Row last update timestamp.                        |

### Agent

| Column Name         | Description                             |
| ------------------- | --------------------------------------- |
| agent\_address      | Agent address associated with the user. |
| agent\_valid\_until | Agent validity timestamp.               |

### Cross Margin

| Column Name                                 | Description                                   |
| ------------------------------------------- | --------------------------------------------- |
| cross\_maintenance\_margin\_used            | Cross maintenance margin used.                |
| cross\_margin\_summary\_account\_value      | Cross margin summary account value.           |
| cross\_margin\_summary\_total\_margin\_used | Cross margin summary total margin used.       |
| cross\_margin\_summary\_total\_natl\_pos    | Cross margin summary total notional position. |
| cross\_margin\_summary\_total\_raw\_usd     | Cross margin summary total raw USD.           |

### Margin Summary

| Column Name                          | Description                             |
| ------------------------------------ | --------------------------------------- |
| margin\_summary\_account\_value      | Margin summary account value.           |
| margin\_summary\_total\_margin\_used | Margin summary total margin used.       |
| margin\_summary\_total\_natl\_pos    | Margin summary total notional position. |
| margin\_summary\_total\_raw\_usd     | Margin summary total raw USD.           |

### Account & Vault

| Column Name          | Description                                |
| -------------------- | ------------------------------------------ |
| withdrawable         | Withdrawable amount.                       |
| net\_deposit         | Net deposit amount.                        |
| is\_vault            | True when the user is a vault.             |
| total\_vault\_equity | Total vault equity.                        |
| pnl                  | PnL of the user at the snapshot timestamp. |

### Staking

| Column Name                         | Description                                       |
| ----------------------------------- | ------------------------------------------------- |
| staking\_delegated                  | Amount of staked tokens delegated.                |
| staking\_undelegated                | Amount of staked tokens undelegated.              |
| staking\_total\_pending\_withdrawal | Total amount of staked tokens pending withdrawal. |

## Sample Query

```sql theme={null}
SELECT
  block_date,
  user,
  margin_summary_account_value,
  withdrawable,
  pnl
FROM hyperliquid.unhydrated.summaries_eod
WHERE block_date >= CURRENT_DATE - 7
ORDER BY block_date DESC, margin_summary_account_value DESC
LIMIT 100
```