No Data to Display
dannyamahWallet Search : Increase Quorum
Updated 2025-05-10
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
›
⌄
with vote AS (
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-11-16'
AND program_id = 'GovaE4iu227srtG2s3tZzB4RmWBzw8sTwrCLZz7kN7rY'
AND event_type = 'setVote'
AND proposal = 'PJVgLKqBa5LabApp9uU5rvxUgqp4RdUfBxVbEddLxWa'
AND succeeded
AND voter = '{{wallet}}'
)
SELECT
date,
tx_id,
voter AS "Voter",
TO_CHAR(vote_weight, '999,999,999,999') AS "Vote Weight",
CASE
when vote_choice = '1' then 'Leave at 60M JUP'
when vote_choice = '2' then 'Increase to 120M JUP'
when vote_choice = '3' then 'Peg to 30% of Staked JUP'
end AS "Vote Choice"
FROM
vote
Last run: 17 days ago
0
2B
4s