text: INSERT INTO stocks (symbol,security_name,active,sector_id,last_modified_by,created_at,updated_at) VALUES
  	 ('ADBL','Agriculture Development Bank Limited',1,4,NULL,'2020-11-28 11:25:29.0','2020-11-28 11:25:29.0'),
  	 ('AHPC','Arun Valley Hydropower Development Co. Ltd.',1,1,NULL,'2020-11-28 11:25:29.0','2020-11-28 11:25:29.0'),
  	 ('AIL','Ajod Insurance Limited',1,7,NULL,'2020-11-28 11:25:29.0','2020-11-28 11:25:29.0'),
  	 ('AKJCL','Ankhu Khola Jalvidhyut Company Ltd',1,1,NULL,'2020-11-28 11:25:29.0','2020-11-28 11:25:29.0'),
  	 ('AKPL','Arun Kabeli Power Ltd.',1,1,NULL,'2020-11-28 11:25:29.0','2020-11-28 11:25:29.0'),
  	 ('ALBSL','Asha Laghubitta Bittiya Sanstha Ltd',1,8,NULL,'2020-11-28 11:25:29.0','2020-11-28 11:25:29.0'),
  	 ('ALICL','Asian Life Insurance Co. Limited',1,6,NULL,'2020-11-28 11:25:29.0','2020-11-28 11:25:29.0'),
  	 ('API','Api Power Company Ltd.',1,1,NULL,'2020-11-28 11:25:29.0','2020-11-28 11:25:29.0'),
  	 ('BARUN','Barun Hydropower Co. Ltd.',1,1,NULL,'2020-11-28 11:25:29.0','2020-11-28 11:25:29.0'),
  	 ('BBC','Bishal Bazar Company Limited',1,14,NULL,'2020-11-28 11:25:29.0','2020-11-28 11:25:29.0');
  INSERT INTO stocks (symbol,security_name,active,sector_id,last_modified_by,created_at,updated_at) VALUES
  	 ('BFC','Best Finance Company Ltd.',1,9,NULL,'2020-11-28 11:25:29.0','2020-11-28 11:25:29.0'),
  	 ('BNT','Bottlers Nepal (Terai) Limited',1,13,NULL,'2020-11-28 11:25:29.0','2020-11-28 11:25:29.0'),
  	 ('BOKL','Bank of Kathmandu Ltd.',1,4,NULL,'2020-11-28 11:25:29.0','2020-11-28 11:25:29.0'),
  	 ('BPCL','Butwal Power Company Limited',1,1,NULL,'2020-11-28 11:25:29.0','2020-11-28 11:25:29.0'),
  	 ('CBBL','Chhimek Laghubitta Bikas Bank Limited',1,8,NULL,'2020-11-28 11:25:29.0','2020-11-28 11:25:29.0'),
  	 ('CBL','Civil Bank Ltd',1,4,NULL,'2020-11-28 11:25:30.0','2020-11-28 11:25:30.0'),
  	 ('CCBL','Century Commercial Bank Ltd.',1,4,NULL,'2020-11-28 11:25:30.0','2020-11-28 11:25:30.0'),
  	 ('CFCL','Central Finance Co. Ltd.',1,9,NULL,'2020-11-28 11:25:30.0','2020-11-28 11:25:30.0'),
  	 ('CHCL','Chilime Hydropower Company Limited',1,1,NULL,'2020-11-28 11:25:30.0','2020-11-28 11:25:30.0'),
  	 ('CHL','Chhyangdi Hydropower Ltd.',1,1,NULL,'2020-11-28 11:25:30.0','2020-11-28 11:25:30.0');
  INSERT INTO stocks (symbol,security_name,active,sector_id,last_modified_by,created_at,updated_at) VALUES
  	 ('CIT','Citizen Investment Trust',1,16,NULL,'2020-11-28 11:25:30.0','2020-11-28 11:25:30.0'),
  	 ('CLBSL','Civil Laghubitta Bittiya Sanstha Ltd.',1,8,NULL,'2020-11-28 11:25:30.0','2020-11-28 11:25:30.0'),
  	 ('CMF1','Citizens Mutual Fund -1',1,12,NULL,'2020-11-28 11:25:30.0','2020-11-28 11:25:30.0'),
  	 ('CMF2','CITIZENS MUTUAL FUND 2',1,12,NULL,'2020-11-28 11:25:30.0','2020-11-28 11:25:30.0'),
  	 ('CORBL','Corporate Development Bank Limited',1,5,NULL,'2020-11-28 11:25:30.0','2020-11-28 11:25:30.0'),
  	 ('CZBIL','Citizen Bank International Limited',1,4,NULL,'2020-11-28 11:25:30.0','2020-11-28 11:25:30.0'),
  	 ('DDBL','Deprosc Laghubitta Bittiya Sanstha Limited',1,8,NULL,'2020-11-28 11:25:30.0','2020-11-28 11:25:30.0'),
  	 ('DHPL','Dibyashwori Hydropower Ltd.',1,1,NULL,'2020-11-28 11:25:30.0','2020-11-28 11:25:30.0'),
  	 ('EBL','Everest Bank Limited',1,4,NULL,'2020-11-28 11:25:30.0','2020-11-28 11:25:30.0'),
  	 ('EBLCP','Everest Bank Limited Con. Pref.',1,15,NULL,'2020-11-28 11:25:30.0','2020-11-28 11:25:30.0');
  INSERT INTO stocks (symbol,security_name,active,sector_id,last_modified_by,created_at,updated_at) VALUES
  	 ('EDBL','Excel Development Bank Ltd.',1,5,NULL,'2020-11-28 11:25:30.0','2020-11-28 11:25:30.0'),
  	 ('EIC','Everest Insurance Co. Ltd.',1,7,NULL,'2020-11-28 11:25:30.0','2020-11-28 11:25:30.0'),
  	 ('EICPO','Everest Insurance Co. Ltd. Promoter Share',1,NULL,NULL,'2020-11-28 11:25:30.0','2020-11-28 11:25:30.0'),
  	 ('FMDBL','First Micro Finance Development Bank Ltd.',1,8,NULL,'2020-11-28 11:25:30.0','2020-11-28 11:25:30.0'),
  	 ('FOWAD','Forward Community Microfinance Bittiya Sanstha Ltd.',1,8,NULL,'2020-11-28 11:25:30.0','2020-11-28 11:25:30.0'),
  	 ('GBBL','Garima Bikas Bank Limited',1,5,NULL,'2020-11-28 11:25:30.0','2020-11-28 11:25:30.0'),
  	 ('GBIME','Global IME Bank Limited',1,4,NULL,'2020-11-28 11:25:30.0','2020-11-28 11:25:30.0'),
  	 ('GBLBS','Grameen Bikas Laghubitta Bittiya Sanstha Ltd.',1,8,NULL,'2020-11-28 11:25:30.0','2020-11-28 11:25:30.0'),
  	 ('GFCL','Goodwill Finance Co. Ltd.',1,9,NULL,'2020-11-28 11:25:30.0','2020-11-28 11:25:30.0'),
  	 ('GHL','Ghalemdi Hydro Limited',1,1,NULL,'2020-11-28 11:25:30.0','2020-11-28 11:25:30.0');
  INSERT INTO stocks (symbol,security_name,active,sector_id,last_modified_by,created_at,updated_at) VALUES
  	 ('GIC','General Insurance Company Nepal Ltd',1,7,NULL,'2020-11-28 11:25:30.0','2020-11-28 11:25:30.0'),
  	 ('GILB','Global IME Laghubitta Bittiya Sanstha Ltd.',1,8,NULL,'2020-11-28 11:25:30.0','2020-11-28 11:25:30.0'),
  	 ('GIMES1','Global IME Samunnat Scheme-1',1,12,NULL,'2020-11-28 11:25:30.0','2020-11-28 11:25:30.0'),
  	 ('GLBSL','Gurans Laghubitta Bittiya Sanstha Limited',1,8,NULL,'2020-11-28 11:25:30.0','2020-11-28 11:25:30.0'),
  	 ('GLICL','Gurans Life Insurance Company Ltd.',1,6,NULL,'2020-11-28 11:25:30.0','2020-11-28 11:25:30.0'),
  	 ('GMFBS','Ganapati Microfinance Bittiya Sanstha Limited',1,8,NULL,'2020-11-28 11:25:30.0','2020-11-28 11:25:30.0'),
  	 ('GMFIL','Guheshowori Merchant Bank & Finance Co. Ltd.',1,9,NULL,'2020-11-28 11:25:30.0','2020-11-28 11:25:30.0'),
  	 ('GRDBL','Green Development Bank Ltd.',1,5,NULL,'2020-11-28 11:25:30.0','2020-11-28 11:25:30.0'),
  	 ('GUFL','Gurkhas Finance Ltd.',1,9,NULL,'2020-11-28 11:25:30.0','2020-11-28 11:25:30.0'),
  	 ('HBL','Himalayan Bank Limited',1,4,NULL,'2020-11-28 11:25:30.0','2020-11-28 11:25:30.0');
  INSERT INTO stocks (symbol,security_name,active,sector_id,last_modified_by,created_at,updated_at) VALUES
  	 ('HDHPC','Himal Dolakha Hydropower Company Limited',1,1,NULL,'2020-11-28 11:25:30.0','2020-11-28 11:25:30.0'),
  	 ('HDL','Himalayan Distillery Limited',1,13,NULL,'2020-11-28 11:25:30.0','2020-11-28 11:25:30.0'),
  	 ('HGI','Himalayan General Insurance Co. Ltd',1,7,NULL,'2020-11-28 11:25:30.0','2020-11-28 11:25:30.0'),
  	 ('HIDCL','Hydorelectricity Investment and Development Company Ltd',1,16,NULL,'2020-11-28 11:25:30.0','2020-11-28 11:25:30.0'),
  	 ('HPPL','Himalayan Power Partner Ltd.',1,1,NULL,'2020-11-28 11:25:30.0','2020-11-28 11:25:30.0'),
  	 ('HURJA','Himalaya Urja Bikas Company Limited',1,1,NULL,'2020-11-28 11:25:30.0','2020-11-28 11:25:30.0'),
  	 ('ICFC','ICFC Finance Limited',1,9,NULL,'2020-11-28 11:25:30.0','2020-11-28 11:25:30.0'),
  	 ('IGI','IME General Insurance Ltd.',1,7,NULL,'2020-11-28 11:25:30.0','2020-11-28 11:25:30.0'),
  	 ('ILBS','Infinity Laghubitta Bittiya Sanstha Limited',1,8,NULL,'2020-11-28 11:25:30.0','2020-11-28 11:25:30.0'),
  	 ('JBBL','Jyoti Bikas Bank Limited',1,5,NULL,'2020-11-28 11:25:30.0','2020-11-28 11:25:30.0');
  INSERT INTO stocks (symbol,security_name,active,sector_id,last_modified_by,created_at,updated_at) VALUES
  	 ('JFL','Janaki Finance Ltd.',1,9,NULL,'2020-11-28 11:25:30.0','2020-11-28 11:25:30.0'),
  	 ('JOSHI','Joshi Hydropower Development Company Ltd',1,1,NULL,'2020-11-28 11:25:30.0','2020-11-28 11:25:30.0'),
  	 ('JSLBB','Janautthan Samudayic Laghubitta Bikas Bank Ltd.',1,8,NULL,'2020-11-28 11:25:30.0','2020-11-28 11:25:30.0'),
  	 ('KBL','Kumari Bank Limited',1,4,NULL,'2020-11-28 11:25:30.0','2020-11-28 11:25:30.0'),
  	 ('KBLPO','Kumari Bank Limited Promotor Share',1,NULL,NULL,'2020-11-28 11:25:30.0','2020-11-28 11:25:30.0'),
  	 ('KKHC','Khanikhola Hydropower Co. Ltd.',1,1,NULL,'2020-11-28 11:25:30.0','2020-11-28 11:25:30.0'),
  	 ('KMCDB','Kalika Microcredit Development Bank Ltd.',1,8,NULL,'2020-11-28 11:25:30.0','2020-11-28 11:25:30.0'),
  	 ('KPCL','Kalika power Company Ltd',1,1,NULL,'2020-11-28 11:25:30.0','2020-11-28 11:25:30.0'),
  	 ('KRBL','Karnali Development Bank Limited',1,5,NULL,'2020-11-28 11:25:30.0','2020-11-28 11:25:30.0'),
  	 ('KSBBL','Kamana Sewa Bikas Bank Limited',1,5,NULL,'2020-11-28 11:25:30.0','2020-11-28 11:25:30.0');
  INSERT INTO stocks (symbol,security_name,active,sector_id,last_modified_by,created_at,updated_at) VALUES
  	 ('LBBL','Lumbini Bikas Bank Ltd.',1,5,NULL,'2020-11-28 11:25:30.0','2020-11-28 11:25:30.0'),
  	 ('LBL','Laxmi Bank Limited',1,4,NULL,'2020-11-28 11:25:30.0','2020-11-28 11:25:30.0'),
  	 ('LEC','Liberty Energy Company Limited',1,1,NULL,'2020-11-28 11:25:30.0','2020-11-28 11:25:30.0'),
  	 ('LEMF','Laxmi Equity Fund',1,12,NULL,'2020-11-28 11:25:30.0','2020-11-28 11:25:30.0'),
  	 ('LGIL','Lumbini General Insurance Co. Ltd.',1,7,NULL,'2020-11-28 11:25:30.0','2020-11-28 11:25:30.0'),
  	 ('LGILPO','Lumbini General Insurance Co. Ltd. Promoter Share',1,NULL,NULL,'2020-11-28 11:25:30.0','2020-11-28 11:25:30.0'),
  	 ('LICN','Life Insurance Co. Nepal',1,6,NULL,'2020-11-28 11:25:30.0','2020-11-28 11:25:30.0'),
  	 ('LLBS','Laxmi Laghubitta Bittiya Sanstha Ltd.',1,8,NULL,'2020-11-28 11:25:30.0','2020-11-28 11:25:30.0'),
  	 ('LUK','Laxmi Unnati Kosh',1,12,NULL,'2020-11-28 11:25:31.0','2020-11-28 11:25:31.0'),
  	 ('MBL','Machhapuchhre Bank Limited',1,4,NULL,'2020-11-28 11:25:31.0','2020-11-28 11:25:31.0');
  INSERT INTO stocks (symbol,security_name,active,sector_id,last_modified_by,created_at,updated_at) VALUES
  	 ('MDB','Miteri Development Bank Limited',1,5,NULL,'2020-11-28 11:25:31.0','2020-11-28 11:25:31.0'),
  	 ('MEGA','Mega  Bank Nepal Ltd.',1,4,NULL,'2020-11-28 11:25:31.0','2020-11-28 11:25:31.0'),
  	 ('MEGAPO','Mega  Bank Nepal Ltd. Promoter Share',1,NULL,NULL,'2020-11-28 11:25:31.0','2020-11-28 11:25:31.0'),
  	 ('MERO','Mero Microfinance Bittiya Sanstha Ltd.',1,8,NULL,'2020-11-28 11:25:31.0','2020-11-28 11:25:31.0'),
  	 ('MFIL','Manjushree Finance Ltd.',1,9,NULL,'2020-11-28 11:25:31.0','2020-11-28 11:25:31.0'),
  	 ('MHNL','Mountain Hydro Nepal Limited',1,1,NULL,'2020-11-28 11:25:31.0','2020-11-28 11:25:31.0'),
  	 ('MLBBL','Mithila LaghuBitta Bittiya Sanstha Limited',1,8,NULL,'2020-11-28 11:25:31.0','2020-11-28 11:25:31.0'),
  	 ('MLBL','Mahalaxmi Bikas Bank Ltd.',1,5,NULL,'2020-11-28 11:25:31.0','2020-11-28 11:25:31.0'),
  	 ('MMFDB','Mirmire Microfinance Development Bank Ltd.',1,8,NULL,'2020-11-28 11:25:31.0','2020-11-28 11:25:31.0'),
  	 ('MNBBL','Muktinath Bikas Bank Ltd.',1,5,NULL,'2020-11-28 11:25:31.0','2020-11-28 11:25:31.0');
  INSERT INTO stocks (symbol,security_name,active,sector_id,last_modified_by,created_at,updated_at) VALUES
  	 ('MPFL','Multipurpose Finance Company  Limited',1,9,NULL,'2020-11-28 11:25:31.0','2020-11-28 11:25:31.0'),
  	 ('MSMBS','Mahila Sahayatra Microfinance Bittiya Sanstha Ltd.',1,8,NULL,'2020-11-28 11:25:31.0','2020-11-28 11:25:31.0'),
  	 ('NABIL','Nabil Bank Limited',1,4,NULL,'2020-11-28 11:25:31.0','2020-11-28 11:25:31.0'),
  	 ('NADEP','Nadep Laghubittiya bittya Sanstha Ltd.',1,8,NULL,'2020-11-28 11:25:31.0','2020-11-28 11:25:31.0'),
  	 ('NBB','Nepal Bangladesh Bank Limited',1,4,NULL,'2020-11-28 11:25:31.0','2020-11-28 11:25:31.0'),
  	 ('NBF2','NABIL BALANCED FUND-2',1,12,NULL,'2020-11-28 11:25:31.0','2020-11-28 11:25:31.0'),
  	 ('NBL','Nepal Bank Limited',1,4,NULL,'2020-11-28 11:25:31.0','2020-11-28 11:25:31.0'),
  	 ('NCCB','Nepal Credit And Commercial Bank Limited',1,4,NULL,'2020-11-28 11:25:31.0','2020-11-28 11:25:31.0'),
  	 ('NCCBPO','Nepal Credit & Commercial Bank Ltd. Promoter Share',1,NULL,NULL,'2020-11-28 11:25:31.0','2020-11-28 11:25:31.0'),
  	 ('NEF','Nabil Equity Fund',1,12,NULL,'2020-11-28 11:25:31.0','2020-11-28 11:25:31.0');
  INSERT INTO stocks (symbol,security_name,active,sector_id,last_modified_by,created_at,updated_at) VALUES
  	 ('NFS','Nepal Finance Ltd.',1,9,NULL,'2020-11-28 11:25:31.0','2020-11-28 11:25:31.0'),
  	 ('NGPL','Ngadi Group Power Ltd.',1,1,NULL,'2020-11-28 11:25:31.0','2020-11-28 11:25:31.0'),
  	 ('NHDL','Nepal Hydro Developers Ltd.',1,1,NULL,'2020-11-28 11:25:31.0','2020-11-28 11:25:31.0'),
  	 ('NHPC','National Hydro Power Company Limited',1,1,NULL,'2020-11-28 11:25:31.0','2020-11-28 11:25:31.0'),
  	 ('NIB','Nepal Investment Bank Limited',1,4,NULL,'2020-11-28 11:25:31.0','2020-11-28 11:25:31.0'),
  	 ('NIBLPF','NIBL Pragati Fund',1,12,NULL,'2020-11-28 11:25:31.0','2020-11-28 11:25:31.0'),
  	 ('NIBPO','Nepal Investment Bank Ltd. Promoter Share',1,NULL,NULL,'2020-11-28 11:25:31.0','2020-11-28 11:25:31.0'),
  	 ('NIBSF1','NIBL Samriddhi Fund 1',1,12,NULL,'2020-11-28 11:25:31.0','2020-11-28 11:25:31.0'),
  	 ('NICA','NIC Asia Bank Ltd.',1,4,NULL,'2020-11-28 11:25:31.0','2020-11-28 11:25:31.0'),
  	 ('NICAD8283','11% NIC Asia Debenture 082/83',1,2,NULL,'2020-11-28 11:25:31.0','2020-11-28 11:25:31.0');
  INSERT INTO stocks (symbol,security_name,active,sector_id,last_modified_by,created_at,updated_at) VALUES
  	 ('NICBF','NIC Asia Balanced Fund',1,12,NULL,'2020-11-28 11:25:31.0','2020-11-28 11:25:31.0'),
  	 ('NICGF','NIC Asia Growth Fund',1,12,NULL,'2020-11-28 11:25:31.0','2020-11-28 11:25:31.0'),
  	 ('NICL','Nepal Insurance Co. Ltd.',1,7,NULL,'2020-11-28 11:25:31.0','2020-11-28 11:25:31.0'),
  	 ('NIL','Neco Insurance Co. Ltd.',1,7,NULL,'2020-11-28 11:25:31.0','2020-11-28 11:25:31.0'),
  	 ('NLBBL','Nerude Laghubita Bikas Bank Limited',1,8,NULL,'2020-11-28 11:25:31.0','2020-11-28 11:25:31.0'),
  	 ('NLBSL','NRN Lagubitta Bittiya Sanstha Limited',1,8,NULL,'2020-11-28 11:25:31.0','2020-11-28 11:25:31.0'),
  	 ('NLG','NLG Insurance Company Ltd.',1,7,NULL,'2020-11-28 11:25:31.0','2020-11-28 11:25:31.0'),
  	 ('NLIC','Nepal Life Insurance Co. Ltd.',1,6,NULL,'2020-11-28 11:25:31.0','2020-11-28 11:25:31.0'),
  	 ('NLICL','National Life Insurance Co. Ltd.',1,6,NULL,'2020-11-28 11:25:31.0','2020-11-28 11:25:31.0'),
  	 ('NMB','NMB Bank Limited',1,4,NULL,'2020-11-28 11:25:31.0','2020-11-28 11:25:31.0');
  INSERT INTO stocks (symbol,security_name,active,sector_id,last_modified_by,created_at,updated_at) VALUES
  	 ('NMB50','NMB 50',1,12,NULL,'2020-11-28 11:25:31.0','2020-11-28 11:25:31.0'),
  	 ('NMBHF1','NMB Hybrid Fund L-1',1,12,NULL,'2020-11-28 11:25:31.0','2020-11-28 11:25:31.0'),
  	 ('NMBMF','NMB  Microfinance Bittiya Sanstha Ltd.',1,8,NULL,'2020-11-28 11:25:31.0','2020-11-28 11:25:31.0'),
  	 ('NMFBS','National Microfinance Bittiya Sanstha Ltd.',1,8,NULL,'2020-11-28 11:25:31.0','2020-11-28 11:25:31.0'),
  	 ('NRIC','Nepal Reinsurance Company Limited',1,16,NULL,'2020-11-28 11:25:31.0','2020-11-28 11:25:31.0'),
  	 ('NRN','NRN Infrastructure and Development Limited',1,16,NULL,'2020-11-28 11:25:31.0','2020-11-28 11:25:31.0'),
  	 ('NSEWA','Nepal Seva Laghubitta Bittiya Sanstha Ltd.',1,8,NULL,'2020-11-28 11:25:31.0','2020-11-28 11:25:31.0'),
  	 ('NTC','Nepal Doorsanchar Comapany Limited',1,16,NULL,'2020-11-28 11:25:31.0','2020-11-28 11:25:31.0'),
  	 ('NUBL','Nirdhan Utthan Laghubitta Bittiya Sanstha Limited',1,8,NULL,'2020-11-28 11:25:31.0','2020-11-28 11:25:31.0'),
  	 ('OHL','Oriental Hotels Limited',1,3,NULL,'2020-11-28 11:25:31.0','2020-11-28 11:25:31.0');
  INSERT INTO stocks (symbol,security_name,active,sector_id,last_modified_by,created_at,updated_at) VALUES
  	 ('PBLD84','10% Prabhu Bank Debenture 2084 ',1,2,NULL,'2020-11-28 11:25:31.0','2020-11-28 11:25:31.0'),
  	 ('PCBL','Prime Commercial Bank Ltd.',1,4,NULL,'2020-11-28 11:25:31.0','2020-11-28 11:25:31.0'),
  	 ('PFL','Pokhara Finance Ltd.',1,9,NULL,'2020-11-28 11:25:31.0','2020-11-28 11:25:31.0'),
  	 ('PIC','Premier Insurance Co. Ltd.',1,7,NULL,'2020-11-28 11:25:31.0','2020-11-28 11:25:31.0'),
  	 ('PICL','Prudential Insurance Co. Ltd.',1,7,NULL,'2020-11-28 11:25:31.0','2020-11-28 11:25:31.0'),
  	 ('PICLPO','Prudential Insurance Co. Ltd. Promoter Share',1,NULL,NULL,'2020-11-28 11:25:31.0','2020-11-28 11:25:31.0'),
  	 ('PLIC','Prime Life Insurance Company Limited',1,6,NULL,'2020-11-28 11:25:31.0','2020-11-28 11:25:31.0'),
  	 ('PMHPL','Panchakanya Mai Hydropower Ltd',1,1,NULL,'2020-11-28 11:25:31.0','2020-11-28 11:25:31.0'),
  	 ('PPCL','Panchthar Power Compant Limited',1,1,NULL,'2020-11-28 11:25:31.0','2020-11-28 11:25:31.0'),
  	 ('PRIN','Prabhu Insurance Ltd.',1,7,NULL,'2020-11-28 11:25:31.0','2020-11-28 11:25:31.0');
  INSERT INTO stocks (symbol,security_name,active,sector_id,last_modified_by,created_at,updated_at) VALUES
  	 ('PROFL','ProgressiveFinance Limited',1,9,NULL,'2020-11-28 11:25:31.0','2020-11-28 11:25:31.0'),
  	 ('PRVU','Prabhu  Bank Limited',1,4,NULL,'2020-11-28 11:25:31.0','2020-11-28 11:25:31.0'),
  	 ('RADHI','Radhi Bidyut Company Ltd',1,1,NULL,'2020-11-28 11:25:31.0','2020-11-28 11:25:31.0'),
  	 ('RBCL','Rastriya Beema Company Limited',1,7,NULL,'2020-11-28 11:25:31.0','2020-11-28 11:25:31.0'),
  	 ('RBCLPO','Rastriya Beema Company Limited Promoter Share',1,NULL,NULL,'2020-11-28 11:25:32.0','2020-11-28 11:25:32.0'),
  	 ('RHPC','Ridi Hydropower Development Company Ltd.',1,1,NULL,'2020-11-28 11:25:32.0','2020-11-28 11:25:32.0'),
  	 ('RHPL','RASUWAGADHI HYDROPOWER COMPANY LIMITED',1,1,NULL,'2020-11-28 11:25:32.0','2020-11-28 11:25:32.0'),
  	 ('RLFL','Reliance Finance Ltd.',1,9,NULL,'2020-11-28 11:25:32.0','2020-11-28 11:25:32.0'),
  	 ('RLI','Reliance Life Insurance Limited',1,6,NULL,'2020-11-28 11:25:32.0','2020-11-28 11:25:32.0'),
  	 ('RMDC','RMDC Laghubitta Bittiya Sanstha Ltd.',1,8,NULL,'2020-11-28 11:25:32.0','2020-11-28 11:25:32.0');
  INSERT INTO stocks (symbol,security_name,active,sector_id,last_modified_by,created_at,updated_at) VALUES
  	 ('RRHP','Rairang Hydropower Development Company Ltd.',1,1,NULL,'2020-11-28 11:25:32.0','2020-11-28 11:25:32.0'),
  	 ('RSDC','RSDC Laghubitta Bittiya Sanstha Ltd.',1,8,NULL,'2020-11-28 11:25:32.0','2020-11-28 11:25:32.0'),
  	 ('SABSL','SABAIKO LAGHUBITTA BITTIYA SANSTHA LIMITED',1,8,NULL,'2020-11-28 11:25:32.0','2020-11-28 11:25:32.0'),
  	 ('SADBL','Shangrila Development Bank Ltd.',1,5,NULL,'2020-11-28 11:25:32.0','2020-11-28 11:25:32.0'),
  	 ('SAEF','Sanima Equity Fund',1,12,NULL,'2020-11-28 11:25:32.0','2020-11-28 11:25:32.0'),
  	 ('SAND2085','Sanima Bank Limited Debenture',1,2,NULL,'2020-11-28 11:25:32.0','2020-11-28 11:25:32.0'),
  	 ('SANIMA','Sanima Bank Limited',1,4,NULL,'2020-11-28 11:25:32.0','2020-11-28 11:25:32.0'),
  	 ('SAPDBL','Saptakoshi Development Bank Ltd',1,5,NULL,'2020-11-28 11:25:32.0','2020-11-28 11:25:32.0'),
  	 ('SBI','Nepal SBI Bank Limited',1,4,NULL,'2020-11-28 11:25:32.0','2020-11-28 11:25:32.0'),
  	 ('SBL','Siddhartha Bank Limited',1,4,NULL,'2020-11-28 11:25:32.0','2020-11-28 11:25:32.0');
  INSERT INTO stocks (symbol,security_name,active,sector_id,last_modified_by,created_at,updated_at) VALUES
  	 ('SCB','Standard Chartered Bank Limited',1,4,NULL,'2020-11-28 11:25:32.0','2020-11-28 11:25:32.0'),
  	 ('SDLBSL','Sadhana Laghubitta Bittiya Sanstha Limited',1,8,NULL,'2020-11-28 11:25:32.0','2020-11-28 11:25:32.0'),
  	 ('SEF','Siddhartha Equity Fund',1,12,NULL,'2020-11-28 11:25:32.0','2020-11-28 11:25:32.0'),
  	 ('SFCL','Samriddhi Finance Company Limited',1,9,NULL,'2020-11-28 11:25:32.0','2020-11-28 11:25:32.0'),
  	 ('SFMF','Sunrise First Mutual Fund',1,12,NULL,'2020-11-28 11:25:32.0','2020-11-28 11:25:32.0'),
  	 ('SGI','Sanima General Insurance Limited',1,7,NULL,'2020-11-28 11:25:32.0','2020-11-28 11:25:32.0'),
  	 ('SHINE','Shine Resunga Development Bank Ltd.',1,5,NULL,'2020-11-28 11:25:32.0','2020-11-28 11:25:32.0'),
  	 ('SHIVM','SHIVAM CEMENTS LTD',1,13,NULL,'2020-11-28 11:25:32.0','2020-11-28 11:25:32.0'),
  	 ('SHL','Soaltee Hotel Limited',1,3,NULL,'2020-11-28 11:25:32.0','2020-11-28 11:25:32.0'),
  	 ('SHPC','Sanima Mai Hydropower Ltd.',1,1,NULL,'2020-11-28 11:25:32.0','2020-11-28 11:25:32.0');
  INSERT INTO stocks (symbol,security_name,active,sector_id,last_modified_by,created_at,updated_at) VALUES
  	 ('SIC','Sagarmatha Insurance Co. Ltd.',1,7,NULL,'2020-11-28 11:25:32.0','2020-11-28 11:25:32.0'),
  	 ('SICL','Shikhar Insurance Co. Ltd.',1,7,NULL,'2020-11-28 11:25:32.0','2020-11-28 11:25:32.0'),
  	 ('SIFC','Shree Investment Finance Co. Ltd.',1,9,NULL,'2020-11-28 11:25:32.0','2020-11-28 11:25:32.0'),
  	 ('SIL','Siddhartha Insurance Ltd.',1,7,NULL,'2020-11-28 11:25:32.0','2020-11-28 11:25:32.0'),
  	 ('SINDU','Sindhu Bikash Bank Ltd',1,5,NULL,'2020-11-28 11:25:32.0','2020-11-28 11:25:32.0'),
  	 ('SJCL','SANJEN JALAVIDHYUT COMPANY LIMITED',1,1,NULL,'2020-11-28 11:25:32.0','2020-11-28 11:25:32.0'),
  	 ('SKBBL','Sana Kisan Bikas Bank Ltd',1,8,NULL,'2020-11-28 11:25:32.0','2020-11-28 11:25:32.0'),
  	 ('SLBBL','Swarojgar Laghu Bitta Bikas Bank Ltd.',1,8,NULL,'2020-11-28 11:25:32.0','2020-11-28 11:25:32.0'),
  	 ('SLBS','Suryodaya Laghubitta Bittiya Sanstha Ltd.',1,8,NULL,'2020-11-28 11:25:32.0','2020-11-28 11:25:32.0'),
  	 ('SLBSL','Samudayik Laghubitta Bittiya Sanstha Limited',1,8,NULL,'2020-11-28 11:25:32.0','2020-11-28 11:25:32.0');
  INSERT INTO stocks (symbol,security_name,active,sector_id,last_modified_by,created_at,updated_at) VALUES
  	 ('SLICL','Surya Life Insurance Company Limited',1,6,NULL,'2020-11-28 11:25:32.0','2020-11-28 11:25:32.0'),
  	 ('SMB','Support Microfinance Bittiya Sanstha Ltd.',1,8,NULL,'2020-11-28 11:25:32.0','2020-11-28 11:25:32.0'),
  	 ('SMFBS','Swabhimaan Laghubitta Bittiya Sanstha Limited',1,8,NULL,'2020-11-28 11:25:32.0','2020-11-28 11:25:32.0'),
  	 ('SMFDB','Summit Laghubitta Bittiya Sanstha Limited',1,8,NULL,'2020-11-28 11:25:32.0','2020-11-28 11:25:32.0'),
  	 ('SNLB','Sarathi Nepal Laghubitta Bittiya Sanstha Limited',1,8,NULL,'2020-11-28 11:25:32.0','2020-11-28 11:25:32.0'),
  	 ('SPDL','Synergy Power Development Ltd.',1,1,NULL,'2020-11-28 11:25:32.0','2020-11-28 11:25:32.0'),
  	 ('SRBL','Sunrise Bank Limited',1,4,NULL,'2020-11-28 11:25:32.0','2020-11-28 11:25:32.0'),
  	 ('SRBLD83','10.25% Sunrise Bank Debenture 2083',1,2,NULL,'2020-11-28 11:25:32.0','2020-11-28 11:25:32.0'),
  	 ('SSHL','Shiva Shree Hydropower Ltd',1,1,NULL,'2020-11-28 11:25:32.0','2020-11-28 11:25:32.0'),
  	 ('STC','Salt Trading Corporation',1,14,NULL,'2020-11-28 11:25:32.0','2020-11-28 11:25:32.0');
  INSERT INTO stocks (symbol,security_name,active,sector_id,last_modified_by,created_at,updated_at) VALUES
  	 ('SWBBL','Swabalamban Laghubitta Bittiya Sanstha Limited',1,8,NULL,'2020-11-28 11:25:32.0','2020-11-28 11:25:32.0'),
  	 ('TRH','Taragaon Regency Hotel Limited',1,3,NULL,'2020-11-28 11:25:32.0','2020-11-28 11:25:32.0'),
  	 ('UFL','United Finance Ltd.',1,9,NULL,'2020-11-28 11:25:32.0','2020-11-28 11:25:32.0'),
  	 ('UIC','United Insurance Co. (Nepal) Ltd.',1,7,NULL,'2020-11-28 11:25:32.0','2020-11-28 11:25:32.0'),
  	 ('UMHL','United Modi Hydropower Ltd.',1,1,NULL,'2020-11-28 11:25:32.0','2020-11-28 11:25:32.0'),
  	 ('UNHPL','Union Hydropower Limited',1,1,NULL,'2020-11-28 11:25:32.0','2020-11-28 11:25:32.0'),
  	 ('UNL','Unilever Nepal Limited',1,13,NULL,'2020-11-28 11:25:32.0','2020-11-28 11:25:32.0'),
  	 ('UPCL','UNIVERSAL POWER COMPANY LTD',1,1,NULL,'2020-11-28 11:25:32.0','2020-11-28 11:25:32.0'),
  	 ('UPPER','Upper Tamakoshi Hydropower Ltd',1,1,NULL,'2020-11-28 11:25:32.0','2020-11-28 11:25:32.0'),
  	 ('USLB','Unnati Sahakarya Laghubitta Bittiya Sanstha Limited',1,8,NULL,'2020-11-28 11:25:32.0','2020-11-28 11:25:32.0');
  INSERT INTO stocks (symbol,security_name,active,sector_id,last_modified_by,created_at,updated_at) VALUES
  	 ('VLBS','Vijaya laghubitta Bittiya Sanstha Ltd.',1,8,NULL,'2020-11-28 11:25:32.0','2020-11-28 11:25:32.0'),
  	 ('GBD80/81','10.25% GLOBAL IME BANK LTD. DEBENTURE 2080/81',1,2,NULL,'2020-11-30 12:33:59.0','2020-11-30 12:33:59.0'),
  	 ('MNBBLP','Muktinath Bikas Bank Ltd. Promoter Share',1,NULL,NULL,'2020-11-30 12:36:53.0','2020-11-30 12:36:53.0'),
  	 ('NLICP','Nepal Life Insurance Co. Ltd. Promoter',1,NULL,NULL,'2020-11-30 12:36:53.0','2020-11-30 12:36:53.0'),
  	 ('CCBLPO','Century Commercial Bank Ltd. Promoter Share',1,NULL,NULL,'2020-12-01 08:25:02.0','2020-12-01 08:25:02.0'),
  	 ('SBIBD86','10% Nepal SBI Bank Debenture 2086',1,NULL,NULL,'2020-12-01 08:25:03.0','2020-12-01 08:25:03.0'),
  	 ('NIBD2082','10.5 % NEPAL INVESTMENT DEBENTURE 2082',1,NULL,NULL,'2020-12-02 07:54:05.0','2020-12-02 07:54:05.0'),
  	 ('NLO','Nepal Lube Oil Limited',1,NULL,NULL,'2020-12-02 07:54:05.0','2020-12-02 07:54:05.0'),
  	 ('JBBLPO','Jyoti Bikash  Bank Ltd. Promoter Share',1,NULL,NULL,'2020-12-02 10:18:56.0','2020-12-02 10:18:56.0'),
  	 ('ALICLP','Asian Life Insurance Co. Ltd Promoter Share',1,NULL,NULL,'2020-12-03 09:59:45.0','2020-12-03 09:59:45.0');
  INSERT INTO stocks (symbol,security_name,active,sector_id,last_modified_by,created_at,updated_at) VALUES
  	 ('GBIMEP','Global IME Bank Ltd. Promoter Share',1,NULL,NULL,'2020-12-03 09:59:45.0','2020-12-03 09:59:45.0'),
  	 ('ICFCPO','ICFC Finance Limited Promotor Share',1,NULL,NULL,'2020-12-03 09:59:45.0','2020-12-03 09:59:45.0'),
  	 ('NABBC','Narayani Development Bank Limited',1,NULL,NULL,'2020-12-03 09:59:46.0','2020-12-03 09:59:46.0'),
  	 ('SBLPO','Siddhartha Bank Limited Promoter Share',1,NULL,NULL,'2020-12-03 09:59:46.0','2020-12-03 09:59:46.0'),
  	 ('TJVCL','à¤¤à¥�à¤°à¤¿à¤¶à¥�à¤²à¥€ à¤œà¤² à¤µà¤¿à¤¦à¥�à¤¯â€Œâ€�â€Œà¥�à¤¤ à¤†à¤¯à¥‹à¤œà¤¨à¤¾',1,1,NULL,NULL,NULL),
  	 ('HBLD83','10% Himalayan Bank Debenture 2083',1,NULL,NULL,'2020-12-06 09:44:03.0','2020-12-06 09:44:03.0'),
  	 ('KBLD86','10.25% KBL Debenture 2086',1,NULL,NULL,'2020-12-06 09:44:03.0','2020-12-06 09:44:03.0'),
  	 ('BOKLPO','Bank of Kathmandu Limited Promoter Share',1,NULL,NULL,'2020-12-07 13:08:34.0','2020-12-07 13:08:34.0'),
  	 ('NICD83/84','10.25% NIC Asia Debenture 2083/84',1,NULL,NULL,'2020-12-07 13:08:35.0','2020-12-07 13:08:35.0'),
  	 ('PRVUPO','Prabhu  Bank Limited Promoter Share',1,NULL,NULL,'2020-12-07 13:08:35.0','2020-12-07 13:08:35.0');
  INSERT INTO stocks (symbol,security_name,active,sector_id,last_modified_by,created_at,updated_at) VALUES
  	 ('RSDCP','RSDC Laghubitta Bittiya Sanstha Ltd. Promoter Share',1,NULL,NULL,'2020-12-07 13:08:35.0','2020-12-07 13:08:35.0'),
  	 ('CBLPO','Civil Bank Ltd Promoter Share',1,NULL,NULL,'2020-12-08 10:57:00.0','2020-12-08 10:57:00.0'),
  	 ('PCBLP','Prime Commercial Bank Promoter Share',1,NULL,NULL,'2020-12-08 10:57:01.0','2020-12-08 10:57:01.0'),
  	 ('MLBLPO','Mahalxmi Bikas Bank Ltd. Promotor Share',1,NULL,NULL,'2020-12-10 06:37:01.0','2020-12-10 06:37:01.0'),
  	 ('MSLB','Mahuli Samudayik Laghubitta Bittiya Sanstha Ltd.',1,NULL,NULL,'2020-12-13 13:17:22.0','2020-12-13 13:17:22.0'),
  	 ('SAPDBLP','Saptakoshi Development Bank Ltd Promoter Share',1,NULL,NULL,'2020-12-13 13:17:22.0','2020-12-13 13:17:22.0'),
  	 ('VLBSPO','Vijaya laghubitta Bittiya Sanstha Ltd. Promoter Share',1,NULL,NULL,'2020-12-14 07:21:00.0','2020-12-14 07:21:00.0'),
  	 ('NMBPO','NMB Bank Limited Promoter Share',1,NULL,NULL,'2020-12-15 10:20:22.0','2020-12-15 10:20:22.0'),
  	 ('PROFLP','Progressive Finance Limited Promoter Share',1,NULL,NULL,'2020-12-15 10:20:22.0','2020-12-15 10:20:22.0'),
  	 ('SLICLP','Surya Life Insurance Co. Ltd. Promoter Share',1,NULL,NULL,'2020-12-15 10:20:22.0','2020-12-15 10:20:22.0');
  INSERT INTO stocks (symbol,security_name,active,sector_id,last_modified_by,created_at,updated_at) VALUES
  	 ('MEN','Mountain Energy Nepal Limited',1,NULL,NULL,'2020-12-16 06:50:57.0','2020-12-16 06:50:57.0'),
  	 ('AKBSL','Adhikhola Laghubitta Bittiya Sanstha Limited',1,8,NULL,NULL,NULL),
  	 ('AMFI','Aarambha Laghubitta Bittiya Sanstha Limited',1,8,NULL,NULL,NULL),
  	 ('ACLBSL','Aarambha Chautari Laghubitta Bittiya Sanstha Limited',1,8,NULL,NULL,NULL),
  	 ('JEFL','Jebils Finance Limited',1,8,NULL,NULL,NULL),
  	 ('CNDBL','Country Development Bank Limited ',1,8,NULL,NULL,NULL);