/* Sales volume (daily)
Total Sales Volume
Daily Average Sales Price and 7-day moving average
Total Unique Buyers
Average Buyers/Day */
select
case
when block_timestamp between '2022-11-19' and '2022-11-26' then 'Thanksgiving Week'
else 'Rest_Of_The_Year'
end as Period
,avg(price)
,median(price)
from flow.core.ez_nft_sales sales
where nft_collection = 'A.e4cf4bdc1751c65d.AllDay'
group by 1