sarathtracer voters
Updated 2022-03-02
99
1
2
3
4
5
6
7
8
9
10
11
12
›
⌄
with data1 as (SELECT origin_address ,sum( CASE
WHEN to_address='0xa84918f3280d488eb3369cb713ec53ce386b6cba' then amount
when from_address='0xa84918f3280d488eb3369cb713ec53ce386b6cba' then -amount
else 0
end ) as voting
from ethereum.udm_events
where contract_address='0x9c4a4204b79dd291d6b6571c5be8bbcd0622f050' and (to_address in ('0xa84918f3280d488eb3369cb713ec53ce386b6cba') or
from_address in('0xa84918f3280d488eb3369cb713ec53ce386b6cba'))
group by origin_address)
SELECT * from data1
LIMIT 1000
Run a query to Download Data