jgvfUnique Solana Programs daily copy
Updated 2023-07-10
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
›
⌄
-- forked from h4wk / Unique Solana Programs daily @ https://flipsidecrypto.xyz/h4wk/q/2xJ41eZ5F7Jp/unique-solana-programs-daily
-- 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 DATE_TRUNC('day', block_timestamp) as date,
count(distinct t.signers[0]) as address,
l.label, count(l.label) as interact
from solana.core.fact_transactions t join solana.core.dim_labels l on t.instructions[0]:programId = l.address
and t.block_timestamp:: date >= '2022-01-01' and t.block_timestamp::date <= dateadd(day, -1, current_date)
and l.label_subtype != 'token_contract'
and l.label != 'solana'
and t.succeeded = TRUE
group by date, l.label
Run a query to Download Data