flipside
Insights
Studio
Quests
For Chains
For Analysts
For Explorers
About
Log in
Sign up
flipside
The number of transactions in terms of status since Sep 2021
princefarzam
The number of transactions in terms of status since Sep 2021
Updated 2022-07-20
Copy Reference
Fork
9
1
2
3
4
5
6
7
8
›
⌄
SELECT
DATE_TRUNC
(
'DAY'
,
block_timestamp
)
::
DATE
AS
DAY
,
COUNT
(
TXN_HASH
)
AS
NUMBER_OF_TRANSACTIONS
,
substr
(
tx_receipt
[
0
]
:
outcome
:
status
,
3
,
7
)
::
string
AS
Status
FROM
flipside_prod_db
.
mdao_near
.
transactions
GROUP
BY
DAY
,
Status
ORDER
BY
DAY
ASC
Results
Run a query to Download Data