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 penind (
"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 peninland (
"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 persistent (
"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 petronet (
"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 pfc (
"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 pfizer (
"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 pfocus (
"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 pfs (
"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 pgel (
"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 pghh (
"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" VARCHAR,
"earning_per_share" DOUBLE,
"variability_index" DOUBLE
);
CREATE TABLE pghl (
"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" VARCHAR,
"earning_per_share" DOUBLE,
"variability_index" DOUBLE
);
CREATE TABLE pgil (
"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 phoenixltd (
"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 pidilitind (
"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 pigl (
"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 piind (
"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 pilaniinvs (
"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 pilita (
"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 pioneeremb (
"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 pittieng (
"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 pixtrans (
"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 pktea (
"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 plastiblen (
"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 platind (
"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" VARCHAR,
"variability_index" DOUBLE
);
CREATE TABLE plazacable (
"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
);
Anyone who has the link will be able to view this.