Lookup an IPO

Options

Entity Id

UUID or permalink of desired entity

Field Ids (*)

Fields to include on the resulting entity - either an array of field_id strings in JSON or a comma-separated list encoded as string

Card Ids (*)

Cards to include on the resulting entity - array of card_id strings in JSON encoded as string\ Card Ids for Ipo: [fields, organization, press_references]

Result Format

Specify how the response should be mapped to the table output. The following formats are available:

Structured Table: Returns a parsed table with data split into rows and columns.

• Amount Raised: Total amount raised from the IPO
  Field Type: money
  Searchable: Yes
  Search Operators: between, blank, eq, gt, gte, lt, lte, not_eq
• Created At: Field Type: datetime
  Searchable: Yes
  Search Operators: between, blank, eq, gte, lte
• Delisted On: Date when the organization delisted its stock
  Field Type: date_precision
  Searchable: Yes
  Search Operators: between, blank, eq, gte, lte
• Entity Def Id:

  Field Type: enum
  Searchable: Yes
  Search Operators: blank, eq, includes, not_eq, not_includes
  Possible values are:

  • ipo - Ipo
• Identifier: Stock ticker symbol (e.g. AAPL, FB, TWTR)
  Field Type: identifier
  Searchable: Yes
  Search Operators: blank, contains, eq, includes, not_contains, not_eq, not_includes, starts
• Image Id: Field Type: image_id
  Searchable: No
• Organization Identifier: Organization went public
  Field Type: identifier
  Searchable: Yes
  Search Operators: blank, contains, eq, includes, not_contains, not_eq, not_includes, starts
• Permalink: Field Type: permalink
  Searchable: No
• Rank Ipo: Algorithmic rank assigned to the top 100,000 most active IPOs
  Field Type: integer
  Searchable: Yes
  Search Operators: between, blank, eq, gt, gte, lt, lte, not_eq
• Share Price: The share price for the stock at the time of IPO
  Field Type: money_decimal
  Searchable: Yes
  Search Operators: between, blank, eq, gt, gte, lt, lte, not_eq
• Shares Outstanding: Number of shares that were outstanding at the time of IPO
  Field Type: integer
  Searchable: Yes
  Search Operators: between, blank, eq, gt, gte, lt, lte, not_eq
• Shares Sold: Number of shares sold at the time of IPO
  Field Type: integer
  Searchable: Yes
  Search Operators: between, blank, eq, gt, gte, lt, lte, not_eq
• Short Description: Field Type: text_long
  Searchable: Yes
  Search Operators: blank, contains, not_contains
• Stock Exchange Symbol:

  Stock exchange where the Organization is listed (e.g. NYSE, NASDAQ)
  Field Type: enum
  Searchable: Yes
  Search Operators: blank, eq, includes, not_eq, not_includes
  Possible values are:

  • adx - ADX - Abu Dhabi Securities Exchange
  • afx - AFX - Afghanistan Stock Exchange
  • altx - ALTX - ALTX East Africa Exchange
  • amex - AMEX - American Stock Exchange
  • ams - AMS - Euronext Amsterdam
  • amx - AMX - Armenia Securities Exchange
  • asce - ASCE - Abuja Securities and Commodities Exchange
  • asx - ASX - Australian Securities Exchange
  • ath - ATH - Athens Stock Exchange
  • bcba - BCBA - Buenos Aires Stock Exchange
  • bdp - BDP - Budapest Stock Exchange
  • belex - BELEX - Belgrade Stock Exchange
  • ber - BER - Berliner Börse
  • bfb - BFB - Baku Stock Exchange
  • bit - BIT - Italian Stock Exchange
  • bkk - BKK - Thailand Stock Exchange
  • blse - BLSE - Banja Luka Stock Exchange
  • bme - BME - Madrid Stock Exchange
  • bmv - BMV - Mexican Stock Exchange
  • bom - BOM - Bombay Stock Exchange
  • brvm - BRVM - Regional Securities Exchange SA
  • bse - BSE - Bulgarian Stock Exchange
  • bse_lb - BSE - Beirut Stock Exchange
  • bsse - BSSE - Bratislava Stock Exchange
  • bsx - BSX - Bermuda Stock Exchange
  • bvb - BVB - Bucharest Stock Exchange
  • bvc - BVC - Colombian Stock Exchange
  • bvfb - BVFB - Belarusian Currency and Stock Exchange
  • bvm - BVM - Montevideo Stock Exchange
  • bvmf - B3 - Brazil Stock Exchange and OTC Market
  • bvmt - BVMT - Tunis Stock Exchange
  • bx - BX - Berne Stock Exchange
  • cas - CAS - Casablanca Stock Exchange
  • cise - CISE - Channel Islands Stock Exchange
  • cnsx - CNSX - Canadian National Stock Exchange
  • col - COL - Colombo Stock Exchange
  • cph - CPH - Copenhagen Stock Exchange
  • cse - CSE - Canadian Securities Exchange
  • cse_cy - CSE - Cyprus Stock Exchange
  • csx - CSX - Cambodia Securities Exchange
  • cve - TSX-V - Toronto TSX Venture Exchange
  • dfm - DFM - Dubai Financial Market
  • dse - DSE - Dhaka Stock Exchange
  • dsx - DSX - Douala Stock Exchange
  • dus - DUS - Börse Düsseldorf
  • ebr - EBR - Euronext Brussels
  • egx - EGX - Egypt Stock Exchange
  • eli - ELI - Euronext Lisbon
  • epa - EPA - Euronext Paris
  • etr - ETR - Deutsche Börse XETRA
  • eurex - EUREX - Eurex Exchange
  • fra - FRA - Frankfurt Stock Exchange
  • fwb - FWB - Börse Frankfurt Stock Exchange
  • gha - GHA - Ghana Stock Exchange
  • gsx - GSX - Georgian Stock Exchange
  • gsx_gi - GSX - Gibraltar Stock Exchange
  • hel - HEL - Helsinki Stock Exchange
  • hkg - HKG - Hong Kong Stock Exchange
  • hnx - HNX - Hanoi Stock Exchange
  • hose - HOSE - Ho Chi Minh Stock Exchange
  • ice - ICE - Iceland Stock Exchange
  • idx - IDX - Indonesia Stock Exchange
  • iex - IEX - Investors Exchange
  • ifb - IFB - Iran Fara Bourse
  • ime - IME - Iran Mercantile Exchange
  • irenex - IRENEX - Iran Energy Exchange
  • ise - ISE - Irish Stock Exchange
  • ist - IST - Istanbul Stock Exchange
  • isx - ISX - Iraq Stock Exchange
  • jp - JP - Japan Exchange
  • jsc - JSC - Belarusian Currency and Stock Exchange
  • jse - JSE - Johannesburg Stock Exchange
  • jse_jam - JSE - Jamaica Stock Exchange
  • kase - KASE - Kazakhstan Stock Exchange
  • klse - KLSE - Malaysia Stock Exchange
  • kosdaq - KOSDAQ - Korean Securities Dealers Automated Quotations
  • krx - KRX - Korea Stock Exchange
  • kse - KSE - Kuwait Stock Exchange
  • lje - LJE - Ljubljana Stock Exchange
  • lse - LSE - London Stock Exchange
  • lsm - LSM - Libyan Stock Market
  • lsx - LSX - Lao Securities Exchange
  • luse - LuSE - Lusaka Securities Exchange
  • luxse - LuxSE - Luxembourg Stock Exchange
  • mal - MAL - Malta Stock Exchange
  • mcx - MCX - Multi Commodity Exchange of India
  • meff - MEFF - Mercado Spanish Financial Futures Market
  • mnse - MNSE - Montenegro Stock Exchange
  • moex - MOEX - Moscow Exchange
  • mse - MSE - Metropolitan Stock Exchange
  • mse_md - MSE - Moldova Stock Exchange
  • mse_mk - MSE - Macedonian Stock Exchange
  • msei - MSEI - Metropolitan Stock Exchange of India
  • msm - MSM - Muscat Securities Market
  • mun - MUN - Börse München
  • nasdaq - NASDAQ
  • nbo - NSE - Nairobi Securities Exchange
  • neeq - NEEQ - National Equities Exchange and Quotations
  • nepse - NEPSE - Nepal Stock Exchange
  • nex - NEX - NEX Exchange
  • ngm - NGM - Nordic Growth Market Exchange
  • nig - NIG - Nigerian Stock Exchange
  • notc - NOTC - Norwegian OTC
  • npex - NPEX - NPEX Stock Exchange
  • nse - NSE - National Stock Exchange of India
  • nsx - NSX - National Stock Exchange of Australia
  • nyse - NYSE - New York Stock Exchange
  • nysearca - NYSEARCA - NYSE Arca
  • nysemkt - NYSEAMERICAN - NYSE American
  • nze - NZE - New Zealand Stock Exchange
  • ose - OSE - Oslo Stock Exchange
  • otcbb - OTCBB - FINRA OTC Bulletin Board
  • otcpink - OTC Pink
  • otcqb - OTCQB
  • otcqx - OTCQX
  • pdex - PDEx - Philippine Dealing Exchange
  • pex - PEX - Palestine Exchange
  • pfts - PFTS - PFTS Ukraine Stock Exchange
  • pomsox - POMSoX - Port Moresby Stock Exchange
  • prg - PRA - Prague Stock Exchange
  • pse - PSE - Philippine Stock Exchange
  • psx - PSX - Pakistan Stock Exchange
  • qse - QSE - Qatar Stock Exchange
  • rfb - RFB - Riga Stock Exchange
  • rse - RSE - Rwanda Stock Exchange
  • rsebl - RSEBL - Royal Securities Exchange of Bhutan
  • sase - SASE - Sarajevo Stock Exchange
  • sbx - SBX - BX Swiss
  • sehk - SEHK - The Stock Exchange of Hong Kong
  • sem - SEM - Stock Exchange of Mauritius
  • sgbv - SGBV - Algiers Stock Exchange
  • sgx - SGX - Singapore Stock Exchange
  • six - SIX - SIX Swiss Exchange
  • spbex - SPBEX - Saint Petersburg Stock Exchange
  • spse - SPSE - South Pacific Stock Exchange
  • sse - SSE - Shanghai Stock Exchange
  • ssx - SSX - Sydney Stock Exchange
  • sto - STO - Stockholm Stock Exchange
  • stu - STU - Börse Stuttgart
  • swx - SWX - SIX Swiss Exchange
  • szse - SZSE - Shenzhen Stock Exchange
  • tadawul - Tadawul - Saudi Stock Exchange
  • tal - TSE - Tallinn Stock Exchange
  • tfex - TFEX - Thailand Futures Exchange
  • tise - TISE - The International Stock Exchange
  • tlv - TLV - Tel Aviv Stock Exchange
  • tpe - TWSE - Taiwan Stock Exchange
  • tse_al - TSE - Tirana Stock Exchange
  • tse_ir - TSE - Tehran Stock Exchange
  • tsec - TWO - Taiwan OTC Exchange
  • tsx - TSX - Toronto Stock Exchange
  • ttse - TTSE - Trinidad and Tobago Stock Exchange
  • tyo - TYO - Tokyo Stock Exchange
  • use - USE - Uganda Securities Exchange
  • ux - UX - Ukrainian Exchange
  • vie - VIE - Vienna Stock Exchange
  • vmf - VMF - Faroese Securities Market
  • vse - VSE - Vancouver Stock Exchange
  • wse - WSE - Warsaw Stock Exchange
  • ysx - YSX - Yangon Stock Exchange
  • zamace - ZAMACE - Zambian Commodity Exchange
  • zse - ZSE - Zimbabwe Stock Exchange
  • zse_hr - ZSE - Zagreb Stock Exchange
• Stock Full Symbol: Field Type: text_blob
  Searchable: No
• Stock Symbol: Stock ticker symbol (e.g. AAPL, FB, TWTR)
  Field Type: text_short
  Searchable: Yes
  Search Operators: blank, contains, eq, not_contains, not_eq, starts
• Updated At: Field Type: datetime
  Searchable: Yes
  Search Operators: between, blank, eq, gte, lte
• Uuid: Field Type: uuid
  Searchable: Yes
  Search Operators: blank, eq, includes, not_eq, not_includes
• Valuation: Valuation of the Organization at IPO
  Field Type: money
  Searchable: Yes
  Search Operators: between, blank, eq, gt, gte, lt, lte, not_eq
• Went Public On: Date the Organization went public
  Field Type: date
  Searchable: Yes
  Search Operators: between, blank, eq, gte, lte

Raw Response: Returns the raw response in a single row with the following columns:

• body: Response body
• status: HTTP status code

Views

This node has no views

Workflows

• No workflows found

Links

• No links available

Developers