0xHaM-dَTVL
    Updated 2025-03-14
    with defiLama as (
    SELECT
    value:tvl::int as number ,
    value:date as date
    FROM
    (
    SELECT
    livequery.live.udf_api('https://api.llama.fi/v2/historicalChainTvl/Aptos')::variant as response

    )
    ,lateral flatten(input => response:data)
    )
    Select *
    from
    (select
    cast(date as timestamp) AS date,
    number as TVL,
    from defiLama
    )
    order by date desc


    Last run: 24 days ago
    DATE
    TVL
    1
    2025-03-14 00:00:00.000946622210
    2
    2025-03-13 00:00:00.000939701559
    3
    2025-03-12 00:00:00.000933785303
    4
    2025-03-11 00:00:00.000934134652
    5
    2025-03-10 00:00:00.000929597021
    6
    2025-03-09 00:00:00.000989715105
    7
    2025-03-08 00:00:00.000983160177
    8
    2025-03-07 00:00:00.0001011044844
    9
    2025-03-06 00:00:00.0001011274273
    10
    2025-03-05 00:00:00.000994416572
    11
    2025-03-04 00:00:00.000947329851
    12
    2025-03-03 00:00:00.0001026685361
    13
    2025-03-02 00:00:00.0001007440145
    14
    2025-03-01 00:00:00.0001015353713
    15
    2025-02-28 00:00:00.000939202314
    16
    2025-02-27 00:00:00.000939041176
    17
    2025-02-26 00:00:00.000917060073
    18
    2025-02-25 00:00:00.000895354699
    19
    2025-02-24 00:00:00.000954200440
    20
    2025-02-23 00:00:00.000983741490
    ...
    876
    32KB
    1s