Updated 2022-11-21
    SELECT
    date_trunc('WEEK', block_timestamp) as date,
    COUNT(DISTINCT TX_ID) as TRANSACTIONS,
    COUNT(DISTINCT proposer) as users ,
    sum(users) over (order by date) as cumulative_users_growth,
    sum(TRANSACTIONS) over (order by date) as cumulative_TRANSACTIONS_growth
    FROM flow.core.fact_transactions WHERE TX_SUCCEEDED='TRUE'AND date > CURRENT_DATE - 365
    GROUP by 1
    Run a query to Download Data