=========================================================================
2025-05-20 17:50:26 Tue START TASK.01 IOOppi_data update_data
=========================================================================
/usr/local/lib/python3.10/site-packages/urllib3/connectionpool.py:1056: InsecureRequestWarning: Unverified HTTPS request is being made to host 'www.100ppi.com'. Adding certificate verification is strongly advised. See: https://urllib3.readthedocs.io/en/1.26.x/advanced-usage.html#ssl-warnings
warnings.warn(
2025-05-20 17:50:28,831 - IOOppi_data - INFO : save data to db IOOppi_rb_t data:
date value
3305 2025-05-16 3184.22
3306 2025-05-17 3184.22
3307 2025-05-18 3184.22
3308 2025-05-19 3158.22
3309 2025-05-20 3158.78
2025-05-20 17:50:28,900 - IOOppi_data - INFO : save new data to db IOOppi_rb_t: date value ... created_at updated_at
3309 2025-05-20 3158.78 ... 2025-05-20 17:50:28.892651 2025-05-20 17:50:28.893078
[1 rows x 5 columns]
2025-05-20 17:50:28,921 - IOOppi_data - INFO : save diff data to db: IOOppi_rb_t: no diff data
2025-05-20 17:50:28,926 - IOOppi_data - INFO : save data to db IOOppi_rb_g data:
date value
3305 2025-05-16 3184.22
3306 2025-05-17 3184.22
3307 2025-05-18 3184.22
3308 2025-05-19 3158.22
3309 2025-05-20 3158.78
2025-05-20 17:50:28,991 - IOOppi_data - INFO : save new data to db IOOppi_rb_g: date value ... created_at updated_at
3312 2025-05-20 3158.78 ... 2025-05-20 17:50:28.984477 2025-05-20 17:50:28.984871
[1 rows x 5 columns]
2025-05-20 17:50:29,009 - 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-05-20 17:50:29,533 - IOOppi_data - INFO : save data to db IOOppi_MA_t data:
date value
3526 2025-05-16 2426.25
3527 2025-05-17 2426.25
3528 2025-05-18 2426.25
3529 2025-05-19 2362.50
3530 2025-05-20 2327.50
2025-05-20 17:50:29,601 - IOOppi_data - INFO : save new data to db IOOppi_MA_t: date value ... created_at updated_at
3530 2025-05-20 2327.5 ... 2025-05-20 17:50:29.593854 2025-05-20 17:50:29.594237
[1 rows x 5 columns]
2025-05-20 17:50:29,619 - IOOppi_data - INFO : save diff data to db: IOOppi_MA_t: no diff data
2025-05-20 17:50:29,624 - IOOppi_data - INFO : save data to db IOOppi_MA_g data:
date value
3526 2025-05-16 2426.25
3527 2025-05-17 2426.25
3528 2025-05-18 2426.25
3529 2025-05-19 2362.50
3530 2025-05-20 2327.50
2025-05-20 17:50:29,695 - IOOppi_data - INFO : save new data to db IOOppi_MA_g: date value ... created_at updated_at
3534 2025-05-20 2327.5 ... 2025-05-20 17:50:29.688090 2025-05-20 17:50:29.688476
[1 rows x 5 columns]
2025-05-20 17:50:29,714 - 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-05-20 17:50:30,280 - IOOppi_data - INFO : save data to db IOOppi_PTA_t data:
date value
866 2025-05-16 5007.50
867 2025-05-17 5007.50
868 2025-05-18 5007.50
869 2025-05-19 4993.75
870 2025-05-20 5001.25
2025-05-20 17:50:30,315 - IOOppi_data - INFO : save new data to db IOOppi_PTA_t: date value ... created_at updated_at
870 2025-05-20 5001.25 ... 2025-05-20 17:50:30.308230 2025-05-20 17:50:30.308616
[1 rows x 5 columns]
2025-05-20 17:50:30,333 - IOOppi_data - INFO : save diff data to db: IOOppi_PTA_t: no diff data
2025-05-20 17:50:30,338 - IOOppi_data - INFO : save data to db IOOppi_PTA_g data:
date value
866 2025-05-16 5007.50
867 2025-05-17 5007.50
868 2025-05-18 5007.50
869 2025-05-19 4993.75
870 2025-05-20 5001.25
2025-05-20 17:50:30,372 - IOOppi_data - INFO : save new data to db IOOppi_PTA_g: date value ... created_at updated_at
870 2025-05-20 5001.25 ... 2025-05-20 17:50:30.365610 2025-05-20 17:50:30.365990
[1 rows x 5 columns]
2025-05-20 17:50:30,391 - 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-05-20 17:50:31,042 - IOOppi_data - INFO : save data to db IOOppi_ru_t data:
date value
3745 2025-05-16 14658.33
3746 2025-05-17 14658.33
3747 2025-05-18 14658.33
3748 2025-05-19 14758.33
3749 2025-05-20 14708.33
2025-05-20 17:50:31,114 - IOOppi_data - INFO : save new data to db IOOppi_ru_t: date ... updated_at
3749 2025-05-20 ... 2025-05-20 17:50:31.106254
[1 rows x 5 columns]
2025-05-20 17:50:31,134 - IOOppi_data - INFO : save diff data to db: IOOppi_ru_t: no diff data
2025-05-20 17:50:31,140 - IOOppi_data - INFO : save data to db IOOppi_ru_g data:
date value
3745 2025-05-16 14658.33
3746 2025-05-17 14658.33
3747 2025-05-18 14658.33
3748 2025-05-19 14758.33
3749 2025-05-20 14708.33
2025-05-20 17:50:31,210 - IOOppi_data - INFO : save new data to db IOOppi_ru_g: date ... updated_at
3752 2025-05-20 ... 2025-05-20 17:50:31.204195
[1 rows x 5 columns]
2025-05-20 17:50:31,228 - 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-05-20 17:50:31,732 - IOOppi_data - INFO : save data to db IOOppi_i_t data:
date value
3077 2025-05-16 787.33
3078 2025-05-17 784.44
3079 2025-05-18 784.44
3080 2025-05-19 779.44
3081 2025-05-20 779.78
2025-05-20 17:50:31,796 - IOOppi_data - INFO : save new data to db IOOppi_i_t: date value ... created_at updated_at
3081 2025-05-20 779.78 ... 2025-05-20 17:50:31.789280 2025-05-20 17:50:31.789702
[1 rows x 5 columns]
2025-05-20 17:50:31,814 - IOOppi_data - INFO : save diff data to db: IOOppi_i_t: no diff data
2025-05-20 17:50:31,820 - IOOppi_data - INFO : save data to db IOOppi_i_g data:
date value
3077 2025-05-16 787.33
3078 2025-05-17 784.44
3079 2025-05-18 784.44
3080 2025-05-19 779.44
3081 2025-05-20 779.78
2025-05-20 17:50:31,884 - IOOppi_data - INFO : save new data to db IOOppi_i_g: date value ... created_at updated_at
3084 2025-05-20 779.78 ... 2025-05-20 17:50:31.876777 2025-05-20 17:50:31.877171
[1 rows x 5 columns]
2025-05-20 17:50:31,903 - 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-05-20 17:50:32,413 - IOOppi_data - INFO : save data to db IOOppi_FG_t data:
date value
3280 2025-05-16 1168.0
3281 2025-05-17 1168.0
3282 2025-05-18 1168.0
3283 2025-05-19 1168.0
3284 2025-05-20 1164.0
2025-05-20 17:50:32,477 - IOOppi_data - INFO : save new data to db IOOppi_FG_t: date value ... created_at updated_at
3284 2025-05-20 1164.0 ... 2025-05-20 17:50:32.470270 2025-05-20 17:50:32.470644
[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-05-20 17:50:34,344 - IOOppi_data - INFO : save diff data to db IOOppi_FG_t: date ... updated_at
12 2012-12-19 ... 2025-05-20 17:50:34.336639
21 2013-01-04 ... 2025-05-20 17:50:34.336639
54 2013-02-27 ... 2025-05-20 17:50:34.336639
60 2013-03-07 ... 2025-05-20 17:50:34.336639
61 2013-03-08 ... 2025-05-20 17:50:34.336639
[5 rows x 6 columns]
2025-05-20 17:50:34,505 - IOOppi_data - INFO : save data to db IOOppi_FG_g data:
date value
3280 2025-05-16 1168.0
3281 2025-05-17 1168.0
3282 2025-05-18 1168.0
3283 2025-05-19 1168.0
3284 2025-05-20 1164.0
2025-05-20 17:50:34,570 - IOOppi_data - INFO : save new data to db IOOppi_FG_g: date value ... created_at updated_at
3288 2025-05-20 1164.0 ... 2025-05-20 17:50:34.563341 2025-05-20 17:50:34.563727
[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-05-20 17:50:36,428 - IOOppi_data - INFO : save diff data to db IOOppi_FG_g: date ... updated_at
12 2012-12-19 ... 2025-05-20 17:50:36.420705
21 2013-01-04 ... 2025-05-20 17:50:36.420705
54 2013-02-27 ... 2025-05-20 17:50:36.420705
60 2013-03-07 ... 2025-05-20 17:50:36.420705
61 2013-03-08 ... 2025-05-20 17:50:36.420705
[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-05-20 17:50:37,093 - IOOppi_data - INFO : save data to db IOOppi_eb_t data:
date value
1625 2025-05-16 8270.0
1626 2025-05-17 8270.0
1627 2025-05-18 8270.0
1628 2025-05-19 8224.0
1629 2025-05-20 8220.0
2025-05-20 17:50:37,137 - IOOppi_data - INFO : save new data to db IOOppi_eb_t: date value ... created_at updated_at
1629 2025-05-20 8220.0 ... 2025-05-20 17:50:37.130726 2025-05-20 17:50:37.131152
[1 rows x 5 columns]
2025-05-20 17:50:37,156 - IOOppi_data - INFO : save diff data to db: IOOppi_eb_t: no diff data
2025-05-20 17:50:37,161 - IOOppi_data - INFO : save data to db IOOppi_eb_g data:
date value
1625 2025-05-16 8270.0
1626 2025-05-17 8270.0
1627 2025-05-18 8270.0
1628 2025-05-19 8224.0
1629 2025-05-20 8220.0
2025-05-20 17:50:37,205 - IOOppi_data - INFO : save new data to db IOOppi_eb_g: date value ... created_at updated_at
1632 2025-05-20 8220.0 ... 2025-05-20 17:50:37.198534 2025-05-20 17:50:37.198915
[1 rows x 5 columns]
2025-05-20 17:50:37,224 - 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-05-20 17:50:37,741 - IOOppi_data - INFO : save data to db IOOppi_SR_t data:
date value
3736 2025-05-16 6145.0
3737 2025-05-17 6145.0
3738 2025-05-18 6145.0
3739 2025-05-19 6145.0
3740 2025-05-20 6145.0
2025-05-20 17:50:37,810 - IOOppi_data - INFO : save new data to db IOOppi_SR_t: date value ... created_at updated_at
3740 2025-05-20 6145.0 ... 2025-05-20 17:50:37.803247 2025-05-20 17:50:37.803625
[1 rows x 5 columns]
2025-05-20 17:50:37,828 - IOOppi_data - INFO : save diff data to db: IOOppi_SR_t: no diff data
2025-05-20 17:50:37,834 - IOOppi_data - INFO : save data to db IOOppi_SR_g data:
date value
3736 2025-05-16 6145.0
3737 2025-05-17 6145.0
3738 2025-05-18 6145.0
3739 2025-05-19 6145.0
3740 2025-05-20 6145.0
2025-05-20 17:50:37,903 - IOOppi_data - INFO : save new data to db IOOppi_SR_g: date value ... created_at updated_at
3744 2025-05-20 6145.0 ... 2025-05-20 17:50:37.896847 2025-05-20 17:50:37.897226
[1 rows x 5 columns]
2025-05-20 17:50:37,922 - 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-05-20 17:50:38,422 - IOOppi_data - INFO : save data to db IOOppi_ss_t data:
date value
1626 2025-05-16 13300.0
1627 2025-05-17 13300.0
1628 2025-05-18 13300.0
1629 2025-05-19 13287.5
1630 2025-05-20 13287.5
2025-05-20 17:50:38,467 - IOOppi_data - INFO : save new data to db IOOppi_ss_t: date value ... created_at updated_at
1630 2025-05-20 13287.5 ... 2025-05-20 17:50:38.460593 2025-05-20 17:50:38.461012
[1 rows x 5 columns]
2025-05-20 17:50:38,488 - IOOppi_data - INFO : save diff data to db: IOOppi_ss_t: no diff data
2025-05-20 17:50:38,493 - IOOppi_data - INFO : save data to db IOOppi_ss_g data:
date value
1626 2025-05-16 13300.0
1627 2025-05-17 13300.0
1628 2025-05-18 13300.0
1629 2025-05-19 13287.5
1630 2025-05-20 13287.5
2025-05-20 17:50:38,539 - IOOppi_data - INFO : save new data to db IOOppi_ss_g: date value ... created_at updated_at
1633 2025-05-20 13287.5 ... 2025-05-20 17:50:38.532418 2025-05-20 17:50:38.532824
[1 rows x 5 columns]
2025-05-20 17:50:38,558 - 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-05-20 17:50:39,106 - IOOppi_data - INFO : save data to db IOOppi_RS_t data:
date value
3136 2025-05-16 9378.33
3137 2025-05-17 9378.33
3138 2025-05-18 9378.33
3139 2025-05-19 9475.00
3140 2025-05-20 9520.00
2025-05-20 17:50:39,169 - IOOppi_data - INFO : save new data to db IOOppi_RS_t: date value ... created_at updated_at
3140 2025-05-20 9520.0 ... 2025-05-20 17:50:39.162559 2025-05-20 17:50:39.162970
[1 rows x 5 columns]
2025-05-20 17:50:39,188 - IOOppi_data - INFO : save diff data to db: IOOppi_RS_t: no diff data
2025-05-20 17:50:39,194 - IOOppi_data - INFO : save data to db IOOppi_RS_g data:
date value
3136 2025-05-16 9378.33
3137 2025-05-17 9378.33
3138 2025-05-18 9378.33
3139 2025-05-19 9475.00
3140 2025-05-20 9520.00
2025-05-20 17:50:39,258 - IOOppi_data - INFO : save new data to db IOOppi_RS_g: date value ... created_at updated_at
3144 2025-05-20 9520.0 ... 2025-05-20 17:50:39.251001 2025-05-20 17:50:39.251374
[1 rows x 5 columns]
2025-05-20 17:50:39,276 - 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-05-20 17:50:39,816 - IOOppi_data - INFO : save data to db IOOppi_RM_t data:
date value
3259 2025-05-16 2476.67
3260 2025-05-17 2476.67
3261 2025-05-18 2476.67
3262 2025-05-19 2471.67
3263 2025-05-20 2475.00
2025-05-20 17:50:39,881 - IOOppi_data - INFO : save new data to db IOOppi_RM_t: date value ... created_at updated_at
3263 2025-05-20 2475.0 ... 2025-05-20 17:50:39.873868 2025-05-20 17:50:39.874259
[1 rows x 5 columns]
2025-05-20 17:50:39,899 - IOOppi_data - INFO : save diff data to db: IOOppi_RM_t: no diff data
2025-05-20 17:50:39,904 - IOOppi_data - INFO : save data to db IOOppi_RM_g data:
date value
3259 2025-05-16 2476.67
3260 2025-05-17 2476.67
3261 2025-05-18 2476.67
3262 2025-05-19 2471.67
3263 2025-05-20 2475.00
2025-05-20 17:50:39,970 - IOOppi_data - INFO : save new data to db IOOppi_RM_g: date value ... created_at updated_at
3267 2025-05-20 2475.0 ... 2025-05-20 17:50:39.962966 2025-05-20 17:50:39.963355
[1 rows x 5 columns]
2025-05-20 17:50:39,988 - 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-05-20 17:50:40,449 - IOOppi_data - INFO : save data to db IOOppi_SA_t data:
date value
1463 2025-05-16 1462.5
1464 2025-05-17 1462.5
1465 2025-05-18 1462.5
1466 2025-05-19 1462.5
1467 2025-05-20 1462.5
2025-05-20 17:50:40,491 - IOOppi_data - INFO : save new data to db IOOppi_SA_t: date value ... created_at updated_at
1467 2025-05-20 1462.5 ... 2025-05-20 17:50:40.484629 2025-05-20 17:50:40.485058
[1 rows x 5 columns]
2025-05-20 17:50:40,510 - IOOppi_data - INFO : save diff data to db: IOOppi_SA_t: no diff data
2025-05-20 17:50:40,515 - IOOppi_data - INFO : save data to db IOOppi_SA_g data:
date value
1463 2025-05-16 1462.5
1464 2025-05-17 1462.5
1465 2025-05-18 1462.5
1466 2025-05-19 1462.5
1467 2025-05-20 1462.5
2025-05-20 17:50:40,560 - IOOppi_data - INFO : save new data to db IOOppi_SA_g: date value ... created_at updated_at
1471 2025-05-20 1462.5 ... 2025-05-20 17:50:40.553669 2025-05-20 17:50:40.554066
[1 rows x 5 columns]
2025-05-20 17:50:40,579 - 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-05-20 17:50:41,348 - IOOppi_data - INFO : save data to db IOOppi_PF_t data:
date value
1376 2025-05-16 6727.50
1377 2025-05-17 6727.50
1378 2025-05-18 6727.50
1379 2025-05-19 6701.04
1380 2025-05-20 6687.71
2025-05-20 17:50:41,390 - IOOppi_data - INFO : save new data to db IOOppi_PF_t: date value ... created_at updated_at
1380 2025-05-20 6687.71 ... 2025-05-20 17:50:41.382688 2025-05-20 17:50:41.383102
[1 rows x 5 columns]
2025-05-20 17:50:41,408 - IOOppi_data - INFO : save diff data to db: IOOppi_PF_t: no diff data
2025-05-20 17:50:41,413 - IOOppi_data - INFO : save data to db IOOppi_PF_g data:
date value
1376 2025-05-16 6727.50
1377 2025-05-17 6727.50
1378 2025-05-18 6727.50
1379 2025-05-19 6701.04
1380 2025-05-20 6687.71
2025-05-20 17:50:41,454 - IOOppi_data - INFO : save new data to db IOOppi_PF_g: date value ... created_at updated_at
1384 2025-05-20 6687.71 ... 2025-05-20 17:50:41.448009 2025-05-20 17:50:41.448379
[1 rows x 5 columns]
2025-05-20 17:50:41,472 - 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-05-20 17:50:41,985 - IOOppi_data - INFO : save data to db IOOppi_m_t data:
date value
3749 2025-05-16 2988.0
3750 2025-05-17 2988.0
3751 2025-05-18 2988.0
3752 2025-05-19 2972.0
3753 2025-05-20 2966.0
2025-05-20 17:50:42,058 - IOOppi_data - INFO : save new data to db IOOppi_m_t: date value ... created_at updated_at
3753 2025-05-20 2966.0 ... 2025-05-20 17:50:42.051546 2025-05-20 17:50:42.051956
[1 rows x 5 columns]
2025-05-20 17:50:42,077 - IOOppi_data - INFO : save diff data to db: IOOppi_m_t: no diff data
2025-05-20 17:50:42,082 - IOOppi_data - INFO : save data to db IOOppi_m_g data:
date value
3749 2025-05-16 2988.0
3750 2025-05-17 2988.0
3751 2025-05-18 2988.0
3752 2025-05-19 2972.0
3753 2025-05-20 2966.0
2025-05-20 17:50:42,153 - IOOppi_data - INFO : save new data to db IOOppi_m_g: date value ... created_at updated_at
3756 2025-05-20 2966.0 ... 2025-05-20 17:50:42.146651 2025-05-20 17:50:42.147059
[1 rows x 5 columns]
2025-05-20 17:50:42,172 - 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-05-20 17:50:42,720 - IOOppi_data - INFO : save data to db IOOppi_y_t data:
date value
3519 2025-05-16 8024.0
3520 2025-05-17 8024.0
3521 2025-05-18 8024.0
3522 2025-05-19 8044.0
3523 2025-05-20 8074.0
2025-05-20 17:50:42,789 - IOOppi_data - INFO : save new data to db IOOppi_y_t: date value ... created_at updated_at
3523 2025-05-20 8074.0 ... 2025-05-20 17:50:42.782193 2025-05-20 17:50:42.782575
[1 rows x 5 columns]
2025-05-20 17:50:42,807 - IOOppi_data - INFO : save diff data to db: IOOppi_y_t: no diff data
2025-05-20 17:50:42,813 - IOOppi_data - INFO : save data to db IOOppi_y_g data:
date value
3519 2025-05-16 8024.0
3520 2025-05-17 8024.0
3521 2025-05-18 8024.0
3522 2025-05-19 8044.0
3523 2025-05-20 8074.0
2025-05-20 17:50:42,881 - IOOppi_data - INFO : save new data to db IOOppi_y_g: date value ... created_at updated_at
3526 2025-05-20 8074.0 ... 2025-05-20 17:50:42.873958 2025-05-20 17:50:42.874362
[1 rows x 5 columns]
2025-05-20 17:50:42,899 - 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-05-20 17:50:43,429 - IOOppi_data - INFO : save data to db IOOppi_a_t data:
date value
3485 2025-05-16 4255.0
3486 2025-05-17 4255.0
3487 2025-05-18 4255.0
3488 2025-05-19 4255.0
3489 2025-05-20 4255.0
2025-05-20 17:50:43,497 - IOOppi_data - INFO : save new data to db IOOppi_a_t: date value ... created_at updated_at
3489 2025-05-20 4255.0 ... 2025-05-20 17:50:43.490172 2025-05-20 17:50:43.490557
[1 rows x 5 columns]
2025-05-20 17:50:43,516 - IOOppi_data - INFO : save diff data to db: IOOppi_a_t: no diff data
2025-05-20 17:50:43,521 - IOOppi_data - INFO : save data to db IOOppi_a_g data:
date value
3485 2025-05-16 4255.0
3486 2025-05-17 4255.0
3487 2025-05-18 4255.0
3488 2025-05-19 4255.0
3489 2025-05-20 4255.0
2025-05-20 17:50:43,589 - IOOppi_data - INFO : save new data to db IOOppi_a_g: date value ... created_at updated_at
3492 2025-05-20 4255.0 ... 2025-05-20 17:50:43.582324 2025-05-20 17:50:43.582694
[1 rows x 5 columns]
2025-05-20 17:50:43,607 - 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-05-20 17:50:44,134 - IOOppi_data - INFO : save data to db IOOppi_SF_t data:
date value
2862 2025-05-16 5440.00
2863 2025-05-17 5440.00
2864 2025-05-18 5440.00
2865 2025-05-19 5435.71
2866 2025-05-20 5435.71
2025-05-20 17:50:44,194 - IOOppi_data - INFO : save new data to db IOOppi_SF_t: date value ... created_at updated_at
2866 2025-05-20 5435.71 ... 2025-05-20 17:50:44.187607 2025-05-20 17:50:44.188015
[1 rows x 5 columns]
2025-05-20 17:50:44,213 - IOOppi_data - INFO : save diff data to db: IOOppi_SF_t: no diff data
2025-05-20 17:50:44,218 - IOOppi_data - INFO : save data to db IOOppi_SF_g data:
date value
2862 2025-05-16 5440.00
2863 2025-05-17 5440.00
2864 2025-05-18 5440.00
2865 2025-05-19 5435.71
2866 2025-05-20 5435.71
2025-05-20 17:50:44,279 - IOOppi_data - INFO : save new data to db IOOppi_SF_g: date value ... created_at updated_at
2870 2025-05-20 5435.71 ... 2025-05-20 17:50:44.272255 2025-05-20 17:50:44.272625
[1 rows x 5 columns]
2025-05-20 17:50:44,297 - 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-05-20 17:50:44,794 - IOOppi_data - INFO : save data to db IOOppi_jd_t data:
date value
3062 2025-05-16 3375.0
3063 2025-05-17 3375.0
3064 2025-05-18 3375.0
3065 2025-05-19 3290.0
3066 2025-05-20 3190.0
2025-05-20 17:50:44,856 - IOOppi_data - INFO : save new data to db IOOppi_jd_t: date value ... created_at updated_at
3066 2025-05-20 3190.0 ... 2025-05-20 17:50:44.849017 2025-05-20 17:50:44.849400
[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-05-20 17:50:44,997 - IOOppi_data - INFO : save diff data to db IOOppi_jd_t: date ... updated_at
39 2014-01-03 ... 2025-05-20 17:50:44.989602
458 2015-09-21 ... 2025-05-20 17:50:44.989602
549 2016-02-03 ... 2025-05-20 17:50:44.989602
693 2016-09-05 ... 2025-05-20 17:50:44.989602
696 2016-09-08 ... 2025-05-20 17:50:44.989602
[5 rows x 6 columns]
2025-05-20 17:50:45,026 - IOOppi_data - INFO : save data to db IOOppi_jd_g data:
date value
3062 2025-05-16 3375.0
3063 2025-05-17 3375.0
3064 2025-05-18 3375.0
3065 2025-05-19 3290.0
3066 2025-05-20 3190.0
2025-05-20 17:50:45,088 - IOOppi_data - INFO : save new data to db IOOppi_jd_g: date value ... created_at updated_at
3069 2025-05-20 3190.0 ... 2025-05-20 17:50:45.081197 2025-05-20 17:50:45.081568
[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-05-20 17:50:45,227 - IOOppi_data - INFO : save diff data to db IOOppi_jd_g: date ... updated_at
39 2014-01-03 ... 2025-05-20 17:50:45.220356
458 2015-09-21 ... 2025-05-20 17:50:45.220356
549 2016-02-03 ... 2025-05-20 17:50:45.220356
693 2016-09-05 ... 2025-05-20 17:50:45.220356
696 2016-09-08 ... 2025-05-20 17:50:45.220356
[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-05-20 17:50:45,792 - IOOppi_data - INFO : save data to db IOOppi_SI_t data:
date value
866 2025-05-16 9480.0
867 2025-05-17 9480.0
868 2025-05-18 9480.0
869 2025-05-19 9390.0
870 2025-05-20 9290.0
2025-05-20 17:50:45,827 - IOOppi_data - INFO : save new data to db IOOppi_SI_t: date value ... created_at updated_at
870 2025-05-20 9290.0 ... 2025-05-20 17:50:45.820301 2025-05-20 17:50:45.820680
[1 rows x 5 columns]
2025-05-20 17:50:45,845 - IOOppi_data - INFO : save diff data to db: IOOppi_SI_t: no diff data
2025-05-20 17:50:45,850 - IOOppi_data - INFO : save data to db IOOppi_SI_g data:
date value
866 2025-05-16 9480.0
867 2025-05-17 9480.0
868 2025-05-18 9480.0
869 2025-05-19 9390.0
870 2025-05-20 9290.0
2025-05-20 17:50:45,885 - IOOppi_data - INFO : save new data to db IOOppi_SI_g: date value ... created_at updated_at
870 2025-05-20 9290.0 ... 2025-05-20 17:50:45.878029 2025-05-20 17:50:45.878401
[1 rows x 5 columns]
2025-05-20 17:50:45,904 - 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-05-20 17:50:46,462 - IOOppi_data - INFO : save data to db IOOppi_l_t data:
date value
3745 2025-05-16 7566.67
3746 2025-05-17 7566.67
3747 2025-05-18 7566.67
3748 2025-05-19 7583.33
3749 2025-05-20 7591.67
2025-05-20 17:50:46,535 - IOOppi_data - INFO : save new data to db IOOppi_l_t: date value ... created_at updated_at
3749 2025-05-20 7591.67 ... 2025-05-20 17:50:46.528421 2025-05-20 17:50:46.528865
[1 rows x 5 columns]
2025-05-20 17:50:46,554 - IOOppi_data - INFO : save diff data to db: IOOppi_l_t: no diff data
2025-05-20 17:50:46,560 - IOOppi_data - INFO : save data to db IOOppi_l_g data:
date value
3745 2025-05-16 7566.67
3746 2025-05-17 7566.67
3747 2025-05-18 7566.67
3748 2025-05-19 7583.33
3749 2025-05-20 7591.67
2025-05-20 17:50:46,631 - IOOppi_data - INFO : save new data to db IOOppi_l_g: date value ... created_at updated_at
3752 2025-05-20 7591.67 ... 2025-05-20 17:50:46.624161 2025-05-20 17:50:46.624534
[1 rows x 5 columns]
2025-05-20 17:50:46,648 - 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-05-20 17:50:47,168 - IOOppi_data - INFO : save data to db IOOppi_bu_t data:
date value
3083 2025-05-16 3600.0
3084 2025-05-17 3600.0
3085 2025-05-18 3600.0
3086 2025-05-19 3582.5
3087 2025-05-20 3590.0
2025-05-20 17:50:47,231 - IOOppi_data - INFO : save new data to db IOOppi_bu_t: date value ... created_at updated_at
3088 2025-05-20 3590.0 ... 2025-05-20 17:50:47.223863 2025-05-20 17:50:47.224250
[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-05-20 17:50:47,265 - IOOppi_data - INFO : save diff data to db IOOppi_bu_t: date ... updated_at
2560 2023-12-09 ... 2025-05-20 17:50:47.258168
[1 rows x 6 columns]
2025-05-20 17:50:47,288 - IOOppi_data - INFO : save data to db IOOppi_bu_g data:
date value
3083 2025-05-16 3600.0
3084 2025-05-17 3600.0
3085 2025-05-18 3600.0
3086 2025-05-19 3582.5
3087 2025-05-20 3590.0
2025-05-20 17:50:47,351 - IOOppi_data - INFO : save new data to db IOOppi_bu_g: date value ... created_at updated_at
3090 2025-05-20 3590.0 ... 2025-05-20 17:50:47.344082 2025-05-20 17:50:47.344458
[1 rows x 5 columns]
2025-05-20 17:50:47,369 - 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-05-20 17:50:47,978 - IOOppi_data - INFO : save data to db IOOppi_al_t data:
date value
3748 2025-05-16 20290.00
3749 2025-05-17 20290.00
3750 2025-05-18 20290.00
3751 2025-05-19 20290.00
3752 2025-05-20 20226.67
2025-05-20 17:50:48,049 - IOOppi_data - INFO : save new data to db IOOppi_al_t: date ... updated_at
3752 2025-05-20 ... 2025-05-20 17:50:48.043279
[1 rows x 5 columns]
2025-05-20 17:50:48,069 - IOOppi_data - INFO : save diff data to db: IOOppi_al_t: no diff data
2025-05-20 17:50:48,075 - IOOppi_data - INFO : save data to db IOOppi_al_g data:
date value
3748 2025-05-16 20290.00
3749 2025-05-17 20290.00
3750 2025-05-18 20290.00
3751 2025-05-19 20290.00
3752 2025-05-20 20226.67
2025-05-20 17:50:48,147 - IOOppi_data - INFO : save new data to db IOOppi_al_g: date ... updated_at
3755 2025-05-20 ... 2025-05-20 17:50:48.140799
[1 rows x 5 columns]
2025-05-20 17:50:48,166 - 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-05-20 17:50:48,702 - IOOppi_data - INFO : save data to db IOOppi_SM_t data:
date value
2862 2025-05-16 5698.0
2863 2025-05-17 5698.0
2864 2025-05-18 5698.0
2865 2025-05-19 5664.0
2866 2025-05-20 5656.0
2025-05-20 17:50:48,762 - IOOppi_data - INFO : save new data to db IOOppi_SM_t: date value ... created_at updated_at
2866 2025-05-20 5656.0 ... 2025-05-20 17:50:48.755613 2025-05-20 17:50:48.756021
[1 rows x 5 columns]
2025-05-20 17:50:48,783 - IOOppi_data - INFO : save diff data to db: IOOppi_SM_t: no diff data
2025-05-20 17:50:48,789 - IOOppi_data - INFO : save data to db IOOppi_SM_g data:
date value
2862 2025-05-16 5698.0
2863 2025-05-17 5698.0
2864 2025-05-18 5698.0
2865 2025-05-19 5664.0
2866 2025-05-20 5656.0
2025-05-20 17:50:48,849 - IOOppi_data - INFO : save new data to db IOOppi_SM_g: date value ... created_at updated_at
2870 2025-05-20 5656.0 ... 2025-05-20 17:50:48.842359 2025-05-20 17:50:48.842741
[1 rows x 5 columns]
2025-05-20 17:50:48,869 - 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-05-20 17:50:49,403 - IOOppi_data - INFO : save data to db IOOppi_CY_t data:
date value
2137 2025-05-16 23775.0
2138 2025-05-17 23775.0
2139 2025-05-18 23775.0
2140 2025-05-19 23775.0
2141 2025-05-20 23775.0
2025-05-20 17:50:49,454 - IOOppi_data - INFO : save new data to db IOOppi_CY_t: date value ... created_at updated_at
2141 2025-05-20 23775.0 ... 2025-05-20 17:50:49.447719 2025-05-20 17:50:49.448133
[1 rows x 5 columns]
2025-05-20 17:50:49,474 - IOOppi_data - INFO : save diff data to db: IOOppi_CY_t: no diff data
2025-05-20 17:50:49,481 - IOOppi_data - INFO : save data to db IOOppi_CY_g data:
date value
2137 2025-05-16 23775.0
2138 2025-05-17 23775.0
2139 2025-05-18 23775.0
2140 2025-05-19 23775.0
2141 2025-05-20 23775.0
2025-05-20 17:50:49,536 - IOOppi_data - INFO : save new data to db IOOppi_CY_g: date value ... created_at updated_at
2145 2025-05-20 23775.0 ... 2025-05-20 17:50:49.529570 2025-05-20 17:50:49.529996
[1 rows x 5 columns]
2025-05-20 17:50:49,554 - 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-05-20 17:50:50,048 - IOOppi_data - INFO : save data to db IOOppi_UR_t data:
date value
1652 2025-05-16 1946.67
1653 2025-05-17 1946.67
1654 2025-05-18 1946.67
1655 2025-05-19 1945.00
1656 2025-05-20 1930.00
2025-05-20 17:50:50,093 - IOOppi_data - INFO : save new data to db IOOppi_UR_t: date value ... created_at updated_at
1656 2025-05-20 1930.0 ... 2025-05-20 17:50:50.086497 2025-05-20 17:50:50.086896
[1 rows x 5 columns]
2025-05-20 17:50:50,111 - IOOppi_data - INFO : save diff data to db: IOOppi_UR_t: no diff data
2025-05-20 17:50:50,118 - IOOppi_data - INFO : save data to db IOOppi_UR_g data:
date value
1652 2025-05-16 1946.67
1653 2025-05-17 1946.67
1654 2025-05-18 1946.67
1655 2025-05-19 1945.00
1656 2025-05-20 1930.00
2025-05-20 17:50:50,165 - IOOppi_data - INFO : save new data to db IOOppi_UR_g: date value ... created_at updated_at
1660 2025-05-20 1930.0 ... 2025-05-20 17:50:50.157985 2025-05-20 17:50:50.158368
[1 rows x 5 columns]
2025-05-20 17:50:50,184 - 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-05-20 17:50:50,826 - IOOppi_data - INFO : save data to db IOOppi_ni_t data:
date value
2724 2025-05-16 126258.33
2725 2025-05-17 126258.33
2726 2025-05-18 126258.33
2727 2025-05-19 125083.33
2728 2025-05-20 124775.00
2025-05-20 17:50:50,885 - IOOppi_data - INFO : save new data to db IOOppi_ni_t: date ... updated_at
2728 2025-05-20 ... 2025-05-20 17:50:50.878955
[1 rows x 5 columns]
2025-05-20 17:50:50,905 - IOOppi_data - INFO : save diff data to db: IOOppi_ni_t: no diff data
2025-05-20 17:50:50,911 - IOOppi_data - INFO : save data to db IOOppi_ni_g data:
date value
2724 2025-05-16 126258.33
2725 2025-05-17 126258.33
2726 2025-05-18 126258.33
2727 2025-05-19 125083.33
2728 2025-05-20 124775.00
2025-05-20 17:50:50,969 - IOOppi_data - INFO : save new data to db IOOppi_ni_g: date ... updated_at
2731 2025-05-20 ... 2025-05-20 17:50:50.963403
[1 rows x 5 columns]
2025-05-20 17:50:50,987 - 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-05-20 17:50:51,517 - IOOppi_data - INFO : save data to db IOOppi_v_t data:
date value
3749 2025-05-16 4782.0
3750 2025-05-17 4782.0
3751 2025-05-18 4782.0
3752 2025-05-19 4726.0
3753 2025-05-20 4719.0
2025-05-20 17:50:51,588 - IOOppi_data - INFO : save new data to db IOOppi_v_t: date value ... created_at updated_at
3753 2025-05-20 4719.0 ... 2025-05-20 17:50:51.581110 2025-05-20 17:50:51.581497
[1 rows x 5 columns]
2025-05-20 17:50:51,606 - IOOppi_data - INFO : save diff data to db: IOOppi_v_t: no diff data
2025-05-20 17:50:51,612 - IOOppi_data - INFO : save data to db IOOppi_v_g data:
date value
3749 2025-05-16 4782.0
3750 2025-05-17 4782.0
3751 2025-05-18 4782.0
3752 2025-05-19 4726.0
3753 2025-05-20 4719.0
2025-05-20 17:50:51,683 - IOOppi_data - INFO : save new data to db IOOppi_v_g: date value ... created_at updated_at
3756 2025-05-20 4719.0 ... 2025-05-20 17:50:51.676415 2025-05-20 17:50:51.676828
[1 rows x 5 columns]
2025-05-20 17:50:51,703 - 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-05-20 17:50:52,240 - IOOppi_data - INFO : save data to db IOOppi_pp_t data:
date value
2988 2025-05-16 7440.0
2989 2025-05-17 7440.0
2990 2025-05-18 7440.0
2991 2025-05-19 7440.0
2992 2025-05-20 7440.0
2025-05-20 17:50:52,301 - IOOppi_data - INFO : save new data to db IOOppi_pp_t: date value ... created_at updated_at
2992 2025-05-20 7440.0 ... 2025-05-20 17:50:52.293941 2025-05-20 17:50:52.294326
[1 rows x 5 columns]
2025-05-20 17:50:52,318 - IOOppi_data - INFO : save diff data to db: IOOppi_pp_t: no diff data
2025-05-20 17:50:52,324 - IOOppi_data - INFO : save data to db IOOppi_pp_g data:
date value
2988 2025-05-16 7440.0
2989 2025-05-17 7440.0
2990 2025-05-18 7440.0
2991 2025-05-19 7440.0
2992 2025-05-20 7440.0
2025-05-20 17:50:52,386 - IOOppi_data - INFO : save new data to db IOOppi_pp_g: date value ... created_at updated_at
2995 2025-05-20 7440.0 ... 2025-05-20 17:50:52.379276 2025-05-20 17:50:52.379673
[1 rows x 5 columns]
2025-05-20 17:50:52,404 - 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-05-20 17:50:52,963 - IOOppi_data - INFO : save data to db IOOppi_CF_t data:
date value
3750 2025-05-16 14558.17
3751 2025-05-17 14558.17
3752 2025-05-18 14558.17
3753 2025-05-19 14551.17
3754 2025-05-20 14539.17
2025-05-20 17:50:53,046 - IOOppi_data - INFO : save new data to db IOOppi_CF_t: date ... updated_at
3754 2025-05-20 ... 2025-05-20 17:50:53.040329
[1 rows x 5 columns]
2025-05-20 17:50:53,065 - IOOppi_data - INFO : save diff data to db: IOOppi_CF_t: no diff data
2025-05-20 17:50:53,071 - IOOppi_data - INFO : save data to db IOOppi_CF_g data:
date value
3750 2025-05-16 14558.17
3751 2025-05-17 14558.17
3752 2025-05-18 14558.17
3753 2025-05-19 14551.17
3754 2025-05-20 14539.17
2025-05-20 17:50:53,142 - IOOppi_data - INFO : save new data to db IOOppi_CF_g: date ... updated_at
3758 2025-05-20 ... 2025-05-20 17:50:53.136413
[1 rows x 5 columns]
2025-05-20 17:50:53,160 - 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-05-20 17:50:53,693 - IOOppi_data - INFO : save data to db IOOppi_pb_t data:
date value
3695 2025-05-16 16847.5
3696 2025-05-17 16847.5
3697 2025-05-18 16847.5
3698 2025-05-19 16825.0
3699 2025-05-20 16750.0
2025-05-20 17:50:53,764 - IOOppi_data - INFO : save new data to db IOOppi_pb_t: date value ... created_at updated_at
3699 2025-05-20 16750.0 ... 2025-05-20 17:50:53.757028 2025-05-20 17:50:53.757416
[1 rows x 5 columns]
2025-05-20 17:50:53,781 - IOOppi_data - INFO : save diff data to db: IOOppi_pb_t: no diff data
2025-05-20 17:50:53,787 - IOOppi_data - INFO : save data to db IOOppi_pb_g data:
date value
3695 2025-05-16 16847.5
3696 2025-05-17 16847.5
3697 2025-05-18 16847.5
3698 2025-05-19 16825.0
3699 2025-05-20 16750.0
2025-05-20 17:50:53,859 - IOOppi_data - INFO : save new data to db IOOppi_pb_g: date value ... created_at updated_at
3702 2025-05-20 16750.0 ... 2025-05-20 17:50:53.852210 2025-05-20 17:50:53.852584
[1 rows x 5 columns]
2025-05-20 17:50:53,878 - 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-05-20 17:50:54,513 - IOOppi_data - INFO : save data to db IOOppi_hc_t data:
date value
2970 2025-05-16 3310.0
2971 2025-05-17 3310.0
2972 2025-05-18 3310.0
2973 2025-05-19 3290.0
2974 2025-05-20 3290.0
2025-05-20 17:50:54,644 - IOOppi_data - INFO : save new data to db IOOppi_hc_t: date value ... created_at updated_at
2974 2025-05-20 3290.0 ... 2025-05-20 17:50:54.637430 2025-05-20 17:50:54.637832
[1 rows x 5 columns]
2025-05-20 17:50:54,663 - IOOppi_data - INFO : save diff data to db: IOOppi_hc_t: no diff data
2025-05-20 17:50:54,668 - IOOppi_data - INFO : save data to db IOOppi_hc_g data:
date value
2970 2025-05-16 3310.0
2971 2025-05-17 3310.0
2972 2025-05-18 3310.0
2973 2025-05-19 3290.0
2974 2025-05-20 3290.0
2025-05-20 17:50:54,730 - IOOppi_data - INFO : save new data to db IOOppi_hc_g: date value ... created_at updated_at
2977 2025-05-20 3290.0 ... 2025-05-20 17:50:54.723218 2025-05-20 17:50:54.723587
[1 rows x 5 columns]
2025-05-20 17:50:54,748 - 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-05-20 17:50:55,420 - IOOppi_data - INFO : save data to db IOOppi_fu_t data:
date value
3250 2025-05-16 5445.0
3251 2025-05-17 5445.0
3252 2025-05-18 5445.0
3253 2025-05-19 5462.5
3254 2025-05-20 5462.5
2025-05-20 17:50:55,484 - IOOppi_data - INFO : save new data to db IOOppi_fu_t: date value ... created_at updated_at
3254 2025-05-20 5462.5 ... 2025-05-20 17:50:55.477191 2025-05-20 17:50:55.477572
[1 rows x 5 columns]
2025-05-20 17:50:55,503 - IOOppi_data - INFO : save diff data to db: IOOppi_fu_t: no diff data
2025-05-20 17:50:55,509 - IOOppi_data - INFO : save data to db IOOppi_fu_g data:
date value
3250 2025-05-16 5445.0
3251 2025-05-17 5445.0
3252 2025-05-18 5445.0
3253 2025-05-19 5462.5
3254 2025-05-20 5462.5
2025-05-20 17:50:55,579 - IOOppi_data - INFO : save new data to db IOOppi_fu_g: date value ... created_at updated_at
3741 2025-05-20 5462.5 ... 2025-05-20 17:50:55.572397 2025-05-20 17:50:55.572794
[1 rows x 5 columns]
2025-05-20 17:50:55,596 - 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-05-20 17:50:56,075 - IOOppi_data - INFO : save data to db IOOppi_lh_t data:
date value
1314 2025-05-16 14650.0
1315 2025-05-17 14650.0
1316 2025-05-18 14650.0
1317 2025-05-19 14620.0
1318 2025-05-20 14600.0
2025-05-20 17:50:56,116 - IOOppi_data - INFO : save new data to db IOOppi_lh_t: date value ... created_at updated_at
1318 2025-05-20 14600.0 ... 2025-05-20 17:50:56.109006 2025-05-20 17:50:56.109387
[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-05-20 17:50:56,344 - IOOppi_data - INFO : save diff data to db IOOppi_lh_t: date ... updated_at
116 2021-07-05 ... 2025-05-20 17:50:56.337120
117 2021-07-06 ... 2025-05-20 17:50:56.337120
121 2021-07-12 ... 2025-05-20 17:50:56.337120
122 2021-07-13 ... 2025-05-20 17:50:56.337120
194 2021-11-01 ... 2025-05-20 17:50:56.337120
[5 rows x 6 columns]
2025-05-20 17:50:56,380 - IOOppi_data - INFO : save data to db IOOppi_lh_g data:
date value
1314 2025-05-16 14650.0
1315 2025-05-17 14650.0
1316 2025-05-18 14650.0
1317 2025-05-19 14620.0
1318 2025-05-20 14600.0
2025-05-20 17:50:56,421 - IOOppi_data - INFO : save new data to db IOOppi_lh_g: date value ... created_at updated_at
1321 2025-05-20 14600.0 ... 2025-05-20 17:50:56.414064 2025-05-20 17:50:56.414431
[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-05-20 17:50:56,647 - IOOppi_data - INFO : save diff data to db IOOppi_lh_g: date ... updated_at
116 2021-07-05 ... 2025-05-20 17:50:56.639289
117 2021-07-06 ... 2025-05-20 17:50:56.639289
121 2021-07-12 ... 2025-05-20 17:50:56.639289
122 2021-07-13 ... 2025-05-20 17:50:56.639289
194 2021-11-01 ... 2025-05-20 17:50:56.639289
[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-05-20 17:50:57,334 - IOOppi_data - INFO : save data to db IOOppi_cu_t data:
date value
3746 2025-05-16 78818.33
3747 2025-05-17 78818.33
3748 2025-05-18 78818.33
3749 2025-05-19 78113.33
3750 2025-05-20 78343.33
2025-05-20 17:50:57,404 - IOOppi_data - INFO : save new data to db IOOppi_cu_t: date ... updated_at
3750 2025-05-20 ... 2025-05-20 17:50:57.397856
[1 rows x 5 columns]
2025-05-20 17:50:57,422 - IOOppi_data - INFO : save diff data to db: IOOppi_cu_t: no diff data
2025-05-20 17:50:57,428 - IOOppi_data - INFO : save data to db IOOppi_cu_g data:
date value
3746 2025-05-16 78818.33
3747 2025-05-17 78818.33
3748 2025-05-18 78818.33
3749 2025-05-19 78113.33
3750 2025-05-20 78343.33
2025-05-20 17:50:57,500 - IOOppi_data - INFO : save new data to db IOOppi_cu_g: date ... updated_at
3753 2025-05-20 ... 2025-05-20 17:50:57.494174
[1 rows x 5 columns]
2025-05-20 17:50:57,518 - 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-05-20 17:50:58,009 - 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-05-20 17:50:58,061 - IOOppi_data - INFO : save new data to db: IOOppi_PM_t: no new data
2025-05-20 17:50:58,061 - IOOppi_data - INFO : save diff data to db: IOOppi_PM_t: no diff data
2025-05-20 17:50:58,067 - 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-05-20 17:50:58,126 - IOOppi_data - INFO : save new data to db: IOOppi_PM_g: no new data
2025-05-20 17:50:58,126 - 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-05-20 17:50:58,738 - IOOppi_data - INFO : save data to db IOOppi_sn_t data:
date value
2724 2025-05-16 265487.5
2725 2025-05-17 265487.5
2726 2025-05-18 265487.5
2727 2025-05-19 265187.5
2728 2025-05-20 265187.5
2025-05-20 17:50:58,795 - IOOppi_data - INFO : save new data to db IOOppi_sn_t: date ... updated_at
2728 2025-05-20 ... 2025-05-20 17:50:58.789511
[1 rows x 5 columns]
2025-05-20 17:50:58,814 - IOOppi_data - INFO : save diff data to db: IOOppi_sn_t: no diff data
2025-05-20 17:50:58,819 - IOOppi_data - INFO : save data to db IOOppi_sn_g data:
date value
2724 2025-05-16 265487.5
2725 2025-05-17 265487.5
2726 2025-05-18 265487.5
2727 2025-05-19 265187.5
2728 2025-05-20 265187.5
2025-05-20 17:50:58,876 - IOOppi_data - INFO : save new data to db IOOppi_sn_g: date ... updated_at
2731 2025-05-20 ... 2025-05-20 17:50:58.870522
[1 rows x 5 columns]
2025-05-20 17:50:58,894 - 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-05-20 17:50:59,440 - IOOppi_data - INFO : save data to db IOOppi_zn_t data:
date value
3745 2025-05-16 22746.0
3746 2025-05-17 22746.0
3747 2025-05-18 22746.0
3748 2025-05-19 22590.0
3749 2025-05-20 22574.0
2025-05-20 17:50:59,519 - IOOppi_data - INFO : save new data to db IOOppi_zn_t: date value ... created_at updated_at
3749 2025-05-20 22574.0 ... 2025-05-20 17:50:59.512515 2025-05-20 17:50:59.512947
[1 rows x 5 columns]
2025-05-20 17:50:59,538 - IOOppi_data - INFO : save diff data to db: IOOppi_zn_t: no diff data
2025-05-20 17:50:59,544 - IOOppi_data - INFO : save data to db IOOppi_zn_g data:
date value
3745 2025-05-16 22746.0
3746 2025-05-17 22746.0
3747 2025-05-18 22746.0
3748 2025-05-19 22590.0
3749 2025-05-20 22574.0
2025-05-20 17:50:59,614 - IOOppi_data - INFO : save new data to db IOOppi_zn_g: date value ... created_at updated_at
3752 2025-05-20 22574.0 ... 2025-05-20 17:50:59.607899 2025-05-20 17:50:59.608280
[1 rows x 5 columns]
2025-05-20 17:50:59,633 - 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-05-20 17:51:00,162 - IOOppi_data - INFO : save data to db IOOppi_wr_t data:
date value
3708 2025-05-16 3372.5
3709 2025-05-17 3372.5
3710 2025-05-18 3372.5
3711 2025-05-19 3347.5
3712 2025-05-20 3347.5
2025-05-20 17:51:00,234 - IOOppi_data - INFO : save new data to db IOOppi_wr_t: date value ... created_at updated_at
3712 2025-05-20 3347.5 ... 2025-05-20 17:51:00.226563 2025-05-20 17:51:00.226986
[1 rows x 5 columns]
2025-05-20 17:51:00,252 - IOOppi_data - INFO : save diff data to db: IOOppi_wr_t: no diff data
2025-05-20 17:51:00,259 - IOOppi_data - INFO : save data to db IOOppi_wr_g data:
date value
3708 2025-05-16 3372.5
3709 2025-05-17 3372.5
3710 2025-05-18 3372.5
3711 2025-05-19 3347.5
3712 2025-05-20 3347.5
2025-05-20 17:51:00,332 - IOOppi_data - INFO : save new data to db IOOppi_wr_g: date value ... created_at updated_at
3715 2025-05-20 3347.5 ... 2025-05-20 17:51:00.324918 2025-05-20 17:51:00.325327
[1 rows x 5 columns]
2025-05-20 17:51:00,351 - 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-05-20 17:51:00,911 - IOOppi_data - INFO : save data to db IOOppi_pg_t data:
date value
1505 2025-05-16 4780.0
1506 2025-05-17 4780.0
1507 2025-05-18 4780.0
1508 2025-05-19 4740.0
1509 2025-05-20 4702.5
2025-05-20 17:51:00,954 - IOOppi_data - INFO : save new data to db IOOppi_pg_t: date value ... created_at updated_at
1509 2025-05-20 4702.5 ... 2025-05-20 17:51:00.947869 2025-05-20 17:51:00.948254
[1 rows x 5 columns]
2025-05-20 17:51:00,973 - IOOppi_data - INFO : save diff data to db: IOOppi_pg_t: no diff data
2025-05-20 17:51:00,978 - IOOppi_data - INFO : save data to db IOOppi_pg_g data:
date value
1505 2025-05-16 4780.0
1506 2025-05-17 4780.0
1507 2025-05-18 4780.0
1508 2025-05-19 4740.0
1509 2025-05-20 4702.5
2025-05-20 17:51:01,021 - IOOppi_data - INFO : save new data to db IOOppi_pg_g: date value ... created_at updated_at
1512 2025-05-20 4702.5 ... 2025-05-20 17:51:01.014465 2025-05-20 17:51:01.014865
[1 rows x 5 columns]
2025-05-20 17:51:01,040 - 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-05-20 17:51:01,564 - IOOppi_data - INFO : save data to db IOOppi_cs_t data:
date value
2779 2025-05-16 2304.29
2780 2025-05-17 2304.29
2781 2025-05-18 2304.29
2782 2025-05-19 2301.43
2783 2025-05-20 2301.43
2025-05-20 17:51:01,623 - IOOppi_data - INFO : save new data to db IOOppi_cs_t: date value ... created_at updated_at
2783 2025-05-20 2301.43 ... 2025-05-20 17:51:01.616288 2025-05-20 17:51:01.616670
[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-05-20 17:51:01,665 - IOOppi_data - INFO : save diff data to db IOOppi_cs_t: date ... updated_at
2782 2025-05-19 ... 2025-05-20 17:51:01.658541
[1 rows x 6 columns]
2025-05-20 17:51:01,690 - IOOppi_data - INFO : save data to db IOOppi_cs_g data:
date value
2779 2025-05-16 2304.29
2780 2025-05-17 2304.29
2781 2025-05-18 2304.29
2782 2025-05-19 2301.43
2783 2025-05-20 2301.43
2025-05-20 17:51:01,750 - IOOppi_data - INFO : save new data to db IOOppi_cs_g: date value ... created_at updated_at
2786 2025-05-20 2301.43 ... 2025-05-20 17:51:01.743063 2025-05-20 17:51:01.743477
[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-05-20 17:51:01,791 - IOOppi_data - INFO : save diff data to db IOOppi_cs_g: date ... updated_at
2785 2025-05-19 ... 2025-05-20 17:51:01.784065
[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-05-20 17:51:02,344 - IOOppi_data - INFO : save data to db IOOppi_cs_t data:
date value
2779 2025-05-16 2304.29
2780 2025-05-17 2304.29
2781 2025-05-18 2304.29
2782 2025-05-19 2301.43
2783 2025-05-20 2922.00
2025-05-20 17:51:02,396 - 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-05-20 17:51:02,420 - IOOppi_data - INFO : save diff data to db IOOppi_cs_t: date ... updated_at
2783 2025-05-20 ... 2025-05-20 17:51:02.412223
[1 rows x 6 columns]
2025-05-20 17:51:02,445 - IOOppi_data - INFO : save data to db IOOppi_cs_g data:
date value
2779 2025-05-16 2304.29
2780 2025-05-17 2304.29
2781 2025-05-18 2304.29
2782 2025-05-19 2301.43
2783 2025-05-20 2922.00
2025-05-20 17:51:02,497 - 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-05-20 17:51:02,519 - IOOppi_data - INFO : save diff data to db IOOppi_cs_g: date ... updated_at
2786 2025-05-20 ... 2025-05-20 17:51:02.512301
[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-05-20 17:51:03,095 - IOOppi_data - INFO : save data to db IOOppi_RS_t data:
date value
3136 2025-05-16 9378.33
3137 2025-05-17 9378.33
3138 2025-05-18 9378.33
3139 2025-05-19 9475.00
3140 2025-05-20 9520.00
2025-05-20 17:51:03,150 - IOOppi_data - INFO : save new data to db: IOOppi_RS_t: no new data
2025-05-20 17:51:03,151 - IOOppi_data - INFO : save diff data to db: IOOppi_RS_t: no diff data
2025-05-20 17:51:03,156 - IOOppi_data - INFO : save data to db IOOppi_RS_g data:
date value
3136 2025-05-16 9378.33
3137 2025-05-17 9378.33
3138 2025-05-18 9378.33
3139 2025-05-19 9475.00
3140 2025-05-20 9520.00
2025-05-20 17:51:03,214 - IOOppi_data - INFO : save new data to db: IOOppi_RS_g: no new data
2025-05-20 17:51:03,214 - 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-05-20 17:51:03,753 - IOOppi_data - INFO : save data to db IOOppi_eg_t data:
date value
1820 2025-05-16 4551.67
1821 2025-05-17 4551.67
1822 2025-05-18 4551.67
1823 2025-05-19 4560.00
1824 2025-05-20 4540.00
2025-05-20 17:51:03,801 - IOOppi_data - INFO : save new data to db IOOppi_eg_t: date value ... created_at updated_at
1824 2025-05-20 4540.0 ... 2025-05-20 17:51:03.794272 2025-05-20 17:51:03.794672
[1 rows x 5 columns]
2025-05-20 17:51:03,820 - IOOppi_data - INFO : save diff data to db: IOOppi_eg_t: no diff data
2025-05-20 17:51:03,826 - IOOppi_data - INFO : save data to db IOOppi_eg_g data:
date value
1820 2025-05-16 4551.67
1821 2025-05-17 4551.67
1822 2025-05-18 4551.67
1823 2025-05-19 4560.00
1824 2025-05-20 4540.00
2025-05-20 17:51:03,878 - IOOppi_data - INFO : save new data to db IOOppi_eg_g: date value ... created_at updated_at
1827 2025-05-20 4540.0 ... 2025-05-20 17:51:03.870697 2025-05-20 17:51:03.871120
[1 rows x 5 columns]
2025-05-20 17:51:03,896 - 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-05-20 17:51:04,461 - IOOppi_data - INFO : save data to db IOOppi_sp_t data:
date value
1829 2025-05-16 6300.0
1830 2025-05-17 6300.0
1831 2025-05-18 6300.0
1832 2025-05-19 6300.0
1833 2025-05-20 6300.0
2025-05-20 17:51:04,511 - IOOppi_data - INFO : save new data to db IOOppi_sp_t: date value ... created_at updated_at
1833 2025-05-20 6300.0 ... 2025-05-20 17:51:04.504772 2025-05-20 17:51:04.505178
[1 rows x 5 columns]
2025-05-20 17:51:04,530 - IOOppi_data - INFO : save diff data to db: IOOppi_sp_t: no diff data
2025-05-20 17:51:04,535 - IOOppi_data - INFO : save data to db IOOppi_sp_g data:
date value
1829 2025-05-16 6300.0
1830 2025-05-17 6300.0
1831 2025-05-18 6300.0
1832 2025-05-19 6300.0
1833 2025-05-20 6300.0
2025-05-20 17:51:04,583 - IOOppi_data - INFO : save new data to db IOOppi_sp_g: date value ... created_at updated_at
1836 2025-05-20 6300.0 ... 2025-05-20 17:51:04.576505 2025-05-20 17:51:04.576914
[1 rows x 5 columns]
2025-05-20 17:51:04,601 - 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-05-20 17:51:05,160 - IOOppi_data - INFO : save data to db IOOppi_p_t data:
date value
3497 2025-05-16 8492.0
3498 2025-05-17 8492.0
3499 2025-05-18 8492.0
3500 2025-05-19 8542.0
3501 2025-05-20 8636.0
2025-05-20 17:51:05,228 - IOOppi_data - INFO : save new data to db IOOppi_p_t: date value ... created_at updated_at
3501 2025-05-20 8636.0 ... 2025-05-20 17:51:05.221545 2025-05-20 17:51:05.221955
[1 rows x 5 columns]
2025-05-20 17:51:05,247 - IOOppi_data - INFO : save diff data to db: IOOppi_p_t: no diff data
2025-05-20 17:51:05,253 - IOOppi_data - INFO : save data to db IOOppi_p_g data:
date value
3497 2025-05-16 8492.0
3498 2025-05-17 8492.0
3499 2025-05-18 8492.0
3500 2025-05-19 8542.0
3501 2025-05-20 8636.0
2025-05-20 17:51:05,324 - IOOppi_data - INFO : save new data to db IOOppi_p_g: date value ... created_at updated_at
3504 2025-05-20 8636.0 ... 2025-05-20 17:51:05.317201 2025-05-20 17:51:05.317667
[1 rows x 5 columns]
2025-05-20 17:51:05,342 - IOOppi_data - INFO : save diff data to db: IOOppi_p_g: no diff data