adambalaDEX Usage Patterns
    Updated 2022-05-25
    with tab1 as (

    select
    date_trunc('month', block_timestamp) as date1 ,
    (count(*)/count(distinct from_address)) as count1


    from ethereum.transactions
    where to_label like 'uniswap'
    group by 1
    )

    , tab2 as (select
    date_trunc('month', block_timestamp) as date2,
    (count(*)/count(distinct from_address)) as count2


    from ethereum.transactions
    where to_label like 'sushiswap'
    group by 1
    )
    select
    date1,
    count1 as Uniswap,
    count2 as Sushiswap
    from tab1 left join tab2 on date1 = date2
    Run a query to Download Data