SELECT

block_timestamp,

tx_id,

signers[0] AS signers,

DECODED_INSTRUCTION,

DECODED_INSTRUCTION['accounts'][0]['pubkey'] AS governor,

DECODED_INSTRUCTION['accounts'][1]['pubkey'] AS proposal,

DECODED_INSTRUCTION['accounts'][2]['pubkey'] AS vote,

DECODED_INSTRUCTION['accounts'][3]['pubkey'] AS locker,

DECODED_INSTRUCTION['args']['side'] AS side,

DECODED_INSTRUCTION['args']['weight'] / POW(10, 6) AS weight,

ROW_NUMBER() OVER (PARTITION BY vote ORDER BY block_timestamp DESC) AS rn

FROM

solana.core.ez_events_decoded

WHERE

program_id = 'GovaE4iu227srtG2s3tZzB4RmWBzw8sTwrCLZz7kN7rY'

AND event_type = 'setVote'

AND block_timestamp >= '2024-03-29'

and block_timestamp <= '2024-04-02'

),

latest_votes AS (

SELECT

block_timestamp,

tx_id,

signers,

DECODED_INSTRUCTION,

governor,

proposal,

vote,

locker,

side,

weight

FROM

jup_set_vote

WHERE