LittlerDataAvg & median price by period
    Updated 2022-12-06
    /* 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