select

date(proposal_end_time) as date,

proposal_title,

voter,

voting_power,

vote_option

from ethereum.core.ez_snapshot

where space_id = 'balancer.eth'

-- and proposal_title != '%Test%'

-- and proposal_title != 'Final test'

-- and proposal_title != 'Test Proposal'

and voting_power > 0.01

order by date asc,

proposal_title,

voting_power desc),

ex_power as (

select

voter,

sum(voting_power) as executed_voting_power

from op_votes

group by voter

select

voter,

executed_voting_power,

executed_voting_power / 769652171 as percentage_of_total

from ex_power

order by executed_voting_power desc