flipside

    Try Quests to earn SOLTry Quests to earn SOL
    Share

    NFT Wallet Behavior Comparison

    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?

    Intro

    in this bounty, the behavior of wallets buying NFT on Flow is compared to the wallets buying NFT on Solana and Ethereum.

    The metrics used in this bounty are:

    • Number of unique buyers and sellers
    • Number of whales on each network: On each network whales are considered as wallets made more than 800 transactions on NFT platform.
    • Tendency of whales on Flow based on NFT projects
    • Analyze hold time or sale within 24 hours or one week
    • Whales tendency on New or old NFT projects

    Method

    • Used table-→ NFT sale table

      1. Flow-→ flow.core.fact_nft_sales
      2. Solana-→ solana.core.fact_nft_sales
      3. Ethereum-→ ethereum.core.ez_nft_sales

    • Whales-→ count(tx_id) as txn>=800

    • NFT projects on Flow-→ flow.core.dim_contract_labels

    • Tendency to sale or hold (Flipping)-→ difference between buy and sell date

      1. Sale within 24 hours-→ datediff(day, a.block_timestamp, purchase_date) <= 1
      2. Sale within 1 week -→ datediff(day, a.block_timestamp, purchase_date) <= 6

    • New or old projects→ based on listing NFT on sale table

      1. when date < '2022-05-01' then 'Established NFT' when date >= '2022-05-01' then 'New projects'
    Loading...
    Loading...
    Loading...
    Loading...
    Loading...

    Outcomes:

    • because of the history of Ethereum network the number of buyers and sellers on this network are more than Flow and Solana.
    • The Number of unique buyers and sellers on Flow are 92460 and 93963, respectively.
    • The number of whales based on definition are more on Ethereum network compared to Solana and Flow.
    • The number of whales who made more than 800 transactions on Flow is about 244 unique wallets.
    • The Top NFT projects on Flow that whales are keener to participate are Top Shots (with 89.9%) and AllDay (184 whales).
    • The sale within 24 hour over time shown that on Ethereum users sold their NFTs within 24 hours more than other two.
    • Flow users are in the second rank of sale within 24 hour and more than Solana network.
    • The sale behavior on weekly basis follows the pattern of daily and Flow users sold their NFT in the same week more than Solana.
    • The tendency of whales on NFT projects based on their history shown in the bar-percentage chart and according to this chart, the Flow whales are participated more on Established NFT projects than New ones.
    Loading...