block_timestamp::date as date,

CASE

WHEN block_timestamp::date >= '2022-11-08' THEN 'Post Collapse' ELSE 'Pre Collapse'

END as period,

label_type,

count(distinct tx_id) as tx_cnt,

count(distinct instruction:accounts[0]) as uniq_users,

sum(tx_cnt) over (partition by label_type order by date) as cum_tx_cnt

from solana.core.fact_events inner join solana.core.dim_labels

on program_id = address

where block_timestamp::date >='2022-10-08'

and block_timestamp::date <= CURRENT_DATE - 1

group by 1 ,2, 3