tkvresearchTotal value locked I L2
    Updated 2024-01-03
    with

    A as( select date, sum(tvl_usd) as tvl
    from external.defillama.fact_chain_tvl
    where chain in ('Arbitrum','Optimism','Base','Manta','Kroma','Scroll','zkSync Era','Polygon zkEVM','Linea',
    'Starknet','Aurora','Mantle')
    and tvl_usd > 0
    and date >= '2022-12-18'
    group by 1)

    select *,
    (tvl / (select tvl from A order by date limit 1) - 1)*100 as tvl_change
    from A
    where day(date) = '01'
    order by date desc

    QueryRunArchived: QueryRun has been archived