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 monarch (
"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 montecarlo (
"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 morepenlab (
"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 motherson (
"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 motilalofs (
"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 motisons (
"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 motogenfin (
"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 mphasis (
"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 mpsltd (
"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 mptoday (
"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 mrf (
"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 mro_tek (
"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 mrpl (
"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 mspl (
"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 mstcltd (
"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 msumi (
"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 mtartech (
"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 mteducare (
"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 mtnl (
"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" DOUBLE,
"earning_per_share" DOUBLE,
"variability_index" DOUBLE
);
CREATE TABLE mufin (
"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 mufti (
"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 mukandltd (
"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 mukka (
"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 muktaarts (
"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" DOUBLE,
"earning_per_share" DOUBLE,
"variability_index" DOUBLE
);
CREATE TABLE munjalau (
"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.