DATE_TRUNC('day', date) AS day,

protocol,

SUM(chain_tvl) AS tvl_usd

FROM external.defillama.fact_protocol_tvl

WHERE chain IN('scroll', 'Scroll')

AND protocol = 'AAVE V3'

GROUP BY 1,2

ORDER BY 1 DESC