TRADER | TOTAL_TRADED_VOLUME | |
|---|---|---|
1 | 0xfa8a...3452 | 39149586.84 |
2 | 0x4339...caeb | 37547763.83 |
3 | 0xc789...1041 | 36574388.07 |
4 | 0xf29d...08d5 | 23025209.39 |
5 | 0xe418...ead3 | 21571331.79 |
6 | 0x0083...2e87 | 20093394.59 |
7 | 0xe4cd...8b40 | 15994529.22 |
8 | 0x9548...94c7 | 14036560.62 |
9 | 0x0080...60fc | 10057891.4 |
10 | 0x62a9...3d42 | 7774266.61 |
datavortexTop traders
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 pool_name,
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 pool_name
UNION ALL
SELECT pool_name,
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 pool_name
UNION ALL
SELECT pool_name,
Last run: 2 months ago
10
299B
2s