=========================================================================
2025-07-11 17:50:26 Fri START TASK.01 IOOppi_data update_data
=========================================================================
/usr/local/lib/python3.10/site-packages/urllib3/connectionpool.py:1056: InsecureRequestWarning: Unverified HTTPS request is being made to host 'www.100ppi.com'. Adding certificate verification is strongly advised. See: https://urllib3.readthedocs.io/en/1.26.x/advanced-usage.html#ssl-warnings
warnings.warn(
2025-07-11 17:50:29,253 - IOOppi_data - INFO : save data to db IOOppi_rb_t data:
date value
3357 2025-07-07 3104.0
3358 2025-07-08 3106.5
3359 2025-07-09 3112.5
3360 2025-07-10 3138.5
3361 2025-07-11 3164.5
2025-07-11 17:50:29,323 - IOOppi_data - INFO : save new data to db IOOppi_rb_t: date value ... created_at updated_at
3360 2025-07-10 3138.5 ... 2025-07-11 17:50:29.315705 2025-07-11 17:50:29.316146
3361 2025-07-11 3164.5 ... 2025-07-11 17:50:29.315705 2025-07-11 17:50:29.316146
[2 rows x 5 columns]
2025-07-11 17:50:29,342 - IOOppi_data - INFO : save diff data to db: IOOppi_rb_t: no diff data
2025-07-11 17:50:29,348 - IOOppi_data - INFO : save data to db IOOppi_rb_g data:
date value
3357 2025-07-07 3104.0
3358 2025-07-08 3106.5
3359 2025-07-09 3112.5
3360 2025-07-10 3138.5
3361 2025-07-11 3164.5
2025-07-11 17:50:29,413 - IOOppi_data - INFO : save new data to db IOOppi_rb_g: date value ... created_at updated_at
3363 2025-07-10 3138.5 ... 2025-07-11 17:50:29.406074 2025-07-11 17:50:29.406451
3364 2025-07-11 3164.5 ... 2025-07-11 17:50:29.406074 2025-07-11 17:50:29.406451
[2 rows x 5 columns]
2025-07-11 17:50:29,431 - 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-11 17:50:29,991 - IOOppi_data - INFO : save data to db IOOppi_MA_t data:
date value
3578 2025-07-07 2423.33
3579 2025-07-08 2410.00
3580 2025-07-09 2390.33
3581 2025-07-10 2397.50
3582 2025-07-11 2378.33
2025-07-11 17:50:30,059 - IOOppi_data - INFO : save new data to db IOOppi_MA_t: date value ... created_at updated_at
3581 2025-07-10 2397.50 ... 2025-07-11 17:50:30.051678 2025-07-11 17:50:30.052092
3582 2025-07-11 2378.33 ... 2025-07-11 17:50:30.051678 2025-07-11 17:50:30.052092
[2 rows x 5 columns]
2025-07-11 17:50:30,076 - IOOppi_data - INFO : save diff data to db: IOOppi_MA_t: no diff data
2025-07-11 17:50:30,082 - IOOppi_data - INFO : save data to db IOOppi_MA_g data:
date value
3578 2025-07-07 2423.33
3579 2025-07-08 2410.00
3580 2025-07-09 2390.33
3581 2025-07-10 2397.50
3582 2025-07-11 2378.33
2025-07-11 17:50:30,150 - IOOppi_data - INFO : save new data to db IOOppi_MA_g: date value ... created_at updated_at
3585 2025-07-10 2397.50 ... 2025-07-11 17:50:30.142968 2025-07-11 17:50:30.143340
3586 2025-07-11 2378.33 ... 2025-07-11 17:50:30.142968 2025-07-11 17:50:30.143340
[2 rows x 5 columns]
2025-07-11 17:50:30,167 - 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-11 17:50:30,709 - IOOppi_data - INFO : save data to db IOOppi_PTA_t data:
date value
918 2025-07-07 4977.50
919 2025-07-08 4930.84
920 2025-07-09 4852.50
921 2025-07-10 4852.50
922 2025-07-11 4852.50
2025-07-11 17:50:30,745 - IOOppi_data - INFO : save new data to db IOOppi_PTA_t: date value ... created_at updated_at
921 2025-07-10 4852.5 ... 2025-07-11 17:50:30.738260 2025-07-11 17:50:30.738647
922 2025-07-11 4852.5 ... 2025-07-11 17:50:30.738260 2025-07-11 17:50:30.738647
[2 rows x 5 columns]
2025-07-11 17:50:30,764 - IOOppi_data - INFO : save diff data to db: IOOppi_PTA_t: no diff data
2025-07-11 17:50:30,769 - IOOppi_data - INFO : save data to db IOOppi_PTA_g data:
date value
918 2025-07-07 4977.50
919 2025-07-08 4930.84
920 2025-07-09 4852.50
921 2025-07-10 4852.50
922 2025-07-11 4852.50
2025-07-11 17:50:30,805 - IOOppi_data - INFO : save new data to db IOOppi_PTA_g: date value ... created_at updated_at
921 2025-07-10 4852.5 ... 2025-07-11 17:50:30.798069 2025-07-11 17:50:30.798509
922 2025-07-11 4852.5 ... 2025-07-11 17:50:30.798069 2025-07-11 17:50:30.798509
[2 rows x 5 columns]
2025-07-11 17:50:30,823 - 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-11 17:50:31,358 - IOOppi_data - INFO : save data to db IOOppi_ru_t data:
date value
3797 2025-07-07 13878.33
3798 2025-07-08 13858.33
3799 2025-07-09 13908.33
3800 2025-07-10 14466.67
3801 2025-07-11 14416.67
2025-07-11 17:50:31,429 - IOOppi_data - INFO : save new data to db IOOppi_ru_t: date ... updated_at
3800 2025-07-10 ... 2025-07-11 17:50:31.423365
3801 2025-07-11 ... 2025-07-11 17:50:31.423365
[2 rows x 5 columns]
2025-07-11 17:50:31,447 - IOOppi_data - INFO : save diff data to db: IOOppi_ru_t: no diff data
2025-07-11 17:50:31,453 - IOOppi_data - INFO : save data to db IOOppi_ru_g data:
date value
3797 2025-07-07 13878.33
3798 2025-07-08 13858.33
3799 2025-07-09 13908.33
3800 2025-07-10 14466.67
3801 2025-07-11 14416.67
2025-07-11 17:50:31,525 - IOOppi_data - INFO : save new data to db IOOppi_ru_g: date ... updated_at
3803 2025-07-10 ... 2025-07-11 17:50:31.518684
3804 2025-07-11 ... 2025-07-11 17:50:31.518684
[2 rows x 5 columns]
2025-07-11 17:50:31,542 - 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-11 17:50:32,058 - IOOppi_data - INFO : save data to db IOOppi_i_t data:
date value
3129 2025-07-07 737.33
3130 2025-07-08 734.67
3131 2025-07-09 739.00
3132 2025-07-10 748.44
3133 2025-07-11 762.56
2025-07-11 17:50:32,121 - IOOppi_data - INFO : save new data to db IOOppi_i_t: date value ... created_at updated_at
3132 2025-07-10 748.44 ... 2025-07-11 17:50:32.114089 2025-07-11 17:50:32.114470
3133 2025-07-11 762.56 ... 2025-07-11 17:50:32.114089 2025-07-11 17:50:32.114470
[2 rows x 5 columns]
2025-07-11 17:50:32,139 - IOOppi_data - INFO : save diff data to db: IOOppi_i_t: no diff data
2025-07-11 17:50:32,145 - IOOppi_data - INFO : save data to db IOOppi_i_g data:
date value
3129 2025-07-07 737.33
3130 2025-07-08 734.67
3131 2025-07-09 739.00
3132 2025-07-10 748.44
3133 2025-07-11 762.56
2025-07-11 17:50:32,209 - IOOppi_data - INFO : save new data to db IOOppi_i_g: date value ... created_at updated_at
3135 2025-07-10 748.44 ... 2025-07-11 17:50:32.201975 2025-07-11 17:50:32.202352
3136 2025-07-11 762.56 ... 2025-07-11 17:50:32.201975 2025-07-11 17:50:32.202352
[2 rows x 5 columns]
2025-07-11 17:50:32,227 - 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-11 17:50:32,768 - IOOppi_data - INFO : save data to db IOOppi_FG_t data:
date value
3332 2025-07-07 1122.4
3333 2025-07-08 1122.4
3334 2025-07-09 1122.4
3335 2025-07-10 1122.4
3336 2025-07-11 1122.4
2025-07-11 17:50:32,834 - IOOppi_data - INFO : save new data to db IOOppi_FG_t: date value ... created_at updated_at
3335 2025-07-10 1122.4 ... 2025-07-11 17:50:32.827019 2025-07-11 17:50:32.827417
3336 2025-07-11 1122.4 ... 2025-07-11 17:50:32.827019 2025-07-11 17:50:32.827417
[2 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-11 17:50:34,706 - IOOppi_data - INFO : save diff data to db IOOppi_FG_t: date ... updated_at
12 2012-12-19 ... 2025-07-11 17:50:34.698654
21 2013-01-04 ... 2025-07-11 17:50:34.698654
54 2013-02-27 ... 2025-07-11 17:50:34.698654
60 2013-03-07 ... 2025-07-11 17:50:34.698654
61 2013-03-08 ... 2025-07-11 17:50:34.698654
[5 rows x 6 columns]
2025-07-11 17:50:34,860 - IOOppi_data - INFO : save data to db IOOppi_FG_g data:
date value
3332 2025-07-07 1122.4
3333 2025-07-08 1122.4
3334 2025-07-09 1122.4
3335 2025-07-10 1122.4
3336 2025-07-11 1122.4
2025-07-11 17:50:34,929 - IOOppi_data - INFO : save new data to db IOOppi_FG_g: date value ... created_at updated_at
3339 2025-07-10 1122.4 ... 2025-07-11 17:50:34.922606 2025-07-11 17:50:34.923017
3340 2025-07-11 1122.4 ... 2025-07-11 17:50:34.922606 2025-07-11 17:50:34.923017
[2 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-11 17:50:36,796 - IOOppi_data - INFO : save diff data to db IOOppi_FG_g: date ... updated_at
12 2012-12-19 ... 2025-07-11 17:50:36.788683
21 2013-01-04 ... 2025-07-11 17:50:36.788683
54 2013-02-27 ... 2025-07-11 17:50:36.788683
60 2013-03-07 ... 2025-07-11 17:50:36.788683
61 2013-03-08 ... 2025-07-11 17:50:36.788683
[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-11 17:50:37,532 - IOOppi_data - INFO : save data to db IOOppi_eb_t data:
date value
1677 2025-07-07 7914.0
1678 2025-07-08 7914.0
1679 2025-07-09 7908.0
1680 2025-07-10 7908.0
1681 2025-07-11 7908.0
2025-07-11 17:50:37,580 - IOOppi_data - INFO : save new data to db IOOppi_eb_t: date value ... created_at updated_at
1680 2025-07-10 7908.0 ... 2025-07-11 17:50:37.573338 2025-07-11 17:50:37.573744
1681 2025-07-11 7908.0 ... 2025-07-11 17:50:37.573338 2025-07-11 17:50:37.573744
[2 rows x 5 columns]
2025-07-11 17:50:37,599 - IOOppi_data - INFO : save diff data to db: IOOppi_eb_t: no diff data
2025-07-11 17:50:37,604 - IOOppi_data - INFO : save data to db IOOppi_eb_g data:
date value
1677 2025-07-07 7914.0
1678 2025-07-08 7914.0
1679 2025-07-09 7908.0
1680 2025-07-10 7908.0
1681 2025-07-11 7908.0
2025-07-11 17:50:37,649 - IOOppi_data - INFO : save new data to db IOOppi_eb_g: date value ... created_at updated_at
1683 2025-07-10 7908.0 ... 2025-07-11 17:50:37.642414 2025-07-11 17:50:37.642824
1684 2025-07-11 7908.0 ... 2025-07-11 17:50:37.642414 2025-07-11 17:50:37.642824
[2 rows x 5 columns]
2025-07-11 17:50:37,667 - 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-11 17:50:38,185 - IOOppi_data - INFO : save data to db IOOppi_SR_t data:
date value
3788 2025-07-07 6043.33
3789 2025-07-08 6040.00
3790 2025-07-09 6050.00
3791 2025-07-10 6046.67
3792 2025-07-11 6046.67
2025-07-11 17:50:38,261 - IOOppi_data - INFO : save new data to db IOOppi_SR_t: date value ... created_at updated_at
3791 2025-07-10 6046.67 ... 2025-07-11 17:50:38.253780 2025-07-11 17:50:38.254226
3792 2025-07-11 6046.67 ... 2025-07-11 17:50:38.253780 2025-07-11 17:50:38.254226
[2 rows x 5 columns]
2025-07-11 17:50:38,280 - IOOppi_data - INFO : save diff data to db: IOOppi_SR_t: no diff data
2025-07-11 17:50:38,286 - IOOppi_data - INFO : save data to db IOOppi_SR_g data:
date value
3788 2025-07-07 6043.33
3789 2025-07-08 6040.00
3790 2025-07-09 6050.00
3791 2025-07-10 6046.67
3792 2025-07-11 6046.67
2025-07-11 17:50:38,360 - IOOppi_data - INFO : save new data to db IOOppi_SR_g: date value ... created_at updated_at
3795 2025-07-10 6046.67 ... 2025-07-11 17:50:38.352906 2025-07-11 17:50:38.353325
3796 2025-07-11 6046.67 ... 2025-07-11 17:50:38.352906 2025-07-11 17:50:38.353325
[2 rows x 5 columns]
2025-07-11 17:50:38,378 - 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-11 17:50:39,053 - IOOppi_data - INFO : save data to db IOOppi_ss_t data:
date value
1678 2025-07-07 12887.5
1679 2025-07-08 12887.5
1680 2025-07-09 12887.5
1681 2025-07-10 12887.5
1682 2025-07-11 12887.5
2025-07-11 17:50:39,099 - IOOppi_data - INFO : save new data to db IOOppi_ss_t: date value ... created_at updated_at
1681 2025-07-10 12887.5 ... 2025-07-11 17:50:39.092394 2025-07-11 17:50:39.092812
1682 2025-07-11 12887.5 ... 2025-07-11 17:50:39.092394 2025-07-11 17:50:39.092812
[2 rows x 5 columns]
2025-07-11 17:50:39,117 - IOOppi_data - INFO : save diff data to db: IOOppi_ss_t: no diff data
2025-07-11 17:50:39,123 - IOOppi_data - INFO : save data to db IOOppi_ss_g data:
date value
1678 2025-07-07 12887.5
1679 2025-07-08 12887.5
1680 2025-07-09 12887.5
1681 2025-07-10 12887.5
1682 2025-07-11 12887.5
2025-07-11 17:50:39,169 - IOOppi_data - INFO : save new data to db IOOppi_ss_g: date value ... created_at updated_at
1684 2025-07-10 12887.5 ... 2025-07-11 17:50:39.162087 2025-07-11 17:50:39.162465
1685 2025-07-11 12887.5 ... 2025-07-11 17:50:39.162087 2025-07-11 17:50:39.162465
[2 rows x 5 columns]
2025-07-11 17:50:39,187 - 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-11 17:50:39,706 - IOOppi_data - INFO : save data to db IOOppi_RS_t data:
date value
3188 2025-07-07 9703.33
3189 2025-07-08 9745.00
3190 2025-07-09 9675.00
3191 2025-07-10 9585.00
3192 2025-07-11 9568.33
2025-07-11 17:50:39,770 - IOOppi_data - INFO : save new data to db IOOppi_RS_t: date value ... created_at updated_at
3191 2025-07-10 9585.00 ... 2025-07-11 17:50:39.763317 2025-07-11 17:50:39.763714
3192 2025-07-11 9568.33 ... 2025-07-11 17:50:39.763317 2025-07-11 17:50:39.763714
[2 rows x 5 columns]
2025-07-11 17:50:39,788 - IOOppi_data - INFO : save diff data to db: IOOppi_RS_t: no diff data
2025-07-11 17:50:39,794 - IOOppi_data - INFO : save data to db IOOppi_RS_g data:
date value
3188 2025-07-07 9703.33
3189 2025-07-08 9745.00
3190 2025-07-09 9675.00
3191 2025-07-10 9585.00
3192 2025-07-11 9568.33
2025-07-11 17:50:39,859 - IOOppi_data - INFO : save new data to db IOOppi_RS_g: date value ... created_at updated_at
3195 2025-07-10 9585.00 ... 2025-07-11 17:50:39.852102 2025-07-11 17:50:39.852510
3196 2025-07-11 9568.33 ... 2025-07-11 17:50:39.852102 2025-07-11 17:50:39.852510
[2 rows x 5 columns]
2025-07-11 17:50:39,881 - 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-11 17:50:40,446 - IOOppi_data - INFO : save data to db IOOppi_RM_t data:
date value
3311 2025-07-07 2525.00
3312 2025-07-08 2505.00
3313 2025-07-09 2505.00
3314 2025-07-10 2523.33
3315 2025-07-11 2551.67
2025-07-11 17:50:40,515 - IOOppi_data - INFO : save new data to db IOOppi_RM_t: date value ... created_at updated_at
3314 2025-07-10 2523.33 ... 2025-07-11 17:50:40.507735 2025-07-11 17:50:40.508148
3315 2025-07-11 2551.67 ... 2025-07-11 17:50:40.507735 2025-07-11 17:50:40.508148
[2 rows x 5 columns]
2025-07-11 17:50:40,533 - IOOppi_data - INFO : save diff data to db: IOOppi_RM_t: no diff data
2025-07-11 17:50:40,538 - IOOppi_data - INFO : save data to db IOOppi_RM_g data:
date value
3311 2025-07-07 2525.00
3312 2025-07-08 2505.00
3313 2025-07-09 2505.00
3314 2025-07-10 2523.33
3315 2025-07-11 2551.67
2025-07-11 17:50:40,603 - IOOppi_data - INFO : save new data to db IOOppi_RM_g: date value ... created_at updated_at
3318 2025-07-10 2523.33 ... 2025-07-11 17:50:40.596551 2025-07-11 17:50:40.596961
3319 2025-07-11 2551.67 ... 2025-07-11 17:50:40.596551 2025-07-11 17:50:40.596961
[2 rows x 5 columns]
2025-07-11 17:50:40,621 - 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-11 17:50:41,216 - IOOppi_data - INFO : save data to db IOOppi_SA_t data:
date value
1515 2025-07-07 1252.5
1516 2025-07-08 1252.5
1517 2025-07-09 1247.5
1518 2025-07-10 1247.5
1519 2025-07-11 1247.5
2025-07-11 17:50:41,259 - IOOppi_data - INFO : save new data to db IOOppi_SA_t: date value ... created_at updated_at
1518 2025-07-10 1247.5 ... 2025-07-11 17:50:41.252460 2025-07-11 17:50:41.252873
1519 2025-07-11 1247.5 ... 2025-07-11 17:50:41.252460 2025-07-11 17:50:41.252873
[2 rows x 5 columns]
2025-07-11 17:50:41,279 - IOOppi_data - INFO : save diff data to db: IOOppi_SA_t: no diff data
2025-07-11 17:50:41,284 - IOOppi_data - INFO : save data to db IOOppi_SA_g data:
date value
1515 2025-07-07 1252.5
1516 2025-07-08 1252.5
1517 2025-07-09 1247.5
1518 2025-07-10 1247.5
1519 2025-07-11 1247.5
2025-07-11 17:50:41,327 - IOOppi_data - INFO : save new data to db IOOppi_SA_g: date value ... created_at updated_at
1522 2025-07-10 1247.5 ... 2025-07-11 17:50:41.320452 2025-07-11 17:50:41.320855
1523 2025-07-11 1247.5 ... 2025-07-11 17:50:41.320452 2025-07-11 17:50:41.320855
[2 rows x 5 columns]
2025-07-11 17:50:41,346 - 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-11 17:50:41,918 - IOOppi_data - INFO : save data to db IOOppi_PF_t data:
date value
1428 2025-07-07 6712.92
1429 2025-07-08 6704.58
1430 2025-07-09 6702.71
1431 2025-07-10 6700.50
1432 2025-07-11 6668.46
2025-07-11 17:50:41,960 - IOOppi_data - INFO : save new data to db IOOppi_PF_t: date value ... created_at updated_at
1431 2025-07-10 6700.50 ... 2025-07-11 17:50:41.953148 2025-07-11 17:50:41.953532
1432 2025-07-11 6668.46 ... 2025-07-11 17:50:41.953148 2025-07-11 17:50:41.953532
[2 rows x 5 columns]
2025-07-11 17:50:41,978 - IOOppi_data - INFO : save diff data to db: IOOppi_PF_t: no diff data
2025-07-11 17:50:41,983 - IOOppi_data - INFO : save data to db IOOppi_PF_g data:
date value
1428 2025-07-07 6712.92
1429 2025-07-08 6704.58
1430 2025-07-09 6702.71
1431 2025-07-10 6700.50
1432 2025-07-11 6668.46
2025-07-11 17:50:42,026 - IOOppi_data - INFO : save new data to db IOOppi_PF_g: date value ... created_at updated_at
1435 2025-07-10 6700.50 ... 2025-07-11 17:50:42.018798 2025-07-11 17:50:42.019182
1436 2025-07-11 6668.46 ... 2025-07-11 17:50:42.018798 2025-07-11 17:50:42.019182
[2 rows x 5 columns]
2025-07-11 17:50:42,044 - 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-11 17:50:42,636 - IOOppi_data - INFO : save data to db IOOppi_m_t data:
date value
3801 2025-07-07 2898.0
3802 2025-07-08 2880.0
3803 2025-07-09 2882.0
3804 2025-07-10 2888.0
3805 2025-07-11 2924.0
2025-07-11 17:50:42,710 - IOOppi_data - INFO : save new data to db IOOppi_m_t: date value ... created_at updated_at
3804 2025-07-10 2888.0 ... 2025-07-11 17:50:42.703150 2025-07-11 17:50:42.703541
3805 2025-07-11 2924.0 ... 2025-07-11 17:50:42.703150 2025-07-11 17:50:42.703541
[2 rows x 5 columns]
2025-07-11 17:50:42,729 - IOOppi_data - INFO : save diff data to db: IOOppi_m_t: no diff data
2025-07-11 17:50:42,735 - IOOppi_data - INFO : save data to db IOOppi_m_g data:
date value
3801 2025-07-07 2898.0
3802 2025-07-08 2880.0
3803 2025-07-09 2882.0
3804 2025-07-10 2888.0
3805 2025-07-11 2924.0
2025-07-11 17:50:42,808 - IOOppi_data - INFO : save new data to db IOOppi_m_g: date value ... created_at updated_at
3807 2025-07-10 2888.0 ... 2025-07-11 17:50:42.800439 2025-07-11 17:50:42.800890
3808 2025-07-11 2924.0 ... 2025-07-11 17:50:42.800439 2025-07-11 17:50:42.800890
[2 rows x 5 columns]
2025-07-11 17:50:42,826 - 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-11 17:50:43,390 - IOOppi_data - INFO : save data to db IOOppi_y_t data:
date value
3571 2025-07-07 8154.0
3572 2025-07-08 8194.0
3573 2025-07-09 8182.0
3574 2025-07-10 8214.0
3575 2025-07-11 8254.0
2025-07-11 17:50:43,461 - IOOppi_data - INFO : save new data to db IOOppi_y_t: date value ... created_at updated_at
3574 2025-07-10 8214.0 ... 2025-07-11 17:50:43.452910 2025-07-11 17:50:43.453323
3575 2025-07-11 8254.0 ... 2025-07-11 17:50:43.452910 2025-07-11 17:50:43.453323
[2 rows x 5 columns]
2025-07-11 17:50:43,480 - IOOppi_data - INFO : save diff data to db: IOOppi_y_t: no diff data
2025-07-11 17:50:43,485 - IOOppi_data - INFO : save data to db IOOppi_y_g data:
date value
3571 2025-07-07 8154.0
3572 2025-07-08 8194.0
3573 2025-07-09 8182.0
3574 2025-07-10 8214.0
3575 2025-07-11 8254.0
2025-07-11 17:50:43,554 - IOOppi_data - INFO : save new data to db IOOppi_y_g: date value ... created_at updated_at
3577 2025-07-10 8214.0 ... 2025-07-11 17:50:43.547239 2025-07-11 17:50:43.547636
3578 2025-07-11 8254.0 ... 2025-07-11 17:50:43.547239 2025-07-11 17:50:43.547636
[2 rows x 5 columns]
2025-07-11 17:50:43,572 - 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-11 17:50:44,104 - IOOppi_data - INFO : save data to db IOOppi_a_t data:
date value
3537 2025-07-07 4295.0
3538 2025-07-08 4295.0
3539 2025-07-09 4295.0
3540 2025-07-10 4295.0
3541 2025-07-11 4295.0
2025-07-11 17:50:44,173 - IOOppi_data - INFO : save new data to db IOOppi_a_t: date value ... created_at updated_at
3540 2025-07-10 4295.0 ... 2025-07-11 17:50:44.165630 2025-07-11 17:50:44.166042
3541 2025-07-11 4295.0 ... 2025-07-11 17:50:44.165630 2025-07-11 17:50:44.166042
[2 rows x 5 columns]
2025-07-11 17:50:44,191 - IOOppi_data - INFO : save diff data to db: IOOppi_a_t: no diff data
2025-07-11 17:50:44,197 - IOOppi_data - INFO : save data to db IOOppi_a_g data:
date value
3537 2025-07-07 4295.0
3538 2025-07-08 4295.0
3539 2025-07-09 4295.0
3540 2025-07-10 4295.0
3541 2025-07-11 4295.0
2025-07-11 17:50:44,266 - IOOppi_data - INFO : save new data to db IOOppi_a_g: date value ... created_at updated_at
3543 2025-07-10 4295.0 ... 2025-07-11 17:50:44.258655 2025-07-11 17:50:44.259071
3544 2025-07-11 4295.0 ... 2025-07-11 17:50:44.258655 2025-07-11 17:50:44.259071
[2 rows x 5 columns]
2025-07-11 17:50:44,285 - 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-11 17:50:44,954 - IOOppi_data - INFO : save data to db IOOppi_SF_t data:
date value
2914 2025-07-07 5138.57
2915 2025-07-08 5138.57
2916 2025-07-09 5138.57
2917 2025-07-10 5178.57
2918 2025-07-11 5217.14
2025-07-11 17:50:45,017 - IOOppi_data - INFO : save new data to db IOOppi_SF_t: date value ... created_at updated_at
2917 2025-07-10 5178.57 ... 2025-07-11 17:50:45.009720 2025-07-11 17:50:45.010135
2918 2025-07-11 5217.14 ... 2025-07-11 17:50:45.009720 2025-07-11 17:50:45.010135
[2 rows x 5 columns]
2025-07-11 17:50:45,035 - IOOppi_data - INFO : save diff data to db: IOOppi_SF_t: no diff data
2025-07-11 17:50:45,041 - IOOppi_data - INFO : save data to db IOOppi_SF_g data:
date value
2914 2025-07-07 5138.57
2915 2025-07-08 5138.57
2916 2025-07-09 5138.57
2917 2025-07-10 5178.57
2918 2025-07-11 5217.14
2025-07-11 17:50:45,103 - IOOppi_data - INFO : save new data to db IOOppi_SF_g: date value ... created_at updated_at
2921 2025-07-10 5178.57 ... 2025-07-11 17:50:45.096070 2025-07-11 17:50:45.096450
2922 2025-07-11 5217.14 ... 2025-07-11 17:50:45.096070 2025-07-11 17:50:45.096450
[2 rows x 5 columns]
2025-07-11 17:50:45,121 - 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-11 17:50:45,828 - IOOppi_data - INFO : save data to db IOOppi_jd_t data:
date value
3114 2025-07-07 2775.0
3115 2025-07-08 2750.0
3116 2025-07-09 2750.0
3117 2025-07-10 2750.0
3118 2025-07-11 2775.0
2025-07-11 17:50:45,891 - IOOppi_data - INFO : save new data to db IOOppi_jd_t: date value ... created_at updated_at
3117 2025-07-10 2750.0 ... 2025-07-11 17:50:45.884573 2025-07-11 17:50:45.885004
3118 2025-07-11 2775.0 ... 2025-07-11 17:50:45.884573 2025-07-11 17:50:45.885004
[2 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-11 17:50:46,039 - IOOppi_data - INFO : save diff data to db IOOppi_jd_t: date ... updated_at
39 2014-01-03 ... 2025-07-11 17:50:46.031685
458 2015-09-21 ... 2025-07-11 17:50:46.031685
549 2016-02-03 ... 2025-07-11 17:50:46.031685
693 2016-09-05 ... 2025-07-11 17:50:46.031685
696 2016-09-08 ... 2025-07-11 17:50:46.031685
[5 rows x 6 columns]
2025-07-11 17:50:46,068 - IOOppi_data - INFO : save data to db IOOppi_jd_g data:
date value
3114 2025-07-07 2775.0
3115 2025-07-08 2750.0
3116 2025-07-09 2750.0
3117 2025-07-10 2750.0
3118 2025-07-11 2775.0
2025-07-11 17:50:46,132 - IOOppi_data - INFO : save new data to db IOOppi_jd_g: date value ... created_at updated_at
3120 2025-07-10 2750.0 ... 2025-07-11 17:50:46.124951 2025-07-11 17:50:46.125328
3121 2025-07-11 2775.0 ... 2025-07-11 17:50:46.124951 2025-07-11 17:50:46.125328
[2 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-11 17:50:46,271 - IOOppi_data - INFO : save diff data to db IOOppi_jd_g: date ... updated_at
39 2014-01-03 ... 2025-07-11 17:50:46.263198
458 2015-09-21 ... 2025-07-11 17:50:46.263198
549 2016-02-03 ... 2025-07-11 17:50:46.263198
693 2016-09-05 ... 2025-07-11 17:50:46.263198
696 2016-09-08 ... 2025-07-11 17:50:46.263198
[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-11 17:50:46,856 - IOOppi_data - INFO : save data to db IOOppi_SI_t data:
date value
918 2025-07-07 8910.0
919 2025-07-08 8910.0
920 2025-07-09 8910.0
921 2025-07-10 8920.0
922 2025-07-11 8940.0
2025-07-11 17:50:46,893 - IOOppi_data - INFO : save new data to db IOOppi_SI_t: date value ... created_at updated_at
921 2025-07-10 8920.0 ... 2025-07-11 17:50:46.885790 2025-07-11 17:50:46.886214
922 2025-07-11 8940.0 ... 2025-07-11 17:50:46.885790 2025-07-11 17:50:46.886214
[2 rows x 5 columns]
2025-07-11 17:50:46,911 - IOOppi_data - INFO : save diff data to db: IOOppi_SI_t: no diff data
2025-07-11 17:50:46,916 - IOOppi_data - INFO : save data to db IOOppi_SI_g data:
date value
918 2025-07-07 8910.0
919 2025-07-08 8910.0
920 2025-07-09 8910.0
921 2025-07-10 8920.0
922 2025-07-11 8940.0
2025-07-11 17:50:46,951 - IOOppi_data - INFO : save new data to db IOOppi_SI_g: date value ... created_at updated_at
921 2025-07-10 8920.0 ... 2025-07-11 17:50:46.944344 2025-07-11 17:50:46.944730
922 2025-07-11 8940.0 ... 2025-07-11 17:50:46.944344 2025-07-11 17:50:46.944730
[2 rows x 5 columns]
2025-07-11 17:50:46,969 - 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-11 17:50:47,537 - IOOppi_data - INFO : save data to db IOOppi_l_t data:
date value
3797 2025-07-07 7433.33
3798 2025-07-08 7416.67
3799 2025-07-09 7411.67
3800 2025-07-10 7415.00
3801 2025-07-11 7416.67
2025-07-11 17:50:47,611 - IOOppi_data - INFO : save new data to db IOOppi_l_t: date value ... created_at updated_at
3800 2025-07-10 7415.00 ... 2025-07-11 17:50:47.603872 2025-07-11 17:50:47.604269
3801 2025-07-11 7416.67 ... 2025-07-11 17:50:47.603872 2025-07-11 17:50:47.604269
[2 rows x 5 columns]
2025-07-11 17:50:47,630 - IOOppi_data - INFO : save diff data to db: IOOppi_l_t: no diff data
2025-07-11 17:50:47,636 - IOOppi_data - INFO : save data to db IOOppi_l_g data:
date value
3797 2025-07-07 7433.33
3798 2025-07-08 7416.67
3799 2025-07-09 7411.67
3800 2025-07-10 7415.00
3801 2025-07-11 7416.67
2025-07-11 17:50:47,709 - IOOppi_data - INFO : save new data to db IOOppi_l_g: date value ... created_at updated_at
3803 2025-07-10 7415.00 ... 2025-07-11 17:50:47.701626 2025-07-11 17:50:47.702041
3804 2025-07-11 7416.67 ... 2025-07-11 17:50:47.701626 2025-07-11 17:50:47.702041
[2 rows x 5 columns]
2025-07-11 17:50:47,726 - 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-11 17:50:48,244 - IOOppi_data - INFO : save data to db IOOppi_bu_t data:
date value
3135 2025-07-07 3690.00
3136 2025-07-08 3690.00
3137 2025-07-09 3696.67
3138 2025-07-10 3690.00
3139 2025-07-11 3700.00
2025-07-11 17:50:48,308 - IOOppi_data - INFO : save new data to db IOOppi_bu_t: date value ... created_at updated_at
3139 2025-07-10 3690.0 ... 2025-07-11 17:50:48.301423 2025-07-11 17:50:48.301831
3140 2025-07-11 3700.0 ... 2025-07-11 17:50:48.301423 2025-07-11 17:50:48.301831
[2 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-11 17:50:48,345 - IOOppi_data - INFO : save diff data to db IOOppi_bu_t: date ... updated_at
2560 2023-12-09 ... 2025-07-11 17:50:48.338132
[1 rows x 6 columns]
2025-07-11 17:50:48,368 - IOOppi_data - INFO : save data to db IOOppi_bu_g data:
date value
3135 2025-07-07 3690.00
3136 2025-07-08 3690.00
3137 2025-07-09 3696.67
3138 2025-07-10 3690.00
3139 2025-07-11 3700.00
2025-07-11 17:50:48,433 - IOOppi_data - INFO : save new data to db IOOppi_bu_g: date value ... created_at updated_at
3141 2025-07-10 3690.0 ... 2025-07-11 17:50:48.425844 2025-07-11 17:50:48.426231
3142 2025-07-11 3700.0 ... 2025-07-11 17:50:48.425844 2025-07-11 17:50:48.426231
[2 rows x 5 columns]
2025-07-11 17:50:48,450 - 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-11 17:50:48,995 - IOOppi_data - INFO : save data to db IOOppi_al_t data:
date value
3800 2025-07-07 20780.00
3801 2025-07-08 20653.33
3802 2025-07-09 20680.00
3803 2025-07-10 20680.00
3804 2025-07-11 20806.67
2025-07-11 17:50:49,067 - IOOppi_data - INFO : save new data to db IOOppi_al_t: date ... updated_at
3803 2025-07-10 ... 2025-07-11 17:50:49.060934
3804 2025-07-11 ... 2025-07-11 17:50:49.060934
[2 rows x 5 columns]
2025-07-11 17:50:49,085 - IOOppi_data - INFO : save diff data to db: IOOppi_al_t: no diff data
2025-07-11 17:50:49,091 - IOOppi_data - INFO : save data to db IOOppi_al_g data:
date value
3800 2025-07-07 20780.00
3801 2025-07-08 20653.33
3802 2025-07-09 20680.00
3803 2025-07-10 20680.00
3804 2025-07-11 20806.67
2025-07-11 17:50:49,162 - IOOppi_data - INFO : save new data to db IOOppi_al_g: date ... updated_at
3806 2025-07-10 ... 2025-07-11 17:50:49.156479
3807 2025-07-11 ... 2025-07-11 17:50:49.156479
[2 rows x 5 columns]
2025-07-11 17:50:49,180 - 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-11 17:50:49,724 - IOOppi_data - INFO : save data to db IOOppi_SM_t data:
date value
2914 2025-07-07 5556.0
2915 2025-07-08 5536.0
2916 2025-07-09 5546.0
2917 2025-07-10 5622.0
2918 2025-07-11 5630.0
2025-07-11 17:50:49,789 - IOOppi_data - INFO : save new data to db IOOppi_SM_t: date value ... created_at updated_at
2917 2025-07-10 5622.0 ... 2025-07-11 17:50:49.781883 2025-07-11 17:50:49.782316
2918 2025-07-11 5630.0 ... 2025-07-11 17:50:49.781883 2025-07-11 17:50:49.782316
[2 rows x 5 columns]
2025-07-11 17:50:49,808 - IOOppi_data - INFO : save diff data to db: IOOppi_SM_t: no diff data
2025-07-11 17:50:49,814 - IOOppi_data - INFO : save data to db IOOppi_SM_g data:
date value
2914 2025-07-07 5556.0
2915 2025-07-08 5536.0
2916 2025-07-09 5546.0
2917 2025-07-10 5622.0
2918 2025-07-11 5630.0
2025-07-11 17:50:49,874 - IOOppi_data - INFO : save new data to db IOOppi_SM_g: date value ... created_at updated_at
2921 2025-07-10 5622.0 ... 2025-07-11 17:50:49.867951 2025-07-11 17:50:49.868315
2922 2025-07-11 5630.0 ... 2025-07-11 17:50:49.867951 2025-07-11 17:50:49.868315
[2 rows x 5 columns]
2025-07-11 17:50:49,892 - 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-11 17:50:50,502 - IOOppi_data - INFO : save data to db IOOppi_CY_t data:
date value
2189 2025-07-07 23200.0
2190 2025-07-08 23200.0
2191 2025-07-09 23200.0
2192 2025-07-10 23200.0
2193 2025-07-11 23200.0
2025-07-11 17:50:50,554 - IOOppi_data - INFO : save new data to db IOOppi_CY_t: date value ... created_at updated_at
2192 2025-07-10 23200.0 ... 2025-07-11 17:50:50.546822 2025-07-11 17:50:50.547216
2193 2025-07-11 23200.0 ... 2025-07-11 17:50:50.546822 2025-07-11 17:50:50.547216
[2 rows x 5 columns]
2025-07-11 17:50:50,571 - IOOppi_data - INFO : save diff data to db: IOOppi_CY_t: no diff data
2025-07-11 17:50:50,577 - IOOppi_data - INFO : save data to db IOOppi_CY_g data:
date value
2189 2025-07-07 23200.0
2190 2025-07-08 23200.0
2191 2025-07-09 23200.0
2192 2025-07-10 23200.0
2193 2025-07-11 23200.0
2025-07-11 17:50:50,629 - IOOppi_data - INFO : save new data to db IOOppi_CY_g: date value ... created_at updated_at
2196 2025-07-10 23200.0 ... 2025-07-11 17:50:50.622230 2025-07-11 17:50:50.622610
2197 2025-07-11 23200.0 ... 2025-07-11 17:50:50.622230 2025-07-11 17:50:50.622610
[2 rows x 5 columns]
2025-07-11 17:50:50,647 - 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-11 17:50:51,246 - IOOppi_data - INFO : save data to db IOOppi_UR_t data:
date value
1704 2025-07-07 1827.0
1705 2025-07-08 1831.0
1706 2025-07-09 1843.0
1707 2025-07-10 1845.0
1708 2025-07-11 1845.0
2025-07-11 17:50:51,294 - IOOppi_data - INFO : save new data to db IOOppi_UR_t: date value ... created_at updated_at
1707 2025-07-10 1845.0 ... 2025-07-11 17:50:51.286528 2025-07-11 17:50:51.286945
1708 2025-07-11 1845.0 ... 2025-07-11 17:50:51.286528 2025-07-11 17:50:51.286945
[2 rows x 5 columns]
2025-07-11 17:50:51,312 - IOOppi_data - INFO : save diff data to db: IOOppi_UR_t: no diff data
2025-07-11 17:50:51,317 - IOOppi_data - INFO : save data to db IOOppi_UR_g data:
date value
1704 2025-07-07 1827.0
1705 2025-07-08 1831.0
1706 2025-07-09 1843.0
1707 2025-07-10 1845.0
1708 2025-07-11 1845.0
2025-07-11 17:50:51,364 - IOOppi_data - INFO : save new data to db IOOppi_UR_g: date value ... created_at updated_at
1711 2025-07-10 1845.0 ... 2025-07-11 17:50:51.357314 2025-07-11 17:50:51.357694
1712 2025-07-11 1845.0 ... 2025-07-11 17:50:51.357314 2025-07-11 17:50:51.357694
[2 rows x 5 columns]
2025-07-11 17:50:51,382 - 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-11 17:50:52,135 - IOOppi_data - INFO : save data to db IOOppi_ni_t data:
date value
2776 2025-07-07 122383.33
2777 2025-07-08 121450.00
2778 2025-07-09 120516.67
2779 2025-07-10 120916.67
2780 2025-07-11 122500.00
2025-07-11 17:50:52,197 - IOOppi_data - INFO : save new data to db IOOppi_ni_t: date ... updated_at
2779 2025-07-10 ... 2025-07-11 17:50:52.191110
2780 2025-07-11 ... 2025-07-11 17:50:52.191110
[2 rows x 5 columns]
2025-07-11 17:50:52,216 - IOOppi_data - INFO : save diff data to db: IOOppi_ni_t: no diff data
2025-07-11 17:50:52,221 - IOOppi_data - INFO : save data to db IOOppi_ni_g data:
date value
2776 2025-07-07 122383.33
2777 2025-07-08 121450.00
2778 2025-07-09 120516.67
2779 2025-07-10 120916.67
2780 2025-07-11 122500.00
2025-07-11 17:50:52,284 - IOOppi_data - INFO : save new data to db IOOppi_ni_g: date ... updated_at
2782 2025-07-10 ... 2025-07-11 17:50:52.277372
2783 2025-07-11 ... 2025-07-11 17:50:52.277372
[2 rows x 5 columns]
2025-07-11 17:50:52,301 - 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-11 17:50:52,843 - IOOppi_data - INFO : save data to db IOOppi_v_t data:
date value
3801 2025-07-07 4651.0
3802 2025-07-08 4648.0
3803 2025-07-09 4688.0
3804 2025-07-10 4768.0
3805 2025-07-11 4733.0
2025-07-11 17:50:52,916 - IOOppi_data - INFO : save new data to db IOOppi_v_t: date value ... created_at updated_at
3804 2025-07-10 4768.0 ... 2025-07-11 17:50:52.908985 2025-07-11 17:50:52.909384
3805 2025-07-11 4733.0 ... 2025-07-11 17:50:52.908985 2025-07-11 17:50:52.909384
[2 rows x 5 columns]
2025-07-11 17:50:52,934 - IOOppi_data - INFO : save diff data to db: IOOppi_v_t: no diff data
2025-07-11 17:50:52,940 - IOOppi_data - INFO : save data to db IOOppi_v_g data:
date value
3801 2025-07-07 4651.0
3802 2025-07-08 4648.0
3803 2025-07-09 4688.0
3804 2025-07-10 4768.0
3805 2025-07-11 4733.0
2025-07-11 17:50:53,013 - IOOppi_data - INFO : save new data to db IOOppi_v_g: date value ... created_at updated_at
3807 2025-07-10 4768.0 ... 2025-07-11 17:50:53.005648 2025-07-11 17:50:53.006058
3808 2025-07-11 4733.0 ... 2025-07-11 17:50:53.005648 2025-07-11 17:50:53.006058
[2 rows x 5 columns]
2025-07-11 17:50:53,031 - 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-11 17:50:53,601 - IOOppi_data - INFO : save data to db IOOppi_pp_t data:
date value
3040 2025-07-07 7390.00
3041 2025-07-08 7376.67
3042 2025-07-09 7376.67
3043 2025-07-10 7360.00
3044 2025-07-11 7355.00
2025-07-11 17:50:53,664 - IOOppi_data - INFO : save new data to db IOOppi_pp_t: date value ... created_at updated_at
3043 2025-07-10 7360.0 ... 2025-07-11 17:50:53.656960 2025-07-11 17:50:53.657388
3044 2025-07-11 7355.0 ... 2025-07-11 17:50:53.656960 2025-07-11 17:50:53.657388
[2 rows x 5 columns]
2025-07-11 17:50:53,682 - IOOppi_data - INFO : save diff data to db: IOOppi_pp_t: no diff data
2025-07-11 17:50:53,688 - IOOppi_data - INFO : save data to db IOOppi_pp_g data:
date value
3040 2025-07-07 7390.00
3041 2025-07-08 7376.67
3042 2025-07-09 7376.67
3043 2025-07-10 7360.00
3044 2025-07-11 7355.00
2025-07-11 17:50:53,752 - IOOppi_data - INFO : save new data to db IOOppi_pp_g: date value ... created_at updated_at
3046 2025-07-10 7360.0 ... 2025-07-11 17:50:53.744682 2025-07-11 17:50:53.745133
3047 2025-07-11 7355.0 ... 2025-07-11 17:50:53.744682 2025-07-11 17:50:53.745133
[2 rows x 5 columns]
2025-07-11 17:50:53,770 - 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-11 17:50:54,417 - IOOppi_data - INFO : save data to db IOOppi_CF_t data:
date value
3802 2025-07-07 15202.17
3803 2025-07-08 15202.17
3804 2025-07-09 15188.83
3805 2025-07-10 15201.00
3806 2025-07-11 15282.00
2025-07-11 17:50:54,489 - IOOppi_data - INFO : save new data to db IOOppi_CF_t: date value ... created_at updated_at
3805 2025-07-10 15201.0 ... 2025-07-11 17:50:54.481886 2025-07-11 17:50:54.482279
3806 2025-07-11 15282.0 ... 2025-07-11 17:50:54.481886 2025-07-11 17:50:54.482279
[2 rows x 5 columns]
2025-07-11 17:50:54,507 - IOOppi_data - INFO : save diff data to db: IOOppi_CF_t: no diff data
2025-07-11 17:50:54,512 - IOOppi_data - INFO : save data to db IOOppi_CF_g data:
date value
3802 2025-07-07 15202.17
3803 2025-07-08 15202.17
3804 2025-07-09 15188.83
3805 2025-07-10 15201.00
3806 2025-07-11 15282.00
2025-07-11 17:50:54,586 - IOOppi_data - INFO : save new data to db IOOppi_CF_g: date value ... created_at updated_at
3809 2025-07-10 15201.0 ... 2025-07-11 17:50:54.578577 2025-07-11 17:50:54.578983
3810 2025-07-11 15282.0 ... 2025-07-11 17:50:54.578577 2025-07-11 17:50:54.578983
[2 rows x 5 columns]
2025-07-11 17:50:54,603 - 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-11 17:50:55,222 - IOOppi_data - INFO : save data to db IOOppi_pb_t data:
date value
3747 2025-07-07 17050.00
3748 2025-07-08 16968.75
3749 2025-07-09 17087.50
3750 2025-07-10 17093.75
3751 2025-07-11 16993.75
2025-07-11 17:50:55,293 - IOOppi_data - INFO : save new data to db IOOppi_pb_t: date ... updated_at
3750 2025-07-10 ... 2025-07-11 17:50:55.286962
3751 2025-07-11 ... 2025-07-11 17:50:55.286962
[2 rows x 5 columns]
2025-07-11 17:50:55,312 - IOOppi_data - INFO : save diff data to db: IOOppi_pb_t: no diff data
2025-07-11 17:50:55,320 - IOOppi_data - INFO : save data to db IOOppi_pb_g data:
date value
3747 2025-07-07 17050.00
3748 2025-07-08 16968.75
3749 2025-07-09 17087.50
3750 2025-07-10 17093.75
3751 2025-07-11 16993.75
2025-07-11 17:50:55,467 - IOOppi_data - INFO : save new data to db IOOppi_pb_g: date ... updated_at
3753 2025-07-10 ... 2025-07-11 17:50:55.460994
3754 2025-07-11 ... 2025-07-11 17:50:55.460994
[2 rows x 5 columns]
2025-07-11 17:50:55,485 - 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-11 17:50:56,017 - IOOppi_data - INFO : save data to db IOOppi_hc_t data:
date value
3022 2025-07-07 3276.67
3023 2025-07-08 3276.67
3024 2025-07-09 3276.67
3025 2025-07-10 3290.00
3026 2025-07-11 3326.67
2025-07-11 17:50:56,079 - IOOppi_data - INFO : save new data to db IOOppi_hc_t: date value ... created_at updated_at
3025 2025-07-10 3290.00 ... 2025-07-11 17:50:56.072254 2025-07-11 17:50:56.072633
3026 2025-07-11 3326.67 ... 2025-07-11 17:50:56.072254 2025-07-11 17:50:56.072633
[2 rows x 5 columns]
2025-07-11 17:50:56,097 - IOOppi_data - INFO : save diff data to db: IOOppi_hc_t: no diff data
2025-07-11 17:50:56,102 - IOOppi_data - INFO : save data to db IOOppi_hc_g data:
date value
3022 2025-07-07 3276.67
3023 2025-07-08 3276.67
3024 2025-07-09 3276.67
3025 2025-07-10 3290.00
3026 2025-07-11 3326.67
2025-07-11 17:50:56,164 - IOOppi_data - INFO : save new data to db IOOppi_hc_g: date value ... created_at updated_at
3028 2025-07-10 3290.00 ... 2025-07-11 17:50:56.157782 2025-07-11 17:50:56.158189
3029 2025-07-11 3326.67 ... 2025-07-11 17:50:56.157782 2025-07-11 17:50:56.158189
[2 rows x 5 columns]
2025-07-11 17:50:56,182 - 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-11 17:50:56,736 - IOOppi_data - INFO : save data to db IOOppi_fu_t data:
date value
3302 2025-07-07 5425.0
3303 2025-07-08 5425.0
3304 2025-07-09 5412.5
3305 2025-07-10 5400.0
3306 2025-07-11 5362.5
2025-07-11 17:50:56,803 - IOOppi_data - INFO : save new data to db IOOppi_fu_t: date value ... created_at updated_at
3305 2025-07-10 5400.0 ... 2025-07-11 17:50:56.796331 2025-07-11 17:50:56.796720
3306 2025-07-11 5362.5 ... 2025-07-11 17:50:56.796331 2025-07-11 17:50:56.796720
[2 rows x 5 columns]
2025-07-11 17:50:56,821 - IOOppi_data - INFO : save diff data to db: IOOppi_fu_t: no diff data
2025-07-11 17:50:56,827 - IOOppi_data - INFO : save data to db IOOppi_fu_g data:
date value
3302 2025-07-07 5425.0
3303 2025-07-08 5425.0
3304 2025-07-09 5412.5
3305 2025-07-10 5400.0
3306 2025-07-11 5362.5
2025-07-11 17:50:56,904 - IOOppi_data - INFO : save new data to db IOOppi_fu_g: date value ... created_at updated_at
3792 2025-07-10 5400.0 ... 2025-07-11 17:50:56.897403 2025-07-11 17:50:56.897808
3793 2025-07-11 5362.5 ... 2025-07-11 17:50:56.897403 2025-07-11 17:50:56.897808
[2 rows x 5 columns]
2025-07-11 17:50:56,922 - 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-11 17:50:57,476 - IOOppi_data - INFO : save data to db IOOppi_lh_t data:
date value
1366 2025-07-07 15000.0
1367 2025-07-08 14980.0
1368 2025-07-09 14900.0
1369 2025-07-10 14830.0
1370 2025-07-11 14820.0
2025-07-11 17:50:57,518 - IOOppi_data - INFO : save new data to db IOOppi_lh_t: date value ... created_at updated_at
1369 2025-07-10 14830.0 ... 2025-07-11 17:50:57.510636 2025-07-11 17:50:57.511047
1370 2025-07-11 14820.0 ... 2025-07-11 17:50:57.510636 2025-07-11 17:50:57.511047
[2 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-11 17:50:57,746 - IOOppi_data - INFO : save diff data to db IOOppi_lh_t: date ... updated_at
116 2021-07-05 ... 2025-07-11 17:50:57.738128
117 2021-07-06 ... 2025-07-11 17:50:57.738128
121 2021-07-12 ... 2025-07-11 17:50:57.738128
122 2021-07-13 ... 2025-07-11 17:50:57.738128
194 2021-11-01 ... 2025-07-11 17:50:57.738128
[5 rows x 6 columns]
2025-07-11 17:50:57,781 - IOOppi_data - INFO : save data to db IOOppi_lh_g data:
date value
1366 2025-07-07 15000.0
1367 2025-07-08 14980.0
1368 2025-07-09 14900.0
1369 2025-07-10 14830.0
1370 2025-07-11 14820.0
2025-07-11 17:50:57,825 - IOOppi_data - INFO : save new data to db IOOppi_lh_g: date value ... created_at updated_at
1372 2025-07-10 14830.0 ... 2025-07-11 17:50:57.817846 2025-07-11 17:50:57.818268
1373 2025-07-11 14820.0 ... 2025-07-11 17:50:57.817846 2025-07-11 17:50:57.818268
[2 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-11 17:50:58,053 - IOOppi_data - INFO : save diff data to db IOOppi_lh_g: date ... updated_at
116 2021-07-05 ... 2025-07-11 17:50:58.045326
117 2021-07-06 ... 2025-07-11 17:50:58.045326
121 2021-07-12 ... 2025-07-11 17:50:58.045326
122 2021-07-13 ... 2025-07-11 17:50:58.045326
194 2021-11-01 ... 2025-07-11 17:50:58.045326
[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-11 17:50:58,707 - IOOppi_data - INFO : save data to db IOOppi_cu_t data:
date value
3798 2025-07-07 79921.67
3799 2025-07-08 79826.67
3800 2025-07-09 79245.00
3801 2025-07-10 78678.33
3802 2025-07-11 78733.33
2025-07-11 17:50:58,779 - IOOppi_data - INFO : save new data to db IOOppi_cu_t: date ... updated_at
3801 2025-07-10 ... 2025-07-11 17:50:58.772689
3802 2025-07-11 ... 2025-07-11 17:50:58.772689
[2 rows x 5 columns]
2025-07-11 17:50:58,796 - IOOppi_data - INFO : save diff data to db: IOOppi_cu_t: no diff data
2025-07-11 17:50:58,802 - IOOppi_data - INFO : save data to db IOOppi_cu_g data:
date value
3798 2025-07-07 79921.67
3799 2025-07-08 79826.67
3800 2025-07-09 79245.00
3801 2025-07-10 78678.33
3802 2025-07-11 78733.33
2025-07-11 17:50:58,874 - IOOppi_data - INFO : save new data to db IOOppi_cu_g: date ... updated_at
3804 2025-07-10 ... 2025-07-11 17:50:58.868102
3805 2025-07-11 ... 2025-07-11 17:50:58.868102
[2 rows x 5 columns]
2025-07-11 17:50:58,892 - 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-11 17:50:59,385 - 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-11 17:50:59,456 - IOOppi_data - INFO : save new data to db: IOOppi_PM_t: no new data
2025-07-11 17:50:59,457 - IOOppi_data - INFO : save diff data to db: IOOppi_PM_t: no diff data
2025-07-11 17:50:59,462 - 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-11 17:50:59,524 - IOOppi_data - INFO : save new data to db: IOOppi_PM_g: no new data
2025-07-11 17:50:59,524 - 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-11 17:51:00,155 - IOOppi_data - INFO : save data to db IOOppi_sn_t data:
date value
2776 2025-07-07 266850.0
2777 2025-07-08 264862.5
2778 2025-07-09 265262.5
2779 2025-07-10 265075.0
2780 2025-07-11 266737.5
2025-07-11 17:51:00,213 - IOOppi_data - INFO : save new data to db IOOppi_sn_t: date ... updated_at
2779 2025-07-10 ... 2025-07-11 17:51:00.207588
2780 2025-07-11 ... 2025-07-11 17:51:00.207588
[2 rows x 5 columns]
2025-07-11 17:51:00,232 - IOOppi_data - INFO : save diff data to db: IOOppi_sn_t: no diff data
2025-07-11 17:51:00,237 - IOOppi_data - INFO : save data to db IOOppi_sn_g data:
date value
2776 2025-07-07 266850.0
2777 2025-07-08 264862.5
2778 2025-07-09 265262.5
2779 2025-07-10 265075.0
2780 2025-07-11 266737.5
2025-07-11 17:51:00,296 - IOOppi_data - INFO : save new data to db IOOppi_sn_g: date ... updated_at
2782 2025-07-10 ... 2025-07-11 17:51:00.290350
2783 2025-07-11 ... 2025-07-11 17:51:00.290350
[2 rows x 5 columns]
2025-07-11 17:51:00,314 - 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-11 17:51:01,051 - IOOppi_data - INFO : save data to db IOOppi_zn_t data:
date value
3797 2025-07-07 22242.0
3798 2025-07-08 22010.0
3799 2025-07-09 22144.0
3800 2025-07-10 22376.0
3801 2025-07-11 22404.0
2025-07-11 17:51:01,128 - IOOppi_data - INFO : save new data to db IOOppi_zn_t: date value ... created_at updated_at
3800 2025-07-10 22376.0 ... 2025-07-11 17:51:01.120046 2025-07-11 17:51:01.120432
3801 2025-07-11 22404.0 ... 2025-07-11 17:51:01.120046 2025-07-11 17:51:01.120432
[2 rows x 5 columns]
2025-07-11 17:51:01,147 - IOOppi_data - INFO : save diff data to db: IOOppi_zn_t: no diff data
2025-07-11 17:51:01,153 - IOOppi_data - INFO : save data to db IOOppi_zn_g data:
date value
3797 2025-07-07 22242.0
3798 2025-07-08 22010.0
3799 2025-07-09 22144.0
3800 2025-07-10 22376.0
3801 2025-07-11 22404.0
2025-07-11 17:51:01,232 - IOOppi_data - INFO : save new data to db IOOppi_zn_g: date value ... created_at updated_at
3803 2025-07-10 22376.0 ... 2025-07-11 17:51:01.224034 2025-07-11 17:51:01.224440
3804 2025-07-11 22404.0 ... 2025-07-11 17:51:01.224034 2025-07-11 17:51:01.224440
[2 rows x 5 columns]
2025-07-11 17:51:01,251 - 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-11 17:51:01,850 - IOOppi_data - INFO : save data to db IOOppi_wr_t data:
date value
3760 2025-07-07 3302.5
3761 2025-07-08 3302.5
3762 2025-07-09 3300.0
3763 2025-07-10 3300.0
3764 2025-07-11 3355.0
2025-07-11 17:51:01,923 - IOOppi_data - INFO : save new data to db IOOppi_wr_t: date value ... created_at updated_at
3763 2025-07-10 3300.0 ... 2025-07-11 17:51:01.916276 2025-07-11 17:51:01.916655
3764 2025-07-11 3355.0 ... 2025-07-11 17:51:01.916276 2025-07-11 17:51:01.916655
[2 rows x 5 columns]
2025-07-11 17:51:01,942 - IOOppi_data - INFO : save diff data to db: IOOppi_wr_t: no diff data
2025-07-11 17:51:01,948 - IOOppi_data - INFO : save data to db IOOppi_wr_g data:
date value
3760 2025-07-07 3302.5
3761 2025-07-08 3302.5
3762 2025-07-09 3300.0
3763 2025-07-10 3300.0
3764 2025-07-11 3355.0
2025-07-11 17:51:02,023 - IOOppi_data - INFO : save new data to db IOOppi_wr_g: date value ... created_at updated_at
3766 2025-07-10 3300.0 ... 2025-07-11 17:51:02.015805 2025-07-11 17:51:02.016249
3767 2025-07-11 3355.0 ... 2025-07-11 17:51:02.015805 2025-07-11 17:51:02.016249
[2 rows x 5 columns]
2025-07-11 17:51:02,043 - 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-11 17:51:02,599 - IOOppi_data - INFO : save data to db IOOppi_pg_t data:
date value
1557 2025-07-07 4935.0
1558 2025-07-08 4885.0
1559 2025-07-09 4870.0
1560 2025-07-10 4882.5
1561 2025-07-11 4875.0
2025-07-11 17:51:02,642 - IOOppi_data - INFO : save new data to db IOOppi_pg_t: date value ... created_at updated_at
1560 2025-07-10 4882.5 ... 2025-07-11 17:51:02.635836 2025-07-11 17:51:02.636222
1561 2025-07-11 4875.0 ... 2025-07-11 17:51:02.635836 2025-07-11 17:51:02.636222
[2 rows x 5 columns]
2025-07-11 17:51:02,662 - IOOppi_data - INFO : save diff data to db: IOOppi_pg_t: no diff data
2025-07-11 17:51:02,667 - IOOppi_data - INFO : save data to db IOOppi_pg_g data:
date value
1557 2025-07-07 4935.0
1558 2025-07-08 4885.0
1559 2025-07-09 4870.0
1560 2025-07-10 4882.5
1561 2025-07-11 4875.0
2025-07-11 17:51:02,712 - IOOppi_data - INFO : save new data to db IOOppi_pg_g: date value ... created_at updated_at
1563 2025-07-10 4882.5 ... 2025-07-11 17:51:02.705008 2025-07-11 17:51:02.705428
1564 2025-07-11 4875.0 ... 2025-07-11 17:51:02.705008 2025-07-11 17:51:02.705428
[2 rows x 5 columns]
2025-07-11 17:51:02,732 - 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-11 17:51:03,464 - IOOppi_data - INFO : save data to db IOOppi_cs_t data:
date value
2831 2025-07-07 2364.29
2832 2025-07-08 2360.00
2833 2025-07-09 2357.14
2834 2025-07-10 2354.29
2835 2025-07-11 2351.43
2025-07-11 17:51:03,528 - IOOppi_data - INFO : save new data to db IOOppi_cs_t: date value ... created_at updated_at
2834 2025-07-10 2354.29 ... 2025-07-11 17:51:03.519928 2025-07-11 17:51:03.520351
2835 2025-07-11 2351.43 ... 2025-07-11 17:51:03.519928 2025-07-11 17:51:03.520351
[2 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-11 17:51:03,570 - IOOppi_data - INFO : save diff data to db IOOppi_cs_t: date ... updated_at
2833 2025-07-09 ... 2025-07-11 17:51:03.562365
[1 rows x 6 columns]
2025-07-11 17:51:03,594 - IOOppi_data - INFO : save data to db IOOppi_cs_g data:
date value
2831 2025-07-07 2364.29
2832 2025-07-08 2360.00
2833 2025-07-09 2357.14
2834 2025-07-10 2354.29
2835 2025-07-11 2351.43
2025-07-11 17:51:03,656 - IOOppi_data - INFO : save new data to db IOOppi_cs_g: date value ... created_at updated_at
2837 2025-07-10 2354.29 ... 2025-07-11 17:51:03.649140 2025-07-11 17:51:03.649521
2838 2025-07-11 2351.43 ... 2025-07-11 17:51:03.649140 2025-07-11 17:51:03.649521
[2 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-11 17:51:03,696 - IOOppi_data - INFO : save diff data to db IOOppi_cs_g: date ... updated_at
2836 2025-07-09 ... 2025-07-11 17:51:03.689076
[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-11 17:51:04,267 - IOOppi_data - INFO : save data to db IOOppi_cs_t data:
date value
2831 2025-07-07 2364.29
2832 2025-07-08 2360.00
2833 2025-07-09 2357.14
2834 2025-07-10 2354.29
2835 2025-07-11 2944.00
2025-07-11 17:51:04,321 - 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-11 17:51:04,343 - IOOppi_data - INFO : save diff data to db IOOppi_cs_t: date ... updated_at
2835 2025-07-11 ... 2025-07-11 17:51:04.336027
[1 rows x 6 columns]
2025-07-11 17:51:04,367 - IOOppi_data - INFO : save data to db IOOppi_cs_g data:
date value
2831 2025-07-07 2364.29
2832 2025-07-08 2360.00
2833 2025-07-09 2357.14
2834 2025-07-10 2354.29
2835 2025-07-11 2944.00
2025-07-11 17:51:04,420 - 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-11 17:51:04,442 - IOOppi_data - INFO : save diff data to db IOOppi_cs_g: date ... updated_at
2838 2025-07-11 ... 2025-07-11 17:51:04.435093
[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-11 17:51:04,928 - IOOppi_data - INFO : save data to db IOOppi_RS_t data:
date value
3188 2025-07-07 9703.33
3189 2025-07-08 9745.00
3190 2025-07-09 9675.00
3191 2025-07-10 9585.00
3192 2025-07-11 9568.33
2025-07-11 17:51:04,983 - IOOppi_data - INFO : save new data to db: IOOppi_RS_t: no new data
2025-07-11 17:51:04,983 - IOOppi_data - INFO : save diff data to db: IOOppi_RS_t: no diff data
2025-07-11 17:51:04,989 - IOOppi_data - INFO : save data to db IOOppi_RS_g data:
date value
3188 2025-07-07 9703.33
3189 2025-07-08 9745.00
3190 2025-07-09 9675.00
3191 2025-07-10 9585.00
3192 2025-07-11 9568.33
2025-07-11 17:51:05,051 - IOOppi_data - INFO : save new data to db: IOOppi_RS_g: no new data
2025-07-11 17:51:05,051 - 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-11 17:51:05,873 - IOOppi_data - INFO : save data to db IOOppi_eg_t data:
date value
1872 2025-07-07 4405.00
1873 2025-07-08 4400.00
1874 2025-07-09 4393.33
1875 2025-07-10 4393.33
1876 2025-07-11 4405.00
2025-07-11 17:51:05,924 - IOOppi_data - INFO : save new data to db IOOppi_eg_t: date value ... created_at updated_at
1875 2025-07-10 4393.33 ... 2025-07-11 17:51:05.916566 2025-07-11 17:51:05.917024
1876 2025-07-11 4405.00 ... 2025-07-11 17:51:05.916566 2025-07-11 17:51:05.917024
[2 rows x 5 columns]
2025-07-11 17:51:05,942 - IOOppi_data - INFO : save diff data to db: IOOppi_eg_t: no diff data
2025-07-11 17:51:05,949 - IOOppi_data - INFO : save data to db IOOppi_eg_g data:
date value
1872 2025-07-07 4405.00
1873 2025-07-08 4400.00
1874 2025-07-09 4393.33
1875 2025-07-10 4393.33
1876 2025-07-11 4405.00
2025-07-11 17:51:05,998 - IOOppi_data - INFO : save new data to db IOOppi_eg_g: date value ... created_at updated_at
1878 2025-07-10 4393.33 ... 2025-07-11 17:51:05.991169 2025-07-11 17:51:05.991555
1879 2025-07-11 4405.00 ... 2025-07-11 17:51:05.991169 2025-07-11 17:51:05.991555
[2 rows x 5 columns]
2025-07-11 17:51:06,016 - 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-11 17:51:07,527 - IOOppi_data - INFO : save data to db IOOppi_sp_t data:
date value
1881 2025-07-07 5950.00
1882 2025-07-08 5916.67
1883 2025-07-09 5900.00
1884 2025-07-10 5933.33
1885 2025-07-11 5950.00
2025-07-11 17:51:07,577 - IOOppi_data - INFO : save new data to db IOOppi_sp_t: date value ... created_at updated_at
1884 2025-07-10 5933.33 ... 2025-07-11 17:51:07.569693 2025-07-11 17:51:07.570119
1885 2025-07-11 5950.00 ... 2025-07-11 17:51:07.569693 2025-07-11 17:51:07.570119
[2 rows x 5 columns]
2025-07-11 17:51:07,596 - IOOppi_data - INFO : save diff data to db: IOOppi_sp_t: no diff data
2025-07-11 17:51:07,602 - IOOppi_data - INFO : save data to db IOOppi_sp_g data:
date value
1881 2025-07-07 5950.00
1882 2025-07-08 5916.67
1883 2025-07-09 5900.00
1884 2025-07-10 5933.33
1885 2025-07-11 5950.00
2025-07-11 17:51:07,654 - IOOppi_data - INFO : save new data to db IOOppi_sp_g: date value ... created_at updated_at
1887 2025-07-10 5933.33 ... 2025-07-11 17:51:07.646594 2025-07-11 17:51:07.647029
1888 2025-07-11 5950.00 ... 2025-07-11 17:51:07.646594 2025-07-11 17:51:07.647029
[2 rows x 5 columns]
2025-07-11 17:51:07,673 - 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-11 17:51:08,182 - IOOppi_data - INFO : save data to db IOOppi_p_t data:
date value
3549 2025-07-07 8668.0
3550 2025-07-08 8828.0
3551 2025-07-09 8874.0
3552 2025-07-10 8836.0
3553 2025-07-11 8944.0
2025-07-11 17:51:08,252 - IOOppi_data - INFO : save new data to db IOOppi_p_t: date value ... created_at updated_at
3552 2025-07-10 8836.0 ... 2025-07-11 17:51:08.244640 2025-07-11 17:51:08.245053
3553 2025-07-11 8944.0 ... 2025-07-11 17:51:08.244640 2025-07-11 17:51:08.245053
[2 rows x 5 columns]
2025-07-11 17:51:08,270 - IOOppi_data - INFO : save diff data to db: IOOppi_p_t: no diff data
2025-07-11 17:51:08,276 - IOOppi_data - INFO : save data to db IOOppi_p_g data:
date value
3549 2025-07-07 8668.0
3550 2025-07-08 8828.0
3551 2025-07-09 8874.0
3552 2025-07-10 8836.0
3553 2025-07-11 8944.0
2025-07-11 17:51:08,352 - IOOppi_data - INFO : save new data to db IOOppi_p_g: date value ... created_at updated_at
3555 2025-07-10 8836.0 ... 2025-07-11 17:51:08.345074 2025-07-11 17:51:08.345460
3556 2025-07-11 8944.0 ... 2025-07-11 17:51:08.345074 2025-07-11 17:51:08.345460
[2 rows x 5 columns]
2025-07-11 17:51:08,371 - IOOppi_data - INFO : save diff data to db: IOOppi_p_g: no diff data