zakkisyedNouns: Voting activity
Updated 2023-04-26
99
1
2
3
4
5
6
7
8
9
10
11
12
›
⌄
select event_inputs:proposalId::number as proposal_id,
count(distinct (event_inputs:voter::string)) as no_of_voter
-- count (event_inputs:votes:number) as no_of_votes,
--event_inputs:support:number as voted_as
from ethereum.core.fact_event_logs
where contract_address=lower('0x6f3E6272A167e8AcCb32072d08E0957F9c79223d')
and event_name = 'VoteCast'
group by 1
order by 1 asc
Run a query to Download Data