flipside
Products
For Protocols
For Analysts
For Explorers
About
Log in
Become a Partner
flipside
Untitled Query
freemartian
Untitled Query
Updated 2022-03-03
Copy Reference
Fork
9
1
2
3
4
5
6
›
⌄
SELECT
date_trunc
(
'day'
,
block_timestamp
::
date
)
as
time_period
,
COUNT
(
DISTINCT
address
)
FROM
algorand
.
transaction_participation
WHERE
time_period
BETWEEN
'2021-12-01'
AND
'2021-12-31'
GROUP
BY
time_period
ORDER
BY
time_period
Results
Run a query to Download Data