Introduction

The CryptoPunks are 10,000 uniquely generated characters. These characters are non-fungible tokens (NFTs) on the Ethereum blockchain. They are the most well-known NFT project and can sell for millions of dollars. In this dashboard, we’ll look at the users that trade these Cryptopunks and rank them based on four different metrics: total volume traded, number of trades, total number of accumulated Cryptopunks, and finally total profit made with trading. All data is based on all-time buying and selling data of CryptoPunks.

Traders by Number of Trades - Methodology

The total volume each generated is calculated in the following way:

• select all buy order of crypto punks from the ethereum.core.ez_nft_sales table in combination with the Crypto Punks NFT address: 0xb47e3cd837ddf8e4c57f05d70ab865de6e193bbb
• we then use count(tx_hash) to get the number of buy trades for every trader
• we do the same for sell orders by taking seller_address by using count(tx_hash) to get the number of sell trader for every trader
• Finally, we add the total number of buy and sell order together for each trader to get the total

Traders by accumulated number of Punks - Methodology

The total volume each generated is calculated in the following way:

• select all buy and sell orders of crypto punks from the ethereum.core.ez_nft_sales table in combination with the Crypto Punks NFT address: 0xb47e3cd837ddf8e4c57f05d70ab865de6e193bbb
• we select the buy and sell price, along with the tokenid to identify the punks
• we then left join the buy order with the sell order on user address and punk id, this gives us a table of all punks that have been bought and sold. Selling data is null for punks that have not been sold and are thus still owned by the user.
• we count the distinct number of punks that have no selling data for each trader to get the total number of punks currently owned by each trader.

Traders by Profit - Methodology

The total volume each generated is calculated in the following way:

• select all buy and sell orders of crypto punks from the ethereum.core.ez_nft_sales table in combination with the Crypto Punks NFT address: 0xb47e3cd837ddf8e4c57f05d70ab865de6e193bbb
• select the trader address, buy price, sell price, buy time and sell time and punk id
• calculate the profit for each crypto trade for each trader by matching the trader address and punk id.
• take the sum of the profit or loss for each trade for each trader to get the total profit made by each trader.

Traders by Volume - Methodology

The total volume each generated is calculated in the following way:

• select all buy order of crypto punks from the ethereum.core.ez_nft_sales table in combination with the Crypto Punks NFT address: 0xb47e3cd837ddf8e4c57f05d70ab865de6e193bbb
• we then filter for transactions where price and price_usd are larger then 0.
• select the buyer_address and take the sum of the price_usd to get the total buying volume of the trader
• we do the same for sell orders by taking seller_address by taking the sum of price_usd to get the total selling volume of the trader
• Finally, we add the buying and selling volumes for each trader to get the total trading volume per trader.

Key Findings

• When it comes to trading volume, the trader 0xef764 generated significantly more volume than other traders. In fact, 2x as much as the second-ranked and 10x to 20x more than the rest of the top 10.
• For the total number of trades, again, the user with the most number of trades has significantly more trades than the other users. This user 0x1919 is second when it comes to total volume.
• This same user 0x1919 also accumulated the most Punks with 327. After some digging on Etherscan, it turns out this address is known as punksOTC which indicates that this address is dedicated to Crypto Punks.
• For the most important metric, profit, a different user shows up: 0xf476. Notice that the total profit is much closer within the top 10 than the other metrics. Trader 0x1919 generated the 3rd most profit. The user 0xef764 with the most volume is not in the top 10 users with the most profit.