date_trunc(day ,hour) as date,

avg(PRICE) as Price

from ethereum.price.ez_prices_hourly

where SYMBOL = 'WETH'

and HOUR > '2024-02-29'

group by 1

)

select

date_trunc(day, block_timestamp) as date,

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

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

count(tx_hash) as "TX Count",

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(day, block_timestamp) = date

where STATUS = 'SUCCESS'

and block_timestamp >= '2024-02-29'

group by 1