What is an NFT 🖼️? → Source

The 'non-fungible' part of NFT means that it is completely unique and cannot be directly replaced with something else.

Unlike in currency where exchanging one note of equal value for another would leave you with the same amount, an NFT has its own unique value which is subjective. This could be, for example, a historic painting or a vintage baseball card. No matter how many copies exist, there will only ever be one original version. NFTs are assets that exist in the digital world with no physical version, and digital tokens serve as the certificate of ownership for these assets.

Records of who owns what NFT is stored on the blockchain, supported and kept safe by the ledger.

📝 Description of Work

This round we are going to be dissecting NFT activity on multiple chains such as Ethereum, Algorand, Flow, Solana, Near. The goal is to create a dashboard to let people compare NFT activities and sales volumes across chains. First, we compare the chains together, then we analyze each of the chains separately.

1️⃣ → To compare the cross chain, we check the following:

• Review and analysis of NFT sales volume (USD) on each chain.
  • For this metric, we calculate the NFT sales volume in each chain in USD.
• Review and analysis of NFT number of sales on each chain.
  • For this metric, we calculate the number of NFT sales per transaction and the total number of transactions. A single NFT transaction may involve the purchase of several different NFT IDs.
• Review and analysis of NFT ==number of buyers on each chain.
• Review and analysis of NFT ==number of marketplace on each chain.
• Review and analysis of NFT ==number of collections on each chain.
  • For this metric, we count the number of unique collections from each chain on which purchase transactions were made
• Review and analysis of number of unique NFT sold on each chain.
  • For this metric, we count the number of unique NFT IDs from each chain that have been bought and sold.
• Review and analysis of average sales price per sales on each chain.
  • For this metric, we calculate the average sale price in each NFT sale transaction for each chain. In other words, we show how many USD were spent on average in each NFT purchase transaction.
• Review and analysis of average sales price per NFT on each chain.
  • For this metric, we calculate the average amount of USD spent for each NFT
• Review and analysis of number of unique NFT sold per buyer on each chain.
  • For this metric, we calculate the number of unique NFTs that each unique buyer buys on average
• Review and analysis of average sales volume per day (average sales volume/day) on each chain.
  • For this metric, we calculate the average volume of NFTs sold per day

2️⃣ → To deep dive into each chains, we check the following:

The things we check in the first section to compare the chains, in this section we check separately for each chain, then we check the following for each of the chains:

• Review and analysis of marketplace by number of buyer, sales volume and number of sales on each chain.
• Review and analysis of distribution of NFT sales price on each chain.
• Review and analysis of top 10 collections by sales volume and number of sales on each chain.
• Review and analysis of new and old buyer per day on each chain.
• Review and analysis of top 10 buyer by sales volume on each chain.

🧠 Methodology

To deal with this bounty, we use ethereum.core, algorand.nft, solana.core, near.core and flow.core schemas and ethereum.core.ez_nft_sales, algorand.nft.ez_nft_sales,

algorand.defi.ez_price_pool_balances, algorand.nft.ez_nft_sales_fifa, solana.core.fact_nft_sales, solana.core.fact_token_prices_hourly, solana.core.dim_labels, near.core.fact_receipts, near.core.fact_prices, flow.core.ez_nft_sales and flow.core.fact_prices tables.

▶️ Well, now we will walk you through the different parts of this dashboard and then I will check how to get NFT sell transaction data from each chain separately.

We have considered two sections to address this dashboard. Part One → Comparing Chains Against Each Other, Part Two → Examines and Analyzes Each Chain Separately

Part One

• In this section, you can compare each of the two chains you want using the {Chain_Comparison} and {Days} parameters and click the Apply All Parameters button to have the results update based on your selection. You can also check all chains together.

Part Two

• In this section, you can examines and analyzes any single chain you want to check using the {Single_Chain} and {Days} parameters and click the Apply All Parameters button to display the results for the chain and timespan you want.

• To apply the parameters, first log in to flipsidecrypto, then select the desired parameters in the parameters section and finally click the Apply All Parameters button to have the results updated for you.
• You can choose to use the =={Days}== parameter to show you data from the ==Last few Days
• All results are updated every day
• This dashboard is updated according to the parameters selected by the reader, so we perform our analysis based on the last 30 days on each of the chain and do not analyze the results numerically

Now I will check how to get each chains NFT sell transaction data separately.

NFT Sales transactions on Ethereum

To find NFT sales transactions on Ethereum, we use the ez_nft_sales table. The price_usd field represents the selling price in USD of each NFT in this table. We discard the transaction etherscan because it is not a real transaction: → cryptonews

• Because this transaction is a type of POS Wash Trading. For more information read this Dashboard on POS Wash Trading provided by Pinehearst-1947.

In NFT sales transactions in Ethereum, in each single transaction, several different NFTs (tokens) may be purchased by the buyer at the same time, such as this transaction: → etherscan

select block_timestamp,tx_hash,buyer_address,
       platform_name,nft_address,project_name,
       tokenid,price_usd
from ethereum.core.ez_nft_sales 
where price_usd < 50000000
and price_usd > 0 and price_usd is not null

NFT Sales transactions on Algorand

To find NFT sales transactions on Algorand, we use the ez_nft_sales table. The total_sales_amount field represents the selling price in ALGO of each NFT in this table. This table shows 0 prices for the fifa collect collection, so we use the ez_nft_sales_fifa table to get the sale price of the fifa collect collection NFTs. Also, in Algorand, it is possible to purchase multiple NFTs (from a specific NFT) in a simultaneous transaction (which is indicated by the number_of_nfts field). So we use sum(number_of_nfts) for the number of NFT sales in Algorand. Also, in Algorand, several different types of NFTs are purchased in a single transaction (their tx_group_id is the same), but the amount field shows a number for each of them, while only one amount was spent for all NFTs purchased. So we first get these transaction types separately, then we divide the amount by the number of NFT purchases to get the actual price of each NFT. → See Query

NFT Sales transactions on Solana

To find NFT sales transactions on Solana, we use the

fact_nft_sales table. The sales_amount field represents the selling price in SOL of each NFT in this table. also we use the fact_token_prices_hourly table to get the daily price of SOL and join the NFT sell trades query result to calculate the NFT sell price in USD. Also, the Mint field displays the NFT ID sold in each transaction, so to get the collection of each NFT, we join the result obtained with the dim_labels table. In Solana, we display the magic eden v1 and magic eden v2 marketplaces as one marketplace with the name Magic Eden.

select 
    	block_timestamp, tx_id,purchaser,
  		marketplace,mint,sales_amount
  	from solana.core.fact_nft_sales
  		where succeeded = true 
  		and sales_amount_sol > 0 
        and sales_amount_sol is not null

NFT Sales transactions on Flow

To find NFT sales transactions on Flow, we use the ez_nft_sales table. The price field represents the selling price in FlowToken==, ==REVV and Stablecoin==, of each NFT in this table. We divide the calculations into two parts. Transactions paid with Stablecoins and transactions with FlowToken and REVV, then taking the daily price of REVV and Flow tokens, we convert the prices to USD. In flow, there are two types of marketplace named NFTStorefrontV2 and NFTStoreFront, which are actually contract addresses and not marketplaces, and we display them as StoreFront Marketplace.

• See Query

NFT Sales transactions on Near

To find NFT sales transactions on Near, we use the fact_receipts table. In this table, first, we modify the logs field using the following command in json format:

replace(logs[0], '\\') as results_logs,
check_json(results_logs) as check_logs

Then, using the try_parse_json function, we test its json format so that we can separate different parts of json from the logs field:

try_parse_json(results_logs) as parse_logs,

Now, in the parsed json, each part represents a part of the NFT purchase transaction:

parse_logs:type as type → It shows the type of transaction that for NFT purchase, this value should be resolve_purchase.

parse_logs:params:buyer_id → It shows the buyer address

parse_logs:params:nft_contract_id → It shows the NFT collection

parse_logs:params:token_id → It shows the NFT ID

parse_logs:params:price / pow(10, 24) → It shows the price in NEAR → See Query

Part One → Comparing Chains Against Each Other by Apply =={Chain_Comparison}== and =={Days}== Parameters

👉 → Review and analysis of NFT sales on selected chains within selected timeframes

> In this section, you can see the chart related to NFT sales on each chain in overall and daily, which includes number of sales, NFT sales volume, average sales price, number of buyer and etc. In this section, you can see the results based on your choice by changing the {Chain_Comparison} and {Days} parameters.

Part Two → Analyzes Each Blockchain Separately by Apply =={Single_Chain}== and =={Days}== Parameters

1️⃣ → Review and analysis of NFT Sales on selected single chain within selected timeframes

> In this section, you can see the chart related to NFT sales on single chain in overall and daily, which includes number of sales, NFT sales volume, average sales price and etc. In this section, you can see the results based on your choice by changing the {Single_Chain} and {Days} parameters.

2️⃣ → Review and analysis of NFT Buyers on selected single chain within selected timeframes

> In this section, you can see the chart related to NFT buyer on single chain in overall and daily, which includes number of buyer, number of NFT sold per buyer, daily new and old buyer and top 10 buyer by sales volume. In this section, you can see the results based on your choice by changing the {Single_Chain} and {Days} parameters.

3️⃣ → Review and analysis of NFT Marketplace on selected single chain within selected timeframes

> In this section, you can see the chart related to NFT Marketplace on single chain in overall and daily, which includes number of marketplace , sales volume, number of sales and number of buyer by marketplace. In this section, you can see the results based on your choice by changing the {Single_Chain} and {Days} parameters.

4️⃣ → Review and analysis of NFT 10 Collections on selected single chain within selected timeframes

> In this section, you can see the chart related to NFT 10 Collections on single chain in overall and daily, which includes number of collections , top 10 collections by sales volume and distribution of top collections by sales volume. In this section, you can see the results based on your choice by changing the {Single_Chain} and {Days} parameters.

5️⃣ → Review and analysis of NFT Top 10 Sales on selected single chain within selected timeframes

> In this section, you can see the chart related to NFT Top 10 Sales on single chain in overall and daily, which includes top 10 sales with their details. In this section, you can see the results based on your choice by changing the {Single_Chain} and {Days} parameters.

✔️ Final Conclusion

In this dashboard, we have investigated the sale of NFT on Ethereum, Algorand, Flow, Solana and Near chains. In this dashboard, in the first part, we showed comparisons between chains, by modifying the {Chain_Comparison} parameter, you can check different chains together in terms of all criteria, and by modifying {Days}, you can determine the time frame for displaying the results, and in the Second section, we did an in-depth look at each chain, by applying the {Single_Chain} parameter, you can select the desired chain, and by modifying {Days}, you can determine the delay in displaying the results. According to the results obtained in the last 30 days:

Cross chain comparisons:

• You can see that the Ethereum blockchain has much higher stats than other blockchains in terms of NFT activity and sales by all criteria examined.
  • In terms of sales volume → Ethereum >> Solana >> Flow >> Algorand >> Near
  • In terms of number of sales → Ethereum >> Solana >> Flow >> Algorand >> Near
  • In terms of number of buyer→ Ethereum >> Solana >> Flow >> Algorand >> Near
  • In terms of average sales price → Ethereum >> Solana >> Flow >> Algorand >> Near
  • In terms of unique NFT sold → Ethereum >> Solana >> Flow >> Algorand >> Near
  • In terms of number of NFT sold per buyer → Flow >> Algorand >> Ethereum >> Solana >> Near

You can see that Ethereum outperforms other blockchains in most metrics. Also, the sales volume of NFTs shows a downward trend in the last thirty days.

Examining blockchains separately:

Ethereum

• The total volume of NFT sales on Ethereum in the last 30 days is 679M USD with 1.33M sales also the total number of buyers is 191.6K and 945K different NFTs were sold
• The average selling price per NFT was 719 USD
• In the last 30 days, the volume of NFT purchases shows a decreasing trend, but there is no noticeable change in the number of sales and the number of buyers.
• The most NFT buying activity was on the opensea marketplace and the largest volume of purchases was from the Art Gobblers collection

Algorand

• The total volume of NFT sales on Algorand in the last 30 days is 920K USD with 38.4K sales also the total number of buyers is 3630 and 33.4K different NFTs were sold
• The average selling price per NFT was 27.5 USD
• On November 18, the volume of sales of NFTs has grown significantly
• In the last 30 days, the volume of NFT purchases shows a decreasing trend, but there is no noticeable change in the number of sales and the number of buyers.
• The most NFT buying activity was on the Rand gallery marketplace and the largest volume of purchases was from the FIFA-genesis collection

Solana

• The total volume of NFT sales on Solana in the last 30 days is 111.84M USD with 998K sales also the total number of buyers is 147.89K and 526.746K different NFTs were sold
• The average selling price per NFT was 212.34 USD
• On November 4, the volume of sales of NFTs has grown significantly
• In the last 30 days, the volume of NFT purchases shows a decreasing trend, but there is no noticeable change in the number of sales and the number of buyers.
• The most NFT buying activity was on the Magic Eden marketplace and the largest volume of purchases was from the y00ts: mint t00bs collection

Near

• The total volume of NFT sales on Near in the last 30 days is 127.61K USD with 3843 sales also the total number of buyers is 1361 and 3843 different NFTs were sold
• The average selling price per NFT was 35 USD
• On November 23, the volume of sales of NFTs has grown significantly
• In the last 30 days, the volume of NFT purchases shows a decreasing trend, but there is no noticeable change in the number of sales and the number of buyers.
• The most NFT buying activity was on the Paras marketplace and the largest volume of purchases was from the spin-nft collection

Flow

• The total volume of NFT sales on Flow in the last 30 days is 9.15M USD with 502K sales also the total number of buyers is 26K and 397K different NFTs were sold
• The average selling price per NFT was 23 USD
• On November 18, the volume of sales of NFTs has grown significantly
• In the last 30 days, the volume of NFT purchases shows a decreasing trend, but there is no noticeable change in the number of sales and the number of buyers.
• The most NFT buying activity was on the StoreFront marketplace and the largest volume of purchases was from the Top Shot collection

According to the obtained results, it was found that users pay more for Ethereum NFTs (Ethereum NFTs are more expensive) and then for Solana, Near, Flow and Algorand, with a slight difference, they are third to fifth.

The data is updated daily and these results change. These results are for 2022-11-30.

🔗 Links

• Tweet link for this dashboard: Flipside World Cup Round of 16: NFT Sales Comparison By Chain
• Discord: Yousefi_1994#7190
• Twitter: Yousefi_1994
• Related link→ The dashboards of the previous rounds:
  • Flipside's World Cup Kick Off: Gas Guzzlers
  • Flipside World Cup Round of 32 - USDC Transfers