-- 1. How often do delegators switch validators? -- 2. Duration of stake accounts delegated per validator? -- 3. Are delegators commission sensitive? How sensitive are they? -- 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. with txns as ( select * from solana.core.ez_staking_lp_actions where event_type in ('delegate', 'withdraw') and node_pubkey is not null and block_timestamp >= '{{start_date}}' ), delegate_events as ( select block_timestamp as date, tx_id, event_type, commission, stake_authority as delegator, node_pubkey as validator from txns where event_type = 'delegate' and commission < 100 -- we should be excluding 100% commission validators (those are private people are just staking to themselves) ), withdraw_events as ( select block_timestamp as date, tx_id, event_type, commission, withdraw_destination as delegator, node_pubkey as validator from txns where event_type = 'withdraw' and commission < 100 -- we should be excluding 100% commission validators (those are private people are just staking to themselves) ), txns_2 as ( select *, lag(commission, 1) ignore nulls over (partition by delegator order by date asc) as last_commission, lag(event_type, 1) ignore nulls over (partition by delegator order by date asc) as last_event_type, lag(date, 1) ignore nulls over (partition by delegator order by date asc) as last_event_date, lag(validator, 1) ignore nulls over (partition by delegator order by date asc) as last_validator, last_commission - commission as diff_commission from ( (select * from delegate_events) union (select * from withdraw_events) ) order by delegator, validator ), switch_validator as ( select * from txns_2 where event_type = 'delegate' and last_event_type = 'withdraw' and validator <> last_validator and diff_commission > 0 ) select count(distinct delegator) as n_wallets, diff_commission, CASE WHEN diff_commission > 0 and diff_commission <= 1 THEN 'b.0-1%' WHEN diff_commission > 1 and diff_commission <= 5 THEN 'b.2-5%' WHEN diff_commission > 5 and diff_commission <= 10 THEN 'c.6-10%' WHEN diff_commission > 10 and diff_commission <= 25 THEN 'd.11-25%' WHEN diff_commission > 26 and diff_commission <= 50 THEN 'e.26-50%' WHEN diff_commission > 51 and diff_commission <= 75 THEN 'f.51-75%' WHEN diff_commission > 76 and diff_commission <= 99 THEN 'g.76-90%' WHEN diff_commission = 100 THEN 'h. 100%' END as category from switch_validator group by diff_commission,category order by category -- group by day

Solana-Core-3. Are delegators commission sensitive? How sensitive are they?