Query editor
SELECTDATE_TRUNC('week', (TIMESTAMP - INTERVAL '3' day)) + INTERVAL '3' day AS week_start,chain,SUM(AMOUNT_USD) AS amount_usd,SUM(SUM(AMOUNT_USD)) OVER (PARTITION BY chainORDER BY DATE_TRUNC('week', (TIMESTAMP - INTERVAL '3' day))) AS cumulative_sum_per_chain,SUM(SUM(AMOUNT_USD)) OVER (ORDER BY DATE_TRUNC('week', (TIMESTAMP - INTERVAL '3' day))) AS cumulative_sum_all_chainsFROMquery_4806917 feesGROUP BYDATE_TRUNC('week', (TIMESTAMP - INTERVAL '3' day)),chainORDER BYchain, week_start DESC;