Loading dataset
Data viewTableSummary
Data viewTableSummary
Updated

723 kB across 6 parts, newest sealed 10 November 2026 at 23:06 UTC. The first build wrote 6 parts and 13,244 rows.

All 3 checks passed.
  • One row per symbol passed.
  • Listed universe size passed.
  • Most rows have cik passed.

symbol

string

Exchange ticker symbol as Nasdaq Trader lists it (ACT symbol), such as AAPL or BRK.B.

13,244 distinct values, no chart

Valid
13,244 · 100%
Missing
0 · 0%
Distinct
13,244 · 100% of valid

sec_ticker

string

The same ticker written the SEC way, with a dash for the class or series, such as BRK-B; used to join SEC data.

13,244 distinct values, no chart

Valid
13,244 · 100%
Missing
0 · 0%
Distinct
13,244 · 100% of valid

security_name

string

The security's full listed name, such as Apple Inc. - Common Stock.

13,234 distinct values, no chart

Valid
13,244 · 100%
Missing
0 · 0%
Distinct
13,234 · 99.9% of valid

exchange

string

The listing exchange: Nasdaq, NYSE, NYSE American, NYSE Arca, Cboe BZX, IEX, NYSE Texas or Texas Stock Exchange.

  • Nasdaq42%
  • NYSE22%
  • NYSE Arca21%
Valid
13,244 · 100%
Missing
0 · 0%
Distinct
6 · 0% of valid

exchange_code

string

Nasdaq Trader's one-letter exchange code (Q Nasdaq, N NYSE, A NYSE American, P NYSE Arca, Z Cboe BZX, V IEX).

  • Q42%
  • N22%
  • P21%
Valid
13,244 · 100%
Missing
0 · 0%
Distinct
6 · 0% of valid

nasdaq_market_tier

string

For Nasdaq listings, the market tier: Global Select, Global Market or Capital Market.

  • Global Market44%
  • Capital Market30%
  • Global Select26%
Valid
5,599 · 42.3%
Missing
7,645 · 57.7%
Distinct
3 · 0.1% of valid

security_type

string

What kind of security this is: common stock, etf, preferred, adr, warrant, unit, right, debt, etn or other, from the listed name and ETF flag.

  • etf44%
  • common40%
  • preferred4%
Valid
13,244 · 100%
Missing
0 · 0%
Distinct
10 · 0.1% of valid

is_etf

boolean

True for exchange-traded funds (ETFs), as the exchange flags them.

  • false56%
  • true44%
Valid
13,244 · 100%
Missing
0 · 0%
Distinct
2 · 0% of valid

round_lot

integer

Round lot size in shares.

Histogram: 1 to 13, 24; 14 to 25, 0; 26 to 38, 0; 39 to 50, 283; 51 to 63, 0; 64 to 75, 0; 76 to 88, 0; 89 to 100, 12,937
1100
Valid
13,244 · 100%
Missing
0 · 0%
Distinct
4 · 0% of valid
Min
1
25%
100
Median
100
75%
100
Max
100

financial_status

string

Nasdaq's financial status flag when not normal: D deficient, E delinquent, Q bankrupt, G deficient and bankrupt, H deficient and delinquent, J delinquent and bankrupt, K all three.

  • D95%
  • E4%
  • H2%
Valid
346 · 2.6%
Missing
12,898 · 97.4%
Distinct
3 · 0.9% of valid

cik

integer

SEC Central Index Key of the issuer, joined from the SEC ticker list; empty when the SEC does not list the ticker (most ETFs).

Histogram: 1750 to 270731, 559; 270732 to 539712, 87; 539713 to 808693, 311; 808694 to 1077674, 1,081; 1077675 to 1346655, 763; 1346656 to 1615636, 1,287; 1615637 to 1884617, 1,685; 1884618 to 2153598, 1,740
17502153598
Valid
7,513 · 56.7%
Missing
5,731 · 43.3%
Distinct
6,042 · 80.4% of valid
Min
1750
25%
1045450
Median
1552033
75%
1863934
Max
2153598

cik10

string

The CIK zero-padded to ten digits, as SEC data URLs need it.

6,042 distinct values, no chart

Valid
7,513 · 56.7%
Missing
5,731 · 43.3%
Distinct
6,042 · 80.4% of valid

sec_company_name

string

The issuer's name as the SEC records it (company, brand).

6,042 distinct values, no chart

Valid
7,513 · 56.7%
Missing
5,731 · 43.3%
Distinct
6,042 · 80.4% of valid

sic_code

string

Standard Industrial Classification code from the issuer's latest XBRL filing.

  • 677010%
  • 28348%
  • 67985%
  • Other (377)
Valid
6,860 · 51.8%
Missing
6,384 · 48.2%
Distinct
389 · 5.7% of valid

sic_industry

string

The SEC's industry title for the SIC code, such as SEMICONDUCTORS & RELATED DEVICES (industry, sector).

  • BLANK CHECKS10%
  • PHARMACEUTICAL PREPARATIONS8%
  • REAL ESTATE INVESTMENT TRUSTS5%
  • Other (361)
Valid
6,770 · 51.1%
Missing
6,474 · 48.9%
Distinct
373 · 5.5% of valid

sic_office

string

The SEC review office for the SIC code, such as Office of Technology.

  • Office of Finance12%
  • Office of Manufacturing12%
  • Office of Technology12%
  • Other (1)
Valid
6,770 · 51.1%
Missing
6,474 · 48.9%
Distinct
13 · 0.2% of valid

sic_division

string

Broad sector from the SIC code range: Manufacturing, Finance, insurance and real estate, Services, Mining, oil and gas, and so on.

  • Finance, insurance and real estate34%
  • Manufacturing32%
  • Services16%
Valid
6,860 · 51.8%
Missing
6,384 · 48.2%
Distinct
9 · 0.1% of valid

business_country

string

Country code of the issuer's business address.

  • US87%
  • CA3%
  • CN2%
  • Other (41)
Valid
6,177 · 46.6%
Missing
7,067 · 53.4%
Distinct
53 · 0.9% of valid

business_state

string

US state or province code of the issuer's business address (headquarters).

  • CA16%
  • NY15%
  • TX10%
  • Other (46)
Valid
5,527 · 41.7%
Missing
7,717 · 58.3%
Distinct
58 · 1% of valid

business_city

string

City of the issuer's business address (headquarters).

  • NEW YORK9%
  • HOUSTON2%
  • DALLAS2%
  • Other (1,579)
Valid
6,940 · 52.4%
Missing
6,304 · 47.6%
Distinct
1,591 · 22.9% of valid

incorporation_country

string

Country code of incorporation.

  • US69%
  • KY17%
  • CA4%
  • Other (39)
Valid
6,252 · 47.2%
Missing
6,992 · 52.8%
Distinct
51 · 0.8% of valid

incorporation_state

string

State of incorporation, such as DE for Delaware.

  • DE59%
  • MD8%
  • NV6%
  • Other (46)
Valid
4,528 · 34.2%
Missing
8,716 · 65.8%
Distinct
58 · 1.3% of valid

fiscal_year_end_mmdd

string

Fiscal year end as month and day, MMDD, such as 1231 or 0930.

  • 123183%
  • 06304%
  • 03313%
Valid
6,932 · 52.3%
Missing
6,312 · 47.7%
Distinct
12 · 0.2% of valid

filer_status

string

SEC filer category: large accelerated, accelerated, non-accelerated, smaller reporting.

  • non-accelerated46%
  • large accelerated40%
  • accelerated14%
Valid
6,761 · 51%
Missing
6,483 · 49%
Distinct
3 · 0% of valid

latest_xbrl_form

string

Form of the issuer's latest XBRL financial filing in the last four quarters, such as 10-Q, 10-K, 20-F or 40-F.

  • 10-Q77%
  • 20-F8%
  • 6-K7%
  • Other (12)
Valid
6,943 · 52.4%
Missing
6,301 · 47.6%
Distinct
24 · 0.3% of valid

latest_xbrl_period

date

Balance-sheet date of that filing.

Timeline per quarter: 2025-04-01, 28; 2025-07-01, 18; 2025-10-01, 634; 2026-01-01, 164; 2026-04-01, 5,809; 2026-07-01, 290
2025-04-012026-07-01

per quarter

Valid
6,943 · 52.4%
Missing
6,301 · 47.6%
Distinct
15 · 0.2% of valid

latest_xbrl_filed

date

Date that filing was filed.

Timeline per month: 2025-10-01, 16; 2025-11-01, 12; 2025-12-01, 6; 2026-01-01, 5; 2026-02-01, 49; 2026-03-01, 170; 2026-04-01, 289; 2026-05-01, 77; 2026-06-01, 100; 2026-07-01, 1,215; 2026-08-01, 4,409; 2026-09-01, 595
2025-10-012026-09-01

per month

Valid
6,943 · 52.4%
Missing
6,301 · 47.6%
Distinct
181 · 2.6% of valid

former_name

string

The issuer's most recent former name, if it changed.

3,008 distinct values, no chart

Valid
3,603 · 27.2%
Missing
9,641 · 72.8%
Distinct
3,008 · 83.5% of valid

edgar_url

string

Link to the issuer's EDGAR filing list.

6,042 distinct values, no chart

Valid
7,513 · 56.7%
Missing
5,731 · 43.3%
Distinct
6,042 · 80.4% of valid

submissions_url

string

The SEC submissions JSON for the issuer, with every filing.

6,042 distinct values, no chart

Valid
7,513 · 56.7%
Missing
5,731 · 43.3%
Distinct
6,042 · 80.4% of valid

companyfacts_url

string

The SEC XBRL company facts JSON for the issuer.

6,042 distinct values, no chart

Valid
7,513 · 56.7%
Missing
5,731 · 43.3%
Distinct
6,042 · 80.4% of valid

directory_date

date

Date of the Nasdaq Trader directory this row came from.

Timeline per hour: 2026-11-10T00:00Z, 13,244
2026-11-10T00:00Z

per hour

Valid
13,244 · 100%
Missing
0 · 0%
Distinct
1 · 0% of valid

Support

Talk to Mostly Right

Loading chat…