mmdrezaTop 10 Holders with Most number of Held NFTs
    Updated 2023-04-27
    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
    Run a query to Download Data