No Data to Display
gergabyteLQ Berachain Delegator Shares
Updated 24 hours ago
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
›
⌄
WITH api_call as (
SELECT
livequery.live.udf_api(
'https://api.testnet.berachain.flipside.services/cosmos/staking/v1beta1/validators'
) as rawOutput
),
formatted_results as (
SELECT
value:operator_address::string as operator_address,
value:description:moniker::string as name,
value:commission:commission_rates:rate::string as commission_rate,
value:tokens::FLOAT / 1e+18 AS ABGT
FROM api_call, LATERAL FLATTEN (input => rawoutput:data:validators)
)
SELECT
*
FROM formatted_results ORDER by ABGT DESC
Last run: about 24 hours agoAuto-refreshes every 24 hours
0
2B
2s