SELECT
-- date_trunc('day', block_timestamp) as day,
sum(price) as volume,
avg(price) as avg_price,
median(price) as median_price,
count(DISTINCT tx_id) as sales_events,
count(DISTINCT buyer) as buyers
FROM flow.core.ez_nft_sales
WHERE NFT_COLLECTION LIKE '%RaceDay%'
--GROUP BY 1