Polkadot
Materialized Views
Useful materialized views for Polkadot, Kusama & their parachains.
A list of useful queries that we have materialized for usability. Some complex dashboards can be constructed more efficiently by referencing these materialized views. Forks and additions are welcome!
Polkadot
Materialized View | Query ID | Description |
---|---|---|
dune.substrate.result_polkadot_validators | query_3302709 | Analyzes Polkadot validators’ performance and staking rewards, including nominator associations and APR calculations. |
dune.substrate.result_polkadot_nominationpools | query_3327350 | Tracks and assesses Nomination Pool rewards, fees, and APR within the Polkadot ecosystem. |
dune.substrate.result_polkadot_nominators | query_3326829 | Summarizes active nominator contributions, rewards, and their share in validators’ stakes in Polkadot. |
dune.substrate.result_polkadot_poolmembers | query_3327479 | Details individual Nomination Pool member contributions, rewards, and unclaimed amounts in Polkadot. |
dune.substrate.result_polkadot_identity | query_3420617 | A mapping between Polkadot and Kusama identities, linking addresses and verifying authenticity. |
dune.substrate.result_polkadot_referenda_total_voting_power | query_3394422 | Summarizes Polkadot referenda votes, detailing direct and delegated voting power and convictions. |
dune.substrate.result_polkadot_staking_nomination_total | query_3426963 | Displays Polkadot nominators, their staked totals per validator, and validator identities by era. |
dune.substrate.result_polkadot_open_gov_delegation | query_3393179 | Details staked totals by Polkadot nominators across validators and eras, including validator names. |
dune.substrate.result_polkadot_vote_record | query_3415321 | Polkadot referenda vote information, integrating direct, proxy, and delegated votes with dynamic links and voter identities. |
dune.substrate.result_polkadot_proposals_proposed | query_3394156 | Tracks Polkadot referenda statuses including proposer details, timelines, and outcome, with direct links to further information. |
dune.substrate.result_polkadot_referenda_direct_vote | query_3391225 | All Polkadot referendum direct votes (filter expired votes). |
dune.substrate.result_polkadot_each_vote_record | query_3393684 | Aggregates Polkadot referendum voting details, showing voter identities, vote types, convictions, and power, including direct and delegated votes. |
dune.substrate.result_polkadot_referenda_origin_map | query_3399352 | Associates Polkadot referenda with their origins. |
dune.substrate.result_polkadot_failed_calls_in_batch | query_3457139 | Finds some failed calls hidden in a utility batch on Polkadot. |
Kusama
Materialized View | Query ID | Description |
---|---|---|
dune.substrate.result_kusama_validators | query_3477509 | Analyzes Kusama validators’ performance and staking rewards, including nominator associations and APR calculations. |
dune.substrate.result_kusama_nominationpools | query_3477568 | Tracks and assesses Nomination Pool rewards, fees, and APR within the Kusama ecosystem. |
dune.substrate.result_kusama_nominators | query_3477192 | Summarizes active nominator contributions, rewards, and their share in validators’ stakes in Kusama. |
dune.substrate.result_kusama_poolmembers | query_3477877 | Details individual Nomination Pool member contributions, rewards, and unclaimed amounts in Kusama. |
dune.substrate.result_kusama_referenda_total_voting_power | query_3480624 | Summarizes Kusama referenda votes, detailing direct and delegated voting power and convictions. |
dune.substrate.result_kusama_open_gov_delegation | query_3480477 | Details staked totals by Kusama nominators across validators and eras, including validator names. |
dune.substrate.result_kusama_vote_record | query_3480405 | Kusama referenda vote information, integrating direct, proxy, and delegated votes with dynamic links and voter identities. |
dune.substrate.result_kusama_proposals_proposed | query_3480370 | Tracks Kusama referenda statuses including proposer details, timelines, and outcome, with direct links to further information. |
dune.substrate.result_kusama_referenda_direct_vote | query_3480617 | All Kusama referendum direct votes (filter expired votes). |
dune.substrate.result_kusama_each_vote_record | query_3480878 | Aggregates Kusama referendum voting details, showing voter identities, vote types, convictions, and power, including direct and delegated votes. |
dune.substrate.result_kusama_referenda_origin_map | query_3480454 | Associates Kusama referenda with their origins. |
dune.substrate.result_kusama_failed_calls_in_batch | query_3480469 | Finds some failed calls hidden in a utility batch on Kusama. |
Interlay
Materialized View | Query ID | Description |
---|---|---|
dune.substrate.result_interlay_oracle | query_3445402 | All graphs that use a price on Interlay |
dune.substrate.result_interlay_vault_creation | query_3437565 | All graphs that show vaults with their collateral |
dune.substrate.result_hydradx_oracle | query_3459562 | All graphs that use trade volume or prices on HydraDX. |