select

BLOCK_TIMESTAMP::DATE as date,

TX_SUCCEEDED,

count(distinct tx_id) as no_txn,

count(distinct TX_SENDER) as no_wallets,

sum(FEE) as paid_fee,

avg(FEE) as avg_fee,

sum(no_wallets) over (partition by TX_SUCCEEDED order by date) as cum_wallets,

sum(no_txn) over (partition by TX_SUCCEEDED order by date) as cum_txn

--round( (txs/all_tx)*100)

from terra.core.fact_transactions

where BLOCK_TIMESTAMP>='2022-12-25'

group by 1,2