m0rt3zaRealms - DAO's cumulative votes over time
    Updated 2023-04-13
    WITH votes AS (
    SELECT block_timestamp::date as date,
    CASE
    WHEN realms_id = 'DPiH3H3c7t47BMxqTxLsuPQpEC6Kne8GA9VXbxpnZxFE' THEN 'Mango'
    WHEN realms_id = '3MMDxjv1SzEFQDKryT7csAvaydYtrgMAc3L9xL9CVLCg' THEN 'Serum'
    WHEN realms_id = 'By2sVGZXwfQq6rAiAM3rNPJ9iQfb5e2QhnF4YjJ4Bip' THEN 'Grape'
    WHEN realms_id = 'FiG6YoqWnVzUmxFNukcRVXZC51HvLr6mts8nxcm7ScR8' THEN 'Psy Finance'
    WHEN realms_id = 'B1CxhV1khhj7n5mi5hebbivesqH9mvXr5Hfh2nD2UCh6' THEN 'MonkeDAO'
    WHEN realms_id = 'Cdui9Va8XnKVng3VGZXcfBFF6XSxbqSi2XruMc7iu817'
    OR realms_id = '2sEcHwzsNBwNoTM1yAXjtF1HTMQKUAXf8ivtdpSpo9Fv' THEN 'Metaplex'
    WHEN realms_id = '78TbURwqF71Qk4w1Xp6Jd2gaoQb6EC7yKBh5xDJmq6qh' THEN 'Jet'
    WHEN realms_id = '7sf3tcWm58vhtkJMwuw2P3T6UBX7UE5VKxPMnXJUZ1Hn' THEN 'Solend'
    WHEN realms_id = '6orGiJYGXYk9GT2NFoTv2ZMYpA6asMieAqdek4YRH2Dn' THEN 'The imperium of Rain'
    WHEN realms_id = '7oB84bSuxv9AH1iRdMp5nFLwpQApv8Yo9s1gGmDkHtSP' THEN 'Synthetify'
    END AS dao_name,
    tbl.*
    FROM solana.core.fact_proposal_votes as tbl
    WHERE succeeded = TRUE
    AND realms_id IN
    ('DPiH3H3c7t47BMxqTxLsuPQpEC6Kne8GA9VXbxpnZxFE', --mango dao
    '3MMDxjv1SzEFQDKryT7csAvaydYtrgMAc3L9xL9CVLCg', --serum
    '78TbURwqF71Qk4w1Xp6Jd2gaoQb6EC7yKBh5xDJmq6qh', -- jet
    '7sf3tcWm58vhtkJMwuw2P3T6UBX7UE5VKxPMnXJUZ1Hn', -- solend
    'FiG6YoqWnVzUmxFNukcRVXZC51HvLr6mts8nxcm7ScR8', -- psy finance
    'B1CxhV1khhj7n5mi5hebbivesqH9mvXr5Hfh2nD2UCh6', -- monke dao
    'Cdui9Va8XnKVng3VGZXcfBFF6XSxbqSi2XruMc7iu817', -- metaplex genesis
    '2sEcHwzsNBwNoTM1yAXjtF1HTMQKUAXf8ivtdpSpo9Fv', -- metaplex foundation
    'By2sVGZXwfQq6rAiAM3rNPJ9iQfb5e2QhnF4YjJ4Bip', -- grape
    '6orGiJYGXYk9GT2NFoTv2ZMYpA6asMieAqdek4YRH2Dn', -- the imperium rain
    '7oB84bSuxv9AH1iRdMp5nFLwpQApv8Yo9s1gGmDkHtSP' -- synthetify
    )--COUNT(*) over (order by date rows unbounded preceding) as cumulative_votes
    ), s AS (
    SELECT date,
    dao_name,
    count(DISTINCT tx_id) as votes,
    CASE
    Run a query to Download Data