with table1 as (
select block_timestamp::date as date,
tx_hash,
buyer_address,
price_usd,
nft_address,
tokenid,
row_number() over (partition by tokenid order by date desc) rn
from optimism.core.ez_nft_sales
where nft_address = lower('0x2831Aa51DE4E3bB318Cf01eAcd8a7FdbB440ac3A')
and price_usd > 0),
table2 as (select * from table1 where rn = 1 order by date desc)
select buyer_address as Holder,
count (tokenid) as NFTS_Count
from table2
group by 1
order by 2 desc
limit 10