CCI× Snowflake

Crown Castle Inc. Quant Signals in Snowflake

Query Crown Castle Inc. 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

CCI

Coverage

2020–present

Update freq

Nightly

Signal types

5

Snowflake query example

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

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

Access CCI signals in Snowflake

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