DEX | USERS | TRANSACTIONS | |
|---|---|---|---|
1 | uniswap | 209762 | 13169791 |
2 | velodrome | 151268 | 4907127 |
3 | beethoven-x | 81217 | 420679 |
4 | curve | 68079 | 369639 |
5 | sushiswap | 55494 | 232887 |
Flipside Community5B - op most popular dexes among super_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
34
›
⌄
-- forked from mar1na-catscatscode / 5B - op most popular dexes among acquired users @ https://flipsidecrypto.xyz/mar1na-catscatscode/q/qKb1SkQts9un/5b---op-most-popular-dexes-among-acquired-users
with super_users as (
select distinct from_address as user
from optimism.core.fact_transactions
where
-- block_timestamp::date >='2023-01-01' and
-- block_timestamp::date < '2024-01-01' and
nonce=99
)
select
case
when platform ilike '%velodrome%' then 'velodrome'
when platform ilike '%uniswap%' then 'uniswap'
when platform ilike '%hashflow%' then 'hashflow'
when platform ilike '%kyberswap%' then 'kyberswap'
when platform ilike '%dodo%' then 'dodo'
else platform
end as dex,
count(distinct origin_from_address) as users,
count(distinct tx_hash) as transactions
from optimism.defi.ez_dex_swaps
where origin_from_address in (select user from super_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
137B
58s