turbot/finance

GitHub
steampipe plugin install financesteampipe plugin install finance

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