stock-streaming-data-pipeline
Tables (10)
balance_sheets
- id — SERIAL
- symbol — VARCHAR(10)
- fiscal_date_ending — DATE — NOT NULL
- reported_currency — VARCHAR(10)
- total_assets — BIGINT
- total_current_assets — BIGINT
- cash_and_cash_equivalents_at_carrying_value — BIGINT
- cash_and_short_term_investments — BIGINT
- inventory — BIGINT
- current_net_receivables — BIGINT
- total_non_current_assets — BIGINT
- property_plant_equipment — BIGINT
- accumulated_depreciation_amortization_ppe — BIGINT
- intangible_assets — BIGINT
- intangible_assets_excluding_goodwill — BIGINT
- goodwill — BIGINT
- investments — BIGINT
- long_term_investments — BIGINT
- short_term_investments — BIGINT
- other_current_assets — BIGINT
- other_non_current_assets — BIGINT
- total_liabilities — BIGINT
- total_current_liabilities — BIGINT
- current_accounts_payable — BIGINT
- deferred_revenue — BIGINT
- current_debt — BIGINT
- short_term_debt — BIGINT
- total_non_current_liabilities — BIGINT
- capital_lease_obligations — BIGINT
- long_term_debt — BIGINT
- current_long_term_debt — BIGINT
- long_term_debt_noncurrent — BIGINT
- short_long_term_debt_total — BIGINT
- other_current_liabilities — BIGINT
- other_non_current_liabilities — BIGINT
- total_shareholder_equity — BIGINT
- treasury_stock — BIGINT
- retained_earnings — BIGINT
- common_stock — BIGINT
- common_stock_shares_outstanding — BIGINT
- is_quarterly — BOOLEAN — NOT NULL
- last_updated — TIMESTAMP
- UNIQUE(symbol, — fiscal_date_ending,
cash_flows
- id — SERIAL
- symbol — VARCHAR(10)
- fiscal_date_ending — DATE — NOT NULL
- reported_currency — VARCHAR(10)
- operating_cashflow — BIGINT
- payments_for_operating_activities — BIGINT
- proceeds_from_operating_activities — BIGINT
- change_in_operating_liabilities — BIGINT
- change_in_operating_assets — BIGINT
- depreciation_depletion_and_amortization — BIGINT
- capital_expenditures — BIGINT
- change_in_receivables — BIGINT
- change_in_inventory — BIGINT
- profit_loss — BIGINT
- cashflow_from_investment — BIGINT
- cashflow_from_financing — BIGINT
- proceeds_from_repayments_of_short_term_debt — BIGINT
- payments_for_repurchase_of_common_stock — BIGINT
- payments_for_repurchase_of_equity — BIGINT
- payments_for_repurchase_of_preferred_stock — BIGINT
- dividend_payout — BIGINT
- dividend_payout_common_stock — BIGINT
- dividend_payout_preferred_stock — BIGINT
- proceeds_from_issuance_of_common_stock — BIGINT
- proceeds_from_issuance_of_long_term_debt_and_capital_securities — BIGINT
- proceeds_from_issuance_of_preferred_stock — BIGINT
- proceeds_from_repurchase_of_equity — BIGINT
- proceeds_from_sale_of_treasury_stock — BIGINT
- change_in_cash_and_cash_equivalents — BIGINT
- change_in_exchange_rate — BIGINT
- net_income — BIGINT
- is_quarterly — BOOLEAN — NOT NULL
- last_updated — TIMESTAMP
- UNIQUE(symbol, — fiscal_date_ending,
company_overview
- symbol — VARCHAR(10)
- description — TEXT
- currency — VARCHAR(10)
- country — VARCHAR(50)
- sector — VARCHAR(100)
- industry — VARCHAR(100)
- address — TEXT
- fiscal_year_end — VARCHAR(10)
- latest_quarter — DATE
- market_capitalization — BIGINT
- ebitda — BIGINT
- pe_ratio — DECIMAL(12, 4)
- peg_ratio — DECIMAL(12, 4)
- book_value — DECIMAL(12, 4)
- dividend_per_share — DECIMAL(12, 4)
- dividend_yield — DECIMAL(12, 4)
- eps — DECIMAL(12, 4)
- revenue_per_share_ttm — DECIMAL(12, 4)
- profit_margin — DECIMAL(12, 4)
- operating_margin_ttm — DECIMAL(12, 4)
- return_on_assets_ttm — DECIMAL(12, 4)
- return_on_equity_ttm — DECIMAL(12, 4)
- revenue_ttm — BIGINT
- gross_profit_ttm — BIGINT
- diluted_eps_ttm — DECIMAL(12, 4)
- quarterly_earnings_growth_yoy — DECIMAL(12, 4)
- quarterly_revenue_growth_yoy — DECIMAL(12, 4)
- analyst_target_price — DECIMAL(12, 4)
- trailing_pe — DECIMAL(12, 4)
- forward_pe — DECIMAL(12, 4)
- price_to_sales_ratio_ttm — DECIMAL(12, 4)
- price_to_book_ratio — DECIMAL(12, 4)
- ev_to_revenue — DECIMAL(12, 4)
- ev_to_ebitda — DECIMAL(12, 4)
- beta — DECIMAL(12, 4)
- fifty_two_week_high — DECIMAL(12, 4)
- fifty_two_week_low — DECIMAL(12, 4)
- fifty_day_moving_average — DECIMAL(12, 4)
- two_hundred_day_moving_average — DECIMAL(12, 4)
- shares_outstanding — BIGINT
- shares_float — BIGINT
- shares_short — BIGINT
- shares_short_prior_month — BIGINT
- short_ratio — DECIMAL(12, 4)
- short_percent_outstanding — DECIMAL(12, 4)
- short_percent_float — DECIMAL(12, 4)
- percent_insiders — DECIMAL(12, 4)
- percent_institutions — DECIMAL(12, 4)
- forward_annual_dividend_rate — DECIMAL(12, 4)
- forward_annual_dividend_yield — DECIMAL(12, 4)
- payout_ratio — DECIMAL(12, 4)
- dividend_date — DATE
- ex_dividend_date — DATE
- last_split_factor — VARCHAR(20)
- last_split_date — DATE
- last_updated — TIMESTAMP
daily_prices
- id — SERIAL
- symbol — VARCHAR(10)
- date — DATE — NOT NULL
- open — DECIMAL(18, 4) — NOT NULL
- high — DECIMAL(18, 4) — NOT NULL
- low — DECIMAL(18, 4) — NOT NULL
- close — DECIMAL(18, 4) — NOT NULL
- volume — BIGINT — NOT NULL
- adjusted_close — DECIMAL(18, 4)
- dividend_amount — DECIMAL(18, 4)
- split_coefficient — DECIMAL(10, 4)
- UNIQUE(symbol, — date)
income_statements
- id — SERIAL
- symbol — VARCHAR(10)
- fiscal_date_ending — DATE — NOT NULL
- reported_currency — VARCHAR(10)
- gross_profit — BIGINT
- total_revenue — BIGINT
- cost_of_revenue — BIGINT
- cost_of_goods_and_services_sold — BIGINT
- operating_income — BIGINT
- selling_general_and_administrative — BIGINT
- research_and_development — BIGINT
- operating_expenses — BIGINT
- investment_income_net — BIGINT
- net_interest_income — BIGINT
- interest_income — BIGINT
- interest_expense — BIGINT
- non_interest_income — BIGINT
- other_non_operating_income — BIGINT
- depreciation — BIGINT
- depreciation_and_amortization — BIGINT
- income_before_tax — BIGINT
- income_tax_expense — BIGINT
- interest_and_debt_expense — BIGINT
- net_income_from_continuing_operations — BIGINT
- comprehensive_income_net_of_tax — BIGINT
- ebit — BIGINT
- ebitda — BIGINT
- net_income — BIGINT
- is_quarterly — BOOLEAN — NOT NULL
- last_updated — TIMESTAMP
- UNIQUE(symbol, — fiscal_date_ending,
market_indices
- id — SERIAL
- symbol — VARCHAR(10) — NOT NULL
- name — VARCHAR(100) — NOT NULL
- date — DATE — NOT NULL
- open — DECIMAL(18, 4) — NOT NULL
- high — DECIMAL(18, 4) — NOT NULL
- low — DECIMAL(18, 4) — NOT NULL
- close — DECIMAL(18, 4) — NOT NULL
- volume — BIGINT — NOT NULL
- last_updated — TIMESTAMP
- UNIQUE(symbol, — date)
news_articles
- id — SERIAL
- title — VARCHAR(255) — NOT NULL
- url — VARCHAR(500) — NOT NULL
- time_published — TIMESTAMP — NOT NULL
- authors — TEXT
- summary — TEXT
- source — VARCHAR(100)
- category_within_source — VARCHAR(100)
- source_domain — VARCHAR(100)
- overall_sentiment_score — DECIMAL(5, 4)
- overall_sentiment_label — VARCHAR(20)
- last_updated — TIMESTAMP
news_stocks
- id — SERIAL
- news_id — INTEGER
- symbol — VARCHAR(10)
- relevance_score — DECIMAL(5, 4)
- sentiment_score — DECIMAL(5, 4)
- sentiment_label — VARCHAR(20)
- UNIQUE(news_id, — symbol)
stock_recommendations
- id — SERIAL
- symbol — VARCHAR(10)
- recommendation_score — INTEGER — NOT NULL
- recommendation_label — VARCHAR(20) — NOT NULL
- reasoning — TEXT
- created_at — TIMESTAMP
- news_based — BOOLEAN
- technical_based — BOOLEAN
- fundamental_based — BOOLEAN
- last_updated — TIMESTAMP
stocks
- symbol — VARCHAR(10)
- name — VARCHAR(100) — NOT NULL
- exchange — VARCHAR(20) — NOT NULL
- asset_type — VARCHAR(20) — NOT NULL
- ipo_date — DATE
- delisting_date — DATE
- status — VARCHAR(20) — NOT NULL
- sector — VARCHAR(100)
- industry — VARCHAR(100)
- last_updated — TIMESTAMP