SELECT date_trunc('day',block_timestamp) as date,
sum(tx_fee) as fee,
sum(fee) over(ORDER BY date) as cumulative_fee,
avg(tx_fee) as daily_avg_fee,
count(*) as n_txns
FROM gnosis.core.fact_transactions
WHERE date >= '2022-01-01'
GROUP BY date
ORDER BY date DESC