with daily_stat as (
select
date(block_timestamp) as day,
sum(price) as total_sales_volume,
count(distinct tx_id) as number_of_sales,
count(distinct buyer) as number_of_buyers
from
flow.core.ez_nft_sales
where
NFT_COLLECTION like '%RaceDay%'
group by
day
)
select
avg(number_of_buyers) as "Average Number of Daily Unique Buyers",
avg(total_sales_volume) as "Daily Average Sales Price"
from
daily_stat