adriaparcerisasflow defi tvl by protocol
    Updated 5 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') and week>='2025-01-01'
    group by 1,2 order by 1 desc,2
    Last run: 5 days ago
    WEEK
    PROTOCOL
    TVL
    1
    2025-05-25 00:00:00.000Ankr10592408
    2
    2025-05-25 00:00:00.000Fixes Launchpad1199
    3
    2025-05-25 00:00:00.000Fixes frc2026678
    4
    2025-05-25 00:00:00.000Fixes frc20 Staking25653
    5
    2025-05-25 00:00:00.000Increment Lending1852952.5
    6
    2025-05-25 00:00:00.000Increment Liquid Staking3875306
    7
    2025-05-25 00:00:00.000Increment Swap12478211
    8
    2025-05-25 00:00:00.000KittyPunch PunchSwap10067201
    9
    2025-05-25 00:00:00.000KittyPunch PunchSwap V36155473
    10
    2025-05-25 00:00:00.000KittyPunch StableKitty18639281
    11
    2025-05-25 00:00:00.000MORE Markets8614730
    12
    2025-05-25 00:00:00.000Sturdy V21046711.5
    13
    2025-05-25 00:00:00.000Trado Perpetual304377
    14
    2025-05-25 00:00:00.000Trado Spot778717
    15
    2025-05-24 00:00:00.000Ankr10894599
    16
    2025-05-24 00:00:00.000Fixes Launchpad1235
    17
    2025-05-24 00:00:00.000Fixes frc2027540
    18
    2025-05-24 00:00:00.000Fixes frc20 Staking26302
    19
    2025-05-24 00:00:00.000Increment Lending1927061
    20
    2025-05-24 00:00:00.000Increment Liquid Staking3992223
    ...
    1824
    95KB
    3s