I tried to plot a basic candlestick with csv files. it runs but chart seems 
incorrect. anyone can help? highly appreciated.
tia

-- 
You received this message because you are subscribed to the Google Groups 
"pyqtgraph" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to [email protected].
To view this discussion on the web visit 
https://groups.google.com/d/msgid/pyqtgraph/8ff97a61-5eb5-490c-91a2-6458d23aa168%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.
1483022040,116.6801,116.8100,116.5700,116.6400,762600
1483022398,117.0700,117.0700,116.6900,116.7000,582100
1483022640,116.7800,117.1095,116.7059,117.0550,444800
1483022940,116.7400,116.8800,116.6900,116.7700,303500
1483023298,116.7850,116.8565,116.6900,116.7335,261500
1483023540,116.8300,116.8600,116.6900,116.7750,208500
1483023840,116.8700,116.9500,116.8100,116.8249,261300
1483024199,116.6800,116.8800,116.6700,116.8800,232100
1483024440,116.7800,116.8100,116.6500,116.6700,182800
1483024740,116.9190,116.9300,116.7700,116.7700,189000
1483025044,116.9500,116.9800,116.9050,116.9100,173800
1483025340,117.0350,117.1000,116.9500,116.9600,301900
1483025640,116.9600,117.0400,116.9500,117.0346,162300
1483025941,116.8800,117.0200,116.8800,116.9500,212200
1483026240,116.7000,116.8900,116.7000,116.8900,287800
1483026541,116.7100,116.8700,116.6800,116.6950,214200
1483026843,116.6700,116.7095,116.6000,116.7000,196800
1483027141,116.7090,116.7900,116.6600,116.6600,216500
1483027440,116.6500,116.7148,116.6200,116.7100,132600
1483027740,116.6500,116.7150,116.5900,116.6450,217600
1483028045,116.6100,116.6750,116.6100,116.6450,143500
1483028340,116.6400,116.6400,116.5300,116.6050,153600
1483028699,116.5590,116.6700,116.5400,116.6376,150100
1483028940,116.6150,116.6500,116.5450,116.5500,132300
1483029240,116.5400,116.6200,116.5100,116.6200,171900
1483029541,116.6000,116.6400,116.5500,116.5500,219200
1483029850,116.5690,116.6090,116.5600,116.6075,78900
1483030147,116.6000,116.6147,116.5550,116.5634,135800
1483030446,116.4750,116.5957,116.4000,116.5957,207600
1483030745,116.5050,116.5600,116.4700,116.4765,132000
1483031042,116.6199,116.6400,116.4900,116.5100,224500
1483031342,116.6200,116.6399,116.5750,116.6150,128100
1483031698,116.6101,116.6400,116.5400,116.6101,134200
1483031942,116.6600,116.6900,116.6100,116.6150,149400
1483032297,116.6750,116.6900,116.6000,116.6550,117200
1483032599,116.6300,116.7200,116.6200,116.6700,94400
1483032840,116.6400,116.6700,116.6300,116.6335,54700
1483033140,116.6250,116.6750,116.6200,116.6500,78900
1483033440,116.6350,116.6750,116.6200,116.6200,62000
1483033799,116.6901,116.7350,116.6300,116.6400,126200
1483034043,116.7465,116.7500,116.6950,116.6950,102100
1483034340,116.6300,116.7700,116.5500,116.7468,204000
1483034643,116.6458,116.6850,116.6100,116.6200,66200
1483034944,116.6400,116.6600,116.6200,116.6447,97800
1483035243,116.6400,116.6800,116.6243,116.6300,171400
1483035543,116.6850,116.6900,116.6259,116.6350,61700
1483035849,116.7150,116.7200,116.6800,116.6900,77000
1483036144,116.6500,116.7400,116.6500,116.7100,90400
1483036441,116.6200,116.6560,116.5800,116.6401,149900
1483036740,116.5658,116.6300,116.5400,116.6250,120700
1483037042,116.4801,116.5700,116.4800,116.5650,161400
1483037341,116.5600,116.6000,116.4800,116.4899,124600
1483037697,116.5700,116.6500,116.5400,116.5642,198500
1483037940,116.6050,116.6150,116.5100,116.5750,104200
1483038242,116.6500,116.6950,116.5850,116.6035,175300
1483038599,116.5933,116.6499,116.5800,116.6450,99400
1483038844,116.6200,116.6300,116.5800,116.6000,84000
1483039146,116.6250,116.6800,116.6100,116.6110,71800
1483039441,116.6200,116.6500,116.6001,116.6300,88800
1483039748,116.6100,116.6499,116.5900,116.6190,72200
1483040040,116.5293,116.6599,116.5200,116.6200,122000
1483040341,116.5800,116.5900,116.5300,116.5300,121300
1483040640,116.6100,116.6200,116.5400,116.5799,132500
1483040941,116.5800,116.6500,116.5600,116.6150,127200
1483041299,116.6123,116.6500,116.5900,116.5900,156000
1483041546,116.5900,116.6300,116.5800,116.6200,109400
1483041845,116.6300,116.6400,116.5800,116.6000,85000
1483042143,116.6450,116.6600,116.6100,116.6200,99200
1483042441,116.6500,116.7000,116.6400,116.6400,113600
1483042798,116.6875,116.7000,116.6300,116.6600,101000
1483043053,116.6800,116.7300,116.6700,116.6816,154800
1483043340,116.6200,116.6900,116.6100,116.6875,121900
1483043640,116.6650,116.7100,116.6200,116.6300,137600
1483043942,116.6335,116.6700,116.5850,116.6635,194700
1483044241,116.6100,116.6500,116.5800,116.6350,167200
1483044540,116.6325,116.6500,116.6100,116.6150,228000
1483044841,116.7100,116.7300,116.6375,116.6400,311100
1483045140,116.7300,116.7400,116.6300,116.7150,0
1483045200,116.7300,116.7300,116.7300,116.7300,7200
1483108442,117.0500,117.2000,116.8100,116.8500,1347800
1483108740,116.9800,117.0950,116.8700,117.0550,455000
1483109040,116.9200,117.0600,116.8100,116.9750,397200
1483109340,116.8900,117.0300,116.8500,116.9100,288900
1483109641,116.7150,116.9000,116.6600,116.8901,303100
1483109940,116.2000,116.7600,116.0900,116.7300,576600
1483110240,116.2800,116.4200,116.0700,116.1900,510900
1483110540,116.3000,116.3800,116.1500,116.2900,290300
1483110899,116.3401,116.3500,116.2600,116.3001,232600
1483111141,116.3200,116.4300,116.2950,116.3500,282400
1483111440,116.2300,116.3665,116.1200,116.3250,284000
1483111799,116.1807,116.3000,116.1800,116.2200,200500
1483112041,116.2900,116.3300,116.1800,116.1800,203500
1483112341,116.1950,116.2900,116.1400,116.2800,204800
1483112641,116.1700,116.2700,116.1600,116.2000,177700
1483112940,116.0800,116.1700,116.0500,116.1602,276500
1483113240,116.0600,116.1400,116.0400,116.0850,226500
1483113540,116.2094,116.2300,116.0600,116.0700,222600
1483113841,116.2400,116.2500,116.1700,116.2000,180900
1483114140,116.2299,116.2500,116.1835,116.2403,119900
1483114440,116.1800,116.2600,116.1700,116.2250,166200
1483114740,116.2850,116.3000,116.1899,116.1899,152600
1483115041,116.3100,116.3700,116.2710,116.2800,182000
1483115398,116.4040,116.4400,116.3019,116.3040,232500
1483115640,116.5100,116.5300,116.3900,116.4025,203200
1483115947,116.4850,116.5400,116.4700,116.5139,173900
1483116251,116.4700,116.5200,116.4500,116.4800,127800
1483116599,116.4412,116.5000,116.4400,116.4750,110400
1483116841,116.3800,116.4600,116.3800,116.4400,119000
1483117140,116.3400,116.3800,116.3200,116.3750,126500
1483117499,115.9700,116.3500,115.8600,116.3300,827000
1483117741,116.1500,116.2100,115.8200,115.9500,532500
1483118041,116.0700,116.2400,116.0500,116.1450,460100
1483118340,115.7242,116.1200,115.5713,116.0800,749900
1483118641,115.8235,115.9800,115.6440,115.7293,491300
1483118940,115.8900,115.9535,115.8000,115.8350,232800
1483119240,115.9600,116.0000,115.8800,115.8950,235100
1483119599,115.9165,115.9700,115.8813,115.9610,144500
1483119840,115.7822,115.9400,115.7500,115.9147,369300
1483120140,115.7600,115.8500,115.7400,115.7900,230500
1483120440,115.7541,115.7765,115.5900,115.7550,386100
1483120741,115.7150,115.7700,115.6900,115.7500,259700
1483121040,115.5900,115.7200,115.5900,115.7141,372200
1483121340,115.5200,115.6100,115.4600,115.5801,525600
1483121699,115.6035,115.6200,115.5100,115.5150,294400
1483121940,115.7550,115.7600,115.5900,115.6000,242600
1483122240,115.8794,115.9000,115.7300,115.7557,260200
1483122541,115.8300,115.9400,115.8300,115.8800,190000
1483122840,115.7950,115.8800,115.7750,115.8201,200600
1483123140,115.7300,115.8100,115.7300,115.7900,152900
1483123442,115.6200,115.7500,115.6100,115.7400,230000
1483123741,115.5854,115.6561,115.5800,115.6300,188100
1483124040,115.6400,115.6800,115.5600,115.5842,239600
1483124399,115.6601,115.6900,115.6100,115.6443,186900
1483124642,115.6000,115.6700,115.5900,115.6600,153700
1483124940,115.5900,115.6300,115.5800,115.6044,166100
1483125246,115.6500,115.6500,115.5400,115.5850,234300
1483125597,115.7090,115.7100,115.6400,115.6450,177700
1483125840,115.6501,115.7200,115.6400,115.7000,184300
1483126141,115.5700,115.6700,115.5600,115.6550,192800
1483126441,115.6421,115.6500,115.5000,115.5750,245200
1483126740,115.6700,115.7000,115.6300,115.6400,172600
1483127042,115.7111,115.7200,115.6600,115.6732,153700
1483127340,115.5500,115.7100,115.5200,115.7000,257900
1483127641,115.5100,115.6400,115.5000,115.5400,304200
1483127940,115.5600,115.5700,115.4700,115.5150,341000
1483128240,115.6100,115.6200,115.5400,115.5700,268600
1483128540,115.5850,115.6200,115.5400,115.6000,219400
1483128899,115.6415,115.6700,115.5700,115.5900,235800
1483129199,115.6455,115.7200,115.6300,115.6450,249000
1483129440,115.7100,115.7250,115.6500,115.6500,422900
1483129741,115.7500,115.7500,115.6650,115.7117,331500
1483130099,115.7742,115.7800,115.6800,115.7550,322300
1483130340,115.7443,115.7900,115.7200,115.7714,301600
1483130640,115.5850,115.7500,115.5800,115.7500,382300
1483130999,115.5341,115.6300,115.5300,115.5900,611200
1483131240,115.5738,115.5800,115.4300,115.5300,686100
1483131540,115.8400,115.9900,115.5850,115.5900,1950600
1483131600,115.8700,115.8700,115.8700,115.8700,100
1483454099,116.1500,116.3300,115.5200,115.7300,0
1483454340,115.1900,116.2500,115.1400,116.2000,1247400
1483454641,115.4100,115.4400,114.7650,115.2031,1297900
1483454940,115.2200,115.4350,115.0600,115.4100,741500
1483455240,115.2742,115.3900,115.1100,115.2100,586100
1483455542,115.6500,115.7000,115.2500,115.2799,533000
1483455840,115.5700,115.6600,115.4967,115.6600,478400
1483456199,115.7837,115.8000,115.3200,115.5800,727200
1483456440,115.6700,115.8300,115.6700,115.7850,413800
1483456741,115.5300,115.6900,115.4600,115.6900,346100
1483457046,115.7300,115.7400,115.5200,115.5200,257500
1483457340,115.7000,115.7400,115.6600,115.7399,303400
1483457640,115.7650,115.7800,115.6900,115.6950,264300
1483457942,115.7200,115.7800,115.6750,115.7642,294300
1483458240,115.7100,115.7800,115.6700,115.7258,262000
1483458599,115.6547,115.7800,115.6500,115.7050,285000
1483458899,115.6000,115.6600,115.5300,115.6565,296600
1483459140,115.4500,115.6000,115.4000,115.5900,380000
1483459440,115.5300,115.5600,115.3450,115.4600,352200
1483459740,115.6250,115.6800,115.5350,115.5353,236700
1483460040,115.6350,115.6700,115.5700,115.6300,251500
1483460340,115.3700,115.6400,115.3500,115.6400,279700
1483460642,115.5400,115.5500,115.3750,115.3800,218400
1483460940,115.3500,115.5450,115.3100,115.5443,265100
1483461241,115.4700,115.5300,115.3500,115.3600,202100
1483461540,115.2500,115.4900,115.2100,115.4600,344600
1483461840,115.1900,115.2600,115.1400,115.2543,350800
1483462141,115.2900,115.3600,115.1300,115.1850,321900
1483462440,115.3300,115.3550,115.2600,115.2800,147100
1483462798,115.3757,115.3918,115.2550,115.3350,211900
1483463042,115.3800,115.4199,115.3500,115.3900,292500
1483463343,115.3507,115.4100,115.2600,115.3848,185300
1483463642,115.4200,115.5300,115.3450,115.3500,222000
1483463942,115.4300,115.4600,115.3600,115.4250,110100
1483464243,115.3650,115.4450,115.3200,115.4250,134800
1483464547,115.3800,115.4400,115.3700,115.3700,117600
1483464842,115.4750,115.4800,115.3300,115.3841,114500
1483465140,115.3939,115.4700,115.3800,115.4700,128800
1483465440,115.2950,115.4000,115.2900,115.4000,105500
1483465741,115.4600,115.4600,115.2700,115.2900,200300
1483466044,115.3800,115.4700,115.3600,115.4700,109500
1483466340,115.4650,115.4800,115.3900,115.3900,144000
1483466641,115.4500,115.5200,115.4400,115.4700,140100
1483466940,115.3850,115.4900,115.3694,115.4535,146000
1483467241,115.4900,115.5000,115.3850,115.3900,148500
1483467544,115.4600,115.5000,115.4500,115.4800,96400
1483467841,115.4800,115.5000,115.4300,115.4569,127100
1483468144,115.4000,115.4900,115.4000,115.4850,102800
1483468441,115.4350,115.4400,115.3800,115.4100,96100
1483468740,115.2900,115.4300,115.2800,115.4300,158900
1483469043,115.2900,115.3259,115.2800,115.2943,132400
1483469341,115.3051,115.4000,115.2600,115.3000,155500
1483469641,115.3200,115.3500,115.3100,115.3100,194200
1483469943,115.2350,115.3300,115.2300,115.3235,203900
1483470299,115.2018,115.3100,115.2000,115.2400,254600
1483470598,115.1600,115.2200,115.1600,115.2000,188800
1483470893,115.2343,115.2500,115.1500,115.1631,219900
1483471185,115.2200,115.2700,115.2100,115.2300,137600
1483471441,115.2800,115.2800,115.2100,115.2254,165600
1483471742,115.3700,115.3700,115.2700,115.2799,188300
1483472044,115.3800,115.4200,115.3600,115.3650,200500
1483472341,115.3750,115.4200,115.3600,115.3850,199400
1483472642,115.4400,115.4600,115.3700,115.3790,211400
1483472944,115.3900,115.4550,115.3800,115.4500,183900
1483473299,115.3950,115.4100,115.3700,115.3925,166400
1483473540,115.4300,115.4400,115.4000,115.4000,184600
1483473840,115.5500,115.5550,115.4300,115.4500,293600
1483474141,115.6100,115.6300,115.5500,115.5599,286100
1483474440,115.5800,115.6300,115.5800,115.6001,155700
1483474745,115.5300,115.6000,115.5300,115.5850,160300
1483475043,115.4942,115.5499,115.4700,115.5350,293900
1483475342,115.4800,115.5200,115.4600,115.5000,192300
1483475645,115.4900,115.5000,115.3900,115.4700,358800
1483475940,115.5600,115.5600,115.3900,115.4900,536500
1483476242,115.6000,115.7300,115.5685,115.5700,454400
1483476540,115.6700,115.7000,115.6000,115.6100,322800
1483476841,115.9593,115.9700,115.6900,115.7500,932400
1483477140,116.1400,116.1400,115.9100,115.9575,1676200
1483477200,116.1500,116.1500,116.1500,116.1500,2334600
1483540499,116.3500,116.4100,115.8400,115.8400,0
1483540740,116.2400,116.4000,116.2305,116.3900,701100
1483541040,116.2400,116.5000,116.1350,116.2500,716800
1483541341,116.3398,116.4400,116.2400,116.2500,362900
1483541640,116.3800,116.4650,116.2900,116.3500,439500
1483541940,116.2700,116.4191,116.2500,116.3750,306100
1483542240,116.3850,116.3900,116.2600,116.2650,374000
1483542541,116.3300,116.3900,116.2600,116.3800,284000
1483542899,116.2101,116.3300,116.1600,116.3200,344000
1483543141,116.1900,116.2300,116.1300,116.2199,227400
1483543440,116.1342,116.2050,116.0500,116.1900,243100
1483543742,116.0900,116.2100,116.0800,116.1301,218900
1483544099,115.9061,116.1450,115.8700,116.0800,436400
1483544340,115.9300,116.0100,115.9000,115.9100,257400
1483544646,115.9900,116.0750,115.9350,115.9350,231600
1483544999,116.0110,116.1100,115.9400,116.0000,272300
1483545246,116.0000,116.1000,115.9700,116.0200,233600
1483545540,115.9600,116.0100,115.9400,115.9950,257000
1483545844,116.0100,116.0700,115.9600,115.9600,255900
1483546142,116.0400,116.0900,115.9700,116.0200,218300
1483546499,116.0168,116.0350,115.9800,116.0300,285500
1483546740,115.9400,116.0500,115.9050,116.0100,242200
1483547041,116.0000,116.0000,115.9300,115.9500,155600
1483547340,116.0576,116.0752,115.9700,115.9964,170600
1483547640,116.1100,116.1400,116.0500,116.0590,197500
1483547997,116.3000,116.3000,116.1100,116.1134,233200
1483548244,116.2400,116.3000,116.1900,116.2900,150100
1483548541,116.2800,116.3400,116.2200,116.2500,163900
1483548840,116.3065,116.3600,116.2600,116.2850,136500
1483549140,116.3700,116.3800,116.3000,116.3050,177000
1483549440,116.3750,116.3800,116.3100,116.3650,111600
1483549745,116.2800,116.3708,116.2600,116.3600,116800
1483550044,116.2250,116.2999,116.1700,116.2900,136000
1483550343,116.1647,116.2500,116.1300,116.2300,139400
1483550640,116.1900,116.2000,116.1200,116.1601,149900
1483550945,116.1558,116.2061,116.1200,116.1950,126500
1483551241,116.0700,116.1600,116.0600,116.1600,169200
1483551547,116.1300,116.1300,116.0400,116.0764,119300
1483551840,116.1767,116.2050,116.1200,116.1200,107400
1483552199,116.2065,116.2100,116.1600,116.1700,126200
1483552499,116.1400,116.2100,116.1200,116.2100,139800
1483552742,116.1300,116.1500,116.0800,116.1441,95800
1483553099,116.1300,116.1610,116.1200,116.1400,84900
1483553347,116.1200,116.1400,116.0950,116.1200,89900
1483553644,116.1300,116.1500,116.1000,116.1252,97900
1483553945,116.1600,116.1700,116.1000,116.1200,116000
1483554240,116.1550,116.2000,116.1300,116.1693,107600
1483554542,116.1600,116.1700,116.1400,116.1500,109100
1483554840,116.2050,116.2100,116.1400,116.1602,160300
1483555146,116.2400,116.2500,116.1800,116.2000,132400
1483555441,116.2000,116.2700,116.2000,116.2461,131600
1483555798,116.1859,116.2200,116.1450,116.2041,134200
1483556043,116.2599,116.2599,116.1800,116.1850,132600
1483556348,116.2100,116.2600,116.1900,116.2500,167300
1483556642,116.1700,116.3000,116.1600,116.2189,209900
1483556945,116.1000,116.1900,116.0800,116.1750,223000
1483557240,116.2100,116.2250,116.0500,116.1200,214000
1483557540,116.2100,116.2550,116.1600,116.2150,148700
1483557840,116.1600,116.2900,116.1400,116.2300,235600
1483558141,116.2400,116.2600,116.1600,116.1700,140800
1483558441,116.2300,116.2800,116.2000,116.2350,163000
1483558740,116.1800,116.2600,116.1500,116.2399,349500
1483559040,116.1600,116.2400,116.1500,116.1900,135800
1483559349,116.1000,116.1643,116.0700,116.1643,183200
1483559647,116.1100,116.1198,116.0500,116.0900,143000
1483559940,116.0608,116.1380,116.0400,116.1200,140200
1483560240,116.0000,116.0700,116.0000,116.0600,197600
1483560541,116.1100,116.1200,116.0050,116.0050,128000
1483560840,116.1300,116.1350,116.0500,116.1100,183400
1483561198,116.0732,116.1300,116.0700,116.1100,124400
1483561440,116.0400,116.0900,116.0400,116.0700,194800
1483561723,115.9850,116.0550,115.9801,116.0300,223100
1483561831,116.0200,116.0200,116.0200,116.0200,616600
1483562641,116.0242,116.0800,116.0100,116.0250,213800
1483562996,115.9064,116.0250,115.9000,116.0200,304800
1483563240,116.0499,116.0900,115.9100,115.9200,600100
1483563540,116.0200,116.0900,115.9600,116.0500,0
1483563600,116.0200,116.0200,116.0200,116.0200,6400
1483626840,116.4602,116.5100,115.9100,115.9600,1395700
1483627142,116.4041,116.5000,116.3300,116.4950,563900
1483627440,116.6700,116.7400,116.3900,116.4100,869400
1483627740,116.8300,116.8500,116.6500,116.6650,452200
1483628040,116.8000,116.8500,116.6650,116.8200,469000
1483628341,116.6700,116.8450,116.5800,116.8050,382600
1483628699,116.6100,116.8000,116.5500,116.6800,332500
1483628942,116.6300,116.7300,116.6100,116.6200,218400
1483629243,116.7450,116.7600,116.6200,116.6200,261100
1483629540,116.5126,116.7900,116.5100,116.7500,327600
1483629842,116.4100,116.5500,116.3300,116.5237,382700
1483630140,116.5500,116.6200,116.4200,116.4235,333800
1483630440,116.3400,116.5800,116.2700,116.5600,603700
1483630740,116.2700,116.3400,116.1800,116.3350,398100
1483631045,116.1300,116.3600,116.1000,116.2600,294500
1483631342,116.2041,116.2100,116.0800,116.1400,296200
1483631640,116.2040,116.2500,116.1700,116.2100,194100
1483631946,116.3400,116.3700,116.1700,116.2100,218700
1483632242,116.2700,116.4000,116.2300,116.3290,183900
1483632599,116.0941,116.2800,116.0500,116.2735,334900
1483632899,116.0862,116.1550,116.0200,116.0800,275800
1483633145,116.1700,116.1899,116.0500,116.0900,227200
1483633449,116.1285,116.2135,116.0700,116.1850,169900
1483633740,116.0500,116.1900,116.0500,116.1200,180600
1483634044,116.0800,116.1400,116.0400,116.0600,122700
1483634340,116.1000,116.1200,116.0000,116.0900,183000
1483634699,115.9644,116.1100,115.9400,116.1050,234100
1483634999,116.1449,116.1700,115.9400,115.9600,400300
1483635241,116.3101,116.3200,116.1200,116.1400,375200
1483635542,116.2900,116.3300,116.2700,116.3150,254800
1483635840,116.2700,116.4000,116.2600,116.3000,303400
1483636141,116.3353,116.3353,116.2100,116.2750,182200
1483636440,116.3300,116.3450,116.2635,116.3300,347000
1483636741,116.5400,116.5550,116.3340,116.3340,292300
1483637040,116.4600,116.5700,116.4100,116.5468,276100
1483637340,116.5150,116.5800,116.4638,116.4700,221400
1483637640,116.5800,116.5850,116.4500,116.5100,315500
1483637940,116.6300,116.6600,116.5600,116.5735,263200
1483638243,116.6400,116.6700,116.6200,116.6385,222700
1483638542,116.7573,116.7600,116.6300,116.6450,329900
1483638843,116.7400,116.8200,116.7300,116.7550,305800
1483639140,116.6900,116.8150,116.6700,116.7500,221100
1483639440,116.5850,116.7000,116.5100,116.7000,192800
1483639743,116.5100,116.6000,116.4900,116.5900,135400
1483640099,116.4800,116.5200,116.4300,116.5150,173800
1483640343,116.4700,116.5400,116.4570,116.4888,144800
1483640699,116.5101,116.5500,116.4400,116.4745,173900
1483640999,116.3910,116.5200,116.3400,116.5150,156400
1483641299,116.3443,116.4500,116.3400,116.4000,125800
1483641540,116.4500,116.4600,116.3450,116.3450,113500
1483641841,116.5400,116.5400,116.4300,116.4400,90600
1483642141,116.5300,116.5700,116.5100,116.5350,121600
1483642441,116.5350,116.5500,116.5000,116.5231,60900
1483642744,116.4800,116.5700,116.4800,116.5400,93800
1483643041,116.5400,116.5400,116.4800,116.4859,75500
1483643344,116.5100,116.5500,116.4850,116.5450,138900
1483643642,116.5600,116.5700,116.5050,116.5150,108000
1483643943,116.4800,116.6150,116.4500,116.5550,145200
1483644242,116.5257,116.5300,116.4600,116.4862,118000
1483644544,116.4699,116.5300,116.4643,116.5300,131300
1483644841,116.4400,116.4750,116.4201,116.4650,100600
1483645141,116.3850,116.4500,116.3500,116.4350,151200
1483645441,116.3700,116.4100,116.3500,116.3900,106700
1483645741,116.3700,116.3800,116.3500,116.3750,127100
1483646041,116.3650,116.3900,116.3100,116.3800,152600
1483646341,116.3200,116.3700,116.3001,116.3600,107000
1483646645,116.3401,116.3750,116.3001,116.3100,100500
1483646948,116.3490,116.3500,116.2900,116.3500,132000
1483647240,116.4800,116.4900,116.3300,116.3460,163300
1483647541,116.4750,116.5500,116.4400,116.4810,223400
1483647840,116.4900,116.4900,116.4000,116.4753,152800
1483648140,116.6501,116.6700,116.4915,116.5000,200800
1483648441,116.6500,116.7300,116.6400,116.6600,375500
1483648742,116.6950,116.7000,116.6100,116.6450,267900
1483649099,116.6250,116.7200,116.6200,116.6950,263400
1483649345,116.7300,116.7400,116.6200,116.6300,336700
1483649644,116.6000,116.7600,116.6000,116.7500,423100
1483649940,116.6100,116.7400,116.5900,116.6000,1902300
1483650000,116.6300,116.6300,116.6300,116.6300,100
1483713299,117.1870,117.3234,116.4700,116.7280,0
1483713599,117.2743,117.3500,117.0300,117.1850,946400
1483713840,117.4118,117.5200,117.2500,117.2800,1589400
1483714141,117.2100,117.5000,117.0900,117.3950,638900
1483714440,117.4200,117.5100,117.1800,117.2200,842700
1483714740,117.6900,117.7000,117.3400,117.4150,937200
1483715099,117.6950,117.7900,117.5700,117.6750,674200
1483715340,117.7000,117.7650,117.5700,117.7000,644800
1483715644,117.6600,117.7400,117.5900,117.6975,450100
1483715999,117.5950,117.6900,117.5200,117.6500,361100
1483716242,117.5300,117.6100,117.5283,117.6000,299800
1483716599,117.5310,117.5500,117.4500,117.5303,345600
1483716842,117.5450,117.5500,117.4000,117.5400,246400
1483717142,117.4500,117.5800,117.4300,117.5492,232400
1483717498,117.6530,117.6700,117.4400,117.4600,360800
1483717742,117.7365,117.7400,117.6550,117.6600,482900
1483718099,117.7261,117.7900,117.6700,117.7350,416900
1483718340,117.6200,117.7900,117.6000,117.7201,308300
1483718642,117.5200,117.6700,117.5200,117.6250,224900
1483718940,117.6000,117.6300,117.5000,117.5300,230600
1483719240,117.7200,117.7300,117.5500,117.5966,261000
1483719540,117.7700,117.8200,117.7200,117.7400,382900
1483719841,117.8600,117.8800,117.7500,117.7800,245800
1483720146,117.8800,117.9400,117.8300,117.8541,325700
1483720444,117.9000,117.9300,117.8150,117.8900,239700
1483720798,117.8347,117.8993,117.7500,117.8993,207300
1483721041,117.8500,117.8735,117.7900,117.8450,311800
1483721340,117.9000,117.9200,117.7900,117.8401,253100
1483721640,117.9250,117.9300,117.8500,117.9200,193600
1483721941,117.9310,117.9700,117.8800,117.9275,253900
1483722241,117.9650,117.9700,117.8900,117.9342,174300
1483722541,117.9300,117.9600,117.9000,117.9600,178800
1483722840,117.9400,117.9500,117.8975,117.9249,213700
1483723140,117.9700,117.9900,117.9200,117.9439,205800
1483723499,118.0941,118.1200,117.9600,117.9800,1413200
1483723740,118.1000,118.1600,118.0800,118.0999,417600
1483724042,118.0200,118.1300,117.9600,118.0950,362200
1483724350,117.9150,118.0650,117.8800,118.0150,291700
1483724641,117.8400,117.9942,117.8100,117.9144,223600
1483724945,117.9000,117.9361,117.8200,117.8399,215500
1483725241,117.8993,117.9200,117.8300,117.9032,181600
1483725540,117.9043,117.9300,117.8500,117.9000,191200
1483725840,117.8500,117.9200,117.8300,117.9000,173300
1483726140,117.7800,117.8700,117.7500,117.8595,319900
1483726440,117.8000,117.8400,117.7841,117.7900,135600
1483726740,117.8000,117.8400,117.7801,117.7900,151300
1483727099,117.7701,117.8500,117.7600,117.7950,171400
1483727340,117.7010,117.7900,117.6450,117.7800,277900
1483727642,117.8230,117.8299,117.7000,117.7041,135600
1483727946,117.9000,117.9100,117.8000,117.8270,185100
1483728245,117.9353,117.9600,117.8900,117.8967,207100
1483728540,117.9399,117.9700,117.8600,117.9343,153800
1483728842,117.9250,117.9600,117.8900,117.9333,128400
1483729142,117.8300,117.9500,117.8000,117.9200,169300
1483729443,117.9000,117.9300,117.8399,117.8400,187400
1483729740,118.0000,118.0000,117.8700,117.8900,319700
1483730040,118.1200,118.1350,117.9800,117.9950,493800
1483730342,118.0900,118.1300,118.0700,118.1242,271300
1483730643,118.0300,118.1600,118.0300,118.0800,334700
1483730943,118.0300,118.0900,117.9396,118.0301,352500
1483731240,118.1300,118.1400,118.0250,118.0250,238900
1483731540,118.1300,118.1500,118.0992,118.1350,238900
1483731844,118.1247,118.1400,118.0200,118.1250,254200
1483732140,118.0300,118.1600,118.0300,118.1200,311000
1483732442,118.0100,118.1000,118.0100,118.0350,243600
1483732741,117.9641,118.0380,117.9500,118.0135,175300
1483733043,117.9850,118.0400,117.9300,117.9600,252500
1483733340,118.0300,118.0800,117.9850,117.9900,254400
1483733640,118.0295,118.0900,118.0000,118.0400,297100
1483733941,118.0100,118.0700,118.0000,118.0200,305500
1483734240,118.0401,118.0700,118.0000,118.0000,202000
1483734541,117.9800,118.0453,117.9700,118.0430,210900
1483734841,117.9300,117.9850,117.9300,117.9600,324400
1483735140,117.9200,117.9399,117.8800,117.9399,347800
1483735440,117.9650,117.9900,117.9134,117.9134,410500
1483735741,117.9800,117.9900,117.9400,117.9500,277000
1483736099,117.9947,118.0300,117.9700,117.9800,477600
1483736340,117.8500,117.9800,117.8200,117.9750,670100
1483972440,118.4300,118.5000,118.1700,118.2950,0
1483972740,118.9400,118.9800,118.3500,118.4200,1678100
1483973040,118.9200,118.9600,118.7800,118.9450,895700
1483973340,119.1000,119.1900,118.8900,118.9250,1633700
1483973699,119.1500,119.3000,119.0300,119.1008,1114800
1483973940,119.0500,119.2900,118.9800,119.1443,765800
1483974240,119.0700,119.2900,119.0389,119.0400,586900
1483974540,118.8699,119.0800,118.8500,119.0600,467500
1483974842,119.0750,119.0750,118.7739,118.8607,561600
1483975140,118.9900,119.0900,118.9300,119.0790,531200
1483975441,119.2500,119.2800,118.9710,118.9839,777200
1483975740,119.0700,119.2459,119.0300,119.2459,439800
1483976040,119.1050,119.1450,118.9200,119.0750,325000
1483976344,119.0300,119.1050,118.9800,119.1001,282800
1483976641,119.0350,119.1200,119.0300,119.0303,226800
1483976940,119.1200,119.1350,118.9533,119.0300,287400
1483977240,119.0550,119.1300,119.0100,119.1240,226900
1483977540,119.1550,119.2000,119.0400,119.0526,395000
1483977841,119.0900,119.1500,119.0600,119.1500,217700
1483978141,119.2001,119.2400,119.0800,119.0800,429600
1483978440,119.2500,119.2700,119.2000,119.2050,302400
1483978799,119.2850,119.3054,119.1400,119.2550,403700
1483979040,119.3100,119.4300,119.2300,119.2831,578200
1483979345,119.2140,119.3300,119.2100,119.3194,283200
1483979641,119.1250,119.2200,119.1100,119.2150,307000
1483979942,119.0500,119.1300,119.0200,119.1300,221400
1483980241,118.9900,119.1099,118.9400,119.0465,396100
1483980541,119.0641,119.0700,118.9700,119.0000,206000
1483980842,118.9850,119.0700,118.9700,119.0644,165300
1483981140,118.9800,118.9900,118.9176,118.9900,223700
1483981499,119.0050,119.0100,118.9200,118.9700,181100
1483981798,119.0241,119.1000,118.9950,119.0040,256600
1483982040,118.9700,119.0398,118.9100,119.0299,328900
1483982399,118.9464,118.9900,118.8400,118.9747,264100
1483982642,119.0857,119.1300,118.9365,118.9450,379300
1483982946,119.0950,119.1200,119.0300,119.0801,203100
1483983243,118.9800,119.1000,118.9400,119.0900,270600
1483983541,118.9900,119.0200,118.9700,118.9714,150100
1483983844,119.0877,119.1000,118.9900,119.0000,139200
1483984141,119.0963,119.1000,119.0400,119.0831,161400
1483984447,119.1800,119.2000,119.0900,119.0999,243600
1483984741,119.1800,119.1900,119.1300,119.1700,138900
1483985095,119.1990,119.2200,119.1600,119.1850,184400
1483985342,119.1200,119.1958,119.1001,119.1958,146000
1483985640,119.1200,119.1400,119.0832,119.1225,187400
1483985940,119.1899,119.1900,119.1100,119.1195,121800
1483986245,119.1050,119.1938,119.1000,119.1800,125800
1483986540,119.0400,119.1099,119.0300,119.1000,183800
1483986840,119.0400,119.0800,119.0100,119.0450,127200
1483987141,119.0499,119.0800,119.0100,119.0300,155300
1483987444,119.0700,119.0868,119.0300,119.0500,220000
1483987741,119.0900,119.1000,119.0500,119.0750,140900
1483988099,119.0531,119.0961,119.0300,119.0961,98600
1483988345,119.0543,119.0600,119.0000,119.0600,188500
1483988640,119.0200,119.0600,119.0050,119.0500,95700
1483988941,118.8600,119.0200,118.8600,119.0150,221900
1483989240,118.9099,118.9100,118.7800,118.8650,352400
1483989541,118.8999,118.9300,118.8500,118.9100,170600
1483989840,118.9101,118.9200,118.8700,118.8939,175800
1483990140,118.9200,118.9200,118.8600,118.9168,164800
1483990440,118.7600,118.9300,118.7600,118.9100,223500
1483990745,118.8510,118.9100,118.7200,118.7699,234800
1483991040,118.8458,118.9150,118.8400,118.8547,187700
1483991343,118.8650,118.9200,118.8300,118.8450,218500
1483991640,119.0100,119.0600,118.8700,118.8700,392100
1483991944,119.0735,119.0900,119.0100,119.0135,314700
1483992246,119.1400,119.1400,119.0700,119.0700,213500
1483992543,119.1100,119.1400,119.0600,119.1340,289600
1483992851,119.1700,119.1800,119.0800,119.1150,225400
1483993198,119.1768,119.2000,119.1100,119.1708,307900
1483993440,119.1700,119.2100,119.1500,119.1751,279300
1483993740,119.2592,119.2900,119.1600,119.1600,383800
1483994040,119.2900,119.3800,119.2600,119.2700,418400
1483994399,119.2550,119.2865,119.2100,119.2850,342700
1483994641,119.1542,119.2900,119.1500,119.2500,415900
1483994941,119.0950,119.1600,119.0500,119.1550,354700
1483995240,119.0600,119.1400,119.0000,119.0950,600500
1483995540,119.0100,119.0700,118.9700,119.0550,924900
1483995600,118.9900,118.9900,118.9900,118.9900,2303800
1484058840,118.6600,118.9700,118.5300,118.7800,0
1484059140,118.7400,118.9500,118.5800,118.6450,677000
1484059440,118.5700,118.7700,118.3000,118.7493,657900
1484059740,118.6600,118.7800,118.4900,118.5650,514700
1484060042,118.5800,118.8600,118.3900,118.6595,631200
1484060340,118.7470,118.7900,118.5100,118.5850,301500
1484060698,118.9405,118.9500,118.7000,118.7800,382900
1484060943,118.6800,118.9500,118.6600,118.9400,350200
1484061240,118.9350,118.9500,118.6300,118.6900,720300
1484061540,118.6600,118.9450,118.6300,118.9400,426300
1484061840,118.7300,118.7700,118.6500,118.6573,244100
1484062140,118.6400,118.7300,118.6000,118.7200,305600
1484062441,118.8700,118.8900,118.5100,118.6350,460800
1484062740,118.7800,118.9000,118.7300,118.8800,238400
1484063040,118.7600,118.8700,118.7600,118.7900,205400
1484063340,118.8100,118.8500,118.6800,118.7500,227900
1484063641,118.8400,118.8400,118.7100,118.8050,179300
1484063945,118.7400,118.8900,118.7300,118.8500,202100
1484064299,118.9600,118.9600,118.7500,118.7500,311900
1484064540,119.0000,119.0000,118.8900,118.9525,376500
1484064843,119.0000,119.0000,118.9550,118.9936,331900
1484065141,119.0650,119.0900,118.9800,118.9961,418800
1484065440,119.2150,119.2600,119.0601,119.0700,369200
1484065740,119.2300,119.2500,119.1833,119.2200,248400
1484066046,119.2100,119.2800,119.2100,119.2400,230800
1484066340,119.3341,119.3657,119.1650,119.2000,399200
1484066643,119.2300,119.3800,119.2200,119.3400,243000
1484066941,119.2800,119.3300,119.2100,119.2335,196200
1484067240,119.2621,119.3333,119.2100,119.2700,145200
1484067542,119.1500,119.3100,119.1400,119.2635,211800
1484067841,119.2741,119.2800,119.1457,119.1457,240000
1484068142,119.2300,119.2800,119.2143,119.2700,106900
1484068441,119.1953,119.2667,119.1800,119.2400,145400
1484068740,119.2550,119.3200,119.2000,119.2000,186400
1484069045,119.2200,119.2650,119.2200,119.2500,125800
1484069344,119.2600,119.2600,119.2100,119.2300,118700
1484069645,119.2600,119.2800,119.2300,119.2523,109700
1484069945,119.2900,119.2900,119.2400,119.2700,113100
1484070240,119.2300,119.2900,119.2300,119.2850,96800
1484070541,119.1100,119.2600,119.1100,119.2301,143500
1484070842,119.1200,119.1300,119.0800,119.1101,160700
1484071143,119.1201,119.1500,119.0941,119.1165,176900
1484071441,119.1200,119.1600,119.1000,119.1265,135300
1484071743,119.0600,119.1200,119.0000,119.1150,241500
1484072042,119.1300,119.1450,119.0500,119.0500,112000
1484072399,119.1400,119.1400,119.0800,119.1312,103700
1484072647,119.1150,119.1400,119.0790,119.1340,120300
1484072942,119.0600,119.1800,119.0600,119.1200,205800
1484073299,119.1200,119.1300,119.0500,119.0650,256000
1484073542,119.1700,119.1900,119.0600,119.1100,168400
1484073841,119.0801,119.1700,119.0600,119.1600,175800
1484074144,119.0250,119.0853,119.0100,119.0800,153500
1484074443,118.9700,119.0400,118.9400,119.0300,267400
1484074740,118.8400,118.9700,118.8000,118.9600,221700
1484075041,118.8600,118.8700,118.7700,118.8309,242900
1484075340,118.8300,118.8750,118.7800,118.8650,171600
1484075642,119.0300,119.0300,118.8300,118.8400,200700
1484075940,118.9974,119.0257,118.9400,119.0257,150700
1484076299,119.0765,119.1283,118.9900,119.0000,222600
1484076541,119.0499,119.1000,119.0400,119.0700,135300
1484076843,119.0717,119.0828,119.0000,119.0442,154000
1484077142,119.1241,119.1700,119.0600,119.0700,206300
1484077443,119.1500,119.1900,119.1200,119.1230,203400
1484077741,119.1300,119.1800,119.0900,119.1600,185700
1484078043,119.0634,119.1225,119.0200,119.1200,145500
1484078345,119.0800,119.0898,118.9950,119.0700,153600
1484078641,119.0700,119.0900,119.0300,119.0750,129200
1484078946,119.0774,119.0900,119.0500,119.0693,113000
1484079242,119.0500,119.0900,119.0100,119.0800,92500
1484079541,119.0250,119.0600,118.9900,119.0400,127100
1484079841,118.9700,119.0600,118.9700,119.0241,165000
1484080142,119.0001,119.0200,118.9200,118.9790,169800
1484080444,119.0800,119.1650,119.0041,119.0048,327900
1484080741,119.1900,119.2050,119.0700,119.0735,307500
1484081099,119.1277,119.2200,119.0900,119.2000,377900
1484081342,119.0700,119.1500,119.0600,119.1250,218400
1484081640,119.1300,119.1500,119.0700,119.0800,328100
1484081940,119.1100,119.2000,119.0700,119.1200,0
1484082000,119.1100,119.1100,119.1100,119.1100,3100
1484145240,119.1900,119.3600,118.6900,118.7000,1515600
1484145540,119.2400,119.2600,119.0500,119.2000,698000
1484145841,118.9700,119.2300,118.9100,119.2300,532000
1484146198,118.9200,118.9800,118.8400,118.9600,415600
1484146499,118.9850,119.0300,118.8200,118.9175,356800
1484146742,119.1550,119.1800,118.9850,118.9900,379000
1484147045,119.0000,119.1600,119.0000,119.1527,321800
1484147399,118.9812,119.0600,118.9500,119.0100,333700
1484147698,118.9550,119.0600,118.9400,118.9900,210500
1484147940,118.9700,118.9900,118.8900,118.9600,199100
1484148247,118.9400,119.0050,118.9200,118.9800,218400
1484148540,118.9900,119.0000,118.8300,118.9300,226200
1484148842,119.0000,119.0400,118.9500,118.9800,195400
1484149140,119.0800,119.1200,119.0001,119.0057,271500
1484149447,119.0600,119.1100,119.0200,119.0900,155800
1484149743,119.0200,119.0800,118.9800,119.0609,235600
1484150040,119.0008,119.0600,118.9400,119.0300,201200
1484150340,118.9700,119.0050,118.9200,119.0035,174000
1484150642,118.9850,119.0400,118.9400,118.9790,182200
1484150940,119.0300,119.0700,118.9700,118.9800,112000
1484151242,119.0500,119.1300,119.0000,119.0250,202000
1484151542,119.0900,119.1200,119.0400,119.0600,181400
1484151841,118.9700,119.1500,118.9700,119.0966,349800
1484152141,118.8300,119.0600,118.7600,118.9600,385400
1484152440,118.8500,118.8600,118.6200,118.8327,497200
1484152740,118.8200,118.8500,118.6100,118.8437,319500
1484153041,118.8800,118.9000,118.7300,118.8100,208500
1484153399,118.9637,118.9900,118.8600,118.8847,252400
1484153640,119.0300,119.0800,118.9300,118.9650,257400
1484153944,119.0550,119.0700,118.9400,119.0201,218900
1484154243,119.0200,119.0900,118.6400,119.0600,288300
1484154541,119.0350,119.0870,118.9600,119.0300,173500
1484154842,119.0200,119.0601,118.9800,119.0300,176200
1484155140,118.9100,119.0300,118.8900,119.0300,317200
1484155441,118.9100,118.9200,118.7300,118.9000,312800
1484155799,118.9700,119.0100,118.8800,118.9000,206100
1484156041,118.8700,119.0100,118.8200,118.9800,135700
1484156341,118.9500,119.0000,118.8600,118.8600,135200
1484156643,118.8500,118.9400,118.7650,118.9400,210600
1484156947,118.7800,118.8400,118.7500,118.8400,148100
1484157244,118.7935,118.8400,118.7800,118.7850,185400
1484157540,118.9600,118.9700,118.7900,118.8000,159700
1484157845,118.8600,118.9700,118.8600,118.9500,125900
1484158142,118.8327,118.9250,118.8200,118.8550,150100
1484158440,118.7600,118.8400,118.6800,118.8300,308300
1484158741,118.6900,118.7600,118.6161,118.7500,291800
1484159044,118.7707,118.8200,118.6500,118.7000,195800
1484159347,118.6600,118.7850,118.6200,118.7800,203200
1484159641,118.7250,118.7354,118.6000,118.6500,251400
1484159942,118.9000,118.9242,118.7200,118.7200,265700
1484160298,118.8900,118.9200,118.8300,118.8900,148100
1484160542,118.8000,118.9400,118.8000,118.8965,141000
1484160849,118.8800,118.8900,118.7900,118.8025,140500
1484161141,118.9200,119.0000,118.8700,118.8900,269100
1484161441,118.9950,119.0000,118.9100,118.9273,146500
1484161743,118.9900,119.0450,118.9600,118.9900,250700
1484162040,119.0900,119.0900,118.9600,118.9875,181800
1484162341,119.1400,119.1700,119.0900,119.1000,282400
1484162640,119.1680,119.1900,119.0900,119.1499,355000
1484162942,119.2300,119.2800,119.1600,119.1600,369200
1484163243,119.3100,119.3200,119.2200,119.2290,451100
1484163540,119.7136,119.7300,119.3050,119.3150,973500
1484163899,119.6300,119.7200,119.5200,119.7100,423700
1484164140,119.5450,119.6500,119.5046,119.6400,338800
1484164440,119.6600,119.6800,119.5400,119.5442,360700
1484164799,119.8241,119.8378,119.6500,119.6500,698300
1484165042,119.8500,119.8800,119.8200,119.8220,560500
1484165340,119.6600,119.8800,119.6250,119.8600,532500
1484165645,119.7168,119.7800,119.6597,119.6597,509000
1484165941,119.9100,119.9100,119.7200,119.7200,352000
1484166298,119.8835,119.9300,119.8500,119.9050,390000
1484166599,119.8342,119.9000,119.7800,119.8800,295300
1484166899,119.8700,119.8859,119.8300,119.8350,320700
1484167199,119.8606,119.8900,119.8600,119.8711,311700
1484167440,119.7500,119.8663,119.7500,119.8600,327200
1484167740,119.7700,119.8300,119.7200,119.7550,375700
1484168040,119.6900,119.8200,119.6600,119.7900,505000
1484168340,119.7500,119.7500,119.6500,119.6800,786300
1484168400,119.7300,119.7300,119.7300,119.7300,100
1484231647,118.9550,119.1750,118.9500,119.0000,0
1484231947,119.0200,119.0900,118.9600,118.9870,926700
1484232283,118.9340,118.9700,118.7900,118.7900,774100
1484232588,118.8100,118.8400,118.7400,118.7850,598900
1484232864,118.7800,118.8165,118.7600,118.8165,580900
1484233141,118.8450,118.9400,118.7300,118.7600,557900
1484233492,118.8800,118.9800,118.7900,118.9200,520100
1484233747,118.5490,118.7750,118.5100,118.7750,666400
1484234072,118.4520,118.5900,118.4500,118.5450,733400
1484234340,118.4200,118.5300,118.4150,118.4450,496300
1484234679,118.5200,118.5250,118.3600,118.3700,541200
1484234825,118.6800,118.7200,118.6250,118.6465,680500
1484235182,118.6400,118.6800,118.6200,118.6800,210800
1484235540,118.4800,118.6792,118.4800,118.6792,209300
1484235855,118.7000,118.7200,118.4700,118.4800,380800
1484236141,118.6100,118.7000,118.6100,118.6800,188900
1484236404,118.5200,118.6250,118.4900,118.6200,164000
1484236695,118.3800,118.5100,118.3700,118.5000,325600
1484237074,118.2800,118.3892,118.2800,118.3800,622600
1484237352,118.4000,118.4750,118.3400,118.3400,278300
1484237665,118.3000,118.4150,118.2900,118.4099,182900
1484237996,118.2100,118.3900,118.2100,118.2842,360600
1484238240,118.4450,118.4750,118.2300,118.2350,360000
1484238564,118.5710,118.5800,118.4000,118.4700,366700
1484238870,118.5300,118.6300,118.5233,118.5800,223400
1484239144,118.5000,118.5400,118.4500,118.5200,159600
1484239463,118.5790,118.5790,118.4700,118.5100,128700
1484239740,118.6800,118.7850,118.5500,118.5700,354500
1484240041,118.6100,118.7130,118.5758,118.7130,139400
1484240352,118.6593,118.6593,118.5600,118.6000,147300
1484240640,118.7100,118.7400,118.6400,118.6550,208500
1484240948,118.6250,118.7400,118.6200,118.7200,132100
1484241242,118.6600,118.6750,118.6100,118.6200,138900
1484241542,118.7785,118.8300,118.6750,118.6850,257600
1484241841,118.7000,118.8150,118.6800,118.7752,210200
1484242141,118.7500,118.7750,118.6200,118.6899,240500
1484242444,118.8200,118.8200,118.7450,118.7600,160600
1484242742,118.8600,118.9000,118.8000,118.8100,174800
1484243098,118.7650,118.8900,118.7600,118.8100,186800
1484243280,118.9000,118.9150,118.7800,118.7900,165900
1484243640,118.9800,118.9900,118.8608,118.8751,231900
1484243940,118.9400,118.9750,118.9000,118.9400,184100
1484244241,118.9735,119.0300,118.9200,118.9389,320500
1484244545,118.9600,118.9800,118.8500,118.9800,146000
1484244894,118.9800,119.0700,118.9700,118.9865,186600
1484245146,119.0308,119.1000,118.9842,118.9950,239000
1484245461,118.9050,119.0250,118.9000,119.0108,160300
1484245741,118.9100,118.9100,118.8200,118.9036,133900
1484246041,118.8600,118.9350,118.8600,118.9200,122200
1484246340,118.9433,118.9600,118.8800,118.9100,135600
1484246650,118.9500,119.0000,118.8935,118.9474,243700
1484246950,118.9800,119.0200,118.9250,118.9590,223200
1484247180,118.9500,118.9800,118.9400,118.9750,181700
1484247558,118.9000,118.9400,118.8700,118.9200,127600
1484247854,118.8700,118.9400,118.8550,118.9400,158900
1484248167,118.8350,118.9000,118.8100,118.9000,133300
1484248472,118.8850,118.9100,118.8600,118.8650,192700
1484248740,118.8700,118.9800,118.8500,118.8608,204000
1484249066,118.8850,118.9200,118.8150,118.8800,184000
1484249346,118.8985,118.9100,118.8500,118.8550,117800
1484249646,119.0000,119.0250,118.8750,118.9265,232500
1484249959,118.9400,119.0250,118.9400,118.9900,218800
1484250296,118.9400,118.9500,118.8800,118.9250,184200
1484250598,118.8837,118.9501,118.8500,118.9500,179800
1484250897,118.9400,118.9400,118.8900,118.8900,129600
1484251082,118.9600,118.9899,118.9300,118.9300,79900
"""
Demonstrate creation of a custom graphic (a candlestick plot)

"""
import pyqtgraph as pg
from pyqtgraph import QtCore, QtGui
import random
import urllib.request as req
import datetime as dt
import pandas as pd
import numpy as np
## Create a subclass of GraphicsObject.
## The only required methods are paint() and boundingRect() 
## (see QGraphicsItem documentation)
class CandlestickItem(pg.GraphicsObject):
    def __init__(self):
        pg.GraphicsObject.__init__(self)
        self.flagHasData = False

    def set_data(self, data):
        self.data = data  ## data must have fields: time, open, close, min, max
        self.flagHasData = True
        self.generatePicture()
        self.informViewBoundsChanged()

    def generatePicture(self):
        ## pre-computing a QPicture object allows paint() to run much more quickly, 
        ## rather than re-drawing the shapes every time.
        self.picture = QtGui.QPicture()
        p = QtGui.QPainter(self.picture)
        p.setPen(pg.mkPen('w'))
        w = (self.data[1][0] - self.data[0][0]) / 3.
        for (t, open, close, min, max) in self.data:
            p.drawLine(QtCore.QPointF(t, min), QtCore.QPointF(t, max))
            if open > close:
                p.setBrush(pg.mkBrush('r'))
            else:
                p.setBrush(pg.mkBrush('g'))
            p.drawRect(QtCore.QRectF(t-w, open, w*2, close-open))
        p.end()

    def paint(self, p, *args):
        if self.flagHasData:
            p.drawPicture(0, 0, self.picture)

    def boundingRect(self):
        ## boundingRect _must_ indicate the entire area that will be drawn on
        ## or else we will get artifacts and possibly crashing.
        ## (in this case, QPicture does all the work of computing the bouning rect for us)
        return QtCore.QRectF(self.picture.boundingRect())

app = QtGui.QApplication([])

# data = [  ## fields are (time, open, close, min, max).
#     [1, 10, 13, 5, 15],
#     [2., 13, 17, 9, 20],
#     [3., 17, 14, 11, 23],
#     [4., 14, 15, 5, 19],
#     [5., 15, 9, 8, 22],
#     [6., 9, 15, 8, 16],
# ]
# def bytespdate2num(fmt, encoding='utf-8'):
#     strconverter = mdates.strpdate2num(fmt)
#     def bytesconverter(b):
#         s = b.decode(encoding)
#         return strconverter(s)
#     return bytesconverter

# url = 'http://chartapi.finance.yahoo.com/instrument/1.0/AAPL/chartdata;type=quote;range=3d/csv'


# stockFile = []
# sourceCode = req.urlopen(url).read().decode()
# # print(sourceCode)
# split_source = sourceCode.split('\n')
# for line in split_source:
#     split_line = line.split(',' )

#     fixMe = split_line[0]

#     if len(split_line) == 6: 
#         if 'values' not in line and 'labels' not in line:
#             fixed = line.replace(fixMe, str(dt.datetime.fromtimestamp(int(fixMe)).strftime('%Y-%m-%d %H:%M:%S')))
#             stockFile.append(fixed)
# data = stockFile
# date, closep, highp, lowp, openp, volume = np.loadtxt(stockFile,
#             delimiter=',', unpack=True,
#             converters={0: bytespdate2num('%Y-%m-%d %H:%M:%S')})
# print(date)

data = open('AAPL.csv', 'r').read() # close high low open
# data = np.loadtxt('AAPL.csv', unpack=True, delimiter=',')

print(data[0])

splitData = data.split('\n')

# print(splitData)
stockData = []
for line in splitData:
    if len(line.split(',')) == 6:
        splitLine = line.split(',')
        splitLine[0] = int(splitLine[0]) # date
        splitLine[1] = float(splitLine[1]) # close
        splitLine[2] = float(splitLine[2]) # high
        splitLine[3] = float(splitLine[3]) # low
        splitLine[4] = float(splitLine[4]) # open
        del splitLine[5]
        formatData = [splitLine[0], splitLine[4], splitLine[1], splitLine[3], splitLine[2] ]
        stockData.append(formatData)
        # intLine = int(splitLine)
    # if not splitLine[0][-1]:
    # datep = int(splitLine[0])
    # print(spl)
    # print(datep)
# print(stockData.sort())
# print(data)
item = CandlestickItem()
item.set_data(stockData)
# open close min max
plt = pg.plot()
plt.addItem(item)
plt.setWindowTitle('pyqtgraph example: customGraphicsItem')


# def update():
#     global item, data
#     data_len = len(data)
#     rand = random.randint(0, len(data)-1)
#     new_bar = data[rand][:]
#     new_bar[0] = data_len
#     data.append(new_bar)
#     item.set_data(data)
#     app.processEvents()  ## force complete redraw for every plot

# timer = QtCore.QTimer()
# timer.timeout.connect(update)
# timer.start(100)

# ## Start Qt event loop unless running in interactive mode or using pyside.
if __name__ == '__main__':
    import sys
    if (sys.flags.interactive != 1) or not hasattr(QtCore, 'PYQT_VERSION'):
        QtGui.QApplication.instance().exec_()

Reply via email to