flipside
FLIPSIDEAI
IDG PLAYBOOK
JOURNEYS
INSIGHTS
About
Log in
GET STARTED
flipside
No of unique programs since the beginning of January 2022
Mufasa
No of unique programs since the beginning of January 2022
Updated 2022-07-06
Copy Reference
Fork
9
1
2
3
4
5
6
›
⌄
SELECT
block_timestamp
::
date
as
date
,
COUNT
(
distinct
INSTRUCTIONS
[
0
]
:
programId
)
as
number_of_programs
FROM
solana
.
core
.
fact_transactions
WHERE
date
>=
'2022-01-01'
AND
succeeded
=
'TRUE'
GROUP
BY
date
ORDER
BY
number_of_programs
DESC
Results
Run a query to Download Data