SELECT

MAX(BLOCK_NUMBER)

FROM

ethereum.defi.ez_dex_swaps

),

uniswap_ETH_stable_swaps AS (

-- Select all trades from the relevant Uniswap pools between the specified blocks

SELECT

BLOCK_NUMBER,

BLOCK_TIMESTAMP,

AMOUNT_IN,

AMOUNT_OUT,

SYMBOL_IN,

SYMBOL_OUT

FROM

ethereum.defi.ez_dex_swaps

WHERE

CONTRACT_ADDRESS IN (

'0x8ad599c3a0ff1de082011efddc58f1908eb6e6d8',

-- ETH-USDC 0.3%

'0x88e6a0c2ddd26feeb64f039a2c41296fcb3f5640',

-- ETH-USDC 0.05%

'0x4e68ccd3e89f51c3074ca5072bbac773960dfa36',

-- ETH-USDT 0.3%

'0x11b815efb8f581194ae79006d24e0d814b7697f6',

-- ETH-USDT 0.05%

'0x7bea39867e4169dbe237d55c8242a8f2fcdcc387',

-- ETH-USDC 1%

'0xc2e9f25be6257c210d7adf0d4cd6e3e881ba25f8' -- ETH-DAI 0.3%

)

AND BLOCK_NUMBER BETWEEN (

SELECT

*

FROM

latest_block