flipside
Products
For Protocols
For Analysts
For Explorers
About
Log in
Become a Partner
flipside
daily last 3 months
datavortex
daily last 3 months
Updated 2024-10-18
Copy Reference
Fork
99
1
2
3
4
5
6
7
8
9
10
11
12
13
›
⌄
SELECT
DATE_TRUNC
(
'day'
,
block_timestamp
)
AS
Day
,
SUM
(
amount_in_usd
)
AS
DailyVolumeUSD
FROM
polygon
.
defi
.
ez_dex_swaps
WHERE
block_timestamp
>=
DATEADD
(
MONTH
,
-
3
,
CURRENT_DATE
)
AND
platform
=
'quickswap-v3'
GROUP
BY
Day
ORDER
BY
Day
ASC
;
Results
QueryRunArchived: QueryRun has been archived