BlockTrackerapi prime protocol total borrowed-volume
    Updated 2023-09-21

    WITH
    json as (
    SELECT
    livequery.live.udf_api (
    'https://api.llama.fi/protocol/prime-protocol'
    ) AS response
    ),
    main as (
    SELECT
    TO_DATE(value:date::string) as dates,
    value:tokens as tokens_json
    FROM
    json,
    LATERAL FLATTEN(input => response:data:chainTvls:"{{chain}}-borrowed":tokensInUsd)
    )

    SELECT
    DISTINCT dates,
    f.key::string AS token,
    f.value::double AS borrowed_volume
    FROM main
    ,LATERAL FLATTEN(input => tokens_json) f
    WHERE dates < current_date
    ORDER BY dates DESC











    Run a query to Download Data