CoinConverseVelodrome open daily new swappers
    Updated 2022-08-18
    with daily_new_swappers as (select date_trunc('day', first_time_date) as dt, count(distinct swapper) as new_swapper
    from (select min(block_timestamp) as first_time_date, origin_from_address as swapper
    from optimism.velodrome.ez_swaps
    group by swapper)
    group by first_time_date)

    select dt, sum(new_swapper) as num_new_swapper, sum(num_new_swapper) over (order by dt asc) as cumulative_num_new_swapper
    from daily_new_swappers
    group by dt
    Run a query to Download Data