CODXIIIMonthly All Time Users
    Updated 2023-04-14
    -- forked from Daily All Time Users @ https://flipsidecrypto.xyz/edit/queries/90a5f1d5-bba8-427d-8452-2c12e42d342a

    WITH table_1 AS (
    SELECT
    TX_ID,
    BLOCK_TIMESTAMP,
    PROPOSER
    FROM
    flow.core.fact_transactions
    )
    SELECT
    date_trunc('month', BLOCK_TIMESTAMP) AS Date,
    COUNT(DISTINCT PROPOSER) AS Users,
    COUNT(DISTINCT TX_ID) AS TXS_NUM,
    SUM(Users) over (ORDER BY Date) AS "Cumul User"
    FROM
    table_1
    GROUP BY 1
    ORDER BY 1


    Run a query to Download Data