sinahosseinzadehUntitled Query
    Updated 2022-08-17
    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