共同基金交易何时结算到账

WITH sessions AS (
    SELECT DISTINCT toDate(toTimeZone(window_start, 'America/New_York')) AS session_date
    FROM global_markets.delayed_stocks_minute_aggs
    WHERE ticker = 'SPY'
      AND toDate(toTimeZone(window_start, 'America/New_York')) BETWEEN toDate('2026-01-01') AND toDate('2026-07-24')
      AND (toHour(toTimeZone(window_start, 'America/New_York')) * 60
           + toMinute(toTimeZone(window_start, 'America/New_York'))) BETWEEN 570 AND 959
),
ordered AS (
    SELECT arraySort(groupArray(session_date)) AS days
    FROM sessions
),
pairs AS (
    SELECT arrayJoin(arrayZip(arraySlice(days, 1, length(days) - 1), arraySlice(days, 2))) AS pair
    FROM ordered
)
SELECT concat(formatDateTimeInJodaSyntax(pair.1, 'EEE MMM d'), ' to ',
              formatDateTimeInJodaSyntax(pair.2, 'EEE MMM d')) AS session_pair,
       dateDiff('day', pair.1, pair.2) AS calendar_days
FROM pairs
WHERE dateDiff('day', pair.1, pair.2) > 1
ORDER BY calendar_days DESC, pair.1 ASC
LIMIT 10

WITH sessions AS (
    SELECT DISTINCT toDate(toTimeZone(window_start, 'America/New_York')) AS session_date
    FROM global_markets.delayed_stocks_minute_aggs
    WHERE ticker = 'SPY'
      AND toDate(toTimeZone(window_start, 'America/New_York')) BETWEEN toDate('2025-07-01') AND toDate('2026-06-30')
      AND (toHour(toTimeZone(window_start, 'America/New_York')) * 60
           + toMinute(toTimeZone(window_start, 'America/New_York'))) BETWEEN 570 AND 959
)
SELECT formatDateTime(toStartOfMonth(session_date), '%Y-%m') AS month,
       formatDateTimeInJodaSyntax(toStartOfMonth(session_date), 'MMMM yyyy') AS month_label,
       count() AS trading_sessions,
       toDayOfMonth(toLastDayOfMonth(session_date)) AS calendar_days
FROM sessions
GROUP BY month, month_label, calendar_days
ORDER BY month

WITH daily AS (
    SELECT toDate(toTimeZone(window_start, 'America/New_York')) AS session_date,
           argMin(open, window_start) AS session_open,
           argMax(close, window_start) AS session_close
    FROM global_markets.delayed_stocks_minute_aggs
    WHERE ticker = 'SPY'
      AND toDate(toTimeZone(window_start, 'America/New_York')) BETWEEN toDate('2025-07-01') AND toDate('2026-06-30')
      AND (toHour(toTimeZone(window_start, 'America/New_York')) * 60
           + toMinute(toTimeZone(window_start, 'America/New_York'))) BETWEEN 570 AND 959
    GROUP BY session_date
),
moves AS (
    SELECT round(abs(session_close - session_open) / session_open * 100, 3) AS abs_move_pct
    FROM daily
    WHERE session_open > 0
)
SELECT multiIf(abs_move_pct < 0.25, 'under 0.25%',
               abs_move_pct < 0.5, '0.25% to 0.5%',
               abs_move_pct < 1, '0.5% to 1%',
               abs_move_pct < 2, '1% to 2%',
               '2% and up') AS move_band,
       count() AS session_count,
       round(100 * count() / sum(count()) OVER (), 1) AS share_pct
FROM moves
GROUP BY move_band
ORDER BY min(abs_move_pct)

SELECT formatDateTime(toStartOfMonth(date), '%Y-%m') AS month,
       formatDateTimeInJodaSyntax(toStartOfMonth(date), 'MMMM yyyy') AS month_label,
       round(avg(yield_3_month), 2) AS bill_3m_pct,
       round(avg(yield_10_year), 2) AS treasury_10y_pct
FROM global_markets.treasury_yields
WHERE date BETWEEN toDate('2024-07-01') AND toDate('2026-06-30')
  AND yield_3_month IS NOT NULL
  AND yield_10_year IS NOT NULL
GROUP BY month, month_label
ORDER BY month