date_trunc('day', block_timestamp) as date,

count(distinct tx_hash) as tx_count,

count(distinct from_address) as user_count,

sum(value) as volume,

sum(tx_fee) as tx_fees,

avg(tx_fee) as avg_fee,

count(distinct case when TX_SUCCEEDED = 'TRUE' then tx_hash end ) as succeed_txns,

(succeed_txns / tx_count ) * 100 as success_rate,

24 * 60 * 60 AS seconds_per_day,

count(DISTINCT tx_hash) / seconds_per_day as TPS,

sum(tx_fees) over (order by date) as cum_total_fee,

sum(tx_count) over (order by date) as cum_tx_count,

sum(volume) over (order by date) as cum_volume

from

monad.testnet.fact_transactions

group by

date

order by

date asc