Introduction

In this analysis i analyzed these metrics:

• Number of members(Unique voters)

• Total Votes

• Number of Proposals

• Date of Last Proposals

• Date of DAOs creations

  \

for these Realms DAOs:

• Mango
• Grape
• Psy Finance
• Jet
• Serum
• Solend
• The Impreium of Rain
• monkeDAO
• Metaplex
• Synthetify

Methodology

In this dashboard i go through Realms DAOs and analyze some data from them.

I gathered data from Flipside Data and used solana.core.fact_proposal_votes table for all of the parts. At first i went to Realms website from the link that was in the question’s description and found DAOs realms__id.Then i used that Realms_id to find the data that i want for the specific DAO.

I used Voter Column for number of members and counted tx_ids for total votes.

The Pubkey in app.realms.today/realms website is realms_idin Flipside Tables.

Realms DAOs has so many DAOs but we only analyzed 10 of them that i mentioned earlier in the introduction.

Number of members(Unique Voters)

• I used count(distinct voter) from solana.core.fact_proposal_votes to gather this data
• And then compared DAOs voters to each other on a pie chart

• These 10 DAOs formed more than 50% of all DAOs voters
• The Imperium of Rain has more unique voters from other DAOs with 1322 unique voters and the lowest voters is for Metaplex with 6 voters.

Others means all Relams DAOs except these 10 DAOs that i mentioned above.

Total Votes

• For this part i used count(distinct tx_id)from solana.core.fact_proposal_votes table and counted transactions txs

• and then compared DAOs Votes to each other on a pie chart

  \

• Grape and The Imperium of Rain have more votes than the other mentioned DAOs
• These 10 DAOs formed 40% of all DAOs votes
• Synthetify has the lowest votes of all time in these specified DAOs

Reminder: Others means all Relams DAOs except these 10 DAOs that i mentioned at first.

Number of Proposals

• For getting the number of proposals i counted the proposal column in solana.core.fact_proposal_votes table

• And then compared the mentioned DAOs proposals to each other on a pie chart

  \

• The mentioned DAOs number of proposals formed almost 15% of all proposals from all Realms DAOs
• The pie chart shows that these mentioned DAOs dont have so many proposals comparing to others
• monkeDAO has more proposals and Solend has less proposals than other specified DAOs

Reminder: Others means all Relams DAOs except these 10 DAOs that i mentioned at first.

Date of Last Porposals

• for this section i used block_timestamp and gave it order by desc and chosed the last proposal date

• As we see mid August 2022 had so many last proposals
• But something that seems interesting is that Synthetify last proposal was on June 13th and it looks like nobody likes to send proposals for that DAO

I used scatter chart for this part

Date of DAOs Creation

• And at last for this part i used min(block_timestamp) and got the date of creation

• As we see in the chart 50% of mentioned DAOs created in December 2021
• Solend is the DAO that created after all of them
• Psy Finance and The Imperium of Rain both created in April 2022

I used scatter chart for this part

Conclusion

• The Imperium of Rain has the most voters from the rest of them(1322 voter) and its 27.65% of all voters
• Grape has the most votes from the rest of them(2860 votes) and its 11.86% of all votes
• monkeDAO has the most number of proposals from the rest of them(196 proposal) and its 4.46% of all proposals
• August 2022 had so many last proposals
• 5 of mentioned DAOs were created in December 2021

• This dashboard written by Sbhn_NP#8717 on August 17th 2022
• Data from flipsidecrypto