MahrooUntitled Query
    Updated 2022-11-02
    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