DATE | Vote Choice | CATEGORY | Category Range | Vote Received | Voters | |
|---|---|---|---|---|---|---|
1 | 2025-03-02 00:00:00.000 | No - Retain Old Logo | dolphin : <100,000 | <100k | 5994581.99902 | 200 |
2 | 2025-03-02 00:00:00.000 | Yes - Change Logo | whale : >100,000 | >=100k | 15053920.079514 | 32 |
3 | 2025-03-02 00:00:00.000 | Yes - Change Logo | fish : <1000 | <1000 | 721152.383443 | 2057 |
4 | 2025-03-02 00:00:00.000 | Yes - Change Logo | dolphin : <100,000 | <100k | 3571920.911908 | 135 |
5 | 2025-03-02 00:00:00.000 | No - Retain Old Logo | plankton : <100 | <100 | 37272.626056 | 1137 |
6 | 2025-03-02 00:00:00.000 | Yes - Change Logo | shrimp : <10,000 | <10k | 2606615.014931 | 889 |
7 | 2025-03-02 00:00:00.000 | Yes - Change Logo | plankton : <100 | <100 | 80955.467104 | 2637 |
8 | 2025-03-02 00:00:00.000 | No - Retain Old Logo | whale : >100,000 | >=100k | 11672064.763653 | 32 |
9 | 2025-03-02 00:00:00.000 | No - Retain Old Logo | shrimp : <10,000 | <10k | 2538143.848544 | 891 |
10 | 2025-03-02 00:00:00.000 | No - Retain Old Logo | fish : <1000 | <1000 | 412022.529147 | 1446 |
11 | 2025-03-01 00:00:00.000 | Yes - Change Logo | plankton : <100 | <100 | 165633.268168 | 5469 |
12 | 2025-03-01 00:00:00.000 | No - Retain Old Logo | plankton : <100 | <100 | 55362.29043 | 1999 |
13 | 2025-03-01 00:00:00.000 | No - Retain Old Logo | shrimp : <10,000 | <10k | 2908985.982992 | 976 |
14 | 2025-03-01 00:00:00.000 | Yes - Change Logo | fish : <1000 | <1000 | 953777.549724 | 3093 |
15 | 2025-03-01 00:00:00.000 | No - Retain Old Logo | dolphin : <100,000 | <100k | 4448615.849269 | 166 |
16 | 2025-03-01 00:00:00.000 | Yes - Change Logo | shrimp : <10,000 | <10k | 3200119.054669 | 1131 |
17 | 2025-03-01 00:00:00.000 | Yes - Change Logo | whale : >100,000 | >=100k | 14254910.213383 | 47 |
18 | 2025-03-01 00:00:00.000 | No - Retain Old Logo | whale : >100,000 | >=100k | 9422474.890186 | 30 |
19 | 2025-03-01 00:00:00.000 | No - Retain Old Logo | fish : <1000 | <1000 | 563148.483256 | 1738 |
20 | 2025-03-01 00:00:00.000 | Yes - Change Logo | dolphin : <100,000 | <100k | 4280727.71866 | 188 |
dannyamahVoters Profiles : Update Jupiter Logo
Updated 2025-03-07
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 vote AS (
SELECT
date_trunc('day', 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
)
SELECT
v.date,
CASE
WHEN v.vote_choice = '1' THEN 'Yes - Change Logo'
WHEN v.vote_choice = '2' THEN 'No - Retain Old Logo'
END AS "Vote Choice",
CASE
WHEN v.vote_weight < 100 THEN 'plankton : <100'
WHEN v.vote_weight < 1000 THEN 'fish : <1000'
Last run: 3 months ago
50
5KB
4s