date(block_timestamp) as day,

count(distinct nft_id) as no_of_nfts_sold,

round(sum(price),2) as total_volume,

round(avg(price),2) as avg_volume,

avg(avg_volume) over (order by day

rows between 7 preceding and current row ) as day7_moving_avg,

count(distinct tx_id) as no_of_sales,

count(distinct buyer) as no_of_buyers,

count(distinct seller) as no_of_sellers

from flow.core.ez_nft_sales

where nft_collection like '%A.329feb3ab062d289.RaceDay_NFT%'

and tx_succeeded = true

group by day

order by day desc