Overview

The near.staking.overview model provides a comprehensive daily snapshot of staking metrics on the NEAR blockchain. It includes key metrics about stake distribution, validator performance, and delegator activity.

For APY calculation, we divide the total rewards accrued by all active validators in the last 24 hours by the median daily staked amount across all active validators for the each.

The model is updated daily.

Key Metrics

This table aggregates the data from the near.staking.events, near.staking.pool_balances, and near.staking.pool_epoch_rewards models.

Stake DistributionValidator PerformanceDelegator Activity
Total StakeDaily RewardsActive Delegators
Active StakeNetwork-wide APYStake Inflow
Top Validator StakeEpoch TrackingStake Outflow
Top Validator Pct ShareEpoch ListActive Delegators
Total PoolsEpoch CountActive Delegators

Column Description

Unique Key: activity_date

ColumnTypeDescription
activity_dateDATEThe date of the overview data
total_stakeFLOATTotal amount of NEAR staked across all validator pools (including idle and inactive validators)
active_stakeFLOATTotal active stake in NEAR from validator pools that received rewards in the last 24 hours
total_rewardsFLOATTotal rewards distributed to active validators each day
apyFLOATAnnual percentage yield based on rewards and active stake
top_10_validator_stakeFLOATSum of stake held by the top 10 validators
top_10_validator_pct_shareFLOATPercentage of active stake held by top 10 validators
top_validator_stakeFLOATStake held by the largest validator pool
top_validator_id_by_stakeSTRINGIdentifier of the validator pool with the highest stake
top_validator_pct_shareFLOATPercentage of active stake held by the top validator
total_poolsBIGINTTotal count of unique staking pools
active_poolsBIGINTCount of staking pools that received rewards in last 24 hours
epoch_countBIGINTNumber of epochs in the data
epoch_listARRAYList of epoch numbers included in the data
active_delegatorsBIGINTCount of unique delegators who have staked on the day
delegator_stake_countBIGINTNumber of delegators who staked on the day
delegator_unstake_countBIGINTNumber of delegators who unstaked on the day
stake_inflowFLOATTotal amount of NEAR staked on the day
stake_outflowFLOATTotal amount of NEAR unstaked on the day