Realms vs Snapshot
Building off previous recent bounties on Realms and Snapshot, create a dashboard that shows how Realms and Snapshot are growing and used in comparison to one another. Feel free to build off previous bounty work on these platforms.

Methodology
To get information from two tables
- solana.core.fact_proposal_votes
- ethereum.core.ez_snapshot
In 90% of the queries, information was extracted with the 2022 filter to have a better view
To extract the power of fish and whales Based on the voting power, whales and fish were separated and their voting power was measured based on the number of votes
In the investigation of voters' behavior: the title of the proposals was examined and filtered through it
:triangular_flag_on_post: In the two graphs below weekly The number and growth of the number of proposals in two systems has been compared
:triangular_flag_on_post: In the two graphs below weekly Number of votes and voters In two systems has been compared
:triangular_flag_on_post: In the two graphs below weekly The growth of the number of votes and the growth of voters In two systems has been compared
- The number of votes has increased in April 2022 in Snapshot
- The number of voters has increased in May 2022 in Realms
:triangular_flag_on_post: In the two graphs below Average proposals and voters In two systems weekly has been compared
- We see a decrease in proposals from May 2022 for Snapshot
:triangular_flag_on_post: In two donut charts
-
The average number of proposals to voters
-
Average number of votes in relation to voters
Average voters→
-
About 55% for Realms
-
About 45% for Snapshot
Average proposals given by→
-
About 53 percent for Realms
-
About 47% for Snapshot
In the two graphs below, the power of whales and fish is examined in Snapshot →
:loudspeaker: It seems that in Snapshot, fish have about 78% power, while whales have about 23% power
In the two charts below, the power of whales and fish in the Realms is examined →
:loudspeaker: It seems that in Realms, fish have about 58% power, while whales have about 42% power.
:triangular_flag_on_post: In the two graphs below The behavior of the voters was examined → In this review, the title of the proposals was reviewed for Snapshot
- About 19% of votes for DAO
- About 18% of votes for COIN or TOKEN
- About 17% of votes for DEX
- About 7% of votes for FARM
- About 6% of votes for NFT
Conclusion
It seems that the total number of proposals in Snapshot is more than Realms, and the number of voters and votes will be more.
Also, in the examination of the voting behavior of the people The most voting interest is DAO, followed by COIN or TOKEN, DEX, FARM and NFT.
The voting power of whales in Realms is higher than the voting power of whales in Snapshot.
:triangular_flag_on_post: In the tables below, general information about Realms and Snapshot It has been reviewed over time
:triangular_flag_on_post: In the table and two graphs below Based on the voting program name in Realms The number of votes and the number of voters and the number of proposals and the power of the vote It was reviewed in aggregate and percentage and weekly
:triangular_flag_on_post: In the two graphs below On a weekly basis, the behavior of the voters and the votes given based on the topic of the proposal have been checked for Snapshot
