SELECT DATE_TRUNC('week', BLOCK_TIMESTAMP) AS WEEK,

ORIGIN_FROM_ADDRESS

FROM optimism.core.ez_dex_swaps

WHERE PLATFORM = 'velodrome'

),

first_week_users AS (

SELECT ORIGIN_FROM_ADDRESS,

MIN(WEEK) AS FIRST_WEEK

FROM weekly_users

GROUP BY ORIGIN_FROM_ADDRESS

SELECT DATE_TRUNC('week', FIRST_WEEK) AS WEEK,

COUNT(DISTINCT ORIGIN_FROM_ADDRESS) AS NEW_USERS

FROM first_week_users

GROUP BY WEEK

ORDER BY WEEK DESC;