Skip to content

capital_markets

sqllocks_spindle.domains.capital_markets

Capital Markets domain — US equities, pricing, corporate actions.

Classes

CapitalMarketsDomain

Bases: Domain

Capital Markets domain — US equities, pricing, corporate actions.

Available schema modes
  • 3nf: Normalized schema with proper 3NF relationships

Tables (3NF mode): - company: Public company reference data (real S&P 500 tickers) - exchange: Stock exchanges (NYSE, NASDAQ, AMEX) - sector: GICS sectors (11) - industry: GICS industries (61) with sector FK - daily_price: OHLCV daily bars via Geometric Brownian Motion - dividend: Dividend payments - split: Stock splits - earnings: Quarterly earnings with EPS surprise - insider_transaction: Insider trades (SEC Form 4) - trade: Tick-level trades (for streaming / RTI)

DISCLAIMER: All generated data is synthetic. Price data does not represent actual market performance. Not suitable for investment decisions.

Methods:
star_schema_map()

Return star schema mapping for the Capital Markets domain.

Produces
  • dim_company (from company)
  • dim_exchange (from exchange)
  • dim_sector (from sector, enriched with industry)
  • dim_date (generated from trade_date / report_date / ex_date)
  • fact_daily_price (from daily_price)
  • fact_dividend (from dividend)
  • fact_earnings (from earnings)
  • fact_insider_txn (from insider_transaction)
cdm_map()

Return the CDM entity map for the Capital Markets domain.