barbodBOTS
Updated 2022-04-29
99
1
2
3
4
5
6
7
8
9
10
11
›
⌄
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