date_trunc('day', block_timestamp),

count(*)

from flow.core.fact_transactions

group by 1