date_trunc('day', block_timestamp) as day,

address_name,

count(distinct TX_ID) as total_number_of_sales,

avg(total_number_of_sales) over (partition by address_name order by day asc rows between 7 preceding and current row) as "Number of Sales Moving Average",

sum(SALES_AMOUNT) as total_sales_price,

sum(total_sales_price) over (partition by address_name order by day asc) as cum_sales_price,

avg(total_sales_price) over (partition by address_name order by day asc rows between 7 preceding and current row) as "Moving Average"

from

solana.core.fact_nft_sales a join solana.core.dim_labels b on a.MINT=b.ADDRESS

where

SUCCEEDED and

address_name in ('Collectorz Club: The Collectorz') --,'','collectorz club gen1','The Suites','Laidback Lions','Sports Rewind')

group by

1, 2

order by

1 asc