Table: finance_us_sec_public_company - Query Finance US SEC Public Companies using SQL

The US Securities and Exchange Commission (SEC) Public Company is a regulated entity that is required to disclose certain business and financial information to the public and the SEC. This includes annual reports, quarterly earnings updates, and any significant developments that could affect the company's financial health. These disclosures help investors make informed decisions and ensure that companies are adhering to regulatory standards.

Table Usage Guide

The finance_us_sec_public_company table provides insights into US SEC Public Companies within the finance sector. As a financial analyst or investor, explore company-specific details through this table, including financial data, filings, and associated metadata. Utilize it to uncover information about companies, such as their financial health, regulatory compliance, and significant developments that could impact their financial status.

Note: To query this table, you must configure an API token in the ~/.steampipe/config/finance.spc file, as instructed in the documentation (https://hub.steampipe.io/plugins/turbot/finance#documentation).

Examples

List public companies

Explore which public companies are listed in the U.S. Securities and Exchange Commission's database. This is useful for gaining insights into the landscape of publicly traded companies.

select
  *
from
  finance_us_sec_public_company
order by
  name;

select
  *
from
  finance_us_sec_public_company
order by
  name;

Find a company by symbol

Discover the details of a specific company by using its unique symbol. This can be useful to quickly gain insights into a company's financial data without having to search through extensive databases.

select
  *
from
  finance_us_sec_public_company
where
  symbol = 'AAPL';

select
  *
from
  finance_us_sec_public_company
where
  symbol = 'AAPL';

Find a company by name

Discover the specifics of a particular company by searching using its name. This can be useful for gaining insights into a company's financial information, which can be beneficial for investment decisions or competitive analysis.

select
  *
from
  finance_us_sec_public_company
where
  name ilike '%apple%'
order by
  name;

select
  *
from
  finance_us_sec_public_company
where
  name like '%apple%'
order by
  name;

"Apple"-ish companies with their last closing price

Discover companies with names similar to "Apple" and gain insights into their latest closing prices. This query can be used to track and compare the financial performance of similarly named companies in the market.

select
  c.symbol,
  c.name,
  f.*
from
  finance_us_sec_public_company as c,
  finance_us_sec_filer as f
where
  c.symbol = f.symbol
  and c.name ilike '%apple%'
order by
  c.symbol;

select
  c.symbol,
  c.name,
  f.*
from
  finance_us_sec_public_company as c,
  finance_us_sec_filer as f
where
  c.symbol = f.symbol
  and lower(c.name) like '%apple%'
order by
  c.symbol;

Schema for finance_us_sec_public_company

Name	Type	Operators	Description
_ctx	jsonb		Steampipe context in JSON form.
cik	text		Central Index Key (CIK), if available for the company. The CIK is used to identify entities that are regulated by the Securities and Exchange Commission (SEC).
currency	text		Currency the symbol is traded in using.
date	timestamp with time zone		Date the symbol reference data was generated.
exchange	text		Exchange symbol.
exchange_name	text		Exchange name.
exchange_segment	text		Exchange segment.
exchange_segment_name	text		Exchange segment name.
exchange_suffix	text		Exchange segment suffix.
figi	text		OpenFIGI id for the security, if available.
iex_id	text		Unique ID applied by IEX to track securities through symbol changes.
is_enabled	boolean		True if the symbol is enabled for trading on IEX.
lei	text		Legal Entity Identifier (LEI) for the security, if available.
name	text		Name of the company.
region	text		Country code for the symbol.
sp_connection_name	text	=, !=, ~~, ~~, !~~, !~~	Steampipe connection name.
sp_ctx	jsonb		Steampipe context in JSON form.
symbol	text		Symbol of the company.
type	text		common issue typepossible values are: ad - ADR, cs - Common Stock, cef - Closed End Fund, et - ETF, oef - Open Ended Fund, ps - Preferred Stock, rt - Right, struct - Structured Product, ut - Unit, wi - When Issued, wt - Warrant, empty - Other.

Export

This table is available as a standalone Exporter CLI. Steampipe exporters are stand-alone binaries that allow you to extract data using Steampipe plugins without a database.

You can download the tarball for your platform from the Releases page, but it is simplest to install them with the steampipe_export_installer.sh script:

/bin/sh -c "$(curl -fsSL https://steampipe.io/install/export.sh)" -- finance

You can pass the configuration to the command with the --config argument:

steampipe_export_finance --config '<your_config>' finance_us_sec_public_company