select date_trunc('day', BLOCK_TIMESTAMP) as date,

sum(AMOUNT_IN)as others,

sum(AMOUNT_IN_USD)as others_USD,

SYMBOL_IN,

sum(AMOUNT_OUT) as USDT,

sum(AMOUNT_OUT_USD) as USDT_USD,

SYMBOL_OUT,

(others_USD/others)as others_price,

(USDT_USD/USDT) as USDT_price,

(usdt-others) as difference,

count(distinct TX_HASH) as transactions

ethereum.core.ez_dex_swaps

SYMBOL_OUT = 'USDT'

and SYMBOL_IN in ('USDC', 'DAI')

and date >= '2023-02-01'

group by

1, 4, 7