shawnedwardsVote on Nouns
Updated 2022-07-07
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
›
⌄
select
event_inputs:proposalId as proposalId,
sum(case when event_inputs:support = '1' then event_inputs:votes end) as for_vote,
sum(case when event_inputs:support = '0' then event_inputs:votes end) as against_vote,
sum(case when event_inputs:support = '2' then event_inputs:votes end) as abstain_vote
from ethereum.core.fact_event_logs
where
event_name = 'VoteCast' and contract_address = '0x6f3e6272a167e8accb32072d08e0957f9c79223d'
group by 1
Run a query to Download Data