SUM(TRANSACTION_COUNT) AS total_transactions

FROM eclipse.stats.ez_core_metrics_hourly

WHERE

BLOCK_TIMESTAMP_HOUR >= DATE_TRUNC('day', CURRENT_TIMESTAMP)

AND BLOCK_TIMESTAMP_HOUR < DATE_TRUNC('day', CURRENT_TIMESTAMP) + INTERVAL '1 day';