Knocks/BackEnd/Knoks.PriceDB/Tables/ETF-Daily-Nov16.sql

17 lines
643 B
Transact-SQL

CREATE TABLE [dbo].[ETF-Daily-Nov16] (
[CRTD_Period] VARCHAR (50) NULL,
[CRTD_FirstQuote] DATETIME NULL,
[CRTD_LastQuote] DATETIME NULL,
[CRTD_PairSymbol] VARCHAR (50) NULL,
[CRTD_BidOpeningValue] FLOAT (53) NULL,
[CRTD_BidClosingValue] FLOAT (53) NULL,
[CRTD_BidLowValue] FLOAT (53) NULL,
[CRTD_BidHighValue] FLOAT (53) NULL,
[CRTD_MidOpeningValue] FLOAT (53) NULL,
[CRTD_MidClosingValue] FLOAT (53) NULL,
[CRTD_MidLowValue] FLOAT (53) NULL,
[CRTD_MidHighValue] FLOAT (53) NULL,
[CRTD_DateIn] FLOAT (53) NULL
);