date_trunc('day', block_timestamp) as day,

CURRENCY,

sum (price ) as volume_usd,

count(distinct(tx_id)) as tx_count

from flow.core.ez_nft_sales

where tx_succeeded = 'TRUE'

and block_timestamp BETWEEN '2022-04-01' and '2022-05-01'

and nft_collection = 'A.329feb3ab062d289.RaceDay_NFT'

group by 1,2