Skip to content

Latest commit

 

History

History
72 lines (55 loc) · 2.35 KB

index.md

File metadata and controls

72 lines (55 loc) · 2.35 KB
Raw
organization category icon_url brand_color display_name name description og_description og_image
Turbot
media
/images/plugins/turbot/finance.svg
#55CC44
Finance
finance
Steampipe plugin to query financial data including quotes and public company information.
Query financial data with SQL! Open source CLI. No DB required.
/images/plugins/turbot/finance-social-graphic.png

Finance + Steampipe

Steampipe is an open source CLI to instantly query cloud APIs using SQL.

Financial data is queried from multiple sources including Yahoo Finance and the US SEC Edgar service.

For example:

select
  symbol,
  short_name,
  regular_market_price,
  regular_market_change_percent,
  regular_market_time
from
  finance_quote
where
  symbol in ('GME', 'BTC-USD', 'DOGE-USD', 'ETH-USD');
+----------+----------------------+----------------------+-------------------------------+---------------------+
| symbol   | short_name           | regular_market_price | regular_market_change_percent | regular_market_time |
+----------+----------------------+----------------------+-------------------------------+---------------------+
| GME      | GameStop Corporation | 168.74               | -0.05330589                   | 2021-05-20 13:51:33 |
| BTC-USD  | Bitcoin USD          | 41959.867            | 18.85597                      | 2021-05-20 13:51:02 |
| DOGE-USD | Dogecoin USD         | 0.41606605           | 16.540815                     | 2021-05-20 13:51:03 |
| ETH-USD  | Ethereum USD         | 2917.209             | 20.443544                     | 2021-05-20 13:51:02 |
+----------+----------------------+----------------------+-------------------------------+---------------------+

Documentation

Get started

Install

Download and install the latest Finance plugin:

steampipe plugin install finance

Configuration

Installing the latest finance plugin will create a config file (~/.steampipe/config/finance.spc) with a single connection named finance:

connection "finance" {
  plugin = "finance"
}

Get involved