DATE | TOTAL_VOTES | BLAZESTAKE_TOTAL_REWARDS | BLAZESTAKE_REWARD_PER_VOTE | |
|---|---|---|---|---|
1 | 2025-05-21 00:00:00.000 | 40152286 | ||
2 | 2025-05-20 00:00:00.000 | 254104736 | 0.001788579 | 7.038747204e-12 |
3 | 2025-05-20 00:00:00.000 | 254104736 | 0.003793606 | 1.492930065e-11 |
4 | 2025-05-20 00:00:00.000 | 254104736 | 3.19e-7 | 1.255387857e-15 |
5 | 2025-05-20 00:00:00.000 | 254104736 | 0.00282306 | 1.110982835e-11 |
6 | 2025-05-20 00:00:00.000 | 254104736 | 0.000377796 | 1.486772761e-12 |
7 | 2025-05-20 00:00:00.000 | 254104736 | 0.003556806 | 1.399740145e-11 |
8 | 2025-05-20 00:00:00.000 | 254104736 | 0.000186396 | 7.33540047e-13 |
9 | 2025-05-20 00:00:00.000 | 254104736 | 0.000156749 | 6.16867684e-13 |
10 | 2025-05-20 00:00:00.000 | 254104736 | 0.000055034 | 2.165799853e-13 |
bobby_daniel8-4 Assessing Reward Discrepancies
Updated 2025-05-21
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 stake_pool AS (
SELECT
authorized_staker,
STAKE_PUBKEY,
vote_pubkey,
SUM(account_sol) AS blazestake_active_stake
FROM solana.gov.fact_stake_accounts
WHERE authorized_staker = '6WecYymEARvjG5ZyqkrVQ6YkhPfujNzWpSPwNKXHCbV2'
AND account_sol > 0.1
GROUP BY authorized_staker, STAKE_PUBKEY, vote_pubkey
),
vote_counts AS (
SELECT
DATE_TRUNC('day', block_timestamp) as date,
SUM(num_votes) as total_votes,
FROM solana.gov.fact_votes_agg_block
WHERE block_timestamp >= CURRENT_DATE - INTERVAL '30 days'
GROUP BY DATE_TRUNC('day', block_timestamp)
),
reward_totals AS (
SELECT
DATE_TRUNC('day', block_timestamp) as date,
SUM(reward_amount_sol) as blazestake_total_rewards,
STAKE_PUBKEY
FROM solana.gov.fact_rewards_staking
WHERE block_timestamp >= CURRENT_DATE - INTERVAL '30 days'
GROUP BY DATE_TRUNC('day', block_timestamp),3
)
SELECT
v.date,
v.total_votes,
r.blazestake_total_rewards,
r.blazestake_total_rewards / NULLIF(v.total_votes, 0) AS blazestake_reward_per_vote
FROM vote_counts v
LEFT JOIN reward_totals r
Last run: 10 days ago
10
635B
14s