Solana-54.NFT Mint Sweet Spot

-- Q54. Compare the mint price of popular Solana NFT collections to their resale price. -- Is there a ‘sweet spot’ for Solana NFT mint prices that fetch higher percentage returns on the secondary market? -- Do collections that cap the number of NFTs a wallet can mint have higher returns? -- Create a dashboard that discusses these points. Start using Magic Eden marketplace data. -- For grand prize eligibility: Consider all marketplaces and see if the “sweet spot” differs between marketplaces. -- Hints: Look at this analysis on Ethereum NFTs for inspiration. Use the “mints” field and join to the labels table -- to determine which collection an NFT belongs to. -- Replicate table #2 here for Magic Eden Solana NFT's: https://a16z.com/2022/03/31/nft-mint-data-early-decisions/

Methodology

Find Mint Prices for each NFT from solana.fact_nft_mints
Join with solana.fact_nft_sales to get the sale price
Return = (s.sales_amount-m.mint_price)/m.mint_price
We only consider sales in SOL to compare apples to apple.

    WHEN mint_price &lt;= 0.1 THEN '1. Less Than 0.10'
    WHEN mint_price &gt; 0.10 and mint_price &lt;= .50 THEN '2. 0.10-0.50'
    WHEN mint_price &gt; 0.50 and mint_price &lt;= 1.00 THEN '3. 0.50-1.00'
    WHEN mint_price &gt; 1.00 and mint_price &lt;= 5.00 THEN '4. 1.00-5.00'
    WHEN mint_price &gt; 5.00 and mint_price &lt;= 10.00 THEN '5. 5.00-10.00'
    WHEN mint_price &gt; 10.00 and mint_price &lt;= 50.00 THEN '6. 10.00-50.00'
    WHEN mint_price &gt; 50.00 THEN '7. More than 50'

    WHEN sale_return &lt;= 1 THEN '1. Less Than 1x'
    WHEN sale_return &gt; 1 and sale_return &lt;= 2 THEN '2. 1-2x Returns'
    WHEN sale_return &gt; 2 and sale_return &lt;= 5 THEN '3. 2-5x Returns'
    WHEN sale_return &gt; 5 and sale_return &lt;= 10 THEN '4. 5-10x Returns'
    WHEN sale_return &gt; 10 THEN '5. More than 10x Returns'

Definition

Sweet spot is defined as spot where we have the most number of sales on the secondary market and the return > 2X

Is there a ‘sweet spot’ for Solana NFT mint prices that fetch higher percentage returns on the secondary market?

Looking at the chart the sweet spot for the most number of sales is when the mint price is less than 0.1 SOL and the returns are more than 10x for about 329K sales.
The other sweet spot is where the mint price is between 1.00-5.00 SOL and the return is 2-5x returns for 162k sales.

Do collections that cap the number of NFTs a wallet can mint have higher returns?