connorhCompound Proposals
Updated 2021-04-19
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
›
⌄
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