CryptoLionLiquidity Positions
    Updated 2023-03-27
    SELECT
    pool_address,
    pool_name,
    count(distinct liquidity_provider) as providers,
    count(distinct liquidity_provider, tick_lower, tick_upper, liquidity_adjusted) as position_changes
    FROM uniswapv3.lp_actions
    WHERE block_timestamp >= getdate() - interval '2 months'
    GROUP BY pool_address, pool_name
    HAVING providers > 100
    ORDER BY pool_name
    Run a query to Download Data