select date_trunc(week,BLOCK_TIMESTAMP) as date ,

count (DISTINCT TX_ID ) as num_swaps ,

sum (num_swaps) over (order by date ) as cum_swaps ,

count (DISTINCT swapper) as num_swappers

from solana.core.fact_swaps

where SWAP_PROGRAM = 'raydium v4'

and SUCCEEDED = true

GROUP by 1