mehdimarjanOptimism Protocols by Number of Users
    Updated 2022-11-09
    SELECT project_name,
    COUNT(DISTINCT origin_from_address) as number_of_users
    FROM optimism.core.fact_event_logs
    INNER JOIN optimism.core.dim_labels ON origin_to_address=address
    WHERE block_timestamp::DATE >= CURRENT_DATE - 90
    AND tx_status='SUCCESS'
    AND project_name IS NOT NULL
    GROUP BY 1
    ORDER BY 2 DESC


    Run a query to Download Data