piperJupiter Governance - Votes in numbers
Updated 2024-11-17
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
›
⌄
-- forked from Jupiter Governance - Votes @ https://flipsidecrypto.xyz/studio/queries/dfed74a9-d2d0-41f3-814b-09bbccc3c1a2
-- forked from kellen / Jupiter LFG Token Launchpad Results @ https://flipsidecrypto.xyz/kellen/q/vdO1szn5p_tq/jupiter-lfg-token-launchpad-results
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-03-06'
and i.program_id in (
'GovaE4iu227srtG2s3tZzB4RmWBzw8sTwrCLZz7kN7rY'
)
and name = 'proposal'
and proposal = 'PJVgLKqBa5LabApp9uU5rvxUgqp4RdUfBxVbEddLxWa'
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
round(sum(weight)) as votes,
count(1) as n_voters
from
t0
QueryRunArchived: QueryRun has been archived