股票低于1美元交易多久？纳斯达克与纽交所规则

SELECT
    bucket_label,
    countIf(px >= lo AND px < hi)                             AS names,
    round(100 * countIf(px >= lo AND px < hi) / count(), 1)   AS share_pct,
    any(session_label)                                        AS as_of
FROM
(
    SELECT
        ticker,
        argMax(toFloat64(close), _ingest_time)       AS px,
        any(formatDateTime(date, '%b %e, %Y'))       AS session_label
    FROM global_markets.stocks_daily_aggs
    WHERE date = (SELECT max(date) FROM global_markets.stocks_daily_aggs
                  WHERE ticker = 'SPY' AND date >= today() - 14)
      AND ifNull(otc, 0) = 0
      AND length(ticker) <= 4
      AND ticker NOT IN ('SPCX')
      AND volume > 0
      AND close > 0
    GROUP BY ticker
    HAVING px < 1
) AS latest
ARRAY JOIN
    [0.00, 0.10, 0.25, 0.50, 0.75]                                                             AS lo,
    [0.10, 0.25, 0.50, 0.75, 1.00]                                                             AS hi,
    ['Under $0.10', '$0.10 to $0.25', '$0.25 to $0.50', '$0.50 to $0.75', '$0.75 to $1.00']   AS bucket_label
GROUP BY lo, hi, bucket_label
ORDER BY lo

SELECT
    toString(date)                                                     AS session_date,
    uniqExactIf(ticker, close < 1)                                     AS names_under_1,
    round(100 * uniqExactIf(ticker, close < 1) / uniqExact(ticker), 2) AS share_of_listed_pct
FROM global_markets.stocks_daily_aggs
WHERE date >= today() - 150
  AND date <= (SELECT max(date) FROM global_markets.stocks_daily_aggs
               WHERE ticker = 'SPY' AND date >= today() - 14)
  AND ifNull(otc, 0) = 0
  AND length(ticker) <= 4
  AND ticker NOT IN ('SPCX')
  AND volume > 0
  AND close > 0
GROUP BY date
ORDER BY date

SELECT
    threshold_label,
    countIf(streak >= threshold)                             AS names,
    round(100 * countIf(streak >= threshold) / count(), 1)   AS share_pct
FROM
(
    SELECT
        ticker,
        arrayReverseSort(groupArray((date, px)))                                                    AS closes_desc,
        arrayFirstIndex(x -> tupleElement(x, 2) >= 1, closes_desc)                                  AS first_at_or_above_1,
        if(first_at_or_above_1 = 0, toInt32(length(closes_desc)), toInt32(first_at_or_above_1) - 1) AS streak
    FROM
    (
        SELECT
            ticker,
            date,
            argMax(toFloat64(close), _ingest_time) AS px
        FROM global_markets.stocks_daily_aggs
        WHERE date >= today() - 400
          AND date <= (SELECT max(date) FROM global_markets.stocks_daily_aggs
                       WHERE ticker = 'SPY' AND date >= today() - 14)
          AND ifNull(otc, 0) = 0
          AND length(ticker) <= 4
          AND ticker NOT IN ('SPCX')
          AND volume > 0
          AND close > 0
          AND ticker IN
          (
              SELECT ticker
              FROM global_markets.stocks_daily_aggs
              WHERE date = (SELECT max(date) FROM global_markets.stocks_daily_aggs
                            WHERE ticker = 'SPY' AND date >= today() - 14)
                AND volume > 0
                AND close > 0
                AND close < 1
          )
        GROUP BY ticker, date
    ) AS daily
    GROUP BY ticker
) AS per_ticker
ARRAY JOIN
    [1, 30, 90, 180]                                             AS threshold,
    ['1 or more', '30 or more', '90 or more', '180 or more']     AS threshold_label
GROUP BY threshold, threshold_label
ORDER BY threshold

SELECT
    formatDateTime(toStartOfMonth(execution_date), '%Y-%m')                     AS month,
    uniqExact(ticker, execution_date)                                            AS reverse_splits,
    round(quantileExact(0.5)(toFloat64(split_from) / toFloat64(split_to)), 1)   AS median_ratio
FROM global_markets.stocks_splits
WHERE execution_date >= toStartOfMonth(today() - INTERVAL 12 MONTH)
  AND execution_date <  toStartOfMonth(today())
  AND split_from > split_to
  AND ticker NOT IN ('SPCX')
GROUP BY month
ORDER BY month