=========================================================================
2025-05-08 17:50:26 Thu 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-08 17:50:28,477 - IOOppi_data - INFO : save data to db IOOppi_rb_t data:
date value
3293 2025-05-04 3183.22
3294 2025-05-05 3183.22
3295 2025-05-06 3176.33
3296 2025-05-07 3177.22
3297 2025-05-08 3162.78
2025-05-08 17:50:28,548 - IOOppi_data - INFO : save new data to db IOOppi_rb_t: date value ... created_at updated_at
3297 2025-05-08 3162.78 ... 2025-05-08 17:50:28.540570 2025-05-08 17:50:28.541003
[1 rows x 5 columns]
2025-05-08 17:50:28,568 - IOOppi_data - INFO : save diff data to db: IOOppi_rb_t: no diff data
2025-05-08 17:50:28,574 - IOOppi_data - INFO : save data to db IOOppi_rb_g data:
date value
3293 2025-05-04 3183.22
3294 2025-05-05 3183.22
3295 2025-05-06 3176.33
3296 2025-05-07 3177.22
3297 2025-05-08 3162.78
2025-05-08 17:50:28,639 - IOOppi_data - INFO : save new data to db IOOppi_rb_g: date value ... created_at updated_at
3300 2025-05-08 3162.78 ... 2025-05-08 17:50:28.632583 2025-05-08 17:50:28.632995
[1 rows x 5 columns]
2025-05-08 17:50:28,659 - 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-08 17:50:29,458 - IOOppi_data - INFO : save data to db IOOppi_MA_t data:
date value
3514 2025-05-04 2440.00
3515 2025-05-05 2440.00
3516 2025-05-06 2428.75
3517 2025-05-07 2410.00
3518 2025-05-08 2390.00
2025-05-08 17:50:29,528 - IOOppi_data - INFO : save new data to db IOOppi_MA_t: date value ... created_at updated_at
3518 2025-05-08 2390.0 ... 2025-05-08 17:50:29.520570 2025-05-08 17:50:29.520987
[1 rows x 5 columns]
2025-05-08 17:50:29,547 - IOOppi_data - INFO : save diff data to db: IOOppi_MA_t: no diff data
2025-05-08 17:50:29,554 - IOOppi_data - INFO : save data to db IOOppi_MA_g data:
date value
3514 2025-05-04 2440.00
3515 2025-05-05 2440.00
3516 2025-05-06 2428.75
3517 2025-05-07 2410.00
3518 2025-05-08 2390.00
2025-05-08 17:50:29,624 - IOOppi_data - INFO : save new data to db IOOppi_MA_g: date value ... created_at updated_at
3522 2025-05-08 2390.0 ... 2025-05-08 17:50:29.617179 2025-05-08 17:50:29.617568
[1 rows x 5 columns]
2025-05-08 17:50:29,644 - 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-08 17:50:30,193 - IOOppi_data - INFO : save data to db IOOppi_PTA_t data:
date value
854 2025-05-04 4584.38
855 2025-05-05 4582.50
856 2025-05-06 4529.17
857 2025-05-07 4555.84
858 2025-05-08 4688.34
2025-05-08 17:50:30,228 - IOOppi_data - INFO : save new data to db IOOppi_PTA_t: date value ... created_at updated_at
858 2025-05-08 4688.34 ... 2025-05-08 17:50:30.221467 2025-05-08 17:50:30.221876
[1 rows x 5 columns]
2025-05-08 17:50:30,248 - IOOppi_data - INFO : save diff data to db: IOOppi_PTA_t: no diff data
2025-05-08 17:50:30,253 - IOOppi_data - INFO : save data to db IOOppi_PTA_g data:
date value
854 2025-05-04 4584.38
855 2025-05-05 4582.50
856 2025-05-06 4529.17
857 2025-05-07 4555.84
858 2025-05-08 4688.34
2025-05-08 17:50:30,289 - IOOppi_data - INFO : save new data to db IOOppi_PTA_g: date value ... created_at updated_at
858 2025-05-08 4688.34 ... 2025-05-08 17:50:30.281791 2025-05-08 17:50:30.282187
[1 rows x 5 columns]
2025-05-08 17:50:30,310 - 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-08 17:50:30,892 - IOOppi_data - INFO : save data to db IOOppi_ru_t data:
date value
3733 2025-05-04 14308.33
3734 2025-05-05 14308.33
3735 2025-05-06 14593.33
3736 2025-05-07 14578.33
3737 2025-05-08 14458.33
2025-05-08 17:50:30,966 - IOOppi_data - INFO : save new data to db IOOppi_ru_t: date ... updated_at
3737 2025-05-08 ... 2025-05-08 17:50:30.957460
[1 rows x 5 columns]
2025-05-08 17:50:30,988 - IOOppi_data - INFO : save diff data to db: IOOppi_ru_t: no diff data
2025-05-08 17:50:30,994 - IOOppi_data - INFO : save data to db IOOppi_ru_g data:
date value
3733 2025-05-04 14308.33
3734 2025-05-05 14308.33
3735 2025-05-06 14593.33
3736 2025-05-07 14578.33
3737 2025-05-08 14458.33
2025-05-08 17:50:31,084 - IOOppi_data - INFO : save new data to db IOOppi_ru_g: date ... updated_at
3740 2025-05-08 ... 2025-05-08 17:50:31.073584
[1 rows x 5 columns]
2025-05-08 17:50:31,105 - 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-08 17:50:31,780 - IOOppi_data - INFO : save data to db IOOppi_i_t data:
date value
3065 2025-05-04 778.11
3066 2025-05-05 778.11
3067 2025-05-06 781.44
3068 2025-05-07 789.44
3069 2025-05-08 776.22
2025-05-08 17:50:31,855 - IOOppi_data - INFO : save new data to db IOOppi_i_t: date value ... created_at updated_at
3069 2025-05-08 776.22 ... 2025-05-08 17:50:31.847722 2025-05-08 17:50:31.848152
[1 rows x 5 columns]
2025-05-08 17:50:31,874 - IOOppi_data - INFO : save diff data to db: IOOppi_i_t: no diff data
2025-05-08 17:50:31,879 - IOOppi_data - INFO : save data to db IOOppi_i_g data:
date value
3065 2025-05-04 778.11
3066 2025-05-05 778.11
3067 2025-05-06 781.44
3068 2025-05-07 789.44
3069 2025-05-08 776.22
2025-05-08 17:50:31,944 - IOOppi_data - INFO : save new data to db IOOppi_i_g: date value ... created_at updated_at
3072 2025-05-08 776.22 ... 2025-05-08 17:50:31.937369 2025-05-08 17:50:31.937783
[1 rows x 5 columns]
2025-05-08 17:50:31,963 - 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-08 17:50:32,670 - IOOppi_data - INFO : save data to db IOOppi_FG_t data:
date value
3268 2025-05-04 1246.4
3269 2025-05-05 1246.4
3270 2025-05-06 1246.4
3271 2025-05-07 1214.4
3272 2025-05-08 1214.4
2025-05-08 17:50:32,736 - IOOppi_data - INFO : save new data to db IOOppi_FG_t: date value ... created_at updated_at
3272 2025-05-08 1214.4 ... 2025-05-08 17:50:32.728625 2025-05-08 17:50:32.729050
[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-08 17:50:34,693 - IOOppi_data - INFO : save diff data to db IOOppi_FG_t: date ... updated_at
12 2012-12-19 ... 2025-05-08 17:50:34.685623
21 2013-01-04 ... 2025-05-08 17:50:34.685623
54 2013-02-27 ... 2025-05-08 17:50:34.685623
60 2013-03-07 ... 2025-05-08 17:50:34.685623
61 2013-03-08 ... 2025-05-08 17:50:34.685623
[5 rows x 6 columns]
2025-05-08 17:50:34,857 - IOOppi_data - INFO : save data to db IOOppi_FG_g data:
date value
3268 2025-05-04 1246.4
3269 2025-05-05 1246.4
3270 2025-05-06 1246.4
3271 2025-05-07 1214.4
3272 2025-05-08 1214.4
2025-05-08 17:50:34,924 - IOOppi_data - INFO : save new data to db IOOppi_FG_g: date value ... created_at updated_at
3276 2025-05-08 1214.4 ... 2025-05-08 17:50:34.917243 2025-05-08 17:50:34.917651
[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-08 17:50:36,884 - IOOppi_data - INFO : save diff data to db IOOppi_FG_g: date ... updated_at
12 2012-12-19 ... 2025-05-08 17:50:36.876709
21 2013-01-04 ... 2025-05-08 17:50:36.876709
54 2013-02-27 ... 2025-05-08 17:50:36.876709
60 2013-03-07 ... 2025-05-08 17:50:36.876709
61 2013-03-08 ... 2025-05-08 17:50:36.876709
[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-08 17:50:37,578 - IOOppi_data - INFO : save data to db IOOppi_eb_t data:
date value
1613 2025-05-04 7680.0
1614 2025-05-05 7680.0
1615 2025-05-06 7650.0
1616 2025-05-07 7650.0
1617 2025-05-08 7686.0
2025-05-08 17:50:37,622 - IOOppi_data - INFO : save new data to db IOOppi_eb_t: date value ... created_at updated_at
1617 2025-05-08 7686.0 ... 2025-05-08 17:50:37.615326 2025-05-08 17:50:37.615773
[1 rows x 5 columns]
2025-05-08 17:50:37,641 - IOOppi_data - INFO : save diff data to db: IOOppi_eb_t: no diff data
2025-05-08 17:50:37,646 - IOOppi_data - INFO : save data to db IOOppi_eb_g data:
date value
1613 2025-05-04 7680.0
1614 2025-05-05 7680.0
1615 2025-05-06 7650.0
1616 2025-05-07 7650.0
1617 2025-05-08 7686.0
2025-05-08 17:50:37,691 - IOOppi_data - INFO : save new data to db IOOppi_eb_g: date value ... created_at updated_at
1620 2025-05-08 7686.0 ... 2025-05-08 17:50:37.684485 2025-05-08 17:50:37.684888
[1 rows x 5 columns]
2025-05-08 17:50:37,711 - 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-08 17:50:38,306 - IOOppi_data - INFO : save data to db IOOppi_SR_t data:
date value
3724 2025-05-04 6160.00
3725 2025-05-05 6160.00
3726 2025-05-06 6156.67
3727 2025-05-07 6156.67
3728 2025-05-08 6156.67
2025-05-08 17:50:38,384 - IOOppi_data - INFO : save new data to db IOOppi_SR_t: date value ... created_at updated_at
3728 2025-05-08 6156.67 ... 2025-05-08 17:50:38.376314 2025-05-08 17:50:38.376805
[1 rows x 5 columns]
2025-05-08 17:50:38,404 - IOOppi_data - INFO : save diff data to db: IOOppi_SR_t: no diff data
2025-05-08 17:50:38,411 - IOOppi_data - INFO : save data to db IOOppi_SR_g data:
date value
3724 2025-05-04 6160.00
3725 2025-05-05 6160.00
3726 2025-05-06 6156.67
3727 2025-05-07 6156.67
3728 2025-05-08 6156.67
2025-05-08 17:50:38,486 - IOOppi_data - INFO : save new data to db IOOppi_SR_g: date value ... created_at updated_at
3732 2025-05-08 6156.67 ... 2025-05-08 17:50:38.478928 2025-05-08 17:50:38.479355
[1 rows x 5 columns]
2025-05-08 17:50:38,505 - 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-08 17:50:39,124 - IOOppi_data - INFO : save data to db IOOppi_ss_t data:
date value
1614 2025-05-04 13050.0
1615 2025-05-05 13050.0
1616 2025-05-06 13062.5
1617 2025-05-07 13062.5
1618 2025-05-08 13042.5
2025-05-08 17:50:39,170 - IOOppi_data - INFO : save new data to db IOOppi_ss_t: date value ... created_at updated_at
1618 2025-05-08 13042.5 ... 2025-05-08 17:50:39.163031 2025-05-08 17:50:39.163416
[1 rows x 5 columns]
2025-05-08 17:50:39,189 - IOOppi_data - INFO : save diff data to db: IOOppi_ss_t: no diff data
2025-05-08 17:50:39,195 - IOOppi_data - INFO : save data to db IOOppi_ss_g data:
date value
1614 2025-05-04 13050.0
1615 2025-05-05 13050.0
1616 2025-05-06 13062.5
1617 2025-05-07 13062.5
1618 2025-05-08 13042.5
2025-05-08 17:50:39,241 - IOOppi_data - INFO : save new data to db IOOppi_ss_g: date value ... created_at updated_at
1621 2025-05-08 13042.5 ... 2025-05-08 17:50:39.234159 2025-05-08 17:50:39.234577
[1 rows x 5 columns]
2025-05-08 17:50:39,260 - 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-08 17:50:39,870 - IOOppi_data - INFO : save data to db IOOppi_RS_t data:
date value
3124 2025-05-04 9378.33
3125 2025-05-05 9378.33
3126 2025-05-06 9330.00
3127 2025-05-07 9430.00
3128 2025-05-08 9471.67
2025-05-08 17:50:39,936 - IOOppi_data - INFO : save new data to db IOOppi_RS_t: date value ... created_at updated_at
3128 2025-05-08 9471.67 ... 2025-05-08 17:50:39.928461 2025-05-08 17:50:39.928874
[1 rows x 5 columns]
2025-05-08 17:50:39,955 - IOOppi_data - INFO : save diff data to db: IOOppi_RS_t: no diff data
2025-05-08 17:50:39,961 - IOOppi_data - INFO : save data to db IOOppi_RS_g data:
date value
3124 2025-05-04 9378.33
3125 2025-05-05 9378.33
3126 2025-05-06 9330.00
3127 2025-05-07 9430.00
3128 2025-05-08 9471.67
2025-05-08 17:50:40,027 - IOOppi_data - INFO : save new data to db IOOppi_RS_g: date value ... created_at updated_at
3132 2025-05-08 9471.67 ... 2025-05-08 17:50:40.019603 2025-05-08 17:50:40.020021
[1 rows x 5 columns]
2025-05-08 17:50:40,046 - 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-08 17:50:40,622 - IOOppi_data - INFO : save data to db IOOppi_RM_t data:
date value
3247 2025-05-04 2531.67
3248 2025-05-05 2531.67
3249 2025-05-06 2511.67
3250 2025-05-07 2511.67
3251 2025-05-08 2550.00
2025-05-08 17:50:40,688 - IOOppi_data - INFO : save new data to db IOOppi_RM_t: date value ... created_at updated_at
3251 2025-05-08 2550.0 ... 2025-05-08 17:50:40.681187 2025-05-08 17:50:40.681565
[1 rows x 5 columns]
2025-05-08 17:50:40,707 - IOOppi_data - INFO : save diff data to db: IOOppi_RM_t: no diff data
2025-05-08 17:50:40,713 - IOOppi_data - INFO : save data to db IOOppi_RM_g data:
date value
3247 2025-05-04 2531.67
3248 2025-05-05 2531.67
3249 2025-05-06 2511.67
3250 2025-05-07 2511.67
3251 2025-05-08 2550.00
2025-05-08 17:50:40,780 - IOOppi_data - INFO : save new data to db IOOppi_RM_g: date value ... created_at updated_at
3255 2025-05-08 2550.0 ... 2025-05-08 17:50:40.772975 2025-05-08 17:50:40.773357
[1 rows x 5 columns]
2025-05-08 17:50:40,799 - 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-08 17:50:41,308 - IOOppi_data - INFO : save data to db IOOppi_SA_t data:
date value
1451 2025-05-04 1502.5
1452 2025-05-05 1502.5
1453 2025-05-06 1502.5
1454 2025-05-07 1462.5
1455 2025-05-08 1462.5
2025-05-08 17:50:41,352 - IOOppi_data - INFO : save new data to db IOOppi_SA_t: date value ... created_at updated_at
1455 2025-05-08 1462.5 ... 2025-05-08 17:50:41.344790 2025-05-08 17:50:41.345229
[1 rows x 5 columns]
2025-05-08 17:50:41,371 - IOOppi_data - INFO : save diff data to db: IOOppi_SA_t: no diff data
2025-05-08 17:50:41,377 - IOOppi_data - INFO : save data to db IOOppi_SA_g data:
date value
1451 2025-05-04 1502.5
1452 2025-05-05 1502.5
1453 2025-05-06 1502.5
1454 2025-05-07 1462.5
1455 2025-05-08 1462.5
2025-05-08 17:50:41,421 - IOOppi_data - INFO : save new data to db IOOppi_SA_g: date value ... created_at updated_at
1459 2025-05-08 1462.5 ... 2025-05-08 17:50:41.413744 2025-05-08 17:50:41.414164
[1 rows x 5 columns]
2025-05-08 17:50:41,439 - 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-08 17:50:42,006 - IOOppi_data - INFO : save data to db IOOppi_PF_t data:
date value
1364 2025-05-04 6351.46
1365 2025-05-05 6351.67
1366 2025-05-06 6313.75
1367 2025-05-07 6377.50
1368 2025-05-08 6364.79
2025-05-08 17:50:42,049 - IOOppi_data - INFO : save new data to db IOOppi_PF_t: date value ... created_at updated_at
1368 2025-05-08 6364.79 ... 2025-05-08 17:50:42.041819 2025-05-08 17:50:42.042219
[1 rows x 5 columns]
2025-05-08 17:50:42,068 - IOOppi_data - INFO : save diff data to db: IOOppi_PF_t: no diff data
2025-05-08 17:50:42,075 - IOOppi_data - INFO : save data to db IOOppi_PF_g data:
date value
1364 2025-05-04 6351.46
1365 2025-05-05 6351.67
1366 2025-05-06 6313.75
1367 2025-05-07 6377.50
1368 2025-05-08 6364.79
2025-05-08 17:50:42,118 - IOOppi_data - INFO : save new data to db IOOppi_PF_g: date value ... created_at updated_at
1372 2025-05-08 6364.79 ... 2025-05-08 17:50:42.111414 2025-05-08 17:50:42.111830
[1 rows x 5 columns]
2025-05-08 17:50:42,137 - 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-08 17:50:42,723 - IOOppi_data - INFO : save data to db IOOppi_m_t data:
date value
3737 2025-05-04 3476.67
3738 2025-05-05 3476.67
3739 2025-05-06 3270.00
3740 2025-05-07 3302.00
3741 2025-05-08 3300.00
2025-05-08 17:50:42,795 - IOOppi_data - INFO : save new data to db IOOppi_m_t: date value ... created_at updated_at
3741 2025-05-08 3300.0 ... 2025-05-08 17:50:42.788211 2025-05-08 17:50:42.788594
[1 rows x 5 columns]
2025-05-08 17:50:42,814 - IOOppi_data - INFO : save diff data to db: IOOppi_m_t: no diff data
2025-05-08 17:50:42,820 - IOOppi_data - INFO : save data to db IOOppi_m_g data:
date value
3737 2025-05-04 3476.67
3738 2025-05-05 3476.67
3739 2025-05-06 3270.00
3740 2025-05-07 3302.00
3741 2025-05-08 3300.00
2025-05-08 17:50:42,893 - IOOppi_data - INFO : save new data to db IOOppi_m_g: date value ... created_at updated_at
3744 2025-05-08 3300.0 ... 2025-05-08 17:50:42.885468 2025-05-08 17:50:42.885916
[1 rows x 5 columns]
2025-05-08 17:50:42,912 - 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-08 17:50:43,488 - IOOppi_data - INFO : save data to db IOOppi_y_t data:
date value
3507 2025-05-04 8126.0
3508 2025-05-05 8126.0
3509 2025-05-06 8056.0
3510 2025-05-07 8076.0
3511 2025-05-08 8056.0
2025-05-08 17:50:43,558 - IOOppi_data - INFO : save new data to db IOOppi_y_t: date value ... created_at updated_at
3511 2025-05-08 8056.0 ... 2025-05-08 17:50:43.551142 2025-05-08 17:50:43.551536
[1 rows x 5 columns]
2025-05-08 17:50:43,578 - IOOppi_data - INFO : save diff data to db: IOOppi_y_t: no diff data
2025-05-08 17:50:43,585 - IOOppi_data - INFO : save data to db IOOppi_y_g data:
date value
3507 2025-05-04 8126.0
3508 2025-05-05 8126.0
3509 2025-05-06 8056.0
3510 2025-05-07 8076.0
3511 2025-05-08 8056.0
2025-05-08 17:50:43,666 - IOOppi_data - INFO : save new data to db IOOppi_y_g: date value ... created_at updated_at
3514 2025-05-08 8056.0 ... 2025-05-08 17:50:43.653384 2025-05-08 17:50:43.654070
[1 rows x 5 columns]
2025-05-08 17:50:43,688 - 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-08 17:50:44,203 - IOOppi_data - INFO : save data to db IOOppi_a_t data:
date value
3473 2025-05-04 4245.0
3474 2025-05-05 4245.0
3475 2025-05-06 4230.0
3476 2025-05-07 4230.0
3477 2025-05-08 4230.0
2025-05-08 17:50:44,271 - IOOppi_data - INFO : save new data to db IOOppi_a_t: date value ... created_at updated_at
3477 2025-05-08 4230.0 ... 2025-05-08 17:50:44.264456 2025-05-08 17:50:44.264864
[1 rows x 5 columns]
2025-05-08 17:50:44,291 - IOOppi_data - INFO : save diff data to db: IOOppi_a_t: no diff data
2025-05-08 17:50:44,297 - IOOppi_data - INFO : save data to db IOOppi_a_g data:
date value
3473 2025-05-04 4245.0
3474 2025-05-05 4245.0
3475 2025-05-06 4230.0
3476 2025-05-07 4230.0
3477 2025-05-08 4230.0
2025-05-08 17:50:44,367 - IOOppi_data - INFO : save new data to db IOOppi_a_g: date value ... created_at updated_at
3480 2025-05-08 4230.0 ... 2025-05-08 17:50:44.359801 2025-05-08 17:50:44.360200
[1 rows x 5 columns]
2025-05-08 17:50:44,386 - 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-08 17:50:44,952 - IOOppi_data - INFO : save data to db IOOppi_SF_t data:
date value
2850 2025-05-04 5548.57
2851 2025-05-05 5548.57
2852 2025-05-06 5548.57
2853 2025-05-07 5402.86
2854 2025-05-08 5402.86
2025-05-08 17:50:45,013 - IOOppi_data - INFO : save new data to db IOOppi_SF_t: date value ... created_at updated_at
2854 2025-05-08 5402.86 ... 2025-05-08 17:50:45.006151 2025-05-08 17:50:45.006536
[1 rows x 5 columns]
2025-05-08 17:50:45,032 - IOOppi_data - INFO : save diff data to db: IOOppi_SF_t: no diff data
2025-05-08 17:50:45,037 - IOOppi_data - INFO : save data to db IOOppi_SF_g data:
date value
2850 2025-05-04 5548.57
2851 2025-05-05 5548.57
2852 2025-05-06 5548.57
2853 2025-05-07 5402.86
2854 2025-05-08 5402.86
2025-05-08 17:50:45,098 - IOOppi_data - INFO : save new data to db IOOppi_SF_g: date value ... created_at updated_at
2858 2025-05-08 5402.86 ... 2025-05-08 17:50:45.091605 2025-05-08 17:50:45.092030
[1 rows x 5 columns]
2025-05-08 17:50:45,118 - 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-08 17:50:45,609 - IOOppi_data - INFO : save data to db IOOppi_jd_t data:
date value
3050 2025-05-04 3375.0
3051 2025-05-05 3375.0
3052 2025-05-06 3375.0
3053 2025-05-07 3300.0
3054 2025-05-08 3225.0
2025-05-08 17:50:45,673 - IOOppi_data - INFO : save new data to db IOOppi_jd_t: date value ... created_at updated_at
3054 2025-05-08 3225.0 ... 2025-05-08 17:50:45.666027 2025-05-08 17:50:45.666537
[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-08 17:50:45,821 - IOOppi_data - INFO : save diff data to db IOOppi_jd_t: date ... updated_at
39 2014-01-03 ... 2025-05-08 17:50:45.813162
458 2015-09-21 ... 2025-05-08 17:50:45.813162
549 2016-02-03 ... 2025-05-08 17:50:45.813162
693 2016-09-05 ... 2025-05-08 17:50:45.813162
696 2016-09-08 ... 2025-05-08 17:50:45.813162
[5 rows x 6 columns]
2025-05-08 17:50:45,852 - IOOppi_data - INFO : save data to db IOOppi_jd_g data:
date value
3050 2025-05-04 3375.0
3051 2025-05-05 3375.0
3052 2025-05-06 3375.0
3053 2025-05-07 3300.0
3054 2025-05-08 3225.0
2025-05-08 17:50:45,915 - IOOppi_data - INFO : save new data to db IOOppi_jd_g: date value ... created_at updated_at
3057 2025-05-08 3225.0 ... 2025-05-08 17:50:45.908480 2025-05-08 17:50:45.908880
[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-08 17:50:46,062 - IOOppi_data - INFO : save diff data to db IOOppi_jd_g: date ... updated_at
39 2014-01-03 ... 2025-05-08 17:50:46.054962
458 2015-09-21 ... 2025-05-08 17:50:46.054962
549 2016-02-03 ... 2025-05-08 17:50:46.054962
693 2016-09-05 ... 2025-05-08 17:50:46.054962
696 2016-09-08 ... 2025-05-08 17:50:46.054962
[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-08 17:50:46,775 - IOOppi_data - INFO : save data to db IOOppi_SI_t data:
date value
854 2025-05-04 9880.0
855 2025-05-05 9880.0
856 2025-05-06 9780.0
857 2025-05-07 9690.0
858 2025-05-08 9640.0
2025-05-08 17:50:46,811 - IOOppi_data - INFO : save new data to db IOOppi_SI_t: date value ... created_at updated_at
858 2025-05-08 9640.0 ... 2025-05-08 17:50:46.804285 2025-05-08 17:50:46.804660
[1 rows x 5 columns]
2025-05-08 17:50:46,830 - IOOppi_data - INFO : save diff data to db: IOOppi_SI_t: no diff data
2025-05-08 17:50:46,835 - IOOppi_data - INFO : save data to db IOOppi_SI_g data:
date value
854 2025-05-04 9880.0
855 2025-05-05 9880.0
856 2025-05-06 9780.0
857 2025-05-07 9690.0
858 2025-05-08 9640.0
2025-05-08 17:50:46,870 - IOOppi_data - INFO : save new data to db IOOppi_SI_g: date value ... created_at updated_at
858 2025-05-08 9640.0 ... 2025-05-08 17:50:46.863319 2025-05-08 17:50:46.863711
[1 rows x 5 columns]
2025-05-08 17:50:46,889 - 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-08 17:50:47,421 - IOOppi_data - INFO : save data to db IOOppi_l_t data:
date value
3733 2025-05-04 7553.33
3734 2025-05-05 7553.33
3735 2025-05-06 7500.00
3736 2025-05-07 7491.67
3737 2025-05-08 7465.00
2025-05-08 17:50:47,493 - IOOppi_data - INFO : save new data to db IOOppi_l_t: date value ... created_at updated_at
3737 2025-05-08 7465.0 ... 2025-05-08 17:50:47.486323 2025-05-08 17:50:47.486700
[1 rows x 5 columns]
2025-05-08 17:50:47,512 - IOOppi_data - INFO : save diff data to db: IOOppi_l_t: no diff data
2025-05-08 17:50:47,518 - IOOppi_data - INFO : save data to db IOOppi_l_g data:
date value
3733 2025-05-04 7553.33
3734 2025-05-05 7553.33
3735 2025-05-06 7500.00
3736 2025-05-07 7491.67
3737 2025-05-08 7465.00
2025-05-08 17:50:47,590 - IOOppi_data - INFO : save new data to db IOOppi_l_g: date value ... created_at updated_at
3740 2025-05-08 7465.0 ... 2025-05-08 17:50:47.583565 2025-05-08 17:50:47.583966
[1 rows x 5 columns]
2025-05-08 17:50:47,609 - 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-08 17:50:48,172 - IOOppi_data - INFO : save data to db IOOppi_bu_t data:
date value
3071 2025-05-04 3647.5
3072 2025-05-05 3647.5
3073 2025-05-06 3590.0
3074 2025-05-07 3590.0
3075 2025-05-08 3582.5
2025-05-08 17:50:48,235 - IOOppi_data - INFO : save new data to db IOOppi_bu_t: date value ... created_at updated_at
3076 2025-05-08 3582.5 ... 2025-05-08 17:50:48.228359 2025-05-08 17:50:48.228734
[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-08 17:50:48,271 - IOOppi_data - INFO : save diff data to db IOOppi_bu_t: date ... updated_at
2560 2023-12-09 ... 2025-05-08 17:50:48.264456
[1 rows x 6 columns]
2025-05-08 17:50:48,296 - IOOppi_data - INFO : save data to db IOOppi_bu_g data:
date value
3071 2025-05-04 3647.5
3072 2025-05-05 3647.5
3073 2025-05-06 3590.0
3074 2025-05-07 3590.0
3075 2025-05-08 3582.5
2025-05-08 17:50:48,360 - IOOppi_data - INFO : save new data to db IOOppi_bu_g: date value ... created_at updated_at
3078 2025-05-08 3582.5 ... 2025-05-08 17:50:48.353305 2025-05-08 17:50:48.353696
[1 rows x 5 columns]
2025-05-08 17:50:48,379 - 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-08 17:50:49,045 - IOOppi_data - INFO : save data to db IOOppi_al_t data:
date value
3736 2025-05-04 20073.33
3737 2025-05-05 20073.33
3738 2025-05-06 20073.33
3739 2025-05-07 19630.00
3740 2025-05-08 19630.00
2025-05-08 17:50:49,117 - IOOppi_data - INFO : save new data to db IOOppi_al_t: date value ... created_at updated_at
3740 2025-05-08 19630.0 ... 2025-05-08 17:50:49.110174 2025-05-08 17:50:49.110588
[1 rows x 5 columns]
2025-05-08 17:50:49,136 - IOOppi_data - INFO : save diff data to db: IOOppi_al_t: no diff data
2025-05-08 17:50:49,142 - IOOppi_data - INFO : save data to db IOOppi_al_g data:
date value
3736 2025-05-04 20073.33
3737 2025-05-05 20073.33
3738 2025-05-06 20073.33
3739 2025-05-07 19630.00
3740 2025-05-08 19630.00
2025-05-08 17:50:49,216 - IOOppi_data - INFO : save new data to db IOOppi_al_g: date value ... created_at updated_at
3743 2025-05-08 19630.0 ... 2025-05-08 17:50:49.208829 2025-05-08 17:50:49.209230
[1 rows x 5 columns]
2025-05-08 17:50:49,235 - 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-08 17:50:49,776 - IOOppi_data - INFO : save data to db IOOppi_SM_t data:
date value
2850 2025-05-04 5640.0
2851 2025-05-05 5640.0
2852 2025-05-06 5610.0
2853 2025-05-07 5586.0
2854 2025-05-08 5590.0
2025-05-08 17:50:49,841 - IOOppi_data - INFO : save new data to db IOOppi_SM_t: date value ... created_at updated_at
2854 2025-05-08 5590.0 ... 2025-05-08 17:50:49.831052 2025-05-08 17:50:49.831669
[1 rows x 5 columns]
2025-05-08 17:50:49,860 - IOOppi_data - INFO : save diff data to db: IOOppi_SM_t: no diff data
2025-05-08 17:50:49,866 - IOOppi_data - INFO : save data to db IOOppi_SM_g data:
date value
2850 2025-05-04 5640.0
2851 2025-05-05 5640.0
2852 2025-05-06 5610.0
2853 2025-05-07 5586.0
2854 2025-05-08 5590.0
2025-05-08 17:50:49,928 - IOOppi_data - INFO : save new data to db IOOppi_SM_g: date value ... created_at updated_at
2858 2025-05-08 5590.0 ... 2025-05-08 17:50:49.920881 2025-05-08 17:50:49.921279
[1 rows x 5 columns]
2025-05-08 17:50:49,947 - 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-08 17:50:50,469 - IOOppi_data - INFO : save data to db IOOppi_CY_t data:
date value
2125 2025-05-04 23775.0
2126 2025-05-05 23775.0
2127 2025-05-06 23775.0
2128 2025-05-07 23775.0
2129 2025-05-08 23775.0
2025-05-08 17:50:50,522 - IOOppi_data - INFO : save new data to db IOOppi_CY_t: date value ... created_at updated_at
2129 2025-05-08 23775.0 ... 2025-05-08 17:50:50.515253 2025-05-08 17:50:50.515639
[1 rows x 5 columns]
2025-05-08 17:50:50,541 - IOOppi_data - INFO : save diff data to db: IOOppi_CY_t: no diff data
2025-05-08 17:50:50,547 - IOOppi_data - INFO : save data to db IOOppi_CY_g data:
date value
2125 2025-05-04 23775.0
2126 2025-05-05 23775.0
2127 2025-05-06 23775.0
2128 2025-05-07 23775.0
2129 2025-05-08 23775.0
2025-05-08 17:50:50,601 - IOOppi_data - INFO : save new data to db IOOppi_CY_g: date value ... created_at updated_at
2133 2025-05-08 23775.0 ... 2025-05-08 17:50:50.594174 2025-05-08 17:50:50.594560
[1 rows x 5 columns]
2025-05-08 17:50:50,620 - 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-08 17:50:51,145 - IOOppi_data - INFO : save data to db IOOppi_UR_t data:
date value
1640 2025-05-04 1875.00
1641 2025-05-05 1875.00
1642 2025-05-06 1893.33
1643 2025-05-07 1906.67
1644 2025-05-08 1911.67
2025-05-08 17:50:51,194 - IOOppi_data - INFO : save new data to db IOOppi_UR_t: date value ... created_at updated_at
1644 2025-05-08 1911.67 ... 2025-05-08 17:50:51.185697 2025-05-08 17:50:51.186156
[1 rows x 5 columns]
2025-05-08 17:50:51,213 - IOOppi_data - INFO : save diff data to db: IOOppi_UR_t: no diff data
2025-05-08 17:50:51,218 - IOOppi_data - INFO : save data to db IOOppi_UR_g data:
date value
1640 2025-05-04 1875.00
1641 2025-05-05 1875.00
1642 2025-05-06 1893.33
1643 2025-05-07 1906.67
1644 2025-05-08 1911.67
2025-05-08 17:50:51,264 - IOOppi_data - INFO : save new data to db IOOppi_UR_g: date value ... created_at updated_at
1648 2025-05-08 1911.67 ... 2025-05-08 17:50:51.257441 2025-05-08 17:50:51.257839
[1 rows x 5 columns]
2025-05-08 17:50:51,284 - 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-08 17:50:51,854 - IOOppi_data - INFO : save data to db IOOppi_ni_t data:
date value
2712 2025-05-04 125175.00
2713 2025-05-05 125175.00
2714 2025-05-06 125775.00
2715 2025-05-07 125683.33
2716 2025-05-08 125050.00
2025-05-08 17:50:51,913 - IOOppi_data - INFO : save new data to db IOOppi_ni_t: date ... updated_at
2716 2025-05-08 ... 2025-05-08 17:50:51.907272
[1 rows x 5 columns]
2025-05-08 17:50:51,932 - IOOppi_data - INFO : save diff data to db: IOOppi_ni_t: no diff data
2025-05-08 17:50:51,938 - IOOppi_data - INFO : save data to db IOOppi_ni_g data:
date value
2712 2025-05-04 125175.00
2713 2025-05-05 125175.00
2714 2025-05-06 125775.00
2715 2025-05-07 125683.33
2716 2025-05-08 125050.00
2025-05-08 17:50:51,998 - IOOppi_data - INFO : save new data to db IOOppi_ni_g: date ... updated_at
2719 2025-05-08 ... 2025-05-08 17:50:51.991875
[1 rows x 5 columns]
2025-05-08 17:50:52,017 - 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-08 17:50:52,553 - IOOppi_data - INFO : save data to db IOOppi_v_t data:
date value
3737 2025-05-04 4679.0
3738 2025-05-05 4679.0
3739 2025-05-06 4653.0
3740 2025-05-07 4665.0
3741 2025-05-08 4632.0
2025-05-08 17:50:52,624 - IOOppi_data - INFO : save new data to db IOOppi_v_t: date value ... created_at updated_at
3741 2025-05-08 4632.0 ... 2025-05-08 17:50:52.617568 2025-05-08 17:50:52.617985
[1 rows x 5 columns]
2025-05-08 17:50:52,643 - IOOppi_data - INFO : save diff data to db: IOOppi_v_t: no diff data
2025-05-08 17:50:52,649 - IOOppi_data - INFO : save data to db IOOppi_v_g data:
date value
3737 2025-05-04 4679.0
3738 2025-05-05 4679.0
3739 2025-05-06 4653.0
3740 2025-05-07 4665.0
3741 2025-05-08 4632.0
2025-05-08 17:50:52,723 - IOOppi_data - INFO : save new data to db IOOppi_v_g: date value ... created_at updated_at
3744 2025-05-08 4632.0 ... 2025-05-08 17:50:52.716071 2025-05-08 17:50:52.716459
[1 rows x 5 columns]
2025-05-08 17:50:52,813 - 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-08 17:50:53,340 - IOOppi_data - INFO : save data to db IOOppi_pp_t data:
date value
2976 2025-05-04 7481.67
2977 2025-05-05 7481.67
2978 2025-05-06 7481.67
2979 2025-05-07 7481.67
2980 2025-05-08 7440.00
2025-05-08 17:50:53,402 - IOOppi_data - INFO : save new data to db IOOppi_pp_t: date value ... created_at updated_at
2980 2025-05-08 7440.0 ... 2025-05-08 17:50:53.395507 2025-05-08 17:50:53.395916
[1 rows x 5 columns]
2025-05-08 17:50:53,421 - IOOppi_data - INFO : save diff data to db: IOOppi_pp_t: no diff data
2025-05-08 17:50:53,427 - IOOppi_data - INFO : save data to db IOOppi_pp_g data:
date value
2976 2025-05-04 7481.67
2977 2025-05-05 7481.67
2978 2025-05-06 7481.67
2979 2025-05-07 7481.67
2980 2025-05-08 7440.00
2025-05-08 17:50:53,491 - IOOppi_data - INFO : save new data to db IOOppi_pp_g: date value ... created_at updated_at
2983 2025-05-08 7440.0 ... 2025-05-08 17:50:53.483964 2025-05-08 17:50:53.484351
[1 rows x 5 columns]
2025-05-08 17:50:53,509 - 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-08 17:50:54,278 - IOOppi_data - INFO : save data to db IOOppi_CF_t data:
date value
3738 2025-05-04 14208.83
3739 2025-05-05 14208.83
3740 2025-05-06 14138.67
3741 2025-05-07 14124.33
3742 2025-05-08 14150.33
2025-05-08 17:50:54,351 - IOOppi_data - INFO : save new data to db IOOppi_CF_t: date ... updated_at
3742 2025-05-08 ... 2025-05-08 17:50:54.345074
[1 rows x 5 columns]
2025-05-08 17:50:54,370 - IOOppi_data - INFO : save diff data to db: IOOppi_CF_t: no diff data
2025-05-08 17:50:54,376 - IOOppi_data - INFO : save data to db IOOppi_CF_g data:
date value
3738 2025-05-04 14208.83
3739 2025-05-05 14208.83
3740 2025-05-06 14138.67
3741 2025-05-07 14124.33
3742 2025-05-08 14150.33
2025-05-08 17:50:54,458 - IOOppi_data - INFO : save new data to db IOOppi_CF_g: date ... updated_at
3746 2025-05-08 ... 2025-05-08 17:50:54.451401
[1 rows x 5 columns]
2025-05-08 17:50:54,480 - 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-08 17:50:55,024 - IOOppi_data - INFO : save data to db IOOppi_pb_t data:
date value
3683 2025-05-04 16812.50
3684 2025-05-05 16812.50
3685 2025-05-06 16706.25
3686 2025-05-07 16637.50
3687 2025-05-08 16737.50
2025-05-08 17:50:55,097 - IOOppi_data - INFO : save new data to db IOOppi_pb_t: date value ... created_at updated_at
3687 2025-05-08 16737.5 ... 2025-05-08 17:50:55.090464 2025-05-08 17:50:55.090877
[1 rows x 5 columns]
2025-05-08 17:50:55,116 - IOOppi_data - INFO : save diff data to db: IOOppi_pb_t: no diff data
2025-05-08 17:50:55,122 - IOOppi_data - INFO : save data to db IOOppi_pb_g data:
date value
3683 2025-05-04 16812.50
3684 2025-05-05 16812.50
3685 2025-05-06 16706.25
3686 2025-05-07 16637.50
3687 2025-05-08 16737.50
2025-05-08 17:50:55,195 - IOOppi_data - INFO : save new data to db IOOppi_pb_g: date value ... created_at updated_at
3690 2025-05-08 16737.5 ... 2025-05-08 17:50:55.187161 2025-05-08 17:50:55.187539
[1 rows x 5 columns]
2025-05-08 17:50:55,215 - 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-08 17:50:55,824 - IOOppi_data - INFO : save data to db IOOppi_hc_t data:
date value
2958 2025-05-04 3276.67
2959 2025-05-05 3276.67
2960 2025-05-06 3263.33
2961 2025-05-07 3283.33
2962 2025-05-08 3276.67
2025-05-08 17:50:55,886 - IOOppi_data - INFO : save new data to db IOOppi_hc_t: date value ... created_at updated_at
2962 2025-05-08 3276.67 ... 2025-05-08 17:50:55.879471 2025-05-08 17:50:55.879888
[1 rows x 5 columns]
2025-05-08 17:50:55,906 - IOOppi_data - INFO : save diff data to db: IOOppi_hc_t: no diff data
2025-05-08 17:50:55,912 - IOOppi_data - INFO : save data to db IOOppi_hc_g data:
date value
2958 2025-05-04 3276.67
2959 2025-05-05 3276.67
2960 2025-05-06 3263.33
2961 2025-05-07 3283.33
2962 2025-05-08 3276.67
2025-05-08 17:50:55,977 - IOOppi_data - INFO : save new data to db IOOppi_hc_g: date value ... created_at updated_at
2965 2025-05-08 3276.67 ... 2025-05-08 17:50:55.970507 2025-05-08 17:50:55.970936
[1 rows x 5 columns]
2025-05-08 17:50:55,996 - 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-08 17:50:56,527 - IOOppi_data - INFO : save data to db IOOppi_fu_t data:
date value
3238 2025-05-04 5462.5
3239 2025-05-05 5462.5
3240 2025-05-06 5425.0
3241 2025-05-07 5425.0
3242 2025-05-08 5450.0
2025-05-08 17:50:56,593 - IOOppi_data - INFO : save new data to db IOOppi_fu_t: date value ... created_at updated_at
3242 2025-05-08 5450.0 ... 2025-05-08 17:50:56.586492 2025-05-08 17:50:56.586904
[1 rows x 5 columns]
2025-05-08 17:50:56,613 - IOOppi_data - INFO : save diff data to db: IOOppi_fu_t: no diff data
2025-05-08 17:50:56,619 - IOOppi_data - INFO : save data to db IOOppi_fu_g data:
date value
3238 2025-05-04 5462.5
3239 2025-05-05 5462.5
3240 2025-05-06 5425.0
3241 2025-05-07 5425.0
3242 2025-05-08 5450.0
2025-05-08 17:50:56,690 - IOOppi_data - INFO : save new data to db IOOppi_fu_g: date value ... created_at updated_at
3729 2025-05-08 5450.0 ... 2025-05-08 17:50:56.683561 2025-05-08 17:50:56.683977
[1 rows x 5 columns]
2025-05-08 17:50:56,711 - 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-08 17:50:57,263 - IOOppi_data - INFO : save data to db IOOppi_lh_t data:
date value
1302 2025-05-04 14830.0
1303 2025-05-05 14830.0
1304 2025-05-06 14820.0
1305 2025-05-07 14830.0
1306 2025-05-08 14830.0
2025-05-08 17:50:57,306 - IOOppi_data - INFO : save new data to db IOOppi_lh_t: date value ... created_at updated_at
1306 2025-05-08 14830.0 ... 2025-05-08 17:50:57.298536 2025-05-08 17:50:57.298962
[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-08 17:50:57,548 - IOOppi_data - INFO : save diff data to db IOOppi_lh_t: date ... updated_at
116 2021-07-05 ... 2025-05-08 17:50:57.540312
117 2021-07-06 ... 2025-05-08 17:50:57.540312
121 2021-07-12 ... 2025-05-08 17:50:57.540312
122 2021-07-13 ... 2025-05-08 17:50:57.540312
194 2021-11-01 ... 2025-05-08 17:50:57.540312
[5 rows x 6 columns]
2025-05-08 17:50:57,585 - IOOppi_data - INFO : save data to db IOOppi_lh_g data:
date value
1302 2025-05-04 14830.0
1303 2025-05-05 14830.0
1304 2025-05-06 14820.0
1305 2025-05-07 14830.0
1306 2025-05-08 14830.0
2025-05-08 17:50:57,627 - IOOppi_data - INFO : save new data to db IOOppi_lh_g: date value ... created_at updated_at
1309 2025-05-08 14830.0 ... 2025-05-08 17:50:57.620268 2025-05-08 17:50:57.620649
[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-08 17:50:57,876 - IOOppi_data - INFO : save diff data to db IOOppi_lh_g: date ... updated_at
116 2021-07-05 ... 2025-05-08 17:50:57.868792
117 2021-07-06 ... 2025-05-08 17:50:57.868792
121 2021-07-12 ... 2025-05-08 17:50:57.868792
122 2021-07-13 ... 2025-05-08 17:50:57.868792
194 2021-11-01 ... 2025-05-08 17:50:57.868792
[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-08 17:50:58,468 - IOOppi_data - INFO : save data to db IOOppi_cu_t data:
date value
3734 2025-05-04 77996.67
3735 2025-05-05 77996.67
3736 2025-05-06 78233.33
3737 2025-05-07 78520.00
3738 2025-05-08 78458.33
2025-05-08 17:50:58,541 - IOOppi_data - INFO : save new data to db IOOppi_cu_t: date ... updated_at
3738 2025-05-08 ... 2025-05-08 17:50:58.535004
[1 rows x 5 columns]
2025-05-08 17:50:58,560 - IOOppi_data - INFO : save diff data to db: IOOppi_cu_t: no diff data
2025-05-08 17:50:58,566 - IOOppi_data - INFO : save data to db IOOppi_cu_g data:
date value
3734 2025-05-04 77996.67
3735 2025-05-05 77996.67
3736 2025-05-06 78233.33
3737 2025-05-07 78520.00
3738 2025-05-08 78458.33
2025-05-08 17:50:58,640 - IOOppi_data - INFO : save new data to db IOOppi_cu_g: date ... updated_at
3741 2025-05-08 ... 2025-05-08 17:50:58.634021
[1 rows x 5 columns]
2025-05-08 17:50:58,659 - 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-08 17:50:59,156 - 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-08 17:50:59,209 - IOOppi_data - INFO : save new data to db: IOOppi_PM_t: no new data
2025-05-08 17:50:59,209 - IOOppi_data - INFO : save diff data to db: IOOppi_PM_t: no diff data
2025-05-08 17:50:59,215 - 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-08 17:50:59,276 - IOOppi_data - INFO : save new data to db: IOOppi_PM_g: no new data
2025-05-08 17:50:59,276 - 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-08 17:50:59,842 - IOOppi_data - INFO : save data to db IOOppi_sn_t data:
date value
2712 2025-05-04 261175.0
2713 2025-05-05 261175.0
2714 2025-05-06 260362.5
2715 2025-05-07 261137.5
2716 2025-05-08 262050.0
2025-05-08 17:50:59,906 - IOOppi_data - INFO : save new data to db IOOppi_sn_t: date ... updated_at
2716 2025-05-08 ... 2025-05-08 17:50:59.899536
[1 rows x 5 columns]
2025-05-08 17:50:59,924 - IOOppi_data - INFO : save diff data to db: IOOppi_sn_t: no diff data
2025-05-08 17:50:59,930 - IOOppi_data - INFO : save data to db IOOppi_sn_g data:
date value
2712 2025-05-04 261175.0
2713 2025-05-05 261175.0
2714 2025-05-06 260362.5
2715 2025-05-07 261137.5
2716 2025-05-08 262050.0
2025-05-08 17:50:59,990 - IOOppi_data - INFO : save new data to db IOOppi_sn_g: date ... updated_at
2719 2025-05-08 ... 2025-05-08 17:50:59.983930
[1 rows x 5 columns]
2025-05-08 17:51:00,011 - 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-08 17:51:00,598 - IOOppi_data - INFO : save data to db IOOppi_zn_t data:
date value
3733 2025-05-04 22904.0
3734 2025-05-05 22904.0
3735 2025-05-06 22864.0
3736 2025-05-07 22758.0
3737 2025-05-08 22832.0
2025-05-08 17:51:00,669 - IOOppi_data - INFO : save new data to db IOOppi_zn_t: date value ... created_at updated_at
3737 2025-05-08 22832.0 ... 2025-05-08 17:51:00.662169 2025-05-08 17:51:00.662556
[1 rows x 5 columns]
2025-05-08 17:51:00,688 - IOOppi_data - INFO : save diff data to db: IOOppi_zn_t: no diff data
2025-05-08 17:51:00,694 - IOOppi_data - INFO : save data to db IOOppi_zn_g data:
date value
3733 2025-05-04 22904.0
3734 2025-05-05 22904.0
3735 2025-05-06 22864.0
3736 2025-05-07 22758.0
3737 2025-05-08 22832.0
2025-05-08 17:51:00,767 - IOOppi_data - INFO : save new data to db IOOppi_zn_g: date value ... created_at updated_at
3740 2025-05-08 22832.0 ... 2025-05-08 17:51:00.760586 2025-05-08 17:51:00.760992
[1 rows x 5 columns]
2025-05-08 17:51:00,786 - 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-08 17:51:01,329 - IOOppi_data - INFO : save data to db IOOppi_wr_t data:
date value
3696 2025-05-04 3377.5
3697 2025-05-05 3377.5
3698 2025-05-06 3377.5
3699 2025-05-07 3377.5
3700 2025-05-08 3367.5
2025-05-08 17:51:01,400 - IOOppi_data - INFO : save new data to db IOOppi_wr_t: date value ... created_at updated_at
3700 2025-05-08 3367.5 ... 2025-05-08 17:51:01.393434 2025-05-08 17:51:01.393845
[1 rows x 5 columns]
2025-05-08 17:51:01,420 - IOOppi_data - INFO : save diff data to db: IOOppi_wr_t: no diff data
2025-05-08 17:51:01,426 - IOOppi_data - INFO : save data to db IOOppi_wr_g data:
date value
3696 2025-05-04 3377.5
3697 2025-05-05 3377.5
3698 2025-05-06 3377.5
3699 2025-05-07 3377.5
3700 2025-05-08 3367.5
2025-05-08 17:51:01,500 - IOOppi_data - INFO : save new data to db IOOppi_wr_g: date value ... created_at updated_at
3703 2025-05-08 3367.5 ... 2025-05-08 17:51:01.493126 2025-05-08 17:51:01.493503
[1 rows x 5 columns]
2025-05-08 17:51:01,519 - 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-08 17:51:02,086 - IOOppi_data - INFO : save data to db IOOppi_pg_t data:
date value
1493 2025-05-04 4980.0
1494 2025-05-05 4980.0
1495 2025-05-06 4967.5
1496 2025-05-07 4930.0
1497 2025-05-08 4917.5
2025-05-08 17:51:02,132 - IOOppi_data - INFO : save new data to db IOOppi_pg_t: date value ... created_at updated_at
1497 2025-05-08 4917.5 ... 2025-05-08 17:51:02.125040 2025-05-08 17:51:02.125440
[1 rows x 5 columns]
2025-05-08 17:51:02,152 - IOOppi_data - INFO : save diff data to db: IOOppi_pg_t: no diff data
2025-05-08 17:51:02,158 - IOOppi_data - INFO : save data to db IOOppi_pg_g data:
date value
1493 2025-05-04 4980.0
1494 2025-05-05 4980.0
1495 2025-05-06 4967.5
1496 2025-05-07 4930.0
1497 2025-05-08 4917.5
2025-05-08 17:51:02,204 - IOOppi_data - INFO : save new data to db IOOppi_pg_g: date value ... created_at updated_at
1500 2025-05-08 4917.5 ... 2025-05-08 17:51:02.196351 2025-05-08 17:51:02.196735
[1 rows x 5 columns]
2025-05-08 17:51:02,223 - 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-08 17:51:02,846 - IOOppi_data - INFO : save data to db IOOppi_cs_t data:
date value
2767 2025-05-04 2252.86
2768 2025-05-05 2252.86
2769 2025-05-06 2272.86
2770 2025-05-07 2282.86
2771 2025-05-08 2285.71
2025-05-08 17:51:02,907 - IOOppi_data - INFO : save new data to db IOOppi_cs_t: date value ... created_at updated_at
2771 2025-05-08 2285.71 ... 2025-05-08 17:51:02.899660 2025-05-08 17:51:02.900132
[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-08 17:51:02,949 - IOOppi_data - INFO : save diff data to db IOOppi_cs_t: date ... updated_at
2770 2025-05-07 ... 2025-05-08 17:51:02.941805
[1 rows x 6 columns]
2025-05-08 17:51:02,974 - IOOppi_data - INFO : save data to db IOOppi_cs_g data:
date value
2767 2025-05-04 2252.86
2768 2025-05-05 2252.86
2769 2025-05-06 2272.86
2770 2025-05-07 2282.86
2771 2025-05-08 2285.71
2025-05-08 17:51:03,036 - IOOppi_data - INFO : save new data to db IOOppi_cs_g: date value ... created_at updated_at
2774 2025-05-08 2285.71 ... 2025-05-08 17:51:03.029357 2025-05-08 17:51:03.029746
[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-08 17:51:03,077 - IOOppi_data - INFO : save diff data to db IOOppi_cs_g: date ... updated_at
2773 2025-05-07 ... 2025-05-08 17:51:03.070204
[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-08 17:51:03,621 - IOOppi_data - INFO : save data to db IOOppi_cs_t data:
date value
2767 2025-05-04 2252.86
2768 2025-05-05 2252.86
2769 2025-05-06 2272.86
2770 2025-05-07 2282.86
2771 2025-05-08 2904.00
2025-05-08 17:51:03,675 - 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-08 17:51:03,698 - IOOppi_data - INFO : save diff data to db IOOppi_cs_t: date ... updated_at
2771 2025-05-08 ... 2025-05-08 17:51:03.691084
[1 rows x 6 columns]
2025-05-08 17:51:03,723 - IOOppi_data - INFO : save data to db IOOppi_cs_g data:
date value
2767 2025-05-04 2252.86
2768 2025-05-05 2252.86
2769 2025-05-06 2272.86
2770 2025-05-07 2282.86
2771 2025-05-08 2904.00
2025-05-08 17:51:03,776 - 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-08 17:51:03,799 - IOOppi_data - INFO : save diff data to db IOOppi_cs_g: date ... updated_at
2774 2025-05-08 ... 2025-05-08 17:51:03.791979
[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-08 17:51:04,302 - IOOppi_data - INFO : save data to db IOOppi_RS_t data:
date value
3124 2025-05-04 9378.33
3125 2025-05-05 9378.33
3126 2025-05-06 9330.00
3127 2025-05-07 9430.00
3128 2025-05-08 9471.67
2025-05-08 17:51:04,363 - IOOppi_data - INFO : save new data to db: IOOppi_RS_t: no new data
2025-05-08 17:51:04,364 - IOOppi_data - INFO : save diff data to db: IOOppi_RS_t: no diff data
2025-05-08 17:51:04,369 - IOOppi_data - INFO : save data to db IOOppi_RS_g data:
date value
3124 2025-05-04 9378.33
3125 2025-05-05 9378.33
3126 2025-05-06 9330.00
3127 2025-05-07 9430.00
3128 2025-05-08 9471.67
2025-05-08 17:51:04,425 - IOOppi_data - INFO : save new data to db: IOOppi_RS_g: no new data
2025-05-08 17:51:04,426 - 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-08 17:51:05,091 - IOOppi_data - INFO : save data to db IOOppi_eg_t data:
date value
1808 2025-05-04 4331.67
1809 2025-05-05 4331.67
1810 2025-05-06 4331.67
1811 2025-05-07 4340.00
1812 2025-05-08 4340.00
2025-05-08 17:51:05,140 - IOOppi_data - INFO : save new data to db IOOppi_eg_t: date value ... created_at updated_at
1812 2025-05-08 4340.0 ... 2025-05-08 17:51:05.132899 2025-05-08 17:51:05.133313
[1 rows x 5 columns]
2025-05-08 17:51:05,159 - IOOppi_data - INFO : save diff data to db: IOOppi_eg_t: no diff data
2025-05-08 17:51:05,165 - IOOppi_data - INFO : save data to db IOOppi_eg_g data:
date value
1808 2025-05-04 4331.67
1809 2025-05-05 4331.67
1810 2025-05-06 4331.67
1811 2025-05-07 4340.00
1812 2025-05-08 4340.00
2025-05-08 17:51:05,214 - IOOppi_data - INFO : save new data to db IOOppi_eg_g: date value ... created_at updated_at
1815 2025-05-08 4340.0 ... 2025-05-08 17:51:05.207318 2025-05-08 17:51:05.207743
[1 rows x 5 columns]
2025-05-08 17:51:05,235 - 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-08 17:51:05,857 - IOOppi_data - INFO : save data to db IOOppi_sp_t data:
date value
1817 2025-05-04 6250.0
1818 2025-05-05 6250.0
1819 2025-05-06 6250.0
1820 2025-05-07 6200.0
1821 2025-05-08 6200.0
2025-05-08 17:51:05,905 - IOOppi_data - INFO : save new data to db IOOppi_sp_t: date value ... created_at updated_at
1821 2025-05-08 6200.0 ... 2025-05-08 17:51:05.897781 2025-05-08 17:51:05.898172
[1 rows x 5 columns]
2025-05-08 17:51:05,924 - IOOppi_data - INFO : save diff data to db: IOOppi_sp_t: no diff data
2025-05-08 17:51:05,929 - IOOppi_data - INFO : save data to db IOOppi_sp_g data:
date value
1817 2025-05-04 6250.0
1818 2025-05-05 6250.0
1819 2025-05-06 6250.0
1820 2025-05-07 6200.0
1821 2025-05-08 6200.0
2025-05-08 17:51:05,977 - IOOppi_data - INFO : save new data to db IOOppi_sp_g: date value ... created_at updated_at
1824 2025-05-08 6200.0 ... 2025-05-08 17:51:05.970255 2025-05-08 17:51:05.970629
[1 rows x 5 columns]
2025-05-08 17:51:05,996 - 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-08 17:51:06,537 - IOOppi_data - INFO : save data to db IOOppi_p_t data:
date value
3485 2025-05-04 8760.0
3486 2025-05-05 8760.0
3487 2025-05-06 8678.0
3488 2025-05-07 8584.0
3489 2025-05-08 8538.0
2025-05-08 17:51:06,606 - IOOppi_data - INFO : save new data to db IOOppi_p_t: date value ... created_at updated_at
3489 2025-05-08 8538.0 ... 2025-05-08 17:51:06.599208 2025-05-08 17:51:06.599601
[1 rows x 5 columns]
2025-05-08 17:51:06,626 - IOOppi_data - INFO : save diff data to db: IOOppi_p_t: no diff data
2025-05-08 17:51:06,632 - IOOppi_data - INFO : save data to db IOOppi_p_g data:
date value
3485 2025-05-04 8760.0
3486 2025-05-05 8760.0
3487 2025-05-06 8678.0
3488 2025-05-07 8584.0
3489 2025-05-08 8538.0
2025-05-08 17:51:06,701 - IOOppi_data - INFO : save new data to db IOOppi_p_g: date value ... created_at updated_at
3492 2025-05-08 8538.0 ... 2025-05-08 17:51:06.694559 2025-05-08 17:51:06.694973
[1 rows x 5 columns]
2025-05-08 17:51:06,721 - IOOppi_data - INFO : save diff data to db: IOOppi_p_g: no diff data