select RECORDED_HOUR::date as date, avg(close) as flowprice

from flow.core.fact_hourly_prices

where TOKEN ='Flow' and PROVIDER ='coinmarketcap'

group by 1)

select count (distinct tx_id) as Sales_Count,

count (distinct nft_id) as Tokens_Count,

count (distinct buyer) as Buyers_Count,

count (distinct seller) as Sellers_Count,

count (distinct marketplace) as Markets_Count,

sum (case when currency ='A.ead892083b3e2c6c.FlowUtilityToken' then price*flowprice else price end) as Total_Sale_Volume,

avg (case when currency ='A.ead892083b3e2c6c.FlowUtilityToken' then price*flowprice else price end) as Average_Sale_Volume,

median (case when currency ='A.ead892083b3e2c6c.FlowUtilityToken' then price*flowprice else price end) as Median_Sale_Volume,

min (case when currency ='A.ead892083b3e2c6c.FlowUtilityToken' then price*flowprice else price end) as Min_Sale_Volume,

max (case when currency ='A.ead892083b3e2c6c.FlowUtilityToken' then price*flowprice else price end) as Maximum_Sale_Volume,

TX_SUCCEEDED as type

from flow.core.ez_nft_sales t1 join flowpricet t2 on t1.block_timestamp::date = t2.date

where nft_collection = 'A.329feb3ab062d289.RaceDay_NFT'

and tx_succeeded = 'TRUE'

GROUP by type