DATE(block_timestamp) as block_date,

a.project_name as projects,

count(distinct tx_hash) as op_tx_count,

count(distinct origin_from_address) as op_user_count

FROM optimism.core.fact_event_logs

LEFT JOIN optimism.core.dim_labels a on contract_address = a.address OR origin_to_address = a.address

WHERE tx_status = 'SUCCESS'

GROUP BY 1,2

having projects is not null-- exclude missing contract data

and block_date >= '2022-08-01'