sell_asset as negative,

sum(sell_volume) as netflow_negative

from

(select date(block_timestamp) as date,

symbol_in as sell_asset,

-coalesce(sum(amount_in_usd),0) as sell_volume

from avalanche.defi.ez_dex_swaps

group by 1,2

union all

select date(block_timestamp) as date,

symbol_out as buy_asset,

coalesce(sum(amount_out_usd),0) as buy_volume

from avalanche.defi.ez_dex_swaps

group by 1,2

)

where date >= current_date - interval '7 day'

group by 1

order by 2 desc

limit 10