NavidCopy of Copy of Copy of Copy of Copy of Copy of Copy of Untitled Query
    Updated 2022-11-14
    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

    Run a query to Download Data