❓ 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.

• Realms Website
• Realms Docs
• GitHub

✍️ Description of Work

In this bounty we are going to explore Realms DAOs on SPL Governance. For this, we check the following:

• Number of Voters for each DAOs
• Total Number of Votes for each DAOs
• Number of Proposals for each DAOs
• Date of Last Proposal for each DAOs
• Date of Creation for each DAOs

🧠 Methodology

To deal with this bounty, we use the solana.core schema and fact_proposal_votes table. To find the list of DAOs that we want to check, we enter the details of the desired DAO using the app.realms, enter the Params tab, and extract the Pubkey or realms_id for the DAO in the Addresses section, and use the fact_proposal_votes table and the realms_id field of the DAOs that We want to investigate the desired items about them, filter and analyze the results

1️⃣ → Which Realms DAOs are we investigating?

Mango DAO

Mango DAO Link and Realms id is → DPiH3H3c7t47BMxqTxLsuPQpEC6Kne8GA9VXbxpnZxFE

Grape DAO

Grape DAO Link and Realms id is → By2sVGZXwfQq6rAiAM3rNPJ9iQfb5e2QhnF4YjJ4Bip

Psy Finance DAO

Psy Finance DAO Link and Realms id is → FiG6YoqWnVzUmxFNukcRVXZC51HvLr6mts8nxcm7ScR8

Solend DAO

Solend DAO Link and Realms id is → 7sf3tcWm58vhtkJMwuw2P3T6UBX7UE5VKxPMnXJUZ1Hn

MonkeDAO

MonkeDAO Link and Realms id is → B1CxhV1khhj7n5mi5hebbivesqH9mvXr5Hfh2nD2UCh6

Metaplex Foundation DAO

Metaplex Foundation DAO Link and Realms id is → 2sEcHwzsNBwNoTM1yAXjtF1HTMQKUAXf8ivtdpSpo9Fv

Metaplex Genesis DAO

Metaplex Genesis DAO Link and Realms id is → Cdui9Va8XnKVng3VGZXcfBFF6XSxbqSi2XruMc7iu817

Serum DAO

Serum DAO Link and Realms id is → 3MMDxjv1SzEFQDKryT7csAvaydYtrgMAc3L9xL9CVLCg

The Imperium of Rain DAO

The Imperium of Rain Link and Realms id is → 6orGiJYGXYk9GT2NFoTv2ZMYpA6asMieAqdek4YRH2Dn

Synthetify DAO

Synthetify DAO Link and Realms id is → 7oB84bSuxv9AH1iRdMp5nFLwpQApv8Yo9s1gGmDkHtSP

2️⃣ → Realms DAOs Number of Votes, Voters and Proposals

✅ Observations

• The highest Number of Unique Voters belong to The Imperium of Rain DAO with 1321 Unique Voters, followed by Grape DAO with 418 and Solend DAO with 221 Unique Voters.
• The highest Number of Votes belong to Grape DAO with **2712 **Votes, followed by The Imperium of Rain DAO with **2403 **and Mango DAO with 1717 Votes.
• The highest Number of Proposals belong to MonkeDAO with 196 Proposals , followed by Mango DAO with 176 and Grape DAO with 72 Proposals.

✅ Observations

• The highest Number of Unique Voters and Votes is related to May 2, 2022, which is related to The Imperium of Rain DAO
• The Number of Unique Voters and Votes shows an increasing trend from Jun 25, 2022 onwards, and more activity is observed.

3️⃣ → Daily Number of Votes and Unique Voters for Realms DAOs

4️⃣ → Date of Last Proposal for each Realms DAOs

✍️To address this section:

• We first obtain the start date of each Proposal for each DAO
  • select proposal, min(block_timestamp) as first_date Pseudocode → For each DAO
• Then, among all the obtained Proposals, we choose the one that started the latest
  • proposal as "Last Proposal", first_date as "Date of Last Proposal", row_number() over(order by first_date desc) as row_num Pseudocode → For each DAO
    • where row_num = 1 → Get Last Proposal

5️⃣ → Date of Creation for each Realms DAOs

In the two tables above, you can see the Date of Last Proposal and Date of Creation for each Realms DAO

6️⃣ → Realms DAOs Top 5 Voters by Number of Vote

✅ Observations

Among all the Voters, the top 5 in terms of the number of Votes for Realms DAOs that we reviewed include:

• BLmQoouPFAy2BwQWDeubyuTH2c5rq47J8AMFVDDwTwLq with 162 Votes
• CKhtvARM4zrQ64kuoUkyUTskUBHM5QXcPBEYSyjG5iTb with 156 Votes
• 4ZjYSCH3Sib9iMSM3QN2sL2kwxNcXG2P4XCemSC2hsyb with 151 Votes
• 6ojzi1cPMj7NXQ2tC1qmu8mP33mpqWDrdmzSA3Ry7cov with 143 Votes
• 6rSocFmyWhtVPwUmrZznZ3Kfg1Tn5aoBuQYAdvSMWBVQ with 142 Votes

It is interesting to see that the top 5 Voters among all Realms DAOs belong to MonkeDAO and this shows that MonkeDAO has less number of Voters but with a high number of Votes.

✔️ Final Conclusion

> After checking Realms DAOs Mango - Grape - Psy Finance - Solend - MonkeDAO - Metaplex - Jet - Serum - The Imperium of Rain - Synthetify In terms of the number of Voters, Votes and Proposals, we came to the conclusion that the highest number of Voters belongs to The Imperium of Rain DAO with 1321 Unique Voters, but it has a lower number of Votes. MonkeDAO has a small number of Voters but a high number of Votes and Proposals. Also, since the End of Jul, the number of Votes and Voters shows an upward trend and more activity