Tracking Realms DAOs
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
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.
Source: docs.realms.today

in this dashboard we use solana.core.fact_proposal_votes table for answering the following questions:
- Total Number of Members
- Total Votes
- Number of Proposals
- Date of Proposals Creation
- Proposals Status
- Proposals Voters Status
- Proposals Votes Status
- Date of Last Proposal - Realms DAOs
- Maximum Unique Voters - Realms DAOs
- Average Unique Voters - Realms DAOs
- Daily Number of Voters on DAOs
- Daily Number of Votes on DAOs
- Top DAO Proposals - Vote Choice [Yes/No] Status
- DAO Proposals - Vote Choice [Yes/No] Status
In the Date of Proposals Creation chart, we see the creation time of each dao. For example, the UXD protocol was created on December 22, 2021, and its total proposals are 543.
also Mango, The Sanctuary, gSAIL Governance DAO and Serum DAOs were created on December 1, 2021.
36% (543) of Proposals are related to Uxd protocol.
13% (196) of Proposals are related to Monke.
11.7% (176) of Proposals are related to Mango.
5.71% (86) of Proposals are related to Meta Collective.
5.64% (85) of Proposals are related to Poor DAO.
In Proposals Voters Status and Proposals Votes Status charts we can see the number of voters and votes.
In the Proposals Voters Status chart, we can see that the highest number of voters is related to The Imperium of rain.
1322 (42.7%) voters are related to The Imperium of rain DAO.
420 (13.6%) voters are related to Grape DAO.
233 (7.53%) voters are related to Orca DAO.
223 (7.2%) voters are related to Solend DAO.
196 (6.33%) voters are related to Jet DAO.
177 (5.72%) voters are related to Mango DAO.
In the chart on the left, we see the number of voters on a daily basis. The largest number of voters were present on May 2. 302 voters are for The Imperium of Rain.
On June 19, 134 voters voted for Solend.
In the chart on the right, we see the number of votes on a daily basis. The highest number of votes was given on May 2.
308 votes are for The Imperium of Rain.
On June 21, 101 votes for Solend.
In the chart on the left, we see the number of voters for each dao.
The largest number of voters belongs to Orca.
The number of 232 unique voters belongs to Orca DAO.
The number of 135 unique voters belongs to Solend.
The number of 130 unique voters belongs to Jet.
The number of 127 unique voters belongs to Grape.
The number of 64 unique voters is belongs to Uxd protocol.
In the chart, we see the number of yes or no to the proposals of DAOs. the number of yes to the proposals is more than the number of no.
The highest number of yes is related to The Imperium of Rain.
2354 YES for The Imperium of Rain.
2532 YES for Grape DAO.
1603 YES for Mango DAO.
114 NO for Mango DAO.
94.9% of votes are YES and 5.07% of votes are NO
Mango Market
Mango Markets provides a single venue to lend, borrow, swap, and leverage-trade crypto assets through a powerful risk engine. Earn interest on deposits Cross-Margin / Cross-Collateralised Decentralised Mango Markets is built on the Solana blockchain and utilises Serum DEX for spot margin trading while perpetual futures are traded on Mango Markets' own order book. Mango Markets is governed by MNGO token holders via the Mango DAO.
Realms id: DPiH3H3c7t47BMxqTxLsuPQpEC6Kne8GA9VXbxpnZxFE


Grape Network
Grape Network is the toolset for Decentralized Social Networking on Solana. Grape is using the platforms of today to build the platform of tomorrow. By layering blockchain solutions on top of systems, people already know and love, we are providing value to the Solana ecosystem, while simultaneously preparing users for the new interactions of the crypto future.
Realms id: By2sVGZXwfQq6rAiAM3rNPJ9iQfb5e2QhnF4YjJ4Bip

Psy Finance
PsyFinance is a suite of option strategy vaults aimed at generating sustainable yield for single token assets for users. The goal is to create the best non-inflationary yields on the Solana Ecosystem.
Realms id: FiG6YoqWnVzUmxFNukcRVXZC51HvLr6mts8nxcm7ScR8

Solend
Solend is an algorithmic, decentralized protocol for lending and borrowing on Solana. Lending and borrowing has proven itself as key in a DeFi ecosystem. However, current products are slow and expensive. On Solana, Solend can scale to being 100x faster and 100x cheaper. Solend aims to be the easiest to use and most secure solution on Solana.
Realms id: 7sf3tcWm58vhtkJMwuw2P3T6UBX7UE5VKxPMnXJUZ1Hn


MonkeDAO
MonkeDAO is a curated community of monkes, the first NFT DAO on Solana.
MonkeDAO is a completely independent, community organized DAO. A validator is one of the basic building blocks of the Solana blockchain. They are servers running specialized software that help secure each and every transaction. From minting an NFT to exchanging tokens on a DEX, the reason you can trust that any action you take on Solana will succeed and be recorded is because of the work validators do behind the scenes.
Realms id: B1CxhV1khhj7n5mi5hebbivesqH9mvXr5Hfh2nD2UCh6

Metaplex
Metaplex is a collection of tools, smart contracts, and more designed to make the process of creating and launching NFTs easier. While initially focused on supporting the needs of the arts and entertainment industry our plans extend far beyond that to all use cases where an NFT may add value.
Metaplex Foundation Realms id: 2sEcHwzsNBwNoTM1yAXjtF1HTMQKUAXf8ivtdpSpo9Fv Metaplex Genesis Realms id: Cdui9Va8XnKVng3VGZXcfBFF6XSxbqSi2XruMc7iu817



Serum
Serum is a protocol and ecosystem that brings unprecedented speed and low transaction costs to decentralized finance. It is built on Solana and is completely permissionless. Ecosystem partners can compose with Serum’s on-chain central limit orderbook to share liquidity and power markets-based features for institutional and retail users.
realms id: 3MMDxjv1SzEFQDKryT7csAvaydYtrgMAc3L9xL9CVLCg
Synthetify
Synthetify is a decentralized protocol allowing for the creation and exchange of synthetic assets without the need of a counterparty.
realms id: 7oB84bSuxv9AH1iRdMp5nFLwpQApv8Yo9s1gGmDkHtSP
The Imperium of Rain
Information about this account is not available, but it seems that this account creates and sells NFTs.
realms id: 6orGiJYGXYk9GT2NFoTv2ZMYpA6asMieAqdek4YRH2Dn

Jet
The JetDAO is a community of DeFi contributors working together to grow and scale the Jet Protocol ecosystem through active governance.
realms id: 78TbURwqF71Qk4w1Xp6Jd2gaoQb6EC7yKBh5xDJmq6qh