select

date(timestamp) as day,

avg(price_usd) as priceusd

from

flow.core.fact_prices

where

token='Flow'

group by

1

), daily_stat as (

select

case

when date(block_timestamp) between '2022-11-19' and '2022-11-26' then 'During Thanksgiving Days'

else 'Other Days'

end as day_label,

*

from

flow.core.ez_nft_sales

where

nft_collection = 'A.e4cf4bdc1751c65d.AllDay' and TX_SUCCEEDED

select

day_label,

count(distinct SELLER) as "Sellers Count",

count(distinct BUYER) as "Buyers Count",

count(distinct TX_ID) as "Sales Count",

sum(PRICE*priceusd) as "Volume",

"Sellers Count"/"Buyers Count" as "Relative Strength of Buyers to Sellers"

from

daily_stat s join prices p on date(block_timestamp)=p.day

group by 1