adriaparcerisasstablekitty tvl
    Updated 7 days ago
    select
    trunc(x.date,'day') as week,
    avg(chain_tvl) as tvl
    --sum(volume) as dex_volume,
    --sum(dex_volume) over (order by week) as total_dex_volume
    from external.defillama.fact_protocol_tvl x
    --join external.defillama.fact_dex_volume y on lower(x.chain)=y.chain and x.date=y.date
    where x.chain ilike '%Flow%' and week>='2025-01-01'
    and protocol='KittyPunch StableKitty'
    group by 1 order by 1 desc


    Last run: 7 days ago
    WEEK
    TVL
    1
    2025-05-05 00:00:00.00019592525
    2
    2025-05-04 00:00:00.00018281743
    3
    2025-05-03 00:00:00.00019721248
    4
    2025-05-02 00:00:00.00017629367
    5
    2025-05-01 00:00:00.00016358568
    6
    2025-04-30 00:00:00.00016341317
    7
    2025-04-29 00:00:00.00015329720
    8
    2025-04-28 00:00:00.00012546414
    9
    2025-04-27 00:00:00.00012546414
    10
    2025-04-26 00:00:00.00012210119
    11
    2025-04-25 00:00:00.00012122150
    12
    2025-04-24 00:00:00.00012296443
    13
    2025-04-23 00:00:00.00012420494
    14
    2025-04-22 00:00:00.00011319953
    15
    2025-04-21 00:00:00.00011910210
    16
    2025-04-20 00:00:00.00011863194
    17
    2025-04-19 00:00:00.00010017669
    18
    2025-04-18 00:00:00.00011131556
    19
    2025-04-17 00:00:00.00010011105
    20
    2025-04-16 00:00:00.00010855086
    80
    3KB
    1s