select date_trunc(week,block_timestamp)::date as date, count(tx_id) as num_transactions , sum (num_transactions) over (order by date) as cum_transactions ,
count(DISTINCT signers[0]) as num_wallets,
(count(tx_id)/(24*60*60*7)) as TPS
from solana.core.fact_transactions where block_timestamp::date>=CURRENT_DATE - 180 and SUCCEEDED=true group by 1