*,

avg(avg_sales_price) OVER(

PARTITION BY token_name

ORDER BY day

ROWS BETWEEN 7 PRECEDING AND CURRENT ROW) as week_price_moving_avg,

sum(sales_volume) OVER(

PARTITION BY token_name

ORDER BY day) as total_volume

FROM (

SELECT

date_trunc('day', block_timestamp) as day,

token_name,

count(DISTINCT tx_id) as sales,

COUNT(DISTINCT PURCHASER) as buyers,

COUNT(DISTINCT SELLER) as sellers,

sum(sales_amount) as sales_volume,

avg(sales_amount) as avg_sales_price

FROM solana.core.fact_nft_sales

LEFT outer JOIN solana.core.dim_nft_metadata

ON solana.core.fact_nft_sales.mint = solana.core.dim_nft_metadata.mint

WHERE token_name LIKE '{{collection}}' --IN ('Degen Apes', 'DeGods', 'Catalina Whale Mixer', 'Primates')

GROUP BY 1,2