KeyrockTransactions over time
    Updated 2024-10-25
    SELECT date_trunc('month', block_timestamp) AS month, count(DISTINCT tx_hash) as monthly_transactions
    FROM aptos.core.fact_transactions
    GROUP BY month
    ORDER BY month


    QueryRunArchived: QueryRun has been archived