Lil Nouns - Voting Activity
Introduction
Lil Nouns are just like Nouns, but Lil!
An expansion DAO based on Nouns DAO, Lil Nouns DAO works to create a new layer within the Nouns ecosystem; Nouns as kids. By expanding the ecosystem, Lil Nouns DAO aims at exposing more people to Nouns.
The Lil Nouns DAO is controlled via onchain voting by token holders.
In this dashboard, We are going to analyze voting activity on Lil Nouns proposals. the main question is that since voting is on chain and costs gas, are smaller holders excluded from the voting process?
Links:
Methods:
- For this dashboard, I've created the 'balance of NFTs per holder per day' table
- For this table, NFT minters, First, NFT senders & NFT receivers from 'ethereum.core.ez_nft_transfers' are combined with Date Dimension that created for this. Then Running total calculated for the combined tables.
- Holders are grouped in this dashboard based on how many NFT they hold as:
- Group 1: 1 NFT
- Group 2: 2-3 NFT
- Group 3: 4-8 NFT
- Group 4: 9-15 NFT
- Group 5: 16+ NFT
- To identify casted votes, 'ethereum.core.fact_event_logs' table with the contract address and Event_Name of VoteCast has been used.
- The balances of NFTs have calculated on daily basis. So if a user transfer his/her only NFT after cast the vote on the same day, The NFT balance will show zero on that day, because of this, In this cases that are very rare, the balance was changed to 1 for that day.
From the above charts, we can see how much voting participation occurred, But to answer the main question, we need participation rate for each NFT holder groups.
To calculate a metric that can determine voting participation rate, Average of number of each holder group of all time per all vote counts that those group participated is calculated:
We can see that, voting participate rate of groups with more NFTs are higher.