select date_trunc('week', block_timestamp) as date,

address_name as name,

count (distinct tx_id) as no_of_sales,

count (distinct purchaser) as total_purchasers,

avg(total_purchasers) over (partition by name order by date) as average_purchasers,

count (distinct seller) as total_sellers,

count (distinct sales.mint) as total_mints,

count (distinct marketplace) as unique_markets,

sum (sales_amount) as sales_amount_volume,

avg (sales_amount) as average_sales_volume,

avg (sales_amount_volume) over (partition by name order by date rows between 6 preceding and current row) as "7-day moving average"

from solana.core.fact_nft_sales sales

join solana.core.dim_labels label on sales.mint=label.address

where (address_name in ('Collectorz Club: The Collectorz','The Suites','the suites token','Laidback Lions','Sports Rewind', 'stepn - run to earn')

or label like '%stepn%')

and SUCCEEDED = 'TRUE' and sales_amount > 0

group by date,name order by date

select * from solana