SUM (TRANSACTION_COUNT) AS transations,

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

FROM base.stats.ez_core_metrics_hourly

WHERE BLOCK_TIMESTAMP_HOUR::date >= current_date-30