POOL_NAME | SYMBOL_OUT | |
|---|---|---|
1 | Balancer LBTC/cbBTC | cbBTC |
2 | cbBTC-LBTC 3000 60 UNI-V3 LP | cbBTC |
3 | cbBTC-0xeca...11c1 0 1 ASLP | cbBTC |
4 | cbBTC-LBTC | cbBTC |
datavortexpleased-black
Updated 2025-02-16
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
›
⌄
⌄
⌄
/*
SELECT
COUNT(DISTINCT tx_hash) AS "Total Trades",
SUM(amount_in_usd) AS "Total Trades Volume",
COUNT(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'
)
*/
SELECT DISTINCT pool_name, symbol_out FROM base.defi.ez_dex_swaps
where symbol_in = 'LBTC'
AND symbol_out IS NOT NULL
/*
SELECT
COUNT(DISTINCT tx_hash) AS "Total Trades",
SUM(amount_in_usd) AS "Total Trades Volume",
COUNT(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'
Last run: 3 months ago
4
137B
2s