Materialized views store pre-computed query results as tables, enabling faster queries and simplified data pipelines. To learn more about creating and using materialized views, see the Materialized Views page.
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. |