keshanUntitled Query
Updated 2022-08-08
999
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
›
⌄
⌄
/*select proposal_id, proposal_title, proposal_text, vote_option, count(voter)
from ethereum.core.ez_snapshot
where space_id='opcollective.eth' and proposal_title != 'Final test'
group by 1, 2, 3, 4 */
--with voters as (select as voter)
--,
with voters as (select distinct voter from ethereum.core.ez_snapshot
where space_id='opcollective.eth' and proposal_title != 'Final test')
,
all_voted_interact as (select cn, sum(cnt) as cnt, sum(users) as users from
((select ifnull(address_name, contract_address) cn, count(distinct tx_hash) as cnt, count(distinct origin_from_address) as users
from optimism.core.fact_event_logs left join optimism.core.dim_labels on contract_address=address
where origin_from_address in ('0x1dd7c29dba3cfc8cd64220f7331e214a791a5989',
'0x1f14c2f40400471fb4a3aef1390f6bbbf2ad8f99',
'0x1fe6a806e0a9858359e16c58e4f84c790171596b',
'0x3764c0dbfc05917d9509f965b31f9b5ad1fca77b',
'0x40cb0b19d71eda986c275c85a6e5b26b6ac7e2e4',
'0x433b1ed3618f460f992157470fbee57f12dd7024',
'0x49d2038eace493dca83fafdf0eeb636be46d226b',
'0x4f7b076d0fcc7641eb968b4bf9983a830699d92a',
'0x514ddb5a550834352c9ba098227d3235363fa913',
'0x5244736b3a8f898149ae33f013126a20ce7abc62',
'0x646e3bd22b9d2c40de855dc467af1528307ae4d5',
'0x6b47a326f049f0c7c7666f05631106daf967d64f',
'0x6bb9e127e0a68f1644a873208097258157bae49d',
'0x7819bffd6a93a941f9c9c68bb6eda17766fbe609',
'0x87c05baa36ffede9fb912fa7128093a0cb6f6d33',
'0x89768ca7e116d7971519af950dbbdf6e80b9ded1',
'0xca517cb74a099b9f39bfe893fefedd7f3734e8ed',
'0xcc60eb2f64e7ad9b6924939b7985970d29a0108c',
'0xf62f7b14a067ddd7db7b6af7a5b57c87437eea5b',
'0xc7567d7fc3de4f83628bb0f08fce753a1f3b611b',
'0xcd0b67a61e5e8f4616c19e421e929813b6d947df',
'0xd6b070f15d10a39f429f25d10bbef42265b94dd1',
'0xfe82578cd7a7fc7e92cb840f7f1c2a88f49ddc0e') and origin_to_address not in ('0x1dd7c29dba3cfc8cd64220f7331e214a791a5989',
'0x1f14c2f40400471fb4a3aef1390f6bbbf2ad8f99',
Run a query to Download Data