-- forked from a90c217f-c207-45dc-8efc-7dd316ba5733
SELECT
DATE,
CHAIN,
TVL_USD
FROM external.defillama.fact_chain_tvl
WHERE CHAIN IN('Arbitrum','Tron', 'Binance', 'Polygon', 'Optimism', 'Avalanche', 'Fantom')
AND DATE> Current_Date-180
ORDER BY 1 DESC