Validator BERA Balances

gergabyteValidator BERA Balances

Updated 7 hours ago

WITH gh_req as (

SELECT

live.udf_api('https://raw.githubusercontent.com/berachain/default-lists/main/src/validators/bartio/defaultValidatorList.json') as rawoutput

val_results as (

SELECT

value:id::string as val_address,

value:name::string as name,

value:logoURI::string as logo_uri,

value:description::string as description,

value:website::string as website,

value:twitter::string as twitter

FROM gh_req, LATERAL FLATTEN (input => rawoutput:data:validators)

balance_requests AS (

SELECT DISTINCT val_address,

utils.udf_json_rpc_call('eth_getBalance', [val_address, 'latest']) as bal_cal,

live.udf_api(

'POST',

'https://rpc.tn.us-east-1.bera.flipside.services',

{'Content-Type': 'application/json'}, bal_cal

):data:result as rpc_result,

utils.udf_hex_to_int(rpc_result::string)::int as bera_balance;

FROM val_results

)

SELECT

val_results.name,

val_results.val_address,

balance_requests.bera_balance / 1e18 as bera_balance

FROM

val_results

JOIN

balance_requests ON val_results.val_address = balance_requests.val_address

ORDER BY bera_balance DESC;

Last run: about 7 hours agoAuto-refreshes every 12 hours

...

139

10KB