AVG_TPS | |
|---|---|
1 | 76.707348374165 |
feyikemiNEAR TPS
Updated 2025-03-25
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
›
⌄
WITH tb1 AS(
SELECT
Date_trunc('day', block_timestamp) AS Date,
COUNT(DISTINCT TX_HASH) AS Txn_count,
COUNT(DISTINCT TX_HASH)/86400 AS TPS
FROM near.core.fact_transactions
WHERE TX_SUCCEEDED = 'True'
AND block_timestamp::date > '2024-01-01'
GROUP BY 1
)
SELECT
AVG(TPS) AS AVG_TPS
FROM Tb1
Last run: 2 months ago
1
19B
562s