with min_dates as (
SELECT
address,
STAKE_POOL_NAME,
date(min(block_timestamp)) as min_date
from
solana.core.fact_stake_pool_actions
where
succeeded
group by 1,2
)
select
min_date,
STAKE_POOL_NAME,
count(distinct address) as cnt_daily_user,
sum(cnt_daily_user) over (partition by STAKE_POOL_NAME order by min_date asc) as cum_daily_user
from
min_dates
group by
1,2