INFY-NSE-DATA-2021-22
Infosys Shares data from the National Stock Exchange for the year 2021 & 2022
@kaggle.andrewgeorgeissac_infynsedata202122
Infosys Shares data from the National Stock Exchange for the year 2021 & 2022
@kaggle.andrewgeorgeissac_infynsedata202122
CREATE TABLE n_01_01_2021_to_31_12_2021infyalln (
"symbol" VARCHAR,
"series" VARCHAR,
"date" TIMESTAMP,
"prev_close" DOUBLE,
"open_price" DOUBLE,
"high_price" DOUBLE,
"low_price" DOUBLE,
"last_price" DOUBLE,
"close_price" DOUBLE,
"average_price" DOUBLE,
"total_traded_quantity" BIGINT,
"turnover" DOUBLE,
"no_of_trades" BIGINT,
"deliverable_qty" VARCHAR,
"n__dly_qt_to_traded_qty" VARCHAR
);
CREATE TABLE n_01_01_2022_to_30_12_2022infyalln (
"symbol" VARCHAR,
"series" VARCHAR,
"date" TIMESTAMP,
"prev_close" DOUBLE,
"open_price" DOUBLE,
"high_price" DOUBLE,
"low_price" DOUBLE,
"last_price" DOUBLE,
"close_price" DOUBLE,
"average_price" DOUBLE,
"total_traded_quantity" BIGINT,
"turnover" DOUBLE,
"no_of_trades" BIGINT,
"deliverable_qty" VARCHAR,
"n__dly_qt_to_traded_qty" VARCHAR
);
Anyone who has the link will be able to view this.