Introduction

The CryptoPunks’ journey to non-fungible stardom is intertwined with the growth of the Ethereum blockchain. Launched in June of 2017 by product studio Larva Labs, and acquired by Yuga Labs in 2022.

And the rise of multi-billion dollar projects like Bored Ape Yacht Club can be traced directly back to the CryptoPunk mold.

It consists of 10,000 unique 24×24 pixel art images that depict mostly humans (male and female). However, there are several other unique types, which are considered more valuable because of their rarity. These include zombies (88), apes (24), and aliens (9).

introduction_source

image source

Methodology

\

• In this bounty we find

  1. Top 10 seller based on number of transactions and USD amount.
  2. Top 10 buyers based on number of transactions and USD amount.
  3. Top 10 addresses based on profit and NFT holding.

• For finding above information we use ethereum.core.ez_nft_sales and ethereum.core.ez_nft_transfers tables.

• Filter NFT contracts

  0xb47e3cd837ddf8e4c57f05d70ab865de6e193bbb for Cryptopunk

  0xb7f7f6c52f2e2fdb1963eab30438024864c313f6 for wpunks

• I also filter 0x0000000000000000000000000000000000000000 addresses i think it helps to get better results.

• Also for finding the amount of profit for each address

  ==USD amount sold - USD amount bought = USD amount of profit==

  \

==Buyers==

• In top 10 buyers based on USD volume we can see that :

  • 0x1919db36ca2fa2e15f9000fd9cdc2edcf863e685 with 113558670.43 USD

  • 0x69c488bcda156379b6661f08a35db627e5d467dd with 26421002.96 USD

  • 0x0e9aed5c7721c642a032812c2c4816f7d6cb87d7 with 20126693.4153433 USD

    are the first top 3 of buyers. \n

  \

• 0x1919db36ca2fa2e15f9000fd9cdc2edcf863e685 with 113558670.43 USD has about 46% off all USD volume that

  spent on buying.

• and after 0x69c488bcda156379b6661f08a35db627e5d467dd with 26421002.96 USD and about 10.7% other addresses have less than 10%.

==Sellers==

==Profit==

==Token==

• According to the charts we can see that :

• 0x53ede7cae3eb6a7d11429fe589c0278c9acbe21a has the highest number of transactions (771 transactions).

  \

• After that 0x1919db36ca2fa2e15f9000fd9cdc2edcf863e685 with 424 transactions is in the second place it has 54% of first address transactions.

• 0x1919db36ca2fa2e15f9000fd9cdc2edcf863e685 has the highest USD amount of sales and its about 82.2M.

• According to the chart we can see that:

1. The highest number of daily punk sells is on Aug 2021 with 349 Punk sales.

   \

2. In 2022 highest amount of sales is on Jan with 127 sold Punks. its about 36% of the highest amount of sell on 2021.

   \

3. After Jan 2022 we see some sells peak on Jun but in compare to 349 sales this amount are very low.

Top 10 token id based on number of transactions.

• Token with id 9032 has the highest transaction numbers and its 15 transactions.

  \

• After that 8970 , 7392 and 6956 have 14 transactions.

Top 10 token id based on number of transactions

• 5822 with 23.75M USD has the highest amount of USD.

  \

• The second is 4156 with 11.54M and its about 48% of the first token USD amount.

  \

• After these all the tokens amount is under 10M.

Conclusion

Top 10 traders based on USD profit :

• 0x6639c089adfba8bb9968da643c6be208a70d6daa with 50.63M USD profit.
• 0x6f4a2d3a4f47f9c647d86c929755593911ee91ec with 30.05 M USD profit in the second place.

After these two other addresses have under 30M profit.

Top 10 Cryptopunk holders:

• 0xa858ddc0445d8131dac4d1de01f834ffcba52ef1 has 423 punks
• After that we see 0xb88f61e6fbda83fbfffabe364112137480398018 with 221 tokens.

Thanks to : pimi1356#9693

For Top 10 Cryptopunk holders query i use this dashboard :

• 0x6639c089adfba8bb9968da643c6be208a70d6daa with 50.63M USD profit also we can see this address in the second place in top 10 seller based on USD amount.
• 0x1919db36ca2fa2e15f9000fd9cdc2edcf863e685 has the highest USD amount of sales and its about 82.2M and also 424 transaction also we can see this address in top 10 buyers.