Validators

Recently updated validators, with their balance and status
Typical query time: < 2 seconds
SELECT validator_index, 
 balance_gwei / 1e9 as balance_eth, 
 status, 
 TO_TIMESTAMP(updated_at) as updated_at_time
FROM eth.beacon.validators
ORDER BY updated_at DESC
LIMIT 10
Number of validators, grouped by status
Typical query time: < 2 seconds
SELECT COUNT(1) as num_validators, status
FROM eth.beacon.validators
GROUP BY status
ORDER BY COUNT(1) DESC
Validator with the highest balance
Typical query time: < 15 seconds
SELECT validator_index, 
 balance_gwei / 1e9 AS balance_eth, 
 status, 
 TO_TIMESTAMP(updated_at) AS updated_at_time
FROM eth.beacon.validators
WHERE balance_gwei = (
 SELECT max(balance_gwei) AS max_balance
 FROM eth.beacon.validators
)
ENS Domain Names that map to a validator
Typical query time: < 30 seconds
SELECT ens.names, ens.eth_address, bls.validator_index, status, balance_gwei / 1e9 AS balance_eth
FROM eth.beacon.bls_to_execution_changes AS bls
LEFT JOIN eth.beacon.validators AS val ON val.validator_index = bls.validator_index
LEFT JOIN (
 SELECT eth_address, LISTAGG(name, ',') WITHIN GROUP (ORDER BY name) AS "names"
 FROM ens.domains
 GROUP BY eth_address
) AS ens ON ens.eth_address = bls.to_execution_address
WHERE ens.names != ''
ORDER BY balance_gwei DESC
LIMIT 100

Last modified 1mo ago