2,309 answered market questions

WITH bars AS (
    SELECT toMonday(toDate(toTimeZone(window_start, 'America/New_York'))) AS week_start,
           argMax(close, window_start) AS week_close,
           sum(volume) AS shares
    FROM global_markets.delayed_stocks_minute_aggs
    WHERE ticker = 'DFMC'
      AND toDate(toTimeZone(window_start, 'America/New_York')) >= toDate('2026-03-20')
      AND toDate(toTimeZone(window_start, 'America/New_York')) <= toDate('2026-07-31')
    GROUP BY week_start
)
SELECT formatDateTime(week_start, '%Y-%m-%d') AS week,
       formatDateTime(week_start, '%b %e') AS week_label,
       round(week_close, 2) AS dfmc_close,
       round(shares / 1000, 1) AS volume_thousands
FROM bars
ORDER BY week_start