SELECT

DATE_TRUNC('week', block_timestamp) as _date,

currency_symbol,

SUM(platform_fee) AS total_platform_fee,

SUM(platform_fee_usd) AS total_platform_fees_usd

FROM ethereum.core.ez_nft_sales

WHERE block_timestamp::DATE BETWEEN '2022-01-01' AND '2022-06-30'

AND platform_name = 'opensea'

GROUP BY 1, 2

ORDER BY 1, 4 DESC;