SELECT

ins.decoded_instruction:accounts[1]:pubkey AS proposal_id

FROM

solana.core.fact_decoded_instructions ins

WHERE

ins.block_timestamp::date BETWEEN '2024-03-01' AND '2024-12-09'

AND ins.program_id = 'GovaE4iu227srtG2s3tZzB4RmWBzw8sTwrCLZz7kN7rY'

AND ins.decoded_instruction:accounts[1]:name = 'proposal'

GROUP BY

ins.decoded_instruction:accounts[1]:pubkey

HAVING

COUNT(DISTINCT ins.tx_id) > 10

),

jupiter_votes AS (

SELECT

ins.block_timestamp,

ins.tx_id,

ins.signers[0] AS user,

ins.decoded_instruction:args:weight / POW(10, 6) AS jup_weight,

ins.decoded_instruction:accounts[1]:pubkey AS proposal

FROM

solana.core.fact_decoded_instructions ins

WHERE

ins.block_timestamp::date BETWEEN '2024-03-01' AND '2024-12-09'

AND ins.program_id = 'GovaE4iu227srtG2s3tZzB4RmWBzw8sTwrCLZz7kN7rY'

AND ins.event_type = 'setVote'

AND ins.decoded_instruction:accounts[1]:name = 'proposal'

AND ins.decoded_instruction:accounts[1]:pubkey IN (

SELECT proposal_id FROM filtered_proposals

)

),

last_vote_time AS (

SELECT