-
Notifications
You must be signed in to change notification settings - Fork 3
/
Entries.sql
300 lines (272 loc) · 21.1 KB
/
Entries.sql
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
190
191
192
193
194
195
196
197
198
199
200
201
202
203
204
205
206
207
208
209
210
211
212
213
214
215
216
217
218
219
220
221
222
223
224
225
226
227
228
229
230
231
232
233
234
235
236
237
238
239
240
241
242
243
244
245
246
247
248
249
250
251
252
253
254
255
256
257
258
259
260
261
262
263
264
265
266
267
268
269
270
271
272
273
274
275
276
277
278
279
280
281
282
283
284
285
286
287
288
289
290
291
292
293
294
295
296
297
298
299
300
INSERT INTO company (CIN , CName , CEO , Market_capital , Revenue ) VALUES
('L67120GJ1993PLC019050', 'Adani Enterprises Ltd', 'Gautam S. Adani', '₹1,91,219.69 Crore', '₹16,188.20 Crore'),
('L74999MH1992PLC069503', 'Larsen & Toubro Infotech Ltd', 'Sanjay Jalona', '₹89,439.88 Crore', '₹12,055.50 Crore'),
('L65921MH1986PLC040754', 'Shriram Transport Finance Company Ltd', 'Umesh Revankar', '₹36,791.26 Crore', '₹17,019.60 Crore'),
('L24239MH1983PLC029043', 'Apollo Hospitals Enterprise Ltd', 'Prathap C. Reddy', '₹89,270.86 Crore', '₹12,460.10 Crore'),
('L24100GJ1993PLC019050', 'Adani Ports & Special Economic Zone Ltd', 'Karan Adani', '₹1,91,219.69 Crore', '₹16,188.20 Crore'),
('L24246WB1945GOI017288', 'Asian Paints Ltd', 'Amit Syngle', '₹2,99,250.36 Crore', '₹20,527.70 Crore'),
('L65191MH1993PLC082610', 'Axis Bank Ltd', 'Amitabh Chaudhry', '₹2,25,162.88 Crore', '₹66,163.40 Crore'),
('L65910MH1986PLC041028', 'Bajaj Auto Ltd', 'Rajiv Bajaj', '₹1,06,764.69 Crore', '₹35,906.30 Crore'),
('L65910MH1987PLC042051', 'Bajaj Finance Ltd', 'Sanjiv Bajaj', '₹3,59,314.21 Crore', '₹34,502.10 Crore'),
('L65921PN1988PLC046493', 'Bajaj Finserv Ltd', 'Sanjiv Bajaj', '₹2,92,907.52 Crore', '₹24,139.10 Crore'),
('L74899DL1995PLC071405', 'Bharti Airtel Ltd', 'Gopal Vittal', '₹2,78,196.94 Crore', '₹88,956.80 Crore'),
('L23201MH1952GOI008858', 'Bharat Petroleum Corporation Ltd', 'Arvind Singh', '₹1,02,698.51 Crore', '₹2,54,477.80 Crore'),
('L15419WB1918PLC002964', 'Britannia Industries Ltd', 'Varun Berry', '₹1,05,648.96 Crore', '₹12,878.60 Crore'),
('L24239MH1984PLC031015', 'Cipla Ltd', 'Umang Vohra', '₹81,038.73 Crore', '₹17,126.00 Crore'),
('L10300DL1975GOI007966', 'Coal India Ltd', 'Pralhad Joshi', '₹1,75,182.56 Crore', '₹1,09,975.70 Crore'),
('L24110TG1990PLC011146', 'Divis Laboratories Ltd', 'Murali Divi', '₹1,70,018.05 Crore', '₹18,139.20 Crore'),
('L24230MH1984PLC080567', 'Dr. Reddys Laboratories Ltd', 'Erez Israeli', '₹98,168.35 Crore', '₹16,700.80 Crore'),
('L34102DL2009PLC191780', 'Eicher Motors Ltd', 'Vinod K. Dasari', '₹80,162.61 Crore', '₹10,833.50 Crore'),
('L17124MH1947PLC004717', 'Grasim Industries Ltd', 'Kumar Mangalam Birla', '₹1,01,156.98 Crore', '₹33,325.40 Crore'),
('L00060DL1991PLC064135', 'HCL Technologies Ltd', 'C. Vijayakumar', '₹2,84,587.16 Crore', '₹78,375.00 Crore'),
('L65920MH1994PLC080618', 'HDFC Bank Ltd', 'Sashidhar Jagdishan', '₹8,91,461.96 Crore', '₹1,53,961.30 Crore'),
('L25120MH2000PLC128245', 'HDFC Life Insurance Company Ltd', 'Vibha Padalkar', '₹1,56,947.36 Crore', '₹42,273.10 Crore'),
('L35999DL1991PLC045735', 'Hero MotoCorp Ltd', 'Pawan Munjal', '₹62,855.82 Crore', '₹31,084.60 Crore'),
('L27020MH1958PLC011238', 'Hindalco Industries Ltd', 'Satish Pai', '₹76,618.33 Crore', '₹1,05,380.40 Crore'),
('L15141MH1933PLC002484', 'Hindustan Unilever Ltd', 'Sanjiv Mehta', '₹5,45,438.89 Crore', '₹45,311.00 Crore'),
('L65923MH1994PLC107677', 'ICICI Bank Ltd', 'Sandeep Bakhshi', '₹5,52,857.50 Crore', '₹1,87,496.60 Crore'),
('L23201MH1959GOI011474', 'Indian Oil Corporation Ltd', 'Shrikant Madhav Vaidya', '₹85,161.67 Crore', '₹6,48,782.00 Crore'),
('L65191MH1994PLC079013', 'IndusInd Bank Ltd', 'Sumant Kathpalia', '₹71,924.25 Crore', '₹30,770.30 Crore'),
('L85110KA1981PLC013115', 'Infosys Ltd', 'Salil Parekh', '₹7,22,001.70 Crore', '₹98,468.00 Crore'),
('L16005WB1910PLC001208', 'ITC Ltd', 'Sanjiv Puri', '₹2,67,787.11 Crore', '₹55,434.70 Crore'),
('L27104MH1994PLC080618', 'JSW Steel Ltd', 'Seshagiri Rao M.V.S.', '₹1,42,211.33 Crore', '₹83,625.00 Crore'),
('L65203MH1985PLC038521', 'Kotak Mahindra Bank Ltd', 'Uday Kotak', '₹3,72,558.29 Crore', '₹46,720.80 Crore'),
('L99999MH1946PLC004768', 'Larsen & Toubro Ltd', 'S. N. Subrahmanyan', '₹2,51,024.97 Crore', '₹1,24,846.00 Crore'),
('L24231MH1951PLC008661', 'Mahindra & Mahindra Ltd', 'Anish Shah', '₹1,13,502.66 Crore', '₹98,464.00 Crore'),
('L34101DL1981PLC011064', 'Maruti Suzuki India Ltd', 'Kenichi Ayukawa', '₹2,52,245.45 Crore', '₹79,051.20 Crore'),
('L15202WB1959PLC002641', 'Nestle India Ltd', 'Suresh Narayanan', '₹1,99,931.02 Crore', '₹14,842.00 Crore'),
('L40101DL1975GOI007966', 'NTPC Ltd', 'Gurdeep Singh', '₹99,747.11 Crore', '₹96,473.10 Crore'),
('L11101DL1993GOI053185', 'Oil & Natural Gas Corporation Ltd', 'Subhash Kumar', '₹1,10,773.86 Crore', '₹77,547.10 Crore'),
('L17110MH1973PLC019786', 'Reliance Industries Ltd', 'Mukesh Ambani', '₹14,15,180.95 Crore', '₹5,39,238.00 Crore'),
('L65910MH1955GOI007276', 'State Bank of India', 'Dinesh Kumar Khara', '₹2,77,989.02 Crore', '₹3,27,628.00 Crore'),
('L66010MH2000PLC129114', 'SBI Life Insurance Company Ltd', 'Mahesh Kumar Sharma', '₹1,29,217.76 Crore', '₹51,177.90 Crore'),
('L85110MH1993PLC082459', 'Sun Pharmaceutical Industries Ltd', 'Dilip Shanghvi', '₹1,50,274.65 Crore', '₹35,424.80 Crore'),
('L67120MH1995PLC149088', 'Tata Consultancy Services Ltd', 'Rajesh Gopinathan', '₹14,96,869.05 Crore', '₹1,63,579.00 Crore'),
('L15490MH1962PLC027325', 'Tata Consumer Products Ltd', 'Sunil DSouza', '₹41,443.82 Crore', '₹12,461.90 Crore'),
('L34103MH1945PLC001196', 'Tata Motors Ltd', 'Guenter Butschek', '₹1,05,688.54 Crore', '₹2,45,658.30 Crore'),
('L27100MH1907PLC000713', 'Tata Steel Ltd', 'T. V. Narendran', '₹1,37,705.93 Crore', '₹1,46,106.00 Crore'),
('L64200MH1986PLC049130', 'Tech Mahindra Ltd', 'C. P. Gurnani', '₹1,25,856.06 Crore', '₹39,719.40 Crore'),
('L74999PN1984PLC033334', 'Titan Company Ltd', 'C K Venkataraman', '₹1,14,674.24 Crore', '₹20,249.00 Crore'),
('L26940MH2000PLC128385', 'UltraTech Cement Ltd', 'K. K. Maheshwari', '₹1,70,330.60 Crore', '₹43,326.80 Crore'),
('L24231KA1945PLC021078', 'Wipro Ltd', 'Thierry Delaporte', '₹3,09,604.67 Crore', '₹63,226.70 Crore'),
('L26942WB1970PLC023245', 'Shree Cement Ltd', 'H M Bangur', '₹1,10,221.49 Crore', '₹11,983.20 Crore'),
('L15139KA1999PLC025229', 'United Breweries Ltd', 'Shekhar Ramamurthy', '₹45,387.35 Crore', '₹13,439.50 Crore'),
('L92141MH1982PLC026935', 'Zee Entertainment Enterprises Ltd', 'Punit Goenka', '₹42,929.90 Crore', '₹9,874.70 Crore'),
('L40101DL1989GOI045867', 'Power Grid Corporation of India Ltd', 'K. Sreekant', '₹1,05,972.47 Crore', '₹39,008.80 Crore'),
('L51434WB1923PLC004793', 'Berger Paints India Ltd', 'Abhijit Roy', '₹10,000 Crore', '₹5,000 Crore'),
('L24230GJ1995PLC025878', 'Cadila Healthcare Ltd', 'Sharvil Patel', '₹15,000 Crore', '₹7,500 Crore'),
('L24200MH1937PLC002700', 'Colgate Palmolive (India) Ltd', 'Ram Raghavan', '₹20,000 Crore', '₹10,000 Crore'),
('L24110TG1990PLC011854', 'Divis Laboratories Ltd', 'Murali K Divi', '₹25,000 Crore', '₹12,500 Crore'),
('L24241MH1988PLC097781', 'Godrej Consumer Products Ltd', 'Nisaba Godrej', '₹30,000 Crore', '₹15,000 Crore'),
('L24299MH1977PLC019982', 'Glenmark Pharmaceuticals Ltd', 'Glenn Saldanha', '₹35,000 Crore', '₹17,500 Crore'),
('L31900DL1983PLC016304', 'Havells India Ltd', 'Anil Rai Gupta', '₹40,000 Crore', '₹20,000 Crore'),
('L23201DL1998PLC097614', 'Indraprastha Gas Ltd', 'E.S. Ranganathan', '₹45,000 Crore', '₹22,500 Crore'),
('L25111TN1960PLC004306', 'MRF Ltd', 'K. M. Mammen', '₹50,000 Crore', '₹25,000 Crore'),
('L29308MH1954PLC009371', 'Voltas Ltd', 'Pradeep Bakshi', '₹55,000 Crore', '₹27,500 Crore'),
('L65910MH1998PLC115967', 'IRB Infrastructure Developers Ltd', 'CEO1', '₹1,000 Crore', '₹500 Crore'),
('L31901WB1978PLC031411', 'CESC Ltd', 'CEO2', '₹2,000 Crore', '₹1,000 Crore'),
('U99999MH1935PTC002399', 'Bank of Maharashtra', 'CEO3', '₹3,000 Crore', '₹1,500 Crore'),
('L24223PB1988PLC008031', 'Max Financial Services Ltd', 'CEO4', '₹4,000 Crore', '₹2,000 Crore'),
('L67120MH1997PLC112443', 'Central Depository Services (India) Limited', 'Nehal Vora', '₹8,240.80 Crore', '₹405.40 Crore'),
('U29299PB1998PLC039602', 'Hero MotoCorp Ltd', 'Pawan Munjal', '₹47,819 Crore', '₹29,632 Crore'),
('L72100DL1992PLC048753', 'Coforge Limited', 'Sudhir Singh', '₹85,226 Crore', '₹87,500 Crore'),
('L30007KA1992PLC025294', 'Mphasis Limited', 'Nitin Rakesh', '₹56,220 Crore', '₹26,486 Crore'),
('U74899DL1995PLC067527', 'Bharti Hexagon', 'Jagdish Saksena', '₹6,579 Crore', '₹18,254 Crore'),
('U45400JK2008PTC002933', 'SRM Contractors', 'Sanjay Mehta', '₹300.29 Crore', '₹137.36 Crore'),
('U74920MH2000PTC129827', 'Krystal Integrated Services', 'Neeta Prasad Lad', '₹707.64 Crore', '₹343.47 Crore'),
('U74999KA2017PTC099619', 'Ola Electric', 'Bhavish Agrawal', '₹2630.93 Crore', '₹5573.17 Crore'),
('U74900GJ2015PTC107035', 'OYO', 'Ritesh Agrawal', '₹4157.39 Crore', '₹8751.05 Crore')
INSERT INTO sector(sector_name , CIN) VALUES
('Private' ,'L67120MH1995PLC149088' ),
('IT service' ,'L67120MH1995PLC149088' ),
('Consultancy' ,'L67120MH1995PLC149088' ),
('Business Solutions' ,'L67120MH1995PLC149088' ),
('solar manufacturing' ,'L67120GJ1993PLC019050' ),
('defence and aerospace' ,'L67120GJ1993PLC019050' ),
('data centers' ,'L67120GJ1993PLC019050' ),
('public' ,'U65190MH1993PLC074381' ),
('pharma' ,'L85110MH1993PLC082459' )
insert into IPO(ipo_name , CIN , open_date , close_date , Issue_price , lot_size , Issue_size , minimum_invest ,listing_date) values
('Bharti Hexacom' , 'U74899DL1995PLC067527' ,'2024-04-03', '2024-04-05','560-570', 26 ,'4,275 Cr', 14092 , '2024-04-12'),
('SRM contractors' , 'U45400JK2008PTC002933' ,'2024-03-26', '2024-03-28', '200-210', 70 ,'130.20 Cr', 14000 , '2024-04-01'),
('Krystal Integrated Services' , 'U74920MH2000PTC129827' ,'2024-03-14', '2024-03-18', '680-715', 20 ,'300.13 Cr', 13600 , '2024-03-21'),
('Ola Electric' , 'U74999KA2017PTC099619' , NULL,NULL,NULL,NULL,'5500 Cr',NULL,NULL),
('OYO' , 'U74900GJ2015PTC107035' ,NULL,NULL,NULL,NULL,'8430 Cr', NULL,NULL )
insert into news(cin ,title , description) values
('L67120MH1995PLC149088', 'BackBack Stock to buy before Q4 results 2024: TCS share price on cusp of breakout. Should you buy?' ,
'Stock to buy before Q4 results 2024: Shares of Tata Consultancy Services (TCS) witnessed sharp selling after Tata Sons stake sale news hit the headlines in mid-March 2024. However, TCS share price witnessed strong buying at lower levels ₹3840 to ₹3850 per share. After ending at ₹3,840 apiece on NSE on 27th March 2024, TCS share price has been ascending after every small profit-booking. TCS share price today touched an intraday high of ₹4,025.95 per share on NSE, logging a nearly 5 percent upside from the lows made after Tata Sons induced selling last month.
'),
('L67120GJ1993PLC019050', 'Adani Total Gas: FPIs stayed put on this Adani stock that fell 6% in Q4' ,
'Adani group firm Adani Total Gas saw foreign portfolio investors (FPIs) staying largely put despite a 6 per cent fall in its shares in the March quarter. Mutual fund holding in this Adani group firm stayed insignificant.
Data compiled from corporate data AceEquity suggests FPIs held 13.13 per cent stake in Adani Total Gas, up 7 basis points over 13.06 per cent in the December quarter. MF holding in the Adani company came in at 0.09 per cent against 0.12 per cent in the third quarter.
'),
('U65190MH1993PLC074381', 'PSU bank stocks rise, IOB up 8%, Union Bank surges 2%; heres why' ,
'PSU Bank stocks surged on April 1, driving the Nifty PSU index up by more than one percent. According to analysts noted that the favorable credit environment at present has bolstered the asset quality of these banks, contributing to the rise in their stocks
')
INSERT INTO STOCK_GROUP (Group_symbol , Group_name , highest , lowest , stock_exchange) VALUES
('NIFTY_IT' , 'Nifty IT' , 38559.85 , 26184.45, 'NSE'),
('NIFTY_50' , 'Nifty fifty' , 22343 , 8660, 'NSE'),
('NIFTY_BANK' , 'Nifty BANK' , 48730.55 , 17249.3, 'NSE'),
('SENSEX' , 'SENSEX' , 74683.7 , 27590.95, 'BSE'),
('BSE_PSU' , 'PSU' , 19365.40 , 9539.86, 'BSE')
INSERT INTO member_of (stock_sym , group_sym) VALUES
('ADANIENT' , 'NIFTY_50'),
('ADANIPORTS' , 'NIFTY_50'),
('ASIANPAINT' , 'NIFTY_50'),
('AXISBANK' , 'NIFTY_50'),
('BAJAJ-AUTO' , 'NIFTY_50'),
('BAJFINANCE' , 'NIFTY_50'),
('BAJAJFINSV' , 'NIFTY_50'),
('BPCL' , 'NIFTY_50'),
('BHARTIARTL' , 'NIFTY_50'),
('CIPLA' , 'NIFTY_50'),
('COALINDIA' , 'NIFTY_50'),
('DIVISLAB' , 'NIFTY_50'),
('DRREDDY' , 'NIFTY_50'),
('EICHERMOT' , 'NIFTY_50'),
('GRASIM' , 'NIFTY_50'),
('HCLTECH' , 'NIFTY_50'),
('HDFCBANK' , 'NIFTY_50'),
('HDFCLIFE' , 'NIFTY_50'),
('HEROMOTOCO' , 'NIFTY_50'),
('HINDALCO' , 'NIFTY_50'),
('HINDUNILVR' , 'NIFTY_50'),
('ICICIBANK' , 'NIFTY_50'),
('ITC' , 'NIFTY_50'),
('INDUSINDBK' , 'NIFTY_50'),
('INFY' , 'NIFTY_50'),
('JSWSTEEL' , 'NIFTY_50'),
('KOTAKBANK' , 'NIFTY_50'),
('LTIM' , 'NIFTY_50'),
('LT' , 'NIFTY_50'),
('M&M' , 'NIFTY_50'),
('MARUTI' , 'NIFTY_50'),
('NTPC' , 'NIFTY_50'),
('NESTLEIND' , 'NIFTY_50'),
('ONGC' , 'NIFTY_50'),
('POWERGRID' , 'NIFTY_50'),
('RELIANCE' , 'NIFTY_50'),
('SBILIFE' , 'NIFTY_50'),
('SHRIRAMFIN' , 'NIFTY_50'),
('SBIN' , 'NIFTY_50'),
('SUNPHARMA' , 'NIFTY_50'),
('TCS' , 'NIFTY_50'),
('TATACONSUM' , 'NIFTY_50'),
('TATAMOTORS' , 'NIFTY_50'),
('TATASTEEL' , 'NIFTY_50'),
('TECHM' , 'NIFTY_50'),
('TITAN' , 'NIFTY_50'),
('ULTRACEMCO' , 'NIFTY_50'),
('WIPRO' , 'NIFTY_50'),
('VOLTAS', 'NIFTY_50'),
('MAHABANK' , 'NIFTY_50'),
('HCLTECH','NIFTY_IT'),
('INFY','NIFTY_IT'),
('LTIM','NIFTY_IT'),
('WIPRO','NIFTY_IT'),
('TCS','NIFTY_IT'),
('MPHASIS','NIFTY_IT'),
('COFORGE','NIFTY_IT'),
('HDFCBANK','NIFTY_BANK'),
('ICICIBANK','NIFTY_BANK'),
('AXISBANK','NIFTY_BANK'),
('SBIN','NIFTY_BANK'),
('INDUSINDBK','NIFTY_BANK'),
('KOTAKBANK','NIFTY_BANK'),
('500034','SENSEX'),
('500084','SENSEX'),
('500180','SENSEX'),
('500271','SENSEX'),
('500290','SENSEX'),
('500325','SENSEX'),
('500570','SENSEX'),
('500696','SENSEX'),
('500830','SENSEX'),
('509480','SENSEX'),
('512599','SENSEX'),
('517354','SENSEX'),
('532174','SENSEX'),
('532215','SENSEX'),
('532424','SENSEX'),
('532540','SENSEX'),
('532921','SENSEX')
INSERT INTO stocks (Stock_Symbol, SName , Stype , highest , lowest ,exchange , CIN ) VALUES
-- large cap with NSE and BSE both.
('ADANIENT', 'Adani Enterprises Ltd', 'LargeCap' , 3608 , 1902 , 'NSE' , 'L67120GJ1993PLC019050'),
('512599', 'Adani Enterprises Ltd', 'LargeCap' , 3604 , 1910 , 'BSE' , 'L67120GJ1993PLC019050'),
('TCS', 'Tata Consultancy Services Ltd', 'LargeCap' , 4215 , 2803 , 'NSE' , 'L67120MH1995PLC149088'),
('532540', 'Tata Consultancy Services Ltd', 'LargeCap' , 4214.5 , 2803 , 'BSE' , 'L67120MH1995PLC149088'),
('TATAMOTORS', 'Tata Motors Ltd', 'LargeCap' , 1175 , 1004 , 'NSE' , 'L34103MH1945PLC001196'),
('500570', 'Tata Motors Ltd', 'LargeCap' , 1175 , 1004 , 'BSE' , 'L34103MH1945PLC001196'),
('ADANIPORTS', 'Adani Ports & Special Economic Zone Ltd', 'LargeCap' , 1384 , 1047 , 'NSE' , 'L24100GJ1993PLC019050'),
('532921', 'Adani Ports & Special Economic Zone Ltd', 'LargeCap' , 1381 , 1047 , 'BSE' , 'L24100GJ1993PLC019050'),
('RELIANCE', 'Reliance Industries Ltd', 'LargeCap' , 2925 , 1330 , 'NSE' , 'L17110MH1973PLC019786'),
('500325', 'Reliance Industries Ltd', 'LargeCap' , 2925 , 1330 , 'BSE' , 'L17110MH1973PLC019786'),
('BAJFINANCE', 'Bajaj Finance Ltd', 'LargeCap' , 7189 , 3008 , 'NSE' , 'L65910MH1987PLC042051'),
('500034', 'Bajaj Finance Ltd', 'LargeCap' , 7189 , 3008 , 'BSE' , 'L65910MH1987PLC042051'),
('HDFCBANK', 'HDFC Bank Ltd', 'LargeCap' , 1550 , 1132 , 'NSE' , 'L65920MH1994PLC080618'),
('500180', 'HDFC Bank Ltd', 'LargeCap' , 1550 , 1132 , 'BSE' , 'L65920MH1994PLC080618'),
('ICICIBANK', 'ICICI Bank Ltd', 'LargeCap' , 1086 , 394 , 'NSE' , 'L65923MH1994PLC107677'),
('532174', 'ICICI Bank Ltd', 'LargeCap' , 1086 , 394 , 'BSE' , 'L65923MH1994PLC107677'),
('AXISBANK', 'Axis Bank Ltd', 'LargeCap' , 1120 , 325 , 'NSE' , 'L65191MH1993PLC082610'),
('532215', 'Axis Bank Ltd', 'LargeCap' , 1120 , 325 , 'BSE' , 'L65191MH1993PLC082610'),
('HINDUNILVR', 'Hindustan Unilever Ltd', 'LargeCap' , 2766 , 2078 , 'NSE' , 'L15141MH1933PLC002484'),
('500696', 'Hindustan Unilever Ltd', 'LargeCap' , 2766 , 2078 , 'BSE' , 'L15141MH1933PLC002484'),
--Mid cap with either NSE or BSE
('509480', 'Berger Paints India Ltd', 'MidCap' , 145 , 207 , 'BSE' , 'L51434WB1923PLC004793'),
('CADILAHC', 'Cadila Healthcare Ltd', 'MidCap' , 209 , 1324 , 'NSE' , 'L24230GJ1995PLC025878'),
('500830', 'Colgate Palmolive (India) Ltd', 'MidCap' , 266 , 1078 , 'BSE' , 'L24200MH1937PLC002700'),
('DIVISLAB', 'Divis Laboratories Ltd', 'MidCap' , 145 , 248 , 'NSE' , 'L24110TG1990PLC011854'),
('532424', 'Godrej Consumer Products Ltd', 'MidCap' , 55 , 146 , 'BSE' , 'L24241MH1988PLC097781'),
('GLENMARK', 'Glenmark Pharmaceuticals Ltd', 'MidCap' , 450 , 667 , 'NSE' , 'L24299MH1977PLC019982'),
('517354', 'Havells India Ltd', 'MidCap' , 451 , 684 , 'BSE' , 'L31900DL1983PLC016304'),
('IGL', 'Indraprastha Gas Ltd', 'MidCap' , 145 , 875 , 'NSE' , 'L23201DL1998PLC097614'),
('500290', 'MRF Ltd' ,'MidCap', 120 , 689 , 'BSE' , 'L25111TN1960PLC004306'),
('VOLTAS', 'Voltas Ltd', 'MidCap' , 123 , 754 , 'NSE' , 'L29308MH1954PLC009371'),
--Small Cap with either NSE or BSE.
('IRB', 'IRB Infrastructure Developers Ltd', 'SmallCap' , 13 , 75 , 'NSE' , 'L65910MH1998PLC115967'),
('500084', 'CESC Ltd' ,'SmallCap', 12.3 , 68 , 'BSE' , 'L31901WB1978PLC031411'),
('MAHABANK', 'Bank of Maharashtra', 'SmallCap' , 15.6 , 75.4 , 'NSE' , 'U99999MH1935PTC002399'),
('500271', 'Max Financial Services Ltd' ,'SmallCap', 14.90 , 68.9 , 'BSE' , 'L24223PB1988PLC008031'),
('CDSL', 'Central Depository Services (India) Limited', 'SmallCap' , 94.4 , 650.4 , 'NSE' , 'L67120MH1997PLC112443'),
--extra remaining comapnies of nifty 50
('ASIANPAINT ', 'Asian Paints Ltd', 'MidCap' , 1235.3 , 2833 , 'NSE' , 'L24220MH1945PLC004598')
('BAJAJ-AUTO', 'Bajaj Auto Ltd', 'LargeCap', 4500, 3000, 'NSE', 'L65993PN2007PLC130076'),
('BAJAJFINSV', 'Bajaj Finserv Ltd', 'LargeCap', 6000, 4000, 'NSE', 'U65923PN2014PLC150522'),
('BPCL', 'Bharat Petroleum Corporation Ltd', 'LargeCap', 5000, 3500, 'NSE', 'L23220MH1952GOI008931'),
('BHARTIARTL', 'Bharti Airtel Ltd', 'LargeCap', 7000, 4500, 'NSE', 'L74899DL1995PLC070609'),
('BRITANNIA', 'Britannia Industries Ltd', 'LargeCap', 5500, 3800, 'NSE', 'L15412WB1918PLC002964'),
('CIPLA', 'Cipla Ltd', 'LargeCap', 3000, 2200, 'NSE', 'L24239MH1935PLC002380'),
('COALINDIA', 'Coal India Ltd', 'LargeCap', 4200, 2800, 'NSE', 'L23109WB1973GOI028844'),
('DRREDDY', 'Dr. Reddy''s Laboratories Ltd', 'LargeCap', 7800, 6500, 'NSE', 'L85195TG1984PLC004507'),
('EICHERMOT', 'Eicher Motors Ltd', 'LargeCap', 8200, 7200, 'NSE', 'L34102DL1982PLC129877'),
('GRASIM', 'Grasim Industries Ltd', 'LargeCap', 5200, 4000, 'NSE', 'L17124MP1947PLC000410'),
('HCLTECH', 'HCL Technologies Ltd', 'LargeCap', 6800, 5800, 'NSE', 'L74140DL1991PLC046369'),
('HDFCLIFE', 'HDFC Life Insurance Company Ltd', 'LargeCap', 6300, 5200, 'NSE', 'L65110MH2000PLC128245'),
('HEROMOTOCO', 'Hero MotoCorp Ltd', 'LargeCap', 5000, 4000, 'NSE', 'U29299PB1998PLC039602'),
('HINDALCO', 'Hindalco Industries Ltd', 'LargeCap', 4700, 3500, 'NSE', 'L27020MH1958PLC011238'),
('ITC', 'ITC Ltd', 'LargeCap', 3600, 2700, 'NSE', 'L16005WB1910PLC001985'),
('INDUSINDBK', 'IndusInd Bank Ltd', 'LargeCap', 6800, 5400, 'NSE', 'L65191PN1994PLC076333'),
('INFY', 'Infosys Ltd', 'LargeCap', 7800, 6000, 'NSE', 'L85110KA1981PLC013115'),
('JSWSTEEL', 'JSW Steel Ltd', 'LargeCap', 5000, 4000, 'NSE', 'L27102MH1994PLC152925'),
('KOTAKBANK', 'Kotak Mahindra Bank Ltd', 'LargeCap', 7000, 5500, 'NSE', 'L65110MH1985PLC038137'),
('LTIM', 'Larsen & Toubro Infotech Ltd', 'LargeCap', 6400, 5000, 'NSE', 'L99999MH1946PLC004768'),
('LT', 'Larsen & Toubro Ltd', 'LargeCap', 7100, 5900, 'NSE', 'U72900MH1996PLC104693'),
('M&M', 'Mahindra & Mahindra Ltd', 'LargeCap', 5800, 4600, 'NSE', 'L65990MH1945PLC004558'),
('MARUTI', 'Maruti Suzuki India Ltd', 'LargeCap', 7800, 6400, 'NSE', 'L34103DL1981PLC011375'),
('NTPC', 'NTPC Ltd', 'LargeCap', 4400, 3200, 'NSE', 'L40101DL1975GOI007966'),
('NESTLEIND', 'Nestle India Ltd', 'LargeCap', 7200, 5800, 'NSE', 'L15202DL1959PLC003786'),
('ONGC', 'Oil & Natural Gas Corporation Ltd', 'LargeCap', 6000, 4800, 'NSE', 'L74899DL1993GOI054155'),
('POWERGRID', 'Power Grid Corporation of India Ltd', 'LargeCap', 4800, 3500, 'NSE', 'L40101DL1989GOI038121'),
('SBILIFE', 'SBI Life Insurance Company Ltd', 'LargeCap', 6200, 5200, 'NSE', 'L99999MH2000PLC129113'),
('SHRIRAMFIN', 'Shriram Transport Finance Company Ltd', 'LargeCap', 4500, 3500, 'NSE', 'L65191TN1979PLC007874'),
('SBIN', 'State Bank of India', 'LargeCap', 5100, 4000, 'NSE', 'U65190MH1993PLC074381'),
('SUNPHARMA', 'Sun Pharmaceutical Industries Ltd', 'LargeCap', 5800, 4600, 'NSE', 'L24230GJ1993PLC019050'),
('TATACONSUM', 'Tata Consumer Products Ltd', 'LargeCap', 6700, 5300, 'NSE', 'L15491WB1962PLC031425'),
('TATASTEEL', 'Tata Steel Ltd', 'LargeCap', 5400, 4200, 'NSE', 'L27100MH1907PLC000260'),
('TECHM', 'Tech Mahindra Ltd', 'LargeCap', 6000, 4900, 'NSE', 'L64200MH1986PLC041370'),
('TITAN', 'Titan Company Ltd', 'LargeCap', 6400, 5300, 'NSE', 'L74999TZ1984PLC001456'),
('ULTRACEMCO', 'UltraTech Cement Ltd', 'LargeCap', 7200, 5900, 'NSE', 'L26940MH2000PLC128420'),
('WIPRO', 'Wipro Ltd', 'LargeCap', 6100, 4900, 'NSE', 'L32102KA1945PLC020800');
('COFORGE', 'Coforge Limited', 'MidCap', 610, 1280, 'NSE', 'L72100DL1992PLC048753'),
('MPHASIS', 'Mphasis Limited', 'MidCap', 846.1, 1840, 'NSE', 'L30007KA1992PLC025294')