=========================================================================
2025-07-03 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-07-03 17:50:28,956 - IOOppi_data - INFO : save data to db IOOppi_rb_t data:
date value
3349 2025-06-29 3072.0
3350 2025-06-30 3072.0
3351 2025-07-01 3069.0
3352 2025-07-02 3087.5
3353 2025-07-03 3104.0
2025-07-03 17:50:29,026 - IOOppi_data - INFO : save new data to db IOOppi_rb_t: date value ... created_at updated_at
3353 2025-07-03 3104.0 ... 2025-07-03 17:50:29.018483 2025-07-03 17:50:29.018929
[1 rows x 5 columns]
2025-07-03 17:50:29,045 - IOOppi_data - INFO : save diff data to db: IOOppi_rb_t: no diff data
2025-07-03 17:50:29,051 - IOOppi_data - INFO : save data to db IOOppi_rb_g data:
date value
3349 2025-06-29 3072.0
3350 2025-06-30 3072.0
3351 2025-07-01 3069.0
3352 2025-07-02 3087.5
3353 2025-07-03 3104.0
2025-07-03 17:50:29,117 - IOOppi_data - INFO : save new data to db IOOppi_rb_g: date value ... created_at updated_at
3356 2025-07-03 3104.0 ... 2025-07-03 17:50:29.109578 2025-07-03 17:50:29.109992
[1 rows x 5 columns]
2025-07-03 17:50:29,135 - 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-03 17:50:29,744 - IOOppi_data - INFO : save data to db IOOppi_MA_t data:
date value
3570 2025-06-29 2785.83
3571 2025-06-30 2805.00
3572 2025-07-01 2530.00
3573 2025-07-02 2478.33
3574 2025-07-03 2474.17
2025-07-03 17:50:29,814 - IOOppi_data - INFO : save new data to db IOOppi_MA_t: date value ... created_at updated_at
3574 2025-07-03 2474.17 ... 2025-07-03 17:50:29.806497 2025-07-03 17:50:29.806925
[1 rows x 5 columns]
2025-07-03 17:50:29,832 - IOOppi_data - INFO : save diff data to db: IOOppi_MA_t: no diff data
2025-07-03 17:50:29,838 - IOOppi_data - INFO : save data to db IOOppi_MA_g data:
date value
3570 2025-06-29 2785.83
3571 2025-06-30 2805.00
3572 2025-07-01 2530.00
3573 2025-07-02 2478.33
3574 2025-07-03 2474.17
2025-07-03 17:50:29,906 - IOOppi_data - INFO : save new data to db IOOppi_MA_g: date value ... created_at updated_at
3578 2025-07-03 2474.17 ... 2025-07-03 17:50:29.899555 2025-07-03 17:50:29.899964
[1 rows x 5 columns]
2025-07-03 17:50:29,925 - 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-03 17:50:30,469 - IOOppi_data - INFO : save data to db IOOppi_PTA_t data:
date value
910 2025-06-29 5084.75
911 2025-06-30 5104.75
912 2025-07-01 5081.66
913 2025-07-02 5031.25
914 2025-07-03 5031.25
2025-07-03 17:50:30,506 - IOOppi_data - INFO : save new data to db IOOppi_PTA_t: date value ... created_at updated_at
914 2025-07-03 5031.25 ... 2025-07-03 17:50:30.498837 2025-07-03 17:50:30.499240
[1 rows x 5 columns]
2025-07-03 17:50:30,525 - IOOppi_data - INFO : save diff data to db: IOOppi_PTA_t: no diff data
2025-07-03 17:50:30,530 - IOOppi_data - INFO : save data to db IOOppi_PTA_g data:
date value
910 2025-06-29 5084.75
911 2025-06-30 5104.75
912 2025-07-01 5081.66
913 2025-07-02 5031.25
914 2025-07-03 5031.25
2025-07-03 17:50:30,566 - IOOppi_data - INFO : save new data to db IOOppi_PTA_g: date value ... created_at updated_at
914 2025-07-03 5031.25 ... 2025-07-03 17:50:30.559534 2025-07-03 17:50:30.559932
[1 rows x 5 columns]
2025-07-03 17:50:30,584 - 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-03 17:50:31,226 - IOOppi_data - INFO : save data to db IOOppi_ru_t data:
date value
3789 2025-06-29 13878.33
3790 2025-06-30 13858.33
3791 2025-07-01 13928.33
3792 2025-07-02 13983.33
3793 2025-07-03 13858.33
2025-07-03 17:50:31,297 - IOOppi_data - INFO : save new data to db IOOppi_ru_t: date ... updated_at
3793 2025-07-03 ... 2025-07-03 17:50:31.291167
[1 rows x 5 columns]
2025-07-03 17:50:31,317 - IOOppi_data - INFO : save diff data to db: IOOppi_ru_t: no diff data
2025-07-03 17:50:31,323 - IOOppi_data - INFO : save data to db IOOppi_ru_g data:
date value
3789 2025-06-29 13878.33
3790 2025-06-30 13858.33
3791 2025-07-01 13928.33
3792 2025-07-02 13983.33
3793 2025-07-03 13858.33
2025-07-03 17:50:31,395 - IOOppi_data - INFO : save new data to db IOOppi_ru_g: date ... updated_at
3796 2025-07-03 ... 2025-07-03 17:50:31.389223
[1 rows x 5 columns]
2025-07-03 17:50:31,414 - 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-03 17:50:33,026 - IOOppi_data - INFO : save data to db IOOppi_i_t data:
date value
3121 2025-06-29 725.44
3122 2025-06-30 726.56
3123 2025-07-01 723.44
3124 2025-07-02 720.22
3125 2025-07-03 730.67
2025-07-03 17:50:33,091 - IOOppi_data - INFO : save new data to db IOOppi_i_t: date value ... created_at updated_at
3125 2025-07-03 730.67 ... 2025-07-03 17:50:33.083363 2025-07-03 17:50:33.083810
[1 rows x 5 columns]
2025-07-03 17:50:33,109 - IOOppi_data - INFO : save diff data to db: IOOppi_i_t: no diff data
2025-07-03 17:50:33,115 - IOOppi_data - INFO : save data to db IOOppi_i_g data:
date value
3121 2025-06-29 725.44
3122 2025-06-30 726.56
3123 2025-07-01 723.44
3124 2025-07-02 720.22
3125 2025-07-03 730.67
2025-07-03 17:50:33,181 - IOOppi_data - INFO : save new data to db IOOppi_i_g: date value ... created_at updated_at
3128 2025-07-03 730.67 ... 2025-07-03 17:50:33.173047 2025-07-03 17:50:33.173452
[1 rows x 5 columns]
2025-07-03 17:50:33,200 - 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-03 17:50:33,740 - IOOppi_data - INFO : save data to db IOOppi_FG_t data:
date value
3324 2025-06-29 1105.6
3325 2025-06-30 1105.6
3326 2025-07-01 1108.0
3327 2025-07-02 1108.0
3328 2025-07-03 1108.0
2025-07-03 17:50:33,811 - IOOppi_data - INFO : save new data to db IOOppi_FG_t: date value ... created_at updated_at
3328 2025-07-03 1108.0 ... 2025-07-03 17:50:33.803403 2025-07-03 17:50:33.803894
[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-03 17:50:35,728 - IOOppi_data - INFO : save diff data to db IOOppi_FG_t: date ... updated_at
12 2012-12-19 ... 2025-07-03 17:50:35.719984
21 2013-01-04 ... 2025-07-03 17:50:35.719984
54 2013-02-27 ... 2025-07-03 17:50:35.719984
60 2013-03-07 ... 2025-07-03 17:50:35.719984
61 2013-03-08 ... 2025-07-03 17:50:35.719984
[5 rows x 6 columns]
2025-07-03 17:50:35,886 - IOOppi_data - INFO : save data to db IOOppi_FG_g data:
date value
3324 2025-06-29 1105.6
3325 2025-06-30 1105.6
3326 2025-07-01 1108.0
3327 2025-07-02 1108.0
3328 2025-07-03 1108.0
2025-07-03 17:50:35,953 - IOOppi_data - INFO : save new data to db IOOppi_FG_g: date value ... created_at updated_at
3332 2025-07-03 1108.0 ... 2025-07-03 17:50:35.945950 2025-07-03 17:50:35.946335
[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-03 17:50:37,883 - IOOppi_data - INFO : save diff data to db IOOppi_FG_g: date ... updated_at
12 2012-12-19 ... 2025-07-03 17:50:37.875282
21 2013-01-04 ... 2025-07-03 17:50:37.875282
54 2013-02-27 ... 2025-07-03 17:50:37.875282
60 2013-03-07 ... 2025-07-03 17:50:37.875282
61 2013-03-08 ... 2025-07-03 17:50:37.875282
[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-03 17:50:38,613 - IOOppi_data - INFO : save data to db IOOppi_eb_t data:
date value
1669 2025-06-29 8084.0
1670 2025-06-30 8050.0
1671 2025-07-01 8036.0
1672 2025-07-02 8036.0
1673 2025-07-03 7904.0
2025-07-03 17:50:38,659 - IOOppi_data - INFO : save new data to db IOOppi_eb_t: date value ... created_at updated_at
1673 2025-07-03 7904.0 ... 2025-07-03 17:50:38.652103 2025-07-03 17:50:38.652486
[1 rows x 5 columns]
2025-07-03 17:50:38,678 - IOOppi_data - INFO : save diff data to db: IOOppi_eb_t: no diff data
2025-07-03 17:50:38,683 - IOOppi_data - INFO : save data to db IOOppi_eb_g data:
date value
1669 2025-06-29 8084.0
1670 2025-06-30 8050.0
1671 2025-07-01 8036.0
1672 2025-07-02 8036.0
1673 2025-07-03 7904.0
2025-07-03 17:50:38,731 - IOOppi_data - INFO : save new data to db IOOppi_eb_g: date value ... created_at updated_at
1676 2025-07-03 7904.0 ... 2025-07-03 17:50:38.723967 2025-07-03 17:50:38.724363
[1 rows x 5 columns]
2025-07-03 17:50:38,750 - 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-03 17:50:39,340 - IOOppi_data - INFO : save data to db IOOppi_SR_t data:
date value
3780 2025-06-29 6056.67
3781 2025-06-30 6053.33
3782 2025-07-01 6060.00
3783 2025-07-02 6050.00
3784 2025-07-03 6050.00
2025-07-03 17:50:39,413 - IOOppi_data - INFO : save new data to db IOOppi_SR_t: date value ... created_at updated_at
3784 2025-07-03 6050.0 ... 2025-07-03 17:50:39.406665 2025-07-03 17:50:39.407075
[1 rows x 5 columns]
2025-07-03 17:50:39,432 - IOOppi_data - INFO : save diff data to db: IOOppi_SR_t: no diff data
2025-07-03 17:50:39,438 - IOOppi_data - INFO : save data to db IOOppi_SR_g data:
date value
3780 2025-06-29 6056.67
3781 2025-06-30 6053.33
3782 2025-07-01 6060.00
3783 2025-07-02 6050.00
3784 2025-07-03 6050.00
2025-07-03 17:50:39,510 - IOOppi_data - INFO : save new data to db IOOppi_SR_g: date value ... created_at updated_at
3788 2025-07-03 6050.0 ... 2025-07-03 17:50:39.503811 2025-07-03 17:50:39.504196
[1 rows x 5 columns]
2025-07-03 17:50:39,531 - 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-03 17:50:40,056 - IOOppi_data - INFO : save data to db IOOppi_ss_t data:
date value
1670 2025-06-29 12762.5
1671 2025-06-30 12775.0
1672 2025-07-01 12775.0
1673 2025-07-02 12825.0
1674 2025-07-03 12825.0
2025-07-03 17:50:40,101 - IOOppi_data - INFO : save new data to db IOOppi_ss_t: date value ... created_at updated_at
1674 2025-07-03 12825.0 ... 2025-07-03 17:50:40.094257 2025-07-03 17:50:40.094637
[1 rows x 5 columns]
2025-07-03 17:50:40,120 - IOOppi_data - INFO : save diff data to db: IOOppi_ss_t: no diff data
2025-07-03 17:50:40,126 - IOOppi_data - INFO : save data to db IOOppi_ss_g data:
date value
1670 2025-06-29 12762.5
1671 2025-06-30 12775.0
1672 2025-07-01 12775.0
1673 2025-07-02 12825.0
1674 2025-07-03 12825.0
2025-07-03 17:50:40,173 - IOOppi_data - INFO : save new data to db IOOppi_ss_g: date value ... created_at updated_at
1677 2025-07-03 12825.0 ... 2025-07-03 17:50:40.166104 2025-07-03 17:50:40.166486
[1 rows x 5 columns]
2025-07-03 17:50:40,191 - 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-03 17:50:40,733 - IOOppi_data - INFO : save data to db IOOppi_RS_t data:
date value
3180 2025-06-29 9631.67
3181 2025-06-30 9581.67
3182 2025-07-01 9625.00
3183 2025-07-02 9763.33
3184 2025-07-03 9775.00
2025-07-03 17:50:40,798 - IOOppi_data - INFO : save new data to db IOOppi_RS_t: date value ... created_at updated_at
3184 2025-07-03 9775.0 ... 2025-07-03 17:50:40.791082 2025-07-03 17:50:40.791462
[1 rows x 5 columns]
2025-07-03 17:50:40,816 - IOOppi_data - INFO : save diff data to db: IOOppi_RS_t: no diff data
2025-07-03 17:50:40,822 - IOOppi_data - INFO : save data to db IOOppi_RS_g data:
date value
3180 2025-06-29 9631.67
3181 2025-06-30 9581.67
3182 2025-07-01 9625.00
3183 2025-07-02 9763.33
3184 2025-07-03 9775.00
2025-07-03 17:50:40,887 - IOOppi_data - INFO : save new data to db IOOppi_RS_g: date value ... created_at updated_at
3188 2025-07-03 9775.0 ... 2025-07-03 17:50:40.880123 2025-07-03 17:50:40.880499
[1 rows x 5 columns]
2025-07-03 17:50:40,906 - 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-03 17:50:41,472 - IOOppi_data - INFO : save data to db IOOppi_RM_t data:
date value
3303 2025-06-29 2475.00
3304 2025-06-30 2500.00
3305 2025-07-01 2516.67
3306 2025-07-02 2506.67
3307 2025-07-03 2530.00
2025-07-03 17:50:41,540 - IOOppi_data - INFO : save new data to db IOOppi_RM_t: date value ... created_at updated_at
3307 2025-07-03 2530.0 ... 2025-07-03 17:50:41.532823 2025-07-03 17:50:41.533251
[1 rows x 5 columns]
2025-07-03 17:50:41,559 - IOOppi_data - INFO : save diff data to db: IOOppi_RM_t: no diff data
2025-07-03 17:50:41,565 - IOOppi_data - INFO : save data to db IOOppi_RM_g data:
date value
3303 2025-06-29 2475.00
3304 2025-06-30 2500.00
3305 2025-07-01 2516.67
3306 2025-07-02 2506.67
3307 2025-07-03 2530.00
2025-07-03 17:50:41,634 - IOOppi_data - INFO : save new data to db IOOppi_RM_g: date value ... created_at updated_at
3311 2025-07-03 2530.0 ... 2025-07-03 17:50:41.626298 2025-07-03 17:50:41.626684
[1 rows x 5 columns]
2025-07-03 17:50:41,652 - 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-03 17:50:42,144 - IOOppi_data - INFO : save data to db IOOppi_SA_t data:
date value
1507 2025-06-29 1337.5
1508 2025-06-30 1325.0
1509 2025-07-01 1325.0
1510 2025-07-02 1252.5
1511 2025-07-03 1252.5
2025-07-03 17:50:42,187 - IOOppi_data - INFO : save new data to db IOOppi_SA_t: date value ... created_at updated_at
1511 2025-07-03 1252.5 ... 2025-07-03 17:50:42.180529 2025-07-03 17:50:42.180944
[1 rows x 5 columns]
2025-07-03 17:50:42,206 - IOOppi_data - INFO : save diff data to db: IOOppi_SA_t: no diff data
2025-07-03 17:50:42,211 - IOOppi_data - INFO : save data to db IOOppi_SA_g data:
date value
1507 2025-06-29 1337.5
1508 2025-06-30 1325.0
1509 2025-07-01 1325.0
1510 2025-07-02 1252.5
1511 2025-07-03 1252.5
2025-07-03 17:50:42,255 - IOOppi_data - INFO : save new data to db IOOppi_SA_g: date value ... created_at updated_at
1515 2025-07-03 1252.5 ... 2025-07-03 17:50:42.248699 2025-07-03 17:50:42.249108
[1 rows x 5 columns]
2025-07-03 17:50:42,274 - 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-03 17:50:42,874 - IOOppi_data - INFO : save data to db IOOppi_PF_t data:
date value
1420 2025-06-29 6736.04
1421 2025-06-30 6727.92
1422 2025-07-01 6735.00
1423 2025-07-02 6744.17
1424 2025-07-03 6748.54
2025-07-03 17:50:42,917 - IOOppi_data - INFO : save new data to db IOOppi_PF_t: date value ... created_at updated_at
1424 2025-07-03 6748.54 ... 2025-07-03 17:50:42.909674 2025-07-03 17:50:42.910097
[1 rows x 5 columns]
2025-07-03 17:50:42,936 - IOOppi_data - INFO : save diff data to db: IOOppi_PF_t: no diff data
2025-07-03 17:50:42,941 - IOOppi_data - INFO : save data to db IOOppi_PF_g data:
date value
1420 2025-06-29 6736.04
1421 2025-06-30 6727.92
1422 2025-07-01 6735.00
1423 2025-07-02 6744.17
1424 2025-07-03 6748.54
2025-07-03 17:50:42,986 - IOOppi_data - INFO : save new data to db IOOppi_PF_g: date value ... created_at updated_at
1428 2025-07-03 6748.54 ... 2025-07-03 17:50:42.978334 2025-07-03 17:50:42.978803
[1 rows x 5 columns]
2025-07-03 17:50:43,005 - 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-03 17:50:43,623 - IOOppi_data - INFO : save data to db IOOppi_m_t data:
date value
3793 2025-06-29 2906.0
3794 2025-06-30 2906.0
3795 2025-07-01 2930.0
3796 2025-07-02 2922.0
3797 2025-07-03 2930.0
2025-07-03 17:50:43,696 - IOOppi_data - INFO : save new data to db IOOppi_m_t: date value ... created_at updated_at
3797 2025-07-03 2930.0 ... 2025-07-03 17:50:43.689202 2025-07-03 17:50:43.689628
[1 rows x 5 columns]
2025-07-03 17:50:43,715 - IOOppi_data - INFO : save diff data to db: IOOppi_m_t: no diff data
2025-07-03 17:50:43,721 - IOOppi_data - INFO : save data to db IOOppi_m_g data:
date value
3793 2025-06-29 2906.0
3794 2025-06-30 2906.0
3795 2025-07-01 2930.0
3796 2025-07-02 2922.0
3797 2025-07-03 2930.0
2025-07-03 17:50:43,795 - IOOppi_data - INFO : save new data to db IOOppi_m_g: date value ... created_at updated_at
3800 2025-07-03 2930.0 ... 2025-07-03 17:50:43.787974 2025-07-03 17:50:43.788390
[1 rows x 5 columns]
2025-07-03 17:50:43,814 - 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-03 17:50:44,398 - IOOppi_data - INFO : save data to db IOOppi_y_t data:
date value
3563 2025-06-29 8254.0
3564 2025-06-30 8234.0
3565 2025-07-01 8224.0
3566 2025-07-02 8284.0
3567 2025-07-03 8264.0
2025-07-03 17:50:44,468 - IOOppi_data - INFO : save new data to db IOOppi_y_t: date value ... created_at updated_at
3567 2025-07-03 8264.0 ... 2025-07-03 17:50:44.460630 2025-07-03 17:50:44.461046
[1 rows x 5 columns]
2025-07-03 17:50:44,486 - IOOppi_data - INFO : save diff data to db: IOOppi_y_t: no diff data
2025-07-03 17:50:44,492 - IOOppi_data - INFO : save data to db IOOppi_y_g data:
date value
3563 2025-06-29 8254.0
3564 2025-06-30 8234.0
3565 2025-07-01 8224.0
3566 2025-07-02 8284.0
3567 2025-07-03 8264.0
2025-07-03 17:50:44,563 - IOOppi_data - INFO : save new data to db IOOppi_y_g: date value ... created_at updated_at
3570 2025-07-03 8264.0 ... 2025-07-03 17:50:44.555323 2025-07-03 17:50:44.555927
[1 rows x 5 columns]
2025-07-03 17:50:44,581 - 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-03 17:50:45,169 - IOOppi_data - INFO : save data to db IOOppi_a_t data:
date value
3529 2025-06-29 4295.0
3530 2025-06-30 4295.0
3531 2025-07-01 4295.0
3532 2025-07-02 4295.0
3533 2025-07-03 4295.0
2025-07-03 17:50:45,239 - IOOppi_data - INFO : save new data to db IOOppi_a_t: date value ... created_at updated_at
3533 2025-07-03 4295.0 ... 2025-07-03 17:50:45.231529 2025-07-03 17:50:45.232114
[1 rows x 5 columns]
2025-07-03 17:50:45,258 - IOOppi_data - INFO : save diff data to db: IOOppi_a_t: no diff data
2025-07-03 17:50:45,264 - IOOppi_data - INFO : save data to db IOOppi_a_g data:
date value
3529 2025-06-29 4295.0
3530 2025-06-30 4295.0
3531 2025-07-01 4295.0
3532 2025-07-02 4295.0
3533 2025-07-03 4295.0
2025-07-03 17:50:45,335 - IOOppi_data - INFO : save new data to db IOOppi_a_g: date value ... created_at updated_at
3536 2025-07-03 4295.0 ... 2025-07-03 17:50:45.327968 2025-07-03 17:50:45.328358
[1 rows x 5 columns]
2025-07-03 17:50:45,354 - 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-03 17:50:46,094 - IOOppi_data - INFO : save data to db IOOppi_SF_t data:
date value
2906 2025-06-29 5158.57
2907 2025-06-30 5158.57
2908 2025-07-01 5158.57
2909 2025-07-02 5122.86
2910 2025-07-03 5122.86
2025-07-03 17:50:46,157 - IOOppi_data - INFO : save new data to db IOOppi_SF_t: date value ... created_at updated_at
2910 2025-07-03 5122.86 ... 2025-07-03 17:50:46.150194 2025-07-03 17:50:46.150588
[1 rows x 5 columns]
2025-07-03 17:50:46,176 - IOOppi_data - INFO : save diff data to db: IOOppi_SF_t: no diff data
2025-07-03 17:50:46,182 - IOOppi_data - INFO : save data to db IOOppi_SF_g data:
date value
2906 2025-06-29 5158.57
2907 2025-06-30 5158.57
2908 2025-07-01 5158.57
2909 2025-07-02 5122.86
2910 2025-07-03 5122.86
2025-07-03 17:50:46,245 - IOOppi_data - INFO : save new data to db IOOppi_SF_g: date value ... created_at updated_at
2914 2025-07-03 5122.86 ... 2025-07-03 17:50:46.238064 2025-07-03 17:50:46.238500
[1 rows x 5 columns]
2025-07-03 17:50:46,264 - 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-03 17:50:46,810 - IOOppi_data - INFO : save data to db IOOppi_jd_t data:
date value
3106 2025-06-29 2890.0
3107 2025-06-30 2810.0
3108 2025-07-01 2790.0
3109 2025-07-02 2790.0
3110 2025-07-03 2790.0
2025-07-03 17:50:46,876 - IOOppi_data - INFO : save new data to db IOOppi_jd_t: date value ... created_at updated_at
3110 2025-07-03 2790.0 ... 2025-07-03 17:50:46.868481 2025-07-03 17:50:46.868898
[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-03 17:50:47,020 - IOOppi_data - INFO : save diff data to db IOOppi_jd_t: date ... updated_at
39 2014-01-03 ... 2025-07-03 17:50:47.012156
458 2015-09-21 ... 2025-07-03 17:50:47.012156
549 2016-02-03 ... 2025-07-03 17:50:47.012156
693 2016-09-05 ... 2025-07-03 17:50:47.012156
696 2016-09-08 ... 2025-07-03 17:50:47.012156
[5 rows x 6 columns]
2025-07-03 17:50:47,050 - IOOppi_data - INFO : save data to db IOOppi_jd_g data:
date value
3106 2025-06-29 2890.0
3107 2025-06-30 2810.0
3108 2025-07-01 2790.0
3109 2025-07-02 2790.0
3110 2025-07-03 2790.0
2025-07-03 17:50:47,115 - IOOppi_data - INFO : save new data to db IOOppi_jd_g: date value ... created_at updated_at
3113 2025-07-03 2790.0 ... 2025-07-03 17:50:47.107424 2025-07-03 17:50:47.107834
[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-03 17:50:47,257 - IOOppi_data - INFO : save diff data to db IOOppi_jd_g: date ... updated_at
39 2014-01-03 ... 2025-07-03 17:50:47.249912
458 2015-09-21 ... 2025-07-03 17:50:47.249912
549 2016-02-03 ... 2025-07-03 17:50:47.249912
693 2016-09-05 ... 2025-07-03 17:50:47.249912
696 2016-09-08 ... 2025-07-03 17:50:47.249912
[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-03 17:50:47,988 - IOOppi_data - INFO : save data to db IOOppi_SI_t data:
date value
910 2025-06-29 8640.0
911 2025-06-30 8730.0
912 2025-07-01 8730.0
913 2025-07-02 8850.0
914 2025-07-03 8890.0
2025-07-03 17:50:48,025 - IOOppi_data - INFO : save new data to db IOOppi_SI_t: date value ... created_at updated_at
914 2025-07-03 8890.0 ... 2025-07-03 17:50:48.017902 2025-07-03 17:50:48.018355
[1 rows x 5 columns]
2025-07-03 17:50:48,045 - IOOppi_data - INFO : save diff data to db: IOOppi_SI_t: no diff data
2025-07-03 17:50:48,050 - IOOppi_data - INFO : save data to db IOOppi_SI_g data:
date value
910 2025-06-29 8640.0
911 2025-06-30 8730.0
912 2025-07-01 8730.0
913 2025-07-02 8850.0
914 2025-07-03 8890.0
2025-07-03 17:50:48,086 - IOOppi_data - INFO : save new data to db IOOppi_SI_g: date value ... created_at updated_at
914 2025-07-03 8890.0 ... 2025-07-03 17:50:48.079079 2025-07-03 17:50:48.079457
[1 rows x 5 columns]
2025-07-03 17:50:48,104 - 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-03 17:50:48,684 - IOOppi_data - INFO : save data to db IOOppi_l_t data:
date value
3789 2025-06-29 7511.67
3790 2025-06-30 7503.33
3791 2025-07-01 7486.67
3792 2025-07-02 7466.67
3793 2025-07-03 7441.67
2025-07-03 17:50:48,757 - IOOppi_data - INFO : save new data to db IOOppi_l_t: date value ... created_at updated_at
3793 2025-07-03 7441.67 ... 2025-07-03 17:50:48.749873 2025-07-03 17:50:48.750293
[1 rows x 5 columns]
2025-07-03 17:50:48,775 - IOOppi_data - INFO : save diff data to db: IOOppi_l_t: no diff data
2025-07-03 17:50:48,782 - IOOppi_data - INFO : save data to db IOOppi_l_g data:
date value
3789 2025-06-29 7511.67
3790 2025-06-30 7503.33
3791 2025-07-01 7486.67
3792 2025-07-02 7466.67
3793 2025-07-03 7441.67
2025-07-03 17:50:48,853 - IOOppi_data - INFO : save new data to db IOOppi_l_g: date value ... created_at updated_at
3796 2025-07-03 7441.67 ... 2025-07-03 17:50:48.846686 2025-07-03 17:50:48.847097
[1 rows x 5 columns]
2025-07-03 17:50:48,872 - 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-03 17:50:49,470 - IOOppi_data - INFO : save data to db IOOppi_bu_t data:
date value
3127 2025-06-29 3700.00
3128 2025-06-30 3673.33
3129 2025-07-01 3670.00
3130 2025-07-02 3670.00
3131 2025-07-03 3683.33
2025-07-03 17:50:49,538 - IOOppi_data - INFO : save new data to db IOOppi_bu_t: date value ... created_at updated_at
3132 2025-07-03 3683.33 ... 2025-07-03 17:50:49.530692 2025-07-03 17:50:49.531181
[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-03 17:50:49,574 - IOOppi_data - INFO : save diff data to db IOOppi_bu_t: date ... updated_at
2560 2023-12-09 ... 2025-07-03 17:50:49.566537
[1 rows x 6 columns]
2025-07-03 17:50:49,598 - IOOppi_data - INFO : save data to db IOOppi_bu_g data:
date value
3127 2025-06-29 3700.00
3128 2025-06-30 3673.33
3129 2025-07-01 3670.00
3130 2025-07-02 3670.00
3131 2025-07-03 3683.33
2025-07-03 17:50:49,663 - IOOppi_data - INFO : save new data to db IOOppi_bu_g: date value ... created_at updated_at
3134 2025-07-03 3683.33 ... 2025-07-03 17:50:49.656254 2025-07-03 17:50:49.656630
[1 rows x 5 columns]
2025-07-03 17:50:49,682 - 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-03 17:50:50,307 - IOOppi_data - INFO : save data to db IOOppi_al_t data:
date value
3792 2025-06-29 20903.33
3793 2025-06-30 20786.67
3794 2025-07-01 20786.67
3795 2025-07-02 20786.67
3796 2025-07-03 20816.67
2025-07-03 17:50:50,379 - IOOppi_data - INFO : save new data to db IOOppi_al_t: date ... updated_at
3796 2025-07-03 ... 2025-07-03 17:50:50.372976
[1 rows x 5 columns]
2025-07-03 17:50:50,398 - IOOppi_data - INFO : save diff data to db: IOOppi_al_t: no diff data
2025-07-03 17:50:50,404 - IOOppi_data - INFO : save data to db IOOppi_al_g data:
date value
3792 2025-06-29 20903.33
3793 2025-06-30 20786.67
3794 2025-07-01 20786.67
3795 2025-07-02 20786.67
3796 2025-07-03 20816.67
2025-07-03 17:50:50,477 - IOOppi_data - INFO : save new data to db IOOppi_al_g: date ... updated_at
3799 2025-07-03 ... 2025-07-03 17:50:50.470732
[1 rows x 5 columns]
2025-07-03 17:50:50,495 - 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-03 17:50:51,096 - IOOppi_data - INFO : save data to db IOOppi_SM_t data:
date value
2906 2025-06-29 5572.0
2907 2025-06-30 5564.0
2908 2025-07-01 5536.0
2909 2025-07-02 5544.0
2910 2025-07-03 5576.0
2025-07-03 17:50:51,157 - IOOppi_data - INFO : save new data to db IOOppi_SM_t: date value ... created_at updated_at
2910 2025-07-03 5576.0 ... 2025-07-03 17:50:51.150351 2025-07-03 17:50:51.150734
[1 rows x 5 columns]
2025-07-03 17:50:51,176 - IOOppi_data - INFO : save diff data to db: IOOppi_SM_t: no diff data
2025-07-03 17:50:51,182 - IOOppi_data - INFO : save data to db IOOppi_SM_g data:
date value
2906 2025-06-29 5572.0
2907 2025-06-30 5564.0
2908 2025-07-01 5536.0
2909 2025-07-02 5544.0
2910 2025-07-03 5576.0
2025-07-03 17:50:51,244 - IOOppi_data - INFO : save new data to db IOOppi_SM_g: date value ... created_at updated_at
2914 2025-07-03 5576.0 ... 2025-07-03 17:50:51.237724 2025-07-03 17:50:51.238138
[1 rows x 5 columns]
2025-07-03 17:50:51,263 - 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-03 17:50:51,897 - IOOppi_data - INFO : save data to db IOOppi_CY_t data:
date value
2181 2025-06-29 23200.0
2182 2025-06-30 23200.0
2183 2025-07-01 23200.0
2184 2025-07-02 23200.0
2185 2025-07-03 23200.0
2025-07-03 17:50:51,949 - IOOppi_data - INFO : save new data to db IOOppi_CY_t: date value ... created_at updated_at
2185 2025-07-03 23200.0 ... 2025-07-03 17:50:51.942385 2025-07-03 17:50:51.942799
[1 rows x 5 columns]
2025-07-03 17:50:51,968 - IOOppi_data - INFO : save diff data to db: IOOppi_CY_t: no diff data
2025-07-03 17:50:51,974 - IOOppi_data - INFO : save data to db IOOppi_CY_g data:
date value
2181 2025-06-29 23200.0
2182 2025-06-30 23200.0
2183 2025-07-01 23200.0
2184 2025-07-02 23200.0
2185 2025-07-03 23200.0
2025-07-03 17:50:52,027 - IOOppi_data - INFO : save new data to db IOOppi_CY_g: date value ... created_at updated_at
2189 2025-07-03 23200.0 ... 2025-07-03 17:50:52.020197 2025-07-03 17:50:52.020639
[1 rows x 5 columns]
2025-07-03 17:50:52,047 - 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-03 17:50:52,690 - IOOppi_data - INFO : save data to db IOOppi_UR_t data:
date value
1696 2025-06-29 1827.0
1697 2025-06-30 1823.0
1698 2025-07-01 1829.0
1699 2025-07-02 1825.0
1700 2025-07-03 1829.0
2025-07-03 17:50:52,737 - IOOppi_data - INFO : save new data to db IOOppi_UR_t: date value ... created_at updated_at
1700 2025-07-03 1829.0 ... 2025-07-03 17:50:52.730381 2025-07-03 17:50:52.730792
[1 rows x 5 columns]
2025-07-03 17:50:52,756 - IOOppi_data - INFO : save diff data to db: IOOppi_UR_t: no diff data
2025-07-03 17:50:52,762 - IOOppi_data - INFO : save data to db IOOppi_UR_g data:
date value
1696 2025-06-29 1827.0
1697 2025-06-30 1823.0
1698 2025-07-01 1829.0
1699 2025-07-02 1825.0
1700 2025-07-03 1829.0
2025-07-03 17:50:52,809 - IOOppi_data - INFO : save new data to db IOOppi_UR_g: date value ... created_at updated_at
1704 2025-07-03 1829.0 ... 2025-07-03 17:50:52.801690 2025-07-03 17:50:52.802107
[1 rows x 5 columns]
2025-07-03 17:50:52,828 - 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-03 17:50:53,463 - IOOppi_data - INFO : save data to db IOOppi_ni_t data:
date value
2768 2025-06-29 122433.33
2769 2025-06-30 122400.00
2770 2025-07-01 121700.00
2771 2025-07-02 122383.33
2772 2025-07-03 122933.33
2025-07-03 17:50:53,523 - IOOppi_data - INFO : save new data to db IOOppi_ni_t: date ... updated_at
2772 2025-07-03 ... 2025-07-03 17:50:53.516983
[1 rows x 5 columns]
2025-07-03 17:50:53,542 - IOOppi_data - INFO : save diff data to db: IOOppi_ni_t: no diff data
2025-07-03 17:50:53,548 - IOOppi_data - INFO : save data to db IOOppi_ni_g data:
date value
2768 2025-06-29 122433.33
2769 2025-06-30 122400.00
2770 2025-07-01 121700.00
2771 2025-07-02 122383.33
2772 2025-07-03 122933.33
2025-07-03 17:50:53,608 - IOOppi_data - INFO : save new data to db IOOppi_ni_g: date ... updated_at
2775 2025-07-03 ... 2025-07-03 17:50:53.601846
[1 rows x 5 columns]
2025-07-03 17:50:53,626 - IOOppi_data - INFO : save diff data to db: IOOppi_ni_g: no diff data
/usr/local/lib/python3.10/site-packages/urllib3/connectionpool.py:1056: InsecureRequestWarning: Unverified HTTPS request is being made to host 'www.100ppi.com'. Adding certificate verification is strongly advised. See: https://urllib3.readthedocs.io/en/1.26.x/advanced-usage.html#ssl-warnings
warnings.warn(
2025-07-03 17:50:54,220 - IOOppi_data - INFO : save data to db IOOppi_v_t data:
date value
3793 2025-06-29 4673.0
3794 2025-06-30 4658.0
3795 2025-07-01 4597.0
3796 2025-07-02 4654.0
3797 2025-07-03 4693.0
2025-07-03 17:50:54,366 - IOOppi_data - INFO : save new data to db IOOppi_v_t: date value ... created_at updated_at
3797 2025-07-03 4693.0 ... 2025-07-03 17:50:54.358812 2025-07-03 17:50:54.359210
[1 rows x 5 columns]
2025-07-03 17:50:54,385 - IOOppi_data - INFO : save diff data to db: IOOppi_v_t: no diff data
2025-07-03 17:50:54,390 - IOOppi_data - INFO : save data to db IOOppi_v_g data:
date value
3793 2025-06-29 4673.0
3794 2025-06-30 4658.0
3795 2025-07-01 4597.0
3796 2025-07-02 4654.0
3797 2025-07-03 4693.0
2025-07-03 17:50:54,464 - IOOppi_data - INFO : save new data to db IOOppi_v_g: date value ... created_at updated_at
3800 2025-07-03 4693.0 ... 2025-07-03 17:50:54.457002 2025-07-03 17:50:54.457405
[1 rows x 5 columns]
2025-07-03 17:50:54,482 - 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-03 17:50:55,121 - IOOppi_data - INFO : save data to db IOOppi_pp_t data:
date value
3032 2025-06-29 7483.33
3033 2025-06-30 7466.67
3034 2025-07-01 7458.33
3035 2025-07-02 7325.00
3036 2025-07-03 7406.67
2025-07-03 17:50:55,187 - IOOppi_data - INFO : save new data to db IOOppi_pp_t: date value ... created_at updated_at
3036 2025-07-03 7406.67 ... 2025-07-03 17:50:55.179507 2025-07-03 17:50:55.179972
[1 rows x 5 columns]
2025-07-03 17:50:55,205 - IOOppi_data - INFO : save diff data to db: IOOppi_pp_t: no diff data
2025-07-03 17:50:55,214 - IOOppi_data - INFO : save data to db IOOppi_pp_g data:
date value
3032 2025-06-29 7483.33
3033 2025-06-30 7466.67
3034 2025-07-01 7458.33
3035 2025-07-02 7325.00
3036 2025-07-03 7406.67
2025-07-03 17:50:55,279 - IOOppi_data - INFO : save new data to db IOOppi_pp_g: date value ... created_at updated_at
3039 2025-07-03 7406.67 ... 2025-07-03 17:50:55.271746 2025-07-03 17:50:55.272207
[1 rows x 5 columns]
2025-07-03 17:50:55,297 - 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-03 17:50:56,016 - IOOppi_data - INFO : save data to db IOOppi_CF_t data:
date value
3794 2025-06-29 15105.67
3795 2025-06-30 15159.83
3796 2025-07-01 15210.00
3797 2025-07-02 15160.33
3798 2025-07-03 15160.33
2025-07-03 17:50:56,090 - IOOppi_data - INFO : save new data to db IOOppi_CF_t: date ... updated_at
3798 2025-07-03 ... 2025-07-03 17:50:56.083387
[1 rows x 5 columns]
2025-07-03 17:50:56,108 - IOOppi_data - INFO : save diff data to db: IOOppi_CF_t: no diff data
2025-07-03 17:50:56,115 - IOOppi_data - INFO : save data to db IOOppi_CF_g data:
date value
3794 2025-06-29 15105.67
3795 2025-06-30 15159.83
3796 2025-07-01 15210.00
3797 2025-07-02 15160.33
3798 2025-07-03 15160.33
2025-07-03 17:50:56,187 - IOOppi_data - INFO : save new data to db IOOppi_CF_g: date ... updated_at
3802 2025-07-03 ... 2025-07-03 17:50:56.180609
[1 rows x 5 columns]
2025-07-03 17:50:56,204 - 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-03 17:50:56,859 - IOOppi_data - INFO : save data to db IOOppi_pb_t data:
date value
3739 2025-06-29 17072.50
3740 2025-06-30 17043.75
3741 2025-07-01 17018.75
3742 2025-07-02 17010.00
3743 2025-07-03 17100.00
2025-07-03 17:50:56,936 - IOOppi_data - INFO : save new data to db IOOppi_pb_t: date value ... created_at updated_at
3743 2025-07-03 17100.0 ... 2025-07-03 17:50:56.927017 2025-07-03 17:50:56.927639
[1 rows x 5 columns]
2025-07-03 17:50:56,955 - IOOppi_data - INFO : save diff data to db: IOOppi_pb_t: no diff data
2025-07-03 17:50:56,961 - IOOppi_data - INFO : save data to db IOOppi_pb_g data:
date value
3739 2025-06-29 17072.50
3740 2025-06-30 17043.75
3741 2025-07-01 17018.75
3742 2025-07-02 17010.00
3743 2025-07-03 17100.00
2025-07-03 17:50:57,034 - IOOppi_data - INFO : save new data to db IOOppi_pb_g: date value ... created_at updated_at
3746 2025-07-03 17100.0 ... 2025-07-03 17:50:57.026853 2025-07-03 17:50:57.027252
[1 rows x 5 columns]
2025-07-03 17:50:57,052 - 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-03 17:50:57,611 - IOOppi_data - INFO : save data to db IOOppi_hc_t data:
date value
3014 2025-06-29 3206.67
3015 2025-06-30 3210.00
3016 2025-07-01 3206.67
3017 2025-07-02 3216.67
3018 2025-07-03 3233.33
2025-07-03 17:50:57,673 - IOOppi_data - INFO : save new data to db IOOppi_hc_t: date value ... created_at updated_at
3018 2025-07-03 3233.33 ... 2025-07-03 17:50:57.666148 2025-07-03 17:50:57.666537
[1 rows x 5 columns]
2025-07-03 17:50:57,692 - IOOppi_data - INFO : save diff data to db: IOOppi_hc_t: no diff data
2025-07-03 17:50:57,697 - IOOppi_data - INFO : save data to db IOOppi_hc_g data:
date value
3014 2025-06-29 3206.67
3015 2025-06-30 3210.00
3016 2025-07-01 3206.67
3017 2025-07-02 3216.67
3018 2025-07-03 3233.33
2025-07-03 17:50:57,761 - IOOppi_data - INFO : save new data to db IOOppi_hc_g: date value ... created_at updated_at
3021 2025-07-03 3233.33 ... 2025-07-03 17:50:57.754085 2025-07-03 17:50:57.754472
[1 rows x 5 columns]
2025-07-03 17:50:57,781 - 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-03 17:50:58,385 - IOOppi_data - INFO : save data to db IOOppi_fu_t data:
date value
3294 2025-06-29 5512.5
3295 2025-06-30 5462.5
3296 2025-07-01 5437.5
3297 2025-07-02 5425.0
3298 2025-07-03 5450.0
2025-07-03 17:50:58,452 - IOOppi_data - INFO : save new data to db IOOppi_fu_t: date value ... created_at updated_at
3298 2025-07-03 5450.0 ... 2025-07-03 17:50:58.445485 2025-07-03 17:50:58.445911
[1 rows x 5 columns]
2025-07-03 17:50:58,471 - IOOppi_data - INFO : save diff data to db: IOOppi_fu_t: no diff data
2025-07-03 17:50:58,478 - IOOppi_data - INFO : save data to db IOOppi_fu_g data:
date value
3294 2025-06-29 5512.5
3295 2025-06-30 5462.5
3296 2025-07-01 5437.5
3297 2025-07-02 5425.0
3298 2025-07-03 5450.0
2025-07-03 17:50:58,553 - IOOppi_data - INFO : save new data to db IOOppi_fu_g: date value ... created_at updated_at
3785 2025-07-03 5450.0 ... 2025-07-03 17:50:58.545478 2025-07-03 17:50:58.545939
[1 rows x 5 columns]
2025-07-03 17:50:58,571 - 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-03 17:50:59,084 - IOOppi_data - INFO : save data to db IOOppi_lh_t data:
date value
1358 2025-06-29 14420.0
1359 2025-06-30 14480.0
1360 2025-07-01 14620.0
1361 2025-07-02 14750.0
1362 2025-07-03 14920.0
2025-07-03 17:50:59,127 - IOOppi_data - INFO : save new data to db IOOppi_lh_t: date value ... created_at updated_at
1362 2025-07-03 14920.0 ... 2025-07-03 17:50:59.120631 2025-07-03 17:50:59.121049
[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-03 17:50:59,358 - IOOppi_data - INFO : save diff data to db IOOppi_lh_t: date ... updated_at
116 2021-07-05 ... 2025-07-03 17:50:59.350388
117 2021-07-06 ... 2025-07-03 17:50:59.350388
121 2021-07-12 ... 2025-07-03 17:50:59.350388
122 2021-07-13 ... 2025-07-03 17:50:59.350388
194 2021-11-01 ... 2025-07-03 17:50:59.350388
[5 rows x 6 columns]
2025-07-03 17:50:59,394 - IOOppi_data - INFO : save data to db IOOppi_lh_g data:
date value
1358 2025-06-29 14420.0
1359 2025-06-30 14480.0
1360 2025-07-01 14620.0
1361 2025-07-02 14750.0
1362 2025-07-03 14920.0
2025-07-03 17:50:59,439 - IOOppi_data - INFO : save new data to db IOOppi_lh_g: date value ... created_at updated_at
1365 2025-07-03 14920.0 ... 2025-07-03 17:50:59.431809 2025-07-03 17:50:59.432222
[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-03 17:50:59,675 - IOOppi_data - INFO : save diff data to db IOOppi_lh_g: date ... updated_at
116 2021-07-05 ... 2025-07-03 17:50:59.666857
117 2021-07-06 ... 2025-07-03 17:50:59.666857
121 2021-07-12 ... 2025-07-03 17:50:59.666857
122 2021-07-13 ... 2025-07-03 17:50:59.666857
194 2021-11-01 ... 2025-07-03 17:50:59.666857
[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-03 17:51:00,369 - IOOppi_data - INFO : save data to db IOOppi_cu_t data:
date value
3790 2025-06-29 80195.00
3791 2025-06-30 80001.67
3792 2025-07-01 80235.00
3793 2025-07-02 80983.33
3794 2025-07-03 81021.67
2025-07-03 17:51:00,442 - IOOppi_data - INFO : save new data to db IOOppi_cu_t: date ... updated_at
3794 2025-07-03 ... 2025-07-03 17:51:00.436159
[1 rows x 5 columns]
2025-07-03 17:51:00,461 - IOOppi_data - INFO : save diff data to db: IOOppi_cu_t: no diff data
2025-07-03 17:51:00,467 - IOOppi_data - INFO : save data to db IOOppi_cu_g data:
date value
3790 2025-06-29 80195.00
3791 2025-06-30 80001.67
3792 2025-07-01 80235.00
3793 2025-07-02 80983.33
3794 2025-07-03 81021.67
2025-07-03 17:51:00,539 - IOOppi_data - INFO : save new data to db IOOppi_cu_g: date ... updated_at
3797 2025-07-03 ... 2025-07-03 17:51:00.533163
[1 rows x 5 columns]
2025-07-03 17:51:00,557 - 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-03 17:51:01,153 - 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-03 17:51:01,206 - IOOppi_data - INFO : save new data to db: IOOppi_PM_t: no new data
2025-07-03 17:51:01,206 - IOOppi_data - INFO : save diff data to db: IOOppi_PM_t: no diff data
2025-07-03 17:51:01,212 - 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-03 17:51:01,272 - IOOppi_data - INFO : save new data to db: IOOppi_PM_g: no new data
2025-07-03 17:51:01,272 - 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-03 17:51:01,990 - IOOppi_data - INFO : save data to db IOOppi_sn_t data:
date value
2768 2025-06-29 269425.0
2769 2025-06-30 267487.5
2770 2025-07-01 266637.5
2771 2025-07-02 268537.5
2772 2025-07-03 268700.0
2025-07-03 17:51:02,052 - IOOppi_data - INFO : save new data to db IOOppi_sn_t: date ... updated_at
2772 2025-07-03 ... 2025-07-03 17:51:02.045822
[1 rows x 5 columns]
2025-07-03 17:51:02,073 - IOOppi_data - INFO : save diff data to db: IOOppi_sn_t: no diff data
2025-07-03 17:51:02,080 - IOOppi_data - INFO : save data to db IOOppi_sn_g data:
date value
2768 2025-06-29 269425.0
2769 2025-06-30 267487.5
2770 2025-07-01 266637.5
2771 2025-07-02 268537.5
2772 2025-07-03 268700.0
2025-07-03 17:51:02,143 - IOOppi_data - INFO : save new data to db IOOppi_sn_g: date ... updated_at
2775 2025-07-03 ... 2025-07-03 17:51:02.135944
[1 rows x 5 columns]
2025-07-03 17:51:02,163 - 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-03 17:51:02,778 - IOOppi_data - INFO : save data to db IOOppi_zn_t data:
date value
3789 2025-06-29 22568.0
3790 2025-06-30 22486.0
3791 2025-07-01 22258.0
3792 2025-07-02 22270.0
3793 2025-07-03 22400.0
2025-07-03 17:51:02,851 - IOOppi_data - INFO : save new data to db IOOppi_zn_t: date value ... created_at updated_at
3793 2025-07-03 22400.0 ... 2025-07-03 17:51:02.843967 2025-07-03 17:51:02.844420
[1 rows x 5 columns]
2025-07-03 17:51:02,870 - IOOppi_data - INFO : save diff data to db: IOOppi_zn_t: no diff data
2025-07-03 17:51:02,877 - IOOppi_data - INFO : save data to db IOOppi_zn_g data:
date value
3789 2025-06-29 22568.0
3790 2025-06-30 22486.0
3791 2025-07-01 22258.0
3792 2025-07-02 22270.0
3793 2025-07-03 22400.0
2025-07-03 17:51:02,950 - IOOppi_data - INFO : save new data to db IOOppi_zn_g: date value ... created_at updated_at
3796 2025-07-03 22400.0 ... 2025-07-03 17:51:02.943167 2025-07-03 17:51:02.943546
[1 rows x 5 columns]
2025-07-03 17:51:02,969 - 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-03 17:51:03,567 - IOOppi_data - INFO : save data to db IOOppi_wr_t data:
date value
3752 2025-06-29 3252.5
3753 2025-06-30 3260.0
3754 2025-07-01 3252.5
3755 2025-07-02 3252.5
3756 2025-07-03 3292.5
2025-07-03 17:51:03,640 - IOOppi_data - INFO : save new data to db IOOppi_wr_t: date value ... created_at updated_at
3756 2025-07-03 3292.5 ... 2025-07-03 17:51:03.633580 2025-07-03 17:51:03.633996
[1 rows x 5 columns]
2025-07-03 17:51:03,659 - IOOppi_data - INFO : save diff data to db: IOOppi_wr_t: no diff data
2025-07-03 17:51:03,667 - IOOppi_data - INFO : save data to db IOOppi_wr_g data:
date value
3752 2025-06-29 3252.5
3753 2025-06-30 3260.0
3754 2025-07-01 3252.5
3755 2025-07-02 3252.5
3756 2025-07-03 3292.5
2025-07-03 17:51:03,738 - IOOppi_data - INFO : save new data to db IOOppi_wr_g: date value ... created_at updated_at
3759 2025-07-03 3292.5 ... 2025-07-03 17:51:03.731599 2025-07-03 17:51:03.732005
[1 rows x 5 columns]
2025-07-03 17:51:03,757 - 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-03 17:51:04,343 - IOOppi_data - INFO : save data to db IOOppi_pg_t data:
date value
1549 2025-06-29 4967.5
1550 2025-06-30 4922.5
1551 2025-07-01 4922.5
1552 2025-07-02 4947.5
1553 2025-07-03 4947.5
2025-07-03 17:51:04,389 - IOOppi_data - INFO : save new data to db IOOppi_pg_t: date value ... created_at updated_at
1553 2025-07-03 4947.5 ... 2025-07-03 17:51:04.381681 2025-07-03 17:51:04.382136
[1 rows x 5 columns]
2025-07-03 17:51:04,408 - IOOppi_data - INFO : save diff data to db: IOOppi_pg_t: no diff data
2025-07-03 17:51:04,414 - IOOppi_data - INFO : save data to db IOOppi_pg_g data:
date value
1549 2025-06-29 4967.5
1550 2025-06-30 4922.5
1551 2025-07-01 4922.5
1552 2025-07-02 4947.5
1553 2025-07-03 4947.5
2025-07-03 17:51:04,460 - IOOppi_data - INFO : save new data to db IOOppi_pg_g: date value ... created_at updated_at
1556 2025-07-03 4947.5 ... 2025-07-03 17:51:04.453068 2025-07-03 17:51:04.453474
[1 rows x 5 columns]
2025-07-03 17:51:04,480 - 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-03 17:51:05,162 - IOOppi_data - INFO : save data to db IOOppi_cs_t data:
date value
2823 2025-06-29 2352.86
2824 2025-06-30 2357.14
2825 2025-07-01 2365.71
2826 2025-07-02 2367.14
2827 2025-07-03 2367.14
2025-07-03 17:51:05,223 - IOOppi_data - INFO : save new data to db IOOppi_cs_t: date value ... created_at updated_at
2827 2025-07-03 2367.14 ... 2025-07-03 17:51:05.215770 2025-07-03 17:51:05.216213
[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-03 17:51:05,265 - IOOppi_data - INFO : save diff data to db IOOppi_cs_t: date ... updated_at
2826 2025-07-02 ... 2025-07-03 17:51:05.257807
[1 rows x 6 columns]
2025-07-03 17:51:05,291 - IOOppi_data - INFO : save data to db IOOppi_cs_g data:
date value
2823 2025-06-29 2352.86
2824 2025-06-30 2357.14
2825 2025-07-01 2365.71
2826 2025-07-02 2367.14
2827 2025-07-03 2367.14
2025-07-03 17:51:05,351 - IOOppi_data - INFO : save new data to db IOOppi_cs_g: date value ... created_at updated_at
2830 2025-07-03 2367.14 ... 2025-07-03 17:51:05.344782 2025-07-03 17:51:05.345173
[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-03 17:51:05,392 - IOOppi_data - INFO : save diff data to db IOOppi_cs_g: date ... updated_at
2829 2025-07-02 ... 2025-07-03 17:51:05.385201
[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-03 17:51:05,996 - IOOppi_data - INFO : save data to db IOOppi_cs_t data:
date value
2823 2025-06-29 2352.86
2824 2025-06-30 2357.14
2825 2025-07-01 2365.71
2826 2025-07-02 2367.14
2827 2025-07-03 2944.00
2025-07-03 17:51:06,048 - 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-03 17:51:06,071 - IOOppi_data - INFO : save diff data to db IOOppi_cs_t: date ... updated_at
2827 2025-07-03 ... 2025-07-03 17:51:06.064145
[1 rows x 6 columns]
2025-07-03 17:51:06,097 - IOOppi_data - INFO : save data to db IOOppi_cs_g data:
date value
2823 2025-06-29 2352.86
2824 2025-06-30 2357.14
2825 2025-07-01 2365.71
2826 2025-07-02 2367.14
2827 2025-07-03 2944.00
2025-07-03 17:51:06,153 - 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-03 17:51:06,177 - IOOppi_data - INFO : save diff data to db IOOppi_cs_g: date ... updated_at
2830 2025-07-03 ... 2025-07-03 17:51:06.169466
[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-03 17:51:06,801 - IOOppi_data - INFO : save data to db IOOppi_RS_t data:
date value
3180 2025-06-29 9631.67
3181 2025-06-30 9581.67
3182 2025-07-01 9625.00
3183 2025-07-02 9763.33
3184 2025-07-03 9775.00
2025-07-03 17:51:06,868 - IOOppi_data - INFO : save new data to db: IOOppi_RS_t: no new data
2025-07-03 17:51:06,868 - IOOppi_data - INFO : save diff data to db: IOOppi_RS_t: no diff data
2025-07-03 17:51:06,874 - IOOppi_data - INFO : save data to db IOOppi_RS_g data:
date value
3180 2025-06-29 9631.67
3181 2025-06-30 9581.67
3182 2025-07-01 9625.00
3183 2025-07-02 9763.33
3184 2025-07-03 9775.00
2025-07-03 17:51:06,939 - IOOppi_data - INFO : save new data to db: IOOppi_RS_g: no new data
2025-07-03 17:51:06,939 - 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-03 17:51:07,511 - IOOppi_data - INFO : save data to db IOOppi_eg_t data:
date value
1864 2025-06-29 4416.67
1865 2025-06-30 4413.33
1866 2025-07-01 4396.67
1867 2025-07-02 4400.00
1868 2025-07-03 4400.00
2025-07-03 17:51:07,560 - IOOppi_data - INFO : save new data to db IOOppi_eg_t: date value ... created_at updated_at
1868 2025-07-03 4400.0 ... 2025-07-03 17:51:07.553036 2025-07-03 17:51:07.553426
[1 rows x 5 columns]
2025-07-03 17:51:07,579 - IOOppi_data - INFO : save diff data to db: IOOppi_eg_t: no diff data
2025-07-03 17:51:07,585 - IOOppi_data - INFO : save data to db IOOppi_eg_g data:
date value
1864 2025-06-29 4416.67
1865 2025-06-30 4413.33
1866 2025-07-01 4396.67
1867 2025-07-02 4400.00
1868 2025-07-03 4400.00
2025-07-03 17:51:07,633 - IOOppi_data - INFO : save new data to db IOOppi_eg_g: date value ... created_at updated_at
1871 2025-07-03 4400.0 ... 2025-07-03 17:51:07.626623 2025-07-03 17:51:07.627031
[1 rows x 5 columns]
2025-07-03 17:51:07,652 - 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-03 17:51:08,231 - IOOppi_data - INFO : save data to db IOOppi_sp_t data:
date value
1873 2025-06-29 5983.33
1874 2025-06-30 5950.00
1875 2025-07-01 5950.00
1876 2025-07-02 5950.00
1877 2025-07-03 5950.00
2025-07-03 17:51:08,281 - IOOppi_data - INFO : save new data to db IOOppi_sp_t: date value ... created_at updated_at
1877 2025-07-03 5950.0 ... 2025-07-03 17:51:08.274032 2025-07-03 17:51:08.274422
[1 rows x 5 columns]
2025-07-03 17:51:08,300 - IOOppi_data - INFO : save diff data to db: IOOppi_sp_t: no diff data
2025-07-03 17:51:08,305 - IOOppi_data - INFO : save data to db IOOppi_sp_g data:
date value
1873 2025-06-29 5983.33
1874 2025-06-30 5950.00
1875 2025-07-01 5950.00
1876 2025-07-02 5950.00
1877 2025-07-03 5950.00
2025-07-03 17:51:08,355 - IOOppi_data - INFO : save new data to db IOOppi_sp_g: date value ... created_at updated_at
1880 2025-07-03 5950.0 ... 2025-07-03 17:51:08.347955 2025-07-03 17:51:08.348340
[1 rows x 5 columns]
2025-07-03 17:51:08,373 - 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-03 17:51:09,048 - IOOppi_data - INFO : save data to db IOOppi_p_t data:
date value
3541 2025-06-29 8586.0
3542 2025-06-30 8570.0
3543 2025-07-01 8600.0
3544 2025-07-02 8638.0
3545 2025-07-03 8744.0
2025-07-03 17:51:09,118 - IOOppi_data - INFO : save new data to db IOOppi_p_t: date value ... created_at updated_at
3545 2025-07-03 8744.0 ... 2025-07-03 17:51:09.110408 2025-07-03 17:51:09.110922
[1 rows x 5 columns]
2025-07-03 17:51:09,136 - IOOppi_data - INFO : save diff data to db: IOOppi_p_t: no diff data
2025-07-03 17:51:09,143 - IOOppi_data - INFO : save data to db IOOppi_p_g data:
date value
3541 2025-06-29 8586.0
3542 2025-06-30 8570.0
3543 2025-07-01 8600.0
3544 2025-07-02 8638.0
3545 2025-07-03 8744.0
2025-07-03 17:51:09,214 - IOOppi_data - INFO : save new data to db IOOppi_p_g: date value ... created_at updated_at
3548 2025-07-03 8744.0 ... 2025-07-03 17:51:09.207247 2025-07-03 17:51:09.207632
[1 rows x 5 columns]
2025-07-03 17:51:09,233 - IOOppi_data - INFO : save diff data to db: IOOppi_p_g: no diff data