FINRA何时发布卖空权益数据？

SELECT settlement_date,
       count() AS names_reported
FROM global_markets.stocks_short_interest
GROUP BY settlement_date
ORDER BY settlement_date DESC
LIMIT 16

SELECT settlement_date,
       toDayOfMonth(settlement_date) AS day_of_month,
       dateDiff('day', prior, settlement_date) AS days_since_prior
FROM (
    SELECT settlement_date,
           lagInFrame(settlement_date) OVER (ORDER BY settlement_date) AS prior
    FROM (
        SELECT DISTINCT settlement_date
        FROM global_markets.stocks_short_interest
        ORDER BY settlement_date DESC
        LIMIT 17
    )
    ORDER BY settlement_date
)
WHERE prior > toDate('2000-01-01')
ORDER BY settlement_date

WITH first_arrival AS (
    SELECT settlement_date,
           toDate(min(_ingest_time)) AS arrived
    FROM global_markets.stocks_short_interest
    GROUP BY settlement_date
),
bulk_days AS (
    SELECT arrived
    FROM first_arrival
    GROUP BY arrived
    HAVING count() > 5
)
SELECT settlement_date,
       toString(arrived) AS arrived_here,
       dateDiff('day', settlement_date, arrived) AS publication_lag_days
FROM first_arrival
WHERE arrived NOT IN (SELECT arrived FROM bulk_days)
ORDER BY settlement_date

WITH first_arrival AS (
    SELECT settlement_date,
           toDate(min(_ingest_time)) AS arrived
    FROM global_markets.stocks_short_interest
    GROUP BY settlement_date
),
bulk_days AS (
    SELECT arrived
    FROM first_arrival
    GROUP BY arrived
    HAVING count() > 5
),
organic AS (
    SELECT settlement_date,
           dateDiff('day', settlement_date, arrived) AS lag
    FROM first_arrival
    WHERE arrived NOT IN (SELECT arrived FROM bulk_days)
)
SELECT count() AS settlements_measured,
       min(lag) AS fastest_lag_days,
       round(quantileDeterministic(0.5)(lag, cityHash64(settlement_date)), 1) AS median_lag_days,
       max(lag) AS slowest_lag_days
FROM organic

WITH (SELECT max(settlement_date) FROM global_markets.stocks_short_interest) AS latest
SELECT toString(latest) AS latest_settlement_on_file,
       formatDateTime(latest, '%b %e, %Y') AS latest_label,
       toDayOfMonth(latest) AS latest_day_of_month,
       (SELECT count() FROM global_markets.stocks_short_interest
        WHERE settlement_date = latest) AS securities_in_that_print,
       (SELECT dateDiff('day', latest, toDate(min(_ingest_time))) FROM global_markets.stocks_short_interest
        WHERE settlement_date = latest) AS its_publication_lag_days,
       (SELECT count() FROM global_markets.stocks_short_interest
        WHERE settlement_date > latest) AS rows_after_latest