select

date(proposal_start_time) as start_date,

date(proposal_end_time) as end_date,

date(vote_timestamp) as vote_date,

space_id,

proposal_id,

proposal_title,

voter,

vote_option,

voting_power

from ethereum.core.ez_snapshot

where space_id = 'ens.eth'

or space_id = 'uniswap'

or space_id = 'sushigov.eth'

or space_id = 'aave.eth'

or space_id = 'gitcoindao.eth'

or space_id = 'balancer.eth'

or space_id = 'lido-snapshot.eth'

or space_id = 'opcollective.eth'

or space_id = '1inch.eth'

or space_id = 'ybaby.eth'

or space_id = 'pooltogether.eth'

or space_id = 'bancornetwork.eth'

or space_id = 'frax.eth'

or space_id = 'index-coop.eth'

or space_id = 'shapeshiftdao.eth'

),

date_trends as (

select

start_date,

proposal_title,

replace(proposal_title,',','' ) as proposaln,

space_id,

voter,