Introduction

Although the world of NFT is very attractive and can bring very big profits, at the same time, it can enter into a hard and exhausting winter that will cause losses to many holders. Some holders sell their NFTs at a loss, but some remain holders while enduring huge unrealized losses. In this dashboard, we go to the second category to see what conditions these holders are in and The loss they have suffered or which holders have the highest unrealized loss.

what is unrealized loss?

> An unrealized loss is a "paper" loss that results from holding an asset that has decreased in price, but not yet selling it and realizing the loss

Method

I used two tables in this dashboard which are ethereum.core.ez_nft_sales and

ethereum.core.ez_nft_transfers.

the holders here are who bought a NFT token and didn’t sell or transferring that token so all the addresses that you see here are the current holders.

We assumed the average price in a last week as the current price or buy price

I selected some of the popular collections, and you can see the stats for each one of them by selecting from the above of the dashboard

here we used all available data in flipside without Time/date limitation

Conclusion

1. in some collections the total unrealized loss amount suppressed even 1b USD

2. most of the NFTs collection holders are having unrealized loss

3. the average unrealized loss per address for some collections reached even higher than 100K USD

4. there are some holders among the collections that have more than 10M USD unrealized loss

5. who spent most on buying had more unrealized loss But this does not mean that their loss percentage is higher

6. most of the tokens that are in loss bought before May

7. most of the tokens in hold are in higher than 90% unrealized loss percentage

8. April and May month were bad months to but NFTs

9. BTC/ETH price and in overall crypto condition had a high impact on unrealized loss amount

10. increase in loss and decrease in NFTs Volume at the same Time is bad news for NFTs world and maybe due to that becomes more difficult to sell

    
    \

Overview

here, we aim to provide these topics:

1. Total unrealized loss and how did changed over Time
2. Total Holders in loss and how did changed over Time
3. average loss per address
4. Top 10 holders in loss and how their unrealized loss changed over Time
5. Top 100 holders in loss stats
6. Top 100 Tokens in loss stats
7. correlation between unrealized loss and date of buying
8. correlation between Total loss amount and ETH price/BTC price/ALL NFTs Volume

Thanks For your time

Discord and Twitter: Abbas_ra21

date: 2022-10-15

Picture source: Link

Observation

• we can see some holders among the collections that have more than 10M USD unrealized loss, for example in BAYC collection the highest unrealized loss that recorded for one address is 11.04M USD which is a big number.

  \

• we can take a look at Top 10 holders and their unrealized loss over Time also which gives us a good view

  \

• Usually who spent most on buying had more unrealized loss But this does not mean that their loss percentage is higher

  \

Observation

• The increase in losses coincides with a sharp decline in NFTs market volume, and this may reduce liquidity So that it becomes more difficult to sell
• It is clearly known that the state of the crypto market has a great impact on the losses, we can see that in old collections such as Cryptopunk, the beginning of the price decrease is almost simultaneous with the decrease in the price of Bitcoin and Ethereum, in the case of newer collections, it may start The decrease in their price or the increase in unrealized loss happened with a little delay and in the middle of the decrease in the prices of Ethereum and Bitcoin.

Observation

• The highest percentages of losses and the highest losses are usually related to tokens that were purchased on early dates

  \

• among the collections that you can select from above, mostly their tokens are having more than 90% unrealized loss which is very high number

  \

• most of the tokens that are in loss bought before May

Observation

• almost in all collections, April and May month is the months that if you bought a NFT and did hold it until now you will have high unrealized

  \

• The earlier the date comes, the less the loss, and the reason for that is clear and obvious, because the person who buys deep will suffer less loss.

  \

• in some old collection like cryptopunks the highest unrealized loss belongs to late 2021

  \

• with all that we can say that for each collection the month that had the highest loss is the month had the highest hype and price

Observation

• in some collections the total unrealized loss amount suppressed even 1b USD like BAYC or cryptopunks.

  \

• in the majority of collections like the total amount of unrealized loss started to increase sharply and suddenly from May or April, the first reason of which can be the sharp decrease in the prices and condition of NFTs markets.

  \

• most of the NFTs collection holders are having unrealized loss

  \

• the average unrealized loss per address for some collections reached even higher than 100K USD