Question:

Create a series of dashboards comparing wallet behavior for buying and selling NFTs on Flow compared to Ethereum and Solana. Is there more or less "whale" activity on Flow compared to each of the other chains?

What do "whales" tend to focus on in Flow? How common is "flipping" on Flow (selling within 24 hrs, within a week etc) compared to other chains, or do wallets tend to hold onto their NFTs? Are wallets more interested in new projects, or already existing projects on Flow?

Overview of essay:

This essay seeks to create the series of dashboards that presents the behavior of NFT purchasers on FLOW blockchain with Solana and Ethereum.

The activity of whales has been considered as a main part of this analysis.

The hold time of NFTs on various blockchains investigated, too.

Flow

• NFT sale

  flow.core.fact_nft_sales where TX_SUCCEEDED='TRUE' and CURRENCY='A.ead892083b3e2c6c.DapperUtilityCoin'

• Distribution of purchasers

  CASE WHEN PRICE <= 10 THEN 'a.below 10' WHEN PRICE > 10 and PRICE <=50 THEN 'b.10-50' WHEN PRICE > 50 and PRICE <=200 THEN 'c.50-200' WHEN PRICE > 200 and PRICE <=1000 THEN 'e.200-1000' WHEN PRICE > 1000 THEN 'f.above 1000'

• Whale

  distinct BUYER with PRICE>1000

Solana

• NFT sale

  from solana.fact_nft_sales where succeeded = 'TRUE' and currency='So11111111111111111111111111111111111111111'

• Distribution of purchasers

CASE WHEN sales_amount <= 1 THEN 'a. below 1' WHEN sales_amount > 1 and sales_amount <=5 THEN 'b. 1-5' WHEN sales_amount > 5 and sales_amount <=20 THEN 'c. 5-20' WHEN sales_amount > 20 and sales_amount <=100 THEN 'd. 20-100' WHEN sales_amount > 100 THEN 'e. above 100'

• Whale

distinct BUYER_ADDRESS with PRICE_USD>10000

Ethereum

• NFT sale

  from ethereum_core.ez_nft_sales where event_type = 'sale'and currency is USD

• Distribution of purchasers

CASE WHEN PRICE_USD <= 200 THEN 'a.below 200' WHEN PRICE_USD > 200 and PRICE_USD <=1000 THEN 'b.200-1000' WHEN PRICE_USD > 1000 and PRICE_USD <=2000 THEN 'c.1000-2000' WHEN PRICE_USD > 2000 and PRICE_USD <=10000 THEN 'e.2000-10000' WHEN PRICE_USD > 10000 THEN 'f.above 10000'

• Whale

distinct PURCHASER with SALES_AMOUNT>100

Approach of Hold NFT:

• Average time hold:

  avg(DATEDIFF(day,buy, sell)) as time_between for each purchaser of NFTs on blockchains

• Distribution of average hold time

case when time_between<1 then 'whitin 24 Hours' when time_between>=1 and time_between<7 then 'Under 1 week' when time_between>=7 and time_between<30 then 'Between 1 week to 1 month' when time_between>=30 then 'Over 1 month'

Key findings 1:

1. The count of NFT purchasers on Ethereum is more than Solana and Flow. The count of purchasers on Solana is larger than Flow.
2. On all blockchain most of the NFT users purchased on group with lowest price or amount of sale.
3. More than 70% of NFT sales on Flow and Solana occurred in the bucket with lowest price or sale amount.
4. For Ethereum, the distribution of sales count has more balance and about 44% of sales occurred on bucket with sale price below 200 USD.

Key findings 2:

1. As expected, the Top shot collection is the most popular NFT project on FLOW among whales. The next places are taken by PackNFT and AllDay.
2. The most popular NFT collection among Solana whales are Okay Bears and DeGods.
3. On Ethereum, the most popular NFTs among whales are opensea, the otherside and mutantapeyachtclub.
4. The dominate period of holding NFTs on FLOW is between 1 week to 1 month by near 60% of purchasers.
5. On Ethereum, 70% of users hold NFTs more than 1 month and its the dominant bucket.
6. The NFT purchasers on Solana hold NFTs over 1 month by 57.7% of purchasers.
7. The background of Ethereum and Solana prove this holding time in comparison with FLOW.