DATE_TRUNC('week', block_timestamp) AS week,

platform_name,

SUM(platform_fee_usd) AS total_platform_fees,

SUM(creator_fee) AS total_creator_fees,

SUM(tx_fee_usd) AS total_gas_fees

FROM

optimism.nft.ez_nft_sales

GROUP BY

DATE_TRUNC('week', block_timestamp),

platform_name

ORDER BY

week,

platform_name;