Cryptopunk Sales and Traders

    Which 10 wallets are the most successful Cryptopunk traders? Successful could either mean the wallet has accumulated a large balance from sales or has accumulated a large number of Punks. Explain your methodology and findings.

    Intro:

    The Cryptopunk project was launched for the first time in June 2017 and was developed by a two-person team including Matt Hall and John Watkinson in the American game studio Larva Labs. CryptoPunk tokens are algorithmically generated 24 x 24 pixel images. Cryptopunk was released before CryptoKitties, and these two projects were the first in the NFT space and are one of the inspirations for the ERC-721 token standard on the Ethereum network.

    In the Cryptopunk project, 10,000 unique tokens were created on the platform of the Ethereum network. Most of these punks are human images, but there are also 88 zombies, 24 monkeys, and 9 aliens that are designated as special punks.

    Method:

    • Used table-→ ethereum.core.ez_nft_sales
    • ETH price-→ ethereum.core.fact_hourly_token_prices where SYMBOL='WETH'
    • Cryptopunk NFTs-→ project_name = 'cryptopunks'
    • Junk TX according to DISCORD channel-→ 0x92488a00dfa0746c300c66a716e6cc11ba9c0f9d40d8c58e792cc7fcebf432d0
    • Estimation of TOP trader-→ difference of USD value of sold NFTs and bought NFTs for each users
      • USD_value_sell-USD_value_buy as profit
    • Identification of TOP buyers and sellers for Cryptopunk NFTs
    • Analyze in the weekly basis for sale activity
    Loading...
    Loading...
    Loading...
    Loading...

    Outcomes:

    1. The weekly analysis indicates the highest number of sale happened on the week connected August 23 to 30, 2021 with 361 unique NFTs sale.
    2. The highest number of sellers and buyers followed the date stated in the previous comment.
    3. On that date, 316 unique NFTs are sold and the volume of sale is more than 27k ETH and near 87 million $.
    4. The pattern of sale volume indicates the jumps on special date like last week of February 2021 and the last 10 days of January 2022.
    5. The bear market on crypto market is affected the sale volume of Cryptopunk NFTs over time and it can be seen on both number and volume of sales.
    Loading...
    Loading...
    Loading...
    Loading...
    Loading...

    Outcomes:

    After investigation on Sale of Cryptopunk in this part the Trade behavior of this NFTs is investigated.

    1. The biggest sales are arranged in the first table and based on it, the Token ID no 2964 is the most expensive Cryptopunk NFT with 374 ETH as price which was equal to over 1.463 million $.
    2. The graphic of top 3 most expensive NFTs based on the sale records are assigned in the below of table.
    3. The top buyers and sellers of Cryptopunk NFTs are listed in the two represented tables.
    4. Finally the most successful traders are selected according to the definition in the Method part. As shown in the bar chart, the most successful trader has over 50 million $ profit over selling Cryptopunk NFTs over time.
    Loading...
    db_img
    db_img
    db_img
    db_img

    Cryptopunk Token Id 2964

    Cryptopunk Token Id 9952

    Cryptopunk Token Id 6552