=========================================================================
2025-09-12 17:50:26 Fri 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-12 17:50:36,455 - IOOppi_data - INFO : save data to db IOOppi_rb_t data:
date value
3420 2025-09-08 3149.5
3421 2025-09-09 3153.5
3422 2025-09-10 3139.5
3423 2025-09-11 3123.5
3424 2025-09-12 3124.0
2025-09-12 17:50:39,282 - IOOppi_data - INFO : save new data to db IOOppi_rb_t: date value ... created_at updated_at
3424 2025-09-12 3124.0 ... 2025-09-12 17:50:39.274045 2025-09-12 17:50:39.274450
[1 rows x 5 columns]
2025-09-12 17:50:39,305 - IOOppi_data - INFO : save diff data to db: IOOppi_rb_t: no diff data
2025-09-12 17:50:39,311 - IOOppi_data - INFO : save data to db IOOppi_rb_g data:
date value
3420 2025-09-08 3149.5
3421 2025-09-09 3153.5
3422 2025-09-10 3139.5
3423 2025-09-11 3123.5
3424 2025-09-12 3124.0
2025-09-12 17:50:40,435 - IOOppi_data - INFO : save new data to db IOOppi_rb_g: date value ... created_at updated_at
3427 2025-09-12 3124.0 ... 2025-09-12 17:50:40.428495 2025-09-12 17:50:40.428923
[1 rows x 5 columns]
2025-09-12 17:50:40,659 - 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-12 17:50:41,273 - IOOppi_data - INFO : save data to db IOOppi_MA_t data:
date value
3641 2025-09-08 2271.67
3642 2025-09-09 2277.83
3643 2025-09-10 2296.67
3644 2025-09-11 2290.00
3645 2025-09-12 2288.33
2025-09-12 17:50:42,705 - IOOppi_data - INFO : save new data to db IOOppi_MA_t: date value ... created_at updated_at
3645 2025-09-12 2288.33 ... 2025-09-12 17:50:42.697911 2025-09-12 17:50:42.698319
[1 rows x 5 columns]
2025-09-12 17:50:44,244 - IOOppi_data - INFO : save diff data to db: IOOppi_MA_t: no diff data
2025-09-12 17:50:44,250 - IOOppi_data - INFO : save data to db IOOppi_MA_g data:
date value
3641 2025-09-08 2271.67
3642 2025-09-09 2277.83
3643 2025-09-10 2296.67
3644 2025-09-11 2290.00
3645 2025-09-12 2288.33
2025-09-12 17:50:49,596 - IOOppi_data - INFO : save new data to db IOOppi_MA_g: date value ... created_at updated_at
3649 2025-09-12 2288.33 ... 2025-09-12 17:50:49.588713 2025-09-12 17:50:49.589167
[1 rows x 5 columns]
2025-09-12 17:50:50,228 - 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-12 17:50:50,884 - IOOppi_data - INFO : save data to db IOOppi_PTA_t data:
date value
981 2025-09-08 4720.00
982 2025-09-09 4643.50
983 2025-09-10 4649.16
984 2025-09-11 4649.16
985 2025-09-12 4636.66
2025-09-12 17:50:51,980 - IOOppi_data - INFO : save new data to db IOOppi_PTA_t: date value ... created_at updated_at
985 2025-09-12 4636.66 ... 2025-09-12 17:50:51.972447 2025-09-12 17:50:51.972888
[1 rows x 5 columns]
2025-09-12 17:50:52,822 - IOOppi_data - INFO : save diff data to db: IOOppi_PTA_t: no diff data
2025-09-12 17:50:52,828 - IOOppi_data - INFO : save data to db IOOppi_PTA_g data:
date value
981 2025-09-08 4720.00
982 2025-09-09 4643.50
983 2025-09-10 4649.16
984 2025-09-11 4649.16
985 2025-09-12 4636.66
2025-09-12 17:50:54,800 - IOOppi_data - INFO : save new data to db IOOppi_PTA_g: date value ... created_at updated_at
985 2025-09-12 4636.66 ... 2025-09-12 17:50:54.792399 2025-09-12 17:50:54.792816
[1 rows x 5 columns]
2025-09-12 17:50:58,517 - 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-12 17:50:59,139 - IOOppi_data - INFO : save data to db IOOppi_ru_t data:
date value
3860 2025-09-08 15416.67
3861 2025-09-09 15175.00
3862 2025-09-10 15150.00
3863 2025-09-11 15058.33
3864 2025-09-12 14983.33
2025-09-12 17:51:11,230 - IOOppi_data - INFO : save new data to db IOOppi_ru_t: date ... updated_at
3864 2025-09-12 ... 2025-09-12 17:51:11.223227
[1 rows x 5 columns]
2025-09-12 17:51:12,426 - IOOppi_data - INFO : save diff data to db: IOOppi_ru_t: no diff data
2025-09-12 17:51:12,432 - IOOppi_data - INFO : save data to db IOOppi_ru_g data:
date value
3860 2025-09-08 15416.67
3861 2025-09-09 15175.00
3862 2025-09-10 15150.00
3863 2025-09-11 15058.33
3864 2025-09-12 14983.33
2025-09-12 17:51:33,149 - IOOppi_data - INFO : save new data to db IOOppi_ru_g: date ... updated_at
3867 2025-09-12 ... 2025-09-12 17:51:33.143800
[1 rows x 5 columns]
2025-09-12 17:51:33,372 - 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-12 17:51:33,979 - IOOppi_data - INFO : save data to db IOOppi_i_t data:
date value
3192 2025-09-08 795.44
3193 2025-09-09 800.11
3194 2025-09-10 808.67
3195 2025-09-11 812.33
3196 2025-09-12 808.00
2025-09-12 17:51:39,792 - IOOppi_data - INFO : save new data to db IOOppi_i_t: date value ... created_at updated_at
3196 2025-09-12 808.0 ... 2025-09-12 17:51:39.785411 2025-09-12 17:51:39.785865
[1 rows x 5 columns]
2025-09-12 17:51:40,016 - IOOppi_data - INFO : save diff data to db: IOOppi_i_t: no diff data
2025-09-12 17:51:40,022 - IOOppi_data - INFO : save data to db IOOppi_i_g data:
date value
3192 2025-09-08 795.44
3193 2025-09-09 800.11
3194 2025-09-10 808.67
3195 2025-09-11 812.33
3196 2025-09-12 808.00
2025-09-12 17:51:49,754 - IOOppi_data - INFO : save new data to db IOOppi_i_g: date value ... created_at updated_at
3199 2025-09-12 808.0 ... 2025-09-12 17:51:49.747419 2025-09-12 17:51:49.747840
[1 rows x 5 columns]
2025-09-12 17:51:51,523 - 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-12 17:51:52,121 - IOOppi_data - INFO : save data to db IOOppi_FG_t data:
date value
3395 2025-09-08 1120.0
3396 2025-09-09 1140.0
3397 2025-09-10 1140.0
3398 2025-09-11 1130.4
3399 2025-09-12 1130.4
2025-09-12 17:52:05,652 - IOOppi_data - INFO : save new data to db IOOppi_FG_t: date value ... created_at updated_at
3399 2025-09-12 1130.4 ... 2025-09-12 17:52:05.644652 2025-09-12 17:52:05.645045
[1 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-12 17:53:49,323 - IOOppi_data - INFO : save diff data to db IOOppi_FG_t: date ... updated_at
12 2012-12-19 ... 2025-09-12 17:53:49.315341
21 2013-01-04 ... 2025-09-12 17:53:49.315341
54 2013-02-27 ... 2025-09-12 17:53:49.315341
60 2013-03-07 ... 2025-09-12 17:53:49.315341
61 2013-03-08 ... 2025-09-12 17:53:49.315341
[5 rows x 6 columns]
2025-09-12 17:53:54,365 - IOOppi_data - INFO : save data to db IOOppi_FG_g data:
date value
3395 2025-09-08 1120.0
3396 2025-09-09 1140.0
3397 2025-09-10 1140.0
3398 2025-09-11 1130.4
3399 2025-09-12 1130.4
2025-09-12 17:54:02,037 - IOOppi_data - INFO : save new data to db IOOppi_FG_g: date value ... created_at updated_at
3403 2025-09-12 1130.4 ... 2025-09-12 17:54:02.030078 2025-09-12 17:54:02.030600
[1 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-12 17:55:50,426 - IOOppi_data - INFO : save diff data to db IOOppi_FG_g: date ... updated_at
12 2012-12-19 ... 2025-09-12 17:55:50.418758
21 2013-01-04 ... 2025-09-12 17:55:50.418758
54 2013-02-27 ... 2025-09-12 17:55:50.418758
60 2013-03-07 ... 2025-09-12 17:55:50.418758
61 2013-03-08 ... 2025-09-12 17:55:50.418758
[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-12 17:55:55,039 - IOOppi_data - INFO : save data to db IOOppi_eb_t data:
date value
1740 2025-09-08 7400.0
1741 2025-09-09 7394.0
1742 2025-09-10 7394.0
1743 2025-09-11 7394.0
1744 2025-09-12 7314.0
2025-09-12 17:55:59,194 - IOOppi_data - INFO : save new data to db IOOppi_eb_t: date value ... created_at updated_at
1744 2025-09-12 7314.0 ... 2025-09-12 17:55:59.187491 2025-09-12 17:55:59.187913
[1 rows x 5 columns]
2025-09-12 17:55:59,213 - IOOppi_data - INFO : save diff data to db: IOOppi_eb_t: no diff data
2025-09-12 17:55:59,219 - IOOppi_data - INFO : save data to db IOOppi_eb_g data:
date value
1740 2025-09-08 7400.0
1741 2025-09-09 7394.0
1742 2025-09-10 7394.0
1743 2025-09-11 7394.0
1744 2025-09-12 7314.0
2025-09-12 17:56:08,087 - IOOppi_data - INFO : save new data to db IOOppi_eb_g: date value ... created_at updated_at
1747 2025-09-12 7314.0 ... 2025-09-12 17:56:08.079649 2025-09-12 17:56:08.080044
[1 rows x 5 columns]
2025-09-12 17:56:08,105 - 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-12 17:56:08,659 - IOOppi_data - INFO : save data to db IOOppi_SR_t data:
date value
3851 2025-09-08 5905.00
3852 2025-09-09 5875.00
3853 2025-09-10 5856.67
3854 2025-09-11 5855.00
3855 2025-09-12 5855.00
2025-09-12 17:56:09,718 - IOOppi_data - INFO : save new data to db IOOppi_SR_t: date value ... created_at updated_at
3855 2025-09-12 5855.0 ... 2025-09-12 17:56:09.710714 2025-09-12 17:56:09.711109
[1 rows x 5 columns]
2025-09-12 17:56:09,736 - IOOppi_data - INFO : save diff data to db: IOOppi_SR_t: no diff data
2025-09-12 17:56:09,743 - IOOppi_data - INFO : save data to db IOOppi_SR_g data:
date value
3851 2025-09-08 5905.00
3852 2025-09-09 5875.00
3853 2025-09-10 5856.67
3854 2025-09-11 5855.00
3855 2025-09-12 5855.00
2025-09-12 17:56:11,763 - IOOppi_data - INFO : save new data to db IOOppi_SR_g: date value ... created_at updated_at
3859 2025-09-12 5855.0 ... 2025-09-12 17:56:11.755962 2025-09-12 17:56:11.756415
[1 rows x 5 columns]
2025-09-12 17:56:11,782 - 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-12 17:56:12,399 - IOOppi_data - INFO : save data to db IOOppi_ss_t data:
date value
1741 2025-09-08 13080.0
1742 2025-09-09 13080.0
1743 2025-09-10 13055.0
1744 2025-09-11 13055.0
1745 2025-09-12 13067.5
2025-09-12 17:56:15,365 - IOOppi_data - INFO : save new data to db IOOppi_ss_t: date value ... created_at updated_at
1745 2025-09-12 13067.5 ... 2025-09-12 17:56:15.358297 2025-09-12 17:56:15.358706
[1 rows x 5 columns]
2025-09-12 17:56:15,384 - IOOppi_data - INFO : save diff data to db: IOOppi_ss_t: no diff data
2025-09-12 17:56:15,389 - IOOppi_data - INFO : save data to db IOOppi_ss_g data:
date value
1741 2025-09-08 13080.0
1742 2025-09-09 13080.0
1743 2025-09-10 13055.0
1744 2025-09-11 13055.0
1745 2025-09-12 13067.5
2025-09-12 17:56:43,151 - IOOppi_data - INFO : save new data to db IOOppi_ss_g: date value ... created_at updated_at
1748 2025-09-12 13067.5 ... 2025-09-12 17:56:43.141362 2025-09-12 17:56:43.141937
[1 rows x 5 columns]
2025-09-12 17:56:43,172 - 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-12 17:56:45,637 - IOOppi_data - INFO : save data to db IOOppi_RS_t data:
date value
3251 2025-09-08 9941.67
3252 2025-09-09 9980.00
3253 2025-09-10 9920.00
3254 2025-09-11 10020.00
3255 2025-09-12 10000.00
2025-09-12 17:57:22,505 - IOOppi_data - INFO : save new data to db IOOppi_RS_t: date value ... created_at updated_at
3255 2025-09-12 10000.0 ... 2025-09-12 17:57:22.498062 2025-09-12 17:57:22.498474
[1 rows x 5 columns]
2025-09-12 17:57:23,145 - IOOppi_data - INFO : save diff data to db: IOOppi_RS_t: no diff data
2025-09-12 17:57:23,152 - IOOppi_data - INFO : save data to db IOOppi_RS_g data:
date value
3251 2025-09-08 9941.67
3252 2025-09-09 9980.00
3253 2025-09-10 9920.00
3254 2025-09-11 10020.00
3255 2025-09-12 10000.00
2025-09-12 17:57:27,000 - IOOppi_data - INFO : save new data to db IOOppi_RS_g: date value ... created_at updated_at
3259 2025-09-12 10000.0 ... 2025-09-12 17:57:26.993251 2025-09-12 17:57:26.993676
[1 rows x 5 columns]
2025-09-12 17:57:27,225 - 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-12 17:57:27,873 - IOOppi_data - INFO : save data to db IOOppi_RM_t data:
date value
3374 2025-09-08 2650.00
3375 2025-09-09 2653.33
3376 2025-09-10 2658.33
3377 2025-09-11 2665.00
3378 2025-09-12 2680.00
2025-09-12 17:57:44,973 - IOOppi_data - INFO : save new data to db IOOppi_RM_t: date value ... created_at updated_at
3378 2025-09-12 2680.0 ... 2025-09-12 17:57:44.965979 2025-09-12 17:57:44.966364
[1 rows x 5 columns]
2025-09-12 17:57:46,013 - IOOppi_data - INFO : save diff data to db: IOOppi_RM_t: no diff data
2025-09-12 17:57:46,019 - IOOppi_data - INFO : save data to db IOOppi_RM_g data:
date value
3374 2025-09-08 2650.00
3375 2025-09-09 2653.33
3376 2025-09-10 2658.33
3377 2025-09-11 2665.00
3378 2025-09-12 2680.00
2025-09-12 17:57:54,030 - IOOppi_data - INFO : save new data to db IOOppi_RM_g: date value ... created_at updated_at
3382 2025-09-12 2680.0 ... 2025-09-12 17:57:54.022762 2025-09-12 17:57:54.023171
[1 rows x 5 columns]
2025-09-12 17:57:55,279 - 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-12 17:57:56,003 - IOOppi_data - INFO : save data to db IOOppi_SA_t data:
date value
1578 2025-09-08 1262.5
1579 2025-09-09 1262.5
1580 2025-09-10 1262.5
1581 2025-09-11 1262.5
1582 2025-09-12 1262.5
2025-09-12 17:57:59,806 - IOOppi_data - INFO : save new data to db IOOppi_SA_t: date value ... created_at updated_at
1582 2025-09-12 1262.5 ... 2025-09-12 17:57:59.798819 2025-09-12 17:57:59.799203
[1 rows x 5 columns]
2025-09-12 17:58:01,263 - IOOppi_data - INFO : save diff data to db: IOOppi_SA_t: no diff data
2025-09-12 17:58:01,269 - IOOppi_data - INFO : save data to db IOOppi_SA_g data:
date value
1578 2025-09-08 1262.5
1579 2025-09-09 1262.5
1580 2025-09-10 1262.5
1581 2025-09-11 1262.5
1582 2025-09-12 1262.5
2025-09-12 17:58:31,211 - IOOppi_data - INFO : save new data to db IOOppi_SA_g: date value ... created_at updated_at
1586 2025-09-12 1262.5 ... 2025-09-12 17:58:31.204198 2025-09-12 17:58:31.204596
[1 rows x 5 columns]
2025-09-12 17:58:31,460 - 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-12 17:58:32,077 - IOOppi_data - INFO : save data to db IOOppi_PF_t data:
date value
1491 2025-09-08 6448.33
1492 2025-09-09 6454.83
1493 2025-09-10 6463.50
1494 2025-09-11 6471.33
1495 2025-09-12 6457.00
2025-09-12 17:58:32,159 - IOOppi_data - INFO : save new data to db IOOppi_PF_t: date value ... created_at updated_at
1495 2025-09-12 6457.0 ... 2025-09-12 17:58:32.152093 2025-09-12 17:58:32.152543
[1 rows x 5 columns]
2025-09-12 17:58:34,040 - IOOppi_data - INFO : save diff data to db: IOOppi_PF_t: no diff data
2025-09-12 17:58:34,046 - IOOppi_data - INFO : save data to db IOOppi_PF_g data:
date value
1491 2025-09-08 6448.33
1492 2025-09-09 6454.83
1493 2025-09-10 6463.50
1494 2025-09-11 6471.33
1495 2025-09-12 6457.00
2025-09-12 17:58:51,915 - IOOppi_data - INFO : save new data to db IOOppi_PF_g: date value ... created_at updated_at
1499 2025-09-12 6457.0 ... 2025-09-12 17:58:51.907603 2025-09-12 17:58:51.908016
[1 rows x 5 columns]
2025-09-12 17:58:52,996 - 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-12 17:58:54,429 - IOOppi_data - INFO : save data to db IOOppi_m_t data:
date value
3864 2025-09-08 3084.0
3865 2025-09-09 3076.0
3866 2025-09-10 3056.0
3867 2025-09-11 3060.0
3868 2025-09-12 3060.0
2025-09-12 17:59:02,901 - IOOppi_data - INFO : save new data to db IOOppi_m_t: date value ... created_at updated_at
3868 2025-09-12 3060.0 ... 2025-09-12 17:59:02.893885 2025-09-12 17:59:02.894309
[1 rows x 5 columns]
2025-09-12 17:59:03,743 - IOOppi_data - INFO : save diff data to db: IOOppi_m_t: no diff data
2025-09-12 17:59:03,750 - IOOppi_data - INFO : save data to db IOOppi_m_g data:
date value
3864 2025-09-08 3084.0
3865 2025-09-09 3076.0
3866 2025-09-10 3056.0
3867 2025-09-11 3060.0
3868 2025-09-12 3060.0
2025-09-12 17:59:04,277 - IOOppi_data - INFO : save new data to db IOOppi_m_g: date value ... created_at updated_at
3871 2025-09-12 3060.0 ... 2025-09-12 17:59:04.270057 2025-09-12 17:59:04.270437
[1 rows x 5 columns]
2025-09-12 17:59:05,115 - 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-12 17:59:06,027 - IOOppi_data - INFO : save data to db IOOppi_y_t data:
date value
3634 2025-09-08 8488.0
3635 2025-09-09 8488.0
3636 2025-09-10 8368.0
3637 2025-09-11 8408.0
3638 2025-09-12 8398.0
2025-09-12 17:59:07,863 - IOOppi_data - INFO : save new data to db IOOppi_y_t: date value ... created_at updated_at
3638 2025-09-12 8398.0 ... 2025-09-12 17:59:07.855995 2025-09-12 17:59:07.856392
[1 rows x 5 columns]
2025-09-12 17:59:14,665 - IOOppi_data - INFO : save diff data to db: IOOppi_y_t: no diff data
2025-09-12 17:59:14,672 - IOOppi_data - INFO : save data to db IOOppi_y_g data:
date value
3634 2025-09-08 8488.0
3635 2025-09-09 8488.0
3636 2025-09-10 8368.0
3637 2025-09-11 8408.0
3638 2025-09-12 8398.0
2025-09-12 17:59:26,810 - IOOppi_data - INFO : save new data to db IOOppi_y_g: date value ... created_at updated_at
3641 2025-09-12 8398.0 ... 2025-09-12 17:59:26.802707 2025-09-12 17:59:26.803143
[1 rows x 5 columns]
2025-09-12 17:59:26,829 - 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-12 17:59:27,420 - IOOppi_data - INFO : save data to db IOOppi_a_t data:
date value
3600 2025-09-08 4305.0
3601 2025-09-09 4305.0
3602 2025-09-10 4305.0
3603 2025-09-11 4305.0
3604 2025-09-12 4305.0
2025-09-12 17:59:32,283 - IOOppi_data - INFO : save new data to db IOOppi_a_t: date value ... created_at updated_at
3604 2025-09-12 4305.0 ... 2025-09-12 17:59:32.275939 2025-09-12 17:59:32.276323
[1 rows x 5 columns]
2025-09-12 17:59:33,527 - IOOppi_data - INFO : save diff data to db: IOOppi_a_t: no diff data
2025-09-12 17:59:33,533 - IOOppi_data - INFO : save data to db IOOppi_a_g data:
date value
3600 2025-09-08 4305.0
3601 2025-09-09 4305.0
3602 2025-09-10 4305.0
3603 2025-09-11 4305.0
3604 2025-09-12 4305.0
2025-09-12 17:59:41,289 - IOOppi_data - INFO : save new data to db IOOppi_a_g: date value ... created_at updated_at
3607 2025-09-12 4305.0 ... 2025-09-12 17:59:41.282647 2025-09-12 17:59:41.283044
[1 rows x 5 columns]
2025-09-12 17:59:41,310 - 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-12 17:59:41,930 - IOOppi_data - INFO : save data to db IOOppi_SF_t data:
date value
2977 2025-09-08 5214.29
2978 2025-09-09 5231.43
2979 2025-09-10 5260.00
2980 2025-09-11 5264.29
2981 2025-09-12 5245.71
2025-09-12 17:59:54,729 - IOOppi_data - INFO : save new data to db IOOppi_SF_t: date value ... created_at updated_at
2981 2025-09-12 5245.71 ... 2025-09-12 17:59:54.721263 2025-09-12 17:59:54.721700
[1 rows x 5 columns]
2025-09-12 17:59:54,953 - IOOppi_data - INFO : save diff data to db: IOOppi_SF_t: no diff data
2025-09-12 17:59:54,959 - IOOppi_data - INFO : save data to db IOOppi_SF_g data:
date value
2977 2025-09-08 5214.29
2978 2025-09-09 5231.43
2979 2025-09-10 5260.00
2980 2025-09-11 5264.29
2981 2025-09-12 5245.71
=========================================================================
2025-09-12 18:30:57 Fri 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-12 18:31:00,470 - IOOppi_data - INFO : save data to db IOOppi_rb_t data:
date value
3420 2025-09-08 3149.5
3421 2025-09-09 3153.5
3422 2025-09-10 3139.5
3423 2025-09-11 3123.5
3424 2025-09-12 3124.0
2025-09-12 18:31:15,792 - IOOppi_data - INFO : save new data to db: IOOppi_rb_t: no new data
2025-09-12 18:31:15,793 - IOOppi_data - INFO : save diff data to db: IOOppi_rb_t: no diff data
2025-09-12 18:31:15,798 - IOOppi_data - INFO : save data to db IOOppi_rb_g data:
date value
3420 2025-09-08 3149.5
3421 2025-09-09 3153.5
3422 2025-09-10 3139.5
3423 2025-09-11 3123.5
3424 2025-09-12 3124.0
2025-09-12 18:31:38,892 - IOOppi_data - INFO : save new data to db: IOOppi_rb_g: no new data
2025-09-12 18:31:38,892 - 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-12 18:31:39,629 - IOOppi_data - INFO : save data to db IOOppi_MA_t data:
date value
3641 2025-09-08 2271.67
3642 2025-09-09 2277.83
3643 2025-09-10 2296.67
3644 2025-09-11 2290.00
3645 2025-09-12 2288.33
2025-09-12 18:31:45,303 - IOOppi_data - INFO : save new data to db: IOOppi_MA_t: no new data
2025-09-12 18:31:45,303 - IOOppi_data - INFO : save diff data to db: IOOppi_MA_t: no diff data
2025-09-12 18:31:45,308 - IOOppi_data - INFO : save data to db IOOppi_MA_g data:
date value
3641 2025-09-08 2271.67
3642 2025-09-09 2277.83
3643 2025-09-10 2296.67
3644 2025-09-11 2290.00
3645 2025-09-12 2288.33
2025-09-12 18:31:46,018 - IOOppi_data - INFO : save new data to db: IOOppi_MA_g: no new data
2025-09-12 18:31:46,018 - 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-12 18:31:46,624 - IOOppi_data - INFO : save data to db IOOppi_PTA_t data:
date value
981 2025-09-08 4720.00
982 2025-09-09 4643.50
983 2025-09-10 4649.16
984 2025-09-11 4649.16
985 2025-09-12 4636.66
2025-09-12 18:31:48,319 - IOOppi_data - INFO : save new data to db: IOOppi_PTA_t: no new data
2025-09-12 18:31:48,320 - IOOppi_data - INFO : save diff data to db: IOOppi_PTA_t: no diff data
2025-09-12 18:31:48,325 - IOOppi_data - INFO : save data to db IOOppi_PTA_g data:
date value
981 2025-09-08 4720.00
982 2025-09-09 4643.50
983 2025-09-10 4649.16
984 2025-09-11 4649.16
985 2025-09-12 4636.66
2025-09-12 18:31:49,819 - IOOppi_data - INFO : save new data to db: IOOppi_PTA_g: no new data
2025-09-12 18:31:49,820 - 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-12 18:31:50,509 - IOOppi_data - INFO : save data to db IOOppi_ru_t data:
date value
3860 2025-09-08 15416.67
3861 2025-09-09 15175.00
3862 2025-09-10 15150.00
3863 2025-09-11 15058.33
3864 2025-09-12 14983.33
2025-09-12 18:31:59,242 - IOOppi_data - INFO : save new data to db: IOOppi_ru_t: no new data
2025-09-12 18:31:59,242 - IOOppi_data - INFO : save diff data to db: IOOppi_ru_t: no diff data
2025-09-12 18:31:59,248 - IOOppi_data - INFO : save data to db IOOppi_ru_g data:
date value
3860 2025-09-08 15416.67
3861 2025-09-09 15175.00
3862 2025-09-10 15150.00
3863 2025-09-11 15058.33
3864 2025-09-12 14983.33
2025-09-12 18:32:05,804 - IOOppi_data - INFO : save new data to db: IOOppi_ru_g: no new data
2025-09-12 18:32:05,805 - 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-12 18:32:06,384 - IOOppi_data - INFO : save data to db IOOppi_i_t data:
date value
3192 2025-09-08 795.44
3193 2025-09-09 800.11
3194 2025-09-10 808.67
3195 2025-09-11 812.33
3196 2025-09-12 808.00
2025-09-12 18:32:07,734 - IOOppi_data - INFO : save new data to db: IOOppi_i_t: no new data
2025-09-12 18:32:07,734 - IOOppi_data - INFO : save diff data to db: IOOppi_i_t: no diff data
2025-09-12 18:32:07,739 - IOOppi_data - INFO : save data to db IOOppi_i_g data:
date value
3192 2025-09-08 795.44
3193 2025-09-09 800.11
3194 2025-09-10 808.67
3195 2025-09-11 812.33
3196 2025-09-12 808.00
2025-09-12 18:32:14,231 - IOOppi_data - INFO : save new data to db: IOOppi_i_g: no new data
2025-09-12 18:32:14,231 - 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-12 18:32:14,792 - IOOppi_data - INFO : save data to db IOOppi_FG_t data:
date value
3395 2025-09-08 1120.0
3396 2025-09-09 1140.0
3397 2025-09-10 1140.0
3398 2025-09-11 1130.4
3399 2025-09-12 1130.4
2025-09-12 18:32:44,281 - 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-12 18:34:09,467 - IOOppi_data - INFO : save diff data to db IOOppi_FG_t: date ... updated_at
12 2012-12-19 ... 2025-09-12 18:34:09.458171
21 2013-01-04 ... 2025-09-12 18:34:09.458171
54 2013-02-27 ... 2025-09-12 18:34:09.458171
60 2013-03-07 ... 2025-09-12 18:34:09.458171
61 2013-03-08 ... 2025-09-12 18:34:09.458171
[5 rows x 6 columns]
2025-09-12 18:34:09,833 - IOOppi_data - INFO : save data to db IOOppi_FG_g data:
date value
3395 2025-09-08 1120.0
3396 2025-09-09 1140.0
3397 2025-09-10 1140.0
3398 2025-09-11 1130.4
3399 2025-09-12 1130.4
2025-09-12 18:34:14,528 - 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-12 18:35:42,337 - IOOppi_data - INFO : save diff data to db IOOppi_FG_g: date ... updated_at
12 2012-12-19 ... 2025-09-12 18:35:42.330038
21 2013-01-04 ... 2025-09-12 18:35:42.330038
54 2013-02-27 ... 2025-09-12 18:35:42.330038
60 2013-03-07 ... 2025-09-12 18:35:42.330038
61 2013-03-08 ... 2025-09-12 18:35:42.330038
[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-12 18:35:53,506 - IOOppi_data - INFO : save data to db IOOppi_eb_t data:
date value
1740 2025-09-08 7400.0
1741 2025-09-09 7394.0
1742 2025-09-10 7394.0
1743 2025-09-11 7394.0
1744 2025-09-12 7314.0
2025-09-12 18:36:11,978 - IOOppi_data - INFO : save new data to db: IOOppi_eb_t: no new data
2025-09-12 18:36:11,978 - IOOppi_data - INFO : save diff data to db: IOOppi_eb_t: no diff data
2025-09-12 18:36:11,983 - IOOppi_data - INFO : save data to db IOOppi_eb_g data:
date value
1740 2025-09-08 7400.0
1741 2025-09-09 7394.0
1742 2025-09-10 7394.0
1743 2025-09-11 7394.0
1744 2025-09-12 7314.0
2025-09-12 18:43:50,806 - IOOppi_data - INFO : save new data to db: IOOppi_eb_g: no new data
2025-09-12 18:43:50,806 - 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-12 18:43:51,384 - IOOppi_data - INFO : save data to db IOOppi_SR_t data:
date value
3851 2025-09-08 5905.00
3852 2025-09-09 5875.00
3853 2025-09-10 5856.67
3854 2025-09-11 5855.00
3855 2025-09-12 5855.00
2025-09-12 18:44:33,037 - IOOppi_data - INFO : save new data to db: IOOppi_SR_t: no new data
2025-09-12 18:44:33,037 - IOOppi_data - INFO : save diff data to db: IOOppi_SR_t: no diff data
2025-09-12 18:44:33,043 - IOOppi_data - INFO : save data to db IOOppi_SR_g data:
date value
3851 2025-09-08 5905.00
3852 2025-09-09 5875.00
3853 2025-09-10 5856.67
3854 2025-09-11 5855.00
3855 2025-09-12 5855.00
2025-09-12 18:44:34,196 - IOOppi_data - INFO : save new data to db: IOOppi_SR_g: no new data
2025-09-12 18:44:34,196 - 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-12 18:44:35,665 - IOOppi_data - INFO : save data to db IOOppi_ss_t data:
date value
1741 2025-09-08 13080.0
1742 2025-09-09 13080.0
1743 2025-09-10 13055.0
1744 2025-09-11 13055.0
1745 2025-09-12 13067.5
2025-09-12 18:44:44,827 - IOOppi_data - INFO : save new data to db: IOOppi_ss_t: no new data
2025-09-12 18:44:44,827 - IOOppi_data - INFO : save diff data to db: IOOppi_ss_t: no diff data
2025-09-12 18:44:44,832 - IOOppi_data - INFO : save data to db IOOppi_ss_g data:
date value
1741 2025-09-08 13080.0
1742 2025-09-09 13080.0
1743 2025-09-10 13055.0
1744 2025-09-11 13055.0
1745 2025-09-12 13067.5
2025-09-12 18:44:54,905 - IOOppi_data - INFO : save new data to db: IOOppi_ss_g: no new data
2025-09-12 18:44:54,905 - 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-12 18:44:55,542 - IOOppi_data - INFO : save data to db IOOppi_RS_t data:
date value
3251 2025-09-08 9941.67
3252 2025-09-09 9980.00
3253 2025-09-10 9920.00
3254 2025-09-11 10020.00
3255 2025-09-12 10000.00
2025-09-12 18:44:57,075 - IOOppi_data - INFO : save new data to db: IOOppi_RS_t: no new data
2025-09-12 18:44:57,075 - IOOppi_data - INFO : save diff data to db: IOOppi_RS_t: no diff data
2025-09-12 18:44:57,081 - IOOppi_data - INFO : save data to db IOOppi_RS_g data:
date value
3251 2025-09-08 9941.67
3252 2025-09-09 9980.00
3253 2025-09-10 9920.00
3254 2025-09-11 10020.00
3255 2025-09-12 10000.00
2025-09-12 18:44:59,620 - IOOppi_data - INFO : save new data to db: IOOppi_RS_g: no new data
2025-09-12 18:44:59,620 - 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-12 18:45:00,255 - IOOppi_data - INFO : save data to db IOOppi_RM_t data:
date value
3374 2025-09-08 2650.00
3375 2025-09-09 2653.33
3376 2025-09-10 2658.33
3377 2025-09-11 2665.00
3378 2025-09-12 2680.00
2025-09-12 18:45:19,742 - IOOppi_data - INFO : save new data to db: IOOppi_RM_t: no new data
2025-09-12 18:45:19,742 - IOOppi_data - INFO : save diff data to db: IOOppi_RM_t: no diff data
2025-09-12 18:45:19,748 - IOOppi_data - INFO : save data to db IOOppi_RM_g data:
date value
3374 2025-09-08 2650.00
3375 2025-09-09 2653.33
3376 2025-09-10 2658.33
3377 2025-09-11 2665.00
3378 2025-09-12 2680.00
2025-09-12 18:45:31,163 - IOOppi_data - INFO : save new data to db: IOOppi_RM_g: no new data
2025-09-12 18:45:31,163 - 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-12 18:45:31,892 - IOOppi_data - INFO : save data to db IOOppi_SA_t data:
date value
1578 2025-09-08 1262.5
1579 2025-09-09 1262.5
1580 2025-09-10 1262.5
1581 2025-09-11 1262.5
1582 2025-09-12 1262.5
2025-09-12 18:45:32,568 - IOOppi_data - INFO : save new data to db: IOOppi_SA_t: no new data
2025-09-12 18:45:32,569 - IOOppi_data - INFO : save diff data to db: IOOppi_SA_t: no diff data
2025-09-12 18:45:32,574 - IOOppi_data - INFO : save data to db IOOppi_SA_g data:
date value
1578 2025-09-08 1262.5
1579 2025-09-09 1262.5
1580 2025-09-10 1262.5
1581 2025-09-11 1262.5
1582 2025-09-12 1262.5
2025-09-12 18:45:34,474 - IOOppi_data - INFO : save new data to db: IOOppi_SA_g: no new data
2025-09-12 18:45:34,474 - 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-12 18:45:35,061 - IOOppi_data - INFO : save data to db IOOppi_PF_t data:
date value
1491 2025-09-08 6448.33
1492 2025-09-09 6454.83
1493 2025-09-10 6463.50
1494 2025-09-11 6471.33
1495 2025-09-12 6457.00
2025-09-12 18:45:38,695 - IOOppi_data - INFO : save new data to db: IOOppi_PF_t: no new data
2025-09-12 18:45:38,695 - IOOppi_data - INFO : save diff data to db: IOOppi_PF_t: no diff data
2025-09-12 18:45:38,700 - IOOppi_data - INFO : save data to db IOOppi_PF_g data:
date value
1491 2025-09-08 6448.33
1492 2025-09-09 6454.83
1493 2025-09-10 6463.50
1494 2025-09-11 6471.33
1495 2025-09-12 6457.00
2025-09-12 18:45:40,671 - IOOppi_data - INFO : save new data to db: IOOppi_PF_g: no new data
2025-09-12 18:45:40,671 - 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-12 18:45:41,359 - IOOppi_data - INFO : save data to db IOOppi_m_t data:
date value
3864 2025-09-08 3084.0
3865 2025-09-09 3076.0
3866 2025-09-10 3056.0
3867 2025-09-11 3060.0
3868 2025-09-12 3060.0
2025-09-12 18:45:51,882 - IOOppi_data - INFO : save new data to db: IOOppi_m_t: no new data
2025-09-12 18:45:51,882 - IOOppi_data - INFO : save diff data to db: IOOppi_m_t: no diff data
2025-09-12 18:45:51,888 - IOOppi_data - INFO : save data to db IOOppi_m_g data:
date value
3864 2025-09-08 3084.0
3865 2025-09-09 3076.0
3866 2025-09-10 3056.0
3867 2025-09-11 3060.0
3868 2025-09-12 3060.0
2025-09-12 18:46:14,111 - IOOppi_data - INFO : save new data to db: IOOppi_m_g: no new data
2025-09-12 18:46:14,111 - 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-12 18:46:14,716 - IOOppi_data - INFO : save data to db IOOppi_y_t data:
date value
3634 2025-09-08 8488.0
3635 2025-09-09 8488.0
3636 2025-09-10 8368.0
3637 2025-09-11 8408.0
3638 2025-09-12 8398.0
2025-09-12 18:46:23,800 - IOOppi_data - INFO : save new data to db: IOOppi_y_t: no new data
2025-09-12 18:46:23,800 - IOOppi_data - INFO : save diff data to db: IOOppi_y_t: no diff data
2025-09-12 18:46:23,806 - IOOppi_data - INFO : save data to db IOOppi_y_g data:
date value
3634 2025-09-08 8488.0
3635 2025-09-09 8488.0
3636 2025-09-10 8368.0
3637 2025-09-11 8408.0
3638 2025-09-12 8398.0
2025-09-12 18:46:29,666 - IOOppi_data - INFO : save new data to db: IOOppi_y_g: no new data
2025-09-12 18:46:29,666 - 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-12 18:46:30,250 - IOOppi_data - INFO : save data to db IOOppi_a_t data:
date value
3600 2025-09-08 4305.0
3601 2025-09-09 4305.0
3602 2025-09-10 4305.0
3603 2025-09-11 4305.0
3604 2025-09-12 4305.0
2025-09-12 18:46:44,686 - IOOppi_data - INFO : save new data to db: IOOppi_a_t: no new data
2025-09-12 18:46:44,687 - IOOppi_data - INFO : save diff data to db: IOOppi_a_t: no diff data
2025-09-12 18:46:44,693 - IOOppi_data - INFO : save data to db IOOppi_a_g data:
date value
3600 2025-09-08 4305.0
3601 2025-09-09 4305.0
3602 2025-09-10 4305.0
3603 2025-09-11 4305.0
3604 2025-09-12 4305.0
2025-09-12 18:46:52,655 - IOOppi_data - INFO : save new data to db: IOOppi_a_g: no new data
2025-09-12 18:46:52,655 - 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-12 18:46:54,116 - IOOppi_data - INFO : save data to db IOOppi_SF_t data:
date value
2977 2025-09-08 5214.29
2978 2025-09-09 5231.43
2979 2025-09-10 5260.00
2980 2025-09-11 5264.29
2981 2025-09-12 5245.71
2025-09-12 18:47:13,053 - IOOppi_data - INFO : save new data to db: IOOppi_SF_t: no new data
2025-09-12 18:47:13,053 - IOOppi_data - INFO : save diff data to db: IOOppi_SF_t: no diff data
2025-09-12 18:47:13,059 - IOOppi_data - INFO : save data to db IOOppi_SF_g data:
date value
2977 2025-09-08 5214.29
2978 2025-09-09 5231.43
2979 2025-09-10 5260.00
2980 2025-09-11 5264.29
2981 2025-09-12 5245.71
2025-09-12 18:47:18,561 - IOOppi_data - INFO : save new data to db IOOppi_SF_g: date value ... created_at updated_at
2985 2025-09-12 5245.71 ... 2025-09-12 18:47:18.553899 2025-09-12 18:47:18.554309
[1 rows x 5 columns]
2025-09-12 18:47:18,581 - 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-12 18:47:19,122 - IOOppi_data - INFO : save data to db IOOppi_jd_t data:
date value
3177 2025-09-08 3450.0
3178 2025-09-09 3525.0
3179 2025-09-10 3575.0
3180 2025-09-11 3640.0
3181 2025-09-12 3675.0
2025-09-12 18:47:35,303 - IOOppi_data - INFO : save new data to db IOOppi_jd_t: date value ... created_at updated_at
3181 2025-09-12 3675.0 ... 2025-09-12 18:47:35.296109 2025-09-12 18:47:35.296507
[1 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-12 18:48:03,729 - IOOppi_data - INFO : save diff data to db IOOppi_jd_t: date ... updated_at
39 2014-01-03 ... 2025-09-12 18:48:03.720935
458 2015-09-21 ... 2025-09-12 18:48:03.720935
549 2016-02-03 ... 2025-09-12 18:48:03.720935
693 2016-09-05 ... 2025-09-12 18:48:03.720935
696 2016-09-08 ... 2025-09-12 18:48:03.720935
[5 rows x 6 columns]
2025-09-12 18:48:04,375 - IOOppi_data - INFO : save data to db IOOppi_jd_g data:
date value
3177 2025-09-08 3450.0
3178 2025-09-09 3525.0
3179 2025-09-10 3575.0
3180 2025-09-11 3640.0
3181 2025-09-12 3675.0
2025-09-12 18:48:10,218 - IOOppi_data - INFO : save new data to db IOOppi_jd_g: date value ... created_at updated_at
3184 2025-09-12 3675.0 ... 2025-09-12 18:48:10.211788 2025-09-12 18:48:10.212204
[1 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-12 18:48:14,654 - IOOppi_data - INFO : save diff data to db IOOppi_jd_g: date ... updated_at
39 2014-01-03 ... 2025-09-12 18:48:14.645709
458 2015-09-21 ... 2025-09-12 18:48:14.645709
549 2016-02-03 ... 2025-09-12 18:48:14.645709
693 2016-09-05 ... 2025-09-12 18:48:14.645709
696 2016-09-08 ... 2025-09-12 18:48:14.645709
[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-12 18:48:15,574 - IOOppi_data - INFO : save data to db IOOppi_SI_t data:
date value
981 2025-09-08 9390.0
982 2025-09-09 9390.0
983 2025-09-10 9390.0
984 2025-09-11 9390.0
985 2025-09-12 9450.0
2025-09-12 18:48:20,213 - IOOppi_data - INFO : save new data to db IOOppi_SI_t: date value ... created_at updated_at
985 2025-09-12 9450.0 ... 2025-09-12 18:48:20.205021 2025-09-12 18:48:20.205408
[1 rows x 5 columns]
2025-09-12 18:48:20,438 - IOOppi_data - INFO : save diff data to db: IOOppi_SI_t: no diff data
2025-09-12 18:48:20,444 - IOOppi_data - INFO : save data to db IOOppi_SI_g data:
date value
981 2025-09-08 9390.0
982 2025-09-09 9390.0
983 2025-09-10 9390.0
984 2025-09-11 9390.0
985 2025-09-12 9450.0
2025-09-12 18:48:20,746 - IOOppi_data - INFO : save new data to db IOOppi_SI_g: date value ... created_at updated_at
985 2025-09-12 9450.0 ... 2025-09-12 18:48:20.739061 2025-09-12 18:48:20.739470
[1 rows x 5 columns]
2025-09-12 18:48:20,974 - 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-12 18:48:21,786 - IOOppi_data - INFO : save data to db IOOppi_l_t data:
date value
3860 2025-09-08 7385.00
3861 2025-09-09 7391.67
3862 2025-09-10 7395.00
3863 2025-09-11 7391.67
3864 2025-09-12 7380.00
2025-09-12 18:48:29,016 - IOOppi_data - INFO : save new data to db IOOppi_l_t: date value ... created_at updated_at
3864 2025-09-12 7380.0 ... 2025-09-12 18:48:29.008966 2025-09-12 18:48:29.009359
[1 rows x 5 columns]
2025-09-12 18:48:29,036 - IOOppi_data - INFO : save diff data to db: IOOppi_l_t: no diff data
2025-09-12 18:48:29,042 - IOOppi_data - INFO : save data to db IOOppi_l_g data:
date value
3860 2025-09-08 7385.00
3861 2025-09-09 7391.67
3862 2025-09-10 7395.00
3863 2025-09-11 7391.67
3864 2025-09-12 7380.00
2025-09-12 18:48:36,092 - IOOppi_data - INFO : save new data to db IOOppi_l_g: date value ... created_at updated_at
3867 2025-09-12 7380.0 ... 2025-09-12 18:48:36.085383 2025-09-12 18:48:36.085799
[1 rows x 5 columns]
2025-09-12 18:48:37,753 - 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-12 18:48:38,309 - IOOppi_data - INFO : save data to db IOOppi_bu_t data:
date value
3198 2025-09-08 3656.67
3199 2025-09-09 3660.00
3200 2025-09-10 3653.33
3201 2025-09-11 3653.33
3202 2025-09-12 3635.00
2025-09-12 18:48:42,790 - IOOppi_data - INFO : save new data to db IOOppi_bu_t: date value ... created_at updated_at
3203 2025-09-12 3635.0 ... 2025-09-12 18:48:42.783255 2025-09-12 18:48:42.783670
[1 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-12 18:48:42,826 - IOOppi_data - INFO : save diff data to db IOOppi_bu_t: date ... updated_at
2560 2023-12-09 ... 2025-09-12 18:48:42.818836
[1 rows x 6 columns]
2025-09-12 18:48:42,849 - IOOppi_data - INFO : save data to db IOOppi_bu_g data:
date value
3198 2025-09-08 3656.67
3199 2025-09-09 3660.00
3200 2025-09-10 3653.33
3201 2025-09-11 3653.33
3202 2025-09-12 3635.00
2025-09-12 18:48:55,488 - IOOppi_data - INFO : save new data to db IOOppi_bu_g: date value ... created_at updated_at
3205 2025-09-12 3635.0 ... 2025-09-12 18:48:55.480914 2025-09-12 18:48:55.481297
[1 rows x 5 columns]
2025-09-12 18:48:55,506 - 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-12 18:48:56,141 - IOOppi_data - INFO : save data to db IOOppi_al_t data:
date value
3863 2025-09-08 20676.67
3864 2025-09-09 20693.33
3865 2025-09-10 20693.33
3866 2025-09-11 20693.33
3867 2025-09-12 21056.67
2025-09-12 18:49:21,411 - IOOppi_data - INFO : save new data to db IOOppi_al_t: date ... updated_at
3867 2025-09-12 ... 2025-09-12 18:49:21.403468
[1 rows x 5 columns]
2025-09-12 18:49:22,455 - IOOppi_data - INFO : save diff data to db: IOOppi_al_t: no diff data
2025-09-12 18:49:22,462 - IOOppi_data - INFO : save data to db IOOppi_al_g data:
date value
3863 2025-09-08 20676.67
3864 2025-09-09 20693.33
3865 2025-09-10 20693.33
3866 2025-09-11 20693.33
3867 2025-09-12 21056.67
2025-09-12 18:49:23,598 - IOOppi_data - INFO : save new data to db IOOppi_al_g: date ... updated_at
3870 2025-09-12 ... 2025-09-12 18:49:23.592238
[1 rows x 5 columns]
2025-09-12 18:49:23,617 - 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-12 18:49:24,216 - IOOppi_data - INFO : save data to db IOOppi_SM_t data:
date value
2977 2025-09-08 5688.0
2978 2025-09-09 5692.0
2979 2025-09-10 5696.0
2980 2025-09-11 5676.0
2981 2025-09-12 5666.0
2025-09-12 18:49:35,066 - IOOppi_data - INFO : save new data to db IOOppi_SM_t: date value ... created_at updated_at
2981 2025-09-12 5666.0 ... 2025-09-12 18:49:35.059086 2025-09-12 18:49:35.059496
[1 rows x 5 columns]
2025-09-12 18:49:35,494 - IOOppi_data - INFO : save diff data to db: IOOppi_SM_t: no diff data
2025-09-12 18:49:35,500 - IOOppi_data - INFO : save data to db IOOppi_SM_g data:
date value
2977 2025-09-08 5688.0
2978 2025-09-09 5692.0
2979 2025-09-10 5696.0
2980 2025-09-11 5676.0
2981 2025-09-12 5666.0
2025-09-12 18:49:45,194 - IOOppi_data - INFO : save new data to db IOOppi_SM_g: date value ... created_at updated_at
2985 2025-09-12 5666.0 ... 2025-09-12 18:49:45.186359 2025-09-12 18:49:45.186792
[1 rows x 5 columns]
2025-09-12 18:49:45,213 - IOOppi_data - INFO : save diff data to db: IOOppi_SM_g: no diff data
/usr/local/lib/python3.10/site-packages/urllib3/connectionpool.py:1056: InsecureRequestWarning: Unverified HTTPS request is being made to host 'www.100ppi.com'. Adding certificate verification is strongly advised. See: https://urllib3.readthedocs.io/en/1.26.x/advanced-usage.html#ssl-warnings
warnings.warn(
2025-09-12 18:49:45,809 - IOOppi_data - INFO : save data to db IOOppi_CY_t data:
date value
2252 2025-09-08 23550.0
2253 2025-09-09 23550.0
2254 2025-09-10 23550.0
2255 2025-09-11 23550.0
2256 2025-09-12 23550.0
2025-09-12 18:49:48,969 - IOOppi_data - INFO : save new data to db IOOppi_CY_t: date value ... created_at updated_at
2256 2025-09-12 23550.0 ... 2025-09-12 18:49:48.961743 2025-09-12 18:49:48.962154
[1 rows x 5 columns]
2025-09-12 18:49:48,987 - IOOppi_data - INFO : save diff data to db: IOOppi_CY_t: no diff data
2025-09-12 18:49:48,993 - IOOppi_data - INFO : save data to db IOOppi_CY_g data:
date value
2252 2025-09-08 23550.0
2253 2025-09-09 23550.0
2254 2025-09-10 23550.0
2255 2025-09-11 23550.0
2256 2025-09-12 23550.0
2025-09-12 18:50:11,484 - IOOppi_data - INFO : save new data to db IOOppi_CY_g: date value ... created_at updated_at
2260 2025-09-12 23550.0 ... 2025-09-12 18:50:11.477383 2025-09-12 18:50:11.477817
[1 rows x 5 columns]
2025-09-12 18:50:11,503 - IOOppi_data - INFO : save diff data to db: IOOppi_CY_g: no diff data
/usr/local/lib/python3.10/site-packages/urllib3/connectionpool.py:1056: InsecureRequestWarning: Unverified HTTPS request is being made to host 'www.100ppi.com'. Adding certificate verification is strongly advised. See: https://urllib3.readthedocs.io/en/1.26.x/advanced-usage.html#ssl-warnings
warnings.warn(
2025-09-12 18:50:12,059 - IOOppi_data - INFO : save data to db IOOppi_UR_t data:
date value
1767 2025-09-08 1703.75
1768 2025-09-09 1691.25
1769 2025-09-10 1693.75
1770 2025-09-11 1673.75
1771 2025-09-12 1673.75
2025-09-12 18:50:14,384 - IOOppi_data - INFO : save new data to db IOOppi_UR_t: date value ... created_at updated_at
1771 2025-09-12 1673.75 ... 2025-09-12 18:50:14.377123 2025-09-12 18:50:14.377513
[1 rows x 5 columns]
2025-09-12 18:50:14,403 - IOOppi_data - INFO : save diff data to db: IOOppi_UR_t: no diff data
2025-09-12 18:50:14,409 - IOOppi_data - INFO : save data to db IOOppi_UR_g data:
date value
1767 2025-09-08 1703.75
1768 2025-09-09 1691.25
1769 2025-09-10 1693.75
1770 2025-09-11 1673.75
1771 2025-09-12 1673.75
2025-09-12 18:50:51,250 - IOOppi_data - INFO : save new data to db IOOppi_UR_g: date value ... created_at updated_at
1775 2025-09-12 1673.75 ... 2025-09-12 18:50:51.243191 2025-09-12 18:50:51.243601
[1 rows x 5 columns]
2025-09-12 18:50:51,269 - IOOppi_data - INFO : save diff data to db: IOOppi_UR_g: no diff data
/usr/local/lib/python3.10/site-packages/urllib3/connectionpool.py:1056: InsecureRequestWarning: Unverified HTTPS request is being made to host 'www.100ppi.com'. Adding certificate verification is strongly advised. See: https://urllib3.readthedocs.io/en/1.26.x/advanced-usage.html#ssl-warnings
warnings.warn(
2025-09-12 18:50:51,952 - IOOppi_data - INFO : save data to db IOOppi_ni_t data:
date value
2839 2025-09-08 121950.00
2840 2025-09-09 122350.00
2841 2025-09-10 121766.67
2842 2025-09-11 121750.00
2843 2025-09-12 123316.67
2025-09-12 18:50:55,814 - IOOppi_data - INFO : save new data to db IOOppi_ni_t: date ... updated_at
2843 2025-09-12 ... 2025-09-12 18:50:55.807953
[1 rows x 5 columns]
2025-09-12 18:50:55,833 - IOOppi_data - INFO : save diff data to db: IOOppi_ni_t: no diff data
2025-09-12 18:50:55,840 - IOOppi_data - INFO : save data to db IOOppi_ni_g data:
date value
2839 2025-09-08 121950.00
2840 2025-09-09 122350.00
2841 2025-09-10 121766.67
2842 2025-09-11 121750.00
2843 2025-09-12 123316.67
2025-09-12 18:51:04,043 - IOOppi_data - INFO : save new data to db IOOppi_ni_g: date ... updated_at
2846 2025-09-12 ... 2025-09-12 18:51:04.036706
[1 rows x 5 columns]
2025-09-12 18:51:04,473 - IOOppi_data - INFO : save diff data to db: IOOppi_ni_g: no diff data
/usr/local/lib/python3.10/site-packages/urllib3/connectionpool.py:1056: InsecureRequestWarning: Unverified HTTPS request is being made to host 'www.100ppi.com'. Adding certificate verification is strongly advised. See: https://urllib3.readthedocs.io/en/1.26.x/advanced-usage.html#ssl-warnings
warnings.warn(
2025-09-12 18:51:05,095 - IOOppi_data - INFO : save data to db IOOppi_v_t data:
date value
3864 2025-09-08 4654.0
3865 2025-09-09 4649.0
3866 2025-09-10 4641.0
3867 2025-09-11 4641.0
3868 2025-09-12 4635.0
2025-09-12 18:51:06,454 - IOOppi_data - INFO : save new data to db IOOppi_v_t: date value ... created_at updated_at
3868 2025-09-12 4635.0 ... 2025-09-12 18:51:06.447250 2025-09-12 18:51:06.447660
[1 rows x 5 columns]
2025-09-12 18:51:06,677 - IOOppi_data - INFO : save diff data to db: IOOppi_v_t: no diff data
2025-09-12 18:51:06,684 - IOOppi_data - INFO : save data to db IOOppi_v_g data:
date value
3864 2025-09-08 4654.0
3865 2025-09-09 4649.0
3866 2025-09-10 4641.0
3867 2025-09-11 4641.0
3868 2025-09-12 4635.0
2025-09-12 18:51:14,214 - IOOppi_data - INFO : save new data to db IOOppi_v_g: date value ... created_at updated_at
3871 2025-09-12 4635.0 ... 2025-09-12 18:51:14.207501 2025-09-12 18:51:14.207960
[1 rows x 5 columns]
2025-09-12 18:51:14,851 - IOOppi_data - INFO : save diff data to db: IOOppi_v_g: no diff data
/usr/local/lib/python3.10/site-packages/urllib3/connectionpool.py:1056: InsecureRequestWarning: Unverified HTTPS request is being made to host 'www.100ppi.com'. Adding certificate verification is strongly advised. See: https://urllib3.readthedocs.io/en/1.26.x/advanced-usage.html#ssl-warnings
warnings.warn(
2025-09-12 18:51:15,483 - IOOppi_data - INFO : save data to db IOOppi_pp_t data:
date value
3103 2025-09-08 7113.33
3104 2025-09-09 7113.33
3105 2025-09-10 7113.33
3106 2025-09-11 7113.33
3107 2025-09-12 7106.67
2025-09-12 18:51:19,507 - IOOppi_data - INFO : save new data to db IOOppi_pp_t: date value ... created_at updated_at
3107 2025-09-12 7106.67 ... 2025-09-12 18:51:19.499783 2025-09-12 18:51:19.500215
[1 rows x 5 columns]
2025-09-12 18:51:19,935 - IOOppi_data - INFO : save diff data to db: IOOppi_pp_t: no diff data
2025-09-12 18:51:19,941 - IOOppi_data - INFO : save data to db IOOppi_pp_g data:
date value
3103 2025-09-08 7113.33
3104 2025-09-09 7113.33
3105 2025-09-10 7113.33
3106 2025-09-11 7113.33
3107 2025-09-12 7106.67
2025-09-12 18:51:32,667 - IOOppi_data - INFO : save new data to db IOOppi_pp_g: date value ... created_at updated_at
3110 2025-09-12 7106.67 ... 2025-09-12 18:51:32.660100 2025-09-12 18:51:32.660475
[1 rows x 5 columns]
2025-09-12 18:51:36,793 - IOOppi_data - INFO : save diff data to db: IOOppi_pp_g: no diff data
/usr/local/lib/python3.10/site-packages/urllib3/connectionpool.py:1056: InsecureRequestWarning: Unverified HTTPS request is being made to host 'www.100ppi.com'. Adding certificate verification is strongly advised. See: https://urllib3.readthedocs.io/en/1.26.x/advanced-usage.html#ssl-warnings
warnings.warn(
2025-09-12 18:51:39,034 - IOOppi_data - INFO : save data to db IOOppi_CF_t data:
date value
3865 2025-09-08 15417.17
3866 2025-09-09 15334.50
3867 2025-09-10 15293.83
3868 2025-09-11 15260.33
3869 2025-09-12 15254.00
2025-09-12 18:51:57,828 - IOOppi_data - INFO : save new data to db IOOppi_CF_t: date value ... created_at updated_at
3869 2025-09-12 15254.0 ... 2025-09-12 18:51:57.820410 2025-09-12 18:51:57.820864
[1 rows x 5 columns]
2025-09-12 18:51:58,257 - IOOppi_data - INFO : save diff data to db: IOOppi_CF_t: no diff data
2025-09-12 18:51:58,264 - IOOppi_data - INFO : save data to db IOOppi_CF_g data:
date value
3865 2025-09-08 15417.17
3866 2025-09-09 15334.50
3867 2025-09-10 15293.83
3868 2025-09-11 15260.33
3869 2025-09-12 15254.00
2025-09-12 18:52:16,732 - IOOppi_data - INFO : save new data to db IOOppi_CF_g: date value ... created_at updated_at
3873 2025-09-12 15254.0 ... 2025-09-12 18:52:16.724410 2025-09-12 18:52:16.724845
[1 rows x 5 columns]
2025-09-12 18:52:17,365 - IOOppi_data - INFO : save diff data to db: IOOppi_CF_g: no diff data
/usr/local/lib/python3.10/site-packages/urllib3/connectionpool.py:1056: InsecureRequestWarning: Unverified HTTPS request is being made to host 'www.100ppi.com'. Adding certificate verification is strongly advised. See: https://urllib3.readthedocs.io/en/1.26.x/advanced-usage.html#ssl-warnings
warnings.warn(
2025-09-12 18:52:19,024 - IOOppi_data - INFO : save data to db IOOppi_pb_t data:
date value
3810 2025-09-08 16825.00
3811 2025-09-09 16843.75
3812 2025-09-10 16781.25
3813 2025-09-11 16825.00
3814 2025-09-12 16850.00
2025-09-12 18:52:36,416 - IOOppi_data - INFO : save new data to db IOOppi_pb_t: date value ... created_at updated_at
3814 2025-09-12 16850.0 ... 2025-09-12 18:52:36.408826 2025-09-12 18:52:36.409273
[1 rows x 5 columns]
2025-09-12 18:52:37,051 - IOOppi_data - INFO : save diff data to db: IOOppi_pb_t: no diff data
2025-09-12 18:52:37,057 - IOOppi_data - INFO : save data to db IOOppi_pb_g data:
date value
3810 2025-09-08 16825.00
3811 2025-09-09 16843.75
3812 2025-09-10 16781.25
3813 2025-09-11 16825.00
3814 2025-09-12 16850.00
2025-09-12 18:52:44,668 - IOOppi_data - INFO : save new data to db IOOppi_pb_g: date value ... created_at updated_at
3817 2025-09-12 16850.0 ... 2025-09-12 18:52:44.661414 2025-09-12 18:52:44.661830
[1 rows x 5 columns]
2025-09-12 18:52:44,688 - IOOppi_data - INFO : save diff data to db: IOOppi_pb_g: no diff data
/usr/local/lib/python3.10/site-packages/urllib3/connectionpool.py:1056: InsecureRequestWarning: Unverified HTTPS request is being made to host 'www.100ppi.com'. Adding certificate verification is strongly advised. See: https://urllib3.readthedocs.io/en/1.26.x/advanced-usage.html#ssl-warnings
warnings.warn(
2025-09-12 18:52:45,266 - IOOppi_data - INFO : save data to db IOOppi_hc_t data:
date value
3085 2025-09-08 3393.33
3086 2025-09-09 3393.33
3087 2025-09-10 3393.33
3088 2025-09-11 3433.33
3089 2025-09-12 3430.00
2025-09-12 18:52:46,598 - IOOppi_data - INFO : save new data to db IOOppi_hc_t: date value ... created_at updated_at
3089 2025-09-12 3430.0 ... 2025-09-12 18:52:46.588626 2025-09-12 18:52:46.589022
[1 rows x 5 columns]
2025-09-12 18:52:47,438 - IOOppi_data - INFO : save diff data to db: IOOppi_hc_t: no diff data
2025-09-12 18:52:47,444 - IOOppi_data - INFO : save data to db IOOppi_hc_g data:
date value
3085 2025-09-08 3393.33
3086 2025-09-09 3393.33
3087 2025-09-10 3393.33
3088 2025-09-11 3433.33
3089 2025-09-12 3430.00
2025-09-12 18:52:54,373 - IOOppi_data - INFO : save new data to db IOOppi_hc_g: date value ... created_at updated_at
3092 2025-09-12 3430.0 ... 2025-09-12 18:52:54.364744 2025-09-12 18:52:54.365151
[1 rows x 5 columns]
2025-09-12 18:52:58,071 - IOOppi_data - INFO : save diff data to db: IOOppi_hc_g: no diff data
/usr/local/lib/python3.10/site-packages/urllib3/connectionpool.py:1056: InsecureRequestWarning: Unverified HTTPS request is being made to host 'www.100ppi.com'. Adding certificate verification is strongly advised. See: https://urllib3.readthedocs.io/en/1.26.x/advanced-usage.html#ssl-warnings
warnings.warn(
2025-09-12 18:52:58,680 - IOOppi_data - INFO : save data to db IOOppi_fu_t data:
date value
3365 2025-09-08 5375.0
3366 2025-09-09 5375.0
3367 2025-09-10 5400.0
3368 2025-09-11 5412.5
3369 2025-09-12 5412.5
2025-09-12 18:52:58,968 - IOOppi_data - INFO : save new data to db IOOppi_fu_t: date value ... created_at updated_at
3369 2025-09-12 5412.5 ... 2025-09-12 18:52:58.960741 2025-09-12 18:52:58.961228
[1 rows x 5 columns]
2025-09-12 18:52:59,398 - IOOppi_data - INFO : save diff data to db: IOOppi_fu_t: no diff data
2025-09-12 18:52:59,404 - IOOppi_data - INFO : save data to db IOOppi_fu_g data:
date value
3365 2025-09-08 5375.0
3366 2025-09-09 5375.0
3367 2025-09-10 5400.0
3368 2025-09-11 5412.5
3369 2025-09-12 5412.5
2025-09-12 18:53:09,103 - IOOppi_data - INFO : save new data to db IOOppi_fu_g: date value ... created_at updated_at
3856 2025-09-12 5412.5 ... 2025-09-12 18:53:09.095857 2025-09-12 18:53:09.096243
[1 rows x 5 columns]
2025-09-12 18:53:09,942 - IOOppi_data - INFO : save diff data to db: IOOppi_fu_g: no diff data
/usr/local/lib/python3.10/site-packages/urllib3/connectionpool.py:1056: InsecureRequestWarning: Unverified HTTPS request is being made to host 'www.100ppi.com'. Adding certificate verification is strongly advised. See: https://urllib3.readthedocs.io/en/1.26.x/advanced-usage.html#ssl-warnings
warnings.warn(
2025-09-12 18:53:10,525 - IOOppi_data - INFO : save data to db IOOppi_lh_t data:
date value
1429 2025-09-08 13730.0
1430 2025-09-09 13650.0
1431 2025-09-10 13600.0
1432 2025-09-11 13520.0
1433 2025-09-12 13480.0
2025-09-12 18:53:13,068 - IOOppi_data - INFO : save new data to db IOOppi_lh_t: date value ... created_at updated_at
1433 2025-09-12 13480.0 ... 2025-09-12 18:53:13.061245 2025-09-12 18:53:13.061663
[1 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-12 18:53:17,793 - IOOppi_data - INFO : save diff data to db IOOppi_lh_t: date ... updated_at
116 2021-07-05 ... 2025-09-12 18:53:17.785270
117 2021-07-06 ... 2025-09-12 18:53:17.785270
121 2021-07-12 ... 2025-09-12 18:53:17.785270
122 2021-07-13 ... 2025-09-12 18:53:17.785270
194 2021-11-01 ... 2025-09-12 18:53:17.785270
[5 rows x 6 columns]
2025-09-12 18:53:18,035 - IOOppi_data - INFO : save data to db IOOppi_lh_g data:
date value
1429 2025-09-08 13730.0
1430 2025-09-09 13650.0
1431 2025-09-10 13600.0
1432 2025-09-11 13520.0
1433 2025-09-12 13480.0
2025-09-12 18:53:18,086 - IOOppi_data - INFO : save new data to db IOOppi_lh_g: date value ... created_at updated_at
1436 2025-09-12 13480.0 ... 2025-09-12 18:53:18.078765 2025-09-12 18:53:18.079150
[1 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-12 18:53:22,188 - IOOppi_data - INFO : save diff data to db IOOppi_lh_g: date ... updated_at
116 2021-07-05 ... 2025-09-12 18:53:22.180221
117 2021-07-06 ... 2025-09-12 18:53:22.180221
121 2021-07-12 ... 2025-09-12 18:53:22.180221
122 2021-07-13 ... 2025-09-12 18:53:22.180221
194 2021-11-01 ... 2025-09-12 18:53:22.180221
[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-12 18:53:22,877 - IOOppi_data - INFO : save data to db IOOppi_cu_t data:
date value
3861 2025-09-08 79893.33
3862 2025-09-09 79890.00
3863 2025-09-10 79776.67
3864 2025-09-11 80198.33
3865 2025-09-12 80945.00
2025-09-12 18:53:41,221 - IOOppi_data - INFO : save new data to db IOOppi_cu_t: date value ... created_at updated_at
3865 2025-09-12 80945.0 ... 2025-09-12 18:53:41.213250 2025-09-12 18:53:41.213688
[1 rows x 5 columns]
2025-09-12 18:53:41,444 - IOOppi_data - INFO : save diff data to db: IOOppi_cu_t: no diff data
2025-09-12 18:53:41,451 - IOOppi_data - INFO : save data to db IOOppi_cu_g data:
date value
3861 2025-09-08 79893.33
3862 2025-09-09 79890.00
3863 2025-09-10 79776.67
3864 2025-09-11 80198.33
3865 2025-09-12 80945.00
2025-09-12 18:53:44,480 - IOOppi_data - INFO : save new data to db IOOppi_cu_g: date value ... created_at updated_at
3868 2025-09-12 80945.0 ... 2025-09-12 18:53:44.472854 2025-09-12 18:53:44.473240
[1 rows x 5 columns]
2025-09-12 18:53:44,702 - IOOppi_data - INFO : save diff data to db: IOOppi_cu_g: no diff data
/usr/local/lib/python3.10/site-packages/urllib3/connectionpool.py:1056: InsecureRequestWarning: Unverified HTTPS request is being made to host 'www.100ppi.com'. Adding certificate verification is strongly advised. See: https://urllib3.readthedocs.io/en/1.26.x/advanced-usage.html#ssl-warnings
warnings.warn(
2025-09-12 18:53:45,622 - IOOppi_data - INFO : save data to db IOOppi_PM_t data:
date value
2947 2024-06-26 2440.0
2948 2024-06-27 2460.0
2949 2024-06-28 2460.0
2950 2024-06-29 2460.0
2951 2024-06-30 2460.0
2025-09-12 18:53:50,028 - IOOppi_data - INFO : save new data to db: IOOppi_PM_t: no new data
2025-09-12 18:53:50,028 - IOOppi_data - INFO : save diff data to db: IOOppi_PM_t: no diff data
2025-09-12 18:53:50,034 - IOOppi_data - INFO : save data to db IOOppi_PM_g data:
date value
2947 2024-06-26 2440.0
2948 2024-06-27 2460.0
2949 2024-06-28 2460.0
2950 2024-06-29 2460.0
2951 2024-06-30 2460.0
2025-09-12 18:53:56,542 - IOOppi_data - INFO : save new data to db: IOOppi_PM_g: no new data
2025-09-12 18:53:56,542 - IOOppi_data - INFO : save diff data to db: IOOppi_PM_g: no diff data
/usr/local/lib/python3.10/site-packages/urllib3/connectionpool.py:1056: InsecureRequestWarning: Unverified HTTPS request is being made to host 'www.100ppi.com'. Adding certificate verification is strongly advised. See: https://urllib3.readthedocs.io/en/1.26.x/advanced-usage.html#ssl-warnings
warnings.warn(
2025-09-12 18:53:57,225 - IOOppi_data - INFO : save data to db IOOppi_sn_t data:
date value
2839 2025-09-08 269575.0
2840 2025-09-09 270400.0
2841 2025-09-10 270187.5
2842 2025-09-11 271125.0
2843 2025-09-12 274212.5
2025-09-12 18:54:09,826 - IOOppi_data - INFO : save new data to db IOOppi_sn_t: date ... updated_at
2843 2025-09-12 ... 2025-09-12 18:54:09.820780
[1 rows x 5 columns]
2025-09-12 18:54:10,461 - IOOppi_data - INFO : save diff data to db: IOOppi_sn_t: no diff data
2025-09-12 18:54:10,467 - IOOppi_data - INFO : save data to db IOOppi_sn_g data:
date value
2839 2025-09-08 269575.0
2840 2025-09-09 270400.0
2841 2025-09-10 270187.5
2842 2025-09-11 271125.0
2843 2025-09-12 274212.5
2025-09-12 18:54:14,648 - IOOppi_data - INFO : save new data to db IOOppi_sn_g: date ... updated_at
2846 2025-09-12 ... 2025-09-12 18:54:14.642524
[1 rows x 5 columns]
2025-09-12 18:54:15,487 - IOOppi_data - INFO : save diff data to db: IOOppi_sn_g: no diff data
/usr/local/lib/python3.10/site-packages/urllib3/connectionpool.py:1056: InsecureRequestWarning: Unverified HTTPS request is being made to host 'www.100ppi.com'. Adding certificate verification is strongly advised. See: https://urllib3.readthedocs.io/en/1.26.x/advanced-usage.html#ssl-warnings
warnings.warn(
2025-09-12 18:54:16,150 - IOOppi_data - INFO : save data to db IOOppi_zn_t data:
date value
3860 2025-09-08 22128.0
3861 2025-09-09 22170.0
3862 2025-09-10 22080.0
3863 2025-09-11 22166.0
3864 2025-09-12 22212.0
2025-09-12 18:54:33,795 - IOOppi_data - INFO : save new data to db IOOppi_zn_t: date value ... created_at updated_at
3864 2025-09-12 22212.0 ... 2025-09-12 18:54:33.787838 2025-09-12 18:54:33.788243
[1 rows x 5 columns]
2025-09-12 18:54:33,816 - IOOppi_data - INFO : save diff data to db: IOOppi_zn_t: no diff data
2025-09-12 18:54:33,822 - IOOppi_data - INFO : save data to db IOOppi_zn_g data:
date value
3860 2025-09-08 22128.0
3861 2025-09-09 22170.0
3862 2025-09-10 22080.0
3863 2025-09-11 22166.0
3864 2025-09-12 22212.0
2025-09-12 18:54:43,943 - IOOppi_data - INFO : save new data to db IOOppi_zn_g: date value ... created_at updated_at
3867 2025-09-12 22212.0 ... 2025-09-12 18:54:43.935933 2025-09-12 18:54:43.936355
[1 rows x 5 columns]
2025-09-12 18:54:46,513 - IOOppi_data - INFO : save diff data to db: IOOppi_zn_g: no diff data
/usr/local/lib/python3.10/site-packages/urllib3/connectionpool.py:1056: InsecureRequestWarning: Unverified HTTPS request is being made to host 'www.100ppi.com'. Adding certificate verification is strongly advised. See: https://urllib3.readthedocs.io/en/1.26.x/advanced-usage.html#ssl-warnings
warnings.warn(
2025-09-12 18:54:47,092 - IOOppi_data - INFO : save data to db IOOppi_wr_t data:
date value
3823 2025-09-08 3312.5
3824 2025-09-09 3317.5
3825 2025-09-10 3315.0
3826 2025-09-11 3305.0
3827 2025-09-12 3290.0
2025-09-12 18:54:50,606 - IOOppi_data - INFO : save new data to db IOOppi_wr_t: date value ... created_at updated_at
3827 2025-09-12 3290.0 ... 2025-09-12 18:54:50.599342 2025-09-12 18:54:50.599756
[1 rows x 5 columns]
2025-09-12 18:55:04,589 - IOOppi_data - INFO : save diff data to db: IOOppi_wr_t: no diff data
2025-09-12 18:55:04,596 - IOOppi_data - INFO : save data to db IOOppi_wr_g data:
date value
3823 2025-09-08 3312.5
3824 2025-09-09 3317.5
3825 2025-09-10 3315.0
3826 2025-09-11 3305.0
3827 2025-09-12 3290.0
2025-09-12 18:55:16,572 - IOOppi_data - INFO : save new data to db IOOppi_wr_g: date value ... created_at updated_at
3830 2025-09-12 3290.0 ... 2025-09-12 18:55:16.565001 2025-09-12 18:55:16.565387
[1 rows x 5 columns]
2025-09-12 18:55:16,590 - IOOppi_data - INFO : save diff data to db: IOOppi_wr_g: no diff data
/usr/local/lib/python3.10/site-packages/urllib3/connectionpool.py:1056: InsecureRequestWarning: Unverified HTTPS request is being made to host 'www.100ppi.com'. Adding certificate verification is strongly advised. See: https://urllib3.readthedocs.io/en/1.26.x/advanced-usage.html#ssl-warnings
warnings.warn(
2025-09-12 18:55:18,263 - IOOppi_data - INFO : save data to db IOOppi_pg_t data:
date value
1620 2025-09-08 4692.5
1621 2025-09-09 4692.5
1622 2025-09-10 4687.5
1623 2025-09-11 4665.0
1624 2025-09-12 4635.0
2025-09-12 18:55:24,522 - IOOppi_data - INFO : save new data to db IOOppi_pg_t: date value ... created_at updated_at
1624 2025-09-12 4635.0 ... 2025-09-12 18:55:24.515283 2025-09-12 18:55:24.515691
[1 rows x 5 columns]
2025-09-12 18:55:24,540 - IOOppi_data - INFO : save diff data to db: IOOppi_pg_t: no diff data
2025-09-12 18:55:24,545 - IOOppi_data - INFO : save data to db IOOppi_pg_g data:
date value
1620 2025-09-08 4692.5
1621 2025-09-09 4692.5
1622 2025-09-10 4687.5
1623 2025-09-11 4665.0
1624 2025-09-12 4635.0
2025-09-12 18:55:35,486 - IOOppi_data - INFO : save new data to db IOOppi_pg_g: date value ... created_at updated_at
1627 2025-09-12 4635.0 ... 2025-09-12 18:55:35.478424 2025-09-12 18:55:35.478837
[1 rows x 5 columns]
2025-09-12 18:55:35,506 - IOOppi_data - INFO : save diff data to db: IOOppi_pg_g: no diff data
/usr/local/lib/python3.10/site-packages/urllib3/connectionpool.py:1056: InsecureRequestWarning: Unverified HTTPS request is being made to host 'www.100ppi.com'. Adding certificate verification is strongly advised. See: https://urllib3.readthedocs.io/en/1.26.x/advanced-usage.html#ssl-warnings
warnings.warn(
2025-09-12 18:55:36,201 - IOOppi_data - INFO : save data to db IOOppi_cs_t data:
date value
2894 2025-09-08 2307.14
2895 2025-09-09 2310.00
2896 2025-09-10 2308.57
2897 2025-09-11 2307.14
2898 2025-09-12 2302.86
2025-09-12 18:55:40,966 - IOOppi_data - INFO : save new data to db IOOppi_cs_t: date value ... created_at updated_at
2898 2025-09-12 2302.86 ... 2025-09-12 18:55:40.959066 2025-09-12 18:55:40.959452
[1 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-12 18:55:41,213 - IOOppi_data - INFO : save diff data to db IOOppi_cs_t: date ... updated_at
2897 2025-09-11 ... 2025-09-12 18:55:41.205947
[1 rows x 6 columns]
2025-09-12 18:55:41,237 - IOOppi_data - INFO : save data to db IOOppi_cs_g data:
date value
2894 2025-09-08 2307.14
2895 2025-09-09 2310.00
2896 2025-09-10 2308.57
2897 2025-09-11 2307.14
2898 2025-09-12 2302.86
2025-09-12 18:55:45,464 - IOOppi_data - INFO : save new data to db IOOppi_cs_g: date value ... created_at updated_at
2901 2025-09-12 2302.86 ... 2025-09-12 18:55:45.456557 2025-09-12 18:55:45.457010
[1 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-12 18:55:45,509 - IOOppi_data - INFO : save diff data to db IOOppi_cs_g: date ... updated_at
2900 2025-09-11 ... 2025-09-12 18:55:45.498390
[1 rows x 6 columns]
/usr/local/lib/python3.10/site-packages/urllib3/connectionpool.py:1056: InsecureRequestWarning: Unverified HTTPS request is being made to host 'www.100ppi.com'. Adding certificate verification is strongly advised. See: https://urllib3.readthedocs.io/en/1.26.x/advanced-usage.html#ssl-warnings
warnings.warn(
2025-09-12 18:55:48,076 - IOOppi_data - INFO : save data to db IOOppi_cs_t data:
date value
2894 2025-09-08 2307.14
2895 2025-09-09 2310.00
2896 2025-09-10 2308.57
2897 2025-09-11 2307.14
2898 2025-09-12 2848.00
2025-09-12 18:55:52,096 - IOOppi_data - INFO : save new data to db: IOOppi_cs_t: no new data
/root/project/IOOppi_data/IOOppi_request.py:308: SettingWithCopyWarning:
A value is trying to be set on a copy of a slice from a DataFrame.
Try using .loc[row_indexer,col_indexer] = value instead
See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy
diff_df.loc[:, 'index_code'] = index_code
/root/project/IOOppi_data/IOOppi_request.py:309: SettingWithCopyWarning:
A value is trying to be set on a copy of a slice from a DataFrame.
Try using .loc[row_indexer,col_indexer] = value instead
See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy
diff_df.loc[:, 'created_at'] = datetime.datetime.now()
/root/project/IOOppi_data/IOOppi_request.py:310: SettingWithCopyWarning:
A value is trying to be set on a copy of a slice from a DataFrame.
Try using .loc[row_indexer,col_indexer] = value instead
See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy
diff_df.loc[:, 'updated_at'] = datetime.datetime.now()
2025-09-12 18:55:52,119 - IOOppi_data - INFO : save diff data to db IOOppi_cs_t: date ... updated_at
2898 2025-09-12 ... 2025-09-12 18:55:52.111967
[1 rows x 6 columns]
2025-09-12 18:55:52,144 - IOOppi_data - INFO : save data to db IOOppi_cs_g data:
date value
2894 2025-09-08 2307.14
2895 2025-09-09 2310.00
2896 2025-09-10 2308.57
2897 2025-09-11 2307.14
2898 2025-09-12 2848.00
2025-09-12 18:55:55,511 - IOOppi_data - INFO : save new data to db: IOOppi_cs_g: no new data
/root/project/IOOppi_data/IOOppi_request.py:308: SettingWithCopyWarning:
A value is trying to be set on a copy of a slice from a DataFrame.
Try using .loc[row_indexer,col_indexer] = value instead
See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy
diff_df.loc[:, 'index_code'] = index_code
/root/project/IOOppi_data/IOOppi_request.py:309: SettingWithCopyWarning:
A value is trying to be set on a copy of a slice from a DataFrame.
Try using .loc[row_indexer,col_indexer] = value instead
See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy
diff_df.loc[:, 'created_at'] = datetime.datetime.now()
/root/project/IOOppi_data/IOOppi_request.py:310: SettingWithCopyWarning:
A value is trying to be set on a copy of a slice from a DataFrame.
Try using .loc[row_indexer,col_indexer] = value instead
See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy
diff_df.loc[:, 'updated_at'] = datetime.datetime.now()
2025-09-12 18:55:55,533 - IOOppi_data - INFO : save diff data to db IOOppi_cs_g: date ... updated_at
2901 2025-09-12 ... 2025-09-12 18:55:55.526243
[1 rows x 6 columns]
/usr/local/lib/python3.10/site-packages/urllib3/connectionpool.py:1056: InsecureRequestWarning: Unverified HTTPS request is being made to host 'www.100ppi.com'. Adding certificate verification is strongly advised. See: https://urllib3.readthedocs.io/en/1.26.x/advanced-usage.html#ssl-warnings
warnings.warn(
2025-09-12 18:55:56,044 - IOOppi_data - INFO : save data to db IOOppi_RS_t data:
date value
3251 2025-09-08 9941.67
3252 2025-09-09 9980.00
3253 2025-09-10 9920.00
3254 2025-09-11 10020.00
3255 2025-09-12 10000.00
2025-09-12 18:56:04,277 - IOOppi_data - INFO : save new data to db: IOOppi_RS_t: no new data
2025-09-12 18:56:04,277 - IOOppi_data - INFO : save diff data to db: IOOppi_RS_t: no diff data
2025-09-12 18:56:04,283 - IOOppi_data - INFO : save data to db IOOppi_RS_g data:
date value
3251 2025-09-08 9941.67
3252 2025-09-09 9980.00
3253 2025-09-10 9920.00
3254 2025-09-11 10020.00
3255 2025-09-12 10000.00
2025-09-12 18:58:04,191 - IOOppi_data - INFO : save new data to db: IOOppi_RS_g: no new data
2025-09-12 18:58:04,191 - 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-12 18:58:04,818 - IOOppi_data - INFO : save data to db IOOppi_eg_t data:
date value
1935 2025-09-08 4486.67
1936 2025-09-09 4490.00
1937 2025-09-10 4470.00
1938 2025-09-11 4470.00
1939 2025-09-12 4466.67
2025-09-12 18:58:05,282 - IOOppi_data - INFO : save new data to db IOOppi_eg_t: date value ... created_at updated_at
1939 2025-09-12 4466.67 ... 2025-09-12 18:58:05.274505 2025-09-12 18:58:05.274978
[1 rows x 5 columns]
2025-09-12 18:58:05,506 - IOOppi_data - INFO : save diff data to db: IOOppi_eg_t: no diff data
2025-09-12 18:58:05,512 - IOOppi_data - INFO : save data to db IOOppi_eg_g data:
date value
1935 2025-09-08 4486.67
1936 2025-09-09 4490.00
1937 2025-09-10 4470.00
1938 2025-09-11 4470.00
1939 2025-09-12 4466.67
2025-09-12 18:58:10,136 - IOOppi_data - INFO : save new data to db IOOppi_eg_g: date value ... created_at updated_at
1942 2025-09-12 4466.67 ... 2025-09-12 18:58:10.129661 2025-09-12 18:58:10.130064
[1 rows x 5 columns]
2025-09-12 18:58:10,155 - IOOppi_data - INFO : save diff data to db: IOOppi_eg_g: no diff data
/usr/local/lib/python3.10/site-packages/urllib3/connectionpool.py:1056: InsecureRequestWarning: Unverified HTTPS request is being made to host 'www.100ppi.com'. Adding certificate verification is strongly advised. See: https://urllib3.readthedocs.io/en/1.26.x/advanced-usage.html#ssl-warnings
warnings.warn(
2025-09-12 18:58:10,723 - IOOppi_data - INFO : save data to db IOOppi_sp_t data:
date value
1944 2025-09-08 5716.67
1945 2025-09-09 5700.00
1946 2025-09-10 5700.00
1947 2025-09-11 5700.00
1948 2025-09-12 5716.67
2025-09-12 18:58:12,296 - IOOppi_data - INFO : save new data to db IOOppi_sp_t: date value ... created_at updated_at
1948 2025-09-12 5716.67 ... 2025-09-12 18:58:12.289163 2025-09-12 18:58:12.289551
[1 rows x 5 columns]
2025-09-12 18:58:12,519 - IOOppi_data - INFO : save diff data to db: IOOppi_sp_t: no diff data
2025-09-12 18:58:12,525 - IOOppi_data - INFO : save data to db IOOppi_sp_g data:
date value
1944 2025-09-08 5716.67
1945 2025-09-09 5700.00
1946 2025-09-10 5700.00
1947 2025-09-11 5700.00
1948 2025-09-12 5716.67
2025-09-12 18:58:13,006 - IOOppi_data - INFO : save new data to db IOOppi_sp_g: date value ... created_at updated_at
1951 2025-09-12 5716.67 ... 2025-09-12 18:58:12.998722 2025-09-12 18:58:12.999126
[1 rows x 5 columns]
2025-09-12 18:58:13,229 - IOOppi_data - INFO : save diff data to db: IOOppi_sp_g: no diff data
/usr/local/lib/python3.10/site-packages/urllib3/connectionpool.py:1056: InsecureRequestWarning: Unverified HTTPS request is being made to host 'www.100ppi.com'. Adding certificate verification is strongly advised. See: https://urllib3.readthedocs.io/en/1.26.x/advanced-usage.html#ssl-warnings
warnings.warn(
2025-09-12 18:58:13,847 - IOOppi_data - INFO : save data to db IOOppi_p_t data:
date value
3612 2025-09-08 9454.0
3613 2025-09-09 9520.0
3614 2025-09-10 9380.0
3615 2025-09-11 9354.0
3616 2025-09-12 9354.0
2025-09-12 18:58:25,979 - IOOppi_data - INFO : save new data to db IOOppi_p_t: date value ... created_at updated_at
3616 2025-09-12 9354.0 ... 2025-09-12 18:58:25.972139 2025-09-12 18:58:25.972573
[1 rows x 5 columns]
2025-09-12 18:58:25,998 - IOOppi_data - INFO : save diff data to db: IOOppi_p_t: no diff data
2025-09-12 18:58:26,004 - IOOppi_data - INFO : save data to db IOOppi_p_g data:
date value
3612 2025-09-08 9454.0
3613 2025-09-09 9520.0
3614 2025-09-10 9380.0
3615 2025-09-11 9354.0
3616 2025-09-12 9354.0
2025-09-12 18:58:39,052 - IOOppi_data - INFO : save new data to db IOOppi_p_g: date value ... created_at updated_at
3619 2025-09-12 9354.0 ... 2025-09-12 18:58:39.045475 2025-09-12 18:58:39.045897
[1 rows x 5 columns]
2025-09-12 18:58:39,073 - IOOppi_data - INFO : save diff data to db: IOOppi_p_g: no diff data
Traceback (most recent call last):
File "/usr/local/lib/python3.10/site-packages/pymysql/connections.py", line 736, in _read_bytes
data = self._rfile.read(num_bytes)
File "/usr/local/lib/python3.10/socket.py", line 705, in readinto
return self._sock.recv_into(b)
ConnectionResetError: [Errno 104] Connection reset by peer
During handling of the above exception, another exception occurred:
Traceback (most recent call last):
File "/usr/local/lib/python3.10/site-packages/sqlalchemy/engine/base.py", line 1967, in _exec_single_context
self.dialect.do_execute(
File "/usr/local/lib/python3.10/site-packages/sqlalchemy/engine/default.py", line 951, in do_execute
cursor.execute(statement, parameters)
File "/usr/local/lib/python3.10/site-packages/pymysql/cursors.py", line 158, in execute
result = self._query(query)
File "/usr/local/lib/python3.10/site-packages/pymysql/cursors.py", line 325, in _query
conn.query(q)
File "/usr/local/lib/python3.10/site-packages/pymysql/connections.py", line 549, in query
self._affected_rows = self._read_query_result(unbuffered=unbuffered)
File "/usr/local/lib/python3.10/site-packages/pymysql/connections.py", line 779, in _read_query_result
result.read()
File "/usr/local/lib/python3.10/site-packages/pymysql/connections.py", line 1164, in read
self._read_result_packet(first_packet)
File "/usr/local/lib/python3.10/site-packages/pymysql/connections.py", line 1240, in _read_result_packet
self._read_rowdata_packet()
File "/usr/local/lib/python3.10/site-packages/pymysql/connections.py", line 1274, in _read_rowdata_packet
packet = self.connection._read_packet()
File "/usr/local/lib/python3.10/site-packages/pymysql/connections.py", line 715, in _read_packet
recv_data = self._read_bytes(bytes_to_read)
File "/usr/local/lib/python3.10/site-packages/pymysql/connections.py", line 742, in _read_bytes
raise err.OperationalError(
pymysql.err.OperationalError: (2013, 'Lost connection to MySQL server during query ([Errno 104] Connection reset by peer)')
The above exception was the direct cause of the following exception:
Traceback (most recent call last):
File "/root/project/IOOppi_data/update_data.py", line 16, in
client.update_data_all()
File "/root/project/IOOppi_data/IOOppi_request.py", line 525, in update_data_all
self.update_time_period_data(cmd_id)
File "/root/project/IOOppi_data/IOOppi_request.py", line 455, in update_time_period_data
self.save_data(index_code, content_df)
File "/root/project/IOOppi_data/IOOppi_request.py", line 235, in save_data
self.save_data_to_db(index_code, df)
File "/root/project/IOOppi_data/IOOppi_request.py", line 249, in save_data_to_db
df = pd.read_sql(sql, self.engine)
File "/usr/local/lib/python3.10/site-packages/pandas/io/sql.py", line 736, in read_sql
return pandas_sql.read_query(
File "/usr/local/lib/python3.10/site-packages/pandas/io/sql.py", line 1848, in read_query
result = self.execute(sql, params)
File "/usr/local/lib/python3.10/site-packages/pandas/io/sql.py", line 1671, in execute
return self.con.exec_driver_sql(sql, *args)
File "/usr/local/lib/python3.10/site-packages/sqlalchemy/engine/base.py", line 1779, in exec_driver_sql
ret = self._execute_context(
File "/usr/local/lib/python3.10/site-packages/sqlalchemy/engine/base.py", line 1846, in _execute_context
return self._exec_single_context(
File "/usr/local/lib/python3.10/site-packages/sqlalchemy/engine/base.py", line 1986, in _exec_single_context
self._handle_dbapi_exception(
File "/usr/local/lib/python3.10/site-packages/sqlalchemy/engine/base.py", line 2355, in _handle_dbapi_exception
raise sqlalchemy_exception.with_traceback(exc_info[2]) from e
File "/usr/local/lib/python3.10/site-packages/sqlalchemy/engine/base.py", line 1967, in _exec_single_context
self.dialect.do_execute(
File "/usr/local/lib/python3.10/site-packages/sqlalchemy/engine/default.py", line 951, in do_execute
cursor.execute(statement, parameters)
File "/usr/local/lib/python3.10/site-packages/pymysql/cursors.py", line 158, in execute
result = self._query(query)
File "/usr/local/lib/python3.10/site-packages/pymysql/cursors.py", line 325, in _query
conn.query(q)
File "/usr/local/lib/python3.10/site-packages/pymysql/connections.py", line 549, in query
self._affected_rows = self._read_query_result(unbuffered=unbuffered)
File "/usr/local/lib/python3.10/site-packages/pymysql/connections.py", line 779, in _read_query_result
result.read()
File "/usr/local/lib/python3.10/site-packages/pymysql/connections.py", line 1164, in read
self._read_result_packet(first_packet)
File "/usr/local/lib/python3.10/site-packages/pymysql/connections.py", line 1240, in _read_result_packet
self._read_rowdata_packet()
File "/usr/local/lib/python3.10/site-packages/pymysql/connections.py", line 1274, in _read_rowdata_packet
packet = self.connection._read_packet()
File "/usr/local/lib/python3.10/site-packages/pymysql/connections.py", line 715, in _read_packet
recv_data = self._read_bytes(bytes_to_read)
File "/usr/local/lib/python3.10/site-packages/pymysql/connections.py", line 742, in _read_bytes
raise err.OperationalError(
sqlalchemy.exc.OperationalError: (pymysql.err.OperationalError) (2013, 'Lost connection to MySQL server during query ([Errno 104] Connection reset by peer)')
[SQL: SELECT `IOOppi_data`.date AS date, `IOOppi_data`.value AS value
FROM `IOOppi_data`
WHERE `IOOppi_data`.index_code = 'IOOppi_SF_g']
(Background on this error at: https://sqlalche.me/e/20/e3q8)