bachiOptimism DEX Projects
    Updated 2022-08-20
    SELECT project_name,
    Count(DISTINCT tx_hash) AS total_txs_count,
    Count(DISTINCT origin_from_address) AS no_of_users
    FROM (SELECT *
    FROM bsc.core.dim_labels
    INNER JOIN bsc.core.fact_event_logs
    ON contract_address = address)
    WHERE label_type = 'dex'
    and tx_status = 'SUCCESS'
    GROUP BY 1
    ORDER BY 2 DESC
    Run a query to Download Data