WITH weekly_activity AS (
SELECT
date_trunc('WEEK', BLOCK_TIMESTAMP) AS week,
SUM(ABS(PRICE_USD)) AS weekly_volume,
COUNT(DISTINCT ORIGIN_FROM_ADDRESS) AS weekly_users
FROM
base.nft.ez_nft_sales
GROUP BY week
ORDER BY week DESC
)
SELECT
week,
weekly_volume,
weekly_users
FROM
weekly_activity
WHERE
week IS NOT NULL
AND week >= '2024-01-01'
ORDER BY week DESC;