NSE Stock Data By Ticker (dataset 2)
This dataset contains data for 1987 NSE Companies
@kaggle.toocool69_nse_stock_data_by_ticker_dataset_2
This dataset contains data for 1987 NSE Companies
@kaggle.toocool69_nse_stock_data_by_ticker_dataset_2
CREATE TABLE lalpathlab (
"date" TIMESTAMP,
"open" DOUBLE,
"high" DOUBLE,
"low" DOUBLE,
"close" DOUBLE,
"adj_close" DOUBLE,
"volume" BIGINT,
"symbol" VARCHAR,
"sector" VARCHAR,
"industry" VARCHAR,
"market" VARCHAR,
"quotetype" VARCHAR,
"dividend_yield" DOUBLE,
"debt_to_equity_ratio" DOUBLE,
"current_ratio" DOUBLE,
"earning_per_share" DOUBLE,
"variability_index" DOUBLE
);
CREATE TABLE lambodhara (
"date" TIMESTAMP,
"open" DOUBLE,
"high" DOUBLE,
"low" DOUBLE,
"close" DOUBLE,
"adj_close" DOUBLE,
"volume" BIGINT,
"symbol" VARCHAR,
"sector" VARCHAR,
"industry" VARCHAR,
"market" VARCHAR,
"quotetype" VARCHAR,
"dividend_yield" DOUBLE,
"debt_to_equity_ratio" DOUBLE,
"current_ratio" DOUBLE,
"earning_per_share" DOUBLE,
"variability_index" DOUBLE
);
CREATE TABLE lancorhol (
"date" TIMESTAMP,
"open" DOUBLE,
"high" DOUBLE,
"low" DOUBLE,
"close" DOUBLE,
"adj_close" DOUBLE,
"volume" BIGINT,
"symbol" VARCHAR,
"sector" VARCHAR,
"industry" VARCHAR,
"market" VARCHAR,
"quotetype" VARCHAR,
"dividend_yield" VARCHAR,
"debt_to_equity_ratio" DOUBLE,
"current_ratio" VARCHAR,
"earning_per_share" DOUBLE,
"variability_index" DOUBLE
);
CREATE TABLE landmark (
"date" TIMESTAMP,
"open" DOUBLE,
"high" DOUBLE,
"low" DOUBLE,
"close" DOUBLE,
"adj_close" DOUBLE,
"volume" BIGINT,
"symbol" VARCHAR,
"sector" VARCHAR,
"industry" VARCHAR,
"market" VARCHAR,
"quotetype" VARCHAR,
"dividend_yield" DOUBLE,
"debt_to_equity_ratio" DOUBLE,
"current_ratio" DOUBLE,
"earning_per_share" DOUBLE,
"variability_index" DOUBLE
);
CREATE TABLE laopala (
"date" TIMESTAMP,
"open" DOUBLE,
"high" DOUBLE,
"low" DOUBLE,
"close" DOUBLE,
"adj_close" DOUBLE,
"volume" BIGINT,
"symbol" VARCHAR,
"sector" VARCHAR,
"industry" VARCHAR,
"market" VARCHAR,
"quotetype" VARCHAR,
"dividend_yield" DOUBLE,
"debt_to_equity_ratio" DOUBLE,
"current_ratio" DOUBLE,
"earning_per_share" DOUBLE,
"variability_index" DOUBLE
);
CREATE TABLE lasa (
"date" TIMESTAMP,
"open" DOUBLE,
"high" DOUBLE,
"low" DOUBLE,
"close" DOUBLE,
"adj_close" DOUBLE,
"volume" BIGINT,
"symbol" VARCHAR,
"sector" VARCHAR,
"industry" VARCHAR,
"market" VARCHAR,
"quotetype" VARCHAR,
"dividend_yield" VARCHAR,
"debt_to_equity_ratio" DOUBLE,
"current_ratio" DOUBLE,
"earning_per_share" DOUBLE,
"variability_index" DOUBLE
);
CREATE TABLE latentview (
"date" TIMESTAMP,
"open" DOUBLE,
"high" DOUBLE,
"low" DOUBLE,
"close" DOUBLE,
"adj_close" DOUBLE,
"volume" BIGINT,
"symbol" VARCHAR,
"sector" VARCHAR,
"industry" VARCHAR,
"market" VARCHAR,
"quotetype" VARCHAR,
"dividend_yield" VARCHAR,
"debt_to_equity_ratio" DOUBLE,
"current_ratio" DOUBLE,
"earning_per_share" DOUBLE,
"variability_index" DOUBLE
);
CREATE TABLE latteys (
"date" TIMESTAMP,
"open" DOUBLE,
"high" DOUBLE,
"low" DOUBLE,
"close" DOUBLE,
"adj_close" DOUBLE,
"volume" BIGINT,
"symbol" VARCHAR,
"sector" VARCHAR,
"industry" VARCHAR,
"market" VARCHAR,
"quotetype" VARCHAR,
"dividend_yield" VARCHAR,
"debt_to_equity_ratio" DOUBLE,
"current_ratio" DOUBLE,
"earning_per_share" DOUBLE,
"variability_index" DOUBLE
);
CREATE TABLE lauruslabs (
"date" TIMESTAMP,
"open" DOUBLE,
"high" DOUBLE,
"low" DOUBLE,
"close" DOUBLE,
"adj_close" DOUBLE,
"volume" BIGINT,
"symbol" VARCHAR,
"sector" VARCHAR,
"industry" VARCHAR,
"market" VARCHAR,
"quotetype" VARCHAR,
"dividend_yield" DOUBLE,
"debt_to_equity_ratio" DOUBLE,
"current_ratio" DOUBLE,
"earning_per_share" DOUBLE,
"variability_index" DOUBLE
);
CREATE TABLE laxmicot (
"date" TIMESTAMP,
"open" DOUBLE,
"high" DOUBLE,
"low" DOUBLE,
"close" DOUBLE,
"adj_close" DOUBLE,
"volume" BIGINT,
"symbol" VARCHAR,
"sector" VARCHAR,
"industry" VARCHAR,
"market" VARCHAR,
"quotetype" VARCHAR,
"dividend_yield" VARCHAR,
"debt_to_equity_ratio" DOUBLE,
"current_ratio" DOUBLE,
"earning_per_share" DOUBLE,
"variability_index" DOUBLE
);
CREATE TABLE laxmimach (
"date" TIMESTAMP,
"open" DOUBLE,
"high" DOUBLE,
"low" DOUBLE,
"close" DOUBLE,
"adj_close" DOUBLE,
"volume" BIGINT,
"symbol" VARCHAR,
"sector" VARCHAR,
"industry" VARCHAR,
"market" VARCHAR,
"quotetype" VARCHAR,
"dividend_yield" DOUBLE,
"debt_to_equity_ratio" VARCHAR,
"current_ratio" DOUBLE,
"earning_per_share" DOUBLE,
"variability_index" DOUBLE
);
CREATE TABLE lccinfotec (
"date" TIMESTAMP,
"open" DOUBLE,
"high" DOUBLE,
"low" DOUBLE,
"close" DOUBLE,
"adj_close" DOUBLE,
"volume" BIGINT,
"symbol" VARCHAR,
"sector" VARCHAR,
"industry" VARCHAR,
"market" VARCHAR,
"quotetype" VARCHAR,
"dividend_yield" VARCHAR,
"debt_to_equity_ratio" DOUBLE,
"current_ratio" DOUBLE,
"earning_per_share" DOUBLE,
"variability_index" DOUBLE
);
CREATE TABLE leel (
"date" TIMESTAMP,
"open" DOUBLE,
"high" DOUBLE,
"low" DOUBLE,
"close" DOUBLE,
"adj_close" DOUBLE,
"volume" BIGINT,
"symbol" VARCHAR,
"sector" VARCHAR,
"industry" VARCHAR,
"market" VARCHAR,
"quotetype" VARCHAR,
"dividend_yield" VARCHAR,
"debt_to_equity_ratio" VARCHAR,
"current_ratio" VARCHAR,
"earning_per_share" VARCHAR,
"variability_index" DOUBLE
);
CREATE TABLE lemontree (
"date" TIMESTAMP,
"open" DOUBLE,
"high" DOUBLE,
"low" DOUBLE,
"close" DOUBLE,
"adj_close" DOUBLE,
"volume" BIGINT,
"symbol" VARCHAR,
"sector" VARCHAR,
"industry" VARCHAR,
"market" VARCHAR,
"quotetype" VARCHAR,
"dividend_yield" VARCHAR,
"debt_to_equity_ratio" DOUBLE,
"current_ratio" DOUBLE,
"earning_per_share" DOUBLE,
"variability_index" DOUBLE
);
CREATE TABLE lexus (
"date" TIMESTAMP,
"open" DOUBLE,
"high" DOUBLE,
"low" DOUBLE,
"close" DOUBLE,
"adj_close" DOUBLE,
"volume" BIGINT,
"symbol" VARCHAR,
"sector" VARCHAR,
"industry" VARCHAR,
"market" VARCHAR,
"quotetype" VARCHAR,
"dividend_yield" VARCHAR,
"debt_to_equity_ratio" DOUBLE,
"current_ratio" DOUBLE,
"earning_per_share" DOUBLE,
"variability_index" DOUBLE
);
CREATE TABLE lgbbrosltd (
"date" TIMESTAMP,
"open" DOUBLE,
"high" DOUBLE,
"low" DOUBLE,
"close" DOUBLE,
"adj_close" DOUBLE,
"volume" BIGINT,
"symbol" VARCHAR,
"sector" VARCHAR,
"industry" VARCHAR,
"market" VARCHAR,
"quotetype" VARCHAR,
"dividend_yield" DOUBLE,
"debt_to_equity_ratio" DOUBLE,
"current_ratio" DOUBLE,
"earning_per_share" DOUBLE,
"variability_index" DOUBLE
);
CREATE TABLE lgbforge (
"date" TIMESTAMP,
"open" DOUBLE,
"high" DOUBLE,
"low" DOUBLE,
"close" DOUBLE,
"adj_close" DOUBLE,
"volume" BIGINT,
"symbol" VARCHAR,
"sector" VARCHAR,
"industry" VARCHAR,
"market" VARCHAR,
"quotetype" VARCHAR,
"dividend_yield" VARCHAR,
"debt_to_equity_ratio" DOUBLE,
"current_ratio" DOUBLE,
"earning_per_share" DOUBLE,
"variability_index" DOUBLE
);
CREATE TABLE lghl (
"date" TIMESTAMP,
"open" DOUBLE,
"high" DOUBLE,
"low" DOUBLE,
"close" DOUBLE,
"adj_close" DOUBLE,
"volume" BIGINT,
"symbol" VARCHAR,
"sector" VARCHAR,
"industry" VARCHAR,
"market" VARCHAR,
"quotetype" VARCHAR,
"dividend_yield" VARCHAR,
"debt_to_equity_ratio" DOUBLE,
"current_ratio" DOUBLE,
"earning_per_share" DOUBLE,
"variability_index" DOUBLE
);
CREATE TABLE libas (
"date" TIMESTAMP,
"open" DOUBLE,
"high" DOUBLE,
"low" DOUBLE,
"close" DOUBLE,
"adj_close" DOUBLE,
"volume" BIGINT,
"symbol" VARCHAR,
"sector" VARCHAR,
"industry" VARCHAR,
"market" VARCHAR,
"quotetype" VARCHAR,
"dividend_yield" VARCHAR,
"debt_to_equity_ratio" DOUBLE,
"current_ratio" DOUBLE,
"earning_per_share" DOUBLE,
"variability_index" DOUBLE
);
CREATE TABLE libertshoe (
"date" TIMESTAMP,
"open" DOUBLE,
"high" DOUBLE,
"low" DOUBLE,
"close" DOUBLE,
"adj_close" DOUBLE,
"volume" BIGINT,
"symbol" VARCHAR,
"sector" VARCHAR,
"industry" VARCHAR,
"market" VARCHAR,
"quotetype" VARCHAR,
"dividend_yield" VARCHAR,
"debt_to_equity_ratio" DOUBLE,
"current_ratio" DOUBLE,
"earning_per_share" DOUBLE,
"variability_index" DOUBLE
);
CREATE TABLE lichsgfin (
"date" TIMESTAMP,
"open" DOUBLE,
"high" DOUBLE,
"low" DOUBLE,
"close" DOUBLE,
"adj_close" DOUBLE,
"volume" BIGINT,
"symbol" VARCHAR,
"sector" VARCHAR,
"industry" VARCHAR,
"market" VARCHAR,
"quotetype" VARCHAR,
"dividend_yield" DOUBLE,
"debt_to_equity_ratio" DOUBLE,
"current_ratio" DOUBLE,
"earning_per_share" DOUBLE,
"variability_index" DOUBLE
);
CREATE TABLE lici (
"date" TIMESTAMP,
"open" DOUBLE,
"high" DOUBLE,
"low" DOUBLE,
"close" DOUBLE,
"adj_close" DOUBLE,
"volume" BIGINT,
"symbol" VARCHAR,
"sector" VARCHAR,
"industry" VARCHAR,
"market" VARCHAR,
"quotetype" VARCHAR,
"dividend_yield" DOUBLE,
"debt_to_equity_ratio" VARCHAR,
"current_ratio" DOUBLE,
"earning_per_share" DOUBLE,
"variability_index" DOUBLE
);
CREATE TABLE likhitha (
"date" TIMESTAMP,
"open" DOUBLE,
"high" DOUBLE,
"low" DOUBLE,
"close" DOUBLE,
"adj_close" DOUBLE,
"volume" BIGINT,
"symbol" VARCHAR,
"sector" VARCHAR,
"industry" VARCHAR,
"market" VARCHAR,
"quotetype" VARCHAR,
"dividend_yield" DOUBLE,
"debt_to_equity_ratio" VARCHAR,
"current_ratio" DOUBLE,
"earning_per_share" DOUBLE,
"variability_index" DOUBLE
);
CREATE TABLE linc (
"date" TIMESTAMP,
"open" DOUBLE,
"high" DOUBLE,
"low" DOUBLE,
"close" DOUBLE,
"adj_close" DOUBLE,
"volume" BIGINT,
"symbol" VARCHAR,
"sector" VARCHAR,
"industry" VARCHAR,
"market" VARCHAR,
"quotetype" VARCHAR,
"dividend_yield" DOUBLE,
"debt_to_equity_ratio" DOUBLE,
"current_ratio" DOUBLE,
"earning_per_share" DOUBLE,
"variability_index" DOUBLE
);
CREATE TABLE lincoln (
"date" TIMESTAMP,
"open" DOUBLE,
"high" DOUBLE,
"low" DOUBLE,
"close" DOUBLE,
"adj_close" DOUBLE,
"volume" BIGINT,
"symbol" VARCHAR,
"sector" VARCHAR,
"industry" VARCHAR,
"market" VARCHAR,
"quotetype" VARCHAR,
"dividend_yield" DOUBLE,
"debt_to_equity_ratio" DOUBLE,
"current_ratio" DOUBLE,
"earning_per_share" DOUBLE,
"variability_index" DOUBLE
);
Anyone who has the link will be able to view this.