Question:

Q1. The Lil Nouns DAO is controlled via onchain voting by token holders. Using the ethereum database, analyze voting activity on Lil Nouns proposals. Since voting is on chain and costs gas, are smaller holders excluded from the voting process? Visualize and analyze this question, along with any other trends you find that are relevant.

Approach:

The voting performance of Lil Nouns DAO by token holders has been established in this essay.

The main feature of this essay is to identify the voting performance based on average gas price on Ethereum blockchain and analyze the token holders voting behavior on high gas price days.

• Voting analyze

     from ethereum.core.fact_event_logs where EVENT_NAME='VoteCast'
     and CONTRACT_ADDRESS='0x5d2c31ce16924c2a71d317e5bbfd5ce387854039'
  

• Gas price

     avg(GAS_PRICE) from ethereum.core.fact_transactions  
  

• Token holders

     Difference of received and sent token from ethereum.core.ez_nft_transfers
     and NFT_ADDRESS='0x4b10701Bfd7BFEdc47d50562b76b436fbB5BdB3B'
  

Results:

The number of unique voters on Lil Noun DAO and average daily gas price both represented in this graph.

It can be seen that, by increasing the average gas price, the number of unique voters on Lil Noun DAO decreased accordingly. The lowest participation occurred on June 1st with only 1 voter.

The donut and bar graphs in this part demonstrate the top voter on Lil Noun DAO and token holders respectively.

1. According to these graphs and the first one, on the days with high average gas price only accounts with more than 3 token have been participated on Lil Noun DAO voting.
2. The top voter on Lil Noun DAO has about 8 tokens and count as big holder.
3. By considering the result it can be concluded that, the voting on Lil Noun DAO is more improtant for great token holders compared with smaller ones.