piperSolana - Unique Solana Programs: Programs by Number of Transactions
Updated 2022-07-03
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?
*/
SELECT
a.block_timestamp::date AS date,
COUNT(a.tx_id) AS number_of_transactions,
b.address_name AS program_name,
b.label_type AS type
FROM
solana.core.fact_events a
JOIN
solana.core.dim_labels b
ON
a.program_id = b.address
WHERE
a.block_timestamp >= '2022-01-01'
AND
a.block_timestamp <= '2022-07-03'
AND
a.succeeded = 'TRUE'
AND
b.label_type IN ('dex', 'nft')
GROUP BY date, program_name, type
ORDER BY date ASC
Run a query to Download Data