connorhCompound Voting
    Updated 2021-04-06
    SELECT
    block_timestamp,
    tx_id,
    event_name,
    CASE WHEN contract_address = '0xc0da01a04c3f3e0be433606045bb7017a7323e38' THEN 'Alpha' ELSE 'Bravo'
    END AS governor_contract,
    event_inputs:proposalId AS proposalId,
    event_inputs:support AS support,
    REGEXP_REPLACE(event_inputs:voter,'\"','') AS voter,
    event_inputs:votes AS votes
    FROM ethereum.events_emitted
    WHERE contract_address IN ('0xc0da01a04c3f3e0be433606045bb7017a7323e38','0xc0da02939e1441f497fd74f78ce7decb17b66529')
    AND block_timestamp >= CURRENT_DATE - 120
    AND event_name = 'VoteCast'
    Run a query to Download Data