select date_trunc('day', block_timestamp) as day, count(distinct(tx_hash)) as transactions_count from optimism.core.fact_event_logs