Updated 2023-10-13

    SELECT
    DATE_TRUNC('month',BLOCK_TIMESTAMP) AS date,
    COUNT(TX_ID)total_transactions

    FROM flow.core.fact_transactions
    WHERE TX_SUCCEEDED ='true'
    GROUP BY date
    ORDER BY date desc
    LIMIT 12