keshanUntitled Query
    Updated 2022-08-08
    /*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