Six household names at the latest settlement: shares short, percent of shares outstanding, days to cover

WITH (SELECT max(settlement_date) FROM global_markets.stocks_short_interest) AS latest,
shares AS
(
    SELECT tk AS ticker,
           argMax(basic_shares_outstanding, (filing_date, period_end)) AS shares_out
    FROM global_markets.stocks_income_statements
    ARRAY JOIN tickers AS tk
    WHERE tk IN ('AAPL', 'KO', 'MSFT', 'NVDA', 'TSLA', 'GME')
      AND timeframe = 'quarterly'
      AND filing_date >= today() - INTERVAL 1 YEAR
      AND basic_shares_outstanding > 0
    GROUP BY tk
),
si AS
(
    SELECT ticker,
           max(short_interest) AS shares_short,
           max(days_to_cover) AS dtc
    FROM global_markets.stocks_short_interest
    WHERE settlement_date = latest
      AND ticker IN ('AAPL', 'KO', 'MSFT', 'NVDA', 'TSLA', 'GME')
    GROUP BY ticker
)
SELECT si.ticker AS ticker,
       round(si.shares_short / 1e6, 1) AS shares_short_m,
       round(shares.shares_out / 1e6, 0) AS shares_outstanding_m,
       multiIf(shares.shares_out < 1e9, toString(toUInt64(round(shares.shares_out / 1e6, 0))),
               concat(toString(intDiv(toUInt64(round(shares.shares_out / 1e6, 0)), 1000)), ',',
                      lpad(toString(toUInt64(round(shares.shares_out / 1e6, 0)) % 1000), 3, '0'))) AS shares_outstanding_m_fmt,
       round(100.0 * si.shares_short / shares.shares_out, 2) AS short_pct_of_shares_out,
       round(si.dtc, 2) AS days_to_cover
FROM si
INNER JOIN shares ON si.ticker = shares.ticker
ORDER BY indexOf(['AAPL', 'KO', 'MSFT', 'NVDA', 'TSLA', 'GME'], si.ticker)