case marketplace

when 'magic eden v2' then 'magic eden'

when 'magic eden v1' then 'magic eden'

else marketplace

end as marketplace,

sum(sales_amount) as volume

from solana.core.fact_nft_sales

where block_timestamp >= '2022-09-01' and block_timestamp < CURRENT_DATE

and succeeded = True

group by 1,2

order by 3 desc