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