gergabyteLQ Berachain Delegator Shares
    Updated 24 hours ago
    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
    No Data to Display
    0
    2B
    2s