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