(select date(hour) as date,

avg(PRICE) as avg_price

from ethereum.price.ez_prices_hourly

where symbol = 'WETH'

group by 1),

base_chain as

(select date(BLOCK_TIMESTAMP) as datetime,

avg(TX_FEE) as avg_fee

from base.core.fact_transactions

group by 1),

arbitrum_chain as (

select date(BLOCK_TIMESTAMP) as datetime,

avg(TX_FEE) as avg_fee

from arbitrum.core.fact_transactions

group by 1

),

blast_chain as (

select date(BLOCK_TIMESTAMP) as datetime,

avg(TX_FEE) as avg_fee

from blast.core.fact_transactions

group by 1

),

optimism_chain as (

select date(BLOCK_TIMESTAMP) as datetime,

avg(TX_FEE) as avg_fee

from optimism.core.fact_transactions

group by 1

select datetime,

-- chain,