Polkadot Dashboards Overview

Polkadot is a flagship project by Web3 Foundation, designed to enable a completely decentralized web where users are in control. It is a sharded multichain network, meaning it can process many transactions on several chains in parallel, improving scalability.

Featured Dashboards on Dune

Here you'll find a variety of dashboards that help visualize data from the Polkadot network:

Governance

Explore Polkadot's governance through dashboards detailing proposal submissions, referenda outcomes, and voting behaviors. These tools highlight the decentralized decision-making process and its efficacy.

• Polkadot Governance Dashboard: The Polkadot Governance Dashboard provides a clear and concise representation of the network's governance activities. It serves as a useful tool for community members to observe treasury management, referendum outcomes, and voting patterns. This dashboard aims to enhance community engagement by simplifying access to governance information and fostering a transparent decision-making environment.
• Polkadot OpenGov Referenda - Home: This dashboard is designed for those who wish to vote, allowing them to quickly understand the current trend in Polkadot OpenGov and proceed to vote on Polkassembly. If you want to see more details of each referendum, please check Polkadot Opengov - Referendum Voting Analysis.
• Polkadot Opengov - Referendum Voting Analysis: Detailed insights into the referendum voting process and outcomes.

Staking

Dive into the staking ecosystem with dashboards that analyze validator performance, nominator contributions, and staking distributions. For a deeper understanding of Polkadot's staking mechanism and to optimize your staking strategies, visit the official staking mechanism documentation and the staking web app documentation.

• Polkadot Staking Dashboard: Overview of staking dynamics and distribution across the network.
• Polkadot Staking Dashboard (Validators) 💰: Analyze validator performance and statistics.
• Polkadot Staking Dashboard (Nominators) 💰: Insights into nominator contributions and rewards.
• Polkadot Staking Dashboard (Pool Member) 💰: Data on staking pools and individual member activity.
• Polkadot Staking Dashboard (Nomination Pool) 💰: Detailed view of nomination pools and their performance.

Miscellaneous

Discover diverse aspects of Polkadot through Miscellaneous dashboards, which provide insights into DOT ordinals and other unique network activities. Ideal for uncovering trends in the broader ecosystem.

• DOT Ordinals: Examination of DOT ordinal metrics and trends.

Key Tables

Data from the Polkadot network is organized into several key tables:

• polkadot.balances
• polkadot.blocks
• polkadot.calls
• polkadot.events
• polkadot.extrinsics
• polkadot.transfers
• polkadot.traces
• polkadot.stakings

Start building your own queries using granular data on Dune here.

Useful Queries

Here are materialized queries for Polkadot that may be useful to build your own charts:

• Polkadot Referenda Total Voting Power (dune.substrate.result_polkadot_referenda_total_voting_power)
• Polkadot Staking Nomination Total (dune.substrate.result_polkadot_staking_nomination_total)
• Polkadot OpenGov Delegation (dune.substrate.result_polkadot_open_gov_delegation)
• Polkadot Vote Record (dune.substrate.result_polkadot_vote_record)
• Polkadot Proposals proposed (dune.substrate.result_polkadot_proposals_proposed)
• Polkadot Referenda Direct Vote (dune.substrate.result_polkadot_referenda_direct_vote)
• Polkadot Each Vote Record(dune.substrate.result_polkadot_each_vote_record)
• Polkdaot Referenda Origin Map(dune.substrate.result_polkdaot_referenda_origin_map)
• Polkadot Failed calls in batch(dune.substrate.result_polkadot_failed_calls_in_batch)
• polkadot_validator (dune.substrate.result_polkadot_validators)
• polkadot_nominationpools (dune.substrate.result_polkadot_nominationpools)
• polkadot_nominators (dune.substrate.result_polkadot_nominators)
• polkadot_poolmembers (dune.substrate.result_polkadot_poolmembers)
• polkadot_identity (dune.substrate.result_polkadot_identity)

Getting Started with Queries

To get started with querying data from Unique, you are welcome to use the mentioned materialized queries. You can use the following DuneSQL queries as examples:

Polkadot Staking APR (Normalized)

SELECT
  AVG(validator_normalized_staking_apr) AS staking_apr,
  era,
  DATE_FORMAT(ts, '%Y-%m-%d') AS era_ts
FROM
  dune.substrate.result_polkadot_validators
WHERE
  validator_is_active = TRUE
  AND validator_commission <> 1
GROUP BY
  era,
  ts
HAVING
  AVG(validator_normalized_staking_apr) > 0
ORDER BY
  era DESC;

Query result:

Visualized result:

DuneSQL Reference

For more information on DuneSQL, please refer to the DuneSQL Cheatsheet and DuneSQL Official Documentation.