flipside
Products
For Protocols
For Analysts
For Explorers
About
Log in
Become a Partner
flipside
Avg tps over time Terra
SocioCrypto
Avg tps over time Terra
Updated 2023-04-13
Copy Reference
Fork
9
1
2
3
4
5
6
7
›
⌄
SELECT
date_trunc
(
'week'
,
block_timestamp
)
as
date
,
count
(
DISTINCT
tx_id
)
/
(
3600
*
24
)
as
TPS
FROM
terra
.
core
.
fact_transactions
WHERE
tx_succeeded
=
'TRUE'
AND
date
<=
CURRENT_DATE
-
1
GROUP
by
date
ORDER
by
date
DESC
Results
Run a query to Download Data