Field Name

Data Type

Description

Date_key

Integer

Date Key

Exchange_Key

Integer

Foreign Key, references Exchange table

Settlement_Key

Integer

Foreign Key, references Settlement table

Trader_Key

Integer

Foreign Key, references Trader Table

Stock_Key

Integer

Foreign Key, references Stock Dimension table

Previous_Close

Float

Previous close of the Script

Open_Price

Float

Opening price of Script for the given day

High_Price

Float

High price of Script for the given day

Low_Price

Float

Low price of Script for the given day

Close_Price

Float

Closing price of Script for the given day

Total_Traded_Quantity

Float

Total traded quantity of the Script for the given day

Total_ Deliverable Qty

Float

Total Deliverable quantity Script for the given day

Total_Turnover

Float

Total value of transactions for the given day

artificial_segmentation_column

Integer

Generated values for load-balancing nodes