Skip to main content

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.

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.

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.

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:

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.