DATE,

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,

'Open Book' 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 = 'srmqPvymJeFKQ4zGQed1GFppgkRHL9kaELCbyksJtPX'

AND SUCCEEDED = 'TRUE'

GROUP BY 1

GROUP BY 1 , 2 , 3