feyikemiTPS
Updated 2024-12-11
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
›
⌄
WITH tb1 AS(
SELECT
DATE_TRUNC('{{Granularity}}', BLOCK_TIMESTAMP) AS DATE,
COUNT(DISTINCT TX_HASH) AS TXNS,
MIN(BLOCK_TIMESTAMP) AS MIN_BLOCK_TIMESTAMP,
MAX(BLOCK_TIMESTAMP) AS MAX_BLOCK_TIMESTAMP
FROM base.core.fact_transactions
WHERE BLOCK_TIMESTAMP IS NOT NULL
GROUP BY 1
)
SELECT
DATE,
TXNS / DATEDIFF(second, MIN_BLOCK_TIMESTAMP, MAX_BLOCK_TIMESTAMP) AS TPS
FROM tb1
QueryRunArchived: QueryRun has been archived