NSE-Cash.Market-Bhavcopies-2016
NSE India's Bhavcopy dataset for Cash market
@kaggle.mayookhlad_nsecashmarketbhavcopies2016
NSE India's Bhavcopy dataset for Cash market
@kaggle.mayookhlad_nsecashmarketbhavcopies2016
CREATE TABLE cm28sep2016bhav (
"symbol" VARCHAR,
"series" VARCHAR,
"open" DOUBLE,
"high" DOUBLE,
"low" DOUBLE,
"close" DOUBLE,
"last" DOUBLE,
"prevclose" DOUBLE,
"tottrdqty" BIGINT,
"tottrdval" DOUBLE,
"timestamp" TIMESTAMP,
"totaltrades" BIGINT,
"isin" VARCHAR,
"unnamed_13" VARCHAR -- Unnamed: 13
);
CREATE TABLE cm29apr2016bhav (
"symbol" VARCHAR,
"series" VARCHAR,
"open" DOUBLE,
"high" DOUBLE,
"low" DOUBLE,
"close" DOUBLE,
"last" DOUBLE,
"prevclose" DOUBLE,
"tottrdqty" BIGINT,
"tottrdval" DOUBLE,
"timestamp" TIMESTAMP,
"totaltrades" BIGINT,
"isin" VARCHAR,
"unnamed_13" VARCHAR -- Unnamed: 13
);
CREATE TABLE cm29aug2016bhav (
"symbol" VARCHAR,
"series" VARCHAR,
"open" DOUBLE,
"high" DOUBLE,
"low" DOUBLE,
"close" DOUBLE,
"last" DOUBLE,
"prevclose" DOUBLE,
"tottrdqty" BIGINT,
"tottrdval" DOUBLE,
"timestamp" TIMESTAMP,
"totaltrades" BIGINT,
"isin" VARCHAR,
"unnamed_13" VARCHAR -- Unnamed: 13
);
CREATE TABLE cm29dec2016bhav (
"symbol" VARCHAR,
"series" VARCHAR,
"open" DOUBLE,
"high" DOUBLE,
"low" DOUBLE,
"close" DOUBLE,
"last" DOUBLE,
"prevclose" DOUBLE,
"tottrdqty" BIGINT,
"tottrdval" DOUBLE,
"timestamp" TIMESTAMP,
"totaltrades" BIGINT,
"isin" VARCHAR,
"unnamed_13" VARCHAR -- Unnamed: 13
);
CREATE TABLE cm29feb2016bhav (
"symbol" VARCHAR,
"series" VARCHAR,
"open" DOUBLE,
"high" DOUBLE,
"low" DOUBLE,
"close" DOUBLE,
"last" DOUBLE,
"prevclose" DOUBLE,
"tottrdqty" BIGINT,
"tottrdval" DOUBLE,
"timestamp" TIMESTAMP,
"totaltrades" BIGINT,
"isin" VARCHAR,
"unnamed_13" VARCHAR -- Unnamed: 13
);
CREATE TABLE cm29jan2016bhav (
"symbol" VARCHAR,
"series" VARCHAR,
"open" DOUBLE,
"high" DOUBLE,
"low" DOUBLE,
"close" DOUBLE,
"last" DOUBLE,
"prevclose" DOUBLE,
"tottrdqty" BIGINT,
"tottrdval" DOUBLE,
"timestamp" TIMESTAMP,
"totaltrades" BIGINT,
"isin" VARCHAR,
"unnamed_13" VARCHAR -- Unnamed: 13
);
CREATE TABLE cm29jul2016bhav (
"symbol" VARCHAR,
"series" VARCHAR,
"open" DOUBLE,
"high" DOUBLE,
"low" DOUBLE,
"close" DOUBLE,
"last" DOUBLE,
"prevclose" DOUBLE,
"tottrdqty" BIGINT,
"tottrdval" DOUBLE,
"timestamp" TIMESTAMP,
"totaltrades" BIGINT,
"isin" VARCHAR,
"unnamed_13" VARCHAR -- Unnamed: 13
);
CREATE TABLE cm29jun2016bhav (
"symbol" VARCHAR,
"series" VARCHAR,
"open" DOUBLE,
"high" DOUBLE,
"low" DOUBLE,
"close" DOUBLE,
"last" DOUBLE,
"prevclose" DOUBLE,
"tottrdqty" BIGINT,
"tottrdval" DOUBLE,
"timestamp" TIMESTAMP,
"totaltrades" BIGINT,
"isin" VARCHAR,
"unnamed_13" VARCHAR -- Unnamed: 13
);
CREATE TABLE cm29mar2016bhav (
"symbol" VARCHAR,
"series" VARCHAR,
"open" DOUBLE,
"high" DOUBLE,
"low" DOUBLE,
"close" DOUBLE,
"last" DOUBLE,
"prevclose" DOUBLE,
"tottrdqty" BIGINT,
"tottrdval" DOUBLE,
"timestamp" TIMESTAMP,
"totaltrades" BIGINT,
"isin" VARCHAR,
"unnamed_13" VARCHAR -- Unnamed: 13
);
CREATE TABLE cm29nov2016bhav (
"symbol" VARCHAR,
"series" VARCHAR,
"open" DOUBLE,
"high" DOUBLE,
"low" DOUBLE,
"close" DOUBLE,
"last" DOUBLE,
"prevclose" DOUBLE,
"tottrdqty" BIGINT,
"tottrdval" DOUBLE,
"timestamp" TIMESTAMP,
"totaltrades" BIGINT,
"isin" VARCHAR,
"unnamed_13" VARCHAR -- Unnamed: 13
);
CREATE TABLE cm29sep2016bhav (
"symbol" VARCHAR,
"series" VARCHAR,
"open" DOUBLE,
"high" DOUBLE,
"low" DOUBLE,
"close" DOUBLE,
"last" DOUBLE,
"prevclose" DOUBLE,
"tottrdqty" BIGINT,
"tottrdval" DOUBLE,
"timestamp" TIMESTAMP,
"totaltrades" BIGINT,
"isin" VARCHAR,
"unnamed_13" VARCHAR -- Unnamed: 13
);
CREATE TABLE cm30aug2016bhav (
"symbol" VARCHAR,
"series" VARCHAR,
"open" DOUBLE,
"high" DOUBLE,
"low" DOUBLE,
"close" DOUBLE,
"last" DOUBLE,
"prevclose" DOUBLE,
"tottrdqty" BIGINT,
"tottrdval" DOUBLE,
"timestamp" TIMESTAMP,
"totaltrades" BIGINT,
"isin" VARCHAR,
"unnamed_13" VARCHAR -- Unnamed: 13
);
CREATE TABLE cm30dec2016bhav (
"symbol" VARCHAR,
"series" VARCHAR,
"open" DOUBLE,
"high" DOUBLE,
"low" DOUBLE,
"close" DOUBLE,
"last" DOUBLE,
"prevclose" DOUBLE,
"tottrdqty" BIGINT,
"tottrdval" DOUBLE,
"timestamp" TIMESTAMP,
"totaltrades" BIGINT,
"isin" VARCHAR,
"unnamed_13" VARCHAR -- Unnamed: 13
);
CREATE TABLE cm30jun2016bhav (
"symbol" VARCHAR,
"series" VARCHAR,
"open" DOUBLE,
"high" DOUBLE,
"low" DOUBLE,
"close" DOUBLE,
"last" DOUBLE,
"prevclose" DOUBLE,
"tottrdqty" BIGINT,
"tottrdval" DOUBLE,
"timestamp" TIMESTAMP,
"totaltrades" BIGINT,
"isin" VARCHAR,
"unnamed_13" VARCHAR -- Unnamed: 13
);
CREATE TABLE cm30mar2016bhav (
"symbol" VARCHAR,
"series" VARCHAR,
"open" DOUBLE,
"high" DOUBLE,
"low" DOUBLE,
"close" DOUBLE,
"last" DOUBLE,
"prevclose" DOUBLE,
"tottrdqty" BIGINT,
"tottrdval" DOUBLE,
"timestamp" TIMESTAMP,
"totaltrades" BIGINT,
"isin" VARCHAR,
"unnamed_13" VARCHAR -- Unnamed: 13
);
CREATE TABLE cm30may2016bhav (
"symbol" VARCHAR,
"series" VARCHAR,
"open" DOUBLE,
"high" DOUBLE,
"low" DOUBLE,
"close" DOUBLE,
"last" DOUBLE,
"prevclose" DOUBLE,
"tottrdqty" BIGINT,
"tottrdval" DOUBLE,
"timestamp" TIMESTAMP,
"totaltrades" BIGINT,
"isin" VARCHAR,
"unnamed_13" VARCHAR -- Unnamed: 13
);
CREATE TABLE cm30nov2016bhav (
"symbol" VARCHAR,
"series" VARCHAR,
"open" DOUBLE,
"high" DOUBLE,
"low" DOUBLE,
"close" DOUBLE,
"last" DOUBLE,
"prevclose" DOUBLE,
"tottrdqty" BIGINT,
"tottrdval" DOUBLE,
"timestamp" TIMESTAMP,
"totaltrades" BIGINT,
"isin" VARCHAR,
"unnamed_13" VARCHAR -- Unnamed: 13
);
CREATE TABLE cm30oct2016bhav (
"symbol" VARCHAR,
"series" VARCHAR,
"open" DOUBLE,
"high" DOUBLE,
"low" DOUBLE,
"close" DOUBLE,
"last" DOUBLE,
"prevclose" DOUBLE,
"tottrdqty" BIGINT,
"tottrdval" DOUBLE,
"timestamp" TIMESTAMP,
"totaltrades" BIGINT,
"isin" VARCHAR,
"unnamed_13" VARCHAR -- Unnamed: 13
);
CREATE TABLE cm30sep2016bhav (
"symbol" VARCHAR,
"series" VARCHAR,
"open" DOUBLE,
"high" DOUBLE,
"low" DOUBLE,
"close" DOUBLE,
"last" DOUBLE,
"prevclose" DOUBLE,
"tottrdqty" BIGINT,
"tottrdval" DOUBLE,
"timestamp" TIMESTAMP,
"totaltrades" BIGINT,
"isin" VARCHAR,
"unnamed_13" VARCHAR -- Unnamed: 13
);
CREATE TABLE cm31aug2016bhav (
"symbol" VARCHAR,
"series" VARCHAR,
"open" DOUBLE,
"high" DOUBLE,
"low" DOUBLE,
"close" DOUBLE,
"last" DOUBLE,
"prevclose" DOUBLE,
"tottrdqty" BIGINT,
"tottrdval" DOUBLE,
"timestamp" TIMESTAMP,
"totaltrades" BIGINT,
"isin" VARCHAR,
"unnamed_13" VARCHAR -- Unnamed: 13
);
CREATE TABLE cm31mar2016bhav (
"symbol" VARCHAR,
"series" VARCHAR,
"open" DOUBLE,
"high" DOUBLE,
"low" DOUBLE,
"close" DOUBLE,
"last" DOUBLE,
"prevclose" DOUBLE,
"tottrdqty" BIGINT,
"tottrdval" DOUBLE,
"timestamp" TIMESTAMP,
"totaltrades" BIGINT,
"isin" VARCHAR,
"unnamed_13" VARCHAR -- Unnamed: 13
);
CREATE TABLE cm31may2016bhav (
"symbol" VARCHAR,
"series" VARCHAR,
"open" DOUBLE,
"high" DOUBLE,
"low" DOUBLE,
"close" DOUBLE,
"last" DOUBLE,
"prevclose" DOUBLE,
"tottrdqty" BIGINT,
"tottrdval" DOUBLE,
"timestamp" TIMESTAMP,
"totaltrades" BIGINT,
"isin" VARCHAR,
"unnamed_13" VARCHAR -- Unnamed: 13
);
Anyone who has the link will be able to view this.