Josh956Velodrome Swap volume
    Updated 2023-02-02
    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 origin_from_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
    --group by day
    Run a query to Download Data