count (distinct tx_id) as sales,

count (distinct buyer) as buyers,

count (distinct seller) as sellers,

count (distinct nft_id) as NFTs,

sum (case when currency = 'A.1654653399040a61.FlowToken' then price*usdprice

else price end) as USD_Volume,

avg (case when currency = 'A.1654653399040a61.FlowToken' then price*usdprice

else price end) as Avg_USD_Volume,

'thanksgiving league' as period

from flow.core.ez_nft_sales a join (select timestamp::date as day,

avg (price_usd) as usdprice

from flow.core.fact_prices

where symbol = 'FLOW'

and source = 'coinmarketcap'

group by 1) b on a.block_timestamp::Date = b.day

where nft_collection = 'A.e4cf4bdc1751c65d.AllDay'

and tx_succeeded = 'TRUE'

and block_timestamp >= '2022-11-24'--start of thanksgiving league

group by 1

union ALL

select block_timestamp::date as day,

count (distinct tx_id) as sales,

count (distinct buyer) as buyers,

count (distinct seller) as sellers,

count (distinct nft_id) as NFTs,

sum (case when currency = 'A.1654653399040a61.FlowToken' then price*usdprice

else price end) as USD_Volume,

avg (case when currency = 'A.1654653399040a61.FlowToken' then price*usdprice

else price end) as Avg_USD_Volume,

'before thanksgiving league' as period

from flow.core.ez_nft_sales a join (select timestamp::date as day,

avg (price_usd) as usdprice

from flow.core.fact_prices