Date | Txns Count | Transaction Status | |
|---|---|---|---|
1 | 2024-01-01 00:00:00.000 | 43654 | FAIL |
2 | 2024-01-01 00:00:00.000 | 446266 | SUCCESS |
3 | 2024-02-01 00:00:00.000 | 380185 | SUCCESS |
4 | 2024-02-01 00:00:00.000 | 24667 | FAIL |
5 | 2024-03-01 00:00:00.000 | 32597 | FAIL |
6 | 2024-03-01 00:00:00.000 | 434634 | SUCCESS |
7 | 2024-04-01 00:00:00.000 | 386823 | SUCCESS |
8 | 2024-04-01 00:00:00.000 | 10901 | FAIL |
9 | 2024-05-01 00:00:00.000 | 6505 | FAIL |
10 | 2024-05-01 00:00:00.000 | 382142 | SUCCESS |
11 | 2024-06-01 00:00:00.000 | 1412476 | SUCCESS |
12 | 2024-06-01 00:00:00.000 | 5243 | FAIL |
13 | 2024-07-01 00:00:00.000 | 7240 | FAIL |
14 | 2024-07-01 00:00:00.000 | 1060921 | SUCCESS |
15 | 2024-08-01 00:00:00.000 | 16778 | FAIL |
16 | 2024-08-01 00:00:00.000 | 599865 | SUCCESS |
17 | 2024-09-01 00:00:00.000 | 4960 | FAIL |
18 | 2024-09-01 00:00:00.000 | 471702 | SUCCESS |
19 | 2024-10-01 00:00:00.000 | 484786 | SUCCESS |
20 | 2024-10-01 00:00:00.000 | 3853 | FAIL |
Eman-RazNumber of Transactions Over Time
Updated 2025-02-03
9
1
2
3
4
5
6
7
›
⌄
select date_trunc('{{Time_Frame}}',block_timestamp) as "Date",
count(distinct tx_hash) as "Txns Count", status as "Transaction Status"
from aurora.core.fact_transactions
where block_timestamp::date>='{{Start_Date}}' and block_timestamp::date<='{{End_Date}}'
and status<>'Series 3'
group by 1, 3
order by 1
Last run: 3 months ago
28
1KB
2s