test
Tables (4)
index_prices
- id — serial4 — Primary key — NOT NULL
- index_id — int4
- open — numeric(18, 6) — NOT NULL
- high — numeric(18, 6) — NOT NULL
- low — numeric(18, 6) — NOT NULL
- close — numeric(18, 6) — NOT NULL
- recorded_at — timestamptz
indices
- id — serial4 — Primary key — NOT NULL
- name — varchar(255) — NOT NULL
- symbol — varchar(50) — NOT NULL
- country — varchar(100)
- currency — varchar(10) — NOT NULL
- created_at — timestamptz
stock_prices
- id — serial4 — Primary key — NOT NULL
- stock_id — int4
- open — numeric(18, 6) — NOT NULL
- high — numeric(18, 6) — NOT NULL
- low — numeric(18, 6) — NOT NULL
- close — numeric(18, 6) — NOT NULL
- volume — int8
- recorded_at — timestamptz
stocks
- id — serial4 — Primary key — NOT NULL
- symbol — varchar(50) — NOT NULL
- name — varchar(255) — NOT NULL
- exchange_id — int4
- sector — varchar(100)
- currency — varchar(10) — NOT NULL
- created_at — timestamptz