KeyrockKeyrock Fees
    Updated 2024-02-28
    WITH raw_data AS (
    SELECT
    livequery.live.udf_api(
    'https://dlmm-api.meteora.ag/wallet/GcsbRotLHuHGc3tzE7XBVQ2sNgAMJqbkeGuzjTAwxPfQ/3msVd34R5KxonDzyNSV5nT19UtUeJ2RF1NaQhvVPNLxL/earning'
    ) AS resp
    )

    SELECT
    PARSE_JSON(resp):data:total_fee_usd_claimed as keyrock_fees
    FROM raw_data



    QueryRunArchived: QueryRun has been archived