DATE,

NAME,

CASE

WHEN DATE < '2022-11-08' THEN 'BEFORE_COLLAPSE'

ELSE 'AFTER_COLLAPSE'

END AS PERIOD,

TX_COUNT,

USERS_NUMBER,

SUM(TX_COUNT) over (order by date) as Cumuletiver_tx,

SUM(USERS_NUMBER) over (order by date) as Cumuletiver_USERS

FROM

BLOCK_TIMESTAMP:: DATE AS DATE,

'Serum' AS NAME,

COUNT(DISTINCT TX_ID) AS TX_COUNT,

COUNT( DISTINCT INSTRUCTION:accounts[1]) AS USERS_NUMBER

FROM solana.core.fact_events

WHERE DATE between '2022-10-01' and '2022-11-21'

AND PROGRAM_ID IN ('BJ3jrUzddfuSrZHXSCxMUUQsjKEyLmuuyZebkcaFp2fg', '9xQeWvG816bUx9EPjHmaT23yvVM2ZWbrrpZb9PusVFin'

, '4ckmDgGdxQoPDLUkDT3vHgSAkzA3QRdNq5ywwY4sUSJn' , 'EUqojwWA2rd19FZrzeBncJsm38Jm1hEhE3zsmX3bRc2o')

AND SUCCEEDED = 'TRUE'

GROUP BY 1

GROUP BY 1 , 2 , 3 , 4 , 5