sinahosseinzadehUntitled Query
    Updated 2022-08-16
    With a as (
    select date_trunc('day', block_timestamp) as day, count(*) as Total_Swap_Count
    from optimism.velodrome.ez_swaps
    group by 1
    ),
    b as (
    select date_trunc('day', block_timestamp) as daya, count(distinct SENDER_ADDRESS) as Number_of_unqiue_users
    from optimism.velodrome.ez_swaps
    group by 1
    )

    select day, total_swap_Count, Number_of_unqiue_users
    from a
    full outer join b on day=daya

    Run a query to Download Data