keshanLil Nouns: Voting Activity
    Updated 2022-06-17
    /*
    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