!pip install sec-api

from sec_api import Form_S1_424B4_Api

form_s1_424B4_api = Form_S1_424B4_Api("YOUR_API_KEY")

query = {
    "query": "ticker:V",
    "from": "0",
    "size": "50",
    "sort": [{"filedAt": {"order": "desc"}}],
}

response = form_s1_424B4_api.get_data(query)

import json
print(json.dumps(response["data"][0], indent=2))

{
  "id": "b4f377b5fcd1c9ea391ba9e8c6c5ab11",
  "filedAt": "2008-03-19T17:14:29-04:00",
  "accessionNo": "0001193125-08-060989",
  "formType": "424B4",
  "cik": "1403161",
  "ticker": "V",
  "entityName": "Visa Inc.",
  "filingUrl": "https://www.sec.gov/Archives/edgar/data/1403161/000119312508060989/d424b4.htm",
  "tickers": [
    {
      "ticker": "V",
      "type": "Class A Common Stock",
      "exchange": "New York Stock Exchange"
    }
  ],
  "securities": [
    {
      "name": "406,000,000 Shares Class A Common Stock"
    }
  ],
  "publicOfferingPrice": {
    "perShare": 44,
    "perShareText": "$44.000",
    "total": 17864000000,
    "totalText": "$17,864,000,000"
  },
  "underwritingDiscount": {
    "perShare": 1.232,
    "perShareText": "$1.232",
    "total": 500192000,
    "totalText": "$500,192,000"
  },
  "proceedsBeforeExpenses": {
    "perShare": 42.768,
    "perShareText": "$42.768",
    "total": 17363808000,
    "totalText": "$17,363,808,000"
  },
  "underwriters": [
    {
      "name": "J.P. Morgan Securities Inc."
    },
    {
      "name": "Goldman, Sachs & Co."
    },
    {
      "name": "UBS Securities LLC"
    },
    {
      "name": "Banc of America Securities LLC"
    },
    {
      "name": "Wachovia Capital Markets, LLC"
    },
    {
      "name": "Citigroup Global Markets Inc."
    },
    {
      "name": "HSBC Securities (USA) Inc."
    },
    {
      "name": "Merrill Lynch, Pierce, Fenner & Smith Incorporated"
    },
    {
      "name": "Piper Jaffray & Co."
    },
    {
      "name": "CIBC World Markets Inc."
    },
    {
      "name": "Mitsubishi UFJ Securities International plc"
    },
    {
      "name": "RBC Capital Markets Corporation"
    },
    {
      "name": "SunTrust Robinson Humphrey Inc."
    },
    {
      "name": "Wells Fargo Securities, LLC"
    },
    {
      "name": "Daiwa Securities America Inc."
    },
    {
      "name": "Mizuho Securities USA Inc."
    },
    {
      "name": "Macquarie Capital (USA) Inc."
    },
    {
      "name": "Credit Suisse Securities (USA) LLC"
    },
    {
      "name": "Santander Investment S.A."
    },
    {
      "name": "TD Securities (USA) LLC"
    },
    {
      "name": "ABN AMRO Incorporated"
    },
    {
      "name": "Barclays Capital Inc."
    },
    {
      "name": "Calyon Securities (USA) Inc."
    },
    {
      "name": "Lehman Brothers Inc."
    },
    {
      "name": "Morgan Keegan & Company, Inc."
    },
    {
      "name": "Scotia Capital (USA) Inc."
    },
    {
      "name": "The Williams Capital Group, L.P."
    },
    {
      "name": "Fox-Pitt Kelton Cochran Caronia Waller (USA) LLC"
    },
    {
      "name": "FirstRand Bank Limited"
    },
    {
      "name": "National Bank of Kuwait"
    },
    {
      "name": "Samsung Securities Co., Ltd."
    },
    {
      "name": "Gardner Rich & Co., Inc."
    },
    {
      "name": "Cowen and Company, LLC"
    },
    {
      "name": "Guzman & Company"
    },
    {
      "name": "Keefe, Bruyette & Woods, Inc."
    },
    {
      "name": "Utendahl Capital Group, LLC"
    },
    {
      "name": "Banco Bilbao Vizcaya Argentaria, S.A."
    },
    {
      "name": "Banco Bradesco BBI S.A."
    },
    {
      "name": "BB&T Capital Markets, a division of Scott & Stringfellow, Inc."
    },
    {
      "name": "BNP Paribas Securities Corp."
    },
    {
      "name": "Loop Capital Markets, LLC"
    },
    {
      "name": "M.R. Beale & Company"
    },
    {
      "name": "Muriel Siebert & Co., Inc."
    },
    {
      "name": "Samuel A. Ramirez & Co., Inc."
    },
    {
      "name": "Dundee Securities Corporation"
    }
  ],
  "lawFirms": [
    {
      "name": "White & Case LLP",
      "location": "New York, New York"
    },
    {
      "name": "Davis Polk & Wardwell",
      "location": "New York, New York"
    }
  ],
  "auditors": [
    {
      "name": "KPMG LLP"
    }
  ],
  "management": [
    {
      "name": "Joseph W. Saunders",
      "age": 62,
      "position": "Chairman and Chief Executive Officer"
    },
    {
      "name": "Byron H. Pollitt",
      "age": 56,
      "position": "Chief Financial Officer"
    },
    {
      "name": "John C. (Hans) Morris",
      "age": 49,
      "position": "President"
    },
    {
      "name": "William M. Sheedy",
      "age": 41,
      "position": "Global Head of Corporate Strategy and Business Development"
    },
    {
      "name": "Joshua R. Floum",
      "age": 49,
      "position": "General Counsel and Corporate Secretary"
    },
    {
      "name": "John M. Partridge",
      "age": 58,
      "position": "Chief Operating Officer"
    },
    {
      "name": "Ellen Richey",
      "age": 58,
      "position": "Chief Enterprise Risk Officer"
    },
    {
      "name": "Elizabeth Buse",
      "age": 47,
      "position": "Global Head of Product"
    },
    {
      "name": "Hani Al-Qadi",
      "age": 45,
      "position": "Director (Regional director from CEMEA)"
    }
  ],
  "employees": {
    "total": 5436,
    "asOfDate": "2007-12-31",
    "perDivision": [],
    "perRegion": []
  }
}

Many use cases require loading large amounts of structured data from the Registration Statement & Prospectus Data API, for example loading all data for 424B4 prospectuses from 2010 to 2023. The following code demonstrates how to achieve this by iterating over the range of years from start_year to end_year and fetching all 424B4 prospectuses for each month of each year.

The query can be adjusted and tailored to your specific needs. For example, if you are interested in S-1 registration statements, you would simply change the value of the formType parameter to "S-1". Note, the quotation marks around "S-1" are required otherwise your search query also matches on F-1 and S-11 forms. The updated query_string would look like this:

f'filedAt:[{start_date} TO {end_date}] AND formType:"S-1"'

In case you are interested in all registration statements and prospectuses, you can simply remove the formType parameter from the query_string:

f'filedAt:[{start_date} TO {end_date}]'

def load_data_from_api(start_year=2023, end_year=2024):
    years = list(range(start_year, end_year + 1))
    months = [f"{month:02d}" for month in range(1, 13)]  # 01, 02, ..., 12
    data = []

    for year in years:
        year_counter = 0

        for month in months:
            has_more = True
            query_from = 0
            query_size = 50
            month_counter = 0

            while has_more:
                start_date = f"{year}-{month}-01"
                end_date = f"{year}-{month}-31"
                query_string = (
                    f'filedAt:[{start_date} TO {end_date}] AND formType:424B4'
                )
                query = {
                    "query": query_string,
                    "from": query_from,
                    "size": query_size,
                    "sort": [{"filedAt": {"order": "desc"}}],
                }

                response = form_s1_424B4_api.get_data(query)
                if len(response["data"]) == 0:
                    break
                data += response["data"]
                query_from += query_size
                month_counter += len(response["data"])

            year_counter += month_counter
            print(f"✅ {year}-{month} with {month_counter} filings")

        print(f"✅ {year} with {year_counter} filings")

    return data

forms_424B4 = load_data_from_api(start_year = 2023, end_year = 2023)

✅ 2023-01 with 22 filings
✅ 2023-02 with 39 filings
✅ 2023-03 with 34 filings
✅ 2023-04 with 32 filings
✅ 2023-05 with 33 filings
✅ 2023-06 with 48 filings
✅ 2023-07 with 30 filings
✅ 2023-08 with 36 filings
✅ 2023-09 with 34 filings
✅ 2023-10 with 35 filings
✅ 2023-11 with 40 filings
✅ 2023-12 with 27 filings
✅ 2023 with 410 filings

forms_424B4[:2]

[{'id': '507481881b3e4416d56763903035a635',
  'filedAt': '2023-01-31T14:46:26-05:00',
  'accessionNo': '0001493152-23-003123',
  'formType': '424B4',
  'cik': '1879726',
  'ticker': 'SIDU',
  'entityName': 'Sidus Space Inc.',
  'filingUrl': 'https://www.sec.gov/Archives/edgar/data/1879726/000149315223003123/form424b4.htm',
  'tickers': [{'ticker': 'SIDU',
    'type': 'Class A Common Stock',
    'exchange': 'The Nasdaq Capital Market'}],
  'securities': [{'name': '2,640,000 shares of Class A Common Stock'},
   {'name': 'Pre-Funded Warrants to Purchase 12,360,000 shares of Class A Common Stock'},
   {'name': 'Class A common stock'},
   {'name': 'Class B common stock'}],
  'publicOfferingPrice': {'perShare': 0.3,
   'perShareText': '$0.30',
   'total': 4500000,
   'totalText': '$4,500,000'},
  'underwritingDiscount': {'perShare': 0.021,
   'perShareText': '$0.021',
   'total': 315000,
   'totalText': '$315,000'},
  'proceedsBeforeExpenses': {'perShare': 0.279,
   'perShareText': '$0.279',
   'total': 4185000,
   'totalText': '$4,185,000'},
  'underwriters': [{'name': 'Boustead Securities, LLC'},
   {'name': 'EF Hutton, division of Benchmark Investments, LLC'}],
  'lawFirms': [{'name': 'Sheppard, Mullin, Richter & Hampton LLP',
    'location': 'New York, New York'},
   {'name': 'ArentFox Schiff LLP', 'location': 'Washington, DC'}],
  'auditors': [{'name': 'BF Borgers CPA PC'}],
  'management': [{'name': 'Carol Craig',
    'age': 55,
    'position': 'Chairwoman and Chief Executive Officer'},
   {'name': 'Teresa Burchfield',
    'age': 60,
    'position': 'Chief Financial Officer'},
   {'name': 'Jamie Adams',
    'age': 59,
    'position': 'Chief Technology Officer and Director'},
   {'name': 'Dana Kilborne', 'age': 60, 'position': 'Director'},
   {'name': 'Cole Oliver', 'age': 44, 'position': 'Director'},
   {'name': 'Miguel Valero', 'age': 59, 'position': 'Director'}],
  'employees': {'total': 70,
   'asOfDate': '2022-12-30',
   'perDivision': [],
   'perRegion': []}},
 {'id': 'f6bfd35065619cbfda75e7868d4542d5',
  'filedAt': '2023-01-30T17:28:57-05:00',
  'accessionNo': '0001213900-23-006094',
  'formType': '424B4',
  'cik': '1939965',
  'ticker': 'BREA',
  'entityName': 'Brera Holdings PLC',
  'filingUrl': 'https://www.sec.gov/Archives/edgar/data/1939965/000121390023006094/ea172411-424b4_brerahold.htm',
  'tickers': [{'ticker': 'BREA',
    'type': 'Class B Ordinary Shares',
    'exchange': 'Nasdaq'}],
  'securities': [{'name': '1,500,000 Class B Ordinary Shares'},
   {'name': 'Class A Ordinary Shares'}],
  'publicOfferingPrice': {'perShare': 5,
   'perShareText': '$5.00',
   'total': 7500000,
   'totalText': '$7,500,000'},
  'underwritingDiscount': {'perShare': 0.4,
   'perShareText': '$0.40',
   'total': 600000,
   'totalText': '$600,000'},
  'proceedsBeforeExpenses': {'perShare': 4.6,
   'perShareText': '$4.60',
   'total': 6900000,
   'totalText': '$6,900,000'},
  'underwriters': [{'name': 'Revere Securities, LLC'}],
  'lawFirms': [{'name': 'Bevilacqua PLLC', 'location': 'United States'},
   {'name': 'Carmel, Milazzo & Feil LLP', 'location': 'United States'},
   {'name': 'Philip Lee LLP', 'location': 'Dublin, Ireland'}],
  'auditors': [{'name': 'TAAD LLP'}],
  'management': [{'name': 'Sergio Carlo Scalpelli',
    'age': 63,
    'position': 'Chief Executive Officer and Director'},
   {'name': 'Alessandro Aleotti',
    'age': 58,
    'position': 'Chief Strategy Officer and Director'},
   {'name': 'Amedeo Montonati',
    'age': 30,
    'position': 'Chief Financial Officer'},
   {'name': 'Daniel Joseph McClory',
    'age': 63,
    'position': 'Executive Chairman and Director'},
   {'name': 'Alberto Libanori', 'age': 33, 'position': 'Director'},
   {'name': 'Christopher Paul Gardner', 'age': 68, 'position': 'Director'},
   {'name': 'Pietro Bersani', 'age': 54, 'position': 'Director'},
   {'name': 'Goran Pandev', 'age': 39, 'position': 'Director'}],
  'employees': {'total': 0,
   'asOfDate': '2022-11-30',
   'perDivision': [],
   'perRegion': []}}]