[1 rows x 5 columns]
2025-09-16 18:30:50,405 - IOOppi_data - INFO : save diff data to db: IOOppi_bu_g: no diff data
/usr/local/lib/python3.10/site-packages/urllib3/connectionpool.py:1056: InsecureRequestWarning: Unverified HTTPS request is being made to host 'www.100ppi.com'. Adding certificate verification is strongly advised. See: https://urllib3.readthedocs.io/en/1.26.x/advanced-usage.html#ssl-warnings
warnings.warn(
2025-09-16 18:30:51,012 - IOOppi_data - INFO : save data to db IOOppi_al_t data:
date value
3867 2025-09-12 21056.67
3868 2025-09-13 21056.67
3869 2025-09-14 21056.67
3870 2025-09-15 21056.67
3871 2025-09-16 20960.00
=========================================================================
2025-09-16 18:30:57 Tue START TASK.01 IOOppi_data update_data
=========================================================================
/usr/local/lib/python3.10/site-packages/urllib3/connectionpool.py:1056: InsecureRequestWarning: Unverified HTTPS request is being made to host 'www.100ppi.com'. Adding certificate verification is strongly advised. See: https://urllib3.readthedocs.io/en/1.26.x/advanced-usage.html#ssl-warnings
warnings.warn(
2025-09-16 18:31:00,237 - IOOppi_data - INFO : save data to db IOOppi_rb_t data:
date value
3424 2025-09-12 3124.0
3425 2025-09-13 3124.0
3426 2025-09-14 3124.0
3427 2025-09-15 3134.0
3428 2025-09-16 3148.0
2025-09-16 18:31:11,409 - IOOppi_data - INFO : save new data to db: IOOppi_rb_t: no new data
2025-09-16 18:31:11,409 - IOOppi_data - INFO : save diff data to db: IOOppi_rb_t: no diff data
2025-09-16 18:31:11,415 - IOOppi_data - INFO : save data to db IOOppi_rb_g data:
date value
3424 2025-09-12 3124.0
3425 2025-09-13 3124.0
3426 2025-09-14 3124.0
3427 2025-09-15 3134.0
3428 2025-09-16 3148.0
2025-09-16 18:31:15,730 - IOOppi_data - INFO : save new data to db IOOppi_al_t: date value ... created_at updated_at
3871 2025-09-16 20960.0 ... 2025-09-16 18:31:15.722933 2025-09-16 18:31:15.723362
[1 rows x 5 columns]
2025-09-16 18:31:15,750 - IOOppi_data - INFO : save diff data to db: IOOppi_al_t: no diff data
2025-09-16 18:31:15,757 - IOOppi_data - INFO : save data to db IOOppi_al_g data:
date value
3867 2025-09-12 21056.67
3868 2025-09-13 21056.67
3869 2025-09-14 21056.67
3870 2025-09-15 21056.67
3871 2025-09-16 20960.00
2025-09-16 18:31:28,085 - IOOppi_data - INFO : save new data to db IOOppi_al_g: date value ... created_at updated_at
3874 2025-09-16 20960.0 ... 2025-09-16 18:31:28.077684 2025-09-16 18:31:28.078120
[1 rows x 5 columns]
2025-09-16 18:31:28,308 - IOOppi_data - INFO : save diff data to db: IOOppi_al_g: no diff data
/usr/local/lib/python3.10/site-packages/urllib3/connectionpool.py:1056: InsecureRequestWarning: Unverified HTTPS request is being made to host 'www.100ppi.com'. Adding certificate verification is strongly advised. See: https://urllib3.readthedocs.io/en/1.26.x/advanced-usage.html#ssl-warnings
warnings.warn(
2025-09-16 18:31:28,954 - IOOppi_data - INFO : save data to db IOOppi_SM_t data:
date value
2981 2025-09-12 5666.0
2982 2025-09-13 5666.0
2983 2025-09-14 5666.0
2984 2025-09-15 5678.0
2985 2025-09-16 5752.0
2025-09-16 18:31:48,590 - IOOppi_data - INFO : save new data to db: IOOppi_rb_g: no new data
2025-09-16 18:31:48,590 - IOOppi_data - INFO : save diff data to db: IOOppi_rb_g: no diff data
/usr/local/lib/python3.10/site-packages/urllib3/connectionpool.py:1056: InsecureRequestWarning: Unverified HTTPS request is being made to host 'www.100ppi.com'. Adding certificate verification is strongly advised. See: https://urllib3.readthedocs.io/en/1.26.x/advanced-usage.html#ssl-warnings
warnings.warn(
2025-09-16 18:31:52,937 - IOOppi_data - INFO : save data to db IOOppi_MA_t data:
date value
3645 2025-09-12 2288.33
3646 2025-09-13 2288.33
3647 2025-09-14 2288.33
3648 2025-09-15 2295.00
3649 2025-09-16 2286.67
2025-09-16 18:32:15,121 - IOOppi_data - INFO : save new data to db: IOOppi_MA_t: no new data
2025-09-16 18:32:15,121 - IOOppi_data - INFO : save diff data to db: IOOppi_MA_t: no diff data
2025-09-16 18:32:15,127 - IOOppi_data - INFO : save data to db IOOppi_MA_g data:
date value
3645 2025-09-12 2288.33
3646 2025-09-13 2288.33
3647 2025-09-14 2288.33
3648 2025-09-15 2295.00
3649 2025-09-16 2286.67
2025-09-16 18:32:17,601 - IOOppi_data - INFO : save new data to db IOOppi_SM_t: date value ... created_at updated_at
2985 2025-09-16 5752.0 ... 2025-09-16 18:32:17.593426 2025-09-16 18:32:17.593836
[1 rows x 5 columns]
2025-09-16 18:32:17,826 - IOOppi_data - INFO : save diff data to db: IOOppi_SM_t: no diff data
2025-09-16 18:32:17,833 - IOOppi_data - INFO : save data to db IOOppi_SM_g data:
date value
2981 2025-09-12 5666.0
2982 2025-09-13 5666.0
2983 2025-09-14 5666.0
2984 2025-09-15 5678.0
2985 2025-09-16 5752.0
2025-09-16 18:32:21,833 - IOOppi_data - INFO : save new data to db IOOppi_SM_g: date value ... created_at updated_at
2986 2025-09-13 5666.0 ... 2025-09-16 18:32:21.825590 2025-09-16 18:32:21.826015
2987 2025-09-14 5666.0 ... 2025-09-16 18:32:21.825590 2025-09-16 18:32:21.826015
2988 2025-09-15 5678.0 ... 2025-09-16 18:32:21.825590 2025-09-16 18:32:21.826015
2989 2025-09-16 5752.0 ... 2025-09-16 18:32:21.825590 2025-09-16 18:32:21.826015
[4 rows x 5 columns]
2025-09-16 18:32:21,854 - IOOppi_data - INFO : save diff data to db: IOOppi_SM_g: no diff data
/usr/local/lib/python3.10/site-packages/urllib3/connectionpool.py:1056: InsecureRequestWarning: Unverified HTTPS request is being made to host 'www.100ppi.com'. Adding certificate verification is strongly advised. See: https://urllib3.readthedocs.io/en/1.26.x/advanced-usage.html#ssl-warnings
warnings.warn(
2025-09-16 18:32:22,500 - IOOppi_data - INFO : save data to db IOOppi_CY_t data:
date value
2256 2025-09-12 23550.0
2257 2025-09-13 23550.0
2258 2025-09-14 23550.0
2259 2025-09-15 23550.0
2260 2025-09-16 23550.0
2025-09-16 18:33:43,964 - IOOppi_data - INFO : save new data to db IOOppi_CY_t: date value ... created_at updated_at
2257 2025-09-13 23550.0 ... 2025-09-16 18:33:43.956398 2025-09-16 18:33:43.956833
2258 2025-09-14 23550.0 ... 2025-09-16 18:33:43.956398 2025-09-16 18:33:43.956833
2259 2025-09-15 23550.0 ... 2025-09-16 18:33:43.956398 2025-09-16 18:33:43.956833
2260 2025-09-16 23550.0 ... 2025-09-16 18:33:43.956398 2025-09-16 18:33:43.956833
[4 rows x 5 columns]
2025-09-16 18:33:44,195 - IOOppi_data - INFO : save diff data to db: IOOppi_CY_t: no diff data
2025-09-16 18:33:44,201 - IOOppi_data - INFO : save data to db IOOppi_CY_g data:
date value
2256 2025-09-12 23550.0
2257 2025-09-13 23550.0
2258 2025-09-14 23550.0
2259 2025-09-15 23550.0
2260 2025-09-16 23550.0
2025-09-16 18:33:48,447 - IOOppi_data - INFO : save new data to db IOOppi_CY_g: date value ... created_at updated_at
2261 2025-09-13 23550.0 ... 2025-09-16 18:33:48.440357 2025-09-16 18:33:48.440762
2262 2025-09-14 23550.0 ... 2025-09-16 18:33:48.440357 2025-09-16 18:33:48.440762
2263 2025-09-15 23550.0 ... 2025-09-16 18:33:48.440357 2025-09-16 18:33:48.440762
2264 2025-09-16 23550.0 ... 2025-09-16 18:33:48.440357 2025-09-16 18:33:48.440762
[4 rows x 5 columns]
2025-09-16 18:33:48,672 - IOOppi_data - INFO : save diff data to db: IOOppi_CY_g: no diff data
/usr/local/lib/python3.10/site-packages/urllib3/connectionpool.py:1056: InsecureRequestWarning: Unverified HTTPS request is being made to host 'www.100ppi.com'. Adding certificate verification is strongly advised. See: https://urllib3.readthedocs.io/en/1.26.x/advanced-usage.html#ssl-warnings
warnings.warn(
2025-09-16 18:33:50,748 - IOOppi_data - INFO : save data to db IOOppi_UR_t data:
date value
1771 2025-09-12 1673.75
1772 2025-09-13 1673.75
1773 2025-09-14 1673.75
1774 2025-09-15 1665.00
1775 2025-09-16 1665.00
2025-09-16 18:33:56,269 - IOOppi_data - INFO : save new data to db IOOppi_UR_t: date value ... created_at updated_at
1772 2025-09-13 1673.75 ... 2025-09-16 18:33:56.261633 2025-09-16 18:33:56.262097
1773 2025-09-14 1673.75 ... 2025-09-16 18:33:56.261633 2025-09-16 18:33:56.262097
1774 2025-09-15 1665.00 ... 2025-09-16 18:33:56.261633 2025-09-16 18:33:56.262097
1775 2025-09-16 1665.00 ... 2025-09-16 18:33:56.261633 2025-09-16 18:33:56.262097
[4 rows x 5 columns]
2025-09-16 18:33:56,289 - IOOppi_data - INFO : save diff data to db: IOOppi_UR_t: no diff data
2025-09-16 18:33:56,295 - IOOppi_data - INFO : save data to db IOOppi_UR_g data:
date value
1771 2025-09-12 1673.75
1772 2025-09-13 1673.75
1773 2025-09-14 1673.75
1774 2025-09-15 1665.00
1775 2025-09-16 1665.00
2025-09-16 18:33:57,836 - IOOppi_data - INFO : save new data to db IOOppi_UR_g: date value ... created_at updated_at
1776 2025-09-13 1673.75 ... 2025-09-16 18:33:57.828478 2025-09-16 18:33:57.828883
1777 2025-09-14 1673.75 ... 2025-09-16 18:33:57.828478 2025-09-16 18:33:57.828883
1778 2025-09-15 1665.00 ... 2025-09-16 18:33:57.828478 2025-09-16 18:33:57.828883
1779 2025-09-16 1665.00 ... 2025-09-16 18:33:57.828478 2025-09-16 18:33:57.828883
[4 rows x 5 columns]
2025-09-16 18:33:57,855 - IOOppi_data - INFO : save diff data to db: IOOppi_UR_g: no diff data
/usr/local/lib/python3.10/site-packages/urllib3/connectionpool.py:1056: InsecureRequestWarning: Unverified HTTPS request is being made to host 'www.100ppi.com'. Adding certificate verification is strongly advised. See: https://urllib3.readthedocs.io/en/1.26.x/advanced-usage.html#ssl-warnings
warnings.warn(
2025-09-16 18:33:58,488 - IOOppi_data - INFO : save data to db IOOppi_ni_t data:
date value
2843 2025-09-12 123316.67
2844 2025-09-13 123316.67
2845 2025-09-14 123316.67
2846 2025-09-15 123533.33
2847 2025-09-16 123750.00
2025-09-16 18:33:59,415 - IOOppi_data - INFO : save new data to db IOOppi_ni_t: date ... updated_at
2844 2025-09-13 ... 2025-09-16 18:33:59.408876
2845 2025-09-14 ... 2025-09-16 18:33:59.408876
2846 2025-09-15 ... 2025-09-16 18:33:59.408876
2847 2025-09-16 ... 2025-09-16 18:33:59.408876
[4 rows x 5 columns]
2025-09-16 18:34:00,257 - IOOppi_data - INFO : save diff data to db: IOOppi_ni_t: no diff data
2025-09-16 18:34:00,263 - IOOppi_data - INFO : save data to db IOOppi_ni_g data:
date value
2843 2025-09-12 123316.67
2844 2025-09-13 123316.67
2845 2025-09-14 123316.67
2846 2025-09-15 123533.33
2847 2025-09-16 123750.00
Traceback (most recent call last):
File "/usr/local/lib/python3.10/site-packages/sqlalchemy/engine/base.py", line 1967, in _exec_single_context
self.dialect.do_execute(
File "/usr/local/lib/python3.10/site-packages/sqlalchemy/engine/default.py", line 951, in do_execute
cursor.execute(statement, parameters)
File "/usr/local/lib/python3.10/site-packages/pymysql/cursors.py", line 158, in execute
result = self._query(query)
File "/usr/local/lib/python3.10/site-packages/pymysql/cursors.py", line 325, in _query
conn.query(q)
File "/usr/local/lib/python3.10/site-packages/pymysql/connections.py", line 549, in query
self._affected_rows = self._read_query_result(unbuffered=unbuffered)
File "/usr/local/lib/python3.10/site-packages/pymysql/connections.py", line 779, in _read_query_result
result.read()
File "/usr/local/lib/python3.10/site-packages/pymysql/connections.py", line 1164, in read
self._read_result_packet(first_packet)
File "/usr/local/lib/python3.10/site-packages/pymysql/connections.py", line 1240, in _read_result_packet
self._read_rowdata_packet()
File "/usr/local/lib/python3.10/site-packages/pymysql/connections.py", line 1274, in _read_rowdata_packet
packet = self.connection._read_packet()
File "/usr/local/lib/python3.10/site-packages/pymysql/connections.py", line 715, in _read_packet
recv_data = self._read_bytes(bytes_to_read)
File "/usr/local/lib/python3.10/site-packages/pymysql/connections.py", line 752, in _read_bytes
raise err.OperationalError(
pymysql.err.OperationalError: (2013, 'Lost connection to MySQL server during query')
The above exception was the direct cause of the following exception:
Traceback (most recent call last):
File "/root/project/IOOppi_data/update_data.py", line 16, in
client.update_data_all()
File "/root/project/IOOppi_data/IOOppi_request.py", line 525, in update_data_all
self.update_time_period_data(cmd_id)
File "/root/project/IOOppi_data/IOOppi_request.py", line 455, in update_time_period_data
self.save_data(index_code, content_df)
File "/root/project/IOOppi_data/IOOppi_request.py", line 235, in save_data
self.save_data_to_db(index_code, df)
File "/root/project/IOOppi_data/IOOppi_request.py", line 249, in save_data_to_db
df = pd.read_sql(sql, self.engine)
File "/usr/local/lib/python3.10/site-packages/pandas/io/sql.py", line 736, in read_sql
return pandas_sql.read_query(
File "/usr/local/lib/python3.10/site-packages/pandas/io/sql.py", line 1848, in read_query
result = self.execute(sql, params)
File "/usr/local/lib/python3.10/site-packages/pandas/io/sql.py", line 1671, in execute
return self.con.exec_driver_sql(sql, *args)
File "/usr/local/lib/python3.10/site-packages/sqlalchemy/engine/base.py", line 1779, in exec_driver_sql
ret = self._execute_context(
File "/usr/local/lib/python3.10/site-packages/sqlalchemy/engine/base.py", line 1846, in _execute_context
return self._exec_single_context(
File "/usr/local/lib/python3.10/site-packages/sqlalchemy/engine/base.py", line 1986, in _exec_single_context
self._handle_dbapi_exception(
File "/usr/local/lib/python3.10/site-packages/sqlalchemy/engine/base.py", line 2355, in _handle_dbapi_exception
raise sqlalchemy_exception.with_traceback(exc_info[2]) from e
File "/usr/local/lib/python3.10/site-packages/sqlalchemy/engine/base.py", line 1967, in _exec_single_context
self.dialect.do_execute(
File "/usr/local/lib/python3.10/site-packages/sqlalchemy/engine/default.py", line 951, in do_execute
cursor.execute(statement, parameters)
File "/usr/local/lib/python3.10/site-packages/pymysql/cursors.py", line 158, in execute
result = self._query(query)
File "/usr/local/lib/python3.10/site-packages/pymysql/cursors.py", line 325, in _query
conn.query(q)
File "/usr/local/lib/python3.10/site-packages/pymysql/connections.py", line 549, in query
self._affected_rows = self._read_query_result(unbuffered=unbuffered)
File "/usr/local/lib/python3.10/site-packages/pymysql/connections.py", line 779, in _read_query_result
result.read()
File "/usr/local/lib/python3.10/site-packages/pymysql/connections.py", line 1164, in read
self._read_result_packet(first_packet)
File "/usr/local/lib/python3.10/site-packages/pymysql/connections.py", line 1240, in _read_result_packet
self._read_rowdata_packet()
File "/usr/local/lib/python3.10/site-packages/pymysql/connections.py", line 1274, in _read_rowdata_packet
packet = self.connection._read_packet()
File "/usr/local/lib/python3.10/site-packages/pymysql/connections.py", line 715, in _read_packet
recv_data = self._read_bytes(bytes_to_read)
File "/usr/local/lib/python3.10/site-packages/pymysql/connections.py", line 752, in _read_bytes
raise err.OperationalError(
sqlalchemy.exc.OperationalError: (pymysql.err.OperationalError) (2013, 'Lost connection to MySQL server during query')
[SQL: SELECT `IOOppi_data`.date AS date, `IOOppi_data`.value AS value
FROM `IOOppi_data`
WHERE `IOOppi_data`.index_code = 'IOOppi_ni_g']
(Background on this error at: https://sqlalche.me/e/20/e3q8)
2025-09-16 18:36:39,994 - IOOppi_data - INFO : save new data to db: IOOppi_MA_g: no new data
2025-09-16 18:36:39,994 - IOOppi_data - INFO : save diff data to db: IOOppi_MA_g: no diff data
/usr/local/lib/python3.10/site-packages/urllib3/connectionpool.py:1056: InsecureRequestWarning: Unverified HTTPS request is being made to host 'www.100ppi.com'. Adding certificate verification is strongly advised. See: https://urllib3.readthedocs.io/en/1.26.x/advanced-usage.html#ssl-warnings
warnings.warn(
2025-09-16 18:36:40,556 - IOOppi_data - INFO : save data to db IOOppi_PTA_t data:
date value
985 2025-09-12 4636.66
986 2025-09-13 4636.66
987 2025-09-14 4636.66
988 2025-09-15 4631.66
989 2025-09-16 4633.75
2025-09-16 18:36:43,290 - IOOppi_data - INFO : save new data to db: IOOppi_PTA_t: no new data
2025-09-16 18:36:43,290 - IOOppi_data - INFO : save diff data to db: IOOppi_PTA_t: no diff data
2025-09-16 18:36:43,295 - IOOppi_data - INFO : save data to db IOOppi_PTA_g data:
date value
985 2025-09-12 4636.66
986 2025-09-13 4636.66
987 2025-09-14 4636.66
988 2025-09-15 4631.66
989 2025-09-16 4633.75
2025-09-16 18:36:45,748 - IOOppi_data - INFO : save new data to db: IOOppi_PTA_g: no new data
2025-09-16 18:36:45,748 - IOOppi_data - INFO : save diff data to db: IOOppi_PTA_g: no diff data
/usr/local/lib/python3.10/site-packages/urllib3/connectionpool.py:1056: InsecureRequestWarning: Unverified HTTPS request is being made to host 'www.100ppi.com'. Adding certificate verification is strongly advised. See: https://urllib3.readthedocs.io/en/1.26.x/advanced-usage.html#ssl-warnings
warnings.warn(
2025-09-16 18:36:46,425 - IOOppi_data - INFO : save data to db IOOppi_ru_t data:
date value
3864 2025-09-12 14983.33
3865 2025-09-13 14983.33
3866 2025-09-14 14983.33
3867 2025-09-15 15133.33
3868 2025-09-16 15166.67
2025-09-16 18:36:48,485 - IOOppi_data - INFO : save new data to db: IOOppi_ru_t: no new data
2025-09-16 18:36:48,486 - IOOppi_data - INFO : save diff data to db: IOOppi_ru_t: no diff data
2025-09-16 18:36:48,491 - IOOppi_data - INFO : save data to db IOOppi_ru_g data:
date value
3864 2025-09-12 14983.33
3865 2025-09-13 14983.33
3866 2025-09-14 14983.33
3867 2025-09-15 15133.33
3868 2025-09-16 15166.67
2025-09-16 18:36:49,869 - IOOppi_data - INFO : save new data to db: IOOppi_ru_g: no new data
2025-09-16 18:36:49,869 - IOOppi_data - INFO : save diff data to db: IOOppi_ru_g: no diff data
/usr/local/lib/python3.10/site-packages/urllib3/connectionpool.py:1056: InsecureRequestWarning: Unverified HTTPS request is being made to host 'www.100ppi.com'. Adding certificate verification is strongly advised. See: https://urllib3.readthedocs.io/en/1.26.x/advanced-usage.html#ssl-warnings
warnings.warn(
2025-09-16 18:36:50,436 - IOOppi_data - INFO : save data to db IOOppi_i_t data:
date value
3196 2025-09-12 808.00
3197 2025-09-13 808.00
3198 2025-09-14 807.89
3199 2025-09-15 807.89
3200 2025-09-16 816.44
2025-09-16 18:36:51,590 - IOOppi_data - INFO : save new data to db: IOOppi_i_t: no new data
2025-09-16 18:36:51,590 - IOOppi_data - INFO : save diff data to db: IOOppi_i_t: no diff data
2025-09-16 18:36:51,596 - IOOppi_data - INFO : save data to db IOOppi_i_g data:
date value
3196 2025-09-12 808.00
3197 2025-09-13 808.00
3198 2025-09-14 807.89
3199 2025-09-15 807.89
3200 2025-09-16 816.44
2025-09-16 18:36:52,500 - IOOppi_data - INFO : save new data to db: IOOppi_i_g: no new data
2025-09-16 18:36:52,500 - IOOppi_data - INFO : save diff data to db: IOOppi_i_g: no diff data
/usr/local/lib/python3.10/site-packages/urllib3/connectionpool.py:1056: InsecureRequestWarning: Unverified HTTPS request is being made to host 'www.100ppi.com'. Adding certificate verification is strongly advised. See: https://urllib3.readthedocs.io/en/1.26.x/advanced-usage.html#ssl-warnings
warnings.warn(
2025-09-16 18:36:53,084 - IOOppi_data - INFO : save data to db IOOppi_FG_t data:
date value
3399 2025-09-12 1130.4
3400 2025-09-13 1130.4
3401 2025-09-14 1130.4
3402 2025-09-15 1130.4
3403 2025-09-16 1120.0
2025-09-16 18:37:13,800 - IOOppi_data - INFO : save new data to db: IOOppi_FG_t: no new data
/root/project/IOOppi_data/IOOppi_request.py:308: SettingWithCopyWarning:
A value is trying to be set on a copy of a slice from a DataFrame.
Try using .loc[row_indexer,col_indexer] = value instead
See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy
diff_df.loc[:, 'index_code'] = index_code
/root/project/IOOppi_data/IOOppi_request.py:309: SettingWithCopyWarning:
A value is trying to be set on a copy of a slice from a DataFrame.
Try using .loc[row_indexer,col_indexer] = value instead
See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy
diff_df.loc[:, 'created_at'] = datetime.datetime.now()
/root/project/IOOppi_data/IOOppi_request.py:310: SettingWithCopyWarning:
A value is trying to be set on a copy of a slice from a DataFrame.
Try using .loc[row_indexer,col_indexer] = value instead
See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy
diff_df.loc[:, 'updated_at'] = datetime.datetime.now()
2025-09-16 18:41:26,776 - IOOppi_data - INFO : save diff data to db IOOppi_FG_t: date ... updated_at
12 2012-12-19 ... 2025-09-16 18:41:26.765421
21 2013-01-04 ... 2025-09-16 18:41:26.765421
54 2013-02-27 ... 2025-09-16 18:41:26.765421
60 2013-03-07 ... 2025-09-16 18:41:26.765421
61 2013-03-08 ... 2025-09-16 18:41:26.765421
[5 rows x 6 columns]
2025-09-16 18:41:37,262 - IOOppi_data - INFO : save data to db IOOppi_FG_g data:
date value
3399 2025-09-12 1130.4
3400 2025-09-13 1130.4
3401 2025-09-14 1130.4
3402 2025-09-15 1130.4
3403 2025-09-16 1120.0
2025-09-16 18:41:52,067 - IOOppi_data - INFO : save new data to db: IOOppi_FG_g: no new data
/root/project/IOOppi_data/IOOppi_request.py:308: SettingWithCopyWarning:
A value is trying to be set on a copy of a slice from a DataFrame.
Try using .loc[row_indexer,col_indexer] = value instead
See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy
diff_df.loc[:, 'index_code'] = index_code
/root/project/IOOppi_data/IOOppi_request.py:309: SettingWithCopyWarning:
A value is trying to be set on a copy of a slice from a DataFrame.
Try using .loc[row_indexer,col_indexer] = value instead
See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy
diff_df.loc[:, 'created_at'] = datetime.datetime.now()
/root/project/IOOppi_data/IOOppi_request.py:310: SettingWithCopyWarning:
A value is trying to be set on a copy of a slice from a DataFrame.
Try using .loc[row_indexer,col_indexer] = value instead
See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy
diff_df.loc[:, 'updated_at'] = datetime.datetime.now()
2025-09-16 18:45:25,232 - IOOppi_data - INFO : save diff data to db IOOppi_FG_g: date ... updated_at
12 2012-12-19 ... 2025-09-16 18:45:25.223942
21 2013-01-04 ... 2025-09-16 18:45:25.223942
54 2013-02-27 ... 2025-09-16 18:45:25.223942
60 2013-03-07 ... 2025-09-16 18:45:25.223942
61 2013-03-08 ... 2025-09-16 18:45:25.223942
[5 rows x 6 columns]
/usr/local/lib/python3.10/site-packages/urllib3/connectionpool.py:1056: InsecureRequestWarning: Unverified HTTPS request is being made to host 'www.100ppi.com'. Adding certificate verification is strongly advised. See: https://urllib3.readthedocs.io/en/1.26.x/advanced-usage.html#ssl-warnings
warnings.warn(
2025-09-16 18:45:42,844 - IOOppi_data - INFO : save data to db IOOppi_eb_t data:
date value
1744 2025-09-12 7314.0
1745 2025-09-13 7320.0
1746 2025-09-14 7320.0
1747 2025-09-15 7314.0
1748 2025-09-16 7324.0
2025-09-16 18:45:45,853 - IOOppi_data - INFO : save new data to db: IOOppi_eb_t: no new data
2025-09-16 18:45:45,853 - IOOppi_data - INFO : save diff data to db: IOOppi_eb_t: no diff data
2025-09-16 18:45:45,858 - IOOppi_data - INFO : save data to db IOOppi_eb_g data:
date value
1744 2025-09-12 7314.0
1745 2025-09-13 7320.0
1746 2025-09-14 7320.0
1747 2025-09-15 7314.0
1748 2025-09-16 7324.0
2025-09-16 18:45:47,024 - IOOppi_data - INFO : save new data to db: IOOppi_eb_g: no new data
2025-09-16 18:45:47,024 - IOOppi_data - INFO : save diff data to db: IOOppi_eb_g: no diff data
/usr/local/lib/python3.10/site-packages/urllib3/connectionpool.py:1056: InsecureRequestWarning: Unverified HTTPS request is being made to host 'www.100ppi.com'. Adding certificate verification is strongly advised. See: https://urllib3.readthedocs.io/en/1.26.x/advanced-usage.html#ssl-warnings
warnings.warn(
2025-09-16 18:45:47,809 - IOOppi_data - INFO : save data to db IOOppi_SR_t data:
date value
3855 2025-09-12 5855.0
3856 2025-09-13 5855.0
3857 2025-09-14 5855.0
3858 2025-09-15 5850.0
3859 2025-09-16 5865.0
2025-09-16 18:45:52,883 - IOOppi_data - INFO : save new data to db: IOOppi_SR_t: no new data
2025-09-16 18:45:52,883 - IOOppi_data - INFO : save diff data to db: IOOppi_SR_t: no diff data
2025-09-16 18:45:52,889 - IOOppi_data - INFO : save data to db IOOppi_SR_g data:
date value
3855 2025-09-12 5855.0
3856 2025-09-13 5855.0
3857 2025-09-14 5855.0
3858 2025-09-15 5850.0
3859 2025-09-16 5865.0
2025-09-16 18:46:01,267 - IOOppi_data - INFO : save new data to db: IOOppi_SR_g: no new data
2025-09-16 18:46:01,267 - IOOppi_data - INFO : save diff data to db: IOOppi_SR_g: no diff data
/usr/local/lib/python3.10/site-packages/urllib3/connectionpool.py:1056: InsecureRequestWarning: Unverified HTTPS request is being made to host 'www.100ppi.com'. Adding certificate verification is strongly advised. See: https://urllib3.readthedocs.io/en/1.26.x/advanced-usage.html#ssl-warnings
warnings.warn(
2025-09-16 18:46:01,883 - IOOppi_data - INFO : save data to db IOOppi_ss_t data:
date value
1745 2025-09-12 13067.5
1746 2025-09-13 13067.5
1747 2025-09-14 13067.5
1748 2025-09-15 13092.5
1749 2025-09-16 13092.5
2025-09-16 18:46:13,759 - IOOppi_data - INFO : save new data to db: IOOppi_ss_t: no new data
2025-09-16 18:46:13,759 - IOOppi_data - INFO : save diff data to db: IOOppi_ss_t: no diff data
2025-09-16 18:46:13,764 - IOOppi_data - INFO : save data to db IOOppi_ss_g data:
date value
1745 2025-09-12 13067.5
1746 2025-09-13 13067.5
1747 2025-09-14 13067.5
1748 2025-09-15 13092.5
1749 2025-09-16 13092.5
2025-09-16 18:46:27,509 - IOOppi_data - INFO : save new data to db: IOOppi_ss_g: no new data
2025-09-16 18:46:27,509 - IOOppi_data - INFO : save diff data to db: IOOppi_ss_g: no diff data
/usr/local/lib/python3.10/site-packages/urllib3/connectionpool.py:1056: InsecureRequestWarning: Unverified HTTPS request is being made to host 'www.100ppi.com'. Adding certificate verification is strongly advised. See: https://urllib3.readthedocs.io/en/1.26.x/advanced-usage.html#ssl-warnings
warnings.warn(
2025-09-16 18:46:28,205 - IOOppi_data - INFO : save data to db IOOppi_RS_t data:
date value
3255 2025-09-12 10000.00
3256 2025-09-13 10000.00
3257 2025-09-14 10000.00
3258 2025-09-15 10026.67
3259 2025-09-16 10166.67
2025-09-16 18:46:49,731 - IOOppi_data - INFO : save new data to db: IOOppi_RS_t: no new data
2025-09-16 18:46:49,731 - IOOppi_data - INFO : save diff data to db: IOOppi_RS_t: no diff data
2025-09-16 18:46:49,737 - IOOppi_data - INFO : save data to db IOOppi_RS_g data:
date value
3255 2025-09-12 10000.00
3256 2025-09-13 10000.00
3257 2025-09-14 10000.00
3258 2025-09-15 10026.67
3259 2025-09-16 10166.67
2025-09-16 18:46:59,329 - IOOppi_data - INFO : save new data to db: IOOppi_RS_g: no new data
2025-09-16 18:46:59,329 - IOOppi_data - INFO : save diff data to db: IOOppi_RS_g: no diff data
/usr/local/lib/python3.10/site-packages/urllib3/connectionpool.py:1056: InsecureRequestWarning: Unverified HTTPS request is being made to host 'www.100ppi.com'. Adding certificate verification is strongly advised. See: https://urllib3.readthedocs.io/en/1.26.x/advanced-usage.html#ssl-warnings
warnings.warn(
2025-09-16 18:46:59,923 - IOOppi_data - INFO : save data to db IOOppi_RM_t data:
date value
3378 2025-09-12 2680.0
3379 2025-09-13 2680.0
3380 2025-09-14 2680.0
3381 2025-09-15 2635.0
3382 2025-09-16 2655.0
2025-09-16 18:47:14,869 - IOOppi_data - INFO : save new data to db: IOOppi_RM_t: no new data
2025-09-16 18:47:14,869 - IOOppi_data - INFO : save diff data to db: IOOppi_RM_t: no diff data
2025-09-16 18:47:14,877 - IOOppi_data - INFO : save data to db IOOppi_RM_g data:
date value
3378 2025-09-12 2680.0
3379 2025-09-13 2680.0
3380 2025-09-14 2680.0
3381 2025-09-15 2635.0
3382 2025-09-16 2655.0
2025-09-16 18:47:31,726 - IOOppi_data - INFO : save new data to db: IOOppi_RM_g: no new data
2025-09-16 18:47:31,726 - IOOppi_data - INFO : save diff data to db: IOOppi_RM_g: no diff data
/usr/local/lib/python3.10/site-packages/urllib3/connectionpool.py:1056: InsecureRequestWarning: Unverified HTTPS request is being made to host 'www.100ppi.com'. Adding certificate verification is strongly advised. See: https://urllib3.readthedocs.io/en/1.26.x/advanced-usage.html#ssl-warnings
warnings.warn(
2025-09-16 18:47:32,341 - IOOppi_data - INFO : save data to db IOOppi_SA_t data:
date value
1582 2025-09-12 1262.5
1583 2025-09-13 1262.5
1584 2025-09-14 1262.5
1585 2025-09-15 1262.5
1586 2025-09-16 1262.5
2025-09-16 18:47:46,506 - IOOppi_data - INFO : save new data to db: IOOppi_SA_t: no new data
2025-09-16 18:47:46,507 - IOOppi_data - INFO : save diff data to db: IOOppi_SA_t: no diff data
2025-09-16 18:47:46,512 - IOOppi_data - INFO : save data to db IOOppi_SA_g data:
date value
1582 2025-09-12 1262.5
1583 2025-09-13 1262.5
1584 2025-09-14 1262.5
1585 2025-09-15 1262.5
1586 2025-09-16 1262.5
2025-09-16 18:47:52,580 - IOOppi_data - INFO : save new data to db: IOOppi_SA_g: no new data
2025-09-16 18:47:52,580 - IOOppi_data - INFO : save diff data to db: IOOppi_SA_g: no diff data
/usr/local/lib/python3.10/site-packages/urllib3/connectionpool.py:1056: InsecureRequestWarning: Unverified HTTPS request is being made to host 'www.100ppi.com'. Adding certificate verification is strongly advised. See: https://urllib3.readthedocs.io/en/1.26.x/advanced-usage.html#ssl-warnings
warnings.warn(
2025-09-16 18:47:53,139 - IOOppi_data - INFO : save data to db IOOppi_PF_t data:
date value
1495 2025-09-12 6457.00
1496 2025-09-13 6457.00
1497 2025-09-14 6457.00
1498 2025-09-15 6471.00
1499 2025-09-16 6478.34
2025-09-16 18:47:54,235 - IOOppi_data - INFO : save new data to db: IOOppi_PF_t: no new data
2025-09-16 18:47:54,236 - IOOppi_data - INFO : save diff data to db: IOOppi_PF_t: no diff data
2025-09-16 18:47:54,241 - IOOppi_data - INFO : save data to db IOOppi_PF_g data:
date value
1495 2025-09-12 6457.00
1496 2025-09-13 6457.00
1497 2025-09-14 6457.00
1498 2025-09-15 6471.00
1499 2025-09-16 6478.34
2025-09-16 18:47:57,008 - IOOppi_data - INFO : save new data to db: IOOppi_PF_g: no new data
2025-09-16 18:47:57,008 - IOOppi_data - INFO : save diff data to db: IOOppi_PF_g: no diff data
/usr/local/lib/python3.10/site-packages/urllib3/connectionpool.py:1056: InsecureRequestWarning: Unverified HTTPS request is being made to host 'www.100ppi.com'. Adding certificate verification is strongly advised. See: https://urllib3.readthedocs.io/en/1.26.x/advanced-usage.html#ssl-warnings
warnings.warn(
2025-09-16 18:47:57,614 - IOOppi_data - INFO : save data to db IOOppi_m_t data:
date value
3868 2025-09-12 3060.0
3869 2025-09-13 3060.0
3870 2025-09-14 3060.0
3871 2025-09-15 3058.0
3872 2025-09-16 3056.0
2025-09-16 18:48:11,635 - IOOppi_data - INFO : save new data to db: IOOppi_m_t: no new data
2025-09-16 18:48:11,635 - IOOppi_data - INFO : save diff data to db: IOOppi_m_t: no diff data
2025-09-16 18:48:11,641 - IOOppi_data - INFO : save data to db IOOppi_m_g data:
date value
3868 2025-09-12 3060.0
3869 2025-09-13 3060.0
3870 2025-09-14 3060.0
3871 2025-09-15 3058.0
3872 2025-09-16 3056.0
=========================================================================
2025-09-16 19:11:27 Tue START TASK.01 IOOppi_data update_data
=========================================================================
/usr/local/lib/python3.10/site-packages/urllib3/connectionpool.py:1056: InsecureRequestWarning: Unverified HTTPS request is being made to host 'www.100ppi.com'. Adding certificate verification is strongly advised. See: https://urllib3.readthedocs.io/en/1.26.x/advanced-usage.html#ssl-warnings
warnings.warn(
2025-09-16 19:11:39,450 - IOOppi_data - INFO : save data to db IOOppi_rb_t data:
date value
3424 2025-09-12 3124.0
3425 2025-09-13 3124.0
3426 2025-09-14 3124.0
3427 2025-09-15 3134.0
3428 2025-09-16 3148.0
2025-09-16 19:11:43,264 - IOOppi_data - INFO : save new data to db: IOOppi_rb_t: no new data
2025-09-16 19:11:43,264 - IOOppi_data - INFO : save diff data to db: IOOppi_rb_t: no diff data
2025-09-16 19:11:43,269 - IOOppi_data - INFO : save data to db IOOppi_rb_g data:
date value
3424 2025-09-12 3124.0
3425 2025-09-13 3124.0
3426 2025-09-14 3124.0
3427 2025-09-15 3134.0
3428 2025-09-16 3148.0
2025-09-16 19:11:51,295 - IOOppi_data - INFO : save new data to db: IOOppi_rb_g: no new data
2025-09-16 19:11:51,296 - IOOppi_data - INFO : save diff data to db: IOOppi_rb_g: no diff data
/usr/local/lib/python3.10/site-packages/urllib3/connectionpool.py:1056: InsecureRequestWarning: Unverified HTTPS request is being made to host 'www.100ppi.com'. Adding certificate verification is strongly advised. See: https://urllib3.readthedocs.io/en/1.26.x/advanced-usage.html#ssl-warnings
warnings.warn(
2025-09-16 19:11:52,057 - IOOppi_data - INFO : save data to db IOOppi_MA_t data:
date value
3645 2025-09-12 2288.33
3646 2025-09-13 2288.33
3647 2025-09-14 2288.33
3648 2025-09-15 2295.00
3649 2025-09-16 2286.67
2025-09-16 19:12:00,134 - IOOppi_data - INFO : save new data to db: IOOppi_MA_t: no new data
2025-09-16 19:12:00,134 - IOOppi_data - INFO : save diff data to db: IOOppi_MA_t: no diff data
2025-09-16 19:12:00,140 - IOOppi_data - INFO : save data to db IOOppi_MA_g data:
date value
3645 2025-09-12 2288.33
3646 2025-09-13 2288.33
3647 2025-09-14 2288.33
3648 2025-09-15 2295.00
3649 2025-09-16 2286.67
2025-09-16 19:12:30,211 - IOOppi_data - INFO : save new data to db: IOOppi_MA_g: no new data
2025-09-16 19:12:30,211 - IOOppi_data - INFO : save diff data to db: IOOppi_MA_g: no diff data
/usr/local/lib/python3.10/site-packages/urllib3/connectionpool.py:1056: InsecureRequestWarning: Unverified HTTPS request is being made to host 'www.100ppi.com'. Adding certificate verification is strongly advised. See: https://urllib3.readthedocs.io/en/1.26.x/advanced-usage.html#ssl-warnings
warnings.warn(
2025-09-16 19:12:30,834 - IOOppi_data - INFO : save data to db IOOppi_PTA_t data:
date value
985 2025-09-12 4636.66
986 2025-09-13 4636.66
987 2025-09-14 4636.66
988 2025-09-15 4631.66
989 2025-09-16 4633.75
2025-09-16 19:12:44,177 - IOOppi_data - INFO : save new data to db: IOOppi_PTA_t: no new data
2025-09-16 19:12:44,177 - IOOppi_data - INFO : save diff data to db: IOOppi_PTA_t: no diff data
2025-09-16 19:12:44,182 - IOOppi_data - INFO : save data to db IOOppi_PTA_g data:
date value
985 2025-09-12 4636.66
986 2025-09-13 4636.66
987 2025-09-14 4636.66
988 2025-09-15 4631.66
989 2025-09-16 4633.75
2025-09-16 19:12:51,143 - IOOppi_data - INFO : save new data to db: IOOppi_PTA_g: no new data
2025-09-16 19:12:51,143 - IOOppi_data - INFO : save diff data to db: IOOppi_PTA_g: no diff data
/usr/local/lib/python3.10/site-packages/urllib3/connectionpool.py:1056: InsecureRequestWarning: Unverified HTTPS request is being made to host 'www.100ppi.com'. Adding certificate verification is strongly advised. See: https://urllib3.readthedocs.io/en/1.26.x/advanced-usage.html#ssl-warnings
warnings.warn(
2025-09-16 19:12:51,786 - IOOppi_data - INFO : save data to db IOOppi_ru_t data:
date value
3864 2025-09-12 14983.33
3865 2025-09-13 14983.33
3866 2025-09-14 14983.33
3867 2025-09-15 15133.33
3868 2025-09-16 15166.67
2025-09-16 19:13:04,732 - IOOppi_data - INFO : save new data to db: IOOppi_ru_t: no new data
2025-09-16 19:13:04,733 - IOOppi_data - INFO : save diff data to db: IOOppi_ru_t: no diff data
2025-09-16 19:13:04,738 - IOOppi_data - INFO : save data to db IOOppi_ru_g data:
date value
3864 2025-09-12 14983.33
3865 2025-09-13 14983.33
3866 2025-09-14 14983.33
3867 2025-09-15 15133.33
3868 2025-09-16 15166.67
2025-09-16 19:13:10,233 - IOOppi_data - INFO : save new data to db: IOOppi_ru_g: no new data
2025-09-16 19:13:10,233 - IOOppi_data - INFO : save diff data to db: IOOppi_ru_g: no diff data
/usr/local/lib/python3.10/site-packages/urllib3/connectionpool.py:1056: InsecureRequestWarning: Unverified HTTPS request is being made to host 'www.100ppi.com'. Adding certificate verification is strongly advised. See: https://urllib3.readthedocs.io/en/1.26.x/advanced-usage.html#ssl-warnings
warnings.warn(
2025-09-16 19:13:10,863 - IOOppi_data - INFO : save data to db IOOppi_i_t data:
date value
3196 2025-09-12 808.00
3197 2025-09-13 808.00
3198 2025-09-14 807.89
3199 2025-09-15 807.89
3200 2025-09-16 816.44
2025-09-16 19:13:16,428 - IOOppi_data - INFO : save new data to db: IOOppi_i_t: no new data
2025-09-16 19:13:16,428 - IOOppi_data - INFO : save diff data to db: IOOppi_i_t: no diff data
2025-09-16 19:13:16,433 - IOOppi_data - INFO : save data to db IOOppi_i_g data:
date value
3196 2025-09-12 808.00
3197 2025-09-13 808.00
3198 2025-09-14 807.89
3199 2025-09-15 807.89
3200 2025-09-16 816.44
2025-09-16 19:13:21,773 - IOOppi_data - INFO : save new data to db: IOOppi_i_g: no new data
2025-09-16 19:13:21,773 - IOOppi_data - INFO : save diff data to db: IOOppi_i_g: no diff data
/usr/local/lib/python3.10/site-packages/urllib3/connectionpool.py:1056: InsecureRequestWarning: Unverified HTTPS request is being made to host 'www.100ppi.com'. Adding certificate verification is strongly advised. See: https://urllib3.readthedocs.io/en/1.26.x/advanced-usage.html#ssl-warnings
warnings.warn(
2025-09-16 19:13:22,350 - IOOppi_data - INFO : save data to db IOOppi_FG_t data:
date value
3399 2025-09-12 1130.4
3400 2025-09-13 1130.4
3401 2025-09-14 1130.4
3402 2025-09-15 1130.4
3403 2025-09-16 1120.0
2025-09-16 19:13:40,781 - IOOppi_data - INFO : save new data to db: IOOppi_FG_t: no new data
/root/project/IOOppi_data/IOOppi_request.py:308: SettingWithCopyWarning:
A value is trying to be set on a copy of a slice from a DataFrame.
Try using .loc[row_indexer,col_indexer] = value instead
See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy
diff_df.loc[:, 'index_code'] = index_code
/root/project/IOOppi_data/IOOppi_request.py:309: SettingWithCopyWarning:
A value is trying to be set on a copy of a slice from a DataFrame.
Try using .loc[row_indexer,col_indexer] = value instead
See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy
diff_df.loc[:, 'created_at'] = datetime.datetime.now()
/root/project/IOOppi_data/IOOppi_request.py:310: SettingWithCopyWarning:
A value is trying to be set on a copy of a slice from a DataFrame.
Try using .loc[row_indexer,col_indexer] = value instead
See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy
diff_df.loc[:, 'updated_at'] = datetime.datetime.now()
2025-09-16 19:15:42,471 - IOOppi_data - INFO : save diff data to db IOOppi_FG_t: date ... updated_at
12 2012-12-19 ... 2025-09-16 19:15:42.461983
21 2013-01-04 ... 2025-09-16 19:15:42.461983
54 2013-02-27 ... 2025-09-16 19:15:42.461983
60 2013-03-07 ... 2025-09-16 19:15:42.461983
61 2013-03-08 ... 2025-09-16 19:15:42.461983
[5 rows x 6 columns]
2025-09-16 19:15:56,930 - IOOppi_data - INFO : save data to db IOOppi_FG_g data:
date value
3399 2025-09-12 1130.4
3400 2025-09-13 1130.4
3401 2025-09-14 1130.4
3402 2025-09-15 1130.4
3403 2025-09-16 1120.0
2025-09-16 19:16:17,645 - IOOppi_data - INFO : save new data to db: IOOppi_FG_g: no new data
/root/project/IOOppi_data/IOOppi_request.py:308: SettingWithCopyWarning:
A value is trying to be set on a copy of a slice from a DataFrame.
Try using .loc[row_indexer,col_indexer] = value instead
See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy
diff_df.loc[:, 'index_code'] = index_code
/root/project/IOOppi_data/IOOppi_request.py:309: SettingWithCopyWarning:
A value is trying to be set on a copy of a slice from a DataFrame.
Try using .loc[row_indexer,col_indexer] = value instead
See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy
diff_df.loc[:, 'created_at'] = datetime.datetime.now()
/root/project/IOOppi_data/IOOppi_request.py:310: SettingWithCopyWarning:
A value is trying to be set on a copy of a slice from a DataFrame.
Try using .loc[row_indexer,col_indexer] = value instead
See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy
diff_df.loc[:, 'updated_at'] = datetime.datetime.now()
2025-09-16 19:17:11,562 - IOOppi_data - INFO : save diff data to db IOOppi_FG_g: date ... updated_at
12 2012-12-19 ... 2025-09-16 19:17:11.553636
21 2013-01-04 ... 2025-09-16 19:17:11.553636
54 2013-02-27 ... 2025-09-16 19:17:11.553636
60 2013-03-07 ... 2025-09-16 19:17:11.553636
61 2013-03-08 ... 2025-09-16 19:17:11.553636
[5 rows x 6 columns]
/usr/local/lib/python3.10/site-packages/urllib3/connectionpool.py:1056: InsecureRequestWarning: Unverified HTTPS request is being made to host 'www.100ppi.com'. Adding certificate verification is strongly advised. See: https://urllib3.readthedocs.io/en/1.26.x/advanced-usage.html#ssl-warnings
warnings.warn(
2025-09-16 19:17:15,967 - IOOppi_data - INFO : save data to db IOOppi_eb_t data:
date value
1744 2025-09-12 7314.0
1745 2025-09-13 7320.0
1746 2025-09-14 7320.0
1747 2025-09-15 7314.0
1748 2025-09-16 7324.0
2025-09-16 19:17:23,980 - IOOppi_data - INFO : save new data to db: IOOppi_eb_t: no new data
2025-09-16 19:17:23,980 - IOOppi_data - INFO : save diff data to db: IOOppi_eb_t: no diff data
2025-09-16 19:17:23,985 - IOOppi_data - INFO : save data to db IOOppi_eb_g data:
date value
1744 2025-09-12 7314.0
1745 2025-09-13 7320.0
1746 2025-09-14 7320.0
1747 2025-09-15 7314.0
1748 2025-09-16 7324.0
2025-09-16 19:17:29,163 - IOOppi_data - INFO : save new data to db: IOOppi_eb_g: no new data
2025-09-16 19:17:29,164 - IOOppi_data - INFO : save diff data to db: IOOppi_eb_g: no diff data
/usr/local/lib/python3.10/site-packages/urllib3/connectionpool.py:1056: InsecureRequestWarning: Unverified HTTPS request is being made to host 'www.100ppi.com'. Adding certificate verification is strongly advised. See: https://urllib3.readthedocs.io/en/1.26.x/advanced-usage.html#ssl-warnings
warnings.warn(
2025-09-16 19:17:29,761 - IOOppi_data - INFO : save data to db IOOppi_SR_t data:
date value
3855 2025-09-12 5855.0
3856 2025-09-13 5855.0
3857 2025-09-14 5855.0
3858 2025-09-15 5850.0
3859 2025-09-16 5865.0
2025-09-16 19:17:36,943 - IOOppi_data - INFO : save new data to db: IOOppi_SR_t: no new data
2025-09-16 19:17:36,943 - IOOppi_data - INFO : save diff data to db: IOOppi_SR_t: no diff data
2025-09-16 19:17:36,949 - IOOppi_data - INFO : save data to db IOOppi_SR_g data:
date value
3855 2025-09-12 5855.0
3856 2025-09-13 5855.0
3857 2025-09-14 5855.0
3858 2025-09-15 5850.0
3859 2025-09-16 5865.0
2025-09-16 19:17:43,562 - IOOppi_data - INFO : save new data to db: IOOppi_SR_g: no new data
2025-09-16 19:17:43,562 - IOOppi_data - INFO : save diff data to db: IOOppi_SR_g: no diff data
/usr/local/lib/python3.10/site-packages/urllib3/connectionpool.py:1056: InsecureRequestWarning: Unverified HTTPS request is being made to host 'www.100ppi.com'. Adding certificate verification is strongly advised. See: https://urllib3.readthedocs.io/en/1.26.x/advanced-usage.html#ssl-warnings
warnings.warn(
2025-09-16 19:17:44,239 - IOOppi_data - INFO : save data to db IOOppi_ss_t data:
date value
1745 2025-09-12 13067.5
1746 2025-09-13 13067.5
1747 2025-09-14 13067.5
1748 2025-09-15 13092.5
1749 2025-09-16 13092.5
2025-09-16 19:17:52,974 - IOOppi_data - INFO : save new data to db: IOOppi_ss_t: no new data
2025-09-16 19:17:52,974 - IOOppi_data - INFO : save diff data to db: IOOppi_ss_t: no diff data
2025-09-16 19:17:52,979 - IOOppi_data - INFO : save data to db IOOppi_ss_g data:
date value
1745 2025-09-12 13067.5
1746 2025-09-13 13067.5
1747 2025-09-14 13067.5
1748 2025-09-15 13092.5
1749 2025-09-16 13092.5
2025-09-16 19:18:04,118 - IOOppi_data - INFO : save new data to db: IOOppi_ss_g: no new data
2025-09-16 19:18:04,118 - IOOppi_data - INFO : save diff data to db: IOOppi_ss_g: no diff data
/usr/local/lib/python3.10/site-packages/urllib3/connectionpool.py:1056: InsecureRequestWarning: Unverified HTTPS request is being made to host 'www.100ppi.com'. Adding certificate verification is strongly advised. See: https://urllib3.readthedocs.io/en/1.26.x/advanced-usage.html#ssl-warnings
warnings.warn(
2025-09-16 19:18:04,772 - IOOppi_data - INFO : save data to db IOOppi_RS_t data:
date value
3255 2025-09-12 10000.00
3256 2025-09-13 10000.00
3257 2025-09-14 10000.00
3258 2025-09-15 10026.67
3259 2025-09-16 10166.67
2025-09-16 19:18:19,908 - IOOppi_data - INFO : save new data to db: IOOppi_RS_t: no new data
2025-09-16 19:18:19,908 - IOOppi_data - INFO : save diff data to db: IOOppi_RS_t: no diff data
2025-09-16 19:18:19,914 - IOOppi_data - INFO : save data to db IOOppi_RS_g data:
date value
3255 2025-09-12 10000.00
3256 2025-09-13 10000.00
3257 2025-09-14 10000.00
3258 2025-09-15 10026.67
3259 2025-09-16 10166.67
2025-09-16 19:18:24,896 - IOOppi_data - INFO : save new data to db: IOOppi_RS_g: no new data
2025-09-16 19:18:24,896 - IOOppi_data - INFO : save diff data to db: IOOppi_RS_g: no diff data
/usr/local/lib/python3.10/site-packages/urllib3/connectionpool.py:1056: InsecureRequestWarning: Unverified HTTPS request is being made to host 'www.100ppi.com'. Adding certificate verification is strongly advised. See: https://urllib3.readthedocs.io/en/1.26.x/advanced-usage.html#ssl-warnings
warnings.warn(
2025-09-16 19:18:26,525 - IOOppi_data - INFO : save data to db IOOppi_RM_t data:
date value
3378 2025-09-12 2680.0
3379 2025-09-13 2680.0
3380 2025-09-14 2680.0
3381 2025-09-15 2635.0
3382 2025-09-16 2655.0
2025-09-16 19:18:42,109 - IOOppi_data - INFO : save new data to db: IOOppi_RM_t: no new data
2025-09-16 19:18:42,109 - IOOppi_data - INFO : save diff data to db: IOOppi_RM_t: no diff data
2025-09-16 19:18:42,115 - IOOppi_data - INFO : save data to db IOOppi_RM_g data:
date value
3378 2025-09-12 2680.0
3379 2025-09-13 2680.0
3380 2025-09-14 2680.0
3381 2025-09-15 2635.0
3382 2025-09-16 2655.0
2025-09-16 19:19:24,605 - IOOppi_data - INFO : save new data to db: IOOppi_RM_g: no new data
2025-09-16 19:19:24,605 - IOOppi_data - INFO : save diff data to db: IOOppi_RM_g: no diff data
/usr/local/lib/python3.10/site-packages/urllib3/connectionpool.py:1056: InsecureRequestWarning: Unverified HTTPS request is being made to host 'www.100ppi.com'. Adding certificate verification is strongly advised. See: https://urllib3.readthedocs.io/en/1.26.x/advanced-usage.html#ssl-warnings
warnings.warn(
2025-09-16 19:19:25,199 - IOOppi_data - INFO : save data to db IOOppi_SA_t data:
date value
1582 2025-09-12 1262.5
1583 2025-09-13 1262.5
1584 2025-09-14 1262.5
1585 2025-09-15 1262.5
1586 2025-09-16 1262.5
2025-09-16 19:19:32,225 - IOOppi_data - INFO : save new data to db: IOOppi_SA_t: no new data
2025-09-16 19:19:32,225 - IOOppi_data - INFO : save diff data to db: IOOppi_SA_t: no diff data
2025-09-16 19:19:32,231 - IOOppi_data - INFO : save data to db IOOppi_SA_g data:
date value
1582 2025-09-12 1262.5
1583 2025-09-13 1262.5
1584 2025-09-14 1262.5
1585 2025-09-15 1262.5
1586 2025-09-16 1262.5
2025-09-16 19:19:33,300 - IOOppi_data - INFO : save new data to db: IOOppi_SA_g: no new data
2025-09-16 19:19:33,300 - IOOppi_data - INFO : save diff data to db: IOOppi_SA_g: no diff data
/usr/local/lib/python3.10/site-packages/urllib3/connectionpool.py:1056: InsecureRequestWarning: Unverified HTTPS request is being made to host 'www.100ppi.com'. Adding certificate verification is strongly advised. See: https://urllib3.readthedocs.io/en/1.26.x/advanced-usage.html#ssl-warnings
warnings.warn(
2025-09-16 19:19:33,889 - IOOppi_data - INFO : save data to db IOOppi_PF_t data:
date value
1495 2025-09-12 6457.00
1496 2025-09-13 6457.00
1497 2025-09-14 6457.00
1498 2025-09-15 6471.00
1499 2025-09-16 6478.34
2025-09-16 19:19:38,580 - IOOppi_data - INFO : save new data to db: IOOppi_PF_t: no new data
2025-09-16 19:19:38,581 - IOOppi_data - INFO : save diff data to db: IOOppi_PF_t: no diff data
2025-09-16 19:19:38,586 - IOOppi_data - INFO : save data to db IOOppi_PF_g data:
date value
1495 2025-09-12 6457.00
1496 2025-09-13 6457.00
1497 2025-09-14 6457.00
1498 2025-09-15 6471.00
1499 2025-09-16 6478.34
2025-09-16 19:19:39,050 - IOOppi_data - INFO : save new data to db: IOOppi_PF_g: no new data
2025-09-16 19:19:39,050 - IOOppi_data - INFO : save diff data to db: IOOppi_PF_g: no diff data
/usr/local/lib/python3.10/site-packages/urllib3/connectionpool.py:1056: InsecureRequestWarning: Unverified HTTPS request is being made to host 'www.100ppi.com'. Adding certificate verification is strongly advised. See: https://urllib3.readthedocs.io/en/1.26.x/advanced-usage.html#ssl-warnings
warnings.warn(
2025-09-16 19:19:39,618 - IOOppi_data - INFO : save data to db IOOppi_m_t data:
date value
3868 2025-09-12 3060.0
3869 2025-09-13 3060.0
3870 2025-09-14 3060.0
3871 2025-09-15 3058.0
3872 2025-09-16 3056.0
2025-09-16 19:19:41,577 - IOOppi_data - INFO : save new data to db: IOOppi_m_t: no new data
2025-09-16 19:19:41,577 - IOOppi_data - INFO : save diff data to db: IOOppi_m_t: no diff data
2025-09-16 19:19:41,582 - IOOppi_data - INFO : save data to db IOOppi_m_g data:
date value
3868 2025-09-12 3060.0
3869 2025-09-13 3060.0
3870 2025-09-14 3060.0
3871 2025-09-15 3058.0
3872 2025-09-16 3056.0
2025-09-16 19:19:59,705 - IOOppi_data - INFO : save new data to db: IOOppi_m_g: no new data
2025-09-16 19:19:59,705 - IOOppi_data - INFO : save diff data to db: IOOppi_m_g: no diff data
/usr/local/lib/python3.10/site-packages/urllib3/connectionpool.py:1056: InsecureRequestWarning: Unverified HTTPS request is being made to host 'www.100ppi.com'. Adding certificate verification is strongly advised. See: https://urllib3.readthedocs.io/en/1.26.x/advanced-usage.html#ssl-warnings
warnings.warn(
2025-09-16 19:20:00,322 - IOOppi_data - INFO : save data to db IOOppi_y_t data:
date value
3638 2025-09-12 8398.0
3639 2025-09-13 8398.0
3640 2025-09-14 8398.0
3641 2025-09-15 8448.0
3642 2025-09-16 8508.0
2025-09-16 19:20:12,449 - IOOppi_data - INFO : save new data to db: IOOppi_y_t: no new data
2025-09-16 19:20:12,449 - IOOppi_data - INFO : save diff data to db: IOOppi_y_t: no diff data
2025-09-16 19:20:12,455 - IOOppi_data - INFO : save data to db IOOppi_y_g data:
date value
3638 2025-09-12 8398.0
3639 2025-09-13 8398.0
3640 2025-09-14 8398.0
3641 2025-09-15 8448.0
3642 2025-09-16 8508.0
2025-09-16 19:20:18,239 - IOOppi_data - INFO : save new data to db: IOOppi_y_g: no new data
2025-09-16 19:20:18,239 - IOOppi_data - INFO : save diff data to db: IOOppi_y_g: no diff data
/usr/local/lib/python3.10/site-packages/urllib3/connectionpool.py:1056: InsecureRequestWarning: Unverified HTTPS request is being made to host 'www.100ppi.com'. Adding certificate verification is strongly advised. See: https://urllib3.readthedocs.io/en/1.26.x/advanced-usage.html#ssl-warnings
warnings.warn(
2025-09-16 19:20:19,727 - IOOppi_data - INFO : save data to db IOOppi_a_t data:
date value
3604 2025-09-12 4305.0
3605 2025-09-13 4305.0
3606 2025-09-14 4305.0
3607 2025-09-15 4305.0
3608 2025-09-16 4305.0
2025-09-16 19:20:27,400 - IOOppi_data - INFO : save new data to db: IOOppi_a_t: no new data
2025-09-16 19:20:27,401 - IOOppi_data - INFO : save diff data to db: IOOppi_a_t: no diff data
2025-09-16 19:20:27,406 - IOOppi_data - INFO : save data to db IOOppi_a_g data:
date value
3604 2025-09-12 4305.0
3605 2025-09-13 4305.0
3606 2025-09-14 4305.0
3607 2025-09-15 4305.0
3608 2025-09-16 4305.0
2025-09-16 19:20:32,096 - IOOppi_data - INFO : save new data to db: IOOppi_a_g: no new data
2025-09-16 19:20:32,096 - IOOppi_data - INFO : save diff data to db: IOOppi_a_g: no diff data
/usr/local/lib/python3.10/site-packages/urllib3/connectionpool.py:1056: InsecureRequestWarning: Unverified HTTPS request is being made to host 'www.100ppi.com'. Adding certificate verification is strongly advised. See: https://urllib3.readthedocs.io/en/1.26.x/advanced-usage.html#ssl-warnings
warnings.warn(
2025-09-16 19:20:32,729 - IOOppi_data - INFO : save data to db IOOppi_SF_t data:
date value
2981 2025-09-12 5245.71
2982 2025-09-13 5245.71
2983 2025-09-14 5245.71
2984 2025-09-15 5245.71
2985 2025-09-16 5245.71
2025-09-16 19:20:52,068 - IOOppi_data - INFO : save new data to db: IOOppi_SF_t: no new data
2025-09-16 19:20:52,068 - IOOppi_data - INFO : save diff data to db: IOOppi_SF_t: no diff data
2025-09-16 19:20:52,074 - IOOppi_data - INFO : save data to db IOOppi_SF_g data:
date value
2981 2025-09-12 5245.71
2982 2025-09-13 5245.71
2983 2025-09-14 5245.71
2984 2025-09-15 5245.71
2985 2025-09-16 5245.71
2025-09-16 19:20:54,011 - IOOppi_data - INFO : save new data to db: IOOppi_SF_g: no new data
2025-09-16 19:20:54,011 - IOOppi_data - INFO : save diff data to db: IOOppi_SF_g: no diff data
/usr/local/lib/python3.10/site-packages/urllib3/connectionpool.py:1056: InsecureRequestWarning: Unverified HTTPS request is being made to host 'www.100ppi.com'. Adding certificate verification is strongly advised. See: https://urllib3.readthedocs.io/en/1.26.x/advanced-usage.html#ssl-warnings
warnings.warn(
2025-09-16 19:20:54,775 - IOOppi_data - INFO : save data to db IOOppi_jd_t data:
date value
3181 2025-09-12 3675.0
3182 2025-09-13 3675.0
3183 2025-09-14 3675.0
3184 2025-09-15 3840.0
3185 2025-09-16 3935.0
2025-09-16 19:22:43,564 - IOOppi_data - INFO : save new data to db: IOOppi_jd_t: no new data
/root/project/IOOppi_data/IOOppi_request.py:308: SettingWithCopyWarning:
A value is trying to be set on a copy of a slice from a DataFrame.
Try using .loc[row_indexer,col_indexer] = value instead
See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy
diff_df.loc[:, 'index_code'] = index_code
/root/project/IOOppi_data/IOOppi_request.py:309: SettingWithCopyWarning:
A value is trying to be set on a copy of a slice from a DataFrame.
Try using .loc[row_indexer,col_indexer] = value instead
See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy
diff_df.loc[:, 'created_at'] = datetime.datetime.now()
/root/project/IOOppi_data/IOOppi_request.py:310: SettingWithCopyWarning:
A value is trying to be set on a copy of a slice from a DataFrame.
Try using .loc[row_indexer,col_indexer] = value instead
See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy
diff_df.loc[:, 'updated_at'] = datetime.datetime.now()
2025-09-16 19:22:48,976 - IOOppi_data - INFO : save diff data to db IOOppi_jd_t: date ... updated_at
39 2014-01-03 ... 2025-09-16 19:22:48.968469
458 2015-09-21 ... 2025-09-16 19:22:48.968469
549 2016-02-03 ... 2025-09-16 19:22:48.968469
693 2016-09-05 ... 2025-09-16 19:22:48.968469
696 2016-09-08 ... 2025-09-16 19:22:48.968469
[5 rows x 6 columns]
2025-09-16 19:22:49,005 - IOOppi_data - INFO : save data to db IOOppi_jd_g data:
date value
3181 2025-09-12 3675.0
3182 2025-09-13 3675.0
3183 2025-09-14 3675.0
3184 2025-09-15 3840.0
3185 2025-09-16 3935.0
2025-09-16 19:22:53,241 - IOOppi_data - INFO : save new data to db: IOOppi_jd_g: no new data
/root/project/IOOppi_data/IOOppi_request.py:308: SettingWithCopyWarning:
A value is trying to be set on a copy of a slice from a DataFrame.
Try using .loc[row_indexer,col_indexer] = value instead
See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy
diff_df.loc[:, 'index_code'] = index_code
/root/project/IOOppi_data/IOOppi_request.py:309: SettingWithCopyWarning:
A value is trying to be set on a copy of a slice from a DataFrame.
Try using .loc[row_indexer,col_indexer] = value instead
See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy
diff_df.loc[:, 'created_at'] = datetime.datetime.now()
/root/project/IOOppi_data/IOOppi_request.py:310: SettingWithCopyWarning:
A value is trying to be set on a copy of a slice from a DataFrame.
Try using .loc[row_indexer,col_indexer] = value instead
See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy
diff_df.loc[:, 'updated_at'] = datetime.datetime.now()
2025-09-16 19:23:00,893 - IOOppi_data - INFO : save diff data to db IOOppi_jd_g: date ... updated_at
39 2014-01-03 ... 2025-09-16 19:23:00.884518
458 2015-09-21 ... 2025-09-16 19:23:00.884518
549 2016-02-03 ... 2025-09-16 19:23:00.884518
693 2016-09-05 ... 2025-09-16 19:23:00.884518
696 2016-09-08 ... 2025-09-16 19:23:00.884518
[5 rows x 6 columns]
/usr/local/lib/python3.10/site-packages/urllib3/connectionpool.py:1056: InsecureRequestWarning: Unverified HTTPS request is being made to host 'www.100ppi.com'. Adding certificate verification is strongly advised. See: https://urllib3.readthedocs.io/en/1.26.x/advanced-usage.html#ssl-warnings
warnings.warn(
2025-09-16 19:23:02,674 - IOOppi_data - INFO : save data to db IOOppi_SI_t data:
date value
985 2025-09-12 9450.0
986 2025-09-13 9450.0
987 2025-09-14 9450.0
988 2025-09-15 9450.0
989 2025-09-16 9560.0
2025-09-16 19:23:03,556 - IOOppi_data - INFO : save new data to db: IOOppi_SI_t: no new data
2025-09-16 19:23:03,556 - IOOppi_data - INFO : save diff data to db: IOOppi_SI_t: no diff data
2025-09-16 19:23:03,561 - IOOppi_data - INFO : save data to db IOOppi_SI_g data:
date value
985 2025-09-12 9450.0
986 2025-09-13 9450.0
987 2025-09-14 9450.0
988 2025-09-15 9450.0
989 2025-09-16 9560.0
2025-09-16 19:23:04,275 - IOOppi_data - INFO : save new data to db: IOOppi_SI_g: no new data
2025-09-16 19:23:04,275 - IOOppi_data - INFO : save diff data to db: IOOppi_SI_g: no diff data
/usr/local/lib/python3.10/site-packages/urllib3/connectionpool.py:1056: InsecureRequestWarning: Unverified HTTPS request is being made to host 'www.100ppi.com'. Adding certificate verification is strongly advised. See: https://urllib3.readthedocs.io/en/1.26.x/advanced-usage.html#ssl-warnings
warnings.warn(
2025-09-16 19:23:04,918 - IOOppi_data - INFO : save data to db IOOppi_l_t data:
date value
3864 2025-09-12 7380.00
3865 2025-09-13 7380.00
3866 2025-09-14 7380.00
3867 2025-09-15 7378.33
3868 2025-09-16 7395.00
2025-09-16 19:23:15,330 - IOOppi_data - INFO : save new data to db: IOOppi_l_t: no new data
2025-09-16 19:23:15,330 - IOOppi_data - INFO : save diff data to db: IOOppi_l_t: no diff data
2025-09-16 19:23:15,336 - IOOppi_data - INFO : save data to db IOOppi_l_g data:
date value
3864 2025-09-12 7380.00
3865 2025-09-13 7380.00
3866 2025-09-14 7380.00
3867 2025-09-15 7378.33
3868 2025-09-16 7395.00
2025-09-16 19:23:23,176 - IOOppi_data - INFO : save new data to db: IOOppi_l_g: no new data
2025-09-16 19:23:23,176 - IOOppi_data - INFO : save diff data to db: IOOppi_l_g: no diff data
/usr/local/lib/python3.10/site-packages/urllib3/connectionpool.py:1056: InsecureRequestWarning: Unverified HTTPS request is being made to host 'www.100ppi.com'. Adding certificate verification is strongly advised. See: https://urllib3.readthedocs.io/en/1.26.x/advanced-usage.html#ssl-warnings
warnings.warn(
2025-09-16 19:23:23,883 - IOOppi_data - INFO : save data to db IOOppi_bu_t data:
date value
3202 2025-09-12 3635.00
3203 2025-09-13 3635.00
3204 2025-09-14 3633.33
3205 2025-09-15 3630.00
3206 2025-09-16 3630.00
2025-09-16 19:23:33,203 - IOOppi_data - INFO : save new data to db: IOOppi_bu_t: no new data
/root/project/IOOppi_data/IOOppi_request.py:308: SettingWithCopyWarning:
A value is trying to be set on a copy of a slice from a DataFrame.
Try using .loc[row_indexer,col_indexer] = value instead
See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy
diff_df.loc[:, 'index_code'] = index_code
/root/project/IOOppi_data/IOOppi_request.py:309: SettingWithCopyWarning:
A value is trying to be set on a copy of a slice from a DataFrame.
Try using .loc[row_indexer,col_indexer] = value instead
See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy
diff_df.loc[:, 'created_at'] = datetime.datetime.now()
/root/project/IOOppi_data/IOOppi_request.py:310: SettingWithCopyWarning:
A value is trying to be set on a copy of a slice from a DataFrame.
Try using .loc[row_indexer,col_indexer] = value instead
See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy
diff_df.loc[:, 'updated_at'] = datetime.datetime.now()
2025-09-16 19:23:33,220 - IOOppi_data - INFO : save diff data to db IOOppi_bu_t: date ... updated_at
2560 2023-12-09 ... 2025-09-16 19:23:33.213020
[1 rows x 6 columns]
2025-09-16 19:23:34,476 - IOOppi_data - INFO : save data to db IOOppi_bu_g data:
date value
3202 2025-09-12 3635.00
3203 2025-09-13 3635.00
3204 2025-09-14 3633.33
3205 2025-09-15 3630.00
3206 2025-09-16 3630.00
2025-09-16 19:23:46,816 - IOOppi_data - INFO : save new data to db: IOOppi_bu_g: no new data
2025-09-16 19:23:46,816 - IOOppi_data - INFO : save diff data to db: IOOppi_bu_g: no diff data
/usr/local/lib/python3.10/site-packages/urllib3/connectionpool.py:1056: InsecureRequestWarning: Unverified HTTPS request is being made to host 'www.100ppi.com'. Adding certificate verification is strongly advised. See: https://urllib3.readthedocs.io/en/1.26.x/advanced-usage.html#ssl-warnings
warnings.warn(
2025-09-16 19:23:47,449 - IOOppi_data - INFO : save data to db IOOppi_al_t data:
date value
3867 2025-09-12 21056.67
3868 2025-09-13 21056.67
3869 2025-09-14 21056.67
3870 2025-09-15 21056.67
3871 2025-09-16 20960.00
2025-09-16 19:23:50,686 - IOOppi_data - INFO : save new data to db: IOOppi_al_t: no new data
2025-09-16 19:23:50,686 - IOOppi_data - INFO : save diff data to db: IOOppi_al_t: no diff data
2025-09-16 19:23:50,692 - IOOppi_data - INFO : save data to db IOOppi_al_g data:
date value
3867 2025-09-12 21056.67
3868 2025-09-13 21056.67
3869 2025-09-14 21056.67
3870 2025-09-15 21056.67
3871 2025-09-16 20960.00
2025-09-16 19:23:57,230 - IOOppi_data - INFO : save new data to db: IOOppi_al_g: no new data
2025-09-16 19:23:57,230 - IOOppi_data - INFO : save diff data to db: IOOppi_al_g: no diff data
/usr/local/lib/python3.10/site-packages/urllib3/connectionpool.py:1056: InsecureRequestWarning: Unverified HTTPS request is being made to host 'www.100ppi.com'. Adding certificate verification is strongly advised. See: https://urllib3.readthedocs.io/en/1.26.x/advanced-usage.html#ssl-warnings
warnings.warn(
2025-09-16 19:23:57,910 - IOOppi_data - INFO : save data to db IOOppi_SM_t data:
date value
2981 2025-09-12 5666.0
2982 2025-09-13 5666.0
2983 2025-09-14 5666.0
2984 2025-09-15 5678.0
2985 2025-09-16 5752.0
2025-09-16 19:24:00,505 - IOOppi_data - INFO : save new data to db: IOOppi_SM_t: no new data
2025-09-16 19:24:00,505 - IOOppi_data - INFO : save diff data to db: IOOppi_SM_t: no diff data
2025-09-16 19:24:00,510 - IOOppi_data - INFO : save data to db IOOppi_SM_g data:
date value
2981 2025-09-12 5666.0
2982 2025-09-13 5666.0
2983 2025-09-14 5666.0
2984 2025-09-15 5678.0
2985 2025-09-16 5752.0
2025-09-16 19:24:11,788 - IOOppi_data - INFO : save new data to db: IOOppi_SM_g: no new data
2025-09-16 19:24:11,789 - IOOppi_data - INFO : save diff data to db: IOOppi_SM_g: no diff data
/usr/local/lib/python3.10/site-packages/urllib3/connectionpool.py:1056: InsecureRequestWarning: Unverified HTTPS request is being made to host 'www.100ppi.com'. Adding certificate verification is strongly advised. See: https://urllib3.readthedocs.io/en/1.26.x/advanced-usage.html#ssl-warnings
warnings.warn(
2025-09-16 19:24:12,500 - IOOppi_data - INFO : save data to db IOOppi_CY_t data:
date value
2256 2025-09-12 23550.0
2257 2025-09-13 23550.0
2258 2025-09-14 23550.0
2259 2025-09-15 23550.0
2260 2025-09-16 23550.0
2025-09-16 19:24:22,872 - IOOppi_data - INFO : save new data to db: IOOppi_CY_t: no new data
2025-09-16 19:24:22,872 - IOOppi_data - INFO : save diff data to db: IOOppi_CY_t: no diff data
2025-09-16 19:24:22,878 - IOOppi_data - INFO : save data to db IOOppi_CY_g data:
date value
2256 2025-09-12 23550.0
2257 2025-09-13 23550.0
2258 2025-09-14 23550.0
2259 2025-09-15 23550.0
2260 2025-09-16 23550.0
2025-09-16 19:24:26,251 - IOOppi_data - INFO : save new data to db: IOOppi_CY_g: no new data
2025-09-16 19:24:26,252 - IOOppi_data - INFO : save diff data to db: IOOppi_CY_g: no diff data
/usr/local/lib/python3.10/site-packages/urllib3/connectionpool.py:1056: InsecureRequestWarning: Unverified HTTPS request is being made to host 'www.100ppi.com'. Adding certificate verification is strongly advised. See: https://urllib3.readthedocs.io/en/1.26.x/advanced-usage.html#ssl-warnings
warnings.warn(
2025-09-16 19:24:27,100 - IOOppi_data - INFO : save data to db IOOppi_UR_t data:
date value
1771 2025-09-12 1673.75
1772 2025-09-13 1673.75
1773 2025-09-14 1673.75
1774 2025-09-15 1665.00
1775 2025-09-16 1665.00
2025-09-16 19:24:28,426 - IOOppi_data - INFO : save new data to db: IOOppi_UR_t: no new data
2025-09-16 19:24:28,426 - IOOppi_data - INFO : save diff data to db: IOOppi_UR_t: no diff data
2025-09-16 19:24:28,431 - IOOppi_data - INFO : save data to db IOOppi_UR_g data:
date value
1771 2025-09-12 1673.75
1772 2025-09-13 1673.75
1773 2025-09-14 1673.75
1774 2025-09-15 1665.00
1775 2025-09-16 1665.00
2025-09-16 19:24:35,429 - IOOppi_data - INFO : save new data to db: IOOppi_UR_g: no new data
2025-09-16 19:24:35,430 - IOOppi_data - INFO : save diff data to db: IOOppi_UR_g: no diff data
/usr/local/lib/python3.10/site-packages/urllib3/connectionpool.py:1056: InsecureRequestWarning: Unverified HTTPS request is being made to host 'www.100ppi.com'. Adding certificate verification is strongly advised. See: https://urllib3.readthedocs.io/en/1.26.x/advanced-usage.html#ssl-warnings
warnings.warn(
2025-09-16 19:24:36,786 - IOOppi_data - INFO : save data to db IOOppi_ni_t data:
date value
2843 2025-09-12 123316.67
2844 2025-09-13 123316.67
2845 2025-09-14 123316.67
2846 2025-09-15 123533.33
2847 2025-09-16 123750.00
2025-09-16 19:24:56,629 - IOOppi_data - INFO : save new data to db: IOOppi_ni_t: no new data
2025-09-16 19:24:56,629 - IOOppi_data - INFO : save diff data to db: IOOppi_ni_t: no diff data
2025-09-16 19:24:56,634 - IOOppi_data - INFO : save data to db IOOppi_ni_g data:
date value
2843 2025-09-12 123316.67
2844 2025-09-13 123316.67
2845 2025-09-14 123316.67
2846 2025-09-15 123533.33
2847 2025-09-16 123750.00
2025-09-16 19:25:06,883 - IOOppi_data - INFO : save new data to db IOOppi_ni_g: date ... updated_at
2847 2025-09-13 ... 2025-09-16 19:25:06.877113
2848 2025-09-14 ... 2025-09-16 19:25:06.877113
2849 2025-09-15 ... 2025-09-16 19:25:06.877113
2850 2025-09-16 ... 2025-09-16 19:25:06.877113
[4 rows x 5 columns]
2025-09-16 19:25:07,718 - IOOppi_data - INFO : save diff data to db: IOOppi_ni_g: no diff data
/usr/local/lib/python3.10/site-packages/urllib3/connectionpool.py:1056: InsecureRequestWarning: Unverified HTTPS request is being made to host 'www.100ppi.com'. Adding certificate verification is strongly advised. See: https://urllib3.readthedocs.io/en/1.26.x/advanced-usage.html#ssl-warnings
warnings.warn(
2025-09-16 19:25:08,349 - IOOppi_data - INFO : save data to db IOOppi_v_t data:
date value
3868 2025-09-12 4635.0
3869 2025-09-13 4635.0
3870 2025-09-14 4635.0
3871 2025-09-15 4660.0
3872 2025-09-16 4704.0
2025-09-16 19:25:13,092 - IOOppi_data - INFO : save new data to db IOOppi_v_t: date value ... created_at updated_at
3869 2025-09-13 4635.0 ... 2025-09-16 19:25:13.083716 2025-09-16 19:25:13.084102
3870 2025-09-14 4635.0 ... 2025-09-16 19:25:13.083716 2025-09-16 19:25:13.084102
3871 2025-09-15 4660.0 ... 2025-09-16 19:25:13.083716 2025-09-16 19:25:13.084102
3872 2025-09-16 4704.0 ... 2025-09-16 19:25:13.083716 2025-09-16 19:25:13.084102
[4 rows x 5 columns]
2025-09-16 19:25:13,111 - IOOppi_data - INFO : save diff data to db: IOOppi_v_t: no diff data
2025-09-16 19:25:13,116 - IOOppi_data - INFO : save data to db IOOppi_v_g data:
date value
3868 2025-09-12 4635.0
3869 2025-09-13 4635.0
3870 2025-09-14 4635.0
3871 2025-09-15 4660.0
3872 2025-09-16 4704.0
2025-09-16 19:25:39,492 - IOOppi_data - INFO : save new data to db IOOppi_v_g: date value ... created_at updated_at
3872 2025-09-13 4635.0 ... 2025-09-16 19:25:39.484857 2025-09-16 19:25:39.485268
3873 2025-09-14 4635.0 ... 2025-09-16 19:25:39.484857 2025-09-16 19:25:39.485268
3874 2025-09-15 4660.0 ... 2025-09-16 19:25:39.484857 2025-09-16 19:25:39.485268
3875 2025-09-16 4704.0 ... 2025-09-16 19:25:39.484857 2025-09-16 19:25:39.485268
[4 rows x 5 columns]
2025-09-16 19:25:39,511 - IOOppi_data - INFO : save diff data to db: IOOppi_v_g: no diff data
/usr/local/lib/python3.10/site-packages/urllib3/connectionpool.py:1056: InsecureRequestWarning: Unverified HTTPS request is being made to host 'www.100ppi.com'. Adding certificate verification is strongly advised. See: https://urllib3.readthedocs.io/en/1.26.x/advanced-usage.html#ssl-warnings
warnings.warn(
2025-09-16 19:25:40,148 - IOOppi_data - INFO : save data to db IOOppi_pp_t data:
date value
3107 2025-09-12 7106.67
3108 2025-09-13 7106.67
3109 2025-09-14 7106.67
3110 2025-09-15 7106.67
3111 2025-09-16 7100.00
2025-09-16 19:25:45,592 - IOOppi_data - INFO : save new data to db IOOppi_pp_t: date value ... created_at updated_at
3108 2025-09-13 7106.67 ... 2025-09-16 19:25:45.585266 2025-09-16 19:25:45.585671
3109 2025-09-14 7106.67 ... 2025-09-16 19:25:45.585266 2025-09-16 19:25:45.585671
3110 2025-09-15 7106.67 ... 2025-09-16 19:25:45.585266 2025-09-16 19:25:45.585671
3111 2025-09-16 7100.00 ... 2025-09-16 19:25:45.585266 2025-09-16 19:25:45.585671
[4 rows x 5 columns]
2025-09-16 19:25:46,225 - IOOppi_data - INFO : save diff data to db: IOOppi_pp_t: no diff data
2025-09-16 19:25:46,231 - IOOppi_data - INFO : save data to db IOOppi_pp_g data:
date value
3107 2025-09-12 7106.67
3108 2025-09-13 7106.67
3109 2025-09-14 7106.67
3110 2025-09-15 7106.67
3111 2025-09-16 7100.00
2025-09-16 19:25:48,824 - IOOppi_data - INFO : save new data to db IOOppi_pp_g: date value ... created_at updated_at
3111 2025-09-13 7106.67 ... 2025-09-16 19:25:48.814757 2025-09-16 19:25:48.815141
3112 2025-09-14 7106.67 ... 2025-09-16 19:25:48.814757 2025-09-16 19:25:48.815141
3113 2025-09-15 7106.67 ... 2025-09-16 19:25:48.814757 2025-09-16 19:25:48.815141
3114 2025-09-16 7100.00 ... 2025-09-16 19:25:48.814757 2025-09-16 19:25:48.815141
[4 rows x 5 columns]
2025-09-16 19:25:48,842 - IOOppi_data - INFO : save diff data to db: IOOppi_pp_g: no diff data
/usr/local/lib/python3.10/site-packages/urllib3/connectionpool.py:1056: InsecureRequestWarning: Unverified HTTPS request is being made to host 'www.100ppi.com'. Adding certificate verification is strongly advised. See: https://urllib3.readthedocs.io/en/1.26.x/advanced-usage.html#ssl-warnings
warnings.warn(
2025-09-16 19:25:49,446 - IOOppi_data - INFO : save data to db IOOppi_CF_t data:
date value
3869 2025-09-12 15254.00
3870 2025-09-13 15254.00
3871 2025-09-14 15254.00
3872 2025-09-15 15255.67
3873 2025-09-16 15299.83
2025-09-16 19:33:21,966 - IOOppi_data - INFO : save new data to db IOOppi_CF_t: date ... updated_at
3870 2025-09-13 ... 2025-09-16 19:33:21.959184
3871 2025-09-14 ... 2025-09-16 19:33:21.959184
3872 2025-09-15 ... 2025-09-16 19:33:21.959184
3873 2025-09-16 ... 2025-09-16 19:33:21.959184
[4 rows x 5 columns]
2025-09-16 19:33:23,419 - IOOppi_data - INFO : save diff data to db: IOOppi_CF_t: no diff data
2025-09-16 19:33:23,425 - IOOppi_data - INFO : save data to db IOOppi_CF_g data:
date value
3869 2025-09-12 15254.00
3870 2025-09-13 15254.00
3871 2025-09-14 15254.00
3872 2025-09-15 15255.67
3873 2025-09-16 15299.83
2025-09-16 19:33:36,840 - IOOppi_data - INFO : save new data to db IOOppi_CF_g: date ... updated_at
3874 2025-09-13 ... 2025-09-16 19:33:36.833844
3875 2025-09-14 ... 2025-09-16 19:33:36.833844
3876 2025-09-15 ... 2025-09-16 19:33:36.833844
3877 2025-09-16 ... 2025-09-16 19:33:36.833844
[4 rows x 5 columns]
2025-09-16 19:33:51,238 - IOOppi_data - INFO : save diff data to db: IOOppi_CF_g: no diff data
/usr/local/lib/python3.10/site-packages/urllib3/connectionpool.py:1056: InsecureRequestWarning: Unverified HTTPS request is being made to host 'www.100ppi.com'. Adding certificate verification is strongly advised. See: https://urllib3.readthedocs.io/en/1.26.x/advanced-usage.html#ssl-warnings
warnings.warn(
2025-09-16 19:33:51,808 - IOOppi_data - INFO : save data to db IOOppi_pb_t data:
date value
3814 2025-09-12 16850.00
3815 2025-09-13 16850.00
3816 2025-09-14 16850.00
3817 2025-09-15 17037.50
3818 2025-09-16 17031.25
2025-09-16 19:34:18,969 - IOOppi_data - INFO : save new data to db IOOppi_pb_t: date ... updated_at
3815 2025-09-13 ... 2025-09-16 19:34:18.962148
3816 2025-09-14 ... 2025-09-16 19:34:18.962148
3817 2025-09-15 ... 2025-09-16 19:34:18.962148
3818 2025-09-16 ... 2025-09-16 19:34:18.962148
[4 rows x 5 columns]
2025-09-16 19:34:20,418 - IOOppi_data - INFO : save diff data to db: IOOppi_pb_t: no diff data
2025-09-16 19:34:20,425 - IOOppi_data - INFO : save data to db IOOppi_pb_g data:
date value
3814 2025-09-12 16850.00
3815 2025-09-13 16850.00
3816 2025-09-14 16850.00
3817 2025-09-15 17037.50
3818 2025-09-16 17031.25
2025-09-16 19:34:28,472 - IOOppi_data - INFO : save new data to db IOOppi_pb_g: date ... updated_at
3818 2025-09-13 ... 2025-09-16 19:34:28.465967
3819 2025-09-14 ... 2025-09-16 19:34:28.465967
3820 2025-09-15 ... 2025-09-16 19:34:28.465967
3821 2025-09-16 ... 2025-09-16 19:34:28.465967
[4 rows x 5 columns]
2025-09-16 19:34:28,492 - IOOppi_data - INFO : save diff data to db: IOOppi_pb_g: no diff data
/usr/local/lib/python3.10/site-packages/urllib3/connectionpool.py:1056: InsecureRequestWarning: Unverified HTTPS request is being made to host 'www.100ppi.com'. Adding certificate verification is strongly advised. See: https://urllib3.readthedocs.io/en/1.26.x/advanced-usage.html#ssl-warnings
warnings.warn(
2025-09-16 19:34:29,172 - IOOppi_data - INFO : save data to db IOOppi_hc_t data:
date value
3089 2025-09-12 3430.0
3090 2025-09-13 3430.0
3091 2025-09-14 3430.0
3092 2025-09-15 3430.0
3093 2025-09-16 3430.0
2025-09-16 19:34:45,932 - IOOppi_data - INFO : save new data to db IOOppi_hc_t: date value ... created_at updated_at
3090 2025-09-13 3430.0 ... 2025-09-16 19:34:45.925265 2025-09-16 19:34:45.925693
3091 2025-09-14 3430.0 ... 2025-09-16 19:34:45.925265 2025-09-16 19:34:45.925693
3092 2025-09-15 3430.0 ... 2025-09-16 19:34:45.925265 2025-09-16 19:34:45.925693
3093 2025-09-16 3430.0 ... 2025-09-16 19:34:45.925265 2025-09-16 19:34:45.925693
[4 rows x 5 columns]
2025-09-16 19:34:47,176 - IOOppi_data - INFO : save diff data to db: IOOppi_hc_t: no diff data
2025-09-16 19:34:47,183 - IOOppi_data - INFO : save data to db IOOppi_hc_g data:
date value
3089 2025-09-12 3430.0
3090 2025-09-13 3430.0
3091 2025-09-14 3430.0
3092 2025-09-15 3430.0
3093 2025-09-16 3430.0
2025-09-16 19:34:48,919 - IOOppi_data - INFO : save new data to db IOOppi_hc_g: date value ... created_at updated_at
3093 2025-09-13 3430.0 ... 2025-09-16 19:34:48.911132 2025-09-16 19:34:48.911510
3094 2025-09-14 3430.0 ... 2025-09-16 19:34:48.911132 2025-09-16 19:34:48.911510
3095 2025-09-15 3430.0 ... 2025-09-16 19:34:48.911132 2025-09-16 19:34:48.911510
3096 2025-09-16 3430.0 ... 2025-09-16 19:34:48.911132 2025-09-16 19:34:48.911510
[4 rows x 5 columns]
2025-09-16 19:34:48,937 - IOOppi_data - INFO : save diff data to db: IOOppi_hc_g: no diff data
/usr/local/lib/python3.10/site-packages/urllib3/connectionpool.py:1056: InsecureRequestWarning: Unverified HTTPS request is being made to host 'www.100ppi.com'. Adding certificate verification is strongly advised. See: https://urllib3.readthedocs.io/en/1.26.x/advanced-usage.html#ssl-warnings
warnings.warn(
2025-09-16 19:34:49,576 - IOOppi_data - INFO : save data to db IOOppi_fu_t data:
date value
3369 2025-09-12 5412.5
3370 2025-09-13 5412.5
3371 2025-09-14 5412.5
3372 2025-09-15 5412.5
3373 2025-09-16 5412.5
2025-09-16 19:35:53,154 - IOOppi_data - INFO : save new data to db IOOppi_fu_t: date value ... created_at updated_at
3370 2025-09-13 5412.5 ... 2025-09-16 19:35:53.146188 2025-09-16 19:35:53.146616
3371 2025-09-14 5412.5 ... 2025-09-16 19:35:53.146188 2025-09-16 19:35:53.146616
3372 2025-09-15 5412.5 ... 2025-09-16 19:35:53.146188 2025-09-16 19:35:53.146616
3373 2025-09-16 5412.5 ... 2025-09-16 19:35:53.146188 2025-09-16 19:35:53.146616
[4 rows x 5 columns]
2025-09-16 19:35:55,421 - IOOppi_data - INFO : save diff data to db: IOOppi_fu_t: no diff data
2025-09-16 19:35:55,427 - IOOppi_data - INFO : save data to db IOOppi_fu_g data:
date value
3369 2025-09-12 5412.5
3370 2025-09-13 5412.5
3371 2025-09-14 5412.5
3372 2025-09-15 5412.5
3373 2025-09-16 5412.5
2025-09-16 19:36:06,123 - IOOppi_data - INFO : save new data to db IOOppi_fu_g: date value ... created_at updated_at
3857 2025-09-13 5412.5 ... 2025-09-16 19:36:06.115742 2025-09-16 19:36:06.116206
3858 2025-09-14 5412.5 ... 2025-09-16 19:36:06.115742 2025-09-16 19:36:06.116206
3859 2025-09-15 5412.5 ... 2025-09-16 19:36:06.115742 2025-09-16 19:36:06.116206
3860 2025-09-16 5412.5 ... 2025-09-16 19:36:06.115742 2025-09-16 19:36:06.116206
[4 rows x 5 columns]
2025-09-16 19:36:06,625 - IOOppi_data - INFO : save diff data to db: IOOppi_fu_g: no diff data
/usr/local/lib/python3.10/site-packages/urllib3/connectionpool.py:1056: InsecureRequestWarning: Unverified HTTPS request is being made to host 'www.100ppi.com'. Adding certificate verification is strongly advised. See: https://urllib3.readthedocs.io/en/1.26.x/advanced-usage.html#ssl-warnings
warnings.warn(
2025-09-16 19:36:07,210 - IOOppi_data - INFO : save data to db IOOppi_lh_t data:
date value
1433 2025-09-12 13480.0
1434 2025-09-13 13480.0
1435 2025-09-14 13480.0
1436 2025-09-15 13450.0
1437 2025-09-16 13400.0
2025-09-16 19:36:09,746 - IOOppi_data - INFO : save new data to db IOOppi_lh_t: date value ... created_at updated_at
1434 2025-09-13 13480.0 ... 2025-09-16 19:36:09.739147 2025-09-16 19:36:09.739525
1435 2025-09-14 13480.0 ... 2025-09-16 19:36:09.739147 2025-09-16 19:36:09.739525
1436 2025-09-15 13450.0 ... 2025-09-16 19:36:09.739147 2025-09-16 19:36:09.739525
1437 2025-09-16 13400.0 ... 2025-09-16 19:36:09.739147 2025-09-16 19:36:09.739525
[4 rows x 5 columns]
/root/project/IOOppi_data/IOOppi_request.py:308: SettingWithCopyWarning:
A value is trying to be set on a copy of a slice from a DataFrame.
Try using .loc[row_indexer,col_indexer] = value instead
See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy
diff_df.loc[:, 'index_code'] = index_code
/root/project/IOOppi_data/IOOppi_request.py:309: SettingWithCopyWarning:
A value is trying to be set on a copy of a slice from a DataFrame.
Try using .loc[row_indexer,col_indexer] = value instead
See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy
diff_df.loc[:, 'created_at'] = datetime.datetime.now()
/root/project/IOOppi_data/IOOppi_request.py:310: SettingWithCopyWarning:
A value is trying to be set on a copy of a slice from a DataFrame.
Try using .loc[row_indexer,col_indexer] = value instead
See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy
diff_df.loc[:, 'updated_at'] = datetime.datetime.now()
2025-09-16 19:38:11,960 - IOOppi_data - INFO : save diff data to db IOOppi_lh_t: date ... updated_at
116 2021-07-05 ... 2025-09-16 19:38:11.952116
117 2021-07-06 ... 2025-09-16 19:38:11.952116
121 2021-07-12 ... 2025-09-16 19:38:11.952116
122 2021-07-13 ... 2025-09-16 19:38:11.952116
194 2021-11-01 ... 2025-09-16 19:38:11.952116
[5 rows x 6 columns]
2025-09-16 19:38:12,608 - IOOppi_data - INFO : save data to db IOOppi_lh_g data:
date value
1433 2025-09-12 13480.0
1434 2025-09-13 13480.0
1435 2025-09-14 13480.0
1436 2025-09-15 13450.0
1437 2025-09-16 13400.0
2025-09-16 19:38:13,895 - IOOppi_data - INFO : save new data to db IOOppi_lh_g: date value ... created_at updated_at
1437 2025-09-13 13480.0 ... 2025-09-16 19:38:13.887177 2025-09-16 19:38:13.887599
1438 2025-09-14 13480.0 ... 2025-09-16 19:38:13.887177 2025-09-16 19:38:13.887599
1439 2025-09-15 13450.0 ... 2025-09-16 19:38:13.887177 2025-09-16 19:38:13.887599
1440 2025-09-16 13400.0 ... 2025-09-16 19:38:13.887177 2025-09-16 19:38:13.887599
[4 rows x 5 columns]
/root/project/IOOppi_data/IOOppi_request.py:308: SettingWithCopyWarning:
A value is trying to be set on a copy of a slice from a DataFrame.
Try using .loc[row_indexer,col_indexer] = value instead
See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy
diff_df.loc[:, 'index_code'] = index_code
/root/project/IOOppi_data/IOOppi_request.py:309: SettingWithCopyWarning:
A value is trying to be set on a copy of a slice from a DataFrame.
Try using .loc[row_indexer,col_indexer] = value instead
See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy
diff_df.loc[:, 'created_at'] = datetime.datetime.now()
/root/project/IOOppi_data/IOOppi_request.py:310: SettingWithCopyWarning:
A value is trying to be set on a copy of a slice from a DataFrame.
Try using .loc[row_indexer,col_indexer] = value instead
See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy
diff_df.loc[:, 'updated_at'] = datetime.datetime.now()
2025-09-16 19:38:22,257 - IOOppi_data - INFO : save diff data to db IOOppi_lh_g: date ... updated_at
116 2021-07-05 ... 2025-09-16 19:38:22.249227
117 2021-07-06 ... 2025-09-16 19:38:22.249227
121 2021-07-12 ... 2025-09-16 19:38:22.249227
122 2021-07-13 ... 2025-09-16 19:38:22.249227
194 2021-11-01 ... 2025-09-16 19:38:22.249227
[5 rows x 6 columns]
/usr/local/lib/python3.10/site-packages/urllib3/connectionpool.py:1056: InsecureRequestWarning: Unverified HTTPS request is being made to host 'www.100ppi.com'. Adding certificate verification is strongly advised. See: https://urllib3.readthedocs.io/en/1.26.x/advanced-usage.html#ssl-warnings
warnings.warn(
2025-09-16 19:38:23,976 - IOOppi_data - INFO : save data to db IOOppi_cu_t data:
date value
3865 2025-09-12 80945.00
3866 2025-09-13 80945.00
3867 2025-09-14 80945.00
3868 2025-09-15 81000.00
3869 2025-09-16 81196.67
2025-09-16 19:38:55,968 - IOOppi_data - INFO : save new data to db IOOppi_cu_t: date ... updated_at
3866 2025-09-13 ... 2025-09-16 19:38:55.961914
3867 2025-09-14 ... 2025-09-16 19:38:55.961914
3868 2025-09-15 ... 2025-09-16 19:38:55.961914
3869 2025-09-16 ... 2025-09-16 19:38:55.961914
[4 rows x 5 columns]
2025-09-16 19:38:57,628 - IOOppi_data - INFO : save diff data to db: IOOppi_cu_t: no diff data
2025-09-16 19:38:57,634 - IOOppi_data - INFO : save data to db IOOppi_cu_g data:
date value
3865 2025-09-12 80945.00
3866 2025-09-13 80945.00
3867 2025-09-14 80945.00
3868 2025-09-15 81000.00
3869 2025-09-16 81196.67
2025-09-16 19:39:02,057 - IOOppi_data - INFO : save new data to db IOOppi_cu_g: date ... updated_at
3869 2025-09-13 ... 2025-09-16 19:39:02.050162
3870 2025-09-14 ... 2025-09-16 19:39:02.050162
3871 2025-09-15 ... 2025-09-16 19:39:02.050162
3872 2025-09-16 ... 2025-09-16 19:39:02.050162
[4 rows x 5 columns]
2025-09-16 19:39:15,567 - IOOppi_data - INFO : save diff data to db: IOOppi_cu_g: no diff data
/usr/local/lib/python3.10/site-packages/urllib3/connectionpool.py:1056: InsecureRequestWarning: Unverified HTTPS request is being made to host 'www.100ppi.com'. Adding certificate verification is strongly advised. See: https://urllib3.readthedocs.io/en/1.26.x/advanced-usage.html#ssl-warnings
warnings.warn(
2025-09-16 19:39:18,346 - IOOppi_data - INFO : save data to db IOOppi_PM_t data:
date value
2947 2024-06-26 2440.0
2948 2024-06-27 2460.0
2949 2024-06-28 2460.0
2950 2024-06-29 2460.0
2951 2024-06-30 2460.0
2025-09-16 19:39:40,166 - IOOppi_data - INFO : save new data to db: IOOppi_PM_t: no new data
2025-09-16 19:39:40,166 - IOOppi_data - INFO : save diff data to db: IOOppi_PM_t: no diff data
2025-09-16 19:39:40,172 - IOOppi_data - INFO : save data to db IOOppi_PM_g data:
date value
2947 2024-06-26 2440.0
2948 2024-06-27 2460.0
2949 2024-06-28 2460.0
2950 2024-06-29 2460.0
2951 2024-06-30 2460.0
2025-09-16 19:39:59,573 - IOOppi_data - INFO : save new data to db: IOOppi_PM_g: no new data
2025-09-16 19:39:59,573 - IOOppi_data - INFO : save diff data to db: IOOppi_PM_g: no diff data
/usr/local/lib/python3.10/site-packages/urllib3/connectionpool.py:1056: InsecureRequestWarning: Unverified HTTPS request is being made to host 'www.100ppi.com'. Adding certificate verification is strongly advised. See: https://urllib3.readthedocs.io/en/1.26.x/advanced-usage.html#ssl-warnings
warnings.warn(
2025-09-16 19:40:00,277 - IOOppi_data - INFO : save data to db IOOppi_sn_t data:
date value
2843 2025-09-12 274212.5
2844 2025-09-13 274212.5
2845 2025-09-14 274212.5
2846 2025-09-15 273537.5
2847 2025-09-16 272712.5
2025-09-16 19:40:04,262 - IOOppi_data - INFO : save new data to db IOOppi_sn_t: date ... updated_at
2844 2025-09-13 ... 2025-09-16 19:40:04.255840
2845 2025-09-14 ... 2025-09-16 19:40:04.255840
2846 2025-09-15 ... 2025-09-16 19:40:04.255840
2847 2025-09-16 ... 2025-09-16 19:40:04.255840
[4 rows x 5 columns]
2025-09-16 19:40:05,917 - IOOppi_data - INFO : save diff data to db: IOOppi_sn_t: no diff data
2025-09-16 19:40:05,923 - IOOppi_data - INFO : save data to db IOOppi_sn_g data:
date value
2843 2025-09-12 274212.5
2844 2025-09-13 274212.5
2845 2025-09-14 274212.5
2846 2025-09-15 273537.5
2847 2025-09-16 272712.5
2025-09-16 19:40:32,922 - IOOppi_data - INFO : save new data to db IOOppi_sn_g: date ... updated_at
2847 2025-09-13 ... 2025-09-16 19:40:32.914952
2848 2025-09-14 ... 2025-09-16 19:40:32.914952
2849 2025-09-15 ... 2025-09-16 19:40:32.914952
2850 2025-09-16 ... 2025-09-16 19:40:32.914952
[4 rows x 5 columns]
2025-09-16 19:40:33,145 - IOOppi_data - INFO : save diff data to db: IOOppi_sn_g: no diff data
/usr/local/lib/python3.10/site-packages/urllib3/connectionpool.py:1056: InsecureRequestWarning: Unverified HTTPS request is being made to host 'www.100ppi.com'. Adding certificate verification is strongly advised. See: https://urllib3.readthedocs.io/en/1.26.x/advanced-usage.html#ssl-warnings
warnings.warn(
2025-09-16 19:40:33,744 - IOOppi_data - INFO : save data to db IOOppi_zn_t data:
date value
3864 2025-09-12 22212.0
3865 2025-09-13 22212.0
3866 2025-09-14 22212.0
3867 2025-09-15 22212.0
3868 2025-09-16 22218.0
2025-09-16 19:40:57,176 - IOOppi_data - INFO : save new data to db IOOppi_zn_t: date value ... created_at updated_at
3865 2025-09-13 22212.0 ... 2025-09-16 19:40:57.167997 2025-09-16 19:40:57.168415
3866 2025-09-14 22212.0 ... 2025-09-16 19:40:57.167997 2025-09-16 19:40:57.168415
3867 2025-09-15 22212.0 ... 2025-09-16 19:40:57.167997 2025-09-16 19:40:57.168415
3868 2025-09-16 22218.0 ... 2025-09-16 19:40:57.167997 2025-09-16 19:40:57.168415
[4 rows x 5 columns]
2025-09-16 19:40:58,426 - IOOppi_data - INFO : save diff data to db: IOOppi_zn_t: no diff data
2025-09-16 19:40:58,433 - IOOppi_data - INFO : save data to db IOOppi_zn_g data:
date value
3864 2025-09-12 22212.0
3865 2025-09-13 22212.0
3866 2025-09-14 22212.0
3867 2025-09-15 22212.0
3868 2025-09-16 22218.0
2025-09-16 19:41:08,007 - IOOppi_data - INFO : save new data to db IOOppi_zn_g: date value ... created_at updated_at
3868 2025-09-13 22212.0 ... 2025-09-16 19:41:07.999754 2025-09-16 19:41:08.000152
3869 2025-09-14 22212.0 ... 2025-09-16 19:41:07.999754 2025-09-16 19:41:08.000152
3870 2025-09-15 22212.0 ... 2025-09-16 19:41:07.999754 2025-09-16 19:41:08.000152
3871 2025-09-16 22218.0 ... 2025-09-16 19:41:07.999754 2025-09-16 19:41:08.000152
[4 rows x 5 columns]
2025-09-16 19:41:08,026 - IOOppi_data - INFO : save diff data to db: IOOppi_zn_g: no diff data
/usr/local/lib/python3.10/site-packages/urllib3/connectionpool.py:1056: InsecureRequestWarning: Unverified HTTPS request is being made to host 'www.100ppi.com'. Adding certificate verification is strongly advised. See: https://urllib3.readthedocs.io/en/1.26.x/advanced-usage.html#ssl-warnings
warnings.warn(
2025-09-16 19:41:08,623 - IOOppi_data - INFO : save data to db IOOppi_wr_t data:
date value
3827 2025-09-12 3290.0
3828 2025-09-13 3290.0
3829 2025-09-14 3290.0
3830 2025-09-15 3315.0
3831 2025-09-16 3315.0
2025-09-16 19:41:12,315 - IOOppi_data - INFO : save new data to db IOOppi_wr_t: date value ... created_at updated_at
3828 2025-09-13 3290.0 ... 2025-09-16 19:41:12.307545 2025-09-16 19:41:12.307964
3829 2025-09-14 3290.0 ... 2025-09-16 19:41:12.307545 2025-09-16 19:41:12.307964
3830 2025-09-15 3315.0 ... 2025-09-16 19:41:12.307545 2025-09-16 19:41:12.307964
3831 2025-09-16 3315.0 ... 2025-09-16 19:41:12.307545 2025-09-16 19:41:12.307964
[4 rows x 5 columns]
2025-09-16 19:41:12,334 - IOOppi_data - INFO : save diff data to db: IOOppi_wr_t: no diff data
2025-09-16 19:41:12,340 - IOOppi_data - INFO : save data to db IOOppi_wr_g data:
date value
3827 2025-09-12 3290.0
3828 2025-09-13 3290.0
3829 2025-09-14 3290.0
3830 2025-09-15 3315.0
3831 2025-09-16 3315.0
2025-09-16 19:41:47,574 - IOOppi_data - INFO : save new data to db IOOppi_wr_g: date value ... created_at updated_at
3831 2025-09-13 3290.0 ... 2025-09-16 19:41:47.567032 2025-09-16 19:41:47.567438
3832 2025-09-14 3290.0 ... 2025-09-16 19:41:47.567032 2025-09-16 19:41:47.567438
3833 2025-09-15 3315.0 ... 2025-09-16 19:41:47.567032 2025-09-16 19:41:47.567438
3834 2025-09-16 3315.0 ... 2025-09-16 19:41:47.567032 2025-09-16 19:41:47.567438
[4 rows x 5 columns]
2025-09-16 19:41:47,800 - IOOppi_data - INFO : save diff data to db: IOOppi_wr_g: no diff data
/usr/local/lib/python3.10/site-packages/urllib3/connectionpool.py:1056: InsecureRequestWarning: Unverified HTTPS request is being made to host 'www.100ppi.com'. Adding certificate verification is strongly advised. See: https://urllib3.readthedocs.io/en/1.26.x/advanced-usage.html#ssl-warnings
warnings.warn(
2025-09-16 19:41:48,463 - IOOppi_data - INFO : save data to db IOOppi_pg_t data:
date value
1624 2025-09-12 4635.0
1625 2025-09-13 4635.0
1626 2025-09-14 4635.0
1627 2025-09-15 4662.5
1628 2025-09-16 4662.5
2025-09-16 19:41:57,380 - IOOppi_data - INFO : save new data to db IOOppi_pg_t: date value ... created_at updated_at
1625 2025-09-13 4635.0 ... 2025-09-16 19:41:57.372270 2025-09-16 19:41:57.372692
1626 2025-09-14 4635.0 ... 2025-09-16 19:41:57.372270 2025-09-16 19:41:57.372692
1627 2025-09-15 4662.5 ... 2025-09-16 19:41:57.372270 2025-09-16 19:41:57.372692
1628 2025-09-16 4662.5 ... 2025-09-16 19:41:57.372270 2025-09-16 19:41:57.372692
[4 rows x 5 columns]
2025-09-16 19:41:59,862 - IOOppi_data - INFO : save diff data to db: IOOppi_pg_t: no diff data
2025-09-16 19:41:59,868 - IOOppi_data - INFO : save data to db IOOppi_pg_g data:
date value
1624 2025-09-12 4635.0
1625 2025-09-13 4635.0
1626 2025-09-14 4635.0
1627 2025-09-15 4662.5
1628 2025-09-16 4662.5
2025-09-16 19:42:01,397 - IOOppi_data - INFO : save new data to db IOOppi_pg_g: date value ... created_at updated_at
1628 2025-09-13 4635.0 ... 2025-09-16 19:42:01.389167 2025-09-16 19:42:01.389584
1629 2025-09-14 4635.0 ... 2025-09-16 19:42:01.389167 2025-09-16 19:42:01.389584
1630 2025-09-15 4662.5 ... 2025-09-16 19:42:01.389167 2025-09-16 19:42:01.389584
1631 2025-09-16 4662.5 ... 2025-09-16 19:42:01.389167 2025-09-16 19:42:01.389584
[4 rows x 5 columns]
2025-09-16 19:42:01,415 - IOOppi_data - INFO : save diff data to db: IOOppi_pg_g: no diff data
/usr/local/lib/python3.10/site-packages/urllib3/connectionpool.py:1056: InsecureRequestWarning: Unverified HTTPS request is being made to host 'www.100ppi.com'. Adding certificate verification is strongly advised. See: https://urllib3.readthedocs.io/en/1.26.x/advanced-usage.html#ssl-warnings
warnings.warn(
2025-09-16 19:42:02,002 - IOOppi_data - INFO : save data to db IOOppi_cs_t data:
date value
2898 2025-09-12 2302.86
2899 2025-09-13 2302.86
2900 2025-09-14 2302.86
2901 2025-09-15 2300.00
2902 2025-09-16 2294.29
2025-09-16 19:42:10,069 - IOOppi_data - INFO : save new data to db IOOppi_cs_t: date value ... created_at updated_at
2899 2025-09-13 2302.86 ... 2025-09-16 19:42:10.061643 2025-09-16 19:42:10.062055
2900 2025-09-14 2302.86 ... 2025-09-16 19:42:10.061643 2025-09-16 19:42:10.062055
2901 2025-09-15 2300.00 ... 2025-09-16 19:42:10.061643 2025-09-16 19:42:10.062055
2902 2025-09-16 2294.29 ... 2025-09-16 19:42:10.061643 2025-09-16 19:42:10.062055
[4 rows x 5 columns]
/root/project/IOOppi_data/IOOppi_request.py:308: SettingWithCopyWarning:
A value is trying to be set on a copy of a slice from a DataFrame.
Try using .loc[row_indexer,col_indexer] = value instead
See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy
diff_df.loc[:, 'index_code'] = index_code
/root/project/IOOppi_data/IOOppi_request.py:309: SettingWithCopyWarning:
A value is trying to be set on a copy of a slice from a DataFrame.
Try using .loc[row_indexer,col_indexer] = value instead
See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy
diff_df.loc[:, 'created_at'] = datetime.datetime.now()
/root/project/IOOppi_data/IOOppi_request.py:310: SettingWithCopyWarning:
A value is trying to be set on a copy of a slice from a DataFrame.
Try using .loc[row_indexer,col_indexer] = value instead
See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy
diff_df.loc[:, 'updated_at'] = datetime.datetime.now()
2025-09-16 19:42:10,109 - IOOppi_data - INFO : save diff data to db IOOppi_cs_t: date ... updated_at
2898 2025-09-12 ... 2025-09-16 19:42:10.101598
[1 rows x 6 columns]
2025-09-16 19:42:11,770 - IOOppi_data - INFO : save data to db IOOppi_cs_g data:
date value
2898 2025-09-12 2302.86
2899 2025-09-13 2302.86
2900 2025-09-14 2302.86
2901 2025-09-15 2300.00
2902 2025-09-16 2294.29
2025-09-16 19:42:16,430 - IOOppi_data - INFO : save new data to db IOOppi_cs_g: date value ... created_at updated_at
2902 2025-09-13 2302.86 ... 2025-09-16 19:42:16.423176 2025-09-16 19:42:16.423555
2903 2025-09-14 2302.86 ... 2025-09-16 19:42:16.423176 2025-09-16 19:42:16.423555
2904 2025-09-15 2300.00 ... 2025-09-16 19:42:16.423176 2025-09-16 19:42:16.423555
2905 2025-09-16 2294.29 ... 2025-09-16 19:42:16.423176 2025-09-16 19:42:16.423555
[4 rows x 5 columns]
/root/project/IOOppi_data/IOOppi_request.py:308: SettingWithCopyWarning:
A value is trying to be set on a copy of a slice from a DataFrame.
Try using .loc[row_indexer,col_indexer] = value instead
See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy
diff_df.loc[:, 'index_code'] = index_code
/root/project/IOOppi_data/IOOppi_request.py:309: SettingWithCopyWarning:
A value is trying to be set on a copy of a slice from a DataFrame.
Try using .loc[row_indexer,col_indexer] = value instead
See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy
diff_df.loc[:, 'created_at'] = datetime.datetime.now()
/root/project/IOOppi_data/IOOppi_request.py:310: SettingWithCopyWarning:
A value is trying to be set on a copy of a slice from a DataFrame.
Try using .loc[row_indexer,col_indexer] = value instead
See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy
diff_df.loc[:, 'updated_at'] = datetime.datetime.now()
2025-09-16 19:42:18,112 - IOOppi_data - INFO : save diff data to db IOOppi_cs_g: date ... updated_at
2901 2025-09-12 ... 2025-09-16 19:42:18.104352
[1 rows x 6 columns]
/usr/local/lib/python3.10/site-packages/urllib3/connectionpool.py:1056: InsecureRequestWarning: Unverified HTTPS request is being made to host 'www.100ppi.com'. Adding certificate verification is strongly advised. See: https://urllib3.readthedocs.io/en/1.26.x/advanced-usage.html#ssl-warnings
warnings.warn(
2025-09-16 19:42:18,720 - IOOppi_data - INFO : save data to db IOOppi_cs_t data:
date value
2898 2025-09-12 2302.86
2899 2025-09-13 2302.86
2900 2025-09-14 2302.86
2901 2025-09-15 2300.00
2902 2025-09-16 2840.00
2025-09-16 19:42:33,684 - IOOppi_data - INFO : save new data to db: IOOppi_cs_t: no new data
/root/project/IOOppi_data/IOOppi_request.py:308: SettingWithCopyWarning:
A value is trying to be set on a copy of a slice from a DataFrame.
Try using .loc[row_indexer,col_indexer] = value instead
See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy
diff_df.loc[:, 'index_code'] = index_code
/root/project/IOOppi_data/IOOppi_request.py:309: SettingWithCopyWarning:
A value is trying to be set on a copy of a slice from a DataFrame.
Try using .loc[row_indexer,col_indexer] = value instead
See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy
diff_df.loc[:, 'created_at'] = datetime.datetime.now()
/root/project/IOOppi_data/IOOppi_request.py:310: SettingWithCopyWarning:
A value is trying to be set on a copy of a slice from a DataFrame.
Try using .loc[row_indexer,col_indexer] = value instead
See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy
diff_df.loc[:, 'updated_at'] = datetime.datetime.now()
2025-09-16 19:42:33,909 - IOOppi_data - INFO : save diff data to db IOOppi_cs_t: date ... updated_at
2902 2025-09-16 ... 2025-09-16 19:42:33.902342
[1 rows x 6 columns]
2025-09-16 19:42:34,954 - IOOppi_data - INFO : save data to db IOOppi_cs_g data:
date value
2898 2025-09-12 2302.86
2899 2025-09-13 2302.86
2900 2025-09-14 2302.86
2901 2025-09-15 2300.00
2902 2025-09-16 2840.00
2025-09-16 19:42:43,331 - IOOppi_data - INFO : save new data to db: IOOppi_cs_g: no new data
/root/project/IOOppi_data/IOOppi_request.py:308: SettingWithCopyWarning:
A value is trying to be set on a copy of a slice from a DataFrame.
Try using .loc[row_indexer,col_indexer] = value instead
See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy
diff_df.loc[:, 'index_code'] = index_code
/root/project/IOOppi_data/IOOppi_request.py:309: SettingWithCopyWarning:
A value is trying to be set on a copy of a slice from a DataFrame.
Try using .loc[row_indexer,col_indexer] = value instead
See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy
diff_df.loc[:, 'created_at'] = datetime.datetime.now()
/root/project/IOOppi_data/IOOppi_request.py:310: SettingWithCopyWarning:
A value is trying to be set on a copy of a slice from a DataFrame.
Try using .loc[row_indexer,col_indexer] = value instead
See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy
diff_df.loc[:, 'updated_at'] = datetime.datetime.now()
2025-09-16 19:42:44,171 - IOOppi_data - INFO : save diff data to db IOOppi_cs_g: date ... updated_at
2905 2025-09-16 ... 2025-09-16 19:42:44.163868
[1 rows x 6 columns]
/usr/local/lib/python3.10/site-packages/urllib3/connectionpool.py:1056: InsecureRequestWarning: Unverified HTTPS request is being made to host 'www.100ppi.com'. Adding certificate verification is strongly advised. See: https://urllib3.readthedocs.io/en/1.26.x/advanced-usage.html#ssl-warnings
warnings.warn(
2025-09-16 19:42:48,657 - IOOppi_data - INFO : save data to db IOOppi_RS_t data:
date value
3255 2025-09-12 10000.00
3256 2025-09-13 10000.00
3257 2025-09-14 10000.00
3258 2025-09-15 10026.67
3259 2025-09-16 10166.67
2025-09-16 19:43:03,375 - IOOppi_data - INFO : save new data to db: IOOppi_RS_t: no new data
2025-09-16 19:43:03,375 - IOOppi_data - INFO : save diff data to db: IOOppi_RS_t: no diff data
2025-09-16 19:43:03,381 - IOOppi_data - INFO : save data to db IOOppi_RS_g data:
date value
3255 2025-09-12 10000.00
3256 2025-09-13 10000.00
3257 2025-09-14 10000.00
3258 2025-09-15 10026.67
3259 2025-09-16 10166.67
2025-09-16 19:43:13,721 - IOOppi_data - INFO : save new data to db: IOOppi_RS_g: no new data
2025-09-16 19:43:13,721 - IOOppi_data - INFO : save diff data to db: IOOppi_RS_g: no diff data
/usr/local/lib/python3.10/site-packages/urllib3/connectionpool.py:1056: InsecureRequestWarning: Unverified HTTPS request is being made to host 'www.100ppi.com'. Adding certificate verification is strongly advised. See: https://urllib3.readthedocs.io/en/1.26.x/advanced-usage.html#ssl-warnings
warnings.warn(
2025-09-16 19:43:14,359 - IOOppi_data - INFO : save data to db IOOppi_eg_t data:
date value
1939 2025-09-12 4466.67
1940 2025-09-13 4466.67
1941 2025-09-14 4466.67
1942 2025-09-15 4458.33
1943 2025-09-16 4458.33
2025-09-16 19:43:21,949 - IOOppi_data - INFO : save new data to db IOOppi_eg_t: date value ... created_at updated_at
1940 2025-09-13 4466.67 ... 2025-09-16 19:43:21.941907 2025-09-16 19:43:21.942317
1941 2025-09-14 4466.67 ... 2025-09-16 19:43:21.941907 2025-09-16 19:43:21.942317
1942 2025-09-15 4458.33 ... 2025-09-16 19:43:21.941907 2025-09-16 19:43:21.942317
1943 2025-09-16 4458.33 ... 2025-09-16 19:43:21.941907 2025-09-16 19:43:21.942317
[4 rows x 5 columns]
2025-09-16 19:43:22,173 - IOOppi_data - INFO : save diff data to db: IOOppi_eg_t: no diff data
2025-09-16 19:43:22,179 - IOOppi_data - INFO : save data to db IOOppi_eg_g data:
date value
1939 2025-09-12 4466.67
1940 2025-09-13 4466.67
1941 2025-09-14 4466.67
1942 2025-09-15 4458.33
1943 2025-09-16 4458.33
2025-09-16 19:43:27,167 - IOOppi_data - INFO : save new data to db IOOppi_eg_g: date value ... created_at updated_at
1943 2025-09-13 4466.67 ... 2025-09-16 19:43:27.159839 2025-09-16 19:43:27.160255
1944 2025-09-14 4466.67 ... 2025-09-16 19:43:27.159839 2025-09-16 19:43:27.160255
1945 2025-09-15 4458.33 ... 2025-09-16 19:43:27.159839 2025-09-16 19:43:27.160255
1946 2025-09-16 4458.33 ... 2025-09-16 19:43:27.159839 2025-09-16 19:43:27.160255
[4 rows x 5 columns]
2025-09-16 19:43:27,392 - IOOppi_data - INFO : save diff data to db: IOOppi_eg_g: no diff data
/usr/local/lib/python3.10/site-packages/urllib3/connectionpool.py:1056: InsecureRequestWarning: Unverified HTTPS request is being made to host 'www.100ppi.com'. Adding certificate verification is strongly advised. See: https://urllib3.readthedocs.io/en/1.26.x/advanced-usage.html#ssl-warnings
warnings.warn(
2025-09-16 19:43:29,027 - IOOppi_data - INFO : save data to db IOOppi_sp_t data:
date value
1948 2025-09-12 5716.67
1949 2025-09-13 5716.67
1950 2025-09-14 5716.67
1951 2025-09-15 5716.67
1952 2025-09-16 5716.67
2025-09-16 19:43:34,308 - IOOppi_data - INFO : save new data to db IOOppi_sp_t: date value ... created_at updated_at
1949 2025-09-13 5716.67 ... 2025-09-16 19:43:34.300539 2025-09-16 19:43:34.300961
1950 2025-09-14 5716.67 ... 2025-09-16 19:43:34.300539 2025-09-16 19:43:34.300961
1951 2025-09-15 5716.67 ... 2025-09-16 19:43:34.300539 2025-09-16 19:43:34.300961
1952 2025-09-16 5716.67 ... 2025-09-16 19:43:34.300539 2025-09-16 19:43:34.300961
[4 rows x 5 columns]
2025-09-16 19:43:34,325 - IOOppi_data - INFO : save diff data to db: IOOppi_sp_t: no diff data
2025-09-16 19:43:34,330 - IOOppi_data - INFO : save data to db IOOppi_sp_g data:
date value
1948 2025-09-12 5716.67
1949 2025-09-13 5716.67
1950 2025-09-14 5716.67
1951 2025-09-15 5716.67
1952 2025-09-16 5716.67
2025-09-16 19:43:48,379 - IOOppi_data - INFO : save new data to db IOOppi_sp_g: date value ... created_at updated_at
1952 2025-09-13 5716.67 ... 2025-09-16 19:43:48.372350 2025-09-16 19:43:48.372754
1953 2025-09-14 5716.67 ... 2025-09-16 19:43:48.372350 2025-09-16 19:43:48.372754
1954 2025-09-15 5716.67 ... 2025-09-16 19:43:48.372350 2025-09-16 19:43:48.372754
1955 2025-09-16 5716.67 ... 2025-09-16 19:43:48.372350 2025-09-16 19:43:48.372754
[4 rows x 5 columns]
2025-09-16 19:43:48,602 - IOOppi_data - INFO : save diff data to db: IOOppi_sp_g: no diff data
/usr/local/lib/python3.10/site-packages/urllib3/connectionpool.py:1056: InsecureRequestWarning: Unverified HTTPS request is being made to host 'www.100ppi.com'. Adding certificate verification is strongly advised. See: https://urllib3.readthedocs.io/en/1.26.x/advanced-usage.html#ssl-warnings
warnings.warn(
2025-09-16 19:43:49,373 - IOOppi_data - INFO : save data to db IOOppi_p_t data:
date value
3616 2025-09-12 9354.0
3617 2025-09-13 9354.0
3618 2025-09-14 9354.0
3619 2025-09-15 9400.0
3620 2025-09-16 9516.0
2025-09-16 19:43:54,262 - IOOppi_data - INFO : save new data to db IOOppi_p_t: date value ... created_at updated_at
3617 2025-09-13 9354.0 ... 2025-09-16 19:43:54.254306 2025-09-16 19:43:54.254713
3618 2025-09-14 9354.0 ... 2025-09-16 19:43:54.254306 2025-09-16 19:43:54.254713
3619 2025-09-15 9400.0 ... 2025-09-16 19:43:54.254306 2025-09-16 19:43:54.254713
3620 2025-09-16 9516.0 ... 2025-09-16 19:43:54.254306 2025-09-16 19:43:54.254713
[4 rows x 5 columns]
2025-09-16 19:43:54,280 - IOOppi_data - INFO : save diff data to db: IOOppi_p_t: no diff data
2025-09-16 19:43:54,286 - IOOppi_data - INFO : save data to db IOOppi_p_g data:
date value
3616 2025-09-12 9354.0
3617 2025-09-13 9354.0
3618 2025-09-14 9354.0
3619 2025-09-15 9400.0
3620 2025-09-16 9516.0
2025-09-16 19:44:02,629 - IOOppi_data - INFO : save new data to db IOOppi_p_g: date value ... created_at updated_at
3620 2025-09-13 9354.0 ... 2025-09-16 19:44:02.621510 2025-09-16 19:44:02.621937
3621 2025-09-14 9354.0 ... 2025-09-16 19:44:02.621510 2025-09-16 19:44:02.621937
3622 2025-09-15 9400.0 ... 2025-09-16 19:44:02.621510 2025-09-16 19:44:02.621937
3623 2025-09-16 9516.0 ... 2025-09-16 19:44:02.621510 2025-09-16 19:44:02.621937
[4 rows x 5 columns]
2025-09-16 19:44:03,467 - IOOppi_data - INFO : save diff data to db: IOOppi_p_g: no diff data
Traceback (most recent call last):
File "/usr/local/lib/python3.10/site-packages/pymysql/connections.py", line 736, in _read_bytes
data = self._rfile.read(num_bytes)
File "/usr/local/lib/python3.10/socket.py", line 705, in readinto
return self._sock.recv_into(b)
ConnectionResetError: [Errno 104] Connection reset by peer
During handling of the above exception, another exception occurred:
Traceback (most recent call last):
File "/usr/local/lib/python3.10/site-packages/sqlalchemy/engine/base.py", line 1967, in _exec_single_context
self.dialect.do_execute(
File "/usr/local/lib/python3.10/site-packages/sqlalchemy/engine/default.py", line 951, in do_execute
cursor.execute(statement, parameters)
File "/usr/local/lib/python3.10/site-packages/pymysql/cursors.py", line 158, in execute
result = self._query(query)
File "/usr/local/lib/python3.10/site-packages/pymysql/cursors.py", line 325, in _query
conn.query(q)
File "/usr/local/lib/python3.10/site-packages/pymysql/connections.py", line 549, in query
self._affected_rows = self._read_query_result(unbuffered=unbuffered)
File "/usr/local/lib/python3.10/site-packages/pymysql/connections.py", line 779, in _read_query_result
result.read()
File "/usr/local/lib/python3.10/site-packages/pymysql/connections.py", line 1164, in read
self._read_result_packet(first_packet)
File "/usr/local/lib/python3.10/site-packages/pymysql/connections.py", line 1240, in _read_result_packet
self._read_rowdata_packet()
File "/usr/local/lib/python3.10/site-packages/pymysql/connections.py", line 1274, in _read_rowdata_packet
packet = self.connection._read_packet()
File "/usr/local/lib/python3.10/site-packages/pymysql/connections.py", line 715, in _read_packet
recv_data = self._read_bytes(bytes_to_read)
File "/usr/local/lib/python3.10/site-packages/pymysql/connections.py", line 742, in _read_bytes
raise err.OperationalError(
pymysql.err.OperationalError: (2013, 'Lost connection to MySQL server during query ([Errno 104] Connection reset by peer)')
The above exception was the direct cause of the following exception:
Traceback (most recent call last):
File "/root/project/IOOppi_data/update_data.py", line 16, in
client.update_data_all()
File "/root/project/IOOppi_data/IOOppi_request.py", line 525, in update_data_all
self.update_time_period_data(cmd_id)
File "/root/project/IOOppi_data/IOOppi_request.py", line 455, in update_time_period_data
self.save_data(index_code, content_df)
File "/root/project/IOOppi_data/IOOppi_request.py", line 235, in save_data
self.save_data_to_db(index_code, df)
File "/root/project/IOOppi_data/IOOppi_request.py", line 249, in save_data_to_db
df = pd.read_sql(sql, self.engine)
File "/usr/local/lib/python3.10/site-packages/pandas/io/sql.py", line 736, in read_sql
return pandas_sql.read_query(
File "/usr/local/lib/python3.10/site-packages/pandas/io/sql.py", line 1848, in read_query
result = self.execute(sql, params)
File "/usr/local/lib/python3.10/site-packages/pandas/io/sql.py", line 1671, in execute
return self.con.exec_driver_sql(sql, *args)
File "/usr/local/lib/python3.10/site-packages/sqlalchemy/engine/base.py", line 1779, in exec_driver_sql
ret = self._execute_context(
File "/usr/local/lib/python3.10/site-packages/sqlalchemy/engine/base.py", line 1846, in _execute_context
return self._exec_single_context(
File "/usr/local/lib/python3.10/site-packages/sqlalchemy/engine/base.py", line 1986, in _exec_single_context
self._handle_dbapi_exception(
File "/usr/local/lib/python3.10/site-packages/sqlalchemy/engine/base.py", line 2355, in _handle_dbapi_exception
raise sqlalchemy_exception.with_traceback(exc_info[2]) from e
File "/usr/local/lib/python3.10/site-packages/sqlalchemy/engine/base.py", line 1967, in _exec_single_context
self.dialect.do_execute(
File "/usr/local/lib/python3.10/site-packages/sqlalchemy/engine/default.py", line 951, in do_execute
cursor.execute(statement, parameters)
File "/usr/local/lib/python3.10/site-packages/pymysql/cursors.py", line 158, in execute
result = self._query(query)
File "/usr/local/lib/python3.10/site-packages/pymysql/cursors.py", line 325, in _query
conn.query(q)
File "/usr/local/lib/python3.10/site-packages/pymysql/connections.py", line 549, in query
self._affected_rows = self._read_query_result(unbuffered=unbuffered)
File "/usr/local/lib/python3.10/site-packages/pymysql/connections.py", line 779, in _read_query_result
result.read()
File "/usr/local/lib/python3.10/site-packages/pymysql/connections.py", line 1164, in read
self._read_result_packet(first_packet)
File "/usr/local/lib/python3.10/site-packages/pymysql/connections.py", line 1240, in _read_result_packet
self._read_rowdata_packet()
File "/usr/local/lib/python3.10/site-packages/pymysql/connections.py", line 1274, in _read_rowdata_packet
packet = self.connection._read_packet()
File "/usr/local/lib/python3.10/site-packages/pymysql/connections.py", line 715, in _read_packet
recv_data = self._read_bytes(bytes_to_read)
File "/usr/local/lib/python3.10/site-packages/pymysql/connections.py", line 742, in _read_bytes
raise err.OperationalError(
sqlalchemy.exc.OperationalError: (pymysql.err.OperationalError) (2013, 'Lost connection to MySQL server during query ([Errno 104] Connection reset by peer)')
[SQL: SELECT `IOOppi_data`.date AS date, `IOOppi_data`.value AS value
FROM `IOOppi_data`
WHERE `IOOppi_data`.index_code = 'IOOppi_m_g']
(Background on this error at: https://sqlalche.me/e/20/e3q8)