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. |
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. |