BlockTrackerchain TVL [Dominance]
    Updated 2025-05-14
    with base_tvl as (
    select
    'Base' as chain,
    date,
    tvl_usd as tvl_usd
    from external.defillama.fact_chain_tvl
    where date >= dateadd(day, -{{past_days}}, current_date())
    and chain = 'Base'
    )
    , avalanche_tvl as (
    select
    'Avalanche' as chain,
    date,
    tvl_usd as tvl_usd
    from external.defillama.fact_chain_tvl
    where date >= dateadd(day, -{{past_days}}, current_date())
    and chain = 'Avalanche'
    )
    select
    *
    from base_tvl
    union all
    select *
    from avalanche_tvl



    Last run: 25 days ago
    CHAIN
    DATE
    TVL_USD
    1
    Base2025-05-14 00:00:00.0004610582647
    2
    Avalanche2025-05-14 00:00:00.0001959987683
    3
    Base2025-04-10 00:00:00.0003445653297
    4
    Base2025-04-09 00:00:00.0003197605077
    5
    Base2025-04-06 00:00:00.0003770037992
    6
    Base2025-04-08 00:00:00.0003318754057
    7
    Base2025-04-07 00:00:00.0003509638962
    8
    Base2025-04-05 00:00:00.0003782164782
    9
    Base2025-04-03 00:00:00.0003583161368
    10
    Base2025-04-02 00:00:00.0003539160175
    11
    Base2025-04-01 00:00:00.0003530776064
    12
    Base2025-03-31 00:00:00.0003488574831
    13
    Base2025-03-29 00:00:00.0003601104621
    14
    Base2025-04-04 00:00:00.0003628218984
    15
    Base2025-02-16 00:00:00.0003958070282
    16
    Base2025-02-28 00:00:00.0003557832026
    17
    Base2025-03-03 00:00:00.0003843336488
    18
    Base2025-03-02 00:00:00.0003546280296
    19
    Base2025-03-01 00:00:00.0003508399427
    20
    Base2025-02-27 00:00:00.0003567887740
    ...
    182
    9KB
    1s