=========================================================================
2025-09-15 17:50:26 Mon 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-15 17:50:41,773 - IOOppi_data - INFO : save data to db IOOppi_rb_t data:
date value
3423 2025-09-11 3123.5
3424 2025-09-12 3124.0
3425 2025-09-13 3124.0
3426 2025-09-14 3124.0
3427 2025-09-15 3134.0
2025-09-15 17:52:00,580 - IOOppi_data - INFO : save new data to db IOOppi_rb_t: date value ... created_at updated_at
3425 2025-09-13 3124.0 ... 2025-09-15 17:52:00.571772 2025-09-15 17:52:00.572214
3426 2025-09-14 3124.0 ... 2025-09-15 17:52:00.571772 2025-09-15 17:52:00.572214
3427 2025-09-15 3134.0 ... 2025-09-15 17:52:00.571772 2025-09-15 17:52:00.572214
[3 rows x 5 columns]
2025-09-15 17:52:00,600 - IOOppi_data - INFO : save diff data to db: IOOppi_rb_t: no diff data
2025-09-15 17:52:00,606 - IOOppi_data - INFO : save data to db IOOppi_rb_g data:
date value
3423 2025-09-11 3123.5
3424 2025-09-12 3124.0
3425 2025-09-13 3124.0
3426 2025-09-14 3124.0
3427 2025-09-15 3134.0
2025-09-15 17:52:17,396 - IOOppi_data - INFO : save new data to db IOOppi_rb_g: date value ... created_at updated_at
3428 2025-09-13 3124.0 ... 2025-09-15 17:52:17.388353 2025-09-15 17:52:17.388778
3429 2025-09-14 3124.0 ... 2025-09-15 17:52:17.388353 2025-09-15 17:52:17.388778
3430 2025-09-15 3134.0 ... 2025-09-15 17:52:17.388353 2025-09-15 17:52:17.388778
[3 rows x 5 columns]
2025-09-15 17:52:17,417 - 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-15 17:52:18,065 - IOOppi_data - INFO : save data to db IOOppi_MA_t data:
date value
3644 2025-09-11 2290.00
3645 2025-09-12 2288.33
3646 2025-09-13 2288.33
3647 2025-09-14 2288.33
3648 2025-09-15 2295.00
2025-09-15 17:52:35,972 - IOOppi_data - INFO : save new data to db IOOppi_MA_t: date value ... created_at updated_at
3646 2025-09-13 2288.33 ... 2025-09-15 17:52:35.964827 2025-09-15 17:52:35.965257
3647 2025-09-14 2288.33 ... 2025-09-15 17:52:35.964827 2025-09-15 17:52:35.965257
3648 2025-09-15 2295.00 ... 2025-09-15 17:52:35.964827 2025-09-15 17:52:35.965257
[3 rows x 5 columns]
2025-09-15 17:52:35,992 - IOOppi_data - INFO : save diff data to db: IOOppi_MA_t: no diff data
2025-09-15 17:52:35,998 - IOOppi_data - INFO : save data to db IOOppi_MA_g data:
date value
3644 2025-09-11 2290.00
3645 2025-09-12 2288.33
3646 2025-09-13 2288.33
3647 2025-09-14 2288.33
3648 2025-09-15 2295.00
2025-09-15 17:52:43,690 - IOOppi_data - INFO : save new data to db IOOppi_MA_g: date value ... created_at updated_at
3650 2025-09-13 2288.33 ... 2025-09-15 17:52:43.682901 2025-09-15 17:52:43.683316
3651 2025-09-14 2288.33 ... 2025-09-15 17:52:43.682901 2025-09-15 17:52:43.683316
3652 2025-09-15 2295.00 ... 2025-09-15 17:52:43.682901 2025-09-15 17:52:43.683316
[3 rows x 5 columns]
2025-09-15 17:52:45,570 - 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-15 17:52:49,530 - IOOppi_data - INFO : save data to db IOOppi_PTA_t data:
date value
984 2025-09-11 4649.16
985 2025-09-12 4636.66
986 2025-09-13 4636.66
987 2025-09-14 4636.66
988 2025-09-15 4631.66
2025-09-15 17:52:54,240 - IOOppi_data - INFO : save new data to db IOOppi_PTA_t: date value ... created_at updated_at
986 2025-09-13 4636.66 ... 2025-09-15 17:52:54.232764 2025-09-15 17:52:54.233165
987 2025-09-14 4636.66 ... 2025-09-15 17:52:54.232764 2025-09-15 17:52:54.233165
988 2025-09-15 4631.66 ... 2025-09-15 17:52:54.232764 2025-09-15 17:52:54.233165
[3 rows x 5 columns]
2025-09-15 17:52:54,261 - IOOppi_data - INFO : save diff data to db: IOOppi_PTA_t: no diff data
2025-09-15 17:52:54,267 - IOOppi_data - INFO : save data to db IOOppi_PTA_g data:
date value
984 2025-09-11 4649.16
985 2025-09-12 4636.66
986 2025-09-13 4636.66
987 2025-09-14 4636.66
988 2025-09-15 4631.66
2025-09-15 17:52:58,004 - IOOppi_data - INFO : save new data to db IOOppi_PTA_g: date value ... created_at updated_at
986 2025-09-13 4636.66 ... 2025-09-15 17:52:57.997516 2025-09-15 17:52:57.997937
987 2025-09-14 4636.66 ... 2025-09-15 17:52:57.997516 2025-09-15 17:52:57.997937
988 2025-09-15 4631.66 ... 2025-09-15 17:52:57.997516 2025-09-15 17:52:57.997937
[3 rows x 5 columns]
2025-09-15 17:52:59,657 - 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-15 17:53:00,254 - IOOppi_data - INFO : save data to db IOOppi_ru_t data:
date value
3863 2025-09-11 15058.33
3864 2025-09-12 14983.33
3865 2025-09-13 14983.33
3866 2025-09-14 14983.33
3867 2025-09-15 15133.33
2025-09-15 17:53:04,365 - IOOppi_data - INFO : save new data to db IOOppi_ru_t: date ... updated_at
3865 2025-09-13 ... 2025-09-15 17:53:04.357801
3866 2025-09-14 ... 2025-09-15 17:53:04.357801
3867 2025-09-15 ... 2025-09-15 17:53:04.357801
[3 rows x 5 columns]
2025-09-15 17:53:05,409 - IOOppi_data - INFO : save diff data to db: IOOppi_ru_t: no diff data
2025-09-15 17:53:05,416 - IOOppi_data - INFO : save data to db IOOppi_ru_g data:
date value
3863 2025-09-11 15058.33
3864 2025-09-12 14983.33
3865 2025-09-13 14983.33
3866 2025-09-14 14983.33
3867 2025-09-15 15133.33
2025-09-15 17:53:41,476 - IOOppi_data - INFO : save new data to db IOOppi_ru_g: date ... updated_at
3868 2025-09-13 ... 2025-09-15 17:53:41.469749
3869 2025-09-14 ... 2025-09-15 17:53:41.469749
3870 2025-09-15 ... 2025-09-15 17:53:41.469749
[3 rows x 5 columns]
2025-09-15 17:53:42,315 - 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-15 17:53:42,938 - IOOppi_data - INFO : save data to db IOOppi_i_t data:
date value
3195 2025-09-11 812.33
3196 2025-09-12 808.00
3197 2025-09-13 808.00
3198 2025-09-14 807.89
3199 2025-09-15 807.89
=========================================================================
2025-09-15 18:30:57 Mon 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-15 18:31:01,255 - IOOppi_data - INFO : save data to db IOOppi_rb_t data:
date value
3423 2025-09-11 3123.5
3424 2025-09-12 3124.0
3425 2025-09-13 3124.0
3426 2025-09-14 3124.0
3427 2025-09-15 3134.0
2025-09-15 18:31:03,066 - IOOppi_data - INFO : save new data to db: IOOppi_rb_t: no new data
2025-09-15 18:31:03,066 - IOOppi_data - INFO : save diff data to db: IOOppi_rb_t: no diff data
2025-09-15 18:31:03,072 - IOOppi_data - INFO : save data to db IOOppi_rb_g data:
date value
3423 2025-09-11 3123.5
3424 2025-09-12 3124.0
3425 2025-09-13 3124.0
3426 2025-09-14 3124.0
3427 2025-09-15 3134.0
2025-09-15 18:31:06,289 - IOOppi_data - INFO : save new data to db: IOOppi_rb_g: no new data
2025-09-15 18:31:06,290 - 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-15 18:31:06,902 - IOOppi_data - INFO : save data to db IOOppi_MA_t data:
date value
3644 2025-09-11 2290.00
3645 2025-09-12 2288.33
3646 2025-09-13 2288.33
3647 2025-09-14 2288.33
3648 2025-09-15 2295.00
2025-09-15 18:31:17,686 - IOOppi_data - INFO : save new data to db: IOOppi_MA_t: no new data
2025-09-15 18:31:17,686 - IOOppi_data - INFO : save diff data to db: IOOppi_MA_t: no diff data
2025-09-15 18:31:17,691 - IOOppi_data - INFO : save data to db IOOppi_MA_g data:
date value
3644 2025-09-11 2290.00
3645 2025-09-12 2288.33
3646 2025-09-13 2288.33
3647 2025-09-14 2288.33
3648 2025-09-15 2295.00
2025-09-15 18:31:32,664 - IOOppi_data - INFO : save new data to db: IOOppi_MA_g: no new data
2025-09-15 18:31:32,664 - 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-15 18:31:33,291 - IOOppi_data - INFO : save data to db IOOppi_PTA_t data:
date value
984 2025-09-11 4649.16
985 2025-09-12 4636.66
986 2025-09-13 4636.66
987 2025-09-14 4636.66
988 2025-09-15 4631.66
2025-09-15 18:31:36,763 - IOOppi_data - INFO : save new data to db: IOOppi_PTA_t: no new data
2025-09-15 18:31:36,763 - IOOppi_data - INFO : save diff data to db: IOOppi_PTA_t: no diff data
2025-09-15 18:31:36,768 - IOOppi_data - INFO : save data to db IOOppi_PTA_g data:
date value
984 2025-09-11 4649.16
985 2025-09-12 4636.66
986 2025-09-13 4636.66
987 2025-09-14 4636.66
988 2025-09-15 4631.66
2025-09-15 18:31:40,784 - IOOppi_data - INFO : save new data to db: IOOppi_PTA_g: no new data
2025-09-15 18:31:40,784 - 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-15 18:31:41,564 - IOOppi_data - INFO : save data to db IOOppi_ru_t data:
date value
3863 2025-09-11 15058.33
3864 2025-09-12 14983.33
3865 2025-09-13 14983.33
3866 2025-09-14 14983.33
3867 2025-09-15 15133.33
2025-09-15 18:31:45,658 - IOOppi_data - INFO : save new data to db: IOOppi_ru_t: no new data
2025-09-15 18:31:45,658 - IOOppi_data - INFO : save diff data to db: IOOppi_ru_t: no diff data
2025-09-15 18:31:45,664 - IOOppi_data - INFO : save data to db IOOppi_ru_g data:
date value
3863 2025-09-11 15058.33
3864 2025-09-12 14983.33
3865 2025-09-13 14983.33
3866 2025-09-14 14983.33
3867 2025-09-15 15133.33
2025-09-15 18:32:09,447 - IOOppi_data - INFO : save new data to db: IOOppi_ru_g: no new data
2025-09-15 18:32:09,447 - 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-15 18:32:10,046 - IOOppi_data - INFO : save data to db IOOppi_i_t data:
date value
3195 2025-09-11 812.33
3196 2025-09-12 808.00
3197 2025-09-13 808.00
3198 2025-09-14 807.89
3199 2025-09-15 807.89
2025-09-15 18:32:46,315 - IOOppi_data - INFO : save new data to db IOOppi_i_t: date value ... created_at updated_at
3197 2025-09-13 808.00 ... 2025-09-15 18:32:46.307262 2025-09-15 18:32:46.307703
3198 2025-09-14 807.89 ... 2025-09-15 18:32:46.307262 2025-09-15 18:32:46.307703
3199 2025-09-15 807.89 ... 2025-09-15 18:32:46.307262 2025-09-15 18:32:46.307703
[3 rows x 5 columns]
2025-09-15 18:32:47,366 - IOOppi_data - INFO : save diff data to db: IOOppi_i_t: no diff data
2025-09-15 18:32:47,373 - IOOppi_data - INFO : save data to db IOOppi_i_g data:
date value
3195 2025-09-11 812.33
3196 2025-09-12 808.00
3197 2025-09-13 808.00
3198 2025-09-14 807.89
3199 2025-09-15 807.89
2025-09-15 18:32:57,717 - IOOppi_data - INFO : save new data to db IOOppi_i_g: date value ... created_at updated_at
3200 2025-09-13 808.00 ... 2025-09-15 18:32:57.709346 2025-09-15 18:32:57.709823
3201 2025-09-14 807.89 ... 2025-09-15 18:32:57.709346 2025-09-15 18:32:57.709823
3202 2025-09-15 807.89 ... 2025-09-15 18:32:57.709346 2025-09-15 18:32:57.709823
[3 rows x 5 columns]
2025-09-15 18:32:57,940 - 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-15 18:32:58,853 - IOOppi_data - INFO : save data to db IOOppi_FG_t data:
date value
3398 2025-09-11 1130.4
3399 2025-09-12 1130.4
3400 2025-09-13 1130.4
3401 2025-09-14 1130.4
3402 2025-09-15 1130.4
2025-09-15 18:33:20,913 - IOOppi_data - INFO : save new data to db IOOppi_FG_t: date value ... created_at updated_at
3400 2025-09-13 1130.4 ... 2025-09-15 18:33:20.905633 2025-09-15 18:33:20.906092
3401 2025-09-14 1130.4 ... 2025-09-15 18:33:20.905633 2025-09-15 18:33:20.906092
3402 2025-09-15 1130.4 ... 2025-09-15 18:33:20.905633 2025-09-15 18:33:20.906092
[3 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-15 18:36:51,117 - IOOppi_data - INFO : save diff data to db IOOppi_FG_t: date ... updated_at
12 2012-12-19 ... 2025-09-15 18:36:51.109940
21 2013-01-04 ... 2025-09-15 18:36:51.109940
54 2013-02-27 ... 2025-09-15 18:36:51.109940
60 2013-03-07 ... 2025-09-15 18:36:51.109940
61 2013-03-08 ... 2025-09-15 18:36:51.109940
[5 rows x 6 columns]
2025-09-15 18:36:58,015 - IOOppi_data - INFO : save data to db IOOppi_FG_g data:
date value
3398 2025-09-11 1130.4
3399 2025-09-12 1130.4
3400 2025-09-13 1130.4
3401 2025-09-14 1130.4
3402 2025-09-15 1130.4
2025-09-15 18:37:01,910 - IOOppi_data - INFO : save new data to db IOOppi_FG_g: date value ... created_at updated_at
3404 2025-09-13 1130.4 ... 2025-09-15 18:37:01.902987 2025-09-15 18:37:01.903368
3405 2025-09-14 1130.4 ... 2025-09-15 18:37:01.902987 2025-09-15 18:37:01.903368
3406 2025-09-15 1130.4 ... 2025-09-15 18:37:01.902987 2025-09-15 18:37:01.903368
[3 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-15 18:38:32,392 - IOOppi_data - INFO : save diff data to db IOOppi_FG_g: date ... updated_at
12 2012-12-19 ... 2025-09-15 18:38:32.384745
21 2013-01-04 ... 2025-09-15 18:38:32.384745
54 2013-02-27 ... 2025-09-15 18:38:32.384745
60 2013-03-07 ... 2025-09-15 18:38:32.384745
61 2013-03-08 ... 2025-09-15 18:38:32.384745
[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-15 18:38:37,515 - IOOppi_data - INFO : save data to db IOOppi_eb_t data:
date value
1743 2025-09-11 7394.0
1744 2025-09-12 7314.0
1745 2025-09-13 7320.0
1746 2025-09-14 7320.0
1747 2025-09-15 7314.0
2025-09-15 18:38:43,418 - IOOppi_data - INFO : save new data to db IOOppi_eb_t: date value ... created_at updated_at
1745 2025-09-13 7320.0 ... 2025-09-15 18:38:43.411042 2025-09-15 18:38:43.411425
1746 2025-09-14 7320.0 ... 2025-09-15 18:38:43.411042 2025-09-15 18:38:43.411425
1747 2025-09-15 7314.0 ... 2025-09-15 18:38:43.411042 2025-09-15 18:38:43.411425
[3 rows x 5 columns]
2025-09-15 18:38:44,463 - IOOppi_data - INFO : save diff data to db: IOOppi_eb_t: no diff data
2025-09-15 18:38:44,469 - IOOppi_data - INFO : save data to db IOOppi_eb_g data:
date value
1743 2025-09-11 7394.0
1744 2025-09-12 7314.0
1745 2025-09-13 7320.0
1746 2025-09-14 7320.0
1747 2025-09-15 7314.0
2025-09-15 18:38:58,627 - IOOppi_data - INFO : save new data to db IOOppi_eb_g: date value ... created_at updated_at
1748 2025-09-13 7320.0 ... 2025-09-15 18:38:58.620117 2025-09-15 18:38:58.620515
1749 2025-09-14 7320.0 ... 2025-09-15 18:38:58.620117 2025-09-15 18:38:58.620515
1750 2025-09-15 7314.0 ... 2025-09-15 18:38:58.620117 2025-09-15 18:38:58.620515
[3 rows x 5 columns]
2025-09-15 18:38:58,852 - 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-15 18:38:59,496 - IOOppi_data - INFO : save data to db IOOppi_SR_t data:
date value
3854 2025-09-11 5855.0
3855 2025-09-12 5855.0
3856 2025-09-13 5855.0
3857 2025-09-14 5855.0
3858 2025-09-15 5850.0
2025-09-15 18:39:02,547 - IOOppi_data - INFO : save new data to db IOOppi_SR_t: date value ... created_at updated_at
3856 2025-09-13 5855.0 ... 2025-09-15 18:39:02.539441 2025-09-15 18:39:02.539854
3857 2025-09-14 5855.0 ... 2025-09-15 18:39:02.539441 2025-09-15 18:39:02.539854
3858 2025-09-15 5850.0 ... 2025-09-15 18:39:02.539441 2025-09-15 18:39:02.539854
[3 rows x 5 columns]
2025-09-15 18:39:02,770 - IOOppi_data - INFO : save diff data to db: IOOppi_SR_t: no diff data
2025-09-15 18:39:02,777 - IOOppi_data - INFO : save data to db IOOppi_SR_g data:
date value
3854 2025-09-11 5855.0
3855 2025-09-12 5855.0
3856 2025-09-13 5855.0
3857 2025-09-14 5855.0
3858 2025-09-15 5850.0
2025-09-15 18:39:10,997 - IOOppi_data - INFO : save new data to db IOOppi_SR_g: date value ... created_at updated_at
3860 2025-09-13 5855.0 ... 2025-09-15 18:39:10.990340 2025-09-15 18:39:10.990765
3861 2025-09-14 5855.0 ... 2025-09-15 18:39:10.990340 2025-09-15 18:39:10.990765
3862 2025-09-15 5850.0 ... 2025-09-15 18:39:10.990340 2025-09-15 18:39:10.990765
[3 rows x 5 columns]
2025-09-15 18:39:11,457 - 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-15 18:39:12,061 - IOOppi_data - INFO : save data to db IOOppi_ss_t data:
date value
1744 2025-09-11 13055.0
1745 2025-09-12 13067.5
1746 2025-09-13 13067.5
1747 2025-09-14 13067.5
1748 2025-09-15 13092.5
2025-09-15 18:39:33,225 - IOOppi_data - INFO : save new data to db IOOppi_ss_t: date value ... created_at updated_at
1746 2025-09-13 13067.5 ... 2025-09-15 18:39:33.218008 2025-09-15 18:39:33.218394
1747 2025-09-14 13067.5 ... 2025-09-15 18:39:33.218008 2025-09-15 18:39:33.218394
1748 2025-09-15 13092.5 ... 2025-09-15 18:39:33.218008 2025-09-15 18:39:33.218394
[3 rows x 5 columns]
2025-09-15 18:39:33,761 - IOOppi_data - INFO : save diff data to db: IOOppi_ss_t: no diff data
2025-09-15 18:39:33,768 - IOOppi_data - INFO : save data to db IOOppi_ss_g data:
date value
1744 2025-09-11 13055.0
1745 2025-09-12 13067.5
1746 2025-09-13 13067.5
1747 2025-09-14 13067.5
1748 2025-09-15 13092.5
2025-09-15 18:39:45,629 - IOOppi_data - INFO : save new data to db IOOppi_ss_g: date value ... created_at updated_at
1749 2025-09-13 13067.5 ... 2025-09-15 18:39:45.621806 2025-09-15 18:39:45.622196
1750 2025-09-14 13067.5 ... 2025-09-15 18:39:45.621806 2025-09-15 18:39:45.622196
1751 2025-09-15 13092.5 ... 2025-09-15 18:39:45.621806 2025-09-15 18:39:45.622196
[3 rows x 5 columns]
2025-09-15 18:39:47,008 - 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-15 18:39:47,716 - IOOppi_data - INFO : save data to db IOOppi_RS_t data:
date value
3254 2025-09-11 10020.00
3255 2025-09-12 10000.00
3256 2025-09-13 10000.00
3257 2025-09-14 10000.00
3258 2025-09-15 10026.67
2025-09-15 18:39:56,335 - IOOppi_data - INFO : save new data to db IOOppi_RS_t: date ... updated_at
3256 2025-09-13 ... 2025-09-15 18:39:56.328787
3257 2025-09-14 ... 2025-09-15 18:39:56.328787
3258 2025-09-15 ... 2025-09-15 18:39:56.328787
[3 rows x 5 columns]
2025-09-15 18:39:56,353 - IOOppi_data - INFO : save diff data to db: IOOppi_RS_t: no diff data
2025-09-15 18:39:56,359 - IOOppi_data - INFO : save data to db IOOppi_RS_g data:
date value
3254 2025-09-11 10020.00
3255 2025-09-12 10000.00
3256 2025-09-13 10000.00
3257 2025-09-14 10000.00
3258 2025-09-15 10026.67
2025-09-15 18:40:08,265 - IOOppi_data - INFO : save new data to db IOOppi_RS_g: date ... updated_at
3260 2025-09-13 ... 2025-09-15 18:40:08.259154
3261 2025-09-14 ... 2025-09-15 18:40:08.259154
3262 2025-09-15 ... 2025-09-15 18:40:08.259154
[3 rows x 5 columns]
2025-09-15 18:40:08,284 - 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-15 18:40:08,829 - IOOppi_data - INFO : save data to db IOOppi_RM_t data:
date value
3377 2025-09-11 2665.0
3378 2025-09-12 2680.0
3379 2025-09-13 2680.0
3380 2025-09-14 2680.0
3381 2025-09-15 2635.0
2025-09-15 18:40:15,668 - IOOppi_data - INFO : save new data to db IOOppi_RM_t: date value ... created_at updated_at
3379 2025-09-13 2680.0 ... 2025-09-15 18:40:15.660928 2025-09-15 18:40:15.661339
3380 2025-09-14 2680.0 ... 2025-09-15 18:40:15.660928 2025-09-15 18:40:15.661339
3381 2025-09-15 2635.0 ... 2025-09-15 18:40:15.660928 2025-09-15 18:40:15.661339
[3 rows x 5 columns]
2025-09-15 18:40:16,507 - IOOppi_data - INFO : save diff data to db: IOOppi_RM_t: no diff data
2025-09-15 18:40:16,514 - IOOppi_data - INFO : save data to db IOOppi_RM_g data:
date value
3377 2025-09-11 2665.0
3378 2025-09-12 2680.0
3379 2025-09-13 2680.0
3380 2025-09-14 2680.0
3381 2025-09-15 2635.0
2025-09-15 18:40:18,957 - IOOppi_data - INFO : save new data to db IOOppi_RM_g: date value ... created_at updated_at
3383 2025-09-13 2680.0 ... 2025-09-15 18:40:18.950174 2025-09-15 18:40:18.950553
3384 2025-09-14 2680.0 ... 2025-09-15 18:40:18.950174 2025-09-15 18:40:18.950553
3385 2025-09-15 2635.0 ... 2025-09-15 18:40:18.950174 2025-09-15 18:40:18.950553
[3 rows x 5 columns]
2025-09-15 18:40:19,182 - 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-15 18:40:19,835 - IOOppi_data - INFO : save data to db IOOppi_SA_t data:
date value
1581 2025-09-11 1262.5
1582 2025-09-12 1262.5
1583 2025-09-13 1262.5
1584 2025-09-14 1262.5
1585 2025-09-15 1262.5
2025-09-15 18:40:26,216 - IOOppi_data - INFO : save new data to db IOOppi_SA_t: date value ... created_at updated_at
1583 2025-09-13 1262.5 ... 2025-09-15 18:40:26.208317 2025-09-15 18:40:26.208803
1584 2025-09-14 1262.5 ... 2025-09-15 18:40:26.208317 2025-09-15 18:40:26.208803
1585 2025-09-15 1262.5 ... 2025-09-15 18:40:26.208317 2025-09-15 18:40:26.208803
[3 rows x 5 columns]
2025-09-15 18:40:27,055 - IOOppi_data - INFO : save diff data to db: IOOppi_SA_t: no diff data
2025-09-15 18:40:27,061 - IOOppi_data - INFO : save data to db IOOppi_SA_g data:
date value
1581 2025-09-11 1262.5
1582 2025-09-12 1262.5
1583 2025-09-13 1262.5
1584 2025-09-14 1262.5
1585 2025-09-15 1262.5
2025-09-15 18:40:30,053 - IOOppi_data - INFO : save new data to db IOOppi_SA_g: date value ... created_at updated_at
1587 2025-09-13 1262.5 ... 2025-09-15 18:40:30.045772 2025-09-15 18:40:30.046162
1588 2025-09-14 1262.5 ... 2025-09-15 18:40:30.045772 2025-09-15 18:40:30.046162
1589 2025-09-15 1262.5 ... 2025-09-15 18:40:30.045772 2025-09-15 18:40:30.046162
[3 rows x 5 columns]
2025-09-15 18:40:30,277 - 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-15 18:40:30,898 - IOOppi_data - INFO : save data to db IOOppi_PF_t data:
date value
1494 2025-09-11 6471.33
1495 2025-09-12 6457.00
1496 2025-09-13 6457.00
1497 2025-09-14 6457.00
1498 2025-09-15 6471.00
2025-09-15 18:40:37,942 - IOOppi_data - INFO : save new data to db IOOppi_PF_t: date value ... created_at updated_at
1496 2025-09-13 6457.0 ... 2025-09-15 18:40:37.934943 2025-09-15 18:40:37.935327
1497 2025-09-14 6457.0 ... 2025-09-15 18:40:37.934943 2025-09-15 18:40:37.935327
1498 2025-09-15 6471.0 ... 2025-09-15 18:40:37.934943 2025-09-15 18:40:37.935327
[3 rows x 5 columns]
2025-09-15 18:40:38,167 - IOOppi_data - INFO : save diff data to db: IOOppi_PF_t: no diff data
2025-09-15 18:40:38,172 - IOOppi_data - INFO : save data to db IOOppi_PF_g data:
date value
1494 2025-09-11 6471.33
1495 2025-09-12 6457.00
1496 2025-09-13 6457.00
1497 2025-09-14 6457.00
1498 2025-09-15 6471.00
2025-09-15 18:40:42,907 - IOOppi_data - INFO : save new data to db IOOppi_PF_g: date value ... created_at updated_at
1500 2025-09-13 6457.0 ... 2025-09-15 18:40:42.899078 2025-09-15 18:40:42.899514
1501 2025-09-14 6457.0 ... 2025-09-15 18:40:42.899078 2025-09-15 18:40:42.899514
1502 2025-09-15 6471.0 ... 2025-09-15 18:40:42.899078 2025-09-15 18:40:42.899514
[3 rows x 5 columns]
2025-09-15 18:40:43,130 - 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-15 18:40:43,768 - IOOppi_data - INFO : save data to db IOOppi_m_t data:
date value
3867 2025-09-11 3060.0
3868 2025-09-12 3060.0
3869 2025-09-13 3060.0
3870 2025-09-14 3060.0
3871 2025-09-15 3058.0
2025-09-15 18:40:45,379 - IOOppi_data - INFO : save new data to db IOOppi_m_t: date value ... created_at updated_at
3869 2025-09-13 3060.0 ... 2025-09-15 18:40:45.371307 2025-09-15 18:40:45.371746
3870 2025-09-14 3060.0 ... 2025-09-15 18:40:45.371307 2025-09-15 18:40:45.371746
3871 2025-09-15 3058.0 ... 2025-09-15 18:40:45.371307 2025-09-15 18:40:45.371746
[3 rows x 5 columns]
2025-09-15 18:40:45,603 - IOOppi_data - INFO : save diff data to db: IOOppi_m_t: no diff data
2025-09-15 18:40:45,610 - IOOppi_data - INFO : save data to db IOOppi_m_g data:
date value
3867 2025-09-11 3060.0
3868 2025-09-12 3060.0
3869 2025-09-13 3060.0
3870 2025-09-14 3060.0
3871 2025-09-15 3058.0
2025-09-15 18:42:08,273 - IOOppi_data - INFO : save new data to db IOOppi_m_g: date value ... created_at updated_at
3872 2025-09-13 3060.0 ... 2025-09-15 18:42:08.264944 2025-09-15 18:42:08.265347
3873 2025-09-14 3060.0 ... 2025-09-15 18:42:08.264944 2025-09-15 18:42:08.265347
3874 2025-09-15 3058.0 ... 2025-09-15 18:42:08.264944 2025-09-15 18:42:08.265347
[3 rows x 5 columns]
2025-09-15 18:42:08,497 - 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-15 18:42:09,127 - IOOppi_data - INFO : save data to db IOOppi_y_t data:
date value
3637 2025-09-11 8408.0
3638 2025-09-12 8398.0
3639 2025-09-13 8398.0
3640 2025-09-14 8398.0
3641 2025-09-15 8448.0
2025-09-15 18:42:39,161 - IOOppi_data - INFO : save new data to db IOOppi_y_t: date value ... created_at updated_at
3639 2025-09-13 8398.0 ... 2025-09-15 18:42:39.153095 2025-09-15 18:42:39.153478
3640 2025-09-14 8398.0 ... 2025-09-15 18:42:39.153095 2025-09-15 18:42:39.153478
3641 2025-09-15 8448.0 ... 2025-09-15 18:42:39.153095 2025-09-15 18:42:39.153478
[3 rows x 5 columns]
2025-09-15 18:42:41,269 - IOOppi_data - INFO : save diff data to db: IOOppi_y_t: no diff data
2025-09-15 18:42:41,276 - IOOppi_data - INFO : save data to db IOOppi_y_g data:
date value
3637 2025-09-11 8408.0
3638 2025-09-12 8398.0
3639 2025-09-13 8398.0
3640 2025-09-14 8398.0
3641 2025-09-15 8448.0
2025-09-15 18:43:01,591 - IOOppi_data - INFO : save new data to db IOOppi_y_g: date value ... created_at updated_at
3642 2025-09-13 8398.0 ... 2025-09-15 18:43:01.583993 2025-09-15 18:43:01.584377
3643 2025-09-14 8398.0 ... 2025-09-15 18:43:01.583993 2025-09-15 18:43:01.584377
3644 2025-09-15 8448.0 ... 2025-09-15 18:43:01.583993 2025-09-15 18:43:01.584377
[3 rows x 5 columns]
2025-09-15 18:43:02,635 - 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-15 18:43:03,445 - IOOppi_data - INFO : save data to db IOOppi_a_t data:
date value
3603 2025-09-11 4305.0
3604 2025-09-12 4305.0
3605 2025-09-13 4305.0
3606 2025-09-14 4305.0
3607 2025-09-15 4305.0
=========================================================================
2025-09-15 19:11:27 Mon 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-15 19:11:40,664 - IOOppi_data - INFO : save data to db IOOppi_rb_t data:
date value
3423 2025-09-11 3123.5
3424 2025-09-12 3124.0
3425 2025-09-13 3124.0
3426 2025-09-14 3124.0
3427 2025-09-15 3134.0
2025-09-15 19:12:12,437 - IOOppi_data - INFO : save new data to db: IOOppi_rb_t: no new data
2025-09-15 19:12:12,438 - IOOppi_data - INFO : save diff data to db: IOOppi_rb_t: no diff data
2025-09-15 19:12:12,443 - IOOppi_data - INFO : save data to db IOOppi_rb_g data:
date value
3423 2025-09-11 3123.5
3424 2025-09-12 3124.0
3425 2025-09-13 3124.0
3426 2025-09-14 3124.0
3427 2025-09-15 3134.0
2025-09-15 19:12:24,959 - IOOppi_data - INFO : save new data to db: IOOppi_rb_g: no new data
2025-09-15 19:12:24,959 - 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-15 19:12:25,554 - IOOppi_data - INFO : save data to db IOOppi_MA_t data:
date value
3644 2025-09-11 2290.00
3645 2025-09-12 2288.33
3646 2025-09-13 2288.33
3647 2025-09-14 2288.33
3648 2025-09-15 2295.00
2025-09-15 19:12:30,564 - IOOppi_data - INFO : save new data to db: IOOppi_MA_t: no new data
2025-09-15 19:12:30,564 - IOOppi_data - INFO : save diff data to db: IOOppi_MA_t: no diff data
2025-09-15 19:12:30,569 - IOOppi_data - INFO : save data to db IOOppi_MA_g data:
date value
3644 2025-09-11 2290.00
3645 2025-09-12 2288.33
3646 2025-09-13 2288.33
3647 2025-09-14 2288.33
3648 2025-09-15 2295.00
2025-09-15 19:13:27,079 - IOOppi_data - INFO : save new data to db: IOOppi_MA_g: no new data
2025-09-15 19:13:27,079 - 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-15 19:13:27,694 - IOOppi_data - INFO : save data to db IOOppi_PTA_t data:
date value
984 2025-09-11 4649.16
985 2025-09-12 4636.66
986 2025-09-13 4636.66
987 2025-09-14 4636.66
988 2025-09-15 4631.66
2025-09-15 19:13:29,864 - IOOppi_data - INFO : save new data to db: IOOppi_PTA_t: no new data
2025-09-15 19:13:29,864 - IOOppi_data - INFO : save diff data to db: IOOppi_PTA_t: no diff data
2025-09-15 19:13:29,869 - IOOppi_data - INFO : save data to db IOOppi_PTA_g data:
date value
984 2025-09-11 4649.16
985 2025-09-12 4636.66
986 2025-09-13 4636.66
987 2025-09-14 4636.66
988 2025-09-15 4631.66
2025-09-15 19:13:33,330 - IOOppi_data - INFO : save new data to db: IOOppi_PTA_g: no new data
2025-09-15 19:13:33,330 - 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-15 19:13:34,001 - IOOppi_data - INFO : save data to db IOOppi_ru_t data:
date value
3863 2025-09-11 15058.33
3864 2025-09-12 14983.33
3865 2025-09-13 14983.33
3866 2025-09-14 14983.33
3867 2025-09-15 15133.33
2025-09-15 19:14:45,220 - IOOppi_data - INFO : save new data to db: IOOppi_ru_t: no new data
2025-09-15 19:14:45,220 - IOOppi_data - INFO : save diff data to db: IOOppi_ru_t: no diff data
2025-09-15 19:14:45,225 - IOOppi_data - INFO : save data to db IOOppi_ru_g data:
date value
3863 2025-09-11 15058.33
3864 2025-09-12 14983.33
3865 2025-09-13 14983.33
3866 2025-09-14 14983.33
3867 2025-09-15 15133.33
2025-09-15 19:15:01,560 - IOOppi_data - INFO : save new data to db: IOOppi_ru_g: no new data
2025-09-15 19:15:01,560 - 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-15 19:15:02,788 - IOOppi_data - INFO : save data to db IOOppi_i_t data:
date value
3195 2025-09-11 812.33
3196 2025-09-12 808.00
3197 2025-09-13 808.00
3198 2025-09-14 807.89
3199 2025-09-15 807.89
2025-09-15 19:15:21,030 - IOOppi_data - INFO : save new data to db: IOOppi_i_t: no new data
2025-09-15 19:15:21,030 - IOOppi_data - INFO : save diff data to db: IOOppi_i_t: no diff data
2025-09-15 19:15:21,036 - IOOppi_data - INFO : save data to db IOOppi_i_g data:
date value
3195 2025-09-11 812.33
3196 2025-09-12 808.00
3197 2025-09-13 808.00
3198 2025-09-14 807.89
3199 2025-09-15 807.89
2025-09-15 19:15:44,956 - IOOppi_data - INFO : save new data to db: IOOppi_i_g: no new data
2025-09-15 19:15:44,957 - 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-15 19:15:45,796 - IOOppi_data - INFO : save data to db IOOppi_FG_t data:
date value
3398 2025-09-11 1130.4
3399 2025-09-12 1130.4
3400 2025-09-13 1130.4
3401 2025-09-14 1130.4
3402 2025-09-15 1130.4
2025-09-15 19:15:54,236 - 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-15 19:17:15,888 - IOOppi_data - INFO : save diff data to db IOOppi_FG_t: date ... updated_at
12 2012-12-19 ... 2025-09-15 19:17:15.879905
21 2013-01-04 ... 2025-09-15 19:17:15.879905
54 2013-02-27 ... 2025-09-15 19:17:15.879905
60 2013-03-07 ... 2025-09-15 19:17:15.879905
61 2013-03-08 ... 2025-09-15 19:17:15.879905
[5 rows x 6 columns]
2025-09-15 19:17:18,444 - IOOppi_data - INFO : save data to db IOOppi_FG_g data:
date value
3398 2025-09-11 1130.4
3399 2025-09-12 1130.4
3400 2025-09-13 1130.4
3401 2025-09-14 1130.4
3402 2025-09-15 1130.4
2025-09-15 19:18:02,382 - 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-15 19:21:13,225 - IOOppi_data - INFO : save diff data to db IOOppi_FG_g: date ... updated_at
12 2012-12-19 ... 2025-09-15 19:21:13.216908
21 2013-01-04 ... 2025-09-15 19:21:13.216908
54 2013-02-27 ... 2025-09-15 19:21:13.216908
60 2013-03-07 ... 2025-09-15 19:21:13.216908
61 2013-03-08 ... 2025-09-15 19:21:13.216908
[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-15 19:21:16,498 - IOOppi_data - INFO : save data to db IOOppi_eb_t data:
date value
1743 2025-09-11 7394.0
1744 2025-09-12 7314.0
1745 2025-09-13 7320.0
1746 2025-09-14 7320.0
1747 2025-09-15 7314.0
2025-09-15 19:21:21,314 - IOOppi_data - INFO : save new data to db: IOOppi_eb_t: no new data
2025-09-15 19:21:21,314 - IOOppi_data - INFO : save diff data to db: IOOppi_eb_t: no diff data
2025-09-15 19:21:21,320 - IOOppi_data - INFO : save data to db IOOppi_eb_g data:
date value
1743 2025-09-11 7394.0
1744 2025-09-12 7314.0
1745 2025-09-13 7320.0
1746 2025-09-14 7320.0
1747 2025-09-15 7314.0
2025-09-15 19:21:34,326 - IOOppi_data - INFO : save new data to db: IOOppi_eb_g: no new data
2025-09-15 19:21:34,326 - 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-15 19:21:34,940 - IOOppi_data - INFO : save data to db IOOppi_SR_t data:
date value
3854 2025-09-11 5855.0
3855 2025-09-12 5855.0
3856 2025-09-13 5855.0
3857 2025-09-14 5855.0
3858 2025-09-15 5850.0
2025-09-15 19:21:40,490 - IOOppi_data - INFO : save new data to db: IOOppi_SR_t: no new data
2025-09-15 19:21:40,490 - IOOppi_data - INFO : save diff data to db: IOOppi_SR_t: no diff data
2025-09-15 19:21:40,498 - IOOppi_data - INFO : save data to db IOOppi_SR_g data:
date value
3854 2025-09-11 5855.0
3855 2025-09-12 5855.0
3856 2025-09-13 5855.0
3857 2025-09-14 5855.0
3858 2025-09-15 5850.0
2025-09-15 19:21:55,732 - IOOppi_data - INFO : save new data to db: IOOppi_SR_g: no new data
2025-09-15 19:21:55,732 - 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-15 19:21:56,378 - IOOppi_data - INFO : save data to db IOOppi_ss_t data:
date value
1744 2025-09-11 13055.0
1745 2025-09-12 13067.5
1746 2025-09-13 13067.5
1747 2025-09-14 13067.5
1748 2025-09-15 13092.5
2025-09-15 19:22:16,041 - IOOppi_data - INFO : save new data to db: IOOppi_ss_t: no new data
2025-09-15 19:22:16,042 - IOOppi_data - INFO : save diff data to db: IOOppi_ss_t: no diff data
2025-09-15 19:22:16,047 - IOOppi_data - INFO : save data to db IOOppi_ss_g data:
date value
1744 2025-09-11 13055.0
1745 2025-09-12 13067.5
1746 2025-09-13 13067.5
1747 2025-09-14 13067.5
1748 2025-09-15 13092.5
2025-09-15 19:22:24,612 - IOOppi_data - INFO : save new data to db: IOOppi_ss_g: no new data
2025-09-15 19:22:24,612 - 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-15 19:22:26,088 - IOOppi_data - INFO : save data to db IOOppi_RS_t data:
date value
3254 2025-09-11 10020.00
3255 2025-09-12 10000.00
3256 2025-09-13 10000.00
3257 2025-09-14 10000.00
3258 2025-09-15 10026.67
2025-09-15 19:22:41,148 - IOOppi_data - INFO : save new data to db: IOOppi_RS_t: no new data
2025-09-15 19:22:41,148 - IOOppi_data - INFO : save diff data to db: IOOppi_RS_t: no diff data
2025-09-15 19:22:41,154 - IOOppi_data - INFO : save data to db IOOppi_RS_g data:
date value
3254 2025-09-11 10020.00
3255 2025-09-12 10000.00
3256 2025-09-13 10000.00
3257 2025-09-14 10000.00
3258 2025-09-15 10026.67
2025-09-15 19:22:48,692 - IOOppi_data - INFO : save new data to db: IOOppi_RS_g: no new data
2025-09-15 19:22:48,692 - 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-15 19:22:49,406 - IOOppi_data - INFO : save data to db IOOppi_RM_t data:
date value
3377 2025-09-11 2665.0
3378 2025-09-12 2680.0
3379 2025-09-13 2680.0
3380 2025-09-14 2680.0
3381 2025-09-15 2635.0
2025-09-15 19:23:11,478 - IOOppi_data - INFO : save new data to db: IOOppi_RM_t: no new data
2025-09-15 19:23:11,478 - IOOppi_data - INFO : save diff data to db: IOOppi_RM_t: no diff data
2025-09-15 19:23:11,484 - IOOppi_data - INFO : save data to db IOOppi_RM_g data:
date value
3377 2025-09-11 2665.0
3378 2025-09-12 2680.0
3379 2025-09-13 2680.0
3380 2025-09-14 2680.0
3381 2025-09-15 2635.0
2025-09-15 19:23:16,553 - IOOppi_data - INFO : save new data to db: IOOppi_RM_g: no new data
2025-09-15 19:23:16,553 - 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-15 19:23:18,246 - IOOppi_data - INFO : save data to db IOOppi_SA_t data:
date value
1581 2025-09-11 1262.5
1582 2025-09-12 1262.5
1583 2025-09-13 1262.5
1584 2025-09-14 1262.5
1585 2025-09-15 1262.5
2025-09-15 19:23:21,957 - IOOppi_data - INFO : save new data to db: IOOppi_SA_t: no new data
2025-09-15 19:23:21,957 - IOOppi_data - INFO : save diff data to db: IOOppi_SA_t: no diff data
2025-09-15 19:23:21,962 - IOOppi_data - INFO : save data to db IOOppi_SA_g data:
date value
1581 2025-09-11 1262.5
1582 2025-09-12 1262.5
1583 2025-09-13 1262.5
1584 2025-09-14 1262.5
1585 2025-09-15 1262.5
2025-09-15 19:23:26,104 - IOOppi_data - INFO : save new data to db: IOOppi_SA_g: no new data
2025-09-15 19:23:26,104 - 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-15 19:23:26,779 - IOOppi_data - INFO : save data to db IOOppi_PF_t data:
date value
1494 2025-09-11 6471.33
1495 2025-09-12 6457.00
1496 2025-09-13 6457.00
1497 2025-09-14 6457.00
1498 2025-09-15 6471.00
2025-09-15 19:23:47,655 - IOOppi_data - INFO : save new data to db: IOOppi_PF_t: no new data
2025-09-15 19:23:47,655 - IOOppi_data - INFO : save diff data to db: IOOppi_PF_t: no diff data
2025-09-15 19:23:47,660 - IOOppi_data - INFO : save data to db IOOppi_PF_g data:
date value
1494 2025-09-11 6471.33
1495 2025-09-12 6457.00
1496 2025-09-13 6457.00
1497 2025-09-14 6457.00
1498 2025-09-15 6471.00
2025-09-15 19:23:47,708 - IOOppi_data - INFO : save new data to db: IOOppi_PF_g: no new data
2025-09-15 19:23:47,708 - 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-15 19:23:48,339 - IOOppi_data - INFO : save data to db IOOppi_m_t data:
date value
3867 2025-09-11 3060.0
3868 2025-09-12 3060.0
3869 2025-09-13 3060.0
3870 2025-09-14 3060.0
3871 2025-09-15 3058.0
2025-09-15 19:23:58,091 - IOOppi_data - INFO : save new data to db: IOOppi_m_t: no new data
2025-09-15 19:23:58,092 - IOOppi_data - INFO : save diff data to db: IOOppi_m_t: no diff data
2025-09-15 19:23:58,098 - IOOppi_data - INFO : save data to db IOOppi_m_g data:
date value
3867 2025-09-11 3060.0
3868 2025-09-12 3060.0
3869 2025-09-13 3060.0
3870 2025-09-14 3060.0
3871 2025-09-15 3058.0
2025-09-15 19:24:32,334 - IOOppi_data - INFO : save new data to db: IOOppi_m_g: no new data
2025-09-15 19:24:32,334 - 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-15 19:24:33,136 - IOOppi_data - INFO : save data to db IOOppi_y_t data:
date value
3637 2025-09-11 8408.0
3638 2025-09-12 8398.0
3639 2025-09-13 8398.0
3640 2025-09-14 8398.0
3641 2025-09-15 8448.0
2025-09-15 19:24:37,074 - IOOppi_data - INFO : save new data to db: IOOppi_y_t: no new data
2025-09-15 19:24:37,074 - IOOppi_data - INFO : save diff data to db: IOOppi_y_t: no diff data
2025-09-15 19:24:37,079 - IOOppi_data - INFO : save data to db IOOppi_y_g data:
date value
3637 2025-09-11 8408.0
3638 2025-09-12 8398.0
3639 2025-09-13 8398.0
3640 2025-09-14 8398.0
3641 2025-09-15 8448.0
2025-09-15 19:25:05,920 - IOOppi_data - INFO : save new data to db: IOOppi_y_g: no new data
2025-09-15 19:25:05,920 - 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-15 19:25:06,688 - IOOppi_data - INFO : save data to db IOOppi_a_t data:
date value
3603 2025-09-11 4305.0
3604 2025-09-12 4305.0
3605 2025-09-13 4305.0
3606 2025-09-14 4305.0
3607 2025-09-15 4305.0
2025-09-15 19:25:09,671 - IOOppi_data - INFO : save new data to db IOOppi_a_t: date value ... created_at updated_at
3605 2025-09-13 4305.0 ... 2025-09-15 19:25:09.663134 2025-09-15 19:25:09.663577
3606 2025-09-14 4305.0 ... 2025-09-15 19:25:09.663134 2025-09-15 19:25:09.663577
3607 2025-09-15 4305.0 ... 2025-09-15 19:25:09.663134 2025-09-15 19:25:09.663577
[3 rows x 5 columns]
2025-09-15 19:25:10,105 - IOOppi_data - INFO : save diff data to db: IOOppi_a_t: no diff data
2025-09-15 19:25:10,111 - IOOppi_data - INFO : save data to db IOOppi_a_g data:
date value
3603 2025-09-11 4305.0
3604 2025-09-12 4305.0
3605 2025-09-13 4305.0
3606 2025-09-14 4305.0
3607 2025-09-15 4305.0
2025-09-15 19:27:13,192 - IOOppi_data - INFO : save new data to db IOOppi_a_g: date value ... created_at updated_at
3608 2025-09-13 4305.0 ... 2025-09-15 19:27:13.184940 2025-09-15 19:27:13.185325
3609 2025-09-14 4305.0 ... 2025-09-15 19:27:13.184940 2025-09-15 19:27:13.185325
3610 2025-09-15 4305.0 ... 2025-09-15 19:27:13.184940 2025-09-15 19:27:13.185325
[3 rows x 5 columns]
2025-09-15 19:27:13,214 - 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-15 19:27:13,853 - IOOppi_data - INFO : save data to db IOOppi_SF_t data:
date value
2980 2025-09-11 5264.29
2981 2025-09-12 5245.71
2982 2025-09-13 5245.71
2983 2025-09-14 5245.71
2984 2025-09-15 5245.71
2025-09-15 19:27:21,006 - IOOppi_data - INFO : save new data to db IOOppi_SF_t: date value ... created_at updated_at
2982 2025-09-13 5245.71 ... 2025-09-15 19:27:20.998719 2025-09-15 19:27:20.999103
2983 2025-09-14 5245.71 ... 2025-09-15 19:27:20.998719 2025-09-15 19:27:20.999103
2984 2025-09-15 5245.71 ... 2025-09-15 19:27:20.998719 2025-09-15 19:27:20.999103
[3 rows x 5 columns]
2025-09-15 19:27:27,604 - IOOppi_data - INFO : save diff data to db: IOOppi_SF_t: no diff data
2025-09-15 19:27:27,610 - IOOppi_data - INFO : save data to db IOOppi_SF_g data:
date value
2980 2025-09-11 5264.29
2981 2025-09-12 5245.71
2982 2025-09-13 5245.71
2983 2025-09-14 5245.71
2984 2025-09-15 5245.71
2025-09-15 19:27:28,808 - IOOppi_data - INFO : save new data to db IOOppi_SF_g: date value ... created_at updated_at
2986 2025-09-13 5245.71 ... 2025-09-15 19:27:28.801406 2025-09-15 19:27:28.801842
2987 2025-09-14 5245.71 ... 2025-09-15 19:27:28.801406 2025-09-15 19:27:28.801842
2988 2025-09-15 5245.71 ... 2025-09-15 19:27:28.801406 2025-09-15 19:27:28.801842
[3 rows x 5 columns]
2025-09-15 19:27:28,828 - 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-15 19:27:29,398 - IOOppi_data - INFO : save data to db IOOppi_jd_t data:
date value
3180 2025-09-11 3640.0
3181 2025-09-12 3675.0
3182 2025-09-13 3675.0
3183 2025-09-14 3675.0
3184 2025-09-15 3840.0
=========================================================================
2025-09-15 19:51:58 Mon 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-15 19:52:02,363 - IOOppi_data - INFO : save data to db IOOppi_rb_t data:
date value
3423 2025-09-11 3123.5
3424 2025-09-12 3124.0
3425 2025-09-13 3124.0
3426 2025-09-14 3124.0
3427 2025-09-15 3134.0
2025-09-15 19:52:03,093 - IOOppi_data - INFO : save new data to db: IOOppi_rb_t: no new data
2025-09-15 19:52:03,093 - IOOppi_data - INFO : save diff data to db: IOOppi_rb_t: no diff data
2025-09-15 19:52:03,099 - IOOppi_data - INFO : save data to db IOOppi_rb_g data:
date value
3423 2025-09-11 3123.5
3424 2025-09-12 3124.0
3425 2025-09-13 3124.0
3426 2025-09-14 3124.0
3427 2025-09-15 3134.0
2025-09-15 19:52:04,002 - IOOppi_data - INFO : save new data to db: IOOppi_rb_g: no new data
2025-09-15 19:52:04,002 - 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-15 19:52:04,622 - IOOppi_data - INFO : save data to db IOOppi_MA_t data:
date value
3644 2025-09-11 2290.00
3645 2025-09-12 2288.33
3646 2025-09-13 2288.33
3647 2025-09-14 2288.33
3648 2025-09-15 2295.00
2025-09-15 19:52:51,873 - IOOppi_data - INFO : save new data to db: IOOppi_MA_t: no new data
2025-09-15 19:52:51,873 - IOOppi_data - INFO : save diff data to db: IOOppi_MA_t: no diff data
2025-09-15 19:52:51,879 - IOOppi_data - INFO : save data to db IOOppi_MA_g data:
date value
3644 2025-09-11 2290.00
3645 2025-09-12 2288.33
3646 2025-09-13 2288.33
3647 2025-09-14 2288.33
3648 2025-09-15 2295.00
2025-09-15 19:53:01,081 - IOOppi_data - INFO : save new data to db: IOOppi_MA_g: no new data
2025-09-15 19:53:01,081 - 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-15 19:53:01,677 - IOOppi_data - INFO : save data to db IOOppi_PTA_t data:
date value
984 2025-09-11 4649.16
985 2025-09-12 4636.66
986 2025-09-13 4636.66
987 2025-09-14 4636.66
988 2025-09-15 4631.66
2025-09-15 19:53:19,900 - IOOppi_data - INFO : save new data to db: IOOppi_PTA_t: no new data
2025-09-15 19:53:19,900 - IOOppi_data - INFO : save diff data to db: IOOppi_PTA_t: no diff data
2025-09-15 19:53:19,905 - IOOppi_data - INFO : save data to db IOOppi_PTA_g data:
date value
984 2025-09-11 4649.16
985 2025-09-12 4636.66
986 2025-09-13 4636.66
987 2025-09-14 4636.66
988 2025-09-15 4631.66
2025-09-15 19:53:22,066 - IOOppi_data - INFO : save new data to db: IOOppi_PTA_g: no new data
2025-09-15 19:53:22,066 - 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-15 19:53:22,714 - IOOppi_data - INFO : save data to db IOOppi_ru_t data:
date value
3863 2025-09-11 15058.33
3864 2025-09-12 14983.33
3865 2025-09-13 14983.33
3866 2025-09-14 14983.33
3867 2025-09-15 15133.33
2025-09-15 19:53:27,038 - IOOppi_data - INFO : save new data to db: IOOppi_ru_t: no new data
2025-09-15 19:53:27,038 - IOOppi_data - INFO : save diff data to db: IOOppi_ru_t: no diff data
2025-09-15 19:53:27,044 - IOOppi_data - INFO : save data to db IOOppi_ru_g data:
date value
3863 2025-09-11 15058.33
3864 2025-09-12 14983.33
3865 2025-09-13 14983.33
3866 2025-09-14 14983.33
3867 2025-09-15 15133.33
2025-09-15 19:53:35,199 - IOOppi_data - INFO : save new data to db: IOOppi_ru_g: no new data
2025-09-15 19:53:35,199 - 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-15 19:53:35,866 - IOOppi_data - INFO : save data to db IOOppi_i_t data:
date value
3195 2025-09-11 812.33
3196 2025-09-12 808.00
3197 2025-09-13 808.00
3198 2025-09-14 807.89
3199 2025-09-15 807.89
2025-09-15 19:53:49,670 - IOOppi_data - INFO : save new data to db: IOOppi_i_t: no new data
2025-09-15 19:53:49,670 - IOOppi_data - INFO : save diff data to db: IOOppi_i_t: no diff data
2025-09-15 19:53:49,675 - IOOppi_data - INFO : save data to db IOOppi_i_g data:
date value
3195 2025-09-11 812.33
3196 2025-09-12 808.00
3197 2025-09-13 808.00
3198 2025-09-14 807.89
3199 2025-09-15 807.89
2025-09-15 19:53:55,099 - IOOppi_data - INFO : save new data to db: IOOppi_i_g: no new data
2025-09-15 19:53:55,099 - 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-15 19:53:55,733 - IOOppi_data - INFO : save data to db IOOppi_FG_t data:
date value
3398 2025-09-11 1130.4
3399 2025-09-12 1130.4
3400 2025-09-13 1130.4
3401 2025-09-14 1130.4
3402 2025-09-15 1130.4
2025-09-15 19:54:22,429 - IOOppi_data - INFO : save new data to db: IOOppi_FG_t: no new 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 696, in _read_packet
packet_header = self._read_bytes(4)
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 450, 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 696, in _read_packet
packet_header = self._read_bytes(4)
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_i_t']
(Background on this error at: https://sqlalche.me/e/20/e3q8)
/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-15 19:58:35,682 - IOOppi_data - INFO : save diff data to db IOOppi_FG_t: date ... updated_at
12 2012-12-19 ... 2025-09-15 19:58:35.674327
21 2013-01-04 ... 2025-09-15 19:58:35.674327
54 2013-02-27 ... 2025-09-15 19:58:35.674327
60 2013-03-07 ... 2025-09-15 19:58:35.674327
61 2013-03-08 ... 2025-09-15 19:58:35.674327
[5 rows x 6 columns]
2025-09-15 19:58:48,643 - IOOppi_data - INFO : save data to db IOOppi_FG_g data:
date value
3398 2025-09-11 1130.4
3399 2025-09-12 1130.4
3400 2025-09-13 1130.4
3401 2025-09-14 1130.4
3402 2025-09-15 1130.4
2025-09-15 19:58:59,737 - 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-15 20:00:48,353 - IOOppi_data - INFO : save diff data to db IOOppi_FG_g: date ... updated_at
12 2012-12-19 ... 2025-09-15 20:00:48.345319
21 2013-01-04 ... 2025-09-15 20:00:48.345319
54 2013-02-27 ... 2025-09-15 20:00:48.345319
60 2013-03-07 ... 2025-09-15 20:00:48.345319
61 2013-03-08 ... 2025-09-15 20:00:48.345319
[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-15 20:00:56,777 - IOOppi_data - INFO : save data to db IOOppi_eb_t data:
date value
1743 2025-09-11 7394.0
1744 2025-09-12 7314.0
1745 2025-09-13 7320.0
1746 2025-09-14 7320.0
1747 2025-09-15 7314.0
2025-09-15 20:00:59,689 - IOOppi_data - INFO : save new data to db: IOOppi_eb_t: no new data
2025-09-15 20:00:59,689 - IOOppi_data - INFO : save diff data to db: IOOppi_eb_t: no diff data
2025-09-15 20:00:59,695 - IOOppi_data - INFO : save data to db IOOppi_eb_g data:
date value
1743 2025-09-11 7394.0
1744 2025-09-12 7314.0
1745 2025-09-13 7320.0
1746 2025-09-14 7320.0
1747 2025-09-15 7314.0
2025-09-15 20:01:03,647 - IOOppi_data - INFO : save new data to db: IOOppi_eb_g: no new data
2025-09-15 20:01:03,647 - 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-15 20:01:04,371 - IOOppi_data - INFO : save data to db IOOppi_SR_t data:
date value
3854 2025-09-11 5855.0
3855 2025-09-12 5855.0
3856 2025-09-13 5855.0
3857 2025-09-14 5855.0
3858 2025-09-15 5850.0
2025-09-15 20:01:06,385 - IOOppi_data - INFO : save new data to db: IOOppi_SR_t: no new data
2025-09-15 20:01:06,385 - IOOppi_data - INFO : save diff data to db: IOOppi_SR_t: no diff data
2025-09-15 20:01:06,390 - IOOppi_data - INFO : save data to db IOOppi_SR_g data:
date value
3854 2025-09-11 5855.0
3855 2025-09-12 5855.0
3856 2025-09-13 5855.0
3857 2025-09-14 5855.0
3858 2025-09-15 5850.0
2025-09-15 20:01:09,163 - IOOppi_data - INFO : save new data to db: IOOppi_SR_g: no new data
2025-09-15 20:01:09,163 - 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-15 20:01:09,800 - IOOppi_data - INFO : save data to db IOOppi_ss_t data:
date value
1744 2025-09-11 13055.0
1745 2025-09-12 13067.5
1746 2025-09-13 13067.5
1747 2025-09-14 13067.5
1748 2025-09-15 13092.5
2025-09-15 20:01:14,672 - IOOppi_data - INFO : save new data to db: IOOppi_ss_t: no new data
2025-09-15 20:01:14,672 - IOOppi_data - INFO : save diff data to db: IOOppi_ss_t: no diff data
2025-09-15 20:01:14,677 - IOOppi_data - INFO : save data to db IOOppi_ss_g data:
date value
1744 2025-09-11 13055.0
1745 2025-09-12 13067.5
1746 2025-09-13 13067.5
1747 2025-09-14 13067.5
1748 2025-09-15 13092.5
2025-09-15 20:01:16,605 - IOOppi_data - INFO : save new data to db: IOOppi_ss_g: no new data
2025-09-15 20:01:16,606 - 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-15 20:01:17,314 - IOOppi_data - INFO : save data to db IOOppi_RS_t data:
date value
3254 2025-09-11 10020.00
3255 2025-09-12 10000.00
3256 2025-09-13 10000.00
3257 2025-09-14 10000.00
3258 2025-09-15 10026.67
2025-09-15 20:01:24,324 - IOOppi_data - INFO : save new data to db: IOOppi_RS_t: no new data
2025-09-15 20:01:24,325 - IOOppi_data - INFO : save diff data to db: IOOppi_RS_t: no diff data
2025-09-15 20:01:24,330 - IOOppi_data - INFO : save data to db IOOppi_RS_g data:
date value
3254 2025-09-11 10020.00
3255 2025-09-12 10000.00
3256 2025-09-13 10000.00
3257 2025-09-14 10000.00
3258 2025-09-15 10026.67
2025-09-15 20:01:47,948 - IOOppi_data - INFO : save new data to db: IOOppi_RS_g: no new data
2025-09-15 20:01:47,948 - 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-15 20:01:48,559 - IOOppi_data - INFO : save data to db IOOppi_RM_t data:
date value
3377 2025-09-11 2665.0
3378 2025-09-12 2680.0
3379 2025-09-13 2680.0
3380 2025-09-14 2680.0
3381 2025-09-15 2635.0
2025-09-15 20:01:53,549 - IOOppi_data - INFO : save new data to db: IOOppi_RM_t: no new data
2025-09-15 20:01:53,549 - IOOppi_data - INFO : save diff data to db: IOOppi_RM_t: no diff data
2025-09-15 20:01:53,555 - IOOppi_data - INFO : save data to db IOOppi_RM_g data:
date value
3377 2025-09-11 2665.0
3378 2025-09-12 2680.0
3379 2025-09-13 2680.0
3380 2025-09-14 2680.0
3381 2025-09-15 2635.0
2025-09-15 20:02:48,622 - IOOppi_data - INFO : save new data to db: IOOppi_RM_g: no new data
2025-09-15 20:02:48,622 - 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-15 20:02:49,239 - IOOppi_data - INFO : save data to db IOOppi_SA_t data:
date value
1581 2025-09-11 1262.5
1582 2025-09-12 1262.5
1583 2025-09-13 1262.5
1584 2025-09-14 1262.5
1585 2025-09-15 1262.5
2025-09-15 20:03:05,852 - IOOppi_data - INFO : save new data to db: IOOppi_SA_t: no new data
2025-09-15 20:03:05,852 - IOOppi_data - INFO : save diff data to db: IOOppi_SA_t: no diff data
2025-09-15 20:03:05,857 - IOOppi_data - INFO : save data to db IOOppi_SA_g data:
date value
1581 2025-09-11 1262.5
1582 2025-09-12 1262.5
1583 2025-09-13 1262.5
1584 2025-09-14 1262.5
1585 2025-09-15 1262.5
2025-09-15 20:03:06,370 - IOOppi_data - INFO : save new data to db: IOOppi_SA_g: no new data
2025-09-15 20:03:06,370 - 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-15 20:03:06,980 - IOOppi_data - INFO : save data to db IOOppi_PF_t data:
date value
1494 2025-09-11 6471.33
1495 2025-09-12 6457.00
1496 2025-09-13 6457.00
1497 2025-09-14 6457.00
1498 2025-09-15 6471.00
2025-09-15 20:03:11,285 - IOOppi_data - INFO : save new data to db: IOOppi_PF_t: no new data
2025-09-15 20:03:11,285 - IOOppi_data - INFO : save diff data to db: IOOppi_PF_t: no diff data
2025-09-15 20:03:11,290 - IOOppi_data - INFO : save data to db IOOppi_PF_g data:
date value
1494 2025-09-11 6471.33
1495 2025-09-12 6457.00
1496 2025-09-13 6457.00
1497 2025-09-14 6457.00
1498 2025-09-15 6471.00
2025-09-15 20:03:17,254 - IOOppi_data - INFO : save new data to db: IOOppi_PF_g: no new data
2025-09-15 20:03:17,254 - 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-15 20:03:17,885 - IOOppi_data - INFO : save data to db IOOppi_m_t data:
date value
3867 2025-09-11 3060.0
3868 2025-09-12 3060.0
3869 2025-09-13 3060.0
3870 2025-09-14 3060.0
3871 2025-09-15 3058.0
2025-09-15 20:03:27,413 - IOOppi_data - INFO : save new data to db: IOOppi_m_t: no new data
2025-09-15 20:03:27,414 - IOOppi_data - INFO : save diff data to db: IOOppi_m_t: no diff data
2025-09-15 20:03:27,420 - IOOppi_data - INFO : save data to db IOOppi_m_g data:
date value
3867 2025-09-11 3060.0
3868 2025-09-12 3060.0
3869 2025-09-13 3060.0
3870 2025-09-14 3060.0
3871 2025-09-15 3058.0
2025-09-15 20:05:36,850 - IOOppi_data - INFO : save new data to db: IOOppi_m_g: no new data
2025-09-15 20:05:36,850 - 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-15 20:05:37,512 - IOOppi_data - INFO : save data to db IOOppi_y_t data:
date value
3637 2025-09-11 8408.0
3638 2025-09-12 8398.0
3639 2025-09-13 8398.0
3640 2025-09-14 8398.0
3641 2025-09-15 8448.0
2025-09-15 20:05:46,653 - IOOppi_data - INFO : save new data to db: IOOppi_y_t: no new data
2025-09-15 20:05:46,653 - IOOppi_data - INFO : save diff data to db: IOOppi_y_t: no diff data
2025-09-15 20:05:46,659 - IOOppi_data - INFO : save data to db IOOppi_y_g data:
date value
3637 2025-09-11 8408.0
3638 2025-09-12 8398.0
3639 2025-09-13 8398.0
3640 2025-09-14 8398.0
3641 2025-09-15 8448.0
2025-09-15 20:06:07,434 - IOOppi_data - INFO : save new data to db: IOOppi_y_g: no new data
2025-09-15 20:06:07,434 - 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-15 20:06:08,021 - IOOppi_data - INFO : save data to db IOOppi_a_t data:
date value
3603 2025-09-11 4305.0
3604 2025-09-12 4305.0
3605 2025-09-13 4305.0
3606 2025-09-14 4305.0
3607 2025-09-15 4305.0
2025-09-15 20:06:12,239 - IOOppi_data - INFO : save new data to db: IOOppi_a_t: no new data
2025-09-15 20:06:12,239 - IOOppi_data - INFO : save diff data to db: IOOppi_a_t: no diff data
2025-09-15 20:06:12,245 - IOOppi_data - INFO : save data to db IOOppi_a_g data:
date value
3603 2025-09-11 4305.0
3604 2025-09-12 4305.0
3605 2025-09-13 4305.0
3606 2025-09-14 4305.0
3607 2025-09-15 4305.0
2025-09-15 20:06:28,189 - IOOppi_data - INFO : save new data to db: IOOppi_a_g: no new data
2025-09-15 20:06:28,189 - 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-15 20:06:28,782 - IOOppi_data - INFO : save data to db IOOppi_SF_t data:
date value
2980 2025-09-11 5264.29
2981 2025-09-12 5245.71
2982 2025-09-13 5245.71
2983 2025-09-14 5245.71
2984 2025-09-15 5245.71
2025-09-15 20:06:40,117 - IOOppi_data - INFO : save new data to db: IOOppi_SF_t: no new data
2025-09-15 20:06:40,118 - IOOppi_data - INFO : save diff data to db: IOOppi_SF_t: no diff data
2025-09-15 20:06:40,123 - IOOppi_data - INFO : save data to db IOOppi_SF_g data:
date value
2980 2025-09-11 5264.29
2981 2025-09-12 5245.71
2982 2025-09-13 5245.71
2983 2025-09-14 5245.71
2984 2025-09-15 5245.71
2025-09-15 20:06:50,183 - IOOppi_data - INFO : save new data to db: IOOppi_SF_g: no new data
2025-09-15 20:06:50,183 - 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-15 20:06:50,834 - IOOppi_data - INFO : save data to db IOOppi_jd_t data:
date value
3180 2025-09-11 3640.0
3181 2025-09-12 3675.0
3182 2025-09-13 3675.0
3183 2025-09-14 3675.0
3184 2025-09-15 3840.0
2025-09-15 20:07:05,556 - IOOppi_data - INFO : save new data to db IOOppi_jd_t: date value ... created_at updated_at
3182 2025-09-13 3675.0 ... 2025-09-15 20:07:05.548083 2025-09-15 20:07:05.548513
3183 2025-09-14 3675.0 ... 2025-09-15 20:07:05.548083 2025-09-15 20:07:05.548513
3184 2025-09-15 3840.0 ... 2025-09-15 20:07:05.548083 2025-09-15 20:07:05.548513
[3 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-15 20:07:09,978 - IOOppi_data - INFO : save diff data to db IOOppi_jd_t: date ... updated_at
39 2014-01-03 ... 2025-09-15 20:07:09.969382
458 2015-09-21 ... 2025-09-15 20:07:09.969382
549 2016-02-03 ... 2025-09-15 20:07:09.969382
693 2016-09-05 ... 2025-09-15 20:07:09.969382
696 2016-09-08 ... 2025-09-15 20:07:09.969382
[5 rows x 6 columns]
2025-09-15 20:07:10,214 - IOOppi_data - INFO : save data to db IOOppi_jd_g data:
date value
3180 2025-09-11 3640.0
3181 2025-09-12 3675.0
3182 2025-09-13 3675.0
3183 2025-09-14 3675.0
3184 2025-09-15 3840.0
2025-09-15 20:07:12,746 - IOOppi_data - INFO : save new data to db IOOppi_jd_g: date value ... created_at updated_at
3185 2025-09-13 3675.0 ... 2025-09-15 20:07:12.734684 2025-09-15 20:07:12.735273
3186 2025-09-14 3675.0 ... 2025-09-15 20:07:12.734684 2025-09-15 20:07:12.735273
3187 2025-09-15 3840.0 ... 2025-09-15 20:07:12.734684 2025-09-15 20:07:12.735273
[3 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-15 20:07:17,797 - IOOppi_data - INFO : save diff data to db IOOppi_jd_g: date ... updated_at
39 2014-01-03 ... 2025-09-15 20:07:17.789772
458 2015-09-21 ... 2025-09-15 20:07:17.789772
549 2016-02-03 ... 2025-09-15 20:07:17.789772
693 2016-09-05 ... 2025-09-15 20:07:17.789772
696 2016-09-08 ... 2025-09-15 20:07:17.789772
[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-15 20:07:18,612 - IOOppi_data - INFO : save data to db IOOppi_SI_t data:
date value
984 2025-09-11 9390.0
985 2025-09-12 9450.0
986 2025-09-13 9450.0
987 2025-09-14 9450.0
988 2025-09-15 9450.0
2025-09-15 20:07:18,874 - IOOppi_data - INFO : save new data to db IOOppi_SI_t: date value ... created_at updated_at
986 2025-09-13 9450.0 ... 2025-09-15 20:07:18.867067 2025-09-15 20:07:18.867452
987 2025-09-14 9450.0 ... 2025-09-15 20:07:18.867067 2025-09-15 20:07:18.867452
988 2025-09-15 9450.0 ... 2025-09-15 20:07:18.867067 2025-09-15 20:07:18.867452
[3 rows x 5 columns]
2025-09-15 20:07:18,893 - IOOppi_data - INFO : save diff data to db: IOOppi_SI_t: no diff data
2025-09-15 20:07:18,898 - IOOppi_data - INFO : save data to db IOOppi_SI_g data:
date value
984 2025-09-11 9390.0
985 2025-09-12 9450.0
986 2025-09-13 9450.0
987 2025-09-14 9450.0
988 2025-09-15 9450.0
2025-09-15 20:07:19,769 - IOOppi_data - INFO : save new data to db IOOppi_SI_g: date value ... created_at updated_at
986 2025-09-13 9450.0 ... 2025-09-15 20:07:19.760981 2025-09-15 20:07:19.761377
987 2025-09-14 9450.0 ... 2025-09-15 20:07:19.760981 2025-09-15 20:07:19.761377
988 2025-09-15 9450.0 ... 2025-09-15 20:07:19.760981 2025-09-15 20:07:19.761377
[3 rows x 5 columns]
2025-09-15 20:07:19,788 - 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-15 20:07:21,269 - IOOppi_data - INFO : save data to db IOOppi_l_t data:
date value
3863 2025-09-11 7391.67
3864 2025-09-12 7380.00
3865 2025-09-13 7380.00
3866 2025-09-14 7380.00
3867 2025-09-15 7378.33
2025-09-15 20:07:23,229 - IOOppi_data - INFO : save new data to db IOOppi_l_t: date value ... created_at updated_at
3865 2025-09-13 7380.00 ... 2025-09-15 20:07:23.222262 2025-09-15 20:07:23.222685
3866 2025-09-14 7380.00 ... 2025-09-15 20:07:23.222262 2025-09-15 20:07:23.222685
3867 2025-09-15 7378.33 ... 2025-09-15 20:07:23.222262 2025-09-15 20:07:23.222685
[3 rows x 5 columns]
2025-09-15 20:07:23,452 - IOOppi_data - INFO : save diff data to db: IOOppi_l_t: no diff data
2025-09-15 20:07:23,458 - IOOppi_data - INFO : save data to db IOOppi_l_g data:
date value
3863 2025-09-11 7391.67
3864 2025-09-12 7380.00
3865 2025-09-13 7380.00
3866 2025-09-14 7380.00
3867 2025-09-15 7378.33
2025-09-15 20:07:34,941 - IOOppi_data - INFO : save new data to db IOOppi_l_g: date value ... created_at updated_at
3868 2025-09-13 7380.00 ... 2025-09-15 20:07:34.933788 2025-09-15 20:07:34.934180
3869 2025-09-14 7380.00 ... 2025-09-15 20:07:34.933788 2025-09-15 20:07:34.934180
3870 2025-09-15 7378.33 ... 2025-09-15 20:07:34.933788 2025-09-15 20:07:34.934180
[3 rows x 5 columns]
2025-09-15 20:07:34,961 - 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-15 20:07:35,577 - IOOppi_data - INFO : save data to db IOOppi_bu_t data:
date value
3201 2025-09-11 3653.33
3202 2025-09-12 3635.00
3203 2025-09-13 3635.00
3204 2025-09-14 3633.33
3205 2025-09-15 3630.00
2025-09-15 20:08:36,294 - IOOppi_data - INFO : save new data to db IOOppi_bu_t: date value ... created_at updated_at
3204 2025-09-13 3635.00 ... 2025-09-15 20:08:36.286719 2025-09-15 20:08:36.287142
3205 2025-09-14 3633.33 ... 2025-09-15 20:08:36.286719 2025-09-15 20:08:36.287142
3206 2025-09-15 3630.00 ... 2025-09-15 20:08:36.286719 2025-09-15 20:08:36.287142
[3 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-15 20:08:36,330 - IOOppi_data - INFO : save diff data to db IOOppi_bu_t: date ... updated_at
2560 2023-12-09 ... 2025-09-15 20:08:36.322558
[1 rows x 6 columns]
2025-09-15 20:08:36,354 - IOOppi_data - INFO : save data to db IOOppi_bu_g data:
date value
3201 2025-09-11 3653.33
3202 2025-09-12 3635.00
3203 2025-09-13 3635.00
3204 2025-09-14 3633.33
3205 2025-09-15 3630.00
2025-09-15 20:09:55,295 - IOOppi_data - INFO : save new data to db IOOppi_bu_g: date value ... created_at updated_at
3206 2025-09-13 3635.00 ... 2025-09-15 20:09:55.287221 2025-09-15 20:09:55.287641
3207 2025-09-14 3633.33 ... 2025-09-15 20:09:55.287221 2025-09-15 20:09:55.287641
3208 2025-09-15 3630.00 ... 2025-09-15 20:09:55.287221 2025-09-15 20:09:55.287641
[3 rows x 5 columns]
2025-09-15 20:09:59,320 - 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-15 20:10:00,008 - IOOppi_data - INFO : save data to db IOOppi_al_t data:
date value
3866 2025-09-11 20693.33
3867 2025-09-12 21056.67
3868 2025-09-13 21056.67
3869 2025-09-14 21056.67
3870 2025-09-15 21056.67
2025-09-15 20:21:07,118 - IOOppi_data - INFO : save new data to db IOOppi_al_t: date ... updated_at
3868 2025-09-13 ... 2025-09-15 20:21:07.111327
3869 2025-09-14 ... 2025-09-15 20:21:07.111327
3870 2025-09-15 ... 2025-09-15 20:21:07.111327
[3 rows x 5 columns]
2025-09-15 20:21:08,572 - IOOppi_data - INFO : save diff data to db: IOOppi_al_t: no diff data
2025-09-15 20:21:08,578 - IOOppi_data - INFO : save data to db IOOppi_al_g data:
date value
3866 2025-09-11 20693.33
3867 2025-09-12 21056.67
3868 2025-09-13 21056.67
3869 2025-09-14 21056.67
3870 2025-09-15 21056.67
2025-09-15 20:24:07,902 - IOOppi_data - INFO : save new data to db IOOppi_al_g: date ... updated_at
3871 2025-09-13 ... 2025-09-15 20:24:07.895819
3872 2025-09-14 ... 2025-09-15 20:24:07.895819
3873 2025-09-15 ... 2025-09-15 20:24:07.895819
[3 rows x 5 columns]
2025-09-15 20:24:09,192 - 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-15 20:24:10,603 - IOOppi_data - INFO : save data to db IOOppi_SM_t data:
date value
2980 2025-09-11 5676.0
2981 2025-09-12 5666.0
2982 2025-09-13 5666.0
2983 2025-09-14 5666.0
2984 2025-09-15 5678.0
2025-09-15 20:24:17,450 - IOOppi_data - INFO : save new data to db IOOppi_SM_t: date value ... created_at updated_at
2982 2025-09-13 5666.0 ... 2025-09-15 20:24:17.442697 2025-09-15 20:24:17.443107
2983 2025-09-14 5666.0 ... 2025-09-15 20:24:17.442697 2025-09-15 20:24:17.443107
2984 2025-09-15 5678.0 ... 2025-09-15 20:24:17.442697 2025-09-15 20:24:17.443107
[3 rows x 5 columns]
2025-09-15 20:24:17,673 - IOOppi_data - INFO : save diff data to db: IOOppi_SM_t: no diff data
2025-09-15 20:24:17,680 - IOOppi_data - INFO : save data to db IOOppi_SM_g data:
date value
2980 2025-09-11 5676.0
2981 2025-09-12 5666.0
2982 2025-09-13 5666.0
2983 2025-09-14 5666.0
2984 2025-09-15 5678.0
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 450, 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_a_t']
(Background on this error at: https://sqlalche.me/e/20/e3q8)
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 696, in _read_packet
packet_header = self._read_bytes(4)
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 450, 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 696, in _read_packet
packet_header = self._read_bytes(4)
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_jd_t']
(Background on this error at: https://sqlalche.me/e/20/e3q8)
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_SM_g']
(Background on this error at: https://sqlalche.me/e/20/e3q8)