cybergenlab[Ecosystem Overview] Network TVL
    Updated 2024-11-17
    with defiLlama as (
    select
    livequery.live.udf_api(
    'https://api.llama.fi/v2/historicalChainTvl/Arbitrum'
    ) as response
    )

    , tvl as (
    select
    date,
    avg(tvl) as tvl
    from(
    select
    date_trunc('month',to_date(tvl.value:date::string)) as date,
    tvl.value:tvl as TVL -- This TVL excluding liquid staking according to Defillama
    from defiLlama
    join lateral flatten (input => response:data) tvl
    )
    where date >= dateadd(year, -1, date_trunc('month',current_date()))
    and date < date_trunc('month',current_date())
    group by 1
    )

    select
    date,
    tvl
    from tvl
    order by 1 desc
    Last run: about 2 months ago
    DATE
    TVL
    1
    2024-10-01 00:00:00.0002386700604.1354
    2
    2024-09-01 00:00:00.0002564686341.32129
    3
    2024-08-01 00:00:00.0002739142817.60841
    4
    2024-07-01 00:00:00.0002978164615.19087
    5
    2024-06-01 00:00:00.0002932237060.79059
    6
    2024-05-01 00:00:00.0002699828448.43396
    7
    2024-04-01 00:00:00.0002630948844.98988
    8
    2024-03-01 00:00:00.0002921887416.76416
    9
    2024-02-01 00:00:00.0002578228185.83987
    10
    2024-01-01 00:00:00.0002384068317.87078
    11
    2023-12-01 00:00:00.0002242126842.31919
    12
    2023-11-01 00:00:00.0002004811961.0629
    12
    539B
    1s