connorhCompound Voting
Updated 2021-04-06
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
›
⌄
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