EPOCH | VALIDATOR_COHORT | AVERAGE | P25 | P50 | P95 | |
|---|---|---|---|---|---|---|
1 | 739 | Cohort 1 | 0.001386590909 | 0.000187 | 0.0003775 | 0.006878549 |
2 | 532 | Cohort 1 | 0.047687904762 | 0.017577 | 0.030732 | 0.100311 |
3 | 519 | Cohort 1 | 0.015429166667 | 0.0070315 | 0.012918 | 0.0320357 |
4 | 491 | Cohort 1 | 0.011552375 | 0.00731 | 0.009891 | 0.02042925 |
5 | 742 | Cohort 1 | 0.003625608696 | 0 | 0.000461 | 0.016040299 |
6 | 457 | Cohort 1 | 0.012287428571 | 0.01076525 | 0.0113605 | 0.0192597 |
7 | 490 | Cohort 1 | 0.015288642857 | 0.0090125 | 0.012209 | 0.031832399 |
8 | 657 | Cohort 1 | 0.019524363636 | 0.00958325 | 0.012058 | 0.036223 |
9 | 641 | Cohort 1 | 0.071973272727 | 0.027602 | 0.033909 | 0.272686549 |
10 | 717 | Cohort 1 | 0.005940409091 | 0.0011615 | 0.001943 | 0.023338399 |
11 | 688 | Cohort 1 | 0.038223681818 | 0.01822075 | 0.0249275 | 0.1350099 |
12 | 534 | Cohort 1 | 0.022777095238 | 0.010728 | 0.014844 | 0.055718 |
13 | 648 | Cohort 1 | 0.055965952381 | 0.027384 | 0.036515 | 0.160468 |
14 | 572 | Cohort 1 | 0.0296902 | 0.00889725 | 0.016892 | 0.077372 |
15 | 747 | Cohort 1 | 0.001281 | 0.00037125 | 0.0006265 | 0.0045909 |
16 | 582 | Cohort 1 | 0.036411947368 | 0.006532 | 0.013131 | 0.133177399 |
17 | 738 | Cohort 1 | 0.003521545455 | 0.00076725 | 0.001572 | 0.0101283 |
18 | 679 | Cohort 1 | 0.030255181818 | 0.0161115 | 0.0262725 | 0.06980905 |
19 | 668 | Cohort 1 | 0.017480714286 | 0.01208 | 0.01624 | 0.030634 |
20 | 666 | Cohort 1 | 0.014551619048 | 0.01049 | 0.013046 | 0.020425 |
MostlyData_Solana Validator Stake - Skip Rate Dist
Updated 2025-02-27
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
›
⌄
-- forked from Solana Validator Stake - commission dist @ https://flipsidecrypto.xyz/studio/queries/0bdda536-fb14-44a0-8651-3f47315c346e
with total_stake as(
select
epoch,
sum(active_stake) * pow(10,-9) as totSOLstaked
from solana.gov.fact_validators
group by 1
)
,validator_cohort_raw as(
select
fv.epoch,
case
when fv.active_stake * pow(10,-9) / ts.totSOLstaked * 100 >= 1 then 'Cohort 1'
when (fv.active_stake * pow(10,-9) / ts.totSOLstaked * 100 < 1
and fv.active_stake * pow(10,-9) / ts.totSOLstaked * 100 >= 0.5) then 'Cohort 2'
when (fv.active_stake * pow(10,-9) / ts.totSOLstaked * 100 < 0.5
and fv.active_stake * pow(10,-9) / ts.totSOLstaked * 100 >= 0.05) then 'Cohort 3'
when (fv.active_stake * pow(10,-9) / ts.totSOLstaked * 100 < 0.05) then 'Cohort 4'
end as validator_cohort,
fv.node_pubkey
from solana.gov.fact_validators fv
inner join total_stake ts on fv.epoch = ts.epoch
)
,skip_rate_data as(
select
vc.epoch,
vc.validator_cohort,
1 - bp.num_blocks_produced / bp.num_leader_slots as skip_rate
from solana.gov.fact_block_production bp
Last run: about 2 months ago
...
1216
68KB
2s