Query editor
1SELECT DATE_TRUNC('week',day) AS WEEK, name, SUM(l2_rev_usd) AS L2_Rev_USD2FROM rollup_economics_ethereum.l2_revenue3GROUP BY 1,2
SELECT DATE_TRUNC('week',day) AS WEEK, name, SUM(l2_rev_usd) AS L2_Rev_USD
FROM rollup_economics_ethereum.l2_revenue
GROUP BY 1,2