date_trunc(week,block_timestamp):: date as date ,

LABEL_TYPE,

count (distinct TX_HASH) as num_txs,

sum(num_txs)over(partition by LABEL_TYPE order by date rows between unbounded preceding and current row ) as cumulative_num_txs

,count (distinct origin_from_address) as num_users

,sum(num_users)over(partition by LABEL_TYPE order by date rows between unbounded preceding and current row ) as cumulative_num_users

from

optimism.core.fact_event_logs l,optimism.core.dim_labels b

where tx_status = 'SUCCESS'

and origin_to_address = address

and contract_address = '0x4200000000000000000000000000000000000042'

group by 1,2

order by 1