hour,

avg(PRICE) as Price

from ethereum.price.ez_prices_hourly

where SYMBOL = 'WETH'

and HOUR > '2024-02-29'

group by 1

)

select

sum(TX_FEE) as "TX FEE ($ETH)",

sum(TX_Fee * Price) as "TX Fee (USD)",

avg(TX_Fee * Price) as "Avg TX Fee",

min(TX_Fee * Price) as "Min TX Fee",

max(TX_Fee * Price) as "Max TX Fee",

median(TX_Fee * Price) as "Median TX Fee"

from blast.core.fact_transactions

join ETH_price on date_trunc(hour, block_timestamp) = hour

where STATUS = 'SUCCESS'

and block_timestamp > '2024-02-29'