flipside
Insights
Studio
Quests
For Chains
For Analysts
For Explorers
About
Log in
Sign up
flipside
January 2021 - kim
freemartian
January 2021 - kim
Updated 2022-03-03
Copy Reference
Fork
9
1
2
3
4
5
›
⌄
SELECT
count
(
distinct
address
)
,
date_trunc
(
'day'
,
block_timestamp
)
as
DATE
FROM
algorand
.
transaction_participation
WHERE
DATE
>=
'2021-01-01'
AND
DATE
<=
'2021-02-01'
GROUP
BY
DATE
ORDER
BY
DATE
ASC
Results
Run a query to Download Data