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
|
LOAD ARCHIVE
FROM http://bossa.pl/pub/metastock/mstock/mstall.zip
-- FROM /Users/dim/dev/temp/mstall.zip
INTO postgresql:///stocks
LOAD CSV
FROM ALL FILENAMES MATCHING ~/ALIOR/
WITH ENCODING iso-8859-2
(ticker, quote_date, open, high, low, close, volume)
INTO postgresql:///stocks?intf_stocks
WITH
SKIP HEADER=1,
FIELDS OPTIONALLY ENCLOSED BY '"',
FIELDS TERMINATED BY ','
AND LOAD CSV
FROM ALL FILENAMES MATCHING ~/F[A-Z]{4}1[456]|OW20/
WITH ENCODING iso-8859-2
(ticker, quote_date, open, high, low, close, volume, openint)
INTO postgresql:///stocks?intf_derivatives
WITH
SKIP HEADER = 1,
FIELDS OPTIONALLY ENCLOSED BY '"',
FIELDS TERMINATED BY ','
;
|
