flipside
Insights
Studio
Quests
For Chains
For Analysts
For Explorers
About
Log in
Sign up
flipside
Uniswap V2 vs. V3
jackguy
Uniswap V2 vs. V3
Updated 2022-03-11
Copy Reference
Fork
99
1
2
3
4
5
6
7
8
9
10
›
⌄
SELECT
date_trunc
(
'day'
,
block_timestamp
)
,
platform
,
count
(
DISTINCT
from_address
)
as
users
,
sum
(
amount_usd
)
as
volume
,
avg
(
amount_usd
)
as
avg_swap_size
FROM
ethereum
.
dex_swaps
WHERE
platform
like
'%uni%'
AND
amount_usd
<
1000000000
GROUP
BY
1
,
2
Results
Run a query to Download Data