avg(avg_price) OVER(ORDER BY day ROWS BETWEEN 7 PRECEDING AND CURRENT ROW ) as sevenday_moving_avg_price

FROM (SELECT date_trunc('day', block_timestamp) as day,

sum(price) as volume,

avg(price) as avg_price,

median(price) as median_price,

count(DISTINCT tx_id) as sales,

count(DISTINCT buyer) as buyers,

(sum(price))/(count(DISTINCT buyer)) as avg_vol_per_buyer

FROM flow.core.ez_nft_sales

WHERE NFT_COLLECTION LIKE '%RaceDay%'

GROUP BY 1

)