SnP500_ENERGY_date|reset|nb|mcap|real_earn|est_earn|real_rev|est_rev|reaction|p/e|p/s|list
2013-07-30|0|1|33245967825|1338291078|654052030|0|5256000000|0.4%|24.84|6.33|BKR!
2013-08-01|1|3|138226396288|3629042312|2802314311|0|22287000000|3.298%|38.09|6.2|APA!COP!
2013-10-18|0|1|39253184166|905610504|784862437|0|5773000000|8.15%|43.34|6.8|BKR!
2013-10-24|1|2|67069232862|1041005008|912735024|0|6213150000|6.29%|64.43|10.79|CTRA!
2013-10-31|2|3|153856879343|2786494683|2634476540|0|20390150000|-0.22%|55.22|7.55|COP!
2013-11-07|3|4|181400283349|3498083740|3293923295|0|24669150000|1.53%|51.86|7.35|APA!
2014-01-21|0|1|39796550468|623865014|613802675|0|5672000000|4.88%|63.79|7.02|BKR!
2014-01-30|1|2|116918696301|2286236133|2169307079|0|20797000000|-1.32%|51.14|5.62|COP!
2014-01-31|2|3|326089558033|7123100580|7006171526|0|85728000000|-4.56%|45.78|3.8|CVX!
2014-02-13|3|4|351666890550|7604650071|7555199290|0|89398000000|2.6%|46.24|3.93|APA!
2014-02-20|4|5|378798444808|7740044575|7690593794|0|89873780000|-9.98%|48.94|4.21|CTRA!
2014-04-17|0|1|49245086723|845236470|784862437|0|5707000000|5.95%|58.26|8.63|BKR!
2014-04-24|1|2|77963765447|1055850143|980432276|0|6228970000|5.64%|73.84|12.52|CTRA!
2014-05-01|2|3|168824221169|2967576930|2832788666|0|21361970000|2.97%|56.89|7.9|COP!
2014-05-08|3|4|196088510502|3513537499|3329674128|0|24922970000|1.29%|55.81|7.87|APA!
2014-07-17|0|1|51368240238|1026358571|905610504|5940000000|5870000000|-1.49%|50.05|8.75|BKR!
2014-07-24|1|2|75904733166|1236972244|1093658427|6980000000|6385240000|-2.22%|61.36|11.89|CTRA!
2014-07-31|2|4|202498646400|3280949922|3499598179|27980000000|25401240000|-3.746%|61.72|7.97|APA!COP!
2014-10-16|3|5|239739362780|4307308493|4636642478|34230000000|31690240000|-0.94%|55.66|7.57|BKR!
2014-10-24|4|6|262718818910|4457746831|4802124650|34742000000|32205990000|-2.83%|58.94|8.16|CTRA!
2014-10-30|5|7|348390301925|5170191596|6227014180|47072000000|45830990000|1.98%|67.38|7.6|COP!
2014-10-31|6|8|568175916763|10722234444|11026237659|98812000000|104006990000|-0.36%|52.99|5.46|CVX!
2014-11-06|7|9|591646086858|11145507245|11449510460|102552000000|107484990000|1.27%|53.08|5.5|APA!
2015-01-20|0|1|40883283073|1448976806|1076670266|6640000000|6407000000|3.12%|28.22|6.38|BKR!
2015-01-29|1|2|115666235260|1235243376|1777240952|17610000000|19452000000|0.64%|93.64|5.95|COP!
2015-01-30|2|3|315276291003|3813649716|4844979881|59280000000|50104000000|2.97%|82.67|6.29|CVX!
2015-02-12|3|4|335841828181|4141839496|5078086641|62230000000|53194000000|3.55%|81.09|6.31|APA!
2015-02-20|4|5|356587274991|4232102499|5243568813|62848000000|53744360000|-0.47%|84.26|6.63|CTRA!
2015-04-21|0|1|47011247481|-70436373|462867591|4590000000|5354000000|-1.87%|-667.43|8.78|BKR!
2015-04-24|1|2|71622959578|-47870622|485433342|5054800000|5771250000|-0.79%|-1496.18|12.41|CTRA!
2015-04-30|2|3|151701751186|35247934|259825833|12814800000|14642250000|-0.91%|4303.85|10.36|COP!
2015-05-01|3|4|355565236365|1860834904|1746644087|45254800000|36944250000|-2.47%|191.08|9.62|CVX!
2015-05-07|4|5|375667627217|1928313177|1571814017|46884800000|38752250000|-2.67%|194.82|9.69|APA!
2015-07-21|0|1|40853096056|-140872745|-140872745|3970000000|3778000000|-1.98%|-290|10.81|BKR!
2015-07-24|1|2|60741044340|-118306994|-110785077|4276300000|4150710000|-4.2%|-513.42|14.63|CTRA!
2015-07-30|2|3|120515160140|-569522012|-63288759|12576300000|13704710000|-4.84%|-211.61|8.79|COP!
2015-07-31|3|4|281618505149|1481910769|2119887412|49436300000|44558710000|-7.99%|190.04|6.32|CVX!
2015-08-06|4|5|295761337651|1549389042|2040140363|51416300000|46416710000|3.76%|190.89|6.37|APA!
2015-10-21|0|1|38961376337|-211309118|-140872745|3790000000|3790000000|4.54%|-184.38|10.28|BKR!
2015-10-23|1|2|54629529240|-218831035|-140872745|4095300000|4144360000|-5.7%|-249.64|13.18|CTRA!
2015-10-29|2|3|117977742946|-670046053|-580213684|11275300000|12249360000|0.02%|-176.07|9.63|COP!
2015-10-30|3|4|296697061194|1381386728|850143117|43835300000|42499360000|5.64%|214.78|6.98|CVX!
2015-11-05|4|5|311318375993|1366050757|739724125|45335300000|44084360000|-3.48%|227.9|7.06|APA!
2016-01-28|0|1|30498949297|-191184440|-100623389|3390000000|3471000000|6.58%|-159.53|8.79|BKR!
2016-01-29|1|2|191018859295|-398209767|746298401|31190000000|32194000000|-0.73%|-479.69|5.93|CVX!
2016-02-04|2|3|230084580587|-1466876915|-25516761|37400000000|41251000000|-14.83%|-156.85|5.58|COP!
2016-02-19|3|4|246286789590|-1564661835|-48082512|37680800000|41586140000|10.18%|-157.41|5.92|CTRA!
2016-02-25|4|5|258393005137|-1687349603|-195307834|38940800000|43008140000|2.25%|-153.14|6.01|APA!
2016-04-27|0|1|33547837993|-191184440|-342119524|2670000000|2851000000|4.51%|-175.47|11.77|BKR!
2016-04-28|1|2|90294063541|-1129236714|-1588897863|7810000000|8419000000|-0.67%|-79.96|10.73|COP!
2016-04-29|2|4|302961612687|-1434046961|-2063092468|31191900000|30116220000|1.054%|-211.26|10.06|CVX!CTRA!
2016-05-05|3|5|319475386314|-1556734729|-2336072753|32271900000|31219220000|6.13%|-205.22|10.23|APA!
2016-07-28|0|2|81997705507|-1843662778|-1348183859|7940000000|9057000000|4.135%|-44.48|9.05|BKR!COP!
2016-07-29|1|4|286377033515|-1237599248|-798581782|36176800000|37872070000|-2.444%|-231.4|7.56|CVX!CTRA!
2016-08-04|2|5|301602585573|-1246800831|-844589695|37546800000|39201070000|-4.04%|-241.9|7.69|APA!
2016-10-25|0|1|38387823018|-150935084|-442742913|2350000000|2413000000|5.01%|-254.33|15.91|BKR!
2016-10-27|1|2|91785558170|-934624326|-1273928472|8870000000|9371000000|7.58%|-98.21|9.79|COP!
2016-10-28|2|4|304635892966|-42508267|-607658223|38360430000|40005110000|4.211%|-7166.51|7.61|CVX!CTRA!
2016-11-03|3|5|321855121261|-51709850|-650598942|39790430000|41388110000|-5.58%|-6224.25|7.78|APA!
2017-01-26|0|1|44223979597|-301870168|-110685728|2410000000|2373000000|-0.79%|-146.5|18.64|BKR!
2017-01-27|1|2|254674634257|93360001|1093825263|32630000000|34202000000|-4.06%|2727.88|7.45|CVX!
2017-02-02|2|3|314555616772|-215366064|595113927|39810000000|41498000000|3.98%|-1460.56|7.58|COP!
2017-02-23|3|4|330937501048|-233769229|616584286|41260000000|43010000000|-2.73%|-1415.66|7.69|APA!
2017-02-24|4|5|347613590815|-226247312|624106203|41576490000|43361780000|-1.6%|-1536.43|8.02|CTRA!
2017-04-25|0|1|41678207848|-241496134|-211309118|2260000000|2268000000|1.37%|-172.58|18.38|BKR!
2017-04-28|1|3|258926939034|2216339847|1527603196|34104460000|36036950000|0.285%|116.83|7.19|CVX!CTRA!
2017-05-02|2|4|314830104943|2192591688|1539477275|41874460000|43469950000|-0.84%|143.59|7.24|COP!
2017-05-04|3|5|329948305204|2217129242|1579350800|43414460000|44992950000|1%|148.82|7.33|APA!
2017-07-27|0|1|53742083455|166237112|-23748159|7920000000|7283000000|3.57%|323.29|7.38|COP!
2017-07-28|1|4|315069926405|1878415612|1605714656|48980460000|42173650000|2.479%|167.73|7.47|CVX!BKR!CTRA!
2017-08-03|2|5|328939778623|1814004534|1602647462|50390460000|43579650000|-5.61%|181.33|7.55|APA!
2017-10-20|0|1|31666180613|150935084|110685728|5380000000|5531000000|-5.07%|209.8|5.73|BKR!
2017-10-26|1|2|92473341323|340920355|205678363|12260000000|11985000000|2.5%|271.25|7.72|COP!
2017-10-27|2|4|328212952481|1963390363|2102739236|48855420000|46445910000|-2.23%|167.17|7.07|CVX!CTRA!
2017-11-02|3|5|341325207729|1975659140|2084336071|50135420000|47835910000|1.23%|172.77|7.14|APA!
2018-01-24|0|1|32511417083|150935084|140872745|5760000000|5609000000|-9.8%|215.4|5.8|BKR!
2018-02-01|1|2|101048603495|685268658|675206319|14380000000|13197000000|-1.85%|147.46|7.66|COP!
2018-02-02|2|3|313004896893|2059728621|2971305395|52000000000|50785000000|-10.31%|151.96|6.16|CVX!
2018-02-22|3|4|324086669574|2160946030|3038783668|53590000000|52335000000|-2.88%|149.97|6.19|APA!
2018-02-23|4|5|342846330323|2258730950|3121524754|53990500000|52764800000|4.44%|151.79|6.5|CTRA!
2018-04-20|0|1|35167874560|90561050|60374034|5400000000|5420000000|3.68%|388.33|6.49|BKR!
2018-04-26|1|2|112290020393|1230472674|927181832|14360000000|14430000000|-0.17%|91.26|7.78|COP!
2018-04-27|2|4|365738001903|5016978351|3915705254|52593230000|55864060000|0.802%|72.9|6.55|CVX!CTRA!
2018-05-02|3|5|377558968388|5115128566|4004653886|54333230000|57484060000|-4.72%|73.81|6.57|APA!
2018-07-20|0|1|32702601523|100623389|140872745|5550000000|5570000000|2.27%|325|5.87|BKR!
2018-07-26|1|2|117542898979|1394898046|1423273322|14790000000|14770000000|-0.08%|84.27|7.96|COP!
2018-07-27|2|4|375222466005|4842729159|5507192864|57403370000|60801960000|2.388%|77.48|6.17|CVX!CTRA!
2018-08-02|3|5|389070847863|4996088870|5626813438|59333370000|62571960000|0.47%|77.88|6.22|APA!
2018-10-25|0|1|81313695868|1614874801|1413015451|10170000000|10140000000|4.25%|50.35|8.02|COP!
2018-10-26|1|2|98584017070|1802922724|1623629124|10621770000|10607740000|7.29%|54.68|9.29|CTRA!
2018-10-30|2|3|125440399674|1994107164|1834938242|16291770000|16497740000|0.38%|62.91|7.6|BKR!
2018-10-31|3|4|136601919404|2187340399|1979096370|18271770000|18477740000|-2.83%|62.45|7.39|APA!
2018-11-02|4|5|360452758836|6779538551|5856116121|62261770000|65147740000|6.99%|53.17|5.53|CVX!
2019-01-31|0|2|106052972752|1603391786|1460902833|16620000000|15470000000|3.894%|66.14|6.86|BKR!COP!
2019-02-01|1|3|331409450922|5273386211|4980333384|58970000000|57950000000|4.44%|62.85|5.72|CVX!
2019-02-22|2|4|350131502086|5687091641|5416604564|59686300000|58610580000|1.43%|61.57|5.97|CTRA!
2019-02-28|3|5|360556895206|5782174662|5487150031|61456300000|60380580000|1.28%|62.36|5.97|APA!
2019-04-26|0|2|241081636628|3033403852|2928065632|35841680000|39086540000|-0.153%|79.48|6.17|CVX!CTRA!
2019-04-30|1|4|339193300533|4371746878|4139417265|51521680000|54586540000|-2.228%|77.59|6.21|BKR!COP!
2019-05-01|2|5|348327404890|4402418820|4176223596|53161680000|56236540000|-9.51%|79.12|6.19|APA!
2019-07-26|0|1|14389427030|270789008|248223258|534120000|491470000|-12.21%|53.14|29.28|CTRA!
2019-07-30|1|2|84541488243|1470071029|1483127518|8914120000|8911470000|1.53%|57.51|9.49|COP!
2019-07-31|2|3|109969018719|1671317808|1674311958|14904120000|14721470000|3.1%|65.8|7.47|BKR!
2019-08-02|3|4|333443448466|5962388212|4986717182|53754120000|54841470000|-1.66%|55.92|6.08|CVX!
2019-08-07|4|5|340329299467|5996127348|5005120347|55354120000|56431470000|-2.05%|56.76|6.03|APA!
2019-10-24|0|1|14148725689|218135590|195569839|429110000|452080000|1.57%|64.86|31.3|CTRA!
2019-10-29|1|2|79503658817|1191810102|1050503557|10519110000|10542080000|-1.15%|66.71|7.54|COP!
2019-10-30|2|4|107680606786|1314170588|1230655807|17879110000|18102080000|-2.16%|81.94|5.95|APA!BKR!
2019-11-01|3|5|336481233570|4306627581|4072548926|53999110000|56102080000|4.68%|78.13|6|CVX!
2020-01-22|0|1|23103130183|271683151|311932507|6350000000|6466000000|1.01%|85.04|3.57|BKR!
2020-01-31|1|2|223127236579|2605423196|3059723205|42700000000|45426000000|-4.6%|85.64|4.91|CVX!
2020-02-04|2|3|292923075410|3507853232|4009649559|50840000000|53556000000|-0.68%|83.5|5.47|COP!
2020-02-20|3|4|304123209674|3733510739|4235307066|51301370000|54033660000|-4.55%|81.46|5.63|CTRA!
2020-02-26|4|5|311812665558|3758048293|4213836707|53001370000|55653660000|-1.69%|82.97|5.6|APA!
2020-04-22|0|1|13654593928|110685728|110685728|5430000000|5640000000|6.43%|123.36|2.42|BKR!
2020-04-30|1|3|75339056750|750326139|398455919|10626460000|10835100000|-6.131%|100.41|6.95|COP!CTRA!
2020-05-01|2|4|247433564549|3178168605|1621787394|42126460000|39975100000|-0.61%|77.85|6.19|CVX!
2020-05-06|3|5|251077391270|3138295080|1520569985|43406460000|41285100000|0.85%|80|6.08|APA!
2020-07-22|0|1|16794043674|-50311695|-10062339|4740000000|4670000000|2.33%|-333.8|3.6|BKR!
2020-07-29|1|2|21704621604|-277284067|-313714566|5336000000|5370330000|20.2%|-78.28|4.04|APA!
2020-07-30|2|4|79839833581|-1332089789|-987367338|9688350000|9691370000|-4.591%|-59.94|8.24|COP!CTRA!
2020-07-31|3|5|239456360336|-4324546782|-2737672371|23178350000|31561370000|-1.69%|-55.37|7.59|CVX!
2020-10-21|4|6|254006502429|-4284297426|-2701850444|28228350000|36341370000|6.09%|-59.29|6.99|BKR!
2020-10-29|5|8|301059448343|-4584696636|-3027383181|32899390000|41080520000|-1.007%|-65.67|7.33|COP!CTRA!
2020-10-30|6|9|436849242062|-4377671309|-3510128601|57349390000|66920520000|4.87%|-99.79|6.53|CVX!
2020-11-04|7|10|439600515268|-4426746416|-3614198501|58489390000|67915120000|2.75%|-99.31|6.47|APA!
2021-01-21|0|1|22308205408|-70436373|169248541|5500000000|5420000000|-3.15%|-316.71|4.12|BKR!
2021-01-29|1|2|184936009639|-89256857|342020586|30750000000|31240000000|-2.93%|-2071.95|5.92|CVX!
2021-02-02|2|3|236243906813|-314864366|40418969|36800000000|37090000000|6.14%|-750.3|6.37|COP!
2021-02-23|3|4|250349005384|-119294527|199432292|37256780000|37503120000|4.69%|-2098.58|6.68|CTRA!
2021-02-24|4|5|256523267329|-134630498|168054895|38546780000|38563120000|1.92%|-1905.39|6.65|APA!
2021-04-21|0|1|19943555759|120748067|111893209|4780000000|4790000000|1.59%|165.17|4.16|BKR!
2021-04-29|1|2|32189988664|406580909|379899108|5239680000|5265720000|-1.77%|79.17|6.11|CTRA!
2021-04-30|2|3|230802558743|2100424490|2049840674|37269680000|37805720000|-1.28%|109.88|6.1|CVX!
2021-05-04|3|4|296632455047|2919735970|2695078150|47829680000|48045720000|5.12%|101.6|6.17|COP!
2021-05-06|4|5|303254527346|3198850643|2911867437|49259680000|49525720000|2.96%|94.8|6.12|APA!
2021-07-21|0|1|20003929793|100623389|157374981|5140000000|4940000000|-0.8%|198.8|4.05|BKR!
2021-07-30|1|3|223119016989|3514496031|3356684689|43064670000|41698470000|-0.786%|63.49|5.35|CVX!CTRA!
2021-08-03|2|4|288343335243|5022504117|4662833425|53274670000|51898470000|-0.81%|57.41|5.56|COP!
2021-08-04|3|5|293882687986|5237207712|4836467289|55054670000|53398470000|-3.83%|56.11|5.5|APA!
2021-10-20|0|1|24421296583|160997423|215032183|5090000000|5330000000|-9.68%|151.69|4.58|BKR!
2021-10-29|1|2|239972302469|5731860755|4355538714|49800000000|45300000000|1.25%|41.87|5.3|CVX!
2021-11-02|2|3|326344356170|7833572812|6160398786|61420000000|56920000000|-2.48%|41.66|5.73|COP!
2021-11-03|3|5|351623926191|8525297524|6836686747|63510400000|59160650000|3.221%|41.24|5.94|APA!CTRA!
2022-01-20|0|1|27409811245|251558473|280839880|5520000000|5490000000|3.61%|108.96|4.99|BKR!
2022-01-28|1|2|274579230638|5069602436|6171651444|53650000000|50830000000|-2.98%|54.16|5.4|CVX!
2022-02-03|2|3|383666398270|7765018464|8772074837|69610000000|66710000000|-0.37%|49.41|5.75|COP!
2022-02-21|3|4|393186969098|8160686517|9219885192|72010000000|68640000000|-3.48%|48.18|5.73|APA!
2022-02-23|4|5|409915712284|8785005620|9987120716|74240000000|70490000000|-1.42%|46.66|5.82|CTRA!
2022-04-20|0|1|33115157419|150935084|195511245|4840000000|5010000000|-10.42%|219.4|6.61|BKR!
2022-04-29|1|2|333772392993|6474617785|6594475883|59210000000|52960000000|-1.26%|51.55|6.3|CVX!
2022-05-02|2|3|357586781898|7234331392|7224586862|60890000000|54760000000|9.97%|49.43|6.53|CTRA!
2022-05-04|3|4|370254293985|7823232680|7899369588|63560000000|57180000000|-2.87%|47.33|6.48|APA!
2022-05-05|4|5|498126255259|11706056650|11663452764|82850000000|76040000000|3.69%|42.55|6.55|COP!
2022-07-20|0|1|25075348614|110685728|216139040|5050000000|5340000000|-11.69%|226.55|4.7|BKR!
2022-07-29|1|2|327162940990|11064207550|9795765513|73810000000|64000000000|6.73%|29.57|5.11|CVX!
2022-08-02|2|3|348735798659|12079666332|10751048959|76380000000|66240000000|-3.01%|28.87|5.26|CTRA!
2022-08-03|3|4|358145950495|12806591360|11465705210|78910000000|68860000000|-14.61%|27.97|5.2|APA!
2022-08-04|4|5|468396777910|17449356413|16049099866|100770000000|90410000000|1.68%|26.84|5.18|COP!
2022-10-19|0|1|26111769523|261620812|245017953|5370000000|5410000000|7.32%|99.81|4.83|BKR!
2022-10-28|1|2|366574329244|10914014886|9335311836|72010000000|62440000000|1.69%|33.59|5.87|CVX!
2022-11-02|2|3|381079090663|11518252145|10007027368|74880000000|64910000000|3.28%|33.08|5.87|APA!
2022-11-03|3|5|559957815140|16861032936|15153483379|99010000000|85777000000|3.338%|33.21|6.53|COP!CTRA!
2023-01-23|0|1|30337951874|382368879|402493557|5900000000|6060000000|-2.96%|79.34|5.01|BKR!
2023-01-27|1|2|358190787161|8079946929|8721147587|62370000000|59890000000|-7.24%|44.33|5.98|CVX!
2023-02-02|2|3|486561459771|11297822452|11950897189|81630000000|77930000000|-8.15%|43.07|6.24|COP!
2023-02-22|3|5|517116892513|12624309555|13207423100|86380000000|82130000000|5.505%|40.96|6.3|APA!CTRA!
2023-04-19|0|1|30277577840|281745490|261620812|5700000000|5530000000|2%|107.46|5.48|BKR!
2023-04-28|1|2|345031356103|6963017392|6622944482|56490000000|54480000000|0.17%|49.55|6.33|CVX!
2023-05-03|2|3|354926124624|7328013503|6951134262|58500000000|56370000000|-6.11%|48.43|6.3|APA!
2023-05-04|3|5|492978749265|10808451175|9923728806|76170000000|73840000000|4.404%|45.61|6.68|COP!CTRA!
2023-07-19|0|1|34876066731|392431218|332057185|6300000000|6270000000|-1.08%|88.87|5.56|BKR!
2023-07-28|1|2|342892111639|6189140361|5940561486|55200000000|53890000000|2.51%|55.4|6.36|CVX!
2023-08-02|2|3|355670042718|6449851869|6176735440|57000000000|55640000000|3.53%|55.14|6.39|APA!
2023-08-03|3|4|490690199803|8634682482|8551551324|71530000000|70620000000|-1.63%|56.83|6.95|COP!
2023-08-07|4|5|511450690447|8928037241|8807296499|72720000000|71880000000|0.11%|57.29|7.12|CTRA!
2023-10-25|0|1|35238310933|422618235|402493557|6640000000|6520000000|1.57%|83.38|5.4|BKR!
2023-10-27|1|2|310186765049|6162865925|7177867880|60720000000|57880000000|-5.6%|50.33|5.36|CVX!
2023-11-01|2|3|322360458868|6570802755|7524460826|63030000000|59900000000|-0.08%|49.06|5.38|APA!
2023-11-02|3|4|464552559923|9135603910|9994269345|77780000000|74960000000|2.64%|50.85|6.2|COP!
2023-11-06|4|5|485200221814|9511699755|10325233689|79140000000|76330000000|-2.1%|51.01|6.36|CTRA!
2024-01-23|0|1|30891380515|0|479269203|0|6940000000|0%|0|4.45|BKR!
2024-02-02|1|2|298593948203|0|7009977231|0|59220000000|0%|0|5.04|CVX!
2024-02-08|2|3|426679642907|0|9919126689|0|74850000000|0%|0|5.7|COP!
2024-02-21|3|4|435994711723|0|10388407403|0|77030000000|0%|0|5.66|APA!
2024-02-23|4|5|454333145125|0|10853863621|0|78630000000|0%|0|5.78|CTRA!