select

column1 as pubkey

from values

('ChorusmmK7i1AxXeiTtQgQZhQNiXYU84ULeaYF1EH15n'), -- 'Chorus One'

('DWvDTSh3qfn88UoQTEKRV2JnLt5jtJAVoiCo3ivtMwXP'), -- 'P2P.org'

('Fd7btgySsrjuo25CJCj7oE7VPMyezDhnx7pZkj2v69Nk'), -- 'Figment'

--('GGX3BEoZDqjxcw4AbCdu62ZTMrkpSgmPt81oP2mVuZNS'), -- 'Hashkey Cloud'

('XkCriyrNwS3G4rzAXtG5B1nnvb5Ka1JtCku93VqeKAr'), -- Coinbase

('DRpbCBMxVnDK7maPM5tGv6MvB3v1sRMC86PZ8okm21hy'), -- Binance Staking

('krakeNd6ednDPEXxHAmoBs1qKVM8kLg79PvWF2mhXV1'), -- Kraken

('5pPRHniefFjkiaArbGX3Y8NUysJmQ9tMZg3FrFGwHzSm'), -- Kiln1

('CAo1dCGYrB6NhHh5xb1cGjUiu86iyCfMTENxgHumSve4'), -- 'Staked'

('DtdSSG8ZJRZVv5Jx7K1MeWp7Zxcu19GD5wQRGRpQ9uMF'), -- 'Galaxy'

--('GoeW4aFK4dGoekJySgUynWDxBZiQJqm8GDAF4H53tDK9'), -- 'Twinstake'

('EvnRmnMrd69kFdbLMxWkTn1icZ7DCceRhvmb2SJXqDo4') -- 'Everstake'

,date_filter as (

select

cast('2025-01-20' as timestamp) as start_date,

cast('2025-02-20' as timestamp) as end_date

,time_vote_credit as(

select

val.validator_name,

pe.value:epoch::number as epoch,

pe.value:previousCredits::number as Credits,

lag(pe.value:previousCredits::number) over (

partition by va.vote_pubkey

order by pe.value:epoch::number

) as previousCredits,

pe.value:previousCredits::number - lag(pe.value:previousCredits::number) over (

partition by va.vote_pubkey