piperJupiter Governance - Votes over time
    Updated 2024-12-27
    with t0 as (
    select decoded_instruction:args:side::string as side
    , decoded_instruction:args:weight::int * power(10, -6) as weight
    , signers[0]::string as voter
    , value:pubkey::string AS proposal
    , value:name::string AS name
    , block_timestamp
    from solana.core.fact_decoded_instructions i
    , LATERAL FLATTEN(input => decoded_instruction:accounts)
    where block_timestamp >= '2024-11-16'
    and i.program_id in (
    'GovaE4iu227srtG2s3tZzB4RmWBzw8sTwrCLZz7kN7rY'
    )
    and name = 'proposal'
    and proposal = 'ByQ21v3hqdQVwPHsfwurrtEAH8pB3DYuLdp9jU2Hwnd4'
    and side is not null
    and weight is not null
    and event_type = 'setVote'
    qualify(
    row_number() over (partition by voter order by block_timestamp desc) = 1
    )
    )
    select
    DATE_TRUNC('day', BLOCK_TIMESTAMP) AS "Date",
    round(sum(weight)) as "Votes",
    count(1) as "Voters",
    sum("Votes") over (order by "Date" asc) as "Cumulative Votes",
    sum("Voters") over (order by "Date" asc) as "Cumulative Voters",
    from
    t0
    GROUP BY 1
    ORDER BY 1 ASC


    Last run: about 2 months agoAuto-refreshes every 12 hours
    Date
    Votes
    Voters
    Cumulative Votes
    Cumulative Voters
    1
    2024-11-16 00:00:00.0001380008233936913800082339369
    2
    2024-11-17 00:00:00.00013839123269660276392055109029
    3
    2024-11-18 00:00:00.0005192096045212328313015154241
    4
    2024-11-19 00:00:00.0002356462119953351877636174194
    5
    2024-11-20 00:00:00.000102080619873362085697184067
    5
    301B
    228s