select date_trunc('day',block_timestamp) as date,block_id, count(distinct tx_id) as number_of_transactions from terra.core.fact_transactions