turbot/finance

steampipe plugin install financesteampipe plugin install finance
On This Page
Get Involved

Table: finance_us_sec_public_company

US public companies as registered by the US Securities and Exchange Commission.

Examples

List public companies

select
*
from
finance_us_sec_public_company
order by
name

Find a company by symbol

select
*
from
finance_us_sec_public_company
where
symbol = 'AAPL'

Find a company by name

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

"Apple"-ish companies with their last closing price

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

.inspect finance_us_sec_public_company

US public companies from the SEC Edgar database.

NameTypeDescription
nametextName of the company.
symboltextSymbol of the company.