sutti_overlap_2026

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.

WITH
    nse_sutti AS
    (
        SELECT toDate(arrayJoin([
            '2026-01-15', '2026-01-26', '2026-03-03', '2026-03-26',
            '2026-03-31', '2026-04-03', '2026-04-14', '2026-05-01',
            '2026-05-28', '2026-06-26', '2026-09-14', '2026-10-02',
            '2026-10-20', '2026-11-10', '2026-11-24', '2026-12-25'
        ])) AS sutti_date
    ),
    us_sessions AS
    (
        SELECT
            date        AS us_date,
            max(volume) AS day_volume
        FROM global_markets.stocks_daily_aggs
        WHERE ticker = 'SPY'
          AND date >= '2026-01-01'
        GROUP BY date
    )
SELECT
    sthiti,
    count() AS divas
FROM
(
    SELECT
        day,
        multiIf(nse_bandh AND us_chalu, 'NSE बंद, अमेरिकी बाजार चालू',
                nse_bandh,              'दोन्ही बाजार बंद',
                                        'अमेरिकी बाजार बंद, NSE चालू') AS sthiti
    FROM
    (
        SELECT
            cal.day                                       AS day,
            cal.day IN (SELECT sutti_date FROM nse_sutti) AS nse_bandh,
            ifNull(toFloat64(u.day_volume), 0) > 0        AS us_chalu
        FROM
        (
            SELECT toDate('2026-01-01') + arrayJoin(range(366)) AS day
        ) AS cal
        LEFT JOIN us_sessions AS u ON u.us_date = cal.day
        WHERE toDayOfWeek(cal.day) BETWEEN 1 AND 5
          AND cal.day <= today() - 3
    )
    WHERE NOT (us_chalu AND NOT nse_bandh)
)
GROUP BY sthiti
ORDER BY divas DESC