Q1. Analyze the on-chain voting for NounsDAO. Which proposals have had the most engagement, relative to the number of tokens minted?

Method

I used the ethereum.core.fact_event_logs table then filtered by:

• origin_to_address = [ '0x6f3e6272a167e8accb32072d08e0957f9c79223d', '0x2573c60a6d127755aa2dc85e342f7da2378a0cc5', '0xae7f458667f1b30746354abc3157907d9f6fd15e', '0x37b8e20646d174b00198b7e183dd1f25520c0f60', '0xcc2688350d29623e2a0844cc8885f9050f0f6ed5', '0xf6c625851d48fe26b50d96b821a87efc7e35c222' ]

• T1.ORIGIN_FUNCTION_SIGNATURE = '0x56781388' OR '0x7b3c71d3' (VoteCast, delegate_call)

  Then I analyzed the proposals based on the number of votes and voters and votes type.

• support = '0' AS number_of_false_votes

• support = '1' number_of_true_votes

• support = '2' number_of_abstain_votes

What is NounsDAO?

Nouns DAO utilizes a fork of compound governance and is the main governing body of the Nouns ecosystem. The Nouns DAO treasury receives 100% of ETH proceeds from daily Noun auctions. Each Noun is an irrevocable member of Nouns DAO and entitled to one vote in all governance matters. Noun votes are non-transferable (if you sell your Noun the vote goes with it) but delegatable, which means you can assign your vote to someone else as long as you own your Noun.

The next charts show proposals based on total votes. Proposal 82 has the highest number of votes with 98 votes.

• 39.5% of proposals between 40 to 80 votes

• 27.6% of proposals between 20 to 40 votes

• 24.8% of proposals above 80 votes

• 6.15% of proposals between 10 to 20 votes

• 1.9% of proposals below 10 votes

  \

The next chart shows proposals based by votes type. According to the chart, 7 of the proposals have not been voted, and 89 of the proposals have been voted about 92%.

The next chart shows top 10 proposals based unique user. Proposal 90 has received the highest number of votes among unique users

The next charts show proposals based on total unique voters.

• Between 20 to 25 about 27.4% users have voted for the proposals

• Between 15 to 20 about 27.2% users have voted for the proposals

• Between 10 to 15 about 24.7% users have voted for the proposals

• Below 10 about 16.8% users have voted for the proposals

• Above 25 about 3.97% users have voted for the proposals

  \

Conclusion

According to observations More than 90% of users have voted positively for the proposals. The proposal that had the most mints was 90.