Question:

Q2. How many Lil Nouns have been sold on a secondary exchange within 24 hours of being minted? Are there any common traits among these Lil Nouns? Which Lil Noun’s have the biggest difference (positive or negative) between their mint price and secondary sale price? Visualize and analyze your findings.

Preliminaries:

Lil Nouns is a fork of Nouns: a generative non-fungible token project on the Ethereum blockchain. Like Nouns, Lil Nouns are 32x32 pixel characters based on people, places, and things. A Lil noun is generated every 15 minutes.

In this essay, the secondary sale of Lil Nouns has been investigated. Also, the most popular traits that cause selling in the first 24 hours of mint have been captured.

Approach:

1. Mint of Lil Nouns

   from ethereum.core.ez_nft_mints 
   where NFT_ADDRESS='0x4b10701Bfd7BFEdc47d50562b76b436fbB5BdB3B'  
   

2. Secondary sale of Lil Nouns

   from ethereum.core.ez_nft_sales
   where NFT_ADDRESS='0x4b10701Bfd7BFEdc47d50562b76b436fbB5BdB3B'
   

3. Identify sold NFTs in the first 24 hour

   DATEDIFF(day, mint_time,sale_time)<1 -- By considering the mint time and first sale on marketplace
   

4. NFTs with most profit

   Difference of Sale price and Mint price
   

5. Trait analysis

   Not included in the Ethereum table and used the reference code in the question
   

Results:

This part represented the count of NFTs that sold in the first 24 hour of mint. Also, the profit and count of sale for these NFTs over time have been shown in the bar graph.

• Only 72 of Lil Noun NFTs have been sold in the first 24 hour of being minted.
• The highest count of sale and obtained profit by selling these Lil Noun NFTs occurred on May 18th.
• These NFTs are the most valuable ones because they sold in the first day after minting.
• The trait analysis of these NFTs placed in the next part.

The Top 5 Lil Noun NFTs with most profit arranged in this bar graph. According to this graph, the Lil Noun NFT with token id= 5 has been sold about 49k USD after being minted.

The trait analysis of NFTs that sold in the first 24 hour of being minted presented in the two table. Due to the lack of data on NFT metadata table and not assigning the traits for Lil Nouns, the extra explanations about these most popular features could not be placed.