flipside
Products
For Protocols
For Analysts
For Explorers
About
Log in
Become a Partner
flipside
polygon new addresses
boomer77
polygon new addresses
Updated 2022-05-29
Copy Reference
Fork
9
1
2
3
4
5
6
7
›
⌄
with
raw
as
(
select
*
,
ROW_NUMBER
(
)
OVER
(
PARTITION
BY
from_address
ORDER
BY
block_timestamp
ASC
)
as
rank
from
polygon
.
udm_events
)
select
*
from
raw
where
rank
=
1
limit
1000
Results
Run a query to Download Data