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.