ETL1

Tables (9)

balance_sheet_raw

  • id — SERIAL
  • symbol — VARCHAR(10)
  • date — DATE
  • raw_json — JSONB
  • created_at — TIMESTAMP

cash_flow_raw

  • id — SERIAL
  • symbol — VARCHAR(10)
  • date — DATE
  • raw_json — JSONB
  • created_at — TIMESTAMP

company_profile_raw

  • id — SERIAL
  • symbol — VARCHAR(10)
  • raw_json — JSONB
  • created_at — TIMESTAMP

dividends_raw

  • id — SERIAL
  • symbol — VARCHAR(10)
  • date — DATE
  • dividend — NUMERIC
  • frequency — VARCHAR(10)
  • raw_json — JSONB
  • created_at — TIMESTAMP

financial_ratios_raw

  • id — SERIAL
  • symbol — VARCHAR(10)
  • date — DATE
  • raw_json — JSONB
  • created_at — TIMESTAMP

income_statement_raw

  • id — SERIAL
  • symbol — VARCHAR(10)
  • date — DATE
  • raw_json — JSONB
  • created_at — TIMESTAMP

key_metrics_raw

  • id — SERIAL
  • symbol — VARCHAR(10)
  • date — DATE
  • raw_json — JSONB
  • created_at — TIMESTAMP

market_cap_raw

  • id — SERIAL
  • symbol — VARCHAR(10)
  • date — DATE
  • market_cap — BIGINT
  • raw_json — JSONB
  • created_at — TIMESTAMP

stock_price_raw

  • id — SERIAL
  • symbol — VARCHAR(10)
  • date — DATE
  • raw_json — JSONB
  • created_at — TIMESTAMP