with all_ss as (

select

date(proposal_end_time) as end_date,

proposal_title as proposal,

voter,

voting_power

from ethereum.core.ez_snapshot

where space_id = 'opcollective.eth'

and proposal_title != '%Test%'

and proposal_title != 'Final test'

and proposal_title != 'Test Proposal'

),

cnt_vtr as (

select

date(end_date) as end_date,

count(voter) as num_voters,

proposal

from all_ss

group by date(end_date), proposal

select

end_date,

num_voters,

proposal

from cnt_vtr

order by date(end_date) asc