date_trunc('day', block_timestamp) as day,

sum(AMOUNT_OUT_USD) as "USD volume IN",

sum(AMOUNT_IN_USD)*-1 as "USD volume out",

"USD volume IN" + "USD volume out" as "net flow"

from ethereum.core.ez_dex_swaps

where TOKEN_IN = '0x92d6c1e31e14520e676a687f0a93788b716beff5'

OR TOKEN_OUT = '0x92d6c1e31e14520e676a687f0a93788b716beff5'

and day >= CURRENT_DATE() - 60

group by 1