SELECT

BLOCK_TIMESTAMP as created_timestamp,

FEE as fee,

FEE_PERCENT as fee_percent,

INIT_PRICE_1_0,

INIT_PRICE_1_0_USD,

INIT_TICK,

POOL_ADDRESS,

POOL_NAME,

TICK_SPACING,

TOKEN0_ADDRESS,

TOKEN1_ADDRESS,

TOKEN0_SYMBOL,

TOKEN1_SYMBOL,

TOKEN0_NAME,

TOKEN1_NAME,

TOKEN0_DECIMALS,

TOKEN1_DECIMALS

FROM ethereum.uniswapv3.ez_pools

WHERE BLOCK_TIMESTAMP > (select dateadd(week, -1, getdate()))

ORDER BY BLOCK_TIMESTAMP DESC

),

pool_stats as (

SELECT

stats.BLOCK_NUMBER,

stats.BLOCK_TIMESTAMP,

stats.BLOCKCHAIN,

stats.FEE_GROWTH_GLOBAL0_X128,

stats.FEE_GROWTH_GLOBAL1_X128,

recent_pools.POOL_ADDRESS,

stats.POOL_NAME,

stats.PRICE_0_1,

stats.PRICE_1_0,

stats.PROTOCOL_FEES_TOKEN0_ADJUSTED,