pouya_22Stellar Operation Overtime
    Updated 10 days ago
    select
    block_timestamp::date as date,
    type_string,
    count(distinct id) as operations
    from stellar.core.fact_operations
    where block_timestamp >= '2025-01-01'
    group by 1,2
    Last run: 10 days agoAuto-refreshes every 24 hours
    DATE
    TYPE_STRING
    OPERATIONS
    1
    2025-01-07 00:00:00.000path_payment_strict_receive2607483
    2
    2025-01-05 00:00:00.000manage_sell_offer1327327
    3
    2025-01-02 00:00:00.000bump_sequence122
    4
    2025-01-14 00:00:00.000manage_buy_offer1380616
    5
    2025-01-20 00:00:00.000payment1923249
    6
    2025-01-08 00:00:00.000manage_data360
    7
    2025-01-18 00:00:00.000manage_buy_offer1200628
    8
    2025-01-15 00:00:00.000set_options39115
    9
    2025-01-18 00:00:00.000path_payment_strict_receive2660084
    10
    2025-01-16 00:00:00.000manage_data234
    11
    2025-01-14 00:00:00.000path_payment_strict_send603066
    12
    2025-01-09 00:00:00.000change_trust43102
    13
    2025-01-09 00:00:00.000end_sponsoring_future_reserves6473
    14
    2025-01-09 00:00:00.000manage_sell_offer1445470
    15
    2025-01-15 00:00:00.000manage_data325
    16
    2025-01-20 00:00:00.000manage_data263
    17
    2025-01-30 00:00:00.000payment1103107
    18
    2025-01-25 00:00:00.000manage_buy_offer1309190
    19
    2025-01-29 00:00:00.000manage_sell_offer1474509
    20
    2025-01-10 00:00:00.000set_trust_line_flags51740
    ...
    1611
    87KB
    211s