SELECT

trunc(hour, 'hour') as hour,

avg(price) as ethprice

FROM

crosschain.price.ez_prices_hourly

WHERE

symbol = 'WETH'

group by

1

),

common_pools AS (

SELECT

DISTINCT pool_name

FROM

arbitrum.defi.ez_dex_swaps

WHERE

platform = 'uniswap-v2'

AND pool_name IN ('WETH-USDT', 'WETH-USDC', 'WETH-DAI')

INTERSECT

SELECT

DISTINCT pool_name

FROM

base.defi.ez_dex_swaps

WHERE

platform = 'uniswap-v2'

AND pool_name IN ('WETH-USDT', 'WETH-USDC', 'WETH-DAI')

LIMIT

10

), arb AS (

SELECT

'arbitrum' AS blockchain,

trunc(block_timestamp, 'hour') AS hour,

date_trunc('day', block_timestamp) as "Day",

tx_hash,

pool_name,