Tobi_1dynamic-moccasin
    Updated 2024-09-21
    SELECT
    DATE_TRUNC('day', BLOCK_TIMESTAMP) AS transaction_day,
    COUNT(TX_ID) AS successful_transactions
    FROM
    flow.core.fact_transactions;
    WHERE
    TX_SUCCEEDED = TRUE
    AND BLOCK_TIMESTAMP >= DATEADD(day, -30, CURRENT_TIMESTAMP)
    GROUP BY
    transaction_day
    ORDER BY
    transaction_day ASC;

    QueryRunArchived: QueryRun has been archived