flipside
Products
For Protocols
For Analysts
For Explorers
About
Log in
Become a Partner
flipside
base_nft_new_users-date-month
Saleh
base_nft_new_users-date-month
Updated 2024-03-13
Copy Reference
Fork
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
›
⌄
with
lst_min
as
(
select
buyer_address
,
min
(
block_timestamp
)
::
date
as
min_date
from
base
.
nft
.
ez_nft_sales
group
by
1
)
select
count
(
buyer_address
)
as
"New users"
,
"New users"
/
30
as
"Avg New users"
from
lst_min
where
min_date
>=
current_date
-
30
Results
QueryRunArchived: QueryRun has been archived