According to the left chart, the wallet address 0x1919db36ca2fa2e15f9000fd9cdc2edcf863e685 has by far performed the most number of Cryptopunks purchase transactions with total 556buy TXs.

After this address, we can see the wallet address 0xd387a6e4e84a6c86bd90c158c6028a58cc8ac459 on the second rank with 191punks buy transactions.

0x6639c089adfba8bb9968da643c6be208a70d6daa is the first rank user with the most profit from CryptoPunks. (50.70075M USD).

According to the chart, we can see the wallet address 0xa858ddc0445d8131dac4d1de01f834ffcba52ef1 is the first person currently holding the most number of Punks on his wallet with 1119 NFT. after that 0xb7f7f6c52f2e2fdb1963eab30438024864c313f6 is the most number of Punks on his wallet with 397 NFT.

For this bounty, I am going to mainly use ethereum.core.ez_nft_sales table:

For Analysing Cryptopunks, we should set some conditions on ethereum.core.ez_nft_sales table to analyse the data about CryptoPunks trades. these conditions are: event_type = sell project_name = cryptopunks

Each tx_hash on this table refers to one successful sale transaction id of Cryptopunks.

The tokenid column on this table refers to the specific token that is being sold via related tx_id.

The price column shows the ETH value of the related transaction and price_usd column refers to its USD value.

The buyer_address is the wallet address of user who is purchasing the NFT and seller_address is the wallet address of user who is selling the NFT.

for the top 10 sellers: we should group seller_addresses and their price and price_usd and order the results by prices column with limiting results to 10

for the top 10 buyers: we should group buyer_addresses and their price and price_usd and order the results by prices column with limiting results to 10

for the top 10 holders: we should use ethereum.core.ez_nft_transfers table and subtract the sent tokens from received tokens where the sender and receivers are the same and also the tokenids sent or received are the same too.

The top 10 holders of Punks by number hold between 79 and 1119 Punks.

Crypto punks have been a very active collection with almost half a billion in sales volume in 2022. There is a huge variation in the price of Punks selling between 23 million and 60K in price. the top collectors of punks hold a few dozen punks and paid a few Million for their collection.

The wallet address 0x1919db36ca2fa2e15f9000fd9cdc2edcf863e685 has by far performed the most number of Cryptopunks purchase transactions (600) and also purchased the most number of punk tokens (556)

The wallet address 0xef764bac8a438e7e498c2e5fccf0f174c3e3f8db has by far spent the most volume for purchasing cryptopunks tokens with more than $535.94M !

The wallet address 0x53ede7cae3eb6a7d11429fe589c0278c9acbe21a has performed the most number of Cryptopunks sale transactions (872) and sold the most number of punk tokens (872).

The most number of users (60% of them) are holding only 1 Cryptopunk NFT.

The wallet address 0xa858ddc0445d8131dac4d1de01f834ffcba52ef1 is currently holding the most number of Punks on his wallet with more than 1119 tokens.