-
Notifications
You must be signed in to change notification settings - Fork 0
Expand file tree
/
Copy pathfill.sql
More file actions
35 lines (35 loc) · 2.97 KB
/
fill.sql
File metadata and controls
35 lines (35 loc) · 2.97 KB
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
copy finstocks from '/home/finproject/NYSE/NYSE_daily_prices_1.csv' delimiter ',' CSV;
copy finstocks from '/home/finproject/NYSE/NYSE_daily_prices_2.csv' delimiter ',' CSV;
copy finstocks from '/home/finproject/NYSE/NYSE_daily_prices_3.csv' delimiter ',' CSV;
copy finstocks from '/home/finproject/NYSE/NYSE_daily_prices_4.csv' delimiter ',' CSV;
copy finstocks from '/home/finproject/NYSE/NYSE_daily_prices_5.csv' delimiter ',' CSV;
copy finstocks from '/home/finproject/NYSE/NYSE_daily_prices_6.csv' delimiter ',' CSV;
copy finstocks from '/home/finproject/NYSE/NYSE_daily_prices_7.csv' delimiter ',' CSV;
copy finstocks from '/home/finproject/NYSE/NYSE_daily_prices_8.csv' delimiter ',' CSV;
copy finstocks from '/home/finproject/NYSE/NYSE_daily_prices_9.csv' delimiter ',' CSV;
copy finstocks from '/home/finproject/NYSE/NYSE_daily_prices_A.csv' delimiter ',' CSV;
copy finstocks from '/home/finproject/NYSE/NYSE_daily_prices_B.csv' delimiter ',' CSV;
copy finstocks from '/home/finproject/NYSE/NYSE_daily_prices_C.csv' delimiter ',' CSV;
copy finstocks from '/home/finproject/NYSE/NYSE_daily_prices_D.csv' delimiter ',' CSV;
copy finstocks from '/home/finproject/NYSE/NYSE_daily_prices_E.csv' delimiter ',' CSV;
copy finstocks from '/home/finproject/NYSE/NYSE_daily_prices_F.csv' delimiter ',' CSV;
copy finstocks from '/home/finproject/NYSE/NYSE_daily_prices_G.csv' delimiter ',' CSV;
copy finstocks from '/home/finproject/NYSE/NYSE_daily_prices_H.csv' delimiter ',' CSV;
copy finstocks from '/home/finproject/NYSE/NYSE_daily_prices_I.csv' delimiter ',' CSV;
copy finstocks from '/home/finproject/NYSE/NYSE_daily_prices_J.csv' delimiter ',' CSV;
copy finstocks from '/home/finproject/NYSE/NYSE_daily_prices_K.csv' delimiter ',' CSV;
copy finstocks from '/home/finproject/NYSE/NYSE_daily_prices_L.csv' delimiter ',' CSV;
copy finstocks from '/home/finproject/NYSE/NYSE_daily_prices_M.csv' delimiter ',' CSV;
copy finstocks from '/home/finproject/NYSE/NYSE_daily_prices_N.csv' delimiter ',' CSV;
copy finstocks from '/home/finproject/NYSE/NYSE_daily_prices_O.csv' delimiter ',' CSV;
copy finstocks from '/home/finproject/NYSE/NYSE_daily_prices_P.csv' delimiter ',' CSV;
copy finstocks from '/home/finproject/NYSE/NYSE_daily_prices_Q.csv' delimiter ',' CSV;
copy finstocks from '/home/finproject/NYSE/NYSE_daily_prices_R.csv' delimiter ',' CSV;
copy finstocks from '/home/finproject/NYSE/NYSE_daily_prices_S.csv' delimiter ',' CSV;
copy finstocks from '/home/finproject/NYSE/NYSE_daily_prices_T.csv' delimiter ',' CSV;
copy finstocks from '/home/finproject/NYSE/NYSE_daily_prices_U.csv' delimiter ',' CSV;
copy finstocks from '/home/finproject/NYSE/NYSE_daily_prices_V.csv' delimiter ',' CSV;
copy finstocks from '/home/finproject/NYSE/NYSE_daily_prices_W.csv' delimiter ',' CSV;
copy finstocks from '/home/finproject/NYSE/NYSE_daily_prices_X.csv' delimiter ',' CSV;
copy finstocks from '/home/finproject/NYSE/NYSE_daily_prices_Y.csv' delimiter ',' CSV;
copy finstocks from '/home/finproject/NYSE/NYSE_daily_prices_Z.csv' delimiter ',' CSV;