flipside
Insights
Studio
Quests
For Chains
For Analysts
For Explorers
About
Log in
Sign up
flipside
Active addresses in Jan 2022
princefarzam
Active addresses in Jan 2022
Updated 2022-03-03
Copy Reference
Fork
99
1
2
3
4
5
6
7
8
9
10
›
⌄
SELECT
DATE_TRUNC
(
'DAY'
,
BLOCK_TIMESTAMP
)
AS
DAY
,
COUNT
(
DISTINCT
ADDRESS
)
AS
ACTIVE_WALLETS
FROM
algorand
.
transaction_participation
WHERE
BLOCK_TIMESTAMP
::
DATE
>=
'2022-01-01'
AND
BLOCK_TIMESTAMP
::
DATE
<
'2022-02-01'
GROUP
BY
DAY
ORDER
BY
DAY
ASC
Results
Run a query to Download Data