Query editor
WITH weekly AS (SELECTdate_trunc('week', CAST(time AS DATE)) AS week,token,market_cap,ROW_NUMBER() OVER (PARTITION BY date_trunc('week', CAST(time AS DATE)), token ORDER BY time DESC) AS rnFROM query_4356428)SELECTweek,SUM(market_cap) / 1e6 AS total_rwa_millionsFROM weeklyWHERE rn = 1GROUP BY 1ORDER BY 1