SniperThe order of the DAOs based on date
    Updated 2022-08-17
    WITH realms_dao AS (
    SELECT *
    FROM (
    VALUES
    ('DPiH3H3c7t47BMxqTxLsuPQpEC6Kne8GA9VXbxpnZxFE' ,'Mango'),
    ('By2sVGZXwfQq6rAiAM3rNPJ9iQfb5e2QhnF4YjJ4Bip' ,'Grape'),
    ('FiG6YoqWnVzUmxFNukcRVXZC51HvLr6mts8nxcm7ScR8' ,'Psy Finance'),
    ('7sf3tcWm58vhtkJMwuw2P3T6UBX7UE5VKxPMnXJUZ1Hn' ,'Solend'),
    ('B1CxhV1khhj7n5mi5hebbivesqH9mvXr5Hfh2nD2UCh6' ,'MonkeDAO'),
    ('Cdui9Va8XnKVng3VGZXcfBFF6XSxbqSi2XruMc7iu817' ,'Metaplex Genesis'),
    ('2sEcHwzsNBwNoTM1yAXjtF1HTMQKUAXf8ivtdpSpo9Fv' ,'Metaplex Foundation'),
    ('78TbURwqF71Qk4w1Xp6Jd2gaoQb6EC7yKBh5xDJmq6qh' ,'Jet'),
    ('6orGiJYGXYk9GT2NFoTv2ZMYpA6asMieAqdek4YRH2Dn' ,'The Imperium of Rain'),
    ('3MMDxjv1SzEFQDKryT7csAvaydYtrgMAc3L9xL9CVLCg' ,'Serum'),
    ('7oB84bSuxv9AH1iRdMp5nFLwpQApv8Yo9s1gGmDkHtSP' ,'Synthetify')
    ) AS dao(pubkey,lable)
    ),

    tbl as
    (select
    BLOCK_TIMESTAMP,
    TX_ID,
    lable,
    realms_id,
    GOVERNANCE_PLATFORM,
    PROGRAM_NAME,
    PROPOSAL,
    VOTER,
    VOTE_CHOICE,
    VOTER_ACCOUNT,
    VOTER_NFT
    from solana.core.fact_proposal_votes A join realms_dao B on A.realms_id = B.pubkey
    where SUCCEEDED = 'TRUE'
    ),
    final as
    ( select lable ,
    Run a query to Download Data