steampipe plugin install finance

Table: finance_us_sec_filer - Query Finance US SEC Filers using SQL

US SEC Filers are entities that are required to file statements, reports, and other forms with the U.S. Securities and Exchange Commission (SEC). These filings provide a comprehensive overview of a company's performance, financial health, and operations. The data from these filings is public and can be used for various analytical purposes.

Table Usage Guide

The finance_us_sec_filer table provides insights into US SEC Filers within the Finance service. As a financial analyst or data scientist, explore filer-specific details through this table, including their CIK, name, address, and associated metadata. Utilize it to uncover information about filers, such as their location, to aid in your financial analysis and decision-making processes.

Important Notes

  • You must specify the symbol in the where clause to query this table.

Examples

Get filer details for Apple

Explore comprehensive information about a specific company listed on the U.S. Securities and Exchange Commission (SEC) by its stock symbol. This is particularly useful for financial analysis or investment decision-making.

select
*
from
finance_us_sec_filer
where
symbol = 'AAPL';
select
*
from
finance_us_sec_filer
where
symbol = 'AAPL';

Schema for finance_us_sec_filer

NameTypeOperatorsDescription
_ctxjsonbSteampipe context in JSON form.
ciktextCIK (Central Index Key) of the filer.
nametextName of the filer.
sictextSIC (Standard Industrial Classification) of the filer.
sic_descriptiontextDescription of the SIC (Standard Industrial Classification) of the filer.
sp_connection_nametext=, !=, ~~, ~~*, !~~, !~~*Steampipe connection name.
sp_ctxjsonbSteampipe context in JSON form.
symboltext=Symbol for the filer.

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_filer