Methodology
==1==- 5 protocols were used for this review→
- Flow
- Solana
- Ethereum
- Algorand
- Optimism
==2==- Except for the part where the title has been used all the time, other tables and charts have been filtered for better understanding and insight in the following time frame→
where block_timestamp::date>='2022-04-23' and block_timestamp::date<='2022-09-12'
==3==- The following tables have been used to extract information→
flow.core.ez_nft_sales
solana.core.fact_nft_sales
ethereum.core.ez_nft_sales
flipside_prod_db.algorand.nft_sales
optimism.core.ez_nft_sales
==4==- The following code is used to extract the daily price of Solana→
select HOUR::date as day, avg(PRICE) as price_usd
from ethereum.core.fact_hourly_token_prices
where TOKEN_ADDRESS = '0xd31a59c85ae9d8edefec411d448f90841571b89c' group by 1
==5==-Average Sales Price/Day → Formula
Daily price/("Total number of days")*"Number of sales transactions"

Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Conclusion
- The Flow protocol is the lowest among other protocols in terms of the number of sales, the number of unique buyers, the dollar sales volume, and the average sales volume.
- As expected, the highest number of sales and dollar sales volume and average daily sales were for the Ethereum protocol
- The highest average daily dollar price was for the Algorand protocol
- The highest contribution number and average number of unique buyers among all protocols was on June 2, 2022
- The highest volume of sales among all protocols was on May 4
- The highest dollar volume of sales among all protocols was on May 1
- The highest number of sales and the average number of sales per day was on September 7, 2022
- Looking at the chart of average daily sales to price, after June 9, we see an increase in the price of the Algorand protocol
- Looking at the graph of the growth of the dollar sales volume, on June 11, 2022, we see the growth of the Algorand protocol