Updated 2025-02-18
    -- forked from TVL growth (>$10M, <$100M) @ https://flipsidecrypto.xyz/studio/queries/cb5dc7bd-1e91-479c-a40a-b5320cc6cae5

    -- forked from TVL growth (>$100M) @ https://flipsidecrypto.xyz/studio/queries/884d00a0-026d-41a4-8c34-575e3a6f69a6

    with tmp as
    (select
    date,
    chain,
    tvl_usd,
    base_tvl,
    tvl_usd/base_tvl as weekly_growth,
    row_number() over(partition by chain order by date desc) as last_day_rn
    from
    (select
    date,
    chain,
    tvl_usd,
    first_value(tvl_usd) over(partition by chain order by date) as base_tvl
    from external.defillama.fact_chain_tvl
    where date >= current_date() - interval '7 days'
    and tvl_usd >= 1000000
    and chain != 'Map') t1
    ),

    top10_growth as
    (
    select
    chain,
    tvl_usd,
    weekly_growth
    from tmp
    where last_day_rn = 1
    and tvl_usd <= 10000000
    -- and tvl_usd > 10000000
    order by weekly_growth desc
    limit 10
    Last run: 3 months agoAuto-refreshes every 12 hours
    CHAIN
    TVL_USD
    WEEKLY_GROWTH
    1
    Unichain86438832.94425
    2
    Dymension34141611.636597
    3
    Meter19033541.441481
    4
    Sora23762781.159562
    5
    Newton18379061.131311
    6
    Dexalot60187271.063493
    7
    HAQQ43625451.054796
    8
    smartBCH12120451.053008
    9
    Horizen EON34959561.047669
    10
    Kroma54467071.037688
    10
    287B
    2s