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 '24 hour'

group by 1

order by 2 asc

limit 10