NSE-Cash.Market-Bhavcopies-2002
NSE India's Bhavcopy dataset for Cash market
@kaggle.mayookhlad_nsecashmarketbhavcopies2002
NSE India's Bhavcopy dataset for Cash market
@kaggle.mayookhlad_nsecashmarketbhavcopies2002
CREATE TABLE cm10dec2002bhav (
"symbol" VARCHAR,
"series" VARCHAR,
"open" DOUBLE,
"high" DOUBLE,
"low" DOUBLE,
"close" DOUBLE,
"last" DOUBLE,
"prevclose" DOUBLE,
"tottrdqty" BIGINT,
"tottrdval" DOUBLE,
"timestamp" TIMESTAMP,
"unnamed_11" VARCHAR -- Unnamed: 11
);
CREATE TABLE cm10jan2002bhav (
"symbol" VARCHAR,
"series" VARCHAR,
"open" DOUBLE,
"high" DOUBLE,
"low" DOUBLE,
"close" DOUBLE,
"last" DOUBLE,
"prevclose" DOUBLE,
"tottrdqty" BIGINT,
"tottrdval" DOUBLE,
"timestamp" TIMESTAMP,
"unnamed_11" VARCHAR -- Unnamed: 11
);
CREATE TABLE cm10jul2002bhav (
"symbol" VARCHAR,
"series" VARCHAR,
"open" DOUBLE,
"high" DOUBLE,
"low" DOUBLE,
"close" DOUBLE,
"last" DOUBLE,
"prevclose" DOUBLE,
"tottrdqty" BIGINT,
"tottrdval" DOUBLE,
"timestamp" TIMESTAMP,
"unnamed_11" VARCHAR -- Unnamed: 11
);
CREATE TABLE cm10jun2002bhav (
"symbol" VARCHAR,
"series" VARCHAR,
"open" DOUBLE,
"high" DOUBLE,
"low" DOUBLE,
"close" DOUBLE,
"last" DOUBLE,
"prevclose" DOUBLE,
"tottrdqty" BIGINT,
"tottrdval" DOUBLE,
"timestamp" TIMESTAMP,
"unnamed_11" VARCHAR -- Unnamed: 11
);
CREATE TABLE cm10may2002bhav (
"symbol" VARCHAR,
"series" VARCHAR,
"open" DOUBLE,
"high" DOUBLE,
"low" DOUBLE,
"close" DOUBLE,
"last" DOUBLE,
"prevclose" DOUBLE,
"tottrdqty" BIGINT,
"tottrdval" DOUBLE,
"timestamp" TIMESTAMP,
"unnamed_11" VARCHAR -- Unnamed: 11
);
CREATE TABLE cm10oct2002bhav (
"symbol" VARCHAR,
"series" VARCHAR,
"open" DOUBLE,
"high" DOUBLE,
"low" DOUBLE,
"close" DOUBLE,
"last" DOUBLE,
"prevclose" DOUBLE,
"tottrdqty" BIGINT,
"tottrdval" DOUBLE,
"timestamp" TIMESTAMP,
"unnamed_11" VARCHAR -- Unnamed: 11
);
CREATE TABLE cm11apr2002bhav (
"symbol" VARCHAR,
"series" VARCHAR,
"open" DOUBLE,
"high" DOUBLE,
"low" DOUBLE,
"close" DOUBLE,
"last" DOUBLE,
"prevclose" DOUBLE,
"tottrdqty" BIGINT,
"tottrdval" DOUBLE,
"timestamp" TIMESTAMP,
"unnamed_11" VARCHAR -- Unnamed: 11
);
CREATE TABLE cm11dec2002bhav (
"symbol" VARCHAR,
"series" VARCHAR,
"open" DOUBLE,
"high" DOUBLE,
"low" DOUBLE,
"close" DOUBLE,
"last" DOUBLE,
"prevclose" DOUBLE,
"tottrdqty" BIGINT,
"tottrdval" DOUBLE,
"timestamp" TIMESTAMP,
"unnamed_11" VARCHAR -- Unnamed: 11
);
CREATE TABLE cm11feb2002bhav (
"symbol" VARCHAR,
"series" VARCHAR,
"open" DOUBLE,
"high" DOUBLE,
"low" DOUBLE,
"close" DOUBLE,
"last" DOUBLE,
"prevclose" DOUBLE,
"tottrdqty" BIGINT,
"tottrdval" DOUBLE,
"timestamp" TIMESTAMP,
"unnamed_11" VARCHAR -- Unnamed: 11
);
CREATE TABLE cm11jan2002bhav (
"symbol" VARCHAR,
"series" VARCHAR,
"open" DOUBLE,
"high" DOUBLE,
"low" DOUBLE,
"close" DOUBLE,
"last" DOUBLE,
"prevclose" DOUBLE,
"tottrdqty" BIGINT,
"tottrdval" DOUBLE,
"timestamp" TIMESTAMP,
"unnamed_11" VARCHAR -- Unnamed: 11
);
CREATE TABLE cm11jul2002bhav (
"symbol" VARCHAR,
"series" VARCHAR,
"open" DOUBLE,
"high" DOUBLE,
"low" DOUBLE,
"close" DOUBLE,
"last" DOUBLE,
"prevclose" DOUBLE,
"tottrdqty" BIGINT,
"tottrdval" DOUBLE,
"timestamp" TIMESTAMP,
"unnamed_11" VARCHAR -- Unnamed: 11
);
CREATE TABLE cm11jun2002bhav (
"symbol" VARCHAR,
"series" VARCHAR,
"open" DOUBLE,
"high" DOUBLE,
"low" DOUBLE,
"close" DOUBLE,
"last" DOUBLE,
"prevclose" DOUBLE,
"tottrdqty" BIGINT,
"tottrdval" DOUBLE,
"timestamp" TIMESTAMP,
"unnamed_11" VARCHAR -- Unnamed: 11
);
CREATE TABLE cm11mar2002bhav (
"symbol" VARCHAR,
"series" VARCHAR,
"open" DOUBLE,
"high" DOUBLE,
"low" DOUBLE,
"close" DOUBLE,
"last" DOUBLE,
"prevclose" DOUBLE,
"tottrdqty" BIGINT,
"tottrdval" DOUBLE,
"timestamp" TIMESTAMP,
"unnamed_11" VARCHAR -- Unnamed: 11
);
CREATE TABLE cm11nov2002bhav (
"symbol" VARCHAR,
"series" VARCHAR,
"open" DOUBLE,
"high" DOUBLE,
"low" DOUBLE,
"close" DOUBLE,
"last" DOUBLE,
"prevclose" DOUBLE,
"tottrdqty" BIGINT,
"tottrdval" DOUBLE,
"timestamp" TIMESTAMP,
"unnamed_11" VARCHAR -- Unnamed: 11
);
CREATE TABLE cm11oct2002bhav (
"symbol" VARCHAR,
"series" VARCHAR,
"open" DOUBLE,
"high" DOUBLE,
"low" DOUBLE,
"close" DOUBLE,
"last" DOUBLE,
"prevclose" DOUBLE,
"tottrdqty" BIGINT,
"tottrdval" DOUBLE,
"timestamp" TIMESTAMP,
"unnamed_11" VARCHAR -- Unnamed: 11
);
CREATE TABLE cm11sep2002bhav (
"symbol" VARCHAR,
"series" VARCHAR,
"open" DOUBLE,
"high" DOUBLE,
"low" DOUBLE,
"close" DOUBLE,
"last" DOUBLE,
"prevclose" DOUBLE,
"tottrdqty" BIGINT,
"tottrdval" DOUBLE,
"timestamp" TIMESTAMP,
"unnamed_11" VARCHAR -- Unnamed: 11
);
CREATE TABLE cm12apr2002bhav (
"symbol" VARCHAR,
"series" VARCHAR,
"open" DOUBLE,
"high" DOUBLE,
"low" DOUBLE,
"close" DOUBLE,
"last" DOUBLE,
"prevclose" DOUBLE,
"tottrdqty" BIGINT,
"tottrdval" DOUBLE,
"timestamp" TIMESTAMP,
"unnamed_11" VARCHAR -- Unnamed: 11
);
CREATE TABLE cm12aug2002bhav (
"symbol" VARCHAR,
"series" VARCHAR,
"open" DOUBLE,
"high" DOUBLE,
"low" DOUBLE,
"close" DOUBLE,
"last" DOUBLE,
"prevclose" DOUBLE,
"tottrdqty" BIGINT,
"tottrdval" DOUBLE,
"timestamp" TIMESTAMP,
"unnamed_11" VARCHAR -- Unnamed: 11
);
CREATE TABLE cm12dec2002bhav (
"symbol" VARCHAR,
"series" VARCHAR,
"open" DOUBLE,
"high" DOUBLE,
"low" DOUBLE,
"close" DOUBLE,
"last" DOUBLE,
"prevclose" DOUBLE,
"tottrdqty" BIGINT,
"tottrdval" DOUBLE,
"timestamp" TIMESTAMP,
"unnamed_11" VARCHAR -- Unnamed: 11
);
CREATE TABLE cm12feb2002bhav (
"symbol" VARCHAR,
"series" VARCHAR,
"open" DOUBLE,
"high" DOUBLE,
"low" DOUBLE,
"close" DOUBLE,
"last" DOUBLE,
"prevclose" DOUBLE,
"tottrdqty" BIGINT,
"tottrdval" DOUBLE,
"timestamp" TIMESTAMP,
"unnamed_11" VARCHAR -- Unnamed: 11
);
CREATE TABLE cm12jul2002bhav (
"symbol" VARCHAR,
"series" VARCHAR,
"open" DOUBLE,
"high" DOUBLE,
"low" DOUBLE,
"close" DOUBLE,
"last" DOUBLE,
"prevclose" DOUBLE,
"tottrdqty" BIGINT,
"tottrdval" DOUBLE,
"timestamp" TIMESTAMP,
"unnamed_11" VARCHAR -- Unnamed: 11
);
CREATE TABLE cm12jun2002bhav (
"symbol" VARCHAR,
"series" VARCHAR,
"open" DOUBLE,
"high" DOUBLE,
"low" DOUBLE,
"close" DOUBLE,
"last" DOUBLE,
"prevclose" DOUBLE,
"tottrdqty" BIGINT,
"tottrdval" DOUBLE,
"timestamp" TIMESTAMP,
"unnamed_11" VARCHAR -- Unnamed: 11
);
CREATE TABLE cm12mar2002bhav (
"symbol" VARCHAR,
"series" VARCHAR,
"open" DOUBLE,
"high" DOUBLE,
"low" DOUBLE,
"close" DOUBLE,
"last" DOUBLE,
"prevclose" DOUBLE,
"tottrdqty" BIGINT,
"tottrdval" DOUBLE,
"timestamp" TIMESTAMP,
"unnamed_11" VARCHAR -- Unnamed: 11
);
CREATE TABLE cm12nov2002bhav (
"symbol" VARCHAR,
"series" VARCHAR,
"open" DOUBLE,
"high" DOUBLE,
"low" DOUBLE,
"close" DOUBLE,
"last" DOUBLE,
"prevclose" DOUBLE,
"tottrdqty" BIGINT,
"tottrdval" DOUBLE,
"timestamp" TIMESTAMP,
"unnamed_11" VARCHAR -- Unnamed: 11
);
CREATE TABLE cm12sep2002bhav (
"symbol" VARCHAR,
"series" VARCHAR,
"open" DOUBLE,
"high" DOUBLE,
"low" DOUBLE,
"close" DOUBLE,
"last" DOUBLE,
"prevclose" DOUBLE,
"tottrdqty" BIGINT,
"tottrdval" DOUBLE,
"timestamp" TIMESTAMP,
"unnamed_11" VARCHAR -- Unnamed: 11
);
Anyone who has the link will be able to view this.