DATE_TRUNC('week', date) AS week,

symbol,

SUM(tvl_usd) AS total_tvl_usd

external.defillama.fact_pool_yields

projects ILIKE '%thala%'

GROUP BY

week, symbol

ORDER BY

week ASC, symbol;