cnallenzhaoAll particiapted LPs copy
    -- forked from All particiapted LPs @ https://flipsidecrypto.xyz/edit/queries/284ab1ba-c781-4326-8442-30db9bb98f3e

    -- SELECT COUNT(DISTINCT(LIQUIDITY_PROVIDER)) FROM
    -- ethereum.uniswapv3.ez_lp_actions
    -- WHERE BLOCK_TIMESTAMP <= '2023-01-01'
    WITH SAMPLE_DATA AS(
    SELECT COUNT(DISTINCT(LIQUIDITY_PROVIDER)) As sample_lp_cnts FROM
    ethereum.uniswapv3.ez_lp_actions
    WHERE BLOCK_TIMESTAMP <= '2023-01-01' AND POOL_ADDRESS IN (
    '0x11b815efb8f581194ae79006d24e0d814b7697f6',
    '0x4e68ccd3e89f51c3074ca5072bbac773960dfa36',
    '0x69d91b94f0aaf8e8a2586909fa77a5c2c89818d5',
    '0x84383fb05f610222430f69727aa638f8fdbf5cc1',
    '0x88e6a0c2ddd26feeb64f039a2c41296fcb3f5640',
    '0x8ad599c3a0ff1de082011efddc58f1908eb6e6d8',
    '0x99ac8ca7087fa4a2a1fb6357269965a2014abc35',
    '0xc2e9f25be6257c210d7adf0d4cd6e3e881ba25f8'
    )
    ),
    FULL_DATA AS(
    SELECT COUNT(DISTINCT(LIQUIDITY_PROVIDER)) AS full_lp_cnts FROM
    ethereum.uniswapv3.ez_lp_actions
    WHERE BLOCK_TIMESTAMP <= '2023-01-01'
    )
    SELECT s.yr, s.month, s.sample_lp_cnts, f.full_lp_cnts FROM SAMPLE_DATA s
    LEFT JOIN FULL_DATA f
    ON s.yr = f.yr AND s.month=f.month
    ORDER BY 1,2


    Run a query to Download Data