date_trunc('week', block_timestamp) as date,

count(*) as no_of_txs,

count(case when status = 'SUCCESS' then 1 end) / count(*) * 100 as success_rate,

count(distinct from_address) as active_addresses

from optimism.core.fact_transactions

group by 1

order by 1