3,256 answered market questions

WITH
    latest_close AS
    (
        SELECT
            ticker,
            argMax(close, date) AS last_px
        FROM global_markets.stocks_daily_aggs
        WHERE ticker IN ('NFLX', 'NVR', 'BKNG', 'AZO', 'MELI', 'COST', 'ORLY', 'AAPL', 'MSFT', 'META', 'NVDA', 'WMT')
          AND date >= today() - 14
        GROUP BY ticker
    ),
    latest_split AS
    (
        SELECT
            ticker,
            max(execution_date) AS split_on
        FROM global_markets.stocks_splits
        WHERE ticker IN ('NFLX', 'NVR', 'BKNG', 'AZO', 'MELI', 'COST', 'ORLY', 'AAPL', 'MSFT', 'META', 'NVDA', 'WMT')
        GROUP BY ticker
    )
SELECT
    c.ticker                       AS ticker,
    round(toFloat64(c.last_px), 2) AS last_close,
    if(toYear(s.split_on) < 1980,
       'none on record',
       formatDateTime(s.split_on, '%b %Y')) AS most_recent_split
FROM latest_close AS c
LEFT JOIN latest_split AS s ON s.ticker = c.ticker
ORDER BY
    c.ticker = 'NFLX' DESC,
    last_close DESC