kentosatisfactory-tomato
    Updated 2024-11-01
    SELECT
    DAY(BLOCK_TIMESTAMP_HOUR) AS day,
    SUM(TRANSACTION_COUNT) AS total_transactions
    FROM sei.stats.ez_core_metrics_hourly
    WHERE BLOCK_TIMESTAMP_HOUR >= '2024-10-01'
    AND BLOCK_TIMESTAMP_HOUR < '2024-11-01'
    GROUP BY day
    ORDER BY day;

    Last run: 2 months ago
    DAY
    TOTAL_TRANSACTIONS
    1
    14406358
    2
    24404898
    3
    34004269
    4
    43949895
    5
    54237789
    6
    64252588
    7
    74181430
    8
    84065567
    9
    94229794
    10
    104228279
    11
    114318413
    12
    124331589
    13
    134309220
    14
    144342710
    15
    154384137
    16
    164349119
    17
    174266255
    18
    184160563
    19
    194221236
    20
    204269610
    30
    382B
    1s