Total Transactions of NFT Sales

Total Number of Buyers of NFTs

Introduction

What is NFT?

NFT means non-fungible tokens (NFTs), which are generally created using the same type of programming used for cryptocurrencies. In simple terms these cryptographic assets are based on blockchain technology. They cannot be exchanged or traded equivalently like other cryptographic assets.

You will read in this dashboard

In this dashboard, I reviewed and compared NFTs in 4 chain: Solana, Flow, Optimism and Arbitrum.

The metrics that will be reviewed in this dashboard:

• Total Sales
• Total Unique Buyers
• Total Volume
• Average Sales/Day
• Average Buyers/Day
• Average Sales Price/Day

Method

I used the day parameter to compare chain NFTs,by default it is the last 90 days, enter the number of past days and compare it to today.

My method to get the metrics in 4 chains(Solana, Flow, Optimism and Arbitrum) is as follows:

• Solana=> There is no price in USD in solana.core.fact_nft_sales table, I obtained the dollar price of NFTs from the solana.fact_swaps table with filter swap_from_mint in ('So11111111111111111111111111111111111111112') and

  swap_to_mint in ('7kbnvuGBxxj8AG9qp8Scn56muWGaRaFqxg1FsRp3PaFT','Ea5SjE2Y6yvCeW5dYTn7PYMuW5ikXkvbGdcmSnXeaLjS','Es9vMFrzaCERmJfrF4H2FYD4KCoNkY11McCe8BenwNYB', 'EPjFWdd5AufqSSqeM2qN1xzybapC8G4wEGGkZwyTDt1v', 'USDH1SM1ojwWUga67PGrgFWUHibbjqMvuMaDkRJTgkX') (UXD, PAI, USDT, USD Coin, USDH). Then I joined with the sol_token_price table by date.

• Flow=> First, from the tablelow.core.ez_nft_sales and with filter currency != 'A.1654653399040a61.FlowToken' Based on stable coins, I got the dollar price of NFTs, And then with the filter currency = 'A.1654653399040a61.FlowToken' and joining with the flow.core.fact_prices table, I got the dollar price of NFT based on the flow, and finally I union both.

• Arbitrum= > First, I joined the two tables arbitrum.core.fact_event_logs and arbitrum.core.fact_transactions And I filtered based on event_inputs:from != '0x0000000000000000000000000000000000000000'and

  event_inputs:to !='0x0000000000000000000000000000000000000000'And I got the transaction of NFTs, then with the ethereum.core.fact_hourly_token_prices table I joined by date and got their volume in dollars.

• Optimism=> I used the optimism.core.ez_nft_sales table and obtained the mentioned metrics.

  \

Total and Average Volume of NFT Sales

Conclusion

This analysis is a comparison between NFTs of 4 chains (Solana, Flow, Arbitrum and Optimism). With the change of days in the parameter section, the values will change and we cannot talk about the charts.

But what is clearly seen in the last 3 month

• The number of Solana NFT transactions is higher than the other 3 chains.
• In the last 3 months, the sales volume of NFT Solana is slightly higher than Flo, and it can be said that the sales volume of NFT Flo has increased in the last 3 months.

Resources

I used parts of previous Solana dashboards scripts to calculate Solana's NFT volume.(banbannard#7857)

Last_day Parameter

In the parameter section, you can enter the number of previous days to see the statistics

THANK YOU FOR READING!

Twitter: mohsen.dastpeyman

Discord_id: mohsen#4796