dannyamahVoting Leaderboard : Jupuary Proposal 2
Updated 2024-12-07
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 >= '2024-12-04'
AND program_id = 'GovaE4iu227srtG2s3tZzB4RmWBzw8sTwrCLZz7kN7rY'
AND event_type = 'setVote'
AND proposal = 'xMLsw7zzBfRXNiQQo42aUohRsibgrmWcPt2mD8HdUUr'
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
QueryRunArchived: QueryRun has been archived