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

PROJECT_NAME,

count (distinct TX_HASH) as num_txs,

count (distinct origin_from_address) as num_users,

row_number()over(partition by weeks order by num_users desc) as n

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' --OP

and PROJECT_NAME != 'optimism'

group by 1,2

qualify n <= 10

order by 1