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

> Daily Hyperliquid account summaries per user.

The `hyperliquid.assets.summaries_daily` view contains daily Hyperliquid account summaries per user.

## Table Columns

### Identifiers

| Column Name   | Description                                    |
| ------------- | ---------------------------------------------- |
| timestamp     | Calendar day for this row.                     |
| user          | User wallet address.                           |
| dex           | DEX deployer address associated with the user. |
| \_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 for the day.   |

### 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
  timestamp,
  user,
  margin_summary_account_value,
  withdrawable,
  pnl
FROM hyperliquid.assets.summaries_daily
WHERE user = '<user_address_to_search>'
  AND timestamp >= CURRENT_DATE - 30
ORDER BY timestamp DESC
LIMIT 100
```