with leader_blocks_fee as(

select

date_trunc('hour', block_timestamp) as dt,

block_id,

case

when pubkey = 'ChorusmmK7i1AxXeiTtQgQZhQNiXYU84ULeaYF1EH15n' then 'Chorus One'

when pubkey = 'DWvDTSh3qfn88UoQTEKRV2JnLt5jtJAVoiCo3ivtMwXP' then 'P2P.org'

when pubkey = 'Fd7btgySsrjuo25CJCj7oE7VPMyezDhnx7pZkj2v69Nk' then 'Figment'

when pubkey = 'CXPeim1wQMkcTvEHx9QdhgKREYYJD8bnaCCqPRwJ1to1' then 'Jito1' --Jito1

when pubkey = 'A4hyMd3FyvUJSRafDUSwtLLaQcxRP4r1BRC9w2AJ1to2' then 'Jito2' --Jito2

when pubkey = '5pPRHniefFjkiaArbGX3Y8NUysJmQ9tMZg3FrFGwHzSm' then 'Kiln'

when pubkey = 'Certusm1sa411sMpV9FPqU5dXAYhmmhygvxJ23S6hJ24' then 'Asymmetric Research'

when pubkey = '7cVfgArCheMR6Cs4t6vz5rfnqd56vZq4ndaBrY5xkxXy' then 'Blockdaemon'

when pubkey = 'DTSUkYHd2e9P2HLyZfbLarsbDdPhQUhZnWjRYuJZQRC8' then 'Temporal'

when pubkey = 'HEL1USMZKAL2odpNBj2oCjffnFGaYwmbGmyewGv1e2TU' then 'Helius'

else 'Others'

end as validator

from solana.gov.fact_rewards_fee

where

(

'{{n_days}}' = 0

and block_timestamp >= cast('{{start_date}}' as timestamp)

and block_timestamp < cast('{{end_date}}' as timestamp)

)

or

(

'{{n_days}}' != 0

and block_timestamp > current_date() - interval '{{n_days}} days'

)