Introduction

Realms is a platform to help developers build Decentralized Autonomous Organizations (DAOs) and manage their proposals, their members vote and their treasuries account. It serves as a frontend to SPL Governance, the program which provides core building blocks and primitive to create DAOs on the Solana blockchain. The program allows to build any type of DAO and manage any type of asset.

This dashboard will explore metrics for specific DAOs as well as some general metrics for Realms.

Analysis

A list of the metrics and the DAOs analyzed in this dashboard can be read below:

Metrics

1. Number of members: unique voters for the specific DAO

2. Number of proposals: unique proposal keys for the specific DAO

3. Total votes: sum of YES and NO votes casted for all proposals for the specific DAO

4. Percentage of YES votes: YES votes out of total votes for the specific DAO

5. Date of creation: date of the first vote transaction casted on chain for the specific DAO

6. Date of last proposal: date of last vote transaction sent for the specific DAO, which also defines the last proposal

   1. Days active: time difference between first and last vote transaction for the last proposal for the specific DAO
   2. Number of voters: unique voters for the last proposal for the specific DAO
   3. Number of votes: unique votes for the last proposal for the specific DAO

DAO’s analyzed

1. Mango: DAO of the decentralized DEX
2. Grape: Grape community DAO, focusing on accelerating adoption and growth of Solana blockchain
3. Psy Finance: DAO of the decentralized options vault protocol
4. Solend: DAO of the decentralized lending and borrowing protocol
5. MonkeDAO: DAO of the Solana Monkey Business (SMB) NFT holders
6. Metaplex: DAO of the Metaplex Foundation, from the leading NFT ecosytem in Solana
7. Jet: DAO of the decentralized lending and borrowing protocol
8. Serum: DAO of the decentralized exchanges protocol
9. The Imperium of Rain: DAO
10. Synthetify: DAO of the decentralized synthetic assets exchange

The tables used for this analysis are backfilled since December 1st. There are two DAOs, Serum and Mango, which were created before the above date and therefore the first recorded transaction is dated in December 1st. Both of these DAOs have a creation date previous to December 1st, so the obtained results from the on-chain data is not accurate.

Results tables from the queries

Conclusions

The analyzed DAOs activity shows different profiles: from ‘The Imperium of Rain’ DAO with a high member count and low participation (small number of proposals and votes) to ‘MonkeDAO’ with a low member count and high participation (high number of proposals and votes).

There is also a big difference between the percentages of YES votes amongst these DAOs - from 100% of approving votes of Metaplex Foundation to the 82% of Solend.

Methodology

All queries have been done using the newly curated solana.core.fact_proposal_votes . The specific DAOs have been identified using the PubKey from their official Realms page - a unique ID assigned upon DAO creation. Each vote transaction has been assumed to be a different vote by counting the number of unique tx_id. Vote choices found in the data is either YES or NO - no abstain ot other vote choices could be found from the data. As mentioned above, data shown accounts only for transactions done since December 1st, 2021. Therefore, activity previous to this data has not been accounted for.

Dashboard created by @KaskzCEA powered by Flipside Crypto.

Last proposals statistics