with uni_lps as (SELECT
liquidity_provider,
date_trunc('day', block_timestamp) as date
FROM
ethereum.uniswapv3.ez_positions
WHERE
date >= CURRENT_DATE - 365 and is_active = TRUE
GROUP BY
1,2
)
SELECT
COUNT(DISTINCT liquidity_provider) as num_LPs
FROM
uni_lps