STRASMORE/EXPLORE 2,170 QUERIES 22Y EQUITIES · 12Y OPTIONS

2,170 answered market questions

every one with its exact SQL, its result and the date it was computed · free, no signup

TSX Trading Hours and Holidays vs NYSE
US volume on five sessions when the TSX was closed and New York was openranking · 2026-08-19 · 5×4Preview: 5 ranked values, smallest first. Where US volume prints across the Eastern clock, July 2026series · 2026-08-19 · 16×3Preview: a 16-point series, roughly flat. How far Shopify's US price wanders after the 4 p.m. close, May to July 2026series · 2026-08-19 · 16×3Preview: a 16-point series, ending lower.
US volume on five sessions when the TSX was closed and New York was open

US volume on five sessions when the TSX was closed and New York was open

most recentas of ranking 5×4read in context →
US volume on five sessions when the TSX was closed and New York was open — 5 rows by 4 columns, computed from US exchange, SIP and OPRA data.
labelinterlisted_volume_pctinterlisted_prints_pctus_only_volume_pct
Boxing Day26.636.339.6
Thanksgiving (CA)43.156.982.9
Canada Day49.865.8101.2
Victoria Day56.676.992.8
Civic Holiday80.87784.5
the exact SQL behind every number 
SELECT
    multiIf(
        d.date = '2025-10-13', 'Thanksgiving (CA)',
        d.date = '2025-12-26', 'Boxing Day',
        d.date = '2026-05-18', 'Victoria Day',
        d.date = '2026-07-01', 'Canada Day',
        'Civic Holiday')                                                        AS label,
    round(100 * sumIf(d.volume, d.ticker IN ('RY','TD','BNS','BMO','ENB','TRP','CNQ','SU','CP'))
              / sumIf(b.avg_volume, d.ticker IN ('RY','TD','BNS','BMO','ENB','TRP','CNQ','SU','CP')), 1)   AS interlisted_volume_pct,
    round(100 * sumIf(d.trades, d.ticker IN ('RY','TD','BNS','BMO','ENB','TRP','CNQ','SU','CP'))
              / sumIf(b.avg_trades, d.ticker IN ('RY','TD','BNS','BMO','ENB','TRP','CNQ','SU','CP')), 1)   AS interlisted_prints_pct,
    round(100 * sumIf(d.volume, d.ticker IN ('JPM','BAC','WFC','XOM','CVX','UNP','KO','PG','CAT'))
              / sumIf(b.avg_volume, d.ticker IN ('JPM','BAC','WFC','XOM','CVX','UNP','KO','PG','CAT')), 1) AS us_only_volume_pct
FROM
(
    SELECT
        ticker,
        date,
        max(toFloat64(volume))       AS volume,
        max(toFloat64(transactions)) AS trades
    FROM global_markets.stocks_daily_aggs
    WHERE date IN ('2025-10-13','2025-12-26','2026-05-18','2026-07-01','2026-08-03')
      AND ticker IN ('RY','TD','BNS','BMO','ENB','TRP','CNQ','SU','CP',
                     'JPM','BAC','WFC','XOM','CVX','UNP','KO','PG','CAT')
    GROUP BY ticker, date
) AS d
INNER JOIN
(
    SELECT
        ticker,
        avg(volume) AS avg_volume,
        avg(trades) AS avg_trades
    FROM
    (
        SELECT
            ticker,
            date,
            max(toFloat64(volume))       AS volume,
            max(toFloat64(transactions)) AS trades
        FROM global_markets.stocks_daily_aggs
        WHERE date >= '2025-09-02'
          AND date <  '2026-08-15'
          AND date NOT IN ('2025-10-13','2025-12-26','2026-05-18','2026-07-01','2026-08-03')
          AND ticker IN ('RY','TD','BNS','BMO','ENB','TRP','CNQ','SU','CP',
                         'JPM','BAC','WFC','XOM','CVX','UNP','KO','PG','CAT')
        GROUP BY ticker, date
    )
    GROUP BY ticker
) AS b ON b.ticker = d.ticker
GROUP BY label
HAVING sumIf(b.avg_volume, d.ticker IN ('RY','TD','BNS','BMO','ENB','TRP','CNQ','SU','CP')) > 0
   AND sumIf(b.avg_volume, d.ticker IN ('JPM','BAC','WFC','XOM','CVX','UNP','KO','PG','CAT')) > 0
ORDER BY interlisted_volume_pct
More from this analysisTSX Trading Hours and Holidays vs NYSE
Where US volume prints across the Eastern clock, July 2026 series 16×3 → How far Shopify's US price wanders after the 4 p.m. close, May to July 2026 series 16×3 → Upcoming US stock market holidays and early closes series 12×6 → Every upcoming NYSE closure and early close on the calendar feed, with a countdown series 12×6 → See all 2,170 queries →
$