AI Analyst for Stock Market Data with BigQuery & Claude
Build a local AI analyst for stock market and investment data using Bruin CLI, BigQuery, and Claude Code.
What
Goal - Build a local AI analyst for stock market data using Bruin CLI, BigQuery, and Claude Code.
Audience - Data professionals and financial analysts who want an AI-powered investment analysis workflow.
Prerequisites
- BigQuery project and dataset with data already loaded
- gcloud CLI installed
- Bruin CLI installed
- Claude Code installed and authenticated for
bruin ai enhance - Bruin MCP configured for Claude Code
More guides
Capstone: add returns to the pipeline
Extend the project, prove the result, and assess the finished pipeline.
Describe the model in its asset definition
Keep the metric definition, owners, limits, and checked examples next to the SQL.
Load and profile the source data
Load local commerce data and check its shape before modeling it.