DATE_TRUNC('week', date) AS week,

category,

protocol,

symbol,

market_cap,

SUM(chain_tvl) AS total_chain_tvl

external.defillama.fact_protocol_tvl

protocol ILIKE '%thala%'

GROUP BY

week, category, protocol, symbol, market_cap

ORDER BY

week, category, protocol;