sinahosseinzadeh2023-04-12 11:20 PM
    Updated 2023-04-12
    WITH
    active_users AS (
    SELECT
    block_timestamp::date AS date,
    COUNT(DISTINCT tx_id) AS txn,
    COUNT(DISTINCT proposer) AS users,
    AVG(txn) OVER (
    ORDER BY
    date ROWS BETWEEN 7 PRECEDING
    AND CURRENT ROW
    ) as ma
    FROM
    flow.core.fact_transactions
    WHERE
    tx_succeeded = TRUE
    AND date >= CURRENT_DATE - 30
    GROUP BY
    date
    ),
    new_users AS (
    SELECT
    first_time::date AS date,
    COUNT(DISTINCT proposer) AS users
    FROM
    (
    SELECT
    proposer,
    MIN(block_timestamp) AS first_time
    FROM
    flow.core.fact_transactions
    WHERE
    tx_succeeded = TRUE
    GROUP BY
    proposer
    )
    GROUP BY
    Run a query to Download Data