saeedmznRealms vs Snapshot - realms Top 10 DAOs
Updated 2022-09-01
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
›
⌄
select
case when realms_id ='By2sVGZXwfQq6rAiAM3rNPJ9iQfb5e2QhnF4YjJ4Bip' then 'Grape'
when realms_id ='DPiH3H3c7t47BMxqTxLsuPQpEC6Kne8GA9VXbxpnZxFE' then 'Mango'
when realms_id = 'B1CxhV1khhj7n5mi5hebbivesqH9mvXr5Hfh2nD2UCh6' then 'MonkeDAO'
when realms_id ='6orGiJYGXYk9GT2NFoTv2ZMYpA6asMieAqdek4YRH2Dn' then 'The Imperium of Rain'
when realms_id ='GBXLYo4ycRNfzuzYeudu6y2ng4afNeW14WcpM2E4JJSL' then 'UXD Protocl'
else realms_id
end as name ,
count (distinct tx_id) as num_votes
-- count (distinct voter) as num_voters
from solana.core.fact_proposal_votes
where governance_platform = 'realms'
group by 1 order by num_votes desc limit 10
Run a query to Download Data