select
count(distinct holder) as users,
--BLOCK_TIMESTAMP as "Transfer Date",
count(distinct TOKENID) as NFTs
from(
select
TOKENID,
NFT_TO_ADDRESS as holder,
BLOCK_TIMESTAMP,
row_number() over (partition by TOKENID order by BLOCK_TIMESTAMP desc) as rank
from arbitrum.nft.ez_nft_transfers
where nft_address = lower('0xA4734bf76F511357d4353D88b84204957972Ac84')
)
where rank = 1
--group by 1
--order by 2 desc