(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' )

)

, SWAPS AS (select

POOL_NAME ,