Query editor
with date_filter as (selectcasewhen {{n_days}} != 0 then date_add('day', -{{n_days}} -1, now()) -- Start 1 day earlier for initial 24h dataelse date_add('day', -1, cast('{{start_date}}' as timestamp))end start_date,casewhen {{n_days}} != 0 then date_add('day', 1, now())else cast('{{end_date}}' as timestamp)end end_date),validator_names as (selectx.votekey,x.pubkey,x.namefrom (values('Chorus6Kis8tFHA7AowrPMcRJk3LbApHTYpgSNXzY5KE', 'ChorusmmK7i1AxXeiTtQgQZhQNiXYU84ULeaYF1EH15n', 'Chorus One'),('EogKVYgic8LKAuV1kR9nRqJaS5zpwCvSMfqoehzmAMpK', '2abwQG3v2xRemFxRszVHSfnjJNe9zu5X8duKgxjyLeaK', 'Chorus One - Research'),('CpfvLiiPALdzZTP3fUrALg2TXwEDSAknRh1sn5JCt9Sr', 'LeDbQ99QT342j9S5YdyXLrsq2Gu3T3dMGajExdAuE3V', 'Chorus One - Ledger'),('spuraUaJeFZfdbgXpJhgqEHFAXatfrMArARXhXioxKd', 'spur5CDwBvTZszvy1ozGjRc1x2TuDWo3VF4jrq7zgvD', 'Spur'),('6H9J5xtcqGwh2hd2GpBHfvrnDicWk8GtvpnypH7piktA', 'MutT1jxCXbRWJXpXoJK259gLrNfzDezdxS3BSkQAmv1', 'Mut..mv1'), -- Random half C1 main stake('Haz7b47sZBpxh9SwggGndN3fAyNQ1S949BPdxWXS3ab6', 'DTSUkYHd2e9P2HLyZfbLarsbDdPhQUhZnWjRYuJZQRC8', 'Temporal'),('6aow5rTURdbhbeMDrFrbP2GR5vZjMEhktEy87iH1VGPs', '6WgdYhhGE53WrZ7ywJA15hBVkw7CRbQ8yDBBTwmBtAHN', 'Luganodes'),('CvSb7wdQAFpHuSpTYTJnX5SYH4hCfQ9VuGnqrKaKwycB', 'DtdSSG8ZJRZVv5Jx7K1MeWp7Zxcu19GD5wQRGRpQ9uMF', 'Galaxy'),('DdCNGDpP7qMgoAy6paFzhhak2EeyCZcgjH7ak5u5v28m', '5pPRHniefFjkiaArbGX3Y8NUysJmQ9tMZg3FrFGwHzSm', 'Kiln1'),('FKsC411dik9ktS6xPADxs4Fk2SCENvAiuccQHLAPndvk', 'DWvDTSh3qfn88UoQTEKRV2JnLt5jtJAVoiCo3ivtMwXP', 'P2P.org'),('CcaHc2L43ZWjwCHART3oZoJvHLAe9hzT2DJNUpBzoTN1', 'Fd7btgySsrjuo25CJCj7oE7VPMyezDhnx7pZkj2v69Nk', 'Figment'),('FQwewNXahV7MiZcLpY6p1xhUs2acVGQ3U5Xxc7FzV571', '7cVfgArCheMR6Cs4t6vz5rfnqd56vZq4ndaBrY5xkxXy', 'Blockdaemon'),('beefKGBWeSpHzYBHZXwp5So7wdQGX6mu4ZHCsH3uTar', 'XkCriyrNwS3G4rzAXtG5B1nnvb5Ka1JtCku93VqeKAr', 'Coinbase'),('3N7s9zXMZ4QqvHQR15t5GNHyqc89KduzMP7423eWiD5g', 'DRpbCBMxVnDK7maPM5tGv6MvB3v1sRMC86PZ8okm21hy', 'Binance Staking'),('9QU2QSxhb24FUX3Tu2FpczXjpK3VYrvRudywSZaM29mF', 'EvnRmnMrd69kFdbLMxWkTn1icZ7DCceRhvmb2SJXqDo4', 'Everstake'),('he1iusunGwqrNtafDtLdhsUQDFvo13z9sUa36PauBtk', 'HEL1USMZKAL2odpNBj2oCjffnFGaYwmbGmyewGv1e2TU', 'Helius'),('CertusDeBmqN8ZawdkxK5kFGMwBXdudvWHYwtNgNhvLu', 'Certusm1sa411sMpV9FPqU5dXAYhmmhygvxJ23S6hJ24', 'Asymmetric Research'),('55gncCYVFXYZhjD5a3aemVVtiHaVwfzu2R4axgamGLwV', 'HSZfYvEn8VnrBsR5Ner7iWWbUcRvLsv1EMeLndnbhPgY', 'R2-D2 Validator') --Random same C1 research stake) as x(votekey, pubkey, name)),leader_slots as(selectblock_slot,date_trunc('hour',block_time) as dt,block_time,name as validatorfrom solana.rewardsjoin validator_nameson pubkey = recipientjoin date_filteron block_time between start_date and end_date),jito_tips as(selectls.dt,ls.block_time,ls.block_slot,