Skip to main content

Polkadot Dashboards Staking

Overview​

This document demonstrated various Polkadot staking dashboards, offering insights into staking rewards, validator and nominator metrics, nomination pools, and pool member activities. These dashboards aim to provide a comprehensive view of staking dynamics within the Polkadot network.

Authored by @ colorfulnotion

Polkadot Staking Dashboard​

View On Dune: Polkadot Staking Dashboard

Completed Era​

Completed eras can have at most a 2-day delay before the staking rewards & APY computation becomes available. The Staking Home Page shows the most recently completed era.

Reward Rate Math​

  • Reward Rate: (validator_erasRewardPoints / erasRewardPoints_total) * ErasValidatorReward / validator_total_stake.
  • Effective Reward Rate: (1 - validator_commission) * Reward Rate.
  • Normalized Reward Rate: total_era_rewards / number_of_validators * (1 - commission) / validator_total_stake.

Source Table: polkadot.stakings, MaterializedView: dune.substrate.result_polkadot_validators, dune.substrate.result_polkadot_nominators, dune.substrate.result_polkadot_nominationpools, dune.substrate.result_polkadot_poolmembers, dune.substrate.result_polkadot_identity

Github repo: substrate-etl

Staking Analytics​

Polkadot Staking Dashboard (Validators)​

View On Dune: Polkadot Staking Dashboard (Validators)

Polkadot Staking Rewards​

  • Reward Rate: (validator_erasRewardPoints / erasRewardPoints_total) * ErasValidatorReward / validator_total_stake.
  • Effective Reward Rate: (1 - validator_commission) * Reward Rate.
  • Normalized Reward Rate: total_era_rewards / number_of_validators * (1 - commission) / validator_total_stake.

Source Table: polkadot.stakings, MaterializedView: dune.substrate.result_polkadot_validators

Polkadot Staking Dashboard (Nominators)​

View On Dune: Polkadot Staking Dashboard (Nominators)

For a specific nominator, this dashboard shows:

  • Nominator Staking Rewards
  • Nominator Shares
  • Delegated Amount
  • Nominator Staking Rewards Raw Data

Source Table: polkadot.stakings, MaterializedView: dune.substrate.result_polkadot_nominators

tip

Default parameters are applied to all parameterized charts on this Wiki page as a demonstration. Visit our dashboard on Dune to use the nominator_ss58 parameter for more in-depth analysis. For more information, please visit the Dune documentation on parameters.

Polkadot Staking Dashboard (Nomination Pool)​

View On Dune: Polkadot Staking Dashboard (Nomination Pool)

For a specific nomination pool ID, this dashboard shows:

  • Pool Members
  • Historical APY, Daily Pool Rewards & Fees

Raw data is presented at the bottom.

Source Table: polkadot.stakings, MaterializedView: dune.substrate.result_polkadot_nominationpools

tip

Default parameters are applied to all parameterized charts on this Wiki page as a demonstration. Visit our dashboard on Dune to use the pool_id parameter for more in-depth analysis. For more information, please visit the Dune documentation on parameters.

Polkadot Staking Dashboard (Pool Member)​

View On Dune: Polkadot Staking Dashboard (Pool Member)

For a specific nomination pool member, this dashboard shows raw data of member activity within the pool.

Member Pool Fee: 365 * member_staking_rewards / member_bonded

Source Table: polkadot.stakings, MaterializedView: dune.substrate.result_polkadot_poolmembers

tip

Default parameters are applied to all parameterized charts on this Wiki page as a demonstration. Visit our dashboard on Dune to use the user_ss58 parameter for more in-depth analysis. For more information, please visit the Dune documentation on parameters.