SELECT

block_timestamp AS date,

tx_id,

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

FROM

solana.core.ez_events_decoded

WHERE 1 = 1

AND block_timestamp :: date >= '2024-09-08'

AND program_id = 'GovaE4iu227srtG2s3tZzB4RmWBzw8sTwrCLZz7kN7rY'

AND event_type = 'setVote'

AND proposal = 'ApKpFDzwsjMEpW4zPNpmsHyPGfKrjaY6rA9HTLwV5a1w'

AND succeeded

AND voter = '{{wallet}}'

date,

tx_id,

voter AS "Voter",

TO_CHAR(vote_weight, '999,999,999,999') AS "Vote Weight",

CASE

when vote_choice = '0' then 'Abstain'

when vote_choice = '1' then 'Against'

when vote_choice = '2' then 'For'

end AS "Vote Choice"

vote