Holders

Method

• First, I obtained the average daily price of Ethereum from the ethereum.core.fact_hourly_token_prices table. I joined ethereum.core.ez_nft_sales and ethereum.core.dim_labels tables based on nft_address = address and filtered with where nft_address = '0xb47e3cd837ddf8e4c57f05d70ab865de6e193bbb' and event_type = 'sale' and I got the total daily sales volume and the total number of daily transactions.

Holders (The wallets that have the largest number of Cryptopunk NFT tokens)

• To find Cryptopunk holders ,I first use the 'ethereum.core.ez_nft_transfers table and filter

  nft_address = '0xb47e3cd837ddf8e4c57f05d70ab865de6e193bbb' and PROJECT_NAME='cryptopunks I got the latest transactions of Cryptopunk tokens Filter holders with nft_to_address!='0x0000000000000000000000000000000000000000' I separated from ethereum.core.ez_nft_transfers table. And then by joining the above two results based on ID tokens,

  I got the top 10 wallets that have the most tokens.

Successful CryptoPunks traders

• Wallets who have made the most profit from buying and selling punks:
  • The largest positive difference between the total USD amount of CryptoPunks bought by each wallet and the total USD amount of CryptoPunks sold by the same wallet.
• Wallets who have made the most profit from selling a punk:
  • The most positive difference between a cryptopunk token bought by each wallet and the same token sold by the same wallet.

Successful CryptoPunks traders

Top 10 wallets that have made the most profitable NFT token trades

• Wallet ==0xf476cd75be8fdd197ae0b466a2ec2ae44da41897== has made the most profit from buying and selling Cryptopunk token with ID ==1456==, which is about ==9M dollars==.

  The most profitable cryptopunk NFT tokens in order:

  • #1456 => about 9M dollars
  • #8888 => 2.8M dollars
  • #7252 => 2.8M dollars
  • #2140 => about 2.5M dollars
  • #3831 => about 2M dollars
  • #4992 => about 1.6M dollars
  • #9052 => about 1.5M dollars
  • #9373 => about 1.2M dollars
  • #4613 => about 1.1M dollars
  • #3783 => about 1M dollars

• The total sales volume of Cryptopunk from the beginning of 2022 is about 427M dollars.
• The total number of Cryptopunk transactions since the beginning of 2022 is about 2800 transactions.
• The cumulative graph of the number of transactions is still rising, but in August, the number of transactions and the volume of sales have decreased.

Conclusion

• The total sales volume of Cryptopunk from the beginning of 2022 is about 427M dollars.
• The total number of Cryptopunk transactions since the beginning of 2022 is about 2800 transactions.
• The cumulative graph of the number of transactions is still rising, but in August, the number of transactions and the volume of sales have decreased.
• Wallet 0xb88f has the largest number of Cryptopunk NFT tokens with 218 tokens.
• The most profitable Volt of Cryptopunk NFT trade tokens belongs to address 0x6639c089adfba8bb9968da643c6be208a70d6daa with about 50M dollars and 21.4% and 191 transactions.
• Among these top 10 wallets, the largest number of trades belongs to address 0x577ebc5de943e35cdf9ecb5bbe1f7d7cb6c7c647 with 320 transactions, which has earned about 20.7 million dollars.
• Wallet 0xf476cd75be8fdd197ae0b466a2ec2ae44da41897 has made the most profit from buying and selling Cryptopunk token with ID 1456, which is about 9M dollars.

Introduction

What is a Cryptopunk?

A CryptoPunk is a 24x24 pixel, 8-bit-style unique avatar that comes in the form of an NFT. Their creation began as an experiment, conducted by software developers Matt Hall and John Watkinson in 2017. The pair wanted to create a software program capable of generating thousands of unique avatars. The program produced a total of 10,000 avatars.

What Will You Read?

In this analysis you will read:

• Total daily sales volume and transactions of Cryptopunk since 2022-01-01
• Top 10 holders(highest number of punks) of Cryptopunk
• Top 10 profitable Cryptopunk wallets
• Top 10 wallets that have made the most profit from cryptopunk NFT trading tokens
• Top 10 wallets based on the most profitable NFT Cryptopunk trades

Total daily sales volume and transactions of Cryptopunk since 2022-01-01

• The highest sales volume since the beginning of 2022 was on February 12 with about 26M dollars.
• The highest number of transactions since the beginning of 2022 was on January 25 with 110 transactions.
• Although the sales volume was the highest on February 12, the number of transactions on that date was only 13 transactions.

Top 10 holders of Cryptopunk

• The two addresses at the beginning of the list belong to Wrapped Cryptopunks and Yuga Labs.
• The results obtained are similar to the https://cryptopunks.app/cryptopunks/leaderboard site.
• Wallet 0xb88f has the largest number of Cryptopunk NFT tokens with 218 tokens.

Top 10 wallets that have made the most profit from Cryptopunk NFT trading tokens

• The most profitable Volt of Cryptopunk NFT trade tokens belongs to address ==0x6639c089adfba8bb9968da643c6be208a70d6daa== with about ==50M dollars== and 21.4% and ==191 transactions==.
• Among these top 10 wallets, the largest number of trades belongs to address ==0x577ebc5de943e35cdf9ecb5bbe1f7d7cb6c7c647== with ==320== transactions, which has earned about ==20.7 million dollars==.

THANK YOU FOR READING!

Twitter: mohsen.dastpeyman

Discord_id: mohsen#4796