DATE | STATUS | N_TRANSACTIONS | |
---|---|---|---|
1 | 2025-02-16 00:00:00.000 | Succeeded | 58881270 |
2 | 2025-02-09 00:00:00.000 | Succeeded | 57194200 |
3 | 2025-03-19 00:00:00.000 | Failed | 40313509 |
4 | 2025-03-06 00:00:00.000 | Succeeded | 55583350 |
5 | 2025-01-26 00:00:00.000 | Succeeded | 67816614 |
6 | 2025-02-02 00:00:00.000 | Failed | 41803860 |
7 | 2025-02-07 00:00:00.000 | Failed | 44405272 |
8 | 2025-02-10 00:00:00.000 | Succeeded | 58462079 |
9 | 2025-02-21 00:00:00.000 | Succeeded | 53443171 |
10 | 2025-03-21 00:00:00.000 | Failed | 33313911 |
11 | 2025-03-08 00:00:00.000 | Succeeded | 48028339 |
12 | 2025-01-31 00:00:00.000 | Succeeded | 59742280 |
13 | 2025-03-24 00:00:00.000 | Succeeded | 53417939 |
14 | 2025-02-11 00:00:00.000 | Failed | 45435493 |
15 | 2025-03-11 00:00:00.000 | Failed | 35752741 |
16 | 2025-02-05 00:00:00.000 | Succeeded | 64708556 |
17 | 2025-02-14 00:00:00.000 | Succeeded | 59561718 |
18 | 2025-03-20 00:00:00.000 | Failed | 33916301 |
19 | 2025-01-25 00:00:00.000 | Failed | 40596443 |
20 | 2025-02-13 00:00:00.000 | Failed | 43933232 |
ArioTransactions
Updated 8 days ago
9
1
2
3
4
5
6
7
8
9
›
⌄
select
date_trunc(day, block_timestamp) as date,
case when succeeded then 'Succeeded'
else 'Failed'
end as status,
count(*) as N_Transactions
from solana.core.fact_transactions
where block_timestamp > current_date - 60
group by 1,2
Last run: 8 days ago
...
122
6KB
213s