SELECT *,

CASE WHEN marketplace = 'opensea' THEN sales_amount END as opensea,

CASE WHEN marketplace = 'magic eden v2' THEN sales_amount END as magic_eden_v2,

CASE WHEN marketplace = 'solana monkey business marketplace' THEN sales_amount END as monkey_business,

CASE WHEN marketplace = 'solanart' THEN sales_amount END as solanart,

CASE WHEN marketplace = 'yawww' THEN sales_amount END as yawww,

CASE WHEN marketplace = 'solport' THEN sales_amount END as solport,

CASE WHEN marketplace = 'magic eden v1' THEN sales_amount END as magic_eden_v1

FROM solana.core.fact_nft_sales

WHERE block_timestamp > CURRENT_DATE - 365

SELECT

block_timestamp::date as date,

sum(opensea) as "OpenSea",

sum(magic_eden_v1) as "Magic Eden V1",

sum(magic_eden_v2) as "Magic Eden V2",

sum(solport) as "Solport",

sum(yawww) as "Yawww",

sum(solanart) as "Solanart",

sum(monkey_business) as "Solana Monkey Business Marketplace"

--COUNT(DISTINCT tx_id) as tx_count,

--COUNT(DISTINCT purchaser) as buyer_count,

--sum(sales_amount) as sol_amount

FROM sales

GROUP BY date