from flow.core.fact_prices

where symbol ='FLOW' and source ='coinmarketcap'

group by 1),

nft_price as (SELECT*, price * b.flow_price as nft_usd_price

from flow.core.ez_nft_sales a join flow_price b on a.block_timestamp::date = b.p_date

where nft_collection = 'A.329feb3ab062d289.RaceDay_NFT'

and tx_succeeded = 'TRUE' )

select

count(distinct tx_id) as unit_sales,

count(distinct buyer) as buyers,

sum(nft_usd_price) as Total_USD_Vol,

avg(nft_usd_price) as Avg_USD_price

from nft_price