keshanLil Nouns: Voting Activity
Updated 2022-06-17
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
›
⌄
⌄
/*
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.
*/
-- contract_address = 0x5d2c31ce16924c2a71d317e5bbfd5ce387854039 event_name = VoteCast
select --block_timestamp,
origin_from_address::String as voter,
sum(event_inputs:votes) as votes,
avg(event_inputs:votes) as avg_votes
from ethereum.core.fact_event_logs
where contract_address='0x5d2c31ce16924c2a71d317e5bbfd5ce387854039'
and event_name='VoteCast' and tx_status='SUCCESS'
group by voter