barbodBOTS
    Updated 2022-04-29
    select proposal_id::number as id,
    case
    when voter in (select address from terra.labels where label_subtype = 'validator') then 'validator'
    else 'retail investors'
    end as validator_vs_regular,
    count(voter) as n,
    sum(voting_power) as mean_voting_power_YES
    from terra.gov_vote
    where option = 'VOTE_OPTION_YES'
    and id in (1046,1025,1014,971,929)
    group by proposal_id, validator_vs_regular
    Run a query to Download Data