select
--*
date_trunc('month', block_timestamp::date) as date,
count(distinct signers) as new_reg,
sum(new_reg) over (order by date) as cum_reg
FROM solana.core.fact_events
WHERE program_id = 'FACTNmq2FhA2QNTnGM2aWJH3i7zT3cND5CgvjYTjyVYe'
AND succeeded = 'true'
and block_timestamp > '2022-07-01' AND block_timestamp < '2023-09-01'
--limit 100
group by 1
order by date desc