0-MIDnew users daily
    Updated 2023-04-13
    with tab1 as (
    select min(BLOCK_TIMESTAMP::date) as date, ORIGIN_FROM_ADDRESS as new_swappers
    , case
    when (ORIGIN_TO_ADDRESS ='0xe592427a0aece92de3edee1f18e0157c05861564'
    or ORIGIN_TO_ADDRESS='0x68b3465833fb72a70ecdf485e0e4c7bd8665fc45') then 'Uniswap'
    when ORIGIN_TO_ADDRESS='0x1b02da8cb0d097eb8d57a175b88c7d8b47997506' then 'Sushiswap' end as rutrs
    from arbitrum.core.fact_event_logs
    where (ORIGIN_TO_ADDRESS='0xe592427a0aece92de3edee1f18e0157c05861564'or
    ORIGIN_TO_ADDRESS='0x68b3465833fb72a70ecdf485e0e4c7bd8665fc45'
    or ORIGIN_TO_ADDRESS='0x1b02da8cb0d097eb8d57a175b88c7d8b47997506')
    and TX_STATUS='SUCCESS'
    group by 2,3)
    select date , rutrs,count(new_swappers) as new_users
    from tab1
    group by 1,2


    Run a query to Download Data