Wildcat

Wildcat is a view-only crude oil markets analytics dashboard built for free-tier deployment on Vercel, Turso, and GitHub Actions. It has no order entry, alerting, or proprietary data distribution.

Architecture

• Frontend: static HTML, CSS, and vanilla ES modules with Chart.js v4 from CDN.
• API: Vercel Node.js serverless functions under api/.
• Database: Turso/libSQL over the HTTP pipeline API via lib/turso.js.
• ETL: Python scripts in etl/, scheduled through GitHub Actions for heavier jobs.
• Cron: Vercel cron handlers for light EIA/FRED polling in api/_cron/.

Local Preview

The frontend can be served without a build step:

python3 -m http.server 4173 -d public

Without Turso secrets and live ETL data, the UI falls back to deterministic demo data so layout and charts remain inspectable.

Required Secrets

Set these in both Vercel and GitHub Actions where applicable:

• TURSO_DATABASE_URL
• TURSO_AUTH_TOKEN
• EIA_API_KEY
• FRED_API_KEY

Initialize Turso with:

turso db shell <database> < etl/schema.sql

Data Sources

• EIA, FRED, and CFTC data are public US government data.
• Yahoo Finance data accessed through yfinance is intended for personal use only and is not redistributed by this repository.
• CME settlement CSVs are used for informational futures-curve snapshots.
• Intraday prices are delayed and should not be treated as executable quotes.

Route Surface

• GET /api/prices
• GET /api/curve
• GET /api/inventory
• GET /api/cot
• GET /api/steo
• GET /api/risk-premium
• GET /api/health

License

MIT for repository code. Third-party market data remains governed by each source's terms.