The Question

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

I have used the following addresses from solana.core.fact_proposal_votes table

when realms_id ='DPiH3H3c7t47BMxqTxLsuPQpEC6Kne8GA9VXbxpnZxFE' then 'Mango'
when realms_id = 'FiG6YoqWnVzUmxFNukcRVXZC51HvLr6mts8nxcm7ScR8' then 'Psy Finance'
when realms_id = 'By2sVGZXwfQq6rAiAM3rNPJ9iQfb5e2QhnF4YjJ4Bip' then 'Grape'
when realms_id = '6orGiJYGXYk9GT2NFoTv2ZMYpA6asMieAqdek4YRH2Dn' then 'The Imperium of Rain'
when realms_id = '7sf3tcWm58vhtkJMwuw2P3T6UBX7UE5VKxPMnXJUZ1Hn' then 'Solend'
when realms_id = 'B1CxhV1khhj7n5mi5hebbivesqH9mvXr5Hfh2nD2UCh6' then 'MonkeDAO'
when realms_id = 'Cdui9Va8XnKVng3VGZXcfBFF6XSxbqSi2XruMc7iu817' then 'Metaplex Genesis'
when realms_id = '2sEcHwzsNBwNoTM1yAXjtF1HTMQKUAXf8ivtdpSpo9Fv' then 'Metaplex Foundation'
when realms_id = '3MMDxjv1SzEFQDKryT7csAvaydYtrgMAc3L9xL9CVLCg' then 'Serum'
when realms_id = '7oB84bSuxv9AH1iRdMp5nFLwpQApv8Yo9s1gGmDkHtSP' then 'Synthetify'
 
  as realms,

Findings

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

The Imperium of Rain is ranked first by 1322 unique voters, and Grape and Solend ranked second and third by 419 and 223

• Total Votes

  The Grape is ranked first by 2835 votes, and Imperium of Rain and Mango ranked second and third by 2534 and 1774

• Number of Proposals

  The MonkeDAO is ranked first by 196 votes, Mango and Grape ranked second and third by 176 and 70

• Date of Last Proposal

  The latest proposals belong to Monkedao and PsyFinance

• Date of Creation

Serum is the older one, created in 2021-12-01 and Solend is the younger one created at 2022-06-19 (date of creation = date of first proposal)

• Max voting Time

  Serum ,Imperium of Rain and Synthetify daos with 7 days

• Votes per user

• Monkedao with 63 , Metaplex Foundation with 24 and Metaplex genesis with 12 are top