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 ibrealest (
"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 ibulhsgfin (
"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 icdsltd (
"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 icemake (
"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 icicibank (
"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" VARCHAR,
"earning_per_share" DOUBLE,
"variability_index" DOUBLE
);
CREATE TABLE icicigi (
"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 icicipruli (
"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 icil (
"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 icra (
"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 idbi (
"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" VARCHAR,
"earning_per_share" DOUBLE,
"variability_index" DOUBLE
);
CREATE TABLE idea (
"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 ideaforge (
"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 idfc (
"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 idfcfirstb (
"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 iel (
"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 iex (
"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 ifbagro (
"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 ifbind (
"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 ifci (
"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 ifglexpor (
"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 igarashi (
"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 igl (
"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 igpl (
"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 iifl (
"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 iiflsec (
"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.