peteerTop 5 DEX projects (maximum Transactions)
    Updated 2022-08-28
    with optimisim_data as (select * from optimism.core.dim_labels inner join optimism.core.fact_event_logs
    on contract_address = address
    where label_type = 'dex' or label_type = 'dapp' )

    select top 5 count(distinct tx_hash) as tx,project_name as pn from optimisim_data
    where label_type = 'dex'
    group by pn
    order by tx desc
    Run a query to Download Data