-
Notifications
You must be signed in to change notification settings - Fork 0
/
CreateTable.txt
48 lines (48 loc) · 1.49 KB
/
CreateTable.txt
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
CREATE TABLE [dbo].[SUMMARY](
[ID] [int] IDENTITY(1,1) NOT NULL,
[DATA] [datetime] NULL,
[ATIVO] [nvarchar](10) NULL,
[SHORTNAME] [nvarchar](150) NULL,
[LONGNAME] [nvarchar](350) NULL,
[MAXAGE] [float] NULL,
[PRICEHINT] [float] NULL,
[PREVIOUSCLOSE] [float] NULL,
[VOPEN] [float] NULL,
[DAYLOW] [float] NULL,
[DAYHIGH] [float] NULL,
[REGULARMARKETPREVIOUSCLOSE] [float] NULL,
[REGULARMARKETOPEN] [float] NULL,
[REGULARMARKETDAYLOW] [float] NULL,
[REGULARMARKETDAYHIGH] [float] NULL,
[DIVIDENDRATE] [float] NULL,
[DIVIDENDYIELD] [float] NULL,
[EXDIVIDENDDATE] [date] NULL,
[PAYOUTRATIO] [float] NULL,
[FIVEYEARAVGDIVIDENDYIELD] [float] NULL,
[BETA] [float] NULL,
[TRAILINGPE] [float] NULL,
[FORWARDPE] [float] NULL,
[VOLUME] [float] NULL,
[REGULARMARKETVOLUME] [float] NULL,
[AVERAGEVOLUME] [float] NULL,
[AVERAGEVOLUME10DAYS] [float] NULL,
[AVERAGEDAILYVOLUME10DAY] [float] NULL,
[BID] [float] NULL,
[ASK] [float] NULL,
[BIDSIZE] [float] NULL,
[ASKSIZE] [float] NULL,
[MARKETCAP] [bigint] NULL,
[FIFTYTWOWEEKLOW] [float] NULL,
[FIFTYTWOWEEKHIGH] [float] NULL,
[PRICETOSALESTRAILING12MONTHS] [float] NULL,
[FIFTYDAYAVERAGE] [float] NULL,
[TWOHUNDREDDAYAVERAGE] [float] NULL,
[TRAILINGANNUALDIVIDENDRATE] [float] NULL,
[TRAILINGANNUALDIVIDENDYIELD] [float] NULL,
[CURRENCY] [nvarchar](10) NULL,
[FROMCURRENCY] [nvarchar](150) NULL,
[TOCURRENCY] [nvarchar](150) NULL,
[LASTMARKET] [nvarchar](150) NULL,
[ALGORITHM] [nvarchar](150) NULL,
[TRADEABLE] [nvarchar](150) NULL
) ON [PRIMARY]