flipside
Insights
Studio
Quests
For Chains
For Analysts
For Explorers
About
Log in
Sign up
flipside
new user count
Josh956
new user count
Updated 2023-02-20
Copy Reference
Fork
99
1
2
3
4
5
6
7
8
9
10
›
⌄
with
a
as
(
select
trader
,
min
(
date_trunc
(
'day'
,
block_timestamp
)
)
as
min_day
from
near
.
core
.
ez_dex_swaps
where
block_timestamp
>=
'2022-12-25'
group
by
1
)
select
count
(
*
)
as
amt
from
a
Results