DAY(BLOCK_TIMESTAMP_HOUR) AS day,

SUM(TRANSACTION_COUNT_SUCCESS) AS successful_transactions,

SUM(TRANSACTION_COUNT_FAILED) AS failed_transactions,

CASE

WHEN SUM(TRANSACTION_COUNT) > 0 THEN

SUM(TRANSACTION_COUNT_SUCCESS) / SUM(TRANSACTION_COUNT) * 100

ELSE 0

END AS success_rate_percentage

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;