date_trunc('day', block_timestamp) as day,

COUNT(DISTINCT tx_id) as sales,

sum(price) as sales_volume,

avg(price) as average_price,

COUNT(DISTINCT buyer) as buyers,

min(price) as floor_price

FROM flow.core.ez_nft_sales

WHERE split(nft_collection, '.')[2] LIKE '{{nft_collections}}'

AND block_timestamp > CURRENT_DATE - {{ first_day }}

GROUP BY day