select

epoch,

validator_name,

node_pubkey,

vote_pubkey,

active_stake

from solana.gov.fact_validators

where

epoch >= '{{epoch_start}}'

and node_pubkey in (

'ChorusmmK7i1AxXeiTtQgQZhQNiXYU84ULeaYF1EH15n',

'2abwQG3v2xRemFxRszVHSfnjJNe9zu5X8duKgxjyLeaK',

'DWvDTSh3qfn88UoQTEKRV2JnLt5jtJAVoiCo3ivtMwXP',

'Fd7btgySsrjuo25CJCj7oE7VPMyezDhnx7pZkj2v69Nk',

'CXPeim1wQMkcTvEHx9QdhgKREYYJD8bnaCCqPRwJ1to1',

'A4hyMd3FyvUJSRafDUSwtLLaQcxRP4r1BRC9w2AJ1to2',

'5pPRHniefFjkiaArbGX3Y8NUysJmQ9tMZg3FrFGwHzSm',

'7cVfgArCheMR6Cs4t6vz5rfnqd56vZq4ndaBrY5xkxXy',

'DTSUkYHd2e9P2HLyZfbLarsbDdPhQUhZnWjRYuJZQRC8',

'HEL1USMZKAL2odpNBj2oCjffnFGaYwmbGmyewGv1e2TU',

'9jDvpZLfD62KKs38fdsFbZza1SgfGBW6KvbqsNRHexak'

)

,skip_rate_data as(

select

bp.epoch,

case

when bp.node_pubkey = 'ChorusmmK7i1AxXeiTtQgQZhQNiXYU84ULeaYF1EH15n' then 'Chorus One'

when bp.node_pubkey = 'DWvDTSh3qfn88UoQTEKRV2JnLt5jtJAVoiCo3ivtMwXP' then 'P2P.org'

when bp.node_pubkey = 'Fd7btgySsrjuo25CJCj7oE7VPMyezDhnx7pZkj2v69Nk' then 'Figment'

when bp.node_pubkey = 'CXPeim1wQMkcTvEHx9QdhgKREYYJD8bnaCCqPRwJ1to1' then 'Jito1' --Jito1

when bp.node_pubkey = 'A4hyMd3FyvUJSRafDUSwtLLaQcxRP4r1BRC9w2AJ1to2' then 'Jito2' --Jito2