You are browsing sample data. Buy download of full dataset or subscribe to API access with one of our member plans.
{ "sample": { "is_sample": "TRUE", "limit_total": 200 }, "api": { "title": "当日美国股市数据及上市公司信息 3", "desc": "美国股市数据及上市公司信息 数据集", "point": { "title": "Main", "desc": "Main access point of this API. " } }, "input": {}, "links": { "up": { "href": "https://songer.datasn.com/data/api/v1/u_e49e7f0fcb85c5451b03/stock_information_of_USA_3/main/" }, "home": { "href": "https://songer.datasn.com/data/api/v1/u_e49e7f0fcb85c5451b03/stock_information_of_USA_3/main/list/?app=html-json&manifest=row" }, "prev": { "href": "https://songer.datasn.com/data/api/v1/u_e49e7f0fcb85c5451b03/stock_information_of_USA_3/main/list/4/?app=html-json&manifest=row" }, "next": { "href": "https://songer.datasn.com/data/api/v1/u_e49e7f0fcb85c5451b03/stock_information_of_USA_3/main/list/6/?app=html-json&manifest=row" } }, "meta": { "query": { "page": 5, "limit": 20, "limit_total": 200, "time": 0.00536999999999999977351450297646806575357913970947265625 }, "stats": { "raw_rows": 20, "rows": 20, "rows_total": 4050, "pages_total": 203 }, "struct": { "stem": { "0": "stock" }, "leaf": "stock.id", "leaf_stem": {}, "leaf_stem_leaf": null } }, "output": { "rows": { "81": { "stock.id": 81, "stock.ts": "2018-05-01 05:07:29", "stock.stock_number": "NFG", "stock.stock": "National Fuel Gas Company", "stock.description": "", "stock.description_1": "", "stock.company_websit_1": "", "stock.company_websit": "", "stock.company_address": "", "stock.business": "", "stock.category_x_stock_id": { "81": { "category_x_stock.id": 81, "category.id": 3, "category.ts": "2018-04-26 23:53:30", "category.title": "公用事业" } }, "stock.day_transaction_id": { "81": { "day_transaction.id": 81, "day_transaction.ts": "2018-05-01 05:07:29", "day_transaction.today_open": 51.88000000000000255795384873636066913604736328125, "day_transaction.last_close": 51.7999999999999971578290569595992565155029296875, "day_transaction.high": 52.02000000000000312638803734444081783294677734375, "day_transaction.low": 51.219999999999998863131622783839702606201171875, "day_transaction.high52week": 59.9200000000000017053025658242404460906982421875, "day_transaction.low52week": 48.31000000000000227373675443232059478759765625, "day_transaction.volume": "45.82万", "day_transaction.amplitude": "1.54%", "day_transaction.turnover_rate": "0.53%", "day_transaction.market_capital": "44.45亿", "day_transaction.eps": 4.55999999999999960920149533194489777088165283203125, "day_transaction.pe_lyr": 15.699999999999999289457264239899814128875732421875, "day_transaction.moving_avg_50_day": 57.47999999999999687361196265555918216705322265625, "day_transaction.moving_avg_200_day": 57.1099999999999994315658113919198513031005859375, "day_transaction.total_shares": "8580.20万", "day_transaction.inst_own": 63.53999999999999914734871708787977695465087890625, "day_transaction.net_assets": 19.699999999999999289457264239899814128875732421875, "day_transaction.bonus_stock": "1.66/3.20", "day_transaction.mrq": 2.95000000000000017763568394002504646778106689453125, "day_transaction.number_of_empty_heads": 11.0299999999999993605115378159098327159881591796875 } }, "stock.board_id": { "981": { "board.id": 981, "board.ts": "2018-05-02 03:46:34", "board.name": "Mr. David F. Smith", "board.position": "Chairman", "board.resume": "" }, "982": { "board.id": 982, "board.ts": "2018-05-02 03:46:34", "board.name": "Mr. Ronald J. Tanski", "board.position": "President, Chief Executive Officer & Director", "board.resume": "" }, "983": { "board.id": 983, "board.ts": "2018-05-02 03:46:34", "board.name": "Mr. John R. Pustulka", "board.position": "Chief Operating Officer", "board.resume": "" }, "984": { "board.id": 984, "board.ts": "2018-05-02 03:46:34", "board.name": "Mr. David P. Bauer", "board.position": "Chief Financial Officer & Treasurer", "board.resume": "" }, "985": { "board.id": 985, "board.ts": "2018-05-02 03:46:34", "board.name": "Ms. Ann M. Wegrzyn", "board.position": "Chief Information Officer", "board.resume": "" }, "986": { "board.id": 986, "board.ts": "2018-05-02 03:46:34", "board.name": "Mr. Carl M. Carlotti", "board.position": "President-Utility", "board.resume": "" }, "987": { "board.id": 987, "board.ts": "2018-05-02 03:46:34", "board.name": "Ms. Donna L. DeCarolis", "board.position": "Vice President-Business Development", "board.resume": "" }, "988": { "board.id": 988, "board.ts": "2018-05-02 03:46:34", "board.name": "Ms. Karen M. Camiolo", "board.position": "Chief Accounting Officer & Controller", "board.resume": "" }, "989": { "board.id": 989, "board.ts": "2018-05-02 03:46:34", "board.name": "Ms. Karen L. Merkel", "board.position": "Media Contact", "board.resume": "" }, "990": { "board.id": 990, "board.ts": "2018-05-02 03:46:34", "board.name": "Mr. Brian M. Welsch", "board.position": "Director-Investor Relations", "board.resume": "" }, "991": { "board.id": 991, "board.ts": "2018-05-02 03:46:34", "board.name": "Ms. Kathryn Nikisch-Hoffman", "board.position": "Investor Relations Contact", "board.resume": "" }, "992": { "board.id": 992, "board.ts": "2018-05-02 03:46:34", "board.name": "Ms. Paula M. Ciprich", "board.position": "Secretary, Senior Vice President & General Counsel", "board.resume": "" }, "993": { "board.id": 993, "board.ts": "2018-05-02 03:46:34", "board.name": "Mr. Philip C. Ackerman", "board.position": "Independent Director", "board.resume": "" }, "994": { "board.id": 994, "board.ts": "2018-05-02 03:46:34", "board.name": "Mr. Thomas E. Skains", "board.position": "Independent Director", "board.resume": "" }, "995": { "board.id": 995, "board.ts": "2018-05-02 03:46:34", "board.name": "Mr. Stephen E. Ewing", "board.position": "Lead Independent Director", "board.resume": "" }, "996": { "board.id": 996, "board.ts": "2018-05-02 03:46:34", "board.name": "Mr. Joseph N. Jaggers", "board.position": "Independent Director", "board.resume": "" }, "997": { "board.id": 997, "board.ts": "2018-05-02 03:46:34", "board.name": "Mr. Jeffrey W. Shaw", "board.position": "Independent Director", "board.resume": "" }, "998": { "board.id": 998, "board.ts": "2018-05-02 03:46:34", "board.name": "Mr. David C. Carroll", "board.position": "Independent Director", "board.resume": "" } } }, "82": { "stock.id": 82, "stock.ts": "2018-05-01 05:07:48", "stock.stock_number": "UGI", "stock.stock": "UGI Corporation", "stock.description": "", "stock.description_1": "", "stock.company_websit_1": "", "stock.company_websit": "", "stock.company_address": "", "stock.business": "", "stock.category_x_stock_id": { "82": { "category_x_stock.id": 82, "category.id": 3, "category.ts": "2018-04-26 23:53:30", "category.title": "公用事业" } }, "stock.day_transaction_id": { "82": { "day_transaction.id": 82, "day_transaction.ts": "2018-05-01 05:07:48", "day_transaction.today_open": 48.590000000000003410605131648480892181396484375, "day_transaction.last_close": 48.5, "day_transaction.high": 48.7999999999999971578290569595992565155029296875, "day_transaction.low": 48.2999999999999971578290569595992565155029296875, "day_transaction.high52week": 52, "day_transaction.low52week": 42.50999999999999801048033987171947956085205078125, "day_transaction.volume": "104.41万", "day_transaction.amplitude": "1.03%", "day_transaction.turnover_rate": "0.60%", "day_transaction.market_capital": "83.91亿", "day_transaction.eps": 4, "day_transaction.pe_lyr": 19.719999999999998863131622783839702606201171875, "day_transaction.moving_avg_50_day": 47.6099999999999994315658113919198513031005859375, "day_transaction.moving_avg_200_day": 48.96000000000000085265128291212022304534912109375, "day_transaction.total_shares": "1.73亿", "day_transaction.inst_own": 79.31999999999999317878973670303821563720703125, "day_transaction.net_assets": 18.32000000000000028421709430404007434844970703125, "day_transaction.bonus_stock": "1.04/2.14", "day_transaction.mrq": 2.609999999999999875655021241982467472553253173828125, "day_transaction.number_of_empty_heads": 1.7800000000000000266453525910037569701671600341796875 } }, "stock.board_id": { "999": { "board.id": 999, "board.ts": "2018-05-02 03:47:12", "board.name": "Mr. John L. Walsh", "board.position": "President, Chief Executive Officer & Director", "board.resume": "" }, "1000": { "board.id": 1000, "board.ts": "2018-05-02 03:47:12", "board.name": "Mr. Kirk R. Oliver", "board.position": "Chief Financial Officer", "board.resume": "" }, "1001": { "board.id": 1001, "board.ts": "2018-05-02 03:47:12", "board.name": "Mr. Alan N. Harris", "board.position": "Director", "board.resume": "" }, "1002": { "board.id": 1002, "board.ts": "2018-05-02 03:47:12", "board.name": "Mr. Theodore A. Dosch", "board.position": "Director", "board.resume": "" }, "1003": { "board.id": 1003, "board.ts": "2018-05-02 03:47:12", "board.name": "Mr. G. Gary Garcia", "board.position": "Treasurer", "board.resume": "" }, "1004": { "board.id": 1004, "board.ts": "2018-05-02 03:47:12", "board.name": "Ms. Ann P. Kelly", "board.position": "Chief Accounting Officer, VP & Controller", "board.resume": "" }, "1005": { "board.id": 1005, "board.ts": "2018-05-02 03:47:12", "board.name": "Ms. Shelly Oates", "board.position": "Finance Assistant", "board.resume": "" }, "1006": { "board.id": 1006, "board.ts": "2018-05-02 03:47:12", "board.name": "Mr. William Ruthrauff", "board.position": "Director-Investor Relations", "board.resume": "" }, "1007": { "board.id": 1007, "board.ts": "2018-05-02 03:47:12", "board.name": "Ms. Monica M. Gaudiosi", "board.position": "Secretary, Vice President & General Counsel", "board.resume": "" }, "1008": { "board.id": 1008, "board.ts": "2018-05-02 03:47:12", "board.name": "Mr. Marvin O. Schlanger", "board.position": "Non-Executive Chairman", "board.resume": "" }, "1009": { "board.id": 1009, "board.ts": "2018-05-02 03:47:12", "board.name": "Ms. Anne Pol", "board.position": "Independent Director", "board.resume": "" }, "1010": { "board.id": 1010, "board.ts": "2018-05-02 03:47:12", "board.name": "Mr. James B. Stallings", "board.position": "Independent Director", "board.resume": "" }, "1011": { "board.id": 1011, "board.ts": "2018-05-02 03:47:12", "board.name": "Ms. M. Shawn Bort", "board.position": "Independent Director", "board.resume": "" }, "1012": { "board.id": 1012, "board.ts": "2018-05-02 03:47:12", "board.name": "Mr. Frank S. Hermance", "board.position": "Independent Director", "board.resume": "" }, "1013": { "board.id": 1013, "board.ts": "2018-05-02 03:47:12", "board.name": "Mr. Richard W. Gochnauer", "board.position": "Independent Director", "board.resume": "" }, "1014": { "board.id": 1014, "board.ts": "2018-05-02 03:47:12", "board.name": "Mr. Roger B. Vincent", "board.position": "Independent Director", "board.resume": "" } } }, "83": { "stock.id": 83, "stock.ts": "2018-05-01 05:08:04", "stock.stock_number": "PEG", "stock.stock": "Public Service Enterprise Group Incorporated", "stock.description": "", "stock.description_1": "", "stock.company_websit_1": "", "stock.company_websit": "", "stock.company_address": "", "stock.business": "", "stock.category_x_stock_id": { "83": { "category_x_stock.id": 83, "category.id": 3, "category.ts": "2018-04-26 23:53:30", "category.title": "公用事业" } }, "stock.day_transaction_id": { "83": { "day_transaction.id": 83, "day_transaction.ts": "2018-05-01 05:08:04", "day_transaction.today_open": 51.61999999999999744204615126363933086395263671875, "day_transaction.last_close": 51.530000000000001136868377216160297393798828125, "day_transaction.high": 52.31000000000000227373675443232059478759765625, "day_transaction.low": 51.31000000000000227373675443232059478759765625, "day_transaction.high52week": 53.280000000000001136868377216160297393798828125, "day_transaction.low52week": 41.6700000000000017053025658242404460906982421875, "day_transaction.volume": "257.41万", "day_transaction.amplitude": "1.94%", "day_transaction.turnover_rate": "0.51%", "day_transaction.market_capital": "260.11亿", "day_transaction.eps": 3.100000000000000088817841970012523233890533447265625, "day_transaction.pe_lyr": 16.620000000000000994759830064140260219573974609375, "day_transaction.moving_avg_50_day": 47.46000000000000085265128291212022304534912109375, "day_transaction.moving_avg_200_day": 45.32000000000000028421709430404007434844970703125, "day_transaction.total_shares": "5.05亿", "day_transaction.inst_own": 63.3599999999999994315658113919198513031005859375, "day_transaction.net_assets": 25.5799999999999982946974341757595539093017578125, "day_transaction.bonus_stock": "1.80/3.49", "day_transaction.mrq": 1.9199999999999999289457264239899814128875732421875, "day_transaction.number_of_empty_heads": 2.20000000000000017763568394002504646778106689453125 } }, "stock.board_id": { "1015": { "board.id": 1015, "board.ts": "2018-05-02 03:47:50", "board.name": "Dr. Ralph Izzo", "board.position": "Chairman, President & Chief Executive Officer", "board.resume": "" }, "1016": { "board.id": 1016, "board.ts": "2018-05-02 03:47:50", "board.name": "Mr. Ralph A. LaRossa", "board.position": "Chief Operating Officer", "board.resume": "" }, "1017": { "board.id": 1017, "board.ts": "2018-05-02 03:47:50", "board.name": "Mr. Daniel J. Cregg", "board.position": "Chief Financial Officer & Executive Vice President", "board.resume": "" }, "1018": { "board.id": 1018, "board.ts": "2018-05-02 03:47:50", "board.name": "Mr. Stuart J. Black", "board.position": "Vice President & Controller", "board.resume": "" }, "1019": { "board.id": 1019, "board.ts": "2018-05-02 03:47:50", "board.name": "Ms. Kathleen A. Lally", "board.position": "Vice President-Investor Relations", "board.resume": "" }, "1020": { "board.id": 1020, "board.ts": "2018-05-02 03:47:50", "board.name": "Mr. Carlotta Chan Lane", "board.position": "Manager-Investor Relations", "board.resume": "" }, "1021": { "board.id": 1021, "board.ts": "2018-05-02 03:47:50", "board.name": "Ms. Karen Cleeve", "board.position": "Vice President-Corporate Communications", "board.resume": "" }, "1022": { "board.id": 1022, "board.ts": "2018-05-02 03:47:50", "board.name": "Mr. Michael K. Hyun", "board.position": "Secretary, Investor Relations & Governance Contact", "board.resume": "" }, "1023": { "board.id": 1023, "board.ts": "2018-05-02 03:47:50", "board.name": "Mr. Michael Jennings", "board.position": "Head-Media Relations", "board.resume": "" }, "1024": { "board.id": 1024, "board.ts": "2018-05-02 03:47:50", "board.name": "Ms. Tamara Louise Linde", "board.position": "Executive Vice President & General Counsel", "board.resume": "" }, "1025": { "board.id": 1025, "board.ts": "2018-05-02 03:47:50", "board.name": "Mr. Albert R. Gamper", "board.position": "Independent Director", "board.resume": "" }, "1026": { "board.id": 1026, "board.ts": "2018-05-02 03:47:50", "board.name": "Mr. Barry H. Ostrowsky", "board.position": "Independent Director", "board.resume": "" }, "1027": { "board.id": 1027, "board.ts": "2018-05-02 03:47:50", "board.name": "Mr. Willie A. Deese", "board.position": "Independent Director", "board.resume": "" }, "1028": { "board.id": 1028, "board.ts": "2018-05-02 03:47:50", "board.name": "Mr. Thomas A. Renyi", "board.position": "Independent Director", "board.resume": "" }, "1029": { "board.id": 1029, "board.ts": "2018-05-02 03:47:50", "board.name": "Mr. Hak Cheol Shin", "board.position": "Independent Director", "board.resume": "" }, "1030": { "board.id": 1030, "board.ts": "2018-05-02 03:47:50", "board.name": "Dr. Shirley Ann Jackson", "board.position": "Independent Director", "board.resume": "" }, "1031": { "board.id": 1031, "board.ts": "2018-05-02 03:47:50", "board.name": "Ms. Susan Tomasky", "board.position": "Independent Director", "board.resume": "" }, "1032": { "board.id": 1032, "board.ts": "2018-05-02 03:47:50", "board.name": "Mr. David Lilley", "board.position": "Independent Director", "board.resume": "" }, "1033": { "board.id": 1033, "board.ts": "2018-05-02 03:47:50", "board.name": "Mr. Alfred W. Zollar", "board.position": "Independent Director", "board.resume": "" }, "1034": { "board.id": 1034, "board.ts": "2018-05-02 03:47:50", "board.name": "Mr. William V. Hickey", "board.position": "Independent Director", "board.resume": "" }, "1035": { "board.id": 1035, "board.ts": "2018-05-02 03:47:50", "board.name": "Mr. Richard J. Swift", "board.position": "Independent Director", "board.resume": "" } } }, "84": { "stock.id": 84, "stock.ts": "2018-05-01 05:08:24", "stock.stock_number": "NWN", "stock.stock": "西北天然气", "stock.description": "", "stock.description_1": "", "stock.company_websit_1": "", "stock.company_websit": "", "stock.company_address": "", "stock.business": "", "stock.category_x_stock_id": { "84": { "category_x_stock.id": 84, "category.id": 3, "category.ts": "2018-04-26 23:53:30", "category.title": "公用事业" } }, "stock.day_transaction_id": { "84": { "day_transaction.id": 84, "day_transaction.ts": "2018-05-01 05:08:24", "day_transaction.today_open": 61.75, "day_transaction.last_close": 61.75, "day_transaction.high": 62.35000000000000142108547152020037174224853515625, "day_transaction.low": 61.2999999999999971578290569595992565155029296875, "day_transaction.high52week": 69.5, "day_transaction.low52week": 51.5, "day_transaction.volume": "8.51万", "day_transaction.amplitude": "1.62%", "day_transaction.turnover_rate": "0.39%", "day_transaction.market_capital": "17.77亿", "day_transaction.eps": -1.939999999999999946709294817992486059665679931640625, "day_transaction.pe_lyr": "-", "day_transaction.moving_avg_50_day": 65.7000000000000028421709430404007434844970703125, "day_transaction.moving_avg_200_day": 63.03999999999999914734871708787977695465087890625, "day_transaction.total_shares": "2878.30万", "day_transaction.inst_own": 58.2000000000000028421709430404007434844970703125, "day_transaction.net_assets": 30.190000000000001278976924368180334568023681640625, "day_transaction.bonus_stock": "1.89/3.06", "day_transaction.mrq": 2.20000000000000017763568394002504646778106689453125, "day_transaction.number_of_empty_heads": 9.4000000000000003552713678800500929355621337890625 } }, "stock.board_id": { "1036": { "board.id": 1036, "board.ts": "2018-05-02 03:48:31", "board.name": "Mr. David Hugo Anderson", "board.position": "President, Chief Executive Officer & Director", "board.resume": "" }, "1037": { "board.id": 1037, "board.ts": "2018-05-02 03:48:31", "board.name": "Mr. Frank Burkhartsmeyer", "board.position": "Chief Financial Officer & Senior Vice President", "board.resume": "" }, "1038": { "board.id": 1038, "board.ts": "2018-05-02 03:48:31", "board.name": "Mr. Jon Huddleston", "board.position": "Vice President-Engineering & Utility Operations", "board.resume": "" }, "1039": { "board.id": 1039, "board.ts": "2018-05-02 03:48:31", "board.name": "Mr. James R. Downing", "board.position": "Chief Information Officer & Vice President", "board.resume": "" }, "1040": { "board.id": 1040, "board.ts": "2018-05-02 03:48:31", "board.name": "Ms. Lea Anne Doolittle", "board.position": "Chief Administrative Officer & Senior VP", "board.resume": "" }, "1041": { "board.id": 1041, "board.ts": "2018-05-02 03:48:31", "board.name": "Ms. Lori Russell", "board.position": "Vice President-Utility Services", "board.resume": "" }, "1042": { "board.id": 1042, "board.ts": "2018-05-02 03:48:31", "board.name": "Mr. Justin Palfreyman", "board.position": "Vice President-Business Development", "board.resume": "" }, "1043": { "board.id": 1043, "board.ts": "2018-05-02 03:48:31", "board.name": "Ms. Shawn M. Filippi", "board.position": "Secretary, Chief Compliance Officer & VP", "board.resume": "" }, "1044": { "board.id": 1044, "board.ts": "2018-05-02 03:48:31", "board.name": "Mr. Brody J. Wilson", "board.position": "Treasurer, Chief Accounting Officer & Controller", "board.resume": "" }, "1045": { "board.id": 1045, "board.ts": "2018-05-02 03:48:31", "board.name": "Ms. Kimberly A. Heiting", "board.position": "Chief Marketing Officer & SVP-Utility Operations", "board.resume": "" }, "1046": { "board.id": 1046, "board.ts": "2018-05-02 03:48:31", "board.name": "Mr. Thomas J. Imeson", "board.position": "Vice President-Public Affairs", "board.resume": "" }, "1047": { "board.id": 1047, "board.ts": "2018-05-02 03:48:31", "board.name": "Ms. Nikki Sparley", "board.position": "Investor Relations Contact", "board.resume": "" }, "1048": { "board.id": 1048, "board.ts": "2018-05-02 03:48:31", "board.name": "Mr. Chu Lee", "board.position": "Shareholder Services Contact", "board.resume": "" }, "1049": { "board.id": 1049, "board.ts": "2018-05-02 03:48:31", "board.name": "Ms. MardiLyn Saathoff", "board.position": "Senior Vice President & General Counsel", "board.resume": "" }, "1050": { "board.id": 1050, "board.ts": "2018-05-02 03:48:31", "board.name": "Mr. Tod R. Hamachek", "board.position": "Chairman", "board.resume": "" }, "1051": { "board.id": 1051, "board.ts": "2018-05-02 03:48:31", "board.name": "Ms. Malia H. Wasson", "board.position": "Independent Director", "board.resume": "" }, "1052": { "board.id": 1052, "board.ts": "2018-05-02 03:48:31", "board.name": "Mr. Kenneth Thrasher", "board.position": "Independent Director", "board.resume": "" }, "1053": { "board.id": 1053, "board.ts": "2018-05-02 03:48:31", "board.name": "Ms. Martha L. Byorum", "board.position": "Independent Director", "board.resume": "" }, "1054": { "board.id": 1054, "board.ts": "2018-05-02 03:48:31", "board.name": "Mr. Mark S. Dodson", "board.position": "Independent Director", "board.resume": "" }, "1055": { "board.id": 1055, "board.ts": "2018-05-02 03:48:31", "board.name": "Mr. Charles Scott Gibson", "board.position": "Independent Director", "board.resume": "" }, "1056": { "board.id": 1056, "board.ts": "2018-05-02 03:48:31", "board.name": "Mr. Timothy P. Boyle", "board.position": "Independent Director", "board.resume": "" }, "1057": { "board.id": 1057, "board.ts": "2018-05-02 03:48:31", "board.name": "Ms. Jane L. Peverett", "board.position": "Independent Director", "board.resume": "" }, "1058": { "board.id": 1058, "board.ts": "2018-05-02 03:48:31", "board.name": "Mr. John D. Carter", "board.position": "Independent Director", "board.resume": "" } } }, "85": { "stock.id": 85, "stock.ts": "2018-05-01 05:08:38", "stock.stock_number": "XEL", "stock.stock": "埃克西尔能源", "stock.description": "", "stock.description_1": "", "stock.company_websit_1": "", "stock.company_websit": "", "stock.company_address": "", "stock.business": "", "stock.category_x_stock_id": { "85": { "category_x_stock.id": 85, "category.id": 3, "category.ts": "2018-04-26 23:53:30", "category.title": "公用事业" } }, "stock.day_transaction_id": { "85": { "day_transaction.id": 85, "day_transaction.ts": "2018-05-01 05:08:38", "day_transaction.today_open": 47.21000000000000085265128291212022304534912109375, "day_transaction.last_close": 47.10000000000000142108547152020037174224853515625, "day_transaction.high": 47.36999999999999744204615126363933086395263671875, "day_transaction.low": 46.81000000000000227373675443232059478759765625, "day_transaction.high52week": 52.219999999999998863131622783839702606201171875, "day_transaction.low52week": 41.50999999999999801048033987171947956085205078125, "day_transaction.volume": "283.28万", "day_transaction.amplitude": "1.19%", "day_transaction.turnover_rate": "0.56%", "day_transaction.market_capital": "239.67亿", "day_transaction.eps": 2.25, "day_transaction.pe_lyr": 20.92999999999999971578290569595992565155029296875, "day_transaction.moving_avg_50_day": 48.409999999999996589394868351519107818603515625, "day_transaction.moving_avg_200_day": 47.409999999999996589394868351519107818603515625, "day_transaction.total_shares": "5.09亿", "day_transaction.inst_own": 69.3700000000000045474735088646411895751953125, "day_transaction.net_assets": 21.910000000000000142108547152020037174224853515625, "day_transaction.bonus_stock": "1.52/3.23", "day_transaction.mrq": 2.2599999999999997868371792719699442386627197265625, "day_transaction.number_of_empty_heads": 3.810000000000000053290705182007513940334320068359375 } }, "stock.board_id": { "1059": { "board.id": 1059, "board.ts": "2018-05-02 03:49:11", "board.name": "Mr. Benjamin G. S. Fowke", "board.position": "Chairman, President & Chief Executive Officer", "board.resume": "" }, "1060": { "board.id": 1060, "board.ts": "2018-05-02 03:49:11", "board.name": "Mr. Kent T. Larson", "board.position": "President-Group Operations & Executive VP", "board.resume": "" }, "1061": { "board.id": 1061, "board.ts": "2018-05-02 03:49:11", "board.name": "Mr. Robert C. Frenzel", "board.position": "Chief Financial Officer & Executive Vice President", "board.resume": "" }, "1062": { "board.id": 1062, "board.ts": "2018-05-02 03:49:11", "board.name": "Mr. Marvin E. McDaniel", "board.position": "Chief Administrative Officer & Executive VP", "board.resume": "" }, "1063": { "board.id": 1063, "board.ts": "2018-05-02 03:49:11", "board.name": "Mr. David L. Eves", "board.position": "Executive VP & Group President-Utilities", "board.resume": "" }, "1064": { "board.id": 1064, "board.ts": "2018-05-02 03:49:11", "board.name": "Mr. Timothy John O'Connor", "board.position": "Chief Nuclear Officer & Senior Vice President", "board.resume": "" }, "1065": { "board.id": 1065, "board.ts": "2018-05-02 03:49:11", "board.name": "Mr. George E. Tyson", "board.position": "Senior Vice President-Corporate Development", "board.resume": "" }, "1066": { "board.id": 1066, "board.ts": "2018-05-02 03:49:11", "board.name": "Mr. Brian J. Van Abel", "board.position": "Treasurer & Vice President", "board.resume": "" }, "1067": { "board.id": 1067, "board.ts": "2018-05-02 03:49:11", "board.name": "Mr. Jeffrey S. Savage", "board.position": "Senior Vice President & Controller", "board.resume": "" }, "1068": { "board.id": 1068, "board.ts": "2018-05-02 03:49:11", "board.name": "Mr. Darin Norman", "board.position": "Senior Analyst-Investor Relations", "board.resume": "" }, "1069": { "board.id": 1069, "board.ts": "2018-05-02 03:49:11", "board.name": "Mr. Paul A. Johnson", "board.position": "Vice President-Investor Relations", "board.resume": "" }, "1070": { "board.id": 1070, "board.ts": "2018-05-02 03:49:11", "board.name": "Ms. Judy M. Poferl", "board.position": "Secretary, SVP & Executive Services", "board.resume": "" }, "1071": { "board.id": 1071, "board.ts": "2018-05-02 03:49:11", "board.name": "Mr. Darcy Diederich Flinn", "board.position": "Director-Regulatory Affairs", "board.resume": "" }, "1072": { "board.id": 1072, "board.ts": "2018-05-02 03:49:11", "board.name": "Mr. Scott M. Wilensky", "board.position": "Executive Vice President & General Counsel", "board.resume": "" }, "1073": { "board.id": 1073, "board.ts": "2018-05-02 03:49:11", "board.name": "Mr. David K. Owens", "board.position": "Independent Director", "board.resume": "" }, "1074": { "board.id": 1074, "board.ts": "2018-05-02 03:49:11", "board.name": "Dr. Daniel W. Yohannes", "board.position": "Independent Director", "board.resume": "" }, "1075": { "board.id": 1075, "board.ts": "2018-05-02 03:49:11", "board.name": "Mr. James T. Prokopanko", "board.position": "Independent Director", "board.resume": "" }, "1076": { "board.id": 1076, "board.ts": "2018-05-02 03:49:11", "board.name": "Mr. Richard K. Davis", "board.position": "Independent Director", "board.resume": "" }, "1077": { "board.id": 1077, "board.ts": "2018-05-02 03:49:11", "board.name": "Mr. Christopher J. Policinski", "board.position": "Lead Independent Director", "board.resume": "" }, "1078": { "board.id": 1078, "board.ts": "2018-05-02 03:49:11", "board.name": "Mr. Timothy V. Wolf", "board.position": "Independent Director", "board.resume": "" }, "1079": { "board.id": 1079, "board.ts": "2018-05-02 03:49:11", "board.name": "Mr. David A. Westerlund", "board.position": "Independent Director", "board.resume": "" }, "1080": { "board.id": 1080, "board.ts": "2018-05-02 03:49:11", "board.name": "Mr. Richard T. O'Brien", "board.position": "Independent Director", "board.resume": "" }, "1081": { "board.id": 1081, "board.ts": "2018-05-02 03:49:11", "board.name": "Mr. James J. Sheppard", "board.position": "Independent Director", "board.resume": "" }, "1082": { "board.id": 1082, "board.ts": "2018-05-02 03:49:11", "board.name": "Ms. Kim Williams", "board.position": "Independent Director", "board.resume": "" }, "1083": { "board.id": 1083, "board.ts": "2018-05-02 03:49:11", "board.name": "Ms. A. Patricia Sampson", "board.position": "Independent Director", "board.resume": "" } } }, "86": { "stock.id": 86, "stock.ts": "2018-05-01 05:08:53", "stock.stock_number": "NI", "stock.stock": "NiSource Inc", "stock.description": "", "stock.description_1": "", "stock.company_websit_1": "", "stock.company_websit": "", "stock.company_address": "", "stock.business": "", "stock.category_x_stock_id": { "86": { "category_x_stock.id": 86, "category.id": 3, "category.ts": "2018-04-26 23:53:30", "category.title": "公用事业" } }, "stock.day_transaction_id": { "86": { "day_transaction.id": 86, "day_transaction.ts": "2018-05-01 05:08:53", "day_transaction.today_open": 24.559999999999998721023075631819665431976318359375, "day_transaction.last_close": 24.510000000000001563194018672220408916473388671875, "day_transaction.high": 24.620000000000000994759830064140260219573974609375, "day_transaction.low": 24.3900000000000005684341886080801486968994140625, "day_transaction.high52week": 27.760000000000001563194018672220408916473388671875, "day_transaction.low52week": 22.440000000000001278976924368180334568023681640625, "day_transaction.volume": "147.45万", "day_transaction.amplitude": "0.90%", "day_transaction.turnover_rate": "0.64%", "day_transaction.market_capital": "82.74亿", "day_transaction.eps": -0.39000000000000001332267629550187848508358001708984375, "day_transaction.pe_lyr": 62.85000000000000142108547152020037174224853515625, "day_transaction.moving_avg_50_day": 26.25, "day_transaction.moving_avg_200_day": 25.8299999999999982946974341757595539093017578125, "day_transaction.total_shares": "3.38亿", "day_transaction.inst_own": 86.6299999999999954525264911353588104248046875, "day_transaction.net_assets": 12.660000000000000142108547152020037174224853515625, "day_transaction.bonus_stock": "0.78/3.18", "day_transaction.mrq": 2.0800000000000000710542735760100185871124267578125, "day_transaction.number_of_empty_heads": "-" } }, "stock.board_id": { "1084": { "board.id": 1084, "board.ts": "2018-05-02 03:49:58", "board.name": "Mr. Joseph J. Hamrock", "board.position": "President, Chief Executive Officer & Director", "board.resume": "" }, "1085": { "board.id": 1085, "board.ts": "2018-05-02 03:49:58", "board.name": "Mr. Donald Eugene Brown", "board.position": "Chief Financial Officer & Executive Vice President", "board.resume": "" }, "1086": { "board.id": 1086, "board.ts": "2018-05-02 03:49:58", "board.name": "Mr. Mark Kempic", "board.position": "Chief Transformation Officer", "board.resume": "" }, "1087": { "board.id": 1087, "board.ts": "2018-05-02 03:49:58", "board.name": "Mr. Pablo A. Vegas", "board.position": "Chief Customer Officer & EVP-Gas Business", "board.resume": "" }, "1088": { "board.id": 1088, "board.ts": "2018-05-02 03:49:58", "board.name": "Mr. Carl W. Levander", "board.position": "EVP-Regulatory Policy & Corporate Affairs Officer", "board.resume": "" }, "1089": { "board.id": 1089, "board.ts": "2018-05-02 03:49:58", "board.name": "Mr. Vincent V. Rea", "board.position": "Assistant Treasurer", "board.resume": "" }, "1090": { "board.id": 1090, "board.ts": "2018-05-02 03:49:58", "board.name": "Ms. Violet G. Sistovaris", "board.position": "Executive Vice President-NIPSCO", "board.resume": "" }, "1091": { "board.id": 1091, "board.ts": "2018-05-02 03:49:58", "board.name": "Mr. Vincent A. Parisi", "board.position": "Vice President-Finance & Regulatory", "board.resume": "" }, "1092": { "board.id": 1092, "board.ts": "2018-05-02 03:49:58", "board.name": "Ms. Suzanne K. Surface", "board.position": "Vice President-Audit", "board.resume": "" }, "1093": { "board.id": 1093, "board.ts": "2018-05-02 03:49:58", "board.name": "Mr. Shawn Anderson", "board.position": "Treasurer & Chief Risk Officer", "board.resume": "" }, "1094": { "board.id": 1094, "board.ts": "2018-05-02 03:49:58", "board.name": "Mr. Joseph W. Mulpas", "board.position": "Chief Accounting Officer & Vice President", "board.resume": "" }, "1095": { "board.id": 1095, "board.ts": "2018-05-02 03:49:58", "board.name": "Ms. Sara Macioch", "board.position": "Manager-Investor Relations", "board.resume": "" }, "1096": { "board.id": 1096, "board.ts": "2018-05-02 03:49:58", "board.name": "Mr. Ken Stammen", "board.position": "Communications Manager", "board.resume": "" }, "1097": { "board.id": 1097, "board.ts": "2018-05-02 03:49:58", "board.name": "Mr. Samuel K. Lee", "board.position": "Secretary & Vice President", "board.resume": "" }, "1098": { "board.id": 1098, "board.ts": "2018-05-02 03:49:58", "board.name": "Ms. Carrie J. Hightman", "board.position": "Chief Legal Officer & Executive Vice President", "board.resume": "" }, "1099": { "board.id": 1099, "board.ts": "2018-05-02 03:49:58", "board.name": "Mr. Richard L. Thompson", "board.position": "Independent Chairman", "board.resume": "" }, "1100": { "board.id": 1100, "board.ts": "2018-05-02 03:49:58", "board.name": "Mr. Eric L. Butler", "board.position": "Independent Director", "board.resume": "" }, "1101": { "board.id": 1101, "board.ts": "2018-05-02 03:49:58", "board.name": "Dr. Peter A. Altabef", "board.position": "Independent Director", "board.resume": "" }, "1102": { "board.id": 1102, "board.ts": "2018-05-02 03:49:58", "board.name": "Mr. Kevin T. Kabat", "board.position": "Independent Director", "board.resume": "" }, "1103": { "board.id": 1103, "board.ts": "2018-05-02 03:49:58", "board.name": "Ms. Deborah Ann Henretta", "board.position": "Independent Director", "board.resume": "" }, "1104": { "board.id": 1104, "board.ts": "2018-05-02 03:49:58", "board.name": "Dr. Aristides S. Candris", "board.position": "Independent Director", "board.resume": "" }, "1105": { "board.id": 1105, "board.ts": "2018-05-02 03:49:58", "board.name": "Dr. Carolyn Y. Woo", "board.position": "Independent Director", "board.resume": "" }, "1106": { "board.id": 1106, "board.ts": "2018-05-02 03:49:58", "board.name": "Mr. Michael E. Jesanis", "board.position": "Independent Director", "board.resume": "" }, "1107": { "board.id": 1107, "board.ts": "2018-05-02 03:49:58", "board.name": "Mr. Richard A. Abdoo", "board.position": "Independent Director", "board.resume": "" } } }, "87": { "stock.id": 87, "stock.ts": "2018-05-01 05:09:08", "stock.stock_number": "WR", "stock.stock": "Westar Energy, Inc.", "stock.description": "Westar Energy, Inc. (Westar Energy) is an electric utility operating in Kansas. It provides electric generation, transmission and distribution services to approximately 685,000 customers in Kansas. Westar Energy provides these services in central and north-eastern Kansas, including the cities of Topeka, Lawrence, Manhattan, Salina and Hutchinson. Kansas Gas and Electric Company (KGE), Westar Energy’s wholly owned subsidiary, provides these services in south-central and south-eastern Kansas, including the city of Wichita. KGE owns a 47% interest in Wolf Creek Generating Station (Wolf Creek), a nuclear power plant located near Burlington, Kansas. Both Westar Energy and KGE conduct business using the name Westar Energy.", "stock.description_1": "", "stock.company_websit_1": "http://www.westarenergy.com/", "stock.company_websit": "", "stock.company_address": "", "stock.business": "", "stock.category_x_stock_id": { "87": { "category_x_stock.id": 87, "category.id": 3, "category.ts": "2018-04-26 23:53:30", "category.title": "公用事业" } }, "stock.day_transaction_id": { "87": { "day_transaction.id": 87, "day_transaction.ts": "2018-05-01 05:09:08", "day_transaction.today_open": 54.39999999999999857891452847979962825775146484375, "day_transaction.last_close": 54.280000000000001136868377216160297393798828125, "day_transaction.high": 54.60000000000000142108547152020037174224853515625, "day_transaction.low": 54.14999999999999857891452847979962825775146484375, "day_transaction.high52week": 57.32000000000000028421709430404007434844970703125, "day_transaction.low52week": 47.06000000000000227373675443232059478759765625, "day_transaction.volume": "33.97万", "day_transaction.amplitude": "0.81%", "day_transaction.turnover_rate": "0.32%", "day_transaction.market_capital": "77.20亿", "day_transaction.eps": 2.270000000000000017763568394002504646778106689453125, "day_transaction.pe_lyr": 23.910000000000000142108547152020037174224853515625, "day_transaction.moving_avg_50_day": 51.36999999999999744204615126363933086395263671875, "day_transaction.moving_avg_200_day": 51.77000000000000312638803734444081783294677734375, "day_transaction.total_shares": "1.42亿", "day_transaction.inst_own": 75.099999999999994315658113919198513031005859375, "day_transaction.net_assets": 26.9200000000000017053025658242404460906982421875, "day_transaction.bonus_stock": "1.60/2.95", "day_transaction.mrq": 1.9899999999999999911182158029987476766109466552734375, "day_transaction.number_of_empty_heads": 1.79000000000000003552713678800500929355621337890625 } }, "stock.board_id": { "1108": { "board.id": 1108, "board.ts": "2018-05-02 03:50:37", "board.name": "Mr. Mark A. Ruelle", "board.position": "President, Chief Executive Officer & Director", "board.resume": "" }, "1109": { "board.id": 1109, "board.ts": "2018-05-02 03:50:37", "board.name": "Mr. Anthony D. Somma", "board.position": "Chief Financial Officer, Treasurer & Senior VP", "board.resume": "" }, "1110": { "board.id": 1110, "board.ts": "2018-05-02 03:50:37", "board.name": "Ms. Debra Grunst", "board.position": "Vice President-Information Technology", "board.resume": "" }, "1111": { "board.id": 1111, "board.ts": "2018-05-02 03:50:37", "board.name": "Mr. Jerl L. Banning", "board.position": "Senior VP-Operations Support & Administration", "board.resume": "" }, "1112": { "board.id": 1112, "board.ts": "2018-05-02 03:50:37", "board.name": "Mr. Bruce A. Akin", "board.position": "Senior Vice President-Power Delivery", "board.resume": "" }, "1113": { "board.id": 1113, "board.ts": "2018-05-02 03:50:37", "board.name": "Ms. Cindy Wilson", "board.position": "Executive Director-Compliance & Internal Audit", "board.resume": "" }, "1114": { "board.id": 1114, "board.ts": "2018-05-02 03:50:37", "board.name": "Mr. Greg A. Greenwood", "board.position": "Senior Vice President-Strategy", "board.resume": "" }, "1115": { "board.id": 1115, "board.ts": "2018-05-02 03:50:37", "board.name": "Mr. Kelly B. Harrison", "board.position": "Vice President-Transmission Operations", "board.resume": "" }, "1116": { "board.id": 1116, "board.ts": "2018-05-02 03:50:37", "board.name": "Mr. John T. Bridson", "board.position": "Senior Vice President-Generation & Marketing", "board.resume": "" }, "1117": { "board.id": 1117, "board.ts": "2018-05-02 03:50:37", "board.name": "Mr. Kevin L. Kongs", "board.position": "Vice President & Controller", "board.resume": "" }, "1118": { "board.id": 1118, "board.ts": "2018-05-02 03:50:37", "board.name": "Ms. Michel Phillipp Cole", "board.position": "VP-Corporate Communications & Public Affairs", "board.resume": "" }, "1119": { "board.id": 1119, "board.ts": "2018-05-02 03:50:37", "board.name": "Mr. Cody VandeVelde", "board.position": "Director-Investor Relations", "board.resume": "" }, "1120": { "board.id": 1120, "board.ts": "2018-05-02 03:50:37", "board.name": "Mr. Larry D. Irick", "board.position": "Secretary, Vice President & General Counsel", "board.resume": "" }, "1121": { "board.id": 1121, "board.ts": "2018-05-02 03:50:37", "board.name": "Mr. Jeffrey L. Martin", "board.position": "Vice President-Regulatory Affairs", "board.resume": "" }, "1122": { "board.id": 1122, "board.ts": "2018-05-02 03:50:37", "board.name": "Mr. Charles Q. Chandler", "board.position": "Chairman", "board.resume": "" }, "1123": { "board.id": 1123, "board.ts": "2018-05-02 03:50:37", "board.name": "Mr. Richard L. Hawley", "board.position": "Independent Director", "board.resume": "" }, "1124": { "board.id": 1124, "board.ts": "2018-05-02 03:50:37", "board.name": "Mr. S. Carl Soderstrom", "board.position": "Independent Director", "board.resume": "" }, "1125": { "board.id": 1125, "board.ts": "2018-05-02 03:50:37", "board.name": "Mr. B. Anthony Isaac", "board.position": "Independent Director", "board.resume": "" }, "1126": { "board.id": 1126, "board.ts": "2018-05-02 03:50:37", "board.name": "Mr. R. A. Edwards", "board.position": "Independent Director", "board.resume": "" }, "1127": { "board.id": 1127, "board.ts": "2018-05-02 03:50:37", "board.name": "Ms. Mollie Hale Carter", "board.position": "Independent Director", "board.resume": "" }, "1128": { "board.id": 1128, "board.ts": "2018-05-02 03:50:37", "board.name": "Ms. Sandra A. J. Lawrence", "board.position": "Independent Director", "board.resume": "" }, "1129": { "board.id": 1129, "board.ts": "2018-05-02 03:50:37", "board.name": "Dr. Jerry B. Farley", "board.position": "Independent Director", "board.resume": "" } } }, "88": { "stock.id": 88, "stock.ts": "2018-05-01 05:09:31", "stock.stock_number": "LNT", "stock.stock": "美国联合能源", "stock.description": "", "stock.description_1": "", "stock.company_websit_1": "", "stock.company_websit": "", "stock.company_address": "", "stock.business": "", "stock.category_x_stock_id": { "88": { "category_x_stock.id": 88, "category.id": 3, "category.ts": "2018-04-26 23:53:30", "category.title": "公用事业" } }, "stock.day_transaction_id": { "88": { "day_transaction.id": 88, "day_transaction.ts": "2018-05-01 05:09:31", "day_transaction.today_open": 43.219999999999998863131622783839702606201171875, "day_transaction.last_close": 43.06000000000000227373675443232059478759765625, "day_transaction.high": 43.27000000000000312638803734444081783294677734375, "day_transaction.low": 42.8900000000000005684341886080801486968994140625, "day_transaction.high52week": 45.5499999999999971578290569595992565155029296875, "day_transaction.low52week": 36.840000000000003410605131648480892181396484375, "day_transaction.volume": "100.54万", "day_transaction.amplitude": "0.86%", "day_transaction.turnover_rate": "0.66%", "day_transaction.market_capital": "99.68亿", "day_transaction.eps": 1.9899999999999999911182158029987476766109466552734375, "day_transaction.pe_lyr": 21.6400000000000005684341886080801486968994140625, "day_transaction.moving_avg_50_day": 42.63000000000000255795384873636066913604736328125, "day_transaction.moving_avg_200_day": 41.409999999999996589394868351519107818603515625, "day_transaction.total_shares": "2.31亿", "day_transaction.inst_own": 57.82000000000000028421709430404007434844970703125, "day_transaction.net_assets": 17.530000000000001136868377216160297393798828125, "day_transaction.bonus_stock": "1.34/3.11", "day_transaction.mrq": 2.470000000000000195399252334027551114559173583984375, "day_transaction.number_of_empty_heads": 2.54000000000000003552713678800500929355621337890625 } }, "stock.board_id": { "1130": { "board.id": 1130, "board.ts": "2018-05-02 03:51:24", "board.name": "Ms. Patricia Leonard Kampling", "board.position": "Chairman & Chief Executive Officer", "board.resume": "" }, "1131": { "board.id": 1131, "board.ts": "2018-05-02 03:51:24", "board.name": "Mr. John O. Larsen", "board.position": "President", "board.resume": "" }, "1132": { "board.id": 1132, "board.ts": "2018-05-02 03:51:24", "board.name": "Mr. Douglas R. Kopp", "board.position": "Senior Vice President-Operations", "board.resume": "" }, "1133": { "board.id": 1133, "board.ts": "2018-05-02 03:51:24", "board.name": "Mr. Robert J. Durian", "board.position": "Chief Financial Officer, Treasurer & VP", "board.resume": "" }, "1134": { "board.id": 1134, "board.ts": "2018-05-02 03:51:24", "board.name": "Dr. Dirk Mahling", "board.position": "Vice President-Technology", "board.resume": "" }, "1135": { "board.id": 1135, "board.ts": "2018-05-02 03:51:24", "board.name": "Mr. Vern A. Gebhart", "board.position": "VP-Business Infrastructure & Technology", "board.resume": "" }, "1136": { "board.id": 1136, "board.ts": "2018-05-02 03:51:24", "board.name": "Ms. Barbara Tormaschy", "board.position": "Vice President-Finance", "board.resume": "" }, "1137": { "board.id": 1137, "board.ts": "2018-05-02 03:51:24", "board.name": "Ms. Jeanine Penticoff", "board.position": "Vice President", "board.resume": "" }, "1138": { "board.id": 1138, "board.ts": "2018-05-02 03:51:24", "board.name": "Mr. Joel J. Schmidt", "board.position": "Vice President", "board.resume": "" }, "1139": { "board.id": 1139, "board.ts": "2018-05-02 03:51:24", "board.name": "Mr. David de Leon", "board.position": "Vice President-Wisconsin Operations", "board.resume": "" }, "1140": { "board.id": 1140, "board.ts": "2018-05-02 03:51:24", "board.name": "Mr. Terry Kouba", "board.position": "Vice President-Generation Operations", "board.resume": "" }, "1141": { "board.id": 1141, "board.ts": "2018-05-02 03:51:24", "board.name": "Mr. Gregg E. Lawry", "board.position": "Vice President-Customer Services", "board.resume": "" }, "1142": { "board.id": 1142, "board.ts": "2018-05-02 03:51:24", "board.name": "Ms. Linda K. Mattes", "board.position": "Vice President-Energy Delivery Operations", "board.resume": "" }, "1143": { "board.id": 1143, "board.ts": "2018-05-02 03:51:24", "board.name": "Mr. Benjamin M. Bilitz", "board.position": "Chief Accounting Officer & Controller", "board.resume": "" }, "1144": { "board.id": 1144, "board.ts": "2018-05-02 03:51:24", "board.name": "Ms. Susan Trapp Gille", "board.position": "Manager-Investor Relations", "board.resume": "" }, "1145": { "board.id": 1145, "board.ts": "2018-05-02 03:51:24", "board.name": "Mr. Scott Reigstad", "board.position": "Head-Media Relations", "board.resume": "" }, "1146": { "board.id": 1146, "board.ts": "2018-05-02 03:51:24", "board.name": "Mr. James H. Gallegos", "board.position": "Secretary, Senior Vice President & General Counsel", "board.resume": "" }, "1147": { "board.id": 1147, "board.ts": "2018-05-02 03:51:24", "board.name": "Mr. Thomas F. O'Toole", "board.position": "Independent Director", "board.resume": "" }, "1148": { "board.id": 1148, "board.ts": "2018-05-02 03:51:24", "board.name": "Ms. Deborah B. Dunie", "board.position": "Independent Director", "board.resume": "" }, "1149": { "board.id": 1149, "board.ts": "2018-05-02 03:51:24", "board.name": "Mr. Darryl Barton Hazel", "board.position": "Independent Director", "board.resume": "" }, "1150": { "board.id": 1150, "board.ts": "2018-05-02 03:51:24", "board.name": "Ms. Susan D. Whiting", "board.position": "Independent Director", "board.resume": "" }, "1151": { "board.id": 1151, "board.ts": "2018-05-02 03:51:24", "board.name": "Mr. Patrick E. Allen", "board.position": "Independent Director", "board.resume": "" }, "1152": { "board.id": 1152, "board.ts": "2018-05-02 03:51:24", "board.name": "Ms. Carol Patricia Sanders", "board.position": "Independent Director", "board.resume": "" }, "1153": { "board.id": 1153, "board.ts": "2018-05-02 03:51:24", "board.name": "Mr. Dean C. Oestreich", "board.position": "Lead Independent Director", "board.resume": "" }, "1154": { "board.id": 1154, "board.ts": "2018-05-02 03:51:24", "board.name": "Ms. Singleton B. McAllister", "board.position": "Independent Director", "board.resume": "" } } }, "89": { "stock.id": 89, "stock.ts": "2018-05-01 05:09:41", "stock.stock_number": "CPK", "stock.stock": "切萨皮克气业", "stock.description": "Chesapeake Utilities Corporation enjoys a long and prosperous history. The Dover Gas Light Company, formed in 1859, would eventually become Chesapeake Utilities Corporation, even though the Company wasn’t officially incorporated in the State of Delaware until 88 years later in 1947. The very next year, the Company acquired two smaller gas companies, one in Seaford, Delaware, and the other in nearby Salisbury, Maryland, and the Company hasn’t stopped growing ever since.", "stock.description_1": "", "stock.company_websit_1": "http://www.chpk.com", "stock.company_websit": "", "stock.company_address": "", "stock.business": "", "stock.category_x_stock_id": { "89": { "category_x_stock.id": 89, "category.id": 3, "category.ts": "2018-04-26 23:53:30", "category.title": "公用事业" } }, "stock.day_transaction_id": { "89": { "day_transaction.id": 89, "day_transaction.ts": "2018-05-01 05:09:41", "day_transaction.today_open": 76.5499999999999971578290569595992565155029296875, "day_transaction.last_close": 76.5, "day_transaction.high": 76.9500000000000028421709430404007434844970703125, "day_transaction.low": 75.9500000000000028421709430404007434844970703125, "day_transaction.high52week": 86.349999999999994315658113919198513031005859375, "day_transaction.low52week": 66.349999999999994315658113919198513031005859375, "day_transaction.volume": "3.51万", "day_transaction.amplitude": "1.11%", "day_transaction.turnover_rate": "0.21%", "day_transaction.market_capital": "12.52亿", "day_transaction.eps": 3.54999999999999982236431605997495353221893310546875, "day_transaction.pe_lyr": 21.550000000000000710542735760100185871124267578125, "day_transaction.moving_avg_50_day": 79.8799999999999954525264911353588104248046875, "day_transaction.moving_avg_200_day": 76.8299999999999982946974341757595539093017578125, "day_transaction.total_shares": "1636.20万", "day_transaction.inst_own": 54.31000000000000227373675443232059478759765625, "day_transaction.net_assets": 28.25, "day_transaction.bonus_stock": "1.30/1.70", "day_transaction.mrq": 2.850000000000000088817841970012523233890533447265625, "day_transaction.number_of_empty_heads": 2.850000000000000088817841970012523233890533447265625 } }, "stock.board_id": { "1155": { "board.id": 1155, "board.ts": "2018-05-02 03:52:03", "board.name": "Mr. Michael P. McMasters", "board.position": "President, Chief Executive Officer & Director", "board.resume": "" }, "1156": { "board.id": 1156, "board.ts": "2018-05-02 03:52:03", "board.name": "Ms. Beth W. Cooper", "board.position": "Chief Financial Officer & Senior Vice President", "board.resume": "" }, "1157": { "board.id": 1157, "board.ts": "2018-05-02 03:52:03", "board.name": "Mr. Vikrant A. Gadgil", "board.position": "Chief Information Officer & Vice President", "board.resume": "" }, "1158": { "board.id": 1158, "board.ts": "2018-05-02 03:52:03", "board.name": "Ms. Sheri Richard", "board.position": "Vice President-Rates & Regulatory Affairs", "board.resume": "" }, "1159": { "board.id": 1159, "board.ts": "2018-05-02 03:52:03", "board.name": "Mr. Stephen C. Thompson", "board.position": "Senior Vice President", "board.resume": "" }, "1160": { "board.id": 1160, "board.ts": "2018-05-02 03:52:03", "board.name": "Ms. Elaine B. Bittner", "board.position": "Senior Vice President-Strategic Development", "board.resume": "" }, "1161": { "board.id": 1161, "board.ts": "2018-05-02 03:52:03", "board.name": "Dr. John J. Lewnard", "board.position": "Vice President-Business Development", "board.resume": "" }, "1162": { "board.id": 1162, "board.ts": "2018-05-02 03:52:03", "board.name": "Mr. Mark L. Eisenhower", "board.position": "Vice President-Strategic Planning & Development", "board.resume": "" }, "1163": { "board.id": 1163, "board.ts": "2018-05-02 03:52:03", "board.name": "Mr. Jospeh D. Steinmetz", "board.position": "Assistant Vice President-Internal Audit", "board.resume": "" }, "1164": { "board.id": 1164, "board.ts": "2018-05-02 03:52:03", "board.name": "Ms. Devon S. Rudloff", "board.position": "Assistant Vice President-Human Resources", "board.resume": "" }, "1165": { "board.id": 1165, "board.ts": "2018-05-02 03:52:03", "board.name": "Mr. Thomas E. Mahn", "board.position": "Treasurer & Vice President", "board.resume": "" }, "1166": { "board.id": 1166, "board.ts": "2018-05-02 03:52:03", "board.name": "Mr. Naimul Islam", "board.position": "Vice President & Controller", "board.resume": "" }, "1167": { "board.id": 1167, "board.ts": "2018-05-02 03:52:03", "board.name": "Ms. Heidi W. Watkins", "board.position": "Investor Relations Administrator", "board.resume": "" }, "1168": { "board.id": 1168, "board.ts": "2018-05-02 03:52:03", "board.name": "Mr. Sydney H. Davis", "board.position": "Communications Manager & Head-Media Contacts", "board.resume": "" }, "1169": { "board.id": 1169, "board.ts": "2018-05-02 03:52:03", "board.name": "Mr. Lou Anatrella", "board.position": "Chief Human Resources Officer", "board.resume": "" }, "1170": { "board.id": 1170, "board.ts": "2018-05-02 03:52:03", "board.name": "Mr. James F. Moriarty", "board.position": "Secretary, Senior Vice President & General Counsel", "board.resume": "" }, "1171": { "board.id": 1171, "board.ts": "2018-05-02 03:52:03", "board.name": "Mr. John R. Schimkaitis", "board.position": "Chairman", "board.resume": "" }, "1172": { "board.id": 1172, "board.ts": "2018-05-02 03:52:03", "board.name": "Dr. Ronald G. Forsythe", "board.position": "Independent Director", "board.resume": "" }, "1173": { "board.id": 1173, "board.ts": "2018-05-02 03:52:03", "board.name": "Ms. Dianna F. Morgan", "board.position": "Independent Director", "board.resume": "" }, "1174": { "board.id": 1174, "board.ts": "2018-05-02 03:52:03", "board.name": "Mr. Calvert A. Morgan", "board.position": "Independent Director", "board.resume": "" }, "1175": { "board.id": 1175, "board.ts": "2018-05-02 03:52:03", "board.name": "Mr. Eugene H. Bayard", "board.position": "Independent Director", "board.resume": "" }, "1176": { "board.id": 1176, "board.ts": "2018-05-02 03:52:03", "board.name": "Mr. Thomas P. Hill", "board.position": "Independent Director", "board.resume": "" }, "1177": { "board.id": 1177, "board.ts": "2018-05-02 03:52:03", "board.name": "Mr. Thomas J. Bresnan", "board.position": "Independent Director", "board.resume": "" }, "1178": { "board.id": 1178, "board.ts": "2018-05-02 03:52:03", "board.name": "Mr. Paul L. Maddock", "board.position": "Independent Director", "board.resume": "" }, "1179": { "board.id": 1179, "board.ts": "2018-05-02 03:52:03", "board.name": "Mr. Dennis S. Hudson", "board.position": "Independent Director", "board.resume": "" } } }, "90": { "stock.id": 90, "stock.ts": "2018-05-01 05:10:08", "stock.stock_number": "POR", "stock.stock": "波特兰通用电气", "stock.description": "", "stock.description_1": "", "stock.company_websit_1": "", "stock.company_websit": "", "stock.company_address": "", "stock.business": "", "stock.category_x_stock_id": { "90": { "category_x_stock.id": 90, "category.id": 3, "category.ts": "2018-04-26 23:53:30", "category.title": "公用事业" } }, "stock.day_transaction_id": { "90": { "day_transaction.id": 90, "day_transaction.ts": "2018-05-01 05:10:08", "day_transaction.today_open": 42.57000000000000028421709430404007434844970703125, "day_transaction.last_close": 42.3299999999999982946974341757595539093017578125, "day_transaction.high": 42.7000000000000028421709430404007434844970703125, "day_transaction.low": 42.32000000000000028421709430404007434844970703125, "day_transaction.high52week": 50.1099999999999994315658113919198513031005859375, "day_transaction.low52week": 39.02000000000000312638803734444081783294677734375, "day_transaction.volume": "65.73万", "day_transaction.amplitude": "0.90%", "day_transaction.turnover_rate": "0.73%", "day_transaction.market_capital": "37.76亿", "day_transaction.eps": 2, "day_transaction.pe_lyr": 20.160000000000000142108547152020037174224853515625, "day_transaction.moving_avg_50_day": 46.22999999999999687361196265555918216705322265625, "day_transaction.moving_avg_200_day": 46.14999999999999857891452847979962825775146484375, "day_transaction.total_shares": "8921.50万", "day_transaction.inst_own": 105.93999999999999772626324556767940521240234375, "day_transaction.net_assets": 26.8599999999999994315658113919198513031005859375, "day_transaction.bonus_stock": "1.45/3.43", "day_transaction.mrq": 1.7800000000000000266453525910037569701671600341796875, "day_transaction.number_of_empty_heads": 2.20999999999999996447286321199499070644378662109375 } }, "stock.board_id": { "1180": { "board.id": 1180, "board.ts": "2018-05-02 03:52:47", "board.name": "Ms. Maria MacGregor Pope", "board.position": "President, Chief Executive Officer & Director", "board.resume": "" }, "1181": { "board.id": 1181, "board.ts": "2018-05-02 03:52:47", "board.name": "Mr. James F. Lobdell", "board.position": "CFO, Treasurer, Principal Accounting Officer & SVP", "board.resume": "" }, "1182": { "board.id": 1182, "board.ts": "2018-05-02 03:52:47", "board.name": "Mr. John Kochavatr", "board.position": "Chief Information Officer & Vice President-IT", "board.resume": "" }, "1183": { "board.id": 1183, "board.ts": "2018-05-02 03:52:47", "board.name": "Ms. Lisa Ann Kaner", "board.position": "VP, General Counsel & Compliance Officer", "board.resume": "" }, "1184": { "board.id": 1184, "board.ts": "2018-05-02 03:52:47", "board.name": "Mr. William O. Nicholson", "board.position": "SVP-Customer Service, Transmission & Distribution", "board.resume": "" }, "1185": { "board.id": 1185, "board.ts": "2018-05-02 03:52:47", "board.name": "Mr. William David Robertson", "board.position": "Vice President-Public Policy", "board.resume": "" }, "1186": { "board.id": 1186, "board.ts": "2018-05-02 03:52:47", "board.name": "Ms. Kristin A. Stathis", "board.position": "Vice President-Customer Service Operations", "board.resume": "" }, "1187": { "board.id": 1187, "board.ts": "2018-05-02 03:52:47", "board.name": "Ms. Carol A. Dillin", "board.position": "VP-Customer Strategies & Business Development", "board.resume": "" }, "1188": { "board.id": 1188, "board.ts": "2018-05-02 03:52:47", "board.name": "Mr. Christopher Liddle", "board.position": "Manager-Corporate Finance & Investor Relations", "board.resume": "" }, "1189": { "board.id": 1189, "board.ts": "2018-05-02 03:52:47", "board.name": "Ms. Anne F. Mersereau", "board.position": "VP-Human Resources, Diversity & Inclusion", "board.resume": "" }, "1190": { "board.id": 1190, "board.ts": "2018-05-02 03:52:47", "board.name": "Mr. Marc S. Bocci", "board.position": "Secretary", "board.resume": "" }, "1191": { "board.id": 1191, "board.ts": "2018-05-02 03:52:47", "board.name": "Mr. Jack E. Davis", "board.position": "Chairman", "board.resume": "" }, "1192": { "board.id": 1192, "board.ts": "2018-05-02 03:52:47", "board.name": "Dr. Kathryn Jean Jackson", "board.position": "Independent Director", "board.resume": "" }, "1193": { "board.id": 1193, "board.ts": "2018-05-02 03:52:47", "board.name": "Mr. John W. Ballantine", "board.position": "Independent Director", "board.resume": "" }, "1194": { "board.id": 1194, "board.ts": "2018-05-02 03:52:47", "board.name": "Mr. Mark B. Ganz", "board.position": "Independent Director", "board.resume": "" }, "1195": { "board.id": 1195, "board.ts": "2018-05-02 03:52:47", "board.name": "Dr. M. Lee Pelton", "board.position": "Independent Director", "board.resume": "" }, "1196": { "board.id": 1196, "board.ts": "2018-05-02 03:52:47", "board.name": "Mr. David A. Dietzler", "board.position": "Independent Director", "board.resume": "" }, "1197": { "board.id": 1197, "board.ts": "2018-05-02 03:52:47", "board.name": "Mr. Charles W. Shivery", "board.position": "Independent Director", "board.resume": "" }, "1198": { "board.id": 1198, "board.ts": "2018-05-02 03:52:47", "board.name": "Ms. Kirby A. Dyess", "board.position": "Independent Director", "board.resume": "" }, "1199": { "board.id": 1199, "board.ts": "2018-05-02 03:52:47", "board.name": "Mr. Rodney L. Brown", "board.position": "Independent Director", "board.resume": "" }, "1200": { "board.id": 1200, "board.ts": "2018-05-02 03:52:47", "board.name": "Mr. Neil J. Nelson", "board.position": "Independent Director", "board.resume": "" } } }, "91": { "stock.id": 91, "stock.ts": "2018-05-01 05:10:30", "stock.stock_number": "PATK", "stock.stock": "Patrick Industries, Inc.", "stock.description": "", "stock.description_1": "", "stock.company_websit_1": "", "stock.company_websit": "", "stock.company_address": "", "stock.business": "", "stock.category_x_stock_id": { "91": { "category_x_stock.id": 91, "category.id": 4, "category.ts": "2018-04-26 23:54:32", "category.title": "工业" } }, "stock.day_transaction_id": { "91": { "day_transaction.id": 91, "day_transaction.ts": "2018-05-01 05:10:30", "day_transaction.today_open": 59.2999999999999971578290569595992565155029296875, "day_transaction.last_close": 58.35000000000000142108547152020037174224853515625, "day_transaction.high": 59.42999999999999971578290569595992565155029296875, "day_transaction.low": 56.75, "day_transaction.high52week": 72.349999999999994315658113919198513031005859375, "day_transaction.low52week": 42.77000000000000312638803734444081783294677734375, "day_transaction.volume": "20.63万", "day_transaction.amplitude": "4.59%", "day_transaction.turnover_rate": "0.81%", "day_transaction.market_capital": "14.78亿", "day_transaction.eps": 2.899999999999999911182158029987476766109466552734375, "day_transaction.pe_lyr": 16.769999999999999573674358543939888477325439453125, "day_transaction.moving_avg_50_day": 83.340000000000003410605131648480892181396484375, "day_transaction.moving_avg_200_day": 74.9200000000000017053025658242404460906982421875, "day_transaction.total_shares": "2532.40万", "day_transaction.inst_own": 83.659999999999996589394868351519107818603515625, "day_transaction.net_assets": 19.030000000000001136868377216160297393798828125, "day_transaction.bonus_stock": "-/-", "day_transaction.mrq": 4.88999999999999968025576890795491635799407958984375, "day_transaction.number_of_empty_heads": 7.92999999999999971578290569595992565155029296875 } }, "stock.board_id": { "1201": { "board.id": 1201, "board.ts": "2018-05-02 03:53:32", "board.name": "Mr. Paul E. Hassler", "board.position": "Chairman", "board.resume": "" }, "1202": { "board.id": 1202, "board.ts": "2018-05-02 03:53:32", "board.name": "Mr. Todd M. Cleveland", "board.position": "Chief Executive Officer & Director", "board.resume": "" }, "1203": { "board.id": 1203, "board.ts": "2018-05-02 03:53:32", "board.name": "Mr. Andy L. Nemeth", "board.position": "President & Director", "board.resume": "" }, "1204": { "board.id": 1204, "board.ts": "2018-05-02 03:53:32", "board.name": "Mr. Kip B. Ellis", "board.position": "Chief Operating Officer & Executive Vice President", "board.resume": "" }, "1205": { "board.id": 1205, "board.ts": "2018-05-02 03:53:32", "board.name": "Mr. Joshua A. Boone", "board.position": "CFO, Secretary, Treasurer & Vice President-Finance", "board.resume": "" }, "1206": { "board.id": 1206, "board.ts": "2018-05-02 03:53:32", "board.name": "Mr. James S. Ritchey", "board.position": "VP-National Accounts & Manufactured Housing", "board.resume": "" }, "1207": { "board.id": 1207, "board.ts": "2018-05-02 03:53:32", "board.name": "Mr. Jeffrey M. Rodino", "board.position": "Chief Sales Officer & Executive VP-Sales", "board.resume": "" }, "1208": { "board.id": 1208, "board.ts": "2018-05-02 03:53:32", "board.name": "Ms. Julie Ann Kotowski", "board.position": "Investor Relations Contact", "board.resume": "" }, "1209": { "board.id": 1209, "board.ts": "2018-05-02 03:53:32", "board.name": "Mr. Courtney A. Blosser", "board.position": "Chief Human Resource Officer & EVP-Human Resources", "board.resume": "" }, "1210": { "board.id": 1210, "board.ts": "2018-05-02 03:53:32", "board.name": "Mr. M. Scott Welch", "board.position": "Independent Director", "board.resume": "" }, "1211": { "board.id": 1211, "board.ts": "2018-05-02 03:53:32", "board.name": "Mr. Michael A. Kitson", "board.position": "Independent Director", "board.resume": "" }, "1212": { "board.id": 1212, "board.ts": "2018-05-02 03:53:32", "board.name": "Mr. John A. Forbes", "board.position": "Independent Director", "board.resume": "" }, "1213": { "board.id": 1213, "board.ts": "2018-05-02 03:53:32", "board.name": "Mr. Joseph M. Cerulli", "board.position": "Independent Director", "board.resume": "" }, "1214": { "board.id": 1214, "board.ts": "2018-05-02 03:53:32", "board.name": "Mr. Walter E. Wells", "board.position": "Independent Director", "board.resume": "" } } }, "92": { "stock.id": 92, "stock.ts": "2018-05-01 05:10:40", "stock.stock_number": "CHCI", "stock.stock": "康斯托克住宅建筑", "stock.description": "Since 1985 several thousand families have chosen to make a Comstock home, their home. Comstock is a leading homebuilder in the Washington, DC metropolitan area and the Raleigh-Durham area in North Carolina.", "stock.description_1": "", "stock.company_websit_1": "http://www.comstockhomes.com", "stock.company_websit": "", "stock.company_address": "", "stock.business": "", "stock.category_x_stock_id": { "92": { "category_x_stock.id": 92, "category.id": 4, "category.ts": "2018-04-26 23:54:32", "category.title": "工业" } }, "stock.day_transaction_id": { "92": { "day_transaction.id": 92, "day_transaction.ts": "2018-05-01 05:10:40", "day_transaction.today_open": 2.37999999999999989341858963598497211933135986328125, "day_transaction.last_close": 2.37000000000000010658141036401502788066864013671875, "day_transaction.high": 2.410000000000000142108547152020037174224853515625, "day_transaction.low": 2.25, "day_transaction.high52week": 3.899999999999999911182158029987476766109466552734375, "day_transaction.low52week": 1.1999999999999999555910790149937383830547332763671875, "day_transaction.volume": 6289, "day_transaction.amplitude": "6.75%", "day_transaction.turnover_rate": "0.19%", "day_transaction.market_capital": "800.08万", "day_transaction.eps": -1.20999999999999996447286321199499070644378662109375, "day_transaction.pe_lyr": "-", "day_transaction.moving_avg_50_day": 1.70999999999999996447286321199499070644378662109375, "day_transaction.moving_avg_200_day": 1.899999999999999911182158029987476766109466552734375, "day_transaction.total_shares": "337.40万", "day_transaction.inst_own": 13.269999999999999573674358543939888477325439453125, "day_transaction.net_assets": -3.100000000000000088817841970012523233890533447265625, "day_transaction.bonus_stock": "-/-", "day_transaction.mrq": -0.5300000000000000266453525910037569701671600341796875, "day_transaction.number_of_empty_heads": 0.450000000000000011102230246251565404236316680908203125 } }, "stock.board_id": { "1215": { "board.id": 1215, "board.ts": "2018-05-02 03:54:20", "board.name": "Mr. Timothy J. Steffan", "board.position": "Executive VP-Development & Asset Management", "board.resume": "" }, "1216": { "board.id": 1216, "board.ts": "2018-05-02 03:54:20", "board.name": "Mr. Jubal R. Thompson", "board.position": "Secretary & General Counsel", "board.resume": "" }, "1217": { "board.id": 1217, "board.ts": "2018-05-02 03:54:20", "board.name": "Mr. Norman D. Chirite", "board.position": "Independent Director", "board.resume": "" }, "1218": { "board.id": 1218, "board.ts": "2018-05-02 03:54:20", "board.name": "Mr. James A. MacCutcheon", "board.position": "Independent Director", "board.resume": "" }, "1219": { "board.id": 1219, "board.ts": "2018-05-02 03:54:20", "board.name": "Mr. David M. Guernsey", "board.position": "Independent Director", "board.resume": "" }, "1220": { "board.id": 1220, "board.ts": "2018-05-02 03:54:20", "board.name": "Mr. A. Clayton Perfall", "board.position": "Independent Director", "board.resume": "" }, "1221": { "board.id": 1221, "board.ts": "2018-05-02 03:54:20", "board.name": "Mr. Socrates Verses", "board.position": "Independent Director", "board.resume": "" }, "1222": { "board.id": 1222, "board.ts": "2018-05-02 03:54:20", "board.name": "Mr. Robert P. Pincus", "board.position": "Independent Director", "board.resume": "" } } }, "93": { "stock.id": 93, "stock.ts": "2018-05-01 05:10:58", "stock.stock_number": "MTH", "stock.stock": "Meritage Homes Corporation", "stock.description": "", "stock.description_1": "", "stock.company_websit_1": "http://www.lgvcapital.com", "stock.company_websit": "", "stock.company_address": "", "stock.business": "", "stock.category_x_stock_id": { "93": { "category_x_stock.id": 93, "category.id": 4, "category.ts": "2018-04-26 23:54:32", "category.title": "工业" } }, "stock.day_transaction_id": { "93": { "day_transaction.id": 93, "day_transaction.ts": "2018-05-01 05:10:58", "day_transaction.today_open": 46.5499999999999971578290569595992565155029296875, "day_transaction.last_close": 46.5499999999999971578290569595992565155029296875, "day_transaction.high": 46.64999999999999857891452847979962825775146484375, "day_transaction.low": 44.35000000000000142108547152020037174224853515625, "day_transaction.high52week": 55.5, "day_transaction.low52week": 37.7000000000000028421709430404007434844970703125, "day_transaction.volume": "23.57万", "day_transaction.amplitude": "4.94%", "day_transaction.turnover_rate": "0.68%", "day_transaction.market_capital": "18.91亿", "day_transaction.eps": 3.9199999999999999289457264239899814128875732421875, "day_transaction.pe_lyr": 13.6500000000000003552713678800500929355621337890625, "day_transaction.moving_avg_50_day": 45.28999999999999914734871708787977695465087890625, "day_transaction.moving_avg_200_day": 42.07000000000000028421709430404007434844970703125, "day_transaction.total_shares": "4063.00万", "day_transaction.inst_own": 98.0799999999999982946974341757595539093017578125, "day_transaction.net_assets": 37.00999999999999801048033987171947956085205078125, "day_transaction.bonus_stock": "-/-", "day_transaction.mrq": 1.3200000000000000621724893790087662637233734130859375, "day_transaction.number_of_empty_heads": "-" } }, "stock.board_id": { "1223": { "board.id": 1223, "board.ts": "2018-05-02 03:54:53", "board.name": "Mr. Steven J. Hilton", "board.position": "Chairman & Chief Executive Officer", "board.resume": "" }, "1224": { "board.id": 1224, "board.ts": "2018-05-02 03:54:53", "board.name": "Mr. Phillippe Lord", "board.position": "Chief Operating Officer & Executive Vice President", "board.resume": "" }, "1225": { "board.id": 1225, "board.ts": "2018-05-02 03:54:53", "board.name": "Ms. Hilla Sferruzza", "board.position": "CFO, Chief Accounting Officer & Executive VP", "board.resume": "" }, "1226": { "board.id": 1226, "board.ts": "2018-05-02 03:54:53", "board.name": "Mr. Robert Gary Sarver", "board.position": "Director", "board.resume": "" }, "1227": { "board.id": 1227, "board.ts": "2018-05-02 03:54:53", "board.name": "Mr. Brent A. Anderson", "board.position": "Vice President-Investor & Media Relations", "board.resume": "" }, "1228": { "board.id": 1228, "board.ts": "2018-05-02 03:54:53", "board.name": "Mr. Javier Feliciano", "board.position": "Chief Human Resources Officer & Executive VP", "board.resume": "" }, "1229": { "board.id": 1229, "board.ts": "2018-05-02 03:54:53", "board.name": "Mr. C. Timothy White", "board.position": "Secretary, Executive VP & General Counsel", "board.resume": "" }, "1230": { "board.id": 1230, "board.ts": "2018-05-02 03:54:53", "board.name": "Mr. Michael R. Odell", "board.position": "Independent Non-Executive Director", "board.resume": "" }, "1231": { "board.id": 1231, "board.ts": "2018-05-02 03:54:53", "board.name": "Mr. Peter L. Ax", "board.position": "Lead Independent Non-Executive Director", "board.resume": "" }, "1232": { "board.id": 1232, "board.ts": "2018-05-02 03:54:53", "board.name": "Mr. Raymond Oppel", "board.position": "Independent Non-Executive Director", "board.resume": "" }, "1233": { "board.id": 1233, "board.ts": "2018-05-02 03:54:53", "board.name": "Mr. Richard T. Burke", "board.position": "Independent Non-Executive Director", "board.resume": "" }, "1234": { "board.id": 1234, "board.ts": "2018-05-02 03:54:53", "board.name": "Ms. Deborah Ann Henretta", "board.position": "Independent Director", "board.resume": "" }, "1235": { "board.id": 1235, "board.ts": "2018-05-02 03:54:53", "board.name": "Mr. Gerald W. Haddock", "board.position": "Independent Non-Executive Director", "board.resume": "" }, "1236": { "board.id": 1236, "board.ts": "2018-05-02 03:54:53", "board.name": "Mr. Dana Cuthbert Bradford", "board.position": "Independent Non-Executive Director", "board.resume": "" } } }, "94": { "stock.id": 94, "stock.ts": "2018-05-01 05:11:16", "stock.stock_number": "RS", "stock.stock": "Reliance Steel & Aluminum", "stock.description": "", "stock.description_1": "", "stock.company_websit_1": "", "stock.company_websit": "", "stock.company_address": "", "stock.business": "", "stock.category_x_stock_id": { "94": { "category_x_stock.id": 94, "category.id": 4, "category.ts": "2018-04-26 23:54:32", "category.title": "工业" }, "406": { "category_x_stock.id": 406, "category.id": 20, "category.ts": "2018-05-01 04:36:43", "category.title": "明星股" } }, "stock.day_transaction_id": { "94": { "day_transaction.id": 94, "day_transaction.ts": "2018-05-01 05:11:16", "day_transaction.today_open": 89.650000000000005684341886080801486968994140625, "day_transaction.last_close": 89.0799999999999982946974341757595539093017578125, "day_transaction.high": 89.9500000000000028421709430404007434844970703125, "day_transaction.low": 87.2699999999999960209606797434389591217041015625, "day_transaction.high52week": 95.969999999999998863131622783839702606201171875, "day_transaction.low52week": 68.4599999999999937472239253111183643341064453125, "day_transaction.volume": "51.79万", "day_transaction.amplitude": "2.76%", "day_transaction.turnover_rate": "0.72%", "day_transaction.market_capital": "64.44亿", "day_transaction.eps": 8.4199999999999999289457264239899814128875732421875, "day_transaction.pe_lyr": 10.67999999999999971578290569595992565155029296875, "day_transaction.moving_avg_50_day": 75.7300000000000039790393202565610408782958984375, "day_transaction.moving_avg_200_day": 74.06000000000000227373675443232059478759765625, "day_transaction.total_shares": "7234.30万", "day_transaction.inst_own": 82.409999999999996589394868351519107818603515625, "day_transaction.net_assets": 59.409999999999996589394868351519107818603515625, "day_transaction.bonus_stock": "2.00/2.25", "day_transaction.mrq": 1.29000000000000003552713678800500929355621337890625, "day_transaction.number_of_empty_heads": 2.839999999999999857891452847979962825775146484375 } }, "stock.board_id": { "1237": { "board.id": 1237, "board.ts": "2018-05-02 03:55:32", "board.name": "Mr. Gregg J. Mollins", "board.position": "President, CEO & Non-Independent Director", "board.resume": "" }, "1238": { "board.id": 1238, "board.ts": "2018-05-02 03:55:32", "board.name": "Mr. James Donald Hoffman", "board.position": "Chief Operating Officer & Executive Vice President", "board.resume": "" }, "1239": { "board.id": 1239, "board.ts": "2018-05-02 03:55:32", "board.name": "Ms. Karla R. Lewis", "board.position": "CFO, Principal Accounting Officer & Senior EVP", "board.resume": "" }, "1240": { "board.id": 1240, "board.ts": "2018-05-02 03:55:32", "board.name": "Ms. Susan C. Borchers", "board.position": "Chief Information Officer", "board.resume": "" }, "1241": { "board.id": 1241, "board.ts": "2018-05-02 03:55:32", "board.name": "Mr. William K. Sales", "board.position": "Executive Vice President-Operations", "board.resume": "" }, "1242": { "board.id": 1242, "board.ts": "2018-05-02 03:55:32", "board.name": "Mr. Michael P. Shanley", "board.position": "Senior Vice President-Operations", "board.resume": "" }, "1243": { "board.id": 1243, "board.ts": "2018-05-02 03:55:32", "board.name": "Mr. Stephen Paul Koch", "board.position": "Senior Vice President-Operations", "board.resume": "" }, "1244": { "board.id": 1244, "board.ts": "2018-05-02 03:55:32", "board.name": "Mr. Arthur Ajemyan", "board.position": "Vice President-Corporate Controller", "board.resume": "" }, "1245": { "board.id": 1245, "board.ts": "2018-05-02 03:55:32", "board.name": "Mr. John A. Shatkus", "board.position": "Vice President-Internal Audit", "board.resume": "" }, "1246": { "board.id": 1246, "board.ts": "2018-05-02 03:55:32", "board.name": "Ms. Silva Yeghyayan", "board.position": "Vice President-Tax", "board.resume": "" }, "1247": { "board.id": 1247, "board.ts": "2018-05-02 03:55:32", "board.name": "Mr. David H. Hannah", "board.position": "Non-Independent Director", "board.resume": "" }, "1248": { "board.id": 1248, "board.ts": "2018-05-02 03:55:32", "board.name": "Ms. Brenda Sumiye Miyamoto", "board.position": "Vice President-Corporate Initiatives", "board.resume": "" }, "1249": { "board.id": 1249, "board.ts": "2018-05-02 03:55:32", "board.name": "Mr. Donald J. Prebola", "board.position": "Vice President-Health, Safety & Human Resources", "board.resume": "" }, "1250": { "board.id": 1250, "board.ts": "2018-05-02 03:55:32", "board.name": "Mr. William A. Smith", "board.position": "Secretary, Senior Vice President & General Counsel", "board.resume": "" }, "1251": { "board.id": 1251, "board.ts": "2018-05-02 03:55:32", "board.name": "Mr. Mark V. Kaminski", "board.position": "Independent Non-Executive Chairman", "board.resume": "" }, "1252": { "board.id": 1252, "board.ts": "2018-05-02 03:55:32", "board.name": "Mr. Douglas W. Stotlar", "board.position": "Independent Director", "board.resume": "" }, "1253": { "board.id": 1253, "board.ts": "2018-05-02 03:55:32", "board.name": "Ms. Karen Winifred Colonias", "board.position": "Independent Director", "board.resume": "" }, "1254": { "board.id": 1254, "board.ts": "2018-05-02 03:55:32", "board.name": "Mr. Andrew G. Sharkey", "board.position": "Independent Director", "board.resume": "" }, "1255": { "board.id": 1255, "board.ts": "2018-05-02 03:55:32", "board.name": "Mr. Thomas W. Gimbel", "board.position": "Independent Director", "board.resume": "" }, "1256": { "board.id": 1256, "board.ts": "2018-05-02 03:55:32", "board.name": "Mr. Douglas M. Hayes", "board.position": "Independent Non-Executive Director", "board.resume": "" }, "1257": { "board.id": 1257, "board.ts": "2018-05-02 03:55:32", "board.name": "Mr. John G. Figueroa", "board.position": "Independent Director", "board.resume": "" }, "1258": { "board.id": 1258, "board.ts": "2018-05-02 03:55:32", "board.name": "Mr. Robert Ambrose McEvoy", "board.position": "Independent Director", "board.resume": "" }, "1259": { "board.id": 1259, "board.ts": "2018-05-02 03:55:32", "board.name": "Ms. Sarah J. Anderson", "board.position": "Independent Director", "board.resume": "" } } }, "95": { "stock.id": 95, "stock.ts": "2018-05-01 05:11:28", "stock.stock_number": "PRLB", "stock.stock": "Proto Labs, Inc. Common stock", "stock.description": "Proto Labs is a leading online and technology-enabled quick-turn manufacturer of custom parts for prototyping and short-run production. We provide “Real Parts, Really Fast” to product developers worldwide, who are under increasing pressure to bring their finished products to market faster than their competition. We utilize computer numerical control, or CNC, machining and injection molding to manufacture custom parts for our customers.", "stock.description_1": "", "stock.company_websit_1": "", "stock.company_websit": "", "stock.company_address": "", "stock.business": "", "stock.category_x_stock_id": { "95": { "category_x_stock.id": 95, "category.id": 4, "category.ts": "2018-04-26 23:54:32", "category.title": "工业" } }, "stock.day_transaction_id": { "95": { "day_transaction.id": 95, "day_transaction.ts": "2018-05-01 05:11:28", "day_transaction.today_open": 120.650000000000005684341886080801486968994140625, "day_transaction.last_close": 120.400000000000005684341886080801486968994140625, "day_transaction.high": 122.2000000000000028421709430404007434844970703125, "day_transaction.low": 119.150000000000005684341886080801486968994140625, "day_transaction.high52week": 128.219999999999998863131622783839702606201171875, "day_transaction.low52week": 57.4500000000000028421709430404007434844970703125, "day_transaction.volume": "10.02万", "day_transaction.amplitude": "2.49%", "day_transaction.turnover_rate": "0.37%", "day_transaction.market_capital": "32.43亿", "day_transaction.eps": 1.9299999999999999378275106209912337362766265869140625, "day_transaction.pe_lyr": 62.38000000000000255795384873636066913604736328125, "day_transaction.moving_avg_50_day": 79.7000000000000028421709430404007434844970703125, "day_transaction.moving_avg_200_day": 69.93999999999999772626324556767940521240234375, "day_transaction.total_shares": "2693.10万", "day_transaction.inst_own": 103, "day_transaction.net_assets": 15.449999999999999289457264239899814128875732421875, "day_transaction.bonus_stock": "-/-", "day_transaction.mrq": 5.6500000000000003552713678800500929355621337890625, "day_transaction.number_of_empty_heads": 31.489999999999998436805981327779591083526611328125 } }, "stock.board_id": { "1260": { "board.id": 1260, "board.ts": "2018-05-02 03:56:15", "board.name": "Ms. Victoria M. Holt", "board.position": "President, Chief Executive Officer & Director", "board.resume": "" }, "1261": { "board.id": 1261, "board.ts": "2018-05-02 03:56:15", "board.name": "Mr. John A. Way", "board.position": "Chief Financial Officer & Executive VP-Development", "board.resume": "" }, "1262": { "board.id": 1262, "board.ts": "2018-05-02 03:56:15", "board.name": "Dr. Arthur Richard Baker", "board.position": "Chief Technology Officer", "board.resume": "" }, "1263": { "board.id": 1263, "board.ts": "2018-05-02 03:56:15", "board.name": "Mr. Bjoern Klaas", "board.position": "VP & Managing Director-European Operations", "board.resume": "" }, "1264": { "board.id": 1264, "board.ts": "2018-05-02 03:56:15", "board.name": "Mr. David M. Fein", "board.position": "Chief Revenue Officer", "board.resume": "" }, "1265": { "board.id": 1265, "board.ts": "2018-05-02 03:56:15", "board.name": "Dr. Robert Bodor", "board.position": "Vice President & General Manager-Americas Division", "board.resume": "" }, "1266": { "board.id": 1266, "board.ts": "2018-05-02 03:56:15", "board.name": "Mr. Donald G. Krantz", "board.position": "Director", "board.resume": "" }, "1267": { "board.id": 1267, "board.ts": "2018-05-02 03:56:15", "board.name": "Mr. Lawrence J. Lukis", "board.position": "Founder", "board.resume": "" }, "1268": { "board.id": 1268, "board.ts": "2018-05-02 03:56:15", "board.name": "Mr. William M. Dietrick", "board.position": "VP-Global Marketing & Head-Media Relations", "board.resume": "" }, "1269": { "board.id": 1269, "board.ts": "2018-05-02 03:56:15", "board.name": "Mr. Dan Schumacher", "board.position": "Director-Investor Relations, FP&A", "board.resume": "" }, "1270": { "board.id": 1270, "board.ts": "2018-05-02 03:56:15", "board.name": "Ms. Renee Conklin", "board.position": "Vice President-Global Human Resources", "board.resume": "" }, "1271": { "board.id": 1271, "board.ts": "2018-05-02 03:56:15", "board.name": "Mr. Jason Frankman", "board.position": "Secretary", "board.resume": "" }, "1272": { "board.id": 1272, "board.ts": "2018-05-02 03:56:15", "board.name": "Mr. Sven A. Wehrwein", "board.position": "Chairman", "board.resume": "" }, "1273": { "board.id": 1273, "board.ts": "2018-05-02 03:56:15", "board.name": "Dr. Sujeet Chand", "board.position": "Independent Director", "board.resume": "" }, "1274": { "board.id": 1274, "board.ts": "2018-05-02 03:56:15", "board.name": "Mr. Archie C. Black", "board.position": "Independent Director", "board.resume": "" }, "1275": { "board.id": 1275, "board.ts": "2018-05-02 03:56:15", "board.name": "Mr. John B. Goodman", "board.position": "Independent Director", "board.resume": "" }, "1276": { "board.id": 1276, "board.ts": "2018-05-02 03:56:15", "board.name": "Dr. Rainer Gawlick", "board.position": "Independent Director", "board.resume": "" } } }, "96": { "stock.id": 96, "stock.ts": "2018-05-01 05:11:43", "stock.stock_number": "MDR", "stock.stock": "迈克德莫特国际", "stock.description": "", "stock.description_1": "", "stock.company_websit_1": "", "stock.company_websit": "", "stock.company_address": "", "stock.business": "", "stock.category_x_stock_id": { "96": { "category_x_stock.id": 96, "category.id": 4, "category.ts": "2018-04-26 23:54:32", "category.title": "工业" } }, "stock.day_transaction_id": { "96": { "day_transaction.id": 96, "day_transaction.ts": "2018-05-01 05:11:43", "day_transaction.today_open": 6.8499999999999996447286321199499070644378662109375, "day_transaction.last_close": 6.88999999999999968025576890795491635799407958984375, "day_transaction.high": 6.87999999999999989341858963598497211933135986328125, "day_transaction.low": 6.5999999999999996447286321199499070644378662109375, "day_transaction.high52week": 9.07000000000000028421709430404007434844970703125, "day_transaction.low52week": 5.37999999999999989341858963598497211933135986328125, "day_transaction.volume": "1633.63万", "day_transaction.amplitude": "4.06%", "day_transaction.turnover_rate": "5.71%", "day_transaction.market_capital": "19.70亿", "day_transaction.eps": 0.67000000000000003996802888650563545525074005126953125, "day_transaction.pe_lyr": 10.9399999999999995026200849679298698902130126953125, "day_transaction.moving_avg_50_day": 6.839999999999999857891452847979962825775146484375, "day_transaction.moving_avg_200_day": 6.62999999999999989341858963598497211933135986328125, "day_transaction.total_shares": "2.86亿", "day_transaction.inst_own": 107.599999999999994315658113919198513031005859375, "day_transaction.net_assets": 5.730000000000000426325641456060111522674560546875, "day_transaction.bonus_stock": "-/-", "day_transaction.mrq": 1.1599999999999999200639422269887290894985198974609375, "day_transaction.number_of_empty_heads": 3.95999999999999996447286321199499070644378662109375 } }, "stock.board_id": { "1277": { "board.id": 1277, "board.ts": "2018-05-02 03:56:49", "board.name": "Mr. David Dickson", "board.position": "President, Chief Executive Officer & Director", "board.resume": "" }, "1278": { "board.id": 1278, "board.ts": "2018-05-02 03:56:49", "board.name": "Mr. Thomas Mackie", "board.position": "Vice President-Operations", "board.resume": "" }, "1279": { "board.id": 1279, "board.ts": "2018-05-02 03:56:49", "board.name": "Mr. Stuart A. Spence", "board.position": "Chief Financial Officer & Executive Vice President", "board.resume": "" }, "1280": { "board.id": 1280, "board.ts": "2018-05-02 03:56:49", "board.name": "Mr. Ian Francis Prescott", "board.position": "Vice President-Asia Region", "board.resume": "" }, "1281": { "board.id": 1281, "board.ts": "2018-05-02 03:56:49", "board.name": "Ms. Kathy Murray", "board.position": "Vice President-Finance", "board.resume": "" }, "1282": { "board.id": 1282, "board.ts": "2018-05-02 03:56:49", "board.name": "Mr. Jonathan Tresilian Kennefick", "board.position": "Senior Vice President-Project Execution & Delivery", "board.resume": "" }, "1283": { "board.id": 1283, "board.ts": "2018-05-02 03:56:49", "board.name": "Mr. Linh Austin", "board.position": "Vice President-Middle East & Caspian", "board.resume": "" }, "1284": { "board.id": 1284, "board.ts": "2018-05-02 03:56:49", "board.name": "Mr. Scott Munro", "board.position": "Vice President-Americas, Europe & Africa", "board.resume": "" }, "1285": { "board.id": 1285, "board.ts": "2018-05-02 03:56:49", "board.name": "Ms. Claire P. Meaney", "board.position": "Vice President & Assistant General Counsel", "board.resume": "" }, "1286": { "board.id": 1286, "board.ts": "2018-05-02 03:56:49", "board.name": "Mr. William L. Soester", "board.position": "Senior Vice President-Project Execution", "board.resume": "" }, "1287": { "board.id": 1287, "board.ts": "2018-05-02 03:56:49", "board.name": "Mr. Philippe Barril", "board.position": "Director", "board.resume": "" }, "1288": { "board.id": 1288, "board.ts": "2018-05-02 03:56:49", "board.name": "Mr. Ty Lawrence", "board.position": "Vice President & Treasurer", "board.resume": "" }, "1289": { "board.id": 1289, "board.ts": "2018-05-02 03:56:49", "board.name": "Mr. Jeff J. Hightower", "board.position": "Vice President-Internal Audit", "board.resume": "" }, "1290": { "board.id": 1290, "board.ts": "2018-05-02 03:56:49", "board.name": "Mr. Christopher A. Krummel", "board.position": "Chief Accounting Officer & Vice President-Finance", "board.resume": "" }, "1291": { "board.id": 1291, "board.ts": "2018-05-02 03:56:49", "board.name": "Mr. Adam Morgan", "board.position": "Media Contact", "board.resume": "" }, "1292": { "board.id": 1292, "board.ts": "2018-05-02 03:56:49", "board.name": "Mr. Andrew Leys", "board.position": "Vice President-Human Resources", "board.resume": "" }, "1293": { "board.id": 1293, "board.ts": "2018-05-02 03:56:49", "board.name": "Mr. John Freeman", "board.position": "Secretary, Senior VP & General Counsel", "board.resume": "" }, "1294": { "board.id": 1294, "board.ts": "2018-05-02 03:56:49", "board.name": "Mr. Gary P. Luquette", "board.position": "Non-Executive Chairman", "board.resume": "" }, "1295": { "board.id": 1295, "board.ts": "2018-05-02 03:56:49", "board.name": "Mr. Erich Kaeser", "board.position": "Independent Director", "board.resume": "" }, "1296": { "board.id": 1296, "board.ts": "2018-05-02 03:56:49", "board.name": "Mr. John F. Bookout", "board.position": "Independent Director", "board.resume": "" }, "1297": { "board.id": 1297, "board.ts": "2018-05-02 03:56:49", "board.name": "Mr. William H. Schumann", "board.position": "Independent Director", "board.resume": "" }, "1298": { "board.id": 1298, "board.ts": "2018-05-02 03:56:49", "board.name": "Ms. Mary L. Shafer-Malicki", "board.position": "Independent Director", "board.resume": "" }, "1299": { "board.id": 1299, "board.ts": "2018-05-02 03:56:49", "board.name": "Mr. Stephen G. Hanks", "board.position": "Independent Director", "board.resume": "" }, "1300": { "board.id": 1300, "board.ts": "2018-05-02 03:56:49", "board.name": "Mr. David A. Trice", "board.position": "Independent Director", "board.resume": "" } } }, "97": { "stock.id": 97, "stock.ts": "2018-05-01 05:12:04", "stock.stock_number": "GGG", "stock.stock": "固瑞克", "stock.description": "", "stock.description_1": "", "stock.company_websit_1": "", "stock.company_websit": "", "stock.company_address": "", "stock.business": "", "stock.category_x_stock_id": { "97": { "category_x_stock.id": 97, "category.id": 4, "category.ts": "2018-04-26 23:54:32", "category.title": "工业" } }, "stock.day_transaction_id": { "97": { "day_transaction.id": 97, "day_transaction.ts": "2018-05-01 05:12:04", "day_transaction.today_open": 44.9200000000000017053025658242404460906982421875, "day_transaction.last_close": 44.6700000000000017053025658242404460906982421875, "day_transaction.high": 45.1700000000000017053025658242404460906982421875, "day_transaction.low": 43.97999999999999687361196265555918216705322265625, "day_transaction.high52week": 49.68999999999999772626324556767940521240234375, "day_transaction.low52week": 34.8900000000000005684341886080801486968994140625, "day_transaction.volume": "64.06万", "day_transaction.amplitude": "2.66%", "day_transaction.turnover_rate": "0.46%", "day_transaction.market_capital": "74.87亿", "day_transaction.eps": 1.5900000000000000799360577730112709105014801025390625, "day_transaction.pe_lyr": 30.809999999999998721023075631819665431976318359375, "day_transaction.moving_avg_50_day": 124.7000000000000028421709430404007434844970703125, "day_transaction.moving_avg_200_day": 114.0100000000000051159076974727213382720947265625, "day_transaction.total_shares": "1.68亿", "day_transaction.inst_own": 81.6099999999999994315658113919198513031005859375, "day_transaction.net_assets": 11.6400000000000005684341886080801486968994140625, "day_transaction.bonus_stock": "0.53/1.19", "day_transaction.mrq": 11.32000000000000028421709430404007434844970703125, "day_transaction.number_of_empty_heads": 4.9199999999999999289457264239899814128875732421875 } }, "stock.board_id": { "1301": { "board.id": 1301, "board.ts": "2018-05-02 03:57:22", "board.name": "Mr. Patrick J. McHale", "board.position": "President, Chief Executive Officer & Director", "board.resume": "" }, "1302": { "board.id": 1302, "board.ts": "2018-05-02 03:57:22", "board.name": "Mr. Christian E. Rothe", "board.position": "Chief Financial Officer & Treasurer", "board.resume": "" }, "1303": { "board.id": 1303, "board.ts": "2018-05-02 03:57:22", "board.name": "Ms. Caroline M. Chambers", "board.position": "Vice President-Information Systems & Controller", "board.resume": "" }, "1304": { "board.id": 1304, "board.ts": "2018-05-02 03:57:22", "board.name": "Mr. Dale D. Johnson", "board.position": "President-Worldwide Contractor Equipment Division", "board.resume": "" }, "1305": { "board.id": 1305, "board.ts": "2018-05-02 03:57:22", "board.name": "Mr. Jeffrey P. Johnson", "board.position": "Vice President & General Manager-EMEA", "board.resume": "" }, "1306": { "board.id": 1306, "board.ts": "2018-05-02 03:57:22", "board.name": "Mr. Peter J. O'Shea", "board.position": "Vice President & General Manager-Asia Pacific", "board.resume": "" }, "1307": { "board.id": 1307, "board.ts": "2018-05-02 03:57:22", "board.name": "Mr. David M. Lowe", "board.position": "Executive VP-Industrial Products Division", "board.resume": "" }, "1308": { "board.id": 1308, "board.ts": "2018-05-02 03:57:22", "board.name": "Mr. Bernard J. Moreau", "board.position": "Vice President, GM-South & Central America", "board.resume": "" }, "1309": { "board.id": 1309, "board.ts": "2018-05-02 03:57:22", "board.name": "Mr. Charles L. Rescorla", "board.position": "VP-Distribution Operations & Corporate Development", "board.resume": "" }, "1310": { "board.id": 1310, "board.ts": "2018-05-02 03:57:22", "board.name": "Mr. Mark D. Eberlein", "board.position": "Vice President & GM-Process Division", "board.resume": "" }, "1311": { "board.id": 1311, "board.ts": "2018-05-02 03:57:22", "board.name": "Mr. Brian J. Zumbolo", "board.position": "Vice President & GM-Lubrication Equipment Division", "board.resume": "" }, "1312": { "board.id": 1312, "board.ts": "2018-05-02 03:57:22", "board.name": "Mr. Mark W. Sheahan", "board.position": "VP & GM-Applied Fluid Technologies Division", "board.resume": "" }, "1313": { "board.id": 1313, "board.ts": "2018-05-02 03:57:22", "board.name": "Dr. David M. Ahlers", "board.position": "Vice President-Human Resources & Communications", "board.resume": "" }, "1314": { "board.id": 1314, "board.ts": "2018-05-02 03:57:22", "board.name": "Ms. Karen Park Gallivan", "board.position": "Secretary, Vice President & General Counsel", "board.resume": "" }, "1315": { "board.id": 1315, "board.ts": "2018-05-02 03:57:22", "board.name": "Mr. Lee R. Mitau", "board.position": "Chairman", "board.resume": "" }, "1316": { "board.id": 1316, "board.ts": "2018-05-02 03:57:22", "board.name": "Ms. Emily C. White", "board.position": "Independent Director", "board.resume": "" }, "1317": { "board.id": 1317, "board.ts": "2018-05-02 03:57:22", "board.name": "Mr. Jack W. Eugster", "board.position": "Independent Director", "board.resume": "" }, "1318": { "board.id": 1318, "board.ts": "2018-05-02 03:57:22", "board.name": "Ms. Martha A. M. Morfitt", "board.position": "Independent Director", "board.resume": "" }, "1319": { "board.id": 1319, "board.ts": "2018-05-02 03:57:22", "board.name": "Mr. William J. Carroll", "board.position": "Independent Director", "board.resume": "" }, "1320": { "board.id": 1320, "board.ts": "2018-05-02 03:57:22", "board.name": "Mr. R. William van Sant", "board.position": "Independent Director", "board.resume": "" }, "1321": { "board.id": 1321, "board.ts": "2018-05-02 03:57:22", "board.name": "Ms. Jody H. Feragen", "board.position": "Independent Director", "board.resume": "" }, "1322": { "board.id": 1322, "board.ts": "2018-05-02 03:57:22", "board.name": "Mr. John Kevin Gilligan", "board.position": "Independent Director", "board.resume": "" }, "1323": { "board.id": 1323, "board.ts": "2018-05-02 03:57:22", "board.name": "Mr. Eric P. Etchart", "board.position": "Independent Director", "board.resume": "" } } }, "98": { "stock.id": 98, "stock.ts": "2018-05-01 05:12:15", "stock.stock_number": "CCS", "stock.stock": "Century Communities, Inc.", "stock.description": "Century Communities is engaged in the development, design, construction, marketing and sale of single-family attached and detached homes in the greater Denver, Colorado metropolitan area and, more recently, in the greater Austin and San Antonio, Texas and Las Vegas, Nevada metropolitan areas, under the Century Communities name. In many of our projects, in addition to building homes, we are responsible for the entitlement and development of the underlying land.", "stock.description_1": "", "stock.company_websit_1": "http://www.centurycommunities.com", "stock.company_websit": "", "stock.company_address": "", "stock.business": "", "stock.category_x_stock_id": { "98": { "category_x_stock.id": 98, "category.id": 4, "category.ts": "2018-04-26 23:54:32", "category.title": "工业" } }, "stock.day_transaction_id": { "98": { "day_transaction.id": 98, "day_transaction.ts": "2018-05-01 05:12:15", "day_transaction.today_open": 31.10000000000000142108547152020037174224853515625, "day_transaction.last_close": 31.050000000000000710542735760100185871124267578125, "day_transaction.high": 31.199999999999999289457264239899814128875732421875, "day_transaction.low": 30.699999999999999289457264239899814128875732421875, "day_transaction.high52week": 36, "day_transaction.low52week": 21.89999999999999857891452847979962825775146484375, "day_transaction.volume": "32.36万", "day_transaction.amplitude": "1.45%", "day_transaction.turnover_rate": "1.09%", "day_transaction.market_capital": "9.20亿", "day_transaction.eps": 2.029999999999999804600747665972448885440826416015625, "day_transaction.pe_lyr": 15.300000000000000710542735760100185871124267578125, "day_transaction.moving_avg_50_day": 25.46000000000000085265128291212022304534912109375, "day_transaction.moving_avg_200_day": 25.1700000000000017053025658242404460906982421875, "day_transaction.total_shares": "2964.40万", "day_transaction.inst_own": "-", "day_transaction.net_assets": 23.190000000000001278976924368180334568023681640625, "day_transaction.bonus_stock": "-/-", "day_transaction.mrq": 1.229999999999999982236431605997495353221893310546875, "day_transaction.number_of_empty_heads": 4.19000000000000039079850466805510222911834716796875 } }, "stock.board_id": { "1324": { "board.id": 1324, "board.ts": "2018-05-02 03:57:55", "board.name": "Mr. Dale Francescon", "board.position": "Chairman & Co-Chief Executive Officer", "board.resume": "" }, "1325": { "board.id": 1325, "board.ts": "2018-05-02 03:57:55", "board.name": "Mr. Robert J. Francescon", "board.position": "President, Co-Chief Executive Officer & Director", "board.resume": "" }, "1326": { "board.id": 1326, "board.ts": "2018-05-02 03:57:55", "board.name": "Mr. David L. Messenger", "board.position": "Chief Financial Officer & Secretary", "board.resume": "" }, "1327": { "board.id": 1327, "board.ts": "2018-05-02 03:57:55", "board.name": "Mr. John Scott Dixon", "board.position": "Chief Accounting Officer", "board.resume": "" }, "1328": { "board.id": 1328, "board.ts": "2018-05-02 03:57:55", "board.name": "Mr. James M. Lippman", "board.position": "Independent Director", "board.resume": "" }, "1329": { "board.id": 1329, "board.ts": "2018-05-02 03:57:55", "board.name": "Mr. Keith R. Guericke", "board.position": "Independent Director", "board.resume": "" }, "1330": { "board.id": 1330, "board.ts": "2018-05-02 03:57:55", "board.name": "Mr. John P. Box", "board.position": "Independent Director", "board.resume": "" } } }, "99": { "stock.id": 99, "stock.ts": "2018-05-01 05:12:29", "stock.stock_number": "SKY", "stock.stock": "Skyline Corporation", "stock.description": "", "stock.description_1": "", "stock.company_websit_1": "", "stock.company_websit": "", "stock.company_address": "", "stock.business": "", "stock.category_x_stock_id": { "99": { "category_x_stock.id": 99, "category.id": 4, "category.ts": "2018-04-26 23:54:32", "category.title": "工业" } }, "stock.day_transaction_id": { "99": { "day_transaction.id": 99, "day_transaction.ts": "2018-05-01 05:12:29", "day_transaction.today_open": 25.0799999999999982946974341757595539093017578125, "day_transaction.last_close": 25.379999999999999005240169935859739780426025390625, "day_transaction.high": 26.199999999999999289457264239899814128875732421875, "day_transaction.low": 24.769999999999999573674358543939888477325439453125, "day_transaction.high52week": 27.260000000000001563194018672220408916473388671875, "day_transaction.low52week": 5.07000000000000028421709430404007434844970703125, "day_transaction.volume": "5.50万", "day_transaction.amplitude": "5.63%", "day_transaction.turnover_rate": "0.66%", "day_transaction.market_capital": "2.13亿", "day_transaction.eps": 0.9499999999999999555910790149937383830547332763671875, "day_transaction.pe_lyr": "-", "day_transaction.moving_avg_50_day": 11.9399999999999995026200849679298698902130126953125, "day_transaction.moving_avg_200_day": 8.4199999999999999289457264239899814128875732421875, "day_transaction.total_shares": "839.10万", "day_transaction.inst_own": 43.72999999999999687361196265555918216705322265625, "day_transaction.net_assets": 3.20999999999999996447286321199499070644378662109375, "day_transaction.bonus_stock": "-/-", "day_transaction.mrq": 3.890000000000000124344978758017532527446746826171875, "day_transaction.number_of_empty_heads": 8.32000000000000028421709430404007434844970703125 } }, "stock.board_id": {} }, "100": { "stock.id": 100, "stock.ts": "2018-05-01 05:12:44", "stock.stock_number": "LXU", "stock.stock": "LSB工业", "stock.description": "", "stock.description_1": "", "stock.company_websit_1": "", "stock.company_websit": "", "stock.company_address": "", "stock.business": "", "stock.category_x_stock_id": { "100": { "category_x_stock.id": 100, "category.id": 4, "category.ts": "2018-04-26 23:54:32", "category.title": "工业" } }, "stock.day_transaction_id": { "100": { "day_transaction.id": 100, "day_transaction.ts": "2018-05-01 05:12:44", "day_transaction.today_open": 5.769999999999999573674358543939888477325439453125, "day_transaction.last_close": 5.7599999999999997868371792719699442386627197265625, "day_transaction.high": 5.79999999999999982236431605997495353221893310546875, "day_transaction.low": 5.519999999999999573674358543939888477325439453125, "day_transaction.high52week": 11.71000000000000085265128291212022304534912109375, "day_transaction.low52week": 5.36000000000000031974423109204508364200592041015625, "day_transaction.volume": "19.40万", "day_transaction.amplitude": "4.51%", "day_transaction.turnover_rate": "0.68%", "day_transaction.market_capital": "1.65亿", "day_transaction.eps": -2.229999999999999982236431605997495353221893310546875, "day_transaction.pe_lyr": "-", "day_transaction.moving_avg_50_day": 7.54000000000000003552713678800500929355621337890625, "day_transaction.moving_avg_200_day": 8.3599999999999994315658113919198513031005859375, "day_transaction.total_shares": "2861.40万", "day_transaction.inst_own": 77.8299999999999982946974341757595539093017578125, "day_transaction.net_assets": 16.39999999999999857891452847979962825775146484375, "day_transaction.bonus_stock": "-/-", "day_transaction.mrq": 0.460000000000000019984014443252817727625370025634765625, "day_transaction.number_of_empty_heads": 21.489999999999998436805981327779591083526611328125 } }, "stock.board_id": { "1331": { "board.id": 1331, "board.ts": "2018-05-02 03:58:56", "board.name": "Mr. Daniel D. Greenwell", "board.position": "President, Chief Executive Officer & Director", "board.resume": "" }, "1332": { "board.id": 1332, "board.ts": "2018-05-02 03:58:56", "board.name": "Mr. Mark T. Behrman", "board.position": "Chief Financial Officer & Executive Vice President", "board.resume": "" }, "1333": { "board.id": 1333, "board.ts": "2018-05-02 03:58:56", "board.name": "Mr. Michael Sullivan", "board.position": "Chief Information Officer & Vice President", "board.resume": "" }, "1334": { "board.id": 1334, "board.ts": "2018-05-02 03:58:56", "board.name": "Mr. John Howard Diesch", "board.position": "Executive Vice President-Chemical Manufacturing", "board.resume": "" }, "1335": { "board.id": 1335, "board.ts": "2018-05-02 03:58:56", "board.name": "Mr. Paul Rydlund", "board.position": "Senior Vice President-Business Development", "board.resume": "" }, "1336": { "board.id": 1336, "board.ts": "2018-05-02 03:58:56", "board.name": "Mr. John M. Carver", "board.position": "Vice President-Environmental & Safety Compliance", "board.resume": "" }, "1337": { "board.id": 1337, "board.ts": "2018-05-02 03:58:56", "board.name": "Mr. Jack E. Golsen", "board.position": "Chairman-Emeritus", "board.resume": "" }, "1338": { "board.id": 1338, "board.ts": "2018-05-02 03:58:56", "board.name": "Mr. Jonathan S. Bobb", "board.position": "Director", "board.resume": "" }, "1339": { "board.id": 1339, "board.ts": "2018-05-02 03:58:56", "board.name": "Mr. Barry H. Golsen", "board.position": "Director", "board.resume": "" }, "1340": { "board.id": 1340, "board.ts": "2018-05-02 03:58:56", "board.name": "Ms. Kristy Carver", "board.position": "Treasurer & Vice President", "board.resume": "" }, "1341": { "board.id": 1341, "board.ts": "2018-05-02 03:58:56", "board.name": "Mr. Cheryl Maguire", "board.position": "Vice President-Financial Planning & Accounting", "board.resume": "" }, "1342": { "board.id": 1342, "board.ts": "2018-05-02 03:58:56", "board.name": "Mr. Harold L. Rieker", "board.position": "Vice President & Controller", "board.resume": "" }, "1343": { "board.id": 1343, "board.ts": "2018-05-02 03:58:56", "board.name": "Mr. Robert Porter", "board.position": "Vice President-Internal Audit", "board.resume": "" }, "1344": { "board.id": 1344, "board.ts": "2018-05-02 03:58:56", "board.name": "Ms. Crystal Schroeder", "board.position": "Vice President-Human Resources", "board.resume": "" }, "1345": { "board.id": 1345, "board.ts": "2018-05-02 03:58:56", "board.name": "Mr. Michael J. Foster", "board.position": "Secretary, Senior VP & General Counsel", "board.resume": "" }, "1346": { "board.id": 1346, "board.ts": "2018-05-02 03:58:56", "board.name": "Mr. Richard S. Sanders", "board.position": "Independent Director", "board.resume": "" }, "1347": { "board.id": 1347, "board.ts": "2018-05-02 03:58:56", "board.name": "Mr. Richard W. Roedel", "board.position": "Independent Director", "board.resume": "" }, "1348": { "board.id": 1348, "board.ts": "2018-05-02 03:58:56", "board.name": "Mr. Lynn F. White", "board.position": "Independent Director", "board.resume": "" }, "1349": { "board.id": 1349, "board.ts": "2018-05-02 03:58:56", "board.name": "Mr. Mark R. Genender", "board.position": "Independent Director", "board.resume": "" } } } } } }