WITH q1_revenue_24 AS (

SELECT

DATE_TRUNC('day', block_timestamp_hour) AS day,

SUM(total_fees_usd) AS total_revenue

FROM

flow.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

Day

),

revenue_with_lag AS (

SELECT

day,

total_revenue,

LAG(total_revenue) OVER (ORDER BY day) AS lagged_revenue

FROM

q1_revenue_24

),

Growth_Rate AS (

SELECT

total_revenue,

total_revenue - lagged_revenue AS revenue_growth,

(total_revenue - lagged_revenue) / Lagged_Revenue * 100 AS revenue_percentage_growth

FROM

revenue_with_lag