permaryDaily TVL
    Updated 2025-05-31
    with klaytn_tvl as (
    with json as (
    select defillama.get('/v2/historicalChainTvl/Klaytn', {}) as resp
    )
    select
    to_timestamp(value:date::string) as date,
    value:tvl as tvl_usd
    from json, lateral flatten(input => resp:data)
    )

    select
    date,
    max(tvl_usd) as "daily tvl [usd]"
    from klaytn_tvl
    where date >= current_date - interval '30 days'
    group by date
    order by date;



    Last run: 14 days ago
    DATE
    daily tvl [usd]
    1
    2025-05-01 00:00:00.000
    28400105
    2
    2025-05-02 00:00:00.000
    29026953
    3
    2025-05-03 00:00:00.000
    29686001
    4
    2025-05-04 00:00:00.000
    28996503
    5
    2025-05-05 00:00:00.000
    27876699
    6
    2025-05-06 00:00:00.000
    27793819
    7
    2025-05-07 00:00:00.000
    27027552
    8
    2025-05-08 00:00:00.000
    26705094
    9
    2025-05-09 00:00:00.000
    28781354
    10
    2025-05-10 00:00:00.000
    28876416
    11
    2025-05-11 00:00:00.000
    30068096
    12
    2025-05-12 00:00:00.000
    29648041
    13
    2025-05-13 00:00:00.000
    30942517
    14
    2025-05-14 00:00:00.000
    32018349
    15
    2025-05-15 00:00:00.000
    31574941
    16
    2025-05-16 00:00:00.000
    30668007
    17
    2025-05-17 00:00:00.000
    29903772
    18
    2025-05-18 00:00:00.000
    29270766
    19
    2025-05-19 00:00:00.000
    29280357
    20
    2025-05-20 00:00:00.000
    29656566
    31
    1KB
    26s