What is a DAO?

At its simplest, a decentralized autonomous organization (DAO) is a community with a shared bank account. Members of the DAO make decisions in a transparent and decentralized fashion, with smart contracts executing these decisions.

For instance, a member can create a proposal suggesting an investment of the treasury or a program upgrade. The DAO members then come together to vote on the proposal. If a predefined quorum votes for the proposal to pass, the proposal is accepted and and executed by a smart contract.

As a result, the DAO structure provides a “flat” organizational structure. Each DAO member has a voice in the community and the opportunity to drive the direction of the organization.

Methodology:

• I completely used the solana.core.fact_proposal_votes table. I treated each dao's pubkey as a realms_id. And based on that, I found the desired DAO . and then considered each voter as a voting wallet.
• And the information of these charts and dashboard is for Mango, Grape, Psy Finance, Solend, MonkeDAO, Metaplex, Jet, Serum, The Imperium of Rain and Synthetify DAOs.

Image and introduction source:

observations:

• The highest number of members is for The Imperium of Rain DAO with 1321 members.
• Grape DAO ranks second with 418 members.
• the lowest number of members is for Metaplexs DAO which has a total of 6 members.

observations:

• The highest number of votes is for Grape DAO. with a total of 2704 votes.
• In second place with a slight difference from grape, The Imperium of Rain DAO is placed with a total number of 2403 votes.
• The lowest number of votes is for Metaplex Genesis DAO with 36 votes.

observations:

• The highest number of positive and negative votes was for Grape DAO with 2513 positive votes and 191 negative votes.

• In the second place of negative votes is for Mango DAO with 114 negative votes and also in the second place of positive votes is The Imperium of Rain DAO with 2354 positive votes.

• Metaplexes DAO received no negative votes in total.

observations:

• The latest proposal is related to Grape DAO , which was created on 2022-08-16.
• The last Synthetify DAO proposal was on 2022-06-13. which is considered the oldest among the latest proposals.

When I added the result table of this query to the dashboard, the numbers changed. So I had to post a picture of it.

link of query:

observations:

• The highest number of proposals is presented is for Monke DAO with a total number of 196 proposals.
• Mango DAO is ranked second in the number of proposals with 176.
• The lowest number of proposal is related to Solend DAO with 3 proposals.

observations:

• Mango DAO and serum DAO are the oldest and were created on 2021-12-01. Among these two, Mango DAO is older by 2 hours.
• The newest DAO is Solend. This dao was created on 2022-06-19.

observations:

• The highest participation percentage of realms users is related to The Imperium of Rain DAO with a participation percentage of 29.42.
• Grape DAO ranks second with a percentage of 9.31 .
• The lowest participation percentage is related to Metaplexes DAO.

observations:

• 0.0288% of all Solana blocks include votes related to these DAO's on the realms platform.

observations:

• The top 6 most transactions in a single proposal were all in The Imperium of Rain DAO.
• The first rank is for 9aLYCv1sazi2uvv1GAEHS68hx4JWrmMSd7ywCivT7cmj with the number of 947 votes.
• The second rank is for ARo5QFL5FmXipRGdxxhQHLsDUgdNERujFniDy2HEJjqw with 387 votes.
• The Third rank is for YkQwTTYEvjrzb1Lrn9KoMzrEpsmEHbRqE3hxP6SE5eK with 264 votes.
• Except for The Imperium of Rain DAO , the frequency of votes in Mango DAO and Jet DAO and Solend DAO is better than Our other desired DAOs.

observations:

• The top 10 wallets with the most contributions were quite strangely active on Monke DAO and Mango DAO .

  \

• And these addresses can be known as very persistent addresses of these two DAO.

observations:

• Among the wallets that have had the largest number of contributions. In general, Monke DAO has been the most active.
• After Monke DAO , these wallets have been more active in Grape DAO and Mango DAO.

observations:

• The highest percentage of the number of transactions compared to the total transactions of the realms is related to Grape DAO with a value of 11.70%.
• The Imperium of Rain DAO comes in second place with a very small margin compared to Grape DAO with an overall percentage of 10.40%.
• The lowest percentage related to Metaplex Genesis DAO is with a percentage of 0.1559.

observations:

• The lowest average time to create a new proposal in a DAO is related to Psy Finance DAO with an average number of 6.15 hours.
• In the second place of the average time to create a new proposal is Synthetify DAO with an average number of 6.23 hours.
• The highest average time to create a new proposal in a DAO related to Serum is 32.85 hours.
• The longest time to create a new DAO in Serum DAO has been with the number of 201 hours and after that Monke DAO ranks second with the number of 124.

• The highest number of wallets unique to Imperium of Rain DAO.
• The highest number of registered votes are for Grape DAO.
• Metaplexes DAO received no negative votes in total.
• The highest number of proposals are for Monke DAO.
• The latest proposal is for Grape DAO.
• Mango and serum have been the oldest DAOS on realms.
• The highest percentage of participation of those who are familiar with realms is for The Imperium of Rain DAO.
• The most transactions in a proposal are for The Imperium of Rain DAO.
• The top 10 wallets with the most contributions were quite strangely active on Monke DAO and Mango DAO.
• Among the top 100 wallets in terms of participation, they have had the most activity on Monke DAO.
• It seems that Psy Finance DAO and Synthetify DAO will provide new proposals soon and they are more updated , And Serum DAO presents a new proposal very late.

final conclusion:

In this section, we check the number of members of each Dao.

In this section, we will review the proposals of each Dao.

In this section, we check the latest proposal for each Dao.

In this section, we calculate the start date of each Dao.

In this section, we compare the data of our desired Dao with the whole realms.

In this section, we compare the data of our desired Dao with the Solana network. In terms of each block

In this section, we examine the behavior of very active wallets in Daos.

In this section, we will check the average and maximum of each new proposal.

In this section, we check the number of votes for each Dao.

contact with me:

Discord:rezarwz#7622

Twitter: rezarwz

Email: rezafereidouni@outlook.com