SELECT

DATE_TRUNC('hour', block_timestamp_hour) AS hour_trunc,

SUM(total_fees_usd) AS revenue

FROM

axelar.stats.ez_core_metrics_hourly

WHERE

total_fees_usd IS NOT NULL

AND

DATE_PART('quarter', block_timestamp_hour) = 1

AND

DATE_PART('year', block_timestamp_hour) = 2024

GROUP BY

hour_trunc

, revenue_with_lag AS (

SELECT

hour_trunc,

revenue,

LAG(revenue) OVER (ORDER BY hour_trunc) AS lagged_revenue

FROM

hourly_revenue

, revenue_growth AS (

SELECT

hour_trunc,

revenue,

lagged_revenue,

CASE

WHEN lagged_revenue = 0 THEN NULL

ELSE revenue / lagged_revenue - 1

END AS revenue_growth_ratio

FROM

revenue_with_lag