SUM(TRANSACTION_COUNT) AS transactions,

SUM(TRANSACTION_COUNT_SUCCESS) AS successful_transactions,

SUM(TRANSACTION_COUNT_FAILED) AS failed_transactions,

SUM(UNIQUE_FROM_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

near.stats.ez_core_metrics_hourly

WHERE

(BLOCK_TIMESTAMP_HOUR::date) >= (current_date - 30)