MLDZMNh26-2
    Updated 2023-08-07
    select
    PROPOSAL_TITLE,
    case
    when PARSE_JSON(PARSE_JSON(TO_VARCHAR(VOTE_OPTION))[0]) = 1 then 'For'
    when PARSE_JSON(PARSE_JSON(TO_VARCHAR(VOTE_OPTION))[0]) = 2 then 'Against'
    when PARSE_JSON(PARSE_JSON(TO_VARCHAR(VOTE_OPTION))[0]) = 3 then 'Abstain'
    end as options,
    Count(*) as "Total votes",
    count(distinct voter) as "voters",
    sum(VOTING_POWER) as "Voting power",
    avg(VOTING_POWER) as "Average voting power",
    median(VOTING_POWER) as "Median voting power"

    from ethereum.core.ez_snapshot
    where NETWORK = 'Avalanche C-Chain'
    and SPACE_ID = 'hubbleexchange.eth'
    and PROPOSAL_TITLE in ('HP028 - Validator Mining Program',
    'HP026 - Onboard an Oracle Provider, Block Explorer and Node Manager',
    'HP027 - Onboarding Designated Market Maker')
    group by 1,2


    Run a query to Download Data