Try Quests to earn SOLSolana NFT Championship
Method
In the current dashboard I tried to investigate on mentioned metrics by using of solana.core.fact_nft_sales table in three timeframe such as Dayli, Weekly and Monthly in three time period such as: 3 past month for in daily, 6 past month in weekly and past year in monthly.
Also used solana.core.dim_labels and solana.fact_swaps tables to find the name of NFTs projects and SOL average price to find the sales volume over time in $USD, respectively.
In the last section the top 10 purchasers addresses for the Suites was found and you can change it by your own choice NFT project by header tape.
✍🏻 Conclusion
- Given that the Suites perform best across the board, they deserve to be named the Solana NFT champions. This is especially true in the recent weeks, when sales and revenue have skyrocketed.
- For a short period of time, Collectorz Club Gen1 was able to challenge the Suites' supremacy, but the Suites have since reclaimed the upper hand.
- The Suites have generated the vast amount of revenue (123k USD; 3.99k SOL) over the past three months.
- Next, the first generation of the Collectorz Club earns $22,000 US (592.2 SOL).
- These two sets have the highest average, median, maximum, and minimum values.
- Since August, the Collectorz club generation 1 has had the greatest daily average of any club.
- There has been a high volume of buyers and sellers in the Suites and Collectorz club gen 1.
About:
-
Author: HaM☰d
\
-
Discord: 0xHaM☰d#8391
\
-
Twitter: @arjmandi_hamed
\
-
Email: h_arjmandi2012@yahoo.com
There’s no shortage of sports-related NFTs on Solana, from Collectorz Club and Suites to Laidback Lions and Aaron Jones’ Showtime collection — but who can lay claim to the title of Solana sports NFT champion?
The Aims of Dashboard:
Looking at top collections, Include following metrics, and more:
> * Sales volume (daily/weekly/monthly) > * Total Sales Volume > * Daily Average Sales Price and 7-day moving average > * Total Unique Buyers > * Average Buyers/Day
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.
:telescope: Findings:
-
With a total of 123k USD (3.99k SOL) in sales over the past three months, the Suites by far account for the majority of the total sales volume.
-
Next, the Collectorz Club Generation 1 brings in just $22,000 USD (592.2 SOL).
-
Average/Median/Max/Min for these two collections are the most, too.
-
The Collectorz club gen 1 have had the highest average buyers/day since August.
-
The Suites and Collectorz club gen 1 have had most count of unique buyers and sellers, too.
:telescope: Findings:
Daily Average Sales Price and 7-day moving average
- The average daily selling price has been all over the place recently as different NFTs have been taking center stage on a regular basis.
- Sometimes it's the Suites, and sometimes it's the Collectorz Club Gen1
- It's easy to observe which team has been performing better over the past week based on the 7-day moving average; in Collectorz Club Gen1, the Suites and the Laidback Lions shared a similar moving average until August 24, 2022.
:bar_chart: Average Buyers/Day, Total Sales Volume, Total Unique Buyers
:telescope: Findings:
- With the exception of August 4–14, when the collectorz club saw a spike in daily sales volume, the Suites have dominated the daily sale volume for the majority of the past three months.
- However, the daily sales numbers paint a different tale, with collectorz club and Hockey Heroes dominating more days than the sale volume would indicate.
- On 10 October 2022, The Suites sold 519 SOL for a record-breaking in sales volume in SOL.
- Both the weekly and monthly figures for April 25, 2022, when sales hit 2,000 SOL, and January 20, 2022, when sales hit 64,740 SOL, are consistent with one another.
- Across all three time periods, there is NO discernible difference between the results for the number of unique customers and sellers or the total volume of sales.
:telescope: Findings:
Finally, in this sections I tracked top 10 addresses who bought most volume in $USD over the past 3 month for the Suites, but you can change it by your own choice by header tape.
HdtZ…tJ5t is the top address with most bought volume with $13.1K, that followed by D9Lx…MbYf with $7.8K.
Highest Average/Median/Max/Min and sales transactions count after HdtZ…tJ5t address is belongs to CfLg..CJVr and DU4E…WVPp, respectively