Mrftilogical-jade copy
Updated 2024-10-15
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
›
⌄
-- forked from logical-jade @ https://flipsidecrypto.xyz/studio/queries/26104c0d-07de-4bfa-b2fa-f49830f08dd8
WITH daily_block_data AS
(
SELECT
date_trunc('day', block_timestamp) AS day,
COUNT(DISTINCT tx_hash) AS daily_tx_count,
DATEDIFF('second', MIN(block_timestamp), MAX(block_timestamp)) AS seconds_in_day
FROM kaia.core.fact_transactions
GROUP BY 1
)
SELECT
day,
daily_tx_count / NULLIF(seconds_in_day, 0) AS "Daily AVG TPS"
FROM daily_block_data
ORDER BY 1
QueryRunArchived: QueryRun has been archived