JCI× Snowflake

Johnson Controls International plc Quant Signals in Snowflake

Query Johnson Controls International plc quant signals — regime detection, GARCH volatility, anomaly scores, and composite WhyStock score — natively in Snowflake. Bitemporal Apache Iceberg tables updated every night.

Get API Access

Ticker

JCI

Coverage

2020–present

Update freq

Nightly

Signal types

5

Snowflake query example

CREATE OR REPLACE ICEBERG TABLE JCI_signals
  EXTERNAL_VOLUME = 'vectorfin_gcs'
  CATALOG = 'vectorfin_polaris'
  CATALOG_TABLE_NAME = 'signals.whystock_score';

SELECT ticker, date, score, regime, anomaly_score
FROM   JCI_signals
WHERE  ticker = 'JCI'
ORDER  BY date DESC
LIMIT  30;

← All JCI signals Snowflake integration docs →

Access JCI signals in Snowflake

Sign up for a free API key. Pro plan unlocks Iceberg delivery to Snowflake, BigQuery, and Databricks.

Get API Access View Pricing