Q2. The Lil Nouns DAO was created as a sub-DAO from Nouns DAO. The Lil Nouns DAO compensates Nouns DAO by automatically sending every 11th Lil Noun (Lil Noun ids #1, #11, #21, #31 and so on) to the Nouns DAO Treasury. 

Estimate the total value of the Lil Nouns in the Nouns DAO treasury, and analyze the value of the Lil Nouns DAO to Nouns DAO. Feel free to include any other relevant trends you may find. Please use the core schema within the Ethereum database for this analysis.

Approach:

• Sending Lil Noun NFTs to Noun Dao

  from ethereum.core.fact_event_logs

  where EVENT_INPUTS:from='0xd5f279ff9eb21c6d40c8f345a66f2751c4eea1fb'

  and EVENT_INPUTS:to='0x0bc3807ec262cb779b38d65b38158acc3bfede10'--treasury address

  and EVENT_NAME='Transfer'

• Average sale price o Lil Noun on OpenSea

avg(PRICE_USD) as avg_sell_price

from ethereum.core.ez_nft_sales

where NFT_ADDRESS=lower('0x4b10701Bfd7BFEdc47d50562b76b436fbB5BdB3B')

• Minted Fee related to Lil Nouns sent to Noun Dao

  sum(tx_fee) as mint_fee

  from ethereum.core.ez_nft_mints

  where NFT_ADDRESS=lower('0x4b10701Bfd7BFEdc47d50562b76b436fbB5BdB3B')

  and TOKENID belongs to token sent to Noun Dao

Results:

Key findings:

1. The value of total transferred Lil Nouns to Noun Dao is about 427k USD for 275 Tokens.
2. The USD value of transferred Lil Noun to Noun Dao was high on May 18 and its value was 33.09k USD.
3. The highest value of sending 11th Lil Noun to Noun Dao treasury for the past month occurred on June 3 with 10.5k USD.
4. Another useful insight to the question is finding the generated fee by automatically sending 11th Lil Noun to Noun Dao.
5. The graph related to generated fee reveals the highest fee occurred on May 17 with 0.38 ETH and this fee used to sent 10 Lil Nouns.
6. The most important graph of this essay is the last one. According to this graph, the value of sending 11th Lil Noun to the Noun Dao treasury increased over time.
7. The final value of this graph displays the total value of Lil nouns on Noun Dao treasury.