=========================================================================
2025-07-15 17:50:26 Tue 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-15 17:50:28,473 - IOOppi_data - INFO : save data to db IOOppi_rb_t data:
date value
3361 2025-07-11 3164.5
3362 2025-07-12 3164.5
3363 2025-07-13 3164.5
3364 2025-07-14 3180.0
3365 2025-07-15 3173.0
2025-07-15 17:50:28,551 - IOOppi_data - INFO : save new data to db IOOppi_rb_t: date value ... created_at updated_at
3362 2025-07-12 3164.5 ... 2025-07-15 17:50:28.543917 2025-07-15 17:50:28.544329
3363 2025-07-13 3164.5 ... 2025-07-15 17:50:28.543917 2025-07-15 17:50:28.544329
3364 2025-07-14 3180.0 ... 2025-07-15 17:50:28.543917 2025-07-15 17:50:28.544329
3365 2025-07-15 3173.0 ... 2025-07-15 17:50:28.543917 2025-07-15 17:50:28.544329
[4 rows x 5 columns]
2025-07-15 17:50:28,573 - IOOppi_data - INFO : save diff data to db: IOOppi_rb_t: no diff data
2025-07-15 17:50:28,579 - IOOppi_data - INFO : save data to db IOOppi_rb_g data:
date value
3361 2025-07-11 3164.5
3362 2025-07-12 3164.5
3363 2025-07-13 3164.5
3364 2025-07-14 3180.0
3365 2025-07-15 3173.0
2025-07-15 17:50:28,645 - IOOppi_data - INFO : save new data to db IOOppi_rb_g: date value ... created_at updated_at
3365 2025-07-12 3164.5 ... 2025-07-15 17:50:28.638341 2025-07-15 17:50:28.638723
3366 2025-07-13 3164.5 ... 2025-07-15 17:50:28.638341 2025-07-15 17:50:28.638723
3367 2025-07-14 3180.0 ... 2025-07-15 17:50:28.638341 2025-07-15 17:50:28.638723
3368 2025-07-15 3173.0 ... 2025-07-15 17:50:28.638341 2025-07-15 17:50:28.638723
[4 rows x 5 columns]
2025-07-15 17:50:28,664 - 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-15 17:50:29,286 - IOOppi_data - INFO : save data to db IOOppi_MA_t data:
date value
3582 2025-07-11 2378.33
3583 2025-07-12 2378.33
3584 2025-07-13 2378.33
3585 2025-07-14 2390.00
3586 2025-07-15 2390.00
2025-07-15 17:50:29,355 - IOOppi_data - INFO : save new data to db IOOppi_MA_t: date value ... created_at updated_at
3583 2025-07-12 2378.33 ... 2025-07-15 17:50:29.347215 2025-07-15 17:50:29.347605
3584 2025-07-13 2378.33 ... 2025-07-15 17:50:29.347215 2025-07-15 17:50:29.347605
3585 2025-07-14 2390.00 ... 2025-07-15 17:50:29.347215 2025-07-15 17:50:29.347605
3586 2025-07-15 2390.00 ... 2025-07-15 17:50:29.347215 2025-07-15 17:50:29.347605
[4 rows x 5 columns]
2025-07-15 17:50:29,373 - IOOppi_data - INFO : save diff data to db: IOOppi_MA_t: no diff data
2025-07-15 17:50:29,379 - IOOppi_data - INFO : save data to db IOOppi_MA_g data:
date value
3582 2025-07-11 2378.33
3583 2025-07-12 2378.33
3584 2025-07-13 2378.33
3585 2025-07-14 2390.00
3586 2025-07-15 2390.00
2025-07-15 17:50:29,449 - IOOppi_data - INFO : save new data to db IOOppi_MA_g: date value ... created_at updated_at
3587 2025-07-12 2378.33 ... 2025-07-15 17:50:29.441902 2025-07-15 17:50:29.442296
3588 2025-07-13 2378.33 ... 2025-07-15 17:50:29.441902 2025-07-15 17:50:29.442296
3589 2025-07-14 2390.00 ... 2025-07-15 17:50:29.441902 2025-07-15 17:50:29.442296
3590 2025-07-15 2390.00 ... 2025-07-15 17:50:29.441902 2025-07-15 17:50:29.442296
[4 rows x 5 columns]
2025-07-15 17:50:29,468 - 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-15 17:50:30,029 - IOOppi_data - INFO : save data to db IOOppi_PTA_t data:
date value
922 2025-07-11 4852.50
923 2025-07-12 4852.50
924 2025-07-13 4852.50
925 2025-07-14 4789.84
926 2025-07-15 4735.66
2025-07-15 17:50:30,067 - IOOppi_data - INFO : save new data to db IOOppi_PTA_t: date value ... created_at updated_at
923 2025-07-12 4852.50 ... 2025-07-15 17:50:30.059701 2025-07-15 17:50:30.060115
924 2025-07-13 4852.50 ... 2025-07-15 17:50:30.059701 2025-07-15 17:50:30.060115
925 2025-07-14 4789.84 ... 2025-07-15 17:50:30.059701 2025-07-15 17:50:30.060115
926 2025-07-15 4735.66 ... 2025-07-15 17:50:30.059701 2025-07-15 17:50:30.060115
[4 rows x 5 columns]
2025-07-15 17:50:30,086 - IOOppi_data - INFO : save diff data to db: IOOppi_PTA_t: no diff data
2025-07-15 17:50:30,092 - IOOppi_data - INFO : save data to db IOOppi_PTA_g data:
date value
922 2025-07-11 4852.50
923 2025-07-12 4852.50
924 2025-07-13 4852.50
925 2025-07-14 4789.84
926 2025-07-15 4735.66
2025-07-15 17:50:30,130 - IOOppi_data - INFO : save new data to db IOOppi_PTA_g: date value ... created_at updated_at
923 2025-07-12 4852.50 ... 2025-07-15 17:50:30.122499 2025-07-15 17:50:30.122914
924 2025-07-13 4852.50 ... 2025-07-15 17:50:30.122499 2025-07-15 17:50:30.122914
925 2025-07-14 4789.84 ... 2025-07-15 17:50:30.122499 2025-07-15 17:50:30.122914
926 2025-07-15 4735.66 ... 2025-07-15 17:50:30.122499 2025-07-15 17:50:30.122914
[4 rows x 5 columns]
2025-07-15 17:50:30,150 - 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-15 17:50:30,793 - IOOppi_data - INFO : save data to db IOOppi_ru_t data:
date value
3801 2025-07-11 14416.67
3802 2025-07-12 14416.67
3803 2025-07-13 14416.67
3804 2025-07-14 14386.67
3805 2025-07-15 14508.33
2025-07-15 17:50:30,865 - IOOppi_data - INFO : save new data to db IOOppi_ru_t: date ... updated_at
3802 2025-07-12 ... 2025-07-15 17:50:30.858954
3803 2025-07-13 ... 2025-07-15 17:50:30.858954
3804 2025-07-14 ... 2025-07-15 17:50:30.858954
3805 2025-07-15 ... 2025-07-15 17:50:30.858954
[4 rows x 5 columns]
2025-07-15 17:50:30,886 - IOOppi_data - INFO : save diff data to db: IOOppi_ru_t: no diff data
2025-07-15 17:50:30,893 - IOOppi_data - INFO : save data to db IOOppi_ru_g data:
date value
3801 2025-07-11 14416.67
3802 2025-07-12 14416.67
3803 2025-07-13 14416.67
3804 2025-07-14 14386.67
3805 2025-07-15 14508.33
2025-07-15 17:50:30,966 - IOOppi_data - INFO : save new data to db IOOppi_ru_g: date ... updated_at
3805 2025-07-12 ... 2025-07-15 17:50:30.959549
3806 2025-07-13 ... 2025-07-15 17:50:30.959549
3807 2025-07-14 ... 2025-07-15 17:50:30.959549
3808 2025-07-15 ... 2025-07-15 17:50:30.959549
[4 rows x 5 columns]
2025-07-15 17:50:30,986 - 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-15 17:50:31,571 - IOOppi_data - INFO : save data to db IOOppi_i_t data:
date value
3133 2025-07-11 762.56
3134 2025-07-12 762.56
3135 2025-07-13 762.89
3136 2025-07-14 764.00
3137 2025-07-15 765.00
2025-07-15 17:50:31,636 - IOOppi_data - INFO : save new data to db IOOppi_i_t: date value ... created_at updated_at
3134 2025-07-12 762.56 ... 2025-07-15 17:50:31.628199 2025-07-15 17:50:31.628628
3135 2025-07-13 762.89 ... 2025-07-15 17:50:31.628199 2025-07-15 17:50:31.628628
3136 2025-07-14 764.00 ... 2025-07-15 17:50:31.628199 2025-07-15 17:50:31.628628
3137 2025-07-15 765.00 ... 2025-07-15 17:50:31.628199 2025-07-15 17:50:31.628628
[4 rows x 5 columns]
2025-07-15 17:50:31,655 - IOOppi_data - INFO : save diff data to db: IOOppi_i_t: no diff data
2025-07-15 17:50:31,662 - IOOppi_data - INFO : save data to db IOOppi_i_g data:
date value
3133 2025-07-11 762.56
3134 2025-07-12 762.56
3135 2025-07-13 762.89
3136 2025-07-14 764.00
3137 2025-07-15 765.00
2025-07-15 17:50:31,728 - IOOppi_data - INFO : save new data to db IOOppi_i_g: date value ... created_at updated_at
3137 2025-07-12 762.56 ... 2025-07-15 17:50:31.720264 2025-07-15 17:50:31.720661
3138 2025-07-13 762.89 ... 2025-07-15 17:50:31.720264 2025-07-15 17:50:31.720661
3139 2025-07-14 764.00 ... 2025-07-15 17:50:31.720264 2025-07-15 17:50:31.720661
3140 2025-07-15 765.00 ... 2025-07-15 17:50:31.720264 2025-07-15 17:50:31.720661
[4 rows x 5 columns]
2025-07-15 17:50:31,747 - 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-15 17:50:32,310 - IOOppi_data - INFO : save data to db IOOppi_FG_t data:
date value
3336 2025-07-11 1122.4
3337 2025-07-12 1128.0
3338 2025-07-13 1128.0
3339 2025-07-14 1128.0
3340 2025-07-15 1128.0
2025-07-15 17:50:32,377 - IOOppi_data - INFO : save new data to db IOOppi_FG_t: date value ... created_at updated_at
3337 2025-07-12 1128.0 ... 2025-07-15 17:50:32.369645 2025-07-15 17:50:32.370070
3338 2025-07-13 1128.0 ... 2025-07-15 17:50:32.369645 2025-07-15 17:50:32.370070
3339 2025-07-14 1128.0 ... 2025-07-15 17:50:32.369645 2025-07-15 17:50:32.370070
3340 2025-07-15 1128.0 ... 2025-07-15 17:50:32.369645 2025-07-15 17:50:32.370070
[4 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-15 17:50:34,582 - IOOppi_data - INFO : save diff data to db IOOppi_FG_t: date ... updated_at
12 2012-12-19 ... 2025-07-15 17:50:34.574881
21 2013-01-04 ... 2025-07-15 17:50:34.574881
54 2013-02-27 ... 2025-07-15 17:50:34.574881
60 2013-03-07 ... 2025-07-15 17:50:34.574881
61 2013-03-08 ... 2025-07-15 17:50:34.574881
[5 rows x 6 columns]
2025-07-15 17:50:34,751 - IOOppi_data - INFO : save data to db IOOppi_FG_g data:
date value
3336 2025-07-11 1122.4
3337 2025-07-12 1128.0
3338 2025-07-13 1128.0
3339 2025-07-14 1128.0
3340 2025-07-15 1128.0
2025-07-15 17:50:34,818 - IOOppi_data - INFO : save new data to db IOOppi_FG_g: date value ... created_at updated_at
3341 2025-07-12 1128.0 ... 2025-07-15 17:50:34.811146 2025-07-15 17:50:34.811524
3342 2025-07-13 1128.0 ... 2025-07-15 17:50:34.811146 2025-07-15 17:50:34.811524
3343 2025-07-14 1128.0 ... 2025-07-15 17:50:34.811146 2025-07-15 17:50:34.811524
3344 2025-07-15 1128.0 ... 2025-07-15 17:50:34.811146 2025-07-15 17:50:34.811524
[4 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-15 17:50:37,065 - IOOppi_data - INFO : save diff data to db IOOppi_FG_g: date ... updated_at
12 2012-12-19 ... 2025-07-15 17:50:37.057725
21 2013-01-04 ... 2025-07-15 17:50:37.057725
54 2013-02-27 ... 2025-07-15 17:50:37.057725
60 2013-03-07 ... 2025-07-15 17:50:37.057725
61 2013-03-08 ... 2025-07-15 17:50:37.057725
[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-15 17:50:38,317 - IOOppi_data - INFO : save data to db IOOppi_eb_t data:
date value
1681 2025-07-11 7908.0
1682 2025-07-12 7908.0
1683 2025-07-13 7908.0
1684 2025-07-14 7936.0
1685 2025-07-15 7956.0
2025-07-15 17:50:38,363 - IOOppi_data - INFO : save new data to db IOOppi_eb_t: date value ... created_at updated_at
1682 2025-07-12 7908.0 ... 2025-07-15 17:50:38.355885 2025-07-15 17:50:38.356281
1683 2025-07-13 7908.0 ... 2025-07-15 17:50:38.355885 2025-07-15 17:50:38.356281
1684 2025-07-14 7936.0 ... 2025-07-15 17:50:38.355885 2025-07-15 17:50:38.356281
1685 2025-07-15 7956.0 ... 2025-07-15 17:50:38.355885 2025-07-15 17:50:38.356281
[4 rows x 5 columns]
2025-07-15 17:50:38,382 - IOOppi_data - INFO : save diff data to db: IOOppi_eb_t: no diff data
2025-07-15 17:50:38,388 - IOOppi_data - INFO : save data to db IOOppi_eb_g data:
date value
1681 2025-07-11 7908.0
1682 2025-07-12 7908.0
1683 2025-07-13 7908.0
1684 2025-07-14 7936.0
1685 2025-07-15 7956.0
2025-07-15 17:50:38,436 - IOOppi_data - INFO : save new data to db IOOppi_eb_g: date value ... created_at updated_at
1685 2025-07-12 7908.0 ... 2025-07-15 17:50:38.428259 2025-07-15 17:50:38.428651
1686 2025-07-13 7908.0 ... 2025-07-15 17:50:38.428259 2025-07-15 17:50:38.428651
1687 2025-07-14 7936.0 ... 2025-07-15 17:50:38.428259 2025-07-15 17:50:38.428651
1688 2025-07-15 7956.0 ... 2025-07-15 17:50:38.428259 2025-07-15 17:50:38.428651
[4 rows x 5 columns]
2025-07-15 17:50:38,454 - 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-15 17:50:39,026 - IOOppi_data - INFO : save data to db IOOppi_SR_t data:
date value
3792 2025-07-11 6046.67
3793 2025-07-12 6046.67
3794 2025-07-13 6046.67
3795 2025-07-14 6050.00
3796 2025-07-15 6043.33
2025-07-15 17:50:39,097 - IOOppi_data - INFO : save new data to db IOOppi_SR_t: date value ... created_at updated_at
3793 2025-07-12 6046.67 ... 2025-07-15 17:50:39.090445 2025-07-15 17:50:39.090863
3794 2025-07-13 6046.67 ... 2025-07-15 17:50:39.090445 2025-07-15 17:50:39.090863
3795 2025-07-14 6050.00 ... 2025-07-15 17:50:39.090445 2025-07-15 17:50:39.090863
3796 2025-07-15 6043.33 ... 2025-07-15 17:50:39.090445 2025-07-15 17:50:39.090863
[4 rows x 5 columns]
2025-07-15 17:50:39,116 - IOOppi_data - INFO : save diff data to db: IOOppi_SR_t: no diff data
2025-07-15 17:50:39,123 - IOOppi_data - INFO : save data to db IOOppi_SR_g data:
date value
3792 2025-07-11 6046.67
3793 2025-07-12 6046.67
3794 2025-07-13 6046.67
3795 2025-07-14 6050.00
3796 2025-07-15 6043.33
2025-07-15 17:50:39,196 - IOOppi_data - INFO : save new data to db IOOppi_SR_g: date value ... created_at updated_at
3797 2025-07-12 6046.67 ... 2025-07-15 17:50:39.189042 2025-07-15 17:50:39.189435
3798 2025-07-13 6046.67 ... 2025-07-15 17:50:39.189042 2025-07-15 17:50:39.189435
3799 2025-07-14 6050.00 ... 2025-07-15 17:50:39.189042 2025-07-15 17:50:39.189435
3800 2025-07-15 6043.33 ... 2025-07-15 17:50:39.189042 2025-07-15 17:50:39.189435
[4 rows x 5 columns]
2025-07-15 17:50:39,215 - 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-15 17:50:40,078 - IOOppi_data - INFO : save data to db IOOppi_ss_t data:
date value
1682 2025-07-11 12887.5
1683 2025-07-12 12887.5
1684 2025-07-13 12887.5
1685 2025-07-14 12900.0
1686 2025-07-15 12900.0
2025-07-15 17:50:40,125 - IOOppi_data - INFO : save new data to db IOOppi_ss_t: date value ... created_at updated_at
1683 2025-07-12 12887.5 ... 2025-07-15 17:50:40.117888 2025-07-15 17:50:40.118303
1684 2025-07-13 12887.5 ... 2025-07-15 17:50:40.117888 2025-07-15 17:50:40.118303
1685 2025-07-14 12900.0 ... 2025-07-15 17:50:40.117888 2025-07-15 17:50:40.118303
1686 2025-07-15 12900.0 ... 2025-07-15 17:50:40.117888 2025-07-15 17:50:40.118303
[4 rows x 5 columns]
2025-07-15 17:50:40,145 - IOOppi_data - INFO : save diff data to db: IOOppi_ss_t: no diff data
2025-07-15 17:50:40,151 - IOOppi_data - INFO : save data to db IOOppi_ss_g data:
date value
1682 2025-07-11 12887.5
1683 2025-07-12 12887.5
1684 2025-07-13 12887.5
1685 2025-07-14 12900.0
1686 2025-07-15 12900.0
2025-07-15 17:50:40,197 - IOOppi_data - INFO : save new data to db IOOppi_ss_g: date value ... created_at updated_at
1686 2025-07-12 12887.5 ... 2025-07-15 17:50:40.189777 2025-07-15 17:50:40.190165
1687 2025-07-13 12887.5 ... 2025-07-15 17:50:40.189777 2025-07-15 17:50:40.190165
1688 2025-07-14 12900.0 ... 2025-07-15 17:50:40.189777 2025-07-15 17:50:40.190165
1689 2025-07-15 12900.0 ... 2025-07-15 17:50:40.189777 2025-07-15 17:50:40.190165
[4 rows x 5 columns]
2025-07-15 17:50:40,216 - 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-15 17:50:40,807 - IOOppi_data - INFO : save data to db IOOppi_RS_t data:
date value
3192 2025-07-11 9568.33
3193 2025-07-12 9568.33
3194 2025-07-13 9568.33
3195 2025-07-14 9541.67
3196 2025-07-15 9533.33
2025-07-15 17:50:40,875 - IOOppi_data - INFO : save new data to db IOOppi_RS_t: date value ... created_at updated_at
3193 2025-07-12 9568.33 ... 2025-07-15 17:50:40.867286 2025-07-15 17:50:40.867698
3194 2025-07-13 9568.33 ... 2025-07-15 17:50:40.867286 2025-07-15 17:50:40.867698
3195 2025-07-14 9541.67 ... 2025-07-15 17:50:40.867286 2025-07-15 17:50:40.867698
3196 2025-07-15 9533.33 ... 2025-07-15 17:50:40.867286 2025-07-15 17:50:40.867698
[4 rows x 5 columns]
2025-07-15 17:50:40,894 - IOOppi_data - INFO : save diff data to db: IOOppi_RS_t: no diff data
2025-07-15 17:50:40,900 - IOOppi_data - INFO : save data to db IOOppi_RS_g data:
date value
3192 2025-07-11 9568.33
3193 2025-07-12 9568.33
3194 2025-07-13 9568.33
3195 2025-07-14 9541.67
3196 2025-07-15 9533.33
2025-07-15 17:50:40,966 - IOOppi_data - INFO : save new data to db IOOppi_RS_g: date value ... created_at updated_at
3197 2025-07-12 9568.33 ... 2025-07-15 17:50:40.958645 2025-07-15 17:50:40.959062
3198 2025-07-13 9568.33 ... 2025-07-15 17:50:40.958645 2025-07-15 17:50:40.959062
3199 2025-07-14 9541.67 ... 2025-07-15 17:50:40.958645 2025-07-15 17:50:40.959062
3200 2025-07-15 9533.33 ... 2025-07-15 17:50:40.958645 2025-07-15 17:50:40.959062
[4 rows x 5 columns]
2025-07-15 17:50:40,984 - 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-15 17:50:41,621 - IOOppi_data - INFO : save data to db IOOppi_RM_t data:
date value
3315 2025-07-11 2551.67
3316 2025-07-12 2551.67
3317 2025-07-13 2551.67
3318 2025-07-14 2566.67
3319 2025-07-15 2581.67
2025-07-15 17:50:41,687 - IOOppi_data - INFO : save new data to db IOOppi_RM_t: date value ... created_at updated_at
3316 2025-07-12 2551.67 ... 2025-07-15 17:50:41.680082 2025-07-15 17:50:41.680464
3317 2025-07-13 2551.67 ... 2025-07-15 17:50:41.680082 2025-07-15 17:50:41.680464
3318 2025-07-14 2566.67 ... 2025-07-15 17:50:41.680082 2025-07-15 17:50:41.680464
3319 2025-07-15 2581.67 ... 2025-07-15 17:50:41.680082 2025-07-15 17:50:41.680464
[4 rows x 5 columns]
2025-07-15 17:50:41,706 - IOOppi_data - INFO : save diff data to db: IOOppi_RM_t: no diff data
2025-07-15 17:50:41,712 - IOOppi_data - INFO : save data to db IOOppi_RM_g data:
date value
3315 2025-07-11 2551.67
3316 2025-07-12 2551.67
3317 2025-07-13 2551.67
3318 2025-07-14 2566.67
3319 2025-07-15 2581.67
2025-07-15 17:50:41,779 - IOOppi_data - INFO : save new data to db IOOppi_RM_g: date value ... created_at updated_at
3320 2025-07-12 2551.67 ... 2025-07-15 17:50:41.771515 2025-07-15 17:50:41.771931
3321 2025-07-13 2551.67 ... 2025-07-15 17:50:41.771515 2025-07-15 17:50:41.771931
3322 2025-07-14 2566.67 ... 2025-07-15 17:50:41.771515 2025-07-15 17:50:41.771931
3323 2025-07-15 2581.67 ... 2025-07-15 17:50:41.771515 2025-07-15 17:50:41.771931
[4 rows x 5 columns]
2025-07-15 17:50:41,797 - 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-15 17:50:42,430 - IOOppi_data - INFO : save data to db IOOppi_SA_t data:
date value
1519 2025-07-11 1247.5
1520 2025-07-12 1247.5
1521 2025-07-13 1247.5
1522 2025-07-14 1247.5
1523 2025-07-15 1247.5
2025-07-15 17:50:42,474 - IOOppi_data - INFO : save new data to db IOOppi_SA_t: date value ... created_at updated_at
1520 2025-07-12 1247.5 ... 2025-07-15 17:50:42.467082 2025-07-15 17:50:42.467467
1521 2025-07-13 1247.5 ... 2025-07-15 17:50:42.467082 2025-07-15 17:50:42.467467
1522 2025-07-14 1247.5 ... 2025-07-15 17:50:42.467082 2025-07-15 17:50:42.467467
1523 2025-07-15 1247.5 ... 2025-07-15 17:50:42.467082 2025-07-15 17:50:42.467467
[4 rows x 5 columns]
2025-07-15 17:50:42,494 - IOOppi_data - INFO : save diff data to db: IOOppi_SA_t: no diff data
2025-07-15 17:50:42,500 - IOOppi_data - INFO : save data to db IOOppi_SA_g data:
date value
1519 2025-07-11 1247.5
1520 2025-07-12 1247.5
1521 2025-07-13 1247.5
1522 2025-07-14 1247.5
1523 2025-07-15 1247.5
2025-07-15 17:50:42,545 - IOOppi_data - INFO : save new data to db IOOppi_SA_g: date value ... created_at updated_at
1524 2025-07-12 1247.5 ... 2025-07-15 17:50:42.537658 2025-07-15 17:50:42.538072
1525 2025-07-13 1247.5 ... 2025-07-15 17:50:42.537658 2025-07-15 17:50:42.538072
1526 2025-07-14 1247.5 ... 2025-07-15 17:50:42.537658 2025-07-15 17:50:42.538072
1527 2025-07-15 1247.5 ... 2025-07-15 17:50:42.537658 2025-07-15 17:50:42.538072
[4 rows x 5 columns]
2025-07-15 17:50:42,563 - 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-15 17:50:43,274 - IOOppi_data - INFO : save data to db IOOppi_PF_t data:
date value
1432 2025-07-11 6668.46
1433 2025-07-12 6668.46
1434 2025-07-13 6668.46
1435 2025-07-14 6667.08
1436 2025-07-15 6646.46
2025-07-15 17:50:43,318 - IOOppi_data - INFO : save new data to db IOOppi_PF_t: date value ... created_at updated_at
1433 2025-07-12 6668.46 ... 2025-07-15 17:50:43.310411 2025-07-15 17:50:43.310822
1434 2025-07-13 6668.46 ... 2025-07-15 17:50:43.310411 2025-07-15 17:50:43.310822
1435 2025-07-14 6667.08 ... 2025-07-15 17:50:43.310411 2025-07-15 17:50:43.310822
1436 2025-07-15 6646.46 ... 2025-07-15 17:50:43.310411 2025-07-15 17:50:43.310822
[4 rows x 5 columns]
2025-07-15 17:50:43,337 - IOOppi_data - INFO : save diff data to db: IOOppi_PF_t: no diff data
2025-07-15 17:50:43,342 - IOOppi_data - INFO : save data to db IOOppi_PF_g data:
date value
1432 2025-07-11 6668.46
1433 2025-07-12 6668.46
1434 2025-07-13 6668.46
1435 2025-07-14 6667.08
1436 2025-07-15 6646.46
2025-07-15 17:50:43,387 - IOOppi_data - INFO : save new data to db IOOppi_PF_g: date value ... created_at updated_at
1437 2025-07-12 6668.46 ... 2025-07-15 17:50:43.379409 2025-07-15 17:50:43.379822
1438 2025-07-13 6668.46 ... 2025-07-15 17:50:43.379409 2025-07-15 17:50:43.379822
1439 2025-07-14 6667.08 ... 2025-07-15 17:50:43.379409 2025-07-15 17:50:43.379822
1440 2025-07-15 6646.46 ... 2025-07-15 17:50:43.379409 2025-07-15 17:50:43.379822
[4 rows x 5 columns]
2025-07-15 17:50:43,405 - 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-15 17:50:44,005 - IOOppi_data - INFO : save data to db IOOppi_m_t data:
date value
3805 2025-07-11 2924.0
3806 2025-07-12 2924.0
3807 2025-07-13 2924.0
3808 2025-07-14 2912.0
3809 2025-07-15 2924.0
2025-07-15 17:50:44,077 - IOOppi_data - INFO : save new data to db IOOppi_m_t: date value ... created_at updated_at
3806 2025-07-12 2924.0 ... 2025-07-15 17:50:44.069317 2025-07-15 17:50:44.069701
3807 2025-07-13 2924.0 ... 2025-07-15 17:50:44.069317 2025-07-15 17:50:44.069701
3808 2025-07-14 2912.0 ... 2025-07-15 17:50:44.069317 2025-07-15 17:50:44.069701
3809 2025-07-15 2924.0 ... 2025-07-15 17:50:44.069317 2025-07-15 17:50:44.069701
[4 rows x 5 columns]
2025-07-15 17:50:44,096 - IOOppi_data - INFO : save diff data to db: IOOppi_m_t: no diff data
2025-07-15 17:50:44,102 - IOOppi_data - INFO : save data to db IOOppi_m_g data:
date value
3805 2025-07-11 2924.0
3806 2025-07-12 2924.0
3807 2025-07-13 2924.0
3808 2025-07-14 2912.0
3809 2025-07-15 2924.0
2025-07-15 17:50:44,174 - IOOppi_data - INFO : save new data to db IOOppi_m_g: date value ... created_at updated_at
3809 2025-07-12 2924.0 ... 2025-07-15 17:50:44.167093 2025-07-15 17:50:44.167480
3810 2025-07-13 2924.0 ... 2025-07-15 17:50:44.167093 2025-07-15 17:50:44.167480
3811 2025-07-14 2912.0 ... 2025-07-15 17:50:44.167093 2025-07-15 17:50:44.167480
3812 2025-07-15 2924.0 ... 2025-07-15 17:50:44.167093 2025-07-15 17:50:44.167480
[4 rows x 5 columns]
2025-07-15 17:50:44,192 - 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-15 17:50:44,854 - IOOppi_data - INFO : save data to db IOOppi_y_t data:
date value
3575 2025-07-11 8254.0
3576 2025-07-12 8254.0
3577 2025-07-13 8254.0
3578 2025-07-14 8254.0
3579 2025-07-15 8264.0
2025-07-15 17:50:44,923 - IOOppi_data - INFO : save new data to db IOOppi_y_t: date value ... created_at updated_at
3576 2025-07-12 8254.0 ... 2025-07-15 17:50:44.916145 2025-07-15 17:50:44.916549
3577 2025-07-13 8254.0 ... 2025-07-15 17:50:44.916145 2025-07-15 17:50:44.916549
3578 2025-07-14 8254.0 ... 2025-07-15 17:50:44.916145 2025-07-15 17:50:44.916549
3579 2025-07-15 8264.0 ... 2025-07-15 17:50:44.916145 2025-07-15 17:50:44.916549
[4 rows x 5 columns]
2025-07-15 17:50:44,942 - IOOppi_data - INFO : save diff data to db: IOOppi_y_t: no diff data
2025-07-15 17:50:44,949 - IOOppi_data - INFO : save data to db IOOppi_y_g data:
date value
3575 2025-07-11 8254.0
3576 2025-07-12 8254.0
3577 2025-07-13 8254.0
3578 2025-07-14 8254.0
3579 2025-07-15 8264.0
2025-07-15 17:50:45,019 - IOOppi_data - INFO : save new data to db IOOppi_y_g: date value ... created_at updated_at
3579 2025-07-12 8254.0 ... 2025-07-15 17:50:45.011568 2025-07-15 17:50:45.011979
3580 2025-07-13 8254.0 ... 2025-07-15 17:50:45.011568 2025-07-15 17:50:45.011979
3581 2025-07-14 8254.0 ... 2025-07-15 17:50:45.011568 2025-07-15 17:50:45.011979
3582 2025-07-15 8264.0 ... 2025-07-15 17:50:45.011568 2025-07-15 17:50:45.011979
[4 rows x 5 columns]
2025-07-15 17:50:45,038 - 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-15 17:50:45,609 - IOOppi_data - INFO : save data to db IOOppi_a_t data:
date value
3541 2025-07-11 4295.0
3542 2025-07-12 4295.0
3543 2025-07-13 4295.0
3544 2025-07-14 4295.0
3545 2025-07-15 4295.0
2025-07-15 17:50:45,677 - IOOppi_data - INFO : save new data to db IOOppi_a_t: date value ... created_at updated_at
3542 2025-07-12 4295.0 ... 2025-07-15 17:50:45.670468 2025-07-15 17:50:45.670878
3543 2025-07-13 4295.0 ... 2025-07-15 17:50:45.670468 2025-07-15 17:50:45.670878
3544 2025-07-14 4295.0 ... 2025-07-15 17:50:45.670468 2025-07-15 17:50:45.670878
3545 2025-07-15 4295.0 ... 2025-07-15 17:50:45.670468 2025-07-15 17:50:45.670878
[4 rows x 5 columns]
2025-07-15 17:50:45,696 - IOOppi_data - INFO : save diff data to db: IOOppi_a_t: no diff data
2025-07-15 17:50:45,703 - IOOppi_data - INFO : save data to db IOOppi_a_g data:
date value
3541 2025-07-11 4295.0
3542 2025-07-12 4295.0
3543 2025-07-13 4295.0
3544 2025-07-14 4295.0
3545 2025-07-15 4295.0
2025-07-15 17:50:45,774 - IOOppi_data - INFO : save new data to db IOOppi_a_g: date value ... created_at updated_at
3545 2025-07-12 4295.0 ... 2025-07-15 17:50:45.766571 2025-07-15 17:50:45.767030
3546 2025-07-13 4295.0 ... 2025-07-15 17:50:45.766571 2025-07-15 17:50:45.767030
3547 2025-07-14 4295.0 ... 2025-07-15 17:50:45.766571 2025-07-15 17:50:45.767030
3548 2025-07-15 4295.0 ... 2025-07-15 17:50:45.766571 2025-07-15 17:50:45.767030
[4 rows x 5 columns]
2025-07-15 17:50:45,793 - 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-15 17:50:46,394 - IOOppi_data - INFO : save data to db IOOppi_SF_t data:
date value
2918 2025-07-11 5217.14
2919 2025-07-12 5217.14
2920 2025-07-13 5217.14
2921 2025-07-14 5202.86
2922 2025-07-15 5202.86
2025-07-15 17:50:46,455 - IOOppi_data - INFO : save new data to db IOOppi_SF_t: date value ... created_at updated_at
2919 2025-07-12 5217.14 ... 2025-07-15 17:50:46.447884 2025-07-15 17:50:46.448272
2920 2025-07-13 5217.14 ... 2025-07-15 17:50:46.447884 2025-07-15 17:50:46.448272
2921 2025-07-14 5202.86 ... 2025-07-15 17:50:46.447884 2025-07-15 17:50:46.448272
2922 2025-07-15 5202.86 ... 2025-07-15 17:50:46.447884 2025-07-15 17:50:46.448272
[4 rows x 5 columns]
2025-07-15 17:50:46,474 - IOOppi_data - INFO : save diff data to db: IOOppi_SF_t: no diff data
2025-07-15 17:50:46,480 - IOOppi_data - INFO : save data to db IOOppi_SF_g data:
date value
2918 2025-07-11 5217.14
2919 2025-07-12 5217.14
2920 2025-07-13 5217.14
2921 2025-07-14 5202.86
2922 2025-07-15 5202.86
2025-07-15 17:50:46,541 - IOOppi_data - INFO : save new data to db IOOppi_SF_g: date value ... created_at updated_at
2923 2025-07-12 5217.14 ... 2025-07-15 17:50:46.534467 2025-07-15 17:50:46.534876
2924 2025-07-13 5217.14 ... 2025-07-15 17:50:46.534467 2025-07-15 17:50:46.534876
2925 2025-07-14 5202.86 ... 2025-07-15 17:50:46.534467 2025-07-15 17:50:46.534876
2926 2025-07-15 5202.86 ... 2025-07-15 17:50:46.534467 2025-07-15 17:50:46.534876
[4 rows x 5 columns]
2025-07-15 17:50:46,564 - 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-15 17:50:47,123 - IOOppi_data - INFO : save data to db IOOppi_jd_t data:
date value
3118 2025-07-11 2775.0
3119 2025-07-12 2775.0
3120 2025-07-13 2775.0
3121 2025-07-14 2875.0
3122 2025-07-15 2875.0
2025-07-15 17:50:47,187 - IOOppi_data - INFO : save new data to db IOOppi_jd_t: date value ... created_at updated_at
3119 2025-07-12 2775.0 ... 2025-07-15 17:50:47.179355 2025-07-15 17:50:47.179772
3120 2025-07-13 2775.0 ... 2025-07-15 17:50:47.179355 2025-07-15 17:50:47.179772
3121 2025-07-14 2875.0 ... 2025-07-15 17:50:47.179355 2025-07-15 17:50:47.179772
3122 2025-07-15 2875.0 ... 2025-07-15 17:50:47.179355 2025-07-15 17:50:47.179772
[4 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-15 17:50:47,338 - IOOppi_data - INFO : save diff data to db IOOppi_jd_t: date ... updated_at
39 2014-01-03 ... 2025-07-15 17:50:47.330255
458 2015-09-21 ... 2025-07-15 17:50:47.330255
549 2016-02-03 ... 2025-07-15 17:50:47.330255
693 2016-09-05 ... 2025-07-15 17:50:47.330255
696 2016-09-08 ... 2025-07-15 17:50:47.330255
[5 rows x 6 columns]
2025-07-15 17:50:47,369 - IOOppi_data - INFO : save data to db IOOppi_jd_g data:
date value
3118 2025-07-11 2775.0
3119 2025-07-12 2775.0
3120 2025-07-13 2775.0
3121 2025-07-14 2875.0
3122 2025-07-15 2875.0
2025-07-15 17:50:47,433 - IOOppi_data - INFO : save new data to db IOOppi_jd_g: date value ... created_at updated_at
3122 2025-07-12 2775.0 ... 2025-07-15 17:50:47.426100 2025-07-15 17:50:47.426486
3123 2025-07-13 2775.0 ... 2025-07-15 17:50:47.426100 2025-07-15 17:50:47.426486
3124 2025-07-14 2875.0 ... 2025-07-15 17:50:47.426100 2025-07-15 17:50:47.426486
3125 2025-07-15 2875.0 ... 2025-07-15 17:50:47.426100 2025-07-15 17:50:47.426486
[4 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-15 17:50:47,582 - IOOppi_data - INFO : save diff data to db IOOppi_jd_g: date ... updated_at
39 2014-01-03 ... 2025-07-15 17:50:47.574476
458 2015-09-21 ... 2025-07-15 17:50:47.574476
549 2016-02-03 ... 2025-07-15 17:50:47.574476
693 2016-09-05 ... 2025-07-15 17:50:47.574476
696 2016-09-08 ... 2025-07-15 17:50:47.574476
[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-15 17:50:48,260 - IOOppi_data - INFO : save data to db IOOppi_SI_t data:
date value
922 2025-07-11 8940.0
923 2025-07-12 9050.0
924 2025-07-13 9050.0
925 2025-07-14 9090.0
926 2025-07-15 9330.0
2025-07-15 17:50:48,298 - IOOppi_data - INFO : save new data to db IOOppi_SI_t: date value ... created_at updated_at
923 2025-07-12 9050.0 ... 2025-07-15 17:50:48.290508 2025-07-15 17:50:48.290928
924 2025-07-13 9050.0 ... 2025-07-15 17:50:48.290508 2025-07-15 17:50:48.290928
925 2025-07-14 9090.0 ... 2025-07-15 17:50:48.290508 2025-07-15 17:50:48.290928
926 2025-07-15 9330.0 ... 2025-07-15 17:50:48.290508 2025-07-15 17:50:48.290928
[4 rows x 5 columns]
2025-07-15 17:50:48,317 - IOOppi_data - INFO : save diff data to db: IOOppi_SI_t: no diff data
2025-07-15 17:50:48,323 - IOOppi_data - INFO : save data to db IOOppi_SI_g data:
date value
922 2025-07-11 8940.0
923 2025-07-12 9050.0
924 2025-07-13 9050.0
925 2025-07-14 9090.0
926 2025-07-15 9330.0
2025-07-15 17:50:48,361 - IOOppi_data - INFO : save new data to db IOOppi_SI_g: date value ... created_at updated_at
923 2025-07-12 9050.0 ... 2025-07-15 17:50:48.353881 2025-07-15 17:50:48.354286
924 2025-07-13 9050.0 ... 2025-07-15 17:50:48.353881 2025-07-15 17:50:48.354286
925 2025-07-14 9090.0 ... 2025-07-15 17:50:48.353881 2025-07-15 17:50:48.354286
926 2025-07-15 9330.0 ... 2025-07-15 17:50:48.353881 2025-07-15 17:50:48.354286
[4 rows x 5 columns]
2025-07-15 17:50:48,380 - 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-15 17:50:48,970 - IOOppi_data - INFO : save data to db IOOppi_l_t data:
date value
3801 2025-07-11 7416.67
3802 2025-07-12 7416.67
3803 2025-07-13 7416.67
3804 2025-07-14 7411.67
3805 2025-07-15 7393.33
2025-07-15 17:50:49,043 - IOOppi_data - INFO : save new data to db IOOppi_l_t: date value ... created_at updated_at
3802 2025-07-12 7416.67 ... 2025-07-15 17:50:49.036193 2025-07-15 17:50:49.036582
3803 2025-07-13 7416.67 ... 2025-07-15 17:50:49.036193 2025-07-15 17:50:49.036582
3804 2025-07-14 7411.67 ... 2025-07-15 17:50:49.036193 2025-07-15 17:50:49.036582
3805 2025-07-15 7393.33 ... 2025-07-15 17:50:49.036193 2025-07-15 17:50:49.036582
[4 rows x 5 columns]
2025-07-15 17:50:49,064 - IOOppi_data - INFO : save diff data to db: IOOppi_l_t: no diff data
2025-07-15 17:50:49,071 - IOOppi_data - INFO : save data to db IOOppi_l_g data:
date value
3801 2025-07-11 7416.67
3802 2025-07-12 7416.67
3803 2025-07-13 7416.67
3804 2025-07-14 7411.67
3805 2025-07-15 7393.33
2025-07-15 17:50:49,144 - IOOppi_data - INFO : save new data to db IOOppi_l_g: date value ... created_at updated_at
3805 2025-07-12 7416.67 ... 2025-07-15 17:50:49.136904 2025-07-15 17:50:49.137301
3806 2025-07-13 7416.67 ... 2025-07-15 17:50:49.136904 2025-07-15 17:50:49.137301
3807 2025-07-14 7411.67 ... 2025-07-15 17:50:49.136904 2025-07-15 17:50:49.137301
3808 2025-07-15 7393.33 ... 2025-07-15 17:50:49.136904 2025-07-15 17:50:49.137301
[4 rows x 5 columns]
2025-07-15 17:50:49,163 - 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-15 17:50:49,957 - IOOppi_data - INFO : save data to db IOOppi_bu_t data:
date value
3139 2025-07-11 3700.0
3140 2025-07-12 3700.0
3141 2025-07-13 3700.0
3142 2025-07-14 3720.0
3143 2025-07-15 3720.0
2025-07-15 17:50:50,024 - IOOppi_data - INFO : save new data to db IOOppi_bu_t: date value ... created_at updated_at
3141 2025-07-12 3700.0 ... 2025-07-15 17:50:50.014748 2025-07-15 17:50:50.015182
3142 2025-07-13 3700.0 ... 2025-07-15 17:50:50.014748 2025-07-15 17:50:50.015182
3143 2025-07-14 3720.0 ... 2025-07-15 17:50:50.014748 2025-07-15 17:50:50.015182
3144 2025-07-15 3720.0 ... 2025-07-15 17:50:50.014748 2025-07-15 17:50:50.015182
[4 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-15 17:50:50,061 - IOOppi_data - INFO : save diff data to db IOOppi_bu_t: date ... updated_at
2560 2023-12-09 ... 2025-07-15 17:50:50.053859
[1 rows x 6 columns]
2025-07-15 17:50:50,088 - IOOppi_data - INFO : save data to db IOOppi_bu_g data:
date value
3139 2025-07-11 3700.0
3140 2025-07-12 3700.0
3141 2025-07-13 3700.0
3142 2025-07-14 3720.0
3143 2025-07-15 3720.0
2025-07-15 17:50:50,152 - IOOppi_data - INFO : save new data to db IOOppi_bu_g: date value ... created_at updated_at
3143 2025-07-12 3700.0 ... 2025-07-15 17:50:50.145149 2025-07-15 17:50:50.145541
3144 2025-07-13 3700.0 ... 2025-07-15 17:50:50.145149 2025-07-15 17:50:50.145541
3145 2025-07-14 3720.0 ... 2025-07-15 17:50:50.145149 2025-07-15 17:50:50.145541
3146 2025-07-15 3720.0 ... 2025-07-15 17:50:50.145149 2025-07-15 17:50:50.145541
[4 rows x 5 columns]
2025-07-15 17:50:50,174 - 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-15 17:50:50,939 - IOOppi_data - INFO : save data to db IOOppi_al_t data:
date value
3804 2025-07-11 20806.67
3805 2025-07-12 20806.67
3806 2025-07-13 20806.67
3807 2025-07-14 20806.67
3808 2025-07-15 20523.33
2025-07-15 17:50:51,015 - IOOppi_data - INFO : save new data to db IOOppi_al_t: date ... updated_at
3805 2025-07-12 ... 2025-07-15 17:50:51.008722
3806 2025-07-13 ... 2025-07-15 17:50:51.008722
3807 2025-07-14 ... 2025-07-15 17:50:51.008722
3808 2025-07-15 ... 2025-07-15 17:50:51.008722
[4 rows x 5 columns]
2025-07-15 17:50:51,033 - IOOppi_data - INFO : save diff data to db: IOOppi_al_t: no diff data
2025-07-15 17:50:51,040 - IOOppi_data - INFO : save data to db IOOppi_al_g data:
date value
3804 2025-07-11 20806.67
3805 2025-07-12 20806.67
3806 2025-07-13 20806.67
3807 2025-07-14 20806.67
3808 2025-07-15 20523.33
2025-07-15 17:50:51,112 - IOOppi_data - INFO : save new data to db IOOppi_al_g: date ... updated_at
3808 2025-07-12 ... 2025-07-15 17:50:51.105614
3809 2025-07-13 ... 2025-07-15 17:50:51.105614
3810 2025-07-14 ... 2025-07-15 17:50:51.105614
3811 2025-07-15 ... 2025-07-15 17:50:51.105614
[4 rows x 5 columns]
2025-07-15 17:50:51,130 - 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-15 17:50:51,862 - IOOppi_data - INFO : save data to db IOOppi_SM_t data:
date value
2918 2025-07-11 5630.0
2919 2025-07-12 5630.0
2920 2025-07-13 5630.0
2921 2025-07-14 5630.0
2922 2025-07-15 5644.0
2025-07-15 17:50:51,924 - IOOppi_data - INFO : save new data to db IOOppi_SM_t: date value ... created_at updated_at
2919 2025-07-12 5630.0 ... 2025-07-15 17:50:51.916528 2025-07-15 17:50:51.916940
2920 2025-07-13 5630.0 ... 2025-07-15 17:50:51.916528 2025-07-15 17:50:51.916940
2921 2025-07-14 5630.0 ... 2025-07-15 17:50:51.916528 2025-07-15 17:50:51.916940
2922 2025-07-15 5644.0 ... 2025-07-15 17:50:51.916528 2025-07-15 17:50:51.916940
[4 rows x 5 columns]
2025-07-15 17:50:51,943 - IOOppi_data - INFO : save diff data to db: IOOppi_SM_t: no diff data
2025-07-15 17:50:51,950 - IOOppi_data - INFO : save data to db IOOppi_SM_g data:
date value
2918 2025-07-11 5630.0
2919 2025-07-12 5630.0
2920 2025-07-13 5630.0
2921 2025-07-14 5630.0
2922 2025-07-15 5644.0
2025-07-15 17:50:52,013 - IOOppi_data - INFO : save new data to db IOOppi_SM_g: date value ... created_at updated_at
2923 2025-07-12 5630.0 ... 2025-07-15 17:50:52.004411 2025-07-15 17:50:52.004919
2924 2025-07-13 5630.0 ... 2025-07-15 17:50:52.004411 2025-07-15 17:50:52.004919
2925 2025-07-14 5630.0 ... 2025-07-15 17:50:52.004411 2025-07-15 17:50:52.004919
2926 2025-07-15 5644.0 ... 2025-07-15 17:50:52.004411 2025-07-15 17:50:52.004919
[4 rows x 5 columns]
2025-07-15 17:50:52,032 - 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-15 17:50:52,641 - IOOppi_data - INFO : save data to db IOOppi_CY_t data:
date value
2193 2025-07-11 23200.0
2194 2025-07-12 23200.0
2195 2025-07-13 23200.0
2196 2025-07-14 23200.0
2197 2025-07-15 23275.0
2025-07-15 17:50:52,693 - IOOppi_data - INFO : save new data to db IOOppi_CY_t: date value ... created_at updated_at
2194 2025-07-12 23200.0 ... 2025-07-15 17:50:52.685336 2025-07-15 17:50:52.685777
2195 2025-07-13 23200.0 ... 2025-07-15 17:50:52.685336 2025-07-15 17:50:52.685777
2196 2025-07-14 23200.0 ... 2025-07-15 17:50:52.685336 2025-07-15 17:50:52.685777
2197 2025-07-15 23275.0 ... 2025-07-15 17:50:52.685336 2025-07-15 17:50:52.685777
[4 rows x 5 columns]
2025-07-15 17:50:52,711 - IOOppi_data - INFO : save diff data to db: IOOppi_CY_t: no diff data
2025-07-15 17:50:52,717 - IOOppi_data - INFO : save data to db IOOppi_CY_g data:
date value
2193 2025-07-11 23200.0
2194 2025-07-12 23200.0
2195 2025-07-13 23200.0
2196 2025-07-14 23200.0
2197 2025-07-15 23275.0
2025-07-15 17:50:52,770 - IOOppi_data - INFO : save new data to db IOOppi_CY_g: date value ... created_at updated_at
2198 2025-07-12 23200.0 ... 2025-07-15 17:50:52.762524 2025-07-15 17:50:52.762924
2199 2025-07-13 23200.0 ... 2025-07-15 17:50:52.762524 2025-07-15 17:50:52.762924
2200 2025-07-14 23200.0 ... 2025-07-15 17:50:52.762524 2025-07-15 17:50:52.762924
2201 2025-07-15 23275.0 ... 2025-07-15 17:50:52.762524 2025-07-15 17:50:52.762924
[4 rows x 5 columns]
2025-07-15 17:50:52,788 - 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-15 17:50:53,340 - IOOppi_data - INFO : save data to db IOOppi_UR_t data:
date value
1708 2025-07-11 1845.00
1709 2025-07-12 1861.25
1710 2025-07-13 1861.25
1711 2025-07-14 1838.75
1712 2025-07-15 1837.50
2025-07-15 17:50:53,386 - IOOppi_data - INFO : save new data to db IOOppi_UR_t: date value ... created_at updated_at
1709 2025-07-12 1861.25 ... 2025-07-15 17:50:53.378886 2025-07-15 17:50:53.379284
1710 2025-07-13 1861.25 ... 2025-07-15 17:50:53.378886 2025-07-15 17:50:53.379284
1711 2025-07-14 1838.75 ... 2025-07-15 17:50:53.378886 2025-07-15 17:50:53.379284
1712 2025-07-15 1837.50 ... 2025-07-15 17:50:53.378886 2025-07-15 17:50:53.379284
[4 rows x 5 columns]
2025-07-15 17:50:53,404 - IOOppi_data - INFO : save diff data to db: IOOppi_UR_t: no diff data
2025-07-15 17:50:53,410 - IOOppi_data - INFO : save data to db IOOppi_UR_g data:
date value
1708 2025-07-11 1845.00
1709 2025-07-12 1861.25
1710 2025-07-13 1861.25
1711 2025-07-14 1838.75
1712 2025-07-15 1837.50
2025-07-15 17:50:53,458 - IOOppi_data - INFO : save new data to db IOOppi_UR_g: date value ... created_at updated_at
1713 2025-07-12 1861.25 ... 2025-07-15 17:50:53.450810 2025-07-15 17:50:53.451243
1714 2025-07-13 1861.25 ... 2025-07-15 17:50:53.450810 2025-07-15 17:50:53.451243
1715 2025-07-14 1838.75 ... 2025-07-15 17:50:53.450810 2025-07-15 17:50:53.451243
1716 2025-07-15 1837.50 ... 2025-07-15 17:50:53.450810 2025-07-15 17:50:53.451243
[4 rows x 5 columns]
2025-07-15 17:50:53,477 - 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-15 17:50:54,199 - IOOppi_data - INFO : save data to db IOOppi_ni_t data:
date value
2780 2025-07-11 122500.00
2781 2025-07-12 122500.00
2782 2025-07-13 122500.00
2783 2025-07-14 122100.00
2784 2025-07-15 120666.67
2025-07-15 17:50:54,258 - IOOppi_data - INFO : save new data to db IOOppi_ni_t: date ... updated_at
2781 2025-07-12 ... 2025-07-15 17:50:54.251513
2782 2025-07-13 ... 2025-07-15 17:50:54.251513
2783 2025-07-14 ... 2025-07-15 17:50:54.251513
2784 2025-07-15 ... 2025-07-15 17:50:54.251513
[4 rows x 5 columns]
2025-07-15 17:50:54,276 - IOOppi_data - INFO : save diff data to db: IOOppi_ni_t: no diff data
2025-07-15 17:50:54,282 - IOOppi_data - INFO : save data to db IOOppi_ni_g data:
date value
2780 2025-07-11 122500.00
2781 2025-07-12 122500.00
2782 2025-07-13 122500.00
2783 2025-07-14 122100.00
2784 2025-07-15 120666.67
2025-07-15 17:50:54,341 - IOOppi_data - INFO : save new data to db IOOppi_ni_g: date ... updated_at
2784 2025-07-12 ... 2025-07-15 17:50:54.334896
2785 2025-07-13 ... 2025-07-15 17:50:54.334896
2786 2025-07-14 ... 2025-07-15 17:50:54.334896
2787 2025-07-15 ... 2025-07-15 17:50:54.334896
[4 rows x 5 columns]
2025-07-15 17:50:54,359 - 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-15 17:50:54,991 - IOOppi_data - INFO : save data to db IOOppi_v_t data:
date value
3805 2025-07-11 4733.0
3806 2025-07-12 4733.0
3807 2025-07-13 4733.0
3808 2025-07-14 4720.0
3809 2025-07-15 4745.0
2025-07-15 17:50:55,063 - IOOppi_data - INFO : save new data to db IOOppi_v_t: date value ... created_at updated_at
3806 2025-07-12 4733.0 ... 2025-07-15 17:50:55.056138 2025-07-15 17:50:55.056530
3807 2025-07-13 4733.0 ... 2025-07-15 17:50:55.056138 2025-07-15 17:50:55.056530
3808 2025-07-14 4720.0 ... 2025-07-15 17:50:55.056138 2025-07-15 17:50:55.056530
3809 2025-07-15 4745.0 ... 2025-07-15 17:50:55.056138 2025-07-15 17:50:55.056530
[4 rows x 5 columns]
2025-07-15 17:50:55,082 - IOOppi_data - INFO : save diff data to db: IOOppi_v_t: no diff data
2025-07-15 17:50:55,088 - IOOppi_data - INFO : save data to db IOOppi_v_g data:
date value
3805 2025-07-11 4733.0
3806 2025-07-12 4733.0
3807 2025-07-13 4733.0
3808 2025-07-14 4720.0
3809 2025-07-15 4745.0
2025-07-15 17:50:55,161 - IOOppi_data - INFO : save new data to db IOOppi_v_g: date value ... created_at updated_at
3809 2025-07-12 4733.0 ... 2025-07-15 17:50:55.153990 2025-07-15 17:50:55.154381
3810 2025-07-13 4733.0 ... 2025-07-15 17:50:55.153990 2025-07-15 17:50:55.154381
3811 2025-07-14 4720.0 ... 2025-07-15 17:50:55.153990 2025-07-15 17:50:55.154381
3812 2025-07-15 4745.0 ... 2025-07-15 17:50:55.153990 2025-07-15 17:50:55.154381
[4 rows x 5 columns]
2025-07-15 17:50:55,180 - 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-15 17:50:55,781 - IOOppi_data - INFO : save data to db IOOppi_pp_t data:
date value
3044 2025-07-11 7355.00
3045 2025-07-12 7355.00
3046 2025-07-13 7355.00
3047 2025-07-14 7355.00
3048 2025-07-15 7366.67
2025-07-15 17:50:55,844 - IOOppi_data - INFO : save new data to db IOOppi_pp_t: date value ... created_at updated_at
3045 2025-07-12 7355.00 ... 2025-07-15 17:50:55.836555 2025-07-15 17:50:55.836964
3046 2025-07-13 7355.00 ... 2025-07-15 17:50:55.836555 2025-07-15 17:50:55.836964
3047 2025-07-14 7355.00 ... 2025-07-15 17:50:55.836555 2025-07-15 17:50:55.836964
3048 2025-07-15 7366.67 ... 2025-07-15 17:50:55.836555 2025-07-15 17:50:55.836964
[4 rows x 5 columns]
2025-07-15 17:50:55,862 - IOOppi_data - INFO : save diff data to db: IOOppi_pp_t: no diff data
2025-07-15 17:50:55,868 - IOOppi_data - INFO : save data to db IOOppi_pp_g data:
date value
3044 2025-07-11 7355.00
3045 2025-07-12 7355.00
3046 2025-07-13 7355.00
3047 2025-07-14 7355.00
3048 2025-07-15 7366.67
2025-07-15 17:50:55,941 - IOOppi_data - INFO : save new data to db IOOppi_pp_g: date value ... created_at updated_at
3048 2025-07-12 7355.00 ... 2025-07-15 17:50:55.933896 2025-07-15 17:50:55.934300
3049 2025-07-13 7355.00 ... 2025-07-15 17:50:55.933896 2025-07-15 17:50:55.934300
3050 2025-07-14 7355.00 ... 2025-07-15 17:50:55.933896 2025-07-15 17:50:55.934300
3051 2025-07-15 7366.67 ... 2025-07-15 17:50:55.933896 2025-07-15 17:50:55.934300
[4 rows x 5 columns]
2025-07-15 17:50:55,960 - 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-15 17:50:56,592 - IOOppi_data - INFO : save data to db IOOppi_CF_t data:
date value
3806 2025-07-11 15282.00
3807 2025-07-12 15282.00
3808 2025-07-13 15282.00
3809 2025-07-14 15312.67
3810 2025-07-15 15327.50
2025-07-15 17:50:56,663 - IOOppi_data - INFO : save new data to db IOOppi_CF_t: date ... updated_at
3807 2025-07-12 ... 2025-07-15 17:50:56.657507
3808 2025-07-13 ... 2025-07-15 17:50:56.657507
3809 2025-07-14 ... 2025-07-15 17:50:56.657507
3810 2025-07-15 ... 2025-07-15 17:50:56.657507
[4 rows x 5 columns]
2025-07-15 17:50:56,683 - IOOppi_data - INFO : save diff data to db: IOOppi_CF_t: no diff data
2025-07-15 17:50:56,689 - IOOppi_data - INFO : save data to db IOOppi_CF_g data:
date value
3806 2025-07-11 15282.00
3807 2025-07-12 15282.00
3808 2025-07-13 15282.00
3809 2025-07-14 15312.67
3810 2025-07-15 15327.50
2025-07-15 17:50:56,762 - IOOppi_data - INFO : save new data to db IOOppi_CF_g: date ... updated_at
3811 2025-07-12 ... 2025-07-15 17:50:56.755999
3812 2025-07-13 ... 2025-07-15 17:50:56.755999
3813 2025-07-14 ... 2025-07-15 17:50:56.755999
3814 2025-07-15 ... 2025-07-15 17:50:56.755999
[4 rows x 5 columns]
2025-07-15 17:50:56,781 - 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-15 17:50:57,398 - IOOppi_data - INFO : save data to db IOOppi_pb_t data:
date value
3751 2025-07-11 16993.75
3752 2025-07-12 16993.75
3753 2025-07-13 16993.75
3754 2025-07-14 16937.50
3755 2025-07-15 16925.00
2025-07-15 17:50:57,469 - IOOppi_data - INFO : save new data to db IOOppi_pb_t: date ... updated_at
3752 2025-07-12 ... 2025-07-15 17:50:57.462725
3753 2025-07-13 ... 2025-07-15 17:50:57.462725
3754 2025-07-14 ... 2025-07-15 17:50:57.462725
3755 2025-07-15 ... 2025-07-15 17:50:57.462725
[4 rows x 5 columns]
2025-07-15 17:50:57,488 - IOOppi_data - INFO : save diff data to db: IOOppi_pb_t: no diff data
2025-07-15 17:50:57,495 - IOOppi_data - INFO : save data to db IOOppi_pb_g data:
date value
3751 2025-07-11 16993.75
3752 2025-07-12 16993.75
3753 2025-07-13 16993.75
3754 2025-07-14 16937.50
3755 2025-07-15 16925.00
2025-07-15 17:50:57,643 - IOOppi_data - INFO : save new data to db IOOppi_pb_g: date ... updated_at
3755 2025-07-12 ... 2025-07-15 17:50:57.636394
3756 2025-07-13 ... 2025-07-15 17:50:57.636394
3757 2025-07-14 ... 2025-07-15 17:50:57.636394
3758 2025-07-15 ... 2025-07-15 17:50:57.636394
[4 rows x 5 columns]
2025-07-15 17:50:57,661 - 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-15 17:50:58,275 - IOOppi_data - INFO : save data to db IOOppi_hc_t data:
date value
3026 2025-07-11 3326.67
3027 2025-07-12 3326.67
3028 2025-07-13 3326.67
3029 2025-07-14 3333.33
3030 2025-07-15 3333.33
2025-07-15 17:50:58,339 - IOOppi_data - INFO : save new data to db IOOppi_hc_t: date value ... created_at updated_at
3027 2025-07-12 3326.67 ... 2025-07-15 17:50:58.331227 2025-07-15 17:50:58.331653
3028 2025-07-13 3326.67 ... 2025-07-15 17:50:58.331227 2025-07-15 17:50:58.331653
3029 2025-07-14 3333.33 ... 2025-07-15 17:50:58.331227 2025-07-15 17:50:58.331653
3030 2025-07-15 3333.33 ... 2025-07-15 17:50:58.331227 2025-07-15 17:50:58.331653
[4 rows x 5 columns]
2025-07-15 17:50:58,358 - IOOppi_data - INFO : save diff data to db: IOOppi_hc_t: no diff data
2025-07-15 17:50:58,364 - IOOppi_data - INFO : save data to db IOOppi_hc_g data:
date value
3026 2025-07-11 3326.67
3027 2025-07-12 3326.67
3028 2025-07-13 3326.67
3029 2025-07-14 3333.33
3030 2025-07-15 3333.33
2025-07-15 17:50:58,427 - IOOppi_data - INFO : save new data to db IOOppi_hc_g: date value ... created_at updated_at
3030 2025-07-12 3326.67 ... 2025-07-15 17:50:58.419927 2025-07-15 17:50:58.420316
3031 2025-07-13 3326.67 ... 2025-07-15 17:50:58.419927 2025-07-15 17:50:58.420316
3032 2025-07-14 3333.33 ... 2025-07-15 17:50:58.419927 2025-07-15 17:50:58.420316
3033 2025-07-15 3333.33 ... 2025-07-15 17:50:58.419927 2025-07-15 17:50:58.420316
[4 rows x 5 columns]
2025-07-15 17:50:58,446 - 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-15 17:50:59,144 - IOOppi_data - INFO : save data to db IOOppi_fu_t data:
date value
3306 2025-07-11 5362.5
3307 2025-07-12 5362.5
3308 2025-07-13 5362.5
3309 2025-07-14 5387.5
3310 2025-07-15 5387.5
2025-07-15 17:50:59,210 - IOOppi_data - INFO : save new data to db IOOppi_fu_t: date value ... created_at updated_at
3307 2025-07-12 5362.5 ... 2025-07-15 17:50:59.203212 2025-07-15 17:50:59.203601
3308 2025-07-13 5362.5 ... 2025-07-15 17:50:59.203212 2025-07-15 17:50:59.203601
3309 2025-07-14 5387.5 ... 2025-07-15 17:50:59.203212 2025-07-15 17:50:59.203601
3310 2025-07-15 5387.5 ... 2025-07-15 17:50:59.203212 2025-07-15 17:50:59.203601
[4 rows x 5 columns]
2025-07-15 17:50:59,229 - IOOppi_data - INFO : save diff data to db: IOOppi_fu_t: no diff data
2025-07-15 17:50:59,235 - IOOppi_data - INFO : save data to db IOOppi_fu_g data:
date value
3306 2025-07-11 5362.5
3307 2025-07-12 5362.5
3308 2025-07-13 5362.5
3309 2025-07-14 5387.5
3310 2025-07-15 5387.5
2025-07-15 17:50:59,307 - IOOppi_data - INFO : save new data to db IOOppi_fu_g: date value ... created_at updated_at
3794 2025-07-12 5362.5 ... 2025-07-15 17:50:59.299913 2025-07-15 17:50:59.300300
3795 2025-07-13 5362.5 ... 2025-07-15 17:50:59.299913 2025-07-15 17:50:59.300300
3796 2025-07-14 5387.5 ... 2025-07-15 17:50:59.299913 2025-07-15 17:50:59.300300
3797 2025-07-15 5387.5 ... 2025-07-15 17:50:59.299913 2025-07-15 17:50:59.300300
[4 rows x 5 columns]
2025-07-15 17:50:59,325 - 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-15 17:50:59,868 - IOOppi_data - INFO : save data to db IOOppi_lh_t data:
date value
1370 2025-07-11 14820.0
1371 2025-07-12 14820.0
1372 2025-07-13 14820.0
1373 2025-07-14 14730.0
1374 2025-07-15 14670.0
2025-07-15 17:50:59,911 - IOOppi_data - INFO : save new data to db IOOppi_lh_t: date value ... created_at updated_at
1371 2025-07-12 14820.0 ... 2025-07-15 17:50:59.903453 2025-07-15 17:50:59.903876
1372 2025-07-13 14820.0 ... 2025-07-15 17:50:59.903453 2025-07-15 17:50:59.903876
1373 2025-07-14 14730.0 ... 2025-07-15 17:50:59.903453 2025-07-15 17:50:59.903876
1374 2025-07-15 14670.0 ... 2025-07-15 17:50:59.903453 2025-07-15 17:50:59.903876
[4 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-15 17:51:00,150 - IOOppi_data - INFO : save diff data to db IOOppi_lh_t: date ... updated_at
116 2021-07-05 ... 2025-07-15 17:51:00.142722
117 2021-07-06 ... 2025-07-15 17:51:00.142722
121 2021-07-12 ... 2025-07-15 17:51:00.142722
122 2021-07-13 ... 2025-07-15 17:51:00.142722
194 2021-11-01 ... 2025-07-15 17:51:00.142722
[5 rows x 6 columns]
2025-07-15 17:51:00,187 - IOOppi_data - INFO : save data to db IOOppi_lh_g data:
date value
1370 2025-07-11 14820.0
1371 2025-07-12 14820.0
1372 2025-07-13 14820.0
1373 2025-07-14 14730.0
1374 2025-07-15 14670.0
2025-07-15 17:51:00,230 - IOOppi_data - INFO : save new data to db IOOppi_lh_g: date value ... created_at updated_at
1374 2025-07-12 14820.0 ... 2025-07-15 17:51:00.222383 2025-07-15 17:51:00.222845
1375 2025-07-13 14820.0 ... 2025-07-15 17:51:00.222383 2025-07-15 17:51:00.222845
1376 2025-07-14 14730.0 ... 2025-07-15 17:51:00.222383 2025-07-15 17:51:00.222845
1377 2025-07-15 14670.0 ... 2025-07-15 17:51:00.222383 2025-07-15 17:51:00.222845
[4 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-15 17:51:00,466 - IOOppi_data - INFO : save diff data to db IOOppi_lh_g: date ... updated_at
116 2021-07-05 ... 2025-07-15 17:51:00.459063
117 2021-07-06 ... 2025-07-15 17:51:00.459063
121 2021-07-12 ... 2025-07-15 17:51:00.459063
122 2021-07-13 ... 2025-07-15 17:51:00.459063
194 2021-11-01 ... 2025-07-15 17:51:00.459063
[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-15 17:51:01,112 - IOOppi_data - INFO : save data to db IOOppi_cu_t data:
date value
3802 2025-07-11 78733.33
3803 2025-07-12 78733.33
3804 2025-07-13 78733.33
3805 2025-07-14 78513.33
3806 2025-07-15 78135.00
2025-07-15 17:51:01,190 - IOOppi_data - INFO : save new data to db IOOppi_cu_t: date ... updated_at
3803 2025-07-12 ... 2025-07-15 17:51:01.181726
3804 2025-07-13 ... 2025-07-15 17:51:01.181726
3805 2025-07-14 ... 2025-07-15 17:51:01.181726
3806 2025-07-15 ... 2025-07-15 17:51:01.181726
[4 rows x 5 columns]
2025-07-15 17:51:01,209 - IOOppi_data - INFO : save diff data to db: IOOppi_cu_t: no diff data
2025-07-15 17:51:01,215 - IOOppi_data - INFO : save data to db IOOppi_cu_g data:
date value
3802 2025-07-11 78733.33
3803 2025-07-12 78733.33
3804 2025-07-13 78733.33
3805 2025-07-14 78513.33
3806 2025-07-15 78135.00
2025-07-15 17:51:01,289 - IOOppi_data - INFO : save new data to db IOOppi_cu_g: date ... updated_at
3806 2025-07-12 ... 2025-07-15 17:51:01.282676
3807 2025-07-13 ... 2025-07-15 17:51:01.282676
3808 2025-07-14 ... 2025-07-15 17:51:01.282676
3809 2025-07-15 ... 2025-07-15 17:51:01.282676
[4 rows x 5 columns]
2025-07-15 17:51:01,308 - 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-15 17:51:01,776 - 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-15 17:51:01,829 - IOOppi_data - INFO : save new data to db: IOOppi_PM_t: no new data
2025-07-15 17:51:01,829 - IOOppi_data - INFO : save diff data to db: IOOppi_PM_t: no diff data
2025-07-15 17:51:01,835 - 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-15 17:51:01,895 - IOOppi_data - INFO : save new data to db: IOOppi_PM_g: no new data
2025-07-15 17:51:01,895 - 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-15 17:51:02,549 - IOOppi_data - INFO : save data to db IOOppi_sn_t data:
date value
2780 2025-07-11 266737.5
2781 2025-07-12 266737.5
2782 2025-07-13 266737.5
2783 2025-07-14 266512.5
2784 2025-07-15 264687.5
2025-07-15 17:51:02,609 - IOOppi_data - INFO : save new data to db IOOppi_sn_t: date ... updated_at
2781 2025-07-12 ... 2025-07-15 17:51:02.602543
2782 2025-07-13 ... 2025-07-15 17:51:02.602543
2783 2025-07-14 ... 2025-07-15 17:51:02.602543
2784 2025-07-15 ... 2025-07-15 17:51:02.602543
[4 rows x 5 columns]
2025-07-15 17:51:02,629 - IOOppi_data - INFO : save diff data to db: IOOppi_sn_t: no diff data
2025-07-15 17:51:02,635 - IOOppi_data - INFO : save data to db IOOppi_sn_g data:
date value
2780 2025-07-11 266737.5
2781 2025-07-12 266737.5
2782 2025-07-13 266737.5
2783 2025-07-14 266512.5
2784 2025-07-15 264687.5
2025-07-15 17:51:02,695 - IOOppi_data - INFO : save new data to db IOOppi_sn_g: date ... updated_at
2784 2025-07-12 ... 2025-07-15 17:51:02.688833
2785 2025-07-13 ... 2025-07-15 17:51:02.688833
2786 2025-07-14 ... 2025-07-15 17:51:02.688833
2787 2025-07-15 ... 2025-07-15 17:51:02.688833
[4 rows x 5 columns]
2025-07-15 17:51:02,715 - 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-15 17:51:03,332 - IOOppi_data - INFO : save data to db IOOppi_zn_t data:
date value
3801 2025-07-11 22404.0
3802 2025-07-12 22404.0
3803 2025-07-13 22404.0
3804 2025-07-14 22154.0
3805 2025-07-15 22118.0
2025-07-15 17:51:03,403 - IOOppi_data - INFO : save new data to db IOOppi_zn_t: date value ... created_at updated_at
3802 2025-07-12 22404.0 ... 2025-07-15 17:51:03.396055 2025-07-15 17:51:03.396441
3803 2025-07-13 22404.0 ... 2025-07-15 17:51:03.396055 2025-07-15 17:51:03.396441
3804 2025-07-14 22154.0 ... 2025-07-15 17:51:03.396055 2025-07-15 17:51:03.396441
3805 2025-07-15 22118.0 ... 2025-07-15 17:51:03.396055 2025-07-15 17:51:03.396441
[4 rows x 5 columns]
2025-07-15 17:51:03,422 - IOOppi_data - INFO : save diff data to db: IOOppi_zn_t: no diff data
2025-07-15 17:51:03,429 - IOOppi_data - INFO : save data to db IOOppi_zn_g data:
date value
3801 2025-07-11 22404.0
3802 2025-07-12 22404.0
3803 2025-07-13 22404.0
3804 2025-07-14 22154.0
3805 2025-07-15 22118.0
2025-07-15 17:51:03,501 - IOOppi_data - INFO : save new data to db IOOppi_zn_g: date value ... created_at updated_at
3805 2025-07-12 22404.0 ... 2025-07-15 17:51:03.493601 2025-07-15 17:51:03.494029
3806 2025-07-13 22404.0 ... 2025-07-15 17:51:03.493601 2025-07-15 17:51:03.494029
3807 2025-07-14 22154.0 ... 2025-07-15 17:51:03.493601 2025-07-15 17:51:03.494029
3808 2025-07-15 22118.0 ... 2025-07-15 17:51:03.493601 2025-07-15 17:51:03.494029
[4 rows x 5 columns]
2025-07-15 17:51:03,520 - 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-15 17:51:04,223 - IOOppi_data - INFO : save data to db IOOppi_wr_t data:
date value
3764 2025-07-11 3355.0
3765 2025-07-12 3355.0
3766 2025-07-13 3355.0
3767 2025-07-14 3345.0
3768 2025-07-15 3345.0
2025-07-15 17:51:04,295 - IOOppi_data - INFO : save new data to db IOOppi_wr_t: date value ... created_at updated_at
3765 2025-07-12 3355.0 ... 2025-07-15 17:51:04.287450 2025-07-15 17:51:04.287879
3766 2025-07-13 3355.0 ... 2025-07-15 17:51:04.287450 2025-07-15 17:51:04.287879
3767 2025-07-14 3345.0 ... 2025-07-15 17:51:04.287450 2025-07-15 17:51:04.287879
3768 2025-07-15 3345.0 ... 2025-07-15 17:51:04.287450 2025-07-15 17:51:04.287879
[4 rows x 5 columns]
2025-07-15 17:51:04,315 - IOOppi_data - INFO : save diff data to db: IOOppi_wr_t: no diff data
2025-07-15 17:51:04,321 - IOOppi_data - INFO : save data to db IOOppi_wr_g data:
date value
3764 2025-07-11 3355.0
3765 2025-07-12 3355.0
3766 2025-07-13 3355.0
3767 2025-07-14 3345.0
3768 2025-07-15 3345.0
2025-07-15 17:51:04,394 - IOOppi_data - INFO : save new data to db IOOppi_wr_g: date value ... created_at updated_at
3768 2025-07-12 3355.0 ... 2025-07-15 17:51:04.386828 2025-07-15 17:51:04.387236
3769 2025-07-13 3355.0 ... 2025-07-15 17:51:04.386828 2025-07-15 17:51:04.387236
3770 2025-07-14 3345.0 ... 2025-07-15 17:51:04.386828 2025-07-15 17:51:04.387236
3771 2025-07-15 3345.0 ... 2025-07-15 17:51:04.386828 2025-07-15 17:51:04.387236
[4 rows x 5 columns]
2025-07-15 17:51:04,413 - 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-15 17:51:05,003 - IOOppi_data - INFO : save data to db IOOppi_pg_t data:
date value
1561 2025-07-11 4875.0
1562 2025-07-12 4875.0
1563 2025-07-13 4875.0
1564 2025-07-14 4817.5
1565 2025-07-15 4785.0
2025-07-15 17:51:05,048 - IOOppi_data - INFO : save new data to db IOOppi_pg_t: date value ... created_at updated_at
1562 2025-07-12 4875.0 ... 2025-07-15 17:51:05.041249 2025-07-15 17:51:05.041643
1563 2025-07-13 4875.0 ... 2025-07-15 17:51:05.041249 2025-07-15 17:51:05.041643
1564 2025-07-14 4817.5 ... 2025-07-15 17:51:05.041249 2025-07-15 17:51:05.041643
1565 2025-07-15 4785.0 ... 2025-07-15 17:51:05.041249 2025-07-15 17:51:05.041643
[4 rows x 5 columns]
2025-07-15 17:51:05,068 - IOOppi_data - INFO : save diff data to db: IOOppi_pg_t: no diff data
2025-07-15 17:51:05,074 - IOOppi_data - INFO : save data to db IOOppi_pg_g data:
date value
1561 2025-07-11 4875.0
1562 2025-07-12 4875.0
1563 2025-07-13 4875.0
1564 2025-07-14 4817.5
1565 2025-07-15 4785.0
2025-07-15 17:51:05,119 - IOOppi_data - INFO : save new data to db IOOppi_pg_g: date value ... created_at updated_at
1565 2025-07-12 4875.0 ... 2025-07-15 17:51:05.112153 2025-07-15 17:51:05.112539
1566 2025-07-13 4875.0 ... 2025-07-15 17:51:05.112153 2025-07-15 17:51:05.112539
1567 2025-07-14 4817.5 ... 2025-07-15 17:51:05.112153 2025-07-15 17:51:05.112539
1568 2025-07-15 4785.0 ... 2025-07-15 17:51:05.112153 2025-07-15 17:51:05.112539
[4 rows x 5 columns]
2025-07-15 17:51:05,138 - 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-15 17:51:05,725 - IOOppi_data - INFO : save data to db IOOppi_cs_t data:
date value
2835 2025-07-11 2351.43
2836 2025-07-12 2351.43
2837 2025-07-13 2351.43
2838 2025-07-14 2340.00
2839 2025-07-15 2331.43
2025-07-15 17:51:05,785 - IOOppi_data - INFO : save new data to db IOOppi_cs_t: date value ... created_at updated_at
2836 2025-07-12 2351.43 ... 2025-07-15 17:51:05.778264 2025-07-15 17:51:05.778648
2837 2025-07-13 2351.43 ... 2025-07-15 17:51:05.778264 2025-07-15 17:51:05.778648
2838 2025-07-14 2340.00 ... 2025-07-15 17:51:05.778264 2025-07-15 17:51:05.778648
2839 2025-07-15 2331.43 ... 2025-07-15 17:51:05.778264 2025-07-15 17:51:05.778648
[4 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-15 17:51:05,828 - IOOppi_data - INFO : save diff data to db IOOppi_cs_t: date ... updated_at
2835 2025-07-11 ... 2025-07-15 17:51:05.820741
[1 rows x 6 columns]
2025-07-15 17:51:05,853 - IOOppi_data - INFO : save data to db IOOppi_cs_g data:
date value
2835 2025-07-11 2351.43
2836 2025-07-12 2351.43
2837 2025-07-13 2351.43
2838 2025-07-14 2340.00
2839 2025-07-15 2331.43
2025-07-15 17:51:05,915 - IOOppi_data - INFO : save new data to db IOOppi_cs_g: date value ... created_at updated_at
2839 2025-07-12 2351.43 ... 2025-07-15 17:51:05.907859 2025-07-15 17:51:05.908255
2840 2025-07-13 2351.43 ... 2025-07-15 17:51:05.907859 2025-07-15 17:51:05.908255
2841 2025-07-14 2340.00 ... 2025-07-15 17:51:05.907859 2025-07-15 17:51:05.908255
2842 2025-07-15 2331.43 ... 2025-07-15 17:51:05.907859 2025-07-15 17:51:05.908255
[4 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-15 17:51:05,956 - IOOppi_data - INFO : save diff data to db IOOppi_cs_g: date ... updated_at
2838 2025-07-11 ... 2025-07-15 17:51:05.948531
[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-15 17:51:06,485 - IOOppi_data - INFO : save data to db IOOppi_cs_t data:
date value
2835 2025-07-11 2351.43
2836 2025-07-12 2351.43
2837 2025-07-13 2351.43
2838 2025-07-14 2340.00
2839 2025-07-15 2934.00
2025-07-15 17:51:06,537 - 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-15 17:51:06,560 - IOOppi_data - INFO : save diff data to db IOOppi_cs_t: date ... updated_at
2839 2025-07-15 ... 2025-07-15 17:51:06.552897
[1 rows x 6 columns]
2025-07-15 17:51:06,585 - IOOppi_data - INFO : save data to db IOOppi_cs_g data:
date value
2835 2025-07-11 2351.43
2836 2025-07-12 2351.43
2837 2025-07-13 2351.43
2838 2025-07-14 2340.00
2839 2025-07-15 2934.00
2025-07-15 17:51:06,637 - 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-15 17:51:06,660 - IOOppi_data - INFO : save diff data to db IOOppi_cs_g: date ... updated_at
2842 2025-07-15 ... 2025-07-15 17:51:06.653083
[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-15 17:51:07,183 - IOOppi_data - INFO : save data to db IOOppi_RS_t data:
date value
3192 2025-07-11 9568.33
3193 2025-07-12 9568.33
3194 2025-07-13 9568.33
3195 2025-07-14 9541.67
3196 2025-07-15 9533.33
2025-07-15 17:51:07,240 - IOOppi_data - INFO : save new data to db: IOOppi_RS_t: no new data
2025-07-15 17:51:07,241 - IOOppi_data - INFO : save diff data to db: IOOppi_RS_t: no diff data
2025-07-15 17:51:07,247 - IOOppi_data - INFO : save data to db IOOppi_RS_g data:
date value
3192 2025-07-11 9568.33
3193 2025-07-12 9568.33
3194 2025-07-13 9568.33
3195 2025-07-14 9541.67
3196 2025-07-15 9533.33
2025-07-15 17:51:07,303 - IOOppi_data - INFO : save new data to db: IOOppi_RS_g: no new data
2025-07-15 17:51:07,304 - 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-15 17:51:07,869 - IOOppi_data - INFO : save data to db IOOppi_eg_t data:
date value
1876 2025-07-11 4405.0
1877 2025-07-12 4405.0
1878 2025-07-13 4405.0
1879 2025-07-14 4410.0
1880 2025-07-15 4405.0
2025-07-15 17:51:07,919 - IOOppi_data - INFO : save new data to db IOOppi_eg_t: date value ... created_at updated_at
1877 2025-07-12 4405.0 ... 2025-07-15 17:51:07.911601 2025-07-15 17:51:07.912012
1878 2025-07-13 4405.0 ... 2025-07-15 17:51:07.911601 2025-07-15 17:51:07.912012
1879 2025-07-14 4410.0 ... 2025-07-15 17:51:07.911601 2025-07-15 17:51:07.912012
1880 2025-07-15 4405.0 ... 2025-07-15 17:51:07.911601 2025-07-15 17:51:07.912012
[4 rows x 5 columns]
2025-07-15 17:51:07,939 - IOOppi_data - INFO : save diff data to db: IOOppi_eg_t: no diff data
2025-07-15 17:51:07,945 - IOOppi_data - INFO : save data to db IOOppi_eg_g data:
date value
1876 2025-07-11 4405.0
1877 2025-07-12 4405.0
1878 2025-07-13 4405.0
1879 2025-07-14 4410.0
1880 2025-07-15 4405.0
2025-07-15 17:51:07,994 - IOOppi_data - INFO : save new data to db IOOppi_eg_g: date value ... created_at updated_at
1880 2025-07-12 4405.0 ... 2025-07-15 17:51:07.987130 2025-07-15 17:51:07.987514
1881 2025-07-13 4405.0 ... 2025-07-15 17:51:07.987130 2025-07-15 17:51:07.987514
1882 2025-07-14 4410.0 ... 2025-07-15 17:51:07.987130 2025-07-15 17:51:07.987514
1883 2025-07-15 4405.0 ... 2025-07-15 17:51:07.987130 2025-07-15 17:51:07.987514
[4 rows x 5 columns]
2025-07-15 17:51:08,012 - 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-15 17:51:08,605 - IOOppi_data - INFO : save data to db IOOppi_sp_t data:
date value
1885 2025-07-11 5950.0
1886 2025-07-12 5950.0
1887 2025-07-13 5950.0
1888 2025-07-14 5950.0
1889 2025-07-15 5950.0
2025-07-15 17:51:08,654 - IOOppi_data - INFO : save new data to db IOOppi_sp_t: date value ... created_at updated_at
1886 2025-07-12 5950.0 ... 2025-07-15 17:51:08.647159 2025-07-15 17:51:08.647543
1887 2025-07-13 5950.0 ... 2025-07-15 17:51:08.647159 2025-07-15 17:51:08.647543
1888 2025-07-14 5950.0 ... 2025-07-15 17:51:08.647159 2025-07-15 17:51:08.647543
1889 2025-07-15 5950.0 ... 2025-07-15 17:51:08.647159 2025-07-15 17:51:08.647543
[4 rows x 5 columns]
2025-07-15 17:51:08,673 - IOOppi_data - INFO : save diff data to db: IOOppi_sp_t: no diff data
2025-07-15 17:51:08,679 - IOOppi_data - INFO : save data to db IOOppi_sp_g data:
date value
1885 2025-07-11 5950.0
1886 2025-07-12 5950.0
1887 2025-07-13 5950.0
1888 2025-07-14 5950.0
1889 2025-07-15 5950.0
2025-07-15 17:51:08,729 - IOOppi_data - INFO : save new data to db IOOppi_sp_g: date value ... created_at updated_at
1889 2025-07-12 5950.0 ... 2025-07-15 17:51:08.722253 2025-07-15 17:51:08.722640
1890 2025-07-13 5950.0 ... 2025-07-15 17:51:08.722253 2025-07-15 17:51:08.722640
1891 2025-07-14 5950.0 ... 2025-07-15 17:51:08.722253 2025-07-15 17:51:08.722640
1892 2025-07-15 5950.0 ... 2025-07-15 17:51:08.722253 2025-07-15 17:51:08.722640
[4 rows x 5 columns]
2025-07-15 17:51:08,748 - 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-15 17:51:09,372 - IOOppi_data - INFO : save data to db IOOppi_p_t data:
date value
3553 2025-07-11 8944.0
3554 2025-07-12 8944.0
3555 2025-07-13 8944.0
3556 2025-07-14 8890.0
3557 2025-07-15 8844.0
2025-07-15 17:51:09,442 - IOOppi_data - INFO : save new data to db IOOppi_p_t: date value ... created_at updated_at
3554 2025-07-12 8944.0 ... 2025-07-15 17:51:09.434366 2025-07-15 17:51:09.434779
3555 2025-07-13 8944.0 ... 2025-07-15 17:51:09.434366 2025-07-15 17:51:09.434779
3556 2025-07-14 8890.0 ... 2025-07-15 17:51:09.434366 2025-07-15 17:51:09.434779
3557 2025-07-15 8844.0 ... 2025-07-15 17:51:09.434366 2025-07-15 17:51:09.434779
[4 rows x 5 columns]
2025-07-15 17:51:09,461 - IOOppi_data - INFO : save diff data to db: IOOppi_p_t: no diff data
2025-07-15 17:51:09,467 - IOOppi_data - INFO : save data to db IOOppi_p_g data:
date value
3553 2025-07-11 8944.0
3554 2025-07-12 8944.0
3555 2025-07-13 8944.0
3556 2025-07-14 8890.0
3557 2025-07-15 8844.0
2025-07-15 17:51:09,537 - IOOppi_data - INFO : save new data to db IOOppi_p_g: date value ... created_at updated_at
3557 2025-07-12 8944.0 ... 2025-07-15 17:51:09.530372 2025-07-15 17:51:09.530769
3558 2025-07-13 8944.0 ... 2025-07-15 17:51:09.530372 2025-07-15 17:51:09.530769
3559 2025-07-14 8890.0 ... 2025-07-15 17:51:09.530372 2025-07-15 17:51:09.530769
3560 2025-07-15 8844.0 ... 2025-07-15 17:51:09.530372 2025-07-15 17:51:09.530769
[4 rows x 5 columns]
2025-07-15 17:51:09,557 - IOOppi_data - INFO : save diff data to db: IOOppi_p_g: no diff data