flipside
Products
For Protocols
For Analysts
For Explorers
About
Log in
Become a Partner
flipside
misouser3.6
sarath
misouser3.6
Updated 2022-09-20
Copy Reference
Fork
9
1
2
3
4
5
6
›
⌄
SELECT
DISTINCT
COUNT
(
SENDER
)
AS
number_user_ava
,
date_trunc
(
'day'
,
BLOCK_TIMESTAMP
)
AS
date
FROM
avalanche
.
sushi
.
ez_swaps
WHERE
BLOCK_TIMESTAMP
>=
CURRENT_DATE
-
7
group
BY
2
ORDER
BY
2
ASC
Results
Run a query to Download Data