flipside

    Voting Leaderboard : Update Jupiter Logo
    dannyamahVoting Leaderboard : Update Jupiter Logo
    Updated 2025-03-01
    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-02-25'
    AND program_id = 'GovaE4iu227srtG2s3tZzB4RmWBzw8sTwrCLZz7kN7rY'
    AND event_type = 'setVote'
    AND proposal = '8DA1TFPjbyfJXmQMrqRcQCGheoordFZ2fWNd3zpEhj2k'
    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: 3 months ago
    Voter
    Vote Weight
    Vote Choice
    Percentage of Total Vote
    1
    2yxE6DfmdzRjv9NLCQFkUJGPLrYnvc2tkJKrcMoF4e5h
    		 15,364,889No - Retain Old Logo4.08%
    2
    5AWhStitFRPPYR4GjPk2ieyg8VLhygcrXMmbUuoQ7Z5i
    		 11,382,183Yes - Change Logo3.03%
    3
    2ADEAbWZPfuZsngbxE19BBwYtdj6iBci2Qm3tFroRMnW
    		 4,309,634No - Retain Old Logo1.15%
    4
    HmW1qSvFoakikZtBk72bqcqGTUfGrELkjGTwWm52cQsK
    		 4,000,000No - Retain Old Logo1.06%
    5
    EsqEkirkY6s1RPsb3YaJZcP4APQz77BWmBAVCsbNNhpj
    		 3,792,483Yes - Change Logo1.01%
    6
    GAeKjsEgLVyjgJsddSuUnACkjzbBWwSnw9RKSjYydwNB
    		 2,437,168Yes - Change Logo0.65%
    7
    CVV5MxfwA24PsM7iuS2ddssYgySf5SxVJ8PpAwGN2yVy
    		 2,358,010Yes - Change Logo0.63%
    8
    31P7UMzSTuCyewLJqX6YjkG9Mp5HzhZSgoDHVskSC5Lr
    		 2,325,134Yes - Change Logo0.62%
    9
    DPD4JVTn6YaqAC5bEoh8uja55oKewj76qwRnzMdfU9fd
    		 2,192,197No - Retain Old Logo0.58%
    10
    E1YVU3YN2j6Z17tXbiN61EQ8W28rfnn4H3ZyH6HwGvab
    		 2,115,050No - Retain Old Logo0.56%
    11
    Fs1UgreRTkjjkistDpimk136UXozZn5fQFW8qwd6N8w2
    		 1,664,808No - Retain Old Logo0.44%
    12
    47ZrS4awZGAAkbsDXKmEPsyL7tMftxRDUJXD8C5SY9Y6
    		 1,580,027No - Retain Old Logo0.42%
    13
    FjUYunzS2EB2MMcWUz2gjjyEuKQjt2QTJ4qa9TGxCUHL
    		 1,461,516No - Retain Old Logo0.39%
    14
    4axWMUPfRPMiMtU3fwSzF9HEQVRbj8ZdDXrcvztU3rtz
    		 1,454,896No - Retain Old Logo0.39%
    15
    86hGL46dxAQMRBU562NotV1ALrZyPJfwRjS6jQM9u89a
    		 1,355,242No - Retain Old Logo0.36%
    16
    81KG22yKD5Ey5AjcyhLFxmCse6rCJ6nBzw95pdjHUjZi
    		 1,299,922Yes - Change Logo0.35%
    17
    A9ZwsC52EMWQRrtM2tphCVNtfWMHAxJ9ddtL9fEDUDkC
    		 1,294,723No - Retain Old Logo0.34%
    18
    EQS3DfZ1pzKrgKqcXnn2pqnSsvvhZYcbCvZDHeKGkVwq
    		 1,204,181No - Retain Old Logo0.32%
    19
    Cs2A2atm3jo7B8eyHD9DFunL4SStqGU1FL37SGWjmFBv
    		 1,173,152No - Retain Old Logo0.31%
    20
    GMGkGFrLAm5FczLNVD5hK7e3NDtEvSYEEuPWbYCimgjH
    		 1,135,493No - Retain Old Logo0.3%
    ...
    1000
    96KB
    2s