kaibladePercentage of Approve votes - 90 Days
Updated 2023-03-22
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
›
⌄
-- forked from 409da91a-48b7-4774-b8b5-edc44e655394
-- forked from c581e13e-d80b-4fa6-9256-3224aa436f70
WITH delegating_tx AS
(SELECT DISTINCT(decoded_log:delegatee) AS delegate
FROM ethereum.core.ez_decoded_event_logs
WHERE contract_address IN ( LOWER('0x4da27a545c0c5B758a6BA100e3a049001de870f5'), LOWER('0x7Fc66500c84A76Ad7e9c93437bFc5Ac33E2DDaE9'))
AND event_name = 'DelegateChanged'
AND block_timestamp::date >= CURRENT_DATE() - INTERVAL '90 days'
AND decoded_log:delegationType =1
AND tx_status = 'SUCCESS'),
delegates_votes AS
(SELECT tx_hash, block_timestamp, contract_address, contract_name,
decoded_log, event_name,origin_from_address, origin_to_address
FROM ethereum.core.ez_decoded_event_logs
WHERE contract_address = '0xec568fffba86c094cf06b22134b23074dfe2252c'
AND event_name = 'VoteEmitted'
AND origin_from_address IN (SELECT delegate FROM delegating_tx)
AND block_timestamp::date >= CURRENT_DATE() - INTERVAL '90 days'
AND tx_status = 'SUCCESS'),
voteswithgas AS
(SELECT votes.*,
(CASE
WHEN decoded_log:support::STRING = 'true' THEN 'Support For'
WHEN decoded_log:support::STRING= 'false' THEN 'Support Against'
END) AS vote_type,
gas.gas_used
FROM delegates_votes votes
JOIN ethereum.core.fact_transactions gas
ON votes.tx_hash = gas.tx_hash
),
Address_ens AS
Run a query to Download Data