flipside
Insights
Studio
Quests
For Chains
For Analysts
For Explorers
About
Log in
Sign up
flipside
6op33
ElDiablo-b9lZ1n
6op33
Updated 2023-03-26
Copy Reference
Fork
9
1
2
3
›
⌄
select
count
(
distinct
ORIGIN_FROM_ADDRESS
)
,
sum
(
AMOUNT_IN_USD
)
,
date_trunc
(
'month'
,
block_timestamp
)
,
PLATFORM
from
optimism
.
core
.
ez_dex_swaps
where
PLATFORM
in
(
'velodrome'
,
'uniswap-v3'
)
and
symbol_in
=
'USDT'
group
by
3
,
4
Results