DATE_TRUNC('week', DATE) AS week,

CHAIN,

AVG(TVL_USD) AS TVL_USD

FROM external.defillama.fact_chain_tvl

WHERE CHAIN IN (

'Fantom',

'Ethereum',

'Avalanche',

'Optimism',

'Arbitrum',

'Polygon',

'xDai',

'Binance',

'Manta',

'Linea',

'Scroll',

'Base'

AND DATE >= CURRENT_DATE - INTERVAL '4 YEARS'

GROUP BY 1, 2

ORDER BY 1 DESC