Count(DISTINCT tx_hash) AS no_of_txs,

Sum(success) / ( Sum(success) + Sum(failed) ) * 100 AS success_percent,

Avg(success_percent)

OVER (

ORDER BY day) AS avg_sucess_rate,

Sum(no_of_txs)

OVER (

ORDER BY day) AS

cumulative_txs_count,

Count(DISTINCT from_address) AS no_of_users,

Sum(no_of_users)

OVER (

ORDER BY day) AS

cumulative_wallets_count,

Sum(tx_fee) AS txn_fees,

Sum(txn_fees)

OVER (

ORDER BY day) AS cumulative_fees

FROM (SELECT *,

Iff(status = 'SUCCESS', '1', '0') AS success,

Iff(status = 'FALSE', '0', '1') AS failed

FROM optimism.core.fact_transactions)

WHERE day >= '2022-07-01' and day <= '2022-07-31' -- July month

GROUP BY day

ORDER BY day DESC