select
mint_date,
count(distinct nft_to_address) as new_lp_address
from
(
select
to_date(block_timestamp) as mint_date,
nft_to_address,
rank() over (
partition by nft_to_address
order by
block_timestamp
) as mint_cnt
from
ethereum.nft.ez_nft_transfers
where
nft_address = LOWER('0xC36442b4a4522E871399CD717aBDD847Ab11FE88')
and event_type = 'mint'
)
where
mint_cnt = 1
group by
1