Methodology

• Find the first delegate event for each delegator for each validator.
• Find the last withdraw event for each delegator for each validator.
• Find the difference between the two to calculate the number of days delegated duration
  • If there is no withdraw event for a delegator against a validator, then find the date difference between the current date and the date delegated.
• Categorize the average number of days delegated for the number of validators.

Definitions Used

-- stake_authority The wallet address of the user who initialized the transaction.
-- withdraw_authority The wallet address of the user that is withdrawing the stake. 
-- node_pubkey A unique key belonging to the validator node.
-- validator_rank The rank of the validator by amount of delegated SOL.
-- commission The percentage of staked earnings given to the validator.
-- validator_name The name of the validator when available. 
-- withdraw_destination The wallet that the SOL is being withdrawn to. 

Duration of stake accounts delegated per validator?

• Most of the validators have an average staked duration of 101-150 days, however they have <100 delegators each.
• The most interesting validator is EvnRmnMrd69kFdbLMxWkTn1icZ7DCceRhvmb2SJXqDo4 with an average stake duration of 102 days and 49K delegators, which is quite an impressive number.
  • This validatorEvnRmnMrd69kFdbLMxWkTn1icZ7DCceRhvmb2SJXqDo4 has 100% commission and is based somewhere in GB, London.
• There are good number of validators with average staked duration between 51-100 days and 151-200 days.
• Another observation is that we see some validators with very high average number of days delegated, however they have like 0-50 delegators only, therefore the average is high.