Voter | Vote Weight | Vote Choice | Percentage of Total Vote | |
|---|---|---|---|---|
1 | F4zq...LZ7o | 15,735,794 | For | 4.13% |
2 | 2yxE...4e5h | 15,364,889 | Abstain | 4.03% |
3 | 5AWh...7Z5i | 12,329,265 | For | 3.24% |
4 | AUQj...tJYE | 5,867,800 | For | 1.54% |
5 | HmW1...cQsK | 5,525,469 | Against | 1.45% |
6 | CVV5...2yVy | 5,105,561 | For | 1.34% |
7 | GAeK...dwNB | 2,437,168 | For | 0.64% |
8 | 31P7...C5Lr | 2,325,134 | For | 0.61% |
9 | AT4v...3iMn | 2,281,006 | For | 0.6% |
10 | 4axW...3rtz | 2,194,895 | For | 0.58% |
11 | DPD4...U9fd | 2,192,197 | For | 0.58% |
12 | E1YV...Gvab | 2,115,050 | Against | 0.55% |
13 | Fs1U...N8w2 | 1,756,301 | For | 0.46% |
14 | FjUY...CUHL | 1,612,168 | For | 0.42% |
15 | 9SD4...g4HH | 1,442,792 | Against | 0.38% |
16 | 7nFL...M2en | 1,362,130 | For | 0.36% |
17 | 81KG...UjZi | 1,299,922 | Against | 0.34% |
18 | A9Zw...UDkC | 1,294,723 | For | 0.34% |
19 | 6SUP...KSgE | 1,245,904 | Against | 0.33% |
20 | 9xtn...yocN | 1,236,415 | Abstain | 0.32% |
dannyamahVoting Leaderboard : DEVREL
Updated 2025-03-31
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
date_trunc('hour', block_timestamp) AS date,
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 1 = 1
AND block_timestamp::date >= '2025-03-29'
AND program_id = 'GovaE4iu227srtG2s3tZzB4RmWBzw8sTwrCLZz7kN7rY'
AND event_type = 'setVote'
AND proposal = 'A3MdKWdsVH2haFb7nDtb2ALVwpvdUe4QRjT37Y8GBjQ3'
AND succeeded
),
latest_vote AS (
SELECT
voter,
MAX(block_timestamp) AS latest
FROM
vote
GROUP BY
voter
),
vote_with_total AS (
SELECT
v.voter AS voter,
v.vote_weight AS vote_weight,
v.vote_choice AS vote_choice,
lv.latest AS latest_vote_time,
SUM(v.vote_weight) OVER () AS total_vote_weight
FROM
vote v
JOIN
Last run: about 2 months ago
...
1000
49KB
3s