EPOCH | Avg. APR (%) | Median APR (%) | Sol Staked Weighted Average APR (%) | Max APR (%) | |
|---|---|---|---|---|---|
1 | 780 | 6.847 | 7.018 | 6.751 | 7.087 |
2 | 779 | 6.831 | 7.007 | 6.746 | 7.073 |
3 | 778 | 6.856 | 7.017 | 6.757 | 7.082 |
4 | 777 | 6.906 | 7.057 | 6.794 | 7.128 |
5 | 776 | 6.832 | 6.997 | 6.752 | 7.082 |
6 | 775 | 6.856 | 7.013 | 6.763 | 7.1 |
7 | 774 | 6.85 | 7.014 | 6.772 | 7.1 |
8 | 773 | 6.896 | 7.052 | 6.791 | 7.155 |
9 | 772 | 6.924 | 7.08 | 6.829 | 7.169 |
10 | 771 | 6.919 | 7.078 | 6.829 | 7.156 |
11 | 770 | 6.975 | 7.128 | 6.876 | 7.208 |
12 | 769 | 6.96 | 7.128 | 6.873 | 7.213 |
13 | 768 | 6.966 | 7.116 | 6.861 | 7.196 |
14 | 767 | 6.958 | 7.112 | 6.866 | 7.198 |
15 | 766 | 6.971 | 7.134 | 6.885 | 7.222 |
16 | 765 | 6.978 | 7.127 | 6.871 | 7.21 |
17 | 764 | 6.99 | 7.142 | 6.885 | 7.225 |
18 | 763 | 6.961 | 7.156 | 6.913 | 7.287 |
19 | 762 | 7.063 | 7.218 | 6.964 | 7.305 |
20 | 761 | 7.026 | 7.177 | 6.914 | 7.262 |
flyingfishSolana Validators APR
Updated 2025-05-03
999
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
›
⌄
-- forked from charliemarketplace / top-sol-stakers @ https://flipsidecrypto.xyz/charliemarketplace/q/ZeQJKGM7v04I/top-sol-stakers
-- APR calculation is based in charliemarketplace query
-- and improved with a rolling estimation of epoch's in one year
with last_epoch as (
select
max(epoch_earned) as latest_epoch
from solana.gov.fact_rewards_staking
)
, epoch_duration as (
-- Calculate number of epochs in 1 year for each epoch
-- Average is based on the current and previous 14 epochs
-- In average one month has ~14 epochs
select
epoch
, start_block
, end_block
, st.block_timestamp as start_timestamp
, en.block_timestamp as end_timestamp
, timediff(minute, start_timestamp, end_timestamp) as epoch_minutes
, avg(epoch_minutes) over (order by epoch rows between 14 preceding and current row) as avg_minutes_last_15_epochs
, div0(525960, avg_minutes_last_15_epochs) as avg_epochs_in_one_year -- 365.25 * 24 * 60 = 525960 (minutes in 1 year)
from solana.gov.dim_epoch
left join solana.core.fact_blocks st on start_block = st.block_id
left join solana.core.fact_blocks en on end_block = en.block_id
where 1 = 1
and epoch <= (select latest_epoch from last_epoch)
)
, node_keys as (
-- get pairs of node_pubkeys's and vote_pubkeys's for each epoch
select
epoch
Last run: 3 months ago
...
180
5KB
43s