select

*

from ethereum.core.ez_snapshot

where space_id = 'aave.eth'

and proposal_title != '%Test%'

and proposal_title != 'Final test'

and proposal_title != 'Test Proposal'

),

new_dates as(

select

proposal_title,

proposal_start_time as date,

date_trunc('day', proposal_start_time) as day

from all_ss

),

props as (

select

distinct(proposal_title) as prop_name,

proposal_start_time as beginning,

proposal_end_time as ending

from all_ss

order by beginning asc

),

votes_fora as (

select

voter,

vote_option as choice,

voting_power,

proposal_title,

proposal_end_time

from all_ss

where choice = ['1']