sinahosseinzadehUntitled Query
    Updated 2022-08-16
    With T1 as (select
    MIN(DATE(block_timestamp)) as date_bloc,
    pool_name

    from optimism.velodrome.ez_lp_actions
    group by 2
    )
    select
    date_bloc,
    count(distinct pool_name) as no_of_new_pairs,
    sum(no_of_new_pairs) over (order by date_bloc asc rows between unbounded preceding and current row) as cumulative_pairs
    from T1
    group by 1
    Run a query to Download Data