nitsProposal
Updated 2022-06-20
99
1
2
3
4
5
6
7
8
9
10
11
›
⌄
SELECT pid, COUNT(DISTINCT origin_from_address) as voters, sum(s) as total_support, (voters-total_support) as non
from
(select * ,
event_inputs:proposalId as pid, event_inputs:support
as s
from ethereum.core.fact_event_logs where
contract_address = '0x5d2c31ce16924c2a71d317e5bbfd5ce387854039'
and origin_function_signature = '0x56781388' and s!='2' )
where pid is not NULL
GROUP by 1
LIMIT 100
Run a query to Download Data