cash_by_weekday

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
    ['Monday', 'Tuesday', 'Wednesday', 'Thursday', 'Friday', 'Saturday', 'Sunday'][toDayOfWeek(trade_day)] AS weekday,
    count()                                                            AS sessions_counted,
    round(avg(dateDiff('day', trade_day, settle_day)), 2)              AS avg_days_to_cash,
    max(dateDiff('day', trade_day, settle_day))                        AS max_days_to_cash
FROM
(
    SELECT
        tupleElement(pair, 1) AS trade_day,
        tupleElement(pair, 2) AS settle_day
    FROM
    (
        SELECT arrayJoin(arrayZip(arrayPopBack(sessions), arrayPopFront(sessions))) AS pair
        FROM
        (
            SELECT arraySort(groupArray(d)) AS sessions
            FROM
            (
                SELECT today() + arrayJoin(range(120)) AS d
            )
            WHERE toDayOfWeek(d) BETWEEN 1 AND 5
              AND d NOT IN
              (
                  SELECT date
                  FROM global_markets.stocks_market_holidays
                  WHERE status = 'closed'
              )
        )
    )
)
GROUP BY weekday, toDayOfWeek(trade_day)
ORDER BY toDayOfWeek(trade_day)