SELECT date_trunc('week', s.block_timestamp) AS week

, CASE

WHEN marketplace ILIKE 'magic%' THEN 'A: Magic Eden'

WHEN marketplace ILIKE 'hadeswap%' THEN 'C: Hadeswap'

WHEN marketplace ILIKE 'coral cube%' THEN 'D: Coral Cube'

WHEN marketplace ILIKE 'tensorswap%' THEN 'B: Tensorswap'

ELSE 'E: Others' END AS marketplace

-- ELSE INITCAP(marketplace) END AS marketplace

, SUM(sales_amount) AS volume

, COUNT(DISTINCT purchaser) AS n_buyers

FROM solana.core.fact_nft_sales s

WHERE block_timestamp >= '2023-01-01'

AND succeeded

AND sales_amount <= 10000

GROUP BY 1, 2