=========================================================================
2025-10-06 17:50:26 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-10-06 17:50:29,011 - IOOppi_data - INFO : save data to db IOOppi_rb_t data:
date value
3444 2025-10-02 3168.5
3445 2025-10-03 3168.5
3446 2025-10-04 3168.5
3447 2025-10-05 3168.5
3448 2025-10-06 3168.5
2025-10-06 17:50:29,085 - IOOppi_data - INFO : save new data to db IOOppi_rb_t: date value ... created_at updated_at
3446 2025-10-04 3168.5 ... 2025-10-06 17:50:29.077681 2025-10-06 17:50:29.078132
3447 2025-10-05 3168.5 ... 2025-10-06 17:50:29.077681 2025-10-06 17:50:29.078132
3448 2025-10-06 3168.5 ... 2025-10-06 17:50:29.077681 2025-10-06 17:50:29.078132
[3 rows x 5 columns]
2025-10-06 17:50:29,106 - IOOppi_data - INFO : save diff data to db: IOOppi_rb_t: no diff data
2025-10-06 17:50:29,112 - IOOppi_data - INFO : save data to db IOOppi_rb_g data:
date value
3444 2025-10-02 3168.5
3445 2025-10-03 3168.5
3446 2025-10-04 3168.5
3447 2025-10-05 3168.5
3448 2025-10-06 3168.5
2025-10-06 17:50:29,182 - IOOppi_data - INFO : save new data to db IOOppi_rb_g: date value ... created_at updated_at
3449 2025-10-04 3168.5 ... 2025-10-06 17:50:29.174134 2025-10-06 17:50:29.174529
3450 2025-10-05 3168.5 ... 2025-10-06 17:50:29.174134 2025-10-06 17:50:29.174529
3451 2025-10-06 3168.5 ... 2025-10-06 17:50:29.174134 2025-10-06 17:50:29.174529
[3 rows x 5 columns]
2025-10-06 17:50:29,200 - 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-10-06 17:50:29,789 - IOOppi_data - INFO : save data to db IOOppi_MA_t data:
date value
3665 2025-10-02 2237.5
3666 2025-10-03 2237.5
3667 2025-10-04 2237.5
3668 2025-10-05 2237.5
3669 2025-10-06 2237.5
2025-10-06 17:50:29,861 - IOOppi_data - INFO : save new data to db IOOppi_MA_t: date value ... created_at updated_at
3667 2025-10-04 2237.5 ... 2025-10-06 17:50:29.852937 2025-10-06 17:50:29.853369
3668 2025-10-05 2237.5 ... 2025-10-06 17:50:29.852937 2025-10-06 17:50:29.853369
3669 2025-10-06 2237.5 ... 2025-10-06 17:50:29.852937 2025-10-06 17:50:29.853369
[3 rows x 5 columns]
2025-10-06 17:50:29,880 - IOOppi_data - INFO : save diff data to db: IOOppi_MA_t: no diff data
2025-10-06 17:50:29,891 - IOOppi_data - INFO : save data to db IOOppi_MA_g data:
date value
3665 2025-10-02 2237.5
3666 2025-10-03 2237.5
3667 2025-10-04 2237.5
3668 2025-10-05 2237.5
3669 2025-10-06 2237.5
2025-10-06 17:50:29,981 - IOOppi_data - INFO : save new data to db IOOppi_MA_g: date value ... created_at updated_at
3671 2025-10-04 2237.5 ... 2025-10-06 17:50:29.974299 2025-10-06 17:50:29.974710
3672 2025-10-05 2237.5 ... 2025-10-06 17:50:29.974299 2025-10-06 17:50:29.974710
3673 2025-10-06 2237.5 ... 2025-10-06 17:50:29.974299 2025-10-06 17:50:29.974710
[3 rows x 5 columns]
2025-10-06 17:50:30,000 - 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-10-06 17:50:30,613 - IOOppi_data - INFO : save data to db IOOppi_PTA_t data:
date value
1005 2025-10-02 4595.0
1006 2025-10-03 4595.0
1007 2025-10-04 4595.0
1008 2025-10-05 4595.0
1009 2025-10-06 4595.0
2025-10-06 17:50:30,650 - IOOppi_data - INFO : save new data to db IOOppi_PTA_t: date value ... created_at updated_at
1007 2025-10-04 4595.0 ... 2025-10-06 17:50:30.642818 2025-10-06 17:50:30.643201
1008 2025-10-05 4595.0 ... 2025-10-06 17:50:30.642818 2025-10-06 17:50:30.643201
1009 2025-10-06 4595.0 ... 2025-10-06 17:50:30.642818 2025-10-06 17:50:30.643201
[3 rows x 5 columns]
2025-10-06 17:50:30,669 - IOOppi_data - INFO : save diff data to db: IOOppi_PTA_t: no diff data
2025-10-06 17:50:30,674 - IOOppi_data - INFO : save data to db IOOppi_PTA_g data:
date value
1005 2025-10-02 4595.0
1006 2025-10-03 4595.0
1007 2025-10-04 4595.0
1008 2025-10-05 4595.0
1009 2025-10-06 4595.0
2025-10-06 17:50:30,710 - IOOppi_data - INFO : save new data to db IOOppi_PTA_g: date value ... created_at updated_at
1007 2025-10-04 4595.0 ... 2025-10-06 17:50:30.703416 2025-10-06 17:50:30.703815
1008 2025-10-05 4595.0 ... 2025-10-06 17:50:30.703416 2025-10-06 17:50:30.703815
1009 2025-10-06 4595.0 ... 2025-10-06 17:50:30.703416 2025-10-06 17:50:30.703815
[3 rows x 5 columns]
2025-10-06 17:50:30,729 - 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-10-06 17:50:31,371 - IOOppi_data - INFO : save data to db IOOppi_ru_t data:
date value
3884 2025-10-02 14666.67
3885 2025-10-03 14666.67
3886 2025-10-04 14666.67
3887 2025-10-05 14666.67
3888 2025-10-06 14666.67
2025-10-06 17:50:31,443 - IOOppi_data - INFO : save new data to db IOOppi_ru_t: date ... updated_at
3886 2025-10-04 ... 2025-10-06 17:50:31.437467
3887 2025-10-05 ... 2025-10-06 17:50:31.437467
3888 2025-10-06 ... 2025-10-06 17:50:31.437467
[3 rows x 5 columns]
2025-10-06 17:50:31,463 - IOOppi_data - INFO : save diff data to db: IOOppi_ru_t: no diff data
2025-10-06 17:50:31,469 - IOOppi_data - INFO : save data to db IOOppi_ru_g data:
date value
3884 2025-10-02 14666.67
3885 2025-10-03 14666.67
3886 2025-10-04 14666.67
3887 2025-10-05 14666.67
3888 2025-10-06 14666.67
2025-10-06 17:50:31,541 - IOOppi_data - INFO : save new data to db IOOppi_ru_g: date ... updated_at
3889 2025-10-04 ... 2025-10-06 17:50:31.534971
3890 2025-10-05 ... 2025-10-06 17:50:31.534971
3891 2025-10-06 ... 2025-10-06 17:50:31.534971
[3 rows x 5 columns]
2025-10-06 17:50:31,560 - 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-10-06 17:50:32,148 - IOOppi_data - INFO : save data to db IOOppi_i_t data:
date value
3216 2025-10-02 792.22
3217 2025-10-03 792.22
3218 2025-10-04 792.22
3219 2025-10-05 792.22
3220 2025-10-06 792.22
2025-10-06 17:50:32,212 - IOOppi_data - INFO : save new data to db IOOppi_i_t: date value ... created_at updated_at
3218 2025-10-04 792.22 ... 2025-10-06 17:50:32.205054 2025-10-06 17:50:32.205436
3219 2025-10-05 792.22 ... 2025-10-06 17:50:32.205054 2025-10-06 17:50:32.205436
3220 2025-10-06 792.22 ... 2025-10-06 17:50:32.205054 2025-10-06 17:50:32.205436
[3 rows x 5 columns]
2025-10-06 17:50:32,232 - IOOppi_data - INFO : save diff data to db: IOOppi_i_t: no diff data
2025-10-06 17:50:32,237 - IOOppi_data - INFO : save data to db IOOppi_i_g data:
date value
3216 2025-10-02 792.22
3217 2025-10-03 792.22
3218 2025-10-04 792.22
3219 2025-10-05 792.22
3220 2025-10-06 792.22
2025-10-06 17:50:32,301 - IOOppi_data - INFO : save new data to db IOOppi_i_g: date value ... created_at updated_at
3221 2025-10-04 792.22 ... 2025-10-06 17:50:32.294374 2025-10-06 17:50:32.294781
3222 2025-10-05 792.22 ... 2025-10-06 17:50:32.294374 2025-10-06 17:50:32.294781
3223 2025-10-06 792.22 ... 2025-10-06 17:50:32.294374 2025-10-06 17:50:32.294781
[3 rows x 5 columns]
2025-10-06 17:50:32,320 - 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-10-06 17:50:32,932 - IOOppi_data - INFO : save data to db IOOppi_FG_t data:
date value
3419 2025-10-02 1248.0
3420 2025-10-03 1248.0
3421 2025-10-04 1248.0
3422 2025-10-05 1248.0
3423 2025-10-06 1248.0
2025-10-06 17:50:33,000 - IOOppi_data - INFO : save new data to db IOOppi_FG_t: date value ... created_at updated_at
3421 2025-10-04 1248.0 ... 2025-10-06 17:50:32.992622 2025-10-06 17:50:32.993040
3422 2025-10-05 1248.0 ... 2025-10-06 17:50:32.992622 2025-10-06 17:50:32.993040
3423 2025-10-06 1248.0 ... 2025-10-06 17:50:32.992622 2025-10-06 17:50:32.993040
[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-10-06 17:50:34,936 - IOOppi_data - INFO : save diff data to db IOOppi_FG_t: date ... updated_at
12 2012-12-19 ... 2025-10-06 17:50:34.929156
21 2013-01-04 ... 2025-10-06 17:50:34.929156
54 2013-02-27 ... 2025-10-06 17:50:34.929156
60 2013-03-07 ... 2025-10-06 17:50:34.929156
61 2013-03-08 ... 2025-10-06 17:50:34.929156
[5 rows x 6 columns]
2025-10-06 17:50:35,091 - IOOppi_data - INFO : save data to db IOOppi_FG_g data:
date value
3419 2025-10-02 1248.0
3420 2025-10-03 1248.0
3421 2025-10-04 1248.0
3422 2025-10-05 1248.0
3423 2025-10-06 1248.0
2025-10-06 17:50:35,160 - IOOppi_data - INFO : save new data to db IOOppi_FG_g: date value ... created_at updated_at
3425 2025-10-04 1248.0 ... 2025-10-06 17:50:35.152847 2025-10-06 17:50:35.153234
3426 2025-10-05 1248.0 ... 2025-10-06 17:50:35.152847 2025-10-06 17:50:35.153234
3427 2025-10-06 1248.0 ... 2025-10-06 17:50:35.152847 2025-10-06 17:50:35.153234
[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-10-06 17:50:37,097 - IOOppi_data - INFO : save diff data to db IOOppi_FG_g: date ... updated_at
12 2012-12-19 ... 2025-10-06 17:50:37.089957
21 2013-01-04 ... 2025-10-06 17:50:37.089957
54 2013-02-27 ... 2025-10-06 17:50:37.089957
60 2013-03-07 ... 2025-10-06 17:50:37.089957
61 2013-03-08 ... 2025-10-06 17:50:37.089957
[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-10-06 17:50:37,942 - IOOppi_data - INFO : save data to db IOOppi_eb_t data:
date value
1764 2025-10-02 7120.0
1765 2025-10-03 7120.0
1766 2025-10-04 7120.0
1767 2025-10-05 7120.0
1768 2025-10-06 7120.0
2025-10-06 17:50:37,989 - IOOppi_data - INFO : save new data to db IOOppi_eb_t: date value ... created_at updated_at
1766 2025-10-04 7120.0 ... 2025-10-06 17:50:37.982236 2025-10-06 17:50:37.982665
1767 2025-10-05 7120.0 ... 2025-10-06 17:50:37.982236 2025-10-06 17:50:37.982665
1768 2025-10-06 7120.0 ... 2025-10-06 17:50:37.982236 2025-10-06 17:50:37.982665
[3 rows x 5 columns]
2025-10-06 17:50:38,008 - IOOppi_data - INFO : save diff data to db: IOOppi_eb_t: no diff data
2025-10-06 17:50:38,014 - IOOppi_data - INFO : save data to db IOOppi_eb_g data:
date value
1764 2025-10-02 7120.0
1765 2025-10-03 7120.0
1766 2025-10-04 7120.0
1767 2025-10-05 7120.0
1768 2025-10-06 7120.0
2025-10-06 17:50:38,061 - IOOppi_data - INFO : save new data to db IOOppi_eb_g: date value ... created_at updated_at
1769 2025-10-04 7120.0 ... 2025-10-06 17:50:38.054040 2025-10-06 17:50:38.054419
1770 2025-10-05 7120.0 ... 2025-10-06 17:50:38.054040 2025-10-06 17:50:38.054419
1771 2025-10-06 7120.0 ... 2025-10-06 17:50:38.054040 2025-10-06 17:50:38.054419
[3 rows x 5 columns]
2025-10-06 17:50:38,079 - 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-10-06 17:50:38,995 - IOOppi_data - INFO : save data to db IOOppi_SR_t data:
date value
3875 2025-10-02 5813.33
3876 2025-10-03 5813.33
3877 2025-10-04 5813.33
3878 2025-10-05 5813.33
3879 2025-10-06 5813.33
2025-10-06 17:50:39,068 - IOOppi_data - INFO : save new data to db IOOppi_SR_t: date value ... created_at updated_at
3877 2025-10-04 5813.33 ... 2025-10-06 17:50:39.061130 2025-10-06 17:50:39.061514
3878 2025-10-05 5813.33 ... 2025-10-06 17:50:39.061130 2025-10-06 17:50:39.061514
3879 2025-10-06 5813.33 ... 2025-10-06 17:50:39.061130 2025-10-06 17:50:39.061514
[3 rows x 5 columns]
2025-10-06 17:50:39,087 - IOOppi_data - INFO : save diff data to db: IOOppi_SR_t: no diff data
2025-10-06 17:50:39,094 - IOOppi_data - INFO : save data to db IOOppi_SR_g data:
date value
3875 2025-10-02 5813.33
3876 2025-10-03 5813.33
3877 2025-10-04 5813.33
3878 2025-10-05 5813.33
3879 2025-10-06 5813.33
2025-10-06 17:50:39,171 - IOOppi_data - INFO : save new data to db IOOppi_SR_g: date value ... created_at updated_at
3881 2025-10-04 5813.33 ... 2025-10-06 17:50:39.163035 2025-10-06 17:50:39.163484
3882 2025-10-05 5813.33 ... 2025-10-06 17:50:39.163035 2025-10-06 17:50:39.163484
3883 2025-10-06 5813.33 ... 2025-10-06 17:50:39.163035 2025-10-06 17:50:39.163484
[3 rows x 5 columns]
2025-10-06 17:50:39,190 - 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-10-06 17:50:39,867 - IOOppi_data - INFO : save data to db IOOppi_ss_t data:
date value
1765 2025-10-02 13055.0
1766 2025-10-03 13055.0
1767 2025-10-04 13055.0
1768 2025-10-05 13055.0
1769 2025-10-06 13055.0
2025-10-06 17:50:39,913 - IOOppi_data - INFO : save new data to db IOOppi_ss_t: date value ... created_at updated_at
1767 2025-10-04 13055.0 ... 2025-10-06 17:50:39.906429 2025-10-06 17:50:39.906839
1768 2025-10-05 13055.0 ... 2025-10-06 17:50:39.906429 2025-10-06 17:50:39.906839
1769 2025-10-06 13055.0 ... 2025-10-06 17:50:39.906429 2025-10-06 17:50:39.906839
[3 rows x 5 columns]
2025-10-06 17:50:39,932 - IOOppi_data - INFO : save diff data to db: IOOppi_ss_t: no diff data
2025-10-06 17:50:39,937 - IOOppi_data - INFO : save data to db IOOppi_ss_g data:
date value
1765 2025-10-02 13055.0
1766 2025-10-03 13055.0
1767 2025-10-04 13055.0
1768 2025-10-05 13055.0
1769 2025-10-06 13055.0
2025-10-06 17:50:39,984 - IOOppi_data - INFO : save new data to db IOOppi_ss_g: date value ... created_at updated_at
1770 2025-10-04 13055.0 ... 2025-10-06 17:50:39.977398 2025-10-06 17:50:39.977804
1771 2025-10-05 13055.0 ... 2025-10-06 17:50:39.977398 2025-10-06 17:50:39.977804
1772 2025-10-06 13055.0 ... 2025-10-06 17:50:39.977398 2025-10-06 17:50:39.977804
[3 rows x 5 columns]
2025-10-06 17:50:40,002 - 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-10-06 17:50:40,683 - IOOppi_data - INFO : save data to db IOOppi_RS_t data:
date value
3275 2025-10-02 10175.0
3276 2025-10-03 10175.0
3277 2025-10-04 10175.0
3278 2025-10-05 10175.0
3279 2025-10-06 10175.0
2025-10-06 17:50:40,747 - IOOppi_data - INFO : save new data to db IOOppi_RS_t: date value ... created_at updated_at
3277 2025-10-04 10175.0 ... 2025-10-06 17:50:40.740437 2025-10-06 17:50:40.740847
3278 2025-10-05 10175.0 ... 2025-10-06 17:50:40.740437 2025-10-06 17:50:40.740847
3279 2025-10-06 10175.0 ... 2025-10-06 17:50:40.740437 2025-10-06 17:50:40.740847
[3 rows x 5 columns]
2025-10-06 17:50:40,767 - IOOppi_data - INFO : save diff data to db: IOOppi_RS_t: no diff data
2025-10-06 17:50:40,773 - IOOppi_data - INFO : save data to db IOOppi_RS_g data:
date value
3275 2025-10-02 10175.0
3276 2025-10-03 10175.0
3277 2025-10-04 10175.0
3278 2025-10-05 10175.0
3279 2025-10-06 10175.0
2025-10-06 17:50:40,838 - IOOppi_data - INFO : save new data to db IOOppi_RS_g: date value ... created_at updated_at
3281 2025-10-04 10175.0 ... 2025-10-06 17:50:40.830948 2025-10-06 17:50:40.831325
3282 2025-10-05 10175.0 ... 2025-10-06 17:50:40.830948 2025-10-06 17:50:40.831325
3283 2025-10-06 10175.0 ... 2025-10-06 17:50:40.830948 2025-10-06 17:50:40.831325
[3 rows x 5 columns]
2025-10-06 17:50:40,856 - 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-10-06 17:50:41,634 - IOOppi_data - INFO : save data to db IOOppi_RM_t data:
date value
3398 2025-10-02 2536.67
3399 2025-10-03 2536.67
3400 2025-10-04 2536.67
3401 2025-10-05 2536.67
3402 2025-10-06 2536.67
2025-10-06 17:50:41,700 - IOOppi_data - INFO : save new data to db IOOppi_RM_t: date value ... created_at updated_at
3400 2025-10-04 2536.67 ... 2025-10-06 17:50:41.692949 2025-10-06 17:50:41.693326
3401 2025-10-05 2536.67 ... 2025-10-06 17:50:41.692949 2025-10-06 17:50:41.693326
3402 2025-10-06 2536.67 ... 2025-10-06 17:50:41.692949 2025-10-06 17:50:41.693326
[3 rows x 5 columns]
2025-10-06 17:50:41,718 - IOOppi_data - INFO : save diff data to db: IOOppi_RM_t: no diff data
2025-10-06 17:50:41,726 - IOOppi_data - INFO : save data to db IOOppi_RM_g data:
date value
3398 2025-10-02 2536.67
3399 2025-10-03 2536.67
3400 2025-10-04 2536.67
3401 2025-10-05 2536.67
3402 2025-10-06 2536.67
2025-10-06 17:50:41,793 - IOOppi_data - INFO : save new data to db IOOppi_RM_g: date value ... created_at updated_at
3404 2025-10-04 2536.67 ... 2025-10-06 17:50:41.786439 2025-10-06 17:50:41.786855
3405 2025-10-05 2536.67 ... 2025-10-06 17:50:41.786439 2025-10-06 17:50:41.786855
3406 2025-10-06 2536.67 ... 2025-10-06 17:50:41.786439 2025-10-06 17:50:41.786855
[3 rows x 5 columns]
2025-10-06 17:50:41,812 - 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-10-06 17:50:42,444 - IOOppi_data - INFO : save data to db IOOppi_SA_t data:
date value
1602 2025-10-02 1262.5
1603 2025-10-03 1262.5
1604 2025-10-04 1262.5
1605 2025-10-05 1262.5
1606 2025-10-06 1262.5
2025-10-06 17:50:42,492 - IOOppi_data - INFO : save new data to db IOOppi_SA_t: date value ... created_at updated_at
1604 2025-10-04 1262.5 ... 2025-10-06 17:50:42.484795 2025-10-06 17:50:42.485188
1605 2025-10-05 1262.5 ... 2025-10-06 17:50:42.484795 2025-10-06 17:50:42.485188
1606 2025-10-06 1262.5 ... 2025-10-06 17:50:42.484795 2025-10-06 17:50:42.485188
[3 rows x 5 columns]
2025-10-06 17:50:42,511 - IOOppi_data - INFO : save diff data to db: IOOppi_SA_t: no diff data
2025-10-06 17:50:42,517 - IOOppi_data - INFO : save data to db IOOppi_SA_g data:
date value
1602 2025-10-02 1262.5
1603 2025-10-03 1262.5
1604 2025-10-04 1262.5
1605 2025-10-05 1262.5
1606 2025-10-06 1262.5
2025-10-06 17:50:42,563 - IOOppi_data - INFO : save new data to db IOOppi_SA_g: date value ... created_at updated_at
1608 2025-10-04 1262.5 ... 2025-10-06 17:50:42.555890 2025-10-06 17:50:42.556285
1609 2025-10-05 1262.5 ... 2025-10-06 17:50:42.555890 2025-10-06 17:50:42.556285
1610 2025-10-06 1262.5 ... 2025-10-06 17:50:42.555890 2025-10-06 17:50:42.556285
[3 rows x 5 columns]
2025-10-06 17:50:42,581 - 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-10-06 17:50:43,249 - IOOppi_data - INFO : save data to db IOOppi_PF_t data:
date value
1515 2025-10-02 6416.33
1516 2025-10-03 6416.33
1517 2025-10-04 6416.33
1518 2025-10-05 6416.33
1519 2025-10-06 6416.33
2025-10-06 17:50:43,300 - IOOppi_data - INFO : save new data to db IOOppi_PF_t: date value ... created_at updated_at
1517 2025-10-04 6416.33 ... 2025-10-06 17:50:43.289731 2025-10-06 17:50:43.290341
1518 2025-10-05 6416.33 ... 2025-10-06 17:50:43.289731 2025-10-06 17:50:43.290341
1519 2025-10-06 6416.33 ... 2025-10-06 17:50:43.289731 2025-10-06 17:50:43.290341
[3 rows x 5 columns]
2025-10-06 17:50:43,322 - IOOppi_data - INFO : save diff data to db: IOOppi_PF_t: no diff data
2025-10-06 17:50:43,327 - IOOppi_data - INFO : save data to db IOOppi_PF_g data:
date value
1515 2025-10-02 6416.33
1516 2025-10-03 6416.33
1517 2025-10-04 6416.33
1518 2025-10-05 6416.33
1519 2025-10-06 6416.33
2025-10-06 17:50:43,371 - IOOppi_data - INFO : save new data to db IOOppi_PF_g: date value ... created_at updated_at
1521 2025-10-04 6416.33 ... 2025-10-06 17:50:43.363779 2025-10-06 17:50:43.364157
1522 2025-10-05 6416.33 ... 2025-10-06 17:50:43.363779 2025-10-06 17:50:43.364157
1523 2025-10-06 6416.33 ... 2025-10-06 17:50:43.363779 2025-10-06 17:50:43.364157
[3 rows x 5 columns]
2025-10-06 17:50:43,390 - 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-10-06 17:50:44,169 - IOOppi_data - INFO : save data to db IOOppi_m_t data:
date value
3888 2025-10-02 2988.0
3889 2025-10-03 2988.0
3890 2025-10-04 2988.0
3891 2025-10-05 2988.0
3892 2025-10-06 2988.0
2025-10-06 17:50:44,242 - IOOppi_data - INFO : save new data to db IOOppi_m_t: date value ... created_at updated_at
3890 2025-10-04 2988.0 ... 2025-10-06 17:50:44.235144 2025-10-06 17:50:44.235527
3891 2025-10-05 2988.0 ... 2025-10-06 17:50:44.235144 2025-10-06 17:50:44.235527
3892 2025-10-06 2988.0 ... 2025-10-06 17:50:44.235144 2025-10-06 17:50:44.235527
[3 rows x 5 columns]
2025-10-06 17:50:44,260 - IOOppi_data - INFO : save diff data to db: IOOppi_m_t: no diff data
2025-10-06 17:50:44,267 - IOOppi_data - INFO : save data to db IOOppi_m_g data:
date value
3888 2025-10-02 2988.0
3889 2025-10-03 2988.0
3890 2025-10-04 2988.0
3891 2025-10-05 2988.0
3892 2025-10-06 2988.0
2025-10-06 17:50:44,342 - IOOppi_data - INFO : save new data to db IOOppi_m_g: date value ... created_at updated_at
3893 2025-10-04 2988.0 ... 2025-10-06 17:50:44.333980 2025-10-06 17:50:44.334583
3894 2025-10-05 2988.0 ... 2025-10-06 17:50:44.333980 2025-10-06 17:50:44.334583
3895 2025-10-06 2988.0 ... 2025-10-06 17:50:44.333980 2025-10-06 17:50:44.334583
[3 rows x 5 columns]
2025-10-06 17:50:44,360 - 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-10-06 17:50:44,996 - IOOppi_data - INFO : save data to db IOOppi_y_t data:
date value
3658 2025-10-02 8218.0
3659 2025-10-03 8218.0
3660 2025-10-04 8218.0
3661 2025-10-05 8218.0
3662 2025-10-06 8218.0
2025-10-06 17:50:45,065 - IOOppi_data - INFO : save new data to db IOOppi_y_t: date value ... created_at updated_at
3660 2025-10-04 8218.0 ... 2025-10-06 17:50:45.058186 2025-10-06 17:50:45.058600
3661 2025-10-05 8218.0 ... 2025-10-06 17:50:45.058186 2025-10-06 17:50:45.058600
3662 2025-10-06 8218.0 ... 2025-10-06 17:50:45.058186 2025-10-06 17:50:45.058600
[3 rows x 5 columns]
2025-10-06 17:50:45,085 - IOOppi_data - INFO : save diff data to db: IOOppi_y_t: no diff data
2025-10-06 17:50:45,091 - IOOppi_data - INFO : save data to db IOOppi_y_g data:
date value
3658 2025-10-02 8218.0
3659 2025-10-03 8218.0
3660 2025-10-04 8218.0
3661 2025-10-05 8218.0
3662 2025-10-06 8218.0
2025-10-06 17:50:45,161 - IOOppi_data - INFO : save new data to db IOOppi_y_g: date value ... created_at updated_at
3663 2025-10-04 8218.0 ... 2025-10-06 17:50:45.153786 2025-10-06 17:50:45.154176
3664 2025-10-05 8218.0 ... 2025-10-06 17:50:45.153786 2025-10-06 17:50:45.154176
3665 2025-10-06 8218.0 ... 2025-10-06 17:50:45.153786 2025-10-06 17:50:45.154176
[3 rows x 5 columns]
2025-10-06 17:50:45,179 - 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-10-06 17:50:45,816 - IOOppi_data - INFO : save data to db IOOppi_a_t data:
date value
3624 2025-10-02 4285.0
3625 2025-10-03 4285.0
3626 2025-10-04 4285.0
3627 2025-10-05 4285.0
3628 2025-10-06 4285.0
2025-10-06 17:50:45,885 - IOOppi_data - INFO : save new data to db IOOppi_a_t: date value ... created_at updated_at
3626 2025-10-04 4285.0 ... 2025-10-06 17:50:45.877598 2025-10-06 17:50:45.877994
3627 2025-10-05 4285.0 ... 2025-10-06 17:50:45.877598 2025-10-06 17:50:45.877994
3628 2025-10-06 4285.0 ... 2025-10-06 17:50:45.877598 2025-10-06 17:50:45.877994
[3 rows x 5 columns]
2025-10-06 17:50:45,903 - IOOppi_data - INFO : save diff data to db: IOOppi_a_t: no diff data
2025-10-06 17:50:45,909 - IOOppi_data - INFO : save data to db IOOppi_a_g data:
date value
3624 2025-10-02 4285.0
3625 2025-10-03 4285.0
3626 2025-10-04 4285.0
3627 2025-10-05 4285.0
3628 2025-10-06 4285.0
2025-10-06 17:50:45,978 - IOOppi_data - INFO : save new data to db IOOppi_a_g: date value ... created_at updated_at
3629 2025-10-04 4285.0 ... 2025-10-06 17:50:45.971007 2025-10-06 17:50:45.971386
3630 2025-10-05 4285.0 ... 2025-10-06 17:50:45.971007 2025-10-06 17:50:45.971386
3631 2025-10-06 4285.0 ... 2025-10-06 17:50:45.971007 2025-10-06 17:50:45.971386
[3 rows x 5 columns]
2025-10-06 17:50:45,996 - 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-10-06 17:50:46,638 - IOOppi_data - INFO : save data to db IOOppi_SF_t data:
date value
3001 2025-10-02 5241.43
3002 2025-10-03 5241.43
3003 2025-10-04 5241.43
3004 2025-10-05 5241.43
3005 2025-10-06 5241.43
2025-10-06 17:50:46,704 - IOOppi_data - INFO : save new data to db IOOppi_SF_t: date value ... created_at updated_at
3003 2025-10-04 5241.43 ... 2025-10-06 17:50:46.694294 2025-10-06 17:50:46.694716
3004 2025-10-05 5241.43 ... 2025-10-06 17:50:46.694294 2025-10-06 17:50:46.694716
3005 2025-10-06 5241.43 ... 2025-10-06 17:50:46.694294 2025-10-06 17:50:46.694716
[3 rows x 5 columns]
2025-10-06 17:50:46,723 - IOOppi_data - INFO : save diff data to db: IOOppi_SF_t: no diff data
2025-10-06 17:50:46,729 - IOOppi_data - INFO : save data to db IOOppi_SF_g data:
date value
3001 2025-10-02 5241.43
3002 2025-10-03 5241.43
3003 2025-10-04 5241.43
3004 2025-10-05 5241.43
3005 2025-10-06 5241.43
2025-10-06 17:50:46,793 - IOOppi_data - INFO : save new data to db IOOppi_SF_g: date value ... created_at updated_at
3007 2025-10-04 5241.43 ... 2025-10-06 17:50:46.785825 2025-10-06 17:50:46.786229
3008 2025-10-05 5241.43 ... 2025-10-06 17:50:46.785825 2025-10-06 17:50:46.786229
3009 2025-10-06 5241.43 ... 2025-10-06 17:50:46.785825 2025-10-06 17:50:46.786229
[3 rows x 5 columns]
2025-10-06 17:50:46,812 - 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-10-06 17:50:47,589 - IOOppi_data - INFO : save data to db IOOppi_jd_t data:
date value
3201 2025-10-02 3635.0
3202 2025-10-03 3635.0
3203 2025-10-04 3635.0
3204 2025-10-05 3635.0
3205 2025-10-06 3635.0
2025-10-06 17:50:47,653 - IOOppi_data - INFO : save new data to db IOOppi_jd_t: date value ... created_at updated_at
3203 2025-10-04 3635.0 ... 2025-10-06 17:50:47.645703 2025-10-06 17:50:47.646093
3204 2025-10-05 3635.0 ... 2025-10-06 17:50:47.645703 2025-10-06 17:50:47.646093
3205 2025-10-06 3635.0 ... 2025-10-06 17:50:47.645703 2025-10-06 17:50:47.646093
[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-10-06 17:50:47,797 - IOOppi_data - INFO : save diff data to db IOOppi_jd_t: date ... updated_at
39 2014-01-03 ... 2025-10-06 17:50:47.789507
458 2015-09-21 ... 2025-10-06 17:50:47.789507
549 2016-02-03 ... 2025-10-06 17:50:47.789507
693 2016-09-05 ... 2025-10-06 17:50:47.789507
696 2016-09-08 ... 2025-10-06 17:50:47.789507
[5 rows x 6 columns]
2025-10-06 17:50:47,826 - IOOppi_data - INFO : save data to db IOOppi_jd_g data:
date value
3201 2025-10-02 3635.0
3202 2025-10-03 3635.0
3203 2025-10-04 3635.0
3204 2025-10-05 3635.0
3205 2025-10-06 3635.0
2025-10-06 17:50:47,897 - IOOppi_data - INFO : save new data to db IOOppi_jd_g: date value ... created_at updated_at
3206 2025-10-04 3635.0 ... 2025-10-06 17:50:47.889753 2025-10-06 17:50:47.890215
3207 2025-10-05 3635.0 ... 2025-10-06 17:50:47.889753 2025-10-06 17:50:47.890215
3208 2025-10-06 3635.0 ... 2025-10-06 17:50:47.889753 2025-10-06 17:50:47.890215
[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-10-06 17:50:48,042 - IOOppi_data - INFO : save diff data to db IOOppi_jd_g: date ... updated_at
39 2014-01-03 ... 2025-10-06 17:50:48.034472
458 2015-09-21 ... 2025-10-06 17:50:48.034472
549 2016-02-03 ... 2025-10-06 17:50:48.034472
693 2016-09-05 ... 2025-10-06 17:50:48.034472
696 2016-09-08 ... 2025-10-06 17:50:48.034472
[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-10-06 17:50:48,733 - IOOppi_data - INFO : save data to db IOOppi_SI_t data:
date value
1005 2025-10-02 9710.0
1006 2025-10-03 9710.0
1007 2025-10-04 9710.0
1008 2025-10-05 9710.0
1009 2025-10-06 9710.0
2025-10-06 17:50:48,771 - IOOppi_data - INFO : save new data to db IOOppi_SI_t: date value ... created_at updated_at
1007 2025-10-04 9710.0 ... 2025-10-06 17:50:48.763904 2025-10-06 17:50:48.764295
1008 2025-10-05 9710.0 ... 2025-10-06 17:50:48.763904 2025-10-06 17:50:48.764295
1009 2025-10-06 9710.0 ... 2025-10-06 17:50:48.763904 2025-10-06 17:50:48.764295
[3 rows x 5 columns]
2025-10-06 17:50:48,790 - IOOppi_data - INFO : save diff data to db: IOOppi_SI_t: no diff data
2025-10-06 17:50:48,795 - IOOppi_data - INFO : save data to db IOOppi_SI_g data:
date value
1005 2025-10-02 9710.0
1006 2025-10-03 9710.0
1007 2025-10-04 9710.0
1008 2025-10-05 9710.0
1009 2025-10-06 9710.0
2025-10-06 17:50:48,831 - IOOppi_data - INFO : save new data to db IOOppi_SI_g: date value ... created_at updated_at
1007 2025-10-04 9710.0 ... 2025-10-06 17:50:48.824606 2025-10-06 17:50:48.824983
1008 2025-10-05 9710.0 ... 2025-10-06 17:50:48.824606 2025-10-06 17:50:48.824983
1009 2025-10-06 9710.0 ... 2025-10-06 17:50:48.824606 2025-10-06 17:50:48.824983
[3 rows x 5 columns]
2025-10-06 17:50:48,850 - 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-10-06 17:50:49,461 - IOOppi_data - INFO : save data to db IOOppi_l_t data:
date value
3884 2025-10-02 7240.0
3885 2025-10-03 7240.0
3886 2025-10-04 7240.0
3887 2025-10-05 7240.0
3888 2025-10-06 7240.0
2025-10-06 17:50:49,533 - IOOppi_data - INFO : save new data to db IOOppi_l_t: date value ... created_at updated_at
3886 2025-10-04 7240.0 ... 2025-10-06 17:50:49.525978 2025-10-06 17:50:49.526363
3887 2025-10-05 7240.0 ... 2025-10-06 17:50:49.525978 2025-10-06 17:50:49.526363
3888 2025-10-06 7240.0 ... 2025-10-06 17:50:49.525978 2025-10-06 17:50:49.526363
[3 rows x 5 columns]
2025-10-06 17:50:49,551 - IOOppi_data - INFO : save diff data to db: IOOppi_l_t: no diff data
2025-10-06 17:50:49,558 - IOOppi_data - INFO : save data to db IOOppi_l_g data:
date value
3884 2025-10-02 7240.0
3885 2025-10-03 7240.0
3886 2025-10-04 7240.0
3887 2025-10-05 7240.0
3888 2025-10-06 7240.0
2025-10-06 17:50:49,631 - IOOppi_data - INFO : save new data to db IOOppi_l_g: date value ... created_at updated_at
3889 2025-10-04 7240.0 ... 2025-10-06 17:50:49.624147 2025-10-06 17:50:49.624532
3890 2025-10-05 7240.0 ... 2025-10-06 17:50:49.624147 2025-10-06 17:50:49.624532
3891 2025-10-06 7240.0 ... 2025-10-06 17:50:49.624147 2025-10-06 17:50:49.624532
[3 rows x 5 columns]
2025-10-06 17:50:49,650 - 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-10-06 17:50:50,279 - IOOppi_data - INFO : save data to db IOOppi_bu_t data:
date value
3222 2025-10-02 3583.33
3223 2025-10-03 3583.33
3224 2025-10-04 3583.33
3225 2025-10-05 3583.33
3226 2025-10-06 3583.33
2025-10-06 17:50:50,344 - IOOppi_data - INFO : save new data to db IOOppi_bu_t: date value ... created_at updated_at
3225 2025-10-04 3583.33 ... 2025-10-06 17:50:50.336899 2025-10-06 17:50:50.337283
3226 2025-10-05 3583.33 ... 2025-10-06 17:50:50.336899 2025-10-06 17:50:50.337283
3227 2025-10-06 3583.33 ... 2025-10-06 17:50:50.336899 2025-10-06 17:50:50.337283
[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-10-06 17:50:50,380 - IOOppi_data - INFO : save diff data to db IOOppi_bu_t: date ... updated_at
2560 2023-12-09 ... 2025-10-06 17:50:50.372960
[1 rows x 6 columns]
2025-10-06 17:50:50,403 - IOOppi_data - INFO : save data to db IOOppi_bu_g data:
date value
3222 2025-10-02 3583.33
3223 2025-10-03 3583.33
3224 2025-10-04 3583.33
3225 2025-10-05 3583.33
3226 2025-10-06 3583.33
2025-10-06 17:50:50,469 - IOOppi_data - INFO : save new data to db IOOppi_bu_g: date value ... created_at updated_at
3227 2025-10-04 3583.33 ... 2025-10-06 17:50:50.461830 2025-10-06 17:50:50.462213
3228 2025-10-05 3583.33 ... 2025-10-06 17:50:50.461830 2025-10-06 17:50:50.462213
3229 2025-10-06 3583.33 ... 2025-10-06 17:50:50.461830 2025-10-06 17:50:50.462213
[3 rows x 5 columns]
2025-10-06 17:50:50,487 - 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-10-06 17:50:51,120 - IOOppi_data - INFO : save data to db IOOppi_al_t data:
date value
3887 2025-10-02 20733.33
3888 2025-10-03 20733.33
3889 2025-10-04 20733.33
3890 2025-10-05 20733.33
3891 2025-10-06 20733.33
2025-10-06 17:50:51,191 - IOOppi_data - INFO : save new data to db IOOppi_al_t: date ... updated_at
3889 2025-10-04 ... 2025-10-06 17:50:51.184745
3890 2025-10-05 ... 2025-10-06 17:50:51.184745
3891 2025-10-06 ... 2025-10-06 17:50:51.184745
[3 rows x 5 columns]
2025-10-06 17:50:51,210 - IOOppi_data - INFO : save diff data to db: IOOppi_al_t: no diff data
2025-10-06 17:50:51,216 - IOOppi_data - INFO : save data to db IOOppi_al_g data:
date value
3887 2025-10-02 20733.33
3888 2025-10-03 20733.33
3889 2025-10-04 20733.33
3890 2025-10-05 20733.33
3891 2025-10-06 20733.33
2025-10-06 17:50:51,305 - IOOppi_data - INFO : save new data to db IOOppi_al_g: date ... updated_at
3892 2025-10-04 ... 2025-10-06 17:50:51.298663
3893 2025-10-05 ... 2025-10-06 17:50:51.298663
3894 2025-10-06 ... 2025-10-06 17:50:51.298663
[3 rows x 5 columns]
2025-10-06 17:50:51,323 - 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-10-06 17:50:52,074 - IOOppi_data - INFO : save data to db IOOppi_SM_t data:
date value
3001 2025-10-02 5656.0
3002 2025-10-03 5656.0
3003 2025-10-04 5656.0
3004 2025-10-05 5656.0
3005 2025-10-06 5656.0
2025-10-06 17:50:52,137 - IOOppi_data - INFO : save new data to db IOOppi_SM_t: date value ... created_at updated_at
3003 2025-10-04 5656.0 ... 2025-10-06 17:50:52.130091 2025-10-06 17:50:52.130468
3004 2025-10-05 5656.0 ... 2025-10-06 17:50:52.130091 2025-10-06 17:50:52.130468
3005 2025-10-06 5656.0 ... 2025-10-06 17:50:52.130091 2025-10-06 17:50:52.130468
[3 rows x 5 columns]
2025-10-06 17:50:52,155 - IOOppi_data - INFO : save diff data to db: IOOppi_SM_t: no diff data
2025-10-06 17:50:52,161 - IOOppi_data - INFO : save data to db IOOppi_SM_g data:
date value
3001 2025-10-02 5656.0
3002 2025-10-03 5656.0
3003 2025-10-04 5656.0
3004 2025-10-05 5656.0
3005 2025-10-06 5656.0
2025-10-06 17:50:52,225 - IOOppi_data - INFO : save new data to db IOOppi_SM_g: date value ... created_at updated_at
3007 2025-10-04 5656.0 ... 2025-10-06 17:50:52.217532 2025-10-06 17:50:52.217965
3008 2025-10-05 5656.0 ... 2025-10-06 17:50:52.217532 2025-10-06 17:50:52.217965
3009 2025-10-06 5656.0 ... 2025-10-06 17:50:52.217532 2025-10-06 17:50:52.217965
[3 rows x 5 columns]
2025-10-06 17:50:52,243 - 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-10-06 17:50:52,974 - IOOppi_data - INFO : save data to db IOOppi_CY_t data:
date value
2276 2025-10-02 23550.0
2277 2025-10-03 23550.0
2278 2025-10-04 23550.0
2279 2025-10-05 23550.0
2280 2025-10-06 23550.0
2025-10-06 17:50:53,026 - IOOppi_data - INFO : save new data to db IOOppi_CY_t: date value ... created_at updated_at
2278 2025-10-04 23550.0 ... 2025-10-06 17:50:53.019422 2025-10-06 17:50:53.019835
2279 2025-10-05 23550.0 ... 2025-10-06 17:50:53.019422 2025-10-06 17:50:53.019835
2280 2025-10-06 23550.0 ... 2025-10-06 17:50:53.019422 2025-10-06 17:50:53.019835
[3 rows x 5 columns]
2025-10-06 17:50:53,045 - IOOppi_data - INFO : save diff data to db: IOOppi_CY_t: no diff data
2025-10-06 17:50:53,050 - IOOppi_data - INFO : save data to db IOOppi_CY_g data:
date value
2276 2025-10-02 23550.0
2277 2025-10-03 23550.0
2278 2025-10-04 23550.0
2279 2025-10-05 23550.0
2280 2025-10-06 23550.0
2025-10-06 17:50:53,103 - IOOppi_data - INFO : save new data to db IOOppi_CY_g: date value ... created_at updated_at
2282 2025-10-04 23550.0 ... 2025-10-06 17:50:53.095859 2025-10-06 17:50:53.096241
2283 2025-10-05 23550.0 ... 2025-10-06 17:50:53.095859 2025-10-06 17:50:53.096241
2284 2025-10-06 23550.0 ... 2025-10-06 17:50:53.095859 2025-10-06 17:50:53.096241
[3 rows x 5 columns]
2025-10-06 17:50:53,191 - 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-10-06 17:50:53,833 - IOOppi_data - INFO : save data to db IOOppi_UR_t data:
date value
1791 2025-10-02 1621.25
1792 2025-10-03 1621.25
1793 2025-10-04 1621.25
1794 2025-10-05 1621.25
1795 2025-10-06 1621.25
2025-10-06 17:50:53,879 - IOOppi_data - INFO : save new data to db IOOppi_UR_t: date value ... created_at updated_at
1793 2025-10-04 1621.25 ... 2025-10-06 17:50:53.872494 2025-10-06 17:50:53.872904
1794 2025-10-05 1621.25 ... 2025-10-06 17:50:53.872494 2025-10-06 17:50:53.872904
1795 2025-10-06 1621.25 ... 2025-10-06 17:50:53.872494 2025-10-06 17:50:53.872904
[3 rows x 5 columns]
2025-10-06 17:50:53,898 - IOOppi_data - INFO : save diff data to db: IOOppi_UR_t: no diff data
2025-10-06 17:50:53,903 - IOOppi_data - INFO : save data to db IOOppi_UR_g data:
date value
1791 2025-10-02 1621.25
1792 2025-10-03 1621.25
1793 2025-10-04 1621.25
1794 2025-10-05 1621.25
1795 2025-10-06 1621.25
2025-10-06 17:50:53,949 - IOOppi_data - INFO : save new data to db IOOppi_UR_g: date value ... created_at updated_at
1797 2025-10-04 1621.25 ... 2025-10-06 17:50:53.942363 2025-10-06 17:50:53.942757
1798 2025-10-05 1621.25 ... 2025-10-06 17:50:53.942363 2025-10-06 17:50:53.942757
1799 2025-10-06 1621.25 ... 2025-10-06 17:50:53.942363 2025-10-06 17:50:53.942757
[3 rows x 5 columns]
2025-10-06 17:50:53,968 - 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-10-06 17:50:54,653 - IOOppi_data - INFO : save data to db IOOppi_ni_t data:
date value
2863 2025-10-02 122500.0
2864 2025-10-03 122500.0
2865 2025-10-04 122500.0
2866 2025-10-05 122500.0
2867 2025-10-06 122500.0
2025-10-06 17:50:54,713 - IOOppi_data - INFO : save new data to db IOOppi_ni_t: date ... updated_at
2865 2025-10-04 ... 2025-10-06 17:50:54.707031
2866 2025-10-05 ... 2025-10-06 17:50:54.707031
2867 2025-10-06 ... 2025-10-06 17:50:54.707031
[3 rows x 5 columns]
2025-10-06 17:50:54,731 - IOOppi_data - INFO : save diff data to db: IOOppi_ni_t: no diff data
2025-10-06 17:50:54,737 - IOOppi_data - INFO : save data to db IOOppi_ni_g data:
date value
2863 2025-10-02 122500.0
2864 2025-10-03 122500.0
2865 2025-10-04 122500.0
2866 2025-10-05 122500.0
2867 2025-10-06 122500.0
2025-10-06 17:50:54,798 - IOOppi_data - INFO : save new data to db IOOppi_ni_g: date ... updated_at
2868 2025-10-04 ... 2025-10-06 17:50:54.792293
2869 2025-10-05 ... 2025-10-06 17:50:54.792293
2870 2025-10-06 ... 2025-10-06 17:50:54.792293
[3 rows x 5 columns]
2025-10-06 17:50:54,817 - 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-10-06 17:50:55,468 - IOOppi_data - INFO : save data to db IOOppi_v_t data:
date value
3888 2025-10-02 4606.0
3889 2025-10-03 4606.0
3890 2025-10-04 4606.0
3891 2025-10-05 4606.0
3892 2025-10-06 4606.0
2025-10-06 17:50:55,543 - IOOppi_data - INFO : save new data to db IOOppi_v_t: date value ... created_at updated_at
3890 2025-10-04 4606.0 ... 2025-10-06 17:50:55.535687 2025-10-06 17:50:55.536080
3891 2025-10-05 4606.0 ... 2025-10-06 17:50:55.535687 2025-10-06 17:50:55.536080
3892 2025-10-06 4606.0 ... 2025-10-06 17:50:55.535687 2025-10-06 17:50:55.536080
[3 rows x 5 columns]
2025-10-06 17:50:55,562 - IOOppi_data - INFO : save diff data to db: IOOppi_v_t: no diff data
2025-10-06 17:50:55,568 - IOOppi_data - INFO : save data to db IOOppi_v_g data:
date value
3888 2025-10-02 4606.0
3889 2025-10-03 4606.0
3890 2025-10-04 4606.0
3891 2025-10-05 4606.0
3892 2025-10-06 4606.0
2025-10-06 17:50:55,640 - IOOppi_data - INFO : save new data to db IOOppi_v_g: date value ... created_at updated_at
3893 2025-10-04 4606.0 ... 2025-10-06 17:50:55.632775 2025-10-06 17:50:55.633151
3894 2025-10-05 4606.0 ... 2025-10-06 17:50:55.632775 2025-10-06 17:50:55.633151
3895 2025-10-06 4606.0 ... 2025-10-06 17:50:55.632775 2025-10-06 17:50:55.633151
[3 rows x 5 columns]
2025-10-06 17:50:55,658 - 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-10-06 17:50:56,327 - IOOppi_data - INFO : save data to db IOOppi_pp_t data:
date value
3127 2025-10-02 6920.0
3128 2025-10-03 6920.0
3129 2025-10-04 6920.0
3130 2025-10-05 6920.0
3131 2025-10-06 6920.0
2025-10-06 17:50:56,390 - IOOppi_data - INFO : save new data to db IOOppi_pp_t: date value ... created_at updated_at
3129 2025-10-04 6920.0 ... 2025-10-06 17:50:56.382905 2025-10-06 17:50:56.383286
3130 2025-10-05 6920.0 ... 2025-10-06 17:50:56.382905 2025-10-06 17:50:56.383286
3131 2025-10-06 6920.0 ... 2025-10-06 17:50:56.382905 2025-10-06 17:50:56.383286
[3 rows x 5 columns]
2025-10-06 17:50:56,409 - IOOppi_data - INFO : save diff data to db: IOOppi_pp_t: no diff data
2025-10-06 17:50:56,415 - IOOppi_data - INFO : save data to db IOOppi_pp_g data:
date value
3127 2025-10-02 6920.0
3128 2025-10-03 6920.0
3129 2025-10-04 6920.0
3130 2025-10-05 6920.0
3131 2025-10-06 6920.0
2025-10-06 17:50:56,480 - IOOppi_data - INFO : save new data to db IOOppi_pp_g: date value ... created_at updated_at
3132 2025-10-04 6920.0 ... 2025-10-06 17:50:56.473269 2025-10-06 17:50:56.473675
3133 2025-10-05 6920.0 ... 2025-10-06 17:50:56.473269 2025-10-06 17:50:56.473675
3134 2025-10-06 6920.0 ... 2025-10-06 17:50:56.473269 2025-10-06 17:50:56.473675
[3 rows x 5 columns]
2025-10-06 17:50:56,499 - 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-10-06 17:50:57,376 - IOOppi_data - INFO : save data to db IOOppi_CF_t data:
date value
3889 2025-10-02 14888.83
3890 2025-10-03 14888.83
3891 2025-10-04 14888.83
3892 2025-10-05 14888.83
3893 2025-10-06 14888.83
2025-10-06 17:50:57,448 - IOOppi_data - INFO : save new data to db IOOppi_CF_t: date ... updated_at
3891 2025-10-04 ... 2025-10-06 17:50:57.442207
3892 2025-10-05 ... 2025-10-06 17:50:57.442207
3893 2025-10-06 ... 2025-10-06 17:50:57.442207
[3 rows x 5 columns]
2025-10-06 17:50:57,467 - IOOppi_data - INFO : save diff data to db: IOOppi_CF_t: no diff data
2025-10-06 17:50:57,473 - IOOppi_data - INFO : save data to db IOOppi_CF_g data:
date value
3889 2025-10-02 14888.83
3890 2025-10-03 14888.83
3891 2025-10-04 14888.83
3892 2025-10-05 14888.83
3893 2025-10-06 14888.83
2025-10-06 17:50:57,545 - IOOppi_data - INFO : save new data to db IOOppi_CF_g: date ... updated_at
3895 2025-10-04 ... 2025-10-06 17:50:57.538988
3896 2025-10-05 ... 2025-10-06 17:50:57.538988
3897 2025-10-06 ... 2025-10-06 17:50:57.538988
[3 rows x 5 columns]
2025-10-06 17:50:57,563 - 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-10-06 17:50:58,376 - IOOppi_data - INFO : save data to db IOOppi_pb_t data:
date value
3834 2025-10-02 16862.5
3835 2025-10-03 16862.5
3836 2025-10-04 16862.5
3837 2025-10-05 16862.5
3838 2025-10-06 16862.5
2025-10-06 17:50:58,454 - IOOppi_data - INFO : save new data to db IOOppi_pb_t: date value ... created_at updated_at
3836 2025-10-04 16862.5 ... 2025-10-06 17:50:58.445513 2025-10-06 17:50:58.445984
3837 2025-10-05 16862.5 ... 2025-10-06 17:50:58.445513 2025-10-06 17:50:58.445984
3838 2025-10-06 16862.5 ... 2025-10-06 17:50:58.445513 2025-10-06 17:50:58.445984
[3 rows x 5 columns]
2025-10-06 17:50:58,473 - IOOppi_data - INFO : save diff data to db: IOOppi_pb_t: no diff data
2025-10-06 17:50:58,479 - IOOppi_data - INFO : save data to db IOOppi_pb_g data:
date value
3834 2025-10-02 16862.5
3835 2025-10-03 16862.5
3836 2025-10-04 16862.5
3837 2025-10-05 16862.5
3838 2025-10-06 16862.5
2025-10-06 17:50:58,551 - IOOppi_data - INFO : save new data to db IOOppi_pb_g: date value ... created_at updated_at
3839 2025-10-04 16862.5 ... 2025-10-06 17:50:58.544366 2025-10-06 17:50:58.544779
3840 2025-10-05 16862.5 ... 2025-10-06 17:50:58.544366 2025-10-06 17:50:58.544779
3841 2025-10-06 16862.5 ... 2025-10-06 17:50:58.544366 2025-10-06 17:50:58.544779
[3 rows x 5 columns]
2025-10-06 17:50:58,570 - 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-10-06 17:50:59,274 - IOOppi_data - INFO : save data to db IOOppi_hc_t data:
date value
3109 2025-10-02 3383.33
3110 2025-10-03 3383.33
3111 2025-10-04 3383.33
3112 2025-10-05 3383.33
3113 2025-10-06 3383.33
2025-10-06 17:50:59,338 - IOOppi_data - INFO : save new data to db IOOppi_hc_t: date value ... created_at updated_at
3111 2025-10-04 3383.33 ... 2025-10-06 17:50:59.330749 2025-10-06 17:50:59.331144
3112 2025-10-05 3383.33 ... 2025-10-06 17:50:59.330749 2025-10-06 17:50:59.331144
3113 2025-10-06 3383.33 ... 2025-10-06 17:50:59.330749 2025-10-06 17:50:59.331144
[3 rows x 5 columns]
2025-10-06 17:50:59,357 - IOOppi_data - INFO : save diff data to db: IOOppi_hc_t: no diff data
2025-10-06 17:50:59,363 - IOOppi_data - INFO : save data to db IOOppi_hc_g data:
date value
3109 2025-10-02 3383.33
3110 2025-10-03 3383.33
3111 2025-10-04 3383.33
3112 2025-10-05 3383.33
3113 2025-10-06 3383.33
2025-10-06 17:50:59,428 - IOOppi_data - INFO : save new data to db IOOppi_hc_g: date value ... created_at updated_at
3114 2025-10-04 3383.33 ... 2025-10-06 17:50:59.421364 2025-10-06 17:50:59.421763
3115 2025-10-05 3383.33 ... 2025-10-06 17:50:59.421364 2025-10-06 17:50:59.421763
3116 2025-10-06 3383.33 ... 2025-10-06 17:50:59.421364 2025-10-06 17:50:59.421763
[3 rows x 5 columns]
2025-10-06 17:50:59,447 - 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-10-06 17:51:00,102 - IOOppi_data - INFO : save data to db IOOppi_fu_t data:
date value
3389 2025-10-02 5475.0
3390 2025-10-03 5475.0
3391 2025-10-04 5475.0
3392 2025-10-05 5475.0
3393 2025-10-06 5475.0
2025-10-06 17:51:00,169 - IOOppi_data - INFO : save new data to db IOOppi_fu_t: date value ... created_at updated_at
3391 2025-10-04 5475.0 ... 2025-10-06 17:51:00.161687 2025-10-06 17:51:00.162082
3392 2025-10-05 5475.0 ... 2025-10-06 17:51:00.161687 2025-10-06 17:51:00.162082
3393 2025-10-06 5475.0 ... 2025-10-06 17:51:00.161687 2025-10-06 17:51:00.162082
[3 rows x 5 columns]
2025-10-06 17:51:00,187 - IOOppi_data - INFO : save diff data to db: IOOppi_fu_t: no diff data
2025-10-06 17:51:00,193 - IOOppi_data - INFO : save data to db IOOppi_fu_g data:
date value
3389 2025-10-02 5475.0
3390 2025-10-03 5475.0
3391 2025-10-04 5475.0
3392 2025-10-05 5475.0
3393 2025-10-06 5475.0
2025-10-06 17:51:00,271 - IOOppi_data - INFO : save new data to db IOOppi_fu_g: date value ... created_at updated_at
3878 2025-10-04 5475.0 ... 2025-10-06 17:51:00.263033 2025-10-06 17:51:00.263541
3879 2025-10-05 5475.0 ... 2025-10-06 17:51:00.263033 2025-10-06 17:51:00.263541
3880 2025-10-06 5475.0 ... 2025-10-06 17:51:00.263033 2025-10-06 17:51:00.263541
[3 rows x 5 columns]
2025-10-06 17:51:00,289 - 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-10-06 17:51:00,897 - IOOppi_data - INFO : save data to db IOOppi_lh_t data:
date value
1453 2025-10-02 12620.0
1454 2025-10-03 12620.0
1455 2025-10-04 12620.0
1456 2025-10-05 12620.0
1457 2025-10-06 12620.0
2025-10-06 17:51:00,943 - IOOppi_data - INFO : save new data to db IOOppi_lh_t: date value ... created_at updated_at
1455 2025-10-04 12620.0 ... 2025-10-06 17:51:00.934843 2025-10-06 17:51:00.935250
1456 2025-10-05 12620.0 ... 2025-10-06 17:51:00.934843 2025-10-06 17:51:00.935250
1457 2025-10-06 12620.0 ... 2025-10-06 17:51:00.934843 2025-10-06 17:51:00.935250
[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-10-06 17:51:01,178 - IOOppi_data - INFO : save diff data to db IOOppi_lh_t: date ... updated_at
116 2021-07-05 ... 2025-10-06 17:51:01.169686
117 2021-07-06 ... 2025-10-06 17:51:01.169686
121 2021-07-12 ... 2025-10-06 17:51:01.169686
122 2021-07-13 ... 2025-10-06 17:51:01.169686
194 2021-11-01 ... 2025-10-06 17:51:01.169686
[5 rows x 6 columns]
2025-10-06 17:51:01,214 - IOOppi_data - INFO : save data to db IOOppi_lh_g data:
date value
1453 2025-10-02 12620.0
1454 2025-10-03 12620.0
1455 2025-10-04 12620.0
1456 2025-10-05 12620.0
1457 2025-10-06 12620.0
2025-10-06 17:51:01,258 - IOOppi_data - INFO : save new data to db IOOppi_lh_g: date value ... created_at updated_at
1458 2025-10-04 12620.0 ... 2025-10-06 17:51:01.251142 2025-10-06 17:51:01.251533
1459 2025-10-05 12620.0 ... 2025-10-06 17:51:01.251142 2025-10-06 17:51:01.251533
1460 2025-10-06 12620.0 ... 2025-10-06 17:51:01.251142 2025-10-06 17:51:01.251533
[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-10-06 17:51:01,494 - IOOppi_data - INFO : save diff data to db IOOppi_lh_g: date ... updated_at
116 2021-07-05 ... 2025-10-06 17:51:01.486250
117 2021-07-06 ... 2025-10-06 17:51:01.486250
121 2021-07-12 ... 2025-10-06 17:51:01.486250
122 2021-07-13 ... 2025-10-06 17:51:01.486250
194 2021-11-01 ... 2025-10-06 17:51:01.486250
[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-10-06 17:51:02,276 - IOOppi_data - INFO : save data to db IOOppi_cu_t data:
date value
3885 2025-10-02 83143.33
3886 2025-10-03 83143.33
3887 2025-10-04 83143.33
3888 2025-10-05 83143.33
3889 2025-10-06 83143.33
2025-10-06 17:51:02,348 - IOOppi_data - INFO : save new data to db IOOppi_cu_t: date ... updated_at
3887 2025-10-04 ... 2025-10-06 17:51:02.341760
3888 2025-10-05 ... 2025-10-06 17:51:02.341760
3889 2025-10-06 ... 2025-10-06 17:51:02.341760
[3 rows x 5 columns]
2025-10-06 17:51:02,367 - IOOppi_data - INFO : save diff data to db: IOOppi_cu_t: no diff data
2025-10-06 17:51:02,373 - IOOppi_data - INFO : save data to db IOOppi_cu_g data:
date value
3885 2025-10-02 83143.33
3886 2025-10-03 83143.33
3887 2025-10-04 83143.33
3888 2025-10-05 83143.33
3889 2025-10-06 83143.33
2025-10-06 17:51:02,455 - IOOppi_data - INFO : save new data to db IOOppi_cu_g: date ... updated_at
3890 2025-10-04 ... 2025-10-06 17:51:02.448952
3891 2025-10-05 ... 2025-10-06 17:51:02.448952
3892 2025-10-06 ... 2025-10-06 17:51:02.448952
[3 rows x 5 columns]
2025-10-06 17:51:02,474 - 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-10-06 17:51:03,014 - 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-10-06 17:51:03,067 - IOOppi_data - INFO : save new data to db: IOOppi_PM_t: no new data
2025-10-06 17:51:03,067 - IOOppi_data - INFO : save diff data to db: IOOppi_PM_t: no diff data
2025-10-06 17:51:03,072 - 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-10-06 17:51:03,131 - IOOppi_data - INFO : save new data to db: IOOppi_PM_g: no new data
2025-10-06 17:51:03,131 - 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-10-06 17:51:03,954 - IOOppi_data - INFO : save data to db IOOppi_sn_t data:
date value
2863 2025-10-02 277800.0
2864 2025-10-03 277800.0
2865 2025-10-04 277800.0
2866 2025-10-05 277800.0
2867 2025-10-06 277800.0
2025-10-06 17:51:04,014 - IOOppi_data - INFO : save new data to db IOOppi_sn_t: date ... updated_at
2865 2025-10-04 ... 2025-10-06 17:51:04.007772
2866 2025-10-05 ... 2025-10-06 17:51:04.007772
2867 2025-10-06 ... 2025-10-06 17:51:04.007772
[3 rows x 5 columns]
2025-10-06 17:51:04,034 - IOOppi_data - INFO : save diff data to db: IOOppi_sn_t: no diff data
2025-10-06 17:51:04,040 - IOOppi_data - INFO : save data to db IOOppi_sn_g data:
date value
2863 2025-10-02 277800.0
2864 2025-10-03 277800.0
2865 2025-10-04 277800.0
2866 2025-10-05 277800.0
2867 2025-10-06 277800.0
2025-10-06 17:51:04,101 - IOOppi_data - INFO : save new data to db IOOppi_sn_g: date ... updated_at
2868 2025-10-04 ... 2025-10-06 17:51:04.094748
2869 2025-10-05 ... 2025-10-06 17:51:04.094748
2870 2025-10-06 ... 2025-10-06 17:51:04.094748
[3 rows x 5 columns]
2025-10-06 17:51:04,120 - 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-10-06 17:51:04,834 - IOOppi_data - INFO : save data to db IOOppi_zn_t data:
date value
3884 2025-10-02 21824.0
3885 2025-10-03 21824.0
3886 2025-10-04 21824.0
3887 2025-10-05 21824.0
3888 2025-10-06 21824.0
2025-10-06 17:51:04,909 - IOOppi_data - INFO : save new data to db IOOppi_zn_t: date value ... created_at updated_at
3886 2025-10-04 21824.0 ... 2025-10-06 17:51:04.902289 2025-10-06 17:51:04.902731
3887 2025-10-05 21824.0 ... 2025-10-06 17:51:04.902289 2025-10-06 17:51:04.902731
3888 2025-10-06 21824.0 ... 2025-10-06 17:51:04.902289 2025-10-06 17:51:04.902731
[3 rows x 5 columns]
2025-10-06 17:51:04,928 - IOOppi_data - INFO : save diff data to db: IOOppi_zn_t: no diff data
2025-10-06 17:51:04,934 - IOOppi_data - INFO : save data to db IOOppi_zn_g data:
date value
3884 2025-10-02 21824.0
3885 2025-10-03 21824.0
3886 2025-10-04 21824.0
3887 2025-10-05 21824.0
3888 2025-10-06 21824.0
2025-10-06 17:51:05,010 - IOOppi_data - INFO : save new data to db IOOppi_zn_g: date value ... created_at updated_at
3889 2025-10-04 21824.0 ... 2025-10-06 17:51:05.002882 2025-10-06 17:51:05.003307
3890 2025-10-05 21824.0 ... 2025-10-06 17:51:05.002882 2025-10-06 17:51:05.003307
3891 2025-10-06 21824.0 ... 2025-10-06 17:51:05.002882 2025-10-06 17:51:05.003307
[3 rows x 5 columns]
2025-10-06 17:51:05,029 - 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-10-06 17:51:05,684 - IOOppi_data - INFO : save data to db IOOppi_wr_t data:
date value
3847 2025-10-02 3357.5
3848 2025-10-03 3357.5
3849 2025-10-04 3357.5
3850 2025-10-05 3357.5
3851 2025-10-06 3357.5
2025-10-06 17:51:05,756 - IOOppi_data - INFO : save new data to db IOOppi_wr_t: date value ... created_at updated_at
3849 2025-10-04 3357.5 ... 2025-10-06 17:51:05.748893 2025-10-06 17:51:05.749275
3850 2025-10-05 3357.5 ... 2025-10-06 17:51:05.748893 2025-10-06 17:51:05.749275
3851 2025-10-06 3357.5 ... 2025-10-06 17:51:05.748893 2025-10-06 17:51:05.749275
[3 rows x 5 columns]
2025-10-06 17:51:05,774 - IOOppi_data - INFO : save diff data to db: IOOppi_wr_t: no diff data
2025-10-06 17:51:05,780 - IOOppi_data - INFO : save data to db IOOppi_wr_g data:
date value
3847 2025-10-02 3357.5
3848 2025-10-03 3357.5
3849 2025-10-04 3357.5
3850 2025-10-05 3357.5
3851 2025-10-06 3357.5
2025-10-06 17:51:05,852 - IOOppi_data - INFO : save new data to db IOOppi_wr_g: date value ... created_at updated_at
3852 2025-10-04 3357.5 ... 2025-10-06 17:51:05.845275 2025-10-06 17:51:05.845675
3853 2025-10-05 3357.5 ... 2025-10-06 17:51:05.845275 2025-10-06 17:51:05.845675
3854 2025-10-06 3357.5 ... 2025-10-06 17:51:05.845275 2025-10-06 17:51:05.845675
[3 rows x 5 columns]
2025-10-06 17:51:05,870 - 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-10-06 17:51:06,494 - IOOppi_data - INFO : save data to db IOOppi_pg_t data:
date value
1644 2025-10-02 4552.5
1645 2025-10-03 4552.5
1646 2025-10-04 4552.5
1647 2025-10-05 4552.5
1648 2025-10-06 4552.5
2025-10-06 17:51:06,539 - IOOppi_data - INFO : save new data to db IOOppi_pg_t: date value ... created_at updated_at
1646 2025-10-04 4552.5 ... 2025-10-06 17:51:06.531967 2025-10-06 17:51:06.532346
1647 2025-10-05 4552.5 ... 2025-10-06 17:51:06.531967 2025-10-06 17:51:06.532346
1648 2025-10-06 4552.5 ... 2025-10-06 17:51:06.531967 2025-10-06 17:51:06.532346
[3 rows x 5 columns]
2025-10-06 17:51:06,558 - IOOppi_data - INFO : save diff data to db: IOOppi_pg_t: no diff data
2025-10-06 17:51:06,563 - IOOppi_data - INFO : save data to db IOOppi_pg_g data:
date value
1644 2025-10-02 4552.5
1645 2025-10-03 4552.5
1646 2025-10-04 4552.5
1647 2025-10-05 4552.5
1648 2025-10-06 4552.5
2025-10-06 17:51:06,608 - IOOppi_data - INFO : save new data to db IOOppi_pg_g: date value ... created_at updated_at
1649 2025-10-04 4552.5 ... 2025-10-06 17:51:06.600951 2025-10-06 17:51:06.601318
1650 2025-10-05 4552.5 ... 2025-10-06 17:51:06.600951 2025-10-06 17:51:06.601318
1651 2025-10-06 4552.5 ... 2025-10-06 17:51:06.600951 2025-10-06 17:51:06.601318
[3 rows x 5 columns]
2025-10-06 17:51:06,628 - 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-10-06 17:51:07,359 - IOOppi_data - INFO : save data to db IOOppi_cs_t data:
date value
2918 2025-10-02 2285.71
2919 2025-10-03 2285.71
2920 2025-10-04 2285.71
2921 2025-10-05 2285.71
2922 2025-10-06 2285.71
2025-10-06 17:51:07,421 - IOOppi_data - INFO : save new data to db IOOppi_cs_t: date value ... created_at updated_at
2920 2025-10-04 2285.71 ... 2025-10-06 17:51:07.414266 2025-10-06 17:51:07.414690
2921 2025-10-05 2285.71 ... 2025-10-06 17:51:07.414266 2025-10-06 17:51:07.414690
2922 2025-10-06 2285.71 ... 2025-10-06 17:51:07.414266 2025-10-06 17:51:07.414690
[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-10-06 17:51:07,463 - IOOppi_data - INFO : save diff data to db IOOppi_cs_t: date ... updated_at
2919 2025-10-03 ... 2025-10-06 17:51:07.456050
[1 rows x 6 columns]
2025-10-06 17:51:07,488 - IOOppi_data - INFO : save data to db IOOppi_cs_g data:
date value
2918 2025-10-02 2285.71
2919 2025-10-03 2285.71
2920 2025-10-04 2285.71
2921 2025-10-05 2285.71
2922 2025-10-06 2285.71
2025-10-06 17:51:07,549 - IOOppi_data - INFO : save new data to db IOOppi_cs_g: date value ... created_at updated_at
2923 2025-10-04 2285.71 ... 2025-10-06 17:51:07.542442 2025-10-06 17:51:07.542856
2924 2025-10-05 2285.71 ... 2025-10-06 17:51:07.542442 2025-10-06 17:51:07.542856
2925 2025-10-06 2285.71 ... 2025-10-06 17:51:07.542442 2025-10-06 17:51:07.542856
[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-10-06 17:51:07,589 - IOOppi_data - INFO : save diff data to db IOOppi_cs_g: date ... updated_at
2922 2025-10-03 ... 2025-10-06 17:51:07.582580
[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-10-06 17:51:08,203 - IOOppi_data - INFO : save data to db IOOppi_cs_t data:
date value
2918 2025-10-02 2285.71
2919 2025-10-03 2285.71
2920 2025-10-04 2285.71
2921 2025-10-05 2285.71
2922 2025-10-06 2828.00
2025-10-06 17:51:08,255 - 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-10-06 17:51:08,277 - IOOppi_data - INFO : save diff data to db IOOppi_cs_t: date ... updated_at
2922 2025-10-06 ... 2025-10-06 17:51:08.269986
[1 rows x 6 columns]
2025-10-06 17:51:08,301 - IOOppi_data - INFO : save data to db IOOppi_cs_g data:
date value
2918 2025-10-02 2285.71
2919 2025-10-03 2285.71
2920 2025-10-04 2285.71
2921 2025-10-05 2285.71
2922 2025-10-06 2828.00
2025-10-06 17:51:08,354 - 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-10-06 17:51:08,377 - IOOppi_data - INFO : save diff data to db IOOppi_cs_g: date ... updated_at
2925 2025-10-06 ... 2025-10-06 17:51:08.369899
[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-10-06 17:51:08,910 - IOOppi_data - INFO : save data to db IOOppi_RS_t data:
date value
3275 2025-10-02 10175.0
3276 2025-10-03 10175.0
3277 2025-10-04 10175.0
3278 2025-10-05 10175.0
3279 2025-10-06 10175.0
2025-10-06 17:51:08,966 - IOOppi_data - INFO : save new data to db: IOOppi_RS_t: no new data
2025-10-06 17:51:08,966 - IOOppi_data - INFO : save diff data to db: IOOppi_RS_t: no diff data
2025-10-06 17:51:08,972 - IOOppi_data - INFO : save data to db IOOppi_RS_g data:
date value
3275 2025-10-02 10175.0
3276 2025-10-03 10175.0
3277 2025-10-04 10175.0
3278 2025-10-05 10175.0
3279 2025-10-06 10175.0
2025-10-06 17:51:09,029 - IOOppi_data - INFO : save new data to db: IOOppi_RS_g: no new data
2025-10-06 17:51:09,029 - 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-10-06 17:51:09,768 - IOOppi_data - INFO : save data to db IOOppi_eg_t data:
date value
1959 2025-10-02 4385.0
1960 2025-10-03 4385.0
1961 2025-10-04 4385.0
1962 2025-10-05 4385.0
1963 2025-10-06 4385.0
2025-10-06 17:51:09,817 - IOOppi_data - INFO : save new data to db IOOppi_eg_t: date value ... created_at updated_at
1961 2025-10-04 4385.0 ... 2025-10-06 17:51:09.809974 2025-10-06 17:51:09.810357
1962 2025-10-05 4385.0 ... 2025-10-06 17:51:09.809974 2025-10-06 17:51:09.810357
1963 2025-10-06 4385.0 ... 2025-10-06 17:51:09.809974 2025-10-06 17:51:09.810357
[3 rows x 5 columns]
2025-10-06 17:51:09,837 - IOOppi_data - INFO : save diff data to db: IOOppi_eg_t: no diff data
2025-10-06 17:51:09,843 - IOOppi_data - INFO : save data to db IOOppi_eg_g data:
date value
1959 2025-10-02 4385.0
1960 2025-10-03 4385.0
1961 2025-10-04 4385.0
1962 2025-10-05 4385.0
1963 2025-10-06 4385.0
2025-10-06 17:51:09,893 - IOOppi_data - INFO : save new data to db IOOppi_eg_g: date value ... created_at updated_at
1964 2025-10-04 4385.0 ... 2025-10-06 17:51:09.885812 2025-10-06 17:51:09.886194
1965 2025-10-05 4385.0 ... 2025-10-06 17:51:09.885812 2025-10-06 17:51:09.886194
1966 2025-10-06 4385.0 ... 2025-10-06 17:51:09.885812 2025-10-06 17:51:09.886194
[3 rows x 5 columns]
2025-10-06 17:51:09,911 - 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-10-06 17:51:10,569 - IOOppi_data - INFO : save data to db IOOppi_sp_t data:
date value
1968 2025-10-02 5633.33
1969 2025-10-03 5633.33
1970 2025-10-04 5633.33
1971 2025-10-05 5633.33
1972 2025-10-06 5633.33
2025-10-06 17:51:10,619 - IOOppi_data - INFO : save new data to db IOOppi_sp_t: date value ... created_at updated_at
1970 2025-10-04 5633.33 ... 2025-10-06 17:51:10.611918 2025-10-06 17:51:10.612296
1971 2025-10-05 5633.33 ... 2025-10-06 17:51:10.611918 2025-10-06 17:51:10.612296
1972 2025-10-06 5633.33 ... 2025-10-06 17:51:10.611918 2025-10-06 17:51:10.612296
[3 rows x 5 columns]
2025-10-06 17:51:10,637 - IOOppi_data - INFO : save diff data to db: IOOppi_sp_t: no diff data
2025-10-06 17:51:10,643 - IOOppi_data - INFO : save data to db IOOppi_sp_g data:
date value
1968 2025-10-02 5633.33
1969 2025-10-03 5633.33
1970 2025-10-04 5633.33
1971 2025-10-05 5633.33
1972 2025-10-06 5633.33
2025-10-06 17:51:10,693 - IOOppi_data - INFO : save new data to db IOOppi_sp_g: date value ... created_at updated_at
1973 2025-10-04 5633.33 ... 2025-10-06 17:51:10.685715 2025-10-06 17:51:10.686105
1974 2025-10-05 5633.33 ... 2025-10-06 17:51:10.685715 2025-10-06 17:51:10.686105
1975 2025-10-06 5633.33 ... 2025-10-06 17:51:10.685715 2025-10-06 17:51:10.686105
[3 rows x 5 columns]
2025-10-06 17:51:10,711 - 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-10-06 17:51:11,549 - IOOppi_data - INFO : save data to db IOOppi_p_t data:
date value
3636 2025-10-02 9226.0
3637 2025-10-03 9226.0
3638 2025-10-04 9226.0
3639 2025-10-05 9226.0
3640 2025-10-06 9226.0
2025-10-06 17:51:11,620 - IOOppi_data - INFO : save new data to db IOOppi_p_t: date value ... created_at updated_at
3638 2025-10-04 9226.0 ... 2025-10-06 17:51:11.613423 2025-10-06 17:51:11.613837
3639 2025-10-05 9226.0 ... 2025-10-06 17:51:11.613423 2025-10-06 17:51:11.613837
3640 2025-10-06 9226.0 ... 2025-10-06 17:51:11.613423 2025-10-06 17:51:11.613837
[3 rows x 5 columns]
2025-10-06 17:51:11,639 - IOOppi_data - INFO : save diff data to db: IOOppi_p_t: no diff data
2025-10-06 17:51:11,644 - IOOppi_data - INFO : save data to db IOOppi_p_g data:
date value
3636 2025-10-02 9226.0
3637 2025-10-03 9226.0
3638 2025-10-04 9226.0
3639 2025-10-05 9226.0
3640 2025-10-06 9226.0
2025-10-06 17:51:11,714 - IOOppi_data - INFO : save new data to db IOOppi_p_g: date value ... created_at updated_at
3641 2025-10-04 9226.0 ... 2025-10-06 17:51:11.706845 2025-10-06 17:51:11.707225
3642 2025-10-05 9226.0 ... 2025-10-06 17:51:11.706845 2025-10-06 17:51:11.707225
3643 2025-10-06 9226.0 ... 2025-10-06 17:51:11.706845 2025-10-06 17:51:11.707225
[3 rows x 5 columns]
2025-10-06 17:51:11,732 - IOOppi_data - INFO : save diff data to db: IOOppi_p_g: no diff data