winnie-fsStats Monthly 3 copy
    Updated 2023-08-28
    -- forked from Abbas_ra21 / Stats Monthly 3 @ https://flipsidecrypto.xyz/Abbas_ra21/q/sXj7X8euPQ2c/stats-monthly-3

    -- forked from Stats Monthly 2 @ https://flipsidecrypto.xyz/edit/queries/ed91545a-6bac-41e2-ba78-a75e8dfc8ac7

    -- forked from Stats Monthly @ https://flipsidecrypto.xyz/edit/queries/4db44afd-0e8c-43e8-910f-8af294d8855b

    select
    date_trunc('Month', First_seen)::DATE AS Month,
    Count(Address) AS "New Stakers",
    sum("New Stakers") over (order by Month) AS "Total Users"
    from
    (
    select
    Address,
    min(BLOCK_TIMESTAMP)::DATE AS First_seen
    from solana.core.fact_stake_pool_actions
    where
    STAKE_POOL_NAME = 'blazestake'
    and SUCCEEDED = TRUE
    and (ACTION like '%deposit%'
    or ACTION like '%withdraw%') group by 1)
    group by 1




    Run a query to Download Data