Cryptopunk Sales and Traders

    db_img

    Questions :

    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.

    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 :

    Loading...
    Loading...


    for finding most cryptopunk accumulated wallets we subtracted number of cryptopunk sent from wallet ,from number of recieved

    here is the results :

    Contact info:

    discord : MOHAMAD23#9722

    Appendix:

    Data provided from app.flipsidecrypto.com

    Conclusion:

    • the most profitable punk trader is :


      0x0e9aed5c7721c642a032812c2c4816f7d6cb87d7

      with 2670 ETH profit

      \

    • the most accumulated cryptopunk wallet is :


      0xb7f7f6c52f2e2fdb1963eab30438024864c313f6

      with 489 punk owned