Skip to main content
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, forward-filled so every user has a row for 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 NameData TypeDescription
block_dateDATEThe calendar day
userVARCHARThe wallet address
staking_delegatedFLOATAmount of HYPE the user has delegated to validators
staking_undelegatedFLOATAmount of HYPE the user has undelegated (pending cooldown)
staking_total_pending_withdrawalFLOATAmount of HYPE pending withdrawal after undelegation cooldown
hype_price_usdFLOATDaily HYPE token price in USD
staking_delegated_usdFLOATUSD value of delegated HYPE (staking_delegated * hype_price_usd)
hype_market_cap_usdFLOATHYPE token market cap in USD
_created_atTIMESTAMP_NTZRow creation timestamp
_updated_atTIMESTAMP_NTZRow 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;