Introduction

In this dashboard we will compare wallets that transacted with an NFT on Flow, Ethereum, Solana.

We will see number of their transaction per day and per week. Also number of NFT buyers and sellers per day and per week.

Then we will look at NFT sale volume on each blockchain over time.

Next we will find NFT whales on each blockchain and do the same above analysis just for whales.

Next we will compare number of transactions had performed by whales over time.

Then we will look at NFT filliping duration on Flow.

In the following six charts we can see number of transaction, buyers and sellers per day since April 20, 2022 where we have date for all three blockchains.

We can see number of NFT transactions per day is decreasing on Flow and number of NFT transactions on Ethereum and Solana is very close.

Total number of NFT transactions since April 20, 2022 is about 4.88M for Ethereum, 4.69M for Solana and 2.23M for Flow.

Method

To do this analysis I have used flow.core.fact_nft_sales table on Flow, ethereum.core.ez_nft_sales table on Ethereum and solana.core.fact_nft_sales table on Solana to find number of NFT transactions and number of NFT buyers and sellers over time.

In the following three charts we can see number of transaction, buyers and sellers per week.

We can see Ethereum NFT users are much higher than others.

Also we can see number of NFT buyers on Ethereum is more than Solana and Flow since April 20,2022.

Total number of NFT buyers on Ethereum is about 2.51M, 1.47M on Solana and 530.7K on Flow.

Also we can see number of NFT sellers on Ethereum and Solana is very close and more than Flow since April 20,2022.

Total number of NFT sellers on Ethereum is about 4.88M, 4.69M on Solana and 2.23M on Flow.

Volume analysis

To do this part first I need to know FLOW, ETH and SOL price in USD to find sale volume. To find FLOW (or other token) price I have used flow.core.fact_prices table and filter the result by token that used to trade NFTs on Flow, In other words I had added this condition to query where token_contract in (select distinct currency from flow.core.fact_nft_sales).

To find SOL price I have used ethereum.core.fact_hourly_token_prices table and limited the token_address to 0xd31a59c85ae9d8edefec411d448f90841571b89c.

To calculate Flow NFT sales volume we can sum up the amount of FLOW (or other Flow tokens) multiplied by token price in USD on the date that transaction was performed.

To calculate Ethereum NFT sales volume we can sum up price_usd field.

To calculate Solana NFT sales volume we can sum up SOL amount of transaction multiplied by SOL price in USD on the date that transaction was performed.

Whale analysis

For this part I have Compared sale volume of whales on each blockchain and number of transactions performed by whales.

To find whales first I have calculated buy volume and sale volume for all NFT users. Then I have subtracted sale volume by buy volume to get user’s revenue of NFTs. And finally I have picked up 50 wallet addresses that had the most revenue of NFTs as whales.

The following charts compare NFT sale volume in USD on Ethereum, Solana and Flow. We can see the sale volume of Ethereum whales is much higher than Solana and Flow. \n

The following charts compare NFT sale volume per day for whales since April 20, 2022 where we have date for all three blockchains.

In the following charts I had compared number of transactions performed by whales per day.

The left chart shows transactions that a whale purchased an NFT and the right charts shows transactions that a whale sold an NFT.

Filliping

The following pie chart shows that 58.7% of Flow NFTs had held for less than one week.

Conclusion

• Number of Ethereum NFT users are much higher than Solana and Flow.
• Number of NFT transactions per day is decreasing on Flow since April 20, 2022.
• Number of NFT transactions on Ethereum and Solana was very close together since April 20, 2022.
• Total number of NFT transactions since April 20, 2022 is about 4.88M for Ethereum, 4.69M for Solana and 2.23M for Flow.
• Number of NFT buyers on Ethereum is more than Solana and Flow since April 20, 2022.
• Total number of NFT buyers on Ethereum is about 2.51M, 1.47M on Solana and 530.7K on Flow.
• Number of NFT sellers on Ethereum and Solana is very close and more than Flow since April 20,2022.
• Total number of NFT sellers on Ethereum is about 4.88M, 4.69M on Solana and 2.23M on Flow.
• 58.7% of Flow NFTs had held for less than one week.

Discord: pouya_22#1428