flipside
Insights
Studio
Quests
For Chains
For Analysts
For Explorers
About
Log in
Sign up
flipside
number of unique programs used per day since the beginning of January
headitmanager
number of unique programs used per day since the beginning of January
Updated 2022-02-10
Copy Reference
Fork
9
1
2
3
4
5
6
7
8
›
⌄
select
date_trunc
(
'day'
,
block_timestamp
)
as
datetime
,
count
(
distinct
(
program_id
)
)
as
COUNT
from
solana
.
transactions
WHERE
block_timestamp
::
date
>=
'2022-01-01'
and
block_timestamp
::
date
<=
'2022-01-31'
group
by
datetime
order
by
datetime
asc
Results
Run a query to Download Data