feyikemi2024-04-16 08:27 PM
Updated 2024-04-16
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
›
⌄
with Txn_speed AS(
SELECT
Count(DISTINCT Date_trunc('second', block_timestamp)) Date,
Count(DISTINCT tx_id) Txns,
abs(Txns/Date) as TPS
FROM sei.core.fact_transactions a
WHERE block_timestamp :: date > current_date - 30
)
SELECT
TPS,
Date_trunc('day', block_timestamp) Date,
Count(DISTINCT b.tx_id) Txns,
FROM sei.core.fact_transactions b
JOIN Txn_speed
--ON a.txns =b.tx_id
WHERE block_timestamp :: date > current_date - 30
GROUP by 1,2
QueryRunArchived: QueryRun has been archived