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 munjalshow (
"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 murudcera (
"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 muthootcap (
"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 muthootfin (
"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 muthootmf (
"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 mvgjl (
"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 naclind (
"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 nagafert (
"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" DOUBLE,
"variability_index" DOUBLE
);
CREATE TABLE nagreekcap (
"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 nagreekexp (
"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 naharcap (
"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 naharindus (
"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 naharpoly (
"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 naharsping (
"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 nakoda (
"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 nam_india (
"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 narmada (
"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 natcopharm (
"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 nathbiogen (
"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 nationalum (
"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 naukri (
"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 nava (
"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 navinfluor (
"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 navkarcorp (
"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 navnetedul (
"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.