Open Analytics Bounty: ETH (November 6)

    Open Analytics Bounty: ETH (November 6)

    📌 Overview

    • in this dashboard,I will review the following
    • In the first stage, a brief introduction to what is foxfam NFT ?
    • Total Buyers & Sellers & Average Price
    • Total sales Volume & Number NFT
    • Top 10 Holder & Top 10 Buyers
    • Top 10 Sellers
    • Top 10 Wallet (Profit Dollar)
    • Total Mint & minter
    • Top NFT
    • Analyze each chart
    • General conclusion about the dashboard

    Introduction

    What is FoxFam?

    View On OpenseaFox Fam is a lovingly crafted NFT project by established artists Yum Yum. We have hand-drawn hundreds of traits to create a vast array of unique and appealing characters. We might possibly have more combinations than stars in the sky at this point! Yum Yum have been designing characters for high profile brands like XBox, Nickelodeon and Lyft since 2010. We are building a high-quality project that rewards our NFT holders. Animation, interactive content and other goodies to come! Let's go fam!

    🖋️ Methodology

    • I Used ethereum.core.ez_nft_sales and ethereum.core.ez_current_balances andethereum.core.ez_nft_mints tables in getting the :
      • foxfam address: 0x099689220846644F87D1137665CDED7BF3422747
      • Project name: foxfam
        • Total Buyers & Sellers & Average Price
        • Total sales Volume & Number NFT
        • Top 10 Holder & Top 10 Buyers
        • Top 10 Sellers
        • Top 10 Wallet (Dollar Profit)
        • Total Mint & minter
        • Top NFT

    Total & Daily Charts ( Buyer , Seller , Total sale volume,…)

    Loading...
    Loading...
    Loading...
    Loading...
    Loading...

    Observations

    • The chart on the Above represents four parameters on a daily basis since the beginning of foxfam NFT sales.
    • As it can be seen, in four parameters, simultaneously with the passage of time, we see a decrease in sales, the number of buyers and sellers.
    • As you can see, since the beginning of the new year, we have seen a decrease in NFT sales, and there is no longer any significant increase.
    • Total Unique Sellers = 5980 Total Unique Buyers = 7410
    • Total Transactions = 17.7 K Total Sales NFT = 8.57 K
    db_img
    db_img
    db_img
    db_img
    db_img
    db_img
    Loading...
    Loading...
    Loading...
    Loading...
    Loading...
    Loading...

    Observations

    • The chart on the Left shows the volume of daily NFT sales since the beginning of foxfam NFT sales.
    • As you can see, since the beginning of the new year, we have seen a decrease in NFT volume sales, and there is no longer any significant increase.
    • The highest volume of sales was on october 8th 2021 amounting to $2.68 million dollars
    • Total Volume $23.4M

    Observations

    • The graph on the left represents the average & minimum & maximum price of selling NFTs on a daily basis since the beginning of selling foxfam NFTs.
    • As you can see, at first the average & minimum & maximum price was very high, then it increases and decreases again. The highest average price was 4180 dollars on March 10st, minimum price is 0.62
    • and maximum price $92.8K USD on october 10 th 2021
    • Average Price $1205

    Top Buyers & Sellers

    db_img
    db_img
    Loading...
    Loading...
    Loading...
    Loading...

    Observations

    • The two charts left include the top NFT buyers based on the number and volume of purchases.

      \

    • top buyer by volume And By Number nft----→

      0x721931508df2764fd4f70c53da646cb8aed16ace

      = $610K USD and 418 NFT

      \

    Top Holders & Wallet (User)

    db_img
    db_img
    Loading...
    Loading...

    Observations

    • In the chart on the left, we see the top ten holder Robotos , which include :
    RankHolderNFT
    10x721931508df2764fd4f70c53da646cb8aed16ace300
    20xb22bd0bcc491e0af426e0ecc624057d981b693f3240
    30xb697b9455eeee9574ec5c5350cb10c8a5b752a39221
    • we see the top ten addresses that have made the most profit from buying and selling NFT, which is in the following order.
    RankPROFIT_USDUSERS
    166823.440xbdd95abe8a7694ccd77143376b0fbea183e6a740
    251865.110x81be7f475e335693fda594abc8b42bb0d873f9a0
    351502.320x46e449a3f88d0e35b4520bc36e8dfda195c896b0

    Top NFT

    db_img
    db_img
    Loading...
    Loading...
    Loading...
    db_img
    db_img

    📚 Conclusion

    • My criteria for identifying top addresses is the amount of dollar profit they have made through NFT trading.

    • at first the average price was very hugh, then it decreases .

    • As you can see, since the beginning of the start sales , we have seen a decrease in NFT volume sales, and there is no longer any significant increase.

    • The one who has made the most profit is the one who ranks third in the sale

    • An important conclusion is that in order to have the most profit in the transaction, you must not be the biggest buyer or the biggest holder, as we can see that the three wallets that made the most profit did not buy the most and were not the top holder. . There are many conditions involved in good trading.

      > In this collection, those who had the most sales, both in terms of number and volume of sales, had the most profit.

      \

    Total Mint & Minter

    Loading...
    Loading...
    Loading...

    observations

    • As can be seen, the highest volume of Mint has been performed in the first 4 days, and the highest number of Mint and Miner is on the fourth day.
    • Overall, all Mints have been done in the first 20 days.
    • highest mint & minter is minter 645 user & 804 mint on Oct 5 .
    • total mint 1770
    • total minter 1149
    db_img
    db_img

    Appendix


    The solution of this question and the queries are completely used from the filipside database

    The construction of the dashboard was also used from the site app.flipsidecrypto.com/velocity, which belongs to flipside

    My Data :grinning:

    discod : esi69#8413

    > # thanks for reading !

    > ## Observation > > * The chart above from the right is of the top 3 NFTs in terms of the highest price. > * First Rank is 1163 ID with 92K USD > * The chart above is the middle of the top ten NFTs in terms of trading volume Note, NFT, ID 7459 with 137 K USD > * The upper left graph is related to the top NFTs in terms of the number of times of buying and selling. > * Firs Ranks is ID 9189 with 11 Trades

    db_img

    Observations

    • The two charts Right include the top NFT sellers based on the number and volume of Sales

      \

    • Top Seller By Volume & Number NFT is

      0x9fa8a0efbed7a7064e761684ce8a78847d62531f

    volume is $141K USD

    Number nft is 113