jackguyCopy of FLOW User Retention vs Other Chains 2
    Updated 2022-12-30
    with tab1 as (
    SELECT
    signers[0],
    min(date_trunc('month', block_timestamp)) as min_day
    FROM solana.core.fact_transactions
    GROUP BY 1
    )


    SELECT
    *,
    sum(new_users) over (ORDER BY month) as cumulative_users
    from (
    SELECT
    min_day as month,
    count(*) as new_users
    FROM tab1
    GROUP BY 1
    )
    Run a query to Download Data