CryptoLionUni top 10 LPs
    Updated 2021-07-13
    WITH lp as (SELECT
    liquidity_provider,
    SUM(CASE WHEN is_active = 'TRUE' THEN liquidity_adjusted ELSE 0 END) as total_liquidity,
    pool_name
    FROM uniswapv3.positions
    WHERE pool_name LIKE 'USDC-WETH%'
    AND is_active = 'TRUE'
    GROUP BY 1,3
    ORDER BY 2 DESC
    LIMIT 10)