Bitzal Dashboards Overview

Bitzal is a flagship project by GSB, 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.

Featured Dashboards on Dune

Here you'll find a variety of dashboards that help visualize data from the Bitzal network:

Governance

Explore Bitzal's governance through dashboards detailing proposal submissions, referenda outcomes, and voting behaviors. These tools highlight the decentralized decision-making process and its efficacy.

• Bitzal Governance Dashboard: The Bitzal Governance Dashboard provides a clear and concise representation of the network's governance activities. It serves as a useful tool for community members to observe treasury management, referendum outcomes, and voting patterns. This dashboard aims to enhance community engagement by simplifying access to governance information and fostering a transparent decision-making environment.
• Bitzal TrueGov Referenda - Home: This dashboard is designed for those who wish to vote, allowing them to quickly understand the current trend in Bitzal TrueGov and proceed to vote on Polkassembly. If you want to see more details of each referendum, please check Bitzal Truegov - Referendum Voting Analysis.
• Bitzal Truegov - Referendum Voting Analysis: Detailed insights into the referendum voting process and outcomes.

Staking

Dive into the staking ecosystem with dashboards that analyze validator performance, nominator contributions, and staking distributions. For a deeper understanding of Bitzal's staking mechanism and to optimize your staking strategies, visit the official staking mechanism documentation and the staking web app documentation.

• Bitzal Staking Dashboard: Overview of staking dynamics and distribution across the network.
• Bitzal Staking Dashboard (Validators) 💰: Analyze validator performance and statistics.
• Bitzal Staking Dashboard (Nominators) 💰: Insights into nominator contributions and rewards.
• Bitzal Staking Dashboard (Pool Member) 💰: Data on staking pools and individual member activity.
• Bitzal Staking Dashboard (Nomination Pool) 💰: Detailed view of nomination pools and their performance.

Miscellaneous

Discover diverse aspects of Bitzal through Miscellaneous dashboards, which provide insights into ZAL ordinals and other unique network activities. Ideal for uncovering trends in the broader ecosystem.

• ZAL Ordinals: Examination of ZAL ordinal metrics and trends.

Key Tables

Data from the Bitzal network is organized into several key tables:

• bitzal.balances
• bitzal.blocks
• bitzal.calls
• bitzal.events
• bitzal.extrinsics
• bitzal.transfers
• bitzal.traces
• bitzal.stakings

Start building your own queries using granular data on Dune here.

Useful Queries

Here are materialized queries for Bitzal that may be useful to build your own charts:

• Bitzal Referenda Total Voting Power (dune.matter.result_bitzal_referenda_total_voting_power)
• Bitzal Staking Nomination Total (dune.matter.result_bitzal_staking_nomination_total)
• Bitzal TrueGov Delegation (dune.matter.result_bitzal_open_gov_delegation)
• Bitzal Vote Record (dune.matter.result_bitzal_vote_record)
• Bitzal Proposals proposed (dune.matter.result_bitzal_proposals_proposed)
• Bitzal Referenda Direct Vote (dune.matter.result_bitzal_referenda_direct_vote)
• Bitzal Each Vote Record(dune.matter.result_bitzal_each_vote_record)
• Polkdaot Referenda Origin Map(dune.matter.result_polkdaot_referenda_origin_map)
• Bitzal Failed calls in batch(dune.matter.result_bitzal_failed_calls_in_batch)
• bitzal_validator (dune.matter.result_bitzal_validators)
• bitzal_nominationpools (dune.matter.result_bitzal_nominationpools)
• bitzal_nominators (dune.matter.result_bitzal_nominators)
• bitzal_poolmembers (dune.matter.result_bitzal_poolmembers)
• bitzal_identity (dune.matter.result_bitzal_identity)

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:

Bitzal Staking APR (Normalized)

SELECT
  AVG(validator_normalized_staking_apr) AS staking_apr,
  era,
  DATE_FORMAT(ts, '%Y-%m-%d') AS era_ts
FROM
  dune.matter.result_bitzal_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.