DATE | TOTAL_TRANSACTIONS | SUCCESSFUL_TRANSACTIONS | FAILED_TRANSACTIONS | TOTAL_OPERATIONS | |
|---|---|---|---|---|---|
1 | 2025-03-13 00:00:00.000 | 1783954 | 975231 | 808723 | 3281733 |
2 | 2025-03-12 00:00:00.000 | 3980753 | 2061046 | 1919707 | 7491939 |
3 | 2025-03-11 00:00:00.000 | 4392909 | 1927597 | 2465312 | 8158803 |
4 | 2025-03-10 00:00:00.000 | 4741574 | 2091135 | 2650439 | 10763204 |
5 | 2025-03-09 00:00:00.000 | 4059170 | 1921754 | 2137416 | 8643519 |
6 | 2025-03-08 00:00:00.000 | 3309265 | 1897896 | 1411369 | 8505020 |
7 | 2025-03-07 00:00:00.000 | 4328858 | 1976714 | 2352144 | 9223783 |
8 | 2025-03-06 00:00:00.000 | 3832742 | 1897078 | 1935664 | 8464821 |
9 | 2025-03-05 00:00:00.000 | 3951103 | 2009857 | 1941246 | 8651973 |
10 | 2025-03-04 00:00:00.000 | 4147430 | 1975817 | 2171613 | 8787492 |
11 | 2025-03-03 00:00:00.000 | 4381576 | 1878408 | 2503168 | 8282844 |
12 | 2025-03-02 00:00:00.000 | 4182208 | 1754285 | 2427923 | 10248251 |
13 | 2025-03-01 00:00:00.000 | 3359465 | 1681732 | 1677733 | 7793540 |
14 | 2025-02-28 00:00:00.000 | 4169270 | 1827380 | 2341890 | 7652935 |
15 | 2025-02-27 00:00:00.000 | 3243674 | 1760826 | 1482848 | 8128312 |
16 | 2025-02-26 00:00:00.000 | 3775670 | 1858148 | 1917522 | 7550494 |
17 | 2025-02-25 00:00:00.000 | 4999926 | 1991887 | 3008039 | 8419410 |
18 | 2025-02-24 00:00:00.000 | 4146543 | 1813162 | 2333381 | 7330626 |
19 | 2025-02-23 00:00:00.000 | 3526945 | 1548842 | 1978103 | 6211438 |
20 | 2025-02-22 00:00:00.000 | 3552202 | 1580929 | 1971273 | 6482831 |
permary Daily Transaction Volume & Activity
Updated 5 days ago
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
›
⌄
select
date(closed_at) as date,
count(*) as total_transactions,
sum(case when successful then 1 else 0 end) as successful_transactions,
sum(case when not successful then 1 else 0 end) as failed_transactions,
sum(operation_count) as total_operations
from stellar.core.fact_transactions
where closed_at >= date_trunc('month', current_date) - interval '12 months'
group by date
order by date desc;
Last run: 5 days ago
...
378
22KB
50s