In [1]:
import pandas as pd
import os

In [34]:
DB = []
path = '/Users/insuyu/GitHub/historical.data/yahoo.csv/'
nFiles = 0
for file in os.listdir(path):
    if file.endswith(".csv"):
        table = pd.read_csv(path+file)
        code = file[:-4]
        if (table['Adj Close'][0] > 5000) :
            print (nFiles, code, 0.0, len(table.index)) 
            DB.append([nFiles, code, 0.0, table]) #table['Adj Close'][0],
            nFiles+=1


0 000030 0.0 3365
1 000040 0.0 3740
2 000050 0.0 3894
3 000070 0.0 2396
4 000075 0.0 1587
5 000087 0.0 808
6 000100 0.0 3899
7 000105 0.0 1646
8 000120 0.0 3882
9 000140 0.0 3997
10 000145 0.0 1778
11 000150 0.0 3898
12 000155 0.0 3869
13 000157 0.0 3828
14 000180 0.0 3899
15 000210 0.0 3988
16 000215 0.0 1864
17 000225 0.0 1832
18 000270 0.0 3907
19 000300 0.0 3865
20 000327 0.0 1815
21 000370 0.0 3878
22 000480 0.0 1954
23 000500 0.0 1922
24 000540 0.0 3877
25 000545 0.0 1846
26 000547 0.0 1598
27 000590 0.0 3877
28 000640 0.0 1922
29 000650 0.0 3878
30 000660 0.0 4004
31 000670 0.0 3899
32 000680 0.0 3271
33 000720 0.0 3988
34 000725 0.0 1833
35 000760 0.0 3896
36 000810 0.0 3986
37 000815 0.0 1862
38 000830 0.0 4008
39 000835 0.0 1864
40 000850 0.0 3899
41 000880 0.0 3897
42 000885 0.0 1800
43 000950 0.0 3839
44 000990 0.0 3998
45 000995 0.0 1722
46 001040 0.0 4008
47 001045 0.0 3855
48 001060 0.0 1894
49 001065 0.0 1756
50 001067 0.0 1848
51 001070 0.0 3899
52 001080 0.0 3882
53 001130 0.0 3898
54 001140 0.0 3899
55 001200 0.0 3882
56 001210 0.0 3899
57 001260 0.0 3887
58 001270 0.0 3877
59 001275 0.0 1756
60 001390 0.0 3877
61 001430 0.0 3887
62 001440 0.0 3896
63 001460 0.0 3897
64 001465 0.0 1841
65 001470 0.0 1861
66 001500 0.0 3899
67 001510 0.0 3893
68 001520 0.0 3890
69 001525 0.0 1750
70 001527 0.0 3752
71 001529 0.0 1709
72 001530 0.0 1909
73 001550 0.0 3882
74 001630 0.0 3877
75 001680 0.0 3886
76 001689 0.0 1444
77 001720 0.0 3898
78 001725 0.0 1775
79 001740 0.0 3997
80 001745 0.0 1842
81 001750 0.0 3899
82 001755 0.0 1528
83 001770 0.0 3894
84 001790 0.0 3887
85 001795 0.0 1647
86 001799 0.0 771
87 001800 0.0 3899
88 002000 0.0 3998
89 002005 0.0 3814
90 002020 0.0 1891
91 002025 0.0 1784
92 002030 0.0 1943
93 002070 0.0 3882
94 002150 0.0 1271
95 002170 0.0 3894
96 002200 0.0 3894
97 002220 0.0 3866
98 002240 0.0 1929
99 002250 0.0 3998
100 002270 0.0 3899
101 002300 0.0 3899
102 002310 0.0 3899
103 002320 0.0 3998
104 002380 0.0 3998
105 002410 0.0 3885
106 002420 0.0 3880
107 002450 0.0 3884
108 002600 0.0 3896
109 002780 0.0 3882
110 002785 0.0 1810
111 002787 0.0 1709
112 002840 0.0 3843
113 002870 0.0 3894
114 002900 0.0 3899
115 002960 0.0 3899
116 002990 0.0 3867
117 002995 0.0 1813
118 003000 0.0 1926
119 003030 0.0 1913
120 003060 0.0 3784
121 003070 0.0 3998
122 003075 0.0 1756
123 003080 0.0 3894
124 003090 0.0 3882
125 003120 0.0 3899
126 003200 0.0 3895
127 003230 0.0 3894
128 003240 0.0 3898
129 003300 0.0 3971
130 003410 0.0 4030
131 003415 0.0 1831
132 003419 0.0 3815
133 003450 0.0 3987
134 003460 0.0 1955
135 003465 0.0 1531
136 003470 0.0 3899
137 003475 0.0 1762
138 003490 0.0 4033
139 003495 0.0 1828
140 003530 0.0 3899
141 003535 0.0 1852
142 003540 0.0 3988
143 003545 0.0 1867
144 003547 0.0 1929
145 003550 0.0 2775
146 003555 0.0 1861
147 003560 0.0 3870
148 003570 0.0 3876
149 003580 0.0 3999
150 003600 0.0 4033
151 003605 0.0 1817
152 003610 0.0 3899
153 003620 0.0 3920
154 003650 0.0 3899
155 003680 0.0 3899
156 003690 0.0 1951
157 003830 0.0 3897
158 003850 0.0 3889
159 003920 0.0 3898
160 003925 0.0 1622
161 003940 0.0 3933
162 003945 0.0 1398
163 003960 0.0 3827
164 004000 0.0 3998
165 004020 0.0 3998
166 004090 0.0 3899
167 004130 0.0 3934
168 004140 0.0 1917
169 004150 0.0 4033
170 004170 0.0 3871
171 004200 0.0 3899
172 004270 0.0 3896
173 004370 0.0 3877
174 004410 0.0 3862
175 004415 0.0 1809
176 004450 0.0 3869
177 004540 0.0 3878
178 004545 0.0 1850
179 004690 0.0 3993
180 004710 0.0 3998
181 004740 0.0 3885
182 004800 0.0 4033
183 004870 0.0 3837
184 004890 0.0 2545
185 004960 0.0 3876
186 004985 0.0 1827
187 004989 0.0 2270
188 004990 0.0 1954
189 005010 0.0 3899
190 005110 0.0 3849
191 005180 0.0 3899
192 005300 0.0 3998
193 005305 0.0 1728
194 005320 0.0 3882
195 005380 0.0 4033
196 005385 0.0 1867
197 005387 0.0 1867
198 005389 0.0 3866
199 005420 0.0 3879
200 005430 0.0 3997
201 005490 0.0 4033
202 005500 0.0 1903
203 005610 0.0 3879
204 005620 0.0 3873
205 005680 0.0 3899
206 005720 0.0 3998
207 005725 0.0 1432
208 005740 0.0 3734
209 005745 0.0 1752
210 005800 0.0 3882
211 005810 0.0 3876
212 005820 0.0 3894
213 005870 0.0 3857
214 005880 0.0 3866
215 005930 0.0 4033
216 005935 0.0 1867
217 005940 0.0 4032
218 005945 0.0 1864
219 005950 0.0 3899
220 005965 0.0 1737
221 005980 0.0 3840
222 006040 0.0 3922
223 006120 0.0 3998
224 006125 0.0 1864
225 006260 0.0 3998
226 006360 0.0 3995
227 006380 0.0 3899
228 006390 0.0 3899
229 006400 0.0 4002
230 006405 0.0 1867
231 006490 0.0 3880
232 006650 0.0 3899
233 006800 0.0 3987
234 006805 0.0 1864
235 006840 0.0 2412
236 006880 0.0 433
237 007070 0.0 849
238 007120 0.0 3899
239 007310 0.0 3997
240 007460 0.0 1926
241 007540 0.0 3898
242 007570 0.0 3890
243 007575 0.0 1840
244 007630 0.0 3831
245 007690 0.0 3899
246 007810 0.0 3899
247 008000 0.0 3873
248 008060 0.0 3899
249 008250 0.0 3899
250 008490 0.0 3894
251 008500 0.0 3893
252 008700 0.0 3868
253 008770 0.0 3898
254 008775 0.0 1856
255 008870 0.0 3881
256 008930 0.0 1929
257 009140 0.0 3995
258 009150 0.0 4003
259 009155 0.0 1864
260 009180 0.0 3899
261 009190 0.0 3898
262 009240 0.0 3345
263 009270 0.0 3879
264 009275 0.0 1829
265 009320 0.0 1876
266 009540 0.0 4002
267 009770 0.0 2220
268 009810 0.0 3836
269 009830 0.0 3999
270 009835 0.0 1862
271 010060 0.0 3999
272 010100 0.0 3898
273 010120 0.0 3998
274 010130 0.0 4025
275 010140 0.0 3998
276 010145 0.0 1829
277 010420 0.0 3857
278 010600 0.0 1912
279 010620 0.0 3988
280 010660 0.0 3899
281 010820 0.0 3860
282 010950 0.0 3991
283 010955 0.0 3869
284 011070 0.0 1787
285 011160 0.0 3976
286 011170 0.0 3998
287 011200 0.0 3993
288 011210 0.0 1141
289 011230 0.0 3899
290 011330 0.0 3860
291 011390 0.0 3899
292 011720 0.0 3842
293 011760 0.0 4005
294 011785 0.0 1762
295 011790 0.0 3971
296 011810 0.0 3872
297 011930 0.0 3878
298 012170 0.0 3797
299 012320 0.0 3897
300 012330 0.0 3998
301 012450 0.0 3988
302 012510 0.0 3878
303 012600 0.0 3899
304 012630 0.0 3998
305 012690 0.0 3885
306 012750 0.0 3899
307 013000 0.0 3858
308 013360 0.0 3888
309 013367 0.0 1703
310 013520 0.0 3898
311 013580 0.0 3899
312 013870 0.0 693
313 014130 0.0 3899
314 014160 0.0 3848
315 014285 0.0 1819
316 014530 0.0 3899
317 014680 0.0 3998
318 014710 0.0 795
319 014820 0.0 3935
320 014825 0.0 1769
321 014830 0.0 2686
322 015230 0.0 3899
323 015260 0.0 3842
324 015350 0.0 3899
325 015360 0.0 3899
326 015540 0.0 3786
327 015760 0.0 4022
328 016360 0.0 3987
329 016380 0.0 3899
330 016385 0.0 1812
331 016590 0.0 3898
332 016610 0.0 3952
333 016880 0.0 2065
334 017390 0.0 3994
335 017550 0.0 3857
336 017670 0.0 4033
337 017800 0.0 3897
338 017810 0.0 3877
339 017900 0.0 3902
340 017940 0.0 1945
341 017960 0.0 3899
342 018260 0.0 235
343 018670 0.0 3997
344 019440 0.0 1067
345 019490 0.0 3997
346 020120 0.0 3859
347 020150 0.0 1078
348 020760 0.0 3369
349 023350 0.0 849
350 023450 0.0 2017
351 023530 0.0 2390
352 023590 0.0 3898
353 025000 0.0 1913
354 025540 0.0 3906
355 025560 0.0 4001
356 025620 0.0 3861
357 025850 0.0 1913
358 025860 0.0 3981
359 025890 0.0 1913
360 027410 0.0 306
361 027970 0.0 3993
362 028050 0.0 3997
363 028100 0.0 1564
364 028260 0.0 153
365 028670 0.0 1981
366 029530 0.0 3996
367 029780 0.0 2049
368 030200 0.0 4033
369 030210 0.0 3896
370 030610 0.0 3869
371 030720 0.0 3897
372 031430 0.0 1037
373 031440 0.0 3502
374 031820 0.0 3898
375 032350 0.0 2309
376 032640 0.0 3907
377 032830 0.0 1335
378 033180 0.0 3870
379 033240 0.0 3897
380 033660 0.0 1555
381 033780 0.0 4001
382 034120 0.0 3854
383 034220 0.0 2845
384 034300 0.0 3382
385 034590 0.0 2207
386 034730 0.0 1457
387 035000 0.0 3996
388 035250 0.0 3443
389 035420 0.0 3204
390 035510 0.0 3670
391 036460 0.0 3992
392 036530 0.0 3838
393 036570 0.0 3763
394 037560 0.0 700
395 037620 0.0 2386
396 037710 0.0 3378
397 039130 0.0 1926
398 039490 0.0 2836
399 042700 0.0 2528
400 044450 0.0 1963
401 047810 0.0 1047
402 049770 0.0 3755
403 051310 0.0 1944
404 051600 0.0 1934
405 051900 0.0 3568
406 051905 0.0 1860
407 051910 0.0 3655
408 051915 0.0 1852
409 052690 0.0 1434
410 053210 0.0 1065
411 053690 0.0 1557
412 057050 0.0 1249
413 058430 0.0 3253
414 058650 0.0 3503
415 060980 0.0 1330
416 063160 0.0 3877
417 064350 0.0 449
418 064960 0.0 3358
419 066570 0.0 3406
420 066575 0.0 1867
421 067830 0.0 3261
422 068400 0.0 644
423 068870 0.0 3252
424 068875 0.0 1773
425 069500 0.0 1870
426 069620 0.0 1926
427 069640 0.0 849
428 069660 0.0 1776
429 069960 0.0 3184
430 071050 0.0 3169
431 071055 0.0 1896
432 071090 0.0 3130
433 071320 0.0 1404
434 071840 0.0 849
435 071970 0.0 1584
436 072130 0.0 3039
437 072710 0.0 3019
438 073240 0.0 2621
439 077970 0.0 2828
440 078000 0.0 2773
441 078930 0.0 2769
442 078935 0.0 1867
443 079160 0.0 2671
444 079430 0.0 2443
445 079660 0.0 2733
446 079980 0.0 884
447 081660 0.0 1241
448 082640 0.0 1481
449 082740 0.0 1168
450 084670 0.0 2527
451 084870 0.0 2426
452 086280 0.0 2421
453 086790 0.0 3199
454 088350 0.0 1374
455 088790 0.0 2343
456 088980 0.0 1458
457 090370 0.0 2173
458 090430 0.0 2295
459 090435 0.0 1847
460 091160 0.0 1870
461 091170 0.0 1870
462 091180 0.0 1870
463 091210 0.0 2034
464 091220 0.0 2214
465 091230 0.0 2073
466 092220 0.0 2220
467 092230 0.0 2225
468 092440 0.0 1967
469 093050 0.0 2189
470 093230 0.0 1965
471 094280 0.0 1970
472 095720 0.0 2067
473 096770 0.0 2030
474 096775 0.0 1864
475 097230 0.0 2005
476 097710 0.0 1853
477 097720 0.0 1639
478 097750 0.0 1854
479 097950 0.0 1988
480 097955 0.0 1867
481 098560 0.0 1898
482 099140 0.0 1870
483 100220 0.0 1805
484 100840 0.0 1878
485 101280 0.0 1836
486 102110 0.0 1805
487 102460 0.0 1316
488 102960 0.0 1769
489 102970 0.0 1769
490 103130 0.0 1302
491 103140 0.0 1781
492 103590 0.0 1779
493 104530 0.0 1727
494 104700 0.0 1742
495 105190 0.0 1687
496 105560 0.0 1743
497 105840 0.0 1284
498 107560 0.0 1610
499 107590 0.0 1636
500 108440 0.0 1528
501 108590 0.0 1576
502 108630 0.0 1392
503 108670 0.0 1078
504 108675 0.0 1576
505 110570 0.0 975
506 111770 0.0 1530
507 112610 0.0 168
508 114090 0.0 1451
509 114100 0.0 1426
510 114260 0.0 1476
511 114460 0.0 1286
512 114470 0.0 1402
513 114800 0.0 1441
514 114820 0.0 1311
515 115390 0.0 1360
516 117460 0.0 1424
517 117580 0.0 1177
518 117680 0.0 1410
519 117690 0.0 1338
520 117700 0.0 1410
521 117930 0.0 1424
522 118000 0.0 1424
523 119650 0.0 1360
524 120030 0.0 1388
525 120110 0.0 1360
526 120115 0.0 1213
527 120210 0.0 952
528 122090 0.0 1335
529 122260 0.0 1351
530 122390 0.0 1286
531 122630 0.0 1333
532 122900 0.0 1280
533 123310 0.0 1309
534 123320 0.0 1301
535 123760 0.0 1305
536 128820 0.0 1267
537 128940 0.0 1280
538 130680 0.0 1222
539 130730 0.0 1216
540 131890 0.0 1159
541 132030 0.0 1158
542 133690 0.0 1151
543 133820 0.0 260
544 134380 0.0 1080
545 134790 0.0 1135
546 136280 0.0 1112
547 136340 0.0 995
548 136490 0.0 1141
549 137610 0.0 1102
550 137930 0.0 1074
551 137990 0.0 1079
552 138230 0.0 1075
553 138250 0.0 82
554 138440 0.0 1126
555 138490 0.0 849
556 138520 0.0 1064
557 138530 0.0 1063
558 138540 0.0 1065
559 138910 0.0 1064
560 138920 0.0 1065
561 138930 0.0 1110
562 139130 0.0 1064
563 139220 0.0 1014
564 139230 0.0 1009
565 139240 0.0 841
566 139250 0.0 1003
567 139260 0.0 1047
568 139270 0.0 983
569 139280 0.0 1041
570 139290 0.0 1011
571 139310 0.0 964
572 139320 0.0 1047
573 139480 0.0 1061
574 139660 0.0 1010
575 140570 0.0 1037
576 140580 0.0 1037
577 140700 0.0 1030
578 140710 0.0 1029
579 140950 0.0 1028
580 141240 0.0 832
581 143460 0.0 998
582 143850 0.0 977
583 143860 0.0 983
584 144600 0.0 967
585 144620 0.0 849
586 145210 0.0 88
587 145670 0.0 944
588 145850 0.0 914
589 145990 0.0 3982
590 145995 0.0 740
591 147970 0.0 828
592 148020 0.0 916
593 148040 0.0 358
594 148070 0.0 909
595 150460 0.0 878
596 152100 0.0 859
597 152180 0.0 827
598 152280 0.0 847
599 152380 0.0 791
600 152870 0.0 836
601 153130 0.0 830
602 153270 0.0 729
603 155660 0.0 567
604 156080 0.0 523
605 157450 0.0 769
606 157510 0.0 666
607 157520 0.0 600
608 157650 0.0 534
609 159800 0.0 542
610 160580 0.0 592
611 161000 0.0 3899
612 161390 0.0 726
613 161500 0.0 703
614 161510 0.0 704
615 161890 0.0 710
616 163560 0.0 644
617 166400 0.0 418
618 167860 0.0 655
619 168300 0.0 434
620 168580 0.0 640
621 169950 0.0 607
622 170350 0.0 464
623 170900 0.0 594
624 174350 0.0 5
625 174360 0.0 510
626 176710 0.0 434
627 176950 0.0 508
628 180640 0.0 478
629 18064K 0.0 450
630 181450 0.0 473
631 181480 0.0 473
632 181710 0.0 492
633 182480 0.0 401
634 182490 0.0 269
635 183190 0.0 444
636 183700 0.0 325
637 183710 0.0 324
638 185750 0.0 422
639 189400 0.0 383
640 190150 0.0 371
641 190160 0.0 372
642 190620 0.0 376
643 192400 0.0 249
644 192530 0.0 302
645 192720 0.0 334
646 192820 0.0 336
647 195920 0.0 279
648 195930 0.0 285
649 195970 0.0 281
650 195980 0.0 281
651 196230 0.0 193

In [35]:
DB[651]


Out[35]:
[651,
 '196230',
 0.0,
            Date    Open    High     Low   Close  Volume  Adj Close  \
 0    2014-05-22  100085  100085  100080  100080     400   99190.64   
 1    2014-05-23  100090  100090  100090  100090     500   99200.55   
 2    2014-05-28  100105  100105  100105  100105   20000   99215.42   
 3    2014-05-29  100130  100130  100115  100120   44500   99230.28   
 4    2014-05-30  100110  100140  100110  100135   25400   99245.15   
 5    2014-06-03  100180  100180  100175  100175  148000   99284.79   
 6    2014-06-05  100185  100185  100185  100185       0   99294.70   
 7    2014-06-09  100190  100190  100185  100185   10000   99294.70   
 8    2014-06-10  100190  100200  100190  100200       0   99309.57   
 9    2014-06-12  100230  100230  100230  100230       0   99339.30   
 10   2014-06-13  100245  100245  100245  100245   20000   99354.17   
 11   2014-06-16  100250  100250  100250  100250   20000   99359.13   
 12   2014-06-17  100260  100260  100260  100260       0   99369.04   
 13   2014-06-18  100265  100265  100265  100265       0   99373.99   
 14   2014-06-19  100285  100285  100285  100285   98000   99393.82   
 15   2014-06-20  100290  100290  100290  100290       0   99398.77   
 16   2014-06-23  100300  100300  100300  100300   69900   99408.68   
 17   2014-06-24  100310  100310  100310  100310       0   99418.59   
 18   2014-06-25  100315  100315  100315  100315       0   99423.55   
 19   2014-06-26  100330  100330  100330  100330       0   99438.42   
 20   2014-06-27  100340  100340  100340  100340       0   99448.33   
 21   2014-06-30  100345  100345  100345  100345     500   99453.28   
 22   2014-07-01  100355  100355  100355  100355       0   99463.19   
 23   2014-07-02  100365  100365  100365  100365   15000   99473.10   
 24   2014-07-03  100400  100400  100400  100400       0   99507.79   
 25   2014-07-04  100405  100405  100405  100405       0   99512.75   
 26   2014-07-07  100410  100410  100410  100410       0   99517.70   
 27   2014-07-08  100415  100415  100415  100415       0   99522.66   
 28   2014-07-09  100425  100425  100425  100425       0   99532.57   
 29   2014-07-10  100450  100450  100450  100450       0   99557.35   
 ..          ...     ...     ...     ...     ...     ...        ...   
 163  2015-05-08  101465  101465  101460  101460    9800  101460.00   
 164  2015-05-11  101480  101480  101480  101480       0  101480.00   
 165  2015-05-15  101510  101510  101505  101505    2600  101505.00   
 166  2015-05-26  101545  101545  101540  101540    3300  101540.00   
 167  2015-05-27  101550  101550  101545  101545       0  101545.00   
 168  2015-05-29  101575  101575  101570  101570    5700  101570.00   
 169  2015-06-02  101610  101610  101610  101610       0  101610.00   
 170  2015-06-04  101615  101615  101610  101610    1300  101610.00   
 171  2015-06-08  101615  101615  101615  101615       0  101615.00   
 172  2015-06-11  101670  101670  101670  101670       0  101670.00   
 173  2015-06-12  101665  101665  101665  101665       0  101665.00   
 174  2015-06-15  101700  101700  101695  101695   11900  101695.00   
 175  2015-06-16  101700  101700  101690  101690   19300  101690.00   
 176  2015-06-18  101715  101715  101710  101710   16200  101710.00   
 177  2015-06-22  101720  101720  101715  101715   76700  101715.00   
 178  2015-06-23  101710  101715  101710  101715       0  101715.00   
 179  2015-06-24  101715  101715  101715  101715       0  101715.00   
 180  2015-06-25  101730  101730  101725  101725    3000  101725.00   
 181  2015-06-26  101730  101730  101725  101725    1000  101725.00   
 182  2015-06-30  101745  101745  101740  101740   23100  101740.00   
 183  2015-07-01  101745  101750  101745  101750    2000  101750.00   
 184  2015-07-02  101755  101760  101755  101760    1000  101760.00   
 185  2015-07-06  101765  101765  101765  101765     100  101765.00   
 186  2015-07-07  101775  101780  101775  101775   10700  101775.00   
 187  2015-07-08  101785  101785  101785  101785     100  101785.00   
 188  2015-07-09  101800  101805  101800  101805     300  101805.00   
 189  2015-07-10  101805  101805  101805  101805     200  101805.00   
 190  2015-07-14  101815  101815  101815  101815     100  101815.00   
 191  2015-07-17  101835  101835  101835  101835       0  101835.00   
 192  2015-07-20  101835  101840  101835  101840   58500  101840.00   
 
               MA30           MA60          MA120  MA240  
 0              NaN            NaN            NaN    NaN  
 1              NaN            NaN            NaN    NaN  
 2              NaN            NaN            NaN    NaN  
 3              NaN            NaN            NaN    NaN  
 4              NaN            NaN            NaN    NaN  
 5              NaN            NaN            NaN    NaN  
 6              NaN            NaN            NaN    NaN  
 7              NaN            NaN            NaN    NaN  
 8              NaN            NaN            NaN    NaN  
 9              NaN            NaN            NaN    NaN  
 10             NaN            NaN            NaN    NaN  
 11             NaN            NaN            NaN    NaN  
 12             NaN            NaN            NaN    NaN  
 13             NaN            NaN            NaN    NaN  
 14             NaN            NaN            NaN    NaN  
 15             NaN            NaN            NaN    NaN  
 16             NaN            NaN            NaN    NaN  
 17             NaN            NaN            NaN    NaN  
 18             NaN            NaN            NaN    NaN  
 19             NaN            NaN            NaN    NaN  
 20             NaN            NaN            NaN    NaN  
 21             NaN            NaN            NaN    NaN  
 22             NaN            NaN            NaN    NaN  
 23             NaN            NaN            NaN    NaN  
 24             NaN            NaN            NaN    NaN  
 25             NaN            NaN            NaN    NaN  
 26             NaN            NaN            NaN    NaN  
 27             NaN            NaN            NaN    NaN  
 28             NaN            NaN            NaN    NaN  
 29    99384.399333            NaN            NaN    NaN  
 ..             ...            ...            ...    ...  
 163  101281.000000  100994.304667  100591.496417    NaN  
 164  101297.333333  101009.747667  100605.866667    NaN  
 165  101314.000000  101025.524833  100620.362667    NaN  
 166  101331.000000  101041.885333  100635.109000    NaN  
 167  101347.500000  101058.329167  100649.607917    NaN  
 168  101363.500000  101075.024333  100664.273917    NaN  
 169  101379.166667  101092.221000  100679.149333    NaN  
 170  101394.000000  101109.500333  100693.859583    NaN  
 171  101408.166667  101126.532667  100708.446333    NaN  
 172  101423.333333  101144.316500  100723.450083    NaN  
 173  101438.000000  101161.934333  100738.205667    NaN  
 174  101453.500000  101179.969500  100753.170000    NaN  
 175  101468.500000  101197.756167  100767.927417    NaN  
 176  101483.500000  101215.793667  100782.727667    NaN  
 177  101498.333333  101233.666667  100797.528250    NaN  
 178  101512.333333  101250.666667  100812.328833    NaN  
 179  101526.333333  101267.333333  100827.005583    NaN  
 180  101539.333333  101284.166667  100841.063583    NaN  
 181  101551.500000  101300.666667  100854.956417    NaN  
 182  101564.000000  101317.416667  100868.891667    NaN  
 183  101576.000000  101333.583333  100882.662417    NaN  
 184  101588.333333  101349.583333  100896.351333    NaN  
 185  101600.333333  101365.500000  100910.081917    NaN  
 186  101612.166667  101381.083333  100923.771917    NaN  
 187  101624.333333  101397.083333  100937.462667    NaN  
 188  101637.333333  101413.000000  100951.237500    NaN  
 189  101649.500000  101428.750000  100964.929750    NaN  
 190  101662.000000  101444.500000  100978.457583    NaN  
 191  101675.166667  101460.083333  100992.028167    NaN  
 192  101687.833333  101475.666667  101005.475250    NaN  
 
 [193 rows x 11 columns]]

In [30]:
len(DB[0][3]['MA240'])


Out[30]:
3365

In [23]:
for file in range(len(DB)):
    print (len(DB[100][3].index))


3899
3899
3899
3899
3899
3899
3899
3899
3899
3899
3899
3899
3899
3899
3899
3899
3899
3899
3899
3899
3899
3899
3899
3899
3899
3899
3899
3899
3899
3899
3899
3899
3899
3899
3899
3899
3899
3899
3899
3899
3899
3899
3899
3899
3899
3899
3899
3899
3899
3899
3899
3899
3899
3899
3899
3899
3899
3899
3899
3899
3899
3899
3899
3899
3899
3899
3899
3899
3899
3899
3899
3899
3899
3899
3899
3899
3899
3899
3899
3899
3899
3899
3899
3899
3899
3899
3899
3899
3899
3899
3899
3899
3899
3899
3899
3899
3899
3899
3899
3899
3899
3899
3899
3899
3899
3899
3899
3899
3899
3899
3899
3899
3899
3899
3899
3899
3899
3899
3899
3899
3899
3899
3899
3899
3899
3899
3899
3899
3899
3899
3899
3899
3899
3899
3899
3899
3899
3899
3899
3899
3899
3899
3899
3899
3899
3899
3899
3899
3899
3899
3899
3899
3899
3899
3899
3899
3899
3899
3899
3899
3899
3899
3899
3899
3899
3899
3899
3899
3899
3899
3899
3899
3899
3899
3899
3899
3899
3899
3899
3899
3899
3899
3899
3899
3899
3899
3899
3899
3899
3899
3899
3899
3899
3899
3899
3899
3899
3899
3899
3899
3899
3899
3899
3899
3899
3899
3899
3899
3899
3899
3899
3899
3899
3899
3899
3899
3899
3899
3899
3899
3899
3899
3899
3899
3899
3899
3899
3899
3899
3899
3899
3899
3899
3899
3899
3899
3899
3899
3899
3899
3899
3899
3899
3899
3899
3899
3899
3899
3899
3899
3899
3899
3899
3899
3899
3899
3899
3899
3899
3899
3899
3899
3899
3899
3899
3899
3899
3899
3899
3899
3899
3899
3899
3899
3899
3899
3899
3899
3899
3899
3899
3899
3899
3899
3899
3899
3899
3899
3899
3899
3899
3899
3899
3899
3899
3899
3899
3899
3899
3899
3899
3899
3899
3899
3899
3899
3899
3899
3899
3899
3899
3899
3899
3899
3899
3899
3899
3899
3899
3899
3899
3899
3899
3899
3899
3899
3899
3899
3899
3899
3899
3899
3899
3899
3899
3899
3899
3899
3899
3899
3899
3899
3899
3899
3899
3899
3899
3899
3899
3899
3899
3899
3899
3899
3899
3899
3899
3899
3899
3899
3899
3899
3899
3899
3899
3899
3899
3899
3899
3899
3899
3899
3899
3899
3899
3899
3899
3899
3899
3899
3899
3899
3899
3899
3899
3899
3899
3899
3899
3899
3899
3899
3899
3899
3899
3899
3899
3899
3899
3899
3899
3899
3899
3899
3899
3899
3899
3899
3899
3899
3899
3899
3899
3899
3899
3899
3899
3899
3899
3899
3899
3899
3899
3899
3899
3899
3899
3899
3899
3899
3899
3899
3899
3899
3899
3899
3899
3899
3899
3899
3899
3899
3899
3899
3899
3899
3899
3899
3899
3899
3899
3899
3899
3899
3899
3899
3899
3899
3899
3899
3899
3899
3899
3899
3899
3899
3899
3899
3899
3899
3899
3899
3899
3899
3899
3899
3899
3899
3899
3899
3899
3899
3899
3899
3899
3899
3899
3899
3899
3899
3899
3899
3899
3899
3899
3899
3899
3899
3899
3899
3899
3899
3899
3899
3899
3899
3899
3899
3899
3899
3899
3899
3899
3899
3899
3899
3899
3899
3899
3899
3899
3899
3899
3899
3899
3899
3899
3899
3899
3899
3899
3899
3899
3899
3899
3899
3899
3899
3899
3899
3899
3899
3899
3899
3899
3899
3899
3899
3899
3899
3899
3899
3899
3899
3899
3899
3899
3899
3899
3899
3899
3899
3899
3899
3899
3899
3899
3899
3899
3899
3899
3899
3899
3899
3899
3899
3899
3899
3899
3899
3899
3899
3899
3899
3899
3899
3899
3899
3899
3899
3899
3899
3899
3899
3899
3899
3899
3899
3899
3899
3899
3899
3899
3899
3899
3899
3899
3899
3899
3899
3899
3899
3899
3899
3899
3899
3899
3899
3899
3899
3899
3899
3899
3899
3899
3899
3899
3899
3899
3899
3899
3899
3899
3899
3899
3899
3899
3899
3899
3899
3899
3899
3899
3899
3899
3899
3899
3899
3899
3899
3899
3899