flipside
Products
For Protocols
For Analysts
For Explorers
About
Log in
Become a Partner
flipside
TPM
Pmisha-bmlMdx
TPM
Updated 2022-06-06
Copy Reference
Fork
9
1
2
3
4
5
6
7
8
›
⌄
SELECT
date_trunc
(
'day'
,
BLOCK_TIMESTAMP
)
as
dt
,
TX_SUCCEEDED
,
count
(
TX_ID
)
/
1440
as
no_txn
from
flow
.
core
.
fact_transactions
where
BLOCK_TIMESTAMP
>=
'2022-05-09'
group
by
1
,
2
)
\
Results
Run a query to Download Data