Polkadot Dasards 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 Dasards on Dune

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

Governance

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

• Polkadot Governance Dasard: The Polkadot Governance Dasard 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 dasard aims to enhance community engagement by simplifying access to governance information and fostering a transparent decision-making environment.
• Polkadot OpenGov Referenda - Home: This dasard 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 dasards 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 Dasard: Overview of staking dynamics and distribution across the network.
• Polkadot Staking Dasard (Validators) 💰: Analyze validator performance and statistics.
• Polkadot Staking Dasard (Nominators) 💰: Insights into nominator contributions and rewards.
• Polkadot Staking Dasard (Pool Member) 💰: Data on staking pools and individual member activity.
• Polkadot Staking Dasard (Nomination Pool) 💰: Detailed view of nomination pools and their performance.

Miscellaneous

Discover diverse aspects of Polkadot through Miscellaneous dasards, 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:

sql title="Polkadot Staking APR (Normalized)" showLineNumbers 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:

Info

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