Tobi_1adverse-chocolate
    Updated 2024-09-21
    SELECT
    COUNT(TX_ID) AS total_transactions
    FROM
    flow.core.fact_transactions;
    WHERE
    BLOCK_TIMESTAMP >= DATEADD(day, -30, CURRENT_DATE()) -- transactions from the last 30 days
    AND TX_SUCCEEDED = TRUE; -- only count successful transactions

    QueryRunArchived: QueryRun has been archived