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

# Staking Daily

> Daily HYPE staking delegation per wallet on Hyperliquid

The `hyperliquid.assets.staking_daily` table contains end-of-day HYPE staking delegation state for each wallet, with HYPE price and USD valuations. One row per user per day, covering every calendar day.

<Note>
  This table tracks how much HYPE each wallet has delegated outward to validators. It does not indicate which validator the HYPE was delegated to. For non-staked HYPE holdings, use [spot\_balances](/historical-data/supported-blockchains/hyperliquid/raw/spot-balances) filtered to `coin = 'HYPE'`.
</Note>

## Table Columns

Unique Key: `block_date, user`

| Column Name                         | Data Type      | Description                                                          |
| ----------------------------------- | -------------- | -------------------------------------------------------------------- |
| block\_date                         | DATE           | The calendar day                                                     |
| user                                | VARCHAR        | The wallet address                                                   |
| staking\_delegated                  | FLOAT          | Amount of HYPE the user has delegated to validators                  |
| staking\_undelegated                | FLOAT          | Amount of HYPE the user has undelegated (pending cooldown)           |
| staking\_total\_pending\_withdrawal | FLOAT          | Amount of HYPE pending withdrawal after undelegation cooldown        |
| hype\_price\_usd                    | FLOAT          | Daily HYPE token price in USD                                        |
| staking\_delegated\_usd             | FLOAT          | USD value of delegated HYPE (staking\_delegated \* hype\_price\_usd) |
| hype\_market\_cap\_usd              | FLOAT          | HYPE token market cap in USD                                         |
| \_created\_at                       | TIMESTAMP\_NTZ | Row creation timestamp                                               |
| \_updated\_at                       | TIMESTAMP\_NTZ | Row update timestamp                                                 |

***

### Sample Query

```sql theme={null}
SELECT
  block_date,
  user,
  staking_delegated,
  hype_price_usd,
  staking_delegated_usd
FROM hyperliquid.assets.staking_daily
WHERE block_date >= CURRENT_DATE - INTERVAL '30 days'
  AND staking_delegated > 0
ORDER BY staking_delegated_usd DESC
LIMIT 100;
```
