ramojopb1
Updated 2022-12-30
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
›
⌄
SELECT
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
(SELECT
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
Run a query to Download Data