Plugins

turbot/finance

GitHub
Overview
5Tables
Versions
GitHub
steampipe plugin install financesteampipe plugin install finance
On This Page
Documentation
Get started
Get involved
Get Involved
Edit on GitHub
Discuss on Slack
Source Code
turbot/steampipe-plugin-finance
License
Apache License 2.0
Version
v0.5.0
Published
12 May 2023

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