date_trunc(day,BLOCK_TIMESTAMP) as days,

count(distinct PROGRAM_ID ) as number_of_programs ,

sum(number_of_programs) over (order by days) as cum_pr_usage

from solana.core.fact_events

where

BLOCK_TIMESTAMP >= '2022-01-01'

group by 1