Try Quests to earn FLOWIntroduction
Dapper Labs was founded in 2018 in Vancouver, Canada by Roham Gharegozlou. This company uses blockchain technology to create new opportunities for users around the world. Dapper Labs is the creator of the Flow blockchain system. Flow supports high performance ecosystems such as apps and games. Artists or bands can use FLOW tokens to create new and unique ways for their fans.
Games and players can create value for their assets and identity. Platforms and sports fans around the world can trade digital memorabilia in a verified, authentic and copyright-compliant manner.
Method
-
contract and summary on how I collected the data:
for the most of these graphs I only used NFT_sale table but for holders stats I had to use events table to track NFT transfer transaction for more accurate numbers.
-
our approach for answering the bounty questions:
-
we have 6 sections which are Swap and Transcations:
-
Price:
Here we have shown the lowest, highest and average price in different time periods such as the last 6 months or the last 3 months for a better understanding of the general price changes and in addition we have the floor, high and daily origin prices. We have also shown the top ten tokens of each collection based on the price of the last sale in a graph so that we have a better understanding of the price in this collection.
-
Volume:
In addition to the usual charts such as daily volume or total, we have put the average volume per day or the average volume for each buyer. And we also categorized the trading volume based on trading time (night/day) or trading day (weekend/other days).
-
distribution of Sale size:
In these graphs, there is an answer to the question of what size has the most sales number
-
Sales number:
like Volume, beside usual charts we also categorized the sales number based on trading time (night/day) or trading day (weekend/other days).
-
Unique buyers number:
we have daily and total number of unique buyers, also we have average buyers number per day
and like sales number and Volume we categorized the stats base on time and day name
-
Holders:
The number of holders, the holders who have the most tokens in their wallets, the distribution of the number of NFTs in the wallet holders is from the information that we have provided for you in this section, and in addition, we divide the total number of tokens held by the number of holders. We reached an important ratio that gives us the average holding of each user
-
some necessary definition base on provided data:
==Floor Price==: Here, I preferred to not consider the lowest traded price as the floor price, which has a relatively high error and cannot be considered as the floor price, because it is possible to conduct sales with a low price, but these sales are very few and does not have a high effect. that's why I used percentile_cont(0.1).
> PERCENTILE_CONT is an inverse distribution function that assumes a continuous distribution model. It takes a percentile value and a sort specification, and returns an interpolated value that would fall into that percentile value with respect to the sort specification
when I use this function it will give me the lowest price that is higher than 10% of all prices in that day, Therefore, with this method, we can avoid outlier prices as much as possible
I used all the available data on flipside
I included 10 collections in this dashbopard
Findings
- recently the floor price of top shot is around 1 USD
- Pack NFT and flunks have s a higher floor price than others recently
- all day and top shot are almost the same in daily average price, but the floor price of all day is a little higher piece
- Top shot Volume is more than 1B USD which is a big number
- all the NFTs recently recorder very low Volume
- in most collections the Volume in Night time is higher
- Topshot has almost 524K holders higher by far than others and every holder holds 45.6 token in average