VOTERS | TOTAL_VOTE_WEIGHT | MIN_VOTE_WEIGHT | MAX_VOTE_WEIGHT | AVG_VOTE_WEIGHT | |
|---|---|---|---|---|---|
1 | 194741 | 360542596.144647 | 0.000001 | 12098977.977561 | 1851.385916467 |
dannyamahProposal: Increase Quorum for Jupiter DAO
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
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
),
latest_vote AS (
SELECT
voter,
MAX(block_timestamp) AS latest
FROM
vote
GROUP BY
voter
)
SELECT
COUNT(DISTINCT v.voter) AS voters,
SUM(v.vote_weight) AS total_vote_weight,
MIN(v.vote_weight) AS min_vote_weight,
MAX(v.vote_weight) AS max_vote_weight,
AVG(v.vote_weight) AS avg_vote_weight
FROM
vote v
JOIN latest_vote lv ON v.voter = lv.voter
AND v.block_timestamp = lv.latest;
Last run: 13 days ago
1
67B
4s