block_timestamp::date as day,

count(distinct(tx_id)) as number_of_txns,

count(distinct(buyer)) as number_of_buyers,

min(price) as min_price,

max(price) as max_price,

sum(price) as volume,

avg(price) as avg_price,

median(price) as median_price

from flow.core.ez_nft_sales

where nft_collection = 'A.329feb3ab062d289.RaceDay_NFT'

group by day