piperSolana - Unique Solana Programs: Daily Transaction
Updated 2022-07-04
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
›
⌄
⌄
/*
Twitter: @der_piper
Discrod: piper#6707
Solana - Unique Solana Programs
Q92. One way to track developer growth in an ecosystem is through the number
of unique contracts used. Create a visualization of the number of unique programs
used per day since the beginning of January.
What type of programs are the most popular, and what programs seem to be gaining
in popularity over that timeframe? Does it appear that development is still ongoing
in the bear market?
*/
WITH part1 AS (
SELECT
block_timestamp::date AS date,
COUNT(tx_id) AS number_of_transactions
FROM
solana.core.fact_events
WHERE
block_timestamp BETWEEN '2022-01-01' AND '2022-04-30'
AND
succeeded = 'TRUE'
GROUP BY date),
part2 AS (
SELECT
block_timestamp::date AS date,
COUNT(tx_id) AS number_of_transactions
FROM
solana.core.fact_events
WHERE
block_timestamp BETWEEN '2022-04-29' AND '2022-05-01'
AND
Run a query to Download Data