3,293 answered market questions

SELECT
    cal.day                                                AS date,
    toUInt16(dateDiff('day', max(p.period_end), cal.day))  AS days_of_staleness
FROM
(
    SELECT today() - 180 + 2 * arrayJoin(range(91)) AS day
) AS cal
CROSS JOIN
(
    SELECT DISTINCT toDate(period) AS period_end
    FROM global_markets.stocks_13f_filings
    WHERE form_type = '13F-HR'
      AND toDate(period) >= '2015-01-01'
      AND toDate(period) <= today()
) AS p
WHERE addDays(p.period_end, 45) <= cal.day
GROUP BY cal.day
ORDER BY cal.day