adriaparcerisasflow defi tvl by protocol all
    Updated 7 days ago
    select
    trunc(x.date,'day') as week,
    x.protocol,
    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')
    group by 1,2 order by 1 desc,2


    Last run: 7 days ago
    WEEK
    PROTOCOL
    TVL
    1
    2025-05-18 00:00:00.000Ankr10910727
    2
    2025-05-18 00:00:00.000Fixes Launchpad1256
    3
    2025-05-18 00:00:00.000Fixes frc2027491
    4
    2025-05-18 00:00:00.000Fixes frc20 Staking26083
    5
    2025-05-18 00:00:00.000Increment Lending1929954.5
    6
    2025-05-18 00:00:00.000Increment Liquid Staking3975650
    7
    2025-05-18 00:00:00.000Increment Swap12312894
    8
    2025-05-18 00:00:00.000KittyPunch PunchSwap10335694
    9
    2025-05-18 00:00:00.000KittyPunch PunchSwap V37473514
    10
    2025-05-18 00:00:00.000KittyPunch StableKitty21492381
    11
    2025-05-18 00:00:00.000MORE Markets9435192
    12
    2025-05-18 00:00:00.000Sturdy V21080165.5
    13
    2025-05-18 00:00:00.000Trado Perpetual304416
    14
    2025-05-18 00:00:00.000Trado Spot815500
    15
    2025-05-17 00:00:00.000Ankr10809120
    16
    2025-05-17 00:00:00.000Fixes Launchpad1310
    17
    2025-05-17 00:00:00.000Fixes frc2027748
    18
    2025-05-17 00:00:00.000Fixes frc20 Staking26208
    19
    2025-05-17 00:00:00.000Increment Lending1926201
    20
    2025-05-17 00:00:00.000Increment Liquid Staking3960953
    ...
    5537
    295KB
    3s