2,170 answered market questions

WITH px AS (
    SELECT ticker,
           round(min(toFloat64(low)), 2) AS jan_low,
           round(max(toFloat64(high)), 2) AS jan_high,
           round(max(toFloat64(high)) / min(toFloat64(low)), 1) AS low_to_high_multiple
    FROM global_markets.delayed_stocks_minute_aggs
    WHERE ticker IN ('GME', 'AMC', 'KOSS', 'BB')
      AND window_start >= '2021-01-04 04:00:00'
      AND window_start < '2021-01-30 04:00:00'
    GROUP BY ticker
),
si AS (
    SELECT ticker,
           round(anyIf(short_interest, settlement_date = '2020-12-31') / 1e6, 1) AS short_dec31_m,
           round(anyIf(short_interest, settlement_date = '2021-02-12') / 1e6, 1) AS short_feb12_m
    FROM global_markets.stocks_short_interest
    WHERE ticker IN ('GME', 'AMC', 'KOSS', 'BB')
      AND settlement_date IN ('2020-12-31', '2021-02-12')
    GROUP BY ticker
)
SELECT px.ticker AS ticker,
       px.jan_low AS jan_low,
       px.jan_high AS jan_high,
       px.low_to_high_multiple AS low_to_high_multiple,
       si.short_dec31_m AS short_dec31_m,
       si.short_feb12_m AS short_feb12_m
FROM px
INNER JOIN si ON px.ticker = si.ticker
ORDER BY px.low_to_high_multiple DESC