20 Years Indian Stock Market Data
Two Decades of Movements: Daily Closing Prices of Stocks (FY 03-24)
@kaggle.ishan2608_20_years_indian_stock_market_data
Two Decades of Movements: Daily Closing Prices of Stocks (FY 03-24)
@kaggle.ishan2608_20_years_indian_stock_market_data
CREATE TABLE all_20_yrs_data (
"date" VARCHAR,
"n_3mindia" DOUBLE,
"aartidrugs" DOUBLE,
"aartiind" DOUBLE,
"aban" DOUBLE,
"abb" DOUBLE,
"abbotindia" DOUBLE,
"acc" DOUBLE,
"accelya" DOUBLE,
"adanient" DOUBLE,
"adorweld" DOUBLE,
"agi" DOUBLE,
"ajantpharm" DOUBLE,
"akshoptfbr" DOUBLE,
"akzoindia" DOUBLE,
"alembicltd" DOUBLE,
"alokinds" DOUBLE,
"alpsindus" DOUBLE,
"ambicaagar" DOUBLE,
"ambujacem" DOUBLE,
"amjland" DOUBLE,
"andhrapap" DOUBLE,
"andhrsugar" DOUBLE,
"antgraphic" DOUBLE,
"aparinds" DOUBLE,
"apcotexind" DOUBLE,
"apollohosp" DOUBLE,
"apollotyre" DOUBLE,
"aptecht" DOUBLE,
"archies" DOUBLE,
"arvind" DOUBLE,
"asahiindia" DOUBLE,
"asal" DOUBLE,
"ashapurmin" DOUBLE,
"ashimasyn" DOUBLE,
"ashokley" DOUBLE,
"asianhotnr" DOUBLE,
"asianpaint" DOUBLE,
"astramicro" DOUBLE,
"astrazen" DOUBLE,
"atfl" DOUBLE,
"atul" DOUBLE,
"auropharma" DOUBLE,
"ausoment" DOUBLE,
"autoaxles" DOUBLE,
"axisbank" DOUBLE,
"axiscades" DOUBLE,
"bagfilms" DOUBLE,
"bajaj_auto" DOUBLE,
"bajajfinsv" DOUBLE,
"bajajhind" DOUBLE,
"bajajhldng" DOUBLE,
"bajfinance" DOUBLE,
"balajitele" DOUBLE,
"balmlawrie" DOUBLE,
"balramchin" DOUBLE,
"banarisug" DOUBLE,
"bankbaroda" DOUBLE,
"bankindia" DOUBLE,
"basf" DOUBLE,
"bataindia" DOUBLE,
"bbox" DOUBLE,
"bbtc" DOUBLE,
"bel" DOUBLE,
"beml" DOUBLE,
"bergepaint" DOUBLE,
"bhagyangr" DOUBLE,
"bharatforg" DOUBLE,
"bharatgear" DOUBLE,
"bharatras" DOUBLE,
"bhartiartl" DOUBLE,
"bhel" DOUBLE,
"bil" DOUBLE,
"binaniind" DOUBLE,
"biocon" DOUBLE,
"birlacable" DOUBLE,
"birlacorpn" DOUBLE,
"blblimited" DOUBLE,
"bluechip" DOUBLE,
"bluedart" DOUBLE,
"bluestarco" DOUBLE,
"bomdyeing" DOUBLE,
"boschltd" DOUBLE,
"bpcl" DOUBLE,
"bpl" DOUBLE,
"britannia" DOUBLE,
"bsl" DOUBLE,
"bsoft" DOUBLE,
"calsoft" DOUBLE,
"canbk" DOUBLE,
"canfinhome" DOUBLE,
"carboruniv" DOUBLE,
"castrolind" DOUBLE,
"ccl" DOUBLE,
"centenka" DOUBLE,
"centext" DOUBLE,
"centum" DOUBLE,
"centurytex" DOUBLE,
"cesc" DOUBLE,
"cgpower" DOUBLE
);
CREATE TABLE bse_stock_list (
"security_code" BIGINT,
"issuer_name" VARCHAR,
"security_id" VARCHAR,
"security_name" VARCHAR,
"status" VARCHAR,
"group" VARCHAR,
"face_value" DOUBLE,
"isin_no" VARCHAR,
"industry" VARCHAR,
"instrument" VARCHAR,
"sector_name" VARCHAR,
"industry_new_name" VARCHAR,
"igroup_name" VARCHAR,
"isubgroup_name" VARCHAR
);
CREATE TABLE combined_stock_data (
"date" VARCHAR,
"n_20microns" DOUBLE,
"n_21stcenmgm" DOUBLE,
"n_360one" DOUBLE,
"n_3iinfoltd" DOUBLE,
"n_3mindia" DOUBLE,
"n_3pland" DOUBLE,
"n_5paisa" DOUBLE,
"n_63moons" DOUBLE,
"a2zinfra" DOUBLE,
"aaatech" DOUBLE,
"aadharhfc" DOUBLE,
"aakash" DOUBLE,
"aareydrugs" DOUBLE,
"aaron" DOUBLE,
"aartech" DOUBLE,
"aartidrugs" DOUBLE,
"aartiind" DOUBLE,
"aartipharm" DOUBLE,
"aartisurf" DOUBLE,
"aarveeden" DOUBLE,
"aarvi" DOUBLE,
"aavas" DOUBLE,
"aban" DOUBLE,
"abb" DOUBLE,
"abbotindia" DOUBLE,
"abcapital" DOUBLE,
"abdl" DOUBLE,
"abfrl" DOUBLE,
"abmintlltd" DOUBLE,
"abslamc" DOUBLE,
"acc" DOUBLE,
"accelya" DOUBLE,
"accuracy" DOUBLE,
"ace" DOUBLE,
"aceinteg" DOUBLE,
"aci" DOUBLE,
"acl" DOUBLE,
"aclgati" DOUBLE,
"adaniensol" DOUBLE,
"adanient" DOUBLE,
"adanigreen" DOUBLE,
"adaniports" DOUBLE,
"adanipower" DOUBLE,
"adffoods" DOUBLE,
"adl" DOUBLE,
"adorweld" DOUBLE,
"adroitinfo" DOUBLE,
"adsl" DOUBLE,
"advanihotr" DOUBLE,
"advenzymes" DOUBLE,
"aegislog" DOUBLE,
"aeroflex" DOUBLE,
"aether" DOUBLE,
"affle" DOUBLE,
"afil" DOUBLE,
"agarind" DOUBLE,
"agi" DOUBLE,
"agiil" DOUBLE,
"agritech" DOUBLE,
"agrophos" DOUBLE,
"agstra" DOUBLE,
"ahl" DOUBLE,
"ahlada" DOUBLE,
"ahleast" DOUBLE,
"ahlucont" DOUBLE,
"aiaeng" DOUBLE,
"aiil" DOUBLE,
"airan" DOUBLE,
"airolam" DOUBLE,
"ajantpharm" DOUBLE,
"ajmera" DOUBLE,
"ajooni" DOUBLE,
"akash" DOUBLE,
"akg" DOUBLE,
"aki" DOUBLE,
"akshar" DOUBLE,
"aksharchem" DOUBLE,
"akshoptfbr" DOUBLE,
"akums" DOUBLE,
"akzoindia" DOUBLE,
"alankit" DOUBLE,
"albertdavd" DOUBLE,
"alembicltd" DOUBLE,
"alicon" DOUBLE,
"alkali" DOUBLE,
"alkem" DOUBLE,
"alkylamine" DOUBLE,
"allcargo" DOUBLE,
"allsec" DOUBLE,
"almondz" DOUBLE,
"alokinds" DOUBLE,
"alpa" DOUBLE,
"alphageo" DOUBLE,
"alpsindus" DOUBLE,
"amber" DOUBLE,
"ambicaagar" DOUBLE,
"ambikco" DOUBLE,
"ambujacem" DOUBLE,
"amdind" DOUBLE
);
CREATE TABLE gt_10_yrs_data (
"date" VARCHAR,
"n_20microns" DOUBLE,
"n_3iinfoltd" DOUBLE,
"n_3mindia" DOUBLE,
"n_3pland" DOUBLE,
"n_63moons" DOUBLE,
"a2zinfra" DOUBLE,
"aartidrugs" DOUBLE,
"aartiind" DOUBLE,
"aarveeden" DOUBLE,
"aban" DOUBLE,
"abb" DOUBLE,
"abbotindia" DOUBLE,
"abfrl" DOUBLE,
"acc" DOUBLE,
"accelya" DOUBLE,
"ace" DOUBLE,
"acl" DOUBLE,
"aclgati" DOUBLE,
"adanient" DOUBLE,
"adaniports" DOUBLE,
"adanipower" DOUBLE,
"adffoods" DOUBLE,
"adorweld" DOUBLE,
"adsl" DOUBLE,
"advanihotr" DOUBLE,
"agarind" DOUBLE,
"agi" DOUBLE,
"agritech" DOUBLE,
"ahleast" DOUBLE,
"ahlucont" DOUBLE,
"aiaeng" DOUBLE,
"ajantpharm" DOUBLE,
"ajmera" DOUBLE,
"akshoptfbr" DOUBLE,
"akzoindia" DOUBLE,
"alembicltd" DOUBLE,
"alicon" DOUBLE,
"alkali" DOUBLE,
"alkylamine" DOUBLE,
"allcargo" DOUBLE,
"allsec" DOUBLE,
"almondz" DOUBLE,
"alokinds" DOUBLE,
"alpa" DOUBLE,
"alphageo" DOUBLE,
"alpsindus" DOUBLE,
"ambicaagar" DOUBLE,
"ambikco" DOUBLE,
"ambujacem" DOUBLE,
"amdind" DOUBLE,
"amjland" DOUBLE,
"amrutanjan" DOUBLE,
"anantraj" DOUBLE,
"andhrapap" DOUBLE,
"andhrsugar" DOUBLE,
"anikinds" DOUBLE,
"ansalapi" DOUBLE,
"antgraphic" DOUBLE,
"aparinds" DOUBLE,
"apcotexind" DOUBLE,
"aplapollo" DOUBLE,
"aplltd" DOUBLE,
"apollohosp" DOUBLE,
"apollotyre" DOUBLE,
"aptecht" DOUBLE,
"archidply" DOUBLE,
"archies" DOUBLE,
"aries" DOUBLE,
"arogranite" DOUBLE,
"arssinfra" DOUBLE,
"arvind" DOUBLE,
"asahiindia" DOUBLE,
"asahisong" DOUBLE,
"asal" DOUBLE,
"ashapurmin" DOUBLE,
"ashiana" DOUBLE,
"ashimasyn" DOUBLE,
"ashoka" DOUBLE,
"ashokley" DOUBLE,
"asianhotnr" DOUBLE,
"asianpaint" DOUBLE,
"asiantiles" DOUBLE,
"asms" DOUBLE,
"astec" DOUBLE,
"astral" DOUBLE,
"astramicro" DOUBLE,
"astrazen" DOUBLE,
"atfl" DOUBLE,
"atlantaa" DOUBLE,
"atul" DOUBLE,
"atulauto" DOUBLE,
"aurionpro" DOUBLE,
"auropharma" DOUBLE,
"ausoment" DOUBLE,
"autoaxles" DOUBLE,
"autoind" DOUBLE,
"avantifeed" DOUBLE,
"avtnpl" DOUBLE,
"axisbank" DOUBLE
);
CREATE TABLE nse_stock_list (
"symbol" VARCHAR,
"name_of_company" VARCHAR,
"n__series" VARCHAR,
"n__date_of_listing" TIMESTAMP,
"n__paid_up_value" BIGINT,
"n__market_lot" BIGINT,
"n__isin_number" VARCHAR,
"n__face_value" BIGINT
);
Anyone who has the link will be able to view this.