connorhCompound Proposals
    Updated 2021-04-19
    WITH p AS (
    SELECT
    block_timestamp,
    tx_id,
    event_name,
    CASE WHEN contract_address = '0xc0da01a04c3f3e0be433606045bb7017a7323e38' THEN 'Alpha' ELSE 'Bravo'
    END AS governor_contract,
    event_inputs:id AS proposal_id,
    REGEXP_REPLACE(event_inputs:proposer,'\"','') AS proposer,
    REGEXP_REPLACE(event_inputs:targets,'\"','') AS targets,
    REGEXP_REPLACE(event_inputs:description,'\"','') AS description
    FROM ethereum.events_emitted
    WHERE
    contract_address IN ('0xc0da01a04c3f3e0be433606045bb7017a7323e38','0xc0da02939e1441f497fd74f78ce7decb17b66529')
    AND
    block_timestamp >= CURRENT_DATE - 120
    AND event_name = 'ProposalCreated'
    ), e AS (
    SELECT
    event_inputs:id AS id
    FROM ethereum.events_emitted
    WHERE contract_address IN ('0xc0da01a04c3f3e0be433606045bb7017a7323e38','0xc0da02939e1441f497fd74f78ce7decb17b66529')
    AND block_timestamp >= CURRENT_DATE - 120
    AND event_name = 'ProposalExecuted'
    ), q AS (
    SELECT
    event_inputs:id AS id
    FROM ethereum.events_emitted
    WHERE contract_address IN ('0xc0da01a04c3f3e0be433606045bb7017a7323e38','0xc0da02939e1441f497fd74f78ce7decb17b66529')
    AND block_timestamp >= CURRENT_DATE - 120
    AND event_name = 'ProposalQueued'
    ), c AS (
    SELECT
    event_inputs:id AS id
    FROM ethereum.events_emitted
    WHERE contract_address IN ('0xc0da01a04c3f3e0be433606045bb7017a7323e38','0xc0da02939e1441f497fd74f78ce7decb17b66529')
    Run a query to Download Data