NVDA మే 2023 ఆదాయాలు: AI అంతరం

WITH
    (
        SELECT argMaxIf(toFloat64(close), window_start,
            (toHour(toTimeZone(window_start, 'America/New_York')) * 60 + toMinute(toTimeZone(window_start, 'America/New_York'))) BETWEEN 570 AND 959)
        FROM global_markets.delayed_stocks_minute_aggs
        WHERE ticker = 'NVDA'
          AND window_start >= toDateTime('2023-05-24 00:00:00') AND window_start < toDateTime('2023-05-25 04:00:00')
    ) AS rth_close_524,
    (
        SELECT argMax(toFloat64(close), window_start)
        FROM global_markets.delayed_stocks_minute_aggs
        WHERE ticker = 'NVDA'
          AND window_start >= toDateTime('2023-05-24 00:00:00') AND window_start < toDateTime('2023-05-25 04:00:00')
    ) AS last_extended_524
SELECT
    round(rth_close_524, 2) AS may24_official_close,
    round(last_extended_524, 2) AS may24_last_extended_print,
    round((last_extended_524 / rth_close_524 - 1) * 100, 1) AS after_hours_move_pct,
    round(toFloat64(argMinIf(open, window_start,
        (toHour(toTimeZone(window_start, 'America/New_York')) * 60 + toMinute(toTimeZone(window_start, 'America/New_York'))) BETWEEN 570 AND 959)), 2) AS may25_rth_open,
    round((toFloat64(argMinIf(open, window_start,
        (toHour(toTimeZone(window_start, 'America/New_York')) * 60 + toMinute(toTimeZone(window_start, 'America/New_York'))) BETWEEN 570 AND 959)) / rth_close_524 - 1) * 100, 1) AS overnight_gap_pct
FROM global_markets.delayed_stocks_minute_aggs
WHERE ticker = 'NVDA'
  AND window_start >= toDateTime('2023-05-25 04:00:00') AND window_start < toDateTime('2023-05-25 23:59:00')

WITH
    (
        SELECT argMaxIf(toFloat64(close), window_start, (toHour(toTimeZone(window_start, 'America/New_York')) * 60 + toMinute(toTimeZone(window_start, 'America/New_York'))) BETWEEN 570 AND 959)
        FROM global_markets.delayed_stocks_minute_aggs
        WHERE ticker = 'NVDA'
          AND window_start >= toDateTime('2023-05-24 00:00:00') AND window_start < toDateTime('2023-05-25 04:00:00')
    ) AS prior_rth_close
SELECT
    round(prior_rth_close, 2) AS prior_close,
    round(toFloat64(argMinIf(open, window_start, (toHour(toTimeZone(window_start, 'America/New_York')) * 60 + toMinute(toTimeZone(window_start, 'America/New_York'))) BETWEEN 570 AND 959)), 2) AS rth_open,
    round((toFloat64(argMinIf(open, window_start, (toHour(toTimeZone(window_start, 'America/New_York')) * 60 + toMinute(toTimeZone(window_start, 'America/New_York'))) BETWEEN 570 AND 959)) / prior_rth_close - 1) * 100, 1) AS gap_pct,
    round(minIf(toFloat64(low), (toHour(toTimeZone(window_start, 'America/New_York')) * 60 + toMinute(toTimeZone(window_start, 'America/New_York'))) BETWEEN 570 AND 959), 2) AS rth_low,
    formatDateTime(toTimeZone(argMinIf(window_start, (toFloat64(low), toInt64(toUnixTimestamp(window_start))), (toHour(toTimeZone(window_start, 'America/New_York')) * 60 + toMinute(toTimeZone(window_start, 'America/New_York'))) BETWEEN 570 AND 959), 'America/New_York'), '%H:%i') AS low_et,
    round(maxIf(toFloat64(high), (toHour(toTimeZone(window_start, 'America/New_York')) * 60 + toMinute(toTimeZone(window_start, 'America/New_York'))) BETWEEN 570 AND 959), 2) AS rth_high,
    formatDateTime(toTimeZone(argMaxIf(window_start, (toFloat64(high), -toInt64(toUnixTimestamp(window_start))), (toHour(toTimeZone(window_start, 'America/New_York')) * 60 + toMinute(toTimeZone(window_start, 'America/New_York'))) BETWEEN 570 AND 959), 'America/New_York'), '%H:%i') AS high_et,
    round(toFloat64(argMaxIf(close, window_start, (toHour(toTimeZone(window_start, 'America/New_York')) * 60 + toMinute(toTimeZone(window_start, 'America/New_York'))) BETWEEN 570 AND 959)), 2) AS rth_close,
    round((toFloat64(argMaxIf(close, window_start, (toHour(toTimeZone(window_start, 'America/New_York')) * 60 + toMinute(toTimeZone(window_start, 'America/New_York'))) BETWEEN 570 AND 959)) / prior_rth_close - 1) * 100, 1) AS day_change_pct,
    round((minIf(toFloat64(low), (toHour(toTimeZone(window_start, 'America/New_York')) * 60 + toMinute(toTimeZone(window_start, 'America/New_York'))) BETWEEN 570 AND 959) / prior_rth_close - 1) * 100, 1) AS low_vs_prior_pct,
    round(toFloat64(sum(volume)) / 1e6, 1) AS day_shares_m,
    countIf((toHour(toTimeZone(window_start, 'America/New_York')) * 60 + toMinute(toTimeZone(window_start, 'America/New_York'))) BETWEEN 570 AND 959) AS rth_minute_bars
FROM global_markets.delayed_stocks_minute_aggs
WHERE ticker = 'NVDA'
  AND window_start >= toDateTime('2023-05-25 04:00:00') AND window_start < toDateTime('2023-05-25 23:59:00')

SELECT
    ticker,
    may24_close,
    may25_close,
    round((may25_close / may24_close - 1) * 100, 1) AS day_change_pct
FROM (
    SELECT
        ticker,
        round(argMaxIf(toFloat64(close), window_start,
            toDate(toTimeZone(window_start, 'America/New_York')) = toDate('2023-05-24') AND (toHour(toTimeZone(window_start, 'America/New_York')) * 60 + toMinute(toTimeZone(window_start, 'America/New_York'))) BETWEEN 570 AND 959), 2) AS may24_close,
        round(argMaxIf(toFloat64(close), window_start,
            toDate(toTimeZone(window_start, 'America/New_York')) = toDate('2023-05-25') AND (toHour(toTimeZone(window_start, 'America/New_York')) * 60 + toMinute(toTimeZone(window_start, 'America/New_York'))) BETWEEN 570 AND 959), 2) AS may25_close
    FROM global_markets.delayed_stocks_minute_aggs
    WHERE ticker IN ('NVDA', 'AMD', 'TSM', 'AVGO', 'MU', 'INTC', 'MSFT', 'SPY', 'QQQ')
      AND window_start >= toDateTime('2023-05-24 00:00:00') AND window_start < toDateTime('2023-05-26 00:00:00')
    GROUP BY ticker
)
ORDER BY day_change_pct DESC

SELECT
    toString(toDate(toTimeZone(sip_timestamp, 'America/New_York'))) AS session,
    round(sum(size) / 1e6, 2) AS contracts_m,
    round(count() / 1e3, 0) AS trades_k,
    round(100.0 * sumIf(size, substring(ticker, 13, 1) = 'C') / sum(size), 1) AS call_share_pct,
    round(sum(size * price * 100) / 1e9, 2) AS premium_bn
FROM global_markets.options_trades
WHERE ticker LIKE 'O:NVDA2%'
  AND sip_timestamp >= toDateTime('2023-05-17 00:00:00') AND sip_timestamp < toDateTime('2023-05-26 00:00:00')
GROUP BY session
ORDER BY session

WITH daily AS (
    SELECT
        toDate(toTimeZone(window_start, 'America/New_York')) AS et_date,
        argMinIf(toFloat64(open), window_start, (toHour(toTimeZone(window_start, 'America/New_York')) * 60 + toMinute(toTimeZone(window_start, 'America/New_York'))) BETWEEN 570 AND 959) AS rth_open,
        argMaxIf(toFloat64(close), window_start, (toHour(toTimeZone(window_start, 'America/New_York')) * 60 + toMinute(toTimeZone(window_start, 'America/New_York'))) BETWEEN 570 AND 959) AS rth_close
    FROM global_markets.delayed_stocks_minute_aggs
    WHERE ticker = 'NVDA'
    GROUP BY et_date
    HAVING countIf((toHour(toTimeZone(window_start, 'America/New_York')) * 60 + toMinute(toTimeZone(window_start, 'America/New_York'))) BETWEEN 570 AND 959) > 0
)
SELECT
    toString(et_date) AS session,
    round(prev_close, 2) AS prior_close,
    round(rth_open, 2) AS open_usd,
    round((rth_open / prev_close - 1) * 100, 1) AS overnight_gap_pct
FROM (
    SELECT et_date, rth_open, rth_close,
           lagInFrame(rth_close) OVER (ORDER BY et_date ASC ROWS BETWEEN 1 PRECEDING AND CURRENT ROW) AS prev_close
    FROM daily
)
WHERE prev_close > 0 AND isFinite(rth_open / prev_close)
ORDER BY overnight_gap_pct DESC
LIMIT 10

WITH
    daily AS (
        SELECT
            toDate(toTimeZone(window_start, 'America/New_York')) AS et_date,
            argMaxIf(toFloat64(close), window_start, (toHour(toTimeZone(window_start, 'America/New_York')) * 60 + toMinute(toTimeZone(window_start, 'America/New_York'))) BETWEEN 570 AND 959) AS rth_close
        FROM global_markets.delayed_stocks_minute_aggs
        WHERE ticker = 'NVDA'
          AND window_start >= toDateTime('2023-05-23 00:00:00') AND window_start < toDateTime('2023-06-17 00:00:00')
        GROUP BY et_date
    ),
    (SELECT any(rth_close) FROM daily WHERE et_date = toDate('2023-05-24')) AS pre_gap_close
SELECT
    toString(et_date) AS session,
    round(rth_close, 2) AS close_usd,
    round(if(prev_close = 0, NULL, (rth_close / prev_close - 1) * 100), 1) AS change_pct,
    round((rth_close / pre_gap_close - 1) * 100, 1) AS cum_vs_pregap_pct
FROM (
    SELECT et_date, rth_close,
           lagInFrame(rth_close) OVER (ORDER BY et_date ASC ROWS BETWEEN 1 PRECEDING AND CURRENT ROW) AS prev_close
    FROM daily
)
WHERE et_date >= toDate('2023-05-24')
ORDER BY et_date

WITH
    daily AS (
        SELECT
            toDate(toTimeZone(window_start, 'America/New_York')) AS et_date,
            argMaxIf(toFloat64(close), window_start, (toHour(toTimeZone(window_start, 'America/New_York')) * 60 + toMinute(toTimeZone(window_start, 'America/New_York'))) BETWEEN 570 AND 959) AS rth_close,
            maxIf(toFloat64(high), (toHour(toTimeZone(window_start, 'America/New_York')) * 60 + toMinute(toTimeZone(window_start, 'America/New_York'))) BETWEEN 570 AND 959) AS rth_high
        FROM global_markets.delayed_stocks_minute_aggs
        WHERE ticker = 'NVDA'
          AND window_start >= toDateTime('2023-05-24 00:00:00') AND window_start < toDateTime('2023-06-20 00:00:00')
        GROUP BY et_date
    ),
    firsts AS (
        SELECT
            minIf(et_date, rth_high >= 404.86) AS ft,
            minIf(et_date, rth_close >= 404.86) AS fc
        FROM daily
    ),
    (SELECT any(rth_close) FROM daily WHERE et_date = toDate('2023-05-24')) AS pre_close,
    (
        SELECT argMinIf(toFloat64(open), window_start, (toHour(toTimeZone(window_start, 'America/New_York')) * 60 + toMinute(toTimeZone(window_start, 'America/New_York'))) BETWEEN 570 AND 959)
        FROM global_markets.delayed_stocks_minute_aggs
        WHERE ticker = 'NVDA'
          AND window_start >= toDateTime('2023-05-25 04:00:00') AND window_start < toDateTime('2023-05-26 00:00:00')
    ) AS may25_open
SELECT
    round((may25_open - pre_close) * 2.47, 0) AS overnight_cap_added_bn,
    toString(any(f.ft)) AS first_touch_session,
    round(anyIf(d.rth_high, d.et_date = f.ft), 2) AS first_touch_high,
    round(anyIf(d.rth_close, d.et_date = f.ft), 2) AS first_touch_close,
    countIf(d.et_date > toDate('2023-05-24') AND d.et_date <= f.ft) AS sessions_to_first_touch,
    toString(any(f.fc)) AS first_close_session,
    round(anyIf(d.rth_close, d.et_date = f.fc), 2) AS first_close_usd,
    countIf(d.et_date > toDate('2023-05-24') AND d.et_date <= f.fc) AS sessions_to_first_close,
    round((anyIf(d.rth_close, d.et_date = f.fc) / pre_close - 1) * 100, 1) AS first_close_cum_pct
FROM daily AS d
CROSS JOIN firsts AS f