sinahosseinzadehUntitled Query
Updated 2022-08-17
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
›
⌄
WITH REALMS AS (
SELECT 'Mango DAO' AS REALM_DAO, 'DPiH3H3c7t47BMxqTxLsuPQpEC6Kne8GA9VXbxpnZxFE' as REALM_ADDRESS
UNION ALL
SELECT 'Grape DAO' AS REALM_DAO, 'By2sVGZXwfQq6rAiAM3rNPJ9iQfb5e2QhnF4YjJ4Bip' as REALM_ADDRESS
UNION ALL
SELECT 'Psy Finance DAO' AS REALM_DAO, 'FiG6YoqWnVzUmxFNukcRVXZC51HvLr6mts8nxcm7ScR8' as REALM_ADDRESS
UNION ALL
SELECT 'Solend DAO' AS REALM_DAO, '7sf3tcWm58vhtkJMwuw2P3T6UBX7UE5VKxPMnXJUZ1Hn' as REALM_ADDRESS
UNION ALL
SELECT 'Monke DAO' AS REALM_DAO, 'B1CxhV1khhj7n5mi5hebbivesqH9mvXr5Hfh2nD2UCh6' as REALM_ADDRESS
UNION ALL
SELECT 'Metaplex Foundation DAO' AS REALM_DAO, '2sEcHwzsNBwNoTM1yAXjtF1HTMQKUAXf8ivtdpSpo9Fv' as REALM_ADDRESS
UNION ALL
SELECT 'Metaplex Genesis DAO' AS REALM_DAO, 'Cdui9Va8XnKVng3VGZXcfBFF6XSxbqSi2XruMc7iu817' as REALM_ADDRESS
UNION ALL
SELECT 'Jet DAO' AS REALM_DAO, '78TbURwqF71Qk4w1Xp6Jd2gaoQb6EC7yKBh5xDJmq6qh' as REALM_ADDRESS
UNION ALL
SELECT 'Serum DAO' AS REALM_DAO, '3MMDxjv1SzEFQDKryT7csAvaydYtrgMAc3L9xL9CVLCg' as REALM_ADDRESS
UNION ALL
SELECT 'The Imperium of Rain DAO' AS REALM_DAO, '6orGiJYGXYk9GT2NFoTv2ZMYpA6asMieAqdek4YRH2Dn' as REALM_ADDRESS
UNION ALL
SELECT 'Synthetify DAO' AS REALM_DAO, '7oB84bSuxv9AH1iRdMp5nFLwpQApv8Yo9s1gGmDkHtSP' as REALM_ADDRESS
)
SELECT DATE_TRUNC('DAY', BLOCK_TIMESTAMP) AS DAY,
COUNT(DISTINCT(TX_ID)) AS TOTAL_VOTES,
COUNT(DISTINCT(PROPOSAL)) AS NO_OF_PROPOSALS
FROM solana.core.fact_proposal_votes v INNER JOIN REALMS r ON v.REALMS_ID=r.REALM_ADDRESS
GROUP BY DAY
Run a query to Download Data