SELECT

signers[0] AS voter,

decoded_instruction:accounts[1]:pubkey AS proposal,

decoded_instruction:args:side AS vote_choice,

decoded_instruction:args:weight / pow(10, 6) AS vote_weight,

block_timestamp

FROM

solana.core.ez_events_decoded

WHERE

block_timestamp::date >= '2024-10-25'

AND program_id = 'GovaE4iu227srtG2s3tZzB4RmWBzw8sTwrCLZz7kN7rY'

AND event_type = 'setVote'

AND proposal = 'PJVgLKqBa5LabApp9uU5rvxUgqp4RdUfBxVbEddLxWa'

AND succeeded

AND decoded_instruction:args:side IN ('1', '2', '3')

),

latest_vote AS (

SELECT

voter,

MAX(block_timestamp) AS latest

FROM

vote

GROUP BY

voter

CASE

WHEN v.vote_choice = '1' THEN 'Leave at 60M JUP'

WHEN v.vote_choice = '2' THEN 'Increase to 120M JUP'

WHEN v.vote_choice = '3' THEN 'Peg to 30% of Staked JUP'

END AS vote_choice,

SUM(v.vote_weight) AS vote_received,

ROUND(SUM(v.vote_weight) * 100.0 / NULLIF(SUM(SUM(v.vote_weight)) OVER (), 0), 2) || '%' AS percentage

vote v