Try Quests to earn cryptoCryptopunk Sales and Traders
❓ What is Cryptopunk
10,000 unique collectible characters with proof of ownership stored on the Ethereum blockchain. The project that inspired the modern CryptoArt movement. Selected press and appearances include Mashable, CNBC, The Financial Times, Bloomberg, MarketWatch, The Paris Review, Salon, The Outline, BreakerMag, Christie's of London, Art|Basel, The PBS NewsHour, The New York Times in 2018 and again in 2021. The Cryptopunks are one of the earliest examples of a "Non-Fungible Token" on Ethereum, and were inspiration for the ERC-721 standard that powers most digital art and collectibles. → Source
✍️ Description of Work
In this dashboard, we want to examine the sales and traders of Cryptopunk. For this, we analyze and check the following:
- Total volume (In USD), number of sales and the number of sellers and buyers
- Top 10 sellers and buyers by volume (In USD) and number of sales/purchase
- Top 10 #NFT by volume (In USD) and number of sales
- Top 10 Cryptopunk holders by number of #NFT holds
- Top 10 profitable traders by volume (In USD)
- Top 10 loser traders by volume (In USD)
🧠 Methodology
To deal with this bounty, we use ethereum.core schema and ez_nft_sales, erc20_balances and ez_nft_transfers tables. To obtain Cryptopunk sales, we use the following query, which is the base query for analyzing and calculating all parts of this bounty:
base query:
select
*
from ethereum.core.ez_nft_sales
where buyer_address != '0x0000000000000000000000000000000000000000'
and seller_address != '0x0000000000000000000000000000000000000000'
and event_type= 'sale'
and price_usd != 0
and tx_hash != '0x92488a00dfa0746c300c66a716e6cc11ba9c0f9d40d8c58e792cc7fcebf432d0'
and nft_address = '0xb47e3cd837ddf8e4c57f05d70ab865de6e193bbb'
-
In this query, we use the contract address 0xb47e3cd837ddf8e4c57f05d70ab865de6e193bbb to obtain Cryptopunk sales, which is related to Cryptopunk, and we consider transactions that are related to sales. In this bounty, we ignore transactions related to Wrapped Cryptopunks and our focus is on Cryptopunks.
-
Wrapped Cryptopunks: Cryptopunk is on the ERC-20 network and users Wrap Cryptopunk to be able to trade it on the ERC-721 network on platforms like opensea
We discard the transaction with tx_hash = ==0x92488a00dfa0746c300c66a716e6cc11ba9c0f9d40d8c58e792cc7fcebf432d0== because it is not a real transaction:
-
To calculate each part of this bounty, we use base query and then based on each part, we make our calculations and findings on Cryptopunk sales transactions.
-
We have data for Cryptopunk from 2020-05-05 onwards and all our calculations and analysis have been done since this date.
✅ Observations
According to the results obtained from 2020-05-05 onwards:
- The total number of Cryptopunk NFTs sold is 14.38k
- The total volume of Cryptopunk NFTs sold is 2.01B USD
- This number and volume of buying and selling was done by 5010 unique buyers and 3520== unique sellers.
- The highest number of sales related to Aug 23, 2021 with 344 sales, Aug 28, 2021 with 303 sales, Jul 31, 2021 with 290 sales and Aug 27, 2021 with 185 sales
- The highest number of sales are for Aug, Jul and Feb in 2021
- The highest volume of sales is related to Aug 28, 2021 with 140.69M USD sales and after that Aug 23, 2021 with 89.99M USD sales.
- In general, in 2021, the most sales activity of NFTs has been recorded for Cryptopunk, and after that, the volume and number of sales will decrease.
✅ Observations
Sales:
- The wallet address 0x1919db36ca2fa2e15f9000fd9cdc2edcf863e685 (punksOTC) has the most Sales with 82248623.83 USD, followed by 0x6639c089adfba8bb9968da643c6be208a70d6daa with 55706812.26 USD. Wallet address 0x6f4a2d3a4f47f9c647d86c929755593911ee91ec is in third place with 30128841.34 USD
- It is interesting that the address 0x7eb28b2f14a59789ec4c782a5dd957f9c8f33f6b with 23759664.68 USD of sales is located in the sixth valley of sellers who made this amount of sales with only One Sale.
Purchase:
- The wallet address 0x1919db36ca2fa2e15f9000fd9cdc2edcf863e685 (punksOTC) has the most Purchase with 113558670.43 USD, followed by 0x69c488bcda156379b6661f08a35db627e5d467dd with 26101059.25 USD. Wallet address 0x0e9aed5c7721c642a032812c2c4816f7d6cb87d7 is in third place with 20096182.62 USD
The address ==0x1919db36ca2fa2e15f9000fd9cdc2edcf863e685== has the most buying and selling activity → etherscan
✅ Observations
- NFT CryptoPunk #5822 has the highest sales volume with 23759664.68 USD sales volume in a transaction mentioned in part 2
You can see that the most expensive NFTs are only sold in a few limited transactions (2 or 3 transactions at most) and are valuable NFTs that buyers holds in their wallets after purchase.
✅ Observations
-
In the charts above, you can see the Top 10 holders of CryptoPunk NFTs based on the flipsidecrypto data and the ez_nft_transfers table, where we obtained the last sale of each NFT and calculated which wallets these last sales were sold to. and finally, we have calculated the number of balances of each wallet, also using the erc20_balances table, the balance of each wallet is obtained, but there is a difference between the flipsidecrypto data and other sources such as etherscan for the top holders of CryptoPunk NFT, which we ignore it.
-
You can see the balance of the top 10 holders of CryptoPunk NFT over time on a monthly basis, in which it can be seen that since Aug 2021, most of the holders have kept their balance almost constant, and from this date on, no significant buying or selling activity can be seen. Except for Yuga Labs (etherscan), which bought its entire inventory in Aug 2022 and is the second largest holder of CryptoPunk NFTs with 423
✅ Observations
- The address 0x6639c089adfba8bb9968da643c6be208a70d6daa has the most profit from buying and selling CryptoPunk NFTs with 50700749.58 USD. After that, the address 0x6f4a2d3a4f47f9c647d86c929755593911ee91ec is in the second place with 30053207.31 USD and 0x6611fe71c233e4e7510b2795c242c9a57790b376 is in the third place with 24673271.15 USD.
- You can see that out of the 10 most profitable traders, only 6 of them currently have NFTs in balance and 4 of them have sold all of their NFTs.
- The most activity of the most profitable traders is related to 2021 and the month of August, and after less activity of buying and selling (based on balance)
- The address 0x577ebc5de943e35cdf9ecb5bbe1f7d7cb6c7c647 (etherscan), which is among the 10 most profitable traders, is among the top 10 sellers and among the top 10 holders of Cryptopunk NFTs, and currently has the largest balance among the most profitable trades.
6️⃣ → Top 10 loser traders by volume (In USD)
- To get the most loser traders, we first calculate the total volume of sales and purchases of each wallet, and then subtract the volume of sales from the volume of purchases to obtain a profit, then we find the wallets that have the lowest profit, provided that all have sold or transferred their NFTs (no balance of Cryptopunk NFTs in their wallet)
✅ Observations
- You can see that 0x1cbb87bb9a4dd0316189eede2277a58590dc124a had the biggest loss from buying and selling Cryptopunk NFTs with 4281021.65 USD,
- Followed by 0x4680cb63563472cac10236c07d288580d8d7b52a with 3018255.7 USD loss.
- And 0x024bcbcaad82e67f721799e259ca60bc7d363419 is third with 2558498.85 USD loss.
✔️ Final Conclusion
> According to the analysis and review of the sales of Cryptopunk traders, it was found that since 2022-05-05, the total number of sales has been 14.38k, and the sales volume of this number has been 2.01B USD, which was made by 5010 unique buyers and 3520 unique sellers. Also, the most activity in buying and selling was related to 2021 and the months of August, July and February. > > Also, the addresses 0x1919db36ca2fa2e15f9000fd9cdc2edcf863e685, 0x6639c089adfba8bb9968da643c6be208a70d6daa and 0x6f4a2d3a4f47f9c647d86c929755593911ee91ec have had the highest sales respectively and the addresses 0x1919db36ca2fa2e15f9000fd9cdc2edcf863e685, 0x69c488bcda156379b6661f08a35db627e5d467dd and 0x0e9aed5c7721c642a032812c2c4816f7d6cb87d7 have had the most purchases respectively and NFT CryptoPunk #5822 has the highest sales volume with 23759664.68 USD sales volume. > > Top owners of Cryptopunk are 0xb7f7f6c52f2e2fdb1963eab30438024864c313f6, 0xa858ddc0445d8131dac4d1de01f834ffcba52ef1, 0xb88f61e6fbda83fbfffabe364112137480398018 and the most profitable traders are also 0x6639c089adfba8bb9968da643c6be208a70d6daa, 0x6f4a2d3a4f47f9c647d86c929755593911ee91ec and 0x6611fe71c233e4e7510b2795c242c9a376790b