Baselight

S&P 500 Companies With Financial Information

S&P500 Complete Financial Data

@kaggle.franoisgeorgesjulien_s_and_p_500_companies_with_financ_a652b32a

Loading...
Loading...

About this Dataset

S&P 500 Companies With Financial Information

This dataset provides comprehensive financial information for companies listed in the S&P 500 index. The dataset encompasses a range of fundamental financial metrics and attributes, making it a valuable resource for financial analysis, investment research, and market insights.

Features:

Name: The official name or full corporate title of each company.

Sector: The sector to which the company belongs, categorizing it into specific industry groups within the S&P 500.

Price: The current trading price of the company's stock.

Price/Earnings: The price-to-earnings (P/E) ratio, a key valuation metric, indicating the relationship between the stock's price and its earnings per share.

Dividend Yield: The dividend yield, representing the ratio of the annual dividend payment to the stock's current price.

Earnings/Share: The earnings per share (EPS), a measure of a company's profitability, calculated as earnings divided by the number of outstanding shares.

52 Week Low: The lowest price at which the stock has traded over the past 52 weeks.

52 Week High: The highest price at which the stock has traded over the past 52 weeks.

Market Cap: The total market capitalization of the company, representing the product of the stock's current price and the total number of outstanding shares.

EBITDA: Earnings before interest, taxes, depreciation, and amortization, a measure of a company's operating performance.

Price/Sales: The price-to-sales ratio, which compares the stock's price to the company's revenue per share.

Price/Book: The price-to-book (P/B) ratio, comparing the stock's price to its book value per share, an indicator of the stock's relative value.

SEC Filings: Information regarding the company's filings with the U.S. Securities and Exchange Commission (SEC), providing transparency and compliance data.

Tables

Constituents Financials

@kaggle.franoisgeorgesjulien_s_and_p_500_companies_with_financ_a652b32a.constituents_financials
  • 57.85 KB
  • 505 rows
  • 14 columns
Loading...

CREATE TABLE constituents_financials (
  "symbol" VARCHAR,
  "name" VARCHAR,
  "sector" VARCHAR,
  "price" DOUBLE,
  "price_earnings" DOUBLE,
  "dividend_yield" DOUBLE,
  "earnings_share" DOUBLE,
  "n_52_week_low" DOUBLE,
  "n_52_week_high" DOUBLE,
  "market_cap" BIGINT,
  "ebitda" DOUBLE,
  "price_sales" DOUBLE,
  "price_book" DOUBLE,
  "sec_filings" VARCHAR
);

Share link

Anyone who has the link will be able to view this.