test4
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.

What is CryptoPunk?
The CryptoPunks collection was one of the first projects in the field of NFT digital currencies and in a way the most expensive of them, which was launched on the platform of Ethereum.
Non-Fungible Tokens, or NFT in short, has been one of the hottest topics in the cryptocurrency field, and with the beginning of 2021 and millions of transactions, its oven became hotter than ever. 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.
Types of cryptopunk
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. Cryptopunk #7804, which is one of the 9 NFT tokens of Spaceman, was sold on March 10, 2021 (March 20, 2019) at a price of 4,200 Ether (ETH) equivalent to about $7.5 million (according to the price of Ether at the time of the transaction). Which is also the most expensive NFT exchange ever. This punk was purchased by the address 0xf4b4a58974524e183c275f3c6ea895bc2368e738 on the Ethereum network, and this purchase was the first activity of this address on the network. Before this, the record for the most expensive token was held by digital artist Beeple for the song "CROSSROAD", which was sold on February 24, 2021 (March 6, 2019) for $6.6 million.
The address 0x03911fecabd6b4809c88e2e6eb856ec932b2ee3e, which sold Punk Spaceman, first bought Crypto Punk #7804 on January 10, 2018 (20 December 2016) at a price of 12 Ether worth $15,000 at that time, and obviously this address is from his initial investment. He made a huge profit. Also, on February 21, 2021 (March 3, 2019), this address sold a cryptopunk monkey for the price of 800 Ether, an amount of about 1.2 million dollars.
Conclusion:
Cryptopunk, as the first projects in the field of cryptocurrency tokens, has a very high market value these days. A value that tempts anyone interested in this area to own one of the 10,000 tokens available. Tokens that have no particular practical use and are meant as collectibles, like what we've seen in the physical world for works of art, stamps, or coins.
Currently, non-fungible tokens have been exploited for various purposes and have grown significantly, and as evidenced, this trend will continue.

Findings :loudspeaker:
-
The most sold by the address 0xef****f8db :top:
-
The most purchases by address 0x9b****0f9b :top:
-
0xf4****1897 earned the most profit :heavy_dollar_sign:
→ Note: There is a gap of 294 days between the first purchase and the last sale of this user :timer_clock:
-
It seems that the growth of purchases in August 2022 was higher than sales, but in July 2021 we saw an increase in sales :1234:
-
The top punk in terms of turnover is 4146, which is about 3% of the total turnover of Cryptopunk :checkered_flag:
-
The top punk holder is the address 0xb7****13f6, which has about 491 punks (up to the moment) :1st_place_medal:
\
Methodology
-
The ethereum.core.ez_nft_sales table was used to find the top 10 addresses and the difference between buyer_address and seller_address And the number of purchases and sales was checked based on dollar volume
-
Top 10 punk image taken from **Cryptopunk,**Also, check the turnover percentage of the top 10 punks compared to another
-
The filter project_name = 'cryptopunks' was also used for NFTs
-
To find the punks, the tokenid column is used
-
The length of the activity period of the top 10 traders was checked daily through datediff, and the difference between the first purchase date and the last sale date was calculated.
:triangular_flag_on_post: In the table and graph below It has been checked as a percentage and the number of purchases and the dollar volume of purchases for the top ten addresses
:1st_place_medal:0xef****f8db :money_with_wings:
:2nd_place_medal:0x19****e685 :money_with_wings:
:triangular_flag_on_post: In the table and graph below It has been checked as a percentage, the number of sales and the dollar volume of sales for the top ten addresses
:1st_place_medal:0x9b****0f9b :money_with_wings:
:2nd_place_medal:0x19****e685 :money_with_wings:
:triangular_flag_on_post: In the following three charts→
- Profit volume of the top 10 traders
- Profit ratio of top 10 traders compared to capital
- The profit percentage of the top 10 traders compared to each other
:triangular_flag_on_post: What we see below for the top 10 traders→
- Number of activity days (the difference between the first purchase and the last sale)
- Number of sales transactions
- Dollar volume of purchases :heavy_dollar_sign:
- Dollar volume of sales :heavy_dollar_sign:
- Profit earned in dollars :heavy_dollar_sign:
- Profit compared to invested capital (%)
:triangular_flag_on_post: In the section below The turnover percentage of the top 10 punks compared to each other and their photos have been checked










:triangular_flag_on_post: In the table and graph below Top 10 Cryptopunk holders reviewed by number of punk holdings
:triangular_flag_on_post: In the table and graph below, the top 10 punks are checked:
- The turnover of punks:heavy_dollar_sign:
- Percentage of turnover relative to each other(%)
- Turnover percentage to all punks :heavy_dollar_sign:
:triangular_flag_on_post: In the two charts below on a monthly basis The amount of buying and selling of the top 10 traders and the growth of buying and selling of the top 10 traders have been checked