One company, two tickers: share class volume split, June 2026

WITH daily AS (
    SELECT ticker,
           multiIf(ticker IN ('GOOGL', 'GOOG'), 'Alphabet',
                   ticker IN ('FOXA', 'FOX'), 'Fox',
                   'News Corp') AS company,
           toDate(toTimeZone(window_start, 'America/New_York')) AS session_date,
           sum(volume) AS day_volume
    FROM global_markets.delayed_stocks_minute_aggs
    WHERE ticker IN ('GOOGL', 'GOOG', 'FOXA', 'FOX', 'NWSA', 'NWS')
      AND toDate(toTimeZone(window_start, 'America/New_York')) >= toDate('2026-06-01')
      AND toDate(toTimeZone(window_start, 'America/New_York')) <= toDate('2026-06-30')
    GROUP BY ticker, company, session_date
),
per_ticker AS (
    SELECT ticker,
           company,
           round(avg(day_volume) / 1e6, 2) AS avg_daily_volume_m
    FROM daily
    GROUP BY ticker, company
),
pair_totals AS (
    SELECT company, sum(avg_daily_volume_m) AS pair_volume_m
    FROM per_ticker
    GROUP BY company
)
SELECT p.ticker AS ticker,
       p.company AS company,
       p.avg_daily_volume_m AS avg_daily_volume_m,
       round(100 * p.avg_daily_volume_m / t.pair_volume_m, 1) AS share_of_pair_pct
FROM per_ticker AS p
INNER JOIN pair_totals AS t ON p.company = t.company
ORDER BY p.company, share_of_pair_pct DESC