datavortexTransaction per second
Updated 2024-11-17Copy Reference Fork
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
›
⌄
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