datavortexTransaction per second
    Updated 2024-11-17
    WITH transactions_2023 AS (
    SELECT COUNT(DISTINCT tx_hash) AS "transaction 2023"
    FROM near.core.fact_transactions
    WHERE block_timestamp >= '2023-01-01' AND block_timestamp < '2024-01-01'
    ),
    transactions_2024 AS (
    SELECT COUNT(DISTINCT tx_hash) AS "transaction 2024"
    FROM near.core.fact_transactions
    WHERE block_timestamp >= '2024-01-01' AND block_timestamp < '2025-01-01'
    )
    SELECT
    "transaction 2023" / (365 * 24 * 60 * 60) AS "transaction 2023 tps",
    "transaction 2024" / (365 * 24 * 60 * 60) AS "transaction 2024 tps",
    ROUND((("transaction 2024" / (365 * 24 * 60 * 60)) - ("transaction 2023" / (365 * 24 * 60 * 60))) / NULLIF(("transaction 2023" / (365 * 24 * 60 * 60)), 0) * 100, 2) AS "transaction tps growth change (%)"
    FROM transactions_2023, transactions_2024;

    QueryRunArchived: QueryRun has been archived