date_trunc (day,block_timestamp) as date,

Count(DISTINCT tx_hash) as transactions,

sum (tx_fee) as fee,

sum(fee) over (order by date) as cum_FEE,

sum(transactions) over (order by date) as cum_tx,

avg(tx_fee) as avg_fee,

min(tx_fee) as min_fee,

max(tx_fee) as max_fee,

median(tx_fee) as median_fee

from ethereum.core.fact_transactions

Where block_Timestamp >= '2022-01-01'

Group by 1 Order by 1