Date | Votes | Voters | Cumulative Votes | Cumulative Voters | |
---|---|---|---|---|---|
1 | 2024-11-16 00:00:00.000 | 138000823 | 39369 | 138000823 | 39369 |
2 | 2024-11-17 00:00:00.000 | 138391232 | 69660 | 276392055 | 109029 |
3 | 2024-11-18 00:00:00.000 | 51920960 | 45212 | 328313015 | 154241 |
4 | 2024-11-19 00:00:00.000 | 23564621 | 19953 | 351877636 | 174194 |
5 | 2024-11-20 00:00:00.000 | 10208061 | 9873 | 362085697 | 184067 |
piperJupiter Governance - Votes over time
Updated 2024-12-27
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
›
⌄
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
5
301B
228s