=========================================================================
2025-07-18 17:50:26 Fri START TASK.01 IOOppi_data update_data
=========================================================================
/usr/local/lib/python3.10/site-packages/urllib3/connectionpool.py:1056: InsecureRequestWarning: Unverified HTTPS request is being made to host 'www.100ppi.com'. Adding certificate verification is strongly advised. See: https://urllib3.readthedocs.io/en/1.26.x/advanced-usage.html#ssl-warnings
warnings.warn(
2025-07-18 17:50:29,019 - IOOppi_data - INFO : save data to db IOOppi_rb_t data:
date value
3364 2025-07-14 3180.0
3365 2025-07-15 3173.0
3366 2025-07-16 3172.0
3367 2025-07-17 3173.5
3368 2025-07-18 3196.0
2025-07-18 17:50:29,144 - IOOppi_data - INFO : save new data to db IOOppi_rb_t: date value ... created_at updated_at
3368 2025-07-18 3196.0 ... 2025-07-18 17:50:29.131793 2025-07-18 17:50:29.132424
[1 rows x 5 columns]
2025-07-18 17:50:29,167 - IOOppi_data - INFO : save diff data to db: IOOppi_rb_t: no diff data
2025-07-18 17:50:29,176 - IOOppi_data - INFO : save data to db IOOppi_rb_g data:
date value
3364 2025-07-14 3180.0
3365 2025-07-15 3173.0
3366 2025-07-16 3172.0
3367 2025-07-17 3173.5
3368 2025-07-18 3196.0
2025-07-18 17:50:29,294 - IOOppi_data - INFO : save new data to db IOOppi_rb_g: date value ... created_at updated_at
3371 2025-07-18 3196.0 ... 2025-07-18 17:50:29.282878 2025-07-18 17:50:29.283487
[1 rows x 5 columns]
2025-07-18 17:50:29,315 - 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-18 17:50:30,194 - IOOppi_data - INFO : save data to db IOOppi_MA_t data:
date value
3585 2025-07-14 2390.00
3586 2025-07-15 2390.00
3587 2025-07-16 2381.67
3588 2025-07-17 2391.67
3589 2025-07-18 2383.33
2025-07-18 17:50:30,271 - IOOppi_data - INFO : save new data to db IOOppi_MA_t: date value ... created_at updated_at
3589 2025-07-18 2383.33 ... 2025-07-18 17:50:30.264341 2025-07-18 17:50:30.264725
[1 rows x 5 columns]
2025-07-18 17:50:30,290 - IOOppi_data - INFO : save diff data to db: IOOppi_MA_t: no diff data
2025-07-18 17:50:30,295 - IOOppi_data - INFO : save data to db IOOppi_MA_g data:
date value
3585 2025-07-14 2390.00
3586 2025-07-15 2390.00
3587 2025-07-16 2381.67
3588 2025-07-17 2391.67
3589 2025-07-18 2383.33
2025-07-18 17:50:30,369 - IOOppi_data - INFO : save new data to db IOOppi_MA_g: date value ... created_at updated_at
3593 2025-07-18 2383.33 ... 2025-07-18 17:50:30.362137 2025-07-18 17:50:30.362513
[1 rows x 5 columns]
2025-07-18 17:50:30,387 - 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-18 17:50:30,988 - IOOppi_data - INFO : save data to db IOOppi_PTA_t data:
date value
925 2025-07-14 4789.84
926 2025-07-15 4735.66
927 2025-07-16 4735.66
928 2025-07-17 4762.66
929 2025-07-18 4776.66
2025-07-18 17:50:31,028 - IOOppi_data - INFO : save new data to db IOOppi_PTA_t: date value ... created_at updated_at
929 2025-07-18 4776.66 ... 2025-07-18 17:50:31.021174 2025-07-18 17:50:31.021569
[1 rows x 5 columns]
2025-07-18 17:50:31,047 - IOOppi_data - INFO : save diff data to db: IOOppi_PTA_t: no diff data
2025-07-18 17:50:31,053 - IOOppi_data - INFO : save data to db IOOppi_PTA_g data:
date value
925 2025-07-14 4789.84
926 2025-07-15 4735.66
927 2025-07-16 4735.66
928 2025-07-17 4762.66
929 2025-07-18 4776.66
2025-07-18 17:50:31,092 - IOOppi_data - INFO : save new data to db IOOppi_PTA_g: date value ... created_at updated_at
929 2025-07-18 4776.66 ... 2025-07-18 17:50:31.085415 2025-07-18 17:50:31.085821
[1 rows x 5 columns]
2025-07-18 17:50:31,112 - 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-18 17:50:31,760 - IOOppi_data - INFO : save data to db IOOppi_ru_t data:
date value
3804 2025-07-14 14386.67
3805 2025-07-15 14508.33
3806 2025-07-16 14516.67
3807 2025-07-17 14658.33
3808 2025-07-18 14900.00
2025-07-18 17:50:31,840 - IOOppi_data - INFO : save new data to db IOOppi_ru_t: date value ... created_at updated_at
3808 2025-07-18 14900.0 ... 2025-07-18 17:50:31.833041 2025-07-18 17:50:31.833432
[1 rows x 5 columns]
2025-07-18 17:50:31,858 - IOOppi_data - INFO : save diff data to db: IOOppi_ru_t: no diff data
2025-07-18 17:50:31,864 - IOOppi_data - INFO : save data to db IOOppi_ru_g data:
date value
3804 2025-07-14 14386.67
3805 2025-07-15 14508.33
3806 2025-07-16 14516.67
3807 2025-07-17 14658.33
3808 2025-07-18 14900.00
2025-07-18 17:50:31,938 - IOOppi_data - INFO : save new data to db IOOppi_ru_g: date value ... created_at updated_at
3811 2025-07-18 14900.0 ... 2025-07-18 17:50:31.931725 2025-07-18 17:50:31.932144
[1 rows x 5 columns]
2025-07-18 17:50:31,957 - 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-18 17:50:32,522 - IOOppi_data - INFO : save data to db IOOppi_i_t data:
date value
3136 2025-07-14 764.00
3137 2025-07-15 765.00
3138 2025-07-16 765.00
3139 2025-07-17 779.67
3140 2025-07-18 787.33
2025-07-18 17:50:32,591 - IOOppi_data - INFO : save new data to db IOOppi_i_t: date value ... created_at updated_at
3140 2025-07-18 787.33 ... 2025-07-18 17:50:32.584381 2025-07-18 17:50:32.584794
[1 rows x 5 columns]
2025-07-18 17:50:32,609 - IOOppi_data - INFO : save diff data to db: IOOppi_i_t: no diff data
2025-07-18 17:50:32,615 - IOOppi_data - INFO : save data to db IOOppi_i_g data:
date value
3136 2025-07-14 764.00
3137 2025-07-15 765.00
3138 2025-07-16 765.00
3139 2025-07-17 779.67
3140 2025-07-18 787.33
2025-07-18 17:50:32,685 - IOOppi_data - INFO : save new data to db IOOppi_i_g: date value ... created_at updated_at
3143 2025-07-18 787.33 ... 2025-07-18 17:50:32.678072 2025-07-18 17:50:32.678488
[1 rows x 5 columns]
2025-07-18 17:50:32,703 - 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-18 17:50:33,261 - IOOppi_data - INFO : save data to db IOOppi_FG_t data:
date value
3339 2025-07-14 1128.0
3340 2025-07-15 1128.0
3341 2025-07-16 1142.4
3342 2025-07-17 1142.4
3343 2025-07-18 1142.4
2025-07-18 17:50:33,331 - IOOppi_data - INFO : save new data to db IOOppi_FG_t: date value ... created_at updated_at
3343 2025-07-18 1142.4 ... 2025-07-18 17:50:33.324712 2025-07-18 17:50:33.325123
[1 rows x 5 columns]
/root/project/IOOppi_data/IOOppi_request.py:308: SettingWithCopyWarning:
A value is trying to be set on a copy of a slice from a DataFrame.
Try using .loc[row_indexer,col_indexer] = value instead
See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy
diff_df.loc[:, 'index_code'] = index_code
/root/project/IOOppi_data/IOOppi_request.py:309: SettingWithCopyWarning:
A value is trying to be set on a copy of a slice from a DataFrame.
Try using .loc[row_indexer,col_indexer] = value instead
See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy
diff_df.loc[:, 'created_at'] = datetime.datetime.now()
/root/project/IOOppi_data/IOOppi_request.py:310: SettingWithCopyWarning:
A value is trying to be set on a copy of a slice from a DataFrame.
Try using .loc[row_indexer,col_indexer] = value instead
See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy
diff_df.loc[:, 'updated_at'] = datetime.datetime.now()
2025-07-18 17:50:35,296 - IOOppi_data - INFO : save diff data to db IOOppi_FG_t: date ... updated_at
12 2012-12-19 ... 2025-07-18 17:50:35.288235
21 2013-01-04 ... 2025-07-18 17:50:35.288235
54 2013-02-27 ... 2025-07-18 17:50:35.288235
60 2013-03-07 ... 2025-07-18 17:50:35.288235
61 2013-03-08 ... 2025-07-18 17:50:35.288235
[5 rows x 6 columns]
2025-07-18 17:50:35,475 - IOOppi_data - INFO : save data to db IOOppi_FG_g data:
date value
3339 2025-07-14 1128.0
3340 2025-07-15 1128.0
3341 2025-07-16 1142.4
3342 2025-07-17 1142.4
3343 2025-07-18 1142.4
2025-07-18 17:50:35,566 - IOOppi_data - INFO : save new data to db IOOppi_FG_g: date value ... created_at updated_at
3347 2025-07-18 1142.4 ... 2025-07-18 17:50:35.556564 2025-07-18 17:50:35.557012
[1 rows x 5 columns]
/root/project/IOOppi_data/IOOppi_request.py:308: SettingWithCopyWarning:
A value is trying to be set on a copy of a slice from a DataFrame.
Try using .loc[row_indexer,col_indexer] = value instead
See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy
diff_df.loc[:, 'index_code'] = index_code
/root/project/IOOppi_data/IOOppi_request.py:309: SettingWithCopyWarning:
A value is trying to be set on a copy of a slice from a DataFrame.
Try using .loc[row_indexer,col_indexer] = value instead
See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy
diff_df.loc[:, 'created_at'] = datetime.datetime.now()
/root/project/IOOppi_data/IOOppi_request.py:310: SettingWithCopyWarning:
A value is trying to be set on a copy of a slice from a DataFrame.
Try using .loc[row_indexer,col_indexer] = value instead
See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy
diff_df.loc[:, 'updated_at'] = datetime.datetime.now()
2025-07-18 17:50:37,443 - IOOppi_data - INFO : save diff data to db IOOppi_FG_g: date ... updated_at
12 2012-12-19 ... 2025-07-18 17:50:37.435838
21 2013-01-04 ... 2025-07-18 17:50:37.435838
54 2013-02-27 ... 2025-07-18 17:50:37.435838
60 2013-03-07 ... 2025-07-18 17:50:37.435838
61 2013-03-08 ... 2025-07-18 17:50:37.435838
[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-18 17:50:38,210 - IOOppi_data - INFO : save data to db IOOppi_eb_t data:
date value
1684 2025-07-14 7936.0
1685 2025-07-15 7956.0
1686 2025-07-16 7946.0
1687 2025-07-17 7900.0
1688 2025-07-18 7846.0
2025-07-18 17:50:38,258 - IOOppi_data - INFO : save new data to db IOOppi_eb_t: date value ... created_at updated_at
1688 2025-07-18 7846.0 ... 2025-07-18 17:50:38.251615 2025-07-18 17:50:38.252026
[1 rows x 5 columns]
2025-07-18 17:50:38,276 - IOOppi_data - INFO : save diff data to db: IOOppi_eb_t: no diff data
2025-07-18 17:50:38,282 - IOOppi_data - INFO : save data to db IOOppi_eb_g data:
date value
1684 2025-07-14 7936.0
1685 2025-07-15 7956.0
1686 2025-07-16 7946.0
1687 2025-07-17 7900.0
1688 2025-07-18 7846.0
2025-07-18 17:50:38,330 - IOOppi_data - INFO : save new data to db IOOppi_eb_g: date value ... created_at updated_at
1691 2025-07-18 7846.0 ... 2025-07-18 17:50:38.322824 2025-07-18 17:50:38.323207
[1 rows x 5 columns]
2025-07-18 17:50:38,348 - 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-18 17:50:39,057 - IOOppi_data - INFO : save data to db IOOppi_SR_t data:
date value
3795 2025-07-14 6050.00
3796 2025-07-15 6043.33
3797 2025-07-16 6043.33
3798 2025-07-17 6046.67
3799 2025-07-18 6043.33
2025-07-18 17:50:39,130 - IOOppi_data - INFO : save new data to db IOOppi_SR_t: date value ... created_at updated_at
3799 2025-07-18 6043.33 ... 2025-07-18 17:50:39.123566 2025-07-18 17:50:39.123984
[1 rows x 5 columns]
2025-07-18 17:50:39,149 - IOOppi_data - INFO : save diff data to db: IOOppi_SR_t: no diff data
2025-07-18 17:50:39,155 - IOOppi_data - INFO : save data to db IOOppi_SR_g data:
date value
3795 2025-07-14 6050.00
3796 2025-07-15 6043.33
3797 2025-07-16 6043.33
3798 2025-07-17 6046.67
3799 2025-07-18 6043.33
2025-07-18 17:50:39,227 - IOOppi_data - INFO : save new data to db IOOppi_SR_g: date value ... created_at updated_at
3803 2025-07-18 6043.33 ... 2025-07-18 17:50:39.220418 2025-07-18 17:50:39.220840
[1 rows x 5 columns]
2025-07-18 17:50:39,246 - 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-18 17:50:39,851 - IOOppi_data - INFO : save data to db IOOppi_ss_t data:
date value
1685 2025-07-14 12900.0
1686 2025-07-15 12900.0
1687 2025-07-16 12950.0
1688 2025-07-17 12950.0
1689 2025-07-18 12937.5
2025-07-18 17:50:39,898 - IOOppi_data - INFO : save new data to db IOOppi_ss_t: date value ... created_at updated_at
1689 2025-07-18 12937.5 ... 2025-07-18 17:50:39.891142 2025-07-18 17:50:39.891536
[1 rows x 5 columns]
2025-07-18 17:50:39,918 - IOOppi_data - INFO : save diff data to db: IOOppi_ss_t: no diff data
2025-07-18 17:50:39,926 - IOOppi_data - INFO : save data to db IOOppi_ss_g data:
date value
1685 2025-07-14 12900.0
1686 2025-07-15 12900.0
1687 2025-07-16 12950.0
1688 2025-07-17 12950.0
1689 2025-07-18 12937.5
2025-07-18 17:50:39,975 - IOOppi_data - INFO : save new data to db IOOppi_ss_g: date value ... created_at updated_at
1692 2025-07-18 12937.5 ... 2025-07-18 17:50:39.967661 2025-07-18 17:50:39.968168
[1 rows x 5 columns]
2025-07-18 17:50:39,993 - 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-18 17:50:40,564 - IOOppi_data - INFO : save data to db IOOppi_RS_t data:
date value
3195 2025-07-14 9541.67
3196 2025-07-15 9533.33
3197 2025-07-16 9581.67
3198 2025-07-17 9581.67
3199 2025-07-18 9691.67
2025-07-18 17:50:40,638 - IOOppi_data - INFO : save new data to db IOOppi_RS_t: date value ... created_at updated_at
3199 2025-07-18 9691.67 ... 2025-07-18 17:50:40.631168 2025-07-18 17:50:40.631545
[1 rows x 5 columns]
2025-07-18 17:50:40,655 - IOOppi_data - INFO : save diff data to db: IOOppi_RS_t: no diff data
2025-07-18 17:50:40,661 - IOOppi_data - INFO : save data to db IOOppi_RS_g data:
date value
3195 2025-07-14 9541.67
3196 2025-07-15 9533.33
3197 2025-07-16 9581.67
3198 2025-07-17 9581.67
3199 2025-07-18 9691.67
2025-07-18 17:50:40,726 - IOOppi_data - INFO : save new data to db IOOppi_RS_g: date value ... created_at updated_at
3203 2025-07-18 9691.67 ... 2025-07-18 17:50:40.719518 2025-07-18 17:50:40.719926
[1 rows x 5 columns]
2025-07-18 17:50:40,744 - 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-18 17:50:41,310 - IOOppi_data - INFO : save data to db IOOppi_RM_t data:
date value
3318 2025-07-14 2566.67
3319 2025-07-15 2581.67
3320 2025-07-16 2576.67
3321 2025-07-17 2576.67
3322 2025-07-18 2668.33
2025-07-18 17:50:41,377 - IOOppi_data - INFO : save new data to db IOOppi_RM_t: date value ... created_at updated_at
3322 2025-07-18 2668.33 ... 2025-07-18 17:50:41.370034 2025-07-18 17:50:41.370436
[1 rows x 5 columns]
2025-07-18 17:50:41,395 - IOOppi_data - INFO : save diff data to db: IOOppi_RM_t: no diff data
2025-07-18 17:50:41,401 - IOOppi_data - INFO : save data to db IOOppi_RM_g data:
date value
3318 2025-07-14 2566.67
3319 2025-07-15 2581.67
3320 2025-07-16 2576.67
3321 2025-07-17 2576.67
3322 2025-07-18 2668.33
2025-07-18 17:50:41,468 - IOOppi_data - INFO : save new data to db IOOppi_RM_g: date value ... created_at updated_at
3326 2025-07-18 2668.33 ... 2025-07-18 17:50:41.460872 2025-07-18 17:50:41.461326
[1 rows x 5 columns]
2025-07-18 17:50:41,486 - 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-18 17:50:42,050 - IOOppi_data - INFO : save data to db IOOppi_SA_t data:
date value
1522 2025-07-14 1247.5
1523 2025-07-15 1247.5
1524 2025-07-16 1247.5
1525 2025-07-17 1250.0
1526 2025-07-18 1250.0
2025-07-18 17:50:42,094 - IOOppi_data - INFO : save new data to db IOOppi_SA_t: date value ... created_at updated_at
1526 2025-07-18 1250.0 ... 2025-07-18 17:50:42.087390 2025-07-18 17:50:42.087811
[1 rows x 5 columns]
2025-07-18 17:50:42,112 - IOOppi_data - INFO : save diff data to db: IOOppi_SA_t: no diff data
2025-07-18 17:50:42,118 - IOOppi_data - INFO : save data to db IOOppi_SA_g data:
date value
1522 2025-07-14 1247.5
1523 2025-07-15 1247.5
1524 2025-07-16 1247.5
1525 2025-07-17 1250.0
1526 2025-07-18 1250.0
2025-07-18 17:50:42,163 - IOOppi_data - INFO : save new data to db IOOppi_SA_g: date value ... created_at updated_at
1530 2025-07-18 1250.0 ... 2025-07-18 17:50:42.156068 2025-07-18 17:50:42.156525
[1 rows x 5 columns]
2025-07-18 17:50:42,181 - 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-18 17:50:42,864 - IOOppi_data - INFO : save data to db IOOppi_PF_t data:
date value
1435 2025-07-14 6667.08
1436 2025-07-15 6646.46
1437 2025-07-16 6633.96
1438 2025-07-17 6626.04
1439 2025-07-18 6643.33
2025-07-18 17:50:42,909 - IOOppi_data - INFO : save new data to db IOOppi_PF_t: date value ... created_at updated_at
1439 2025-07-18 6643.33 ... 2025-07-18 17:50:42.901504 2025-07-18 17:50:42.901919
[1 rows x 5 columns]
2025-07-18 17:50:42,927 - IOOppi_data - INFO : save diff data to db: IOOppi_PF_t: no diff data
2025-07-18 17:50:42,932 - IOOppi_data - INFO : save data to db IOOppi_PF_g data:
date value
1435 2025-07-14 6667.08
1436 2025-07-15 6646.46
1437 2025-07-16 6633.96
1438 2025-07-17 6626.04
1439 2025-07-18 6643.33
2025-07-18 17:50:42,978 - IOOppi_data - INFO : save new data to db IOOppi_PF_g: date value ... created_at updated_at
1443 2025-07-18 6643.33 ... 2025-07-18 17:50:42.970692 2025-07-18 17:50:42.971149
[1 rows x 5 columns]
2025-07-18 17:50:42,996 - 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-18 17:50:43,721 - IOOppi_data - INFO : save data to db IOOppi_m_t data:
date value
3808 2025-07-14 2912.0
3809 2025-07-15 2924.0
3810 2025-07-16 2916.0
3811 2025-07-17 2952.0
3812 2025-07-18 2966.0
2025-07-18 17:50:43,796 - IOOppi_data - INFO : save new data to db IOOppi_m_t: date value ... created_at updated_at
3812 2025-07-18 2966.0 ... 2025-07-18 17:50:43.789306 2025-07-18 17:50:43.789690
[1 rows x 5 columns]
2025-07-18 17:50:43,815 - IOOppi_data - INFO : save diff data to db: IOOppi_m_t: no diff data
2025-07-18 17:50:43,821 - IOOppi_data - INFO : save data to db IOOppi_m_g data:
date value
3808 2025-07-14 2912.0
3809 2025-07-15 2924.0
3810 2025-07-16 2916.0
3811 2025-07-17 2952.0
3812 2025-07-18 2966.0
2025-07-18 17:50:43,897 - IOOppi_data - INFO : save new data to db IOOppi_m_g: date value ... created_at updated_at
3815 2025-07-18 2966.0 ... 2025-07-18 17:50:43.890342 2025-07-18 17:50:43.890729
[1 rows x 5 columns]
2025-07-18 17:50:43,916 - 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-18 17:50:44,504 - IOOppi_data - INFO : save data to db IOOppi_y_t data:
date value
3578 2025-07-14 8254.0
3579 2025-07-15 8264.0
3580 2025-07-16 8304.0
3581 2025-07-17 8304.0
3582 2025-07-18 8414.0
2025-07-18 17:50:44,575 - IOOppi_data - INFO : save new data to db IOOppi_y_t: date value ... created_at updated_at
3582 2025-07-18 8414.0 ... 2025-07-18 17:50:44.568398 2025-07-18 17:50:44.568809
[1 rows x 5 columns]
2025-07-18 17:50:44,594 - IOOppi_data - INFO : save diff data to db: IOOppi_y_t: no diff data
2025-07-18 17:50:44,600 - IOOppi_data - INFO : save data to db IOOppi_y_g data:
date value
3578 2025-07-14 8254.0
3579 2025-07-15 8264.0
3580 2025-07-16 8304.0
3581 2025-07-17 8304.0
3582 2025-07-18 8414.0
2025-07-18 17:50:44,673 - IOOppi_data - INFO : save new data to db IOOppi_y_g: date value ... created_at updated_at
3585 2025-07-18 8414.0 ... 2025-07-18 17:50:44.666585 2025-07-18 17:50:44.666994
[1 rows x 5 columns]
2025-07-18 17:50:44,692 - 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-18 17:50:45,302 - IOOppi_data - INFO : save data to db IOOppi_a_t data:
date value
3544 2025-07-14 4295.0
3545 2025-07-15 4295.0
3546 2025-07-16 4295.0
3547 2025-07-17 4295.0
3548 2025-07-18 4295.0
2025-07-18 17:50:45,371 - IOOppi_data - INFO : save new data to db IOOppi_a_t: date value ... created_at updated_at
3548 2025-07-18 4295.0 ... 2025-07-18 17:50:45.364708 2025-07-18 17:50:45.365144
[1 rows x 5 columns]
2025-07-18 17:50:45,390 - IOOppi_data - INFO : save diff data to db: IOOppi_a_t: no diff data
2025-07-18 17:50:45,396 - IOOppi_data - INFO : save data to db IOOppi_a_g data:
date value
3544 2025-07-14 4295.0
3545 2025-07-15 4295.0
3546 2025-07-16 4295.0
3547 2025-07-17 4295.0
3548 2025-07-18 4295.0
2025-07-18 17:50:45,465 - IOOppi_data - INFO : save new data to db IOOppi_a_g: date value ... created_at updated_at
3551 2025-07-18 4295.0 ... 2025-07-18 17:50:45.458394 2025-07-18 17:50:45.458795
[1 rows x 5 columns]
2025-07-18 17:50:45,483 - 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-18 17:50:46,101 - IOOppi_data - INFO : save data to db IOOppi_SF_t data:
date value
2921 2025-07-14 5202.86
2922 2025-07-15 5202.86
2923 2025-07-16 5202.86
2924 2025-07-17 5185.71
2925 2025-07-18 5221.43
2025-07-18 17:50:46,162 - IOOppi_data - INFO : save new data to db IOOppi_SF_t: date value ... created_at updated_at
2925 2025-07-18 5221.43 ... 2025-07-18 17:50:46.154893 2025-07-18 17:50:46.155283
[1 rows x 5 columns]
2025-07-18 17:50:46,181 - IOOppi_data - INFO : save diff data to db: IOOppi_SF_t: no diff data
2025-07-18 17:50:46,186 - IOOppi_data - INFO : save data to db IOOppi_SF_g data:
date value
2921 2025-07-14 5202.86
2922 2025-07-15 5202.86
2923 2025-07-16 5202.86
2924 2025-07-17 5185.71
2925 2025-07-18 5221.43
2025-07-18 17:50:46,247 - IOOppi_data - INFO : save new data to db IOOppi_SF_g: date value ... created_at updated_at
2929 2025-07-18 5221.43 ... 2025-07-18 17:50:46.240646 2025-07-18 17:50:46.241054
[1 rows x 5 columns]
2025-07-18 17:50:46,265 - 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-18 17:50:46,799 - IOOppi_data - INFO : save data to db IOOppi_jd_t data:
date value
3121 2025-07-14 2875.0
3122 2025-07-15 2875.0
3123 2025-07-16 2885.0
3124 2025-07-17 2885.0
3125 2025-07-18 3050.0
2025-07-18 17:50:46,867 - IOOppi_data - INFO : save new data to db IOOppi_jd_t: date value ... created_at updated_at
3125 2025-07-18 3050.0 ... 2025-07-18 17:50:46.859564 2025-07-18 17:50:46.859970
[1 rows x 5 columns]
/root/project/IOOppi_data/IOOppi_request.py:308: SettingWithCopyWarning:
A value is trying to be set on a copy of a slice from a DataFrame.
Try using .loc[row_indexer,col_indexer] = value instead
See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy
diff_df.loc[:, 'index_code'] = index_code
/root/project/IOOppi_data/IOOppi_request.py:309: SettingWithCopyWarning:
A value is trying to be set on a copy of a slice from a DataFrame.
Try using .loc[row_indexer,col_indexer] = value instead
See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy
diff_df.loc[:, 'created_at'] = datetime.datetime.now()
/root/project/IOOppi_data/IOOppi_request.py:310: SettingWithCopyWarning:
A value is trying to be set on a copy of a slice from a DataFrame.
Try using .loc[row_indexer,col_indexer] = value instead
See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy
diff_df.loc[:, 'updated_at'] = datetime.datetime.now()
2025-07-18 17:50:47,011 - IOOppi_data - INFO : save diff data to db IOOppi_jd_t: date ... updated_at
39 2014-01-03 ... 2025-07-18 17:50:47.003535
458 2015-09-21 ... 2025-07-18 17:50:47.003535
549 2016-02-03 ... 2025-07-18 17:50:47.003535
693 2016-09-05 ... 2025-07-18 17:50:47.003535
696 2016-09-08 ... 2025-07-18 17:50:47.003535
[5 rows x 6 columns]
2025-07-18 17:50:47,040 - IOOppi_data - INFO : save data to db IOOppi_jd_g data:
date value
3121 2025-07-14 2875.0
3122 2025-07-15 2875.0
3123 2025-07-16 2885.0
3124 2025-07-17 2885.0
3125 2025-07-18 3050.0
2025-07-18 17:50:47,110 - IOOppi_data - INFO : save new data to db IOOppi_jd_g: date value ... created_at updated_at
3128 2025-07-18 3050.0 ... 2025-07-18 17:50:47.099683 2025-07-18 17:50:47.100331
[1 rows x 5 columns]
/root/project/IOOppi_data/IOOppi_request.py:308: SettingWithCopyWarning:
A value is trying to be set on a copy of a slice from a DataFrame.
Try using .loc[row_indexer,col_indexer] = value instead
See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy
diff_df.loc[:, 'index_code'] = index_code
/root/project/IOOppi_data/IOOppi_request.py:309: SettingWithCopyWarning:
A value is trying to be set on a copy of a slice from a DataFrame.
Try using .loc[row_indexer,col_indexer] = value instead
See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy
diff_df.loc[:, 'created_at'] = datetime.datetime.now()
/root/project/IOOppi_data/IOOppi_request.py:310: SettingWithCopyWarning:
A value is trying to be set on a copy of a slice from a DataFrame.
Try using .loc[row_indexer,col_indexer] = value instead
See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy
diff_df.loc[:, 'updated_at'] = datetime.datetime.now()
2025-07-18 17:50:47,256 - IOOppi_data - INFO : save diff data to db IOOppi_jd_g: date ... updated_at
39 2014-01-03 ... 2025-07-18 17:50:47.248512
458 2015-09-21 ... 2025-07-18 17:50:47.248512
549 2016-02-03 ... 2025-07-18 17:50:47.248512
693 2016-09-05 ... 2025-07-18 17:50:47.248512
696 2016-09-08 ... 2025-07-18 17:50:47.248512
[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-18 17:50:48,051 - IOOppi_data - INFO : save data to db IOOppi_SI_t data:
date value
925 2025-07-14 9090.0
926 2025-07-15 9330.0
927 2025-07-16 9380.0
928 2025-07-17 9380.0
929 2025-07-18 9500.0
2025-07-18 17:50:48,089 - IOOppi_data - INFO : save new data to db IOOppi_SI_t: date value ... created_at updated_at
929 2025-07-18 9500.0 ... 2025-07-18 17:50:48.081127 2025-07-18 17:50:48.081518
[1 rows x 5 columns]
2025-07-18 17:50:48,107 - IOOppi_data - INFO : save diff data to db: IOOppi_SI_t: no diff data
2025-07-18 17:50:48,114 - IOOppi_data - INFO : save data to db IOOppi_SI_g data:
date value
925 2025-07-14 9090.0
926 2025-07-15 9330.0
927 2025-07-16 9380.0
928 2025-07-17 9380.0
929 2025-07-18 9500.0
2025-07-18 17:50:48,151 - IOOppi_data - INFO : save new data to db IOOppi_SI_g: date value ... created_at updated_at
929 2025-07-18 9500.0 ... 2025-07-18 17:50:48.144446 2025-07-18 17:50:48.144862
[1 rows x 5 columns]
2025-07-18 17:50:48,170 - 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-18 17:50:48,763 - IOOppi_data - INFO : save data to db IOOppi_l_t data:
date value
3804 2025-07-14 7411.67
3805 2025-07-15 7393.33
3806 2025-07-16 7393.33
3807 2025-07-17 7373.33
3808 2025-07-18 7378.33
2025-07-18 17:50:48,836 - IOOppi_data - INFO : save new data to db IOOppi_l_t: date value ... created_at updated_at
3808 2025-07-18 7378.33 ... 2025-07-18 17:50:48.828940 2025-07-18 17:50:48.829333
[1 rows x 5 columns]
2025-07-18 17:50:48,854 - IOOppi_data - INFO : save diff data to db: IOOppi_l_t: no diff data
2025-07-18 17:50:48,861 - IOOppi_data - INFO : save data to db IOOppi_l_g data:
date value
3804 2025-07-14 7411.67
3805 2025-07-15 7393.33
3806 2025-07-16 7393.33
3807 2025-07-17 7373.33
3808 2025-07-18 7378.33
2025-07-18 17:50:48,933 - IOOppi_data - INFO : save new data to db IOOppi_l_g: date value ... created_at updated_at
3811 2025-07-18 7378.33 ... 2025-07-18 17:50:48.926304 2025-07-18 17:50:48.926682
[1 rows x 5 columns]
2025-07-18 17:50:48,953 - 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-18 17:50:49,621 - IOOppi_data - INFO : save data to db IOOppi_bu_t data:
date value
3142 2025-07-14 3720.00
3143 2025-07-15 3720.00
3144 2025-07-16 3713.33
3145 2025-07-17 3710.00
3146 2025-07-18 3710.00
2025-07-18 17:50:49,686 - IOOppi_data - INFO : save new data to db IOOppi_bu_t: date value ... created_at updated_at
3147 2025-07-18 3710.0 ... 2025-07-18 17:50:49.679253 2025-07-18 17:50:49.679652
[1 rows x 5 columns]
/root/project/IOOppi_data/IOOppi_request.py:308: SettingWithCopyWarning:
A value is trying to be set on a copy of a slice from a DataFrame.
Try using .loc[row_indexer,col_indexer] = value instead
See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy
diff_df.loc[:, 'index_code'] = index_code
/root/project/IOOppi_data/IOOppi_request.py:309: SettingWithCopyWarning:
A value is trying to be set on a copy of a slice from a DataFrame.
Try using .loc[row_indexer,col_indexer] = value instead
See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy
diff_df.loc[:, 'created_at'] = datetime.datetime.now()
/root/project/IOOppi_data/IOOppi_request.py:310: SettingWithCopyWarning:
A value is trying to be set on a copy of a slice from a DataFrame.
Try using .loc[row_indexer,col_indexer] = value instead
See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy
diff_df.loc[:, 'updated_at'] = datetime.datetime.now()
2025-07-18 17:50:49,725 - IOOppi_data - INFO : save diff data to db IOOppi_bu_t: date ... updated_at
2560 2023-12-09 ... 2025-07-18 17:50:49.717419
[1 rows x 6 columns]
2025-07-18 17:50:49,748 - IOOppi_data - INFO : save data to db IOOppi_bu_g data:
date value
3142 2025-07-14 3720.00
3143 2025-07-15 3720.00
3144 2025-07-16 3713.33
3145 2025-07-17 3710.00
3146 2025-07-18 3710.00
2025-07-18 17:50:49,814 - IOOppi_data - INFO : save new data to db IOOppi_bu_g: date value ... created_at updated_at
3149 2025-07-18 3710.0 ... 2025-07-18 17:50:49.806991 2025-07-18 17:50:49.807385
[1 rows x 5 columns]
2025-07-18 17:50:49,832 - 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-18 17:50:50,454 - IOOppi_data - INFO : save data to db IOOppi_al_t data:
date value
3807 2025-07-14 20806.67
3808 2025-07-15 20523.33
3809 2025-07-16 20540.00
3810 2025-07-17 20540.00
3811 2025-07-18 20720.00
2025-07-18 17:50:50,532 - IOOppi_data - INFO : save new data to db IOOppi_al_t: date value ... created_at updated_at
3811 2025-07-18 20720.0 ... 2025-07-18 17:50:50.525227 2025-07-18 17:50:50.525615
[1 rows x 5 columns]
2025-07-18 17:50:50,551 - IOOppi_data - INFO : save diff data to db: IOOppi_al_t: no diff data
2025-07-18 17:50:50,557 - IOOppi_data - INFO : save data to db IOOppi_al_g data:
date value
3807 2025-07-14 20806.67
3808 2025-07-15 20523.33
3809 2025-07-16 20540.00
3810 2025-07-17 20540.00
3811 2025-07-18 20720.00
2025-07-18 17:50:50,630 - IOOppi_data - INFO : save new data to db IOOppi_al_g: date value ... created_at updated_at
3814 2025-07-18 20720.0 ... 2025-07-18 17:50:50.622945 2025-07-18 17:50:50.623332
[1 rows x 5 columns]
2025-07-18 17:50:50,648 - 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-18 17:50:51,382 - IOOppi_data - INFO : save data to db IOOppi_SM_t data:
date value
2921 2025-07-14 5630.0
2922 2025-07-15 5644.0
2923 2025-07-16 5630.0
2924 2025-07-17 5622.0
2925 2025-07-18 5652.0
2025-07-18 17:50:51,443 - IOOppi_data - INFO : save new data to db IOOppi_SM_t: date value ... created_at updated_at
2925 2025-07-18 5652.0 ... 2025-07-18 17:50:51.436816 2025-07-18 17:50:51.437204
[1 rows x 5 columns]
2025-07-18 17:50:51,461 - IOOppi_data - INFO : save diff data to db: IOOppi_SM_t: no diff data
2025-07-18 17:50:51,467 - IOOppi_data - INFO : save data to db IOOppi_SM_g data:
date value
2921 2025-07-14 5630.0
2922 2025-07-15 5644.0
2923 2025-07-16 5630.0
2924 2025-07-17 5622.0
2925 2025-07-18 5652.0
2025-07-18 17:50:51,529 - IOOppi_data - INFO : save new data to db IOOppi_SM_g: date value ... created_at updated_at
2929 2025-07-18 5652.0 ... 2025-07-18 17:50:51.522202 2025-07-18 17:50:51.522590
[1 rows x 5 columns]
2025-07-18 17:50:51,547 - 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-18 17:50:52,172 - IOOppi_data - INFO : save data to db IOOppi_CY_t data:
date value
2196 2025-07-14 23200.0
2197 2025-07-15 23275.0
2198 2025-07-16 23275.0
2199 2025-07-17 23275.0
2200 2025-07-18 23275.0
2025-07-18 17:50:52,225 - IOOppi_data - INFO : save new data to db IOOppi_CY_t: date value ... created_at updated_at
2200 2025-07-18 23275.0 ... 2025-07-18 17:50:52.218461 2025-07-18 17:50:52.218892
[1 rows x 5 columns]
2025-07-18 17:50:52,243 - IOOppi_data - INFO : save diff data to db: IOOppi_CY_t: no diff data
2025-07-18 17:50:52,249 - IOOppi_data - INFO : save data to db IOOppi_CY_g data:
date value
2196 2025-07-14 23200.0
2197 2025-07-15 23275.0
2198 2025-07-16 23275.0
2199 2025-07-17 23275.0
2200 2025-07-18 23275.0
2025-07-18 17:50:52,301 - IOOppi_data - INFO : save new data to db IOOppi_CY_g: date value ... created_at updated_at
2204 2025-07-18 23275.0 ... 2025-07-18 17:50:52.294359 2025-07-18 17:50:52.294736
[1 rows x 5 columns]
2025-07-18 17:50:52,319 - 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-18 17:50:53,028 - IOOppi_data - INFO : save data to db IOOppi_UR_t data:
date value
1711 2025-07-14 1838.75
1712 2025-07-15 1837.50
1713 2025-07-16 1827.50
1714 2025-07-17 1825.00
1715 2025-07-18 1830.00
2025-07-18 17:50:53,075 - IOOppi_data - INFO : save new data to db IOOppi_UR_t: date value ... created_at updated_at
1715 2025-07-18 1830.0 ... 2025-07-18 17:50:53.067919 2025-07-18 17:50:53.068369
[1 rows x 5 columns]
2025-07-18 17:50:53,092 - IOOppi_data - INFO : save diff data to db: IOOppi_UR_t: no diff data
2025-07-18 17:50:53,098 - IOOppi_data - INFO : save data to db IOOppi_UR_g data:
date value
1711 2025-07-14 1838.75
1712 2025-07-15 1837.50
1713 2025-07-16 1827.50
1714 2025-07-17 1825.00
1715 2025-07-18 1830.00
2025-07-18 17:50:53,144 - IOOppi_data - INFO : save new data to db IOOppi_UR_g: date value ... created_at updated_at
1719 2025-07-18 1830.0 ... 2025-07-18 17:50:53.137281 2025-07-18 17:50:53.137664
[1 rows x 5 columns]
2025-07-18 17:50:53,163 - 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-18 17:50:53,897 - IOOppi_data - INFO : save data to db IOOppi_ni_t data:
date value
2783 2025-07-14 122100.00
2784 2025-07-15 120666.67
2785 2025-07-16 122216.67
2786 2025-07-17 120800.00
2787 2025-07-18 121800.00
2025-07-18 17:50:53,956 - IOOppi_data - INFO : save new data to db IOOppi_ni_t: date ... updated_at
2787 2025-07-18 ... 2025-07-18 17:50:53.949830
[1 rows x 5 columns]
2025-07-18 17:50:53,974 - IOOppi_data - INFO : save diff data to db: IOOppi_ni_t: no diff data
2025-07-18 17:50:53,980 - IOOppi_data - INFO : save data to db IOOppi_ni_g data:
date value
2783 2025-07-14 122100.00
2784 2025-07-15 120666.67
2785 2025-07-16 122216.67
2786 2025-07-17 120800.00
2787 2025-07-18 121800.00
2025-07-18 17:50:54,039 - IOOppi_data - INFO : save new data to db IOOppi_ni_g: date ... updated_at
2790 2025-07-18 ... 2025-07-18 17:50:54.033284
[1 rows x 5 columns]
2025-07-18 17:50:54,057 - 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-18 17:50:54,661 - IOOppi_data - INFO : save data to db IOOppi_v_t data:
date value
3808 2025-07-14 4720.0
3809 2025-07-15 4745.0
3810 2025-07-16 4736.0
3811 2025-07-17 4710.0
3812 2025-07-18 4712.0
2025-07-18 17:50:54,753 - IOOppi_data - INFO : save new data to db IOOppi_v_t: date value ... created_at updated_at
3812 2025-07-18 4712.0 ... 2025-07-18 17:50:54.743389 2025-07-18 17:50:54.744002
[1 rows x 5 columns]
2025-07-18 17:50:54,772 - IOOppi_data - INFO : save diff data to db: IOOppi_v_t: no diff data
2025-07-18 17:50:54,779 - IOOppi_data - INFO : save data to db IOOppi_v_g data:
date value
3808 2025-07-14 4720.0
3809 2025-07-15 4745.0
3810 2025-07-16 4736.0
3811 2025-07-17 4710.0
3812 2025-07-18 4712.0
2025-07-18 17:50:54,854 - IOOppi_data - INFO : save new data to db IOOppi_v_g: date value ... created_at updated_at
3815 2025-07-18 4712.0 ... 2025-07-18 17:50:54.847347 2025-07-18 17:50:54.847727
[1 rows x 5 columns]
2025-07-18 17:50:54,872 - 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-18 17:50:55,561 - IOOppi_data - INFO : save data to db IOOppi_pp_t data:
date value
3047 2025-07-14 7355.00
3048 2025-07-15 7366.67
3049 2025-07-16 7358.33
3050 2025-07-17 7321.67
3051 2025-07-18 7313.33
2025-07-18 17:50:55,625 - IOOppi_data - INFO : save new data to db IOOppi_pp_t: date value ... created_at updated_at
3051 2025-07-18 7313.33 ... 2025-07-18 17:50:55.618211 2025-07-18 17:50:55.618595
[1 rows x 5 columns]
2025-07-18 17:50:55,642 - IOOppi_data - INFO : save diff data to db: IOOppi_pp_t: no diff data
2025-07-18 17:50:55,648 - IOOppi_data - INFO : save data to db IOOppi_pp_g data:
date value
3047 2025-07-14 7355.00
3048 2025-07-15 7366.67
3049 2025-07-16 7358.33
3050 2025-07-17 7321.67
3051 2025-07-18 7313.33
2025-07-18 17:50:55,711 - IOOppi_data - INFO : save new data to db IOOppi_pp_g: date value ... created_at updated_at
3054 2025-07-18 7313.33 ... 2025-07-18 17:50:55.703887 2025-07-18 17:50:55.704279
[1 rows x 5 columns]
2025-07-18 17:50:55,728 - 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-18 17:50:56,406 - IOOppi_data - INFO : save data to db IOOppi_CF_t data:
date value
3809 2025-07-14 15312.67
3810 2025-07-15 15327.50
3811 2025-07-16 15291.33
3812 2025-07-17 15375.33
3813 2025-07-18 15522.67
2025-07-18 17:50:56,478 - IOOppi_data - INFO : save new data to db IOOppi_CF_t: date ... updated_at
3813 2025-07-18 ... 2025-07-18 17:50:56.472167
[1 rows x 5 columns]
2025-07-18 17:50:56,496 - IOOppi_data - INFO : save diff data to db: IOOppi_CF_t: no diff data
2025-07-18 17:50:56,502 - IOOppi_data - INFO : save data to db IOOppi_CF_g data:
date value
3809 2025-07-14 15312.67
3810 2025-07-15 15327.50
3811 2025-07-16 15291.33
3812 2025-07-17 15375.33
3813 2025-07-18 15522.67
2025-07-18 17:50:56,574 - IOOppi_data - INFO : save new data to db IOOppi_CF_g: date ... updated_at
3817 2025-07-18 ... 2025-07-18 17:50:56.567851
[1 rows x 5 columns]
2025-07-18 17:50:56,593 - 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-18 17:50:57,197 - IOOppi_data - INFO : save data to db IOOppi_pb_t data:
date value
3754 2025-07-14 16937.50
3755 2025-07-15 16925.00
3756 2025-07-16 16825.00
3757 2025-07-17 16762.50
3758 2025-07-18 16756.25
2025-07-18 17:50:57,267 - IOOppi_data - INFO : save new data to db IOOppi_pb_t: date ... updated_at
3758 2025-07-18 ... 2025-07-18 17:50:57.261562
[1 rows x 5 columns]
2025-07-18 17:50:57,286 - IOOppi_data - INFO : save diff data to db: IOOppi_pb_t: no diff data
2025-07-18 17:50:57,291 - IOOppi_data - INFO : save data to db IOOppi_pb_g data:
date value
3754 2025-07-14 16937.50
3755 2025-07-15 16925.00
3756 2025-07-16 16825.00
3757 2025-07-17 16762.50
3758 2025-07-18 16756.25
2025-07-18 17:50:57,435 - IOOppi_data - INFO : save new data to db IOOppi_pb_g: date ... updated_at
3761 2025-07-18 ... 2025-07-18 17:50:57.428985
[1 rows x 5 columns]
2025-07-18 17:50:57,453 - 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-18 17:50:58,222 - IOOppi_data - INFO : save data to db IOOppi_hc_t data:
date value
3029 2025-07-14 3333.33
3030 2025-07-15 3333.33
3031 2025-07-16 3326.67
3032 2025-07-17 3343.33
3033 2025-07-18 3380.00
2025-07-18 17:50:58,288 - IOOppi_data - INFO : save new data to db IOOppi_hc_t: date value ... created_at updated_at
3033 2025-07-18 3380.0 ... 2025-07-18 17:50:58.280668 2025-07-18 17:50:58.281121
[1 rows x 5 columns]
2025-07-18 17:50:58,309 - IOOppi_data - INFO : save diff data to db: IOOppi_hc_t: no diff data
2025-07-18 17:50:58,316 - IOOppi_data - INFO : save data to db IOOppi_hc_g data:
date value
3029 2025-07-14 3333.33
3030 2025-07-15 3333.33
3031 2025-07-16 3326.67
3032 2025-07-17 3343.33
3033 2025-07-18 3380.00
2025-07-18 17:50:58,380 - IOOppi_data - INFO : save new data to db IOOppi_hc_g: date value ... created_at updated_at
3036 2025-07-18 3380.0 ... 2025-07-18 17:50:58.373528 2025-07-18 17:50:58.373939
[1 rows x 5 columns]
2025-07-18 17:50:58,399 - 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-18 17:50:59,076 - IOOppi_data - INFO : save data to db IOOppi_fu_t data:
date value
3309 2025-07-14 5387.5
3310 2025-07-15 5387.5
3311 2025-07-16 5387.5
3312 2025-07-17 5325.0
3313 2025-07-18 5325.0
2025-07-18 17:50:59,143 - IOOppi_data - INFO : save new data to db IOOppi_fu_t: date value ... created_at updated_at
3313 2025-07-18 5325.0 ... 2025-07-18 17:50:59.136014 2025-07-18 17:50:59.136409
[1 rows x 5 columns]
2025-07-18 17:50:59,160 - IOOppi_data - INFO : save diff data to db: IOOppi_fu_t: no diff data
2025-07-18 17:50:59,166 - IOOppi_data - INFO : save data to db IOOppi_fu_g data:
date value
3309 2025-07-14 5387.5
3310 2025-07-15 5387.5
3311 2025-07-16 5387.5
3312 2025-07-17 5325.0
3313 2025-07-18 5325.0
2025-07-18 17:50:59,239 - IOOppi_data - INFO : save new data to db IOOppi_fu_g: date value ... created_at updated_at
3800 2025-07-18 5325.0 ... 2025-07-18 17:50:59.232019 2025-07-18 17:50:59.232410
[1 rows x 5 columns]
2025-07-18 17:50:59,257 - 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-18 17:50:59,782 - IOOppi_data - INFO : save data to db IOOppi_lh_t data:
date value
1373 2025-07-14 14730.0
1374 2025-07-15 14670.0
1375 2025-07-16 14600.0
1376 2025-07-17 14600.0
1377 2025-07-18 14500.0
2025-07-18 17:50:59,825 - IOOppi_data - INFO : save new data to db IOOppi_lh_t: date value ... created_at updated_at
1377 2025-07-18 14500.0 ... 2025-07-18 17:50:59.817561 2025-07-18 17:50:59.818007
[1 rows x 5 columns]
/root/project/IOOppi_data/IOOppi_request.py:308: SettingWithCopyWarning:
A value is trying to be set on a copy of a slice from a DataFrame.
Try using .loc[row_indexer,col_indexer] = value instead
See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy
diff_df.loc[:, 'index_code'] = index_code
/root/project/IOOppi_data/IOOppi_request.py:309: SettingWithCopyWarning:
A value is trying to be set on a copy of a slice from a DataFrame.
Try using .loc[row_indexer,col_indexer] = value instead
See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy
diff_df.loc[:, 'created_at'] = datetime.datetime.now()
/root/project/IOOppi_data/IOOppi_request.py:310: SettingWithCopyWarning:
A value is trying to be set on a copy of a slice from a DataFrame.
Try using .loc[row_indexer,col_indexer] = value instead
See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy
diff_df.loc[:, 'updated_at'] = datetime.datetime.now()
2025-07-18 17:51:00,053 - IOOppi_data - INFO : save diff data to db IOOppi_lh_t: date ... updated_at
116 2021-07-05 ... 2025-07-18 17:51:00.045419
117 2021-07-06 ... 2025-07-18 17:51:00.045419
121 2021-07-12 ... 2025-07-18 17:51:00.045419
122 2021-07-13 ... 2025-07-18 17:51:00.045419
194 2021-11-01 ... 2025-07-18 17:51:00.045419
[5 rows x 6 columns]
2025-07-18 17:51:00,090 - IOOppi_data - INFO : save data to db IOOppi_lh_g data:
date value
1373 2025-07-14 14730.0
1374 2025-07-15 14670.0
1375 2025-07-16 14600.0
1376 2025-07-17 14600.0
1377 2025-07-18 14500.0
2025-07-18 17:51:00,134 - IOOppi_data - INFO : save new data to db IOOppi_lh_g: date value ... created_at updated_at
1380 2025-07-18 14500.0 ... 2025-07-18 17:51:00.126893 2025-07-18 17:51:00.127293
[1 rows x 5 columns]
/root/project/IOOppi_data/IOOppi_request.py:308: SettingWithCopyWarning:
A value is trying to be set on a copy of a slice from a DataFrame.
Try using .loc[row_indexer,col_indexer] = value instead
See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy
diff_df.loc[:, 'index_code'] = index_code
/root/project/IOOppi_data/IOOppi_request.py:309: SettingWithCopyWarning:
A value is trying to be set on a copy of a slice from a DataFrame.
Try using .loc[row_indexer,col_indexer] = value instead
See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy
diff_df.loc[:, 'created_at'] = datetime.datetime.now()
/root/project/IOOppi_data/IOOppi_request.py:310: SettingWithCopyWarning:
A value is trying to be set on a copy of a slice from a DataFrame.
Try using .loc[row_indexer,col_indexer] = value instead
See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy
diff_df.loc[:, 'updated_at'] = datetime.datetime.now()
2025-07-18 17:51:00,360 - IOOppi_data - INFO : save diff data to db IOOppi_lh_g: date ... updated_at
116 2021-07-05 ... 2025-07-18 17:51:00.353194
117 2021-07-06 ... 2025-07-18 17:51:00.353194
121 2021-07-12 ... 2025-07-18 17:51:00.353194
122 2021-07-13 ... 2025-07-18 17:51:00.353194
194 2021-11-01 ... 2025-07-18 17:51:00.353194
[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-18 17:51:01,044 - IOOppi_data - INFO : save data to db IOOppi_cu_t data:
date value
3805 2025-07-14 78513.33
3806 2025-07-15 78135.00
3807 2025-07-16 78096.67
3808 2025-07-17 78055.00
3809 2025-07-18 78678.33
2025-07-18 17:51:01,117 - IOOppi_data - INFO : save new data to db IOOppi_cu_t: date ... updated_at
3809 2025-07-18 ... 2025-07-18 17:51:01.111142
[1 rows x 5 columns]
2025-07-18 17:51:01,135 - IOOppi_data - INFO : save diff data to db: IOOppi_cu_t: no diff data
2025-07-18 17:51:01,141 - IOOppi_data - INFO : save data to db IOOppi_cu_g data:
date value
3805 2025-07-14 78513.33
3806 2025-07-15 78135.00
3807 2025-07-16 78096.67
3808 2025-07-17 78055.00
3809 2025-07-18 78678.33
2025-07-18 17:51:01,218 - IOOppi_data - INFO : save new data to db IOOppi_cu_g: date ... updated_at
3812 2025-07-18 ... 2025-07-18 17:51:01.211786
[1 rows x 5 columns]
2025-07-18 17:51:01,236 - 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-18 17:51:01,728 - 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-18 17:51:01,782 - IOOppi_data - INFO : save new data to db: IOOppi_PM_t: no new data
2025-07-18 17:51:01,782 - IOOppi_data - INFO : save diff data to db: IOOppi_PM_t: no diff data
2025-07-18 17:51:01,788 - 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-18 17:51:01,849 - IOOppi_data - INFO : save new data to db: IOOppi_PM_g: no new data
2025-07-18 17:51:01,849 - 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-18 17:51:02,489 - IOOppi_data - INFO : save data to db IOOppi_sn_t data:
date value
2783 2025-07-14 266512.5
2784 2025-07-15 264687.5
2785 2025-07-16 263625.0
2786 2025-07-17 261962.5
2787 2025-07-18 265575.0
2025-07-18 17:51:02,549 - IOOppi_data - INFO : save new data to db IOOppi_sn_t: date ... updated_at
2787 2025-07-18 ... 2025-07-18 17:51:02.542903
[1 rows x 5 columns]
2025-07-18 17:51:02,569 - IOOppi_data - INFO : save diff data to db: IOOppi_sn_t: no diff data
2025-07-18 17:51:02,575 - IOOppi_data - INFO : save data to db IOOppi_sn_g data:
date value
2783 2025-07-14 266512.5
2784 2025-07-15 264687.5
2785 2025-07-16 263625.0
2786 2025-07-17 261962.5
2787 2025-07-18 265575.0
2025-07-18 17:51:02,635 - IOOppi_data - INFO : save new data to db IOOppi_sn_g: date ... updated_at
2790 2025-07-18 ... 2025-07-18 17:51:02.629049
[1 rows x 5 columns]
2025-07-18 17:51:02,654 - 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-18 17:51:03,282 - IOOppi_data - INFO : save data to db IOOppi_zn_t data:
date value
3804 2025-07-14 22154.0
3805 2025-07-15 22118.0
3806 2025-07-16 22018.0
3807 2025-07-17 22082.0
3808 2025-07-18 22306.0
2025-07-18 17:51:03,355 - IOOppi_data - INFO : save new data to db IOOppi_zn_t: date value ... created_at updated_at
3808 2025-07-18 22306.0 ... 2025-07-18 17:51:03.346984 2025-07-18 17:51:03.347378
[1 rows x 5 columns]
2025-07-18 17:51:03,375 - IOOppi_data - INFO : save diff data to db: IOOppi_zn_t: no diff data
2025-07-18 17:51:03,381 - IOOppi_data - INFO : save data to db IOOppi_zn_g data:
date value
3804 2025-07-14 22154.0
3805 2025-07-15 22118.0
3806 2025-07-16 22018.0
3807 2025-07-17 22082.0
3808 2025-07-18 22306.0
2025-07-18 17:51:03,453 - IOOppi_data - INFO : save new data to db IOOppi_zn_g: date value ... created_at updated_at
3811 2025-07-18 22306.0 ... 2025-07-18 17:51:03.446617 2025-07-18 17:51:03.447041
[1 rows x 5 columns]
2025-07-18 17:51:03,471 - 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-18 17:51:04,065 - IOOppi_data - INFO : save data to db IOOppi_wr_t data:
date value
3767 2025-07-14 3345.0
3768 2025-07-15 3345.0
3769 2025-07-16 3345.0
3770 2025-07-17 3347.5
3771 2025-07-18 3372.5
2025-07-18 17:51:04,136 - IOOppi_data - INFO : save new data to db IOOppi_wr_t: date value ... created_at updated_at
3771 2025-07-18 3372.5 ... 2025-07-18 17:51:04.129627 2025-07-18 17:51:04.130043
[1 rows x 5 columns]
2025-07-18 17:51:04,156 - IOOppi_data - INFO : save diff data to db: IOOppi_wr_t: no diff data
2025-07-18 17:51:04,162 - IOOppi_data - INFO : save data to db IOOppi_wr_g data:
date value
3767 2025-07-14 3345.0
3768 2025-07-15 3345.0
3769 2025-07-16 3345.0
3770 2025-07-17 3347.5
3771 2025-07-18 3372.5
2025-07-18 17:51:04,235 - IOOppi_data - INFO : save new data to db IOOppi_wr_g: date value ... created_at updated_at
3774 2025-07-18 3372.5 ... 2025-07-18 17:51:04.227198 2025-07-18 17:51:04.227605
[1 rows x 5 columns]
2025-07-18 17:51:04,254 - 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-18 17:51:04,883 - IOOppi_data - INFO : save data to db IOOppi_pg_t data:
date value
1564 2025-07-14 4817.5
1565 2025-07-15 4785.0
1566 2025-07-16 4747.5
1567 2025-07-17 4760.0
1568 2025-07-18 4757.5
2025-07-18 17:51:04,928 - IOOppi_data - INFO : save new data to db IOOppi_pg_t: date value ... created_at updated_at
1568 2025-07-18 4757.5 ... 2025-07-18 17:51:04.920963 2025-07-18 17:51:04.921351
[1 rows x 5 columns]
2025-07-18 17:51:04,946 - IOOppi_data - INFO : save diff data to db: IOOppi_pg_t: no diff data
2025-07-18 17:51:04,951 - IOOppi_data - INFO : save data to db IOOppi_pg_g data:
date value
1564 2025-07-14 4817.5
1565 2025-07-15 4785.0
1566 2025-07-16 4747.5
1567 2025-07-17 4760.0
1568 2025-07-18 4757.5
2025-07-18 17:51:04,996 - IOOppi_data - INFO : save new data to db IOOppi_pg_g: date value ... created_at updated_at
1571 2025-07-18 4757.5 ... 2025-07-18 17:51:04.989504 2025-07-18 17:51:04.989902
[1 rows x 5 columns]
2025-07-18 17:51:05,014 - 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-18 17:51:05,571 - IOOppi_data - INFO : save data to db IOOppi_cs_t data:
date value
2838 2025-07-14 2340.00
2839 2025-07-15 2331.43
2840 2025-07-16 2327.14
2841 2025-07-17 2327.14
2842 2025-07-18 2330.00
2025-07-18 17:51:05,630 - IOOppi_data - INFO : save new data to db IOOppi_cs_t: date value ... created_at updated_at
2842 2025-07-18 2330.0 ... 2025-07-18 17:51:05.623918 2025-07-18 17:51:05.624302
[1 rows x 5 columns]
/root/project/IOOppi_data/IOOppi_request.py:308: SettingWithCopyWarning:
A value is trying to be set on a copy of a slice from a DataFrame.
Try using .loc[row_indexer,col_indexer] = value instead
See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy
diff_df.loc[:, 'index_code'] = index_code
/root/project/IOOppi_data/IOOppi_request.py:309: SettingWithCopyWarning:
A value is trying to be set on a copy of a slice from a DataFrame.
Try using .loc[row_indexer,col_indexer] = value instead
See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy
diff_df.loc[:, 'created_at'] = datetime.datetime.now()
/root/project/IOOppi_data/IOOppi_request.py:310: SettingWithCopyWarning:
A value is trying to be set on a copy of a slice from a DataFrame.
Try using .loc[row_indexer,col_indexer] = value instead
See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy
diff_df.loc[:, 'updated_at'] = datetime.datetime.now()
2025-07-18 17:51:05,670 - IOOppi_data - INFO : save diff data to db IOOppi_cs_t: date ... updated_at
2841 2025-07-17 ... 2025-07-18 17:51:05.663106
[1 rows x 6 columns]
2025-07-18 17:51:05,693 - IOOppi_data - INFO : save data to db IOOppi_cs_g data:
date value
2838 2025-07-14 2340.00
2839 2025-07-15 2331.43
2840 2025-07-16 2327.14
2841 2025-07-17 2327.14
2842 2025-07-18 2330.00
2025-07-18 17:51:05,753 - IOOppi_data - INFO : save new data to db IOOppi_cs_g: date value ... created_at updated_at
2845 2025-07-18 2330.0 ... 2025-07-18 17:51:05.746371 2025-07-18 17:51:05.746746
[1 rows x 5 columns]
/root/project/IOOppi_data/IOOppi_request.py:308: SettingWithCopyWarning:
A value is trying to be set on a copy of a slice from a DataFrame.
Try using .loc[row_indexer,col_indexer] = value instead
See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy
diff_df.loc[:, 'index_code'] = index_code
/root/project/IOOppi_data/IOOppi_request.py:309: SettingWithCopyWarning:
A value is trying to be set on a copy of a slice from a DataFrame.
Try using .loc[row_indexer,col_indexer] = value instead
See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy
diff_df.loc[:, 'created_at'] = datetime.datetime.now()
/root/project/IOOppi_data/IOOppi_request.py:310: SettingWithCopyWarning:
A value is trying to be set on a copy of a slice from a DataFrame.
Try using .loc[row_indexer,col_indexer] = value instead
See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy
diff_df.loc[:, 'updated_at'] = datetime.datetime.now()
2025-07-18 17:51:05,794 - IOOppi_data - INFO : save diff data to db IOOppi_cs_g: date ... updated_at
2844 2025-07-17 ... 2025-07-18 17:51:05.786603
[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-18 17:51:06,425 - IOOppi_data - INFO : save data to db IOOppi_cs_t data:
date value
2838 2025-07-14 2340.00
2839 2025-07-15 2331.43
2840 2025-07-16 2327.14
2841 2025-07-17 2327.14
2842 2025-07-18 2930.00
2025-07-18 17:51:06,477 - 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-18 17:51:06,500 - IOOppi_data - INFO : save diff data to db IOOppi_cs_t: date ... updated_at
2842 2025-07-18 ... 2025-07-18 17:51:06.492535
[1 rows x 6 columns]
2025-07-18 17:51:06,525 - IOOppi_data - INFO : save data to db IOOppi_cs_g data:
date value
2838 2025-07-14 2340.00
2839 2025-07-15 2331.43
2840 2025-07-16 2327.14
2841 2025-07-17 2327.14
2842 2025-07-18 2930.00
2025-07-18 17:51:06,579 - 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-18 17:51:06,602 - IOOppi_data - INFO : save diff data to db IOOppi_cs_g: date ... updated_at
2845 2025-07-18 ... 2025-07-18 17:51:06.594896
[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-18 17:51:07,136 - IOOppi_data - INFO : save data to db IOOppi_RS_t data:
date value
3195 2025-07-14 9541.67
3196 2025-07-15 9533.33
3197 2025-07-16 9581.67
3198 2025-07-17 9581.67
3199 2025-07-18 9691.67
2025-07-18 17:51:07,191 - IOOppi_data - INFO : save new data to db: IOOppi_RS_t: no new data
2025-07-18 17:51:07,191 - IOOppi_data - INFO : save diff data to db: IOOppi_RS_t: no diff data
2025-07-18 17:51:07,197 - IOOppi_data - INFO : save data to db IOOppi_RS_g data:
date value
3195 2025-07-14 9541.67
3196 2025-07-15 9533.33
3197 2025-07-16 9581.67
3198 2025-07-17 9581.67
3199 2025-07-18 9691.67
2025-07-18 17:51:07,255 - IOOppi_data - INFO : save new data to db: IOOppi_RS_g: no new data
2025-07-18 17:51:07,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-18 17:51:07,843 - IOOppi_data - INFO : save data to db IOOppi_eg_t data:
date value
1879 2025-07-14 4410.00
1880 2025-07-15 4405.00
1881 2025-07-16 4405.00
1882 2025-07-17 4416.67
1883 2025-07-18 4415.00
2025-07-18 17:51:07,892 - IOOppi_data - INFO : save new data to db IOOppi_eg_t: date value ... created_at updated_at
1883 2025-07-18 4415.0 ... 2025-07-18 17:51:07.884723 2025-07-18 17:51:07.885149
[1 rows x 5 columns]
2025-07-18 17:51:07,909 - IOOppi_data - INFO : save diff data to db: IOOppi_eg_t: no diff data
2025-07-18 17:51:07,915 - IOOppi_data - INFO : save data to db IOOppi_eg_g data:
date value
1879 2025-07-14 4410.00
1880 2025-07-15 4405.00
1881 2025-07-16 4405.00
1882 2025-07-17 4416.67
1883 2025-07-18 4415.00
2025-07-18 17:51:07,964 - IOOppi_data - INFO : save new data to db IOOppi_eg_g: date value ... created_at updated_at
1886 2025-07-18 4415.0 ... 2025-07-18 17:51:07.957294 2025-07-18 17:51:07.957687
[1 rows x 5 columns]
2025-07-18 17:51:07,982 - 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-18 17:51:08,586 - IOOppi_data - INFO : save data to db IOOppi_sp_t data:
date value
1888 2025-07-14 5950.00
1889 2025-07-15 5950.00
1890 2025-07-16 5916.67
1891 2025-07-17 5916.67
1892 2025-07-18 5933.33
2025-07-18 17:51:08,635 - IOOppi_data - INFO : save new data to db IOOppi_sp_t: date value ... created_at updated_at
1892 2025-07-18 5933.33 ... 2025-07-18 17:51:08.628185 2025-07-18 17:51:08.628572
[1 rows x 5 columns]
2025-07-18 17:51:08,653 - IOOppi_data - INFO : save diff data to db: IOOppi_sp_t: no diff data
2025-07-18 17:51:08,658 - IOOppi_data - INFO : save data to db IOOppi_sp_g data:
date value
1888 2025-07-14 5950.00
1889 2025-07-15 5950.00
1890 2025-07-16 5916.67
1891 2025-07-17 5916.67
1892 2025-07-18 5933.33
2025-07-18 17:51:08,707 - IOOppi_data - INFO : save new data to db IOOppi_sp_g: date value ... created_at updated_at
1895 2025-07-18 5933.33 ... 2025-07-18 17:51:08.700352 2025-07-18 17:51:08.700729
[1 rows x 5 columns]
2025-07-18 17:51:08,725 - 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-18 17:51:09,371 - IOOppi_data - INFO : save data to db IOOppi_p_t data:
date value
3556 2025-07-14 8890.0
3557 2025-07-15 8844.0
3558 2025-07-16 8864.0
3559 2025-07-17 8894.0
3560 2025-07-18 9048.0
2025-07-18 17:51:09,443 - IOOppi_data - INFO : save new data to db IOOppi_p_t: date value ... created_at updated_at
3560 2025-07-18 9048.0 ... 2025-07-18 17:51:09.436560 2025-07-18 17:51:09.437032
[1 rows x 5 columns]
2025-07-18 17:51:09,462 - IOOppi_data - INFO : save diff data to db: IOOppi_p_t: no diff data
2025-07-18 17:51:09,468 - IOOppi_data - INFO : save data to db IOOppi_p_g data:
date value
3556 2025-07-14 8890.0
3557 2025-07-15 8844.0
3558 2025-07-16 8864.0
3559 2025-07-17 8894.0
3560 2025-07-18 9048.0
2025-07-18 17:51:09,538 - IOOppi_data - INFO : save new data to db IOOppi_p_g: date value ... created_at updated_at
3563 2025-07-18 9048.0 ... 2025-07-18 17:51:09.530842 2025-07-18 17:51:09.531234
[1 rows x 5 columns]
2025-07-18 17:51:09,556 - IOOppi_data - INFO : save diff data to db: IOOppi_p_g: no diff data