--sales.marketplace,

count (sales.tx_id) as number_sales,

sum (number_sales) over (order by fecha) as cumulative_sales,

sum (sales.sales_amount) as volume_sales,

sum (volume_sales) over (order by fecha) as cumulative_volume,

count (distinct purchaser) as unique_purchasers

from flipside_prod_db.solana.fact_nft_sales sales

inner join flipside_prod_db.solana.dim_nft_metadata dat

on sales.mint = dat.mint

where fecha >= '2022-04-25'

and dat.project_name = 'Catalina Whale Mixer'

and sales.succeeded = 'TRUE'

group by 1--,2

order by 1