adriaparcerisasstablekitty tvl
    Updated 2025-04-14
    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<trunc(current_date,'day') and week>='2025-01-01'
    and protocol='KittyPunch StableKitty'
    group by 1 order by 1 desc


    Last run: 13 days ago
    WEEK
    TVL
    1
    2025-04-13 00:00:00.00010692228
    2
    2025-04-12 00:00:00.00010625002
    3
    2025-04-11 00:00:00.00010277092
    4
    2025-04-10 00:00:00.00010204186
    5
    2025-04-09 00:00:00.00010325284
    6
    2025-04-08 00:00:00.00010393640
    7
    2025-04-07 00:00:00.00010529905
    8
    2025-04-06 00:00:00.00011129412
    9
    2025-04-05 00:00:00.00011175514
    10
    2025-04-04 00:00:00.00011173373
    11
    2025-04-03 00:00:00.00011237758
    12
    2025-04-02 00:00:00.00011765332
    13
    2025-04-01 00:00:00.00011738934
    14
    2025-03-31 00:00:00.00011397138
    15
    2025-03-30 00:00:00.00010963294
    16
    2025-03-29 00:00:00.00010956299
    17
    2025-03-28 00:00:00.00011084576
    18
    2025-03-27 00:00:00.00011563193
    19
    2025-03-26 00:00:00.00011592429
    20
    2025-03-25 00:00:00.00011511578
    58
    2KB
    1s