select TIMESTAMP::date as price_hour,avg(price_usd) as usd,token_contract from flow.core.fact_prices where token_contract = 'A.1654653399040a61.FlowToken'

group by 1,3

select count(distinct buyer) as buyers,count(distinct SELLER) as sellers,

CASE WHEN block_timestamp::date BETWEEN '2022-11-19' AND '2022-11-26' THEN 'Thanksgiving Week' else 'Other Days' end as period,

count (distinct nft_id) as nfts,count (distinct tx_id) as sales,

sum(case when currency ilike 'A.1654653399040a61.FlowToken' then price*usd else price end ) as usd_amount,

avg(case when currency ilike 'A.1654653399040a61.FlowToken' then price*usd else price end )as avg_usd_amount,

min(case when currency ilike 'A.1654653399040a61.FlowToken' then price*usd else price end )as min_usd_amount,

max(case when currency ilike 'A.1654653399040a61.FlowToken' then price*usd else price end )as max_usd_amount

from flow.core.ez_nft_sales a join price b on a.block_timestamp::date=b.price_hour

where nft_collection ilike 'A.e4cf4bdc1751c65d.AllDay' and tx_succeeded = 'TRUE'

group by period