flipside
Insights
Studio
Quests
For Chains
For Analysts
For Explorers
About
Log in
Sign up
flipside
poly_new_addresses
maybeyonas
poly_new_addresses
Updated 2022-05-28
Copy Reference
Fork
99
1
2
3
4
5
6
7
8
9
10
11
12
›
⌄
select
date
(
first_tx
)
as
first_date
,
count
(
distinct
from_address
)
as
users
from
(
select
from_address
,
min
(
block_timestamp
)
as
first_tx
from
polygon
.
transactions
group
by
1
)
where
first_tx
>=
current_date
-
interval
{
{
HISTORY
}
}
group
by
1
Results
Run a query to Download Data