The listing record + the SEC filing trail behind the debut

WITH sk AS (
    SELECT
        any(issuer_name) AS issuer,
        toString(any(listing_date)) AS listed,
        any(primary_exchange) AS exchange_mic,
        any(security_description) AS security,
        round(toFloat64(any(final_issue_price)), 2) AS px,
        round(any(total_offer_size) / 1e9, 1) AS raised,
        round(any(max_shares_offered) / 1e6, 1) AS ads_m,
        round(any(max_shares_offered) * toFloat64(any(final_issue_price)) / 1e9, 1) AS math_bn,
        any(total_offer_size) AS raw_size
    FROM global_markets.stocks_ipos
    WHERE issuer_name = 'SK Hynix Inc' AND listing_date = '2026-07-10'
)
SELECT
    issuer,
    listed,
    exchange_mic,
    security,
    px AS recorded_issue_price,
    raised AS raised_bn,
    ads_m AS ads_offered_m,
    math_bn AS shares_x_price_bn,
    (SELECT count() FROM global_markets.stocks_ipos
     WHERE listing_date >= '2026-01-01' AND listing_date <= '2026-07-10'
       AND total_offer_size > (SELECT raw_size FROM sk)) AS larger_2026_raises,
    (SELECT countIf(form_type IN ('F-1', 'F-1/A')) FROM global_markets.stocks_sec_edgar_index
     WHERE issuer_name ILIKE '%hynix%' AND filing_date >= '2026-05-01' AND filing_date <= '2026-07-10') AS f1_registrations,
    (SELECT countIf(form_type = 'F-6') FROM global_markets.stocks_sec_edgar_index
     WHERE issuer_name ILIKE '%hynix%' AND filing_date >= '2026-05-01' AND filing_date <= '2026-07-10') AS f6_adr_registrations
FROM sk