superflyGeneral table
Updated 2023-07-27
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
›
⌄
select iff(program_name = 'GovHgfDPyQ1GwazJTDY2avSVY8GGcpmCapmmCsymRaGe','Psy Finance', 'null') as name, min(BLOCK_TIMESTAMP) as creation_date from solana.core.fact_proposal_votes
where governance_platform = 'realms' and realms_id = 'FiG6YoqWnVzUmxFNukcRVXZC51HvLr6mts8nxcm7ScR8' group by name
UNION select iff(program_name = 'GqTPL6qRf5aUuqscLh8Rg2HTxPUXfhhAXDptTLhp1t2J','Mango', 'null') as name, min(BLOCK_TIMESTAMP) as creation_date
from solana.core.fact_proposal_votes where governance_platform = 'realms' and realms_id = 'DPiH3H3c7t47BMxqTxLsuPQpEC6Kne8GA9VXbxpnZxFE'
group by name UNION select iff(program_name = 'A7kmu2kUcnQwAVn8B4znQmGJeUrsJ1WEhYVMtmiBLkEr','Solend', 'null') as name, min(BLOCK_TIMESTAMP) as creation_date
from solana.core.fact_proposal_votes where governance_platform = 'realms' and realms_id = '7sf3tcWm58vhtkJMwuw2P3T6UBX7UE5VKxPMnXJUZ1Hn'
group by name UNION select iff(program_name = 'GovER5Lthms3bLBqWub97yVrMmEogzX7xNjdXpPPCVZw','Synthetify', 'null') as name, min(BLOCK_TIMESTAMP) as creation_date
from solana.core.fact_proposal_votes
where governance_platform = 'realms' and realms_id = '7oB84bSuxv9AH1iRdMp5nFLwpQApv8Yo9s1gGmDkHtSP'
group by name UNION select iff(program_name = 'GovER5Lthms3bLBqWub97yVrMmEogzX7xNjdXpPPCVZw','Grape', 'null') as name, min(BLOCK_TIMESTAMP) as creation_date
from solana.core.fact_proposal_votes
where governance_platform = 'realms' and realms_id = 'By2sVGZXwfQq6rAiAM3rNPJ9iQfb5e2QhnF4YjJ4Bip'
group by name UNION
select iff(program_name = 'GovER5Lthms3bLBqWub97yVrMmEogzX7xNjdXpPPCVZw','The Imperium of Rain', 'null') as name, min(BLOCK_TIMESTAMP) as creation_date from solana.core.fact_proposal_votes
where governance_platform = 'realms' and realms_id = '6orGiJYGXYk9GT2NFoTv2ZMYpA6asMieAqdek4YRH2Dn' group by name
UNION select iff(program_name = 'AVoAYTs36yB5izAaBkxRG67wL1AMwG3vo41hKtUSb8is','serum', 'null') as name, min(BLOCK_TIMESTAMP) as creation_date from solana.core.fact_proposal_votes
where governance_platform = 'realms' and realms_id = '3MMDxjv1SzEFQDKryT7csAvaydYtrgMAc3L9xL9CVLCg' group by name
UNION select iff(program_name = 'GMpXgTSJt2nJ7zjD1RwbT2QyPhKqD2MjAZuEaLsfPYLF','Metaplex Genesis', 'null') as name, min(BLOCK_TIMESTAMP) as creation_date from solana.core.fact_proposal_votes
where governance_platform = 'realms' and realms_id = 'Cdui9Va8XnKVng3VGZXcfBFF6XSxbqSi2XruMc7iu817' group by name
UNION select iff(program_name = 'GmtpXy362L8cZfkRmTZMYunWVe8TyRjX5B7sodPZ63LJ','Metaplex Foundation', 'null') as name, min(BLOCK_TIMESTAMP) as creation_date
from solana.core.fact_proposal_votes
where governance_platform = 'realms' and realms_id = '2sEcHwzsNBwNoTM1yAXjtF1HTMQKUAXf8ivtdpSpo9Fv'
group by name
UNION select iff(program_name = 'GMnke6kxYvqoAXgbFGnu84QzvNHoqqTnijWSXYYTFQbB','MonkeDAO', 'null') as name, min(BLOCK_TIMESTAMP) as creation_date
from solana.core.fact_proposal_votes where governance_platform = 'realms' and realms_id = 'B1CxhV1khhj7n5mi5hebbivesqH9mvXr5Hfh2nD2UCh6' group by name
Run a query to Download Data