SELECT
*,
sum(new_users) over (ORDER by first_week) as total_users
FROM (
SELECT
first_week,
count(*) as new_users
FROM (
SELECT
--date_trunc('week', block_timestamp) as week,
trader,
min(date_trunc('week', block_timestamp)) as first_week
FROM near.core.ez_dex_swaps
GROUP by 1
)
GROUP BY 1
)