Try Quests to earn crypto[Optimism] - NFT Crossovers
Bounty Question
> Create a dashboard that shows the crossover between the Optimism OP NFT projects by market cap. Which of the strongest projects tend to have the most crossover, and which projects have a wider mix of other communities? Which communities tend to provide the most signal that another NFT project will do well? As in, is there any alpha if you were to see a certain PFP buying another collection? Which communities tend to be most active in minting new collections? Which communities have are the most diamond handed on other projects?
Why focus on NFT Crypto Community
> ## The NFT crypto community refers to a group of people that are actively collecting, trading, selling, and engaging in conversations about Non-Fungible Tokens or NFTs. A creative who shares links to their art or project shill their NFTs. Those who buy NFTs and resell them for a profit are called flippers. > > ## Building an NFT crypto community from the very beginning is crucial. Not only does a strong community set the foundations for a successful NFTs sale, but it can also generate buzz that attracts buy-in—and bring additional traffic to your profile. > > ## Indeed, NFTs are evolving to the point where you either now need to offer a service or a community. For instance, some projects are offering tokens where holders get exposure to a range of NFTs. Investors need to know that there’s a credible team behind the project and a community around it. They also want to follow the journey of the project closely and be assured that the team behind the NFT is in it for the long term. > > ## SuperRare, for instance, is a curated NFT crypto community with onboarding policies and quality guidelines for artists and collectors. This helps to attract like-minded people to their platform, creating a sort of informal social layer that facilitates buying and selling more than anything else. > > ## If your community is large and strong enough, your project will quickly gather interest from both investors, fans, and the press. It is therefore critical to build your audience from early on. The community approach provides you with the opportunity to build a strong network of relations amongst the blockchain ecosystem.
Methodology
> First, through this link, the top 5 collections in terms of sales volume over time were determined, and in the screenshot taken from this list, which follows, you can see these 5 collections and their sales volume over time:
> Then, the addresses of these collections were found at optimistic.etherscan.io, and due to these addresses, the review on these collections was started. To check these collections, a basic query was used, which is as follows:
select
BLOCK_TIMESTAMP,
TX_HASH,
SELLER_ADDRESS,
BUYER_ADDRESS,
nft_Address,
case
when nft_Address = lower('0x0110Bb5739a6F82eafc748418e572Fc67d854a0F') then 'Early Optimists'
when nft_Address = lower('0xB8Df6Cc3050cC02F967Db1eE48330bA23276A492') then 'OptiPunks'
when nft_Address = lower('0x51E5426eDE4e2d4c2586371372313B5782387222') then 'Apetimism'
when nft_Address = lower('0x81b30ff521D1fEB67EDE32db726D95714eb00637') then 'Optimistic Explorer'
when nft_Address = lower('0xA95579592078783B409803Ddc75Bb402C217A924') then 'Hello World'
end as Collections_Title,
TOKENID,
CURRENCY_SYMBOL,
PRICE,
zeroifnull(PRICE_USD) as PRICE_USD
from optimism.core.ez_nft_sales
where nft_Address in (lower('0x0110Bb5739a6F82eafc748418e572Fc67d854a0F'), lower('0xB8Df6Cc3050cC02F967Db1eE48330bA23276A492'),
lower('0x51E5426eDE4e2d4c2586371372313B5782387222'), lower('0x81b30ff521D1fEB67EDE32db726D95714eb00637'),
lower('0xA95579592078783B409803Ddc75Bb402C217A924'))
and EVENT_TYPE = 'sale'
order by 1
> First, the number of unique tokens sold from each of these collections was obtained. The sharp difference between the numbers shows the incompleteness of the data in the tables.
>
>
> Then, as a beginning, a very comprehensive overview of the sales of these top 5 collections was conducted.
>
>
> In the following, it was investigated what percentage of the buyers and sellers of these 5 collections were the buyers and how many of these collections.
>
>
> Then, the crossover between these 5 collections was done in pairs for both the buyers and sellers.
>
>
> In the following, the people who played a role in these crossovers were investigated, what percentage of the society of that collection formed.
>
>
> Finally, it was checked which other collections were minted by the buyers and sellers of these top 5 collections.
>
>
>
>
> The highest volume of USD in a sale, the highest average USD in sales, the highest median USD in sales is related to the OptiPunks collection.
>
>
>
>
>
>
>
> The Hello World collection is the best-selling collection in terms of number of unique NFTs sold. It is also the best selling collection.
>
>
>
>
>
>
>
> The highest overall sales volume is the OptiPunks collection with $1.173m, followed by the Early Optimists collection with $898k.
>
>
>
>
>
>
>
> The largest number of buyers was from the Hello World collection and the largest number of sellers was from the Early Optimists collection.
>
>
>
>
>
>
>
> Optimistic Explorer collection buyers have bought an average of 2.67 NFTs from this collection.
>
>
>
>
>
>
>
> Sellers of the Hello World collection have sold an average of over 19 NFTs from the collection.
>
>
>
>
>
>
>
> Buyers of the OptiPunks collection have paid an average of over $574 to purchase NFTs from this collection. On the other hand, the sellers of this collection have earned an average of $985 from the sale of NFTs of this collection. Each piece of NFTs in this collection has been sold for an average of $401. On average, each NFT sale from this collection was worth more than $284.
>
>
>
>
>
>
>
> NFTs of Early Optimists collection with more than 1.91 times selling, has the upper hand among other collections. With more than 349 sales, the collection has an average number of sales per day. This average number of daily sales is over $20.8k per day.
>
>
>
>
> > \
> 88% of unique buyers (about 29.7k buyers) of all 5 collections bought only one collection. This is 8.82 times the number of buyers who bought from two collections (3.36k buyers).
>
>
>
>
>
> There are only 4 buyers who bought at least one NFT from every 5 collections.
>
>
>
>
>
> 84.5% of unique sellers (about 18.57k sellers) of all 5 collections sold NFTs from only one collection. That's 5.65 times the number of sellers who sold dual-collection NFTs (3.28k buyers).
>
>
>
>
>
> There was no seller among these approximately 22k sellers who sold at least one NFT in every 5 collections. There are only 8 sellers who have sold at least one NFT from 4 out of 5 collections.
>
>
>
> In the crossovers between the two collections, the most crossovers can be observed between the Optimistic Explorer and Hello World collections. 1426 common buyers can be seen in the group of buyers of these collections.
>
>
>
>
>
> Apetimism collection with 94 joint buyers with Optimistic Explorer and Hello World collections have formed the least amount of crossover between collections.
>
>
>
>
>
> In the buyer community, the most crossovers are related to the Optimistic Explorer, Hello World and Early Optimists collections.
>
>
>
>
>
> The situation in the community of sellers of the most crossovers belongs to the Early Optimists collection. In the first two ranks, this collection has 2577 and 352 sellers in common with the Optimistic Explorer and Hello World collections, respectively.
>
>
>
>
>
>
> About 35% of the OptiPunks buyer community were also buyers of the Hello World collection. Of course, this number is about 5% of Hello World collection buyers.
>
>
>
>
>
> 33% of buyers of Apetimism collection were also buyers of Hello World collection. This number is about 2.5% of Hello World collection buyers.
>
>
>
>
>
> 24% of Apetimism collection buyers have also bought OptiPunks collection. This number of buyers is 12.8% of all buyers of OptiPunks collection.
>
>
>
>
>
> 26% of sellers of Early Optimists collection were also sellers of Optimistic Explorer collection.
>
>
>
>
>
> 22% of Early Optimists collection sellers were also Hello World collection sellers.
>
>
>
>
>
> 20% of OptiPunks collection sellers were also Apetimism collection sellers.
>
>
>
> > \
>
>
>
> Only three other collections have been minted by the community of buyers and sellers of the top 5 collections, which of course cannot be true from my point of view. I consider it most likely to be my own error in how to extract the data from the table rather than the table's defect. However, the result obtained is not without grace.
>
>
>
>
>
> The nerdapedaonft collection is a collection minted by 3518 buyers of these top 5 collections and 1311 sellers of these collections. (Between these users, there are definitely common users, and these numbers do not show the number of unique users)
>
>
>
>
>
> Nerdapedaonft and cat game collections have been minted by the community members of all top 5 collections, but in the case of xzeros collection, only Hello World and Optimistic Explorer collections have been minted.
>
>
>
>
>
> Only the nerdapedaonft collection has been minted by the community members of all top 5 collections. The cat game collection has been minted by the members of the top 4 collections community (Apetimism collection community members have not participated in the minting of this collection). Regarding the xzeros collection, only the Early Optimists collection community has participated in its minting.
>
>
>
> > \