with tps as (

select

block_timestamp::date as date,

sum(n_txns_secs) as sum_tps,

avg(n_txns_secs) as avg_tps,

max(n_txns_secs) as max_tps,

sum(sum_tps) over (order by date asc rows between unbounded preceding and current row) as cumulative_sum_tps,

avg(avg_tps) over (order by date asc rows between unbounded preceding and current row) as overall_avg_tps,

max(max_tps) over (order by date asc rows between unbounded preceding and current row) as overall_max_tps

from(

select

block_timestamp,

count(distinct tx_hash) as n_txns_secs

from arbitrum.core.fact_transactions

group by block_timestamp

) group by date

select * from tps

order by date desc