NSE-Cash.Market-Bhavcopies-2009
NSE India's Bhavcopy dataset for Cash market
@kaggle.mayookhlad_nsecashmarketbhavcopies2009
NSE India's Bhavcopy dataset for Cash market
@kaggle.mayookhlad_nsecashmarketbhavcopies2009
CREATE TABLE cm22sep2009bhav (
"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 cm23apr2009bhav (
"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 cm23dec2009bhav (
"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 cm23jan2009bhav (
"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 cm23jul2009bhav (
"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 cm23jun2009bhav (
"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 cm23mar2009bhav (
"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 cm23nov2009bhav (
"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 cm23oct2009bhav (
"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 cm23sep2009bhav (
"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 cm24apr2009bhav (
"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 cm24aug2009bhav (
"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 cm24dec2009bhav (
"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 cm24feb2009bhav (
"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 cm24jul2009bhav (
"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 cm24jun2009bhav (
"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 cm24mar2009bhav (
"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 cm24nov2009bhav (
"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 cm24sep2009bhav (
"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 cm25aug2009bhav (
"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 cm25feb2009bhav (
"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 cm25jun2009bhav (
"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 cm25mar2009bhav (
"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 cm25may2009bhav (
"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 cm25nov2009bhav (
"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.