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