ArioTransactions
    Updated 8 days ago
    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
    DATE
    STATUS
    N_TRANSACTIONS
    1
    2025-02-16 00:00:00.000Succeeded58881270
    2
    2025-02-09 00:00:00.000Succeeded57194200
    3
    2025-03-19 00:00:00.000Failed40313509
    4
    2025-03-06 00:00:00.000Succeeded55583350
    5
    2025-01-26 00:00:00.000Succeeded67816614
    6
    2025-02-02 00:00:00.000Failed41803860
    7
    2025-02-07 00:00:00.000Failed44405272
    8
    2025-02-10 00:00:00.000Succeeded58462079
    9
    2025-02-21 00:00:00.000Succeeded53443171
    10
    2025-03-21 00:00:00.000Failed33313911
    11
    2025-03-08 00:00:00.000Succeeded48028339
    12
    2025-01-31 00:00:00.000Succeeded59742280
    13
    2025-03-24 00:00:00.000Succeeded53417939
    14
    2025-02-11 00:00:00.000Failed45435493
    15
    2025-03-11 00:00:00.000Failed35752741
    16
    2025-02-05 00:00:00.000Succeeded64708556
    17
    2025-02-14 00:00:00.000Succeeded59561718
    18
    2025-03-20 00:00:00.000Failed33916301
    19
    2025-01-25 00:00:00.000Failed40596443
    20
    2025-02-13 00:00:00.000Failed43933232
    ...
    122
    6KB
    213s