KeyrockSOL-USDC TVL (API) [2]
    Updated 2024-05-23
    WITH raw_data AS (
    SELECT
    livequery.live.udf_api(
    'https://dlmm-api.meteora.ag/pair/4YVLUZGEhsjfsWuxRbo6h18vL297HYRHTrLVE8bwpyCW/analytic/pair_tvl?num_of_days=90'
    ) AS resp
    )

    SELECT
    flattened.value:day_date::DATE AS date,
    flattened.value:total_value_locked::DECIMAL(18, 4) AS tvl
    FROM
    raw_data,
    LATERAL FLATTEN(input => PARSE_JSON(RESP):data) AS flattened;



    QueryRunArchived: QueryRun has been archived