MahrooUntitled Query
Updated 2022-11-02Copy Reference Fork
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
›
⌄
with table1 as (
select from_address,
sum (raw_amount/1e18) as Volume1
from ethereum.core.ez_token_transfers
where contract_address = '0x600000000a36f3cd48407e35eb7c5c910dc1f7a8'
group by 1),
table2 as (
select to_address,
sum (raw_amount/1e18) as Volume2
from ethereum.core.ez_token_transfers
where contract_address = '0x600000000a36f3cd48407e35eb7c5c910dc1f7a8'
group by 1)
select from_address,
sum (volume2 - volume1) as Amount
from table1 t1 join table2 t2 on t1.from_address = t2.to_address
group by 1
order by 2 DESC
limit 10
Run a query to Download Data