FLOW NFT Floor Tracker

    Introduction


    What Is Flow?

    Flow is a blockchain network designed to enable transactions that are fast and cheap. The flow blockchain is a competitor to ethereum, another blockchain platform that supports a native currency plus an ecosystem of blockchain-based projects.

    The flow blockchain was developed by Dapper Labs. Dapper Labs is also the team behind CryptoKitties, a blockchain-based game to buy, sell, create, and trade digital cats.

    The flow blockchain was launched in conjunction with Dapper Labs’ NBA Top Shot, a blockchain-based digital collectibles marketplace that specializes in basketball cards. According to Dapper Labs, as of May 2022, the flow blockchain has processed more than 20 million NBA Top Shot transactions worth over $1 billion.

    Flow was first built as a tool for Dapper Labs’ game developers to meet their own needs, and later launched publicly to support other decentralized applications.

    The coin supply is not capped, although the inflation rate of FLOW—the annual rate at which new tokens are generated as rewards leading to an increase in supply—is currently limited to 3.75%.

    Special Features of Flow

    The flow blockchain was designed to support games and consumer applications, and can potentially process the transactions of millions of active users. Games, collectibles, and related apps can be supported by the flow blockchain.

    By supporting interaction among smart contracts, the flow blockchain is positioned to allow for a large number of applications on its platform, much like the ethereum blockchain.

    Flow also claims it is more efficient than other blockchains because the job typically done by each miner—computers that work to verify transactions and maintain the blockchain’s records—is divided across five nodes. Such segmentation, according to Flow, reduces redundancy in the work done by each node and results in faster throughput.


    Source:

    db_img
    db_img

    Question


    Let’s sweep some floors. Build a dashboard that 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.

    Methodology


    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

    Last Date Floor Price


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

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

    Findings


    The left chart 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 left chart 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.

    Findings


    • According right chart, 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.

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

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

    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.

    Five Selected Collections to Assess. (Topshot, AllDay, OlympicPin, UFC_NFT & DimensionX)

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

    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.

    Findings


    The normalized left chart 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.

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

    Sales Volume, Average/Max & Floor Price by Months of Year

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

    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.
    db_img