count(distinct liquidity_provider) as monthly_lp,

date_trunc('month', block_timestamp) as date,

case when action = 'INCREASE_LIQUIDITY' then 'Increase liquidity/mint new position' else 'Decrease liquidity/close position' end as type

from ethereum.uniswapv3.ez_lp_actions

where block_timestamp::date >= '2022-06-01'

group by 2, 3