Skip to content
Book a demoStart free
Connectors

Finage connector

Set up the Finage connector in Kaivo: authentication, configuration, the 18 BigQuery tables it syncs, and answers to common questions.

Finage connector pricing, tier and credits on kaivo.io

Kaivo is a fully managed data platform that syncs your Finage data into a Google BigQuery warehouse and keeps it up to date automatically. There is no pipeline to build and no infrastructure to run, so you can spend your time analysing your payment and finance data instead of moving it.

Sync your Finage market data, financial statements, and calendars into BigQuery with Kaivo to analyse stocks, fundamentals, and market events.

CategoryFinance & Payments
AuthenticationAPI key
SetupSelf-service
  1. Sign up for Kaivo and create a workspace.
  2. Connect your Finage account.
  3. Choose which tables to sync.
  4. Wait for the initial sync to finish.
  5. Query your data in BigQuery or your favourite AI or BI tool.

Authenticate with your API Key.

Field Description
API Key
Your Finage API key.

|

When you set up the connector, you provide:

Field Description
Symbols
List of ticker symbols to fetch data for (e.g. AAPL, MSFT).

| | Technical Indicator Type |

Technical indicator to use for the Technical Indicators stream.

| | Time Interval |

Time interval for the Technical Indicators stream.

| | Period |

Number of data points used to calculate the technical indicator (e.g. a 10-period moving average).

| | Time Period |

Reporting period for financial statement streams.

| | Start Date |

Any data before this date will not be fetched.

|

Kaivo syncs 18 tables from Finage into a dedicated dataset in your BigQuery warehouse. Click any table to see its columns and types.

balance_sheet_statements (47 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
accepted_date STRING
account_payables FLOAT64
accumulated_other_comprehensive_income_loss FLOAT64
cash_and_cash_equivalents FLOAT64
cash_and_short_term_investments FLOAT64
common_stock FLOAT64
date STRING
deferred_revenue FLOAT64
deferred_revenue_non_current FLOAT64
deferred_tax_liabilities_non_current FLOAT64
filling_date STRING
final_link STRING
goodwill FLOAT64
goodwill_and_intangible_assets FLOAT64
intangible_assets FLOAT64
inventory FLOAT64
link STRING
long_term_debt FLOAT64
long_term_investments FLOAT64
net_debt FLOAT64
net_receivables FLOAT64
other_assets FLOAT64
other_current_assets FLOAT64
other_current_liabilities FLOAT64
other_non_current_assets FLOAT64
other_non_current_liabilities FLOAT64
othertotal_stockholders_equity FLOAT64
period STRING
property_plant_equipment_net FLOAT64
retained_earnings FLOAT64
short_term_debt FLOAT64
short_term_investments FLOAT64
symbol STRING
tax_assets FLOAT64
tax_payables FLOAT64
total_assets FLOAT64
total_current_assets FLOAT64
total_current_liabilities FLOAT64
total_debt FLOAT64
total_investments FLOAT64
total_liabilities FLOAT64
total_liabilities_and_stockholders_equity FLOAT64
total_non_current_assets FLOAT64
total_non_current_liabilities FLOAT64
total_stockholders_equity FLOAT64
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
cash_flow_statements (39 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
accepted_date STRING
accounts_payables FLOAT64
accounts_receivables FLOAT64
acquisitions_net FLOAT64
capital_expenditure FLOAT64
cash_at_beginning_of_period FLOAT64
cash_at_end_of_period FLOAT64
change_in_working_capital FLOAT64
common_stock_issued FLOAT64
common_stock_repurchased FLOAT64
date STRING
debt_repayment FLOAT64
deferred_income_tax FLOAT64
depreciation_and_amortization FLOAT64
dividends_paid FLOAT64
effect_of_forex_changes_on_cash FLOAT64
filling_date STRING
final_link STRING
free_cash_flow FLOAT64
inventory FLOAT64
investments_in_property_plant_and_equipment FLOAT64
link STRING
net_cash_provided_by_operating_activities FLOAT64
net_cash_used_for_investing_activites FLOAT64
net_cash_used_provided_by_financing_activities FLOAT64
net_change_in_cash FLOAT64
net_income FLOAT64
operating_cash_flow FLOAT64
other_financing_activites FLOAT64
other_investing_activites FLOAT64
other_non_cash_items FLOAT64
other_working_capital FLOAT64
period STRING
purchases_of_investments FLOAT64
sales_maturities_of_investments FLOAT64
stock_based_compensation FLOAT64
symbol STRING
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
delisted_companies (7 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
company_name STRING
delisted_date STRING
exchange STRING
ipo_date STRING
symbol STRING
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
earning_calendar (9 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
date STRING
eps FLOAT64
estimated_eps FLOAT64
estimated_revenue FLOAT64
revenue FLOAT64
symbol STRING
time STRING
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
economic_calendar (11 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
actual FLOAT64
change FLOAT64
change_percentage FLOAT64
country STRING
country_flag STRING
date STRING
estimate FLOAT64
event STRING
previous FLOAT64
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
historical_dividends_calendar (9 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
adj_dividend FLOAT64
date STRING
declaration_date STRING
dividend FLOAT64
label STRING
payment_date STRING
record_date STRING
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
historical_stock_split (6 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
date STRING
denominator_factor FLOAT64
label STRING
numerator_factor FLOAT64
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
income_statement (35 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
accepted_date STRING
cost_and_expenses FLOAT64
cost_of_revenue FLOAT64
date STRING
depreciation_and_amortization FLOAT64
ebitda FLOAT64
ebitda_ratio FLOAT64
eps FLOAT64
eps_diluted FLOAT64
filling_date STRING
final_link STRING
general_and_administrative_expenses FLOAT64
gross_profit FLOAT64
gross_profit_ratio FLOAT64
income_before_tax FLOAT64
income_before_tax_ratio FLOAT64
income_tax_expense FLOAT64
interest_expense FLOAT64
link STRING
net_income FLOAT64
net_income_ratio FLOAT64
operating_expenses FLOAT64
operating_income FLOAT64
operating_income_ratio FLOAT64
other_expenses FLOAT64
period STRING
research_and_development_expenses FLOAT64
revenue FLOAT64
selling_and_marketing_expenses FLOAT64
symbol STRING
total_other_income_expenses_net FLOAT64
weighted_average_shs_out FLOAT64
weighted_average_shs_out_dil FLOAT64
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
institutional_holders (6 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
change FLOAT64
holder STRING
report_date STRING
shares FLOAT64
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
ipo_calendar (10 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
company STRING
date STRING
exchange STRING
market_cap FLOAT64
price_range STRING
shares FLOAT64
status STRING
symbol STRING
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
market_news (7 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
description STRING
date STRING
source STRING
title STRING
url STRING
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
most_active_us_stocks (8 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
datetime STRING
change FLOAT64
change_percentage STRING
company_name STRING
price STRING
symbol STRING
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
most_gainers (7 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
change STRING
change_percentage STRING
company_name STRING
price STRING
symbol STRING
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
most_losers (7 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
change STRING
change_percentage STRING
company_name STRING
price STRING
symbol STRING
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
mutual_fund_holder (7 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
change FLOAT64
holder STRING
report_date STRING
shares FLOAT64
weight_percentage STRING
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
sector_performance (4 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
change_percentage STRING
sector STRING
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
shares_float (7 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
date STRING
outstanding_shares FLOAT64
public_float FLOAT64
stock_float FLOAT64
symbol STRING
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
technical_indicators (11 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
type STRING
close STRING
date STRING
high STRING
low STRING
open STRING
symbol STRING
value STRING
volume STRING
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.

After the first load, Kaivo keeps your BigQuery warehouse up to date for you. Where Finage supports it, each sync pulls only new and changed records so it stays fast; otherwise it refreshes the whole table. Every record keeps its original ID, so you won’t get duplicate rows.

How long does the initial sync take for Finage?

Section titled “How long does the initial sync take for Finage?”

It depends on how much history is in your Finage account. Most initial syncs finish within minutes, while large accounts can take a few hours. After that, syncs only fetch new and changed records, so they’re much faster.

Yes. You pick which tables to sync when you set up the connection and can change the selection later. Tables you don’t select are never copied to your warehouse.

What happens when Finage’s schema changes?

Section titled “What happens when Finage’s schema changes?”

New fields are never added automatically. You choose which fields to sync, so data you haven’t selected (sensitive personal data, for example) never lands in your warehouse. When a new field appears, it becomes available for you to add. What happens to removed or renamed fields depends on a table’s sync mode: full-refresh tables always match what’s currently in Finage, so dropped fields disappear, while incremental tables keep their existing columns and history, so an old field stays and newly added fields fill in over time.

How do I handle GDPR or data deletion requests?

Section titled “How do I handle GDPR or data deletion requests?”

Your data lives in your own Kaivo-managed BigQuery warehouse, so the most direct option is to delete or anonymise specific records right in BigQuery. If you delete data in Finage instead, full-refresh tables drop it on the next sync, while incremental tables keep it, so you would remove the row in BigQuery or ask us to run a full refresh. To remove everything, delete the Finage connector in Kaivo and all of its synced data is deleted with it.

Combine income_statement, balance_sheet_statements, and cash_flow_statements to analyse company fundamentals.

Use earning_calendar and economic_calendar to track upcoming events by date.

Join historical_dividends_calendar and historical_stock_split to follow dividends and splits.

Use institutional_holders and mutual_fund_holder to see who holds each stock and how positions change.

Once Finage data lands in your Kaivo-managed BigQuery warehouse, you can explore it with AI tools or any BI tool that connects to BigQuery. Here’s how the most common destinations work with Finage data.

Use Kaivo’s MCP server to give Claude secure, workspace-scoped access to your data. Setup guide →

Microsoft’s BI tool with a native BigQuery connector. Supports direct query and scheduled refresh. Setup guide →

Free Google BI tool with native BigQuery support. One-click connection to your Kaivo warehouse; great for SMB teams on Google Workspace. Setup guide →

The premium analytics standard, with native BigQuery integration. Setup guide →

Use Connected Sheets to query BigQuery directly from a spreadsheet, with no SQL. Setup guide →

Connect via Power Query’s BigQuery connector. Setup guide →

Open-source BI tool with strong BigQuery support. Setup guide →

See our pricing page for Finage connector pricing and plan details.