flipside
Insights
Studio
Quests
For Chains
For Analysts
For Explorers
About
Log in
Sign up
flipside
the new wallets were created in May
mohammadh
the new wallets were created in May
Updated 2022-06-14
Copy Reference
Fork
9
1
2
3
4
›
⌄
select
count
(
distinct
(
ADDRESS
)
)
as
count_address
,
date_trunc
(
'day'
,
block_timestamp
)
as
block_day
from
flipside_prod_db
.
algorand
.
account
join
flipside_prod_db
.
algorand
.
block
on
CREATED_AT
=
BLOCK_ID
where
block_day
>=
'2022-05-01'
group
by
block_day
Results
Run a query to Download Data