=========================================================================
2025-05-27 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-27 17:50:28,848 - IOOppi_data - INFO : save data to db IOOppi_rb_t data:
date value
3312 2025-05-23 3138.56
3313 2025-05-24 3138.56
3314 2025-05-25 3138.56
3315 2025-05-26 3115.67
3316 2025-05-27 3077.11
2025-05-27 17:50:28,920 - IOOppi_data - INFO : save new data to db IOOppi_rb_t: date value ... created_at updated_at
3316 2025-05-27 3077.11 ... 2025-05-27 17:50:28.912826 2025-05-27 17:50:28.913235
[1 rows x 5 columns]
2025-05-27 17:50:28,947 - IOOppi_data - INFO : save diff data to db: IOOppi_rb_t: no diff data
2025-05-27 17:50:28,953 - IOOppi_data - INFO : save data to db IOOppi_rb_g data:
date value
3312 2025-05-23 3138.56
3313 2025-05-24 3138.56
3314 2025-05-25 3138.56
3315 2025-05-26 3115.67
3316 2025-05-27 3077.11
2025-05-27 17:50:29,020 - IOOppi_data - INFO : save new data to db IOOppi_rb_g: date value ... created_at updated_at
3319 2025-05-27 3077.11 ... 2025-05-27 17:50:29.013357 2025-05-27 17:50:29.013735
[1 rows x 5 columns]
2025-05-27 17:50:29,041 - 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-27 17:50:29,640 - IOOppi_data - INFO : save data to db IOOppi_MA_t data:
date value
3533 2025-05-23 2300.00
3534 2025-05-24 2300.00
3535 2025-05-25 2300.00
3536 2025-05-26 2300.00
3537 2025-05-27 2253.75
2025-05-27 17:50:29,709 - IOOppi_data - INFO : save new data to db IOOppi_MA_t: date value ... created_at updated_at
3537 2025-05-27 2253.75 ... 2025-05-27 17:50:29.702247 2025-05-27 17:50:29.702635
[1 rows x 5 columns]
2025-05-27 17:50:29,729 - IOOppi_data - INFO : save diff data to db: IOOppi_MA_t: no diff data
2025-05-27 17:50:29,735 - IOOppi_data - INFO : save data to db IOOppi_MA_g data:
date value
3533 2025-05-23 2300.00
3534 2025-05-24 2300.00
3535 2025-05-25 2300.00
3536 2025-05-26 2300.00
3537 2025-05-27 2253.75
2025-05-27 17:50:29,804 - IOOppi_data - INFO : save new data to db IOOppi_MA_g: date value ... created_at updated_at
3541 2025-05-27 2253.75 ... 2025-05-27 17:50:29.797230 2025-05-27 17:50:29.797612
[1 rows x 5 columns]
2025-05-27 17:50:29,825 - 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-27 17:50:30,354 - IOOppi_data - INFO : save data to db IOOppi_PTA_t data:
date value
873 2025-05-23 4915.00
874 2025-05-24 4915.00
875 2025-05-25 4915.00
876 2025-05-26 4917.50
877 2025-05-27 4938.75
2025-05-27 17:50:30,390 - IOOppi_data - INFO : save new data to db IOOppi_PTA_t: date value ... created_at updated_at
877 2025-05-27 4938.75 ... 2025-05-27 17:50:30.383707 2025-05-27 17:50:30.384115
[1 rows x 5 columns]
2025-05-27 17:50:30,410 - IOOppi_data - INFO : save diff data to db: IOOppi_PTA_t: no diff data
2025-05-27 17:50:30,415 - IOOppi_data - INFO : save data to db IOOppi_PTA_g data:
date value
873 2025-05-23 4915.00
874 2025-05-24 4915.00
875 2025-05-25 4915.00
876 2025-05-26 4917.50
877 2025-05-27 4938.75
2025-05-27 17:50:30,450 - IOOppi_data - INFO : save new data to db IOOppi_PTA_g: date value ... created_at updated_at
877 2025-05-27 4938.75 ... 2025-05-27 17:50:30.443528 2025-05-27 17:50:30.443918
[1 rows x 5 columns]
2025-05-27 17:50:30,469 - 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-27 17:50:31,015 - IOOppi_data - INFO : save data to db IOOppi_ru_t data:
date value
3752 2025-05-23 14308.33
3753 2025-05-24 14308.33
3754 2025-05-25 14308.33
3755 2025-05-26 14158.33
3756 2025-05-27 14258.33
2025-05-27 17:50:31,086 - IOOppi_data - INFO : save new data to db IOOppi_ru_t: date ... updated_at
3756 2025-05-27 ... 2025-05-27 17:50:31.079724
[1 rows x 5 columns]
2025-05-27 17:50:31,106 - IOOppi_data - INFO : save diff data to db: IOOppi_ru_t: no diff data
2025-05-27 17:50:31,111 - IOOppi_data - INFO : save data to db IOOppi_ru_g data:
date value
3752 2025-05-23 14308.33
3753 2025-05-24 14308.33
3754 2025-05-25 14308.33
3755 2025-05-26 14158.33
3756 2025-05-27 14258.33
2025-05-27 17:50:31,188 - IOOppi_data - INFO : save new data to db IOOppi_ru_g: date ... updated_at
3759 2025-05-27 ... 2025-05-27 17:50:31.182448
[1 rows x 5 columns]
2025-05-27 17:50:31,209 - 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-27 17:50:31,960 - IOOppi_data - INFO : save data to db IOOppi_i_t data:
date value
3084 2025-05-23 777.56
3085 2025-05-24 777.56
3086 2025-05-25 772.56
3087 2025-05-26 769.67
3088 2025-05-27 757.33
2025-05-27 17:50:32,022 - IOOppi_data - INFO : save new data to db IOOppi_i_t: date value ... created_at updated_at
3088 2025-05-27 757.33 ... 2025-05-27 17:50:32.015469 2025-05-27 17:50:32.015870
[1 rows x 5 columns]
2025-05-27 17:50:32,042 - IOOppi_data - INFO : save diff data to db: IOOppi_i_t: no diff data
2025-05-27 17:50:32,048 - IOOppi_data - INFO : save data to db IOOppi_i_g data:
date value
3084 2025-05-23 777.56
3085 2025-05-24 777.56
3086 2025-05-25 772.56
3087 2025-05-26 769.67
3088 2025-05-27 757.33
2025-05-27 17:50:32,113 - IOOppi_data - INFO : save new data to db IOOppi_i_g: date value ... created_at updated_at
3091 2025-05-27 757.33 ... 2025-05-27 17:50:32.104194 2025-05-27 17:50:32.104587
[1 rows x 5 columns]
2025-05-27 17:50:32,133 - 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-27 17:50:32,640 - IOOppi_data - INFO : save data to db IOOppi_FG_t data:
date value
3287 2025-05-23 1152.0
3288 2025-05-24 1152.0
3289 2025-05-25 1152.0
3290 2025-05-26 1152.0
3291 2025-05-27 1152.0
2025-05-27 17:50:32,705 - IOOppi_data - INFO : save new data to db IOOppi_FG_t: date value ... created_at updated_at
3291 2025-05-27 1152.0 ... 2025-05-27 17:50:32.698137 2025-05-27 17:50:32.698548
[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-27 17:50:34,815 - IOOppi_data - INFO : save diff data to db IOOppi_FG_t: date ... updated_at
12 2012-12-19 ... 2025-05-27 17:50:34.807699
21 2013-01-04 ... 2025-05-27 17:50:34.807699
54 2013-02-27 ... 2025-05-27 17:50:34.807699
60 2013-03-07 ... 2025-05-27 17:50:34.807699
61 2013-03-08 ... 2025-05-27 17:50:34.807699
[5 rows x 6 columns]
2025-05-27 17:50:34,981 - IOOppi_data - INFO : save data to db IOOppi_FG_g data:
date value
3287 2025-05-23 1152.0
3288 2025-05-24 1152.0
3289 2025-05-25 1152.0
3290 2025-05-26 1152.0
3291 2025-05-27 1152.0
2025-05-27 17:50:35,052 - IOOppi_data - INFO : save new data to db IOOppi_FG_g: date value ... created_at updated_at
3295 2025-05-27 1152.0 ... 2025-05-27 17:50:35.044911 2025-05-27 17:50:35.045312
[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-27 17:50:37,127 - IOOppi_data - INFO : save diff data to db IOOppi_FG_g: date ... updated_at
12 2012-12-19 ... 2025-05-27 17:50:37.119062
21 2013-01-04 ... 2025-05-27 17:50:37.119062
54 2013-02-27 ... 2025-05-27 17:50:37.119062
60 2013-03-07 ... 2025-05-27 17:50:37.119062
61 2013-03-08 ... 2025-05-27 17:50:37.119062
[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-27 17:50:38,024 - IOOppi_data - INFO : save data to db IOOppi_eb_t data:
date value
1632 2025-05-23 8130.0
1633 2025-05-24 8130.0
1634 2025-05-25 8130.0
1635 2025-05-26 8110.0
1636 2025-05-27 8110.0
2025-05-27 17:50:38,071 - IOOppi_data - INFO : save new data to db IOOppi_eb_t: date value ... created_at updated_at
1636 2025-05-27 8110.0 ... 2025-05-27 17:50:38.063839 2025-05-27 17:50:38.064238
[1 rows x 5 columns]
2025-05-27 17:50:38,090 - IOOppi_data - INFO : save diff data to db: IOOppi_eb_t: no diff data
2025-05-27 17:50:38,096 - IOOppi_data - INFO : save data to db IOOppi_eb_g data:
date value
1632 2025-05-23 8130.0
1633 2025-05-24 8130.0
1634 2025-05-25 8130.0
1635 2025-05-26 8110.0
1636 2025-05-27 8110.0
2025-05-27 17:50:38,141 - IOOppi_data - INFO : save new data to db IOOppi_eb_g: date value ... created_at updated_at
1639 2025-05-27 8110.0 ... 2025-05-27 17:50:38.134805 2025-05-27 17:50:38.135188
[1 rows x 5 columns]
2025-05-27 17:50:38,162 - 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-27 17:50:38,707 - IOOppi_data - INFO : save data to db IOOppi_SR_t data:
date value
3743 2025-05-23 6145.0
3744 2025-05-24 6145.0
3745 2025-05-25 6145.0
3746 2025-05-26 6145.0
3747 2025-05-27 6145.0
2025-05-27 17:50:38,778 - IOOppi_data - INFO : save new data to db IOOppi_SR_t: date value ... created_at updated_at
3747 2025-05-27 6145.0 ... 2025-05-27 17:50:38.771108 2025-05-27 17:50:38.771491
[1 rows x 5 columns]
2025-05-27 17:50:38,797 - IOOppi_data - INFO : save diff data to db: IOOppi_SR_t: no diff data
2025-05-27 17:50:38,803 - IOOppi_data - INFO : save data to db IOOppi_SR_g data:
date value
3743 2025-05-23 6145.0
3744 2025-05-24 6145.0
3745 2025-05-25 6145.0
3746 2025-05-26 6145.0
3747 2025-05-27 6145.0
2025-05-27 17:50:38,875 - IOOppi_data - INFO : save new data to db IOOppi_SR_g: date value ... created_at updated_at
3751 2025-05-27 6145.0 ... 2025-05-27 17:50:38.867859 2025-05-27 17:50:38.868233
[1 rows x 5 columns]
2025-05-27 17:50:38,896 - 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-27 17:50:39,407 - IOOppi_data - INFO : save data to db IOOppi_ss_t data:
date value
1633 2025-05-23 13225.0
1634 2025-05-24 13225.0
1635 2025-05-25 13225.0
1636 2025-05-26 13225.0
1637 2025-05-27 13225.0
2025-05-27 17:50:39,453 - IOOppi_data - INFO : save new data to db IOOppi_ss_t: date value ... created_at updated_at
1637 2025-05-27 13225.0 ... 2025-05-27 17:50:39.446028 2025-05-27 17:50:39.446414
[1 rows x 5 columns]
2025-05-27 17:50:39,473 - IOOppi_data - INFO : save diff data to db: IOOppi_ss_t: no diff data
2025-05-27 17:50:39,479 - IOOppi_data - INFO : save data to db IOOppi_ss_g data:
date value
1633 2025-05-23 13225.0
1634 2025-05-24 13225.0
1635 2025-05-25 13225.0
1636 2025-05-26 13225.0
1637 2025-05-27 13225.0
2025-05-27 17:50:39,525 - IOOppi_data - INFO : save new data to db IOOppi_ss_g: date value ... created_at updated_at
1640 2025-05-27 13225.0 ... 2025-05-27 17:50:39.518322 2025-05-27 17:50:39.518698
[1 rows x 5 columns]
2025-05-27 17:50:39,545 - 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-27 17:50:40,101 - IOOppi_data - INFO : save data to db IOOppi_RS_t data:
date value
3143 2025-05-23 9513.33
3144 2025-05-24 9513.33
3145 2025-05-25 9513.33
3146 2025-05-26 9493.33
3147 2025-05-27 9545.00
2025-05-27 17:50:40,165 - IOOppi_data - INFO : save new data to db IOOppi_RS_t: date value ... created_at updated_at
3147 2025-05-27 9545.0 ... 2025-05-27 17:50:40.158933 2025-05-27 17:50:40.159312
[1 rows x 5 columns]
2025-05-27 17:50:40,186 - IOOppi_data - INFO : save diff data to db: IOOppi_RS_t: no diff data
2025-05-27 17:50:40,191 - IOOppi_data - INFO : save data to db IOOppi_RS_g data:
date value
3143 2025-05-23 9513.33
3144 2025-05-24 9513.33
3145 2025-05-25 9513.33
3146 2025-05-26 9493.33
3147 2025-05-27 9545.00
2025-05-27 17:50:40,256 - IOOppi_data - INFO : save new data to db IOOppi_RS_g: date value ... created_at updated_at
3151 2025-05-27 9545.0 ... 2025-05-27 17:50:40.249295 2025-05-27 17:50:40.249667
[1 rows x 5 columns]
2025-05-27 17:50:40,275 - 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-27 17:50:40,809 - IOOppi_data - INFO : save data to db IOOppi_RM_t data:
date value
3266 2025-05-23 2521.67
3267 2025-05-24 2521.67
3268 2025-05-25 2521.67
3269 2025-05-26 2515.00
3270 2025-05-27 2543.33
2025-05-27 17:50:40,908 - IOOppi_data - INFO : save new data to db IOOppi_RM_t: date value ... created_at updated_at
3270 2025-05-27 2543.33 ... 2025-05-27 17:50:40.898299 2025-05-27 17:50:40.898815
[1 rows x 5 columns]
2025-05-27 17:50:40,929 - IOOppi_data - INFO : save diff data to db: IOOppi_RM_t: no diff data
2025-05-27 17:50:40,935 - IOOppi_data - INFO : save data to db IOOppi_RM_g data:
date value
3266 2025-05-23 2521.67
3267 2025-05-24 2521.67
3268 2025-05-25 2521.67
3269 2025-05-26 2515.00
3270 2025-05-27 2543.33
2025-05-27 17:50:41,000 - IOOppi_data - INFO : save new data to db IOOppi_RM_g: date value ... created_at updated_at
3274 2025-05-27 2543.33 ... 2025-05-27 17:50:40.993040 2025-05-27 17:50:40.993416
[1 rows x 5 columns]
2025-05-27 17:50:41,020 - 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-27 17:50:41,499 - IOOppi_data - INFO : save data to db IOOppi_SA_t data:
date value
1470 2025-05-23 1462.5
1471 2025-05-24 1462.5
1472 2025-05-25 1462.5
1473 2025-05-26 1462.5
1474 2025-05-27 1450.0
2025-05-27 17:50:41,543 - IOOppi_data - INFO : save new data to db IOOppi_SA_t: date value ... created_at updated_at
1474 2025-05-27 1450.0 ... 2025-05-27 17:50:41.536411 2025-05-27 17:50:41.536814
[1 rows x 5 columns]
2025-05-27 17:50:41,564 - IOOppi_data - INFO : save diff data to db: IOOppi_SA_t: no diff data
2025-05-27 17:50:41,569 - IOOppi_data - INFO : save data to db IOOppi_SA_g data:
date value
1470 2025-05-23 1462.5
1471 2025-05-24 1462.5
1472 2025-05-25 1462.5
1473 2025-05-26 1462.5
1474 2025-05-27 1450.0
2025-05-27 17:50:41,613 - IOOppi_data - INFO : save new data to db IOOppi_SA_g: date value ... created_at updated_at
1478 2025-05-27 1450.0 ... 2025-05-27 17:50:41.605930 2025-05-27 17:50:41.606305
[1 rows x 5 columns]
2025-05-27 17:50:41,654 - 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-27 17:50:42,171 - IOOppi_data - INFO : save data to db IOOppi_PF_t data:
date value
1383 2025-05-23 6597.08
1384 2025-05-24 6597.08
1385 2025-05-25 6597.08
1386 2025-05-26 6572.50
1387 2025-05-27 6545.21
2025-05-27 17:50:42,213 - IOOppi_data - INFO : save new data to db IOOppi_PF_t: date value ... created_at updated_at
1387 2025-05-27 6545.21 ... 2025-05-27 17:50:42.206274 2025-05-27 17:50:42.206649
[1 rows x 5 columns]
2025-05-27 17:50:42,234 - IOOppi_data - INFO : save diff data to db: IOOppi_PF_t: no diff data
2025-05-27 17:50:42,239 - IOOppi_data - INFO : save data to db IOOppi_PF_g data:
date value
1383 2025-05-23 6597.08
1384 2025-05-24 6597.08
1385 2025-05-25 6597.08
1386 2025-05-26 6572.50
1387 2025-05-27 6545.21
2025-05-27 17:50:42,281 - IOOppi_data - INFO : save new data to db IOOppi_PF_g: date value ... created_at updated_at
1391 2025-05-27 6545.21 ... 2025-05-27 17:50:42.274252 2025-05-27 17:50:42.274598
[1 rows x 5 columns]
2025-05-27 17:50:42,302 - 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-27 17:50:42,849 - IOOppi_data - INFO : save data to db IOOppi_m_t data:
date value
3756 2025-05-23 3024.0
3757 2025-05-24 3024.0
3758 2025-05-25 3024.0
3759 2025-05-26 2982.0
3760 2025-05-27 2962.0
2025-05-27 17:50:42,920 - IOOppi_data - INFO : save new data to db IOOppi_m_t: date value ... created_at updated_at
3760 2025-05-27 2962.0 ... 2025-05-27 17:50:42.913251 2025-05-27 17:50:42.913630
[1 rows x 5 columns]
2025-05-27 17:50:42,941 - IOOppi_data - INFO : save diff data to db: IOOppi_m_t: no diff data
2025-05-27 17:50:42,947 - IOOppi_data - INFO : save data to db IOOppi_m_g data:
date value
3756 2025-05-23 3024.0
3757 2025-05-24 3024.0
3758 2025-05-25 3024.0
3759 2025-05-26 2982.0
3760 2025-05-27 2962.0
2025-05-27 17:50:43,018 - IOOppi_data - INFO : save new data to db IOOppi_m_g: date value ... created_at updated_at
3763 2025-05-27 2962.0 ... 2025-05-27 17:50:43.011495 2025-05-27 17:50:43.011892
[1 rows x 5 columns]
2025-05-27 17:50:43,037 - 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-27 17:50:43,615 - IOOppi_data - INFO : save data to db IOOppi_y_t data:
date value
3526 2025-05-23 8034.0
3527 2025-05-24 8034.0
3528 2025-05-25 8034.0
3529 2025-05-26 7964.0
3530 2025-05-27 7994.0
2025-05-27 17:50:43,684 - IOOppi_data - INFO : save new data to db IOOppi_y_t: date value ... created_at updated_at
3530 2025-05-27 7994.0 ... 2025-05-27 17:50:43.676896 2025-05-27 17:50:43.677286
[1 rows x 5 columns]
2025-05-27 17:50:43,704 - IOOppi_data - INFO : save diff data to db: IOOppi_y_t: no diff data
2025-05-27 17:50:43,709 - IOOppi_data - INFO : save data to db IOOppi_y_g data:
date value
3526 2025-05-23 8034.0
3527 2025-05-24 8034.0
3528 2025-05-25 8034.0
3529 2025-05-26 7964.0
3530 2025-05-27 7994.0
2025-05-27 17:50:43,779 - IOOppi_data - INFO : save new data to db IOOppi_y_g: date value ... created_at updated_at
3533 2025-05-27 7994.0 ... 2025-05-27 17:50:43.771827 2025-05-27 17:50:43.772212
[1 rows x 5 columns]
2025-05-27 17:50:43,799 - 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-27 17:50:44,341 - IOOppi_data - INFO : save data to db IOOppi_a_t data:
date value
3492 2025-05-23 4255.0
3493 2025-05-24 4255.0
3494 2025-05-25 4255.0
3495 2025-05-26 4255.0
3496 2025-05-27 4255.0
2025-05-27 17:50:44,408 - IOOppi_data - INFO : save new data to db IOOppi_a_t: date value ... created_at updated_at
3496 2025-05-27 4255.0 ... 2025-05-27 17:50:44.401599 2025-05-27 17:50:44.402008
[1 rows x 5 columns]
2025-05-27 17:50:44,429 - IOOppi_data - INFO : save diff data to db: IOOppi_a_t: no diff data
2025-05-27 17:50:44,434 - IOOppi_data - INFO : save data to db IOOppi_a_g data:
date value
3492 2025-05-23 4255.0
3493 2025-05-24 4255.0
3494 2025-05-25 4255.0
3495 2025-05-26 4255.0
3496 2025-05-27 4255.0
2025-05-27 17:50:44,508 - IOOppi_data - INFO : save new data to db IOOppi_a_g: date value ... created_at updated_at
3499 2025-05-27 4255.0 ... 2025-05-27 17:50:44.500234 2025-05-27 17:50:44.500875
[1 rows x 5 columns]
2025-05-27 17:50:44,527 - 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-27 17:50:45,119 - IOOppi_data - INFO : save data to db IOOppi_SF_t data:
date value
2869 2025-05-23 5387.14
2870 2025-05-24 5387.14
2871 2025-05-25 5387.14
2872 2025-05-26 5380.00
2873 2025-05-27 5380.00
2025-05-27 17:50:45,179 - IOOppi_data - INFO : save new data to db IOOppi_SF_t: date value ... created_at updated_at
2873 2025-05-27 5380.0 ... 2025-05-27 17:50:45.172639 2025-05-27 17:50:45.173052
[1 rows x 5 columns]
2025-05-27 17:50:45,200 - IOOppi_data - INFO : save diff data to db: IOOppi_SF_t: no diff data
2025-05-27 17:50:45,205 - IOOppi_data - INFO : save data to db IOOppi_SF_g data:
date value
2869 2025-05-23 5387.14
2870 2025-05-24 5387.14
2871 2025-05-25 5387.14
2872 2025-05-26 5380.00
2873 2025-05-27 5380.00
2025-05-27 17:50:45,286 - IOOppi_data - INFO : save new data to db IOOppi_SF_g: date value ... created_at updated_at
2877 2025-05-27 5380.0 ... 2025-05-27 17:50:45.278002 2025-05-27 17:50:45.278605
[1 rows x 5 columns]
2025-05-27 17:50:45,307 - 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-27 17:50:45,914 - IOOppi_data - INFO : save data to db IOOppi_jd_t data:
date value
3069 2025-05-23 3075.0
3070 2025-05-24 3075.0
3071 2025-05-25 3075.0
3072 2025-05-26 3050.0
3073 2025-05-27 3040.0
2025-05-27 17:50:45,978 - IOOppi_data - INFO : save new data to db IOOppi_jd_t: date value ... created_at updated_at
3073 2025-05-27 3040.0 ... 2025-05-27 17:50:45.971237 2025-05-27 17:50:45.971613
[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-27 17:50:46,138 - IOOppi_data - INFO : save diff data to db IOOppi_jd_t: date ... updated_at
39 2014-01-03 ... 2025-05-27 17:50:46.130364
458 2015-09-21 ... 2025-05-27 17:50:46.130364
549 2016-02-03 ... 2025-05-27 17:50:46.130364
693 2016-09-05 ... 2025-05-27 17:50:46.130364
696 2016-09-08 ... 2025-05-27 17:50:46.130364
[5 rows x 6 columns]
2025-05-27 17:50:46,168 - IOOppi_data - INFO : save data to db IOOppi_jd_g data:
date value
3069 2025-05-23 3075.0
3070 2025-05-24 3075.0
3071 2025-05-25 3075.0
3072 2025-05-26 3050.0
3073 2025-05-27 3040.0
2025-05-27 17:50:46,232 - IOOppi_data - INFO : save new data to db IOOppi_jd_g: date value ... created_at updated_at
3076 2025-05-27 3040.0 ... 2025-05-27 17:50:46.225004 2025-05-27 17:50:46.225383
[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-27 17:50:46,391 - IOOppi_data - INFO : save diff data to db IOOppi_jd_g: date ... updated_at
39 2014-01-03 ... 2025-05-27 17:50:46.383428
458 2015-09-21 ... 2025-05-27 17:50:46.383428
549 2016-02-03 ... 2025-05-27 17:50:46.383428
693 2016-09-05 ... 2025-05-27 17:50:46.383428
696 2016-09-08 ... 2025-05-27 17:50:46.383428
[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-27 17:50:46,971 - IOOppi_data - INFO : save data to db IOOppi_SI_t data:
date value
873 2025-05-23 9180.0
874 2025-05-24 9180.0
875 2025-05-25 9180.0
876 2025-05-26 9180.0
877 2025-05-27 9000.0
2025-05-27 17:50:47,006 - IOOppi_data - INFO : save new data to db IOOppi_SI_t: date value ... created_at updated_at
877 2025-05-27 9000.0 ... 2025-05-27 17:50:46.999638 2025-05-27 17:50:47.000043
[1 rows x 5 columns]
2025-05-27 17:50:47,026 - IOOppi_data - INFO : save diff data to db: IOOppi_SI_t: no diff data
2025-05-27 17:50:47,031 - IOOppi_data - INFO : save data to db IOOppi_SI_g data:
date value
873 2025-05-23 9180.0
874 2025-05-24 9180.0
875 2025-05-25 9180.0
876 2025-05-26 9180.0
877 2025-05-27 9000.0
2025-05-27 17:50:47,067 - IOOppi_data - INFO : save new data to db IOOppi_SI_g: date value ... created_at updated_at
877 2025-05-27 9000.0 ... 2025-05-27 17:50:47.059915 2025-05-27 17:50:47.060279
[1 rows x 5 columns]
2025-05-27 17:50:47,088 - 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-27 17:50:47,865 - IOOppi_data - INFO : save data to db IOOppi_l_t data:
date value
3752 2025-05-23 7558.33
3753 2025-05-24 7558.33
3754 2025-05-25 7558.33
3755 2025-05-26 7496.67
3756 2025-05-27 7451.67
2025-05-27 17:50:47,937 - IOOppi_data - INFO : save new data to db IOOppi_l_t: date value ... created_at updated_at
3756 2025-05-27 7451.67 ... 2025-05-27 17:50:47.930267 2025-05-27 17:50:47.930650
[1 rows x 5 columns]
2025-05-27 17:50:47,958 - IOOppi_data - INFO : save diff data to db: IOOppi_l_t: no diff data
2025-05-27 17:50:47,964 - IOOppi_data - INFO : save data to db IOOppi_l_g data:
date value
3752 2025-05-23 7558.33
3753 2025-05-24 7558.33
3754 2025-05-25 7558.33
3755 2025-05-26 7496.67
3756 2025-05-27 7451.67
2025-05-27 17:50:48,036 - IOOppi_data - INFO : save new data to db IOOppi_l_g: date value ... created_at updated_at
3759 2025-05-27 7451.67 ... 2025-05-27 17:50:48.029324 2025-05-27 17:50:48.029704
[1 rows x 5 columns]
2025-05-27 17:50:48,055 - 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-27 17:50:48,588 - IOOppi_data - INFO : save data to db IOOppi_bu_t data:
date value
3090 2025-05-23 3570.00
3091 2025-05-24 3570.00
3092 2025-05-25 3570.00
3093 2025-05-26 3570.00
3094 2025-05-27 3583.33
2025-05-27 17:50:48,653 - IOOppi_data - INFO : save new data to db IOOppi_bu_t: date value ... created_at updated_at
3095 2025-05-27 3583.33 ... 2025-05-27 17:50:48.646619 2025-05-27 17:50:48.647049
[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-27 17:50:48,691 - IOOppi_data - INFO : save diff data to db IOOppi_bu_t: date ... updated_at
2560 2023-12-09 ... 2025-05-27 17:50:48.684523
[1 rows x 6 columns]
2025-05-27 17:50:48,716 - IOOppi_data - INFO : save data to db IOOppi_bu_g data:
date value
3090 2025-05-23 3570.00
3091 2025-05-24 3570.00
3092 2025-05-25 3570.00
3093 2025-05-26 3570.00
3094 2025-05-27 3583.33
2025-05-27 17:50:48,778 - IOOppi_data - INFO : save new data to db IOOppi_bu_g: date value ... created_at updated_at
3097 2025-05-27 3583.33 ... 2025-05-27 17:50:48.772020 2025-05-27 17:50:48.772385
[1 rows x 5 columns]
2025-05-27 17:50:48,798 - 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-27 17:50:49,374 - IOOppi_data - INFO : save data to db IOOppi_al_t data:
date value
3755 2025-05-23 20390.00
3756 2025-05-24 20390.00
3757 2025-05-25 20390.00
3758 2025-05-26 20366.67
3759 2025-05-27 20366.67
2025-05-27 17:50:49,445 - IOOppi_data - INFO : save new data to db IOOppi_al_t: date ... updated_at
3759 2025-05-27 ... 2025-05-27 17:50:49.439530
[1 rows x 5 columns]
2025-05-27 17:50:49,466 - IOOppi_data - INFO : save diff data to db: IOOppi_al_t: no diff data
2025-05-27 17:50:49,471 - IOOppi_data - INFO : save data to db IOOppi_al_g data:
date value
3755 2025-05-23 20390.00
3756 2025-05-24 20390.00
3757 2025-05-25 20390.00
3758 2025-05-26 20366.67
3759 2025-05-27 20366.67
2025-05-27 17:50:49,543 - IOOppi_data - INFO : save new data to db IOOppi_al_g: date ... updated_at
3762 2025-05-27 ... 2025-05-27 17:50:49.537216
[1 rows x 5 columns]
2025-05-27 17:50:49,563 - 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-27 17:50:50,128 - IOOppi_data - INFO : save data to db IOOppi_SM_t data:
date value
2869 2025-05-23 5642.0
2870 2025-05-24 5642.0
2871 2025-05-25 5642.0
2872 2025-05-26 5614.0
2873 2025-05-27 5586.0
2025-05-27 17:50:50,189 - IOOppi_data - INFO : save new data to db IOOppi_SM_t: date value ... created_at updated_at
2873 2025-05-27 5586.0 ... 2025-05-27 17:50:50.181952 2025-05-27 17:50:50.182338
[1 rows x 5 columns]
2025-05-27 17:50:50,209 - IOOppi_data - INFO : save diff data to db: IOOppi_SM_t: no diff data
2025-05-27 17:50:50,214 - IOOppi_data - INFO : save data to db IOOppi_SM_g data:
date value
2869 2025-05-23 5642.0
2870 2025-05-24 5642.0
2871 2025-05-25 5642.0
2872 2025-05-26 5614.0
2873 2025-05-27 5586.0
2025-05-27 17:50:50,275 - IOOppi_data - INFO : save new data to db IOOppi_SM_g: date value ... created_at updated_at
2877 2025-05-27 5586.0 ... 2025-05-27 17:50:50.268328 2025-05-27 17:50:50.268696
[1 rows x 5 columns]
2025-05-27 17:50:50,295 - 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-27 17:50:50,831 - IOOppi_data - INFO : save data to db IOOppi_CY_t data:
date value
2144 2025-05-23 23775.0
2145 2025-05-24 23775.0
2146 2025-05-25 23775.0
2147 2025-05-26 23775.0
2148 2025-05-27 23800.0
2025-05-27 17:50:50,881 - IOOppi_data - INFO : save new data to db IOOppi_CY_t: date value ... created_at updated_at
2148 2025-05-27 23800.0 ... 2025-05-27 17:50:50.874837 2025-05-27 17:50:50.875244
[1 rows x 5 columns]
2025-05-27 17:50:50,901 - IOOppi_data - INFO : save diff data to db: IOOppi_CY_t: no diff data
2025-05-27 17:50:50,907 - IOOppi_data - INFO : save data to db IOOppi_CY_g data:
date value
2144 2025-05-23 23775.0
2145 2025-05-24 23775.0
2146 2025-05-25 23775.0
2147 2025-05-26 23775.0
2148 2025-05-27 23800.0
2025-05-27 17:50:50,958 - IOOppi_data - INFO : save new data to db IOOppi_CY_g: date value ... created_at updated_at
2152 2025-05-27 23800.0 ... 2025-05-27 17:50:50.951465 2025-05-27 17:50:50.951862
[1 rows x 5 columns]
2025-05-27 17:50:50,977 - 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-27 17:50:51,545 - IOOppi_data - INFO : save data to db IOOppi_UR_t data:
date value
1659 2025-05-23 1912.0
1660 2025-05-24 1912.0
1661 2025-05-25 1912.0
1662 2025-05-26 1900.0
1663 2025-05-27 1886.0
2025-05-27 17:50:51,590 - IOOppi_data - INFO : save new data to db IOOppi_UR_t: date value ... created_at updated_at
1663 2025-05-27 1886.0 ... 2025-05-27 17:50:51.583661 2025-05-27 17:50:51.584073
[1 rows x 5 columns]
2025-05-27 17:50:51,612 - IOOppi_data - INFO : save diff data to db: IOOppi_UR_t: no diff data
2025-05-27 17:50:51,617 - IOOppi_data - INFO : save data to db IOOppi_UR_g data:
date value
1659 2025-05-23 1912.0
1660 2025-05-24 1912.0
1661 2025-05-25 1912.0
1662 2025-05-26 1900.0
1663 2025-05-27 1886.0
2025-05-27 17:50:51,664 - IOOppi_data - INFO : save new data to db IOOppi_UR_g: date value ... created_at updated_at
1667 2025-05-27 1886.0 ... 2025-05-27 17:50:51.657313 2025-05-27 17:50:51.657693
[1 rows x 5 columns]
2025-05-27 17:50:51,684 - 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-27 17:50:52,239 - IOOppi_data - INFO : save data to db IOOppi_ni_t data:
date value
2731 2025-05-23 124358.33
2732 2025-05-24 124358.33
2733 2025-05-25 124358.33
2734 2025-05-26 124200.00
2735 2025-05-27 123400.00
2025-05-27 17:50:52,296 - IOOppi_data - INFO : save new data to db IOOppi_ni_t: date ... updated_at
2735 2025-05-27 ... 2025-05-27 17:50:52.290775
[1 rows x 5 columns]
2025-05-27 17:50:52,316 - IOOppi_data - INFO : save diff data to db: IOOppi_ni_t: no diff data
2025-05-27 17:50:52,321 - IOOppi_data - INFO : save data to db IOOppi_ni_g data:
date value
2731 2025-05-23 124358.33
2732 2025-05-24 124358.33
2733 2025-05-25 124358.33
2734 2025-05-26 124200.00
2735 2025-05-27 123400.00
2025-05-27 17:50:52,379 - IOOppi_data - INFO : save new data to db IOOppi_ni_g: date ... updated_at
2738 2025-05-27 ... 2025-05-27 17:50:52.373202
[1 rows x 5 columns]
2025-05-27 17:50:52,400 - 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-27 17:50:53,062 - IOOppi_data - INFO : save data to db IOOppi_v_t data:
date value
3756 2025-05-23 4681.0
3757 2025-05-24 4681.0
3758 2025-05-25 4681.0
3759 2025-05-26 4673.0
3760 2025-05-27 4580.0
2025-05-27 17:50:53,134 - IOOppi_data - INFO : save new data to db IOOppi_v_t: date value ... created_at updated_at
3760 2025-05-27 4580.0 ... 2025-05-27 17:50:53.127655 2025-05-27 17:50:53.128089
[1 rows x 5 columns]
2025-05-27 17:50:53,155 - IOOppi_data - INFO : save diff data to db: IOOppi_v_t: no diff data
2025-05-27 17:50:53,161 - IOOppi_data - INFO : save data to db IOOppi_v_g data:
date value
3756 2025-05-23 4681.0
3757 2025-05-24 4681.0
3758 2025-05-25 4681.0
3759 2025-05-26 4673.0
3760 2025-05-27 4580.0
2025-05-27 17:50:53,234 - IOOppi_data - INFO : save new data to db IOOppi_v_g: date value ... created_at updated_at
3763 2025-05-27 4580.0 ... 2025-05-27 17:50:53.227327 2025-05-27 17:50:53.227704
[1 rows x 5 columns]
2025-05-27 17:50:53,255 - 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-27 17:50:53,843 - IOOppi_data - INFO : save data to db IOOppi_pp_t data:
date value
2995 2025-05-23 7426.67
2996 2025-05-24 7426.67
2997 2025-05-25 7426.67
2998 2025-05-26 7426.67
2999 2025-05-27 7426.67
2025-05-27 17:50:53,904 - IOOppi_data - INFO : save new data to db IOOppi_pp_t: date value ... created_at updated_at
2999 2025-05-27 7426.67 ... 2025-05-27 17:50:53.897523 2025-05-27 17:50:53.897927
[1 rows x 5 columns]
2025-05-27 17:50:53,925 - IOOppi_data - INFO : save diff data to db: IOOppi_pp_t: no diff data
2025-05-27 17:50:53,930 - IOOppi_data - INFO : save data to db IOOppi_pp_g data:
date value
2995 2025-05-23 7426.67
2996 2025-05-24 7426.67
2997 2025-05-25 7426.67
2998 2025-05-26 7426.67
2999 2025-05-27 7426.67
2025-05-27 17:50:53,994 - IOOppi_data - INFO : save new data to db IOOppi_pp_g: date value ... created_at updated_at
3002 2025-05-27 7426.67 ... 2025-05-27 17:50:53.987117 2025-05-27 17:50:53.987540
[1 rows x 5 columns]
2025-05-27 17:50:54,015 - 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-27 17:50:54,583 - IOOppi_data - INFO : save data to db IOOppi_CF_t data:
date value
3757 2025-05-23 14604.00
3758 2025-05-24 14604.00
3759 2025-05-25 14604.00
3760 2025-05-26 14605.00
3761 2025-05-27 14597.17
2025-05-27 17:50:54,653 - IOOppi_data - INFO : save new data to db IOOppi_CF_t: date ... updated_at
3761 2025-05-27 ... 2025-05-27 17:50:54.647073
[1 rows x 5 columns]
2025-05-27 17:50:54,672 - IOOppi_data - INFO : save diff data to db: IOOppi_CF_t: no diff data
2025-05-27 17:50:54,678 - IOOppi_data - INFO : save data to db IOOppi_CF_g data:
date value
3757 2025-05-23 14604.00
3758 2025-05-24 14604.00
3759 2025-05-25 14604.00
3760 2025-05-26 14605.00
3761 2025-05-27 14597.17
2025-05-27 17:50:54,749 - IOOppi_data - INFO : save new data to db IOOppi_CF_g: date ... updated_at
3765 2025-05-27 ... 2025-05-27 17:50:54.743105
[1 rows x 5 columns]
2025-05-27 17:50:54,768 - 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-27 17:50:55,304 - IOOppi_data - INFO : save data to db IOOppi_pb_t data:
date value
3702 2025-05-23 16743.75
3703 2025-05-24 16743.75
3704 2025-05-25 16743.75
3705 2025-05-26 16768.75
3706 2025-05-27 16718.75
2025-05-27 17:50:55,374 - IOOppi_data - INFO : save new data to db IOOppi_pb_t: date ... updated_at
3706 2025-05-27 ... 2025-05-27 17:50:55.368672
[1 rows x 5 columns]
2025-05-27 17:50:55,395 - IOOppi_data - INFO : save diff data to db: IOOppi_pb_t: no diff data
2025-05-27 17:50:55,402 - IOOppi_data - INFO : save data to db IOOppi_pb_g data:
date value
3702 2025-05-23 16743.75
3703 2025-05-24 16743.75
3704 2025-05-25 16743.75
3705 2025-05-26 16768.75
3706 2025-05-27 16718.75
2025-05-27 17:50:55,475 - IOOppi_data - INFO : save new data to db IOOppi_pb_g: date ... updated_at
3709 2025-05-27 ... 2025-05-27 17:50:55.469592
[1 rows x 5 columns]
2025-05-27 17:50:55,495 - 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-27 17:50:56,054 - IOOppi_data - INFO : save data to db IOOppi_hc_t data:
date value
2977 2025-05-23 3266.67
2978 2025-05-24 3266.67
2979 2025-05-25 3266.67
2980 2025-05-26 3256.67
2981 2025-05-27 3243.33
2025-05-27 17:50:56,192 - IOOppi_data - INFO : save new data to db IOOppi_hc_t: date value ... created_at updated_at
2981 2025-05-27 3243.33 ... 2025-05-27 17:50:56.184709 2025-05-27 17:50:56.185130
[1 rows x 5 columns]
2025-05-27 17:50:56,213 - IOOppi_data - INFO : save diff data to db: IOOppi_hc_t: no diff data
2025-05-27 17:50:56,219 - IOOppi_data - INFO : save data to db IOOppi_hc_g data:
date value
2977 2025-05-23 3266.67
2978 2025-05-24 3266.67
2979 2025-05-25 3266.67
2980 2025-05-26 3256.67
2981 2025-05-27 3243.33
2025-05-27 17:50:56,283 - IOOppi_data - INFO : save new data to db IOOppi_hc_g: date value ... created_at updated_at
2984 2025-05-27 3243.33 ... 2025-05-27 17:50:56.276377 2025-05-27 17:50:56.276783
[1 rows x 5 columns]
2025-05-27 17:50:56,303 - 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-27 17:50:56,874 - IOOppi_data - INFO : save data to db IOOppi_fu_t data:
date value
3257 2025-05-23 5337.5
3258 2025-05-24 5337.5
3259 2025-05-25 5337.5
3260 2025-05-26 5325.0
3261 2025-05-27 5325.0
2025-05-27 17:50:56,939 - IOOppi_data - INFO : save new data to db IOOppi_fu_t: date value ... created_at updated_at
3261 2025-05-27 5325.0 ... 2025-05-27 17:50:56.931979 2025-05-27 17:50:56.932366
[1 rows x 5 columns]
2025-05-27 17:50:56,961 - IOOppi_data - INFO : save diff data to db: IOOppi_fu_t: no diff data
2025-05-27 17:50:56,966 - IOOppi_data - INFO : save data to db IOOppi_fu_g data:
date value
3257 2025-05-23 5337.5
3258 2025-05-24 5337.5
3259 2025-05-25 5337.5
3260 2025-05-26 5325.0
3261 2025-05-27 5325.0
2025-05-27 17:50:57,039 - IOOppi_data - INFO : save new data to db IOOppi_fu_g: date value ... created_at updated_at
3748 2025-05-27 5325.0 ... 2025-05-27 17:50:57.031985 2025-05-27 17:50:57.032371
[1 rows x 5 columns]
2025-05-27 17:50:57,059 - 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-27 17:50:57,600 - IOOppi_data - INFO : save data to db IOOppi_lh_t data:
date value
1321 2025-05-23 14530.0
1322 2025-05-24 14530.0
1323 2025-05-25 14530.0
1324 2025-05-26 14520.0
1325 2025-05-27 14500.0
2025-05-27 17:50:57,644 - IOOppi_data - INFO : save new data to db IOOppi_lh_t: date value ... created_at updated_at
1325 2025-05-27 14500.0 ... 2025-05-27 17:50:57.634440 2025-05-27 17:50:57.634866
[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-27 17:50:57,904 - IOOppi_data - INFO : save diff data to db IOOppi_lh_t: date ... updated_at
116 2021-07-05 ... 2025-05-27 17:50:57.895089
117 2021-07-06 ... 2025-05-27 17:50:57.895089
121 2021-07-12 ... 2025-05-27 17:50:57.895089
122 2021-07-13 ... 2025-05-27 17:50:57.895089
194 2021-11-01 ... 2025-05-27 17:50:57.895089
[5 rows x 6 columns]
2025-05-27 17:50:57,943 - IOOppi_data - INFO : save data to db IOOppi_lh_g data:
date value
1321 2025-05-23 14530.0
1322 2025-05-24 14530.0
1323 2025-05-25 14530.0
1324 2025-05-26 14520.0
1325 2025-05-27 14500.0
2025-05-27 17:50:57,986 - IOOppi_data - INFO : save new data to db IOOppi_lh_g: date value ... created_at updated_at
1328 2025-05-27 14500.0 ... 2025-05-27 17:50:57.979124 2025-05-27 17:50:57.979543
[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-27 17:50:58,245 - IOOppi_data - INFO : save diff data to db IOOppi_lh_g: date ... updated_at
116 2021-07-05 ... 2025-05-27 17:50:58.237334
117 2021-07-06 ... 2025-05-27 17:50:58.237334
121 2021-07-12 ... 2025-05-27 17:50:58.237334
122 2021-07-13 ... 2025-05-27 17:50:58.237334
194 2021-11-01 ... 2025-05-27 17:50:58.237334
[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-27 17:50:58,851 - IOOppi_data - INFO : save data to db IOOppi_cu_t data:
date value
3753 2025-05-23 78110.00
3754 2025-05-24 78110.00
3755 2025-05-25 78110.00
3756 2025-05-26 78588.33
3757 2025-05-27 78556.67
2025-05-27 17:50:58,922 - IOOppi_data - INFO : save new data to db IOOppi_cu_t: date ... updated_at
3757 2025-05-27 ... 2025-05-27 17:50:58.916056
[1 rows x 5 columns]
2025-05-27 17:50:58,942 - IOOppi_data - INFO : save diff data to db: IOOppi_cu_t: no diff data
2025-05-27 17:50:58,948 - IOOppi_data - INFO : save data to db IOOppi_cu_g data:
date value
3753 2025-05-23 78110.00
3754 2025-05-24 78110.00
3755 2025-05-25 78110.00
3756 2025-05-26 78588.33
3757 2025-05-27 78556.67
2025-05-27 17:50:59,020 - IOOppi_data - INFO : save new data to db IOOppi_cu_g: date ... updated_at
3760 2025-05-27 ... 2025-05-27 17:50:59.014409
[1 rows x 5 columns]
2025-05-27 17:50:59,041 - 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-27 17:50:59,540 - 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-27 17:50:59,593 - IOOppi_data - INFO : save new data to db: IOOppi_PM_t: no new data
2025-05-27 17:50:59,594 - IOOppi_data - INFO : save diff data to db: IOOppi_PM_t: no diff data
2025-05-27 17:50:59,599 - 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-27 17:50:59,659 - IOOppi_data - INFO : save new data to db: IOOppi_PM_g: no new data
2025-05-27 17:50:59,659 - 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-27 17:51:00,226 - IOOppi_data - INFO : save data to db IOOppi_sn_t data:
date value
2731 2025-05-23 265337.5
2732 2025-05-24 265337.5
2733 2025-05-25 265337.5
2734 2025-05-26 264400.0
2735 2025-05-27 264975.0
2025-05-27 17:51:00,285 - IOOppi_data - INFO : save new data to db IOOppi_sn_t: date ... updated_at
2735 2025-05-27 ... 2025-05-27 17:51:00.279249
[1 rows x 5 columns]
2025-05-27 17:51:00,306 - IOOppi_data - INFO : save diff data to db: IOOppi_sn_t: no diff data
2025-05-27 17:51:00,311 - IOOppi_data - INFO : save data to db IOOppi_sn_g data:
date value
2731 2025-05-23 265337.5
2732 2025-05-24 265337.5
2733 2025-05-25 265337.5
2734 2025-05-26 264400.0
2735 2025-05-27 264975.0
2025-05-27 17:51:00,372 - IOOppi_data - INFO : save new data to db IOOppi_sn_g: date ... updated_at
2738 2025-05-27 ... 2025-05-27 17:51:00.365926
[1 rows x 5 columns]
2025-05-27 17:51:00,392 - 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-27 17:51:00,935 - IOOppi_data - INFO : save data to db IOOppi_zn_t data:
date value
3752 2025-05-23 22692.0
3753 2025-05-24 22692.0
3754 2025-05-25 22692.0
3755 2025-05-26 22556.0
3756 2025-05-27 22736.0
2025-05-27 17:51:01,005 - IOOppi_data - INFO : save new data to db IOOppi_zn_t: date value ... created_at updated_at
3756 2025-05-27 22736.0 ... 2025-05-27 17:51:00.998666 2025-05-27 17:51:00.999095
[1 rows x 5 columns]
2025-05-27 17:51:01,026 - IOOppi_data - INFO : save diff data to db: IOOppi_zn_t: no diff data
2025-05-27 17:51:01,031 - IOOppi_data - INFO : save data to db IOOppi_zn_g data:
date value
3752 2025-05-23 22692.0
3753 2025-05-24 22692.0
3754 2025-05-25 22692.0
3755 2025-05-26 22556.0
3756 2025-05-27 22736.0
2025-05-27 17:51:01,104 - IOOppi_data - INFO : save new data to db IOOppi_zn_g: date value ... created_at updated_at
3759 2025-05-27 22736.0 ... 2025-05-27 17:51:01.097129 2025-05-27 17:51:01.097500
[1 rows x 5 columns]
2025-05-27 17:51:01,124 - 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-27 17:51:01,712 - IOOppi_data - INFO : save data to db IOOppi_wr_t data:
date value
3715 2025-05-23 3327.5
3716 2025-05-24 3327.5
3717 2025-05-25 3327.5
3718 2025-05-26 3295.0
3719 2025-05-27 3277.5
2025-05-27 17:51:01,786 - IOOppi_data - INFO : save new data to db IOOppi_wr_t: date value ... created_at updated_at
3719 2025-05-27 3277.5 ... 2025-05-27 17:51:01.777665 2025-05-27 17:51:01.778102
[1 rows x 5 columns]
2025-05-27 17:51:01,806 - IOOppi_data - INFO : save diff data to db: IOOppi_wr_t: no diff data
2025-05-27 17:51:01,812 - IOOppi_data - INFO : save data to db IOOppi_wr_g data:
date value
3715 2025-05-23 3327.5
3716 2025-05-24 3327.5
3717 2025-05-25 3327.5
3718 2025-05-26 3295.0
3719 2025-05-27 3277.5
2025-05-27 17:51:01,884 - IOOppi_data - INFO : save new data to db IOOppi_wr_g: date value ... created_at updated_at
3722 2025-05-27 3277.5 ... 2025-05-27 17:51:01.877342 2025-05-27 17:51:01.877724
[1 rows x 5 columns]
2025-05-27 17:51:01,905 - 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-27 17:51:02,493 - IOOppi_data - INFO : save data to db IOOppi_pg_t data:
date value
1512 2025-05-23 4742.5
1513 2025-05-24 4742.5
1514 2025-05-25 4742.5
1515 2025-05-26 4730.0
1516 2025-05-27 4730.0
2025-05-27 17:51:02,538 - IOOppi_data - INFO : save new data to db IOOppi_pg_t: date value ... created_at updated_at
1516 2025-05-27 4730.0 ... 2025-05-27 17:51:02.531066 2025-05-27 17:51:02.531454
[1 rows x 5 columns]
2025-05-27 17:51:02,559 - IOOppi_data - INFO : save diff data to db: IOOppi_pg_t: no diff data
2025-05-27 17:51:02,564 - IOOppi_data - INFO : save data to db IOOppi_pg_g data:
date value
1512 2025-05-23 4742.5
1513 2025-05-24 4742.5
1514 2025-05-25 4742.5
1515 2025-05-26 4730.0
1516 2025-05-27 4730.0
2025-05-27 17:51:02,609 - IOOppi_data - INFO : save new data to db IOOppi_pg_g: date value ... created_at updated_at
1519 2025-05-27 4730.0 ... 2025-05-27 17:51:02.602412 2025-05-27 17:51:02.602848
[1 rows x 5 columns]
2025-05-27 17:51:02,629 - 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-27 17:51:03,241 - IOOppi_data - INFO : save data to db IOOppi_cs_t data:
date value
2786 2025-05-23 2295.71
2787 2025-05-24 2295.71
2788 2025-05-25 2295.71
2789 2025-05-26 2295.71
2790 2025-05-27 2294.29
2025-05-27 17:51:03,304 - IOOppi_data - INFO : save new data to db IOOppi_cs_t: date value ... created_at updated_at
2790 2025-05-27 2294.29 ... 2025-05-27 17:51:03.297013 2025-05-27 17:51:03.297390
[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-27 17:51:03,347 - IOOppi_data - INFO : save diff data to db IOOppi_cs_t: date ... updated_at
2789 2025-05-26 ... 2025-05-27 17:51:03.339950
[1 rows x 6 columns]
2025-05-27 17:51:03,372 - IOOppi_data - INFO : save data to db IOOppi_cs_g data:
date value
2786 2025-05-23 2295.71
2787 2025-05-24 2295.71
2788 2025-05-25 2295.71
2789 2025-05-26 2295.71
2790 2025-05-27 2294.29
2025-05-27 17:51:03,434 - IOOppi_data - INFO : save new data to db IOOppi_cs_g: date value ... created_at updated_at
2793 2025-05-27 2294.29 ... 2025-05-27 17:51:03.426996 2025-05-27 17:51:03.427394
[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-27 17:51:03,479 - IOOppi_data - INFO : save diff data to db IOOppi_cs_g: date ... updated_at
2792 2025-05-26 ... 2025-05-27 17:51:03.473090
[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-27 17:51:04,155 - IOOppi_data - INFO : save data to db IOOppi_cs_t data:
date value
2786 2025-05-23 2295.71
2787 2025-05-24 2295.71
2788 2025-05-25 2295.71
2789 2025-05-26 2295.71
2790 2025-05-27 2912.00
2025-05-27 17:51:04,207 - 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-27 17:51:04,230 - IOOppi_data - INFO : save diff data to db IOOppi_cs_t: date ... updated_at
2790 2025-05-27 ... 2025-05-27 17:51:04.223389
[1 rows x 6 columns]
2025-05-27 17:51:04,255 - IOOppi_data - INFO : save data to db IOOppi_cs_g data:
date value
2786 2025-05-23 2295.71
2787 2025-05-24 2295.71
2788 2025-05-25 2295.71
2789 2025-05-26 2295.71
2790 2025-05-27 2912.00
2025-05-27 17:51:04,306 - 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-27 17:51:04,328 - IOOppi_data - INFO : save diff data to db IOOppi_cs_g: date ... updated_at
2793 2025-05-27 ... 2025-05-27 17:51:04.321620
[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-27 17:51:04,852 - IOOppi_data - INFO : save data to db IOOppi_RS_t data:
date value
3143 2025-05-23 9513.33
3144 2025-05-24 9513.33
3145 2025-05-25 9513.33
3146 2025-05-26 9493.33
3147 2025-05-27 9545.00
2025-05-27 17:51:04,907 - IOOppi_data - INFO : save new data to db: IOOppi_RS_t: no new data
2025-05-27 17:51:04,907 - IOOppi_data - INFO : save diff data to db: IOOppi_RS_t: no diff data
2025-05-27 17:51:04,913 - IOOppi_data - INFO : save data to db IOOppi_RS_g data:
date value
3143 2025-05-23 9513.33
3144 2025-05-24 9513.33
3145 2025-05-25 9513.33
3146 2025-05-26 9493.33
3147 2025-05-27 9545.00
2025-05-27 17:51:04,971 - IOOppi_data - INFO : save new data to db: IOOppi_RS_g: no new data
2025-05-27 17:51:04,971 - 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-27 17:51:05,495 - IOOppi_data - INFO : save data to db IOOppi_eg_t data:
date value
1827 2025-05-23 4543.33
1828 2025-05-24 4543.33
1829 2025-05-25 4543.33
1830 2025-05-26 4548.33
1831 2025-05-27 4548.33
2025-05-27 17:51:05,545 - IOOppi_data - INFO : save new data to db IOOppi_eg_t: date value ... created_at updated_at
1831 2025-05-27 4548.33 ... 2025-05-27 17:51:05.538259 2025-05-27 17:51:05.538634
[1 rows x 5 columns]
2025-05-27 17:51:05,566 - IOOppi_data - INFO : save diff data to db: IOOppi_eg_t: no diff data
2025-05-27 17:51:05,571 - IOOppi_data - INFO : save data to db IOOppi_eg_g data:
date value
1827 2025-05-23 4543.33
1828 2025-05-24 4543.33
1829 2025-05-25 4543.33
1830 2025-05-26 4548.33
1831 2025-05-27 4548.33
2025-05-27 17:51:05,619 - IOOppi_data - INFO : save new data to db IOOppi_eg_g: date value ... created_at updated_at
1834 2025-05-27 4548.33 ... 2025-05-27 17:51:05.612111 2025-05-27 17:51:05.612477
[1 rows x 5 columns]
2025-05-27 17:51:05,639 - 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-27 17:51:06,209 - IOOppi_data - INFO : save data to db IOOppi_sp_t data:
date value
1836 2025-05-23 6300.00
1837 2025-05-24 6300.00
1838 2025-05-25 6300.00
1839 2025-05-26 6300.00
1840 2025-05-27 6266.67
2025-05-27 17:51:06,257 - IOOppi_data - INFO : save new data to db IOOppi_sp_t: date value ... created_at updated_at
1840 2025-05-27 6266.67 ... 2025-05-27 17:51:06.250323 2025-05-27 17:51:06.250708
[1 rows x 5 columns]
2025-05-27 17:51:06,278 - IOOppi_data - INFO : save diff data to db: IOOppi_sp_t: no diff data
2025-05-27 17:51:06,283 - IOOppi_data - INFO : save data to db IOOppi_sp_g data:
date value
1836 2025-05-23 6300.00
1837 2025-05-24 6300.00
1838 2025-05-25 6300.00
1839 2025-05-26 6300.00
1840 2025-05-27 6266.67
2025-05-27 17:51:06,331 - IOOppi_data - INFO : save new data to db IOOppi_sp_g: date value ... created_at updated_at
1843 2025-05-27 6266.67 ... 2025-05-27 17:51:06.324876 2025-05-27 17:51:06.325256
[1 rows x 5 columns]
2025-05-27 17:51:06,352 - 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-27 17:51:06,908 - IOOppi_data - INFO : save data to db IOOppi_p_t data:
date value
3504 2025-05-23 8510.0
3505 2025-05-24 8510.0
3506 2025-05-25 8510.0
3507 2025-05-26 8468.0
3508 2025-05-27 8488.0
2025-05-27 17:51:06,975 - IOOppi_data - INFO : save new data to db IOOppi_p_t: date value ... created_at updated_at
3508 2025-05-27 8488.0 ... 2025-05-27 17:51:06.968947 2025-05-27 17:51:06.969327
[1 rows x 5 columns]
2025-05-27 17:51:06,999 - IOOppi_data - INFO : save diff data to db: IOOppi_p_t: no diff data
2025-05-27 17:51:07,005 - IOOppi_data - INFO : save data to db IOOppi_p_g data:
date value
3504 2025-05-23 8510.0
3505 2025-05-24 8510.0
3506 2025-05-25 8510.0
3507 2025-05-26 8468.0
3508 2025-05-27 8488.0
2025-05-27 17:51:07,074 - IOOppi_data - INFO : save new data to db IOOppi_p_g: date value ... created_at updated_at
3511 2025-05-27 8488.0 ... 2025-05-27 17:51:07.067101 2025-05-27 17:51:07.067478
[1 rows x 5 columns]
2025-05-27 17:51:07,094 - IOOppi_data - INFO : save diff data to db: IOOppi_p_g: no diff data