# Linking Finnhub as a source - Docs

![](https://res.cloudinary.com/dmukukwp6/image/upload/texture_tan_9608fcca70)

![](https://res.cloudinary.com/dmukukwp6/image/upload/texture_tan_dark_a92b0e022d)

Let AI connect your sources for you

Skip the manual setup — run this in your project and the wizard auto-detects your databases and APIs and connects them to PostHog.

`npx @posthog/wizard warehouse`

[Learn more](/wizard.md)

![PostHog Wizard hedgehog](https://res.cloudinary.com/dmukukwp6/image/upload/wizard_3f8bb7a240.png)

**Alpha release**

This source is currently in **alpha**. The interface and available tables may change.

The Finnhub connector pulls market and company financial data into the PostHog Data warehouse, so you can analyze financial metrics alongside your product data.

## Prerequisites

You need a Finnhub account so you can create an API key. A free key works, though the free tier is rate limited to 60 requests per minute and some endpoints require a paid plan.

## Adding a data source

1.  In PostHog, go to the [Sources tab](https://app.posthog.com/data-management/sources) of the data pipeline section.
2.  Click **\+ New source** and click **Link** next to this source.
3.  Enter your credentials (see [Configuration](#configuration) below) and click **Next**.
4.  Select the tables you want to sync, choose a sync method and frequency, then click **Import**.

Once the syncs are complete, you can start querying this data in PostHog.

When linking Finnhub, you'll need:

-   **API key** – create a free API key in your [Finnhub dashboard](https://finnhub.io/dashboard).
-   **Symbols** – optional, comma-separated. Per-company tables (company profile, quote, company news, basic financials, recommendation trends, and earnings surprises) are synced for each ticker you list here, for example `AAPL, MSFT, GOOGL`. Market-wide tables sync without any symbols.
-   **Exchange** – optional. Used for the stock symbols table, for example `US`.

## Sync modes

Each table can be synced in one of several modes, depending on what the source supports:

-   **Webhook** (when available) – the source pushes changes to PostHog in real time. Fastest freshness, lowest ongoing cost, and the only mode that reliably captures updates and deletes.
-   **Incremental** – only new or updated rows are synced on each run, using a cursor field (such as an `updated_at` timestamp). Cheaper than a full refresh, but deletes aren't captured.
-   **Append only** – new rows are appended using a cursor field; existing rows are never updated. Ideal for immutable, append-only tables like event logs.
-   **Full refresh** – the whole table is reloaded on every sync. Use it when a table has no reliable cursor or when you need deletions reflected.

See [sync methods](/docs/cdp/sources.md#sync-methods) for a full explanation of how each mode works and how to choose between them.

## Configuration

| Option | Type | Required |
| --- | --- | --- |
| API key | password | Yes |
| Symbols (comma-separated) | text | No |
| Exchange (for the stock symbols table) | text | No |

## Supported tables

| Table | Description | Sync method | Incremental field | Primary key |
| --- | --- | --- | --- | --- |
| stock_symbols | All tradable symbols for the configured exchange (default US). Full refresh. | Full refresh | — | — |
| market_news | Latest general market news. Full refresh. | Full refresh | — | — |
| ipo_calendar | Recent and upcoming IPOs over a rolling window. Full refresh. | Full refresh | — | — |
| earnings_calendar | Recent and upcoming company earnings over a rolling window. Full refresh. | Full refresh | — | — |
| country | Reference list of supported countries and their metadata. Full refresh. | Full refresh | — | — |
| company_profile | Company profile for each configured symbol. Full refresh. | Full refresh | — | — |
| quote | Latest real-time quote snapshot for each configured symbol. Full refresh. | Full refresh | — | — |
| company_news | Company-specific news per configured symbol. Supports incremental sync on the published datetime. | Incremental, Full refresh | datetime | — |
| basic_financials | Basic financial metrics (valuation, margins, growth) per configured symbol. Full refresh. | Full refresh | — | — |
| recommendation_trends | Analyst recommendation trends per configured symbol. Full refresh. | Full refresh | — | — |
| earnings_surprises | Historical EPS estimate vs actual surprises per configured symbol. Full refresh. | Full refresh | — | — |

## Troubleshooting

-   If you see an authentication error, your API key may be invalid or revoked. Create a new key in your Finnhub dashboard, then reconnect.
-   If a table fails with a forbidden error, your plan may not include access to that data. Upgrade your plan or deselect the affected tables, then reconnect.

If your sync is failing or data looks wrong, see the [Data warehouse troubleshooting guide](/docs/data-warehouse/troubleshooting.md). If that doesn't help, [contact support](https://us.posthog.com/#panel=support%3Asupport%3Adata_warehouse%3A%3Atrue) – we're happy to help.

### Community questions

Ask a question

### Was this page useful?

HelpfulCould be better