count(distinct tx_hash) as count_of_txs

from optimism.core.fact_event_logs

where block_timestamp::date >= '2022-07-01'

and event_name != ''

group by 1

order by 2 desc

limit 10