SELECT

chain,

tvl_usd,

DATE,

ROW_NUMBER() OVER (PARTITION BY chain ORDER BY DATE DESC) AS row_num

FROM external.defillama.fact_chain_tvl

WHERE (CHAIN = 'Arbitrum' OR chain LIKE '%Optimism%' OR chain LIKE '%Base%')

AND DATE < '2024-07-01'

SELECT chain, tvl_usd

FROM RankedTVL

WHERE row_num = 1;