freemartianProposal Votes
Updated 2022-06-20
99
1
2
3
4
5
6
7
8
9
10
›
⌄
select event_inputs:proposalId as proposalID, sum(event_inputs:votes) as power,
case
when event_inputs:support = '0' then 'against'
when event_inputs:support = '1' then 'for'
when event_inputs:support = '2' then 'abstain'
end as position
from ethereum.core.fact_event_logs
where origin_to_address = '0x5d2c31ce16924c2a71d317e5bbfd5ce387854039'
and event_name = 'VoteCast'
group by proposalID, position
Run a query to Download Data