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
);