Question:

Choose a NFT project from the following list and create a dashboard with the new Flipside dashboard layout that can refresh once a day highlighting at least 4 metrics of your choosing that helps show the "health" of the project. Note any noticeable trends or current events for the project. Highlight how liquidity is flowing in and out of the project and what types of buyers and sellers are interacting with the project.

\n

Introduction:

AURORY is a play-to-earn game and has a bunch of NFTs and goes the motto- “PLAY HATCH TRADE“. According to their official site, AURORY is a free-to-play, tactical, turn-based JRPG built on the Solana blockchain. Players are invited to explore a rich and diverse universe where they will travel across the worlds of Antik and Tokané as they complete quests, discover lost relics, defeat enemies, and compete against other players using creatures called “Nefties".

Summary:

In this dashboard we would look at various metrics which could define the health of an NFT Project.

We would be seeing the following charts:

• Daily and Average Sales made over time
• Cumulative Sales in the past 90 days
• Minimum Price for Aurory vs any NFT on Solana for the day
• Maximum Price for Aurory vs any NFT on Solana for the day
• Average Transactions per day on Solana vs Aurory over time
• Daily Transactions in the past 90 days Aurory vs Others
• Cumulative Transactions in the past 90 days Aurory vs Others
• Price paid per transaction in the ;past 90 days Aurory vs Others
• Total Sales normalised aurory vs others
• Average Sales normalised aurory vs others
• % dominance of Aurory in the past 90 days
• Top 10 Sales in the past 90 days
• After how many days was the NFT sold
• Average Sale Time After Days over time

We would be looking at all the charts first and then explain each of these charts

Methodology:

• To get the contracts on Aurory, the dim nft metadata was used and to get the daily and average sales over time, the solana.core.fact_nft_sales table was used and only those mints were selected which were for Aurory to get the daily , cumulative and average sales.
• To get the minimum price, maxprice, average transactions, daily and cumulative transactions, price paid per transaction, total sales normalised, average sales, % dominance of Aurory vs others, the fact_nft_sales was used again with one of the queries getting all the data for Aurory while one for everything but Aurory and both were grouped
• To get the top 10 sales, the sales amount was arranged in desc order for the past 90 days
• To get the average sale time after days, and the value of it over time, the mint was considered and the time of their sale was considered and joined with the next sale and the time difference between the two were calculated

Explanation, Insights & Conclusions:

The health of an NFT project is determined by the number of transactions, sales and user adoption in general. Other parameters could be how old users are transacting and how many old users are transacting, the % of total NFT market it has, the top 10 sales made recently, the value per transaction , the minimum/maximum price of the NFT currently.

At the time of analysis (Jul 18th, 2022):

• The daily sales are on a downtrend and the same can be seen for the average number of sales daily
• For the past 90 days about 580 SOL has been the average daily sale amount
• 52k+ SOL has been transacted only in the past 90 days
• About 35-60 SOL is the recent average of the maximum price at which an Aurory NFT was sold
• Less than 15 transactions have taken place per day on an average in the past 90 days
• The minimum price at which an Aurory was sols is less than 30 SOL in the past 90 days
• About 1150 transactions have taken place in the past 90 days as compared to about 4.67M nft transactions on Solana
• The value per transaction has gone down from about 52 SOL at one point to about 45 SOL
• Aurory accounts for about 0.5% by total NFT sale volume down from 1.5%
• There are 7 sales in which Aurory was sold above 100 SOL, 2 of which had been above 250 (299 and 280 respectively)
• About 0.4% of all sales went through Aurory
• About 42 days is the average age currently after which an Aurory was sold and this has been on an upward trend implying a lack of swappers on Aurory (Swappers are those who buy and sell instantly for a profit)

Conclusions:

It can be concluded that Aurory has also seen an impact of the current market circumstances and has seen a downfall from sales to transactions and on almost everything including it’s floor price and the sale of the costliest NFTs in the past 90 days