Staking Daily

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.

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 filtered to coin = 'HYPE'.

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

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;

Fungible Token Transfers Spot Balances Latest

⌘I

Overview

Data Verticals

Solana

Hyperliquid

Lighter

Bitcoin Ecosystem

EVM

Cosmos Ecosystem

Move Ecosystem

Other Ecosystems

Table Columns

Sample Query

​Table Columns

​Sample Query

Table Columns

Sample Query