permary Ledger Growth Over Time
    Updated 9 days ago
    select
    date(closed_at)as date,
    sum(TRANSACTION_COUNT) as total_transactions,
    sum(OPERATION_COUNT) as total_operations
    from stellar.core.fact_ledgers
    group by date
    order by date desc;

    Last run: 9 days ago
    DATE
    TOTAL_TRANSACTIONS
    TOTAL_OPERATIONS
    1
    2025-03-13 00:00:00.00013447112960012
    2
    2025-03-12 00:00:00.00020610464979097
    3
    2025-03-11 00:00:00.00019275975068453
    4
    2025-03-10 00:00:00.00020911357506830
    5
    2025-03-09 00:00:00.00019217546101912
    6
    2025-03-08 00:00:00.00018978966689185
    7
    2025-03-07 00:00:00.00019767146464388
    8
    2025-03-06 00:00:00.00018970786113487
    9
    2025-03-05 00:00:00.00020098576307912
    10
    2025-03-04 00:00:00.00019758176186164
    11
    2025-03-03 00:00:00.00018784085383194
    12
    2025-03-02 00:00:00.00017542857420692
    13
    2025-03-01 00:00:00.00016817325729634
    14
    2025-02-28 00:00:00.00018273804936121
    15
    2025-02-27 00:00:00.00017608266256911
    16
    2025-02-26 00:00:00.00018581485215150
    17
    2025-02-25 00:00:00.00019918875055814
    18
    2025-02-24 00:00:00.00018131624617644
    19
    2025-02-23 00:00:00.00015488423892374
    20
    2025-02-22 00:00:00.00015809294179618
    ...
    438
    19KB
    1s