trunc(block_timestamp,'day') as date,

status,

count(distinct from_address) as daily_users,

sum(daily_users) over (order by date) as cum_users,

count(distinct tx_hash) as daily_transactions,

sum(daily_transactions) over (order by date) as cum_transactions,

sum(tx_fee) as daily_fees,

sum(daily_fees) over (order by date) as cum_fees,

avg(tx_fee) as avg_fee_per_tx

from gnosis.core.fact_transactions

group by 1,2

order by 1 asc