-- Explore your data SELECT ticker, date, close, volume, momentum_12_1, sentiment_score FROM feature_store.security_master WHERE sector = 'Technology' AND market_cap > 10e9 ORDER BY momentum_12_1 DESC LIMIT 25
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