flipside
Products
For Protocols
For Analysts
For Explorers
About
Log in
Become a Partner
flipside
Getting Started
tanny
Getting Started
Updated 2024-11-06
Copy Reference
Fork
99
1
2
3
4
5
6
7
8
9
10
11
12
›
⌄
SELECT
DATE_TRUNC
(
'month'
,
block_timestamp
)
AS
month
,
COUNT
(
DISTINCT
sender
)
AS
unique_users
FROM
ethereum
.
uniswapv3
.
ez_swaps
WHERE
block_timestamp
BETWEEN
'2024-07-01'
AND
'2024-09-30'
GROUP
BY
month
ORDER
BY
month
;
Results
QueryRunArchived: QueryRun has been archived