flipside

    Top Defi projects on Optimism
    nitsTop Defi projects on Optimism
    Updated 2022-08-08
    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 = 'defi'
    GROUP by 1
    order by 2 desc
    limit 10
    Run a query to Download Data