MONTH | TYPE | TOTAL_TRANSACTIONS | |
|---|---|---|---|
1 | 2025-01-01 00:00:00.000 | Succeeded | 222193 |
2 | 2025-01-01 00:00:00.000 | Failed | 12981 |
3 | 2025-01-02 00:00:00.000 | Succeeded | 245677 |
4 | 2025-01-02 00:00:00.000 | Failed | 13726 |
5 | 2025-01-03 00:00:00.000 | Succeeded | 230655 |
6 | 2025-01-03 00:00:00.000 | Failed | 12185 |
7 | 2025-01-04 00:00:00.000 | Succeeded | 235336 |
8 | 2025-01-04 00:00:00.000 | Failed | 10889 |
9 | 2025-01-05 00:00:00.000 | Failed | 132408 |
10 | 2025-01-05 00:00:00.000 | Succeeded | 222578 |
11 | 2025-01-06 00:00:00.000 | Failed | 27554 |
12 | 2025-01-06 00:00:00.000 | Succeeded | 204752 |
13 | 2025-01-07 00:00:00.000 | Succeeded | 258813 |
14 | 2025-01-07 00:00:00.000 | Failed | 7979 |
15 | 2025-01-08 00:00:00.000 | Failed | 9429 |
16 | 2025-01-08 00:00:00.000 | Succeeded | 245214 |
17 | 2025-01-09 00:00:00.000 | Succeeded | 238209 |
18 | 2025-01-09 00:00:00.000 | Failed | 9169 |
19 | 2025-01-10 00:00:00.000 | Failed | 8887 |
20 | 2025-01-10 00:00:00.000 | Succeeded | 180176 |
adriaparcerisasflow tx after axelar 1.2
Updated 2 days ago
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
›
⌄
with txs as (
select distinct tx_id, block_timestamp, tx_succeeded
from flow.core.fact_transactions
UNION
select distinct tx_hash as tx_id, block_timestamp, tx_succeeded
from flow.core_evm.fact_transactions
)
SELECT
trunc(block_timestamp,'day') as month,
--case when block_timestamp<='2025-01-22' then 'Before Axelar Integration' else 'After Axelar Integration' end as period,
case when tx_succeeded='true' then 'Succeeded' else 'Failed' end as type,
count(distinct tx_id) as total_transactions
from txs
where month<trunc(current_date,'day') and month>='2025-01-01' --and tx_succeeded='true'
group by 1,2
order by 1 asc
Last run: 2 days ago
...
332
15KB
67s