pietrekttest here
    Updated 2024-09-27
    WITH thornode_call AS (SELECT
    livequery.live.udf_api('https://thornode.ninerealms.com/thorchain/runepool') as rawoutput),

    formatted_results as (
    SELECT
    rawoutput:data:providers:units::string as uni
    FROM thornode_call
    )

    select * from formatted_results

    QueryRunArchived: QueryRun has been archived