count(DISTINCT tx_hash) as txs,

sum(txs) over (order by date) as cum_txs,

count(DISTINCT from_address) as users,

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

sum(tx_fee) as fee,

avg(tx_fee) as average_fee,

avg(gas_used) as gas,

sum(cumulative_gas_used) as cum_gas

from gnosis.core.fact_transactions

where block_timestamp >= '2022-10-01'

and status = 'SUCCESS'

group by 1

order by 1