piperSolana - Unique Solana Programs: Top 5 popular Programs
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
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 != 'chadmin'
GROUP BY program_name, type
ORDER BY number_of_transactions DESC
LIMIT 5
Run a query to Download Data