dannyamahVoting Leaderboard : Jupuary Proposal 2
    Updated 2024-12-07
    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