0xHaM-dTOP TVLs
    Updated 2025-03-14
    -- forked from Azin / Total @ https://flipsidecrypto.xyz/Azin/q/il_xLYclKaMW/total

    -- https://flipsidecrypto.xyz/Azin/aptos-weekly-report-nnUhLr
    with
    amnis_finance as
    (SELECT
    value:totalLiquidityUSD::int as number ,

    value:date as date
    FROM

    (SELECT
    livequery.live.udf_api('https://api.llama.fi/protocol/amnis-finance')::variant as response
    )

    ,lateral flatten(input => response:data:tvl)
    )
    ,

    thala as
    (SELECT
    value:totalLiquidityUSD::int as number ,

    value:date as date
    FROM

    (SELECT
    livequery.live.udf_api('https://api.llama.fi/protocol/thala')::variant as response
    )

    ,lateral flatten(input => response:data:tvl)
    )
    ,

    liquidswap as
    (SELECT
    QueryRunArchived: QueryRun has been archived