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,