=========================================================================
2025-05-28 17:50:26 Wed 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-28 17:50:29,128 - IOOppi_data - INFO : save data to db IOOppi_rb_t data:
date value
3313 2025-05-24 3138.56
3314 2025-05-25 3138.56
3315 2025-05-26 3115.67
3316 2025-05-27 3077.11
3317 2025-05-28 3061.67
2025-05-28 17:50:29,198 - IOOppi_data - INFO : save new data to db IOOppi_rb_t: date value ... created_at updated_at
3317 2025-05-28 3061.67 ... 2025-05-28 17:50:29.191244 2025-05-28 17:50:29.191664
[1 rows x 5 columns]
2025-05-28 17:50:29,223 - IOOppi_data - INFO : save diff data to db: IOOppi_rb_t: no diff data
2025-05-28 17:50:29,229 - IOOppi_data - INFO : save data to db IOOppi_rb_g data:
date value
3313 2025-05-24 3138.56
3314 2025-05-25 3138.56
3315 2025-05-26 3115.67
3316 2025-05-27 3077.11
3317 2025-05-28 3061.67
2025-05-28 17:50:29,295 - IOOppi_data - INFO : save new data to db IOOppi_rb_g: date value ... created_at updated_at
3320 2025-05-28 3061.67 ... 2025-05-28 17:50:29.287973 2025-05-28 17:50:29.288376
[1 rows x 5 columns]
2025-05-28 17:50:29,314 - 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-28 17:50:29,910 - IOOppi_data - INFO : save data to db IOOppi_MA_t data:
date value
3534 2025-05-24 2300.00
3535 2025-05-25 2300.00
3536 2025-05-26 2300.00
3537 2025-05-27 2253.75
3538 2025-05-28 2246.25
2025-05-28 17:50:29,978 - IOOppi_data - INFO : save new data to db IOOppi_MA_t: date value ... created_at updated_at
3538 2025-05-28 2246.25 ... 2025-05-28 17:50:29.971587 2025-05-28 17:50:29.971985
[1 rows x 5 columns]
2025-05-28 17:50:29,998 - IOOppi_data - INFO : save diff data to db: IOOppi_MA_t: no diff data
2025-05-28 17:50:30,003 - IOOppi_data - INFO : save data to db IOOppi_MA_g data:
date value
3534 2025-05-24 2300.00
3535 2025-05-25 2300.00
3536 2025-05-26 2300.00
3537 2025-05-27 2253.75
3538 2025-05-28 2246.25
2025-05-28 17:50:30,074 - IOOppi_data - INFO : save new data to db IOOppi_MA_g: date value ... created_at updated_at
3542 2025-05-28 2246.25 ... 2025-05-28 17:50:30.066630 2025-05-28 17:50:30.067120
[1 rows x 5 columns]
2025-05-28 17:50:30,096 - 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-28 17:50:30,817 - IOOppi_data - INFO : save data to db IOOppi_PTA_t data:
date value
874 2025-05-24 4915.00
875 2025-05-25 4915.00
876 2025-05-26 4917.50
877 2025-05-27 4938.75
878 2025-05-28 4893.75
2025-05-28 17:50:30,853 - IOOppi_data - INFO : save new data to db IOOppi_PTA_t: date value ... created_at updated_at
878 2025-05-28 4893.75 ... 2025-05-28 17:50:30.846086 2025-05-28 17:50:30.846458
[1 rows x 5 columns]
2025-05-28 17:50:30,872 - IOOppi_data - INFO : save diff data to db: IOOppi_PTA_t: no diff data
2025-05-28 17:50:30,877 - IOOppi_data - INFO : save data to db IOOppi_PTA_g data:
date value
874 2025-05-24 4915.00
875 2025-05-25 4915.00
876 2025-05-26 4917.50
877 2025-05-27 4938.75
878 2025-05-28 4893.75
2025-05-28 17:50:30,912 - IOOppi_data - INFO : save new data to db IOOppi_PTA_g: date value ... created_at updated_at
878 2025-05-28 4893.75 ... 2025-05-28 17:50:30.905190 2025-05-28 17:50:30.905543
[1 rows x 5 columns]
2025-05-28 17:50:30,932 - 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-28 17:50:31,463 - IOOppi_data - INFO : save data to db IOOppi_ru_t data:
date value
3753 2025-05-24 14308.33
3754 2025-05-25 14308.33
3755 2025-05-26 14158.33
3756 2025-05-27 14258.33
3757 2025-05-28 13658.33
2025-05-28 17:50:31,535 - IOOppi_data - INFO : save new data to db IOOppi_ru_t: date ... updated_at
3757 2025-05-28 ... 2025-05-28 17:50:31.529616
[1 rows x 5 columns]
2025-05-28 17:50:31,556 - IOOppi_data - INFO : save diff data to db: IOOppi_ru_t: no diff data
2025-05-28 17:50:31,561 - IOOppi_data - INFO : save data to db IOOppi_ru_g data:
date value
3753 2025-05-24 14308.33
3754 2025-05-25 14308.33
3755 2025-05-26 14158.33
3756 2025-05-27 14258.33
3757 2025-05-28 13658.33
2025-05-28 17:50:31,637 - IOOppi_data - INFO : save new data to db IOOppi_ru_g: date ... updated_at
3760 2025-05-28 ... 2025-05-28 17:50:31.631089
[1 rows x 5 columns]
2025-05-28 17:50:31,656 - 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-28 17:50:32,187 - IOOppi_data - INFO : save data to db IOOppi_i_t data:
date value
3085 2025-05-24 777.56
3086 2025-05-25 772.56
3087 2025-05-26 769.67
3088 2025-05-27 757.33
3089 2025-05-28 751.44
2025-05-28 17:50:32,251 - IOOppi_data - INFO : save new data to db IOOppi_i_t: date value ... created_at updated_at
3089 2025-05-28 751.44 ... 2025-05-28 17:50:32.243892 2025-05-28 17:50:32.244275
[1 rows x 5 columns]
2025-05-28 17:50:32,270 - IOOppi_data - INFO : save diff data to db: IOOppi_i_t: no diff data
2025-05-28 17:50:32,276 - IOOppi_data - INFO : save data to db IOOppi_i_g data:
date value
3085 2025-05-24 777.56
3086 2025-05-25 772.56
3087 2025-05-26 769.67
3088 2025-05-27 757.33
3089 2025-05-28 751.44
2025-05-28 17:50:32,338 - IOOppi_data - INFO : save new data to db IOOppi_i_g: date value ... created_at updated_at
3092 2025-05-28 751.44 ... 2025-05-28 17:50:32.331770 2025-05-28 17:50:32.332141
[1 rows x 5 columns]
2025-05-28 17:50:32,357 - 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-28 17:50:32,883 - IOOppi_data - INFO : save data to db IOOppi_FG_t data:
date value
3288 2025-05-24 1152.0
3289 2025-05-25 1152.0
3290 2025-05-26 1152.0
3291 2025-05-27 1152.0
3292 2025-05-28 1152.0
2025-05-28 17:50:32,950 - IOOppi_data - INFO : save new data to db IOOppi_FG_t: date value ... created_at updated_at
3292 2025-05-28 1152.0 ... 2025-05-28 17:50:32.942831 2025-05-28 17:50:32.943219
[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-28 17:50:35,004 - IOOppi_data - INFO : save diff data to db IOOppi_FG_t: date ... updated_at
12 2012-12-19 ... 2025-05-28 17:50:34.996683
21 2013-01-04 ... 2025-05-28 17:50:34.996683
54 2013-02-27 ... 2025-05-28 17:50:34.996683
60 2013-03-07 ... 2025-05-28 17:50:34.996683
61 2013-03-08 ... 2025-05-28 17:50:34.996683
[5 rows x 6 columns]
2025-05-28 17:50:35,168 - IOOppi_data - INFO : save data to db IOOppi_FG_g data:
date value
3288 2025-05-24 1152.0
3289 2025-05-25 1152.0
3290 2025-05-26 1152.0
3291 2025-05-27 1152.0
3292 2025-05-28 1152.0
2025-05-28 17:50:35,235 - IOOppi_data - INFO : save new data to db IOOppi_FG_g: date value ... created_at updated_at
3296 2025-05-28 1152.0 ... 2025-05-28 17:50:35.228075 2025-05-28 17:50:35.228453
[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-28 17:50:37,282 - IOOppi_data - INFO : save diff data to db IOOppi_FG_g: date ... updated_at
12 2012-12-19 ... 2025-05-28 17:50:37.274517
21 2013-01-04 ... 2025-05-28 17:50:37.274517
54 2013-02-27 ... 2025-05-28 17:50:37.274517
60 2013-03-07 ... 2025-05-28 17:50:37.274517
61 2013-03-08 ... 2025-05-28 17:50:37.274517
[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-28 17:50:37,971 - IOOppi_data - INFO : save data to db IOOppi_eb_t data:
date value
1633 2025-05-24 8130.0
1634 2025-05-25 8130.0
1635 2025-05-26 8110.0
1636 2025-05-27 8110.0
1637 2025-05-28 8110.0
2025-05-28 17:50:38,016 - IOOppi_data - INFO : save new data to db IOOppi_eb_t: date value ... created_at updated_at
1637 2025-05-28 8110.0 ... 2025-05-28 17:50:38.009614 2025-05-28 17:50:38.010022
[1 rows x 5 columns]
2025-05-28 17:50:38,036 - IOOppi_data - INFO : save diff data to db: IOOppi_eb_t: no diff data
2025-05-28 17:50:38,041 - IOOppi_data - INFO : save data to db IOOppi_eb_g data:
date value
1633 2025-05-24 8130.0
1634 2025-05-25 8130.0
1635 2025-05-26 8110.0
1636 2025-05-27 8110.0
1637 2025-05-28 8110.0
2025-05-28 17:50:38,088 - IOOppi_data - INFO : save new data to db IOOppi_eb_g: date value ... created_at updated_at
1640 2025-05-28 8110.0 ... 2025-05-28 17:50:38.080894 2025-05-28 17:50:38.081270
[1 rows x 5 columns]
2025-05-28 17:50:38,107 - 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-28 17:50:38,709 - IOOppi_data - INFO : save data to db IOOppi_SR_t data:
date value
3744 2025-05-24 6145.0
3745 2025-05-25 6145.0
3746 2025-05-26 6145.0
3747 2025-05-27 6145.0
3748 2025-05-28 6145.0
2025-05-28 17:50:38,781 - IOOppi_data - INFO : save new data to db IOOppi_SR_t: date value ... created_at updated_at
3748 2025-05-28 6145.0 ... 2025-05-28 17:50:38.773846 2025-05-28 17:50:38.774229
[1 rows x 5 columns]
2025-05-28 17:50:38,800 - IOOppi_data - INFO : save diff data to db: IOOppi_SR_t: no diff data
2025-05-28 17:50:38,805 - IOOppi_data - INFO : save data to db IOOppi_SR_g data:
date value
3744 2025-05-24 6145.0
3745 2025-05-25 6145.0
3746 2025-05-26 6145.0
3747 2025-05-27 6145.0
3748 2025-05-28 6145.0
2025-05-28 17:50:38,877 - IOOppi_data - INFO : save new data to db IOOppi_SR_g: date value ... created_at updated_at
3752 2025-05-28 6145.0 ... 2025-05-28 17:50:38.870278 2025-05-28 17:50:38.870647
[1 rows x 5 columns]
2025-05-28 17:50:38,897 - 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-28 17:50:39,436 - IOOppi_data - INFO : save data to db IOOppi_ss_t data:
date value
1634 2025-05-24 13225.0
1635 2025-05-25 13225.0
1636 2025-05-26 13225.0
1637 2025-05-27 13225.0
1638 2025-05-28 13175.0
2025-05-28 17:50:39,482 - IOOppi_data - INFO : save new data to db IOOppi_ss_t: date value ... created_at updated_at
1638 2025-05-28 13175.0 ... 2025-05-28 17:50:39.475485 2025-05-28 17:50:39.475888
[1 rows x 5 columns]
2025-05-28 17:50:39,502 - IOOppi_data - INFO : save diff data to db: IOOppi_ss_t: no diff data
2025-05-28 17:50:39,507 - IOOppi_data - INFO : save data to db IOOppi_ss_g data:
date value
1634 2025-05-24 13225.0
1635 2025-05-25 13225.0
1636 2025-05-26 13225.0
1637 2025-05-27 13225.0
1638 2025-05-28 13175.0
2025-05-28 17:50:39,553 - IOOppi_data - INFO : save new data to db IOOppi_ss_g: date value ... created_at updated_at
1641 2025-05-28 13175.0 ... 2025-05-28 17:50:39.546336 2025-05-28 17:50:39.546703
[1 rows x 5 columns]
2025-05-28 17:50:39,572 - 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-28 17:50:40,103 - IOOppi_data - INFO : save data to db IOOppi_RS_t data:
date value
3144 2025-05-24 9513.33
3145 2025-05-25 9513.33
3146 2025-05-26 9493.33
3147 2025-05-27 9545.00
3148 2025-05-28 9525.00
2025-05-28 17:50:40,170 - IOOppi_data - INFO : save new data to db IOOppi_RS_t: date value ... created_at updated_at
3148 2025-05-28 9525.0 ... 2025-05-28 17:50:40.163318 2025-05-28 17:50:40.163695
[1 rows x 5 columns]
2025-05-28 17:50:40,190 - IOOppi_data - INFO : save diff data to db: IOOppi_RS_t: no diff data
2025-05-28 17:50:40,195 - IOOppi_data - INFO : save data to db IOOppi_RS_g data:
date value
3144 2025-05-24 9513.33
3145 2025-05-25 9513.33
3146 2025-05-26 9493.33
3147 2025-05-27 9545.00
3148 2025-05-28 9525.00
2025-05-28 17:50:40,261 - IOOppi_data - INFO : save new data to db IOOppi_RS_g: date value ... created_at updated_at
3152 2025-05-28 9525.0 ... 2025-05-28 17:50:40.253731 2025-05-28 17:50:40.254191
[1 rows x 5 columns]
2025-05-28 17:50:40,280 - 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-28 17:50:40,810 - IOOppi_data - INFO : save data to db IOOppi_RM_t data:
date value
3267 2025-05-24 2521.67
3268 2025-05-25 2521.67
3269 2025-05-26 2515.00
3270 2025-05-27 2543.33
3271 2025-05-28 2550.00
2025-05-28 17:50:40,876 - IOOppi_data - INFO : save new data to db IOOppi_RM_t: date value ... created_at updated_at
3271 2025-05-28 2550.0 ... 2025-05-28 17:50:40.868862 2025-05-28 17:50:40.869248
[1 rows x 5 columns]
2025-05-28 17:50:40,896 - IOOppi_data - INFO : save diff data to db: IOOppi_RM_t: no diff data
2025-05-28 17:50:40,902 - IOOppi_data - INFO : save data to db IOOppi_RM_g data:
date value
3267 2025-05-24 2521.67
3268 2025-05-25 2521.67
3269 2025-05-26 2515.00
3270 2025-05-27 2543.33
3271 2025-05-28 2550.00
2025-05-28 17:50:40,970 - IOOppi_data - INFO : save new data to db IOOppi_RM_g: date value ... created_at updated_at
3275 2025-05-28 2550.0 ... 2025-05-28 17:50:40.962268 2025-05-28 17:50:40.962870
[1 rows x 5 columns]
2025-05-28 17:50:40,989 - 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-28 17:50:41,483 - IOOppi_data - INFO : save data to db IOOppi_SA_t data:
date value
1471 2025-05-24 1462.5
1472 2025-05-25 1462.5
1473 2025-05-26 1462.5
1474 2025-05-27 1450.0
1475 2025-05-28 1450.0
2025-05-28 17:50:41,527 - IOOppi_data - INFO : save new data to db IOOppi_SA_t: date value ... created_at updated_at
1475 2025-05-28 1450.0 ... 2025-05-28 17:50:41.520257 2025-05-28 17:50:41.520662
[1 rows x 5 columns]
2025-05-28 17:50:41,546 - IOOppi_data - INFO : save diff data to db: IOOppi_SA_t: no diff data
2025-05-28 17:50:41,551 - IOOppi_data - INFO : save data to db IOOppi_SA_g data:
date value
1471 2025-05-24 1462.5
1472 2025-05-25 1462.5
1473 2025-05-26 1462.5
1474 2025-05-27 1450.0
1475 2025-05-28 1450.0
2025-05-28 17:50:41,594 - IOOppi_data - INFO : save new data to db IOOppi_SA_g: date value ... created_at updated_at
1479 2025-05-28 1450.0 ... 2025-05-28 17:50:41.587735 2025-05-28 17:50:41.588110
[1 rows x 5 columns]
2025-05-28 17:50:41,613 - 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-28 17:50:42,166 - IOOppi_data - INFO : save data to db IOOppi_PF_t data:
date value
1384 2025-05-24 6597.08
1385 2025-05-25 6597.08
1386 2025-05-26 6572.50
1387 2025-05-27 6545.21
1388 2025-05-28 6535.21
2025-05-28 17:50:42,208 - IOOppi_data - INFO : save new data to db IOOppi_PF_t: date value ... created_at updated_at
1388 2025-05-28 6535.21 ... 2025-05-28 17:50:42.201136 2025-05-28 17:50:42.201545
[1 rows x 5 columns]
2025-05-28 17:50:42,229 - IOOppi_data - INFO : save diff data to db: IOOppi_PF_t: no diff data
2025-05-28 17:50:42,234 - IOOppi_data - INFO : save data to db IOOppi_PF_g data:
date value
1384 2025-05-24 6597.08
1385 2025-05-25 6597.08
1386 2025-05-26 6572.50
1387 2025-05-27 6545.21
1388 2025-05-28 6535.21
2025-05-28 17:50:42,282 - IOOppi_data - INFO : save new data to db IOOppi_PF_g: date value ... created_at updated_at
1392 2025-05-28 6535.21 ... 2025-05-28 17:50:42.275180 2025-05-28 17:50:42.275722
[1 rows x 5 columns]
2025-05-28 17:50:42,301 - 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-28 17:50:42,851 - IOOppi_data - INFO : save data to db IOOppi_m_t data:
date value
3757 2025-05-24 3024.0
3758 2025-05-25 3024.0
3759 2025-05-26 2982.0
3760 2025-05-27 2962.0
3761 2025-05-28 2966.0
2025-05-28 17:50:42,924 - IOOppi_data - INFO : save new data to db IOOppi_m_t: date value ... created_at updated_at
3761 2025-05-28 2966.0 ... 2025-05-28 17:50:42.917168 2025-05-28 17:50:42.917551
[1 rows x 5 columns]
2025-05-28 17:50:42,944 - IOOppi_data - INFO : save diff data to db: IOOppi_m_t: no diff data
2025-05-28 17:50:42,950 - IOOppi_data - INFO : save data to db IOOppi_m_g data:
date value
3757 2025-05-24 3024.0
3758 2025-05-25 3024.0
3759 2025-05-26 2982.0
3760 2025-05-27 2962.0
3761 2025-05-28 2966.0
2025-05-28 17:50:43,024 - IOOppi_data - INFO : save new data to db IOOppi_m_g: date value ... created_at updated_at
3764 2025-05-28 2966.0 ... 2025-05-28 17:50:43.017278 2025-05-28 17:50:43.017653
[1 rows x 5 columns]
2025-05-28 17:50:43,043 - 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-28 17:50:43,726 - IOOppi_data - INFO : save data to db IOOppi_y_t data:
date value
3527 2025-05-24 8034.0
3528 2025-05-25 8034.0
3529 2025-05-26 7964.0
3530 2025-05-27 7994.0
3531 2025-05-28 7974.0
2025-05-28 17:50:43,794 - IOOppi_data - INFO : save new data to db IOOppi_y_t: date value ... created_at updated_at
3531 2025-05-28 7974.0 ... 2025-05-28 17:50:43.787669 2025-05-28 17:50:43.788072
[1 rows x 5 columns]
2025-05-28 17:50:43,813 - IOOppi_data - INFO : save diff data to db: IOOppi_y_t: no diff data
2025-05-28 17:50:43,819 - IOOppi_data - INFO : save data to db IOOppi_y_g data:
date value
3527 2025-05-24 8034.0
3528 2025-05-25 8034.0
3529 2025-05-26 7964.0
3530 2025-05-27 7994.0
3531 2025-05-28 7974.0
2025-05-28 17:50:43,888 - IOOppi_data - INFO : save new data to db IOOppi_y_g: date value ... created_at updated_at
3534 2025-05-28 7974.0 ... 2025-05-28 17:50:43.881252 2025-05-28 17:50:43.881619
[1 rows x 5 columns]
2025-05-28 17:50:43,906 - 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-28 17:50:44,505 - IOOppi_data - INFO : save data to db IOOppi_a_t data:
date value
3493 2025-05-24 4255.0
3494 2025-05-25 4255.0
3495 2025-05-26 4255.0
3496 2025-05-27 4255.0
3497 2025-05-28 4255.0
2025-05-28 17:50:44,573 - IOOppi_data - INFO : save new data to db IOOppi_a_t: date value ... created_at updated_at
3497 2025-05-28 4255.0 ... 2025-05-28 17:50:44.566282 2025-05-28 17:50:44.566662
[1 rows x 5 columns]
2025-05-28 17:50:44,593 - IOOppi_data - INFO : save diff data to db: IOOppi_a_t: no diff data
2025-05-28 17:50:44,598 - IOOppi_data - INFO : save data to db IOOppi_a_g data:
date value
3493 2025-05-24 4255.0
3494 2025-05-25 4255.0
3495 2025-05-26 4255.0
3496 2025-05-27 4255.0
3497 2025-05-28 4255.0
2025-05-28 17:50:44,669 - IOOppi_data - INFO : save new data to db IOOppi_a_g: date value ... created_at updated_at
3500 2025-05-28 4255.0 ... 2025-05-28 17:50:44.662032 2025-05-28 17:50:44.662414
[1 rows x 5 columns]
2025-05-28 17:50:44,688 - 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-28 17:50:45,213 - IOOppi_data - INFO : save data to db IOOppi_SF_t data:
date value
2870 2025-05-24 5387.14
2871 2025-05-25 5387.14
2872 2025-05-26 5380.00
2873 2025-05-27 5380.00
2874 2025-05-28 5380.00
2025-05-28 17:50:45,275 - IOOppi_data - INFO : save new data to db IOOppi_SF_t: date value ... created_at updated_at
2874 2025-05-28 5380.0 ... 2025-05-28 17:50:45.268371 2025-05-28 17:50:45.268777
[1 rows x 5 columns]
2025-05-28 17:50:45,295 - IOOppi_data - INFO : save diff data to db: IOOppi_SF_t: no diff data
2025-05-28 17:50:45,301 - IOOppi_data - INFO : save data to db IOOppi_SF_g data:
date value
2870 2025-05-24 5387.14
2871 2025-05-25 5387.14
2872 2025-05-26 5380.00
2873 2025-05-27 5380.00
2874 2025-05-28 5380.00
2025-05-28 17:50:45,363 - IOOppi_data - INFO : save new data to db IOOppi_SF_g: date value ... created_at updated_at
2878 2025-05-28 5380.0 ... 2025-05-28 17:50:45.355887 2025-05-28 17:50:45.356272
[1 rows x 5 columns]
2025-05-28 17:50:45,383 - 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-28 17:50:45,976 - IOOppi_data - INFO : save data to db IOOppi_jd_t data:
date value
3070 2025-05-24 3075.0
3071 2025-05-25 3075.0
3072 2025-05-26 3050.0
3073 2025-05-27 3040.0
3074 2025-05-28 3040.0
2025-05-28 17:50:46,042 - IOOppi_data - INFO : save new data to db IOOppi_jd_t: date value ... created_at updated_at
3074 2025-05-28 3040.0 ... 2025-05-28 17:50:46.035007 2025-05-28 17:50:46.035388
[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-28 17:50:46,198 - IOOppi_data - INFO : save diff data to db IOOppi_jd_t: date ... updated_at
39 2014-01-03 ... 2025-05-28 17:50:46.189974
458 2015-09-21 ... 2025-05-28 17:50:46.189974
549 2016-02-03 ... 2025-05-28 17:50:46.189974
693 2016-09-05 ... 2025-05-28 17:50:46.189974
696 2016-09-08 ... 2025-05-28 17:50:46.189974
[5 rows x 6 columns]
2025-05-28 17:50:46,230 - IOOppi_data - INFO : save data to db IOOppi_jd_g data:
date value
3070 2025-05-24 3075.0
3071 2025-05-25 3075.0
3072 2025-05-26 3050.0
3073 2025-05-27 3040.0
3074 2025-05-28 3040.0
2025-05-28 17:50:46,295 - IOOppi_data - INFO : save new data to db IOOppi_jd_g: date value ... created_at updated_at
3077 2025-05-28 3040.0 ... 2025-05-28 17:50:46.287861 2025-05-28 17:50:46.288265
[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-28 17:50:46,447 - IOOppi_data - INFO : save diff data to db IOOppi_jd_g: date ... updated_at
39 2014-01-03 ... 2025-05-28 17:50:46.440174
458 2015-09-21 ... 2025-05-28 17:50:46.440174
549 2016-02-03 ... 2025-05-28 17:50:46.440174
693 2016-09-05 ... 2025-05-28 17:50:46.440174
696 2016-09-08 ... 2025-05-28 17:50:46.440174
[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-28 17:50:47,013 - IOOppi_data - INFO : save data to db IOOppi_SI_t data:
date value
874 2025-05-24 9180.0
875 2025-05-25 9180.0
876 2025-05-26 9180.0
877 2025-05-27 9000.0
878 2025-05-28 8990.0
2025-05-28 17:50:47,049 - IOOppi_data - INFO : save new data to db IOOppi_SI_t: date value ... created_at updated_at
878 2025-05-28 8990.0 ... 2025-05-28 17:50:47.042518 2025-05-28 17:50:47.042916
[1 rows x 5 columns]
2025-05-28 17:50:47,069 - IOOppi_data - INFO : save diff data to db: IOOppi_SI_t: no diff data
2025-05-28 17:50:47,074 - IOOppi_data - INFO : save data to db IOOppi_SI_g data:
date value
874 2025-05-24 9180.0
875 2025-05-25 9180.0
876 2025-05-26 9180.0
877 2025-05-27 9000.0
878 2025-05-28 8990.0
2025-05-28 17:50:47,109 - IOOppi_data - INFO : save new data to db IOOppi_SI_g: date value ... created_at updated_at
878 2025-05-28 8990.0 ... 2025-05-28 17:50:47.102204 2025-05-28 17:50:47.102564
[1 rows x 5 columns]
2025-05-28 17:50:47,128 - 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-28 17:50:47,647 - IOOppi_data - INFO : save data to db IOOppi_l_t data:
date value
3753 2025-05-24 7558.33
3754 2025-05-25 7558.33
3755 2025-05-26 7496.67
3756 2025-05-27 7451.67
3757 2025-05-28 7431.67
2025-05-28 17:50:47,719 - IOOppi_data - INFO : save new data to db IOOppi_l_t: date value ... created_at updated_at
3757 2025-05-28 7431.67 ... 2025-05-28 17:50:47.712249 2025-05-28 17:50:47.712638
[1 rows x 5 columns]
2025-05-28 17:50:47,739 - IOOppi_data - INFO : save diff data to db: IOOppi_l_t: no diff data
2025-05-28 17:50:47,745 - IOOppi_data - INFO : save data to db IOOppi_l_g data:
date value
3753 2025-05-24 7558.33
3754 2025-05-25 7558.33
3755 2025-05-26 7496.67
3756 2025-05-27 7451.67
3757 2025-05-28 7431.67
2025-05-28 17:50:47,816 - IOOppi_data - INFO : save new data to db IOOppi_l_g: date value ... created_at updated_at
3760 2025-05-28 7431.67 ... 2025-05-28 17:50:47.809576 2025-05-28 17:50:47.809972
[1 rows x 5 columns]
2025-05-28 17:50:47,835 - 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-28 17:50:48,376 - IOOppi_data - INFO : save data to db IOOppi_bu_t data:
date value
3091 2025-05-24 3570.00
3092 2025-05-25 3570.00
3093 2025-05-26 3570.00
3094 2025-05-27 3583.33
3095 2025-05-28 3620.00
2025-05-28 17:50:48,442 - IOOppi_data - INFO : save new data to db IOOppi_bu_t: date value ... created_at updated_at
3096 2025-05-28 3620.0 ... 2025-05-28 17:50:48.435473 2025-05-28 17:50:48.435878
[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-28 17:50:48,479 - IOOppi_data - INFO : save diff data to db IOOppi_bu_t: date ... updated_at
2560 2023-12-09 ... 2025-05-28 17:50:48.472
[1 rows x 6 columns]
2025-05-28 17:50:48,504 - IOOppi_data - INFO : save data to db IOOppi_bu_g data:
date value
3091 2025-05-24 3570.00
3092 2025-05-25 3570.00
3093 2025-05-26 3570.00
3094 2025-05-27 3583.33
3095 2025-05-28 3620.00
2025-05-28 17:50:48,569 - IOOppi_data - INFO : save new data to db IOOppi_bu_g: date value ... created_at updated_at
3098 2025-05-28 3620.0 ... 2025-05-28 17:50:48.562046 2025-05-28 17:50:48.562420
[1 rows x 5 columns]
2025-05-28 17:50:48,590 - 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-28 17:50:49,232 - IOOppi_data - INFO : save data to db IOOppi_al_t data:
date value
3756 2025-05-24 20390.00
3757 2025-05-25 20390.00
3758 2025-05-26 20366.67
3759 2025-05-27 20366.67
3760 2025-05-28 20213.33
2025-05-28 17:50:49,304 - IOOppi_data - INFO : save new data to db IOOppi_al_t: date ... updated_at
3760 2025-05-28 ... 2025-05-28 17:50:49.297990
[1 rows x 5 columns]
2025-05-28 17:50:49,323 - IOOppi_data - INFO : save diff data to db: IOOppi_al_t: no diff data
2025-05-28 17:50:49,329 - IOOppi_data - INFO : save data to db IOOppi_al_g data:
date value
3756 2025-05-24 20390.00
3757 2025-05-25 20390.00
3758 2025-05-26 20366.67
3759 2025-05-27 20366.67
3760 2025-05-28 20213.33
2025-05-28 17:50:49,400 - IOOppi_data - INFO : save new data to db IOOppi_al_g: date ... updated_at
3763 2025-05-28 ... 2025-05-28 17:50:49.394140
[1 rows x 5 columns]
2025-05-28 17:50:49,420 - 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-28 17:50:49,978 - IOOppi_data - INFO : save data to db IOOppi_SM_t data:
date value
2870 2025-05-24 5642.0
2871 2025-05-25 5642.0
2872 2025-05-26 5614.0
2873 2025-05-27 5586.0
2874 2025-05-28 5586.0
2025-05-28 17:50:50,040 - IOOppi_data - INFO : save new data to db IOOppi_SM_t: date value ... created_at updated_at
2874 2025-05-28 5586.0 ... 2025-05-28 17:50:50.032800 2025-05-28 17:50:50.033248
[1 rows x 5 columns]
2025-05-28 17:50:50,060 - IOOppi_data - INFO : save diff data to db: IOOppi_SM_t: no diff data
2025-05-28 17:50:50,066 - IOOppi_data - INFO : save data to db IOOppi_SM_g data:
date value
2870 2025-05-24 5642.0
2871 2025-05-25 5642.0
2872 2025-05-26 5614.0
2873 2025-05-27 5586.0
2874 2025-05-28 5586.0
2025-05-28 17:50:50,128 - IOOppi_data - INFO : save new data to db IOOppi_SM_g: date value ... created_at updated_at
2878 2025-05-28 5586.0 ... 2025-05-28 17:50:50.121343 2025-05-28 17:50:50.121721
[1 rows x 5 columns]
2025-05-28 17:50:50,148 - 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-28 17:50:50,845 - IOOppi_data - INFO : save data to db IOOppi_CY_t data:
date value
2145 2025-05-24 23775.0
2146 2025-05-25 23775.0
2147 2025-05-26 23775.0
2148 2025-05-27 23800.0
2149 2025-05-28 23800.0
2025-05-28 17:50:50,896 - IOOppi_data - INFO : save new data to db IOOppi_CY_t: date value ... created_at updated_at
2149 2025-05-28 23800.0 ... 2025-05-28 17:50:50.889815 2025-05-28 17:50:50.890207
[1 rows x 5 columns]
2025-05-28 17:50:50,917 - IOOppi_data - INFO : save diff data to db: IOOppi_CY_t: no diff data
2025-05-28 17:50:50,922 - IOOppi_data - INFO : save data to db IOOppi_CY_g data:
date value
2145 2025-05-24 23775.0
2146 2025-05-25 23775.0
2147 2025-05-26 23775.0
2148 2025-05-27 23800.0
2149 2025-05-28 23800.0
2025-05-28 17:50:50,974 - IOOppi_data - INFO : save new data to db IOOppi_CY_g: date value ... created_at updated_at
2153 2025-05-28 23800.0 ... 2025-05-28 17:50:50.967232 2025-05-28 17:50:50.967590
[1 rows x 5 columns]
2025-05-28 17:50:50,993 - 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-28 17:50:51,736 - IOOppi_data - INFO : save data to db IOOppi_UR_t data:
date value
1660 2025-05-24 1912.0
1661 2025-05-25 1912.0
1662 2025-05-26 1900.0
1663 2025-05-27 1886.0
1664 2025-05-28 1896.0
2025-05-28 17:50:51,782 - IOOppi_data - INFO : save new data to db IOOppi_UR_t: date value ... created_at updated_at
1664 2025-05-28 1896.0 ... 2025-05-28 17:50:51.775150 2025-05-28 17:50:51.775554
[1 rows x 5 columns]
2025-05-28 17:50:51,802 - IOOppi_data - INFO : save diff data to db: IOOppi_UR_t: no diff data
2025-05-28 17:50:51,808 - IOOppi_data - INFO : save data to db IOOppi_UR_g data:
date value
1660 2025-05-24 1912.0
1661 2025-05-25 1912.0
1662 2025-05-26 1900.0
1663 2025-05-27 1886.0
1664 2025-05-28 1896.0
2025-05-28 17:50:51,856 - IOOppi_data - INFO : save new data to db IOOppi_UR_g: date value ... created_at updated_at
1668 2025-05-28 1896.0 ... 2025-05-28 17:50:51.848566 2025-05-28 17:50:51.848991
[1 rows x 5 columns]
2025-05-28 17:50:51,875 - 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-28 17:50:52,463 - IOOppi_data - INFO : save data to db IOOppi_ni_t data:
date value
2732 2025-05-24 124358.33
2733 2025-05-25 124358.33
2734 2025-05-26 124200.00
2735 2025-05-27 123400.00
2736 2025-05-28 123283.33
2025-05-28 17:50:52,521 - IOOppi_data - INFO : save new data to db IOOppi_ni_t: date ... updated_at
2736 2025-05-28 ... 2025-05-28 17:50:52.515529
[1 rows x 5 columns]
2025-05-28 17:50:52,541 - IOOppi_data - INFO : save diff data to db: IOOppi_ni_t: no diff data
2025-05-28 17:50:52,546 - IOOppi_data - INFO : save data to db IOOppi_ni_g data:
date value
2732 2025-05-24 124358.33
2733 2025-05-25 124358.33
2734 2025-05-26 124200.00
2735 2025-05-27 123400.00
2736 2025-05-28 123283.33
2025-05-28 17:50:52,605 - IOOppi_data - INFO : save new data to db IOOppi_ni_g: date ... updated_at
2739 2025-05-28 ... 2025-05-28 17:50:52.599442
[1 rows x 5 columns]
2025-05-28 17:50:52,626 - 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-28 17:50:53,145 - IOOppi_data - INFO : save data to db IOOppi_v_t data:
date value
3757 2025-05-24 4681.0
3758 2025-05-25 4681.0
3759 2025-05-26 4673.0
3760 2025-05-27 4580.0
3761 2025-05-28 4577.0
2025-05-28 17:50:53,219 - IOOppi_data - INFO : save new data to db IOOppi_v_t: date value ... created_at updated_at
3761 2025-05-28 4577.0 ... 2025-05-28 17:50:53.211614 2025-05-28 17:50:53.212166
[1 rows x 5 columns]
2025-05-28 17:50:53,239 - IOOppi_data - INFO : save diff data to db: IOOppi_v_t: no diff data
2025-05-28 17:50:53,245 - IOOppi_data - INFO : save data to db IOOppi_v_g data:
date value
3757 2025-05-24 4681.0
3758 2025-05-25 4681.0
3759 2025-05-26 4673.0
3760 2025-05-27 4580.0
3761 2025-05-28 4577.0
2025-05-28 17:50:53,319 - IOOppi_data - INFO : save new data to db IOOppi_v_g: date value ... created_at updated_at
3764 2025-05-28 4577.0 ... 2025-05-28 17:50:53.311203 2025-05-28 17:50:53.311576
[1 rows x 5 columns]
2025-05-28 17:50:53,339 - 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-28 17:50:53,888 - IOOppi_data - INFO : save data to db IOOppi_pp_t data:
date value
2996 2025-05-24 7426.67
2997 2025-05-25 7426.67
2998 2025-05-26 7426.67
2999 2025-05-27 7426.67
3000 2025-05-28 7426.67
2025-05-28 17:50:53,951 - IOOppi_data - INFO : save new data to db IOOppi_pp_t: date value ... created_at updated_at
3000 2025-05-28 7426.67 ... 2025-05-28 17:50:53.944642 2025-05-28 17:50:53.945055
[1 rows x 5 columns]
2025-05-28 17:50:53,971 - IOOppi_data - INFO : save diff data to db: IOOppi_pp_t: no diff data
2025-05-28 17:50:53,977 - IOOppi_data - INFO : save data to db IOOppi_pp_g data:
date value
2996 2025-05-24 7426.67
2997 2025-05-25 7426.67
2998 2025-05-26 7426.67
2999 2025-05-27 7426.67
3000 2025-05-28 7426.67
2025-05-28 17:50:54,039 - IOOppi_data - INFO : save new data to db IOOppi_pp_g: date value ... created_at updated_at
3003 2025-05-28 7426.67 ... 2025-05-28 17:50:54.032833 2025-05-28 17:50:54.033215
[1 rows x 5 columns]
2025-05-28 17:50:54,059 - 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-28 17:50:54,639 - IOOppi_data - INFO : save data to db IOOppi_CF_t data:
date value
3758 2025-05-24 14604.00
3759 2025-05-25 14604.00
3760 2025-05-26 14605.00
3761 2025-05-27 14597.17
3762 2025-05-28 14580.67
2025-05-28 17:50:54,710 - IOOppi_data - INFO : save new data to db IOOppi_CF_t: date ... updated_at
3762 2025-05-28 ... 2025-05-28 17:50:54.704570
[1 rows x 5 columns]
2025-05-28 17:50:54,730 - IOOppi_data - INFO : save diff data to db: IOOppi_CF_t: no diff data
2025-05-28 17:50:54,736 - IOOppi_data - INFO : save data to db IOOppi_CF_g data:
date value
3758 2025-05-24 14604.00
3759 2025-05-25 14604.00
3760 2025-05-26 14605.00
3761 2025-05-27 14597.17
3762 2025-05-28 14580.67
2025-05-28 17:50:54,807 - IOOppi_data - INFO : save new data to db IOOppi_CF_g: date ... updated_at
3766 2025-05-28 ... 2025-05-28 17:50:54.801690
[1 rows x 5 columns]
2025-05-28 17:50:54,827 - 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-28 17:50:55,380 - IOOppi_data - INFO : save data to db IOOppi_pb_t data:
date value
3703 2025-05-24 16743.75
3704 2025-05-25 16743.75
3705 2025-05-26 16768.75
3706 2025-05-27 16718.75
3707 2025-05-28 16681.25
2025-05-28 17:50:55,450 - IOOppi_data - INFO : save new data to db IOOppi_pb_t: date ... updated_at
3707 2025-05-28 ... 2025-05-28 17:50:55.444305
[1 rows x 5 columns]
2025-05-28 17:50:55,470 - IOOppi_data - INFO : save diff data to db: IOOppi_pb_t: no diff data
2025-05-28 17:50:55,475 - IOOppi_data - INFO : save data to db IOOppi_pb_g data:
date value
3703 2025-05-24 16743.75
3704 2025-05-25 16743.75
3705 2025-05-26 16768.75
3706 2025-05-27 16718.75
3707 2025-05-28 16681.25
2025-05-28 17:50:55,546 - IOOppi_data - INFO : save new data to db IOOppi_pb_g: date ... updated_at
3710 2025-05-28 ... 2025-05-28 17:50:55.540733
[1 rows x 5 columns]
2025-05-28 17:50:55,565 - 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-28 17:50:56,121 - IOOppi_data - INFO : save data to db IOOppi_hc_t data:
date value
2978 2025-05-24 3266.67
2979 2025-05-25 3266.67
2980 2025-05-26 3256.67
2981 2025-05-27 3243.33
2982 2025-05-28 3226.67
2025-05-28 17:50:56,182 - IOOppi_data - INFO : save new data to db IOOppi_hc_t: date value ... created_at updated_at
2982 2025-05-28 3226.67 ... 2025-05-28 17:50:56.175395 2025-05-28 17:50:56.175783
[1 rows x 5 columns]
2025-05-28 17:50:56,202 - IOOppi_data - INFO : save diff data to db: IOOppi_hc_t: no diff data
2025-05-28 17:50:56,207 - IOOppi_data - INFO : save data to db IOOppi_hc_g data:
date value
2978 2025-05-24 3266.67
2979 2025-05-25 3266.67
2980 2025-05-26 3256.67
2981 2025-05-27 3243.33
2982 2025-05-28 3226.67
2025-05-28 17:50:56,271 - IOOppi_data - INFO : save new data to db IOOppi_hc_g: date value ... created_at updated_at
2985 2025-05-28 3226.67 ... 2025-05-28 17:50:56.264124 2025-05-28 17:50:56.264490
[1 rows x 5 columns]
2025-05-28 17:50:56,366 - 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-28 17:50:56,894 - IOOppi_data - INFO : save data to db IOOppi_fu_t data:
date value
3258 2025-05-24 5337.5
3259 2025-05-25 5337.5
3260 2025-05-26 5325.0
3261 2025-05-27 5325.0
3262 2025-05-28 5350.0
2025-05-28 17:50:56,963 - IOOppi_data - INFO : save new data to db IOOppi_fu_t: date value ... created_at updated_at
3262 2025-05-28 5350.0 ... 2025-05-28 17:50:56.956199 2025-05-28 17:50:56.956576
[1 rows x 5 columns]
2025-05-28 17:50:56,982 - IOOppi_data - INFO : save diff data to db: IOOppi_fu_t: no diff data
2025-05-28 17:50:56,988 - IOOppi_data - INFO : save data to db IOOppi_fu_g data:
date value
3258 2025-05-24 5337.5
3259 2025-05-25 5337.5
3260 2025-05-26 5325.0
3261 2025-05-27 5325.0
3262 2025-05-28 5350.0
2025-05-28 17:50:57,059 - IOOppi_data - INFO : save new data to db IOOppi_fu_g: date value ... created_at updated_at
3749 2025-05-28 5350.0 ... 2025-05-28 17:50:57.052214 2025-05-28 17:50:57.052576
[1 rows x 5 columns]
2025-05-28 17:50:57,078 - 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-28 17:50:57,592 - IOOppi_data - INFO : save data to db IOOppi_lh_t data:
date value
1322 2025-05-24 14530.0
1323 2025-05-25 14530.0
1324 2025-05-26 14520.0
1325 2025-05-27 14500.0
1326 2025-05-28 14550.0
2025-05-28 17:50:57,634 - IOOppi_data - INFO : save new data to db IOOppi_lh_t: date value ... created_at updated_at
1326 2025-05-28 14550.0 ... 2025-05-28 17:50:57.627326 2025-05-28 17:50:57.627744
[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-28 17:50:57,881 - IOOppi_data - INFO : save diff data to db IOOppi_lh_t: date ... updated_at
116 2021-07-05 ... 2025-05-28 17:50:57.873497
117 2021-07-06 ... 2025-05-28 17:50:57.873497
121 2021-07-12 ... 2025-05-28 17:50:57.873497
122 2021-07-13 ... 2025-05-28 17:50:57.873497
194 2021-11-01 ... 2025-05-28 17:50:57.873497
[5 rows x 6 columns]
2025-05-28 17:50:57,918 - IOOppi_data - INFO : save data to db IOOppi_lh_g data:
date value
1322 2025-05-24 14530.0
1323 2025-05-25 14530.0
1324 2025-05-26 14520.0
1325 2025-05-27 14500.0
1326 2025-05-28 14550.0
2025-05-28 17:50:57,959 - IOOppi_data - INFO : save new data to db IOOppi_lh_g: date value ... created_at updated_at
1329 2025-05-28 14550.0 ... 2025-05-28 17:50:57.952593 2025-05-28 17:50:57.952977
[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-28 17:50:58,208 - IOOppi_data - INFO : save diff data to db IOOppi_lh_g: date ... updated_at
116 2021-07-05 ... 2025-05-28 17:50:58.200487
117 2021-07-06 ... 2025-05-28 17:50:58.200487
121 2021-07-12 ... 2025-05-28 17:50:58.200487
122 2021-07-13 ... 2025-05-28 17:50:58.200487
194 2021-11-01 ... 2025-05-28 17:50:58.200487
[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-28 17:50:58,795 - IOOppi_data - INFO : save data to db IOOppi_cu_t data:
date value
3754 2025-05-24 78110.00
3755 2025-05-25 78110.00
3756 2025-05-26 78588.33
3757 2025-05-27 78556.67
3758 2025-05-28 78561.67
2025-05-28 17:50:58,867 - IOOppi_data - INFO : save new data to db IOOppi_cu_t: date ... updated_at
3758 2025-05-28 ... 2025-05-28 17:50:58.861023
[1 rows x 5 columns]
2025-05-28 17:50:58,887 - IOOppi_data - INFO : save diff data to db: IOOppi_cu_t: no diff data
2025-05-28 17:50:58,893 - IOOppi_data - INFO : save data to db IOOppi_cu_g data:
date value
3754 2025-05-24 78110.00
3755 2025-05-25 78110.00
3756 2025-05-26 78588.33
3757 2025-05-27 78556.67
3758 2025-05-28 78561.67
2025-05-28 17:50:58,964 - IOOppi_data - INFO : save new data to db IOOppi_cu_g: date ... updated_at
3761 2025-05-28 ... 2025-05-28 17:50:58.958192
[1 rows x 5 columns]
2025-05-28 17:50:58,983 - 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-28 17:50:59,499 - 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-28 17:50:59,552 - IOOppi_data - INFO : save new data to db: IOOppi_PM_t: no new data
2025-05-28 17:50:59,552 - IOOppi_data - INFO : save diff data to db: IOOppi_PM_t: no diff data
2025-05-28 17:50:59,558 - 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-28 17:50:59,618 - IOOppi_data - INFO : save new data to db: IOOppi_PM_g: no new data
2025-05-28 17:50:59,618 - 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-28 17:51:00,182 - IOOppi_data - INFO : save data to db IOOppi_sn_t data:
date value
2732 2025-05-24 265337.5
2733 2025-05-25 265337.5
2734 2025-05-26 264400.0
2735 2025-05-27 264975.0
2736 2025-05-28 265025.0
2025-05-28 17:51:00,240 - IOOppi_data - INFO : save new data to db IOOppi_sn_t: date ... updated_at
2736 2025-05-28 ... 2025-05-28 17:51:00.234707
[1 rows x 5 columns]
2025-05-28 17:51:00,259 - IOOppi_data - INFO : save diff data to db: IOOppi_sn_t: no diff data
2025-05-28 17:51:00,265 - IOOppi_data - INFO : save data to db IOOppi_sn_g data:
date value
2732 2025-05-24 265337.5
2733 2025-05-25 265337.5
2734 2025-05-26 264400.0
2735 2025-05-27 264975.0
2736 2025-05-28 265025.0
2025-05-28 17:51:00,324 - IOOppi_data - INFO : save new data to db IOOppi_sn_g: date ... updated_at
2739 2025-05-28 ... 2025-05-28 17:51:00.318526
[1 rows x 5 columns]
2025-05-28 17:51:00,344 - 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-28 17:51:00,992 - IOOppi_data - INFO : save data to db IOOppi_zn_t data:
date value
3753 2025-05-24 22692.0
3754 2025-05-25 22692.0
3755 2025-05-26 22556.0
3756 2025-05-27 22736.0
3757 2025-05-28 22828.0
2025-05-28 17:51:01,064 - IOOppi_data - INFO : save new data to db IOOppi_zn_t: date value ... created_at updated_at
3757 2025-05-28 22828.0 ... 2025-05-28 17:51:01.057528 2025-05-28 17:51:01.057936
[1 rows x 5 columns]
2025-05-28 17:51:01,084 - IOOppi_data - INFO : save diff data to db: IOOppi_zn_t: no diff data
2025-05-28 17:51:01,090 - IOOppi_data - INFO : save data to db IOOppi_zn_g data:
date value
3753 2025-05-24 22692.0
3754 2025-05-25 22692.0
3755 2025-05-26 22556.0
3756 2025-05-27 22736.0
3757 2025-05-28 22828.0
2025-05-28 17:51:01,162 - IOOppi_data - INFO : save new data to db IOOppi_zn_g: date value ... created_at updated_at
3760 2025-05-28 22828.0 ... 2025-05-28 17:51:01.155568 2025-05-28 17:51:01.155971
[1 rows x 5 columns]
2025-05-28 17:51:01,182 - 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-28 17:51:01,762 - IOOppi_data - INFO : save data to db IOOppi_wr_t data:
date value
3716 2025-05-24 3327.5
3717 2025-05-25 3327.5
3718 2025-05-26 3295.0
3719 2025-05-27 3277.5
3720 2025-05-28 3255.0
2025-05-28 17:51:01,835 - IOOppi_data - INFO : save new data to db IOOppi_wr_t: date value ... created_at updated_at
3720 2025-05-28 3255.0 ... 2025-05-28 17:51:01.828147 2025-05-28 17:51:01.828526
[1 rows x 5 columns]
2025-05-28 17:51:01,856 - IOOppi_data - INFO : save diff data to db: IOOppi_wr_t: no diff data
2025-05-28 17:51:01,862 - IOOppi_data - INFO : save data to db IOOppi_wr_g data:
date value
3716 2025-05-24 3327.5
3717 2025-05-25 3327.5
3718 2025-05-26 3295.0
3719 2025-05-27 3277.5
3720 2025-05-28 3255.0
2025-05-28 17:51:01,937 - IOOppi_data - INFO : save new data to db IOOppi_wr_g: date value ... created_at updated_at
3723 2025-05-28 3255.0 ... 2025-05-28 17:51:01.929924 2025-05-28 17:51:01.930319
[1 rows x 5 columns]
2025-05-28 17:51:01,957 - 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-28 17:51:02,596 - IOOppi_data - INFO : save data to db IOOppi_pg_t data:
date value
1513 2025-05-24 4742.5
1514 2025-05-25 4742.5
1515 2025-05-26 4730.0
1516 2025-05-27 4730.0
1517 2025-05-28 4730.0
2025-05-28 17:51:02,640 - IOOppi_data - INFO : save new data to db IOOppi_pg_t: date value ... created_at updated_at
1517 2025-05-28 4730.0 ... 2025-05-28 17:51:02.633699 2025-05-28 17:51:02.634122
[1 rows x 5 columns]
2025-05-28 17:51:02,660 - IOOppi_data - INFO : save diff data to db: IOOppi_pg_t: no diff data
2025-05-28 17:51:02,665 - IOOppi_data - INFO : save data to db IOOppi_pg_g data:
date value
1513 2025-05-24 4742.5
1514 2025-05-25 4742.5
1515 2025-05-26 4730.0
1516 2025-05-27 4730.0
1517 2025-05-28 4730.0
2025-05-28 17:51:02,710 - IOOppi_data - INFO : save new data to db IOOppi_pg_g: date value ... created_at updated_at
1520 2025-05-28 4730.0 ... 2025-05-28 17:51:02.703043 2025-05-28 17:51:02.703420
[1 rows x 5 columns]
2025-05-28 17:51:02,729 - 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-28 17:51:03,269 - IOOppi_data - INFO : save data to db IOOppi_cs_t data:
date value
2787 2025-05-24 2295.71
2788 2025-05-25 2295.71
2789 2025-05-26 2295.71
2790 2025-05-27 2294.29
2791 2025-05-28 2294.29
2025-05-28 17:51:03,362 - IOOppi_data - INFO : save new data to db IOOppi_cs_t: date value ... created_at updated_at
2791 2025-05-28 2294.29 ... 2025-05-28 17:51:03.352732 2025-05-28 17:51:03.353322
[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-28 17:51:03,405 - IOOppi_data - INFO : save diff data to db IOOppi_cs_t: date ... updated_at
2790 2025-05-27 ... 2025-05-28 17:51:03.398104
[1 rows x 6 columns]
2025-05-28 17:51:03,430 - IOOppi_data - INFO : save data to db IOOppi_cs_g data:
date value
2787 2025-05-24 2295.71
2788 2025-05-25 2295.71
2789 2025-05-26 2295.71
2790 2025-05-27 2294.29
2791 2025-05-28 2294.29
2025-05-28 17:51:03,501 - IOOppi_data - INFO : save new data to db IOOppi_cs_g: date value ... created_at updated_at
2794 2025-05-28 2294.29 ... 2025-05-28 17:51:03.494316 2025-05-28 17:51:03.494711
[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-28 17:51:03,544 - IOOppi_data - INFO : save diff data to db IOOppi_cs_g: date ... updated_at
2793 2025-05-27 ... 2025-05-28 17:51:03.536813
[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-28 17:51:04,199 - IOOppi_data - INFO : save data to db IOOppi_cs_t data:
date value
2787 2025-05-24 2295.71
2788 2025-05-25 2295.71
2789 2025-05-26 2295.71
2790 2025-05-27 2294.29
2791 2025-05-28 2900.00
2025-05-28 17:51:04,251 - 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-28 17:51:04,275 - IOOppi_data - INFO : save diff data to db IOOppi_cs_t: date ... updated_at
2791 2025-05-28 ... 2025-05-28 17:51:04.268671
[1 rows x 6 columns]
2025-05-28 17:51:04,302 - IOOppi_data - INFO : save data to db IOOppi_cs_g data:
date value
2787 2025-05-24 2295.71
2788 2025-05-25 2295.71
2789 2025-05-26 2295.71
2790 2025-05-27 2294.29
2791 2025-05-28 2900.00
2025-05-28 17:51:04,362 - 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-28 17:51:04,386 - IOOppi_data - INFO : save diff data to db IOOppi_cs_g: date ... updated_at
2794 2025-05-28 ... 2025-05-28 17:51:04.378999
[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-28 17:51:04,901 - IOOppi_data - INFO : save data to db IOOppi_RS_t data:
date value
3144 2025-05-24 9513.33
3145 2025-05-25 9513.33
3146 2025-05-26 9493.33
3147 2025-05-27 9545.00
3148 2025-05-28 9525.00
2025-05-28 17:51:04,958 - IOOppi_data - INFO : save new data to db: IOOppi_RS_t: no new data
2025-05-28 17:51:04,958 - IOOppi_data - INFO : save diff data to db: IOOppi_RS_t: no diff data
2025-05-28 17:51:04,963 - IOOppi_data - INFO : save data to db IOOppi_RS_g data:
date value
3144 2025-05-24 9513.33
3145 2025-05-25 9513.33
3146 2025-05-26 9493.33
3147 2025-05-27 9545.00
3148 2025-05-28 9525.00
2025-05-28 17:51:05,020 - IOOppi_data - INFO : save new data to db: IOOppi_RS_g: no new data
2025-05-28 17:51:05,020 - 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-28 17:51:05,585 - IOOppi_data - INFO : save data to db IOOppi_eg_t data:
date value
1828 2025-05-24 4543.33
1829 2025-05-25 4543.33
1830 2025-05-26 4548.33
1831 2025-05-27 4548.33
1832 2025-05-28 4521.67
2025-05-28 17:51:05,633 - IOOppi_data - INFO : save new data to db IOOppi_eg_t: date value ... created_at updated_at
1832 2025-05-28 4521.67 ... 2025-05-28 17:51:05.626451 2025-05-28 17:51:05.626848
[1 rows x 5 columns]
2025-05-28 17:51:05,652 - IOOppi_data - INFO : save diff data to db: IOOppi_eg_t: no diff data
2025-05-28 17:51:05,658 - IOOppi_data - INFO : save data to db IOOppi_eg_g data:
date value
1828 2025-05-24 4543.33
1829 2025-05-25 4543.33
1830 2025-05-26 4548.33
1831 2025-05-27 4548.33
1832 2025-05-28 4521.67
2025-05-28 17:51:05,706 - IOOppi_data - INFO : save new data to db IOOppi_eg_g: date value ... created_at updated_at
1835 2025-05-28 4521.67 ... 2025-05-28 17:51:05.699521 2025-05-28 17:51:05.699941
[1 rows x 5 columns]
2025-05-28 17:51:05,726 - 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-28 17:51:06,267 - IOOppi_data - INFO : save data to db IOOppi_sp_t data:
date value
1837 2025-05-24 6300.00
1838 2025-05-25 6300.00
1839 2025-05-26 6300.00
1840 2025-05-27 6266.67
1841 2025-05-28 6266.67
2025-05-28 17:51:06,314 - IOOppi_data - INFO : save new data to db IOOppi_sp_t: date value ... created_at updated_at
1841 2025-05-28 6266.67 ... 2025-05-28 17:51:06.307493 2025-05-28 17:51:06.307882
[1 rows x 5 columns]
2025-05-28 17:51:06,334 - IOOppi_data - INFO : save diff data to db: IOOppi_sp_t: no diff data
2025-05-28 17:51:06,339 - IOOppi_data - INFO : save data to db IOOppi_sp_g data:
date value
1837 2025-05-24 6300.00
1838 2025-05-25 6300.00
1839 2025-05-26 6300.00
1840 2025-05-27 6266.67
1841 2025-05-28 6266.67
2025-05-28 17:51:06,388 - IOOppi_data - INFO : save new data to db IOOppi_sp_g: date value ... created_at updated_at
1844 2025-05-28 6266.67 ... 2025-05-28 17:51:06.381790 2025-05-28 17:51:06.382171
[1 rows x 5 columns]
2025-05-28 17:51:06,408 - 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-28 17:51:06,957 - IOOppi_data - INFO : save data to db IOOppi_p_t data:
date value
3505 2025-05-24 8510.0
3506 2025-05-25 8510.0
3507 2025-05-26 8468.0
3508 2025-05-27 8488.0
3509 2025-05-28 8572.0
2025-05-28 17:51:07,042 - IOOppi_data - INFO : save new data to db IOOppi_p_t: date value ... created_at updated_at
3509 2025-05-28 8572.0 ... 2025-05-28 17:51:07.032851 2025-05-28 17:51:07.033414
[1 rows x 5 columns]
2025-05-28 17:51:07,062 - IOOppi_data - INFO : save diff data to db: IOOppi_p_t: no diff data
2025-05-28 17:51:07,068 - IOOppi_data - INFO : save data to db IOOppi_p_g data:
date value
3505 2025-05-24 8510.0
3506 2025-05-25 8510.0
3507 2025-05-26 8468.0
3508 2025-05-27 8488.0
3509 2025-05-28 8572.0
2025-05-28 17:51:07,137 - IOOppi_data - INFO : save new data to db IOOppi_p_g: date value ... created_at updated_at
3512 2025-05-28 8572.0 ... 2025-05-28 17:51:07.130725 2025-05-28 17:51:07.131127
[1 rows x 5 columns]
2025-05-28 17:51:07,156 - IOOppi_data - INFO : save diff data to db: IOOppi_p_g: no diff data