with dates as (
SELECT
address,
date(block_timestamp) as dt
from
solana.core.fact_stake_pool_actions
where
succeeded
)
select
count(distinct address) as total_users,
max(dt)-min(dt) as total_days,
total_users/total_days as avg_daily_new_users
from
dates