flipside
Insights
Studio
Quests
For Chains
For Analysts
For Explorers
About
Log in
Sign up
flipside
2023-05-13 02:57 AM
drone-mostafa
2023-05-13 02:57 AM
Updated 2023-05-12
Copy Reference
Fork
9
1
2
3
›
⌄
SELECT
sum
(
case
when
AMOUNT_IN_USD
>
0
then
AMOUNT_IN_USD
else
AMOUNT_OUT_USD
end
)
as
Volume
,
date_trunc
(
'month'
,
BLOCK_TIMESTAMP
)
as
date
FROM
ethereum
.
core
.
ez_dex_swaps
WHERE
PLATFORM
LIKE
'%uniswap%'
GROUP
BY
2
Results
Run a query to Download Data