NSE-Cash.Market-Bhavcopies-2015
NSE India's Bhavcopy dataset for Cash market
@kaggle.mayookhlad_nsecashmarketbhavcopies2015
NSE India's Bhavcopy dataset for Cash market
@kaggle.mayookhlad_nsecashmarketbhavcopies2015
CREATE TABLE cm04feb2015bhav (
"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 cm04jun2015bhav (
"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 cm04mar2015bhav (
"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 cm04may2015bhav (
"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 cm04nov2015bhav (
"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 cm04sep2015bhav (
"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 cm05aug2015bhav (
"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 cm05feb2015bhav (
"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 cm05jan2015bhav (
"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 cm05jun2015bhav (
"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 cm05mar2015bhav (
"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 cm05may2015bhav (
"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 cm05nov2015bhav (
"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 cm05oct2015bhav (
"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 cm06apr2015bhav (
"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 cm06aug2015bhav (
"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 cm06feb2015bhav (
"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 cm06jan2015bhav (
"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 cm06jul2015bhav (
"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 cm06may2015bhav (
"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 cm06nov2015bhav (
"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 cm06oct2015bhav (
"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 cm07apr2015bhav (
"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 cm07aug2015bhav (
"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 cm07dec2015bhav (
"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.