mondovuniswap-v3 pools
Updated 2023-04-29
99
1
2
3
4
5
6
7
8
9
10
11
12
13
›
⌄
SELECT pool_name, pool_address, (token0_balance_usd + token1_balance_usd) as balance
FROM (
SELECT *, ROW_NUMBER() OVER (PARTITION BY pool_address ORDER BY block_timestamp DESC) as rn
FROM ethereum.uniswapv3.ez_pool_stats
WHERE pool_address IN (
SELECT DISTINCT pool_address
FROM ethereum.core.dim_dex_liquidity_pools
WHERE platform = 'uniswap-v3'
)
) subquery
WHERE balance > 0 and rn = 1 and pool_address != '0x39d625a589d8796d629b353239239ab1970f01cc'
ORDER BY balance desc;
Run a query to Download Data