Moebeefy gov 2
Updated 2023-08-19
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
›
⌄
select
PROPOSAL_TITLE,
case
when to_varchar(VOTE_OPTION[0]) = 1 then 'For'
when to_varchar(VOTE_OPTION[0]) = 2 then 'Against'
when 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 SPACE_ID ilike '%beefy%'
and PROPOSAL_TITLE in ('[BIP:71] $BIFI Migration Plan',
'[BSP:03] $BIFI Migration',
'[BIP:72] August - October 2023 Core Contributor Funding Proposal')
group by 1,2
Run a query to Download Data