POOL_ADDRESS | TOKEN0_SYMBOL | TOKEN1_SYMBOL | TOKEN_0_BALANCE_USD | TOKEN_1_BALANCE_USD | POOL_NAME | TVL | |
|---|---|---|---|---|---|---|---|
1 | 0xcbcdf9626bc03e24f779434178a73a0b4bad62ed | WBTC | WETH | 57682814.8750119 | 179129516.664938 | WBTC-WETH 3000 60 | 236812331.53995 |
2 | 0x88e6a0c2ddd26feeb64f039a2c41296fcb3f5640 | USDC | WETH | 102985739.979533 | 43887979.4194648 | USDC-WETH 500 10 | 146873719.398997 |
3 | 0x4585fe77225b41b697c938b018e2ac67ac5a20c0 | WBTC | WETH | 23686635.4413214 | 51737206.3965091 | WBTC-WETH 500 10 | 75423841.8378305 |
4 | 0x8ad599c3a0ff1de082011efddc58f1908eb6e6d8 | USDC | WETH | 36971321.8839865 | 27913885.4909198 | USDC-WETH 3000 60 | 64885207.3749063 |
5 | 0x4e68ccd3e89f51c3074ca5072bbac773960dfa36 | WETH | USDT | 23092562.4701051 | 33487106.8544086 | WETH-USDT 3000 60 | 56579669.3245137 |
6 | 0x109830a1aaad605bbf02a9dfa7b0b92ec2fb7daa | wstETH | WETH | 21679490.4628044 | 15348804.1939111 | wstETH-WETH 100 1 | 37028294.6567154 |
7 | 0xc5c134a1f112efa96003f8559dba6fac0ba77692 | WHITE | WETH | 10661409.0640766 | 21409052.6385229 | WHITE-WETH 100 1 | 32070461.7025995 |
8 | 0xa6cc3c2531fdaa6ae1a3ca84c2855806728693e8 | LINK | WETH | 7927549.03869633 | 23950035.2793769 | LINK-WETH 3000 60 | 31877584.3180732 |
9 | 0x11b815efb8f581194ae79006d24e0d814b7697f6 | WETH | USDT | 15620318.0426288 | 16214929.5001334 | WETH-USDT 500 10 | 31835247.5427622 |
10 | 0xe8c6c9227491c0a8156a0106a0204d881bb7e531 | WETH | 19640767.841426 | 9472109.68801718 | -WETH 3000 60 | 29112877.5294432 |
KeyrockMost Liquid Uniswap V3 Pools
Updated 2024-01-26
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
›
⌄
-- forked from andreafiandro / Latest TVL @ https://flipsidecrypto.xyz/andreafiandro/q/vg6bGclZMOzB/latest-tvl
-- Last 3 days average TVL for each Uniswap V3 pool
SELECT
pool_address,
token0_symbol,
token1_symbol,
token_0_balance_usd,
token_1_balance_usd,
pool_name,
(
COALESCE(token_0_balance_usd, 0) + COALESCE(token_1_balance_usd, 0)
) as "TVL"
FROM
(
SELECT
pool_address,
token0_symbol,
token1_symbol,
pool_name,
AVG(token0_balance_usd) as token_0_balance_usd,
AVG(token1_balance_usd) as token_1_balance_usd
FROM
ethereum.uniswapv3.ez_pool_stats
WHERE
block_timestamp > CURRENT_DATE -3
AND (
(
token0_symbol = '{{token_symbol}}'
OR token1_symbol = '{{token_symbol}}'
)
OR '{{token_symbol}}' = '' -- check if token_symbol is empty
)
GROUP BY
pool_address,
token0_symbol,
token1_symbol,
Last run: over 1 year ago
10
1KB
2s