SELECT

transaction_date,

total_transactions_today,

SUM(total_transactions_today) OVER (ORDER BY transaction_date) AS cumulative_transactions,

(SELECT SUM(TRANSACTION_COUNT) FROM eclipse.stats.ez_core_metrics_hourly) AS total_transactions_since_launch,

(SELECT SUM(TOTAL_FEES_USD) FROM eclipse.stats.ez_core_metrics_hourly) AS total_fees_since_launch,

(SELECT SUM(TOTAL_FEES_USD) FROM eclipse.stats.ez_core_metrics_hourly) / NULLIF((SELECT SUM(TRANSACTION_COUNT) FROM eclipse.stats.ez_core_metrics_hourly), 0) AS average_fee_per_transaction

FROM (

SELECT

DATE_TRUNC('day', BLOCK_TIMESTAMP_HOUR) AS transaction_date,

SUM(TRANSACTION_COUNT) AS total_transactions_today

FROM

eclipse.stats.ez_core_metrics_hourly

GROUP BY

transaction_date

) AS daily_totals

ORDER BY

transaction_date;