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
| CREATE TABLE T
(
EuroStoxxBase1Opening float,
EuroStoxxBase1Maximum float,
EuroStoxxBase1Minimum float,
EuroStoxxBase1ClosingDifference float,
EuroStoxxBase1ClosingDifferenceTradeDate smalldatetime,
EuroSoxxBase1Closing1min2min float
);
INSERT INTO T VALUES (2438, 2438, 2426, 2450, '19/12/2008 7:00', NULL);
INSERT INTO T VALUES (2439, 2427, 2425, 2452, '19/12/2008 7:01', 0);
INSERT INTO T VALUES (2440, 2430, 2425, 2454, '19/12/2008 7:02', 0);
INSERT INTO T VALUES (2441, 2427, 2424, 2456, '19/12/2008 7:03', -0.5);
INSERT INTO T VALUES (2442, 2428, 2424, 2458, '19/12/2008 7:04', 0);
INSERT INTO T VALUES (2443, 2429, 2425, 2460, '19/12/2008 7:05', 1.5);
INSERT INTO T VALUES (2444, 2431, 2426, 2462, '19/12/2008 7:06', 0);
INSERT INTO T VALUES (2445, 2429, 2425, 2464, '19/12/2008 7:07', -1);
INSERT INTO T VALUES (2446, 2428, 2426, 2466, '19/12/2008 7:08', 1);
INSERT INTO T VALUES (2447, 2431, 2421, 2468, '19/12/2008 7:09', 1);
INSERT INTO T VALUES (2448, 2434, 2416, 2470, '19/12/2008 7:10', 0);
INSERT INTO T VALUES (2449, 2437, 2411, 2472, '19/12/2008 7:11', -1);
INSERT INTO T VALUES (2450, 2440, 2404, 2474, '19/12/2008 7:12', -3);
INSERT INTO T VALUES (2451, 2443, 2397, 2476, '19/12/2008 7:13', -4);
INSERT INTO T VALUES (2452, 2446, 2390, 2478, '19/12/2008 7:14', -2);
INSERT INTO T VALUES (2453, 2449, 2383, 2480, '20/12/2008 7:15', 0);
INSERT INTO T VALUES (2454, 2452, 2376, 2482, '21/12/2008 7:16', 1);
INSERT INTO T VALUES (2455, 2455, 2369, 2484, '22/12/2008 7:17', 5); |
Partager