Cryptopunk Sales and Traders
methods :
-
finding buy price of each nft every time that each nft were sold .
-
finding sell price of each nft every time that each nft were sold .
-
calculating profit earned from trading each NFT and summing profits earned by each wallet based on eth value , and finding top 10 Cryptopunk traders .
(all data above got from
ethereum.core.ez_nft_sales
table .) -
counting number Cryptopunk NFTs transfered to each wallet.
-
counting number of Cryptopunk NFTs moved frome each wallet.
-
subtracting these two number to find how many NFTs each wallet accumulated.
-
selecting top 10 of them
first of all we divided cryptopunk sales from other NFTs .
then we calculated profit earned from trading each nft and summing these profits grouped by user wallet based on eth value.
here is the results :
for finding most cryptopunk accumulated wallets we subtracted number of cryptopunk sent from wallet ,from number of recieved
here is the results :
Appendix:
Data provided from app.flipsidecrypto.com