POOL | TOTAL_DEPOSITS | TOTAL_WITHDRAWALS | POOL_TVL | |
|---|---|---|---|---|
1 | Uniswap LBTC/WBTC | 7123.76259403 | 6729.30932259 | 33890636.1755819 |
2 | Aerodrome LBTC/cbBTC | 1733.47497528 | 1437.26321926 | 25449921.6537263 |
3 | Curve eBTC/LBTC/WBTC | 1958.55418562 | 1885.30192763 | 6293687.50198485 |
4 | Curve LBTC/WBTC | 1266.89576641 | 1250.1151515 | 1441756.87183743 |
5 | Uniswap cbBTC/LBTC | 1354.85933081 | 1352.86032733 | 171750.380994625 |
datavortexPOOL TVL
Updated 2025-03-02
999
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 btc_price AS (
SELECT
symbol,
price,
DATE_TRUNC('hour', hour) AS hour_timestamp
FROM
ethereum.price.ez_prices_hourly
WHERE
symbol = 'WBTC'
order by
hour DESC
LIMIT
1
), deposit_eth AS (
SELECT
to_address AS pool_address,
CASE
WHEN to_address = LOWER('0x87428a53e14d24Ab19c6Ca4939B4df93B8996cA9') THEN 'Uniswap LBTC/WBTC'
WHEN to_address = LOWER('0xD4F56e41E77e2594E89473C7ec03f3F8f6Ed315B') THEN 'Uniswap cbBTC/LBTC'
WHEN to_address = LOWER('0x2f3bc4c27a4437aeca13de0e37cdf1028f3706f0') THEN 'Curve LBTC/WBTC'
WHEN to_address = LOWER('0xabaf76590478f2fe0b396996f55f0b61101e9502') THEN 'Curve eBTC/LBTC/WBTC'
END AS pool,
SUM(amount) AS total_deposits
FROM
ethereum.core.ez_token_transfers
WHERE
contract_address IN (
LOWER('0x8236a87084f8B84306f72007F36F2618A5634494'),
LOWER('0x2260FAC5E5542a773Aa44fBCfeDf7C193bc2C599'),
LOWER('0x657e8C867D8B37dCC18fA4Caead9C45EB088C642'),
LOWER('0xcbB7C0000aB88B473b1f5aFd9ef808440eed33Bf')
)
AND to_address IN (
LOWER('0x87428a53e14d24Ab19c6Ca4939B4df93B8996cA9'),
LOWER('0x2f3bc4c27a4437aeca13de0e37cdf1028f3706f0'),
LOWER('0xabaf76590478f2fe0b396996f55f0b61101e9502'),
Last run: 2 months ago
5
340B
14s