SELECT
date_trunc('day', block_timestamp) as date,
CASE
WHEN ACTION = 'INCREASE_LIQUIDITY' THEN 'INCREASE'
WHEN ACTION = 'DECREASE_LIQUIDITY' AND LIQUIDITY <= 10000 THEN 'COLLECT FEE'
ELSE 'DECREASE'
END AS action_type,
count(*) AS evt_cnt
FROM ethereum.uniswapv3.ez_lp_actions
WHERE date <= '2022-11-01'
AND NF_POSITION_MANAGER_ADDRESS = '0xc36442b4a4522e871399cd717abdd847ab11fe88'
GROUP BY date, action_type
ORDER BY date ASC