SELECT label_type, count(DISTINCT tx_hash) as total_txs from optimism.core.fact_event_logs
inner join optimism.core.dim_labels
on contract_address = address
where date(block_timestamp)>='2022-07-01' and date(block_timestamp) <='2022-07-30'
GROUP by 1