with tab1 as (

select date_trunc('minute',BLOCK_TIMESTAMP) as time

,LIQUIDITY_PROVIDER_ADDRESS

from osmosis.core.fact_liquidity_provider_actions

where CURRENCY='uosmo')

select date_trunc('week',time) as week

,LIQUIDITY_PROVIDER_ADDRESS

,rank()over(partition by LIQUIDITY_PROVIDER_ADDRESS order by week)as time_row

from tab1)

select week

,count(LIQUIDITY_PROVIDER_ADDRESS) as "New Lpers"

,sum("New Lpers")over(order by week) as "total New Lpers"

from act1

where week>='2023-01-01'

group by 1