count(DISTINCT tx_hash) as txs,

count(DISTINCT from_address) as users,

sum(tx_fee) as fee,

avg(tx_fee) as average_fee,

avg(gas_used) as gas

from gnosis.core.fact_transactions

where block_timestamp >= '2022-10-01'

and status = 'SUCCESS'