with vote_txn as (select date_trunc('day', block_timestamp) as date, tx_hash, origin_from_address from ethereum.core.fact_event_logs where contract_address = '0x5d2c31ce16924c2a71d317e5bbfd5ce387854039' -- Nouns DAO voting contract and event_name = 'VoteCast' and tx_status = 'SUCCESS'), gas_price as (select tx_hash, gas_price from ethereum.core.fact_transactions where tx_hash in (select tx_hash from vote_txn)), balance_as_at_vote as (select balance_date, user_address, sum(amount_usd) as balance_usd from flipside_prod_db.ethereum.erc20_balances where user_address in (select origin_from_address from vote_txn) -- select addresses from vote txn list and balance_date in (select date from vote_txn) -- select vote dates from vote txn list group by 1, 2), final_table as (select date, origin_from_address as voter, gas_price as vote_gas_price, balance_usd from vote_txn v join gas_price g on g.tx_hash = v.tx_hash join balance_as_at_vote b on (b.balance_date = v.date and b.user_address = v.origin_from_address)) select case when balance_usd > 100000 then '10) >100,000' when balance_usd > 90000 and balance_usd <= 100000 then '09) 90,000 to 100,000' when balance_usd > 80000 and balance_usd <= 90000 then '08) 80,000 to 90,000' when balance_usd > 70000 and balance_usd <= 80000 then '07) 70,000 to 80,000' when balance_usd > 60000 and balance_usd <= 70000 then '07) 60,000 to 70,000' when balance_usd > 50000 and balance_usd <= 60000 then '06) 50,000 to 60,000' when balance_usd > 40000 and balance_usd <= 50000 then '05) 40,000 to 50,000' when balance_usd > 30000 and balance_usd <= 40000 then '04) 30,000 to 40,000' when balance_usd > 20000 and balance_usd <= 30000 then '03) 20,000 to 30,000' when balance_usd > 10000 and balance_usd <= 20000 then '02) 10,000 to 20,000' when balance_usd > 0 and balance_usd <= 10000 then '01) 0 to 10,000' end as balance_usd_bucket, count(voter) as voter_count from final_table group by 1

Lil Nouns DAO Voting Activity