-
Notifications
You must be signed in to change notification settings - Fork 0
/
Copy pathstock_table_demo_one.sql
63 lines (63 loc) · 4.71 KB
/
stock_table_demo_one.sql
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
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
CREATE TABLE FirstLook.StockTableDemoOne (ClientID INTEGER, BrokerID INTEGER,
Symbol VARCHAR(10), TransactionType VARCHAR(4), TransactionDate TIMESTAMP, Quantity INTEGER, Price DECIMAL(15,2), CommmissionRate DECIMAL(15,2))
GO
INSERT INTO FirstLook.StockTableDemoOne (ClientID, BrokerID, Symbol, TransactionType, TransactionDate, Quantity, Price, CommmissionRate)
VALUES (29834783, 3103, 'RTYU', 'SELL', '2016-01-03 13:59:01.098', 342, 5.05, 3.25)
GO
INSERT INTO FirstLook.StockTableDemoOne (ClientID, BrokerID, Symbol, TransactionType, TransactionDate, Quantity, Price, CommmissionRate)
VALUES (59203943, 5001, 'ASUB', 'BUY', '2017-12-13 05:42:07.062', 56, 15.62, 4.25)
GO
INSERT INTO FirstLook.StockTableDemoOne (ClientID, BrokerID, Symbol, TransactionType, TransactionDate, Quantity, Price, CommmissionRate)
VALUES (29834783, 3103, 'FGQT', 'BUY', '2016-01-14 12:02:23.109', 500, 32.41, 3.25)
GO
INSERT INTO FirstLook.StockTableDemoOne (ClientID, BrokerID, Symbol, TransactionType, TransactionDate, Quantity, Price, CommmissionRate)
VALUES (10993023, 1009, 'YTR', 'SELL', '2016-01-15 18:18:15.346', 50, 33.87, 5.25)
GO
INSERT INTO FirstLook.StockTableDemoOne (ClientID, BrokerID, Symbol, TransactionType, TransactionDate, Quantity, Price, CommmissionRate)
VALUES (40149304, 5001, 'YQER', 'SELL', '2015-11-13 22:13:49.457', 120, 109.28, 4.25)
GO
INSERT INTO FirstLook.StockTableDemoOne (ClientID, BrokerID, Symbol, TransactionType, TransactionDate, Quantity, Price, CommmissionRate)
VALUES (37482093, 1009, 'TIOE', 'BUY', '2018-03-01 13:59:01.098', 500, 56.23, 5.25)
GO
INSERT INTO FirstLook.StockTableDemoOne (ClientID, BrokerID, Symbol, TransactionType, TransactionDate, Quantity, Price, CommmissionRate)
VALUES (92609349, 3103, 'HWVT', 'BUY', '2017-10-25 01:28:51.198', 1500, 451.09, 3.25)
GO
INSERT INTO FirstLook.StockTableDemoOne (ClientID, BrokerID, Symbol, TransactionType, TransactionDate, Quantity, Price, CommmissionRate)
VALUES (40149304, 5001, 'YQER', 'SELL', '2015-10-13 05:50:23.209', 120, 105.30, 4.25)
GO
INSERT INTO FirstLook.StockTableDemoOne (ClientID, BrokerID, Symbol, TransactionType, TransactionDate, Quantity, Price, CommmissionRate)
VALUES (29834783, 3103, 'HJQU', 'BUY', '2017-07-23 23:02:20.510', 650, 110.41, 3.25)
GO
INSERT INTO FirstLook.StockTableDemoOne (ClientID, BrokerID, Symbol, TransactionType, TransactionDate, Quantity, Price, CommmissionRate)
VALUES (85102938, 5001, 'WTI', 'SELL', '2017-07-31 23:05:49.830', 350, 66.23, 4.25)
GO
INSERT INTO FirstLook.StockTableDemoOne (ClientID, BrokerID, Symbol, TransactionType, TransactionDate, Quantity, Price, CommmissionRate)
VALUES (673845918, 1009, 'AJUI', 'BUY', '2017-05-10 22:57:17.612', 10000, 75.04, 5.25)
GO
INSERT INTO FirstLook.StockTableDemoOne (ClientID, BrokerID, Symbol, TransactionType, TransactionDate, Quantity, Price, CommmissionRate)
VALUES (810293023, 5001, 'ITBUY', 'BUY', '2016-11-06 09:04:51.275', 2000, 110.34, 4.25)
GO
INSERT INTO FirstLook.StockTableDemoOne (ClientID, BrokerID, Symbol, TransactionType, TransactionDate, Quantity, Price, CommmissionRate)
VALUES (73821029, 3103, 'MJTU', 'SELL', '2016-10-31 19:21:08.913', 750, 60.02, 3.25)
GO
INSERT INTO FirstLook.StockTableDemoOne (ClientID, BrokerID, Symbol, TransactionType, TransactionDate, Quantity, Price, CommmissionRate)
VALUES (810293023, 5001, 'ITUY', 'SELL', '2017-11-06 09:51:24.735', 2000, 151.39, 4.25)
GO
INSERT INTO FirstLook.StockTableDemoOne (ClientID, BrokerID, Symbol, TransactionType, TransactionDate, Quantity, Price, CommmissionRate)
VALUES (37482093, 1009, 'JKIO', 'BUY', '2018-04-01 01:28:44.121', 500, 20.57, 5.25)
GO
INSERT INTO FirstLook.StockTableDemoOne (ClientID, BrokerID, Symbol, TransactionType, TransactionDate, Quantity, Price, CommmissionRate)
VALUES (68101935, 1009, 'YTR', 'BUY', '2016-01-17 03:36:40.111', 500, 35.92, 5.25)
GO
INSERT INTO FirstLook.StockTableDemoOne (ClientID, BrokerID, Symbol, TransactionType, TransactionDate, Quantity, Price, CommmissionRate)
VALUES (87029367, 5001, 'HIO', 'BUY', '2017-12-13 21:08:42.030', 200, 99.89, 4.25)
GO
INSERT INTO FirstLook.StockTableDemoOne (ClientID, BrokerID, Symbol, TransactionType, TransactionDate, Quantity, Price, CommmissionRate)
VALUES (57293842, 5002, 'HIO', 'BUY', '2017-12-15 01:25:37.310', 1000, 95.21, 5.5)
GO
INSERT INTO FirstLook.StockTableDemoOne (ClientID, BrokerID, Symbol, TransactionType, TransactionDate, Quantity, Price, CommmissionRate)
VALUES (31306978, 3103, 'QURP', 'SELL', '2017-09-24 19:36:43.079', 700, 82.35, 3.25)
GO
INSERT INTO FirstLook.StockTableDemoOne (ClientID, BrokerID, Symbol, TransactionType, TransactionDate, Quantity, Price, CommmissionRate)
VALUES (57293842, 5002, 'HIO', 'SELL', '2018-01-15 22:21:17.638', 1000, 92.35, 5.5)
GO