StangFAST05 - Type active day
    Updated 2023-04-13
    with new_users as (

    SELECT
    c.proposer
    , min( c.block_timestamp ) AS min_date
    FROM
    flow.core.fact_transactions c

    GROUP BY
    1
    ORDER BY
    1 DESC

    )

    ,

    conclus AS
    (

    SELECT
    a.proposer
    , count( DISTINCT( a.block_timestamp::date ) ) AS active_days
    , count( DISTINCT( a.tx_id ) ) AS transaction_count

    FROM
    flow.core.fact_transactions a

    INNER JOIN
    new_users b
    ON a.proposer = b.proposer

    WHERE
    a.block_timestamp::date < '2023-04-01'
    Run a query to Download Data