flipside

    Metaplex Foundation
    HadisehMetaplex Foundation
    Updated 2022-08-18
    with tb1 as ( select block_timestamp::date as day ,REALMS_ID, tx_id, voter, proposal
    from solana.core.fact_proposal_votes
    where REALMS_ID in (
    '7oB84bSuxv9AH1iRdMp5nFLwpQApv8Yo9s1gGmDkHtSP', '78TbURwqF71Qk4w1Xp6Jd2gaoQb6EC7yKBh5xDJmq6qh','Cdui9Va8XnKVng3VGZXcfBFF6XSxbqSi2XruMc7iu817',
    '3MMDxjv1SzEFQDKryT7csAvaydYtrgMAc3L9xL9CVLCg','B1CxhV1khhj7n5mi5hebbivesqH9mvXr5Hfh2nD2UCh6' , '7sf3tcWm58vhtkJMwuw2P3T6UBX7UE5VKxPMnXJUZ1Hn',
    '6orGiJYGXYk9GT2NFoTv2ZMYpA6asMieAqdek4YRH2Dn', '2sEcHwzsNBwNoTM1yAXjtF1HTMQKUAXf8ivtdpSpo9Fv', 'DPiH3H3c7t47BMxqTxLsuPQpEC6Kne8GA9VXbxpnZxFE',
    'FiG6YoqWnVzUmxFNukcRVXZC51HvLr6mts8nxcm7ScR8' ,'By2sVGZXwfQq6rAiAM3rNPJ9iQfb5e2QhnF4YjJ4Bip' )
    and SUCCEEDED = 'TRUE')


    select 'Metaplex Foundation DAO' as realm_name , REALMS_ID , min(day) as first_proposal_date, max(day) as last_proposal_date,
    count(DISTINCT voter) as total_voters, count(DISTINCT tx_id) as total_votes, count(DISTINCT proposal ) as total_proposals
    from tb1
    where REALMS_ID = '2sEcHwzsNBwNoTM1yAXjtF1HTMQKUAXf8ivtdpSpo9Fv'
    group by 1,2
    Run a query to Download Data