SELECT
DATE_TRUNC('week', block_timestamp) AS week_start_date,
COUNT(DISTINCT origin_from_address) AS weekly_traders,
COUNT(*) AS weekly_transactions
FROM
polygon.defi.ez_dex_swaps
WHERE
block_timestamp >= DATEADD(DAY, -30, CURRENT_DATE())
GROUP BY
week_start_date
ORDER BY
week_start_date;