(select

SYMBOL_IN ,

SYMBOL_OUT ,

PLATFORM ,

AMOUNT_IN,

AMOUNT_IN_USD,

AMOUNT_OUT ,

AMOUNT_OUT_USD,

POOL_NAME ,

ORIGIN_FROM_ADDRESS ,

BLOCK_TIMESTAMP ,

TX_HASH

from ethereum.core.ez_dex_swaps

where EVENT_NAME ='Swap'

and SYMBOL_IN in ('USDT','USDC','USDH','UST','fUSD','USVC','USDS','USDK' )

and SYMBOL_OUT in ('USDT','USDC','USDH','UST','fUSD','USVC','USDS','USDK' )

)

, SWAPS AS (select

POOL_NAME , BLOCK_TIMESTAMP , TX_HASH ,ORIGIN_FROM_ADDRESS ,AMOUNT_IN_USD,

AMOUNT_OUT_USD ,SYMBOL_IN ,

SYMBOL_OUT ,PLATFORM,

(-(AMOUNT_OUT_USD-AMOUNT_IN_USD)*100/(AMOUNT_IN_USD)) as slippage , AMOUNT_OUT_USD- AMOUNT_IN_USD AS PROFIT

from fuop WHERE AMOUNT_IN_USD IS NOT NULL AND AMOUNT_OUT_USD IS NOT NULL

)