flipside
Insights
Studio
Quests
For Chains
For Analysts
For Explorers
About
Log in
Sign up
flipside
New Wallets Created
AndyCool
New Wallets Created
Updated 2022-05-12
Copy Reference
Fork
99
1
2
3
4
5
6
7
8
9
10
›
⌄
WITH
new_wallet
as
(
SELECT
sender
,
min
(
block_timestamp
)
AS
DATE
FROM
algorand
.
transactions
WHERE
block_timestamp
>=
'2022-04-30'
GROUP
BY
sender
)
SELECT
date_trunc
(
'day'
,
DATE
)
as
TIME
,
COUNT
(
sender
)
AS
new_wallet
FROM
new_wallet
GROUP
BY
TIME
Results
Run a query to Download Data