SELECT
DATE_TRUNC('week', block_timestamp) AS "week",
SUM(price_usd) AS "sales Volume in USD",
SUM(price) AS "Sales Volume in ETH",
CASE
WHEN platform_name ='opensea' THEN 'opensea'
WHEN platform_name = 'blur' THEN 'blur'
WHEN platform_name = 'looksrare' THEN 'looksrare'
END AS "platform"
FROM ethereum.core.ez_nft_sales
WHERE platform_name IN ('opensea', 'blur', 'looksrare')
AND DATE_TRUNC('week', block_timestamp) BETWEEN '2023-01-01' AND '2023-08-31'
GROUP BY "week", "platform"
ORDER BY "week"
;