SUM (TRANSACTION_COUNT) AS transactions,

SUM (TRANSACTION_COUNT_SUCCESS) AS successful_transactions,

SUM (TRANSACTION_COUNT_FAILED) AS failed_transactions,

SUM (UNIQUE_SIGNERS_COUNT) AS users,

SUM (TOTAL_FEES_USD) AS fees,

CASE

WHEN SUM(TRANSACTION_COUNT) > 0 THEN

(SUM(TRANSACTION_COUNT_SUCCESS) * 100.0 / SUM(TRANSACTION_COUNT))

ELSE

0

END AS success_rate

FROM eclipse.stats.ez_core_metrics_hourly

WHERE BLOCK_TIMESTAMP_HOUR::date >= current_date-30