CoinConverseAverage Optimism Portfolio top 10 protocols by total users
    Updated 2022-11-06
    SELECT b.PROJECT_NAME AS project_name,
    count(DISTINCT tx_hash) AS num_tx,
    count(DISTINCT origin_from_address) AS num_users
    FROM optimism.core.fact_event_logs AS a
    JOIN optimism.core.dim_labels AS b ON a.origin_to_address = b.address
    WHERE tx_status = 'SUCCESS'
    GROUP BY 1
    ORDER BY 3 DESC
    LIMIT 10
    Run a query to Download Data