Updated6 Nov 2026

US stocks and ETFs, prices and SEC fundamentals since 2010

Updated 30 Oct 2026

42.4 MB across 201 parts, newest sealed 30 October 2026 at 23:42 UTC.

The first build wrote 201 parts and 225,872 rows.

ONE_ROW_PER_COMPANY_PERIOD passed.

ENOUGH_COMPANY_PERIODS passed.

NET_INCOME_MOSTLY_PRESENT passed.

REVENUE_MOSTLY_PRESENT passed.

cik

integer

SEC Central Index Key of the filer.

17502152026

Valid: 225,872 · 100%
Missing: 0 · 0%
Distinct: 5,248 · 2.3% of valid
Min: 1750
25%: 826154
Median: 1126956
75%: 1533615
Max: 2152026

ticker

string

The issuer's main ticker on a US exchange, from the SEC ticker list.

ACN0%
BCPC0%
ELV0%
Other (5,061)

Valid: 222,673 · 98.6%
Missing: 3,199 · 1.4%
Distinct: 5,073 · 2.3% of valid

tickers_all

string

Every US-exchange ticker of the issuer, comma separated.

ACN0%
BCPC0%
ELV0%
Other (5,061)

Valid: 222,673 · 98.6%
Missing: 3,199 · 1.4%
Distinct: 5,073 · 2.3% of valid

company_name

string

Company name (issuer, brand).

Spectrum Brands Holdings, Inc.0%
Star Equity Holdings, Inc.0%
DAWSON GEOPHYSICAL CO0%
Other (5,229)

Valid: 225,872 · 100%
Missing: 0 · 0%
Distinct: 5,241 · 2.3% of valid

filer_name

string

The filer's name as the XBRL facts give it.

Spectrum Brands Holdings, Inc.0%
COMMUNITY WEST BANCSHARES0%
Bristow Group Inc.0%
Other (9,006)

Valid: 225,872 · 100%
Missing: 0 · 0%
Distinct: 9,018 · 4% of valid

frame

string

SEC calendar frame: CY2024Q1 for a calendar quarter, CY2024 for a calendar year. Fiscal periods are mapped to the nearest calendar period.

CY20252%
CY20242%
CY20232%
Other (71)

Valid: 225,872 · 100%
Missing: 0 · 0%
Distinct: 83 · 0% of valid

period_type

string

quarter or year (annual).

quarter76%
year24%

Valid: 225,872 · 100%
Missing: 0 · 0%
Distinct: 2 · 0% of valid

calendar_year

integer

Calendar year of the frame.

20102026

Valid: 225,872 · 100%
Missing: 0 · 0%
Distinct: 17 · 0% of valid
Min: 2010
25%: 2015
Median: 2019
75%: 2023
Max: 2026

calendar_quarter

integer

Calendar quarter 1 to 4 of the frame; empty for annual rows.

Valid: 172,310 · 76.3%
Missing: 53,562 · 23.7%
Distinct: 4 · 0% of valid
Min: 1
25%: 1
Median: 2
75%: 3
Max: 4

period_start

date

First day of the reported period.

2025-01-013%
2024-01-013%
2023-01-013%
Other (2,187)

Valid: 225,872 · 100%
Missing: 0 · 0%
Distinct: 2,199 · 1% of valid

period_end

date

Last day of the reported period (fiscal quarter or year end).

2019-12-312%
2020-12-312%
2025-12-312%
Other (1,832)

Valid: 225,872 · 100%
Missing: 0 · 0%
Distinct: 1,844 · 0.8% of valid

balance_sheet_date

date

Date of the balance sheet joined to this period (the calendar quarter end frame).

2019-12-312%
2020-12-312%
2025-12-312%
Other (1,925)

Valid: 222,806 · 98.6%
Missing: 3,066 · 1.4%
Distinct: 1,937 · 0.9% of valid

accession

string

Accession number of the filing the income facts came from.

0001193125-17-0624190%
0001096906-26-0003950%
0001185185-17-0005950%
Other (115,711)

Valid: 225,872 · 100%
Missing: 0 · 0%
Distinct: 115,723 · 51.2% of valid

revenue

decimal

Revenue (sales, top line) for the period, USD: Revenues, else revenue from contracts with customers, else net sales, else revenue net of interest expense for banks.

0.00002%
5000.00000%
200000.00000%
Other (147,608)

Valid: 185,237 · 82%
Missing: 40,635 · 18%
Distinct: 147,620 · 79.7% of valid
Min: -3075964000.0000
25%: 28134000.0000
Median: 208807000.0000
75%: 1082249000.0000
Max: 716924000000.0000

revenue_concept

string

Which US GAAP concept supplied revenue.

Revenues49%
RevenueFromContractWithCustomerExcludingAssessedTax30%
SalesRevenueNet12%

Valid: 185,237 · 82%
Missing: 40,635 · 18%
Distinct: 5 · 0% of valid

cost_of_revenue

decimal

Cost of revenue (cost of goods sold), USD.

0.00001%
100000.00000%
1000.00000%
Other (79,038)

Valid: 95,350 · 42.2%
Missing: 130,522 · 57.8%
Distinct: 79,050 · 82.9% of valid
Min: -153131000.0000
25%: 13280000.0000
Median: 120166000.0000
75%: 649512000.0000
Max: 535395000000.0000

gross_profit

decimal

Gross profit, USD; revenue less cost of revenue when not reported.

0.00001%
2000.00000%
4000.00000%
Other (92,114)

Valid: 118,624 · 52.5%
Missing: 107,248 · 47.5%
Distinct: 92,126 · 77.7% of valid
Min: -15646000000.0000
25%: 11972000.0000
Median: 89687000.0000
75%: 393615000.0000
Max: 396912000000.0000

operating_income

decimal

Operating income (operating profit, EBIT), USD.

0.00000%
58000000.00000%
63000000.00000%
Other (115,515)

Valid: 168,687 · 74.7%
Missing: 57,185 · 25.3%
Distinct: 115,527 · 68.5% of valid
Min: -30363000000.0000
25%: -4013000.0000
Median: 6409000.0000
75%: 91218000.0000
Max: 133050000000.0000

net_income

decimal

Net income (profit, earnings) attributable to the parent, USD; else profit or loss.

0.00000%
36000000.00000%
24000000.00000%
Other (131,517)

Valid: 218,752 · 96.8%
Missing: 7,120 · 3.2%
Distinct: 131,529 · 60.1% of valid
Min: -22395000000000.0000
25%: -3647000.0000
Median: 5711000.0000
75%: 64150000.0000
Max: 1620000000000.0000

eps_basic

decimal

Basic earnings per share, USD.

0.00001%
0.01001%
-0.01001%
Other (6,099)

Valid: 186,353 · 82.5%
Missing: 39,519 · 17.5%
Distinct: 6,111 · 3.3% of valid
Min: -152717402.0000
25%: -0.0800
Median: 0.3000
75%: 1.0000
Max: 108438984.0000

eps_diluted

decimal

Diluted earnings per share (EPS), USD.

0.00001%
0.01001%
-0.01001%
Other (5,817)

Valid: 182,795 · 80.9%
Missing: 43,077 · 19.1%
Distinct: 5,829 · 3.2% of valid
Min: -152717402.0000
25%: -0.0700
Median: 0.3000
75%: 0.9900
Max: 223207000.0000

diluted_shares

decimal

Weighted average diluted shares outstanding.

0.00000%
20000000.00000%
10000000.00000%
Other (134,344)

Valid: 172,981 · 76.6%
Missing: 52,891 · 23.4%
Distinct: 134,356 · 77.7% of valid
Min: -5.1400
25%: 19369165.0000
Median: 51645000.0000
75%: 142656000.0000
Max: 3543602532000000.0000

research_development_expense

decimal

Research and development (R&D) expense, USD.

0.00001%
1000000.00000%
7000000.00000%
Other (45,435)

Valid: 72,694 · 32.2%
Missing: 153,178 · 67.8%
Distinct: 45,447 · 62.5% of valid
Min: -7739000.0000
25%: 2110000.0000
Median: 10884000.0000
75%: 41848000.0000
Max: 61087000000.0000

sga_expense

decimal

Selling, general and administrative (SG&A) expense, USD.

0.00000%
105000000.00000%
161000000.00000%
Other (58,428)

Valid: 80,832 · 35.8%
Missing: 145,040 · 64.2%
Distinct: 58,440 · 72.3% of valid
Min: -152000000.0000
25%: 16692000.0000
Median: 73502000.0000
75%: 279000000.0000
Max: 147943000000.0000

income_tax_expense

decimal

Income tax expense, USD.

0.00007%
2000.00000%
1000.00000%
Other (59,327)

Valid: 174,847 · 77.4%
Missing: 51,025 · 22.6%
Distinct: 59,339 · 33.9% of valid
Min: -34831000000.0000
25%: 10000.0000
Median: 2817000.0000
75%: 24000000.0000
Max: 3158873000000.0000

interest_expense

decimal

Interest expense, USD.

0.00002%
1000.00000%
2000.00000%
Other (47,255)

Valid: 113,640 · 50.3%
Missing: 112,232 · 49.7%
Distinct: 47,267 · 41.6% of valid
Min: -2070000000.0000
25%: 691000.0000
Median: 6260000.0000
75%: 32745000.0000
Max: 81321000000.0000

depreciation_amortization

decimal

Depreciation, depletion and amortization (D&A), USD.

0.00000%
200000.00000%
100000.00000%
Other (40,582)

Valid: 72,833 · 32.2%
Missing: 153,039 · 67.8%
Distinct: 40,594 · 55.7% of valid
Min: -162416000.0000
25%: 1921000.0000
Median: 14466000.0000
75%: 74470000.0000
Max: 65756000000.0000

stock_based_compensation

decimal

Share-based (stock-based) compensation, USD.

0.00001%
9000000.00000%
4000000.00000%
Other (36,163)

Valid: 95,162 · 42.1%
Missing: 130,710 · 57.9%
Distinct: 36,175 · 38% of valid
Min: -144600000.0000
25%: 761000.0000
Median: 3712000.0000
75%: 14873000.0000
Max: 24953000000.0000

operating_cash_flow

decimal

Net cash from operating activities (operating cash flow), USD.

0.00000%
-2000000.00000%
154000000.00000%
Other (77,917)

Valid: 95,993 · 42.5%
Missing: 129,879 · 57.5%
Distinct: 77,929 · 81.2% of valid
Min: -251839000000.0000
25%: -3050533.0000
Median: 13887000.0000
75%: 161240058.0000
Max: 164713000000.0000

capex

decimal

Capital expenditure: payments for property, plant and equipment, USD.

0.00002%
2000.00000%
6000.00000%
Other (37,593)

Valid: 76,377 · 33.8%
Missing: 149,495 · 66.2%
Distinct: 37,605 · 49.2% of valid
Min: -417751000.0000
25%: 605000.0000
Median: 6090000.0000
75%: 42965000.0000
Max: 91447000000.0000

free_cash_flow

decimal

Free cash flow (FCF): operating cash flow less capex, USD.

0.00000%
-22000000.00000%
-56000000.00000%
Other (76,925)

Valid: 95,993 · 42.5%
Missing: 129,879 · 57.5%
Distinct: 76,937 · 80.1% of valid
Min: -251839000000.0000
25%: -6677000.0000
Median: 5938000.0000
75%: 112978000.0000
Max: 139514000000.0000

buybacks

decimal

Share repurchases (buybacks), USD.

0.000020%
100000000.00000%
50000000.00000%
Other (21,950)

Valid: 46,973 · 20.8%
Missing: 178,899 · 79.2%
Distinct: 21,962 · 46.8% of valid
Min: -22581000000.0000
25%: 195206.0000
Median: 11212000.0000
75%: 114547000.0000
Max: 94949000000.0000

dividends_paid

decimal

Dividends paid, USD.

0.00006%
3000000.00000%
19000000.00000%
Other (26,158)

Valid: 46,030 · 20.4%
Missing: 179,842 · 79.6%
Distinct: 26,170 · 56.9% of valid
Min: -2729000000.0000
25%: 4500000.0000
Median: 24381000.0000
75%: 112100000.0000
Max: 24082000000.0000

total_assets

decimal

Total assets at the period's quarter end, USD.

0.00000%
1000.00000%
25000.00000%
Other (179,316)

Valid: 210,704 · 93.3%
Missing: 15,168 · 6.7%
Distinct: 179,328 · 85.1% of valid
Min: 0.0000
25%: 209521000.0000
Median: 1330913000.0000
75%: 5953350000.0000
Max: 5015069000000.0000

current_assets

decimal

Current assets, USD.

0.00000%
25000.00000%
3012000000.00000%
Other (131,634)

Valid: 164,582 · 72.9%
Missing: 61,290 · 27.1%
Distinct: 131,646 · 80% of valid
Min: 0.0000
25%: 60262000.0000
Median: 337900000.0000
75%: 1388984000.0000
Max: 374665000000.0000

total_liabilities

decimal

Total liabilities, USD.

0.00000%
1000.00000%
2000.00000%
Other (142,818)

Valid: 169,868 · 75.2%
Missing: 56,004 · 24.8%
Distinct: 142,830 · 84.1% of valid
Min: -2241000.0000
25%: 48868000.0000
Median: 592452000.0000
75%: 3266416000.0000
Max: 4640471000000.0000

current_liabilities

decimal

Current liabilities, USD.

0.00000%
721000000.00000%
874000000.00000%
Other (122,465)

Valid: 164,074 · 72.6%
Missing: 61,798 · 27.4%
Distinct: 122,477 · 74.6% of valid
Min: 0.0000
25%: 18737000.0000
Median: 144897000.0000
75%: 790569000.0000
Max: 335734599000.0000

equity

decimal

Stockholders' equity (book value), USD.

0.00000%
5000001.00000%
5000008.00000%
Other (174,012)

Valid: 213,577 · 94.6%
Missing: 12,295 · 5.4%
Distinct: 174,024 · 81.5% of valid
Min: -23552000000.0000
25%: 54372000.0000
Median: 397828000.0000
75%: 1672025000.0000
Max: 747910000000.0000

cash

decimal

Cash and cash equivalents, USD.

0.00001%
1000.00000%
25000.00000%
Other (136,584)

Valid: 213,154 · 94.4%
Missing: 12,718 · 5.6%
Distinct: 136,596 · 64.1% of valid
Min: -77987000.0000
25%: 16732000.0000
Median: 82616000.0000
75%: 330719000.0000
Max: 759869000000.0000

short_term_investments

decimal

Short-term investments, USD.

0.00007%
5000000.00000%
50000000.00000%
Other (16,424)

Valid: 24,373 · 10.8%
Missing: 201,499 · 89.2%
Distinct: 16,436 · 67.4% of valid
Min: 0.0000
25%: 8189000.0000
Median: 55115000.0000
75%: 261000000.0000
Max: 125916000000.0000

long_term_debt

decimal

Long-term debt, non-current portion, USD.

0.00003%
10000000.00000%
250000000.00000%
Other (73,128)

Valid: 103,837 · 46%
Missing: 122,035 · 54%
Distinct: 73,140 · 70.4% of valid
Min: -23806000000.0000
25%: 73131000.0000
Median: 540800000.0000
75%: 2317733000.0000
Max: 511653000000.0000

current_debt

decimal

Debt due within a year, USD.

0.00008%
10000000.00001%
4000000.00001%
Other (27,493)

Valid: 68,496 · 30.3%
Missing: 157,376 · 69.7%
Distinct: 27,505 · 40.2% of valid
Min: -4710000000.0000
25%: 2002000.0000
Median: 15000000.0000
75%: 123818000.0000
Max: 38374000000.0000

total_debt

decimal

Total debt: long-term plus current debt, USD.

0.00002%
10000000.00000%
20000000.00000%
Other (77,421)

Valid: 111,764 · 49.5%
Missing: 114,108 · 50.5%
Distinct: 77,433 · 69.3% of valid
Min: -21412000000.0000
25%: 59330000.0000
Median: 499700000.0000
75%: 2230000000.0000
Max: 511653000000.0000

inventory

decimal

Inventory, USD.

0.00000%
44000000.00000%
12000000.00000%
Other (68,255)

Valid: 102,057 · 45.2%
Missing: 123,815 · 54.8%
Distinct: 68,267 · 66.9% of valid
Min: 0.0000
25%: 12199000.0000
Median: 95833000.0000
75%: 473299000.0000
Max: 65354000000.0000

goodwill

decimal

Goodwill, USD.

0.00001%
491479000.00000%
990000.00000%
Other (58,506)

Valid: 129,859 · 57.5%
Missing: 96,013 · 42.5%
Distinct: 58,518 · 45.1% of valid
Min: -4214000.0000
25%: 26444000.0000
Median: 204100000.0000
75%: 1139700000.0000
Max: 50263000000000.0000

fetched_at

timestamp_utc

When the SEC frames were read.

2026-10-30 23:37:31+009%
2026-10-30 23:27:02+009%
2026-10-30 23:29:10+006%
Other (136)

Valid: 225,872 · 100%
Missing: 0 · 0%
Distinct: 148 · 0.1% of valid

net_cash

decimal

Net cash: cash plus short-term investments less total debt, USD.

0.00001%
25000.00000%
1000.00000%
Other (161,059)

Valid: 213,154 · 94.4%
Missing: 12,718 · 5.6%
Distinct: 161,071 · 75.6% of valid
Min: -366859000000.0000
25%: -246586000.0000
Median: 8519000.0000
75%: 109335000.0000
Max: 759869000000.0000

gross_margin_pct

decimal

Gross margin, percent of revenue.

100.001%
0.000%
30.290%
Other (13,211)

Valid: 106,728 · 47.3%
Missing: 119,144 · 52.7%
Distinct: 13,223 · 12.4% of valid
Min: -1034250.00
25%: 22.87
Median: 37.89
75%: 59.09
Max: 2158893.50

operating_margin_pct

decimal

Operating margin, percent of revenue.

4.340%
4.000%
3.770%
Other (30,270)

Valid: 136,740 · 60.5%
Missing: 89,132 · 39.5%
Distinct: 30,282 · 22.1% of valid
Min: -5817056.76
25%: -10.47
Median: 5.98
75%: 15.57
Max: 11458333.33

net_margin_pct

decimal

Net margin (profit margin), percent of revenue.

0.000%
0.010%
4.390%
Other (34,404)

Valid: 177,265 · 78.5%
Missing: 48,607 · 21.5%
Distinct: 34,416 · 19.4% of valid
Min: -10775900.00
25%: -5.58
Median: 5.24
75%: 14.74
Max: 47396186.08

fcf_margin_pct

decimal

Free cash flow margin, percent of revenue.

5.850%
0.000%
4.100%
Other (22,529)

Valid: 79,434 · 35.2%
Missing: 146,438 · 64.8%
Distinct: 22,541 · 28.4% of valid
Min: -7616906.45
25%: -8.25
Median: 5.60
75%: 20.06
Max: 457848.28

roe_pct

decimal

Return on equity for the period (not annualized), percent.

0.000%
2.720%
2.430%
Other (20,422)

Valid: 188,894 · 83.6%
Missing: 36,978 · 16.4%
Distinct: 20,434 · 10.8% of valid
Min: -59000000000.00
25%: -3.16
Median: 2.14
75%: 5.58
Max: 3700000000.00

debt_to_equity

decimal

Total debt divided by equity (leverage).

0.00003%
0.00010%
0.00040%
Other (26,551)

Valid: 101,992 · 45.2%
Missing: 123,880 · 54.8%
Distinct: 26,563 · 26% of valid
Min: -11.4990
25%: 0.1909
Median: 0.5407
75%: 1.1065
Max: 436452.0000

current_ratio

decimal

Current assets divided by current liabilities (liquidity).

0.00000%
1.22830%
1.01940%
Other (62,045)

Valid: 163,591 · 72.4%
Missing: 62,281 · 27.6%
Distinct: 62,057 · 37.9% of valid
Min: 0.0000
25%: 1.2130
Median: 1.9715
75%: 3.5593
Max: 10291.5641

revenue_growth_yoy_pct

decimal

Revenue growth versus the same period a year earlier (year over year), percent.

-100.000%
0.000%
4.350%
Other (24,711)

Valid: 162,645 · 72%
Missing: 63,227 · 28%
Distinct: 24,723 · 15.2% of valid
Min: -39450.16
25%: -3.16
Median: 6.37
75%: 20.02
Max: 130555455.56

net_income_growth_yoy_pct

decimal

Net income (profit, earnings) growth year over year, percent; empty when last year's was not positive.

0.000%
-100.000%
-25.000%
Other (44,647)

Valid: 125,045 · 55.4%
Missing: 100,827 · 44.6%
Distinct: 44,659 · 35.7% of valid
Min: -2373328.48
25%: -40.48
Median: 3.30
75%: 38.44
Max: 2159999900.00

eps_diluted_growth_yoy_pct

decimal

Diluted EPS growth year over year, percent; empty when last year's was not positive.

0.002%
100.001%
-100.001%
Other (25,108)

Valid: 114,524 · 50.7%
Missing: 111,348 · 49.3%
Distinct: 25,120 · 21.9% of valid
Min: -3043662071.83
25%: -37.50
Median: 3.45
75%: 35.71
Max: 7828968947.62

taxonomy

string

XBRL taxonomy of the facts: us-gaap.

us-gaap100%

Valid: 225,872 · 100%
Missing: 0 · 0%
Distinct: 1 · 0% of valid

currency

string

Currency of money columns: USD.

USD100%

Valid: 225,872 · 100%
Missing: 0 · 0%
Distinct: 1 · 0% of valid

filing_url

string

Link to the SEC filing index of the accession.

https://www.sec.gov/Archives/edgar/data/92416/000119312517062419/0001193125-17-062419-index.htm0%
https://www.sec.gov/Archives/edgar/data/1267395/000126739519000008/0001267395-19-000008-index.htm0%
https://www.sec.gov/Archives/edgar/data/1417926/000118518517000595/0001185185-17-000595-index.htm0%
Other (115,711)

Valid: 225,872 · 100%
Missing: 0 · 0%
Distinct: 115,723 · 51.2% of valid