PLATFORM,

DATE_TRUNC('week', TO_TIMESTAMP_NTZ(block_timestamp)) AS week_start_date,

COUNT(DISTINCT ORIGIN_FROM_ADDRESS) AS weekly_users,

SUM(COUNT(DISTINCT ORIGIN_FROM_ADDRESS)) OVER (PARTITION BY PLATFORM ORDER BY DATE_TRUNC('week', TO_TIMESTAMP_NTZ(block_timestamp))) AS cumulative_users

FROM optimism.core.ez_dex_swaps

GROUP BY

PLATFORM,

week_start_date

ORDER BY

PLATFORM,

week_start_date;