RaceDay NFTs 🏎️ → Image Source

RaceDay NFT is a first-of-its-kind motorsports NFT marketplace for race fans offering various collectibles - officially authenticated and verified on the Flow Blockchain.

🔗 Links

• Website
• Marketplace
• Twitter, Discord

✍️ Description of Work

In this dashboard, we will review NFT sales on RaceDay. For this, we examine the following:

• Sales Volume (USD):
  • Total Sales Volume (In USD)
  • Average Daily/Weekly/Monthly Sales Volume
  • Daily/Weekly/Monthly Sales Volume
• Number of Sales:
  • Total Number of Sales
  • Average Daily/Weekly/Monthly Number of Sales
  • Daily/Weekly/Monthly Number of Sales
• Daily Average Sales Price and 7-Day Moving Average
• Top 10 Buyers/Sellers
  • By Number of Sales/Purchase and Sales/Purchase Volume
• Top 10 NFTs
  • By Number of Sales and Sales Volume

• Secondary Sales vs. Mint Sales
  • Total and Monthly Secondary and Mint Sales
• NFTs Mint
  • Total and Weekly NFTs Mint
• Other collections RaceDay fans are buying
  • In Total and Over Time (Weekly)
• Purchase Frequency
• Average Number of NFTs held per wallet
  • For RaceDay Holders and in Other Collections for RaceDay Fans
• Average Purchase Price of NFTs held by RaceDay fans
  • Average Purchase Price for RaceDay Holders
  • In Other Collections for RaceDay Fans
• Social Mentions/Shares

🧠 Methodology

To deal with this bounty, we use the flow.core schema and the ez_nft_sales table. Based on the query below, we obtain the list of all NFT sales related to RaceDay and then perform all our calculations on this query:

🔍 Base Query One (RaceDay NFT sales by flow token):

select * from flow.core.ez_nft_sales 
    where nft_collection = 'A.329feb3ab062d289.RaceDay_NFT'
  	and tx_succeeded = true and currency = 'A.1654653399040a61.FlowToken' and block_timestamp <= current_date - 1

🔍 Base Query Two (RaceDay NFT sales by StableCoin):

select * from flow.core.ez_nft_sales
  	where nft_collection = 'A.329feb3ab062d289.RaceDay_NFT'
  	and tx_succeeded = true
  	and currency in ('A.3c5959b568896393.FUSD', 'A.ead892083b3e2c6c.DapperUtilityCoin')	
  	and block_timestamp <= current_date - 1

After this step, we get the average daily price of the Flow token and then we join with the Base Query One to get the selling price in USD and finally we union all Base Query Two and Base Query One and call it the ==🔍Final Query

• Mint Sales: To obtain Mint Sales, we consider the first sale of each NFT as Mint Sales

  select nft_id, min(block_timestamp) from final_race_day_sales group by nft_id
  

• Secondary Sales: To obtain Secondary Sales, we consider the second sale and sales after that as Secondary Sales

• Purchase Frequency:
  • Based on Day (method 1): For this method, we obtain the number of days from the first sale of each NFT Collection until now and also calculate how many days each NFT Collection has been purchased and sold for, then we divide these two numbers and get the Purchase Frequency we obtain for each NFT Collection
  • Based on the number of purchases per buyer (method 2): For this method, we calculate the number of purchases of each user and show its distribution

1 → Analysis of Sales Volume on RaceDay

✅ Observations

• The total Sales Volume of NFTs on RaceDay since inception is 29.7K USD
• The Average Sales Volume/Day on RaceDay is 88.3 USD
• The Average Sales Volume/Week on RaceDay is 550 USD
• The Average Sales Volume/Month on RaceDay is 2280 USD
• As you can see according to the Daily/Weekly/Monthly Sales Volume charts of RaceDay, the highest sales volume is related to April 2022 and April 20, 2022 (The third week of April).
• From April 2022 onwards, the volume of RaceDay sales has increased significantly

2 → Analysis of Number of Sales on RaceDay

✅ Observations

• The total Number of Sales of NFTs on RaceDay since inception is 4400 NFTs
• The Average Number of Sales/Day on RaceDay is 13 NFTs
• The Average Number of Sales/Week on RaceDay is 81.5 NFTs
• The Average Number of Sales/Month on RaceDay is 338 NFTs
• As you can see according to the Daily/Weekly/Monthly Number of Sales charts of RaceDay, the highest number of sales is related to May 2022 and Apr 28, 2022 (The last week of April)
• From April 2022 onwards, the number of RaceDay sales has increased significantly

3 → Daily Average Sales Price and 7-Day Moving Average

✅ Observations

• You can see that out of the 336 days that RaceDay have been sold, on 122 days the average price is above the 7-Day MA, that is, on 36% of the days.

4 → Analysis of Buyers on RaceDay

✅ Observations

• The total Number of Unique Buyer on RaceDay since inception is 516 Buyer== and the Average Buyers/Day on RaceDay is 1.5 Buyer
• As you can see according to the Daily/Weekly/Monthly Number of Unique Buyer charts of RaceDay , the highest Number of Unique Buyer is related to May 2022 and May 25, 2022 (The last week of May)
• Buyer 0x4af0e3f447afc87b has the largest volume and number of purchases on RaceDay

5 → Analysis of Sellers on RaceDay

✅ Observations

• The total Number of Unique Sellers on RaceDay since inception is 1008 Seller== and the Average Sellers/Day on RaceDay is 3 Seller
• As you can see according to the Daily/Weekly/Monthly Number of Unique Buyer charts of RaceDay , the highest Number of Unique Buyer is related to April 2022 and April 28, 2022 (The last week of April)
• Seller 0xc8b75d0745d3f284 has the highest volume and number of sales on RaceDay

6 → Top 10 NFT on RaceDay

✅ Observations

• The Top NFT Collections in terms of Sales Volume in RaceDay are RaceDay #77874, RaceDay #20563 and RaceDay #12130
• The Top NFT Collections in terms of Number of Sales in RaceDay are RaceDay #13787, RaceDay #25618 and RaceDay #29375

7 → Analysis of Mints on RaceDay

✅ Observations

• The total number of mints since inception is 131K
• The highest number of Mint is related to the months of Mar 2022 and Oct 2021

8 → Analysis of Secondary Sales vs. Mint Sales on RaceDay

✅ Observations

• More than 80% of the volume and number of sales on RaceDay is related to Mint Sales
• More than 70% of RaceDay buyers are from Mint Sales
• More than 90% of the number of sellers at RaceDay are from Mint Sales
• As you can see, from the beginning until now, and over time, the volume and number of Mint Sales has been more than Secondary Sales
  • Recently the activity of Secondary Sales has increased
  • Recently More purchases and sales have occurred in Secondary Sales.

9 → Cross-Project Comparative - Other collections RaceDay fans are buying

✅ Observations

• RaceDay fans have made the most purchases in terms of volume and number of purchases from TopShot, AllDay, UFC, Driverz , Rarible and Pack Collections respectively.
• As you can see, RaceDay fans have made all their purchases from TopShot until October 2021.
• Recently, the volume of AllDay purchases by RaceDay fans has increased

10 → Cross-Project Comparative - Analysis of Purchase Frequency On RaceDay and Other Collections 

✅ Observations

• Purchase Frequency for RaceDay is 1 Day
  • It means that almost every day buying and selling is done on RaceDay by its users
• You can see that RaceDay buyers almost every day in other collections that have the largest volume of purchases.
  • Purchase Frequency for TopShot, AllDay, UFC is 1 Day== → Top Volume Buying by RaceDay Fans
• In RaceDay, more users buy Only once or between 2 and 5 times
• In other collections, more users buy more than 50 times

11 → Cross-Project Comparative - Average Number of NFTs held per wallet

✅ Observations

• The total number of RaceDay Holders is 457 who hold 3630 NFTs
  • Average Number of NFTs held per wallet is 8 NFT for RaceDay
• The address 0x4af0e3f447afc87b holds the most RaceDay NFTs (501), followed by 0x0c4a39107850f89b with 469 NFTs.
• Out of 457 RaceDay Holders, almost 220 users also held NFTs of other collections
• These 220 users hold approximately 40.8K NFT
  • Average Number of NFTs held per wallet is 185 NFT for Other Collection

12 → Cross-Project Comparative - Average Purchase Price of NFTs held by RaceDay fans

✅ Observations

• Purchase Price for RaceDay Holders is 7.6 USD
• Purchase Price for RaceDay fans in other collections is 17.95 USD
• RaceDay fans buy other collections more expensive than RaceDay to hold NFTs

✔️ Conclusion

After reviewing RaceDay NFT, we got the following results:

> * The total Sales Volume of NFTs on RaceDay since inception is ==29.7K USD > * The Average ==Sales Volume/Day== on RaceDay is ==88.3 USD > * The Average ==Sales Volume/Week== on RaceDay is ==550 USD > * The Average ==Sales Volume/Month== on RaceDay is ==2280 USD > * The total Number of Sales of NFTs on RaceDay since inception is ==4400 NFTs > * The Average ==Number of Sales/Day== on RaceDay is ==13 NFTs > * The Average ==Number of Sales/Week== on RaceDay is ==81.5 NFTs > * The Average ==Number of Sales/Month== on RaceDay is ==338 NFTs > * From April 2022 onwards, the volume/number of RaceDay sales has increased significantly > * The total Number of Unique Sellers on RaceDay since inception is ==1008 Seller== and the Average ==Sellers/Day== on RaceDay is ==3 Seller > * The total Number of Unique Buyer on RaceDay since inception is ==516 Buyer== and the Average ==Buyers/Day== on RaceDay is ==1.5 Buyer > * From the beginning until now, and over time, the volume and number of Mint Sales has been more than Secondary Sales > * RaceDay fans have made the most purchases in terms of volume and number of purchases from TopShot, AllDay, UFC, Driverz , Rarible and Pack Collections respectively. > * Purchase Frequency for TopShot, AllDay, UFC is 1 Day > * Purchase Frequency for RaceDay is 1 Day > * The total number of RaceDay Holders is ==457== who hold ==3630== NFTs > * Average Number of NFTs held per wallet is ==8== NFT for RaceDay > * Average Number of NFTs held per wallet is ==185== NFT for Other Collection > * RaceDay fans buy other collections more expensive than RaceDay to hold NFTs

13 → Social Mentions/Shares

RaceDayNFT Twitter → Link

RaceDay NFT Podcast → Link

• RaceDayNFT related mentions on Twitter:

  • Tweet Link

  • Tweet Link

  • Tweet Link

  • Tweet Link → Image

    \

• RaceDayNFT related mentions on Twitter:

  \

  • Tweet Link
  • Tweet Link
  • Tweet Link
  • Tweet Link
  • Tweet Link
  • Tweet Link