flipside

    optimsim data3
    bachioptimsim data3
    Updated 2022-08-04
    select project_name, count(DISTINCT tx_hash) as total_txs
    from
    (SELECT * from optimism.core.dim_labels
    inner join optimism.core.fact_event_logs
    on contract_address = address)
    where label_type = 'dex'
    GROUP by 1
    order by 2 desc
    Run a query to Download Data