flipside
Insights
Studio
Quests
For Chains
For Analysts
For Explorers
About
Log in
Sign up
flipside
2024-04-07 01:57 AM
kumbayaa
2024-04-07 01:57 AM
Updated 2024-04-07
Copy Reference
Fork
99
1
2
3
4
5
6
7
8
9
10
11
›
⌄
SELECT
date_trunc
(
'day'
,
block_timestamp
)
AS
date
,
tx_hash
,
to_address
,
tx_fee
,
status
FROM
ethereum
.
core
.
fact_transactions
WHERE
status
=
'FAIL'
--GROUP BY 1 2,
ORDER
BY
1
DESC
LIMIT
100
Results
QueryRunArchived: QueryRun has been archived