date_trunc(week, block_timestamp) as week,

case

when marketplace ilike '%coral cube%' then 'Coral Cube'

when marketplace ilike '%magic eden%' then 'Magic Eden'

when marketplace ilike 'tensorswap' then 'Tensor'

when marketplace ilike 'solana monkey business marketplace' then 'SMB Marketplace'

else initcap(marketplace)

end as marketplace_normalized,

count(distinct tx_id) as txs,

count(distinct purchaser) as buyers,

count(distinct seller) as sellers,

count(distinct mint) as nfts_sold,

sum(sales_amount) sol_amount

solana.nft.fact_nft_sales

week < date_trunc(week, current_date)

group by

week,

marketplace_normalized

order by week desc