In this article, we aim to find out 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.
An Overview About Cryptopunk
On the Ethereum blockchain, 10,000 unique collectible characters are stored with proof of ownership. Originally inspired by the CryptoArt movement of the modern era. Most digital artwork and collectibles are powered by Ethereum’s ERC-721 standard. The Ethereum blockchain allows a single person to officially own multiple punks, each of which is unique. Anyone with an Ethereum wallet could claim them for free, but all 10,000 were claimed very quickly. The Ethereum marketplace contract now requires that they be purchased from someone there. It is possible to buy, sell, bid on, and buy punks via the market.
These CryptoPunk images have been generated algorithmically and measure 24×24 pixels. There are many punky-looking guys and girls mixed in with a few spooky types like apes, zombies, and aliens.
What is the process for getting a punk?
- MetaMask is a Chrome browser plugin that can be downloaded and installed. As a result, your Ethereum account can be accessed by websites that you authorize.
- Make sure you buy some Ether if you have just created an account. The MetaMask plugin includes a Coinbase button for buying Ether.
- This website will recognize the plugin and display buttons that allow you to buy, sell and bid directly on punks once it has been installed.
- For example, we can purchase a punk WPUNKS 9845 for 88 WETH($134).
Approach
On this dashboard, we aim to find the top 10 wallets which are the most successful Cryptopunk traders based on their sales volume, as well as the top 10 punks based on their accumulated sales profit. Then, let’s examine cryptopunks sales statistics based on their transactions so that we can compare their price with their transactions and sales volume. In addition, you can find out who are the buyers and sellers over time.
Cryptopunk Sales Statistics
This section illustrates the different metrics on cryptopunks: number of transactions, sales volume in both USD and ETH, average sale price, Ethereum price, buyers and sellers. Moreover, we can see the Top 10 wallets for the last two years according to the number of punks owned.
From the below graph we can see the overall sales statistics of cryptopunks for the past 2 years period.
On a monthly basis, the graph below shows sales transactions compared with Ethereum price. The number of transactions between May 2020 and August 2022 was 14.44K. During August 2021, a maximum of 2.49K transactions were observed, while a minimum of 50 transactions was observed in July 2020. As of July 2022, total transactions are on a downward trend. In February 2021 and August 2021, there were more transactions than normal. A maximum of $4.43K was observed in November 2021 and a minimum of $206.6 was observed in May 2020 for the Ethereum Price.
It can be seen that whenever the Ethereum price falls, the number of sale transactions increases. During the peak of the Ethereum price in Nov 2021, we can clearly see the sudden drop in transactions.
Compared to the years 2021 and 2022, there were very few transactions found during 2020. As we move forward into 2021, we can see a very good increase in the number of transactions. The number of monthly transactions seems to have dropped suddenly from Sept 2021 onward. The reason is due to the crypto market volatility and the ETH price increase up to $4.43. Because of the sudden change in ETH price, we may see a decrease in transactions from September 2021 onwards.
Below is a graph that shows the cumulative sales transactions of Cryptopunks. There were 14.44K cumulative transactions between May 2020 and August 2022.
The total sale volume (eth) from May 2020 to August 2022 was $866.3K. The maximum sale volume (eth) was $210.98K in August 2021, and the minimum sale volume (eth) was $71.67 in July 2020. Sales volume in November 2021 and September 2021 are lower than normal, while sales volume in August 2021 is higher than normal. An average sale price of 576.24 was observed in October 2021, and an average sale price of 1.24 was observed in August 2020. Average Sale Price(ETH) and also sales volume show an upward trend.
As the Ethereum price increases, the sale volume increases as well. During the peak of the Ethereum price in October 2021, the average sale price also increased suddenly. Based on this, we can conclude that both the average sale price and the average sale volume are positively correlated. Hence, we can say that both are proportional.
There was a lower sale volume during 2020 than during 2021 and 2022. On a monthly basis, we can see a very good increase in sales volume as we move forward into 2021. Afterward, we can see a drop in sales volume due to the volatility of the crypto market from November 2021 onward.
According to the graph below, cryptopunks’ average sale price and sales volume in USD are displayed on a monthly basis. Total Sale Volume(usd) between May 2020 to August 2022 was 2.5B. August 2021 observed a maximum Sale Volume(usd) of 649.15M, and July 2020 recorded a minimum Sale Volume(usd) of 18.61K.
On the graph below, we can see the sellers and buyers of cryptopunks, as well as their comparison with the Ethereum price. We can see the maximum number of sellers and buyers on August 2021 when the Ethereum Price was $3076. In Nov 2021, when the price of Ethereum is maximum $4432, a sudden drop of sellers and buyers can be observed in the graph. Thus, we can assume that the increase in Ethereum price has reduced cryptopunk buyers and sellers.
Based on the graph below, we can see the cumulative number of sellers of cryptopunks. We had 6.13K sellers between May 2020 and August 2022. A maximum of 1.03K sellers was observed in August 2021, and a minimum of 24 sellers was observed in July 2020. The number of sellers in August 2021 and July 2021 is higher than usual.
The heat map of cryptopunk sellers shows that on Aug 2021 there is a maximum number of sellers exceeding 1000.
Based on the graph below, we can see the cumulative number of buyers of cryptopunks. We had 7.1K buyers between May 2020 and August 2022. A maximum of 1188 buyers was observed in August 2021, and a minimum of 35 buyers was observed in July 2020. The number of buyers in August 2021 and Feb 2021 is higher than usual.
The heat map of cryptopunk buyers shows that on Aug 2021 there is a maximum number of buyers exceeding 1.1K.
The following graph shows the top 10 wallets based on the number of punks owned on each wallet. Among the top 10 wallets by number of punks owned, 1,109 punks are owned. The WrappedCryptoPunks-Escrow Wallets contributed 44.09% to the total amount of Punks Owned, while the Top 2 Wallets contributed 58.52% to the total number of Punks Owned. Tonyherreravault has the lowest number of Punks Owned out of these top 10 wallets, while WrappedCryptoPunks-Escrow has the highest number.
Most Popular Punk Sellers By Their Sales Volume
In this section, we can see the top 10 cryptopunk sellers by volume, as well as the top 10 punk profiles. Below is a graph showing 9 different profiles and 10 different sellers. Among these top 10 punk sellers, the total volume(eth) is $233.61K. As we can see, the top four sellers account for almost 3 quarters of the volume out of top 10 sellers . Among the lowest and highest Volume(eth), the lowest volume(eth) is $6.85K (0xcc7c335f3365ae3f7e4e8c9535dc92780a4add9d) and the highest volume(eth) is $124.46K (0x9b5a5a5c5800c91af9c965b3bf06ad29caa6d00f9b).
Top 10 Punks By Their Accumulated Sales Profit
In this section, we can see the top 10 most profitable punk sales, which are ranked based on their accumulated sales profit after each sale. The total profit from these top 10 punks was $1,536.18 from August 28, 2021 to January 26, 2022. Almost 38% of top 10 punks’ profits come from just the top 2 punks. In the same way, the top 4 punks contribute almost 58% of the total profit of the top 10. The lowest total Profit is $95.99 , while the highest total Profit is $379 . There was a maximum profit of $389.69 observed on August 28, 2021, and a minimum profit of $102.5 was observed on October 16, 2021.
Here from the below graph we can see the top 10 sellers by profit . There is a total profit of $17,949.84 across all the sellers. There were 27.92% of total profit generated by the top two sellers, and over half (52.19%) was generated by the top four sellers. It has a lowest total Profit of $1,060.59 (0xdde8df9a7dc9f68bdac815f493d1d731de911b5a) and a highest total Profit of $2,670.57 (0x0e9aed5c7721c642a032812c2c4816f7d6cb87d7). Here we can see all top 10 sellers are gained profit more than 1000$ . In that , the top 4 sellers are gained more than $2K profit .
Observations
- Based on the above analysis, there were 14.44K transactions between May 2020 and August 2022. A maximum of 2.49K transactions were observed in August 2021.
- Total transactions in July 2022 are on a downward trend.
- According to the above analysis, the number of sale transactions increases whenever Ethereum’s price falls. The sudden drop in transactions during the peak of the Ethereum price in Nov 2021 is clearly visible.
- There were $866.3K in total sales (eth) from May 2020 to August 2022.
- The sale volume increases with the increase in Ethereum price. At the peak of the Ethereum price in October 2021, the average sale price also spiked. As a result, we can conclude that both the average sale price and the average sale volume are positively correlated. As a result, both are proportional.
- This graph shows a sudden drop of sellers and buyers when Ethereum reaches its maximum price of $4432 in November 2021. Thus, cryptopunk buyers and sellers have decreased as Ethereum prices have increased.
- Compared with previous months, there are more sellers and buyers of cryptopunks in August 2021. There is a possibility that during that time the Ethereum price was close to $3K. After that we can see the gradual increase of Ethereum price and the sellers and buyers of punks both dropped. Crypto markets are volatile, so we can assume this is happening.
- There are 1,109 punks owned by the top 10 wallets. WrappedCryptoPunks-Escrow Wallets contributed 44.09% of the total amount of Punks owned. The lowest number of Punks Owned is held by Tonyherreravault, while the highest number belongs to WrappedCryptoPunks-Escrow.
- Among these top 10 punk sellers, the total volume (eth) is $233.61K. We can see that the top four sellers account for almost 3 quarters of the volume.
- The top 2 punks make nearly 38% of all the profits from the top 10.
- Based on the top 10 sellers by profit, a total of 27.92% of profit was generated by the top two sellers, and over half (52.19%) was generated by the top four sellers.
Reference Query
with sale_txns as (
SELECT
block_timestamp,
to_date(block_timestamp) as date,
tx_hash,
price as price_eth,
seller_address,
buyer_address,
case seller_address
when '0x9b5a5c5800c91af9c965b3bf06ad29caa6d00f9b' then null
when '0x1919db36ca2fa2e15f9000fd9cdc2edcf863e685' then 'punksotc.eth'
when '0x6639c089adfba8bb9968da643c6be208a70d6daa' then 'punksotc'
when '0x6f4a2d3a4f47f9c647d86c929755593911ee91ec' then 'Shaw'
when '0x0232d1083e970f0c78f56202b9a666b526fa379f' then 'punksOTC2'
when '0x577ebc5de943e35cdf9ecb5bbe1f7d7cb6c7c647' then 'MR703'
when '0x6611fe71c233e4e7510b2795c242c9a57790b376' then 'moineau'
when '0x0e9aed5c7721c642a032812c2c4816f7d6cb87d7' then null
when '0x7eb28b2f14a59789ec4c782a5dd957f9c8f33f6b' then null
when '0xcc7c335f3365ae3f7e4e8c9535dc92780a4add9d' then 'ape123'
end as seller_name,
case seller_address
when '0x9b5a5c5800c91af9c965b3bf06ad29caa6d00f9b' then 'https://storage.googleapis.com/opensea-static/opensea-profile/14.png'
when '0x1919db36ca2fa2e15f9000fd9cdc2edcf863e685' then 'https://storage.googleapis.com/opensea-static/opensea-profile/11.png'
when '0x6639c089adfba8bb9968da643c6be208a70d6daa' then 'https://openseauserdata.com/files/ed9120113a6d173e3805d1f19340d5e0.jpg'
when '0x6f4a2d3a4f47f9c647d86c929755593911ee91ec' then 'https://storage.googleapis.com/opensea-static/opensea-profile/6.png'
when '0x0232d1083e970f0c78f56202b9a666b526fa379f' then 'https://openseauserdata.com/files/a809ec82f387ec41ecf592b0ff10ce0c.png'
when '0x577ebc5de943e35cdf9ecb5bbe1f7d7cb6c7c647' then 'https://lh3.googleusercontent.com/idDmlI1YJrwNAaqNQHExinevexZvGwOJ_vVfWrRvQD6g2lNyZo96JA3xYKW1vC-tFSu8trn0G34R4kDeVipZEE9ffpIpG3PqNoPaEQ=s168'
when '0x6611fe71c233e4e7510b2795c242c9a57790b376' then 'https://storage.googleapis.com/opensea-static/opensea-profile/20.png'
when '0x0e9aed5c7721c642a032812c2c4816f7d6cb87d7' then 'https://storage.googleapis.com/opensea-static/opensea-profile/25.png'
when '0x7eb28b2f14a59789ec4c782a5dd957f9c8f33f6b' then 'https://storage.googleapis.com/opensea-static/opensea-profile/3.png'
when '0xcc7c335f3365ae3f7e4e8c9535dc92780a4add9d' then 'https://storage.googleapis.com/opensea-static/opensea-profile/3.png'
end as opensea_profile_pic,
tokenid
from ethereum.core.ez_nft_sales
where event_type = 'sale'
and project_name='cryptopunks'
and price > 0
),
sales as(
SELECT
seller_address,
tokenid,
count(tx_hash) as sold_items,
sum(price_eth) as amount_received_eth
FROm sale_txns
GROUP BY seller_address, tokenid
),
purchases as (
SELECT
buyer_address,
tokenid,
count(tx_hash) as bought_items,
sum(price_eth) as amount_paid_eth
FROm sale_txns
GROUP BY buyer_address, tokenid
),
pl as (
SELECT
seller_address,
amount_received_eth - amount_paid_eth AS profit_eth
FROM sales INNER JOIN purchases ON seller_address = buyer_address and sales.tokenid = purchases.tokenid
)
SELECT
seller_address,
sum(profit_eth) as eth_profit
FROM PL
GROUP BY seller_address
QUALIFY row_number() over(order by eth_profit desc) <= 10