POOL_NAME | TOTAL_TRADES | TOTAL_TRADES_VOLUME | TOTAL_TRADERS | |
|---|---|---|---|---|
1 | WBTC-LBTC 500 10 UNI-V3 LP | 46020 | 502773261.43 | 33275 |
2 | cbBTC-0xeca...11c1 0 1 ASLP | 133387 | 116999457.83 | 17630 |
3 | LBTC-cbBTC 500 10 UNI-V3 LP | 1537 | 106188865.83 | 816 |
4 | eBTC-LBTC 500 10 UNI-V3 LP | 688 | 29617594.7 | 519 |
5 | WBTC-LBTC 100 1 UNI-V3 LP | 3908 | 13483311.95 | 3016 |
6 | BTCB-LBTC 500 10 PCS-V3 LP | 3315 | 7920625.14 | 2703 |
7 | cbBTC-LBTC | 1721 | 849377.17 | 1148 |
8 | 0xad3...15ff-WBNB | 93 | 69427.69 | 29 |
9 | LBTC-WBNB | 17646 | 66348.54 | 2633 |
10 | USD0-LBTC 3000 60 UNI-V3 LP | 190 | 24238.72 | 125 |
11 | WBNB-LBTC | 1225 | 13339.35 | 459 |
12 | LBTC-WETH | 175 | 7982.3 | 93 |
13 | cbBTC-LBTC 3000 60 UNI-V3 LP | 7 | 762.68 | 6 |
14 | WBNB-LBTC 10000 200 PCS-V3 LP | 69 | 68.45 | 4 |
15 | Balancer LBTC/cbBTC | 48 | 46.65 | 44 |
datavortexby pool name
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,
COUNT(DISTINCT tx_hash) AS total_trades,
SUM(amount_in_usd) AS total_trades_volume,
Last run: 2 months ago
15
663B
8s