quotes.sql

wwwquote super programming.

/* Database: Stocks */

/****** Object:  Table dbo.Issues ******/
if exists (select * from sysobjects where id = object_id('Issues') and sysstat & 0xf = 3)
	drop table Issues
GO

CREATE TABLE Issues
(
	CUSIP varchar (8) NULL ,
	Ticker varchar (7) NULL ,
	Name varchar (50) NULL
)
GO

INSERT INTO Issues (CUSIP, Ticker, Name)
VALUES ("09984310", "BORL", "BORLAND INTL INC/COM")
GO
INSERT INTO Issues (CUSIP, Ticker, Name)
VALUES ("59491810", "MSFT", "MICROSOFT CORP/COM")
GO
INSERT INTO Issues (CUSIP, Ticker, Name)
VALUES ("54570010", "LOTS", "LOTUS DEV CORP/COM")
GO
INSERT INTO Issues (CUSIP, Ticker, Name)
VALUES ("67000610", "NOVL", "NOVELL INC/COM")
GO


/****** Object:  Table dbo.Quotes ******/
if exists (select * from sysobjects where id = object_id('Quotes') and sysstat & 0xf = 3)
	drop table Quotes
GO								    

CREATE TABLE Quotes
(
	Ticker varchar (50) NULL ,
	Date datetime NULL ,
	Volume int NULL ,
	HighAsk varchar (50) NULL ,
	LowBid varchar (50) NULL ,
	CloseAvg varchar (50) NULL
)
GO

INSERT INTO Quotes (Ticker, Date, Volume, HighAsk, LowBid, CloseAvg)
VALUES ("BORL", "19941201  0:00",  1115500, "9 5/8", "8 5/8", "8 5/8")
GO
INSERT INTO Quotes (Ticker, Date, Volume, HighAsk, LowBid, CloseAvg)
VALUES ("BORL", "19941202  0:00", 1062600, "8 7/8", "8 1/4", "8 5/8")
GO
INSERT INTO Quotes (Ticker, Date, Volume, HighAsk, LowBid, CloseAvg)
VALUES ("BORL", "19941205  0:00", 298200, "8 5/8", "8 3/8", "8 7/16")
GO
INSERT INTO Quotes (Ticker, Date, Volume, HighAsk, LowBid, CloseAvg)
VALUES ("BORL", "19941206  0:00", 355600, "8 1/2", "8 1/4", "8 1/2")
GO
INSERT INTO Quotes (Ticker, Date, Volume, HighAsk, LowBid, CloseAvg)
VALUES ("BORL", "19941207  0:00", 150300, "8 1/2", "8 1/4", "8 1/2")
GO
INSERT INTO Quotes (Ticker, Date, Volume, HighAsk, LowBid, CloseAvg)
VALUES ("BORL", "19941208  0:00", 239100, "8 1/2", "8 1/4", "8 1/4")
GO
INSERT INTO Quotes (Ticker, Date, Volume, HighAsk, LowBid, CloseAvg)
VALUES ("BORL", "19941209  0:00", 584600, "9", "8 1/8", "8 3/4")
GO
INSERT INTO Quotes (Ticker, Date, Volume, HighAsk, LowBid, CloseAvg)
VALUES ("BORL", "19941212  0:00", 458900, "8 7/8", "8 1/4", "8 3/8")
GO
INSERT INTO Quotes (Ticker, Date, Volume, HighAsk, LowBid, CloseAvg)
VALUES ("BORL", "19941213  0:00", 229000, "8 5/8", "8 1/4", "8 1/4")
GO
INSERT INTO Quotes (Ticker, Date, Volume, HighAsk, LowBid, CloseAvg)
VALUES ("BORL", "19941214  0:00", 207300, "8 3/8", "8 1/8", "8 1/8")
GO
INSERT INTO Quotes (Ticker, Date, Volume, HighAsk, LowBid, CloseAvg)
VALUES ("BORL", "19941215  0:00", 187100, "8 3/8", "8 1/8", "8 1/4")
GO
INSERT INTO Quotes (Ticker, Date, Volume, HighAsk, LowBid, CloseAvg)
VALUES ("BORL", "19941216  0:00", 296000, "8 1/2", "8 1/8", "8 3/8")
GO
INSERT INTO Quotes (Ticker, Date, Volume, HighAsk, LowBid, CloseAvg)
VALUES ("BORL", "19941219  0:00", 680200, "8 1/4", "7 1/4", "7 9/16")
GO
INSERT INTO Quotes (Ticker, Date, Volume, HighAsk, LowBid, CloseAvg)
VALUES ("BORL", "19941220  0:00", 794900, "7 5/8", "6 3/4", "7 1/8")
GO
INSERT INTO Quotes (Ticker, Date, Volume, HighAsk, LowBid, CloseAvg)
VALUES ("BORL", "19941221  0:00", 527400, "8", "7 1/8", "7 1/2")
GO
INSERT INTO Quotes (Ticker, Date, Volume, HighAsk, LowBid, CloseAvg)
VALUES ("BORL", "19941222  0:00", 1403300, "7 1/4", "6 1/2", "6 5/8")
GO
INSERT INTO Quotes (Ticker, Date, Volume, HighAsk, LowBid, CloseAvg)
VALUES ("BORL", "19941223  0:00", 713400, "6 3/4", "6 3/8", "6 1/2")
GO
INSERT INTO Quotes (Ticker, Date, Volume, HighAsk, LowBid, CloseAvg)
VALUES ("BORL", "19941226  0:00", -1, NULL, NULL, NULL)
GO
INSERT INTO Quotes (Ticker, Date, Volume, HighAsk, LowBid, CloseAvg)
VALUES ("BORL", "19941227  0:00", 498000, "6 5/8", "6 1/4", "6 1/4")
GO
INSERT INTO Quotes (Ticker, Date, Volume, HighAsk, LowBid, CloseAvg)
VALUES ("BORL", "19941228  0:00", 708000, "6 1/2", "6", "6 1/8")
GO
INSERT INTO Quotes (Ticker, Date, Volume, HighAsk, LowBid, CloseAvg)
VALUES ("BORL", "19941229  0:00", 895400, "6 1/4", "6", "6 1/8")
GO
INSERT INTO Quotes (Ticker, Date, Volume, HighAsk, LowBid, CloseAvg)
VALUES ("BORL", "19941230  0:00", 1077900, "6 1/4", "6", "6 1/8")
GO
INSERT INTO Quotes (Ticker, Date, Volume, HighAsk, LowBid, CloseAvg)
VALUES ("BORL", "19950102  0:00", -1, NULL, NULL, NULL)
GO
INSERT INTO Quotes (Ticker, Date, Volume, HighAsk, LowBid, CloseAvg)
VALUES ("BORL", "19950103  0:00", 713500, "7 1/4", "6 1/8", "7 1/8")
GO
INSERT INTO Quotes (Ticker, Date, Volume, HighAsk, LowBid, CloseAvg)
VALUES ("BORL", "19950104  0:00", 371900, "7", "6 1/2", "6 7/8")
GO
INSERT INTO Quotes (Ticker, Date, Volume, HighAsk, LowBid, CloseAvg)
VALUES ("BORL", "19950105  0:00", 254600, "6 7/8", "6 3/8", "6 5/8")
GO
INSERT INTO Quotes (Ticker, Date, Volume, HighAsk, LowBid, CloseAvg)
VALUES ("BORL", "19950106  0:00", 171400, "6 7/8", "6 1/2", "6 7/8")
GO
INSERT INTO Quotes (Ticker, Date, Volume, HighAsk, LowBid, CloseAvg)
VALUES ("BORL", "19950109  0:00", 316000, "7", "6 5/8", "6 3/4")
GO
INSERT INTO Quotes (Ticker, Date, Volume, HighAsk, LowBid, CloseAvg)
VALUES ("BORL", "19950110  0:00", 185000, "7 1/16", "6 5/8", "6 3/4")
GO
INSERT INTO Quotes (Ticker, Date, Volume, HighAsk, LowBid, CloseAvg)
VALUES ("BORL", "19950111  0:00", 515000, "7 1/4", "6 3/4", "7")
GO
INSERT INTO Quotes (Ticker, Date, Volume, HighAsk, LowBid, CloseAvg)
VALUES ("BORL", "19950112  0:00", 962000, "7 1/2", "7", "7")
GO
INSERT INTO Quotes (Ticker, Date, Volume, HighAsk, LowBid, CloseAvg)
VALUES ("BORL", "19950113  0:00", 3093000, "8 1/8", "7", "7 3/4")
GO
INSERT INTO Quotes (Ticker, Date, Volume, HighAsk, LowBid, CloseAvg)
VALUES ("BORL", "19950116  0:00", 1597500, "8 5/8", "8 1/8", "8 1/4")
GO
INSERT INTO Quotes (Ticker, Date, Volume, HighAsk, LowBid, CloseAvg)
VALUES ("BORL", "19950117  0:00", 633900, "8 1/2", "8", "8")
GO
INSERT INTO Quotes (Ticker, Date, Volume, HighAsk, LowBid, CloseAvg)
VALUES ("BORL", "19950118  0:00", 448500, "8 1/8", "7 3/4", "7 3/4")
GO
INSERT INTO Quotes (Ticker, Date, Volume, HighAsk, LowBid, CloseAvg)
VALUES ("BORL", "19950119  0:00", 240600, "8", "7 3/4", "8")
GO
INSERT INTO Quotes (Ticker, Date, Volume, HighAsk, LowBid, CloseAvg)
VALUES ("BORL", "19950120  0:00", 245600, "8", "7 5/8", "7 7/8")
GO
INSERT INTO Quotes (Ticker, Date, Volume, HighAsk, LowBid, CloseAvg)
VALUES ("BORL", "19950123  0:00", 485000, "7 7/8", "7 1/8", "7 7/8")
GO
INSERT INTO Quotes (Ticker, Date, Volume, HighAsk, LowBid, CloseAvg)
VALUES ("BORL", "19950124  0:00", 318600, "7 7/8", "7 1/4", "7 3/8")
GO
INSERT INTO Quotes (Ticker, Date, Volume, HighAsk, LowBid, CloseAvg)
VALUES ("BORL", "19950125  0:00", 657700, "7 1/4", "6 1/2", "7")
GO
INSERT INTO Quotes (Ticker, Date, Volume, HighAsk, LowBid, CloseAvg)
VALUES ("BORL", "19950126  0:00", 234600, "7 1/4", "7", "7")
GO
INSERT INTO Quotes (Ticker, Date, Volume, HighAsk, LowBid, CloseAvg)
VALUES ("BORL", "19950127  0:00", 406800, "7 1/2", "6 7/8", "6 7/8")
GO
INSERT INTO Quotes (Ticker, Date, Volume, HighAsk, LowBid, CloseAvg)
VALUES ("BORL", "19950130  0:00", 226500, "7", "6 5/8", "6 11/16")
GO
INSERT INTO Quotes (Ticker, Date, Volume, HighAsk, LowBid, CloseAvg)
VALUES ("BORL", "19950131  0:00", 158400, "7 1/16", "6 5/8", "7")
GO
INSERT INTO Quotes (Ticker, Date, Volume, HighAsk, LowBid, CloseAvg)
VALUES ("BORL", "19950201  0:00", 116100, "7 1/4", "7", "7 1/16")
GO
INSERT INTO Quotes (Ticker, Date, Volume, HighAsk, LowBid, CloseAvg)
VALUES ("BORL", "19950202  0:00", 255000, "7 3/8", "7", "7 3/8")
GO
INSERT INTO Quotes (Ticker, Date, Volume, HighAsk, LowBid, CloseAvg)
VALUES ("BORL", "19950203  0:00", 364400, "7 5/8", "7 1/4", "7 5/8")
GO
INSERT INTO Quotes (Ticker, Date, Volume, HighAsk, LowBid, CloseAvg)
VALUES ("BORL", "19950206  0:00", 160600, "7 5/8", "7 3/8", "7 9/16")
GO
INSERT INTO Quotes (Ticker, Date, Volume, HighAsk, LowBid, CloseAvg)
VALUES ("BORL", "19950207  0:00", 74600, "7 5/8", "7 3/8", "7 5/8")
GO
INSERT INTO Quotes (Ticker, Date, Volume, HighAsk, LowBid, CloseAvg)
VALUES ("BORL", "19950208  0:00", 219900, "7 3/4", "7 7/16", "7 3/4")
GO
INSERT INTO Quotes (Ticker, Date, Volume, HighAsk, LowBid, CloseAvg)
VALUES ("BORL", "19950209  0:00", 450600, "8", "7 1/2", "7 13/16")
GO
INSERT INTO Quotes (Ticker, Date, Volume, HighAsk, LowBid, CloseAvg)
VALUES ("BORL", "19950210  0:00", 209700, "8", "7 3/4", "8")
GO
INSERT INTO Quotes (Ticker, Date, Volume, HighAsk, LowBid, CloseAvg)
VALUES ("BORL", "19950213  0:00", 301500, "8", "7 3/4", "7 15/16")
GO
INSERT INTO Quotes (Ticker, Date, Volume, HighAsk, LowBid, CloseAvg)
VALUES ("BORL", "19950214  0:00", 151600, "8", "7 3/4", "7 7/8")
GO
INSERT INTO Quotes (Ticker, Date, Volume, HighAsk, LowBid, CloseAvg)
VALUES ("BORL", "19950215  0:00", 294300, "8 1/8", "7 3/4", "7 7/8")
GO
INSERT INTO Quotes (Ticker, Date, Volume, HighAsk, LowBid, CloseAvg)
VALUES ("BORL", "19950216  0:00", 155900, "8", "7 5/8", "7 5/8")
GO
INSERT INTO Quotes (Ticker, Date, Volume, HighAsk, LowBid, CloseAvg)
VALUES ("BORL", "19950217  0:00", 195700, "7 3/4", "7 1/2", "7 11/16")
GO
INSERT INTO Quotes (Ticker, Date, Volume, HighAsk, LowBid, CloseAvg)
VALUES ("BORL", "19950220  0:00", -1, NULL, NULL, NULL)
GO
INSERT INTO Quotes (Ticker, Date, Volume, HighAsk, LowBid, CloseAvg)
VALUES ("BORL", "19950221  0:00", 192000, "7 7/8", "7 5/8", "7 5/8")
GO
INSERT INTO Quotes (Ticker, Date, Volume, HighAsk, LowBid, CloseAvg)
VALUES ("BORL", "19950222  0:00", 236000, "8", "7 5/8", "7 7/8")
GO
INSERT INTO Quotes (Ticker, Date, Volume, HighAsk, LowBid, CloseAvg)
VALUES ("BORL", "19950223  0:00", 549000, "8 1/8", "7 3/4", "8 1/8")
GO
INSERT INTO Quotes (Ticker, Date, Volume, HighAsk, LowBid, CloseAvg)
VALUES ("BORL", "19950224  0:00", 2403000, "9 1/2", "8", "8 3/4")
GO
INSERT INTO Quotes (Ticker, Date, Volume, HighAsk, LowBid, CloseAvg)
VALUES ("BORL", "19950227  0:00", 1160600, "8 1/8", "7 5/8", "7 13/16")
GO
INSERT INTO Quotes (Ticker, Date, Volume, HighAsk, LowBid, CloseAvg)
VALUES ("BORL", "19950228  0:00", 372300, "8", "7 3/4", "8")
GO
INSERT INTO Quotes (Ticker, Date, Volume, HighAsk, LowBid, CloseAvg)
VALUES ("MSFT", "19940121  0:00", 2694000, "63 13/32", "62  1/2", "62  9/16")
GO
INSERT INTO Quotes (Ticker, Date, Volume, HighAsk, LowBid, CloseAvg)
VALUES ("MSFT", "19940122  0:00", 2357000, "63  1/4", "62", "63  1/4")
GO
INSERT INTO Quotes (Ticker, Date, Volume, HighAsk, LowBid, CloseAvg)
VALUES ("MSFT", "19940125  0:00", 2385000, "64  1/4", "63  1/8", "63  5/16")
GO		     
INSERT INTO Quotes (Ticker, Date, Volume, HighAsk, LowBid, CloseAvg)
VALUES ("MSFT", "19940126  0:00", 2427000, "64  1/8", "63", "63  3/8")
GO
INSERT INTO Quotes (Ticker, Date, Volume, HighAsk, LowBid, CloseAvg)
VALUES ("MSFT", "19940127  0:00", 2297000, "63  7/8", "63", "63")
GO
INSERT INTO Quotes (Ticker, Date, Volume, HighAsk, LowBid, CloseAvg)
VALUES ("MSFT", "19940128  0:00", 2621000, "63  3/4", "62  1/4", "62  1/2")
GO
INSERT INTO Quotes (Ticker, Date, Volume, HighAsk, LowBid, CloseAvg)
VALUES ("MSFT", "19940129  0:00", 4997000, "63  1/4", "62  1/4", "63  1/8")
GO
INSERT INTO Quotes (Ticker, Date, Volume, HighAsk, LowBid, CloseAvg)
VALUES ("MSFT", "19941212  0:00", 4082000, "63  1/2", "61  5/8", "63  1/8")
GO
INSERT INTO Quotes (Ticker, Date, Volume, HighAsk, LowBid, CloseAvg)
VALUES ("MSFT", "19941213  0:00", 1889000, "63  1/2", "62  1/4", "62  3/4")
GO
INSERT INTO Quotes (Ticker, Date, Volume, HighAsk, LowBid, CloseAvg)
VALUES ("MSFT", "19941214  0:00", 2103000, "63  5/8", "62  1/2", "63  1/4")
GO
INSERT INTO Quotes (Ticker, Date, Volume, HighAsk, LowBid, CloseAvg)
VALUES ("MSFT", "19941215  0:00", 1803000, "64  1/8", "63", "63  1/2")
GO
INSERT INTO Quotes (Ticker, Date, Volume, HighAsk, LowBid, CloseAvg)
VALUES ("MSFT", "19941216  0:00", 3376000, "64  1/4", "63 13/64", "63  3/8")
GO