Firedancer TVC - stats

MostlyData_Firedancer TVC - stats

Updated 2025-04-09

-- forked from Firedancer TVC @ https://flipsidecrypto.xyz/studio/queries/05aec19b-103d-4865-8e06-bfa6b8611c29

with validators_infos as(

select

epoch,

node_pubkey,

vote_pubkey,

active_stake,

epoch_active,

epoch_credits,

'Frankendancer Version: ' || software_version as software_version

from solana.gov.fact_validators

where

inserted_timestamp > dateadd(day, -{{n_days}}, current_date())

and software_version like '%0.%'

and software_version like '%.20113%'

)

,time_vote_credit as(

select

vi.software_version,

pe.value:epoch::number as epoch,

(pe.value:previousCredits::number - lag(pe.value:previousCredits::number) over (

partition by va.vote_pubkey

order by pe.value:epoch::number

)) / (432000 * 16) * 100 as effectiveness

from validators_infos as vi

inner join solana.gov.fact_rewards_voting rv

on rv.vote_pubkey = vi.vote_pubkey

and rv.epoch_earned = vi.epoch

inner join solana.gov.fact_vote_accounts va

on va.epoch = rv.epoch_earned

and va.vote_pubkey = rv.vote_pubkey,

Last run: 2 months ago

	SOFTWARE_VERSION	EPOCH	P25	P50	P95	EFFECTIVENESS
1	Frankendancer Version: 0.101.20113	760	99.42355	99.4355	99.44756	99.432
2	Frankendancer Version: 0.101.20113	756	99.58865	99.5941	99.60391	99.5941
3	Frankendancer Version: 0.101.20113	766	99.42895	99.5226	99.55908	99.44815
4	Frankendancer Version: 0.101.20113	768	99.686725	99.6964	99.704765	99.69215
5	Frankendancer Version: 0.101.20113	764	98.8352	98.9131	99.033295	98.887775
6	Frankendancer Version: 0.101.20113	767	99.361625	99.4438	99.539785	99.43595
7	Frankendancer Version: 0.101.20113	759	99.0894	99.3947	99.4262	99.202833333333
8	Frankendancer Version: 0.101.20113	763	99.378375	99.48365	99.510245	99.40035
9	Frankendancer Version: 0.101.20113	762	96.739	97.0786	99.15976	97.623
10	Frankendancer Version: 0.101.20113	755	99.7337	99.7394	99.74966	99.7394
11	Frankendancer Version: 0.101.20113	761	99.5917	99.6015	99.61869	99.601333333333
12	Frankendancer Version: 0.101.20113	757	99.483775	99.55155	99.673545	99.55155
13	Frankendancer Version: 0.101.20113	758	99.37025	99.3794	99.39587	99.3794
14	Frankendancer Version: 0.101.20113	765	99.571175	99.6055	99.62591	99.585225
15	Frankendancer Version: 0.404.20113	756	99.3843	99.5003	99.604105	99.474125
16	Frankendancer Version: 0.404.20113	759	99.4221	99.4221	99.4221	99.4221
17	Frankendancer Version: 0.404.20113	757	99.708125	99.70815	99.708195	99.70815
18	Frankendancer Version: 0.404.20113	758	99.389425	99.38965	99.390055	99.38965
19	Frankendancer Version: 0.404.20113	755	99.72895	99.7436	99.79262	99.748771428571
20	Frankendancer Version: 0.406.20113	758	99.426325	99.47415	99.560235	99.47415

4KB