SniperThe order of the DAOs based on date
Updated 2022-08-17Copy 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
30
31
32
33
34
35
36
›
⌄
WITH realms_dao AS (
SELECT *
FROM (
VALUES
('DPiH3H3c7t47BMxqTxLsuPQpEC6Kne8GA9VXbxpnZxFE' ,'Mango'),
('By2sVGZXwfQq6rAiAM3rNPJ9iQfb5e2QhnF4YjJ4Bip' ,'Grape'),
('FiG6YoqWnVzUmxFNukcRVXZC51HvLr6mts8nxcm7ScR8' ,'Psy Finance'),
('7sf3tcWm58vhtkJMwuw2P3T6UBX7UE5VKxPMnXJUZ1Hn' ,'Solend'),
('B1CxhV1khhj7n5mi5hebbivesqH9mvXr5Hfh2nD2UCh6' ,'MonkeDAO'),
('Cdui9Va8XnKVng3VGZXcfBFF6XSxbqSi2XruMc7iu817' ,'Metaplex Genesis'),
('2sEcHwzsNBwNoTM1yAXjtF1HTMQKUAXf8ivtdpSpo9Fv' ,'Metaplex Foundation'),
('78TbURwqF71Qk4w1Xp6Jd2gaoQb6EC7yKBh5xDJmq6qh' ,'Jet'),
('6orGiJYGXYk9GT2NFoTv2ZMYpA6asMieAqdek4YRH2Dn' ,'The Imperium of Rain'),
('3MMDxjv1SzEFQDKryT7csAvaydYtrgMAc3L9xL9CVLCg' ,'Serum'),
('7oB84bSuxv9AH1iRdMp5nFLwpQApv8Yo9s1gGmDkHtSP' ,'Synthetify')
) AS dao(pubkey,lable)
),
tbl as
(select
BLOCK_TIMESTAMP,
TX_ID,
lable,
realms_id,
GOVERNANCE_PLATFORM,
PROGRAM_NAME,
PROPOSAL,
VOTER,
VOTE_CHOICE,
VOTER_ACCOUNT,
VOTER_NFT
from solana.core.fact_proposal_votes A join realms_dao B on A.realms_id = B.pubkey
where SUCCEEDED = 'TRUE'
),
final as
( select lable ,
Run a query to Download Data