adriaparcerisasflow defi tvl by protocol all
    Updated 1 day 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: 1 day ago
    WEEK
    PROTOCOL
    TVL
    1
    2025-04-21 00:00:00.000Ankr6512638
    2
    2025-04-21 00:00:00.000Fixes Launchpad1073
    3
    2025-04-21 00:00:00.000Fixes frc2025370
    4
    2025-04-21 00:00:00.000Fixes frc20 Staking24068
    5
    2025-04-21 00:00:00.000Increment Lending2000923
    6
    2025-04-21 00:00:00.000Increment Liquid Staking4496395
    7
    2025-04-21 00:00:00.000Increment Swap15874694
    8
    2025-04-21 00:00:00.000KittyPunch PunchSwap7977713
    9
    2025-04-21 00:00:00.000KittyPunch PunchSwap V31293547
    10
    2025-04-21 00:00:00.000KittyPunch StableKitty11910210
    11
    2025-04-21 00:00:00.000MORE Markets13554783
    12
    2025-04-21 00:00:00.000Sturdy V2819985.5
    13
    2025-04-21 00:00:00.000Trado Perpetual304365
    14
    2025-04-21 00:00:00.000Trado Spot1671885
    15
    2025-04-20 00:00:00.000Ankr6358772
    16
    2025-04-20 00:00:00.000Fixes Launchpad1007
    17
    2025-04-20 00:00:00.000Fixes frc2024911
    18
    2025-04-20 00:00:00.000Fixes frc20 Staking23540
    19
    2025-04-20 00:00:00.000Increment Lending1964780
    20
    2025-04-20 00:00:00.000Increment Liquid Staking4410623
    ...
    2961
    154KB
    2s