SELECT
DATE_TRUNC('week', date) AS day,
chain,
COUNT(DISTINCT protocol) AS daily_prot
FROM external.defillama.fact_protocol_tvl
WHERE chain IN(
'Scroll',
'Taiko',
'zkSync Era',
'Starknet',
'Linea',
'Polygon zkEVM'
-- ,'Astar zkEVM'
)
GROUP BY 1, 2
ORDER BY 1 DESC, 3 DESC