=========================================================================
2025-07-24 17:50:26 Thu 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-07-24 17:50:28,476 - IOOppi_data - INFO : save data to db IOOppi_rb_t data:
date value
3370 2025-07-20 3196.0
3371 2025-07-21 3234.0
3372 2025-07-22 3297.0
3373 2025-07-23 3302.5
3374 2025-07-24 3349.5
2025-07-24 17:50:28,557 - IOOppi_data - INFO : save new data to db IOOppi_rb_t: date value ... created_at updated_at
3374 2025-07-24 3349.5 ... 2025-07-24 17:50:28.549593 2025-07-24 17:50:28.550030
[1 rows x 5 columns]
2025-07-24 17:50:28,579 - IOOppi_data - INFO : save diff data to db: IOOppi_rb_t: no diff data
2025-07-24 17:50:28,585 - IOOppi_data - INFO : save data to db IOOppi_rb_g data:
date value
3370 2025-07-20 3196.0
3371 2025-07-21 3234.0
3372 2025-07-22 3297.0
3373 2025-07-23 3302.5
3374 2025-07-24 3349.5
2025-07-24 17:50:28,660 - IOOppi_data - INFO : save new data to db IOOppi_rb_g: date value ... created_at updated_at
3377 2025-07-24 3349.5 ... 2025-07-24 17:50:28.652571 2025-07-24 17:50:28.652981
[1 rows x 5 columns]
2025-07-24 17:50:28,680 - 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-07-24 17:50:29,306 - IOOppi_data - INFO : save data to db IOOppi_MA_t data:
date value
3591 2025-07-20 2383.33
3592 2025-07-21 2405.00
3593 2025-07-22 2433.33
3594 2025-07-23 2404.17
3595 2025-07-24 2459.17
2025-07-24 17:50:29,381 - IOOppi_data - INFO : save new data to db IOOppi_MA_t: date value ... created_at updated_at
3595 2025-07-24 2459.17 ... 2025-07-24 17:50:29.374704 2025-07-24 17:50:29.375121
[1 rows x 5 columns]
2025-07-24 17:50:29,400 - IOOppi_data - INFO : save diff data to db: IOOppi_MA_t: no diff data
2025-07-24 17:50:29,406 - IOOppi_data - INFO : save data to db IOOppi_MA_g data:
date value
3591 2025-07-20 2383.33
3592 2025-07-21 2405.00
3593 2025-07-22 2433.33
3594 2025-07-23 2404.17
3595 2025-07-24 2459.17
2025-07-24 17:50:29,480 - IOOppi_data - INFO : save new data to db IOOppi_MA_g: date value ... created_at updated_at
3599 2025-07-24 2459.17 ... 2025-07-24 17:50:29.473271 2025-07-24 17:50:29.473648
[1 rows x 5 columns]
2025-07-24 17:50:29,498 - 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-07-24 17:50:30,112 - IOOppi_data - INFO : save data to db IOOppi_PTA_t data:
date value
931 2025-07-20 4776.66
932 2025-07-21 4825.00
933 2025-07-22 4817.00
934 2025-07-23 4831.34
935 2025-07-24 4831.34
2025-07-24 17:50:30,152 - IOOppi_data - INFO : save new data to db IOOppi_PTA_t: date value ... created_at updated_at
935 2025-07-24 4831.34 ... 2025-07-24 17:50:30.144987 2025-07-24 17:50:30.145375
[1 rows x 5 columns]
2025-07-24 17:50:30,172 - IOOppi_data - INFO : save diff data to db: IOOppi_PTA_t: no diff data
2025-07-24 17:50:30,177 - IOOppi_data - INFO : save data to db IOOppi_PTA_g data:
date value
931 2025-07-20 4776.66
932 2025-07-21 4825.00
933 2025-07-22 4817.00
934 2025-07-23 4831.34
935 2025-07-24 4831.34
2025-07-24 17:50:30,216 - IOOppi_data - INFO : save new data to db IOOppi_PTA_g: date value ... created_at updated_at
935 2025-07-24 4831.34 ... 2025-07-24 17:50:30.209587 2025-07-24 17:50:30.209993
[1 rows x 5 columns]
2025-07-24 17:50:30,235 - 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-07-24 17:50:30,938 - IOOppi_data - INFO : save data to db IOOppi_ru_t data:
date value
3810 2025-07-20 14900.00
3811 2025-07-21 14941.67
3812 2025-07-22 15108.33
3813 2025-07-23 15066.67
3814 2025-07-24 15291.67
2025-07-24 17:50:31,017 - IOOppi_data - INFO : save new data to db IOOppi_ru_t: date ... updated_at
3814 2025-07-24 ... 2025-07-24 17:50:31.011131
[1 rows x 5 columns]
2025-07-24 17:50:31,037 - IOOppi_data - INFO : save diff data to db: IOOppi_ru_t: no diff data
2025-07-24 17:50:31,042 - IOOppi_data - INFO : save data to db IOOppi_ru_g data:
date value
3810 2025-07-20 14900.00
3811 2025-07-21 14941.67
3812 2025-07-22 15108.33
3813 2025-07-23 15066.67
3814 2025-07-24 15291.67
2025-07-24 17:50:31,117 - IOOppi_data - INFO : save new data to db IOOppi_ru_g: date ... updated_at
3817 2025-07-24 ... 2025-07-24 17:50:31.111239
[1 rows x 5 columns]
2025-07-24 17:50:31,136 - 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-07-24 17:50:31,889 - IOOppi_data - INFO : save data to db IOOppi_i_t data:
date value
3142 2025-07-20 779.22
3143 2025-07-21 799.11
3144 2025-07-22 798.89
3145 2025-07-23 798.89
3146 2025-07-24 800.44
2025-07-24 17:50:31,958 - IOOppi_data - INFO : save new data to db IOOppi_i_t: date value ... created_at updated_at
3146 2025-07-24 800.44 ... 2025-07-24 17:50:31.951249 2025-07-24 17:50:31.951630
[1 rows x 5 columns]
2025-07-24 17:50:31,977 - IOOppi_data - INFO : save diff data to db: IOOppi_i_t: no diff data
2025-07-24 17:50:31,983 - IOOppi_data - INFO : save data to db IOOppi_i_g data:
date value
3142 2025-07-20 779.22
3143 2025-07-21 799.11
3144 2025-07-22 798.89
3145 2025-07-23 798.89
3146 2025-07-24 800.44
2025-07-24 17:50:32,050 - IOOppi_data - INFO : save new data to db IOOppi_i_g: date value ... created_at updated_at
3149 2025-07-24 800.44 ... 2025-07-24 17:50:32.043782 2025-07-24 17:50:32.044176
[1 rows x 5 columns]
2025-07-24 17:50:32,074 - 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-07-24 17:50:32,713 - IOOppi_data - INFO : save data to db IOOppi_FG_t data:
date value
3345 2025-07-20 1142.4
3346 2025-07-21 1174.4
3347 2025-07-22 1174.4
3348 2025-07-23 1210.4
3349 2025-07-24 1216.0
2025-07-24 17:50:32,786 - IOOppi_data - INFO : save new data to db IOOppi_FG_t: date value ... created_at updated_at
3349 2025-07-24 1216.0 ... 2025-07-24 17:50:32.778971 2025-07-24 17:50:32.779361
[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-07-24 17:50:34,864 - IOOppi_data - INFO : save diff data to db IOOppi_FG_t: date ... updated_at
12 2012-12-19 ... 2025-07-24 17:50:34.857046
21 2013-01-04 ... 2025-07-24 17:50:34.857046
54 2013-02-27 ... 2025-07-24 17:50:34.857046
60 2013-03-07 ... 2025-07-24 17:50:34.857046
61 2013-03-08 ... 2025-07-24 17:50:34.857046
[5 rows x 6 columns]
2025-07-24 17:50:35,047 - IOOppi_data - INFO : save data to db IOOppi_FG_g data:
date value
3345 2025-07-20 1142.4
3346 2025-07-21 1174.4
3347 2025-07-22 1174.4
3348 2025-07-23 1210.4
3349 2025-07-24 1216.0
2025-07-24 17:50:35,117 - IOOppi_data - INFO : save new data to db IOOppi_FG_g: date value ... created_at updated_at
3353 2025-07-24 1216.0 ... 2025-07-24 17:50:35.110297 2025-07-24 17:50:35.110698
[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-07-24 17:50:37,090 - IOOppi_data - INFO : save diff data to db IOOppi_FG_g: date ... updated_at
12 2012-12-19 ... 2025-07-24 17:50:37.082018
21 2013-01-04 ... 2025-07-24 17:50:37.082018
54 2013-02-27 ... 2025-07-24 17:50:37.082018
60 2013-03-07 ... 2025-07-24 17:50:37.082018
61 2013-03-08 ... 2025-07-24 17:50:37.082018
[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-07-24 17:50:37,891 - IOOppi_data - INFO : save data to db IOOppi_eb_t data:
date value
1690 2025-07-20 7846.0
1691 2025-07-21 7856.0
1692 2025-07-22 7860.0
1693 2025-07-23 7754.0
1694 2025-07-24 7744.0
2025-07-24 17:50:37,941 - IOOppi_data - INFO : save new data to db IOOppi_eb_t: date value ... created_at updated_at
1694 2025-07-24 7744.0 ... 2025-07-24 17:50:37.934040 2025-07-24 17:50:37.934426
[1 rows x 5 columns]
2025-07-24 17:50:37,959 - IOOppi_data - INFO : save diff data to db: IOOppi_eb_t: no diff data
2025-07-24 17:50:37,964 - IOOppi_data - INFO : save data to db IOOppi_eb_g data:
date value
1690 2025-07-20 7846.0
1691 2025-07-21 7856.0
1692 2025-07-22 7860.0
1693 2025-07-23 7754.0
1694 2025-07-24 7744.0
2025-07-24 17:50:38,015 - IOOppi_data - INFO : save new data to db IOOppi_eb_g: date value ... created_at updated_at
1697 2025-07-24 7744.0 ... 2025-07-24 17:50:38.007666 2025-07-24 17:50:38.008197
[1 rows x 5 columns]
2025-07-24 17:50:38,034 - 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-07-24 17:50:38,709 - IOOppi_data - INFO : save data to db IOOppi_SR_t data:
date value
3801 2025-07-20 6043.33
3802 2025-07-21 6046.67
3803 2025-07-22 6043.33
3804 2025-07-23 6050.00
3805 2025-07-24 6043.33
2025-07-24 17:50:38,784 - IOOppi_data - INFO : save new data to db IOOppi_SR_t: date value ... created_at updated_at
3805 2025-07-24 6043.33 ... 2025-07-24 17:50:38.776670 2025-07-24 17:50:38.777105
[1 rows x 5 columns]
2025-07-24 17:50:38,803 - IOOppi_data - INFO : save diff data to db: IOOppi_SR_t: no diff data
2025-07-24 17:50:38,809 - IOOppi_data - INFO : save data to db IOOppi_SR_g data:
date value
3801 2025-07-20 6043.33
3802 2025-07-21 6046.67
3803 2025-07-22 6043.33
3804 2025-07-23 6050.00
3805 2025-07-24 6043.33
2025-07-24 17:50:38,883 - IOOppi_data - INFO : save new data to db IOOppi_SR_g: date value ... created_at updated_at
3809 2025-07-24 6043.33 ... 2025-07-24 17:50:38.876259 2025-07-24 17:50:38.876646
[1 rows x 5 columns]
2025-07-24 17:50:38,902 - 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-07-24 17:50:39,706 - IOOppi_data - INFO : save data to db IOOppi_ss_t data:
date value
1691 2025-07-20 12937.5
1692 2025-07-21 12955.0
1693 2025-07-22 12955.0
1694 2025-07-23 13030.0
1695 2025-07-24 13030.0
2025-07-24 17:50:39,754 - IOOppi_data - INFO : save new data to db IOOppi_ss_t: date value ... created_at updated_at
1695 2025-07-24 13030.0 ... 2025-07-24 17:50:39.746704 2025-07-24 17:50:39.747124
[1 rows x 5 columns]
2025-07-24 17:50:39,775 - IOOppi_data - INFO : save diff data to db: IOOppi_ss_t: no diff data
2025-07-24 17:50:39,780 - IOOppi_data - INFO : save data to db IOOppi_ss_g data:
date value
1691 2025-07-20 12937.5
1692 2025-07-21 12955.0
1693 2025-07-22 12955.0
1694 2025-07-23 13030.0
1695 2025-07-24 13030.0
2025-07-24 17:50:39,827 - IOOppi_data - INFO : save new data to db IOOppi_ss_g: date value ... created_at updated_at
1698 2025-07-24 13030.0 ... 2025-07-24 17:50:39.819967 2025-07-24 17:50:39.820343
[1 rows x 5 columns]
2025-07-24 17:50:39,845 - 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-07-24 17:50:40,414 - IOOppi_data - INFO : save data to db IOOppi_RS_t data:
date value
3201 2025-07-20 9691.67
3202 2025-07-21 9681.67
3203 2025-07-22 9586.67
3204 2025-07-23 9570.00
3205 2025-07-24 9590.00
2025-07-24 17:50:40,483 - IOOppi_data - INFO : save new data to db IOOppi_RS_t: date value ... created_at updated_at
3205 2025-07-24 9590.0 ... 2025-07-24 17:50:40.476047 2025-07-24 17:50:40.476432
[1 rows x 5 columns]
2025-07-24 17:50:40,501 - IOOppi_data - INFO : save diff data to db: IOOppi_RS_t: no diff data
2025-07-24 17:50:40,507 - IOOppi_data - INFO : save data to db IOOppi_RS_g data:
date value
3201 2025-07-20 9691.67
3202 2025-07-21 9681.67
3203 2025-07-22 9586.67
3204 2025-07-23 9570.00
3205 2025-07-24 9590.00
2025-07-24 17:50:40,572 - IOOppi_data - INFO : save new data to db IOOppi_RS_g: date value ... created_at updated_at
3209 2025-07-24 9590.0 ... 2025-07-24 17:50:40.565387 2025-07-24 17:50:40.565789
[1 rows x 5 columns]
2025-07-24 17:50:40,590 - 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-07-24 17:50:41,206 - IOOppi_data - INFO : save data to db IOOppi_RM_t data:
date value
3324 2025-07-20 2668.33
3325 2025-07-21 2675.00
3326 2025-07-22 2690.00
3327 2025-07-23 2700.00
3328 2025-07-24 2630.00
2025-07-24 17:50:41,274 - IOOppi_data - INFO : save new data to db IOOppi_RM_t: date value ... created_at updated_at
3328 2025-07-24 2630.0 ... 2025-07-24 17:50:41.266685 2025-07-24 17:50:41.267111
[1 rows x 5 columns]
2025-07-24 17:50:41,293 - IOOppi_data - INFO : save diff data to db: IOOppi_RM_t: no diff data
2025-07-24 17:50:41,298 - IOOppi_data - INFO : save data to db IOOppi_RM_g data:
date value
3324 2025-07-20 2668.33
3325 2025-07-21 2675.00
3326 2025-07-22 2690.00
3327 2025-07-23 2700.00
3328 2025-07-24 2630.00
2025-07-24 17:50:41,365 - IOOppi_data - INFO : save new data to db IOOppi_RM_g: date value ... created_at updated_at
3332 2025-07-24 2630.0 ... 2025-07-24 17:50:41.358125 2025-07-24 17:50:41.358507
[1 rows x 5 columns]
2025-07-24 17:50:41,384 - 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-07-24 17:50:41,940 - IOOppi_data - INFO : save data to db IOOppi_SA_t data:
date value
1528 2025-07-20 1250.0
1529 2025-07-21 1250.0
1530 2025-07-22 1250.0
1531 2025-07-23 1270.0
1532 2025-07-24 1272.5
2025-07-24 17:50:41,987 - IOOppi_data - INFO : save new data to db IOOppi_SA_t: date value ... created_at updated_at
1532 2025-07-24 1272.5 ... 2025-07-24 17:50:41.979905 2025-07-24 17:50:41.980324
[1 rows x 5 columns]
2025-07-24 17:50:42,008 - IOOppi_data - INFO : save diff data to db: IOOppi_SA_t: no diff data
2025-07-24 17:50:42,014 - IOOppi_data - INFO : save data to db IOOppi_SA_g data:
date value
1528 2025-07-20 1250.0
1529 2025-07-21 1250.0
1530 2025-07-22 1250.0
1531 2025-07-23 1270.0
1532 2025-07-24 1272.5
2025-07-24 17:50:42,059 - IOOppi_data - INFO : save new data to db IOOppi_SA_g: date value ... created_at updated_at
1536 2025-07-24 1272.5 ... 2025-07-24 17:50:42.052283 2025-07-24 17:50:42.052686
[1 rows x 5 columns]
2025-07-24 17:50:42,078 - 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-07-24 17:50:42,635 - IOOppi_data - INFO : save data to db IOOppi_PF_t data:
date value
1441 2025-07-20 6643.33
1442 2025-07-21 6610.42
1443 2025-07-22 6592.08
1444 2025-07-23 6601.67
1445 2025-07-24 6599.17
2025-07-24 17:50:42,681 - IOOppi_data - INFO : save new data to db IOOppi_PF_t: date value ... created_at updated_at
1445 2025-07-24 6599.17 ... 2025-07-24 17:50:42.673248 2025-07-24 17:50:42.673731
[1 rows x 5 columns]
2025-07-24 17:50:42,700 - IOOppi_data - INFO : save diff data to db: IOOppi_PF_t: no diff data
2025-07-24 17:50:42,707 - IOOppi_data - INFO : save data to db IOOppi_PF_g data:
date value
1441 2025-07-20 6643.33
1442 2025-07-21 6610.42
1443 2025-07-22 6592.08
1444 2025-07-23 6601.67
1445 2025-07-24 6599.17
2025-07-24 17:50:42,753 - IOOppi_data - INFO : save new data to db IOOppi_PF_g: date value ... created_at updated_at
1449 2025-07-24 6599.17 ... 2025-07-24 17:50:42.745956 2025-07-24 17:50:42.746366
[1 rows x 5 columns]
2025-07-24 17:50:42,773 - 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-07-24 17:50:43,371 - IOOppi_data - INFO : save data to db IOOppi_m_t data:
date value
3814 2025-07-20 2966.0
3815 2025-07-21 2974.0
3816 2025-07-22 2990.0
3817 2025-07-23 3024.0
3818 2025-07-24 2980.0
2025-07-24 17:50:43,448 - IOOppi_data - INFO : save new data to db IOOppi_m_t: date value ... created_at updated_at
3818 2025-07-24 2980.0 ... 2025-07-24 17:50:43.441019 2025-07-24 17:50:43.441405
[1 rows x 5 columns]
2025-07-24 17:50:43,467 - IOOppi_data - INFO : save diff data to db: IOOppi_m_t: no diff data
2025-07-24 17:50:43,473 - IOOppi_data - INFO : save data to db IOOppi_m_g data:
date value
3814 2025-07-20 2966.0
3815 2025-07-21 2974.0
3816 2025-07-22 2990.0
3817 2025-07-23 3024.0
3818 2025-07-24 2980.0
2025-07-24 17:50:43,553 - IOOppi_data - INFO : save new data to db IOOppi_m_g: date value ... created_at updated_at
3821 2025-07-24 2980.0 ... 2025-07-24 17:50:43.546010 2025-07-24 17:50:43.546413
[1 rows x 5 columns]
2025-07-24 17:50:43,573 - 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-07-24 17:50:44,265 - IOOppi_data - INFO : save data to db IOOppi_y_t data:
date value
3584 2025-07-20 8414.0
3585 2025-07-21 8364.0
3586 2025-07-22 8334.0
3587 2025-07-23 8334.0
3588 2025-07-24 8414.0
2025-07-24 17:50:44,340 - IOOppi_data - INFO : save new data to db IOOppi_y_t: date value ... created_at updated_at
3588 2025-07-24 8414.0 ... 2025-07-24 17:50:44.332546 2025-07-24 17:50:44.332990
[1 rows x 5 columns]
2025-07-24 17:50:44,359 - IOOppi_data - INFO : save diff data to db: IOOppi_y_t: no diff data
2025-07-24 17:50:44,365 - IOOppi_data - INFO : save data to db IOOppi_y_g data:
date value
3584 2025-07-20 8414.0
3585 2025-07-21 8364.0
3586 2025-07-22 8334.0
3587 2025-07-23 8334.0
3588 2025-07-24 8414.0
2025-07-24 17:50:44,439 - IOOppi_data - INFO : save new data to db IOOppi_y_g: date value ... created_at updated_at
3591 2025-07-24 8414.0 ... 2025-07-24 17:50:44.431962 2025-07-24 17:50:44.432342
[1 rows x 5 columns]
2025-07-24 17:50:44,457 - 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-07-24 17:50:45,151 - IOOppi_data - INFO : save data to db IOOppi_a_t data:
date value
3550 2025-07-20 4295.0
3551 2025-07-21 4295.0
3552 2025-07-22 4295.0
3553 2025-07-23 4295.0
3554 2025-07-24 4295.0
2025-07-24 17:50:45,223 - IOOppi_data - INFO : save new data to db IOOppi_a_t: date value ... created_at updated_at
3554 2025-07-24 4295.0 ... 2025-07-24 17:50:45.216346 2025-07-24 17:50:45.216731
[1 rows x 5 columns]
2025-07-24 17:50:45,243 - IOOppi_data - INFO : save diff data to db: IOOppi_a_t: no diff data
2025-07-24 17:50:45,248 - IOOppi_data - INFO : save data to db IOOppi_a_g data:
date value
3550 2025-07-20 4295.0
3551 2025-07-21 4295.0
3552 2025-07-22 4295.0
3553 2025-07-23 4295.0
3554 2025-07-24 4295.0
2025-07-24 17:50:45,318 - IOOppi_data - INFO : save new data to db IOOppi_a_g: date value ... created_at updated_at
3557 2025-07-24 4295.0 ... 2025-07-24 17:50:45.310864 2025-07-24 17:50:45.311344
[1 rows x 5 columns]
2025-07-24 17:50:45,336 - 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-07-24 17:50:45,909 - IOOppi_data - INFO : save data to db IOOppi_SF_t data:
date value
2927 2025-07-20 5221.43
2928 2025-07-21 5221.43
2929 2025-07-22 5382.86
2930 2025-07-23 5495.71
2931 2025-07-24 5452.86
2025-07-24 17:50:45,970 - IOOppi_data - INFO : save new data to db IOOppi_SF_t: date value ... created_at updated_at
2931 2025-07-24 5452.86 ... 2025-07-24 17:50:45.963391 2025-07-24 17:50:45.963794
[1 rows x 5 columns]
2025-07-24 17:50:45,988 - IOOppi_data - INFO : save diff data to db: IOOppi_SF_t: no diff data
2025-07-24 17:50:45,994 - IOOppi_data - INFO : save data to db IOOppi_SF_g data:
date value
2927 2025-07-20 5221.43
2928 2025-07-21 5221.43
2929 2025-07-22 5382.86
2930 2025-07-23 5495.71
2931 2025-07-24 5452.86
2025-07-24 17:50:46,056 - IOOppi_data - INFO : save new data to db IOOppi_SF_g: date value ... created_at updated_at
2935 2025-07-24 5452.86 ... 2025-07-24 17:50:46.049112 2025-07-24 17:50:46.049575
[1 rows x 5 columns]
2025-07-24 17:50:46,075 - 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-07-24 17:50:46,685 - IOOppi_data - INFO : save data to db IOOppi_jd_t data:
date value
3127 2025-07-20 3050.0
3128 2025-07-21 3275.0
3129 2025-07-22 3300.0
3130 2025-07-23 3375.0
3131 2025-07-24 3440.0
2025-07-24 17:50:46,748 - IOOppi_data - INFO : save new data to db IOOppi_jd_t: date value ... created_at updated_at
3131 2025-07-24 3440.0 ... 2025-07-24 17:50:46.741412 2025-07-24 17:50:46.741817
[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-07-24 17:50:46,899 - IOOppi_data - INFO : save diff data to db IOOppi_jd_t: date ... updated_at
39 2014-01-03 ... 2025-07-24 17:50:46.891893
458 2015-09-21 ... 2025-07-24 17:50:46.891893
549 2016-02-03 ... 2025-07-24 17:50:46.891893
693 2016-09-05 ... 2025-07-24 17:50:46.891893
696 2016-09-08 ... 2025-07-24 17:50:46.891893
[5 rows x 6 columns]
2025-07-24 17:50:46,931 - IOOppi_data - INFO : save data to db IOOppi_jd_g data:
date value
3127 2025-07-20 3050.0
3128 2025-07-21 3275.0
3129 2025-07-22 3300.0
3130 2025-07-23 3375.0
3131 2025-07-24 3440.0
2025-07-24 17:50:46,996 - IOOppi_data - INFO : save new data to db IOOppi_jd_g: date value ... created_at updated_at
3134 2025-07-24 3440.0 ... 2025-07-24 17:50:46.988971 2025-07-24 17:50:46.989358
[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-07-24 17:50:47,150 - IOOppi_data - INFO : save diff data to db IOOppi_jd_g: date ... updated_at
39 2014-01-03 ... 2025-07-24 17:50:47.143161
458 2015-09-21 ... 2025-07-24 17:50:47.143161
549 2016-02-03 ... 2025-07-24 17:50:47.143161
693 2016-09-05 ... 2025-07-24 17:50:47.143161
696 2016-09-08 ... 2025-07-24 17:50:47.143161
[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-07-24 17:50:47,928 - IOOppi_data - INFO : save data to db IOOppi_SI_t data:
date value
931 2025-07-20 9500.0
932 2025-07-21 9620.0
933 2025-07-22 9840.0
934 2025-07-23 10080.0
935 2025-07-24 10180.0
2025-07-24 17:50:47,967 - IOOppi_data - INFO : save new data to db IOOppi_SI_t: date value ... created_at updated_at
935 2025-07-24 10180.0 ... 2025-07-24 17:50:47.959944 2025-07-24 17:50:47.960331
[1 rows x 5 columns]
2025-07-24 17:50:47,985 - IOOppi_data - INFO : save diff data to db: IOOppi_SI_t: no diff data
2025-07-24 17:50:47,991 - IOOppi_data - INFO : save data to db IOOppi_SI_g data:
date value
931 2025-07-20 9500.0
932 2025-07-21 9620.0
933 2025-07-22 9840.0
934 2025-07-23 10080.0
935 2025-07-24 10180.0
2025-07-24 17:50:48,031 - IOOppi_data - INFO : save new data to db IOOppi_SI_g: date value ... created_at updated_at
935 2025-07-24 10180.0 ... 2025-07-24 17:50:48.024417 2025-07-24 17:50:48.024828
[1 rows x 5 columns]
2025-07-24 17:50:48,050 - 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-07-24 17:50:48,873 - IOOppi_data - INFO : save data to db IOOppi_l_t data:
date value
3810 2025-07-20 7378.33
3811 2025-07-21 7383.33
3812 2025-07-22 7388.33
3813 2025-07-23 7405.00
3814 2025-07-24 7401.67
2025-07-24 17:50:48,945 - IOOppi_data - INFO : save new data to db IOOppi_l_t: date value ... created_at updated_at
3814 2025-07-24 7401.67 ... 2025-07-24 17:50:48.938639 2025-07-24 17:50:48.939044
[1 rows x 5 columns]
2025-07-24 17:50:48,965 - IOOppi_data - INFO : save diff data to db: IOOppi_l_t: no diff data
2025-07-24 17:50:48,971 - IOOppi_data - INFO : save data to db IOOppi_l_g data:
date value
3810 2025-07-20 7378.33
3811 2025-07-21 7383.33
3812 2025-07-22 7388.33
3813 2025-07-23 7405.00
3814 2025-07-24 7401.67
2025-07-24 17:50:49,044 - IOOppi_data - INFO : save new data to db IOOppi_l_g: date value ... created_at updated_at
3817 2025-07-24 7401.67 ... 2025-07-24 17:50:49.037340 2025-07-24 17:50:49.037726
[1 rows x 5 columns]
2025-07-24 17:50:49,064 - 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-07-24 17:50:49,820 - IOOppi_data - INFO : save data to db IOOppi_bu_t data:
date value
3148 2025-07-20 3710.00
3149 2025-07-21 3720.00
3150 2025-07-22 3723.33
3151 2025-07-23 3710.00
3152 2025-07-24 3700.00
2025-07-24 17:50:49,885 - IOOppi_data - INFO : save new data to db IOOppi_bu_t: date value ... created_at updated_at
3153 2025-07-24 3700.0 ... 2025-07-24 17:50:49.878273 2025-07-24 17:50:49.878656
[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-07-24 17:50:49,921 - IOOppi_data - INFO : save diff data to db IOOppi_bu_t: date ... updated_at
2560 2023-12-09 ... 2025-07-24 17:50:49.913613
[1 rows x 6 columns]
2025-07-24 17:50:49,944 - IOOppi_data - INFO : save data to db IOOppi_bu_g data:
date value
3148 2025-07-20 3710.00
3149 2025-07-21 3720.00
3150 2025-07-22 3723.33
3151 2025-07-23 3710.00
3152 2025-07-24 3700.00
2025-07-24 17:50:50,008 - IOOppi_data - INFO : save new data to db IOOppi_bu_g: date value ... created_at updated_at
3155 2025-07-24 3700.0 ... 2025-07-24 17:50:50.001683 2025-07-24 17:50:50.002097
[1 rows x 5 columns]
2025-07-24 17:50:50,027 - 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-07-24 17:50:50,668 - IOOppi_data - INFO : save data to db IOOppi_al_t data:
date value
3813 2025-07-20 20720.00
3814 2025-07-21 20720.00
3815 2025-07-22 20950.00
3816 2025-07-23 20950.00
3817 2025-07-24 20856.67
2025-07-24 17:50:50,740 - IOOppi_data - INFO : save new data to db IOOppi_al_t: date ... updated_at
3817 2025-07-24 ... 2025-07-24 17:50:50.734354
[1 rows x 5 columns]
2025-07-24 17:50:50,760 - IOOppi_data - INFO : save diff data to db: IOOppi_al_t: no diff data
2025-07-24 17:50:50,765 - IOOppi_data - INFO : save data to db IOOppi_al_g data:
date value
3813 2025-07-20 20720.00
3814 2025-07-21 20720.00
3815 2025-07-22 20950.00
3816 2025-07-23 20950.00
3817 2025-07-24 20856.67
2025-07-24 17:50:50,837 - IOOppi_data - INFO : save new data to db IOOppi_al_g: date ... updated_at
3820 2025-07-24 ... 2025-07-24 17:50:50.831648
[1 rows x 5 columns]
2025-07-24 17:50:50,856 - 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-07-24 17:50:51,497 - IOOppi_data - INFO : save data to db IOOppi_SM_t data:
date value
2927 2025-07-20 5652.0
2928 2025-07-21 5692.0
2929 2025-07-22 5726.0
2930 2025-07-23 5770.0
2931 2025-07-24 5710.0
2025-07-24 17:50:51,566 - IOOppi_data - INFO : save new data to db IOOppi_SM_t: date value ... created_at updated_at
2931 2025-07-24 5710.0 ... 2025-07-24 17:50:51.552954 2025-07-24 17:50:51.553367
[1 rows x 5 columns]
2025-07-24 17:50:51,586 - IOOppi_data - INFO : save diff data to db: IOOppi_SM_t: no diff data
2025-07-24 17:50:51,592 - IOOppi_data - INFO : save data to db IOOppi_SM_g data:
date value
2927 2025-07-20 5652.0
2928 2025-07-21 5692.0
2929 2025-07-22 5726.0
2930 2025-07-23 5770.0
2931 2025-07-24 5710.0
2025-07-24 17:50:51,656 - IOOppi_data - INFO : save new data to db IOOppi_SM_g: date value ... created_at updated_at
2935 2025-07-24 5710.0 ... 2025-07-24 17:50:51.649285 2025-07-24 17:50:51.649660
[1 rows x 5 columns]
2025-07-24 17:50:51,676 - 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-07-24 17:50:52,299 - IOOppi_data - INFO : save data to db IOOppi_CY_t data:
date value
2202 2025-07-20 23275.0
2203 2025-07-21 23275.0
2204 2025-07-22 23450.0
2205 2025-07-23 23450.0
2206 2025-07-24 23450.0
2025-07-24 17:50:52,364 - IOOppi_data - INFO : save new data to db IOOppi_CY_t: date value ... created_at updated_at
2206 2025-07-24 23450.0 ... 2025-07-24 17:50:52.351904 2025-07-24 17:50:52.352541
[1 rows x 5 columns]
2025-07-24 17:50:52,384 - IOOppi_data - INFO : save diff data to db: IOOppi_CY_t: no diff data
2025-07-24 17:50:52,389 - IOOppi_data - INFO : save data to db IOOppi_CY_g data:
date value
2202 2025-07-20 23275.0
2203 2025-07-21 23275.0
2204 2025-07-22 23450.0
2205 2025-07-23 23450.0
2206 2025-07-24 23450.0
2025-07-24 17:50:52,443 - IOOppi_data - INFO : save new data to db IOOppi_CY_g: date value ... created_at updated_at
2210 2025-07-24 23450.0 ... 2025-07-24 17:50:52.436388 2025-07-24 17:50:52.436786
[1 rows x 5 columns]
2025-07-24 17:50:52,463 - 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-07-24 17:50:53,064 - IOOppi_data - INFO : save data to db IOOppi_UR_t data:
date value
1717 2025-07-20 1830.0
1718 2025-07-21 1830.0
1719 2025-07-22 1830.0
1720 2025-07-23 1835.0
1721 2025-07-24 1832.5
2025-07-24 17:50:53,110 - IOOppi_data - INFO : save new data to db IOOppi_UR_t: date value ... created_at updated_at
1721 2025-07-24 1832.5 ... 2025-07-24 17:50:53.103945 2025-07-24 17:50:53.104326
[1 rows x 5 columns]
2025-07-24 17:50:53,130 - IOOppi_data - INFO : save diff data to db: IOOppi_UR_t: no diff data
2025-07-24 17:50:53,135 - IOOppi_data - INFO : save data to db IOOppi_UR_g data:
date value
1717 2025-07-20 1830.0
1718 2025-07-21 1830.0
1719 2025-07-22 1830.0
1720 2025-07-23 1835.0
1721 2025-07-24 1832.5
2025-07-24 17:50:53,186 - IOOppi_data - INFO : save new data to db IOOppi_UR_g: date value ... created_at updated_at
1725 2025-07-24 1832.5 ... 2025-07-24 17:50:53.178289 2025-07-24 17:50:53.178667
[1 rows x 5 columns]
2025-07-24 17:50:53,205 - 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-07-24 17:50:53,869 - IOOppi_data - INFO : save data to db IOOppi_ni_t data:
date value
2789 2025-07-20 121800.00
2790 2025-07-21 123350.00
2791 2025-07-22 123783.33
2792 2025-07-23 124416.67
2793 2025-07-24 125000.00
2025-07-24 17:50:53,929 - IOOppi_data - INFO : save new data to db IOOppi_ni_t: date ... updated_at
2793 2025-07-24 ... 2025-07-24 17:50:53.923105
[1 rows x 5 columns]
2025-07-24 17:50:53,948 - IOOppi_data - INFO : save diff data to db: IOOppi_ni_t: no diff data
2025-07-24 17:50:53,953 - IOOppi_data - INFO : save data to db IOOppi_ni_g data:
date value
2789 2025-07-20 121800.00
2790 2025-07-21 123350.00
2791 2025-07-22 123783.33
2792 2025-07-23 124416.67
2793 2025-07-24 125000.00
2025-07-24 17:50:54,012 - IOOppi_data - INFO : save new data to db IOOppi_ni_g: date ... updated_at
2796 2025-07-24 ... 2025-07-24 17:50:54.006410
[1 rows x 5 columns]
2025-07-24 17:50:54,030 - 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-07-24 17:50:54,631 - IOOppi_data - INFO : save data to db IOOppi_v_t data:
date value
3814 2025-07-20 4712.0
3815 2025-07-21 4837.0
3816 2025-07-22 4911.0
3817 2025-07-23 4907.0
3818 2025-07-24 4918.0
2025-07-24 17:50:54,708 - IOOppi_data - INFO : save new data to db IOOppi_v_t: date value ... created_at updated_at
3818 2025-07-24 4918.0 ... 2025-07-24 17:50:54.701790 2025-07-24 17:50:54.702189
[1 rows x 5 columns]
2025-07-24 17:50:54,727 - IOOppi_data - INFO : save diff data to db: IOOppi_v_t: no diff data
2025-07-24 17:50:54,733 - IOOppi_data - INFO : save data to db IOOppi_v_g data:
date value
3814 2025-07-20 4712.0
3815 2025-07-21 4837.0
3816 2025-07-22 4911.0
3817 2025-07-23 4907.0
3818 2025-07-24 4918.0
2025-07-24 17:50:54,806 - IOOppi_data - INFO : save new data to db IOOppi_v_g: date value ... created_at updated_at
3821 2025-07-24 4918.0 ... 2025-07-24 17:50:54.799843 2025-07-24 17:50:54.800233
[1 rows x 5 columns]
2025-07-24 17:50:54,825 - 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-07-24 17:50:55,501 - IOOppi_data - INFO : save data to db IOOppi_pp_t data:
date value
3053 2025-07-20 7313.33
3054 2025-07-21 7313.33
3055 2025-07-22 7291.67
3056 2025-07-23 7303.33
3057 2025-07-24 7295.00
2025-07-24 17:50:55,566 - IOOppi_data - INFO : save new data to db IOOppi_pp_t: date value ... created_at updated_at
3057 2025-07-24 7295.0 ... 2025-07-24 17:50:55.559363 2025-07-24 17:50:55.559772
[1 rows x 5 columns]
2025-07-24 17:50:55,586 - IOOppi_data - INFO : save diff data to db: IOOppi_pp_t: no diff data
2025-07-24 17:50:55,592 - IOOppi_data - INFO : save data to db IOOppi_pp_g data:
date value
3053 2025-07-20 7313.33
3054 2025-07-21 7313.33
3055 2025-07-22 7291.67
3056 2025-07-23 7303.33
3057 2025-07-24 7295.00
2025-07-24 17:50:55,655 - IOOppi_data - INFO : save new data to db IOOppi_pp_g: date value ... created_at updated_at
3060 2025-07-24 7295.0 ... 2025-07-24 17:50:55.648561 2025-07-24 17:50:55.648972
[1 rows x 5 columns]
2025-07-24 17:50:55,674 - 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-07-24 17:50:56,304 - IOOppi_data - INFO : save data to db IOOppi_CF_t data:
date value
3815 2025-07-20 15522.67
3816 2025-07-21 15596.33
3817 2025-07-22 15549.00
3818 2025-07-23 15551.33
3819 2025-07-24 15573.50
2025-07-24 17:50:56,392 - IOOppi_data - INFO : save new data to db IOOppi_CF_t: date value ... created_at updated_at
3819 2025-07-24 15573.5 ... 2025-07-24 17:50:56.385617 2025-07-24 17:50:56.386020
[1 rows x 5 columns]
2025-07-24 17:50:56,412 - IOOppi_data - INFO : save diff data to db: IOOppi_CF_t: no diff data
2025-07-24 17:50:56,418 - IOOppi_data - INFO : save data to db IOOppi_CF_g data:
date value
3815 2025-07-20 15522.67
3816 2025-07-21 15596.33
3817 2025-07-22 15549.00
3818 2025-07-23 15551.33
3819 2025-07-24 15573.50
2025-07-24 17:50:56,491 - IOOppi_data - INFO : save new data to db IOOppi_CF_g: date value ... created_at updated_at
3823 2025-07-24 15573.5 ... 2025-07-24 17:50:56.484070 2025-07-24 17:50:56.484445
[1 rows x 5 columns]
2025-07-24 17:50:56,510 - 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-07-24 17:50:57,136 - IOOppi_data - INFO : save data to db IOOppi_pb_t data:
date value
3760 2025-07-20 16756.25
3761 2025-07-21 16862.50
3762 2025-07-22 16806.25
3763 2025-07-23 16806.25
3764 2025-07-24 16768.75
2025-07-24 17:50:57,209 - IOOppi_data - INFO : save new data to db IOOppi_pb_t: date ... updated_at
3764 2025-07-24 ... 2025-07-24 17:50:57.202640
[1 rows x 5 columns]
2025-07-24 17:50:57,228 - IOOppi_data - INFO : save diff data to db: IOOppi_pb_t: no diff data
2025-07-24 17:50:57,234 - IOOppi_data - INFO : save data to db IOOppi_pb_g data:
date value
3760 2025-07-20 16756.25
3761 2025-07-21 16862.50
3762 2025-07-22 16806.25
3763 2025-07-23 16806.25
3764 2025-07-24 16768.75
2025-07-24 17:50:57,377 - IOOppi_data - INFO : save new data to db IOOppi_pb_g: date ... updated_at
3767 2025-07-24 ... 2025-07-24 17:50:57.371056
[1 rows x 5 columns]
2025-07-24 17:50:57,396 - 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-07-24 17:50:58,125 - IOOppi_data - INFO : save data to db IOOppi_hc_t data:
date value
3035 2025-07-20 3380.00
3036 2025-07-21 3406.67
3037 2025-07-22 3446.67
3038 2025-07-23 3470.00
3039 2025-07-24 3476.67
2025-07-24 17:50:58,189 - IOOppi_data - INFO : save new data to db IOOppi_hc_t: date value ... created_at updated_at
3039 2025-07-24 3476.67 ... 2025-07-24 17:50:58.182597 2025-07-24 17:50:58.183014
[1 rows x 5 columns]
2025-07-24 17:50:58,211 - IOOppi_data - INFO : save diff data to db: IOOppi_hc_t: no diff data
2025-07-24 17:50:58,217 - IOOppi_data - INFO : save data to db IOOppi_hc_g data:
date value
3035 2025-07-20 3380.00
3036 2025-07-21 3406.67
3037 2025-07-22 3446.67
3038 2025-07-23 3470.00
3039 2025-07-24 3476.67
2025-07-24 17:50:58,282 - IOOppi_data - INFO : save new data to db IOOppi_hc_g: date value ... created_at updated_at
3042 2025-07-24 3476.67 ... 2025-07-24 17:50:58.275679 2025-07-24 17:50:58.276099
[1 rows x 5 columns]
2025-07-24 17:50:58,301 - 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-07-24 17:50:58,861 - IOOppi_data - INFO : save data to db IOOppi_fu_t data:
date value
3315 2025-07-20 5325.0
3316 2025-07-21 5312.5
3317 2025-07-22 5312.5
3318 2025-07-23 5275.0
3319 2025-07-24 5275.0
2025-07-24 17:50:58,929 - IOOppi_data - INFO : save new data to db IOOppi_fu_t: date value ... created_at updated_at
3319 2025-07-24 5275.0 ... 2025-07-24 17:50:58.921615 2025-07-24 17:50:58.922032
[1 rows x 5 columns]
2025-07-24 17:50:58,951 - IOOppi_data - INFO : save diff data to db: IOOppi_fu_t: no diff data
2025-07-24 17:50:58,957 - IOOppi_data - INFO : save data to db IOOppi_fu_g data:
date value
3315 2025-07-20 5325.0
3316 2025-07-21 5312.5
3317 2025-07-22 5312.5
3318 2025-07-23 5275.0
3319 2025-07-24 5275.0
2025-07-24 17:50:59,030 - IOOppi_data - INFO : save new data to db IOOppi_fu_g: date value ... created_at updated_at
3806 2025-07-24 5275.0 ... 2025-07-24 17:50:59.023495 2025-07-24 17:50:59.023949
[1 rows x 5 columns]
2025-07-24 17:50:59,050 - 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-07-24 17:50:59,691 - IOOppi_data - INFO : save data to db IOOppi_lh_t data:
date value
1379 2025-07-20 14500.0
1380 2025-07-21 14480.0
1381 2025-07-22 14450.0
1382 2025-07-23 14420.0
1383 2025-07-24 14380.0
2025-07-24 17:50:59,734 - IOOppi_data - INFO : save new data to db IOOppi_lh_t: date value ... created_at updated_at
1383 2025-07-24 14380.0 ... 2025-07-24 17:50:59.727472 2025-07-24 17:50:59.727897
[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-07-24 17:50:59,972 - IOOppi_data - INFO : save diff data to db IOOppi_lh_t: date ... updated_at
116 2021-07-05 ... 2025-07-24 17:50:59.964383
117 2021-07-06 ... 2025-07-24 17:50:59.964383
121 2021-07-12 ... 2025-07-24 17:50:59.964383
122 2021-07-13 ... 2025-07-24 17:50:59.964383
194 2021-11-01 ... 2025-07-24 17:50:59.964383
[5 rows x 6 columns]
2025-07-24 17:51:00,009 - IOOppi_data - INFO : save data to db IOOppi_lh_g data:
date value
1379 2025-07-20 14500.0
1380 2025-07-21 14480.0
1381 2025-07-22 14450.0
1382 2025-07-23 14420.0
1383 2025-07-24 14380.0
2025-07-24 17:51:00,053 - IOOppi_data - INFO : save new data to db IOOppi_lh_g: date value ... created_at updated_at
1386 2025-07-24 14380.0 ... 2025-07-24 17:51:00.045633 2025-07-24 17:51:00.046056
[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-07-24 17:51:00,292 - IOOppi_data - INFO : save diff data to db IOOppi_lh_g: date ... updated_at
116 2021-07-05 ... 2025-07-24 17:51:00.284869
117 2021-07-06 ... 2025-07-24 17:51:00.284869
121 2021-07-12 ... 2025-07-24 17:51:00.284869
122 2021-07-13 ... 2025-07-24 17:51:00.284869
194 2021-11-01 ... 2025-07-24 17:51:00.284869
[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-07-24 17:51:01,005 - IOOppi_data - INFO : save data to db IOOppi_cu_t data:
date value
3811 2025-07-20 78678.33
3812 2025-07-21 79651.67
3813 2025-07-22 79766.67
3814 2025-07-23 79861.67
3815 2025-07-24 79820.00
2025-07-24 17:51:01,077 - IOOppi_data - INFO : save new data to db IOOppi_cu_t: date value ... created_at updated_at
3815 2025-07-24 79820.0 ... 2025-07-24 17:51:01.070682 2025-07-24 17:51:01.071102
[1 rows x 5 columns]
2025-07-24 17:51:01,096 - IOOppi_data - INFO : save diff data to db: IOOppi_cu_t: no diff data
2025-07-24 17:51:01,102 - IOOppi_data - INFO : save data to db IOOppi_cu_g data:
date value
3811 2025-07-20 78678.33
3812 2025-07-21 79651.67
3813 2025-07-22 79766.67
3814 2025-07-23 79861.67
3815 2025-07-24 79820.00
2025-07-24 17:51:01,174 - IOOppi_data - INFO : save new data to db IOOppi_cu_g: date value ... created_at updated_at
3818 2025-07-24 79820.0 ... 2025-07-24 17:51:01.167601 2025-07-24 17:51:01.168013
[1 rows x 5 columns]
2025-07-24 17:51:01,193 - 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-07-24 17:51:01,684 - 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-07-24 17:51:01,738 - IOOppi_data - INFO : save new data to db: IOOppi_PM_t: no new data
2025-07-24 17:51:01,738 - IOOppi_data - INFO : save diff data to db: IOOppi_PM_t: no diff data
2025-07-24 17:51:01,744 - 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-07-24 17:51:01,807 - IOOppi_data - INFO : save new data to db: IOOppi_PM_g: no new data
2025-07-24 17:51:01,807 - 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-07-24 17:51:02,482 - IOOppi_data - INFO : save data to db IOOppi_sn_t data:
date value
2789 2025-07-20 265575.0
2790 2025-07-21 267362.5
2791 2025-07-22 266600.0
2792 2025-07-23 269150.0
2793 2025-07-24 273025.0
2025-07-24 17:51:02,543 - IOOppi_data - INFO : save new data to db IOOppi_sn_t: date ... updated_at
2793 2025-07-24 ... 2025-07-24 17:51:02.536881
[1 rows x 5 columns]
2025-07-24 17:51:02,564 - IOOppi_data - INFO : save diff data to db: IOOppi_sn_t: no diff data
2025-07-24 17:51:02,571 - IOOppi_data - INFO : save data to db IOOppi_sn_g data:
date value
2789 2025-07-20 265575.0
2790 2025-07-21 267362.5
2791 2025-07-22 266600.0
2792 2025-07-23 269150.0
2793 2025-07-24 273025.0
2025-07-24 17:51:02,632 - IOOppi_data - INFO : save new data to db IOOppi_sn_g: date ... updated_at
2796 2025-07-24 ... 2025-07-24 17:51:02.626201
[1 rows x 5 columns]
2025-07-24 17:51:02,651 - 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-07-24 17:51:03,287 - IOOppi_data - INFO : save data to db IOOppi_zn_t data:
date value
3810 2025-07-20 22306.0
3811 2025-07-21 22814.0
3812 2025-07-22 22770.0
3813 2025-07-23 22818.0
3814 2025-07-24 22852.0
2025-07-24 17:51:03,362 - IOOppi_data - INFO : save new data to db IOOppi_zn_t: date value ... created_at updated_at
3814 2025-07-24 22852.0 ... 2025-07-24 17:51:03.354452 2025-07-24 17:51:03.354882
[1 rows x 5 columns]
2025-07-24 17:51:03,383 - IOOppi_data - INFO : save diff data to db: IOOppi_zn_t: no diff data
2025-07-24 17:51:03,389 - IOOppi_data - INFO : save data to db IOOppi_zn_g data:
date value
3810 2025-07-20 22306.0
3811 2025-07-21 22814.0
3812 2025-07-22 22770.0
3813 2025-07-23 22818.0
3814 2025-07-24 22852.0
2025-07-24 17:51:03,469 - IOOppi_data - INFO : save new data to db IOOppi_zn_g: date value ... created_at updated_at
3817 2025-07-24 22852.0 ... 2025-07-24 17:51:03.462235 2025-07-24 17:51:03.462620
[1 rows x 5 columns]
2025-07-24 17:51:03,488 - 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-07-24 17:51:04,091 - IOOppi_data - INFO : save data to db IOOppi_wr_t data:
date value
3773 2025-07-20 3372.5
3774 2025-07-21 3372.5
3775 2025-07-22 3497.5
3776 2025-07-23 3497.5
3777 2025-07-24 3497.5
2025-07-24 17:51:04,164 - IOOppi_data - INFO : save new data to db IOOppi_wr_t: date value ... created_at updated_at
3777 2025-07-24 3497.5 ... 2025-07-24 17:51:04.157828 2025-07-24 17:51:04.158231
[1 rows x 5 columns]
2025-07-24 17:51:04,184 - IOOppi_data - INFO : save diff data to db: IOOppi_wr_t: no diff data
2025-07-24 17:51:04,191 - IOOppi_data - INFO : save data to db IOOppi_wr_g data:
date value
3773 2025-07-20 3372.5
3774 2025-07-21 3372.5
3775 2025-07-22 3497.5
3776 2025-07-23 3497.5
3777 2025-07-24 3497.5
2025-07-24 17:51:04,275 - IOOppi_data - INFO : save new data to db IOOppi_wr_g: date value ... created_at updated_at
3780 2025-07-24 3497.5 ... 2025-07-24 17:51:04.266620 2025-07-24 17:51:04.267062
[1 rows x 5 columns]
2025-07-24 17:51:04,295 - 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-07-24 17:51:04,885 - IOOppi_data - INFO : save data to db IOOppi_pg_t data:
date value
1570 2025-07-20 4757.5
1571 2025-07-21 4807.5
1572 2025-07-22 4782.5
1573 2025-07-23 4770.0
1574 2025-07-24 4750.0
2025-07-24 17:51:04,930 - IOOppi_data - INFO : save new data to db IOOppi_pg_t: date value ... created_at updated_at
1574 2025-07-24 4750.0 ... 2025-07-24 17:51:04.922958 2025-07-24 17:51:04.923348
[1 rows x 5 columns]
2025-07-24 17:51:04,949 - IOOppi_data - INFO : save diff data to db: IOOppi_pg_t: no diff data
2025-07-24 17:51:04,955 - IOOppi_data - INFO : save data to db IOOppi_pg_g data:
date value
1570 2025-07-20 4757.5
1571 2025-07-21 4807.5
1572 2025-07-22 4782.5
1573 2025-07-23 4770.0
1574 2025-07-24 4750.0
2025-07-24 17:51:05,004 - IOOppi_data - INFO : save new data to db IOOppi_pg_g: date value ... created_at updated_at
1577 2025-07-24 4750.0 ... 2025-07-24 17:51:04.997390 2025-07-24 17:51:04.997792
[1 rows x 5 columns]
2025-07-24 17:51:05,023 - 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-07-24 17:51:05,753 - IOOppi_data - INFO : save data to db IOOppi_cs_t data:
date value
2844 2025-07-20 2330.00
2845 2025-07-21 2332.86
2846 2025-07-22 2338.57
2847 2025-07-23 2340.00
2848 2025-07-24 2340.00
2025-07-24 17:51:05,813 - IOOppi_data - INFO : save new data to db IOOppi_cs_t: date value ... created_at updated_at
2848 2025-07-24 2340.0 ... 2025-07-24 17:51:05.806682 2025-07-24 17:51:05.807102
[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-07-24 17:51:05,855 - IOOppi_data - INFO : save diff data to db IOOppi_cs_t: date ... updated_at
2847 2025-07-23 ... 2025-07-24 17:51:05.848106
[1 rows x 6 columns]
2025-07-24 17:51:05,879 - IOOppi_data - INFO : save data to db IOOppi_cs_g data:
date value
2844 2025-07-20 2330.00
2845 2025-07-21 2332.86
2846 2025-07-22 2338.57
2847 2025-07-23 2340.00
2848 2025-07-24 2340.00
2025-07-24 17:51:05,941 - IOOppi_data - INFO : save new data to db IOOppi_cs_g: date value ... created_at updated_at
2851 2025-07-24 2340.0 ... 2025-07-24 17:51:05.934112 2025-07-24 17:51:05.934493
[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-07-24 17:51:05,982 - IOOppi_data - INFO : save diff data to db IOOppi_cs_g: date ... updated_at
2850 2025-07-23 ... 2025-07-24 17:51:05.975128
[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-07-24 17:51:06,831 - IOOppi_data - INFO : save data to db IOOppi_cs_t data:
date value
2844 2025-07-20 2330.00
2845 2025-07-21 2332.86
2846 2025-07-22 2338.57
2847 2025-07-23 2340.00
2848 2025-07-24 2926.00
2025-07-24 17:51:06,884 - 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-07-24 17:51:06,907 - IOOppi_data - INFO : save diff data to db IOOppi_cs_t: date ... updated_at
2848 2025-07-24 ... 2025-07-24 17:51:06.899287
[1 rows x 6 columns]
2025-07-24 17:51:06,932 - IOOppi_data - INFO : save data to db IOOppi_cs_g data:
date value
2844 2025-07-20 2330.00
2845 2025-07-21 2332.86
2846 2025-07-22 2338.57
2847 2025-07-23 2340.00
2848 2025-07-24 2926.00
2025-07-24 17:51:06,986 - 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-07-24 17:51:07,008 - IOOppi_data - INFO : save diff data to db IOOppi_cs_g: date ... updated_at
2851 2025-07-24 ... 2025-07-24 17:51:07.001565
[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-07-24 17:51:07,553 - IOOppi_data - INFO : save data to db IOOppi_RS_t data:
date value
3201 2025-07-20 9691.67
3202 2025-07-21 9681.67
3203 2025-07-22 9586.67
3204 2025-07-23 9570.00
3205 2025-07-24 9590.00
2025-07-24 17:51:07,610 - IOOppi_data - INFO : save new data to db: IOOppi_RS_t: no new data
2025-07-24 17:51:07,610 - IOOppi_data - INFO : save diff data to db: IOOppi_RS_t: no diff data
2025-07-24 17:51:07,615 - IOOppi_data - INFO : save data to db IOOppi_RS_g data:
date value
3201 2025-07-20 9691.67
3202 2025-07-21 9681.67
3203 2025-07-22 9586.67
3204 2025-07-23 9570.00
3205 2025-07-24 9590.00
2025-07-24 17:51:07,674 - IOOppi_data - INFO : save new data to db: IOOppi_RS_g: no new data
2025-07-24 17:51:07,674 - 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-07-24 17:51:08,269 - IOOppi_data - INFO : save data to db IOOppi_eg_t data:
date value
1885 2025-07-20 4415.00
1886 2025-07-21 4431.67
1887 2025-07-22 4436.67
1888 2025-07-23 4436.67
1889 2025-07-24 4443.33
2025-07-24 17:51:08,318 - IOOppi_data - INFO : save new data to db IOOppi_eg_t: date value ... created_at updated_at
1889 2025-07-24 4443.33 ... 2025-07-24 17:51:08.311237 2025-07-24 17:51:08.311644
[1 rows x 5 columns]
2025-07-24 17:51:08,337 - IOOppi_data - INFO : save diff data to db: IOOppi_eg_t: no diff data
2025-07-24 17:51:08,343 - IOOppi_data - INFO : save data to db IOOppi_eg_g data:
date value
1885 2025-07-20 4415.00
1886 2025-07-21 4431.67
1887 2025-07-22 4436.67
1888 2025-07-23 4436.67
1889 2025-07-24 4443.33
2025-07-24 17:51:08,391 - IOOppi_data - INFO : save new data to db IOOppi_eg_g: date value ... created_at updated_at
1892 2025-07-24 4443.33 ... 2025-07-24 17:51:08.384827 2025-07-24 17:51:08.385228
[1 rows x 5 columns]
2025-07-24 17:51:08,410 - 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-07-24 17:51:09,212 - IOOppi_data - INFO : save data to db IOOppi_sp_t data:
date value
1894 2025-07-20 5933.33
1895 2025-07-21 5950.00
1896 2025-07-22 5923.33
1897 2025-07-23 5950.00
1898 2025-07-24 5966.67
2025-07-24 17:51:09,261 - IOOppi_data - INFO : save new data to db IOOppi_sp_t: date value ... created_at updated_at
1898 2025-07-24 5966.67 ... 2025-07-24 17:51:09.253975 2025-07-24 17:51:09.254362
[1 rows x 5 columns]
2025-07-24 17:51:09,280 - IOOppi_data - INFO : save diff data to db: IOOppi_sp_t: no diff data
2025-07-24 17:51:09,285 - IOOppi_data - INFO : save data to db IOOppi_sp_g data:
date value
1894 2025-07-20 5933.33
1895 2025-07-21 5950.00
1896 2025-07-22 5923.33
1897 2025-07-23 5950.00
1898 2025-07-24 5966.67
2025-07-24 17:51:09,336 - IOOppi_data - INFO : save new data to db IOOppi_sp_g: date value ... created_at updated_at
1901 2025-07-24 5966.67 ... 2025-07-24 17:51:09.329334 2025-07-24 17:51:09.329777
[1 rows x 5 columns]
2025-07-24 17:51:09,354 - 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-07-24 17:51:10,007 - IOOppi_data - INFO : save data to db IOOppi_p_t data:
date value
3562 2025-07-20 9048.0
3563 2025-07-21 9046.0
3564 2025-07-22 8994.0
3565 2025-07-23 9048.0
3566 2025-07-24 9172.0
2025-07-24 17:51:10,082 - IOOppi_data - INFO : save new data to db IOOppi_p_t: date value ... created_at updated_at
3566 2025-07-24 9172.0 ... 2025-07-24 17:51:10.074797 2025-07-24 17:51:10.075195
[1 rows x 5 columns]
2025-07-24 17:51:10,102 - IOOppi_data - INFO : save diff data to db: IOOppi_p_t: no diff data
2025-07-24 17:51:10,108 - IOOppi_data - INFO : save data to db IOOppi_p_g data:
date value
3562 2025-07-20 9048.0
3563 2025-07-21 9046.0
3564 2025-07-22 8994.0
3565 2025-07-23 9048.0
3566 2025-07-24 9172.0
2025-07-24 17:51:10,177 - IOOppi_data - INFO : save new data to db IOOppi_p_g: date value ... created_at updated_at
3569 2025-07-24 9172.0 ... 2025-07-24 17:51:10.170922 2025-07-24 17:51:10.171305
[1 rows x 5 columns]
2025-07-24 17:51:10,196 - IOOppi_data - INFO : save diff data to db: IOOppi_p_g: no diff data