NSE-Cash.Market-Bhavcopies-2012
NSE India's Bhavcopy dataset for Cash market
@kaggle.mayookhlad_nsecashmarketbhavcopies2012
NSE India's Bhavcopy dataset for Cash market
@kaggle.mayookhlad_nsecashmarketbhavcopies2012
CREATE TABLE cm22feb2012bhav (
"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 cm22jun2012bhav (
"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 cm22mar2012bhav (
"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 cm22may2012bhav (
"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 cm22nov2012bhav (
"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 cm22oct2012bhav (
"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 cm23apr2012bhav (
"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 cm23aug2012bhav (
"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 cm23feb2012bhav (
"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 cm23jan2012bhav (
"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 cm23jul2012bhav (
"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 cm23mar2012bhav (
"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 cm23may2012bhav (
"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 cm23nov2012bhav (
"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 cm23oct2012bhav (
"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 cm24apr2012bhav (
"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 cm24aug2012bhav (
"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 cm24dec2012bhav (
"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 cm24feb2012bhav (
"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 cm24jan2012bhav (
"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 cm24jul2012bhav (
"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 cm24may2012bhav (
"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 cm24sep2012bhav (
"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 cm25apr2012bhav (
"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 cm25jan2012bhav (
"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.