FilesExpand file tree

 master

/

schema.sql

Copy path

Blame

More file actions

Blame

More file actions

Latest commit

 

History

History

History

11 lines (11 loc) · 307 Bytes

 master

/

schema.sql

Copy path

Top

File metadata and controls

• Code
• Blame

11 lines (11 loc) · 307 Bytes

Raw

Copy raw file

Download raw file

Open symbols panel

Edit and raw actions

1

2

3

4

5

6

7

8

9

10

11

CREATE TABLE IF NOT EXISTS financial_data

(

t_date date,

symbol character varying(15),

open_price real NOT NULL,

close_price real NOT NULL,

high_price real NOT NULL,

low_price real NOT NULL,

volume bigint NOT NULL,

CONSTRAINT financial_data_key PRIMARY KEY (t_date, symbol)

)