MostlyData_Fees by version
    Updated 2025-03-18
    -- forked from Priority Fees by version @ https://flipsidecrypto.xyz/studio/queries/8b5fad26-faf3-457e-9eb3-5e5e8e0b89ee

    with validators_infos as(
    select
    epoch,
    node_pubkey,
    vote_pubkey,
    active_stake,
    epoch_active,
    epoch_credits,
    case
    when vote_pubkey = 'CertusDeBmqN8ZawdkxK5kFGMwBXdudvWHYwtNgNhvLu' then ' Frankendancer Version: ' || software_version
    else ' Agave Version: ' || software_version
    end as software_version
    --data_center_key

    from solana.gov.fact_validators

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

    ,firedancer_version as(
    select
    epoch,
    ' Frankendancer Version: ' || software_version as software_version

    from solana.gov.fact_validators

    where
    inserted_timestamp > dateadd(day, -{{n_days}}, current_date())
    and vote_pubkey = 'CertusDeBmqN8ZawdkxK5kFGMwBXdudvWHYwtNgNhvLu'
    )

    ,total_stake as(
    Last run: 17 days ago
    DT
    SOFTWARE_VERSION
    P25
    P50
    P95
    1
    2025-03-01 17:00:00.000 Agave Version: 2.1.110.01366582750.0195509260.0561780683
    2
    2025-03-03 15:00:00.000 Agave Version: 2.1.110.0212864570.0325780450.1209524369
    3
    2025-03-06 22:00:00.000 Agave Version: 2.1.110.0236327020.03318544150.09532925885
    4
    2025-03-05 19:00:00.000 Agave Version: 2.1.110.01968790.0288099920.0806240424
    5
    2025-03-05 09:00:00.000 Agave Version: 2.1.110.0124952970.0174864850.044451213
    6
    2025-03-09 11:00:00.000 Agave Version: 2.1.110.011007919250.01532942650.0397933937
    7
    2025-03-06 13:00:00.000 Agave Version: 2.1.110.014874627250.0205557550.05605826775
    8
    2025-03-09 04:00:00.000 Agave Version: 2.1.110.013920427250.02011320150.06074894085
    9
    2025-02-28 13:00:00.000 Agave Version: 2.1.110.0155512360.0218226360.0569731971
    10
    2025-03-14 04:00:00.000 Agave Version: 2.1.110.01493124850.0208373390.0603372504
    11
    2025-03-02 08:00:00.000 Agave Version: 2.1.110.00828518450.01133829150.0286160381
    12
    2025-03-15 16:00:00.000 Agave Version: 2.1.110.01478904550.02145116550.06081543475
    13
    2025-03-10 11:00:00.000 Agave Version: 2.1.110.009602130250.01327685550.0376253898
    14
    2025-03-08 06:00:00.000 Agave Version: 2.1.110.01263646950.0178271960.048100113
    15
    2025-03-13 08:00:00.000 Agave Version: 2.1.110.010605444250.0146132290.03795964625
    16
    2025-03-06 02:00:00.000 Agave Version: 2.1.110.0196309670.0277449670.07578082
    17
    2025-03-15 23:00:00.000 Agave Version: 2.1.110.0180700010.02645750350.07583478855
    18
    2025-03-01 23:00:00.000 Agave Version: 2.1.110.0136455040.0196614560.0544990387
    19
    2025-03-07 21:00:00.000 Agave Version: 2.1.110.032960878750.04946031550.1484986702
    20
    2025-03-03 21:00:00.000 Agave Version: 2.1.110.01706844150.0247333530.0727988452
    ...
    1480
    138KB
    3s