MLDZMNh26-2
Updated 2023-08-07
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
›
⌄
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