monthly_volume

Run it yourself

This is the exact query behind the result above. Change a ticker, a date or a column and run it against the warehouse — no account, no key. The no-signup tier is smaller than the one this page was computed on; a query that reaches past it comes back saying which plan runs it.

SELECT
    formatDateTime(toStartOfMonth(day), '%Y-%m')      AS month,
    formatDateTime(toStartOfMonth(day), '%m/%Y')      AS month_label,
    round(avg(day_volume) / 1e6, 1)                   AS avg_daily_volume_millions,
    round(avg(day_volume * day_close) / 1e9, 1)       AS avg_daily_turnover_billions_usd
FROM
(
    SELECT
        date                                   AS day,
        max(toFloat64(volume))                 AS day_volume,
        argMax(toFloat64(close), _ingest_time) AS day_close
    FROM global_markets.stocks_daily_aggs
    WHERE ticker = 'SPY'
      AND date >= toStartOfMonth(today() - 365)
      AND date <  toStartOfMonth(today())
    GROUP BY day
)
GROUP BY month, month_label
ORDER BY month