select liquidity_provider_address,

min (block_timestamp) as min_date

from osmosis.core.fact_liquidity_provider_actions

where action = 'pool_joined'

and pool_id [0] = '773'

and tx_status = 'SUCCEEDED'

group by 1

select trunc(min_date, 'month') as week,

count (distinct (liquidity_provider_address)) as new_liquidity_providers_count,

sum (new_liquidity_providers_count) over (order by week) as comulative_liquidity_providers_count

from t

group by 1

order by 1