Try Quests to earn FLOWNFT Wallet Behavior Comparison
Questions :
> ### 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?
Metods :
> ### For this bounty we used below tables :
>
> > flow.core.fact_nft_sales
> >
> > solana.core.fact_nft_sales
> >
> > ethereum.core.ez_nft_sales
> >
> > flow.core.fact_transactions
> >
> > flow.core.fact_events
> >
> > flow.core.dim_contract_labels
>
> ### Our data in Flow table had started from 2022-04-20 so we compared this three Blockchains from this date till today.
>
> ### In this bounty we took those who sell and buy more than 500 NFT , as whales
>
> \
As you can see total users in last 3 month in Ethereum NFTs are much more than Solana and Flow , and Solana and Flow almost had equall NFT users
But in term of whales this is diferrent because whales in Flow almost are equall to whales in Ethereum , and whales activity in Solana in very low
In this two chart you can see type of activities done by whales and their contrats
As you can see after Flow Token and Flow Fees Top Shot is most used contract
***We used ***DATE_PART(DAY,BLOCK_TIMESTAMP) ***function for each ***NFT_ID to see in what period of days, they were sold, and we take 1 day periods as daily flipping, and lower than 7 day periods as weekly flipping, if there was no sell in one month, we counted them as holders
As you can see in term of flipping and holders in last three months, Flow is behind of Solana and Ethereum
New NFT projects on Flow cant compate with old projects like Top Shot and in chart you can see this in last month 99 persent of sell is for old NFT projects