adriaparcerisasSushi vs Uni on L2
    Updated 2022-11-18
    SELECT
    trunc(block_timestamp,'month') as date,
    case when project_name = 'sushiswap' then 'Sushiswap'
    else 'Uniswap' end as platform,
    count(distinct tx_hash) as swaps,
    count(distinct origin_from_address) as users,
    swaps/users as swaps_per_user
    from arbitrum.core.fact_event_logs left join arbitrum.core.dim_labels ON contract_address = address
    where (project_name = 'sushiswap' or project_name like '%uniswap%')
    and address is not null
    GROUP BY 1,2
    order by 1 asc
    Run a query to Download Data