SELECT ticker, date, close, volume
FROM market_data.ohlcv

SELECT s.ticker, s.sector, m.momentum_12_1, a.score AS sentiment
FROM feature_store.security_master s

SELECT ticker, fiscal_quarter, revenue, net_income,
  net_income / NULLIF(revenue, 0) AS margin

SELECT sector, AVG(ret_1d) as avg_ret, COUNT(*) as n
FROM feature_store.momentum m

SELECT ticker, eps_actual - eps_estimate AS surprise,
  (eps_actual - eps_estimate) / ABS(eps_estimate) AS surprise_pct

SELECT source, last_update, is_stale, row_count
FROM monitoring.staleness_check

WITH ranked AS (
  SELECT ticker, date, ret_21d,

SELECT t.ticker, t.quarter, t.word_count, s.score
FROM alt_data.transcripts_raw t

INSERT INTO custom.my_watchlist (ticker, added_date, notes)
VALUES ('NVDA', CURRENT_DATE, 'AI capex cycle')

SELECT ticker, form_type, filing_date
FROM alt_data.sec_filings_clean