, BLOCK_TIMESTAMP

, TRADER

, ((AMOUNT_OUT)-(AMOUNT_IN)) as diff

, case when diff > 0 then '+' else '-' end as type

from near.defi.ez_dex_swaps

where SYMBOL_OUT in ('USDt' , 'USDT.e' ,'USDC' ,'USDC.e')

and SYMBOL_IN in ('USDt' , 'USDT.e' ,'USDC' ,'USDC.e')

and BLOCK_TIMESTAMP >= '2023-03-11 00:00:00.000'

and BLOCK_TIMESTAMP < '2023-03-12 00:00:00.000'