flipside
Insights
Studio
Quests
For Chains
For Analysts
For Explorers
About
Log in
Sign up
flipside
Success rates of transactions in last month
kasadegh
Success rates of transactions in last month
Updated 2022-07-12
Copy Reference
Fork
9
1
2
3
4
5
6
7
›
⌄
select
SUCCEEDED
,
count
(
*
)
as
"Total Number of Transactions in last month"
FROM
solana
.
core
.
fact_transactions
where
BLOCK_TIMESTAMP
::
date
between
'2022-06-1'
and
'2022-07-01'
group
by
SUCCEEDED
Results
Run a query to Download Data