flipside
Products
For Protocols
For Analysts
For Explorers
About
Log in
Become a Partner
flipside
Untitled Query
boomer77
Untitled Query
Updated 2021-08-04
Copy Reference
Fork
9
1
2
3
4
5
6
7
8
›
⌄
SELECT
date_trunc
(
'month'
,
block_timestamp
)
as
month
,
avg
(
amount_usd
)
,
direction
,
platform
from
ethereum
.
dex_swaps
where
amount_usd
is
not
null
and
platform
in
(
'uniswap-v2'
,
'uniswap-v3'
)
and
direction
=
'IN'
group
by
1
,
3
,
4
Results
Run a query to Download Data