nickpUniswapv3.2nd
    Updated 2021-07-28
    --select * from uniswapv3.lp_actions limit 10;

    /*
    --increase or decrease each day
    select DATE(block_timestamp), count(action)
    from uniswapv3.lp_actions
    WHERE
    action = 'DECREASE_LIQUIDITY' --INCREASE_LIQUIDITY
    AND block_timestamp BETWEEN '2021-06-01 00:00:00' AND '2021-07-26 00:00:00'
    AND (POOL_NAME LIKE '%WETH%' OR TOKEN0_SYMBOL LIKE '%WETH%' OR TOKEN1_SYMBOL LIKE '%WETH%')
    group by DATE(block_timestamp)
    order by DATE(block_timestamp);
    */


    /*
    --increase or decrease by unique individual each day
    select DATE(block_timestamp), count(DISTINCT liquidity_provider)
    from uniswapv3.lp_actions
    WHERE
    action = 'INCREASE_LIQUIDITY' --INCREASE_LIQUIDITY
    AND block_timestamp BETWEEN '2021-06-01 00:00:00' AND '2021-07-26 00:00:00'
    AND (POOL_NAME LIKE '%WETH%' OR TOKEN0_SYMBOL LIKE '%WETH%' OR TOKEN1_SYMBOL LIKE '%WETH%')
    group by DATE(block_timestamp)
    order by DATE(block_timestamp);

    */


    /*
    select DISTINCT a.liquidity_provider, a.block_timestamp, b.block_timestamp
    from uniswapv3.lp_actions as a
    left join uniswapv3.lp_actions as b
    on a.liquidity_provider = b.liquidity_provider
    AND a.block_timestamp <> b.block_timestamp
    AND a.block_timestamp < b.block_timestamp
    Run a query to Download Data