SELECT date_trunc('week',block_timestamp) as wk,

CASE WHEN marketplace LIKE 'magic eden%' THEN 'magic eden'

WHEN marketplace LIKE 'solana monkey business%' THEN 'SMB' ELSE marketplace END marketplace,

count(distinct purchaser) as unique_buyer, sum(sales_amount) as volume

FROM solana.core.fact_nft_sales

WHERE SUCCEEDED = TRUE

GROUP BY 1,2

ORDER BY 1