Updated 2023-01-31
    SELECT


    DATE_TRUNC('day',block_timestamp) day,
    COUNT(DISTINCT TX_ID ) total_transaction_vol


    FROM flow.core.fact_transactions
    WHERE TX_SUCCEEDED = 'TRUE'
    GROUP BY day

    Run a query to Download Data