=========================================================================
2025-07-25 17:50:26 Fri START TASK.01 IOOppi_data update_data
=========================================================================
/usr/local/lib/python3.10/site-packages/urllib3/connectionpool.py:1056: InsecureRequestWarning: Unverified HTTPS request is being made to host 'www.100ppi.com'. Adding certificate verification is strongly advised. See: https://urllib3.readthedocs.io/en/1.26.x/advanced-usage.html#ssl-warnings
warnings.warn(
2025-07-25 17:50:28,317 - IOOppi_data - INFO : save data to db IOOppi_rb_t data:
date value
3371 2025-07-21 3234.0
3372 2025-07-22 3297.0
3373 2025-07-23 3302.5
3374 2025-07-24 3349.5
3375 2025-07-25 3369.0
2025-07-25 17:50:28,395 - IOOppi_data - INFO : save new data to db IOOppi_rb_t: date value ... created_at updated_at
3375 2025-07-25 3369.0 ... 2025-07-25 17:50:28.388083 2025-07-25 17:50:28.388482
[1 rows x 5 columns]
2025-07-25 17:50:28,414 - IOOppi_data - INFO : save diff data to db: IOOppi_rb_t: no diff data
2025-07-25 17:50:28,420 - IOOppi_data - INFO : save data to db IOOppi_rb_g data:
date value
3371 2025-07-21 3234.0
3372 2025-07-22 3297.0
3373 2025-07-23 3302.5
3374 2025-07-24 3349.5
3375 2025-07-25 3369.0
2025-07-25 17:50:28,486 - IOOppi_data - INFO : save new data to db IOOppi_rb_g: date value ... created_at updated_at
3378 2025-07-25 3369.0 ... 2025-07-25 17:50:28.479801 2025-07-25 17:50:28.480187
[1 rows x 5 columns]
2025-07-25 17:50:28,505 - IOOppi_data - INFO : save diff data to db: IOOppi_rb_g: no diff data
/usr/local/lib/python3.10/site-packages/urllib3/connectionpool.py:1056: InsecureRequestWarning: Unverified HTTPS request is being made to host 'www.100ppi.com'. Adding certificate verification is strongly advised. See: https://urllib3.readthedocs.io/en/1.26.x/advanced-usage.html#ssl-warnings
warnings.warn(
2025-07-25 17:50:29,115 - IOOppi_data - INFO : save data to db IOOppi_MA_t data:
date value
3592 2025-07-21 2405.00
3593 2025-07-22 2433.33
3594 2025-07-23 2404.17
3595 2025-07-24 2459.17
3596 2025-07-25 2481.67
2025-07-25 17:50:29,182 - IOOppi_data - INFO : save new data to db IOOppi_MA_t: date value ... created_at updated_at
3596 2025-07-25 2481.67 ... 2025-07-25 17:50:29.175102 2025-07-25 17:50:29.175481
[1 rows x 5 columns]
2025-07-25 17:50:29,200 - IOOppi_data - INFO : save diff data to db: IOOppi_MA_t: no diff data
2025-07-25 17:50:29,206 - IOOppi_data - INFO : save data to db IOOppi_MA_g data:
date value
3592 2025-07-21 2405.00
3593 2025-07-22 2433.33
3594 2025-07-23 2404.17
3595 2025-07-24 2459.17
3596 2025-07-25 2481.67
2025-07-25 17:50:29,274 - IOOppi_data - INFO : save new data to db IOOppi_MA_g: date value ... created_at updated_at
3600 2025-07-25 2481.67 ... 2025-07-25 17:50:29.267075 2025-07-25 17:50:29.267458
[1 rows x 5 columns]
2025-07-25 17:50:29,292 - IOOppi_data - INFO : save diff data to db: IOOppi_MA_g: no diff data
/usr/local/lib/python3.10/site-packages/urllib3/connectionpool.py:1056: InsecureRequestWarning: Unverified HTTPS request is being made to host 'www.100ppi.com'. Adding certificate verification is strongly advised. See: https://urllib3.readthedocs.io/en/1.26.x/advanced-usage.html#ssl-warnings
warnings.warn(
2025-07-25 17:50:29,961 - IOOppi_data - INFO : save data to db IOOppi_PTA_t data:
date value
932 2025-07-21 4825.00
933 2025-07-22 4817.00
934 2025-07-23 4831.34
935 2025-07-24 4831.34
936 2025-07-25 4874.84
2025-07-25 17:50:29,997 - IOOppi_data - INFO : save new data to db IOOppi_PTA_t: date value ... created_at updated_at
936 2025-07-25 4874.84 ... 2025-07-25 17:50:29.990161 2025-07-25 17:50:29.990542
[1 rows x 5 columns]
2025-07-25 17:50:30,015 - IOOppi_data - INFO : save diff data to db: IOOppi_PTA_t: no diff data
2025-07-25 17:50:30,020 - IOOppi_data - INFO : save data to db IOOppi_PTA_g data:
date value
932 2025-07-21 4825.00
933 2025-07-22 4817.00
934 2025-07-23 4831.34
935 2025-07-24 4831.34
936 2025-07-25 4874.84
2025-07-25 17:50:30,055 - IOOppi_data - INFO : save new data to db IOOppi_PTA_g: date value ... created_at updated_at
936 2025-07-25 4874.84 ... 2025-07-25 17:50:30.048802 2025-07-25 17:50:30.049181
[1 rows x 5 columns]
2025-07-25 17:50:30,073 - IOOppi_data - INFO : save diff data to db: IOOppi_PTA_g: no diff data
/usr/local/lib/python3.10/site-packages/urllib3/connectionpool.py:1056: InsecureRequestWarning: Unverified HTTPS request is being made to host 'www.100ppi.com'. Adding certificate verification is strongly advised. See: https://urllib3.readthedocs.io/en/1.26.x/advanced-usage.html#ssl-warnings
warnings.warn(
2025-07-25 17:50:30,698 - IOOppi_data - INFO : save data to db IOOppi_ru_t data:
date value
3811 2025-07-21 14941.67
3812 2025-07-22 15108.33
3813 2025-07-23 15066.67
3814 2025-07-24 15291.67
3815 2025-07-25 15633.33
2025-07-25 17:50:30,769 - IOOppi_data - INFO : save new data to db IOOppi_ru_t: date ... updated_at
3815 2025-07-25 ... 2025-07-25 17:50:30.763375
[1 rows x 5 columns]
2025-07-25 17:50:30,787 - IOOppi_data - INFO : save diff data to db: IOOppi_ru_t: no diff data
2025-07-25 17:50:30,793 - IOOppi_data - INFO : save data to db IOOppi_ru_g data:
date value
3811 2025-07-21 14941.67
3812 2025-07-22 15108.33
3813 2025-07-23 15066.67
3814 2025-07-24 15291.67
3815 2025-07-25 15633.33
2025-07-25 17:50:30,865 - IOOppi_data - INFO : save new data to db IOOppi_ru_g: date ... updated_at
3818 2025-07-25 ... 2025-07-25 17:50:30.859072
[1 rows x 5 columns]
2025-07-25 17:50:30,883 - IOOppi_data - INFO : save diff data to db: IOOppi_ru_g: no diff data
/usr/local/lib/python3.10/site-packages/urllib3/connectionpool.py:1056: InsecureRequestWarning: Unverified HTTPS request is being made to host 'www.100ppi.com'. Adding certificate verification is strongly advised. See: https://urllib3.readthedocs.io/en/1.26.x/advanced-usage.html#ssl-warnings
warnings.warn(
2025-07-25 17:50:31,488 - IOOppi_data - INFO : save data to db IOOppi_i_t data:
date value
3143 2025-07-21 799.11
3144 2025-07-22 798.89
3145 2025-07-23 798.89
3146 2025-07-24 800.44
3147 2025-07-25 800.44
2025-07-25 17:50:31,552 - IOOppi_data - INFO : save new data to db IOOppi_i_t: date value ... created_at updated_at
3147 2025-07-25 800.44 ... 2025-07-25 17:50:31.545403 2025-07-25 17:50:31.545812
[1 rows x 5 columns]
2025-07-25 17:50:31,572 - IOOppi_data - INFO : save diff data to db: IOOppi_i_t: no diff data
2025-07-25 17:50:31,577 - IOOppi_data - INFO : save data to db IOOppi_i_g data:
date value
3143 2025-07-21 799.11
3144 2025-07-22 798.89
3145 2025-07-23 798.89
3146 2025-07-24 800.44
3147 2025-07-25 800.44
2025-07-25 17:50:31,643 - IOOppi_data - INFO : save new data to db IOOppi_i_g: date value ... created_at updated_at
3150 2025-07-25 800.44 ... 2025-07-25 17:50:31.636286 2025-07-25 17:50:31.636685
[1 rows x 5 columns]
2025-07-25 17:50:31,664 - IOOppi_data - INFO : save diff data to db: IOOppi_i_g: no diff data
/usr/local/lib/python3.10/site-packages/urllib3/connectionpool.py:1056: InsecureRequestWarning: Unverified HTTPS request is being made to host 'www.100ppi.com'. Adding certificate verification is strongly advised. See: https://urllib3.readthedocs.io/en/1.26.x/advanced-usage.html#ssl-warnings
warnings.warn(
2025-07-25 17:50:32,190 - IOOppi_data - INFO : save data to db IOOppi_FG_t data:
date value
3346 2025-07-21 1174.4
3347 2025-07-22 1174.4
3348 2025-07-23 1210.4
3349 2025-07-24 1216.0
3350 2025-07-25 1256.0
2025-07-25 17:50:32,258 - IOOppi_data - INFO : save new data to db IOOppi_FG_t: date value ... created_at updated_at
3350 2025-07-25 1256.0 ... 2025-07-25 17:50:32.250648 2025-07-25 17:50:32.251064
[1 rows x 5 columns]
/root/project/IOOppi_data/IOOppi_request.py:308: SettingWithCopyWarning:
A value is trying to be set on a copy of a slice from a DataFrame.
Try using .loc[row_indexer,col_indexer] = value instead
See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy
diff_df.loc[:, 'index_code'] = index_code
/root/project/IOOppi_data/IOOppi_request.py:309: SettingWithCopyWarning:
A value is trying to be set on a copy of a slice from a DataFrame.
Try using .loc[row_indexer,col_indexer] = value instead
See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy
diff_df.loc[:, 'created_at'] = datetime.datetime.now()
/root/project/IOOppi_data/IOOppi_request.py:310: SettingWithCopyWarning:
A value is trying to be set on a copy of a slice from a DataFrame.
Try using .loc[row_indexer,col_indexer] = value instead
See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy
diff_df.loc[:, 'updated_at'] = datetime.datetime.now()
2025-07-25 17:50:35,090 - IOOppi_data - INFO : save diff data to db IOOppi_FG_t: date ... updated_at
12 2012-12-19 ... 2025-07-25 17:50:35.082671
21 2013-01-04 ... 2025-07-25 17:50:35.082671
54 2013-02-27 ... 2025-07-25 17:50:35.082671
60 2013-03-07 ... 2025-07-25 17:50:35.082671
61 2013-03-08 ... 2025-07-25 17:50:35.082671
[5 rows x 6 columns]
2025-07-25 17:50:35,315 - IOOppi_data - INFO : save data to db IOOppi_FG_g data:
date value
3346 2025-07-21 1174.4
3347 2025-07-22 1174.4
3348 2025-07-23 1210.4
3349 2025-07-24 1216.0
3350 2025-07-25 1256.0
2025-07-25 17:50:35,382 - IOOppi_data - INFO : save new data to db IOOppi_FG_g: date value ... created_at updated_at
3354 2025-07-25 1256.0 ... 2025-07-25 17:50:35.375203 2025-07-25 17:50:35.375589
[1 rows x 5 columns]
/root/project/IOOppi_data/IOOppi_request.py:308: SettingWithCopyWarning:
A value is trying to be set on a copy of a slice from a DataFrame.
Try using .loc[row_indexer,col_indexer] = value instead
See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy
diff_df.loc[:, 'index_code'] = index_code
/root/project/IOOppi_data/IOOppi_request.py:309: SettingWithCopyWarning:
A value is trying to be set on a copy of a slice from a DataFrame.
Try using .loc[row_indexer,col_indexer] = value instead
See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy
diff_df.loc[:, 'created_at'] = datetime.datetime.now()
/root/project/IOOppi_data/IOOppi_request.py:310: SettingWithCopyWarning:
A value is trying to be set on a copy of a slice from a DataFrame.
Try using .loc[row_indexer,col_indexer] = value instead
See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy
diff_df.loc[:, 'updated_at'] = datetime.datetime.now()
2025-07-25 17:50:37,792 - IOOppi_data - INFO : save diff data to db IOOppi_FG_g: date ... updated_at
12 2012-12-19 ... 2025-07-25 17:50:37.784575
21 2013-01-04 ... 2025-07-25 17:50:37.784575
54 2013-02-27 ... 2025-07-25 17:50:37.784575
60 2013-03-07 ... 2025-07-25 17:50:37.784575
61 2013-03-08 ... 2025-07-25 17:50:37.784575
[5 rows x 6 columns]
/usr/local/lib/python3.10/site-packages/urllib3/connectionpool.py:1056: InsecureRequestWarning: Unverified HTTPS request is being made to host 'www.100ppi.com'. Adding certificate verification is strongly advised. See: https://urllib3.readthedocs.io/en/1.26.x/advanced-usage.html#ssl-warnings
warnings.warn(
2025-07-25 17:50:38,612 - IOOppi_data - INFO : save data to db IOOppi_eb_t data:
date value
1691 2025-07-21 7856.0
1692 2025-07-22 7860.0
1693 2025-07-23 7754.0
1694 2025-07-24 7744.0
1695 2025-07-25 7736.0
2025-07-25 17:50:38,660 - IOOppi_data - INFO : save new data to db IOOppi_eb_t: date value ... created_at updated_at
1695 2025-07-25 7736.0 ... 2025-07-25 17:50:38.653144 2025-07-25 17:50:38.653530
[1 rows x 5 columns]
2025-07-25 17:50:38,679 - IOOppi_data - INFO : save diff data to db: IOOppi_eb_t: no diff data
2025-07-25 17:50:38,685 - IOOppi_data - INFO : save data to db IOOppi_eb_g data:
date value
1691 2025-07-21 7856.0
1692 2025-07-22 7860.0
1693 2025-07-23 7754.0
1694 2025-07-24 7744.0
1695 2025-07-25 7736.0
2025-07-25 17:50:38,729 - IOOppi_data - INFO : save new data to db IOOppi_eb_g: date value ... created_at updated_at
1698 2025-07-25 7736.0 ... 2025-07-25 17:50:38.722810 2025-07-25 17:50:38.723184
[1 rows x 5 columns]
2025-07-25 17:50:38,747 - IOOppi_data - INFO : save diff data to db: IOOppi_eb_g: no diff data
/usr/local/lib/python3.10/site-packages/urllib3/connectionpool.py:1056: InsecureRequestWarning: Unverified HTTPS request is being made to host 'www.100ppi.com'. Adding certificate verification is strongly advised. See: https://urllib3.readthedocs.io/en/1.26.x/advanced-usage.html#ssl-warnings
warnings.warn(
2025-07-25 17:50:39,589 - IOOppi_data - INFO : save data to db IOOppi_SR_t data:
date value
3802 2025-07-21 6046.67
3803 2025-07-22 6043.33
3804 2025-07-23 6050.00
3805 2025-07-24 6043.33
3806 2025-07-25 6046.67
2025-07-25 17:50:39,660 - IOOppi_data - INFO : save new data to db IOOppi_SR_t: date value ... created_at updated_at
3806 2025-07-25 6046.67 ... 2025-07-25 17:50:39.653349 2025-07-25 17:50:39.653746
[1 rows x 5 columns]
2025-07-25 17:50:39,679 - IOOppi_data - INFO : save diff data to db: IOOppi_SR_t: no diff data
2025-07-25 17:50:39,685 - IOOppi_data - INFO : save data to db IOOppi_SR_g data:
date value
3802 2025-07-21 6046.67
3803 2025-07-22 6043.33
3804 2025-07-23 6050.00
3805 2025-07-24 6043.33
3806 2025-07-25 6046.67
2025-07-25 17:50:39,758 - IOOppi_data - INFO : save new data to db IOOppi_SR_g: date value ... created_at updated_at
3810 2025-07-25 6046.67 ... 2025-07-25 17:50:39.751328 2025-07-25 17:50:39.751774
[1 rows x 5 columns]
2025-07-25 17:50:39,777 - IOOppi_data - INFO : save diff data to db: IOOppi_SR_g: no diff data
/usr/local/lib/python3.10/site-packages/urllib3/connectionpool.py:1056: InsecureRequestWarning: Unverified HTTPS request is being made to host 'www.100ppi.com'. Adding certificate verification is strongly advised. See: https://urllib3.readthedocs.io/en/1.26.x/advanced-usage.html#ssl-warnings
warnings.warn(
2025-07-25 17:50:40,425 - IOOppi_data - INFO : save data to db IOOppi_ss_t data:
date value
1692 2025-07-21 12955.0
1693 2025-07-22 12955.0
1694 2025-07-23 13030.0
1695 2025-07-24 13030.0
1696 2025-07-25 13030.0
2025-07-25 17:50:40,470 - IOOppi_data - INFO : save new data to db IOOppi_ss_t: date value ... created_at updated_at
1696 2025-07-25 13030.0 ... 2025-07-25 17:50:40.463285 2025-07-25 17:50:40.463674
[1 rows x 5 columns]
2025-07-25 17:50:40,489 - IOOppi_data - INFO : save diff data to db: IOOppi_ss_t: no diff data
2025-07-25 17:50:40,494 - IOOppi_data - INFO : save data to db IOOppi_ss_g data:
date value
1692 2025-07-21 12955.0
1693 2025-07-22 12955.0
1694 2025-07-23 13030.0
1695 2025-07-24 13030.0
1696 2025-07-25 13030.0
2025-07-25 17:50:40,540 - IOOppi_data - INFO : save new data to db IOOppi_ss_g: date value ... created_at updated_at
1699 2025-07-25 13030.0 ... 2025-07-25 17:50:40.532856 2025-07-25 17:50:40.533244
[1 rows x 5 columns]
2025-07-25 17:50:40,558 - IOOppi_data - INFO : save diff data to db: IOOppi_ss_g: no diff data
/usr/local/lib/python3.10/site-packages/urllib3/connectionpool.py:1056: InsecureRequestWarning: Unverified HTTPS request is being made to host 'www.100ppi.com'. Adding certificate verification is strongly advised. See: https://urllib3.readthedocs.io/en/1.26.x/advanced-usage.html#ssl-warnings
warnings.warn(
2025-07-25 17:50:41,269 - IOOppi_data - INFO : save data to db IOOppi_RS_t data:
date value
3202 2025-07-21 9681.67
3203 2025-07-22 9586.67
3204 2025-07-23 9570.00
3205 2025-07-24 9590.00
3206 2025-07-25 9590.00
2025-07-25 17:50:41,334 - IOOppi_data - INFO : save new data to db IOOppi_RS_t: date value ... created_at updated_at
3206 2025-07-25 9590.0 ... 2025-07-25 17:50:41.327148 2025-07-25 17:50:41.327527
[1 rows x 5 columns]
2025-07-25 17:50:41,351 - IOOppi_data - INFO : save diff data to db: IOOppi_RS_t: no diff data
2025-07-25 17:50:41,357 - IOOppi_data - INFO : save data to db IOOppi_RS_g data:
date value
3202 2025-07-21 9681.67
3203 2025-07-22 9586.67
3204 2025-07-23 9570.00
3205 2025-07-24 9590.00
3206 2025-07-25 9590.00
2025-07-25 17:50:41,420 - IOOppi_data - INFO : save new data to db IOOppi_RS_g: date value ... created_at updated_at
3210 2025-07-25 9590.0 ... 2025-07-25 17:50:41.413469 2025-07-25 17:50:41.413862
[1 rows x 5 columns]
2025-07-25 17:50:41,438 - IOOppi_data - INFO : save diff data to db: IOOppi_RS_g: no diff data
/usr/local/lib/python3.10/site-packages/urllib3/connectionpool.py:1056: InsecureRequestWarning: Unverified HTTPS request is being made to host 'www.100ppi.com'. Adding certificate verification is strongly advised. See: https://urllib3.readthedocs.io/en/1.26.x/advanced-usage.html#ssl-warnings
warnings.warn(
2025-07-25 17:50:42,111 - IOOppi_data - INFO : save data to db IOOppi_RM_t data:
date value
3325 2025-07-21 2675.0
3326 2025-07-22 2690.0
3327 2025-07-23 2700.0
3328 2025-07-24 2630.0
3329 2025-07-25 2630.0
2025-07-25 17:50:42,177 - IOOppi_data - INFO : save new data to db IOOppi_RM_t: date value ... created_at updated_at
3329 2025-07-25 2630.0 ... 2025-07-25 17:50:42.170078 2025-07-25 17:50:42.170458
[1 rows x 5 columns]
2025-07-25 17:50:42,196 - IOOppi_data - INFO : save diff data to db: IOOppi_RM_t: no diff data
2025-07-25 17:50:42,202 - IOOppi_data - INFO : save data to db IOOppi_RM_g data:
date value
3325 2025-07-21 2675.0
3326 2025-07-22 2690.0
3327 2025-07-23 2700.0
3328 2025-07-24 2630.0
3329 2025-07-25 2630.0
2025-07-25 17:50:42,268 - IOOppi_data - INFO : save new data to db IOOppi_RM_g: date value ... created_at updated_at
3333 2025-07-25 2630.0 ... 2025-07-25 17:50:42.261325 2025-07-25 17:50:42.261708
[1 rows x 5 columns]
2025-07-25 17:50:42,288 - IOOppi_data - INFO : save diff data to db: IOOppi_RM_g: no diff data
/usr/local/lib/python3.10/site-packages/urllib3/connectionpool.py:1056: InsecureRequestWarning: Unverified HTTPS request is being made to host 'www.100ppi.com'. Adding certificate verification is strongly advised. See: https://urllib3.readthedocs.io/en/1.26.x/advanced-usage.html#ssl-warnings
warnings.warn(
2025-07-25 17:50:42,958 - IOOppi_data - INFO : save data to db IOOppi_SA_t data:
date value
1529 2025-07-21 1250.0
1530 2025-07-22 1250.0
1531 2025-07-23 1270.0
1532 2025-07-24 1272.5
1533 2025-07-25 1315.0
2025-07-25 17:50:43,005 - IOOppi_data - INFO : save new data to db IOOppi_SA_t: date value ... created_at updated_at
1533 2025-07-25 1315.0 ... 2025-07-25 17:50:42.997298 2025-07-25 17:50:42.997683
[1 rows x 5 columns]
2025-07-25 17:50:43,024 - IOOppi_data - INFO : save diff data to db: IOOppi_SA_t: no diff data
2025-07-25 17:50:43,032 - IOOppi_data - INFO : save data to db IOOppi_SA_g data:
date value
1529 2025-07-21 1250.0
1530 2025-07-22 1250.0
1531 2025-07-23 1270.0
1532 2025-07-24 1272.5
1533 2025-07-25 1315.0
2025-07-25 17:50:43,094 - IOOppi_data - INFO : save new data to db IOOppi_SA_g: date value ... created_at updated_at
1537 2025-07-25 1315.0 ... 2025-07-25 17:50:43.085513 2025-07-25 17:50:43.086067
[1 rows x 5 columns]
2025-07-25 17:50:43,112 - IOOppi_data - INFO : save diff data to db: IOOppi_SA_g: no diff data
/usr/local/lib/python3.10/site-packages/urllib3/connectionpool.py:1056: InsecureRequestWarning: Unverified HTTPS request is being made to host 'www.100ppi.com'. Adding certificate verification is strongly advised. See: https://urllib3.readthedocs.io/en/1.26.x/advanced-usage.html#ssl-warnings
warnings.warn(
2025-07-25 17:50:43,791 - IOOppi_data - INFO : save data to db IOOppi_PF_t data:
date value
1442 2025-07-21 6610.42
1443 2025-07-22 6592.08
1444 2025-07-23 6601.67
1445 2025-07-24 6599.17
1446 2025-07-25 6637.08
2025-07-25 17:50:43,842 - IOOppi_data - INFO : save new data to db IOOppi_PF_t: date value ... created_at updated_at
1446 2025-07-25 6637.08 ... 2025-07-25 17:50:43.833093 2025-07-25 17:50:43.833492
[1 rows x 5 columns]
2025-07-25 17:50:43,861 - IOOppi_data - INFO : save diff data to db: IOOppi_PF_t: no diff data
2025-07-25 17:50:43,866 - IOOppi_data - INFO : save data to db IOOppi_PF_g data:
date value
1442 2025-07-21 6610.42
1443 2025-07-22 6592.08
1444 2025-07-23 6601.67
1445 2025-07-24 6599.17
1446 2025-07-25 6637.08
2025-07-25 17:50:43,917 - IOOppi_data - INFO : save new data to db IOOppi_PF_g: date value ... created_at updated_at
1450 2025-07-25 6637.08 ... 2025-07-25 17:50:43.909933 2025-07-25 17:50:43.910323
[1 rows x 5 columns]
2025-07-25 17:50:43,934 - IOOppi_data - INFO : save diff data to db: IOOppi_PF_g: no diff data
/usr/local/lib/python3.10/site-packages/urllib3/connectionpool.py:1056: InsecureRequestWarning: Unverified HTTPS request is being made to host 'www.100ppi.com'. Adding certificate verification is strongly advised. See: https://urllib3.readthedocs.io/en/1.26.x/advanced-usage.html#ssl-warnings
warnings.warn(
2025-07-25 17:50:44,969 - IOOppi_data - INFO : save data to db IOOppi_m_t data:
date value
3815 2025-07-21 2974.0
3816 2025-07-22 2990.0
3817 2025-07-23 3024.0
3818 2025-07-24 2980.0
3819 2025-07-25 2964.0
2025-07-25 17:50:45,047 - IOOppi_data - INFO : save new data to db IOOppi_m_t: date value ... created_at updated_at
3819 2025-07-25 2964.0 ... 2025-07-25 17:50:45.039697 2025-07-25 17:50:45.040117
[1 rows x 5 columns]
2025-07-25 17:50:45,065 - IOOppi_data - INFO : save diff data to db: IOOppi_m_t: no diff data
2025-07-25 17:50:45,071 - IOOppi_data - INFO : save data to db IOOppi_m_g data:
date value
3815 2025-07-21 2974.0
3816 2025-07-22 2990.0
3817 2025-07-23 3024.0
3818 2025-07-24 2980.0
3819 2025-07-25 2964.0
2025-07-25 17:50:45,151 - IOOppi_data - INFO : save new data to db IOOppi_m_g: date value ... created_at updated_at
3822 2025-07-25 2964.0 ... 2025-07-25 17:50:45.143810 2025-07-25 17:50:45.144235
[1 rows x 5 columns]
2025-07-25 17:50:45,169 - IOOppi_data - INFO : save diff data to db: IOOppi_m_g: no diff data
/usr/local/lib/python3.10/site-packages/urllib3/connectionpool.py:1056: InsecureRequestWarning: Unverified HTTPS request is being made to host 'www.100ppi.com'. Adding certificate verification is strongly advised. See: https://urllib3.readthedocs.io/en/1.26.x/advanced-usage.html#ssl-warnings
warnings.warn(
2025-07-25 17:50:45,764 - IOOppi_data - INFO : save data to db IOOppi_y_t data:
date value
3585 2025-07-21 8364.0
3586 2025-07-22 8334.0
3587 2025-07-23 8334.0
3588 2025-07-24 8414.0
3589 2025-07-25 8414.0
2025-07-25 17:50:45,833 - IOOppi_data - INFO : save new data to db IOOppi_y_t: date value ... created_at updated_at
3589 2025-07-25 8414.0 ... 2025-07-25 17:50:45.826276 2025-07-25 17:50:45.826664
[1 rows x 5 columns]
2025-07-25 17:50:45,854 - IOOppi_data - INFO : save diff data to db: IOOppi_y_t: no diff data
2025-07-25 17:50:45,859 - IOOppi_data - INFO : save data to db IOOppi_y_g data:
date value
3585 2025-07-21 8364.0
3586 2025-07-22 8334.0
3587 2025-07-23 8334.0
3588 2025-07-24 8414.0
3589 2025-07-25 8414.0
2025-07-25 17:50:45,929 - IOOppi_data - INFO : save new data to db IOOppi_y_g: date value ... created_at updated_at
3592 2025-07-25 8414.0 ... 2025-07-25 17:50:45.922612 2025-07-25 17:50:45.923023
[1 rows x 5 columns]
2025-07-25 17:50:45,947 - IOOppi_data - INFO : save diff data to db: IOOppi_y_g: no diff data
/usr/local/lib/python3.10/site-packages/urllib3/connectionpool.py:1056: InsecureRequestWarning: Unverified HTTPS request is being made to host 'www.100ppi.com'. Adding certificate verification is strongly advised. See: https://urllib3.readthedocs.io/en/1.26.x/advanced-usage.html#ssl-warnings
warnings.warn(
2025-07-25 17:50:46,557 - IOOppi_data - INFO : save data to db IOOppi_a_t data:
date value
3551 2025-07-21 4295.0
3552 2025-07-22 4295.0
3553 2025-07-23 4295.0
3554 2025-07-24 4295.0
3555 2025-07-25 4295.0
2025-07-25 17:50:46,625 - IOOppi_data - INFO : save new data to db IOOppi_a_t: date value ... created_at updated_at
3555 2025-07-25 4295.0 ... 2025-07-25 17:50:46.618701 2025-07-25 17:50:46.619113
[1 rows x 5 columns]
2025-07-25 17:50:46,644 - IOOppi_data - INFO : save diff data to db: IOOppi_a_t: no diff data
2025-07-25 17:50:46,649 - IOOppi_data - INFO : save data to db IOOppi_a_g data:
date value
3551 2025-07-21 4295.0
3552 2025-07-22 4295.0
3553 2025-07-23 4295.0
3554 2025-07-24 4295.0
3555 2025-07-25 4295.0
2025-07-25 17:50:46,717 - IOOppi_data - INFO : save new data to db IOOppi_a_g: date value ... created_at updated_at
3558 2025-07-25 4295.0 ... 2025-07-25 17:50:46.710777 2025-07-25 17:50:46.711172
[1 rows x 5 columns]
2025-07-25 17:50:46,735 - IOOppi_data - INFO : save diff data to db: IOOppi_a_g: no diff data
/usr/local/lib/python3.10/site-packages/urllib3/connectionpool.py:1056: InsecureRequestWarning: Unverified HTTPS request is being made to host 'www.100ppi.com'. Adding certificate verification is strongly advised. See: https://urllib3.readthedocs.io/en/1.26.x/advanced-usage.html#ssl-warnings
warnings.warn(
2025-07-25 17:50:47,349 - IOOppi_data - INFO : save data to db IOOppi_SF_t data:
date value
2928 2025-07-21 5221.43
2929 2025-07-22 5382.86
2930 2025-07-23 5495.71
2931 2025-07-24 5452.86
2932 2025-07-25 5511.43
2025-07-25 17:50:47,410 - IOOppi_data - INFO : save new data to db IOOppi_SF_t: date value ... created_at updated_at
2932 2025-07-25 5511.43 ... 2025-07-25 17:50:47.403176 2025-07-25 17:50:47.403560
[1 rows x 5 columns]
2025-07-25 17:50:47,428 - IOOppi_data - INFO : save diff data to db: IOOppi_SF_t: no diff data
2025-07-25 17:50:47,433 - IOOppi_data - INFO : save data to db IOOppi_SF_g data:
date value
2928 2025-07-21 5221.43
2929 2025-07-22 5382.86
2930 2025-07-23 5495.71
2931 2025-07-24 5452.86
2932 2025-07-25 5511.43
2025-07-25 17:50:47,498 - IOOppi_data - INFO : save new data to db IOOppi_SF_g: date value ... created_at updated_at
2936 2025-07-25 5511.43 ... 2025-07-25 17:50:47.491193 2025-07-25 17:50:47.491567
[1 rows x 5 columns]
2025-07-25 17:50:47,518 - IOOppi_data - INFO : save diff data to db: IOOppi_SF_g: no diff data
/usr/local/lib/python3.10/site-packages/urllib3/connectionpool.py:1056: InsecureRequestWarning: Unverified HTTPS request is being made to host 'www.100ppi.com'. Adding certificate verification is strongly advised. See: https://urllib3.readthedocs.io/en/1.26.x/advanced-usage.html#ssl-warnings
warnings.warn(
2025-07-25 17:50:48,156 - IOOppi_data - INFO : save data to db IOOppi_jd_t data:
date value
3128 2025-07-21 3275.0
3129 2025-07-22 3300.0
3130 2025-07-23 3375.0
3131 2025-07-24 3440.0
3132 2025-07-25 3440.0
2025-07-25 17:50:48,223 - IOOppi_data - INFO : save new data to db IOOppi_jd_t: date value ... created_at updated_at
3132 2025-07-25 3440.0 ... 2025-07-25 17:50:48.215834 2025-07-25 17:50:48.216242
[1 rows x 5 columns]
/root/project/IOOppi_data/IOOppi_request.py:308: SettingWithCopyWarning:
A value is trying to be set on a copy of a slice from a DataFrame.
Try using .loc[row_indexer,col_indexer] = value instead
See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy
diff_df.loc[:, 'index_code'] = index_code
/root/project/IOOppi_data/IOOppi_request.py:309: SettingWithCopyWarning:
A value is trying to be set on a copy of a slice from a DataFrame.
Try using .loc[row_indexer,col_indexer] = value instead
See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy
diff_df.loc[:, 'created_at'] = datetime.datetime.now()
/root/project/IOOppi_data/IOOppi_request.py:310: SettingWithCopyWarning:
A value is trying to be set on a copy of a slice from a DataFrame.
Try using .loc[row_indexer,col_indexer] = value instead
See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy
diff_df.loc[:, 'updated_at'] = datetime.datetime.now()
2025-07-25 17:50:48,369 - IOOppi_data - INFO : save diff data to db IOOppi_jd_t: date ... updated_at
39 2014-01-03 ... 2025-07-25 17:50:48.361508
458 2015-09-21 ... 2025-07-25 17:50:48.361508
549 2016-02-03 ... 2025-07-25 17:50:48.361508
693 2016-09-05 ... 2025-07-25 17:50:48.361508
696 2016-09-08 ... 2025-07-25 17:50:48.361508
[5 rows x 6 columns]
2025-07-25 17:50:48,402 - IOOppi_data - INFO : save data to db IOOppi_jd_g data:
date value
3128 2025-07-21 3275.0
3129 2025-07-22 3300.0
3130 2025-07-23 3375.0
3131 2025-07-24 3440.0
3132 2025-07-25 3440.0
2025-07-25 17:50:48,466 - IOOppi_data - INFO : save new data to db IOOppi_jd_g: date value ... created_at updated_at
3135 2025-07-25 3440.0 ... 2025-07-25 17:50:48.459058 2025-07-25 17:50:48.459451
[1 rows x 5 columns]
/root/project/IOOppi_data/IOOppi_request.py:308: SettingWithCopyWarning:
A value is trying to be set on a copy of a slice from a DataFrame.
Try using .loc[row_indexer,col_indexer] = value instead
See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy
diff_df.loc[:, 'index_code'] = index_code
/root/project/IOOppi_data/IOOppi_request.py:309: SettingWithCopyWarning:
A value is trying to be set on a copy of a slice from a DataFrame.
Try using .loc[row_indexer,col_indexer] = value instead
See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy
diff_df.loc[:, 'created_at'] = datetime.datetime.now()
/root/project/IOOppi_data/IOOppi_request.py:310: SettingWithCopyWarning:
A value is trying to be set on a copy of a slice from a DataFrame.
Try using .loc[row_indexer,col_indexer] = value instead
See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy
diff_df.loc[:, 'updated_at'] = datetime.datetime.now()
2025-07-25 17:50:48,609 - IOOppi_data - INFO : save diff data to db IOOppi_jd_g: date ... updated_at
39 2014-01-03 ... 2025-07-25 17:50:48.601928
458 2015-09-21 ... 2025-07-25 17:50:48.601928
549 2016-02-03 ... 2025-07-25 17:50:48.601928
693 2016-09-05 ... 2025-07-25 17:50:48.601928
696 2016-09-08 ... 2025-07-25 17:50:48.601928
[5 rows x 6 columns]
/usr/local/lib/python3.10/site-packages/urllib3/connectionpool.py:1056: InsecureRequestWarning: Unverified HTTPS request is being made to host 'www.100ppi.com'. Adding certificate verification is strongly advised. See: https://urllib3.readthedocs.io/en/1.26.x/advanced-usage.html#ssl-warnings
warnings.warn(
2025-07-25 17:50:49,503 - IOOppi_data - INFO : save data to db IOOppi_SI_t data:
date value
932 2025-07-21 9620.0
933 2025-07-22 9840.0
934 2025-07-23 10080.0
935 2025-07-24 10180.0
936 2025-07-25 10180.0
2025-07-25 17:50:49,538 - IOOppi_data - INFO : save new data to db IOOppi_SI_t: date value ... created_at updated_at
936 2025-07-25 10180.0 ... 2025-07-25 17:50:49.531950 2025-07-25 17:50:49.532332
[1 rows x 5 columns]
2025-07-25 17:50:49,558 - IOOppi_data - INFO : save diff data to db: IOOppi_SI_t: no diff data
2025-07-25 17:50:49,562 - IOOppi_data - INFO : save data to db IOOppi_SI_g data:
date value
932 2025-07-21 9620.0
933 2025-07-22 9840.0
934 2025-07-23 10080.0
935 2025-07-24 10180.0
936 2025-07-25 10180.0
2025-07-25 17:50:49,597 - IOOppi_data - INFO : save new data to db IOOppi_SI_g: date value ... created_at updated_at
936 2025-07-25 10180.0 ... 2025-07-25 17:50:49.590837 2025-07-25 17:50:49.591211
[1 rows x 5 columns]
2025-07-25 17:50:49,615 - IOOppi_data - INFO : save diff data to db: IOOppi_SI_g: no diff data
/usr/local/lib/python3.10/site-packages/urllib3/connectionpool.py:1056: InsecureRequestWarning: Unverified HTTPS request is being made to host 'www.100ppi.com'. Adding certificate verification is strongly advised. See: https://urllib3.readthedocs.io/en/1.26.x/advanced-usage.html#ssl-warnings
warnings.warn(
2025-07-25 17:50:50,266 - IOOppi_data - INFO : save data to db IOOppi_l_t data:
date value
3811 2025-07-21 7383.33
3812 2025-07-22 7388.33
3813 2025-07-23 7405.00
3814 2025-07-24 7401.67
3815 2025-07-25 7450.00
2025-07-25 17:50:50,337 - IOOppi_data - INFO : save new data to db IOOppi_l_t: date value ... created_at updated_at
3815 2025-07-25 7450.0 ... 2025-07-25 17:50:50.330713 2025-07-25 17:50:50.331207
[1 rows x 5 columns]
2025-07-25 17:50:50,355 - IOOppi_data - INFO : save diff data to db: IOOppi_l_t: no diff data
2025-07-25 17:50:50,361 - IOOppi_data - INFO : save data to db IOOppi_l_g data:
date value
3811 2025-07-21 7383.33
3812 2025-07-22 7388.33
3813 2025-07-23 7405.00
3814 2025-07-24 7401.67
3815 2025-07-25 7450.00
2025-07-25 17:50:50,432 - IOOppi_data - INFO : save new data to db IOOppi_l_g: date value ... created_at updated_at
3818 2025-07-25 7450.0 ... 2025-07-25 17:50:50.425829 2025-07-25 17:50:50.426219
[1 rows x 5 columns]
2025-07-25 17:50:50,450 - IOOppi_data - INFO : save diff data to db: IOOppi_l_g: no diff data
/usr/local/lib/python3.10/site-packages/urllib3/connectionpool.py:1056: InsecureRequestWarning: Unverified HTTPS request is being made to host 'www.100ppi.com'. Adding certificate verification is strongly advised. See: https://urllib3.readthedocs.io/en/1.26.x/advanced-usage.html#ssl-warnings
warnings.warn(
2025-07-25 17:50:51,024 - IOOppi_data - INFO : save data to db IOOppi_bu_t data:
date value
3149 2025-07-21 3720.00
3150 2025-07-22 3723.33
3151 2025-07-23 3710.00
3152 2025-07-24 3700.00
3153 2025-07-25 3700.00
2025-07-25 17:50:51,087 - IOOppi_data - INFO : save new data to db IOOppi_bu_t: date value ... created_at updated_at
3154 2025-07-25 3700.0 ... 2025-07-25 17:50:51.080508 2025-07-25 17:50:51.080917
[1 rows x 5 columns]
/root/project/IOOppi_data/IOOppi_request.py:308: SettingWithCopyWarning:
A value is trying to be set on a copy of a slice from a DataFrame.
Try using .loc[row_indexer,col_indexer] = value instead
See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy
diff_df.loc[:, 'index_code'] = index_code
/root/project/IOOppi_data/IOOppi_request.py:309: SettingWithCopyWarning:
A value is trying to be set on a copy of a slice from a DataFrame.
Try using .loc[row_indexer,col_indexer] = value instead
See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy
diff_df.loc[:, 'created_at'] = datetime.datetime.now()
/root/project/IOOppi_data/IOOppi_request.py:310: SettingWithCopyWarning:
A value is trying to be set on a copy of a slice from a DataFrame.
Try using .loc[row_indexer,col_indexer] = value instead
See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy
diff_df.loc[:, 'updated_at'] = datetime.datetime.now()
2025-07-25 17:50:51,121 - IOOppi_data - INFO : save diff data to db IOOppi_bu_t: date ... updated_at
2560 2023-12-09 ... 2025-07-25 17:50:51.114310
[1 rows x 6 columns]
2025-07-25 17:50:51,144 - IOOppi_data - INFO : save data to db IOOppi_bu_g data:
date value
3149 2025-07-21 3720.00
3150 2025-07-22 3723.33
3151 2025-07-23 3710.00
3152 2025-07-24 3700.00
3153 2025-07-25 3700.00
2025-07-25 17:50:51,208 - IOOppi_data - INFO : save new data to db IOOppi_bu_g: date value ... created_at updated_at
3156 2025-07-25 3700.0 ... 2025-07-25 17:50:51.201115 2025-07-25 17:50:51.201495
[1 rows x 5 columns]
2025-07-25 17:50:51,226 - IOOppi_data - INFO : save diff data to db: IOOppi_bu_g: no diff data
/usr/local/lib/python3.10/site-packages/urllib3/connectionpool.py:1056: InsecureRequestWarning: Unverified HTTPS request is being made to host 'www.100ppi.com'. Adding certificate verification is strongly advised. See: https://urllib3.readthedocs.io/en/1.26.x/advanced-usage.html#ssl-warnings
warnings.warn(
2025-07-25 17:50:51,848 - IOOppi_data - INFO : save data to db IOOppi_al_t data:
date value
3814 2025-07-21 20720.00
3815 2025-07-22 20950.00
3816 2025-07-23 20950.00
3817 2025-07-24 20856.67
3818 2025-07-25 20730.00
2025-07-25 17:50:51,920 - IOOppi_data - INFO : save new data to db IOOppi_al_t: date value ... created_at updated_at
3818 2025-07-25 20730.0 ... 2025-07-25 17:50:51.913270 2025-07-25 17:50:51.913648
[1 rows x 5 columns]
2025-07-25 17:50:51,938 - IOOppi_data - INFO : save diff data to db: IOOppi_al_t: no diff data
2025-07-25 17:50:51,943 - IOOppi_data - INFO : save data to db IOOppi_al_g data:
date value
3814 2025-07-21 20720.00
3815 2025-07-22 20950.00
3816 2025-07-23 20950.00
3817 2025-07-24 20856.67
3818 2025-07-25 20730.00
2025-07-25 17:50:52,015 - IOOppi_data - INFO : save new data to db IOOppi_al_g: date value ... created_at updated_at
3821 2025-07-25 20730.0 ... 2025-07-25 17:50:52.008818 2025-07-25 17:50:52.009210
[1 rows x 5 columns]
2025-07-25 17:50:52,034 - IOOppi_data - INFO : save diff data to db: IOOppi_al_g: no diff data
/usr/local/lib/python3.10/site-packages/urllib3/connectionpool.py:1056: InsecureRequestWarning: Unverified HTTPS request is being made to host 'www.100ppi.com'. Adding certificate verification is strongly advised. See: https://urllib3.readthedocs.io/en/1.26.x/advanced-usage.html#ssl-warnings
warnings.warn(
2025-07-25 17:50:52,699 - IOOppi_data - INFO : save data to db IOOppi_SM_t data:
date value
2928 2025-07-21 5692.0
2929 2025-07-22 5726.0
2930 2025-07-23 5770.0
2931 2025-07-24 5710.0
2932 2025-07-25 5850.0
2025-07-25 17:50:52,760 - IOOppi_data - INFO : save new data to db IOOppi_SM_t: date value ... created_at updated_at
2932 2025-07-25 5850.0 ... 2025-07-25 17:50:52.753138 2025-07-25 17:50:52.753530
[1 rows x 5 columns]
2025-07-25 17:50:52,779 - IOOppi_data - INFO : save diff data to db: IOOppi_SM_t: no diff data
2025-07-25 17:50:52,784 - IOOppi_data - INFO : save data to db IOOppi_SM_g data:
date value
2928 2025-07-21 5692.0
2929 2025-07-22 5726.0
2930 2025-07-23 5770.0
2931 2025-07-24 5710.0
2932 2025-07-25 5850.0
2025-07-25 17:50:52,845 - IOOppi_data - INFO : save new data to db IOOppi_SM_g: date value ... created_at updated_at
2936 2025-07-25 5850.0 ... 2025-07-25 17:50:52.838419 2025-07-25 17:50:52.838826
[1 rows x 5 columns]
2025-07-25 17:50:52,863 - IOOppi_data - INFO : save diff data to db: IOOppi_SM_g: no diff data
/usr/local/lib/python3.10/site-packages/urllib3/connectionpool.py:1056: InsecureRequestWarning: Unverified HTTPS request is being made to host 'www.100ppi.com'. Adding certificate verification is strongly advised. See: https://urllib3.readthedocs.io/en/1.26.x/advanced-usage.html#ssl-warnings
warnings.warn(
2025-07-25 17:50:53,527 - IOOppi_data - INFO : save data to db IOOppi_CY_t data:
date value
2203 2025-07-21 23275.0
2204 2025-07-22 23450.0
2205 2025-07-23 23450.0
2206 2025-07-24 23450.0
2207 2025-07-25 23450.0
2025-07-25 17:50:53,578 - IOOppi_data - INFO : save new data to db IOOppi_CY_t: date value ... created_at updated_at
2207 2025-07-25 23450.0 ... 2025-07-25 17:50:53.571209 2025-07-25 17:50:53.571594
[1 rows x 5 columns]
2025-07-25 17:50:53,595 - IOOppi_data - INFO : save diff data to db: IOOppi_CY_t: no diff data
2025-07-25 17:50:53,600 - IOOppi_data - INFO : save data to db IOOppi_CY_g data:
date value
2203 2025-07-21 23275.0
2204 2025-07-22 23450.0
2205 2025-07-23 23450.0
2206 2025-07-24 23450.0
2207 2025-07-25 23450.0
2025-07-25 17:50:53,652 - IOOppi_data - INFO : save new data to db IOOppi_CY_g: date value ... created_at updated_at
2211 2025-07-25 23450.0 ... 2025-07-25 17:50:53.645453 2025-07-25 17:50:53.645846
[1 rows x 5 columns]
2025-07-25 17:50:53,669 - IOOppi_data - INFO : save diff data to db: IOOppi_CY_g: no diff data
/usr/local/lib/python3.10/site-packages/urllib3/connectionpool.py:1056: InsecureRequestWarning: Unverified HTTPS request is being made to host 'www.100ppi.com'. Adding certificate verification is strongly advised. See: https://urllib3.readthedocs.io/en/1.26.x/advanced-usage.html#ssl-warnings
warnings.warn(
2025-07-25 17:50:54,300 - IOOppi_data - INFO : save data to db IOOppi_UR_t data:
date value
1718 2025-07-21 1830.0
1719 2025-07-22 1830.0
1720 2025-07-23 1835.0
1721 2025-07-24 1832.5
1722 2025-07-25 1825.0
2025-07-25 17:50:54,345 - IOOppi_data - INFO : save new data to db IOOppi_UR_t: date value ... created_at updated_at
1722 2025-07-25 1825.0 ... 2025-07-25 17:50:54.338112 2025-07-25 17:50:54.338494
[1 rows x 5 columns]
2025-07-25 17:50:54,363 - IOOppi_data - INFO : save diff data to db: IOOppi_UR_t: no diff data
2025-07-25 17:50:54,368 - IOOppi_data - INFO : save data to db IOOppi_UR_g data:
date value
1718 2025-07-21 1830.0
1719 2025-07-22 1830.0
1720 2025-07-23 1835.0
1721 2025-07-24 1832.5
1722 2025-07-25 1825.0
2025-07-25 17:50:54,414 - IOOppi_data - INFO : save new data to db IOOppi_UR_g: date value ... created_at updated_at
1726 2025-07-25 1825.0 ... 2025-07-25 17:50:54.407186 2025-07-25 17:50:54.407567
[1 rows x 5 columns]
2025-07-25 17:50:54,431 - IOOppi_data - INFO : save diff data to db: IOOppi_UR_g: no diff data
/usr/local/lib/python3.10/site-packages/urllib3/connectionpool.py:1056: InsecureRequestWarning: Unverified HTTPS request is being made to host 'www.100ppi.com'. Adding certificate verification is strongly advised. See: https://urllib3.readthedocs.io/en/1.26.x/advanced-usage.html#ssl-warnings
warnings.warn(
2025-07-25 17:50:55,121 - IOOppi_data - INFO : save data to db IOOppi_ni_t data:
date value
2790 2025-07-21 123350.00
2791 2025-07-22 123783.33
2792 2025-07-23 124416.67
2793 2025-07-24 125000.00
2794 2025-07-25 124916.67
2025-07-25 17:50:55,179 - IOOppi_data - INFO : save new data to db IOOppi_ni_t: date ... updated_at
2794 2025-07-25 ... 2025-07-25 17:50:55.173210
[1 rows x 5 columns]
2025-07-25 17:50:55,198 - IOOppi_data - INFO : save diff data to db: IOOppi_ni_t: no diff data
2025-07-25 17:50:55,203 - IOOppi_data - INFO : save data to db IOOppi_ni_g data:
date value
2790 2025-07-21 123350.00
2791 2025-07-22 123783.33
2792 2025-07-23 124416.67
2793 2025-07-24 125000.00
2794 2025-07-25 124916.67
2025-07-25 17:50:55,261 - IOOppi_data - INFO : save new data to db IOOppi_ni_g: date ... updated_at
2797 2025-07-25 ... 2025-07-25 17:50:55.255827
[1 rows x 5 columns]
2025-07-25 17:50:55,279 - IOOppi_data - INFO : save diff data to db: IOOppi_ni_g: no diff data
/usr/local/lib/python3.10/site-packages/urllib3/connectionpool.py:1056: InsecureRequestWarning: Unverified HTTPS request is being made to host 'www.100ppi.com'. Adding certificate verification is strongly advised. See: https://urllib3.readthedocs.io/en/1.26.x/advanced-usage.html#ssl-warnings
warnings.warn(
2025-07-25 17:50:55,986 - IOOppi_data - INFO : save data to db IOOppi_v_t data:
date value
3815 2025-07-21 4837.0
3816 2025-07-22 4911.0
3817 2025-07-23 4907.0
3818 2025-07-24 4918.0
3819 2025-07-25 5024.0
2025-07-25 17:50:56,058 - IOOppi_data - INFO : save new data to db IOOppi_v_t: date value ... created_at updated_at
3819 2025-07-25 5024.0 ... 2025-07-25 17:50:56.051523 2025-07-25 17:50:56.051957
[1 rows x 5 columns]
2025-07-25 17:50:56,076 - IOOppi_data - INFO : save diff data to db: IOOppi_v_t: no diff data
2025-07-25 17:50:56,082 - IOOppi_data - INFO : save data to db IOOppi_v_g data:
date value
3815 2025-07-21 4837.0
3816 2025-07-22 4911.0
3817 2025-07-23 4907.0
3818 2025-07-24 4918.0
3819 2025-07-25 5024.0
2025-07-25 17:50:56,155 - IOOppi_data - INFO : save new data to db IOOppi_v_g: date value ... created_at updated_at
3822 2025-07-25 5024.0 ... 2025-07-25 17:50:56.148267 2025-07-25 17:50:56.148643
[1 rows x 5 columns]
2025-07-25 17:50:56,174 - IOOppi_data - INFO : save diff data to db: IOOppi_v_g: no diff data
/usr/local/lib/python3.10/site-packages/urllib3/connectionpool.py:1056: InsecureRequestWarning: Unverified HTTPS request is being made to host 'www.100ppi.com'. Adding certificate verification is strongly advised. See: https://urllib3.readthedocs.io/en/1.26.x/advanced-usage.html#ssl-warnings
warnings.warn(
2025-07-25 17:50:56,919 - IOOppi_data - INFO : save data to db IOOppi_pp_t data:
date value
3054 2025-07-21 7313.33
3055 2025-07-22 7291.67
3056 2025-07-23 7303.33
3057 2025-07-24 7295.00
3058 2025-07-25 7295.00
2025-07-25 17:50:56,981 - IOOppi_data - INFO : save new data to db IOOppi_pp_t: date value ... created_at updated_at
3058 2025-07-25 7295.0 ... 2025-07-25 17:50:56.974678 2025-07-25 17:50:56.975095
[1 rows x 5 columns]
2025-07-25 17:50:57,000 - IOOppi_data - INFO : save diff data to db: IOOppi_pp_t: no diff data
2025-07-25 17:50:57,006 - IOOppi_data - INFO : save data to db IOOppi_pp_g data:
date value
3054 2025-07-21 7313.33
3055 2025-07-22 7291.67
3056 2025-07-23 7303.33
3057 2025-07-24 7295.00
3058 2025-07-25 7295.00
2025-07-25 17:50:57,068 - IOOppi_data - INFO : save new data to db IOOppi_pp_g: date value ... created_at updated_at
3061 2025-07-25 7295.0 ... 2025-07-25 17:50:57.061067 2025-07-25 17:50:57.061447
[1 rows x 5 columns]
2025-07-25 17:50:57,088 - IOOppi_data - INFO : save diff data to db: IOOppi_pp_g: no diff data
/usr/local/lib/python3.10/site-packages/urllib3/connectionpool.py:1056: InsecureRequestWarning: Unverified HTTPS request is being made to host 'www.100ppi.com'. Adding certificate verification is strongly advised. See: https://urllib3.readthedocs.io/en/1.26.x/advanced-usage.html#ssl-warnings
warnings.warn(
2025-07-25 17:50:57,780 - IOOppi_data - INFO : save data to db IOOppi_CF_t data:
date value
3816 2025-07-21 15596.33
3817 2025-07-22 15549.00
3818 2025-07-23 15551.33
3819 2025-07-24 15573.50
3820 2025-07-25 15557.50
2025-07-25 17:50:57,852 - IOOppi_data - INFO : save new data to db IOOppi_CF_t: date value ... created_at updated_at
3820 2025-07-25 15557.5 ... 2025-07-25 17:50:57.845331 2025-07-25 17:50:57.845718
[1 rows x 5 columns]
2025-07-25 17:50:57,871 - IOOppi_data - INFO : save diff data to db: IOOppi_CF_t: no diff data
2025-07-25 17:50:57,877 - IOOppi_data - INFO : save data to db IOOppi_CF_g data:
date value
3816 2025-07-21 15596.33
3817 2025-07-22 15549.00
3818 2025-07-23 15551.33
3819 2025-07-24 15573.50
3820 2025-07-25 15557.50
2025-07-25 17:50:57,956 - IOOppi_data - INFO : save new data to db IOOppi_CF_g: date value ... created_at updated_at
3824 2025-07-25 15557.5 ... 2025-07-25 17:50:57.949077 2025-07-25 17:50:57.949500
[1 rows x 5 columns]
2025-07-25 17:50:57,974 - IOOppi_data - INFO : save diff data to db: IOOppi_CF_g: no diff data
/usr/local/lib/python3.10/site-packages/urllib3/connectionpool.py:1056: InsecureRequestWarning: Unverified HTTPS request is being made to host 'www.100ppi.com'. Adding certificate verification is strongly advised. See: https://urllib3.readthedocs.io/en/1.26.x/advanced-usage.html#ssl-warnings
warnings.warn(
2025-07-25 17:50:58,581 - IOOppi_data - INFO : save data to db IOOppi_pb_t data:
date value
3761 2025-07-21 16862.50
3762 2025-07-22 16806.25
3763 2025-07-23 16806.25
3764 2025-07-24 16768.75
3765 2025-07-25 16818.75
2025-07-25 17:50:58,654 - IOOppi_data - INFO : save new data to db IOOppi_pb_t: date ... updated_at
3765 2025-07-25 ... 2025-07-25 17:50:58.648645
[1 rows x 5 columns]
2025-07-25 17:50:58,673 - IOOppi_data - INFO : save diff data to db: IOOppi_pb_t: no diff data
2025-07-25 17:50:58,678 - IOOppi_data - INFO : save data to db IOOppi_pb_g data:
date value
3761 2025-07-21 16862.50
3762 2025-07-22 16806.25
3763 2025-07-23 16806.25
3764 2025-07-24 16768.75
3765 2025-07-25 16818.75
2025-07-25 17:50:58,822 - IOOppi_data - INFO : save new data to db IOOppi_pb_g: date ... updated_at
3768 2025-07-25 ... 2025-07-25 17:50:58.816769
[1 rows x 5 columns]
2025-07-25 17:50:58,841 - IOOppi_data - INFO : save diff data to db: IOOppi_pb_g: no diff data
/usr/local/lib/python3.10/site-packages/urllib3/connectionpool.py:1056: InsecureRequestWarning: Unverified HTTPS request is being made to host 'www.100ppi.com'. Adding certificate verification is strongly advised. See: https://urllib3.readthedocs.io/en/1.26.x/advanced-usage.html#ssl-warnings
warnings.warn(
2025-07-25 17:50:59,485 - IOOppi_data - INFO : save data to db IOOppi_hc_t data:
date value
3036 2025-07-21 3406.67
3037 2025-07-22 3446.67
3038 2025-07-23 3470.00
3039 2025-07-24 3476.67
3040 2025-07-25 3476.67
2025-07-25 17:50:59,547 - IOOppi_data - INFO : save new data to db IOOppi_hc_t: date value ... created_at updated_at
3040 2025-07-25 3476.67 ... 2025-07-25 17:50:59.539900 2025-07-25 17:50:59.540290
[1 rows x 5 columns]
2025-07-25 17:50:59,565 - IOOppi_data - INFO : save diff data to db: IOOppi_hc_t: no diff data
2025-07-25 17:50:59,571 - IOOppi_data - INFO : save data to db IOOppi_hc_g data:
date value
3036 2025-07-21 3406.67
3037 2025-07-22 3446.67
3038 2025-07-23 3470.00
3039 2025-07-24 3476.67
3040 2025-07-25 3476.67
2025-07-25 17:50:59,633 - IOOppi_data - INFO : save new data to db IOOppi_hc_g: date value ... created_at updated_at
3043 2025-07-25 3476.67 ... 2025-07-25 17:50:59.626185 2025-07-25 17:50:59.626564
[1 rows x 5 columns]
2025-07-25 17:50:59,650 - IOOppi_data - INFO : save diff data to db: IOOppi_hc_g: no diff data
/usr/local/lib/python3.10/site-packages/urllib3/connectionpool.py:1056: InsecureRequestWarning: Unverified HTTPS request is being made to host 'www.100ppi.com'. Adding certificate verification is strongly advised. See: https://urllib3.readthedocs.io/en/1.26.x/advanced-usage.html#ssl-warnings
warnings.warn(
2025-07-25 17:51:00,400 - IOOppi_data - INFO : save data to db IOOppi_fu_t data:
date value
3316 2025-07-21 5312.5
3317 2025-07-22 5312.5
3318 2025-07-23 5275.0
3319 2025-07-24 5275.0
3320 2025-07-25 5275.0
2025-07-25 17:51:00,466 - IOOppi_data - INFO : save new data to db IOOppi_fu_t: date value ... created_at updated_at
3320 2025-07-25 5275.0 ... 2025-07-25 17:51:00.459385 2025-07-25 17:51:00.459797
[1 rows x 5 columns]
2025-07-25 17:51:00,484 - IOOppi_data - INFO : save diff data to db: IOOppi_fu_t: no diff data
2025-07-25 17:51:00,490 - IOOppi_data - INFO : save data to db IOOppi_fu_g data:
date value
3316 2025-07-21 5312.5
3317 2025-07-22 5312.5
3318 2025-07-23 5275.0
3319 2025-07-24 5275.0
3320 2025-07-25 5275.0
2025-07-25 17:51:00,562 - IOOppi_data - INFO : save new data to db IOOppi_fu_g: date value ... created_at updated_at
3807 2025-07-25 5275.0 ... 2025-07-25 17:51:00.554975 2025-07-25 17:51:00.555387
[1 rows x 5 columns]
2025-07-25 17:51:00,580 - IOOppi_data - INFO : save diff data to db: IOOppi_fu_g: no diff data
/usr/local/lib/python3.10/site-packages/urllib3/connectionpool.py:1056: InsecureRequestWarning: Unverified HTTPS request is being made to host 'www.100ppi.com'. Adding certificate verification is strongly advised. See: https://urllib3.readthedocs.io/en/1.26.x/advanced-usage.html#ssl-warnings
warnings.warn(
2025-07-25 17:51:01,244 - IOOppi_data - INFO : save data to db IOOppi_lh_t data:
date value
1380 2025-07-21 14480.0
1381 2025-07-22 14450.0
1382 2025-07-23 14420.0
1383 2025-07-24 14380.0
1384 2025-07-25 14370.0
2025-07-25 17:51:01,289 - IOOppi_data - INFO : save new data to db IOOppi_lh_t: date value ... created_at updated_at
1384 2025-07-25 14370.0 ... 2025-07-25 17:51:01.281145 2025-07-25 17:51:01.281589
[1 rows x 5 columns]
/root/project/IOOppi_data/IOOppi_request.py:308: SettingWithCopyWarning:
A value is trying to be set on a copy of a slice from a DataFrame.
Try using .loc[row_indexer,col_indexer] = value instead
See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy
diff_df.loc[:, 'index_code'] = index_code
/root/project/IOOppi_data/IOOppi_request.py:309: SettingWithCopyWarning:
A value is trying to be set on a copy of a slice from a DataFrame.
Try using .loc[row_indexer,col_indexer] = value instead
See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy
diff_df.loc[:, 'created_at'] = datetime.datetime.now()
/root/project/IOOppi_data/IOOppi_request.py:310: SettingWithCopyWarning:
A value is trying to be set on a copy of a slice from a DataFrame.
Try using .loc[row_indexer,col_indexer] = value instead
See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy
diff_df.loc[:, 'updated_at'] = datetime.datetime.now()
2025-07-25 17:51:01,521 - IOOppi_data - INFO : save diff data to db IOOppi_lh_t: date ... updated_at
116 2021-07-05 ... 2025-07-25 17:51:01.514019
117 2021-07-06 ... 2025-07-25 17:51:01.514019
121 2021-07-12 ... 2025-07-25 17:51:01.514019
122 2021-07-13 ... 2025-07-25 17:51:01.514019
194 2021-11-01 ... 2025-07-25 17:51:01.514019
[5 rows x 6 columns]
2025-07-25 17:51:01,565 - IOOppi_data - INFO : save data to db IOOppi_lh_g data:
date value
1380 2025-07-21 14480.0
1381 2025-07-22 14450.0
1382 2025-07-23 14420.0
1383 2025-07-24 14380.0
1384 2025-07-25 14370.0
2025-07-25 17:51:01,607 - IOOppi_data - INFO : save new data to db IOOppi_lh_g: date value ... created_at updated_at
1387 2025-07-25 14370.0 ... 2025-07-25 17:51:01.600828 2025-07-25 17:51:01.601221
[1 rows x 5 columns]
/root/project/IOOppi_data/IOOppi_request.py:308: SettingWithCopyWarning:
A value is trying to be set on a copy of a slice from a DataFrame.
Try using .loc[row_indexer,col_indexer] = value instead
See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy
diff_df.loc[:, 'index_code'] = index_code
/root/project/IOOppi_data/IOOppi_request.py:309: SettingWithCopyWarning:
A value is trying to be set on a copy of a slice from a DataFrame.
Try using .loc[row_indexer,col_indexer] = value instead
See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy
diff_df.loc[:, 'created_at'] = datetime.datetime.now()
/root/project/IOOppi_data/IOOppi_request.py:310: SettingWithCopyWarning:
A value is trying to be set on a copy of a slice from a DataFrame.
Try using .loc[row_indexer,col_indexer] = value instead
See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy
diff_df.loc[:, 'updated_at'] = datetime.datetime.now()
2025-07-25 17:51:01,845 - IOOppi_data - INFO : save diff data to db IOOppi_lh_g: date ... updated_at
116 2021-07-05 ... 2025-07-25 17:51:01.837178
117 2021-07-06 ... 2025-07-25 17:51:01.837178
121 2021-07-12 ... 2025-07-25 17:51:01.837178
122 2021-07-13 ... 2025-07-25 17:51:01.837178
194 2021-11-01 ... 2025-07-25 17:51:01.837178
[5 rows x 6 columns]
/usr/local/lib/python3.10/site-packages/urllib3/connectionpool.py:1056: InsecureRequestWarning: Unverified HTTPS request is being made to host 'www.100ppi.com'. Adding certificate verification is strongly advised. See: https://urllib3.readthedocs.io/en/1.26.x/advanced-usage.html#ssl-warnings
warnings.warn(
2025-07-25 17:51:02,622 - IOOppi_data - INFO : save data to db IOOppi_cu_t data:
date value
3812 2025-07-21 79651.67
3813 2025-07-22 79766.67
3814 2025-07-23 79861.67
3815 2025-07-24 79820.00
3816 2025-07-25 79538.33
2025-07-25 17:51:02,695 - IOOppi_data - INFO : save new data to db IOOppi_cu_t: date ... updated_at
3816 2025-07-25 ... 2025-07-25 17:51:02.687310
[1 rows x 5 columns]
2025-07-25 17:51:02,714 - IOOppi_data - INFO : save diff data to db: IOOppi_cu_t: no diff data
2025-07-25 17:51:02,721 - IOOppi_data - INFO : save data to db IOOppi_cu_g data:
date value
3812 2025-07-21 79651.67
3813 2025-07-22 79766.67
3814 2025-07-23 79861.67
3815 2025-07-24 79820.00
3816 2025-07-25 79538.33
2025-07-25 17:51:02,801 - IOOppi_data - INFO : save new data to db IOOppi_cu_g: date ... updated_at
3819 2025-07-25 ... 2025-07-25 17:51:02.794083
[1 rows x 5 columns]
2025-07-25 17:51:02,821 - IOOppi_data - INFO : save diff data to db: IOOppi_cu_g: no diff data
/usr/local/lib/python3.10/site-packages/urllib3/connectionpool.py:1056: InsecureRequestWarning: Unverified HTTPS request is being made to host 'www.100ppi.com'. Adding certificate verification is strongly advised. See: https://urllib3.readthedocs.io/en/1.26.x/advanced-usage.html#ssl-warnings
warnings.warn(
2025-07-25 17:51:03,355 - IOOppi_data - INFO : save data to db IOOppi_PM_t data:
date value
2947 2024-06-26 2440.0
2948 2024-06-27 2460.0
2949 2024-06-28 2460.0
2950 2024-06-29 2460.0
2951 2024-06-30 2460.0
2025-07-25 17:51:03,411 - IOOppi_data - INFO : save new data to db: IOOppi_PM_t: no new data
2025-07-25 17:51:03,411 - IOOppi_data - INFO : save diff data to db: IOOppi_PM_t: no diff data
2025-07-25 17:51:03,417 - IOOppi_data - INFO : save data to db IOOppi_PM_g data:
date value
2947 2024-06-26 2440.0
2948 2024-06-27 2460.0
2949 2024-06-28 2460.0
2950 2024-06-29 2460.0
2951 2024-06-30 2460.0
2025-07-25 17:51:03,481 - IOOppi_data - INFO : save new data to db: IOOppi_PM_g: no new data
2025-07-25 17:51:03,481 - IOOppi_data - INFO : save diff data to db: IOOppi_PM_g: no diff data
/usr/local/lib/python3.10/site-packages/urllib3/connectionpool.py:1056: InsecureRequestWarning: Unverified HTTPS request is being made to host 'www.100ppi.com'. Adding certificate verification is strongly advised. See: https://urllib3.readthedocs.io/en/1.26.x/advanced-usage.html#ssl-warnings
warnings.warn(
2025-07-25 17:51:04,135 - IOOppi_data - INFO : save data to db IOOppi_sn_t data:
date value
2790 2025-07-21 267362.5
2791 2025-07-22 266600.0
2792 2025-07-23 269150.0
2793 2025-07-24 273025.0
2794 2025-07-25 271437.5
2025-07-25 17:51:04,196 - IOOppi_data - INFO : save new data to db IOOppi_sn_t: date ... updated_at
2794 2025-07-25 ... 2025-07-25 17:51:04.189364
[1 rows x 5 columns]
2025-07-25 17:51:04,214 - IOOppi_data - INFO : save diff data to db: IOOppi_sn_t: no diff data
2025-07-25 17:51:04,220 - IOOppi_data - INFO : save data to db IOOppi_sn_g data:
date value
2790 2025-07-21 267362.5
2791 2025-07-22 266600.0
2792 2025-07-23 269150.0
2793 2025-07-24 273025.0
2794 2025-07-25 271437.5
2025-07-25 17:51:04,281 - IOOppi_data - INFO : save new data to db IOOppi_sn_g: date ... updated_at
2797 2025-07-25 ... 2025-07-25 17:51:04.275520
[1 rows x 5 columns]
2025-07-25 17:51:04,299 - IOOppi_data - INFO : save diff data to db: IOOppi_sn_g: no diff data
/usr/local/lib/python3.10/site-packages/urllib3/connectionpool.py:1056: InsecureRequestWarning: Unverified HTTPS request is being made to host 'www.100ppi.com'. Adding certificate verification is strongly advised. See: https://urllib3.readthedocs.io/en/1.26.x/advanced-usage.html#ssl-warnings
warnings.warn(
2025-07-25 17:51:04,945 - IOOppi_data - INFO : save data to db IOOppi_zn_t data:
date value
3811 2025-07-21 22814.0
3812 2025-07-22 22770.0
3813 2025-07-23 22818.0
3814 2025-07-24 22852.0
3815 2025-07-25 22756.0
2025-07-25 17:51:05,016 - IOOppi_data - INFO : save new data to db IOOppi_zn_t: date value ... created_at updated_at
3815 2025-07-25 22756.0 ... 2025-07-25 17:51:05.009695 2025-07-25 17:51:05.010111
[1 rows x 5 columns]
2025-07-25 17:51:05,035 - IOOppi_data - INFO : save diff data to db: IOOppi_zn_t: no diff data
2025-07-25 17:51:05,041 - IOOppi_data - INFO : save data to db IOOppi_zn_g data:
date value
3811 2025-07-21 22814.0
3812 2025-07-22 22770.0
3813 2025-07-23 22818.0
3814 2025-07-24 22852.0
3815 2025-07-25 22756.0
2025-07-25 17:51:05,113 - IOOppi_data - INFO : save new data to db IOOppi_zn_g: date value ... created_at updated_at
3818 2025-07-25 22756.0 ... 2025-07-25 17:51:05.106350 2025-07-25 17:51:05.106733
[1 rows x 5 columns]
2025-07-25 17:51:05,137 - IOOppi_data - INFO : save diff data to db: IOOppi_zn_g: no diff data
/usr/local/lib/python3.10/site-packages/urllib3/connectionpool.py:1056: InsecureRequestWarning: Unverified HTTPS request is being made to host 'www.100ppi.com'. Adding certificate verification is strongly advised. See: https://urllib3.readthedocs.io/en/1.26.x/advanced-usage.html#ssl-warnings
warnings.warn(
2025-07-25 17:51:05,885 - IOOppi_data - INFO : save data to db IOOppi_wr_t data:
date value
3774 2025-07-21 3372.5
3775 2025-07-22 3497.5
3776 2025-07-23 3497.5
3777 2025-07-24 3497.5
3778 2025-07-25 3497.5
2025-07-25 17:51:05,956 - IOOppi_data - INFO : save new data to db IOOppi_wr_t: date value ... created_at updated_at
3778 2025-07-25 3497.5 ... 2025-07-25 17:51:05.949307 2025-07-25 17:51:05.949684
[1 rows x 5 columns]
2025-07-25 17:51:05,974 - IOOppi_data - INFO : save diff data to db: IOOppi_wr_t: no diff data
2025-07-25 17:51:05,979 - IOOppi_data - INFO : save data to db IOOppi_wr_g data:
date value
3774 2025-07-21 3372.5
3775 2025-07-22 3497.5
3776 2025-07-23 3497.5
3777 2025-07-24 3497.5
3778 2025-07-25 3497.5
2025-07-25 17:51:06,050 - IOOppi_data - INFO : save new data to db IOOppi_wr_g: date value ... created_at updated_at
3781 2025-07-25 3497.5 ... 2025-07-25 17:51:06.043323 2025-07-25 17:51:06.043699
[1 rows x 5 columns]
2025-07-25 17:51:06,069 - IOOppi_data - INFO : save diff data to db: IOOppi_wr_g: no diff data
/usr/local/lib/python3.10/site-packages/urllib3/connectionpool.py:1056: InsecureRequestWarning: Unverified HTTPS request is being made to host 'www.100ppi.com'. Adding certificate verification is strongly advised. See: https://urllib3.readthedocs.io/en/1.26.x/advanced-usage.html#ssl-warnings
warnings.warn(
2025-07-25 17:51:07,035 - IOOppi_data - INFO : save data to db IOOppi_pg_t data:
date value
1571 2025-07-21 4807.5
1572 2025-07-22 4782.5
1573 2025-07-23 4770.0
1574 2025-07-24 4750.0
1575 2025-07-25 4762.5
2025-07-25 17:51:07,078 - IOOppi_data - INFO : save new data to db IOOppi_pg_t: date value ... created_at updated_at
1575 2025-07-25 4762.5 ... 2025-07-25 17:51:07.072027 2025-07-25 17:51:07.072401
[1 rows x 5 columns]
2025-07-25 17:51:07,097 - IOOppi_data - INFO : save diff data to db: IOOppi_pg_t: no diff data
2025-07-25 17:51:07,102 - IOOppi_data - INFO : save data to db IOOppi_pg_g data:
date value
1571 2025-07-21 4807.5
1572 2025-07-22 4782.5
1573 2025-07-23 4770.0
1574 2025-07-24 4750.0
1575 2025-07-25 4762.5
2025-07-25 17:51:07,146 - IOOppi_data - INFO : save new data to db IOOppi_pg_g: date value ... created_at updated_at
1578 2025-07-25 4762.5 ... 2025-07-25 17:51:07.139293 2025-07-25 17:51:07.139652
[1 rows x 5 columns]
2025-07-25 17:51:07,163 - IOOppi_data - INFO : save diff data to db: IOOppi_pg_g: no diff data
/usr/local/lib/python3.10/site-packages/urllib3/connectionpool.py:1056: InsecureRequestWarning: Unverified HTTPS request is being made to host 'www.100ppi.com'. Adding certificate verification is strongly advised. See: https://urllib3.readthedocs.io/en/1.26.x/advanced-usage.html#ssl-warnings
warnings.warn(
2025-07-25 17:51:07,798 - IOOppi_data - INFO : save data to db IOOppi_cs_t data:
date value
2845 2025-07-21 2332.86
2846 2025-07-22 2338.57
2847 2025-07-23 2340.00
2848 2025-07-24 2340.00
2849 2025-07-25 2332.86
2025-07-25 17:51:07,860 - IOOppi_data - INFO : save new data to db IOOppi_cs_t: date value ... created_at updated_at
2849 2025-07-25 2332.86 ... 2025-07-25 17:51:07.852979 2025-07-25 17:51:07.853364
[1 rows x 5 columns]
/root/project/IOOppi_data/IOOppi_request.py:308: SettingWithCopyWarning:
A value is trying to be set on a copy of a slice from a DataFrame.
Try using .loc[row_indexer,col_indexer] = value instead
See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy
diff_df.loc[:, 'index_code'] = index_code
/root/project/IOOppi_data/IOOppi_request.py:309: SettingWithCopyWarning:
A value is trying to be set on a copy of a slice from a DataFrame.
Try using .loc[row_indexer,col_indexer] = value instead
See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy
diff_df.loc[:, 'created_at'] = datetime.datetime.now()
/root/project/IOOppi_data/IOOppi_request.py:310: SettingWithCopyWarning:
A value is trying to be set on a copy of a slice from a DataFrame.
Try using .loc[row_indexer,col_indexer] = value instead
See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy
diff_df.loc[:, 'updated_at'] = datetime.datetime.now()
2025-07-25 17:51:07,902 - IOOppi_data - INFO : save diff data to db IOOppi_cs_t: date ... updated_at
2848 2025-07-24 ... 2025-07-25 17:51:07.895242
[1 rows x 6 columns]
2025-07-25 17:51:07,925 - IOOppi_data - INFO : save data to db IOOppi_cs_g data:
date value
2845 2025-07-21 2332.86
2846 2025-07-22 2338.57
2847 2025-07-23 2340.00
2848 2025-07-24 2340.00
2849 2025-07-25 2332.86
2025-07-25 17:51:07,985 - IOOppi_data - INFO : save new data to db IOOppi_cs_g: date value ... created_at updated_at
2852 2025-07-25 2332.86 ... 2025-07-25 17:51:07.977919 2025-07-25 17:51:07.978293
[1 rows x 5 columns]
/root/project/IOOppi_data/IOOppi_request.py:308: SettingWithCopyWarning:
A value is trying to be set on a copy of a slice from a DataFrame.
Try using .loc[row_indexer,col_indexer] = value instead
See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy
diff_df.loc[:, 'index_code'] = index_code
/root/project/IOOppi_data/IOOppi_request.py:309: SettingWithCopyWarning:
A value is trying to be set on a copy of a slice from a DataFrame.
Try using .loc[row_indexer,col_indexer] = value instead
See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy
diff_df.loc[:, 'created_at'] = datetime.datetime.now()
/root/project/IOOppi_data/IOOppi_request.py:310: SettingWithCopyWarning:
A value is trying to be set on a copy of a slice from a DataFrame.
Try using .loc[row_indexer,col_indexer] = value instead
See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy
diff_df.loc[:, 'updated_at'] = datetime.datetime.now()
2025-07-25 17:51:08,025 - IOOppi_data - INFO : save diff data to db IOOppi_cs_g: date ... updated_at
2851 2025-07-24 ... 2025-07-25 17:51:08.018575
[1 rows x 6 columns]
/usr/local/lib/python3.10/site-packages/urllib3/connectionpool.py:1056: InsecureRequestWarning: Unverified HTTPS request is being made to host 'www.100ppi.com'. Adding certificate verification is strongly advised. See: https://urllib3.readthedocs.io/en/1.26.x/advanced-usage.html#ssl-warnings
warnings.warn(
2025-07-25 17:51:08,599 - IOOppi_data - INFO : save data to db IOOppi_cs_t data:
date value
2845 2025-07-21 2332.86
2846 2025-07-22 2338.57
2847 2025-07-23 2340.00
2848 2025-07-24 2340.00
2849 2025-07-25 2930.00
2025-07-25 17:51:08,652 - IOOppi_data - INFO : save new data to db: IOOppi_cs_t: no new data
/root/project/IOOppi_data/IOOppi_request.py:308: SettingWithCopyWarning:
A value is trying to be set on a copy of a slice from a DataFrame.
Try using .loc[row_indexer,col_indexer] = value instead
See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy
diff_df.loc[:, 'index_code'] = index_code
/root/project/IOOppi_data/IOOppi_request.py:309: SettingWithCopyWarning:
A value is trying to be set on a copy of a slice from a DataFrame.
Try using .loc[row_indexer,col_indexer] = value instead
See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy
diff_df.loc[:, 'created_at'] = datetime.datetime.now()
/root/project/IOOppi_data/IOOppi_request.py:310: SettingWithCopyWarning:
A value is trying to be set on a copy of a slice from a DataFrame.
Try using .loc[row_indexer,col_indexer] = value instead
See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy
diff_df.loc[:, 'updated_at'] = datetime.datetime.now()
2025-07-25 17:51:08,678 - IOOppi_data - INFO : save diff data to db IOOppi_cs_t: date ... updated_at
2849 2025-07-25 ... 2025-07-25 17:51:08.669659
[1 rows x 6 columns]
2025-07-25 17:51:08,702 - IOOppi_data - INFO : save data to db IOOppi_cs_g data:
date value
2845 2025-07-21 2332.86
2846 2025-07-22 2338.57
2847 2025-07-23 2340.00
2848 2025-07-24 2340.00
2849 2025-07-25 2930.00
2025-07-25 17:51:08,757 - IOOppi_data - INFO : save new data to db: IOOppi_cs_g: no new data
/root/project/IOOppi_data/IOOppi_request.py:308: SettingWithCopyWarning:
A value is trying to be set on a copy of a slice from a DataFrame.
Try using .loc[row_indexer,col_indexer] = value instead
See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy
diff_df.loc[:, 'index_code'] = index_code
/root/project/IOOppi_data/IOOppi_request.py:309: SettingWithCopyWarning:
A value is trying to be set on a copy of a slice from a DataFrame.
Try using .loc[row_indexer,col_indexer] = value instead
See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy
diff_df.loc[:, 'created_at'] = datetime.datetime.now()
/root/project/IOOppi_data/IOOppi_request.py:310: SettingWithCopyWarning:
A value is trying to be set on a copy of a slice from a DataFrame.
Try using .loc[row_indexer,col_indexer] = value instead
See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy
diff_df.loc[:, 'updated_at'] = datetime.datetime.now()
2025-07-25 17:51:08,778 - IOOppi_data - INFO : save diff data to db IOOppi_cs_g: date ... updated_at
2852 2025-07-25 ... 2025-07-25 17:51:08.771496
[1 rows x 6 columns]
/usr/local/lib/python3.10/site-packages/urllib3/connectionpool.py:1056: InsecureRequestWarning: Unverified HTTPS request is being made to host 'www.100ppi.com'. Adding certificate verification is strongly advised. See: https://urllib3.readthedocs.io/en/1.26.x/advanced-usage.html#ssl-warnings
warnings.warn(
2025-07-25 17:51:09,305 - IOOppi_data - INFO : save data to db IOOppi_RS_t data:
date value
3202 2025-07-21 9681.67
3203 2025-07-22 9586.67
3204 2025-07-23 9570.00
3205 2025-07-24 9590.00
3206 2025-07-25 9590.00
2025-07-25 17:51:09,360 - IOOppi_data - INFO : save new data to db: IOOppi_RS_t: no new data
2025-07-25 17:51:09,361 - IOOppi_data - INFO : save diff data to db: IOOppi_RS_t: no diff data
2025-07-25 17:51:09,366 - IOOppi_data - INFO : save data to db IOOppi_RS_g data:
date value
3202 2025-07-21 9681.67
3203 2025-07-22 9586.67
3204 2025-07-23 9570.00
3205 2025-07-24 9590.00
3206 2025-07-25 9590.00
2025-07-25 17:51:09,422 - IOOppi_data - INFO : save new data to db: IOOppi_RS_g: no new data
2025-07-25 17:51:09,423 - IOOppi_data - INFO : save diff data to db: IOOppi_RS_g: no diff data
/usr/local/lib/python3.10/site-packages/urllib3/connectionpool.py:1056: InsecureRequestWarning: Unverified HTTPS request is being made to host 'www.100ppi.com'. Adding certificate verification is strongly advised. See: https://urllib3.readthedocs.io/en/1.26.x/advanced-usage.html#ssl-warnings
warnings.warn(
2025-07-25 17:51:10,101 - IOOppi_data - INFO : save data to db IOOppi_eg_t data:
date value
1886 2025-07-21 4431.67
1887 2025-07-22 4436.67
1888 2025-07-23 4436.67
1889 2025-07-24 4443.33
1890 2025-07-25 4448.33
2025-07-25 17:51:10,148 - IOOppi_data - INFO : save new data to db IOOppi_eg_t: date value ... created_at updated_at
1890 2025-07-25 4448.33 ... 2025-07-25 17:51:10.141611 2025-07-25 17:51:10.142021
[1 rows x 5 columns]
2025-07-25 17:51:10,166 - IOOppi_data - INFO : save diff data to db: IOOppi_eg_t: no diff data
2025-07-25 17:51:10,171 - IOOppi_data - INFO : save data to db IOOppi_eg_g data:
date value
1886 2025-07-21 4431.67
1887 2025-07-22 4436.67
1888 2025-07-23 4436.67
1889 2025-07-24 4443.33
1890 2025-07-25 4448.33
2025-07-25 17:51:10,219 - IOOppi_data - INFO : save new data to db IOOppi_eg_g: date value ... created_at updated_at
1893 2025-07-25 4448.33 ... 2025-07-25 17:51:10.212154 2025-07-25 17:51:10.212529
[1 rows x 5 columns]
2025-07-25 17:51:10,237 - IOOppi_data - INFO : save diff data to db: IOOppi_eg_g: no diff data
/usr/local/lib/python3.10/site-packages/urllib3/connectionpool.py:1056: InsecureRequestWarning: Unverified HTTPS request is being made to host 'www.100ppi.com'. Adding certificate verification is strongly advised. See: https://urllib3.readthedocs.io/en/1.26.x/advanced-usage.html#ssl-warnings
warnings.warn(
2025-07-25 17:51:10,840 - IOOppi_data - INFO : save data to db IOOppi_sp_t data:
date value
1895 2025-07-21 5950.00
1896 2025-07-22 5923.33
1897 2025-07-23 5950.00
1898 2025-07-24 5966.67
1899 2025-07-25 5966.67
2025-07-25 17:51:10,888 - IOOppi_data - INFO : save new data to db IOOppi_sp_t: date value ... created_at updated_at
1899 2025-07-25 5966.67 ... 2025-07-25 17:51:10.881118 2025-07-25 17:51:10.881492
[1 rows x 5 columns]
2025-07-25 17:51:10,906 - IOOppi_data - INFO : save diff data to db: IOOppi_sp_t: no diff data
2025-07-25 17:51:10,911 - IOOppi_data - INFO : save data to db IOOppi_sp_g data:
date value
1895 2025-07-21 5950.00
1896 2025-07-22 5923.33
1897 2025-07-23 5950.00
1898 2025-07-24 5966.67
1899 2025-07-25 5966.67
2025-07-25 17:51:10,960 - IOOppi_data - INFO : save new data to db IOOppi_sp_g: date value ... created_at updated_at
1902 2025-07-25 5966.67 ... 2025-07-25 17:51:10.953242 2025-07-25 17:51:10.953626
[1 rows x 5 columns]
2025-07-25 17:51:10,977 - IOOppi_data - INFO : save diff data to db: IOOppi_sp_g: no diff data
/usr/local/lib/python3.10/site-packages/urllib3/connectionpool.py:1056: InsecureRequestWarning: Unverified HTTPS request is being made to host 'www.100ppi.com'. Adding certificate verification is strongly advised. See: https://urllib3.readthedocs.io/en/1.26.x/advanced-usage.html#ssl-warnings
warnings.warn(
2025-07-25 17:51:11,703 - IOOppi_data - INFO : save data to db IOOppi_p_t data:
date value
3563 2025-07-21 9046.0
3564 2025-07-22 8994.0
3565 2025-07-23 9048.0
3566 2025-07-24 9172.0
3567 2025-07-25 9016.0
2025-07-25 17:51:11,774 - IOOppi_data - INFO : save new data to db IOOppi_p_t: date value ... created_at updated_at
3567 2025-07-25 9016.0 ... 2025-07-25 17:51:11.767295 2025-07-25 17:51:11.767683
[1 rows x 5 columns]
2025-07-25 17:51:11,793 - IOOppi_data - INFO : save diff data to db: IOOppi_p_t: no diff data
2025-07-25 17:51:11,798 - IOOppi_data - INFO : save data to db IOOppi_p_g data:
date value
3563 2025-07-21 9046.0
3564 2025-07-22 8994.0
3565 2025-07-23 9048.0
3566 2025-07-24 9172.0
3567 2025-07-25 9016.0
2025-07-25 17:51:11,867 - IOOppi_data - INFO : save new data to db IOOppi_p_g: date value ... created_at updated_at
3570 2025-07-25 9016.0 ... 2025-07-25 17:51:11.860401 2025-07-25 17:51:11.860813
[1 rows x 5 columns]
2025-07-25 17:51:11,885 - IOOppi_data - INFO : save diff data to db: IOOppi_p_g: no diff data