Questions

---

Q104. We now have Solana Realms governace data! Their team would love to be able to see a list of DAOs / multisigs built on SPL Governance, and understand their:

• Number of Members (assuming unique voters is what he means here)

• Total Votes

• Number of Proposals

• Date of Last Proposal

• Date of Creation

  \

Track these metrics and any other metrics that you find interesting for the following DAOs: -Mango -Grape -Psy Finance -Solend -MonkeDAO -Metaplex -Jet -Serum -The Imperium of Rain -Synthetify

Approach

---

Methodology

• We use data from the table solana.core.fact_proposal_votes
• We can identify DAO’s name from the realms_id column
• We then collect and analyze data to answer the questions as will be presented

Limitation

• The oldest data we can query is from 31 Dec 2021
• The information we obtained is from data between 31 Dec 2021 and 17 Aug 2022 (The day we finish this work)
• vote_weight column is unavailable for now, causing lose of some dimension of information

DAO all information

---

The following information is shown in the right table

• Number of Members (assuming unique voters is what he means here)
• Total Votes
• Number of Proposals
• Date of Last Proposal
• Date of Creation

Number of proposals

• We count number of proposal by counting distinct proposal from PROPOSAL column
• Highest one is MonkeDAO with 196 proposals
• Lowest one is Solend with 3 proposals
• As shown in the scattered graph (Number of proposals on each DAO and creation date), number of proposals is quite related to creation date, the older, the higher proposal number
• But this does not work with Serum which is the oldest one but has only 21 proposals

Number of members

• We count number of members by counting distinct voter from VOTER column
• The DAO with highest number of members is The Imperium of Rain with 1,321 members
  • even this DAO is the 3rd newest DAO and has only 20 proposals
• The DAO with lowest number of members is Metaplex with only 3 members

Number of total votes

• We count number of total votes by counting all voting Tx

• Grape has highest total votes with 2712 votes

  • Grape has 2nd highest number of members, 418
  • and has 3rd highest number of proposals, 71

• Synthetify has lowest total votes with 42 votes

  • Synthetify has 2nd lowest number of members, 19
  • and has 3rd lowest number of proposals, 17

• We can see that number of total votes goes in the same way as number of member and number of proposals

• We can also see in scattered graph (Number of Voters in each proposal), Grape has high number of proposals with medium number of voters.

• The Imperium of Rain has low number of proposals but has very high number of votes

  \

Date of last proposal

• We obtain date of last proposal from the first day users vote the latest proposal
• The newest one is proposal of Grape, created on 16 Aug 2022
• The oldest one is proposal of Synthetify, created on 13 Jun 2022

Date of creation

• We obtain date of creation from the first day users vote the first proposal

• The oldest one created is Serum and Mango on 1 Dec 2021 (Actually, they may be older but it’s the oldest information we can query)

• The newest one created is Solend on 20 Jun 2022, correspondingly, it has only 3 proposals.

  \

Conclusions

---

Date of last proposal

• The newest one is proposal of Grape, created on 16 Aug 2022
• The oldest one is proposal of Synthetify, created on 13 Jun 2022

Date of creation

• The oldest one created is Serum and Mango on 1 Dec 2021 (May be older)

• The newest one created is Solend on 20 Jun 2022

  \

Number of members

• The DAO with highest number of members is The Imperium of Rain with 1,321 members
• The DAO with lowest number of members is Metaplex with only 3 members

Number of proposals

• Highest one is MonkeDAO with 196 proposal

• Lowest one is Solend with 3 proposals

• Number of proposals is quite related to creation date, the older, the higher proposal number

  \

Number of total votes

• Grape has highest total votes with 2712 votes
• Synthetify has lowest total votes with 42 votes
• Number of total votes goes in the same way as number of members and number of proposals