select hour::Date as day,

avg (price) as USDPrice

from ethereum.price.ez_hourly_token_prices

where symbol = 'WETH'

group by 1),

maintable as (

select block_number,

sum (tx_fee) as Gas,

sum (tx_fee*usdprice) as USD_Gas,

avg (tx_fee*usdprice) as Average_USD_Gas

from blast.core.fact_transactions t1 join ethpricet t2 on t1.block_timestamp::Date = t2.DAY

where block_timestamp >= '2024-02-29 00:00:00.000'

group by 1)

select avg (Gas) as "Average Gas [ETH]",

avg (usd_gas) as "Average Gas [USD]"

from maintable