{"id":240,"date":"2021-09-03T11:22:51","date_gmt":"2021-09-03T03:22:51","guid":{"rendered":"http:\/\/blog.ofuyuan.com\/?p=240"},"modified":"2021-09-09T21:54:17","modified_gmt":"2021-09-09T13:54:17","slug":"%e8%b3%87%e6%96%99%e5%ba%ab%e8%a8%ad%e8%a8%88","status":"publish","type":"post","link":"https:\/\/blog.ofuyuan.com\/?p=240","title":{"rendered":"\u500b\u80a1\u7684\u8cc7\u6599\u5eab\u8a2d\u8a08"},"content":{"rendered":"\n<p>\u958b\u767c\u74b0\u5883\u67b6\u69cb\u5e95\u5b9a\u5f8c\uff0c\u63a5\u4e0b\u4f86\u7684\u8a2d\u8a08\u6216\u898f\u756b\u4e5f\u6bd4\u8f03\u80fd\u5920\u56fa\u5b9a\u4e0b\u4f86\uff0c\u7576\u7136\u6700\u597d\u662f\u80fd\u628a\u958b\u767c\u74b0\u5883\u76f4\u63a5\u67b6\u8d77\u4f86\uff0c\u9019\u6a23\u5728\u601d\u8003\u8a2d\u8a08\u7684\u904e\u7a0b\u4e5f\u80fd\u5920\u76f4\u63a5\u7c21\u55ae\u7684\u9a57\u8b49\u601d\u8003\u7684\u65b9\u5411\u662f\u5426\u6b63\u78ba\uff0c\u4e26\u4e14\u53ef\u4ee5\u96a8\u6642\u8abf\u6574\u958b\u767c\u74b0\u5883\u3002\u63a5\u4e0b\u4f86\u5c31\u7531\u8cc7\u6599\u5eab\u7684\u898f\u756b\u958b\u59cb\u3002<\/p>\n\n\n\n<p>\u8003\u91cf\u5230\u5c0f\u767d\u672a\u4f86\u5728\u641c\u5c0b\u53ca\u61c9\u7528\u4e0a\u53ef\u4ee5\u5373\u6642\u7684\u53d6\u5f97\u5206\u6790\u7d50\u679c\uff0c\u4ee5\u53ca\u5927\u91cf\u8cc7\u6599\u7684\u641c\u5c0b\u554f\u984c\u7b49\uff0c\u90a3\u8cc7\u6599\u5eab\u7684\u8a2d\u8a08\u76e1\u91cf\u9054\u5230\u4ee5\u4e0b\u5e7e\u500b\u9ede\uff0c<\/p>\n\n\n\n<ol class=\"wp-block-list\"><li>\u4e0d\u8981\u592a\u8907\u96dc\u53ca\u95dc\u806f\u592a\u591a\u8cc7\u6599\u8868(Table)\uff0c\u9019\u6a23\u53ef\u4ee5\u63d0\u9ad8\u672a\u4f86\u67e5\u8a62\u6548\u80fd\u3002<\/li><li>\u8cc7\u6599\u5206\u6d41\uff0c\u76ee\u524d\u500b\u80a1\u3001ETF\u96c6\u6b0a\u8a3c\u7b49\uff0c\u5927\u7d04\u670910000\u96bb\uff0c\u5982\u679c\u5168\u90e8\u653e\u4e00\u500b\u6a94\u6848\u53ef\u80fd\u6703\u9020\u6210\u8cc7\u6599\u5eab\u67e5\u8a62\u6548\u80fd\u7de9\u6162\u554f\u984c\uff0c\u800c\u4e14\u8cc7\u6599\u5eab\u9084\u662f\u6709\u4e00\u4e9b\u5bb9\u91cf\u4e0a\u9650\u554f\u984c\uff0c\u4e00\u822c\u662f\u5e7eTB\uff0c\u4f46\u9084\u662f\u60f3\u8fa6\u6cd5\u5206\u6d41\uff0c\u662f\u6bd4\u8f03\u597d\uff0c\u5c0f\u767d\u7684\u5206\u6d41\u65b9\u5f0f\u662f\u4e00\u500b\u500b\u80a1\uff0c\u5c31\u81ea\u52d5\u5efa\u7acb\u4e00\u500b\u8cc7\u6599\u8868(table)\uff0c\u9019\u6a23\u61c9\u8a72\u53ef\u4ee5\u6709\u6548\u7684\u9054\u5230\u5206\u6d41\u53ca\u63d0\u9ad8\u6548\u80fd\u7684\u76ee\u6a19\u3002<\/li><li>\u8cc7\u6599\u6b04\u4f4d(Field)\uff0c\u898f\u5283\u4e0a\u662f\u5e0c\u671b\u5728\u67e5\u8a62\u500b\u80a1\u8cc7\u6599\u6642\uff0c\u5c31\u53ef\u4ee5\u628a\u6bcf\u5929\u5206\u6790\u7684\u7d50\u679c\u4e00\u4f75\u627e\u51fa\u4f86\uff0c\u56e0\u6b64\u5728\u6bcf\u65e5\u7684\u8cc7\u6599\u8868\u4e0a\uff0c\u5c31\u4fdd\u7559\u5206\u6790\u7d50\u679c\u53ca\u5176\u4ed6\u5e38\u898f\u8a08\u7b97\u7684\u6b04\u4f4d\uff0c\u8b93\u6bcf\u65e5\u5206\u6790\u5f8c\u7684\u7d50\u679c\u5b58\u653e\uff0c\u7f3a\u9ede\u5c31\u662f\u6bcf\u4e00\u7b46\u8cc7\u6599\u7684\u6b04\u4f4d\u6578\u6703\u8b8a\u5f97\u8a31\u591a\uff0c\u6c92\u7d50\u69cb\u5316\uff0c\u4f46\u9019\u554f\u984c\u5012\u4e0d\u7528\u5728\u610f\uff0c\u8a2d\u8a08\u7684\u76ee\u7684\u5728\u65bc\u5e73\u8861\uff0c\u800c\u4e0d\u5728\u70ab\u6280\u3002<\/li><\/ol>\n\n\n\n<p>\u6709\u4e86\u90193\u500b\u6982\u5ff5\u60f3\u6cd5\u5f8c\uff0c\u5927\u90e8\u5206\u8cc7\u6599\u5beb\u5165\u8cc7\u6599\u5eab\u524d\u6216\u5f8c\uff0c\u6703\u5373\u6642\u6216\u76f4\u63a5\u9032\u884c\u5206\u6790\u8ddf\u8907\u96dc\u7684\u8a08\u7b97\uff0c\u66f4\u65b0\u8cc7\u6599\u5eab\u88e1\u7684\u5206\u6790\u3001\u5747\u91cf\u50f9\u7b49\u6b04\u4f4d\uff0c\u4ee5\u4e0b\u5c31\u662f\u8a2d\u8a08\u7684\u8cc7\u6599\u683c\u5f0f(Table Schema)\u3002<\/p>\n\n\n\n<div class=\"wp-block-image\"><figure class=\"aligncenter size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"490\" height=\"378\" src=\"http:\/\/blog.ofuyuan.com\/wp-content\/uploads\/2021\/09\/image-5.png\" alt=\"\" class=\"wp-image-243\" srcset=\"https:\/\/blog.ofuyuan.com\/wp-content\/uploads\/2021\/09\/image-5.png 490w, https:\/\/blog.ofuyuan.com\/wp-content\/uploads\/2021\/09\/image-5-300x231.png 300w\" sizes=\"auto, (max-width: 490px) 100vw, 490px\" \/><figcaption>\u5c0f\u767d\u8cc7\u6599\u8868\u7d50\u69cb<\/figcaption><\/figure><\/div>\n\n\n\n<p>\u6211\u5011\u5b9a\u7fa9\u4e86\u4e09\u500b\u8cc7\u6599\u8868(Table)\uff0c\u95dc\u806f\u6027\u4e26\u4e0d\u8907\u96dc\uff0c\u4f46\u5be6\u969b\u4e0a\u6bd4\u8f03\u8907\u96dc\u6703\u843d\u5728\u7b2c\u4e09\u500b\u8cc7\u6599\u8868-StockDaliy\uff0c\u56e0\u70ba\u4ed6\u8981\u8ca0\u8cac\u505a\u5206\u6d41\u7684\u5de5\u4f5c\uff0c\u6211\u7684\u505a\u6cd5\u662f\u9019\u500b\u8cc7\u6599\u8868\u7531\u7a0b\u5f0f\u81ea\u52d5\u7522\u751f\uff0c\u53ea\u8981\u6709\u65b0\u7684\u500b\u80a1\u5728\u8490\u96c6\u8cc7\u6599\u6642\u767c\u73fe\uff0c\u5c31\u7522\u751f\u4e00\u500bStockDaliy\uff0c\u8cc7\u6599\u8868\u7684\u683c\u5f0f\u5c31\u6703\u8b8a\u6210&#8221;StockDaliy_&#8221; + {Stock id}\uff0c\u57fa\u672c\u4e0a\u662f\u5c0d\u61c9Stock\u9019\u500b\u8cc7\u6599\u8868\u7684\uff0c\u7576\u7136\u4e4b\u5f8c\u5982\u679cStockDaliy\u8981\u589e\u6e1b\u6b04\u4f4d(Field)\uff0c\u90a3\u5c31\u5fc5\u9808\u8981\u5beb\u4e00\u96bb\u7a0b\u5f0f\u505a\u6279\u6b21\u4fee\u6539\uff0c\u4f46\u9019\u61c9\u8a72\u662f\u53ef\u4ee5\u63a5\u53d7\u7684\u7bc4\u570d\u3002<\/p>\n\n\n\n<div class=\"wp-block-image\"><figure class=\"aligncenter size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"535\" height=\"344\" src=\"http:\/\/blog.ofuyuan.com\/wp-content\/uploads\/2021\/09\/image-7.png\" alt=\"\" class=\"wp-image-256\" srcset=\"https:\/\/blog.ofuyuan.com\/wp-content\/uploads\/2021\/09\/image-7.png 535w, https:\/\/blog.ofuyuan.com\/wp-content\/uploads\/2021\/09\/image-7-300x193.png 300w\" sizes=\"auto, (max-width: 535px) 100vw, 535px\" \/><figcaption>Daliy Stock\u95dc\u806f<\/figcaption><\/figure><\/div>\n\n\n\n<p>\u56e0\u6b64\u672a\u4f86\u6bcf\u65e5\u8490\u96c6\u5b8c\u8cc7\u6599\u6599\u5c31\u8981\u540c\u6642\u66f4\u65b0Stock\u53caStockDaliy\uff0c\u4e00\u500b\u662f\u8a18\u9304\u6700\u8fd1\u7684\u8a18\u9304\uff0c\u53e6\u4e00\u500b\u5247\u662f\u8a18\u9304\u6bcf\u5929\u7684\u8cc7\u8a0a\uff0c\u7576\u5206\u6790\u5b8c\u8cc7\u6599\u5f8c\uff0c\u4e5f\u662f\u7528\u540c\u4e00\u500b\u908f\u8f2f\u4f86\u8a18\u9304\u3002<\/p>\n\n\n\n<p>\u5728StockDaliy\u4e0a\u6709\u4e00\u500btype\u7684\u6b04\u4f4d\uff0c\u9019\u500b\u6b04\u4f4d\u7528\u4f86\u8a18\u9304\u8a72\u7b46\u8a18\u9304\u662f\u6bcf\u65e5\u3001\u6bcf\u5468\u3001\u6bcf\u6708\u3001\u6bcf\u5b63\u7b49\u7e3d\u5408\u8a18\u9304\uff0c\u56e0\u6b64\u5728\u8490\u96c6\u8cc7\u6599\u7684\u540c\u6642\uff0c\u4e5f\u6703\u9806\u4fbf\u7b97\u51fa\u5468\u3001\u6708\u3001\u5b63\u7b49\u7d71\u8a08\u578b\u7684\u8cc7\u6599\u4e26\u653e\u5165StockDaliy\uff0c\u672a\u4f86\u60f3\u8981\u67e5\u8a62\u5468\u3001\u6708\u3001\u5b63\uff0c\u5c31\u4f9dtype\u67e5\u8a62\u5373\u53ef\u3002<\/p>\n\n\n\n<div class=\"wp-block-image\"><figure class=\"aligncenter size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"309\" height=\"418\" src=\"http:\/\/blog.ofuyuan.com\/wp-content\/uploads\/2021\/09\/image-8.png\" alt=\"\" class=\"wp-image-263\" srcset=\"https:\/\/blog.ofuyuan.com\/wp-content\/uploads\/2021\/09\/image-8.png 309w, https:\/\/blog.ofuyuan.com\/wp-content\/uploads\/2021\/09\/image-8-222x300.png 222w\" sizes=\"auto, (max-width: 309px) 100vw, 309px\" \/><figcaption>StockDaliy\u7684\u8cc7\u6599\u5167\u5bb9<\/figcaption><\/figure><\/div>\n\n\n\n<p>\u672a\u4f86\u5982\u679c\u8981\u7e7c\u7e8c\u589e\u52a0\u500b\u80a1\u8cc7\u6599\u6642\uff0c\u53ef\u4ee5\u4ee5Stock\u9019\u500b\u8cc7\u6599\u8868\u70ba\u4e3b\u95dc\u806f\uff0c\u4e26\u5f80\u5916\u5ef6\u4f38\uff0c\u5982\u9664\u6b0a\u606f\u3001EPS\u3001\u71df\u5229\u7b49\u8cc7\u8a0a\uff0c\u53e6\u5916\u5927\u76e4\u6307\u6578\u3001\u985e\u80a1\u6307\u6578\u76ee\u524d\u4e5f\u662f\u5b9a\u7fa9\u5728Stock \u8cc7\u6599\u8868 \u88e1\u9762\uff0c\u900f\u904eCategory\u9019\u500b\u8cc7\u6599\u8868\u4f86\u505a\u5206\u8fa8\uff0c\u597d\u8655\u662f\u4ee5\u5f8c\u9664\u4e86\u5206\u6790\u500b\u80a1\u5916\uff0c\u4e5f\u53ef\u4ee5\u4e00\u4f75\u5206\u6790\u5927\u76e4\u6307\u6578\u8ddf\u985e\u80a1\u6307\u6578\uff0c\u90a3\u7a0b\u5f0f\u8a2d\u8a08\u8d77\u4f86\u4e5f\u76f8\u5c0d\u55ae\u7d14\uff0c\u4e26\u4e14\u53ef\u91cd\u8907\u5229\u7528\uff0c\u4e5f\u8a31\u53ea\u8981\u8abf\u6574\u4e00\u4e0b\u53c3\u6578\u5c31\u53ef\u4ee5\u641e\u5b9a\u3002<\/p>\n\n\n\n<p><\/p>\n\n\n\n<p><\/p>\n\n\n\n<script async src=\"https:\/\/pagead2.googlesyndication.com\/pagead\/js\/adsbygoogle.js?client=ca-pub-4684515702886614\"\n     crossorigin=\"anonymous\"><\/script>\n<ins class=\"adsbygoogle\"\n     style=\"display:block; text-align:center;\"\n     data-ad-layout=\"in-article\"\n     data-ad-format=\"fluid\"\n     data-ad-client=\"ca-pub-4684515702886614\"\n     data-ad-slot=\"1573644073\"><\/ins>\n<script>\n     (adsbygoogle = window.adsbygoogle || []).push({});\n<\/script>\n\n\n","protected":false},"excerpt":{"rendered":"<p>\u958b\u767c\u74b0\u5883\u67b6\u69cb\u5e95\u5b9a\u5f8c\uff0c\u63a5\u4e0b\u4f86\u7684\u8a2d\u8a08\u6216\u898f\u756b\u4e5f\u6bd4\u8f03\u80fd\u5920\u56fa\u5b9a\u4e0b\u4f86\uff0c\u7576\u7136\u6700\u597d\u662f\u80fd\u628a\u958b\u767c\u74b0\u5883 &hellip; <a href=\"https:\/\/blog.ofuyuan.com\/?p=240\">\u95b1\u8b80\u5168\u6587 <span class=\"meta-nav\">&rarr;<\/span><\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_bbp_topic_count":0,"_bbp_reply_count":0,"_bbp_total_topic_count":0,"_bbp_total_reply_count":0,"_bbp_voice_count":0,"_bbp_anonymous_reply_count":0,"_bbp_topic_count_hidden":0,"_bbp_reply_count_hidden":0,"_bbp_forum_subforum_count":0,"footnotes":""},"categories":[5,3,11],"tags":[7,19,30,20,8,18,28,17,16,29],"class_list":["post-240","post","type-post","status-publish","format-standard","hentry","category-white","category-design","category-designdoit","tag-stock","tag-19","tag-30","tag-20","tag-8","tag-18","tag-28","tag-17","tag-16","tag-29"],"_links":{"self":[{"href":"https:\/\/blog.ofuyuan.com\/index.php?rest_route=\/wp\/v2\/posts\/240","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/blog.ofuyuan.com\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/blog.ofuyuan.com\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/blog.ofuyuan.com\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/blog.ofuyuan.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=240"}],"version-history":[{"count":8,"href":"https:\/\/blog.ofuyuan.com\/index.php?rest_route=\/wp\/v2\/posts\/240\/revisions"}],"predecessor-version":[{"id":322,"href":"https:\/\/blog.ofuyuan.com\/index.php?rest_route=\/wp\/v2\/posts\/240\/revisions\/322"}],"wp:attachment":[{"href":"https:\/\/blog.ofuyuan.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=240"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.ofuyuan.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=240"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.ofuyuan.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=240"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}