adriaparcerisasUnique Solana Programs 2.1
Updated 2022-07-05
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
›
⌄
-- 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
--case when trunc(block_timestamp,'day')='2022-01-01' then 'Starting 2022'
--else 'Currently' end as period,
--address_name as program,
label_type,
--count(distinct address_name) as n_programs,
count(distinct tx_id) as counts
from solana.core.fact_events x
join solana.core.dim_labels y on x.program_id=y.address
where trunc(block_timestamp,'day')='2022-01-01' --or trunc(block_timestamp,'day')=CURRENT_DATE-1
group by 1
--having counts >100000
order by 1 asc
Run a query to Download Data