date_trunc('week', block_timestamp) as day,

count(DISTINCT tx_hash) as events,

count(DISTINCT origin_from_address) as users,

COUNT(DISTINCT contract_address) as wallets

FROM optimism.core.fact_event_logs

LEFT outer JOIN (

SELECT

origin_from_address as from_address,

min(date_trunc('day', block_timestamp)) as first_day

FROM optimism.core.fact_event_logs

where contract_address in (

lower('0xa81D244A1814468C734E5b4101F7b9c0c577a8fC'),

lower('0x46ae9BaB8CEA96610807a275EBD36f8e916b5C61'),

lower('0x7191061D5d4C60f598214cC6913502184BAddf18'),

lower('0x83f6244Bd87662118d96D9a6D44f09dffF14b30E'),

lower('0xB1ea9FeD58a317F81eEEFC18715Dd323FDEf45c4')

)

GROUP BY 1

) on origin_from_address = from_address

LEFT outer JOIN optimism.core.dim_labels

ON address = contract_address

WHERE first_day >= block_timestamp

GROUP BY 1