date_trunc('day', block_timestamp),

count(DISTINCT tx_id) as sales

FROM flow.core.fact_nft_sales

GROUP BY 1