Total Votes by the DAO | |
|---|---|
1 | 6663566098.81089 |
CyberaResearchTotal Votes by the DAO
Updated 4 hours ago
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
36
›
⌄
WITH filtered_proposals AS (
SELECT
ins.decoded_instruction:accounts[1]:pubkey AS proposal_id,
COUNT(DISTINCT ins.tx_id) AS vote_count
FROM
solana.core.fact_decoded_instructions ins
WHERE
ins.block_timestamp::date >= '2024-03-01'
AND ins.program_id = 'GovaE4iu227srtG2s3tZzB4RmWBzw8sTwrCLZz7kN7rY'
AND ins.decoded_instruction:accounts[1]:name = 'proposal'
GROUP BY
ins.decoded_instruction:accounts[1]:pubkey
HAVING
COUNT(DISTINCT ins.tx_id) > 10
),
votes AS (
SELECT
ins.decoded_instruction:accounts[1]:pubkey AS proposal_id,
ins.signers[0] AS user,
ins.block_timestamp AS vote_time,
ins.decoded_instruction:args:weight / POW(10,6) AS vote_weight
FROM
solana.core.fact_decoded_instructions ins
WHERE
ins.block_timestamp::date >= '2024-03-01'
AND ins.program_id = 'GovaE4iu227srtG2s3tZzB4RmWBzw8sTwrCLZz7kN7rY'
AND ins.event_type = 'setVote'
AND ins.decoded_instruction:accounts[1]:name = 'proposal'
AND ins.decoded_instruction:accounts[1]:pubkey IN (
SELECT proposal_id FROM filtered_proposals
)
),
last_votes AS (
SELECT
Last run: about 4 hours agoAuto-refreshes every 12 hours
1
20B
11s