address_name AS nft_collection,

Count(DISTINCT(tx_id)) AS no_of_nfts_sold,

Count(DISTINCT(purchaser)) AS no_of_buyers,

Count(DISTINCT(seller)) AS no_of_sellers,

Round(Sum(sales_amount),2) AS tot_sol_volume,

Round(Avg(sales_amount),2) AS avg_sol_volume,

Min(sales_amount) AS nft_floor_price,

avg(tot_sol_volume) OVER (ORDER BY day rows BETWEEN 7 PRECEDING AND CURRENT row) AS ma_sol_volume

FROM solana.core.fact_nft_sales a

JOIN solana.core.dim_labels b

ON a.mint = b.address

WHERE address_name IN ('The Suites',

'Collectorz Club: The Collectorz',

'Laidback Lions',

'Hockey Heroes')

AND block_timestamp >= CURRENT_DATE - {{time_period}}

group by

day, address_name

order by

day desc