freemartianAverage Sushi VS Uni
Updated 2022-06-25
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
›
⌄
with platforms as (
select count(distinct origin_from_address) as user_count, count(distinct tx_hash) as swap_count, sum(amount_in_usd) as volume, platform
from ethereum.core.ez_dex_swaps
where origin_from_address not in (
select distinct origin_from_address as MetaMask_Swappers
from ethereum.core.fact_event_logs
where origin_to_address = '0x881d40237659c251811cec9c364ef91dc08d300c')
group by platform)
select volume/swap_count as average, platform
from platforms
Run a query to Download Data