fmp

Tables (7)

daily_financial_metrics

  • id — SERIAL
  • symbol — VARCHAR(20)
  • metric_date — DATE
  • metric_type — VARCHAR(50)
  • metric_value — FLOAT
  • source — VARCHAR(50)
  • created_at — TIMESTAMP

daily_prices

  • id — SERIAL
  • symbol — VARCHAR(20)
  • price_date — DATE
  • closing_price — FLOAT
  • percent_change — FLOAT
  • net_change — FLOAT
  • market_cap — BIGINT
  • country — VARCHAR(10)
  • created_at — TIMESTAMP
  • updated_at — TIMESTAMP
  • UNIQUE(symbol, — price_date)

dividend_events

  • id — SERIAL
  • symbol — VARCHAR(20) — NOT NULL
  • country — VARCHAR(3) — NOT NULL
  • ex_dividend_date — DATE — NOT NULL
  • payment_date — DATE
  • dividend_amount — DECIMAL(10,4)
  • frequency — VARCHAR(20)
  • source — VARCHAR(50)
  • created_at — TIMESTAMP
  • updated_at — TIMESTAMP
  • UNIQUE(symbol, — country,

dividend_ttm_metrics

  • id — SERIAL
  • symbol — VARCHAR(20) — NOT NULL
  • country — VARCHAR(3) — NOT NULL
  • metric_date — DATE — NOT NULL
  • dividend_yield_ttm — DECIMAL(8,4)
  • payout_ratio_ttm — DECIMAL(8,4)
  • source — VARCHAR(50)
  • created_at — TIMESTAMP
  • updated_at — TIMESTAMP
  • UNIQUE(symbol, — country,

financial_metrics

  • id — SERIAL
  • symbol — VARCHAR(20)
  • fiscal_year — INT
  • fiscal_period — VARCHAR(10)
  • metric_type — VARCHAR(50)
  • metric_value — FLOAT
  • source — VARCHAR(50)
  • created_at — TIMESTAMP
  • UNIQUE(symbol, — fiscal_year,

outstanding_shares

  • id — SERIAL
  • symbol — VARCHAR(20)
  • record_date — TIMESTAMP
  • shares_outstanding — BIGINT
  • country — VARCHAR(10)
  • created_at — TIMESTAMP
  • UNIQUE(symbol, — record_date)

revenue_segments

  • id — SERIAL
  • symbol — VARCHAR(20)
  • date — DATE
  • fiscal_year — INT
  • fiscal_period — VARCHAR(10)
  • segment_name — VARCHAR(100)
  • segment_revenue — BIGINT
  • country — VARCHAR(10)
  • created_at — TIMESTAMP
  • UNIQUE(symbol, — date,