Sajjadiii2. Tracking Realms DAOs
Updated 2022-08-16Copy Reference Fork
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
›
⌄
select case
when realms_id = 'DPiH3H3c7t47BMxqTxLsuPQpEC6Kne8GA9VXbxpnZxFE' then 'Mango DAO'
when realms_id = 'By2sVGZXwfQq6rAiAM3rNPJ9iQfb5e2QhnF4YjJ4Bip' then 'Grape DAO'
when realms_id = 'FiG6YoqWnVzUmxFNukcRVXZC51HvLr6mts8nxcm7ScR8' then 'Psy Finance DAO'
when realms_id = '7sf3tcWm58vhtkJMwuw2P3T6UBX7UE5VKxPMnXJUZ1Hn' then 'Solend DAO'
when realms_id = 'B1CxhV1khhj7n5mi5hebbivesqH9mvXr5Hfh2nD2UCh6' then 'Monke DAO'
when realms_id = '2sEcHwzsNBwNoTM1yAXjtF1HTMQKUAXf8ivtdpSpo9Fv' then 'Metaplex Foundation DAO'
when realms_id = '78TbURwqF71Qk4w1Xp6Jd2gaoQb6EC7yKBh5xDJmq6qh' then 'Jet DAO'
when realms_id = '3MMDxjv1SzEFQDKryT7csAvaydYtrgMAc3L9xL9CVLCg' then 'Serum DAO'
when realms_id = '6orGiJYGXYk9GT2NFoTv2ZMYpA6asMieAqdek4YRH2Dn' then 'The Imperium of Rain DAO'
when realms_id = '7oB84bSuxv9AH1iRdMp5nFLwpQApv8Yo9s1gGmDkHtSP' then 'Synthetify DAO'
else null
end as program_name ,
max(block_timestamp)as date_last_proposal ,
min(block_timestamp)as creation_date
from solana.core.fact_proposal_votes
where
realms_id = 'DPiH3H3c7t47BMxqTxLsuPQpEC6Kne8GA9VXbxpnZxFE' -- 'Mango DAO'
or realms_id = 'By2sVGZXwfQq6rAiAM3rNPJ9iQfb5e2QhnF4YjJ4Bip' -- 'Grape DAO'
or realms_id = 'FiG6YoqWnVzUmxFNukcRVXZC51HvLr6mts8nxcm7ScR8' -- 'Psy Finance DAO'
or realms_id = '7sf3tcWm58vhtkJMwuw2P3T6UBX7UE5VKxPMnXJUZ1Hn' -- 'Solend DAO'
or realms_id = 'B1CxhV1khhj7n5mi5hebbivesqH9mvXr5Hfh2nD2UCh6' -- 'Monke DAO'
or realms_id = '2sEcHwzsNBwNoTM1yAXjtF1HTMQKUAXf8ivtdpSpo9Fv' -- 'Metaplex Foundation DAO'
or realms_id = '78TbURwqF71Qk4w1Xp6Jd2gaoQb6EC7yKBh5xDJmq6qh' -- 'Jet DAO'
or realms_id = '3MMDxjv1SzEFQDKryT7csAvaydYtrgMAc3L9xL9CVLCg' -- 'Serum DAO'
or realms_id = '6orGiJYGXYk9GT2NFoTv2ZMYpA6asMieAqdek4YRH2Dn' -- 'The Imperium of Rain DAO'
or realms_id = '7oB84bSuxv9AH1iRdMp5nFLwpQApv8Yo9s1gGmDkHtSP' -- 'Synthetify DAO'
and SUCCEEDED = 'TRUE'
group by 1
Run a query to Download Data