flipside

    Solana Client Version
    MostlyData_Solana Client Version
    Updated 2025-03-12
    with validators_infos as(
    select
    epoch,
    inserted_timestamp,
    validator_name,
    ' Software Version: ' || software_version as software_version,
    data_center_key,
    node_pubkey,
    vote_pubkey,
    active_stake,
    epoch_active,
    epoch_credits

    from solana.gov.fact_validators

    where
    epoch >= '{{epoch_start}}'
    --and vote_pubkey = 'Chorus6Kis8tFHA7AowrPMcRJk3LbApHTYpgSNXzY5KE'
    and vote_pubkey = 'CertusDeBmqN8ZawdkxK5kFGMwBXdudvWHYwtNgNhvLu'
    )

    select * from validators_infos
    --where software_version = ' Software Version: 2.1.5'
    order by epoch desc
    --order by software_version desc




    Last run: about 1 month ago
    EPOCH
    INSERTED_TIMESTAMP
    VALIDATOR_NAME
    SOFTWARE_VERSION
    DATA_CENTER_KEY
    NODE_PUBKEY
    VOTE_PUBKEY
    ACTIVE_STAKE
    EPOCH_ACTIVE
    EPOCH_CREDITS
    1
    		7552025-03-12 04:39:40.771🔥💃 Asymmetric Research Software Version: 0.406.2011320326-DE-Frankfurt am MainCertusm1sa411sMpV9FPqU5dXAYhmmhygvxJ23S6hJ24CertusDeBmqN8ZawdkxK5kFGMwBXdudvWHYwtNgNhvLu2463282631249225755147092
    2
    		7542025-03-10 04:52:15.629🔥💃 Asymmetric Research Software Version: 0.406.2011320326-DE-Frankfurt am MainCertusm1sa411sMpV9FPqU5dXAYhmmhygvxJ23S6hJ24CertusDeBmqN8ZawdkxK5kFGMwBXdudvWHYwtNgNhvLu24623519633927737543570634
    3
    		7532025-03-09 04:32:37.115🔥💃 Asymmetric Research Software Version: 0.406.2011320326-DE-Frankfurt am MainCertusm1sa411sMpV9FPqU5dXAYhmmhygvxJ23S6hJ24CertusDeBmqN8ZawdkxK5kFGMwBXdudvWHYwtNgNhvLu24615118023220577533506368
    4
    		7522025-03-07 04:23:29.152🔥💃 Asymmetric Research Software Version: 0.406.2011320326-DE-Frankfurt am MainCertusm1sa411sMpV9FPqU5dXAYhmmhygvxJ23S6hJ24CertusDeBmqN8ZawdkxK5kFGMwBXdudvWHYwtNgNhvLu24639330834205627526854161
    5
    		7512025-03-05 04:06:01.405🔥💃 Asymmetric Research Software Version: 0.404.2011320326-DE-Frankfurt am MainCertusm1sa411sMpV9FPqU5dXAYhmmhygvxJ23S6hJ24CertusDeBmqN8ZawdkxK5kFGMwBXdudvWHYwtNgNhvLu246304660899287275113511
    6
    		7502025-03-03 04:24:26.218🔥💃 Asymmetric Research Software Version: 0.404.2011320326-DE-Frankfurt am MainCertusm1sa411sMpV9FPqU5dXAYhmmhygvxJ23S6hJ24CertusDeBmqN8ZawdkxK5kFGMwBXdudvWHYwtNgNhvLu24621242733025817506842217
    7
    		7492025-03-01 04:59:03.121🔥💃 Asymmetric Research Software Version: 0.404.2011320326-DE-Frankfurt am MainCertusm1sa411sMpV9FPqU5dXAYhmmhygvxJ23S6hJ24CertusDeBmqN8ZawdkxK5kFGMwBXdudvWHYwtNgNhvLu24611681507002637496790275
    8
    		7482025-02-27 04:19:10.735🔥💃 Asymmetric Research Software Version: 0.404.2011320326-DE-Frankfurt am MainCertusm1sa411sMpV9FPqU5dXAYhmmhygvxJ23S6hJ24CertusDeBmqN8ZawdkxK5kFGMwBXdudvWHYwtNgNhvLu24607700292903437486637985
    9
    		7472025-02-25 04:03:25.620🔥💃 Asymmetric Research Software Version: 0.305.2011120326-DE-Frankfurt am MainCertusm1sa411sMpV9FPqU5dXAYhmmhygvxJ23S6hJ24CertusDeBmqN8ZawdkxK5kFGMwBXdudvWHYwtNgNhvLu24601995935050617476597138
    10
    		7462025-02-23 04:14:44.027🔥💃 Asymmetric Research Software Version: 0.305.2011120326-DE-Frankfurt am MainCertusm1sa411sMpV9FPqU5dXAYhmmhygvxJ23S6hJ24CertusDeBmqN8ZawdkxK5kFGMwBXdudvWHYwtNgNhvLu24593176663444907466559834
    11
    		7452025-02-21 05:02:08.747🔥💃 Asymmetric Research Software Version: 0.305.2011120326-DE-Frankfurt am MainCertusm1sa411sMpV9FPqU5dXAYhmmhygvxJ23S6hJ24CertusDeBmqN8ZawdkxK5kFGMwBXdudvWHYwtNgNhvLu24584170285558127456460266
    12
    		7442025-02-19 05:08:20.941🔥💃 Asymmetric Research Software Version: 0.305.2011120326-DE-Frankfurt am MainCertusm1sa411sMpV9FPqU5dXAYhmmhygvxJ23S6hJ24CertusDeBmqN8ZawdkxK5kFGMwBXdudvWHYwtNgNhvLu24575576378711927446397803
    13
    		7432025-02-17 06:01:51.089🔥💃 Asymmetric Research Software Version: 0.305.2011120326-DE-Frankfurt am MainCertusm1sa411sMpV9FPqU5dXAYhmmhygvxJ23S6hJ24CertusDeBmqN8ZawdkxK5kFGMwBXdudvWHYwtNgNhvLu24568447363002037436335921
    14
    		7422025-02-15 05:07:09.295🔥💃 Asymmetric Research Software Version: 0.305.2011120326-DE-Frankfurt am MainCertusm1sa411sMpV9FPqU5dXAYhmmhygvxJ23S6hJ24CertusDeBmqN8ZawdkxK5kFGMwBXdudvWHYwtNgNhvLu24559580861538117426277563
    15
    		7412025-02-13 04:03:52.829🔥💃 Asymmetric Research Software Version: 0.305.2011120326-DE-Frankfurt am MainCertusm1sa411sMpV9FPqU5dXAYhmmhygvxJ23S6hJ24CertusDeBmqN8ZawdkxK5kFGMwBXdudvWHYwtNgNhvLu24552495203452027416205247
    16
    		7402025-02-11 04:37:09.362🔥💃 Asymmetric Research Software Version: 0.305.2011120326-DE-Frankfurt am MainCertusm1sa411sMpV9FPqU5dXAYhmmhygvxJ23S6hJ24CertusDeBmqN8ZawdkxK5kFGMwBXdudvWHYwtNgNhvLu24537215286955127406117251
    17
    		7392025-02-09 04:58:19.814🔥💃 Asymmetric Research Software Version: 0.305.2011120326-DE-Frankfurt am MainCertusm1sa411sMpV9FPqU5dXAYhmmhygvxJ23S6hJ24CertusDeBmqN8ZawdkxK5kFGMwBXdudvWHYwtNgNhvLu24528049884042947396067494
    18
    		7382025-02-07 04:03:13.938🔥💃 Asymmetric Research Software Version: 0.305.2011120326-DE-Frankfurt am MainCertusm1sa411sMpV9FPqU5dXAYhmmhygvxJ23S6hJ24CertusDeBmqN8ZawdkxK5kFGMwBXdudvWHYwtNgNhvLu24520315570607367385929116
    19
    		7372025-02-05 05:23:20.235🔥💃 Asymmetric Research Software Version: 0.304.2010620326-DE-Frankfurt am MainCertusm1sa411sMpV9FPqU5dXAYhmmhygvxJ23S6hJ24CertusDeBmqN8ZawdkxK5kFGMwBXdudvWHYwtNgNhvLu24533393566275767375920753
    20
    		7362025-02-03 04:09:03.159🔥💃 Asymmetric Research Software Version: 0.304.2010620326-DE-Frankfurt am MainCertusm1sa411sMpV9FPqU5dXAYhmmhygvxJ23S6hJ24CertusDeBmqN8ZawdkxK5kFGMwBXdudvWHYwtNgNhvLu24522829895686507365899660
    36
    9KB
    2s