FLASH BOUNTY: FLOW NFT Floor Tracker

    Introduction

    Flow, a proof-of-stake blockchain, supports consumer-scale decentralized applications, NFTs, DeFi, DAOs, PFP initiatives, and more. Powered by Cadence, an innovative programming language for digital assets, Flow lets developers innovate and push the limits to bring the next billion to Web3. Flow is an open, decentralized platform with a growing community of creators from top brands, development studios, venture-backed companies, crypto leaders, and more. The team behind CryptoKitties, NBA Top Shot, and NFL ALL DAY has repeatedly developed industry-leading consumer-scale experiences.

    An NFT is a licensed collectible image or video. Bitcoin's blockchain verifies NFT ownership. That means just one movie, image, or animated present can be authenticated online, even though copies can multiply. Collectibles can be bought, sold, and traded.

    The floor price is the fundamental metric in the NFT market that is one of the most common ways that collectors evaluate a project is by looking at the floor price of NFTs, which is the lowest-priced NFT in the collection. The minimum amount that a collection's owners are willing to accept for their NFTs. The base cost rises as interest in an NFT project grows. An NFT project's momentum may be waning if the floor price drops suddenly.

    In addition to purchasing individual NFTs, investors can also purchase all of the listed NFTs at the floor price. The mops in their hands may sweep the floor. That can only occur if the buyer keeps tabs on the progress of the venture up until the point it is put up for sale.

    "sweeping the floor" is slang for purchasing several at once. Project developers and purchasers alike can benefit from "sweeping the floor" in the NFT industry. If the owners of the project buy all of their NFTs at the floor price, the cost of the project will be reduced to zero. When consumers do a final sweep before making a purchase, it can

    Method

    In the current dashboard, I tried to track the floor price of Flow NFT projects by the use of flow.core.ez_nft_sales and flow.core.fact_prices tables.

    I used a sales table to calculate the sales metrics, including sales volume, unique sellers and buyers, etc.

    I used a price table to calculate sales volume, average price, and min price in $USD.

    I assessed the floor price in some way. First, I calculated it by max(block_timestamp) as the last date floor price, then I calculated it over time so that the min price in each time period is called the floor price. For instance, when the calculation time period is by daily, the min(price in $USD) is mentioned as the floor price on that day.

    In the final sections, I showed the sales metrics on the months of the year by joining the sales table with the ethereum.core.dim_dates table to find the short name of the months.

    In the first part I calculated the last date floor price of Flow NFTs collections and categorized those by range of floor price with $2 deference.

    And the next section I selected five projects inclufing Topshot, AllDay, OlympicPin, UFC_NFT & DimensionX and assessed their sales metrics by weekly and categorized those by $50 floor price range.

    However you can ==change== timeframe and floor price range by above tapes.

    Analysis

    :hourglass_flowing_sand: Last date Floor Price


    This section allocated to last date (min(price in $USD) in max(block_timestamp)) floor price.

    ✍🏻 Conclusion

    • There are currently more than ten NFT projects in the FLOW ecosystem that have a minimum price of more than ten dollars.
    • The majority of NFT collections had a $1–$2 floor price until August 2021, but since then, the proportion of other types has steadily increased all the way up to the present day.
    • When compared to other NFT projects in the FLOW ecosystem, DimensionX has the highest floor pricing as of today (65 USD).
    • In the Flow ecosystem, the overall trend for the average floor price of NFT collections is dropping after 2022. AllDay hit its PHI in the first week of February.

    About:

    FLOW NFT Floor Tracker

    What going on in the current dashboard?

    > * Tracks the floor by contract for various NFT projects in the FLOW ecosystem. > * We’re interested to see how you come up with your own methodology. > * Include at least five projects in your dashboard, as well as any interesting metrics, notes, trends, or outliers that you see. \n

    Hey there 👋!

    Firstly, I appreciate you sticking with it until the conclusion.

    I'm Hamed, a civil engineering Ph.D.

    student interested in data analysis.

    I've made many similar dashboards and visualizations since I started at Flipside in January.

    Please take a look at my various contact details and let me know what you think.

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

    :telescope: Findings:

    The chart right shows the floor price of NFT collections on Flow.

    • As can be seen there are 28 collections that have had floor price over $1, that four of those has floor price over $50.
    • MotoGPPack is the collection with the highest floor price that reached $2K.
    • Second collection with most floor price is Gaia wirh $250.
    • The floor price of first place of top last date floor price of collection is 4x more expensive than second place.

    The second chart right show the distribution of sales count of collections based on last date floor price range.

    • The range of floor price categorized by $2 differences.
    • As of this chart can be observed the most of sales transactions count are belong to Baskeballs collection with more than 103.6K sales count in range of 10 to $12, that followed by AllDay collection with over 101.5K sales transactions count in range of 4 to $6.
    • All of other collections sold below 10K.
    • Over 90% of share’s sales transactions count belong to mentioned above collections, and 6.4% of total sales count sold in range of below $2.
    • Nearly 80% of NFT traders tends to trade of AllDay collections.

    :telescope: Findings:

    • In this section I categorized collections by weekly floor price and tracked top 5 higher floor price in $USD over time. the floor price selected ranges $50 selected, but you can change it to your own choice.
    • As can be seen 27% (nearly 60 pieces)
    • of collections floor price were in range of 50 to $100 and 14.4% (over 30 pieces) of total number of collections sold in range of 100 - $150 over past 6 month.
    • Nearly 90% of total sales count has transacted to PackNFT collection that had sold in range of 50 ~ $100 over past 6 months.
    Loading...
    Loading...
    Loading...
    Loading...
    Loading...
    Loading...

    :hourglass_flowing_sand: Sales volume, Average/Max & floor price by months of year

    :telescope: Findings:

    In this sections 5 NFT projects was selected to assess the sales metrics, specially floor price since 2022.

    According to the charts right, the total trend for these top 5 projects’ sales is significantly decreasing over time.

    Overall, TopShot dominates most charts over time in every metric imaginable, but the AllDay NFT collection is quickly gaining ground and may soon overtake TopShot in a few key areas. While February 2022 saw the highest sales volume for these collections, February 2022 saw the highest sales volume overall.

    Although, the The DimensionX is a new collections in flow according the first sales day (early week of Sep), but the highest average sales price is belongs to that with latest day in $248.8.

    The AllDay colleactions floor price peaked at $80 in early week of Feb, but overall floor price of all 5 projects were below $1 till Oct 10 and 24th, that DimensionX reached the highest floor price wirt 44 & $65.

    :telescope: Findings:

    The normalized chart right shows the distributed share of average price over 2022.

    Totally, average price of 4 projects (except DimensionX) decreased since 2022, but DimensionX, because of being newly, has risen average price since first sales date in early week of Sep.

    The following charts show the cumulative sales volume of collections in $USD over time and in an animated graph, the changes of average sales price over time have shown.

    :telescope: Findings:

    • According chart right, as excepted it seems more NFT traders tends to buy in floor price than sell.
    • AllDay as collection with highest sales count are the most interested by buyer rather than sellers.
    • Total count of who bought UFS_NFT collections was are 2x more than sellers.

    :hourglass_flowing_sand: Following section are belong to weekly top 5 collections with most floor price in $USD

    db_img
    Loading...
    Loading...

    :hourglass_flowing_sand: Five selected collections to assess. (==Topshot, AllDay, OlympicPin, UFC_NFT & DimensionX==)

    Loading...