Ranjit-YadavOP vs other l2 4
    Updated 2022-10-19
    SELECT
    date_trunc('WEEK', block_timestamp) as WEEK,
    PROJECT_NAME,
    COUNT(DISTINCT tx_hash)
    FROM optimism.core.fact_event_logs
    LEFT outer JOIN arbitrum.core.dim_labels
    ON address = contract_address
    where project_name IS NOT NULL
    GROUP BY 1,2


    Run a query to Download Data