flipside
Insights
Studio
Quests
For Chains
For Analysts
For Explorers
About
Log in
Sign up
flipside
Daily total number of unique programs since the beginning of January
kasadegh
Daily total number of unique programs since the beginning of January
Updated 2022-07-06
Copy Reference
Fork
9
1
2
3
4
5
6
›
⌄
select
BLOCK_TIMESTAMP
::
date
as
day
,
count
(
distinct
PROGRAM_ID
)
as
unique_programs_count
from
solana
.
core
.
fact_events
where
day
>=
'2022-06-01'
group
by
day
order
by
day
Results
Run a query to Download Data