Query editor
WITH orderly_revenue (volume_date, daily_rev, cum_rev) as (SELECTfrom_iso8601_timestamp(date) as volume_date,sum(orderly_revenue) daily_revenue,sum(sum(orderly_revenue)) OVER (ORDER BY from_iso8601_timestamp(date) ASC) as cumulative_revenueFROMdune.orderly_network.orderly_revenueWHERE from_iso8601_timestamp(date) >= timestamp '2023-11-03'GROUP BY from_iso8601_timestamp(date)),orderly_revenue_with_roling (volume_date, daily_rev, cum_rev, rolling_rev, rolling_total_rev) as (SELECTvolume_date,daily_rev,cum_rev,AVG(daily_rev) OVER (ORDER BY volume_date ASC ROWS BETWEEN 29 PRECEDING AND CURRENT ROW) as rolling_rev,SUM(daily_rev) OVER (ORDER BY volume_date ASC ROWS BETWEEN 29 PRECEDING AND CURRENT ROW) as rolling_total_revFROM orderly_revenue)SELECT * FROM orderly_revenue_with_rolingWHERE volume_date >= current_date - interval '90' day AND volume_date < current_dateORDER BY volume_date DESC