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_timefrom finance_quotewhere 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
- Open source: https://github.com/turbot/steampipe-plugin-finance
- Community: Slack Channel