Method

• I first got the Lil Nouns holders. To do this from the table ethereum.core.ez_nft_transfers Based on filter nft_address = lower ('0x4b10701bfd7bfedc47d50562b76b436fbb5bdb3b') I got the inventory value of each address (from / to).

• I for voter analysis From ethereum.core.fact_event_logs table based on filter T1.TX_STATUS = 'SUCCESS' and T1.EVENT_REMOVED = 'false' and T1.EVENT_NAME = 'VoteCast' and contract_address = '0x5d2c31ce16924c2a71d317e5bbfd5ce387854039'

• From the field information EVENT_INPUTS,and I fetched 'support', 'voter' and 'votes'

• support = '0' AS number_of_false_votes

• support = '1' number_of_true_votes

• support = '2' number_of_abstain_votes

• I got the total number of voters and the total number of votes.

• I considered those whose vote was 0 as excluded.

• I got the amount of gas at the time of voting on a daily basis and analysis it.

• I analysis the votes and voters based on the proposal

Analysis

The next chart shows total amount Lil Nouns holder.

The next chart shows total amount Lil Nouns vote. Only Lil Nouns holders have the right to vote.

The next chart shows daily total number of voters by support.

Support :

• Number of abstain votes : Red
• Number of true votes : Orange
• Number of false votes: Blue

According to the chart, it is clear that the users' vote was positive and there are a few who did not vote.

The next chart shows proposals based on total unique voters.Most related to Proposal 2 with 60 voters.

The next chart shows proposals based on total votes.Most related to Proposal 17 with 389 votes.

The next query shows the price of gas at the time of voting.

The next chart shows daily total number of votes by gas.

Conclusion

According to the observations and the price of astringent at that time One of the reasons for the excluded may be related to the increase in gas prices for smaller holders.

The next query shows inventory of those excluded from voting.