Votes

Voters

Proposals

DAOs

Percentage of users participating in voting

This section shows what percentage of each blockchain user participates in their voting platform i.e. Realms or Snapshot.

method:

• Total users => count all unique users on Ethereum and Solana by using the transactions table.
• Total voters => count all unique voters on Ethereum - SnapShot and Realms.
• calculate (Total voters / Total users) * 100

Conclusion

• In general, the number of voters, votes, DAOs and proposals in Realms is much less than Snapshot.
• Comparing Realms with Snapshot chains, it can be said that after Ethereum chains, Realms has the second number of proposals.
• Blockchain user activity is low on both platforms.
• Whales participate a lot in the voting of both platforms, but it can be said that Realms has a higher percentage of whales and will have more influence.

Select proposal_type and last_day , then apply to all visualizations

• Last_Day: The number of days before the current date.
• Proposal_Type: The keywords selected based on the proposal name are created for voting behavior on each platform.You can use the % character to find all types of proposals.

Introduction

What is Realms?

Realms provides a platform for builders on Solana to create a DAO, manage their members, vote on proposals, and allocate their treasury. Whether you are running a multisig, NFT community DAO, or community token DAO, Realms has the tools and integrations to help your community flourish.

Realms serves as the frontend for SPL Governance, a DAO-type and asset-type agnostic standard for building and maintaining DAOs on Solana.

What is Snapshot?

Snapshot is a place where projects can create proposals for people to vote on using cryptocurrency. In the industry, this process is called ‘vote signaling’. Traditionally, to vote using cryptocurrency would normally incur fees to process the movement of currency from one wallet to another. 

Method

In this dashboard, based on the date and proposal type parameters, I have compared Realms and Snapshots from ethereum.core.ez_snapshot and solana.core.fact_proposal_votes tables.

The words selected for searching in the type of proposal that searches in the name of the proposal are to better identify the behavior of users in voting on each platform.

Also, I compared the number of voters, votes, DAOs and proposals with Realms based on each top 10 chain in the Snapshot.

• Metrics provided in this dashboard are:
  • Total daily votes on each Platform
  • Total daily voter on each Platform
  • Total daily DAOs on each Platform
  • Total daily Proposals on each Platform
  • Total number of Votes / Voters / DAOs by Platform
  • Cumulative number of Votes / Voters / DAOs/ Proposals on each platform
  • Activity percentage of Ethereum and Solana users in Snapshot and Realms voting
  • Whales impact

Percentage of participation of whales in voting

This section shows the percentage of participation of whales in the voting in their voting platform.

I identified Ethereum and Solana whales and compared their presence percentage in Realms and Snapshot.

Those who hold more than 1M dollars in their wallet are whales.

observations

• None of the Ethereum voters in the snapshot are whales.
• 0.06% of Realms voters are Solana whales.

The END

Twitter: mohsen.dastpeyman

Discord_id: mohsen#4796