WITH t0 AS (

SELECT date_trunc('week', block_timestamp) AS week

, CASE

WHEN marketplace LIKE 'magic%' THEN 'A. Magic Eden'

WHEN marketplace LIKE 'tensorswap' THEN 'B. Tensor'

ELSE 'C. Others' END AS marketplace

, SUM(sales_amount) AS volume

FROM solana.core.fact_nft_sales

WHERE week >= '2022-09-01'

AND succeeded

AND sales_amount < 10000

GROUP BY 1, 2

SELECT *

, SUM(volume) OVER (PARTITION BY week) AS tot_volume

, ROUND(100 * volume / tot_volume, 1) AS pct_volume

FROM t0

WHERE week <= '2022-12-12'

AND marketplace = 'B. Tensor'