feyikemiNEAR Txns Status
Updated 2024-10-04
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
›
⌄
WITH TRANSACTION_STATUS AS (
SELECT
CASE
WHEN TX_SUCCEEDED = 'TRUE' THEN 'Successful'
ELSE 'Failed'
END AS status,
Date_trunc('day', block_timestamp) AS Date,
COUNT(DISTINCT tx_hash) AS tx_count
FROM near.core.fact_transactions
WHERE block_timestamp::date >'2024-01-01'
GROUP BY 1, 2
)
SELECT
Date,
status,
tx_count
FROM TRANSACTION_STATUS
ORDER BY 1 DESC
QueryRunArchived: QueryRun has been archived