PLATFORM | TOTAL_TRADES | TOTAL_TRADES_VOLUME | TOTAL_TRADERS | |
|---|---|---|---|---|
1 | uniswap-v3 | 51389 | 652088035.31 | 35407 |
2 | aerodrome-slipstream | 133387 | 116999457.83 | 17630 |
3 | pancakeswap-v3 | 3384 | 7920693.59 | 2707 |
4 | maverick | 1713 | 849377.03 | 1141 |
5 | pancakeswap-v2 | 85409 | 149115.58 | 13526 |
6 | uniswap-v2 | 173 | 7972.28 | 91 |
7 | balancer | 48 | 46.65 | 44 |
8 | woofi | 2 | 10.02 | 2 |
9 | aerodrome | 8 | 0.14 | 7 |
datavortexby platform
Updated 2025-03-02
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
35
36
›
⌄
WITH all_trades AS (
SELECT platform,
COUNT(DISTINCT tx_hash) AS total_trades,
SUM(amount_in_usd) AS total_trades_volume,
COUNT(DISTINCT origin_from_address) AS total_traders
FROM ethereum.defi.ez_dex_swaps
WHERE pool_name IN (
'USD0-LBTC 3000 60 UNI-V3 LP',
'WBTC-LBTC 100 1 UNI-V3 LP',
'eBTC-LBTC 500 10 UNI-V3 LP',
'LBTC-WETH',
'LBTC-cbBTC 500 10 UNI-V3 LP',
'WBTC-LBTC 500 10 UNI-V3 LP'
)
GROUP BY platform
UNION ALL
SELECT platform,
COUNT(DISTINCT tx_hash) AS total_trades,
SUM(amount_in_usd) AS total_trades_volume,
COUNT(DISTINCT origin_from_address) AS total_traders
FROM base.defi.ez_dex_swaps
WHERE pool_name IN (
'cbBTC-LBTC 3000 60 UNI-V3 LP',
'cbBTC-0xeca...11c1 0 1 ASLP',
'Balancer LBTC/cbBTC',
'cbBTC-LBTC'
)
GROUP BY platform
UNION ALL
SELECT platform,
COUNT(DISTINCT tx_hash) AS total_trades,
SUM(amount_in_usd) AS total_trades_volume,
Last run: 2 months ago
9
304B
17s