-- forked from swap from usdt @ https://flipsidecrypto.xyz/edit/queries/1fda5a82-2ce8-4988-b117-0a21d85a2443

select BLOCK_TIMESTAMP as date,TX_HASH,

(AMOUNT_IN)as others,

(AMOUNT_IN_USD)as others_USD,

SYMBOL_IN,

(AMOUNT_OUT) as USDT,

(AMOUNT_OUT_USD) as USDT_USD,

SYMBOL_OUT,

(others_USD/others)as others_price,

(USDT_USD/USDT) as USDT_price,

(usdt-others) as difference

ethereum.core.ez_dex_swaps

SYMBOL_OUT = 'USDT'

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

and date >= '2023-02-01'

order by difference DESC

limit 10