DEX | USERS | TRANSACTIONS | |
|---|---|---|---|
1 | uniswap | 333745 | 1450410 |
2 | baseswap | 202552 | 1764673 |
3 | maverick | 170815 | 509392 |
4 | sushiswap | 116028 | 576109 |
5 | aerodrome | 84595 | 574378 |
Flipside Community5B - base most popular dexes among acquired_users
Updated 2025-02-04
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
›
⌄
with acquired_users as (
select distinct from_address as user
from base.core.fact_transactions
where block_timestamp::date >='2023-01-01'
and block_timestamp::date < '2024-01-01'
and nonce=1
)
select
-- platform,
case
when platform ilike '%uniswap%' then 'uniswap'
else platform
end as dex,
count(distinct origin_from_address) as users,
count(distinct tx_hash) as transactions
from base.defi.ez_dex_swaps
where origin_from_address in (select user from acquired_users)
and block_timestamp::date >='2023-01-01'
and block_timestamp::date < '2024-01-01'
group by 1
order by 2 desc, 3 desc
limit 5
Last run: 3 months ago
5
138B
14s