SELECT

*

FROM

ethereum.uniswapv3.ez_swaps

WHERE

BLOCK_NUMBER >= (

(

SELECT

MAX(BLOCK_NUMBER)

FROM

ethereum.uniswapv3.ez_swaps

) -25000

)

),

eth_stable_price AS (

SELECT

BLOCK_NUMBER,

BLOCK_TIMESTAMP,

IFF(

TOKEN1_SYMBOL = 'WETH',

ABS(DIV0(AMOUNT0_ADJUSTED, AMOUNT1_ADJUSTED)),

ABS(DIV0(AMOUNT1_ADJUSTED, AMOUNT0_ADJUSTED))

) as eth_stable_trade_price,

IFF(

TOKEN1_SYMBOL = 'WETH',

ABS(AMOUNT1_ADJUSTED),

ABS(AMOUNT0_ADJUSTED)

) as eth_volume,

IFF(

TOKEN1_SYMBOL = 'WETH',

TOKEN0_SYMBOL,

TOKEN1_SYMBOL

) as stable

FROM

uniswap_eth_stable_swaps