select

date(proposal_end_time) as a_date,

*

from ethereum.core.ez_snapshot

where space_id = 'opcollective.eth'

and proposal_title != '%Test%'

and proposal_title != 'Final test'

and proposal_title != 'Test Proposal'

),

votes_fora as (

select

voter,

vote_option as choice,

voting_power,

proposal_title,

proposal_end_time

from all_ss

where choice = ['1']

),

votes_forb as (

select

sum(voting_power) as votes_for,

proposal_title,

proposal_end_time

from votes_fora

group by proposal_title, proposal_end_time

),

votes_againsta as(

select

voter,

vote_option as choice,

voting_power,