{"id":29037,"date":"2023-09-24T15:14:41","date_gmt":"2024-01-12T09:59:47","guid":{"rendered":"https:\/\/www.silicloud.com\/zh\/blog\/%e4%bd%bf%e7%94%a8%e6%a0%91%e8%8e%93%e6%b4%be%e8%8e%b7%e5%8f%96%e6%af%94%e7%89%b9%e5%b8%81%e7%9a%84%e6%9c%80%e6%96%b0%e4%ba%a4%e6%98%93%e4%bb%b7%e6%a0%bc%e4%bf%a1%e6%81%af%e3%80%82\/"},"modified":"2025-08-12T11:28:10","modified_gmt":"2025-08-12T03:28:10","slug":"%e4%bd%bf%e7%94%a8%e6%a0%91%e8%8e%93%e6%b4%be%e8%8e%b7%e5%8f%96%e6%af%94%e7%89%b9%e5%b8%81%e7%9a%84%e6%9c%80%e6%96%b0%e4%ba%a4%e6%98%93%e4%bb%b7%e6%a0%bc%e4%bf%a1%e6%81%af%e3%80%82","status":"publish","type":"post","link":"https:\/\/www.silicloud.com\/zh\/blog\/%e4%bd%bf%e7%94%a8%e6%a0%91%e8%8e%93%e6%b4%be%e8%8e%b7%e5%8f%96%e6%af%94%e7%89%b9%e5%b8%81%e7%9a%84%e6%9c%80%e6%96%b0%e4%ba%a4%e6%98%93%e4%bb%b7%e6%a0%bc%e4%bf%a1%e6%81%af%e3%80%82\/","title":{"rendered":"\u4f7f\u7528\u6811\u8393\u6d3e\u83b7\u53d6\u6bd4\u7279\u5e01\u7684\u6700\u65b0\u4ea4\u6613\u4ef7\u683c\u4fe1\u606f"},"content":{"rendered":"

\u603b\u7ed3\u7531\u4e8e\u6bd4\u7279\u5e01\u7684\u4ea4\u6613\u4ef7\u683c\u6700\u8fd1\u4e0a\u6da8\uff0c\u6211\u51b3\u5b9a\u901a\u8fc7Bitflyer\u7684API\u6765\u6536\u96c6\u6bd4\u7279\u5e01\u7684\u4ea4\u6613\u4fe1\u606f\uff0c\u5e76\u5c06\u5176\u8f6c\u5316\u4e3a\u6570\u636e\u3002\u4e3a\u6b64\uff0c\u6211\u521b\u5efa\u4e86\u4ee5\u4e0b\u8fd9\u6bb5\u4ee3\u7801\u3002<\/p>\n

\u9884\u5148\u8bbe\u7f6e\u73af\u5883- Python
\n– MySql
\n\u203b\u6211\u8ba4\u4e3a\u7248\u672c\u4e0d\u4f1a\u6709\u592a\u5927\u5f71\u54cd\u3002
\n\u6211\u662f\u7528\u4ee5\u4e0b\u547d\u4ee4\u8fdb\u884c\u5b89\u88c5\u7684\u3002<\/p>\n
\u25a0\u57fa\u672c\u8a2d\u5b9a\r\nsudo <\/span>apt-get install <\/span>python2.7-dev python3-dev\r\nsudo <\/span>apt-get install <\/span>mariadb-server-10.0\r\nsudo <\/span>apt-get install <\/span>python-mysqldb\r\n\u25a0\u305d\u306e\u4ed6\u8a2d\u5b9a\r\nsudo <\/span>apt-get install <\/span>python-pandas\r\nsudo <\/span>apt-get install <\/span>jq\r\n\u203b\u30cd\u30c3\u30c8\u306e\u30b5\u30f3\u30d7\u30eb\u3092\u8a66\u3059\u305f\u3081\u3001\u30a4\u30f3\u30b9\u30c8\u30fc\u30eb\u3057\u3066\u3044\u305f\u30d1\u30c3\u30b1\u30fc\u30b8\u3067\u3059\u3002\r\n<\/code><\/pre>\n
\u521b\u5efa\u8868\u8bf7\u6839\u636e\u4ee5\u4e0b\u8bbe\u5b9a\u7684\u4e34\u65f6\u6570\u636e\u7c7b\u578b\uff0c\u5404\u4f4d\u53ef\u4ee5\u81ea\u884c\u8fdb\u884c\u4fee\u6539\u3002\u8fd9\u6837\u5c31\u53ef\u4ee5\u521b\u5efa\u8868\u683c\u4e86\u3002<\/p>\n
create table coindata(<\/span>\r\nproduct_code varchar(<\/span>50)<\/span>,\r\nstate varchar(<\/span>50)<\/span>,\r\ntimestamp varchar(<\/span>50)<\/span>,\r\ntick_id varchar(<\/span>50)<\/span>,\r\nbest_bid varchar(<\/span>50)<\/span>,\r\nbest_ask varchar(<\/span>50)<\/span>,\r\nbest_bid_size varchar(<\/span>50)<\/span>,\r\nbest_ask_size varchar(<\/span>50)<\/span>,\r\ntotal_bid_depth varchar(<\/span>50)<\/span>,\r\ntotal_ask_depth varchar(<\/span>50)<\/span>,\r\nmarket_bid_size varchar(<\/span>50)<\/span>,\r\nmarket_ask_size varchar(<\/span>50)<\/span>,\r\nltp varchar(<\/span>50)<\/span>,\r\nvolume varchar(<\/span>50)<\/span>,\r\nvolume_by_product varchar(<\/span>50)<\/span>\r\n)<\/span>;<\/span>\r\n<\/code><\/pre>\n
\u8868\u7684\u5efa\u7acb\u7ed3\u679c\u6309\u7167\u4ee5\u4e0b\u6b65\u9aa4\u6b63\u786e\u521b\u5efa\u8868\u683c\u3002<\/p>\n
pi@RPI4-DEV:~\/work\/python $ <\/span>sudo <\/span>mysql -uroot<\/span> -A<\/span>\r\nWelcome to the MariaDB monitor.  Commands end with ;<\/span> or \\g<\/span>.<\/span>\r\nYour MariaDB connection id <\/span>is 58\r\nServer version: 10.0.28-MariaDB-2+b1 Raspbian testing-staging\r\n\r\nCopyright (<\/span>c)<\/span> 2000, 2016, Oracle, MariaDB Corporation Ab and others.\r\n\r\nType 'help;'<\/span> or '\\h'<\/span> for <\/span>help. Type '\\c'<\/span> to clear the current input statement.\r\n\r\nMariaDB [(<\/span>none)]><\/span> create database bitcoin;<\/span>\r\nQuery OK, 1 row affected (<\/span>0.00 sec)<\/span>\r\n\r\nMariaDB [<\/span>bitcoin]> use bitcoin;<\/span>\r\nDatabase changed\r\nMariaDB [<\/span>bitcoin]> create table coindata(<\/span>\r\n    -> product_code varchar(<\/span>50)<\/span>,\r\n    -> state varchar(<\/span>50)<\/span>,\r\n    -> timestamp varchar(<\/span>50)<\/span>,\r\n    -> tick_id varchar(<\/span>50)<\/span>,\r\n    -> best_bid varchar(<\/span>50)<\/span>,\r\n    -> best_ask varchar(<\/span>50)<\/span>,\r\n    -> best_bid_size varchar(<\/span>50)<\/span>,\r\n    -> best_ask_size varchar(<\/span>50)<\/span>,\r\n    -> total_bid_depth varchar(<\/span>50)<\/span>,\r\n    -> total_ask_depth varchar(<\/span>50)<\/span>,\r\n    -> market_bid_size varchar(<\/span>50)<\/span>,\r\n    -> market_ask_size varchar(<\/span>50)<\/span>,\r\n    -> ltp varchar(<\/span>50)<\/span>,\r\n    -> volume varchar(<\/span>50)<\/span>,\r\n    -> volume_by_product varchar(<\/span>50)<\/span>\r\n    -> )<\/span>;<\/span>\r\nQuery OK, 0 rows affected (<\/span>0.06 sec)<\/span>\r\n\r\nMariaDB [<\/span>bitcoin]>\r\n<\/code><\/pre>\n
\u6e90\u4ee3\u7801
\n\u8bf7\u590d\u5236\u4ee5\u4e0b\u4ee3\u7801\uff0c\u521b\u5efa\u4e00\u4e2a\u6587\u4ef6\u3002<\/p>\n
#!\/usr\/bin\/python<\/span>\r\n# -*- coding: utf-8 -*-<\/span>\r\nimport requests\r\nimport sys\r\nimport MySQLdb\r\n\r\n###############<\/span>\r\n#### const ####<\/span>\r\n###############<\/span>\r\nhost<\/span>=<\/span>\"localhost\"<\/span>\r\nuser<\/span>=<\/span>\"bitcoin\"<\/span>\r\npasswd<\/span>=<\/span>\"bitcoin\"<\/span>\r\ndb<\/span>=<\/span>\"bitcoin\"<\/span>\r\n###############<\/span>\r\n\r\ndef insertDB(<\/span>data)<\/span>:\r\n    try:\r\n        database =<\/span> MySQLdb.connect (<\/span>host<\/span>=<\/span>host, user<\/span>=<\/span>user, passwd<\/span>=<\/span>passwd, db<\/span>=<\/span>db, charset<\/span>=<\/span>\"utf8\"<\/span>)<\/span>\r\n        cursor =<\/span> database.cursor()<\/span>\r\n        query =<\/span> \"\"\"INSERT INTO coindata (product_code, state, timestamp, tick_id, best_bid, best_ask, best_bid_size, best_ask_size, total_bid_depth, total_ask_depth, market_bid_size, market_ask_size, ltp, volume,volume_by_product) VALUES (%s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s)\"\"\"<\/span>\r\n        values =<\/span> (<\/span>str(<\/span>data['product_code'<\/span>])<\/span>,str(<\/span>data['state'<\/span>])<\/span>,str(<\/span>data['timestamp'<\/span>])<\/span>,str(<\/span>data['tick_id'<\/span>])<\/span>,str(<\/span>data['best_bid'<\/span>])<\/span>,str(<\/span>data['best_ask'<\/span>])<\/span>,str(<\/span>data['best_bid_size'<\/span>])<\/span>,str(<\/span>data['best_ask_size'<\/span>])<\/span>,str(<\/span>data['total_bid_depth'<\/span>])<\/span>,str(<\/span>data['total_ask_depth'<\/span>])<\/span>,str(<\/span>data['market_bid_size'<\/span>])<\/span>,str(<\/span>data['market_ask_size'<\/span>])<\/span>,str(<\/span>data['ltp'<\/span>])<\/span>,str(<\/span>data['volume'<\/span>])<\/span>,str(<\/span>data['volume_by_product'<\/span>]))<\/span>\r\n        cursor.execute(<\/span>query, values)<\/span>\r\n        cursor.close()<\/span>\r\n        database.commit()<\/span>\r\n        database.close()<\/span>\r\n    except Exception as e:\r\n        print(<\/span>\"#######################\"<\/span>)<\/span>\r\n        print(<\/span>\"# data process error. #\"<\/span>)<\/span>\r\n        print(<\/span>\"#######################\"<\/span>)<\/span>\r\n        print(<\/span>\"# Error >>>>>>>>>>>>>>>\"<\/span>)<\/span>\r\n        print(<\/span>e)<\/span>\r\n        print(<\/span>\"#######################\"<\/span>)<\/span>\r\n        sys.exit(<\/span>1)<\/span>\r\n\r\n\r\ndef main()<\/span>:\r\n    headers =<\/span> {<\/span>\r\n        'Accept'<\/span>: 'application\/json'<\/span>,\r\n    }<\/span>\r\n    response =<\/span> requests.get(<\/span>'https:\/\/api.bitflyer.com\/v1\/ticker?product_code=BTC_JPY'<\/span>, headers<\/span>=<\/span>headers, data<\/span>={})<\/span>\r\n    #print(response.text)<\/span>\r\n    data =<\/span> response.json()<\/span>\r\n\r\n    if <\/span>response is not None:\r\n        print(<\/span>\"#######################\"<\/span>)<\/span>\r\n        print(<\/span>\"# Api response data.  #\"<\/span>)<\/span>\r\n        print(<\/span>\"#######################\"<\/span>)<\/span>\r\n        print(<\/span>'product_code='<\/span>+ str(<\/span>data['product_code'<\/span>]))<\/span>\r\n        print(<\/span>'state='<\/span>+ str(<\/span>data['state'<\/span>]))<\/span>\r\n        print(<\/span>'timestamp='<\/span>+ str(<\/span>data['timestamp'<\/span>]))<\/span>\r\n        print(<\/span>'tick_id='<\/span>+ str(<\/span>data['tick_id'<\/span>]))<\/span>\r\n        print(<\/span>'best_bid='<\/span>+ str(<\/span>data['best_bid'<\/span>]))<\/span>\r\n        print(<\/span>'best_ask='<\/span>+ str(<\/span>data['best_ask'<\/span>]))<\/span>\r\n        print(<\/span>'best_bid_size='<\/span>+ str(<\/span>data['best_bid_size'<\/span>]))<\/span>\r\n        print(<\/span>'best_ask_size='<\/span>+ str(<\/span>data['best_ask_size'<\/span>]))<\/span>\r\n        print(<\/span>'total_bid_depth='<\/span>+ str(<\/span>data['total_bid_depth'<\/span>]))<\/span>\r\n        print(<\/span>'total_ask_depth='<\/span>+ str(<\/span>data['total_ask_depth'<\/span>]))<\/span>\r\n        print(<\/span>'market_bid_size='<\/span>+ str(<\/span>data['market_bid_size'<\/span>]))<\/span>\r\n        print(<\/span>'market_ask_size='<\/span>+ str(<\/span>data['market_ask_size'<\/span>]))<\/span>\r\n        print(<\/span>'ltp='<\/span>+ str(<\/span>data['ltp'<\/span>]))<\/span>\r\n        print(<\/span>'volume='<\/span>+ str(<\/span>data['volume'<\/span>]))<\/span>\r\n        print(<\/span>'volume_by_product='<\/span>+ str(<\/span>data['volume_by_product'<\/span>]))<\/span>\r\n        insertDB(<\/span>data)<\/span>;<\/span>\r\n    else<\/span>:\r\n        print(<\/span>\"reponse is null\"<\/span>)<\/span>\r\n\r\n\r\nif <\/span>__name__ ==<\/span> '__main__'<\/span>:\r\n    main()<\/span>\r\npi@RPI4-DEV:~\/work\/python $<\/span>\r\n<\/code><\/pre>\n
\u6267\u884c\u7ed3\u679c
\n\u6267\u884c\u547d\u4ee4\u540e\uff0c\u5c06\u663e\u793a\u5f53\u524d\u7684\u4e70\u5356\u4fe1\u606f\u5982\u4e0b\u3002
\n\u663e\u793a\u7684\u6bcf\u4e2a\u9879\u76ee\u5c06\u88ab\u6ce8\u518c\u5230\u6570\u636e\u5e93\u4e2d\u3002<\/p>\n
pi@RPI4-DEV:~\/work\/python $ <\/span>python pybitflyer1.py\r\n#######################<\/span>\r\n# Api response data.  #<\/span>\r\n#######################<\/span>\r\nproduct_code<\/span>=<\/span>BTC_JPY\r\nstate<\/span>=<\/span>RUNNING\r\ntimestamp<\/span>=<\/span>2021-01-09T01:36:12.597\r\ntick_id<\/span>=<\/span>7241936\r\nbest_bid<\/span>=<\/span>4154675.0\r\nbest_ask<\/span>=<\/span>4156000.0\r\nbest_bid_size<\/span>=<\/span>0.38445428\r\nbest_ask_size<\/span>=<\/span>0.03\r\ntotal_bid_depth<\/span>=<\/span>1206.39330272\r\ntotal_ask_depth<\/span>=<\/span>603.2624046\r\nmarket_bid_size<\/span>=<\/span>0.0\r\nmarket_ask_size<\/span>=<\/span>0.0\r\nltp<\/span>=<\/span>4154675.0\r\nvolume<\/span>=<\/span>190283.400721\r\nvolume_by_product<\/span>=<\/span>17158.1161835\r\npi@RPI4-DEV:~\/work\/python $<\/span>\r\n<\/code><\/pre>\n
\u5728\u6570\u636e\u5e93\u4e2d\u67e5\u770b\u8868\u683c\u7684\u4fe1\u606f\u3002de \u3002)<\/p>\n
\u60a8\u53ef\u4ee5\u4f7f\u7528\u4ee5\u4e0b\u547d\u4ee4\u64cd\u4f5c\u6765\u786e\u8ba4\u5df2\u6ce8\u518c\u7684\u4fe1\u606f\u3002<\/p>\n
pi@RPI4-DEV:~\/work\/python $ <\/span>sudo <\/span>mysql -uroot<\/span> -A<\/span>\r\nWelcome to the MariaDB monitor.  Commands end with ;<\/span> or \\g<\/span>.<\/span>\r\nYour MariaDB connection id <\/span>is 62\r\nServer version: 10.0.28-MariaDB-2+b1 Raspbian testing-staging\r\n\r\nCopyright (<\/span>c)<\/span> 2000, 2016, Oracle, MariaDB Corporation Ab and others.\r\n\r\nType 'help;'<\/span> or '\\h'<\/span> for <\/span>help. Type '\\c'<\/span> to clear the current input statement.\r\n\r\nMariaDB [(<\/span>none)]><\/span> use bitcoin\r\nDatabase changed\r\nMariaDB [<\/span>bitcoin]> select<\/span> *<\/span> from coindata;<\/span>\r\n+--------------+---------+-------------------------+---------+-----------+-----------+---------------+---------------+-----------------+-----------------+-----------------+-----------------+-----------+---------------+-------------------+\r\n| product_code | state   | timestamp               | tick_id | best_bid  | best_ask  | best_bid_size | best_ask_size | total_bid_depth | total_ask_depth | market_bid_size | market_ask_size | ltp       | volume        | volume_by_product |\r\n+--------------+---------+-------------------------+---------+-----------+-----------+---------------+---------------+-----------------+-----------------+-----------------+-----------------+-----------+---------------+-------------------+\r\n| BTC_JPY      | RUNNING | 2021-01-09T01:36:12.597 | 7241936 | 4154675.0 | 4156000.0 | 0.38445428    | 0.03          | 1206.39330272   | 603.2624046     | 0.0             | 0.0             | 4154675.0 | 190283.400721 | 17158.1161835     |\r\n+--------------+---------+-------------------------+---------+-----------+-----------+---------------+---------------+-----------------+-----------------+-----------------+-----------------+-----------+---------------+-------------------+\r\n1 rows in <\/span>set<\/span> (<\/span>0.00 sec)<\/span>\r\n\r\nMariaDB [<\/span>bitcoin]>\r\n<\/code><\/pre>\n
CRON\u8bbe\u7f6e\u5c06\u4e0a\u8ff0\u7684\u4ea4\u6613\u4fe1\u606f\u4ee5\u6bcf\u4e00\u5206\u949f\u7684\u95f4\u9694\u6267\u884c\uff0c\u5e76\u5c06\u5176\u6ce8\u518c\u5230\u6570\u636e\u5e93\u4e2d\uff0c\u8fd9\u662f\u901a\u8fc7CRON\u8fdb\u884c\u8bbe\u7f6e\u7684\u3002
\n\u8bbe\u7f6e\u7684\u547d\u4ee4\u5982\u4e0b\u6240\u793a\u3002<\/p>\n
crontab -e<\/span>\r\n<\/code><\/pre>\n
\u9996\u5148\uff0c\u6211\u4eec\u9700\u8981\u786e\u8ba4\u7a0b\u5e8f\u7684\u7edd\u5bf9\u8def\u5f84\u3002
\n\u203b\u5173\u4e8eCRON\u8bbe\u7f6e\u7684\u8be6\u7ec6\u4fe1\u606f\uff0c\u8bf7\u81ea\u884c\u641c\u7d22\u3002<\/p>\n
pi@RPI4-DEV:~\/work\/python $ <\/span>pwd<\/span>\r\n\/home\/pi\/work\/python\r\npi@RPI4-DEV:~\/work\/python $ <\/span>crontab -e<\/span>\r\npi@RPI4-DEV:~\/work\/python $ <\/span>crontab -e<\/span>\r\nno crontab for <\/span>pi - using an empty one\r\n\r\nSelect an editor.  To change later, run 'select-editor'<\/span>.<\/span>\r\n  1. \/bin\/nano        <----<\/span> easiest\r\n  2. \/usr\/bin\/vim.tiny\r\n  3. \/bin\/ed\r\n\r\nChoose 1-3 [<\/span>1]: 2\r\n\u203b\u521d\u3081\u3066\u5b9f\u884c\u3059\u308b\u5834\u5408\u306f\u3001\u3053\u306e\u753b\u9762\u304c\u8868\u793a\u3055\u308c\u307e\u3059\u3002\u597d\u304d\u306a\u30a8\u30c7\u30a3\u30bf\u3092\u9078\u3073\u307e\u3059\u3002\r\n\r\n\u203b\u30a8\u30c7\u30a3\u30bf\u753b\u9762\u304c\u8868\u793a\u3055\u308c\u305f\u3089\u4e00\u756a\u4e0b\u306b\u6b21\u306e\u884c\u3092\u8ffd\u52a0\u3057\u307e\u3059\u3002\r\n# m h  dom mon dow   command<\/span>\r\n*<\/span>\/1 *<\/span> *<\/span> *<\/span> *<\/span> \/usr\/bin\/python \/home\/pi\/work\/python\/pybitflyer.py\r\n<\/code><\/pre>\n
\u786e\u8ba4\u6ce8\u518c\u6570\u636e
\n\u60a8\u53ef\u4ee5\u4f7f\u7528\u4ee5\u4e0b\u547d\u4ee4\u6765\u786e\u8ba4\u6bcf\u4e00\u5206\u949f\u6ce8\u518c\u7684\u6570\u636e\u3002<\/p>\n
pi@RPI4-DEV:~\/work\/python $ <\/span>sudo <\/span>mysql -uroot<\/span> bitcoin -A<\/span>\r\nWelcome to the MariaDB monitor.  Commands end with ;<\/span> or \\g<\/span>.<\/span>\r\nYour MariaDB connection id <\/span>is 67\r\nServer version: 10.0.28-MariaDB-2+b1 Raspbian testing-staging\r\n\r\nCopyright (<\/span>c)<\/span> 2000, 2016, Oracle, MariaDB Corporation Ab and others.\r\n\r\nType 'help;'<\/span> or '\\h'<\/span> for <\/span>help. Type '\\c'<\/span> to clear the current input statement.\r\n\r\nMariaDB [<\/span>bitcoin]> select<\/span> *<\/span> from coindata;<\/span>\r\n+--------------+---------+-------------------------+---------+-----------+-----------+---------------+---------------+-----------------+-----------------+-----------------+-----------------+-----------+---------------+-------------------+\r\n| product_code | state   | timestamp               | tick_id | best_bid  | best_ask  | best_bid_size | best_ask_size | total_bid_depth | total_ask_depth | market_bid_size | market_ask_size | ltp       | volume        | volume_by_product |\r\n+--------------+---------+-------------------------+---------+-----------+-----------+---------------+---------------+-----------------+-----------------+-----------------+-----------------+-----------+---------------+-------------------+\r\n| BTC_JPY      | RUNNING | 2021-01-09T01:36:12.597 | 7241936 | 4154675.0 | 4156000.0 | 0.38445428    | 0.03          | 1206.39330272   | 603.2624046     | 0.0             | 0.0             | 4154675.0 | 190283.400721 | 17158.1161835     |\r\n| BTC_JPY      | RUNNING | 2021-01-09T02:00:01.737 | 7277223 | 4181830.0 | 4183521.0 | 0.1782        | 0.05          | 1209.05388127   | 607.47497788    | 0.0             | 0.0             | 4182870.0 | 188553.381385 | 16853.8598802     |\r\n| BTC_JPY      | RUNNING | 2021-01-09T02:01:01.477 | 7278952 | 4185354.0 | 4189102.0 | 0.204         | 0.05          | 1202.80743073   | 609.78078502    | 0.0             | 0.0             | 4186504.0 | 188608.251493 | 16866.3219666     |\r\n| BTC_JPY      | RUNNING | 2021-01-09T02:02:01.51  | 7280690 | 4184065.0 | 4186520.0 | 0.1           | 0.03          | 1201.72775047   | 610.64902502    | 0.0             | 0.0             | 4184065.0 | 188603.676283 | 16867.4278812     |\r\n| BTC_JPY      | RUNNING | 2021-01-09T02:03:00.583 | 7282149 | 4182182.0 | 4185000.0 | 0.05          | 0.2           | 1203.15019458   | 605.12780202    | 0.0             | 0.0             | 4183657.0 | 188626.810728 | 16863.1595472     |\r\n| BTC_JPY      | RUNNING | 2021-01-09T02:04:01.443 | 7283487 | 4186501.0 | 4188169.0 | 0.107         | 0.1762        | 1203.22910919   | 606.56515624    | 0.0             | 0.0             | 4188169.0 | 188611.955945 | 16854.4726057     |\r\n| BTC_JPY      | RUNNING | 2021-01-09T02:05:01.99  | 7284970 | 4183318.0 | 4185000.0 | 0.03          | 0.02994       | 1203.19692324   | 612.95260845    | 0.0             | 0.0             | 4184364.0 | 188625.722582 | 16854.5922007     |\r\n| BTC_JPY      | RUNNING | 2021-01-09T02:06:01.467 | 7286247 | 4182683.0 | 4184961.0 | 0.074         | 0.01          | 1205.67149056   | 618.09582191    | 0.0             | 0.0             | 4184961.0 | 188616.57201  | 16850.0963765     |\r\n| BTC_JPY      | RUNNING | 2021-01-09T02:07:01.627 | 7287530 | 4186482.0 | 4188998.0 | 0.03          | 0.6           | 1199.76322728   | 614.5609498     | 0.0             | 0.0             | 4186483.0 | 188612.761309 | 16855.8516827     |\r\n| BTC_JPY      | RUNNING | 2021-01-09T02:08:02.017 | 7289554 | 4208196.0 | 4210176.0 | 0.0296        | 0.02896875    | 1199.07365715   | 584.77633435    | 0.0             | 0.0             | 4210000.0 | 188746.858826 | 16885.9375454     |\r\n| BTC_JPY      | RUNNING | 2021-01-09T02:09:01.2   | 7291398 | 4218089.0 | 4220000.0 | 0.202         | 0.5989905     | 1203.38397034   | 578.56932313    | 0.0             | 0.0             | 4220000.0 | 188808.063154 | 16888.2721248     |\r\n+--------------+---------+-------------------------+---------+-----------+-----------+---------------+---------------+-----------------+-----------------+-----------------+-----------------+-----------+---------------+-------------------+\r\n13 rows in <\/span>set<\/span> (<\/span>0.00 sec)<\/span>\r\n\r\nMariaDB [<\/span>bitcoin]>\r\n<\/code><\/pre>\n
\u6700\u540e\u4e00\u523b\u56e0\u4e3a\u4eca\u5929\u6211\u4eec\u5df2\u7ecf\u80fd\u591f\u4ee51\u5206\u949f\u95f4\u9694\u83b7\u53d6\u6bd4\u7279\u5e01\u7684\u4ea4\u6613\u4fe1\u606f\uff0c\u6240\u4ee5\u6211\u60f3\u57fa\u4e8e\u8fd9\u4e9b\u6570\u636e\u521b\u5efa\u81ea\u52a8\u4ea4\u6613\u548c\u865a\u62df\u6a21\u62df\u3002
\n\u4eca\u5929\u5c31\u5230\u8fd9\u91cc\u5427\u3002\u8c22\u8c22\u4f60\u3002\uff3e\uff3e<\/p>\n","protected":false},"excerpt":{"rendered":"
\u603b\u7ed3\u7531\u4e8e\u6bd4\u7279\u5e01\u7684\u4ea4\u6613\u4ef7\u683c\u6700\u8fd1\u4e0a\u6da8\uff0c\u6211\u51b3\u5b9a\u901a\u8fc7Bitflyer\u7684API\u6765\u6536\u96c6\u6bd4\u7279\u5e01\u7684\u4ea4\u6613\u4fe1\u606f\uff0c\u5e76\u5c06\u5176\u8f6c\u5316\u4e3a\u6570\u636e\u3002 […]<\/p>\n","protected":false},"author":10,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1],"tags":[227],"class_list":["post-29037","post","type-post","status-publish","format-standard","hentry","category-uncategorized","tag-227"],"yoast_head":"\n\u4f7f\u7528\u6811\u8393\u6d3e\u83b7\u53d6\u6bd4\u7279\u5e01\u7684\u6700\u65b0\u4ea4\u6613\u4ef7\u683c\u4fe1\u606f - Blog - Silicon Cloud<\/title>\n<meta name=\"description\" content=\"\u5173\u4e8e\u4f7f\u7528\u6811\u8393\u6d3e\u83b7\u53d6\u6bd4\u7279\u5e01\u7684\u6700\u65b0\u4ea4\u6613\u4ef7\u683c\u4fe1\u606f\u7684\u6280\u672f\u6587\u7ae0\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.silicloud.com\/zh\/blog\/\u4f7f\u7528\u6811\u8393\u6d3e\u83b7\u53d6\u6bd4\u7279\u5e01\u7684\u6700\u65b0\u4ea4\u6613\u4ef7\u683c\u4fe1\u606f\u3002\/\" \/>\n<meta property=\"og:locale\" content=\"zh_CN\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"\u4f7f\u7528\u6811\u8393\u6d3e\u83b7\u53d6\u6bd4\u7279\u5e01\u7684\u6700\u65b0\u4ea4\u6613\u4ef7\u683c\u4fe1\u606f\" \/>\n<meta property=\"og:description\" content=\"\u5173\u4e8e\u4f7f\u7528\u6811\u8393\u6d3e\u83b7\u53d6\u6bd4\u7279\u5e01\u7684\u6700\u65b0\u4ea4\u6613\u4ef7\u683c\u4fe1\u606f\u7684\u6280\u672f\u6587\u7ae0\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.silicloud.com\/zh\/blog\/\u4f7f\u7528\u6811\u8393\u6d3e\u83b7\u53d6\u6bd4\u7279\u5e01\u7684\u6700\u65b0\u4ea4\u6613\u4ef7\u683c\u4fe1\u606f\u3002\/\" \/>\n<meta property=\"og:site_name\" content=\"Blog - Silicon Cloud\" \/>\n<meta property=\"article:published_time\" content=\"2024-01-12T09:59:47+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2025-08-12T03:28:10+00:00\" \/>\n<meta name=\"author\" content=\"\u5b87, \u534e\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"\u4f5c\u8005\" \/>\n\t<meta name=\"twitter:data1\" content=\"\u5b87, \u534e\" \/>\n\t<meta name=\"twitter:label2\" content=\"\u9884\u8ba1\u9605\u8bfb\u65f6\u95f4\" \/>\n\t<meta name=\"twitter:data2\" content=\"1 \u5206\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.silicloud.com\/zh\/blog\/%e4%bd%bf%e7%94%a8%e6%a0%91%e8%8e%93%e6%b4%be%e8%8e%b7%e5%8f%96%e6%af%94%e7%89%b9%e5%b8%81%e7%9a%84%e6%9c%80%e6%96%b0%e4%ba%a4%e6%98%93%e4%bb%b7%e6%a0%bc%e4%bf%a1%e6%81%af%e3%80%82\/\",\"url\":\"https:\/\/www.silicloud.com\/zh\/blog\/%e4%bd%bf%e7%94%a8%e6%a0%91%e8%8e%93%e6%b4%be%e8%8e%b7%e5%8f%96%e6%af%94%e7%89%b9%e5%b8%81%e7%9a%84%e6%9c%80%e6%96%b0%e4%ba%a4%e6%98%93%e4%bb%b7%e6%a0%bc%e4%bf%a1%e6%81%af%e3%80%82\/\",\"name\":\"\u4f7f\u7528\u6811\u8393\u6d3e\u83b7\u53d6\u6bd4\u7279\u5e01\u7684\u6700\u65b0\u4ea4\u6613\u4ef7\u683c\u4fe1\u606f - Blog - Silicon Cloud\",\"isPartOf\":{\"@id\":\"https:\/\/www.silicloud.com\/zh\/blog\/#website\"},\"datePublished\":\"2024-01-12T09:59:47+00:00\",\"dateModified\":\"2025-08-12T03:28:10+00:00\",\"author\":{\"@id\":\"https:\/\/www.silicloud.com\/zh\/blog\/#\/schema\/person\/513018e4e121d3add1b7c5de8be21458\"},\"description\":\"\u5173\u4e8e\u4f7f\u7528\u6811\u8393\u6d3e\u83b7\u53d6\u6bd4\u7279\u5e01\u7684\u6700\u65b0\u4ea4\u6613\u4ef7\u683c\u4fe1\u606f\u7684\u6280\u672f\u6587\u7ae0\",\"breadcrumb\":{\"@id\":\"https:\/\/www.silicloud.com\/zh\/blog\/%e4%bd%bf%e7%94%a8%e6%a0%91%e8%8e%93%e6%b4%be%e8%8e%b7%e5%8f%96%e6%af%94%e7%89%b9%e5%b8%81%e7%9a%84%e6%9c%80%e6%96%b0%e4%ba%a4%e6%98%93%e4%bb%b7%e6%a0%bc%e4%bf%a1%e6%81%af%e3%80%82\/#breadcrumb\"},\"inLanguage\":\"zh-Hans\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.silicloud.com\/zh\/blog\/%e4%bd%bf%e7%94%a8%e6%a0%91%e8%8e%93%e6%b4%be%e8%8e%b7%e5%8f%96%e6%af%94%e7%89%b9%e5%b8%81%e7%9a%84%e6%9c%80%e6%96%b0%e4%ba%a4%e6%98%93%e4%bb%b7%e6%a0%bc%e4%bf%a1%e6%81%af%e3%80%82\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.silicloud.com\/zh\/blog\/%e4%bd%bf%e7%94%a8%e6%a0%91%e8%8e%93%e6%b4%be%e8%8e%b7%e5%8f%96%e6%af%94%e7%89%b9%e5%b8%81%e7%9a%84%e6%9c%80%e6%96%b0%e4%ba%a4%e6%98%93%e4%bb%b7%e6%a0%bc%e4%bf%a1%e6%81%af%e3%80%82\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"\u9996\u9875\",\"item\":\"https:\/\/www.silicloud.com\/zh\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"\u4f7f\u7528\u6811\u8393\u6d3e\u83b7\u53d6\u6bd4\u7279\u5e01\u7684\u6700\u65b0\u4ea4\u6613\u4ef7\u683c\u4fe1\u606f\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.silicloud.com\/zh\/blog\/#website\",\"url\":\"https:\/\/www.silicloud.com\/zh\/blog\/\",\"name\":\"Blog - Silicon Cloud\",\"description\":\"\",\"inLanguage\":\"zh-Hans\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/www.silicloud.com\/zh\/blog\/#\/schema\/person\/513018e4e121d3add1b7c5de8be21458\",\"name\":\"\u5b87, \u534e\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"zh-Hans\",\"@id\":\"https:\/\/www.silicloud.com\/zh\/blog\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/63cd45cbc05a35fc4ff7637a163c83c4962ef58d27472726c3a3e0c9c5194f0f?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/63cd45cbc05a35fc4ff7637a163c83c4962ef58d27472726c3a3e0c9c5194f0f?s=96&d=mm&r=g\",\"caption\":\"\u5b87, \u534e\"},\"url\":\"https:\/\/www.silicloud.com\/zh\/blog\/author\/yuhua\/\"},{\"@type\":\"ImageObject\",\"inLanguage\":\"zh-Hans\",\"@id\":\"https:\/\/www.silicloud.com\/zh\/blog\/%e4%bd%bf%e7%94%a8%e6%a0%91%e8%8e%93%e6%b4%be%e8%8e%b7%e5%8f%96%e6%af%94%e7%89%b9%e5%b8%81%e7%9a%84%e6%9c%80%e6%96%b0%e4%ba%a4%e6%98%93%e4%bb%b7%e6%a0%bc%e4%bf%a1%e6%81%af%e3%80%82\/#local-main-organization-logo\",\"url\":\"\",\"contentUrl\":\"\",\"caption\":\"Blog - Silicon Cloud\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"\u4f7f\u7528\u6811\u8393\u6d3e\u83b7\u53d6\u6bd4\u7279\u5e01\u7684\u6700\u65b0\u4ea4\u6613\u4ef7\u683c\u4fe1\u606f - Blog - Silicon Cloud","description":"\u5173\u4e8e\u4f7f\u7528\u6811\u8393\u6d3e\u83b7\u53d6\u6bd4\u7279\u5e01\u7684\u6700\u65b0\u4ea4\u6613\u4ef7\u683c\u4fe1\u606f\u7684\u6280\u672f\u6587\u7ae0","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/www.silicloud.com\/zh\/blog\/\u4f7f\u7528\u6811\u8393\u6d3e\u83b7\u53d6\u6bd4\u7279\u5e01\u7684\u6700\u65b0\u4ea4\u6613\u4ef7\u683c\u4fe1\u606f\u3002\/","og_locale":"zh_CN","og_type":"article","og_title":"\u4f7f\u7528\u6811\u8393\u6d3e\u83b7\u53d6\u6bd4\u7279\u5e01\u7684\u6700\u65b0\u4ea4\u6613\u4ef7\u683c\u4fe1\u606f","og_description":"\u5173\u4e8e\u4f7f\u7528\u6811\u8393\u6d3e\u83b7\u53d6\u6bd4\u7279\u5e01\u7684\u6700\u65b0\u4ea4\u6613\u4ef7\u683c\u4fe1\u606f\u7684\u6280\u672f\u6587\u7ae0","og_url":"https:\/\/www.silicloud.com\/zh\/blog\/\u4f7f\u7528\u6811\u8393\u6d3e\u83b7\u53d6\u6bd4\u7279\u5e01\u7684\u6700\u65b0\u4ea4\u6613\u4ef7\u683c\u4fe1\u606f\u3002\/","og_site_name":"Blog - Silicon Cloud","article_published_time":"2024-01-12T09:59:47+00:00","article_modified_time":"2025-08-12T03:28:10+00:00","author":"\u5b87, \u534e","twitter_card":"summary_large_image","twitter_misc":{"\u4f5c\u8005":"\u5b87, \u534e","\u9884\u8ba1\u9605\u8bfb\u65f6\u95f4":"1 \u5206"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/www.silicloud.com\/zh\/blog\/%e4%bd%bf%e7%94%a8%e6%a0%91%e8%8e%93%e6%b4%be%e8%8e%b7%e5%8f%96%e6%af%94%e7%89%b9%e5%b8%81%e7%9a%84%e6%9c%80%e6%96%b0%e4%ba%a4%e6%98%93%e4%bb%b7%e6%a0%bc%e4%bf%a1%e6%81%af%e3%80%82\/","url":"https:\/\/www.silicloud.com\/zh\/blog\/%e4%bd%bf%e7%94%a8%e6%a0%91%e8%8e%93%e6%b4%be%e8%8e%b7%e5%8f%96%e6%af%94%e7%89%b9%e5%b8%81%e7%9a%84%e6%9c%80%e6%96%b0%e4%ba%a4%e6%98%93%e4%bb%b7%e6%a0%bc%e4%bf%a1%e6%81%af%e3%80%82\/","name":"\u4f7f\u7528\u6811\u8393\u6d3e\u83b7\u53d6\u6bd4\u7279\u5e01\u7684\u6700\u65b0\u4ea4\u6613\u4ef7\u683c\u4fe1\u606f - Blog - Silicon Cloud","isPartOf":{"@id":"https:\/\/www.silicloud.com\/zh\/blog\/#website"},"datePublished":"2024-01-12T09:59:47+00:00","dateModified":"2025-08-12T03:28:10+00:00","author":{"@id":"https:\/\/www.silicloud.com\/zh\/blog\/#\/schema\/person\/513018e4e121d3add1b7c5de8be21458"},"description":"\u5173\u4e8e\u4f7f\u7528\u6811\u8393\u6d3e\u83b7\u53d6\u6bd4\u7279\u5e01\u7684\u6700\u65b0\u4ea4\u6613\u4ef7\u683c\u4fe1\u606f\u7684\u6280\u672f\u6587\u7ae0","breadcrumb":{"@id":"https:\/\/www.silicloud.com\/zh\/blog\/%e4%bd%bf%e7%94%a8%e6%a0%91%e8%8e%93%e6%b4%be%e8%8e%b7%e5%8f%96%e6%af%94%e7%89%b9%e5%b8%81%e7%9a%84%e6%9c%80%e6%96%b0%e4%ba%a4%e6%98%93%e4%bb%b7%e6%a0%bc%e4%bf%a1%e6%81%af%e3%80%82\/#breadcrumb"},"inLanguage":"zh-Hans","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.silicloud.com\/zh\/blog\/%e4%bd%bf%e7%94%a8%e6%a0%91%e8%8e%93%e6%b4%be%e8%8e%b7%e5%8f%96%e6%af%94%e7%89%b9%e5%b8%81%e7%9a%84%e6%9c%80%e6%96%b0%e4%ba%a4%e6%98%93%e4%bb%b7%e6%a0%bc%e4%bf%a1%e6%81%af%e3%80%82\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.silicloud.com\/zh\/blog\/%e4%bd%bf%e7%94%a8%e6%a0%91%e8%8e%93%e6%b4%be%e8%8e%b7%e5%8f%96%e6%af%94%e7%89%b9%e5%b8%81%e7%9a%84%e6%9c%80%e6%96%b0%e4%ba%a4%e6%98%93%e4%bb%b7%e6%a0%bc%e4%bf%a1%e6%81%af%e3%80%82\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"\u9996\u9875","item":"https:\/\/www.silicloud.com\/zh\/blog\/"},{"@type":"ListItem","position":2,"name":"\u4f7f\u7528\u6811\u8393\u6d3e\u83b7\u53d6\u6bd4\u7279\u5e01\u7684\u6700\u65b0\u4ea4\u6613\u4ef7\u683c\u4fe1\u606f"}]},{"@type":"WebSite","@id":"https:\/\/www.silicloud.com\/zh\/blog\/#website","url":"https:\/\/www.silicloud.com\/zh\/blog\/","name":"Blog - Silicon Cloud","description":"","inLanguage":"zh-Hans"},{"@type":"Person","@id":"https:\/\/www.silicloud.com\/zh\/blog\/#\/schema\/person\/513018e4e121d3add1b7c5de8be21458","name":"\u5b87, \u534e","image":{"@type":"ImageObject","inLanguage":"zh-Hans","@id":"https:\/\/www.silicloud.com\/zh\/blog\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/63cd45cbc05a35fc4ff7637a163c83c4962ef58d27472726c3a3e0c9c5194f0f?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/63cd45cbc05a35fc4ff7637a163c83c4962ef58d27472726c3a3e0c9c5194f0f?s=96&d=mm&r=g","caption":"\u5b87, \u534e"},"url":"https:\/\/www.silicloud.com\/zh\/blog\/author\/yuhua\/"},{"@type":"ImageObject","inLanguage":"zh-Hans","@id":"https:\/\/www.silicloud.com\/zh\/blog\/%e4%bd%bf%e7%94%a8%e6%a0%91%e8%8e%93%e6%b4%be%e8%8e%b7%e5%8f%96%e6%af%94%e7%89%b9%e5%b8%81%e7%9a%84%e6%9c%80%e6%96%b0%e4%ba%a4%e6%98%93%e4%bb%b7%e6%a0%bc%e4%bf%a1%e6%81%af%e3%80%82\/#local-main-organization-logo","url":"","contentUrl":"","caption":"Blog - Silicon Cloud"}]}},"_links":{"self":[{"href":"https:\/\/www.silicloud.com\/zh\/blog\/wp-json\/wp\/v2\/posts\/29037","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.silicloud.com\/zh\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.silicloud.com\/zh\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.silicloud.com\/zh\/blog\/wp-json\/wp\/v2\/users\/10"}],"replies":[{"embeddable":true,"href":"https:\/\/www.silicloud.com\/zh\/blog\/wp-json\/wp\/v2\/comments?post=29037"}],"version-history":[{"count":3,"href":"https:\/\/www.silicloud.com\/zh\/blog\/wp-json\/wp\/v2\/posts\/29037\/revisions"}],"predecessor-version":[{"id":111431,"href":"https:\/\/www.silicloud.com\/zh\/blog\/wp-json\/wp\/v2\/posts\/29037\/revisions\/111431"}],"wp:attachment":[{"href":"https:\/\/www.silicloud.com\/zh\/blog\/wp-json\/wp\/v2\/media?parent=29037"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.silicloud.com\/zh\/blog\/wp-json\/wp\/v2\/categories?post=29037"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.silicloud.com\/zh\/blog\/wp-json\/wp\/v2\/tags?post=29037"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}