flipside
Products
For Protocols
For Analysts
For Explorers
About
Log in
Become a Partner
flipside
Sei Txn Count
feyikemi
Sei Txn Count
Updated 2024-07-20
Copy Reference
Fork
9
1
2
3
4
5
6
7
8
›
⌄
SELECT
Count
(
DISTINCT
Date_trunc
(
'second'
,
block_timestamp
)
)
Date
,
Count
(
DISTINCT
tx_id
)
Txns
,
abs
(
Txns
/
Date
)
as
TPS
FROM
sei
.
core
.
fact_transactions
WHERE
block_timestamp
::
date
>
current_date
-
30
Results
QueryRunArchived: QueryRun has been archived