SELECT *

FROM optimism.core.dim_labels

where project_name IN (

'perpetual protocol',

'synthetix',

'lyra',

'chainlink',

'uniswap',

'hop protocol',

'stargate finance',

'celer',

'synapse',

'pika protocol',

'rubicon',

'kwenta',

'thales',

'polynomial protocol',

'aelin',

'zipswap',

'0x',

'layer zero',

'band protocol',

'clipper',

'layer2dao',

'gelato'

)

SELECT

date_trunc('week', block_timestamp) as week,

project_name,

COUNT(DISTINCT tx_hash),

count(DISTINCT origin_from_address)

FROM optimism.core.fact_event_logs