amsterdam_dicht

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
    closures AS
    (
        SELECT arrayJoin([
            toDate('2023-04-10'), toDate('2023-05-01'), toDate('2023-12-26'),
            toDate('2024-04-01'), toDate('2024-05-01'), toDate('2024-12-26'),
            toDate('2025-04-21'), toDate('2025-05-01'), toDate('2025-12-26'),
            toDate('2026-04-06'), toDate('2026-05-01')
        ]) AS closure_date
    ),
    adr AS
    (
        SELECT
            date,
            max(volume) AS day_volume
        FROM global_markets.stocks_daily_aggs
        WHERE ticker = 'ASML'
          AND date >= '2023-01-01'
        GROUP BY date
    ),
    yearly AS
    (
        SELECT
            toYear(date) AS yr,
            quantileDeterministic(0.5)(toFloat64(day_volume), toUInt32(toYYYYMMDD(date))) AS median_volume
        FROM adr
        GROUP BY yr
    )
SELECT
    toString(c.closure_date)                       AS date,
    concat(
        toString(toDayOfMonth(c.closure_date)), ' ',
        ['januari','februari','maart','april','mei','juni','juli','augustus',
         'september','oktober','november','december'][toMonth(c.closure_date)], ' ',
        toString(toYear(c.closure_date))
    )                                              AS closure_label,
    round(toFloat64(a.day_volume) / 1e6, 2)        AS asml_volume_mln,
    round(y.median_volume / 1e6, 2)                AS median_volume_mln
FROM closures AS c
INNER JOIN adr AS a ON a.date = c.closure_date
INNER JOIN yearly AS y ON y.yr = toYear(c.closure_date)
ORDER BY c.closure_date