date_trunc('week', BLOCK_TIMESTAMP) AS week,

project_name,

count(DISTINCT tx_hash) as total_txs

from

(

SELECT

*

from

optimism.core.dim_labels

inner join optimism.core.fact_event_logs on contract_address = address

)

where

label_type = 'dapp'

GROUP by

1 ,2

order by

2 desc