MLDZMNsnap2
Updated 2023-07-03
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
›
⌄
select
case
when PARSE_JSON(PARSE_JSON(TO_VARCHAR(VOTE_OPTION))[0])[0] = 1 then 'Min. vesting of 15d (current)'
when PARSE_JSON(PARSE_JSON(TO_VARCHAR(VOTE_OPTION))[0])[0] = 2 then 'Min. vesting of 10d (current)'
when PARSE_JSON(PARSE_JSON(TO_VARCHAR(VOTE_OPTION))[0])[0] = 3 then 'Min. vesting of 5d (current)'
when PARSE_JSON(PARSE_JSON(TO_VARCHAR(VOTE_OPTION))[0])[0] = 4 then 'Max. vesting of 90d (current)'
when PARSE_JSON(PARSE_JSON(TO_VARCHAR(VOTE_OPTION))[0])[0] = 5 then 'Max. vesting of 60d (current)'
when PARSE_JSON(PARSE_JSON(TO_VARCHAR(VOTE_OPTION))[0])[0] = 6 then 'Max. vesting of 45d (current)'
end as options,
--PARSE_JSON(TO_VARCHAR(VOTE_OPTION))[0] as vote_choices,
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 = 'steakhut.eth'
and PROPOSAL_TITLE = 'xSTEAK Vesting Schedule'
group by 1
order by 2 DESC
Run a query to Download Data