NSE-Cash.Market-Bhavcopies-2014
NSE India's Bhavcopy dataset for Cash market
@kaggle.mayookhlad_nsecashmarketbhavcopies2014
NSE India's Bhavcopy dataset for Cash market
@kaggle.mayookhlad_nsecashmarketbhavcopies2014
CREATE TABLE cm13mar2014bhav (
"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 cm13may2014bhav (
"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 cm13nov2014bhav (
"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 cm13oct2014bhav (
"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 cm14aug2014bhav (
"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 cm14feb2014bhav (
"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 cm14jan2014bhav (
"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 cm14jul2014bhav (
"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 cm14mar2014bhav (
"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 cm14may2014bhav (
"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 cm14nov2014bhav (
"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 cm14oct2014bhav (
"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 cm15apr2014bhav (
"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 cm15dec2014bhav (
"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 cm15jan2014bhav (
"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 cm15jul2014bhav (
"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 cm15may2014bhav (
"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 cm15sep2014bhav (
"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 cm16apr2014bhav (
"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 cm16dec2014bhav (
"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 cm16jan2014bhav (
"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 cm16jul2014bhav (
"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 cm16jun2014bhav (
"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 cm16may2014bhav (
"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 cm16oct2014bhav (
"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.