Twelve Data
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.
Connect Twelve Data to PostHog to sync your data into the PostHog data warehouse for analysis and modeling.
Import market data from Twelve Data: instrument catalogs, historical prices, quotes, dividends, splits, and earnings.
Configuration
| Option | Description |
|---|---|
API keyType: password Required: True | |
SymbolsType: text Required: True | Comma-separated list of up to 100 symbols to sync in the time series, quotes, dividends, splits, and earnings tables. Each Twelve Data request is charged per symbol, so a longer list uses more of your plan's API credits. |
Time series intervalType: select Required: True | |
Time series start dateType: text Required: False | Backfill time series history from this date. Leave empty to sync only the most recent 5,000 bars per symbol. |
Linking Twelve Data to PostHog
- Go to the Data pipeline page in PostHog
- Click New source and select Twelve Data
- Fill in the required configuration fields
- Click Next, select the tables you want to sync, and then press Import
Supported tables
| Table | Description | Sync method | Incremental field | Primary key |
|---|---|---|---|---|
stocks | Catalog of every stock listing Twelve Data covers, one row per symbol per exchange listing. | Full refresh | — | — |
etfs | Catalog of every ETF Twelve Data covers, one row per symbol per exchange listing. | Full refresh | — | — |
indices | Catalog of market indices Twelve Data covers. | Full refresh | — | — |
forex_pairs | Catalog of foreign exchange currency pairs available at Twelve Data. | Full refresh | — | — |
cryptocurrencies | Catalog of cryptocurrency pairs available at Twelve Data. | Full refresh | — | — |
exchanges | Catalog of stock exchanges available at Twelve Data. | Full refresh | — | — |
time_series | Historical OHLCV bars for each configured symbol at the configured interval. | Incremental, Full refresh | datetime | — |
quotes | Latest quote snapshot for each configured symbol at sync time. | Full refresh | — | — |
dividends | Full dividend payout history for each configured symbol. | Full refresh | — | — |
splits | Full stock split history for each configured symbol. | Full refresh | — | — |
earnings | Earnings report history for each configured symbol, with EPS estimates and actuals. | Full refresh | — | — |