=========================================================================
2025-07-07 17:50:27 Mon 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-07 17:50:29,295 - IOOppi_data - INFO : save data to db IOOppi_rb_t data:
date value
3353 2025-07-03 3104.0
3354 2025-07-04 3113.0
3355 2025-07-05 3113.0
3356 2025-07-06 3113.0
3357 2025-07-07 3104.0
2025-07-07 17:50:29,365 - IOOppi_data - INFO : save new data to db IOOppi_rb_t: date value ... created_at updated_at
3355 2025-07-05 3113.0 ... 2025-07-07 17:50:29.357655 2025-07-07 17:50:29.358107
3356 2025-07-06 3113.0 ... 2025-07-07 17:50:29.357655 2025-07-07 17:50:29.358107
3357 2025-07-07 3104.0 ... 2025-07-07 17:50:29.357655 2025-07-07 17:50:29.358107
[3 rows x 5 columns]
2025-07-07 17:50:29,388 - IOOppi_data - INFO : save diff data to db: IOOppi_rb_t: no diff data
2025-07-07 17:50:29,394 - IOOppi_data - INFO : save data to db IOOppi_rb_g data:
date value
3353 2025-07-03 3104.0
3354 2025-07-04 3113.0
3355 2025-07-05 3113.0
3356 2025-07-06 3113.0
3357 2025-07-07 3104.0
2025-07-07 17:50:29,460 - IOOppi_data - INFO : save new data to db IOOppi_rb_g: date value ... created_at updated_at
3358 2025-07-05 3113.0 ... 2025-07-07 17:50:29.452965 2025-07-07 17:50:29.453364
3359 2025-07-06 3113.0 ... 2025-07-07 17:50:29.452965 2025-07-07 17:50:29.453364
3360 2025-07-07 3104.0 ... 2025-07-07 17:50:29.452965 2025-07-07 17:50:29.453364
[3 rows x 5 columns]
2025-07-07 17:50:29,481 - 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-07 17:50:30,073 - IOOppi_data - INFO : save data to db IOOppi_MA_t data:
date value
3574 2025-07-03 2474.17
3575 2025-07-04 2474.17
3576 2025-07-05 2447.50
3577 2025-07-06 2447.50
3578 2025-07-07 2423.33
2025-07-07 17:50:30,140 - IOOppi_data - INFO : save new data to db IOOppi_MA_t: date value ... created_at updated_at
3576 2025-07-05 2447.50 ... 2025-07-07 17:50:30.133145 2025-07-07 17:50:30.133585
3577 2025-07-06 2447.50 ... 2025-07-07 17:50:30.133145 2025-07-07 17:50:30.133585
3578 2025-07-07 2423.33 ... 2025-07-07 17:50:30.133145 2025-07-07 17:50:30.133585
[3 rows x 5 columns]
2025-07-07 17:50:30,159 - IOOppi_data - INFO : save diff data to db: IOOppi_MA_t: no diff data
2025-07-07 17:50:30,165 - IOOppi_data - INFO : save data to db IOOppi_MA_g data:
date value
3574 2025-07-03 2474.17
3575 2025-07-04 2474.17
3576 2025-07-05 2447.50
3577 2025-07-06 2447.50
3578 2025-07-07 2423.33
2025-07-07 17:50:30,237 - IOOppi_data - INFO : save new data to db IOOppi_MA_g: date value ... created_at updated_at
3580 2025-07-05 2447.50 ... 2025-07-07 17:50:30.230318 2025-07-07 17:50:30.230697
3581 2025-07-06 2447.50 ... 2025-07-07 17:50:30.230318 2025-07-07 17:50:30.230697
3582 2025-07-07 2423.33 ... 2025-07-07 17:50:30.230318 2025-07-07 17:50:30.230697
[3 rows x 5 columns]
2025-07-07 17:50:30,256 - 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-07 17:50:30,820 - IOOppi_data - INFO : save data to db IOOppi_PTA_t data:
date value
914 2025-07-03 5031.25
915 2025-07-04 5031.25
916 2025-07-05 5031.25
917 2025-07-06 5031.25
918 2025-07-07 4977.50
2025-07-07 17:50:30,857 - IOOppi_data - INFO : save new data to db IOOppi_PTA_t: date value ... created_at updated_at
916 2025-07-05 5031.25 ... 2025-07-07 17:50:30.849761 2025-07-07 17:50:30.850199
917 2025-07-06 5031.25 ... 2025-07-07 17:50:30.849761 2025-07-07 17:50:30.850199
918 2025-07-07 4977.50 ... 2025-07-07 17:50:30.849761 2025-07-07 17:50:30.850199
[3 rows x 5 columns]
2025-07-07 17:50:30,876 - IOOppi_data - INFO : save diff data to db: IOOppi_PTA_t: no diff data
2025-07-07 17:50:30,882 - IOOppi_data - INFO : save data to db IOOppi_PTA_g data:
date value
914 2025-07-03 5031.25
915 2025-07-04 5031.25
916 2025-07-05 5031.25
917 2025-07-06 5031.25
918 2025-07-07 4977.50
2025-07-07 17:50:30,919 - IOOppi_data - INFO : save new data to db IOOppi_PTA_g: date value ... created_at updated_at
916 2025-07-05 5031.25 ... 2025-07-07 17:50:30.911414 2025-07-07 17:50:30.911848
917 2025-07-06 5031.25 ... 2025-07-07 17:50:30.911414 2025-07-07 17:50:30.911848
918 2025-07-07 4977.50 ... 2025-07-07 17:50:30.911414 2025-07-07 17:50:30.911848
[3 rows x 5 columns]
2025-07-07 17:50:30,937 - 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-07 17:50:31,619 - IOOppi_data - INFO : save data to db IOOppi_ru_t data:
date value
3793 2025-07-03 13858.33
3794 2025-07-04 13958.33
3795 2025-07-05 13958.33
3796 2025-07-06 13958.33
3797 2025-07-07 13878.33
2025-07-07 17:50:31,690 - IOOppi_data - INFO : save new data to db IOOppi_ru_t: date ... updated_at
3795 2025-07-05 ... 2025-07-07 17:50:31.684423
3796 2025-07-06 ... 2025-07-07 17:50:31.684423
3797 2025-07-07 ... 2025-07-07 17:50:31.684423
[3 rows x 5 columns]
2025-07-07 17:50:31,710 - IOOppi_data - INFO : save diff data to db: IOOppi_ru_t: no diff data
2025-07-07 17:50:31,716 - IOOppi_data - INFO : save data to db IOOppi_ru_g data:
date value
3793 2025-07-03 13858.33
3794 2025-07-04 13958.33
3795 2025-07-05 13958.33
3796 2025-07-06 13958.33
3797 2025-07-07 13878.33
2025-07-07 17:50:31,791 - IOOppi_data - INFO : save new data to db IOOppi_ru_g: date ... updated_at
3798 2025-07-05 ... 2025-07-07 17:50:31.784987
3799 2025-07-06 ... 2025-07-07 17:50:31.784987
3800 2025-07-07 ... 2025-07-07 17:50:31.784987
[3 rows x 5 columns]
2025-07-07 17:50:31,809 - 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-07 17:50:32,375 - IOOppi_data - INFO : save data to db IOOppi_i_t data:
date value
3125 2025-07-03 730.67
3126 2025-07-04 741.78
3127 2025-07-05 737.33
3128 2025-07-06 737.33
3129 2025-07-07 737.33
2025-07-07 17:50:32,437 - IOOppi_data - INFO : save new data to db IOOppi_i_t: date value ... created_at updated_at
3127 2025-07-05 737.33 ... 2025-07-07 17:50:32.430512 2025-07-07 17:50:32.430922
3128 2025-07-06 737.33 ... 2025-07-07 17:50:32.430512 2025-07-07 17:50:32.430922
3129 2025-07-07 737.33 ... 2025-07-07 17:50:32.430512 2025-07-07 17:50:32.430922
[3 rows x 5 columns]
2025-07-07 17:50:32,456 - IOOppi_data - INFO : save diff data to db: IOOppi_i_t: no diff data
2025-07-07 17:50:32,462 - IOOppi_data - INFO : save data to db IOOppi_i_g data:
date value
3125 2025-07-03 730.67
3126 2025-07-04 741.78
3127 2025-07-05 737.33
3128 2025-07-06 737.33
3129 2025-07-07 737.33
2025-07-07 17:50:32,526 - IOOppi_data - INFO : save new data to db IOOppi_i_g: date value ... created_at updated_at
3130 2025-07-05 737.33 ... 2025-07-07 17:50:32.518952 2025-07-07 17:50:32.519343
3131 2025-07-06 737.33 ... 2025-07-07 17:50:32.518952 2025-07-07 17:50:32.519343
3132 2025-07-07 737.33 ... 2025-07-07 17:50:32.518952 2025-07-07 17:50:32.519343
[3 rows x 5 columns]
2025-07-07 17:50:32,545 - 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-07 17:50:33,093 - IOOppi_data - INFO : save data to db IOOppi_FG_t data:
date value
3328 2025-07-03 1108.0
3329 2025-07-04 1122.4
3330 2025-07-05 1122.4
3331 2025-07-06 1122.4
3332 2025-07-07 1122.4
2025-07-07 17:50:33,160 - IOOppi_data - INFO : save new data to db IOOppi_FG_t: date value ... created_at updated_at
3330 2025-07-05 1122.4 ... 2025-07-07 17:50:33.152252 2025-07-07 17:50:33.152636
3331 2025-07-06 1122.4 ... 2025-07-07 17:50:33.152252 2025-07-07 17:50:33.152636
3332 2025-07-07 1122.4 ... 2025-07-07 17:50:33.152252 2025-07-07 17:50:33.152636
[3 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-07 17:50:35,087 - IOOppi_data - INFO : save diff data to db IOOppi_FG_t: date ... updated_at
12 2012-12-19 ... 2025-07-07 17:50:35.079332
21 2013-01-04 ... 2025-07-07 17:50:35.079332
54 2013-02-27 ... 2025-07-07 17:50:35.079332
60 2013-03-07 ... 2025-07-07 17:50:35.079332
61 2013-03-08 ... 2025-07-07 17:50:35.079332
[5 rows x 6 columns]
2025-07-07 17:50:35,243 - IOOppi_data - INFO : save data to db IOOppi_FG_g data:
date value
3328 2025-07-03 1108.0
3329 2025-07-04 1122.4
3330 2025-07-05 1122.4
3331 2025-07-06 1122.4
3332 2025-07-07 1122.4
2025-07-07 17:50:35,310 - IOOppi_data - INFO : save new data to db IOOppi_FG_g: date value ... created_at updated_at
3334 2025-07-05 1122.4 ... 2025-07-07 17:50:35.302816 2025-07-07 17:50:35.303215
3335 2025-07-06 1122.4 ... 2025-07-07 17:50:35.302816 2025-07-07 17:50:35.303215
3336 2025-07-07 1122.4 ... 2025-07-07 17:50:35.302816 2025-07-07 17:50:35.303215
[3 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-07 17:50:37,235 - IOOppi_data - INFO : save diff data to db IOOppi_FG_g: date ... updated_at
12 2012-12-19 ... 2025-07-07 17:50:37.227471
21 2013-01-04 ... 2025-07-07 17:50:37.227471
54 2013-02-27 ... 2025-07-07 17:50:37.227471
60 2013-03-07 ... 2025-07-07 17:50:37.227471
61 2013-03-08 ... 2025-07-07 17:50:37.227471
[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-07 17:50:37,950 - IOOppi_data - INFO : save data to db IOOppi_eb_t data:
date value
1673 2025-07-03 7904.0
1674 2025-07-04 7904.0
1675 2025-07-05 7904.0
1676 2025-07-06 7904.0
1677 2025-07-07 7914.0
2025-07-07 17:50:37,997 - IOOppi_data - INFO : save new data to db IOOppi_eb_t: date value ... created_at updated_at
1675 2025-07-05 7904.0 ... 2025-07-07 17:50:37.990038 2025-07-07 17:50:37.990430
1676 2025-07-06 7904.0 ... 2025-07-07 17:50:37.990038 2025-07-07 17:50:37.990430
1677 2025-07-07 7914.0 ... 2025-07-07 17:50:37.990038 2025-07-07 17:50:37.990430
[3 rows x 5 columns]
2025-07-07 17:50:38,017 - IOOppi_data - INFO : save diff data to db: IOOppi_eb_t: no diff data
2025-07-07 17:50:38,023 - IOOppi_data - INFO : save data to db IOOppi_eb_g data:
date value
1673 2025-07-03 7904.0
1674 2025-07-04 7904.0
1675 2025-07-05 7904.0
1676 2025-07-06 7904.0
1677 2025-07-07 7914.0
2025-07-07 17:50:38,070 - IOOppi_data - INFO : save new data to db IOOppi_eb_g: date value ... created_at updated_at
1678 2025-07-05 7904.0 ... 2025-07-07 17:50:38.062517 2025-07-07 17:50:38.062932
1679 2025-07-06 7904.0 ... 2025-07-07 17:50:38.062517 2025-07-07 17:50:38.062932
1680 2025-07-07 7914.0 ... 2025-07-07 17:50:38.062517 2025-07-07 17:50:38.062932
[3 rows x 5 columns]
2025-07-07 17:50:38,088 - 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-07 17:50:38,667 - IOOppi_data - INFO : save data to db IOOppi_SR_t data:
date value
3784 2025-07-03 6050.00
3785 2025-07-04 6053.33
3786 2025-07-05 6053.33
3787 2025-07-06 6053.33
3788 2025-07-07 6043.33
2025-07-07 17:50:38,739 - IOOppi_data - INFO : save new data to db IOOppi_SR_t: date value ... created_at updated_at
3786 2025-07-05 6053.33 ... 2025-07-07 17:50:38.731877 2025-07-07 17:50:38.732305
3787 2025-07-06 6053.33 ... 2025-07-07 17:50:38.731877 2025-07-07 17:50:38.732305
3788 2025-07-07 6043.33 ... 2025-07-07 17:50:38.731877 2025-07-07 17:50:38.732305
[3 rows x 5 columns]
2025-07-07 17:50:38,758 - IOOppi_data - INFO : save diff data to db: IOOppi_SR_t: no diff data
2025-07-07 17:50:38,764 - IOOppi_data - INFO : save data to db IOOppi_SR_g data:
date value
3784 2025-07-03 6050.00
3785 2025-07-04 6053.33
3786 2025-07-05 6053.33
3787 2025-07-06 6053.33
3788 2025-07-07 6043.33
2025-07-07 17:50:38,837 - IOOppi_data - INFO : save new data to db IOOppi_SR_g: date value ... created_at updated_at
3790 2025-07-05 6053.33 ... 2025-07-07 17:50:38.829828 2025-07-07 17:50:38.830221
3791 2025-07-06 6053.33 ... 2025-07-07 17:50:38.829828 2025-07-07 17:50:38.830221
3792 2025-07-07 6043.33 ... 2025-07-07 17:50:38.829828 2025-07-07 17:50:38.830221
[3 rows x 5 columns]
2025-07-07 17:50:38,856 - 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-07 17:50:39,589 - IOOppi_data - INFO : save data to db IOOppi_ss_t data:
date value
1674 2025-07-03 12825.0
1675 2025-07-04 12887.5
1676 2025-07-05 12887.5
1677 2025-07-06 12887.5
1678 2025-07-07 12887.5
2025-07-07 17:50:39,635 - IOOppi_data - INFO : save new data to db IOOppi_ss_t: date value ... created_at updated_at
1676 2025-07-05 12887.5 ... 2025-07-07 17:50:39.628416 2025-07-07 17:50:39.628835
1677 2025-07-06 12887.5 ... 2025-07-07 17:50:39.628416 2025-07-07 17:50:39.628835
1678 2025-07-07 12887.5 ... 2025-07-07 17:50:39.628416 2025-07-07 17:50:39.628835
[3 rows x 5 columns]
2025-07-07 17:50:39,654 - IOOppi_data - INFO : save diff data to db: IOOppi_ss_t: no diff data
2025-07-07 17:50:39,659 - IOOppi_data - INFO : save data to db IOOppi_ss_g data:
date value
1674 2025-07-03 12825.0
1675 2025-07-04 12887.5
1676 2025-07-05 12887.5
1677 2025-07-06 12887.5
1678 2025-07-07 12887.5
2025-07-07 17:50:39,708 - IOOppi_data - INFO : save new data to db IOOppi_ss_g: date value ... created_at updated_at
1679 2025-07-05 12887.5 ... 2025-07-07 17:50:39.700639 2025-07-07 17:50:39.701055
1680 2025-07-06 12887.5 ... 2025-07-07 17:50:39.700639 2025-07-07 17:50:39.701055
1681 2025-07-07 12887.5 ... 2025-07-07 17:50:39.700639 2025-07-07 17:50:39.701055
[3 rows x 5 columns]
2025-07-07 17:50:39,726 - 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-07 17:50:40,296 - IOOppi_data - INFO : save data to db IOOppi_RS_t data:
date value
3184 2025-07-03 9775.00
3185 2025-07-04 9755.00
3186 2025-07-05 9755.00
3187 2025-07-06 9755.00
3188 2025-07-07 9703.33
2025-07-07 17:50:40,361 - IOOppi_data - INFO : save new data to db IOOppi_RS_t: date value ... created_at updated_at
3186 2025-07-05 9755.00 ... 2025-07-07 17:50:40.353788 2025-07-07 17:50:40.354335
3187 2025-07-06 9755.00 ... 2025-07-07 17:50:40.353788 2025-07-07 17:50:40.354335
3188 2025-07-07 9703.33 ... 2025-07-07 17:50:40.353788 2025-07-07 17:50:40.354335
[3 rows x 5 columns]
2025-07-07 17:50:40,380 - IOOppi_data - INFO : save diff data to db: IOOppi_RS_t: no diff data
2025-07-07 17:50:40,386 - IOOppi_data - INFO : save data to db IOOppi_RS_g data:
date value
3184 2025-07-03 9775.00
3185 2025-07-04 9755.00
3186 2025-07-05 9755.00
3187 2025-07-06 9755.00
3188 2025-07-07 9703.33
2025-07-07 17:50:40,450 - IOOppi_data - INFO : save new data to db IOOppi_RS_g: date value ... created_at updated_at
3190 2025-07-05 9755.00 ... 2025-07-07 17:50:40.443127 2025-07-07 17:50:40.443513
3191 2025-07-06 9755.00 ... 2025-07-07 17:50:40.443127 2025-07-07 17:50:40.443513
3192 2025-07-07 9703.33 ... 2025-07-07 17:50:40.443127 2025-07-07 17:50:40.443513
[3 rows x 5 columns]
2025-07-07 17:50:40,470 - 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-07 17:50:41,125 - IOOppi_data - INFO : save data to db IOOppi_RM_t data:
date value
3307 2025-07-03 2530.0
3308 2025-07-04 2535.0
3309 2025-07-05 2535.0
3310 2025-07-06 2535.0
3311 2025-07-07 2525.0
2025-07-07 17:50:41,191 - IOOppi_data - INFO : save new data to db IOOppi_RM_t: date value ... created_at updated_at
3309 2025-07-05 2535.0 ... 2025-07-07 17:50:41.183818 2025-07-07 17:50:41.184212
3310 2025-07-06 2535.0 ... 2025-07-07 17:50:41.183818 2025-07-07 17:50:41.184212
3311 2025-07-07 2525.0 ... 2025-07-07 17:50:41.183818 2025-07-07 17:50:41.184212
[3 rows x 5 columns]
2025-07-07 17:50:41,210 - IOOppi_data - INFO : save diff data to db: IOOppi_RM_t: no diff data
2025-07-07 17:50:41,216 - IOOppi_data - INFO : save data to db IOOppi_RM_g data:
date value
3307 2025-07-03 2530.0
3308 2025-07-04 2535.0
3309 2025-07-05 2535.0
3310 2025-07-06 2535.0
3311 2025-07-07 2525.0
2025-07-07 17:50:41,283 - IOOppi_data - INFO : save new data to db IOOppi_RM_g: date value ... created_at updated_at
3313 2025-07-05 2535.0 ... 2025-07-07 17:50:41.275617 2025-07-07 17:50:41.276085
3314 2025-07-06 2535.0 ... 2025-07-07 17:50:41.275617 2025-07-07 17:50:41.276085
3315 2025-07-07 2525.0 ... 2025-07-07 17:50:41.275617 2025-07-07 17:50:41.276085
[3 rows x 5 columns]
2025-07-07 17:50:41,303 - 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-07 17:50:41,849 - IOOppi_data - INFO : save data to db IOOppi_SA_t data:
date value
1511 2025-07-03 1252.5
1512 2025-07-04 1252.5
1513 2025-07-05 1252.5
1514 2025-07-06 1252.5
1515 2025-07-07 1252.5
2025-07-07 17:50:41,892 - IOOppi_data - INFO : save new data to db IOOppi_SA_t: date value ... created_at updated_at
1513 2025-07-05 1252.5 ... 2025-07-07 17:50:41.885542 2025-07-07 17:50:41.885955
1514 2025-07-06 1252.5 ... 2025-07-07 17:50:41.885542 2025-07-07 17:50:41.885955
1515 2025-07-07 1252.5 ... 2025-07-07 17:50:41.885542 2025-07-07 17:50:41.885955
[3 rows x 5 columns]
2025-07-07 17:50:41,912 - IOOppi_data - INFO : save diff data to db: IOOppi_SA_t: no diff data
2025-07-07 17:50:41,918 - IOOppi_data - INFO : save data to db IOOppi_SA_g data:
date value
1511 2025-07-03 1252.5
1512 2025-07-04 1252.5
1513 2025-07-05 1252.5
1514 2025-07-06 1252.5
1515 2025-07-07 1252.5
2025-07-07 17:50:41,962 - IOOppi_data - INFO : save new data to db IOOppi_SA_g: date value ... created_at updated_at
1517 2025-07-05 1252.5 ... 2025-07-07 17:50:41.955023 2025-07-07 17:50:41.955405
1518 2025-07-06 1252.5 ... 2025-07-07 17:50:41.955023 2025-07-07 17:50:41.955405
1519 2025-07-07 1252.5 ... 2025-07-07 17:50:41.955023 2025-07-07 17:50:41.955405
[3 rows x 5 columns]
2025-07-07 17:50:41,981 - 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-07 17:50:42,676 - IOOppi_data - INFO : save data to db IOOppi_PF_t data:
date value
1424 2025-07-03 6748.54
1425 2025-07-04 6739.58
1426 2025-07-05 6739.58
1427 2025-07-06 6739.58
1428 2025-07-07 6712.92
2025-07-07 17:50:42,719 - IOOppi_data - INFO : save new data to db IOOppi_PF_t: date value ... created_at updated_at
1426 2025-07-05 6739.58 ... 2025-07-07 17:50:42.711727 2025-07-07 17:50:42.712140
1427 2025-07-06 6739.58 ... 2025-07-07 17:50:42.711727 2025-07-07 17:50:42.712140
1428 2025-07-07 6712.92 ... 2025-07-07 17:50:42.711727 2025-07-07 17:50:42.712140
[3 rows x 5 columns]
2025-07-07 17:50:42,737 - IOOppi_data - INFO : save diff data to db: IOOppi_PF_t: no diff data
2025-07-07 17:50:42,743 - IOOppi_data - INFO : save data to db IOOppi_PF_g data:
date value
1424 2025-07-03 6748.54
1425 2025-07-04 6739.58
1426 2025-07-05 6739.58
1427 2025-07-06 6739.58
1428 2025-07-07 6712.92
2025-07-07 17:50:42,786 - IOOppi_data - INFO : save new data to db IOOppi_PF_g: date value ... created_at updated_at
1430 2025-07-05 6739.58 ... 2025-07-07 17:50:42.778809 2025-07-07 17:50:42.779199
1431 2025-07-06 6739.58 ... 2025-07-07 17:50:42.778809 2025-07-07 17:50:42.779199
1432 2025-07-07 6712.92 ... 2025-07-07 17:50:42.778809 2025-07-07 17:50:42.779199
[3 rows x 5 columns]
2025-07-07 17:50:42,805 - 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-07 17:50:43,431 - IOOppi_data - INFO : save data to db IOOppi_m_t data:
date value
3797 2025-07-03 2930.0
3798 2025-07-04 2928.0
3799 2025-07-05 2928.0
3800 2025-07-06 2928.0
3801 2025-07-07 2898.0
2025-07-07 17:50:43,504 - IOOppi_data - INFO : save new data to db IOOppi_m_t: date value ... created_at updated_at
3799 2025-07-05 2928.0 ... 2025-07-07 17:50:43.496565 2025-07-07 17:50:43.496980
3800 2025-07-06 2928.0 ... 2025-07-07 17:50:43.496565 2025-07-07 17:50:43.496980
3801 2025-07-07 2898.0 ... 2025-07-07 17:50:43.496565 2025-07-07 17:50:43.496980
[3 rows x 5 columns]
2025-07-07 17:50:43,523 - IOOppi_data - INFO : save diff data to db: IOOppi_m_t: no diff data
2025-07-07 17:50:43,528 - IOOppi_data - INFO : save data to db IOOppi_m_g data:
date value
3797 2025-07-03 2930.0
3798 2025-07-04 2928.0
3799 2025-07-05 2928.0
3800 2025-07-06 2928.0
3801 2025-07-07 2898.0
2025-07-07 17:50:43,601 - IOOppi_data - INFO : save new data to db IOOppi_m_g: date value ... created_at updated_at
3802 2025-07-05 2928.0 ... 2025-07-07 17:50:43.594218 2025-07-07 17:50:43.594601
3803 2025-07-06 2928.0 ... 2025-07-07 17:50:43.594218 2025-07-07 17:50:43.594601
3804 2025-07-07 2898.0 ... 2025-07-07 17:50:43.594218 2025-07-07 17:50:43.594601
[3 rows x 5 columns]
2025-07-07 17:50:43,620 - 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-07 17:50:44,211 - IOOppi_data - INFO : save data to db IOOppi_y_t data:
date value
3567 2025-07-03 8264.0
3568 2025-07-04 8214.0
3569 2025-07-05 8214.0
3570 2025-07-06 8214.0
3571 2025-07-07 8154.0
2025-07-07 17:50:44,281 - IOOppi_data - INFO : save new data to db IOOppi_y_t: date value ... created_at updated_at
3569 2025-07-05 8214.0 ... 2025-07-07 17:50:44.273616 2025-07-07 17:50:44.274036
3570 2025-07-06 8214.0 ... 2025-07-07 17:50:44.273616 2025-07-07 17:50:44.274036
3571 2025-07-07 8154.0 ... 2025-07-07 17:50:44.273616 2025-07-07 17:50:44.274036
[3 rows x 5 columns]
2025-07-07 17:50:44,299 - IOOppi_data - INFO : save diff data to db: IOOppi_y_t: no diff data
2025-07-07 17:50:44,305 - IOOppi_data - INFO : save data to db IOOppi_y_g data:
date value
3567 2025-07-03 8264.0
3568 2025-07-04 8214.0
3569 2025-07-05 8214.0
3570 2025-07-06 8214.0
3571 2025-07-07 8154.0
2025-07-07 17:50:44,377 - IOOppi_data - INFO : save new data to db IOOppi_y_g: date value ... created_at updated_at
3572 2025-07-05 8214.0 ... 2025-07-07 17:50:44.369154 2025-07-07 17:50:44.369551
3573 2025-07-06 8214.0 ... 2025-07-07 17:50:44.369154 2025-07-07 17:50:44.369551
3574 2025-07-07 8154.0 ... 2025-07-07 17:50:44.369154 2025-07-07 17:50:44.369551
[3 rows x 5 columns]
2025-07-07 17:50:44,396 - 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-07 17:50:44,965 - IOOppi_data - INFO : save data to db IOOppi_a_t data:
date value
3533 2025-07-03 4295.0
3534 2025-07-04 4295.0
3535 2025-07-05 4295.0
3536 2025-07-06 4295.0
3537 2025-07-07 4295.0
2025-07-07 17:50:45,034 - IOOppi_data - INFO : save new data to db IOOppi_a_t: date value ... created_at updated_at
3535 2025-07-05 4295.0 ... 2025-07-07 17:50:45.026465 2025-07-07 17:50:45.026886
3536 2025-07-06 4295.0 ... 2025-07-07 17:50:45.026465 2025-07-07 17:50:45.026886
3537 2025-07-07 4295.0 ... 2025-07-07 17:50:45.026465 2025-07-07 17:50:45.026886
[3 rows x 5 columns]
2025-07-07 17:50:45,054 - IOOppi_data - INFO : save diff data to db: IOOppi_a_t: no diff data
2025-07-07 17:50:45,060 - IOOppi_data - INFO : save data to db IOOppi_a_g data:
date value
3533 2025-07-03 4295.0
3534 2025-07-04 4295.0
3535 2025-07-05 4295.0
3536 2025-07-06 4295.0
3537 2025-07-07 4295.0
2025-07-07 17:50:45,130 - IOOppi_data - INFO : save new data to db IOOppi_a_g: date value ... created_at updated_at
3538 2025-07-05 4295.0 ... 2025-07-07 17:50:45.122479 2025-07-07 17:50:45.122896
3539 2025-07-06 4295.0 ... 2025-07-07 17:50:45.122479 2025-07-07 17:50:45.122896
3540 2025-07-07 4295.0 ... 2025-07-07 17:50:45.122479 2025-07-07 17:50:45.122896
[3 rows x 5 columns]
2025-07-07 17:50:45,149 - 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-07 17:50:45,717 - IOOppi_data - INFO : save data to db IOOppi_SF_t data:
date value
2910 2025-07-03 5122.86
2911 2025-07-04 5152.86
2912 2025-07-05 5152.86
2913 2025-07-06 5152.86
2914 2025-07-07 5138.57
2025-07-07 17:50:45,778 - IOOppi_data - INFO : save new data to db IOOppi_SF_t: date value ... created_at updated_at
2912 2025-07-05 5152.86 ... 2025-07-07 17:50:45.771272 2025-07-07 17:50:45.771660
2913 2025-07-06 5152.86 ... 2025-07-07 17:50:45.771272 2025-07-07 17:50:45.771660
2914 2025-07-07 5138.57 ... 2025-07-07 17:50:45.771272 2025-07-07 17:50:45.771660
[3 rows x 5 columns]
2025-07-07 17:50:45,796 - IOOppi_data - INFO : save diff data to db: IOOppi_SF_t: no diff data
2025-07-07 17:50:45,803 - IOOppi_data - INFO : save data to db IOOppi_SF_g data:
date value
2910 2025-07-03 5122.86
2911 2025-07-04 5152.86
2912 2025-07-05 5152.86
2913 2025-07-06 5152.86
2914 2025-07-07 5138.57
2025-07-07 17:50:45,869 - IOOppi_data - INFO : save new data to db IOOppi_SF_g: date value ... created_at updated_at
2916 2025-07-05 5152.86 ... 2025-07-07 17:50:45.862294 2025-07-07 17:50:45.862679
2917 2025-07-06 5152.86 ... 2025-07-07 17:50:45.862294 2025-07-07 17:50:45.862679
2918 2025-07-07 5138.57 ... 2025-07-07 17:50:45.862294 2025-07-07 17:50:45.862679
[3 rows x 5 columns]
2025-07-07 17:50:45,887 - 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-07 17:50:46,418 - IOOppi_data - INFO : save data to db IOOppi_jd_t data:
date value
3110 2025-07-03 2790.0
3111 2025-07-04 2790.0
3112 2025-07-05 2790.0
3113 2025-07-06 2790.0
3114 2025-07-07 2775.0
2025-07-07 17:50:46,483 - IOOppi_data - INFO : save new data to db IOOppi_jd_t: date value ... created_at updated_at
3112 2025-07-05 2790.0 ... 2025-07-07 17:50:46.475424 2025-07-07 17:50:46.475842
3113 2025-07-06 2790.0 ... 2025-07-07 17:50:46.475424 2025-07-07 17:50:46.475842
3114 2025-07-07 2775.0 ... 2025-07-07 17:50:46.475424 2025-07-07 17:50:46.475842
[3 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-07 17:50:46,627 - IOOppi_data - INFO : save diff data to db IOOppi_jd_t: date ... updated_at
39 2014-01-03 ... 2025-07-07 17:50:46.619668
458 2015-09-21 ... 2025-07-07 17:50:46.619668
549 2016-02-03 ... 2025-07-07 17:50:46.619668
693 2016-09-05 ... 2025-07-07 17:50:46.619668
696 2016-09-08 ... 2025-07-07 17:50:46.619668
[5 rows x 6 columns]
2025-07-07 17:50:46,656 - IOOppi_data - INFO : save data to db IOOppi_jd_g data:
date value
3110 2025-07-03 2790.0
3111 2025-07-04 2790.0
3112 2025-07-05 2790.0
3113 2025-07-06 2790.0
3114 2025-07-07 2775.0
2025-07-07 17:50:46,721 - IOOppi_data - INFO : save new data to db IOOppi_jd_g: date value ... created_at updated_at
3115 2025-07-05 2790.0 ... 2025-07-07 17:50:46.713737 2025-07-07 17:50:46.714150
3116 2025-07-06 2790.0 ... 2025-07-07 17:50:46.713737 2025-07-07 17:50:46.714150
3117 2025-07-07 2775.0 ... 2025-07-07 17:50:46.713737 2025-07-07 17:50:46.714150
[3 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-07 17:50:46,867 - IOOppi_data - INFO : save diff data to db IOOppi_jd_g: date ... updated_at
39 2014-01-03 ... 2025-07-07 17:50:46.859009
458 2015-09-21 ... 2025-07-07 17:50:46.859009
549 2016-02-03 ... 2025-07-07 17:50:46.859009
693 2016-09-05 ... 2025-07-07 17:50:46.859009
696 2016-09-08 ... 2025-07-07 17:50:46.859009
[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-07 17:50:47,475 - IOOppi_data - INFO : save data to db IOOppi_SI_t data:
date value
914 2025-07-03 8890.0
915 2025-07-04 8890.0
916 2025-07-05 8910.0
917 2025-07-06 8910.0
918 2025-07-07 8910.0
2025-07-07 17:50:47,513 - IOOppi_data - INFO : save new data to db IOOppi_SI_t: date value ... created_at updated_at
916 2025-07-05 8910.0 ... 2025-07-07 17:50:47.506182 2025-07-07 17:50:47.506578
917 2025-07-06 8910.0 ... 2025-07-07 17:50:47.506182 2025-07-07 17:50:47.506578
918 2025-07-07 8910.0 ... 2025-07-07 17:50:47.506182 2025-07-07 17:50:47.506578
[3 rows x 5 columns]
2025-07-07 17:50:47,533 - IOOppi_data - INFO : save diff data to db: IOOppi_SI_t: no diff data
2025-07-07 17:50:47,538 - IOOppi_data - INFO : save data to db IOOppi_SI_g data:
date value
914 2025-07-03 8890.0
915 2025-07-04 8890.0
916 2025-07-05 8910.0
917 2025-07-06 8910.0
918 2025-07-07 8910.0
2025-07-07 17:50:47,574 - IOOppi_data - INFO : save new data to db IOOppi_SI_g: date value ... created_at updated_at
916 2025-07-05 8910.0 ... 2025-07-07 17:50:47.567391 2025-07-07 17:50:47.567794
917 2025-07-06 8910.0 ... 2025-07-07 17:50:47.567391 2025-07-07 17:50:47.567794
918 2025-07-07 8910.0 ... 2025-07-07 17:50:47.567391 2025-07-07 17:50:47.567794
[3 rows x 5 columns]
2025-07-07 17:50:47,593 - 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-07 17:50:48,144 - IOOppi_data - INFO : save data to db IOOppi_l_t data:
date value
3793 2025-07-03 7441.67
3794 2025-07-04 7445.00
3795 2025-07-05 7445.00
3796 2025-07-06 7445.00
3797 2025-07-07 7433.33
2025-07-07 17:50:48,216 - IOOppi_data - INFO : save new data to db IOOppi_l_t: date value ... created_at updated_at
3795 2025-07-05 7445.00 ... 2025-07-07 17:50:48.209095 2025-07-07 17:50:48.209491
3796 2025-07-06 7445.00 ... 2025-07-07 17:50:48.209095 2025-07-07 17:50:48.209491
3797 2025-07-07 7433.33 ... 2025-07-07 17:50:48.209095 2025-07-07 17:50:48.209491
[3 rows x 5 columns]
2025-07-07 17:50:48,235 - IOOppi_data - INFO : save diff data to db: IOOppi_l_t: no diff data
2025-07-07 17:50:48,241 - IOOppi_data - INFO : save data to db IOOppi_l_g data:
date value
3793 2025-07-03 7441.67
3794 2025-07-04 7445.00
3795 2025-07-05 7445.00
3796 2025-07-06 7445.00
3797 2025-07-07 7433.33
2025-07-07 17:50:48,315 - IOOppi_data - INFO : save new data to db IOOppi_l_g: date value ... created_at updated_at
3798 2025-07-05 7445.00 ... 2025-07-07 17:50:48.308563 2025-07-07 17:50:48.308974
3799 2025-07-06 7445.00 ... 2025-07-07 17:50:48.308563 2025-07-07 17:50:48.308974
3800 2025-07-07 7433.33 ... 2025-07-07 17:50:48.308563 2025-07-07 17:50:48.308974
[3 rows x 5 columns]
2025-07-07 17:50:48,334 - 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-07 17:50:48,894 - IOOppi_data - INFO : save data to db IOOppi_bu_t data:
date value
3131 2025-07-03 3683.33
3132 2025-07-04 3713.33
3133 2025-07-05 3713.33
3134 2025-07-06 3713.33
3135 2025-07-07 3690.00
2025-07-07 17:50:48,960 - IOOppi_data - INFO : save new data to db IOOppi_bu_t: date value ... created_at updated_at
3134 2025-07-05 3713.33 ... 2025-07-07 17:50:48.952723 2025-07-07 17:50:48.953197
3135 2025-07-06 3713.33 ... 2025-07-07 17:50:48.952723 2025-07-07 17:50:48.953197
3136 2025-07-07 3690.00 ... 2025-07-07 17:50:48.952723 2025-07-07 17:50:48.953197
[3 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-07 17:50:48,996 - IOOppi_data - INFO : save diff data to db IOOppi_bu_t: date ... updated_at
2560 2023-12-09 ... 2025-07-07 17:50:48.988797
[1 rows x 6 columns]
2025-07-07 17:50:49,021 - IOOppi_data - INFO : save data to db IOOppi_bu_g data:
date value
3131 2025-07-03 3683.33
3132 2025-07-04 3713.33
3133 2025-07-05 3713.33
3134 2025-07-06 3713.33
3135 2025-07-07 3690.00
2025-07-07 17:50:49,085 - IOOppi_data - INFO : save new data to db IOOppi_bu_g: date value ... created_at updated_at
3136 2025-07-05 3713.33 ... 2025-07-07 17:50:49.078308 2025-07-07 17:50:49.078691
3137 2025-07-06 3713.33 ... 2025-07-07 17:50:49.078308 2025-07-07 17:50:49.078691
3138 2025-07-07 3690.00 ... 2025-07-07 17:50:49.078308 2025-07-07 17:50:49.078691
[3 rows x 5 columns]
2025-07-07 17:50:49,104 - 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-07 17:50:49,676 - IOOppi_data - INFO : save data to db IOOppi_al_t data:
date value
3796 2025-07-03 20816.67
3797 2025-07-04 20870.00
3798 2025-07-05 20780.00
3799 2025-07-06 20780.00
3800 2025-07-07 20780.00
2025-07-07 17:50:49,748 - IOOppi_data - INFO : save new data to db IOOppi_al_t: date value ... created_at updated_at
3798 2025-07-05 20780.0 ... 2025-07-07 17:50:49.740920 2025-07-07 17:50:49.741308
3799 2025-07-06 20780.0 ... 2025-07-07 17:50:49.740920 2025-07-07 17:50:49.741308
3800 2025-07-07 20780.0 ... 2025-07-07 17:50:49.740920 2025-07-07 17:50:49.741308
[3 rows x 5 columns]
2025-07-07 17:50:49,766 - IOOppi_data - INFO : save diff data to db: IOOppi_al_t: no diff data
2025-07-07 17:50:49,772 - IOOppi_data - INFO : save data to db IOOppi_al_g data:
date value
3796 2025-07-03 20816.67
3797 2025-07-04 20870.00
3798 2025-07-05 20780.00
3799 2025-07-06 20780.00
3800 2025-07-07 20780.00
2025-07-07 17:50:49,845 - IOOppi_data - INFO : save new data to db IOOppi_al_g: date value ... created_at updated_at
3801 2025-07-05 20780.0 ... 2025-07-07 17:50:49.837791 2025-07-07 17:50:49.838255
3802 2025-07-06 20780.0 ... 2025-07-07 17:50:49.837791 2025-07-07 17:50:49.838255
3803 2025-07-07 20780.0 ... 2025-07-07 17:50:49.837791 2025-07-07 17:50:49.838255
[3 rows x 5 columns]
2025-07-07 17:50:49,870 - 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-07 17:50:50,455 - IOOppi_data - INFO : save data to db IOOppi_SM_t data:
date value
2910 2025-07-03 5576.0
2911 2025-07-04 5576.0
2912 2025-07-05 5576.0
2913 2025-07-06 5576.0
2914 2025-07-07 5556.0
2025-07-07 17:50:50,516 - IOOppi_data - INFO : save new data to db IOOppi_SM_t: date value ... created_at updated_at
2912 2025-07-05 5576.0 ... 2025-07-07 17:50:50.509290 2025-07-07 17:50:50.509678
2913 2025-07-06 5576.0 ... 2025-07-07 17:50:50.509290 2025-07-07 17:50:50.509678
2914 2025-07-07 5556.0 ... 2025-07-07 17:50:50.509290 2025-07-07 17:50:50.509678
[3 rows x 5 columns]
2025-07-07 17:50:50,535 - IOOppi_data - INFO : save diff data to db: IOOppi_SM_t: no diff data
2025-07-07 17:50:50,541 - IOOppi_data - INFO : save data to db IOOppi_SM_g data:
date value
2910 2025-07-03 5576.0
2911 2025-07-04 5576.0
2912 2025-07-05 5576.0
2913 2025-07-06 5576.0
2914 2025-07-07 5556.0
2025-07-07 17:50:50,603 - IOOppi_data - INFO : save new data to db IOOppi_SM_g: date value ... created_at updated_at
2916 2025-07-05 5576.0 ... 2025-07-07 17:50:50.595543 2025-07-07 17:50:50.595953
2917 2025-07-06 5576.0 ... 2025-07-07 17:50:50.595543 2025-07-07 17:50:50.595953
2918 2025-07-07 5556.0 ... 2025-07-07 17:50:50.595543 2025-07-07 17:50:50.595953
[3 rows x 5 columns]
2025-07-07 17:50:50,621 - 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-07 17:50:51,238 - IOOppi_data - INFO : save data to db IOOppi_CY_t data:
date value
2185 2025-07-03 23200.0
2186 2025-07-04 23200.0
2187 2025-07-05 23200.0
2188 2025-07-06 23200.0
2189 2025-07-07 23200.0
2025-07-07 17:50:51,292 - IOOppi_data - INFO : save new data to db IOOppi_CY_t: date value ... created_at updated_at
2187 2025-07-05 23200.0 ... 2025-07-07 17:50:51.284172 2025-07-07 17:50:51.284600
2188 2025-07-06 23200.0 ... 2025-07-07 17:50:51.284172 2025-07-07 17:50:51.284600
2189 2025-07-07 23200.0 ... 2025-07-07 17:50:51.284172 2025-07-07 17:50:51.284600
[3 rows x 5 columns]
2025-07-07 17:50:51,310 - IOOppi_data - INFO : save diff data to db: IOOppi_CY_t: no diff data
2025-07-07 17:50:51,316 - IOOppi_data - INFO : save data to db IOOppi_CY_g data:
date value
2185 2025-07-03 23200.0
2186 2025-07-04 23200.0
2187 2025-07-05 23200.0
2188 2025-07-06 23200.0
2189 2025-07-07 23200.0
2025-07-07 17:50:51,369 - IOOppi_data - INFO : save new data to db IOOppi_CY_g: date value ... created_at updated_at
2191 2025-07-05 23200.0 ... 2025-07-07 17:50:51.361924 2025-07-07 17:50:51.362329
2192 2025-07-06 23200.0 ... 2025-07-07 17:50:51.361924 2025-07-07 17:50:51.362329
2193 2025-07-07 23200.0 ... 2025-07-07 17:50:51.361924 2025-07-07 17:50:51.362329
[3 rows x 5 columns]
2025-07-07 17:50:51,388 - 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-07 17:50:51,918 - IOOppi_data - INFO : save data to db IOOppi_UR_t data:
date value
1700 2025-07-03 1829.0
1701 2025-07-04 1829.0
1702 2025-07-05 1829.0
1703 2025-07-06 1829.0
1704 2025-07-07 1827.0
2025-07-07 17:50:51,965 - IOOppi_data - INFO : save new data to db IOOppi_UR_t: date value ... created_at updated_at
1702 2025-07-05 1829.0 ... 2025-07-07 17:50:51.957825 2025-07-07 17:50:51.958225
1703 2025-07-06 1829.0 ... 2025-07-07 17:50:51.957825 2025-07-07 17:50:51.958225
1704 2025-07-07 1827.0 ... 2025-07-07 17:50:51.957825 2025-07-07 17:50:51.958225
[3 rows x 5 columns]
2025-07-07 17:50:51,983 - IOOppi_data - INFO : save diff data to db: IOOppi_UR_t: no diff data
2025-07-07 17:50:51,989 - IOOppi_data - INFO : save data to db IOOppi_UR_g data:
date value
1700 2025-07-03 1829.0
1701 2025-07-04 1829.0
1702 2025-07-05 1829.0
1703 2025-07-06 1829.0
1704 2025-07-07 1827.0
2025-07-07 17:50:52,035 - IOOppi_data - INFO : save new data to db IOOppi_UR_g: date value ... created_at updated_at
1706 2025-07-05 1829.0 ... 2025-07-07 17:50:52.028138 2025-07-07 17:50:52.028532
1707 2025-07-06 1829.0 ... 2025-07-07 17:50:52.028138 2025-07-07 17:50:52.028532
1708 2025-07-07 1827.0 ... 2025-07-07 17:50:52.028138 2025-07-07 17:50:52.028532
[3 rows x 5 columns]
2025-07-07 17:50:52,054 - 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-07 17:50:52,640 - IOOppi_data - INFO : save data to db IOOppi_ni_t data:
date value
2772 2025-07-03 122933.33
2773 2025-07-04 123783.33
2774 2025-07-05 123783.33
2775 2025-07-06 123783.33
2776 2025-07-07 122383.33
2025-07-07 17:50:52,698 - IOOppi_data - INFO : save new data to db IOOppi_ni_t: date ... updated_at
2774 2025-07-05 ... 2025-07-07 17:50:52.692467
2775 2025-07-06 ... 2025-07-07 17:50:52.692467
2776 2025-07-07 ... 2025-07-07 17:50:52.692467
[3 rows x 5 columns]
2025-07-07 17:50:52,718 - IOOppi_data - INFO : save diff data to db: IOOppi_ni_t: no diff data
2025-07-07 17:50:52,724 - IOOppi_data - INFO : save data to db IOOppi_ni_g data:
date value
2772 2025-07-03 122933.33
2773 2025-07-04 123783.33
2774 2025-07-05 123783.33
2775 2025-07-06 123783.33
2776 2025-07-07 122383.33
2025-07-07 17:50:52,783 - IOOppi_data - INFO : save new data to db IOOppi_ni_g: date ... updated_at
2777 2025-07-05 ... 2025-07-07 17:50:52.777440
2778 2025-07-06 ... 2025-07-07 17:50:52.777440
2779 2025-07-07 ... 2025-07-07 17:50:52.777440
[3 rows x 5 columns]
2025-07-07 17:50:52,802 - 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-07 17:50:53,371 - IOOppi_data - INFO : save data to db IOOppi_v_t data:
date value
3797 2025-07-03 4693.0
3798 2025-07-04 4678.0
3799 2025-07-05 4678.0
3800 2025-07-06 4678.0
3801 2025-07-07 4651.0
2025-07-07 17:50:53,442 - IOOppi_data - INFO : save new data to db IOOppi_v_t: date value ... created_at updated_at
3799 2025-07-05 4678.0 ... 2025-07-07 17:50:53.435416 2025-07-07 17:50:53.435826
3800 2025-07-06 4678.0 ... 2025-07-07 17:50:53.435416 2025-07-07 17:50:53.435826
3801 2025-07-07 4651.0 ... 2025-07-07 17:50:53.435416 2025-07-07 17:50:53.435826
[3 rows x 5 columns]
2025-07-07 17:50:53,461 - IOOppi_data - INFO : save diff data to db: IOOppi_v_t: no diff data
2025-07-07 17:50:53,466 - IOOppi_data - INFO : save data to db IOOppi_v_g data:
date value
3797 2025-07-03 4693.0
3798 2025-07-04 4678.0
3799 2025-07-05 4678.0
3800 2025-07-06 4678.0
3801 2025-07-07 4651.0
2025-07-07 17:50:53,539 - IOOppi_data - INFO : save new data to db IOOppi_v_g: date value ... created_at updated_at
3802 2025-07-05 4678.0 ... 2025-07-07 17:50:53.531514 2025-07-07 17:50:53.531927
3803 2025-07-06 4678.0 ... 2025-07-07 17:50:53.531514 2025-07-07 17:50:53.531927
3804 2025-07-07 4651.0 ... 2025-07-07 17:50:53.531514 2025-07-07 17:50:53.531927
[3 rows x 5 columns]
2025-07-07 17:50:53,557 - 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-07 17:50:54,115 - IOOppi_data - INFO : save data to db IOOppi_pp_t data:
date value
3036 2025-07-03 7406.67
3037 2025-07-04 7406.67
3038 2025-07-05 7406.67
3039 2025-07-06 7406.67
3040 2025-07-07 7390.00
2025-07-07 17:50:54,178 - IOOppi_data - INFO : save new data to db IOOppi_pp_t: date value ... created_at updated_at
3038 2025-07-05 7406.67 ... 2025-07-07 17:50:54.170843 2025-07-07 17:50:54.171235
3039 2025-07-06 7406.67 ... 2025-07-07 17:50:54.170843 2025-07-07 17:50:54.171235
3040 2025-07-07 7390.00 ... 2025-07-07 17:50:54.170843 2025-07-07 17:50:54.171235
[3 rows x 5 columns]
2025-07-07 17:50:54,197 - IOOppi_data - INFO : save diff data to db: IOOppi_pp_t: no diff data
2025-07-07 17:50:54,202 - IOOppi_data - INFO : save data to db IOOppi_pp_g data:
date value
3036 2025-07-03 7406.67
3037 2025-07-04 7406.67
3038 2025-07-05 7406.67
3039 2025-07-06 7406.67
3040 2025-07-07 7390.00
2025-07-07 17:50:54,265 - IOOppi_data - INFO : save new data to db IOOppi_pp_g: date value ... created_at updated_at
3041 2025-07-05 7406.67 ... 2025-07-07 17:50:54.257827 2025-07-07 17:50:54.258246
3042 2025-07-06 7406.67 ... 2025-07-07 17:50:54.257827 2025-07-07 17:50:54.258246
3043 2025-07-07 7390.00 ... 2025-07-07 17:50:54.257827 2025-07-07 17:50:54.258246
[3 rows x 5 columns]
2025-07-07 17:50:54,283 - 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-07 17:50:54,860 - IOOppi_data - INFO : save data to db IOOppi_CF_t data:
date value
3798 2025-07-03 15160.33
3799 2025-07-04 15198.33
3800 2025-07-05 15198.33
3801 2025-07-06 15198.33
3802 2025-07-07 15202.17
2025-07-07 17:50:54,932 - IOOppi_data - INFO : save new data to db IOOppi_CF_t: date ... updated_at
3800 2025-07-05 ... 2025-07-07 17:50:54.926120
3801 2025-07-06 ... 2025-07-07 17:50:54.926120
3802 2025-07-07 ... 2025-07-07 17:50:54.926120
[3 rows x 5 columns]
2025-07-07 17:50:54,951 - IOOppi_data - INFO : save diff data to db: IOOppi_CF_t: no diff data
2025-07-07 17:50:54,957 - IOOppi_data - INFO : save data to db IOOppi_CF_g data:
date value
3798 2025-07-03 15160.33
3799 2025-07-04 15198.33
3800 2025-07-05 15198.33
3801 2025-07-06 15198.33
3802 2025-07-07 15202.17
2025-07-07 17:50:55,032 - IOOppi_data - INFO : save new data to db IOOppi_CF_g: date ... updated_at
3804 2025-07-05 ... 2025-07-07 17:50:55.025682
3805 2025-07-06 ... 2025-07-07 17:50:55.025682
3806 2025-07-07 ... 2025-07-07 17:50:55.025682
[3 rows x 5 columns]
2025-07-07 17:50:55,050 - 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-07 17:50:55,611 - IOOppi_data - INFO : save data to db IOOppi_pb_t data:
date value
3743 2025-07-03 17100.0
3744 2025-07-04 17112.5
3745 2025-07-05 17112.5
3746 2025-07-06 17112.5
3747 2025-07-07 17050.0
2025-07-07 17:50:55,681 - IOOppi_data - INFO : save new data to db IOOppi_pb_t: date value ... created_at updated_at
3745 2025-07-05 17112.5 ... 2025-07-07 17:50:55.674522 2025-07-07 17:50:55.674937
3746 2025-07-06 17112.5 ... 2025-07-07 17:50:55.674522 2025-07-07 17:50:55.674937
3747 2025-07-07 17050.0 ... 2025-07-07 17:50:55.674522 2025-07-07 17:50:55.674937
[3 rows x 5 columns]
2025-07-07 17:50:55,700 - IOOppi_data - INFO : save diff data to db: IOOppi_pb_t: no diff data
2025-07-07 17:50:55,706 - IOOppi_data - INFO : save data to db IOOppi_pb_g data:
date value
3743 2025-07-03 17100.0
3744 2025-07-04 17112.5
3745 2025-07-05 17112.5
3746 2025-07-06 17112.5
3747 2025-07-07 17050.0
2025-07-07 17:50:55,778 - IOOppi_data - INFO : save new data to db IOOppi_pb_g: date value ... created_at updated_at
3748 2025-07-05 17112.5 ... 2025-07-07 17:50:55.770777 2025-07-07 17:50:55.771177
3749 2025-07-06 17112.5 ... 2025-07-07 17:50:55.770777 2025-07-07 17:50:55.771177
3750 2025-07-07 17050.0 ... 2025-07-07 17:50:55.770777 2025-07-07 17:50:55.771177
[3 rows x 5 columns]
2025-07-07 17:50:55,796 - 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-07 17:50:56,349 - IOOppi_data - INFO : save data to db IOOppi_hc_t data:
date value
3018 2025-07-03 3233.33
3019 2025-07-04 3273.33
3020 2025-07-05 3273.33
3021 2025-07-06 3273.33
3022 2025-07-07 3276.67
2025-07-07 17:50:56,419 - IOOppi_data - INFO : save new data to db IOOppi_hc_t: date value ... created_at updated_at
3020 2025-07-05 3273.33 ... 2025-07-07 17:50:56.409445 2025-07-07 17:50:56.410054
3021 2025-07-06 3273.33 ... 2025-07-07 17:50:56.409445 2025-07-07 17:50:56.410054
3022 2025-07-07 3276.67 ... 2025-07-07 17:50:56.409445 2025-07-07 17:50:56.410054
[3 rows x 5 columns]
2025-07-07 17:50:56,438 - IOOppi_data - INFO : save diff data to db: IOOppi_hc_t: no diff data
2025-07-07 17:50:56,444 - IOOppi_data - INFO : save data to db IOOppi_hc_g data:
date value
3018 2025-07-03 3233.33
3019 2025-07-04 3273.33
3020 2025-07-05 3273.33
3021 2025-07-06 3273.33
3022 2025-07-07 3276.67
2025-07-07 17:50:56,506 - IOOppi_data - INFO : save new data to db IOOppi_hc_g: date value ... created_at updated_at
3023 2025-07-05 3273.33 ... 2025-07-07 17:50:56.499352 2025-07-07 17:50:56.499730
3024 2025-07-06 3273.33 ... 2025-07-07 17:50:56.499352 2025-07-07 17:50:56.499730
3025 2025-07-07 3276.67 ... 2025-07-07 17:50:56.499352 2025-07-07 17:50:56.499730
[3 rows x 5 columns]
2025-07-07 17:50:56,524 - 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-07 17:50:57,082 - IOOppi_data - INFO : save data to db IOOppi_fu_t data:
date value
3298 2025-07-03 5450.0
3299 2025-07-04 5450.0
3300 2025-07-05 5425.0
3301 2025-07-06 5425.0
3302 2025-07-07 5425.0
2025-07-07 17:50:57,147 - IOOppi_data - INFO : save new data to db IOOppi_fu_t: date value ... created_at updated_at
3300 2025-07-05 5425.0 ... 2025-07-07 17:50:57.139692 2025-07-07 17:50:57.140099
3301 2025-07-06 5425.0 ... 2025-07-07 17:50:57.139692 2025-07-07 17:50:57.140099
3302 2025-07-07 5425.0 ... 2025-07-07 17:50:57.139692 2025-07-07 17:50:57.140099
[3 rows x 5 columns]
2025-07-07 17:50:57,166 - IOOppi_data - INFO : save diff data to db: IOOppi_fu_t: no diff data
2025-07-07 17:50:57,174 - IOOppi_data - INFO : save data to db IOOppi_fu_g data:
date value
3298 2025-07-03 5450.0
3299 2025-07-04 5450.0
3300 2025-07-05 5425.0
3301 2025-07-06 5425.0
3302 2025-07-07 5425.0
2025-07-07 17:50:57,249 - IOOppi_data - INFO : save new data to db IOOppi_fu_g: date value ... created_at updated_at
3787 2025-07-05 5425.0 ... 2025-07-07 17:50:57.242319 2025-07-07 17:50:57.242694
3788 2025-07-06 5425.0 ... 2025-07-07 17:50:57.242319 2025-07-07 17:50:57.242694
3789 2025-07-07 5425.0 ... 2025-07-07 17:50:57.242319 2025-07-07 17:50:57.242694
[3 rows x 5 columns]
2025-07-07 17:50:57,267 - 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-07 17:50:57,779 - IOOppi_data - INFO : save data to db IOOppi_lh_t data:
date value
1362 2025-07-03 14920.0
1363 2025-07-04 15020.0
1364 2025-07-05 15020.0
1365 2025-07-06 15020.0
1366 2025-07-07 15000.0
2025-07-07 17:50:57,821 - IOOppi_data - INFO : save new data to db IOOppi_lh_t: date value ... created_at updated_at
1364 2025-07-05 15020.0 ... 2025-07-07 17:50:57.813889 2025-07-07 17:50:57.814281
1365 2025-07-06 15020.0 ... 2025-07-07 17:50:57.813889 2025-07-07 17:50:57.814281
1366 2025-07-07 15000.0 ... 2025-07-07 17:50:57.813889 2025-07-07 17:50:57.814281
[3 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-07 17:50:58,055 - IOOppi_data - INFO : save diff data to db IOOppi_lh_t: date ... updated_at
116 2021-07-05 ... 2025-07-07 17:50:58.046827
117 2021-07-06 ... 2025-07-07 17:50:58.046827
121 2021-07-12 ... 2025-07-07 17:50:58.046827
122 2021-07-13 ... 2025-07-07 17:50:58.046827
194 2021-11-01 ... 2025-07-07 17:50:58.046827
[5 rows x 6 columns]
2025-07-07 17:50:58,091 - IOOppi_data - INFO : save data to db IOOppi_lh_g data:
date value
1362 2025-07-03 14920.0
1363 2025-07-04 15020.0
1364 2025-07-05 15020.0
1365 2025-07-06 15020.0
1366 2025-07-07 15000.0
2025-07-07 17:50:58,134 - IOOppi_data - INFO : save new data to db IOOppi_lh_g: date value ... created_at updated_at
1367 2025-07-05 15020.0 ... 2025-07-07 17:50:58.126652 2025-07-07 17:50:58.127063
1368 2025-07-06 15020.0 ... 2025-07-07 17:50:58.126652 2025-07-07 17:50:58.127063
1369 2025-07-07 15000.0 ... 2025-07-07 17:50:58.126652 2025-07-07 17:50:58.127063
[3 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-07 17:50:58,363 - IOOppi_data - INFO : save diff data to db IOOppi_lh_g: date ... updated_at
116 2021-07-05 ... 2025-07-07 17:50:58.355238
117 2021-07-06 ... 2025-07-07 17:50:58.355238
121 2021-07-12 ... 2025-07-07 17:50:58.355238
122 2021-07-13 ... 2025-07-07 17:50:58.355238
194 2021-11-01 ... 2025-07-07 17:50:58.355238
[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-07 17:50:58,982 - IOOppi_data - INFO : save data to db IOOppi_cu_t data:
date value
3794 2025-07-03 81021.67
3795 2025-07-04 80533.33
3796 2025-07-05 80533.33
3797 2025-07-06 80533.33
3798 2025-07-07 79921.67
2025-07-07 17:50:59,061 - IOOppi_data - INFO : save new data to db IOOppi_cu_t: date ... updated_at
3796 2025-07-05 ... 2025-07-07 17:50:59.054705
3797 2025-07-06 ... 2025-07-07 17:50:59.054705
3798 2025-07-07 ... 2025-07-07 17:50:59.054705
[3 rows x 5 columns]
2025-07-07 17:50:59,081 - IOOppi_data - INFO : save diff data to db: IOOppi_cu_t: no diff data
2025-07-07 17:50:59,090 - IOOppi_data - INFO : save data to db IOOppi_cu_g data:
date value
3794 2025-07-03 81021.67
3795 2025-07-04 80533.33
3796 2025-07-05 80533.33
3797 2025-07-06 80533.33
3798 2025-07-07 79921.67
2025-07-07 17:50:59,163 - IOOppi_data - INFO : save new data to db IOOppi_cu_g: date ... updated_at
3799 2025-07-05 ... 2025-07-07 17:50:59.157220
3800 2025-07-06 ... 2025-07-07 17:50:59.157220
3801 2025-07-07 ... 2025-07-07 17:50:59.157220
[3 rows x 5 columns]
2025-07-07 17:50:59,183 - 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-07 17:50:59,890 - 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-07 17:50:59,941 - IOOppi_data - INFO : save new data to db: IOOppi_PM_t: no new data
2025-07-07 17:50:59,941 - IOOppi_data - INFO : save diff data to db: IOOppi_PM_t: no diff data
2025-07-07 17:50:59,947 - 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-07 17:51:00,007 - IOOppi_data - INFO : save new data to db: IOOppi_PM_g: no new data
2025-07-07 17:51:00,007 - 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-07 17:51:00,632 - IOOppi_data - INFO : save data to db IOOppi_sn_t data:
date value
2772 2025-07-03 268700.0
2773 2025-07-04 267600.0
2774 2025-07-05 267600.0
2775 2025-07-06 267600.0
2776 2025-07-07 266850.0
2025-07-07 17:51:00,690 - IOOppi_data - INFO : save new data to db IOOppi_sn_t: date ... updated_at
2774 2025-07-05 ... 2025-07-07 17:51:00.684354
2775 2025-07-06 ... 2025-07-07 17:51:00.684354
2776 2025-07-07 ... 2025-07-07 17:51:00.684354
[3 rows x 5 columns]
2025-07-07 17:51:00,709 - IOOppi_data - INFO : save diff data to db: IOOppi_sn_t: no diff data
2025-07-07 17:51:00,714 - IOOppi_data - INFO : save data to db IOOppi_sn_g data:
date value
2772 2025-07-03 268700.0
2773 2025-07-04 267600.0
2774 2025-07-05 267600.0
2775 2025-07-06 267600.0
2776 2025-07-07 266850.0
2025-07-07 17:51:00,774 - IOOppi_data - INFO : save new data to db IOOppi_sn_g: date ... updated_at
2777 2025-07-05 ... 2025-07-07 17:51:00.767801
2778 2025-07-06 ... 2025-07-07 17:51:00.767801
2779 2025-07-07 ... 2025-07-07 17:51:00.767801
[3 rows x 5 columns]
2025-07-07 17:51:00,792 - 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-07 17:51:01,383 - IOOppi_data - INFO : save data to db IOOppi_zn_t data:
date value
3793 2025-07-03 22400.0
3794 2025-07-04 22394.0
3795 2025-07-05 22394.0
3796 2025-07-06 22394.0
3797 2025-07-07 22242.0
2025-07-07 17:51:01,459 - IOOppi_data - INFO : save new data to db IOOppi_zn_t: date value ... created_at updated_at
3795 2025-07-05 22394.0 ... 2025-07-07 17:51:01.451775 2025-07-07 17:51:01.452180
3796 2025-07-06 22394.0 ... 2025-07-07 17:51:01.451775 2025-07-07 17:51:01.452180
3797 2025-07-07 22242.0 ... 2025-07-07 17:51:01.451775 2025-07-07 17:51:01.452180
[3 rows x 5 columns]
2025-07-07 17:51:01,478 - IOOppi_data - INFO : save diff data to db: IOOppi_zn_t: no diff data
2025-07-07 17:51:01,485 - IOOppi_data - INFO : save data to db IOOppi_zn_g data:
date value
3793 2025-07-03 22400.0
3794 2025-07-04 22394.0
3795 2025-07-05 22394.0
3796 2025-07-06 22394.0
3797 2025-07-07 22242.0
2025-07-07 17:51:01,557 - IOOppi_data - INFO : save new data to db IOOppi_zn_g: date value ... created_at updated_at
3798 2025-07-05 22394.0 ... 2025-07-07 17:51:01.549562 2025-07-07 17:51:01.549982
3799 2025-07-06 22394.0 ... 2025-07-07 17:51:01.549562 2025-07-07 17:51:01.549982
3800 2025-07-07 22242.0 ... 2025-07-07 17:51:01.549562 2025-07-07 17:51:01.549982
[3 rows x 5 columns]
2025-07-07 17:51:01,578 - 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-07 17:51:02,141 - IOOppi_data - INFO : save data to db IOOppi_wr_t data:
date value
3756 2025-07-03 3292.5
3757 2025-07-04 3292.5
3758 2025-07-05 3312.5
3759 2025-07-06 3312.5
3760 2025-07-07 3302.5
2025-07-07 17:51:02,220 - IOOppi_data - INFO : save new data to db IOOppi_wr_t: date value ... created_at updated_at
3758 2025-07-05 3312.5 ... 2025-07-07 17:51:02.212483 2025-07-07 17:51:02.212906
3759 2025-07-06 3312.5 ... 2025-07-07 17:51:02.212483 2025-07-07 17:51:02.212906
3760 2025-07-07 3302.5 ... 2025-07-07 17:51:02.212483 2025-07-07 17:51:02.212906
[3 rows x 5 columns]
2025-07-07 17:51:02,239 - IOOppi_data - INFO : save diff data to db: IOOppi_wr_t: no diff data
2025-07-07 17:51:02,245 - IOOppi_data - INFO : save data to db IOOppi_wr_g data:
date value
3756 2025-07-03 3292.5
3757 2025-07-04 3292.5
3758 2025-07-05 3312.5
3759 2025-07-06 3312.5
3760 2025-07-07 3302.5
2025-07-07 17:51:02,318 - IOOppi_data - INFO : save new data to db IOOppi_wr_g: date value ... created_at updated_at
3761 2025-07-05 3312.5 ... 2025-07-07 17:51:02.310328 2025-07-07 17:51:02.310791
3762 2025-07-06 3312.5 ... 2025-07-07 17:51:02.310328 2025-07-07 17:51:02.310791
3763 2025-07-07 3302.5 ... 2025-07-07 17:51:02.310328 2025-07-07 17:51:02.310791
[3 rows x 5 columns]
2025-07-07 17:51:02,336 - 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-07 17:51:02,927 - IOOppi_data - INFO : save data to db IOOppi_pg_t data:
date value
1553 2025-07-03 4947.5
1554 2025-07-04 4972.5
1555 2025-07-05 4972.5
1556 2025-07-06 4972.5
1557 2025-07-07 4935.0
2025-07-07 17:51:02,972 - IOOppi_data - INFO : save new data to db IOOppi_pg_t: date value ... created_at updated_at
1555 2025-07-05 4972.5 ... 2025-07-07 17:51:02.964707 2025-07-07 17:51:02.965130
1556 2025-07-06 4972.5 ... 2025-07-07 17:51:02.964707 2025-07-07 17:51:02.965130
1557 2025-07-07 4935.0 ... 2025-07-07 17:51:02.964707 2025-07-07 17:51:02.965130
[3 rows x 5 columns]
2025-07-07 17:51:02,992 - IOOppi_data - INFO : save diff data to db: IOOppi_pg_t: no diff data
2025-07-07 17:51:02,998 - IOOppi_data - INFO : save data to db IOOppi_pg_g data:
date value
1553 2025-07-03 4947.5
1554 2025-07-04 4972.5
1555 2025-07-05 4972.5
1556 2025-07-06 4972.5
1557 2025-07-07 4935.0
2025-07-07 17:51:03,044 - IOOppi_data - INFO : save new data to db IOOppi_pg_g: date value ... created_at updated_at
1558 2025-07-05 4972.5 ... 2025-07-07 17:51:03.036979 2025-07-07 17:51:03.037363
1559 2025-07-06 4972.5 ... 2025-07-07 17:51:03.036979 2025-07-07 17:51:03.037363
1560 2025-07-07 4935.0 ... 2025-07-07 17:51:03.036979 2025-07-07 17:51:03.037363
[3 rows x 5 columns]
2025-07-07 17:51:03,062 - 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-07 17:51:03,639 - IOOppi_data - INFO : save data to db IOOppi_cs_t data:
date value
2827 2025-07-03 2367.14
2828 2025-07-04 2367.14
2829 2025-07-05 2367.14
2830 2025-07-06 2367.14
2831 2025-07-07 2364.29
2025-07-07 17:51:03,700 - IOOppi_data - INFO : save new data to db IOOppi_cs_t: date value ... created_at updated_at
2829 2025-07-05 2367.14 ... 2025-07-07 17:51:03.692550 2025-07-07 17:51:03.692973
2830 2025-07-06 2367.14 ... 2025-07-07 17:51:03.692550 2025-07-07 17:51:03.692973
2831 2025-07-07 2364.29 ... 2025-07-07 17:51:03.692550 2025-07-07 17:51:03.692973
[3 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-07 17:51:03,740 - IOOppi_data - INFO : save diff data to db IOOppi_cs_t: date ... updated_at
2828 2025-07-04 ... 2025-07-07 17:51:03.733273
[1 rows x 6 columns]
2025-07-07 17:51:03,763 - IOOppi_data - INFO : save data to db IOOppi_cs_g data:
date value
2827 2025-07-03 2367.14
2828 2025-07-04 2367.14
2829 2025-07-05 2367.14
2830 2025-07-06 2367.14
2831 2025-07-07 2364.29
2025-07-07 17:51:03,824 - IOOppi_data - INFO : save new data to db IOOppi_cs_g: date value ... created_at updated_at
2832 2025-07-05 2367.14 ... 2025-07-07 17:51:03.816986 2025-07-07 17:51:03.817365
2833 2025-07-06 2367.14 ... 2025-07-07 17:51:03.816986 2025-07-07 17:51:03.817365
2834 2025-07-07 2364.29 ... 2025-07-07 17:51:03.816986 2025-07-07 17:51:03.817365
[3 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-07 17:51:03,864 - IOOppi_data - INFO : save diff data to db IOOppi_cs_g: date ... updated_at
2831 2025-07-04 ... 2025-07-07 17:51:03.857194
[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-07 17:51:04,437 - IOOppi_data - INFO : save data to db IOOppi_cs_t data:
date value
2827 2025-07-03 2367.14
2828 2025-07-04 2367.14
2829 2025-07-05 2367.14
2830 2025-07-06 2367.14
2831 2025-07-07 2944.00
2025-07-07 17:51:04,488 - 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-07 17:51:04,510 - IOOppi_data - INFO : save diff data to db IOOppi_cs_t: date ... updated_at
2831 2025-07-07 ... 2025-07-07 17:51:04.503509
[1 rows x 6 columns]
2025-07-07 17:51:04,536 - IOOppi_data - INFO : save data to db IOOppi_cs_g data:
date value
2827 2025-07-03 2367.14
2828 2025-07-04 2367.14
2829 2025-07-05 2367.14
2830 2025-07-06 2367.14
2831 2025-07-07 2944.00
2025-07-07 17:51:04,588 - 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-07 17:51:04,610 - IOOppi_data - INFO : save diff data to db IOOppi_cs_g: date ... updated_at
2834 2025-07-07 ... 2025-07-07 17:51:04.603307
[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-07 17:51:05,136 - IOOppi_data - INFO : save data to db IOOppi_RS_t data:
date value
3184 2025-07-03 9775.00
3185 2025-07-04 9755.00
3186 2025-07-05 9755.00
3187 2025-07-06 9755.00
3188 2025-07-07 9703.33
2025-07-07 17:51:05,193 - IOOppi_data - INFO : save new data to db: IOOppi_RS_t: no new data
2025-07-07 17:51:05,193 - IOOppi_data - INFO : save diff data to db: IOOppi_RS_t: no diff data
2025-07-07 17:51:05,198 - IOOppi_data - INFO : save data to db IOOppi_RS_g data:
date value
3184 2025-07-03 9775.00
3185 2025-07-04 9755.00
3186 2025-07-05 9755.00
3187 2025-07-06 9755.00
3188 2025-07-07 9703.33
2025-07-07 17:51:05,255 - IOOppi_data - INFO : save new data to db: IOOppi_RS_g: no new data
2025-07-07 17:51:05,255 - 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-07 17:51:05,800 - IOOppi_data - INFO : save data to db IOOppi_eg_t data:
date value
1868 2025-07-03 4400.0
1869 2025-07-04 4405.0
1870 2025-07-05 4405.0
1871 2025-07-06 4405.0
1872 2025-07-07 4405.0
2025-07-07 17:51:05,848 - IOOppi_data - INFO : save new data to db IOOppi_eg_t: date value ... created_at updated_at
1870 2025-07-05 4405.0 ... 2025-07-07 17:51:05.841282 2025-07-07 17:51:05.841666
1871 2025-07-06 4405.0 ... 2025-07-07 17:51:05.841282 2025-07-07 17:51:05.841666
1872 2025-07-07 4405.0 ... 2025-07-07 17:51:05.841282 2025-07-07 17:51:05.841666
[3 rows x 5 columns]
2025-07-07 17:51:05,867 - IOOppi_data - INFO : save diff data to db: IOOppi_eg_t: no diff data
2025-07-07 17:51:05,873 - IOOppi_data - INFO : save data to db IOOppi_eg_g data:
date value
1868 2025-07-03 4400.0
1869 2025-07-04 4405.0
1870 2025-07-05 4405.0
1871 2025-07-06 4405.0
1872 2025-07-07 4405.0
2025-07-07 17:51:05,922 - IOOppi_data - INFO : save new data to db IOOppi_eg_g: date value ... created_at updated_at
1873 2025-07-05 4405.0 ... 2025-07-07 17:51:05.914648 2025-07-07 17:51:05.915071
1874 2025-07-06 4405.0 ... 2025-07-07 17:51:05.914648 2025-07-07 17:51:05.915071
1875 2025-07-07 4405.0 ... 2025-07-07 17:51:05.914648 2025-07-07 17:51:05.915071
[3 rows x 5 columns]
2025-07-07 17:51:05,940 - 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-07 17:51:06,511 - IOOppi_data - INFO : save data to db IOOppi_sp_t data:
date value
1877 2025-07-03 5950.0
1878 2025-07-04 5950.0
1879 2025-07-05 5950.0
1880 2025-07-06 5950.0
1881 2025-07-07 5950.0
2025-07-07 17:51:06,570 - IOOppi_data - INFO : save new data to db IOOppi_sp_t: date value ... created_at updated_at
1879 2025-07-05 5950.0 ... 2025-07-07 17:51:06.563044 2025-07-07 17:51:06.563434
1880 2025-07-06 5950.0 ... 2025-07-07 17:51:06.563044 2025-07-07 17:51:06.563434
1881 2025-07-07 5950.0 ... 2025-07-07 17:51:06.563044 2025-07-07 17:51:06.563434
[3 rows x 5 columns]
2025-07-07 17:51:06,589 - IOOppi_data - INFO : save diff data to db: IOOppi_sp_t: no diff data
2025-07-07 17:51:06,595 - IOOppi_data - INFO : save data to db IOOppi_sp_g data:
date value
1877 2025-07-03 5950.0
1878 2025-07-04 5950.0
1879 2025-07-05 5950.0
1880 2025-07-06 5950.0
1881 2025-07-07 5950.0
2025-07-07 17:51:06,643 - IOOppi_data - INFO : save new data to db IOOppi_sp_g: date value ... created_at updated_at
1882 2025-07-05 5950.0 ... 2025-07-07 17:51:06.635805 2025-07-07 17:51:06.636191
1883 2025-07-06 5950.0 ... 2025-07-07 17:51:06.635805 2025-07-07 17:51:06.636191
1884 2025-07-07 5950.0 ... 2025-07-07 17:51:06.635805 2025-07-07 17:51:06.636191
[3 rows x 5 columns]
2025-07-07 17:51:06,661 - 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-07 17:51:07,240 - IOOppi_data - INFO : save data to db IOOppi_p_t data:
date value
3545 2025-07-03 8744.0
3546 2025-07-04 8710.0
3547 2025-07-05 8710.0
3548 2025-07-06 8710.0
3549 2025-07-07 8668.0
2025-07-07 17:51:07,309 - IOOppi_data - INFO : save new data to db IOOppi_p_t: date value ... created_at updated_at
3547 2025-07-05 8710.0 ... 2025-07-07 17:51:07.302181 2025-07-07 17:51:07.302563
3548 2025-07-06 8710.0 ... 2025-07-07 17:51:07.302181 2025-07-07 17:51:07.302563
3549 2025-07-07 8668.0 ... 2025-07-07 17:51:07.302181 2025-07-07 17:51:07.302563
[3 rows x 5 columns]
2025-07-07 17:51:07,328 - IOOppi_data - INFO : save diff data to db: IOOppi_p_t: no diff data
2025-07-07 17:51:07,334 - IOOppi_data - INFO : save data to db IOOppi_p_g data:
date value
3545 2025-07-03 8744.0
3546 2025-07-04 8710.0
3547 2025-07-05 8710.0
3548 2025-07-06 8710.0
3549 2025-07-07 8668.0
2025-07-07 17:51:07,404 - IOOppi_data - INFO : save new data to db IOOppi_p_g: date value ... created_at updated_at
3550 2025-07-05 8710.0 ... 2025-07-07 17:51:07.397248 2025-07-07 17:51:07.397667
3551 2025-07-06 8710.0 ... 2025-07-07 17:51:07.397248 2025-07-07 17:51:07.397667
3552 2025-07-07 8668.0 ... 2025-07-07 17:51:07.397248 2025-07-07 17:51:07.397667
[3 rows x 5 columns]
2025-07-07 17:51:07,423 - IOOppi_data - INFO : save diff data to db: IOOppi_p_g: no diff data