SELECT

BLOCK_TIMESTAMP,

LIQUIDITY_PROVIDER as user_wallet_address,

'ADD LP' as EVENT_NAME,

AMOUNT0_USD,

AMOUNT1_USD,

TOKEN0_SYMBOL,

TOKEN1_SYMBOL,

POOL_NAME,

RANK() OVER (partition by LIQUIDITY_PROVIDER order by BLOCK_TIMESTAMP asc)as rank

FROM ethereum.uniswapv3.ez_lp_actions)

date_trunc('month',block_timestamp) as month,

count(user_wallet_address) as "Number of new pool users"

FROM pool_users

WHERE rank=1 and BLOCK_TIMESTAMP>=current_date-365

GROUP BY month