freemartianAmnis TVL
    Updated 2025-01-13
    WITH datas AS (
    SELECT livequery.live.udf_api(
    'GET',
    'https://api.llama.fi/protocol/amnis-finance',
    {'content-type':'application/json;charset=utf-8'},
    {}
    ) AS res
    )

    SELECT

    to_timestamp(value:date) AS day,
    value:totalLiquidityUSD AS liquidity

    FROM datas,
    LATERAL FLATTEN (input => res:data:tvl)

    WHERE day BETWEEN '{{start_time}}' AND '{{end_time}}'
    Auto-refreshes every 1 hour
    QueryRunArchived: QueryRun has been archived