=========================================================================
2025-05-30 17:50:26 Fri START TASK.01 IOOppi_data update_data
=========================================================================
/usr/local/lib/python3.10/site-packages/urllib3/connectionpool.py:1056: InsecureRequestWarning: Unverified HTTPS request is being made to host 'www.100ppi.com'. Adding certificate verification is strongly advised. See: https://urllib3.readthedocs.io/en/1.26.x/advanced-usage.html#ssl-warnings
warnings.warn(
2025-05-30 17:50:28,373 - IOOppi_data - INFO : save data to db IOOppi_rb_t data:
date value
3315 2025-05-26 3115.67
3316 2025-05-27 3077.11
3317 2025-05-28 3061.67
3318 2025-05-29 3069.00
3319 2025-05-30 3062.22
2025-05-30 17:50:28,450 - IOOppi_data - INFO : save new data to db IOOppi_rb_t: date value ... created_at updated_at
3319 2025-05-30 3062.22 ... 2025-05-30 17:50:28.442680 2025-05-30 17:50:28.443102
[1 rows x 5 columns]
2025-05-30 17:50:28,477 - IOOppi_data - INFO : save diff data to db: IOOppi_rb_t: no diff data
2025-05-30 17:50:28,482 - IOOppi_data - INFO : save data to db IOOppi_rb_g data:
date value
3315 2025-05-26 3115.67
3316 2025-05-27 3077.11
3317 2025-05-28 3061.67
3318 2025-05-29 3069.00
3319 2025-05-30 3062.22
2025-05-30 17:50:28,549 - IOOppi_data - INFO : save new data to db IOOppi_rb_g: date value ... created_at updated_at
3322 2025-05-30 3062.22 ... 2025-05-30 17:50:28.542342 2025-05-30 17:50:28.542712
[1 rows x 5 columns]
2025-05-30 17:50:28,582 - 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-30 17:50:29,216 - IOOppi_data - INFO : save data to db IOOppi_MA_t data:
date value
3536 2025-05-26 2300.00
3537 2025-05-27 2253.75
3538 2025-05-28 2246.25
3539 2025-05-29 2247.00
3540 2025-05-30 2245.00
2025-05-30 17:50:29,292 - IOOppi_data - INFO : save new data to db IOOppi_MA_t: date value ... created_at updated_at
3540 2025-05-30 2245.0 ... 2025-05-30 17:50:29.284185 2025-05-30 17:50:29.284585
[1 rows x 5 columns]
2025-05-30 17:50:29,311 - IOOppi_data - INFO : save diff data to db: IOOppi_MA_t: no diff data
2025-05-30 17:50:29,317 - IOOppi_data - INFO : save data to db IOOppi_MA_g data:
date value
3536 2025-05-26 2300.00
3537 2025-05-27 2253.75
3538 2025-05-28 2246.25
3539 2025-05-29 2247.00
3540 2025-05-30 2245.00
2025-05-30 17:50:29,390 - IOOppi_data - INFO : save new data to db IOOppi_MA_g: date value ... created_at updated_at
3544 2025-05-30 2245.0 ... 2025-05-30 17:50:29.383700 2025-05-30 17:50:29.384104
[1 rows x 5 columns]
2025-05-30 17:50:29,410 - 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-30 17:50:30,003 - IOOppi_data - INFO : save data to db IOOppi_PTA_t data:
date value
876 2025-05-26 4917.50
877 2025-05-27 4938.75
878 2025-05-28 4893.75
879 2025-05-29 4972.50
880 2025-05-30 4965.62
2025-05-30 17:50:30,042 - IOOppi_data - INFO : save new data to db IOOppi_PTA_t: date value ... created_at updated_at
880 2025-05-30 4965.62 ... 2025-05-30 17:50:30.035235 2025-05-30 17:50:30.035611
[1 rows x 5 columns]
2025-05-30 17:50:30,061 - IOOppi_data - INFO : save diff data to db: IOOppi_PTA_t: no diff data
2025-05-30 17:50:30,066 - IOOppi_data - INFO : save data to db IOOppi_PTA_g data:
date value
876 2025-05-26 4917.50
877 2025-05-27 4938.75
878 2025-05-28 4893.75
879 2025-05-29 4972.50
880 2025-05-30 4965.62
2025-05-30 17:50:30,105 - IOOppi_data - INFO : save new data to db IOOppi_PTA_g: date value ... created_at updated_at
880 2025-05-30 4965.62 ... 2025-05-30 17:50:30.098205 2025-05-30 17:50:30.098575
[1 rows x 5 columns]
2025-05-30 17:50:30,125 - 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-30 17:50:30,758 - IOOppi_data - INFO : save data to db IOOppi_ru_t data:
date value
3755 2025-05-26 14158.33
3756 2025-05-27 14258.33
3757 2025-05-28 13658.33
3758 2025-05-29 13708.33
3759 2025-05-30 13308.33
2025-05-30 17:50:30,839 - IOOppi_data - INFO : save new data to db IOOppi_ru_t: date ... updated_at
3759 2025-05-30 ... 2025-05-30 17:50:30.833106
[1 rows x 5 columns]
2025-05-30 17:50:30,859 - IOOppi_data - INFO : save diff data to db: IOOppi_ru_t: no diff data
2025-05-30 17:50:30,865 - IOOppi_data - INFO : save data to db IOOppi_ru_g data:
date value
3755 2025-05-26 14158.33
3756 2025-05-27 14258.33
3757 2025-05-28 13658.33
3758 2025-05-29 13708.33
3759 2025-05-30 13308.33
2025-05-30 17:50:30,942 - IOOppi_data - INFO : save new data to db IOOppi_ru_g: date ... updated_at
3762 2025-05-30 ... 2025-05-30 17:50:30.935949
[1 rows x 5 columns]
2025-05-30 17:50:30,961 - 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-30 17:50:31,612 - IOOppi_data - INFO : save data to db IOOppi_i_t data:
date value
3087 2025-05-26 769.67
3088 2025-05-27 757.33
3089 2025-05-28 751.44
3090 2025-05-29 753.67
3091 2025-05-30 750.33
2025-05-30 17:50:31,681 - IOOppi_data - INFO : save new data to db IOOppi_i_t: date value ... created_at updated_at
3091 2025-05-30 750.33 ... 2025-05-30 17:50:31.674538 2025-05-30 17:50:31.674943
[1 rows x 5 columns]
2025-05-30 17:50:31,700 - IOOppi_data - INFO : save diff data to db: IOOppi_i_t: no diff data
2025-05-30 17:50:31,706 - IOOppi_data - INFO : save data to db IOOppi_i_g data:
date value
3087 2025-05-26 769.67
3088 2025-05-27 757.33
3089 2025-05-28 751.44
3090 2025-05-29 753.67
3091 2025-05-30 750.33
2025-05-30 17:50:31,777 - IOOppi_data - INFO : save new data to db IOOppi_i_g: date value ... created_at updated_at
3094 2025-05-30 750.33 ... 2025-05-30 17:50:31.770541 2025-05-30 17:50:31.770938
[1 rows x 5 columns]
2025-05-30 17:50:31,796 - 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-30 17:50:32,339 - IOOppi_data - INFO : save data to db IOOppi_FG_t data:
date value
3290 2025-05-26 1152.0
3291 2025-05-27 1152.0
3292 2025-05-28 1152.0
3293 2025-05-29 1152.0
3294 2025-05-30 1150.4
2025-05-30 17:50:32,413 - IOOppi_data - INFO : save new data to db IOOppi_FG_t: date value ... created_at updated_at
3294 2025-05-30 1150.4 ... 2025-05-30 17:50:32.406281 2025-05-30 17:50:32.406655
[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-30 17:50:34,502 - IOOppi_data - INFO : save diff data to db IOOppi_FG_t: date ... updated_at
12 2012-12-19 ... 2025-05-30 17:50:34.494431
21 2013-01-04 ... 2025-05-30 17:50:34.494431
54 2013-02-27 ... 2025-05-30 17:50:34.494431
60 2013-03-07 ... 2025-05-30 17:50:34.494431
61 2013-03-08 ... 2025-05-30 17:50:34.494431
[5 rows x 6 columns]
2025-05-30 17:50:35,108 - IOOppi_data - INFO : save data to db IOOppi_FG_g data:
date value
3290 2025-05-26 1152.0
3291 2025-05-27 1152.0
3292 2025-05-28 1152.0
3293 2025-05-29 1152.0
3294 2025-05-30 1150.4
2025-05-30 17:50:35,180 - IOOppi_data - INFO : save new data to db IOOppi_FG_g: date value ... created_at updated_at
3298 2025-05-30 1150.4 ... 2025-05-30 17:50:35.173612 2025-05-30 17:50:35.174020
[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-30 17:50:37,148 - IOOppi_data - INFO : save diff data to db IOOppi_FG_g: date ... updated_at
12 2012-12-19 ... 2025-05-30 17:50:37.140193
21 2013-01-04 ... 2025-05-30 17:50:37.140193
54 2013-02-27 ... 2025-05-30 17:50:37.140193
60 2013-03-07 ... 2025-05-30 17:50:37.140193
61 2013-03-08 ... 2025-05-30 17:50:37.140193
[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-30 17:50:39,211 - IOOppi_data - INFO : save data to db IOOppi_eb_t data:
date value
1635 2025-05-26 8110.0
1636 2025-05-27 8110.0
1637 2025-05-28 8110.0
1638 2025-05-29 8110.0
1639 2025-05-30 8104.0
2025-05-30 17:50:39,262 - IOOppi_data - INFO : save new data to db IOOppi_eb_t: date value ... created_at updated_at
1639 2025-05-30 8104.0 ... 2025-05-30 17:50:39.255122 2025-05-30 17:50:39.255521
[1 rows x 5 columns]
2025-05-30 17:50:39,281 - IOOppi_data - INFO : save diff data to db: IOOppi_eb_t: no diff data
2025-05-30 17:50:39,287 - IOOppi_data - INFO : save data to db IOOppi_eb_g data:
date value
1635 2025-05-26 8110.0
1636 2025-05-27 8110.0
1637 2025-05-28 8110.0
1638 2025-05-29 8110.0
1639 2025-05-30 8104.0
2025-05-30 17:50:39,334 - IOOppi_data - INFO : save new data to db IOOppi_eb_g: date value ... created_at updated_at
1642 2025-05-30 8104.0 ... 2025-05-30 17:50:39.327169 2025-05-30 17:50:39.327533
[1 rows x 5 columns]
2025-05-30 17:50:39,353 - 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-30 17:50:39,934 - IOOppi_data - INFO : save data to db IOOppi_SR_t data:
date value
3746 2025-05-26 6145.0
3747 2025-05-27 6145.0
3748 2025-05-28 6145.0
3749 2025-05-29 6130.0
3750 2025-05-30 6130.0
2025-05-30 17:50:40,010 - IOOppi_data - INFO : save new data to db IOOppi_SR_t: date value ... created_at updated_at
3750 2025-05-30 6130.0 ... 2025-05-30 17:50:40.003296 2025-05-30 17:50:40.003675
[1 rows x 5 columns]
2025-05-30 17:50:40,029 - IOOppi_data - INFO : save diff data to db: IOOppi_SR_t: no diff data
2025-05-30 17:50:40,035 - IOOppi_data - INFO : save data to db IOOppi_SR_g data:
date value
3746 2025-05-26 6145.0
3747 2025-05-27 6145.0
3748 2025-05-28 6145.0
3749 2025-05-29 6130.0
3750 2025-05-30 6130.0
2025-05-30 17:50:40,111 - IOOppi_data - INFO : save new data to db IOOppi_SR_g: date value ... created_at updated_at
3754 2025-05-30 6130.0 ... 2025-05-30 17:50:40.104462 2025-05-30 17:50:40.104857
[1 rows x 5 columns]
2025-05-30 17:50:40,130 - 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-30 17:50:40,670 - IOOppi_data - INFO : save data to db IOOppi_ss_t data:
date value
1636 2025-05-26 13225.0
1637 2025-05-27 13225.0
1638 2025-05-28 13175.0
1639 2025-05-29 13175.0
1640 2025-05-30 13175.0
2025-05-30 17:50:40,718 - IOOppi_data - INFO : save new data to db IOOppi_ss_t: date value ... created_at updated_at
1640 2025-05-30 13175.0 ... 2025-05-30 17:50:40.710773 2025-05-30 17:50:40.711168
[1 rows x 5 columns]
2025-05-30 17:50:40,737 - IOOppi_data - INFO : save diff data to db: IOOppi_ss_t: no diff data
2025-05-30 17:50:40,742 - IOOppi_data - INFO : save data to db IOOppi_ss_g data:
date value
1636 2025-05-26 13225.0
1637 2025-05-27 13225.0
1638 2025-05-28 13175.0
1639 2025-05-29 13175.0
1640 2025-05-30 13175.0
2025-05-30 17:50:40,792 - IOOppi_data - INFO : save new data to db IOOppi_ss_g: date value ... created_at updated_at
1643 2025-05-30 13175.0 ... 2025-05-30 17:50:40.784965 2025-05-30 17:50:40.785341
[1 rows x 5 columns]
2025-05-30 17:50:40,811 - 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-30 17:50:41,410 - IOOppi_data - INFO : save data to db IOOppi_RS_t data:
date value
3146 2025-05-26 9493.33
3147 2025-05-27 9545.00
3148 2025-05-28 9525.00
3149 2025-05-29 9530.00
3150 2025-05-30 9456.67
2025-05-30 17:50:41,480 - IOOppi_data - INFO : save new data to db IOOppi_RS_t: date value ... created_at updated_at
3150 2025-05-30 9456.67 ... 2025-05-30 17:50:41.472797 2025-05-30 17:50:41.473207
[1 rows x 5 columns]
2025-05-30 17:50:41,498 - IOOppi_data - INFO : save diff data to db: IOOppi_RS_t: no diff data
2025-05-30 17:50:41,504 - IOOppi_data - INFO : save data to db IOOppi_RS_g data:
date value
3146 2025-05-26 9493.33
3147 2025-05-27 9545.00
3148 2025-05-28 9525.00
3149 2025-05-29 9530.00
3150 2025-05-30 9456.67
2025-05-30 17:50:41,573 - IOOppi_data - INFO : save new data to db IOOppi_RS_g: date value ... created_at updated_at
3154 2025-05-30 9456.67 ... 2025-05-30 17:50:41.566595 2025-05-30 17:50:41.566991
[1 rows x 5 columns]
2025-05-30 17:50:41,591 - 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-30 17:50:42,160 - IOOppi_data - INFO : save data to db IOOppi_RM_t data:
date value
3269 2025-05-26 2515.00
3270 2025-05-27 2543.33
3271 2025-05-28 2550.00
3272 2025-05-29 2543.33
3273 2025-05-30 2565.00
2025-05-30 17:50:42,232 - IOOppi_data - INFO : save new data to db IOOppi_RM_t: date value ... created_at updated_at
3273 2025-05-30 2565.0 ... 2025-05-30 17:50:42.225646 2025-05-30 17:50:42.226052
[1 rows x 5 columns]
2025-05-30 17:50:42,252 - IOOppi_data - INFO : save diff data to db: IOOppi_RM_t: no diff data
2025-05-30 17:50:42,257 - IOOppi_data - INFO : save data to db IOOppi_RM_g data:
date value
3269 2025-05-26 2515.00
3270 2025-05-27 2543.33
3271 2025-05-28 2550.00
3272 2025-05-29 2543.33
3273 2025-05-30 2565.00
2025-05-30 17:50:42,329 - IOOppi_data - INFO : save new data to db IOOppi_RM_g: date value ... created_at updated_at
3277 2025-05-30 2565.0 ... 2025-05-30 17:50:42.321616 2025-05-30 17:50:42.322038
[1 rows x 5 columns]
2025-05-30 17:50:42,348 - 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-30 17:50:42,842 - IOOppi_data - INFO : save data to db IOOppi_SA_t data:
date value
1473 2025-05-26 1462.5
1474 2025-05-27 1450.0
1475 2025-05-28 1450.0
1476 2025-05-29 1450.0
1477 2025-05-30 1450.0
2025-05-30 17:50:42,896 - IOOppi_data - INFO : save new data to db IOOppi_SA_t: date value ... created_at updated_at
1477 2025-05-30 1450.0 ... 2025-05-30 17:50:42.889210 2025-05-30 17:50:42.889586
[1 rows x 5 columns]
2025-05-30 17:50:42,915 - IOOppi_data - INFO : save diff data to db: IOOppi_SA_t: no diff data
2025-05-30 17:50:42,920 - IOOppi_data - INFO : save data to db IOOppi_SA_g data:
date value
1473 2025-05-26 1462.5
1474 2025-05-27 1450.0
1475 2025-05-28 1450.0
1476 2025-05-29 1450.0
1477 2025-05-30 1450.0
2025-05-30 17:50:42,968 - IOOppi_data - INFO : save new data to db IOOppi_SA_g: date value ... created_at updated_at
1481 2025-05-30 1450.0 ... 2025-05-30 17:50:42.961101 2025-05-30 17:50:42.961475
[1 rows x 5 columns]
2025-05-30 17:50:42,987 - 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-30 17:50:43,640 - IOOppi_data - INFO : save data to db IOOppi_PF_t data:
date value
1386 2025-05-26 6572.50
1387 2025-05-27 6545.21
1388 2025-05-28 6535.21
1389 2025-05-29 6522.08
1390 2025-05-30 6511.46
2025-05-30 17:50:43,687 - IOOppi_data - INFO : save new data to db IOOppi_PF_t: date value ... created_at updated_at
1390 2025-05-30 6511.46 ... 2025-05-30 17:50:43.680108 2025-05-30 17:50:43.680479
[1 rows x 5 columns]
2025-05-30 17:50:43,706 - IOOppi_data - INFO : save diff data to db: IOOppi_PF_t: no diff data
2025-05-30 17:50:43,711 - IOOppi_data - INFO : save data to db IOOppi_PF_g data:
date value
1386 2025-05-26 6572.50
1387 2025-05-27 6545.21
1388 2025-05-28 6535.21
1389 2025-05-29 6522.08
1390 2025-05-30 6511.46
2025-05-30 17:50:43,755 - IOOppi_data - INFO : save new data to db IOOppi_PF_g: date value ... created_at updated_at
1394 2025-05-30 6511.46 ... 2025-05-30 17:50:43.748180 2025-05-30 17:50:43.748535
[1 rows x 5 columns]
2025-05-30 17:50:43,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-05-30 17:50:44,344 - IOOppi_data - INFO : save data to db IOOppi_m_t data:
date value
3759 2025-05-26 2982.0
3760 2025-05-27 2962.0
3761 2025-05-28 2966.0
3762 2025-05-29 2952.0
3763 2025-05-30 2956.0
2025-05-30 17:50:44,415 - IOOppi_data - INFO : save new data to db IOOppi_m_t: date value ... created_at updated_at
3763 2025-05-30 2956.0 ... 2025-05-30 17:50:44.408085 2025-05-30 17:50:44.408459
[1 rows x 5 columns]
2025-05-30 17:50:44,434 - IOOppi_data - INFO : save diff data to db: IOOppi_m_t: no diff data
2025-05-30 17:50:44,439 - IOOppi_data - INFO : save data to db IOOppi_m_g data:
date value
3759 2025-05-26 2982.0
3760 2025-05-27 2962.0
3761 2025-05-28 2966.0
3762 2025-05-29 2952.0
3763 2025-05-30 2956.0
2025-05-30 17:50:44,510 - IOOppi_data - INFO : save new data to db IOOppi_m_g: date value ... created_at updated_at
3766 2025-05-30 2956.0 ... 2025-05-30 17:50:44.503660 2025-05-30 17:50:44.504064
[1 rows x 5 columns]
2025-05-30 17:50:44,530 - 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-30 17:50:45,123 - IOOppi_data - INFO : save data to db IOOppi_y_t data:
date value
3529 2025-05-26 7964.0
3530 2025-05-27 7994.0
3531 2025-05-28 7974.0
3532 2025-05-29 7984.0
3533 2025-05-30 7904.0
2025-05-30 17:50:45,201 - IOOppi_data - INFO : save new data to db IOOppi_y_t: date value ... created_at updated_at
3533 2025-05-30 7904.0 ... 2025-05-30 17:50:45.193888 2025-05-30 17:50:45.194281
[1 rows x 5 columns]
2025-05-30 17:50:45,220 - IOOppi_data - INFO : save diff data to db: IOOppi_y_t: no diff data
2025-05-30 17:50:45,226 - IOOppi_data - INFO : save data to db IOOppi_y_g data:
date value
3529 2025-05-26 7964.0
3530 2025-05-27 7994.0
3531 2025-05-28 7974.0
3532 2025-05-29 7984.0
3533 2025-05-30 7904.0
2025-05-30 17:50:45,305 - IOOppi_data - INFO : save new data to db IOOppi_y_g: date value ... created_at updated_at
3536 2025-05-30 7904.0 ... 2025-05-30 17:50:45.297578 2025-05-30 17:50:45.298011
[1 rows x 5 columns]
2025-05-30 17:50:45,323 - 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-30 17:50:45,899 - IOOppi_data - INFO : save data to db IOOppi_a_t data:
date value
3495 2025-05-26 4255.0
3496 2025-05-27 4255.0
3497 2025-05-28 4255.0
3498 2025-05-29 4255.0
3499 2025-05-30 4255.0
2025-05-30 17:50:45,978 - IOOppi_data - INFO : save new data to db IOOppi_a_t: date value ... created_at updated_at
3499 2025-05-30 4255.0 ... 2025-05-30 17:50:45.971081 2025-05-30 17:50:45.971464
[1 rows x 5 columns]
2025-05-30 17:50:45,997 - IOOppi_data - INFO : save diff data to db: IOOppi_a_t: no diff data
2025-05-30 17:50:46,003 - IOOppi_data - INFO : save data to db IOOppi_a_g data:
date value
3495 2025-05-26 4255.0
3496 2025-05-27 4255.0
3497 2025-05-28 4255.0
3498 2025-05-29 4255.0
3499 2025-05-30 4255.0
2025-05-30 17:50:46,075 - IOOppi_data - INFO : save new data to db IOOppi_a_g: date value ... created_at updated_at
3502 2025-05-30 4255.0 ... 2025-05-30 17:50:46.068195 2025-05-30 17:50:46.068567
[1 rows x 5 columns]
2025-05-30 17:50:46,093 - 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-30 17:50:46,666 - IOOppi_data - INFO : save data to db IOOppi_SF_t data:
date value
2872 2025-05-26 5380.00
2873 2025-05-27 5380.00
2874 2025-05-28 5380.00
2875 2025-05-29 5298.57
2876 2025-05-30 5298.57
2025-05-30 17:50:46,738 - IOOppi_data - INFO : save new data to db IOOppi_SF_t: date value ... created_at updated_at
2876 2025-05-30 5298.57 ... 2025-05-30 17:50:46.729976 2025-05-30 17:50:46.730452
[1 rows x 5 columns]
2025-05-30 17:50:46,758 - IOOppi_data - INFO : save diff data to db: IOOppi_SF_t: no diff data
2025-05-30 17:50:46,764 - IOOppi_data - INFO : save data to db IOOppi_SF_g data:
date value
2872 2025-05-26 5380.00
2873 2025-05-27 5380.00
2874 2025-05-28 5380.00
2875 2025-05-29 5298.57
2876 2025-05-30 5298.57
2025-05-30 17:50:46,833 - IOOppi_data - INFO : save new data to db IOOppi_SF_g: date value ... created_at updated_at
2880 2025-05-30 5298.57 ... 2025-05-30 17:50:46.826472 2025-05-30 17:50:46.826912
[1 rows x 5 columns]
2025-05-30 17:50:46,853 - 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-30 17:50:47,479 - IOOppi_data - INFO : save data to db IOOppi_jd_t data:
date value
3072 2025-05-26 3050.0
3073 2025-05-27 3040.0
3074 2025-05-28 3040.0
3075 2025-05-29 3040.0
3076 2025-05-30 3015.0
2025-05-30 17:50:47,554 - IOOppi_data - INFO : save new data to db IOOppi_jd_t: date value ... created_at updated_at
3076 2025-05-30 3015.0 ... 2025-05-30 17:50:47.546742 2025-05-30 17:50:47.547182
[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-30 17:50:47,714 - IOOppi_data - INFO : save diff data to db IOOppi_jd_t: date ... updated_at
39 2014-01-03 ... 2025-05-30 17:50:47.706746
458 2015-09-21 ... 2025-05-30 17:50:47.706746
549 2016-02-03 ... 2025-05-30 17:50:47.706746
693 2016-09-05 ... 2025-05-30 17:50:47.706746
696 2016-09-08 ... 2025-05-30 17:50:47.706746
[5 rows x 6 columns]
2025-05-30 17:50:47,755 - IOOppi_data - INFO : save data to db IOOppi_jd_g data:
date value
3072 2025-05-26 3050.0
3073 2025-05-27 3040.0
3074 2025-05-28 3040.0
3075 2025-05-29 3040.0
3076 2025-05-30 3015.0
2025-05-30 17:50:47,820 - IOOppi_data - INFO : save new data to db IOOppi_jd_g: date value ... created_at updated_at
3079 2025-05-30 3015.0 ... 2025-05-30 17:50:47.813163 2025-05-30 17:50:47.813530
[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-30 17:50:47,970 - IOOppi_data - INFO : save diff data to db IOOppi_jd_g: date ... updated_at
39 2014-01-03 ... 2025-05-30 17:50:47.962411
458 2015-09-21 ... 2025-05-30 17:50:47.962411
549 2016-02-03 ... 2025-05-30 17:50:47.962411
693 2016-09-05 ... 2025-05-30 17:50:47.962411
696 2016-09-08 ... 2025-05-30 17:50:47.962411
[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-30 17:50:48,609 - IOOppi_data - INFO : save data to db IOOppi_SI_t data:
date value
876 2025-05-26 9180.0
877 2025-05-27 9000.0
878 2025-05-28 8990.0
879 2025-05-29 8990.0
880 2025-05-30 8780.0
2025-05-30 17:50:48,647 - IOOppi_data - INFO : save new data to db IOOppi_SI_t: date value ... created_at updated_at
880 2025-05-30 8780.0 ... 2025-05-30 17:50:48.640227 2025-05-30 17:50:48.640601
[1 rows x 5 columns]
2025-05-30 17:50:48,666 - IOOppi_data - INFO : save diff data to db: IOOppi_SI_t: no diff data
2025-05-30 17:50:48,671 - IOOppi_data - INFO : save data to db IOOppi_SI_g data:
date value
876 2025-05-26 9180.0
877 2025-05-27 9000.0
878 2025-05-28 8990.0
879 2025-05-29 8990.0
880 2025-05-30 8780.0
2025-05-30 17:50:48,707 - IOOppi_data - INFO : save new data to db IOOppi_SI_g: date value ... created_at updated_at
880 2025-05-30 8780.0 ... 2025-05-30 17:50:48.700014 2025-05-30 17:50:48.700371
[1 rows x 5 columns]
2025-05-30 17:50:48,730 - 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-30 17:50:49,371 - IOOppi_data - INFO : save data to db IOOppi_l_t data:
date value
3755 2025-05-26 7496.67
3756 2025-05-27 7451.67
3757 2025-05-28 7431.67
3758 2025-05-29 7378.33
3759 2025-05-30 7368.33
2025-05-30 17:50:49,447 - IOOppi_data - INFO : save new data to db IOOppi_l_t: date value ... created_at updated_at
3759 2025-05-30 7368.33 ... 2025-05-30 17:50:49.440389 2025-05-30 17:50:49.440801
[1 rows x 5 columns]
2025-05-30 17:50:49,466 - IOOppi_data - INFO : save diff data to db: IOOppi_l_t: no diff data
2025-05-30 17:50:49,472 - IOOppi_data - INFO : save data to db IOOppi_l_g data:
date value
3755 2025-05-26 7496.67
3756 2025-05-27 7451.67
3757 2025-05-28 7431.67
3758 2025-05-29 7378.33
3759 2025-05-30 7368.33
2025-05-30 17:50:49,544 - IOOppi_data - INFO : save new data to db IOOppi_l_g: date value ... created_at updated_at
3762 2025-05-30 7368.33 ... 2025-05-30 17:50:49.537021 2025-05-30 17:50:49.537413
[1 rows x 5 columns]
2025-05-30 17:50:49,563 - 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-30 17:50:50,179 - IOOppi_data - INFO : save data to db IOOppi_bu_t data:
date value
3093 2025-05-26 3570.00
3094 2025-05-27 3583.33
3095 2025-05-28 3620.00
3096 2025-05-29 3611.67
3097 2025-05-30 3611.67
2025-05-30 17:50:50,251 - IOOppi_data - INFO : save new data to db IOOppi_bu_t: date value ... created_at updated_at
3098 2025-05-30 3611.67 ... 2025-05-30 17:50:50.244368 2025-05-30 17:50:50.244772
[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-30 17:50:50,287 - IOOppi_data - INFO : save diff data to db IOOppi_bu_t: date ... updated_at
2560 2023-12-09 ... 2025-05-30 17:50:50.280322
[1 rows x 6 columns]
2025-05-30 17:50:50,312 - IOOppi_data - INFO : save data to db IOOppi_bu_g data:
date value
3093 2025-05-26 3570.00
3094 2025-05-27 3583.33
3095 2025-05-28 3620.00
3096 2025-05-29 3611.67
3097 2025-05-30 3611.67
2025-05-30 17:50:50,384 - IOOppi_data - INFO : save new data to db IOOppi_bu_g: date value ... created_at updated_at
3100 2025-05-30 3611.67 ... 2025-05-30 17:50:50.377208 2025-05-30 17:50:50.377581
[1 rows x 5 columns]
2025-05-30 17:50:50,402 - 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-30 17:50:51,017 - IOOppi_data - INFO : save data to db IOOppi_al_t data:
date value
3758 2025-05-26 20366.67
3759 2025-05-27 20366.67
3760 2025-05-28 20213.33
3761 2025-05-29 20396.67
3762 2025-05-30 20303.33
2025-05-30 17:50:51,097 - IOOppi_data - INFO : save new data to db IOOppi_al_t: date ... updated_at
3762 2025-05-30 ... 2025-05-30 17:50:51.091523
[1 rows x 5 columns]
2025-05-30 17:50:51,117 - IOOppi_data - INFO : save diff data to db: IOOppi_al_t: no diff data
2025-05-30 17:50:51,122 - IOOppi_data - INFO : save data to db IOOppi_al_g data:
date value
3758 2025-05-26 20366.67
3759 2025-05-27 20366.67
3760 2025-05-28 20213.33
3761 2025-05-29 20396.67
3762 2025-05-30 20303.33
2025-05-30 17:50:51,200 - IOOppi_data - INFO : save new data to db IOOppi_al_g: date ... updated_at
3765 2025-05-30 ... 2025-05-30 17:50:51.194444
[1 rows x 5 columns]
2025-05-30 17:50:51,219 - 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-30 17:50:51,800 - IOOppi_data - INFO : save data to db IOOppi_SM_t data:
date value
2872 2025-05-26 5614.0
2873 2025-05-27 5586.0
2874 2025-05-28 5586.0
2875 2025-05-29 5570.0
2876 2025-05-30 5520.0
2025-05-30 17:50:51,869 - IOOppi_data - INFO : save new data to db IOOppi_SM_t: date value ... created_at updated_at
2876 2025-05-30 5520.0 ... 2025-05-30 17:50:51.861909 2025-05-30 17:50:51.862308
[1 rows x 5 columns]
2025-05-30 17:50:51,888 - IOOppi_data - INFO : save diff data to db: IOOppi_SM_t: no diff data
2025-05-30 17:50:51,894 - IOOppi_data - INFO : save data to db IOOppi_SM_g data:
date value
2872 2025-05-26 5614.0
2873 2025-05-27 5586.0
2874 2025-05-28 5586.0
2875 2025-05-29 5570.0
2876 2025-05-30 5520.0
2025-05-30 17:50:51,962 - IOOppi_data - INFO : save new data to db IOOppi_SM_g: date value ... created_at updated_at
2880 2025-05-30 5520.0 ... 2025-05-30 17:50:51.954694 2025-05-30 17:50:51.955133
[1 rows x 5 columns]
2025-05-30 17:50:51,980 - 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-30 17:50:52,583 - IOOppi_data - INFO : save data to db IOOppi_CY_t data:
date value
2147 2025-05-26 23775.0
2148 2025-05-27 23800.0
2149 2025-05-28 23800.0
2150 2025-05-29 23800.0
2151 2025-05-30 23800.0
2025-05-30 17:50:52,645 - IOOppi_data - INFO : save new data to db IOOppi_CY_t: date value ... created_at updated_at
2151 2025-05-30 23800.0 ... 2025-05-30 17:50:52.637863 2025-05-30 17:50:52.638281
[1 rows x 5 columns]
2025-05-30 17:50:52,664 - IOOppi_data - INFO : save diff data to db: IOOppi_CY_t: no diff data
2025-05-30 17:50:52,669 - IOOppi_data - INFO : save data to db IOOppi_CY_g data:
date value
2147 2025-05-26 23775.0
2148 2025-05-27 23800.0
2149 2025-05-28 23800.0
2150 2025-05-29 23800.0
2151 2025-05-30 23800.0
2025-05-30 17:50:52,733 - IOOppi_data - INFO : save new data to db IOOppi_CY_g: date value ... created_at updated_at
2155 2025-05-30 23800.0 ... 2025-05-30 17:50:52.725716 2025-05-30 17:50:52.726138
[1 rows x 5 columns]
2025-05-30 17:50:52,751 - 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-30 17:50:53,340 - IOOppi_data - INFO : save data to db IOOppi_UR_t data:
date value
1662 2025-05-26 1900.0
1663 2025-05-27 1886.0
1664 2025-05-28 1896.0
1665 2025-05-29 1896.0
1666 2025-05-30 1892.0
2025-05-30 17:50:53,391 - IOOppi_data - INFO : save new data to db IOOppi_UR_t: date value ... created_at updated_at
1666 2025-05-30 1892.0 ... 2025-05-30 17:50:53.383951 2025-05-30 17:50:53.384352
[1 rows x 5 columns]
2025-05-30 17:50:53,411 - IOOppi_data - INFO : save diff data to db: IOOppi_UR_t: no diff data
2025-05-30 17:50:53,416 - IOOppi_data - INFO : save data to db IOOppi_UR_g data:
date value
1662 2025-05-26 1900.0
1663 2025-05-27 1886.0
1664 2025-05-28 1896.0
1665 2025-05-29 1896.0
1666 2025-05-30 1892.0
2025-05-30 17:50:53,465 - IOOppi_data - INFO : save new data to db IOOppi_UR_g: date value ... created_at updated_at
1670 2025-05-30 1892.0 ... 2025-05-30 17:50:53.458496 2025-05-30 17:50:53.458892
[1 rows x 5 columns]
2025-05-30 17:50:53,484 - 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-30 17:50:54,282 - IOOppi_data - INFO : save data to db IOOppi_ni_t data:
date value
2734 2025-05-26 124200.00
2735 2025-05-27 123400.00
2736 2025-05-28 123283.33
2737 2025-05-29 121758.33
2738 2025-05-30 122425.00
2025-05-30 17:50:54,350 - IOOppi_data - INFO : save new data to db IOOppi_ni_t: date ... updated_at
2738 2025-05-30 ... 2025-05-30 17:50:54.344235
[1 rows x 5 columns]
2025-05-30 17:50:54,369 - IOOppi_data - INFO : save diff data to db: IOOppi_ni_t: no diff data
2025-05-30 17:50:54,375 - IOOppi_data - INFO : save data to db IOOppi_ni_g data:
date value
2734 2025-05-26 124200.00
2735 2025-05-27 123400.00
2736 2025-05-28 123283.33
2737 2025-05-29 121758.33
2738 2025-05-30 122425.00
2025-05-30 17:50:54,437 - IOOppi_data - INFO : save new data to db IOOppi_ni_g: date ... updated_at
2741 2025-05-30 ... 2025-05-30 17:50:54.431407
[1 rows x 5 columns]
2025-05-30 17:50:54,455 - 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-30 17:50:55,108 - IOOppi_data - INFO : save data to db IOOppi_v_t data:
date value
3759 2025-05-26 4673.0
3760 2025-05-27 4580.0
3761 2025-05-28 4577.0
3762 2025-05-29 4591.0
3763 2025-05-30 4597.0
2025-05-30 17:50:55,184 - IOOppi_data - INFO : save new data to db IOOppi_v_t: date value ... created_at updated_at
3763 2025-05-30 4597.0 ... 2025-05-30 17:50:55.177496 2025-05-30 17:50:55.177899
[1 rows x 5 columns]
2025-05-30 17:50:55,203 - IOOppi_data - INFO : save diff data to db: IOOppi_v_t: no diff data
2025-05-30 17:50:55,209 - IOOppi_data - INFO : save data to db IOOppi_v_g data:
date value
3759 2025-05-26 4673.0
3760 2025-05-27 4580.0
3761 2025-05-28 4577.0
3762 2025-05-29 4591.0
3763 2025-05-30 4597.0
2025-05-30 17:50:55,286 - IOOppi_data - INFO : save new data to db IOOppi_v_g: date value ... created_at updated_at
3766 2025-05-30 4597.0 ... 2025-05-30 17:50:55.279745 2025-05-30 17:50:55.280155
[1 rows x 5 columns]
2025-05-30 17:50:55,306 - 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-30 17:50:55,998 - IOOppi_data - INFO : save data to db IOOppi_pp_t data:
date value
2998 2025-05-26 7426.67
2999 2025-05-27 7426.67
3000 2025-05-28 7426.67
3001 2025-05-29 7418.33
3002 2025-05-30 7393.33
2025-05-30 17:50:56,067 - IOOppi_data - INFO : save new data to db IOOppi_pp_t: date value ... created_at updated_at
3002 2025-05-30 7393.33 ... 2025-05-30 17:50:56.059017 2025-05-30 17:50:56.059394
[1 rows x 5 columns]
2025-05-30 17:50:56,088 - IOOppi_data - INFO : save diff data to db: IOOppi_pp_t: no diff data
2025-05-30 17:50:56,094 - IOOppi_data - INFO : save data to db IOOppi_pp_g data:
date value
2998 2025-05-26 7426.67
2999 2025-05-27 7426.67
3000 2025-05-28 7426.67
3001 2025-05-29 7418.33
3002 2025-05-30 7393.33
2025-05-30 17:50:56,157 - IOOppi_data - INFO : save new data to db IOOppi_pp_g: date value ... created_at updated_at
3005 2025-05-30 7393.33 ... 2025-05-30 17:50:56.150140 2025-05-30 17:50:56.150506
[1 rows x 5 columns]
2025-05-30 17:50:56,175 - 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-30 17:50:56,771 - IOOppi_data - INFO : save data to db IOOppi_CF_t data:
date value
3760 2025-05-26 14605.00
3761 2025-05-27 14597.17
3762 2025-05-28 14580.67
3763 2025-05-29 14581.67
3764 2025-05-30 14580.33
2025-05-30 17:50:56,848 - IOOppi_data - INFO : save new data to db IOOppi_CF_t: date ... updated_at
3764 2025-05-30 ... 2025-05-30 17:50:56.842232
[1 rows x 5 columns]
2025-05-30 17:50:56,867 - IOOppi_data - INFO : save diff data to db: IOOppi_CF_t: no diff data
2025-05-30 17:50:56,873 - IOOppi_data - INFO : save data to db IOOppi_CF_g data:
date value
3760 2025-05-26 14605.00
3761 2025-05-27 14597.17
3762 2025-05-28 14580.67
3763 2025-05-29 14581.67
3764 2025-05-30 14580.33
2025-05-30 17:50:56,947 - IOOppi_data - INFO : save new data to db IOOppi_CF_g: date ... updated_at
3768 2025-05-30 ... 2025-05-30 17:50:56.941168
[1 rows x 5 columns]
2025-05-30 17:50:56,966 - 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-30 17:50:57,571 - IOOppi_data - INFO : save data to db IOOppi_pb_t data:
date value
3705 2025-05-26 16768.75
3706 2025-05-27 16718.75
3707 2025-05-28 16681.25
3708 2025-05-29 16687.50
3709 2025-05-30 16487.50
2025-05-30 17:50:57,651 - IOOppi_data - INFO : save new data to db IOOppi_pb_t: date value ... created_at updated_at
3709 2025-05-30 16487.5 ... 2025-05-30 17:50:57.644234 2025-05-30 17:50:57.644610
[1 rows x 5 columns]
2025-05-30 17:50:57,670 - IOOppi_data - INFO : save diff data to db: IOOppi_pb_t: no diff data
2025-05-30 17:50:57,675 - IOOppi_data - INFO : save data to db IOOppi_pb_g data:
date value
3705 2025-05-26 16768.75
3706 2025-05-27 16718.75
3707 2025-05-28 16681.25
3708 2025-05-29 16687.50
3709 2025-05-30 16487.50
2025-05-30 17:50:57,752 - IOOppi_data - INFO : save new data to db IOOppi_pb_g: date value ... created_at updated_at
3712 2025-05-30 16487.5 ... 2025-05-30 17:50:57.745678 2025-05-30 17:50:57.746068
[1 rows x 5 columns]
2025-05-30 17:50:57,770 - 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-30 17:50:58,375 - IOOppi_data - INFO : save data to db IOOppi_hc_t data:
date value
2980 2025-05-26 3256.67
2981 2025-05-27 3243.33
2982 2025-05-28 3226.67
2983 2025-05-29 3226.67
2984 2025-05-30 3196.67
2025-05-30 17:50:58,442 - IOOppi_data - INFO : save new data to db IOOppi_hc_t: date value ... created_at updated_at
2984 2025-05-30 3196.67 ... 2025-05-30 17:50:58.435667 2025-05-30 17:50:58.436080
[1 rows x 5 columns]
2025-05-30 17:50:58,463 - IOOppi_data - INFO : save diff data to db: IOOppi_hc_t: no diff data
2025-05-30 17:50:58,469 - IOOppi_data - INFO : save data to db IOOppi_hc_g data:
date value
2980 2025-05-26 3256.67
2981 2025-05-27 3243.33
2982 2025-05-28 3226.67
2983 2025-05-29 3226.67
2984 2025-05-30 3196.67
2025-05-30 17:50:58,540 - IOOppi_data - INFO : save new data to db IOOppi_hc_g: date value ... created_at updated_at
2987 2025-05-30 3196.67 ... 2025-05-30 17:50:58.532940 2025-05-30 17:50:58.533323
[1 rows x 5 columns]
2025-05-30 17:50:58,631 - 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-30 17:50:59,229 - IOOppi_data - INFO : save data to db IOOppi_fu_t data:
date value
3260 2025-05-26 5325.0
3261 2025-05-27 5325.0
3262 2025-05-28 5350.0
3263 2025-05-29 5350.0
3264 2025-05-30 5337.5
2025-05-30 17:50:59,300 - IOOppi_data - INFO : save new data to db IOOppi_fu_t: date value ... created_at updated_at
3264 2025-05-30 5337.5 ... 2025-05-30 17:50:59.293248 2025-05-30 17:50:59.293630
[1 rows x 5 columns]
2025-05-30 17:50:59,319 - IOOppi_data - INFO : save diff data to db: IOOppi_fu_t: no diff data
2025-05-30 17:50:59,325 - IOOppi_data - INFO : save data to db IOOppi_fu_g data:
date value
3260 2025-05-26 5325.0
3261 2025-05-27 5325.0
3262 2025-05-28 5350.0
3263 2025-05-29 5350.0
3264 2025-05-30 5337.5
2025-05-30 17:50:59,402 - IOOppi_data - INFO : save new data to db IOOppi_fu_g: date value ... created_at updated_at
3751 2025-05-30 5337.5 ... 2025-05-30 17:50:59.394743 2025-05-30 17:50:59.395161
[1 rows x 5 columns]
2025-05-30 17:50:59,422 - 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-30 17:51:00,037 - IOOppi_data - INFO : save data to db IOOppi_lh_t data:
date value
1324 2025-05-26 14520.0
1325 2025-05-27 14500.0
1326 2025-05-28 14550.0
1327 2025-05-29 14570.0
1328 2025-05-30 14530.0
2025-05-30 17:51:00,083 - IOOppi_data - INFO : save new data to db IOOppi_lh_t: date value ... created_at updated_at
1328 2025-05-30 14530.0 ... 2025-05-30 17:51:00.076237 2025-05-30 17:51:00.076627
[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-30 17:51:00,342 - IOOppi_data - INFO : save diff data to db IOOppi_lh_t: date ... updated_at
116 2021-07-05 ... 2025-05-30 17:51:00.334835
117 2021-07-06 ... 2025-05-30 17:51:00.334835
121 2021-07-12 ... 2025-05-30 17:51:00.334835
122 2021-07-13 ... 2025-05-30 17:51:00.334835
194 2021-11-01 ... 2025-05-30 17:51:00.334835
[5 rows x 6 columns]
2025-05-30 17:51:00,396 - IOOppi_data - INFO : save data to db IOOppi_lh_g data:
date value
1324 2025-05-26 14520.0
1325 2025-05-27 14500.0
1326 2025-05-28 14550.0
1327 2025-05-29 14570.0
1328 2025-05-30 14530.0
2025-05-30 17:51:00,443 - IOOppi_data - INFO : save new data to db IOOppi_lh_g: date value ... created_at updated_at
1331 2025-05-30 14530.0 ... 2025-05-30 17:51:00.435839 2025-05-30 17:51:00.436233
[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-30 17:51:00,689 - IOOppi_data - INFO : save diff data to db IOOppi_lh_g: date ... updated_at
116 2021-07-05 ... 2025-05-30 17:51:00.680553
117 2021-07-06 ... 2025-05-30 17:51:00.680553
121 2021-07-12 ... 2025-05-30 17:51:00.680553
122 2021-07-13 ... 2025-05-30 17:51:00.680553
194 2021-11-01 ... 2025-05-30 17:51:00.680553
[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-30 17:51:01,302 - IOOppi_data - INFO : save data to db IOOppi_cu_t data:
date value
3756 2025-05-26 78588.33
3757 2025-05-27 78556.67
3758 2025-05-28 78561.67
3759 2025-05-29 78550.00
3760 2025-05-30 78286.67
2025-05-30 17:51:01,380 - IOOppi_data - INFO : save new data to db IOOppi_cu_t: date ... updated_at
3760 2025-05-30 ... 2025-05-30 17:51:01.373794
[1 rows x 5 columns]
2025-05-30 17:51:01,398 - IOOppi_data - INFO : save diff data to db: IOOppi_cu_t: no diff data
2025-05-30 17:51:01,404 - IOOppi_data - INFO : save data to db IOOppi_cu_g data:
date value
3756 2025-05-26 78588.33
3757 2025-05-27 78556.67
3758 2025-05-28 78561.67
3759 2025-05-29 78550.00
3760 2025-05-30 78286.67
2025-05-30 17:51:01,481 - IOOppi_data - INFO : save new data to db IOOppi_cu_g: date ... updated_at
3763 2025-05-30 ... 2025-05-30 17:51:01.475314
[1 rows x 5 columns]
2025-05-30 17:51:01,501 - 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-30 17:51:02,048 - 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-30 17:51:02,103 - IOOppi_data - INFO : save new data to db: IOOppi_PM_t: no new data
2025-05-30 17:51:02,103 - IOOppi_data - INFO : save diff data to db: IOOppi_PM_t: no diff data
2025-05-30 17:51:02,109 - 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-30 17:51:02,172 - IOOppi_data - INFO : save new data to db: IOOppi_PM_g: no new data
2025-05-30 17:51:02,173 - 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-30 17:51:02,805 - IOOppi_data - INFO : save data to db IOOppi_sn_t data:
date value
2734 2025-05-26 264400.0
2735 2025-05-27 264975.0
2736 2025-05-28 265025.0
2737 2025-05-29 260550.0
2738 2025-05-30 251325.0
2025-05-30 17:51:02,873 - IOOppi_data - INFO : save new data to db IOOppi_sn_t: date ... updated_at
2738 2025-05-30 ... 2025-05-30 17:51:02.866493
[1 rows x 5 columns]
2025-05-30 17:51:02,893 - IOOppi_data - INFO : save diff data to db: IOOppi_sn_t: no diff data
2025-05-30 17:51:02,898 - IOOppi_data - INFO : save data to db IOOppi_sn_g data:
date value
2734 2025-05-26 264400.0
2735 2025-05-27 264975.0
2736 2025-05-28 265025.0
2737 2025-05-29 260550.0
2738 2025-05-30 251325.0
2025-05-30 17:51:02,963 - IOOppi_data - INFO : save new data to db IOOppi_sn_g: date ... updated_at
2741 2025-05-30 ... 2025-05-30 17:51:02.957311
[1 rows x 5 columns]
2025-05-30 17:51:02,983 - 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-30 17:51:03,584 - IOOppi_data - INFO : save data to db IOOppi_zn_t data:
date value
3755 2025-05-26 22556.0
3756 2025-05-27 22736.0
3757 2025-05-28 22828.0
3758 2025-05-29 22826.0
3759 2025-05-30 22738.0
2025-05-30 17:51:03,667 - IOOppi_data - INFO : save new data to db IOOppi_zn_t: date value ... created_at updated_at
3759 2025-05-30 22738.0 ... 2025-05-30 17:51:03.659528 2025-05-30 17:51:03.659952
[1 rows x 5 columns]
2025-05-30 17:51:03,685 - IOOppi_data - INFO : save diff data to db: IOOppi_zn_t: no diff data
2025-05-30 17:51:03,691 - IOOppi_data - INFO : save data to db IOOppi_zn_g data:
date value
3755 2025-05-26 22556.0
3756 2025-05-27 22736.0
3757 2025-05-28 22828.0
3758 2025-05-29 22826.0
3759 2025-05-30 22738.0
2025-05-30 17:51:03,767 - IOOppi_data - INFO : save new data to db IOOppi_zn_g: date value ... created_at updated_at
3762 2025-05-30 22738.0 ... 2025-05-30 17:51:03.759933 2025-05-30 17:51:03.760316
[1 rows x 5 columns]
2025-05-30 17:51:03,785 - 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-30 17:51:04,343 - IOOppi_data - INFO : save data to db IOOppi_wr_t data:
date value
3718 2025-05-26 3295.0
3719 2025-05-27 3277.5
3720 2025-05-28 3255.0
3721 2025-05-29 3252.5
3722 2025-05-30 3260.0
2025-05-30 17:51:04,422 - IOOppi_data - INFO : save new data to db IOOppi_wr_t: date value ... created_at updated_at
3722 2025-05-30 3260.0 ... 2025-05-30 17:51:04.415582 2025-05-30 17:51:04.415981
[1 rows x 5 columns]
2025-05-30 17:51:04,441 - IOOppi_data - INFO : save diff data to db: IOOppi_wr_t: no diff data
2025-05-30 17:51:04,446 - IOOppi_data - INFO : save data to db IOOppi_wr_g data:
date value
3718 2025-05-26 3295.0
3719 2025-05-27 3277.5
3720 2025-05-28 3255.0
3721 2025-05-29 3252.5
3722 2025-05-30 3260.0
2025-05-30 17:51:04,524 - IOOppi_data - INFO : save new data to db IOOppi_wr_g: date value ... created_at updated_at
3725 2025-05-30 3260.0 ... 2025-05-30 17:51:04.517164 2025-05-30 17:51:04.517541
[1 rows x 5 columns]
2025-05-30 17:51:04,543 - 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-30 17:51:05,234 - IOOppi_data - INFO : save data to db IOOppi_pg_t data:
date value
1515 2025-05-26 4730.0
1516 2025-05-27 4730.0
1517 2025-05-28 4730.0
1518 2025-05-29 4747.5
1519 2025-05-30 4750.0
2025-05-30 17:51:05,284 - IOOppi_data - INFO : save new data to db IOOppi_pg_t: date value ... created_at updated_at
1519 2025-05-30 4750.0 ... 2025-05-30 17:51:05.277077 2025-05-30 17:51:05.277449
[1 rows x 5 columns]
2025-05-30 17:51:05,302 - IOOppi_data - INFO : save diff data to db: IOOppi_pg_t: no diff data
2025-05-30 17:51:05,307 - IOOppi_data - INFO : save data to db IOOppi_pg_g data:
date value
1515 2025-05-26 4730.0
1516 2025-05-27 4730.0
1517 2025-05-28 4730.0
1518 2025-05-29 4747.5
1519 2025-05-30 4750.0
2025-05-30 17:51:05,354 - IOOppi_data - INFO : save new data to db IOOppi_pg_g: date value ... created_at updated_at
1522 2025-05-30 4750.0 ... 2025-05-30 17:51:05.347222 2025-05-30 17:51:05.347560
[1 rows x 5 columns]
2025-05-30 17:51:05,372 - 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-30 17:51:06,154 - IOOppi_data - INFO : save data to db IOOppi_cs_t data:
date value
2789 2025-05-26 2295.71
2790 2025-05-27 2294.29
2791 2025-05-28 2294.29
2792 2025-05-29 2294.29
2793 2025-05-30 2294.29
2025-05-30 17:51:06,221 - IOOppi_data - INFO : save new data to db IOOppi_cs_t: date value ... created_at updated_at
2793 2025-05-30 2294.29 ... 2025-05-30 17:51:06.214093 2025-05-30 17:51:06.214473
[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-30 17:51:06,262 - IOOppi_data - INFO : save diff data to db IOOppi_cs_t: date ... updated_at
2792 2025-05-29 ... 2025-05-30 17:51:06.255158
[1 rows x 6 columns]
2025-05-30 17:51:06,287 - IOOppi_data - INFO : save data to db IOOppi_cs_g data:
date value
2789 2025-05-26 2295.71
2790 2025-05-27 2294.29
2791 2025-05-28 2294.29
2792 2025-05-29 2294.29
2793 2025-05-30 2294.29
2025-05-30 17:51:06,353 - IOOppi_data - INFO : save new data to db IOOppi_cs_g: date value ... created_at updated_at
2796 2025-05-30 2294.29 ... 2025-05-30 17:51:06.346687 2025-05-30 17:51:06.347132
[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-30 17:51:06,394 - IOOppi_data - INFO : save diff data to db IOOppi_cs_g: date ... updated_at
2795 2025-05-29 ... 2025-05-30 17:51:06.387531
[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-30 17:51:06,967 - IOOppi_data - INFO : save data to db IOOppi_cs_t data:
date value
2789 2025-05-26 2295.71
2790 2025-05-27 2294.29
2791 2025-05-28 2294.29
2792 2025-05-29 2294.29
2793 2025-05-30 2898.00
2025-05-30 17:51:07,022 - 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-30 17:51:07,045 - IOOppi_data - INFO : save diff data to db IOOppi_cs_t: date ... updated_at
2793 2025-05-30 ... 2025-05-30 17:51:07.038084
[1 rows x 6 columns]
2025-05-30 17:51:07,075 - IOOppi_data - INFO : save data to db IOOppi_cs_g data:
date value
2789 2025-05-26 2295.71
2790 2025-05-27 2294.29
2791 2025-05-28 2294.29
2792 2025-05-29 2294.29
2793 2025-05-30 2898.00
2025-05-30 17:51:07,130 - 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-30 17:51:07,154 - IOOppi_data - INFO : save diff data to db IOOppi_cs_g: date ... updated_at
2796 2025-05-30 ... 2025-05-30 17:51:07.146563
[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-30 17:51:07,713 - IOOppi_data - INFO : save data to db IOOppi_RS_t data:
date value
3146 2025-05-26 9493.33
3147 2025-05-27 9545.00
3148 2025-05-28 9525.00
3149 2025-05-29 9530.00
3150 2025-05-30 9456.67
2025-05-30 17:51:07,770 - IOOppi_data - INFO : save new data to db: IOOppi_RS_t: no new data
2025-05-30 17:51:07,770 - IOOppi_data - INFO : save diff data to db: IOOppi_RS_t: no diff data
2025-05-30 17:51:07,775 - IOOppi_data - INFO : save data to db IOOppi_RS_g data:
date value
3146 2025-05-26 9493.33
3147 2025-05-27 9545.00
3148 2025-05-28 9525.00
3149 2025-05-29 9530.00
3150 2025-05-30 9456.67
2025-05-30 17:51:07,834 - IOOppi_data - INFO : save new data to db: IOOppi_RS_g: no new data
2025-05-30 17:51:07,834 - 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-30 17:51:08,398 - IOOppi_data - INFO : save data to db IOOppi_eg_t data:
date value
1830 2025-05-26 4548.33
1831 2025-05-27 4548.33
1832 2025-05-28 4521.67
1833 2025-05-29 4521.67
1834 2025-05-30 4521.67
2025-05-30 17:51:08,447 - IOOppi_data - INFO : save new data to db IOOppi_eg_t: date value ... created_at updated_at
1834 2025-05-30 4521.67 ... 2025-05-30 17:51:08.441016 2025-05-30 17:51:08.441386
[1 rows x 5 columns]
2025-05-30 17:51:08,466 - IOOppi_data - INFO : save diff data to db: IOOppi_eg_t: no diff data
2025-05-30 17:51:08,472 - IOOppi_data - INFO : save data to db IOOppi_eg_g data:
date value
1830 2025-05-26 4548.33
1831 2025-05-27 4548.33
1832 2025-05-28 4521.67
1833 2025-05-29 4521.67
1834 2025-05-30 4521.67
2025-05-30 17:51:08,521 - IOOppi_data - INFO : save new data to db IOOppi_eg_g: date value ... created_at updated_at
1837 2025-05-30 4521.67 ... 2025-05-30 17:51:08.514960 2025-05-30 17:51:08.515335
[1 rows x 5 columns]
2025-05-30 17:51:08,541 - 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-30 17:51:09,069 - IOOppi_data - INFO : save data to db IOOppi_sp_t data:
date value
1839 2025-05-26 6300.00
1840 2025-05-27 6266.67
1841 2025-05-28 6266.67
1842 2025-05-29 6250.00
1843 2025-05-30 6216.67
2025-05-30 17:51:09,119 - IOOppi_data - INFO : save new data to db IOOppi_sp_t: date value ... created_at updated_at
1843 2025-05-30 6216.67 ... 2025-05-30 17:51:09.110815 2025-05-30 17:51:09.111411
[1 rows x 5 columns]
2025-05-30 17:51:09,139 - IOOppi_data - INFO : save diff data to db: IOOppi_sp_t: no diff data
2025-05-30 17:51:09,144 - IOOppi_data - INFO : save data to db IOOppi_sp_g data:
date value
1839 2025-05-26 6300.00
1840 2025-05-27 6266.67
1841 2025-05-28 6266.67
1842 2025-05-29 6250.00
1843 2025-05-30 6216.67
2025-05-30 17:51:09,196 - IOOppi_data - INFO : save new data to db IOOppi_sp_g: date value ... created_at updated_at
1846 2025-05-30 6216.67 ... 2025-05-30 17:51:09.189081 2025-05-30 17:51:09.189464
[1 rows x 5 columns]
2025-05-30 17:51:09,215 - 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-30 17:51:09,901 - IOOppi_data - INFO : save data to db IOOppi_p_t data:
date value
3507 2025-05-26 8468.0
3508 2025-05-27 8488.0
3509 2025-05-28 8572.0
3510 2025-05-29 8652.0
3511 2025-05-30 8652.0
2025-05-30 17:51:09,978 - IOOppi_data - INFO : save new data to db IOOppi_p_t: date value ... created_at updated_at
3511 2025-05-30 8652.0 ... 2025-05-30 17:51:09.971263 2025-05-30 17:51:09.971647
[1 rows x 5 columns]
2025-05-30 17:51:09,997 - IOOppi_data - INFO : save diff data to db: IOOppi_p_t: no diff data
2025-05-30 17:51:10,003 - IOOppi_data - INFO : save data to db IOOppi_p_g data:
date value
3507 2025-05-26 8468.0
3508 2025-05-27 8488.0
3509 2025-05-28 8572.0
3510 2025-05-29 8652.0
3511 2025-05-30 8652.0
2025-05-30 17:51:10,075 - IOOppi_data - INFO : save new data to db IOOppi_p_g: date value ... created_at updated_at
3514 2025-05-30 8652.0 ... 2025-05-30 17:51:10.068869 2025-05-30 17:51:10.069249
[1 rows x 5 columns]
2025-05-30 17:51:10,094 - IOOppi_data - INFO : save diff data to db: IOOppi_p_g: no diff data