[BUG] Validator Index wrong in ethereum_staking.flows

[Yonatank88]

Description

Some where around validator index 1023000 there seems to start a discrepancy between validator index and public key

Current behavior

Run the following query:

SELECT
  *
FROM staking_ethereum.flows
WHERE
  validator_index = 1023000

Copy the public key and search for it on beaconcha.in
Youll see the validator the public key has a different index then in the query response

Expected behavior

Validator index should be identical in dune and beaconcha.in

Impacted model

ethereum_staking.flows Invalid public keys list

ethereum_staking.flows index calculation

Possible Solution

My best guess is that there are a few more invalid public keys that should be added so they won't be counted in the index counter but I'm not sure whats the right way to find invalid validators.

[jeff-dude]

@hildobby did you want to look into this?

[hildobby]

@hildobby did you want to look into this?

yes its on my backlog @jeff-dude, thanks for pointing out @yoanatanblox 🙏🙏