=========================================================================
2025-07-22 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-22 17:50:28,635 - IOOppi_data - INFO : save data to db IOOppi_rb_t data:
date value
3368 2025-07-18 3196.0
3369 2025-07-19 3196.0
3370 2025-07-20 3196.0
3371 2025-07-21 3234.0
3372 2025-07-22 3297.0
2025-07-22 17:50:28,715 - IOOppi_data - INFO : save new data to db IOOppi_rb_t: date value ... created_at updated_at
3369 2025-07-19 3196.0 ... 2025-07-22 17:50:28.708119 2025-07-22 17:50:28.708519
3370 2025-07-20 3196.0 ... 2025-07-22 17:50:28.708119 2025-07-22 17:50:28.708519
3371 2025-07-21 3234.0 ... 2025-07-22 17:50:28.708119 2025-07-22 17:50:28.708519
3372 2025-07-22 3297.0 ... 2025-07-22 17:50:28.708119 2025-07-22 17:50:28.708519
[4 rows x 5 columns]
2025-07-22 17:50:28,735 - IOOppi_data - INFO : save diff data to db: IOOppi_rb_t: no diff data
2025-07-22 17:50:28,741 - IOOppi_data - INFO : save data to db IOOppi_rb_g data:
date value
3368 2025-07-18 3196.0
3369 2025-07-19 3196.0
3370 2025-07-20 3196.0
3371 2025-07-21 3234.0
3372 2025-07-22 3297.0
2025-07-22 17:50:28,808 - IOOppi_data - INFO : save new data to db IOOppi_rb_g: date value ... created_at updated_at
3372 2025-07-19 3196.0 ... 2025-07-22 17:50:28.800630 2025-07-22 17:50:28.801044
3373 2025-07-20 3196.0 ... 2025-07-22 17:50:28.800630 2025-07-22 17:50:28.801044
3374 2025-07-21 3234.0 ... 2025-07-22 17:50:28.800630 2025-07-22 17:50:28.801044
3375 2025-07-22 3297.0 ... 2025-07-22 17:50:28.800630 2025-07-22 17:50:28.801044
[4 rows x 5 columns]
2025-07-22 17:50:28,827 - 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-22 17:50:29,528 - IOOppi_data - INFO : save data to db IOOppi_MA_t data:
date value
3589 2025-07-18 2383.33
3590 2025-07-19 2383.33
3591 2025-07-20 2383.33
3592 2025-07-21 2405.00
3593 2025-07-22 2433.33
2025-07-22 17:50:29,596 - IOOppi_data - INFO : save new data to db IOOppi_MA_t: date value ... created_at updated_at
3590 2025-07-19 2383.33 ... 2025-07-22 17:50:29.589183 2025-07-22 17:50:29.589568
3591 2025-07-20 2383.33 ... 2025-07-22 17:50:29.589183 2025-07-22 17:50:29.589568
3592 2025-07-21 2405.00 ... 2025-07-22 17:50:29.589183 2025-07-22 17:50:29.589568
3593 2025-07-22 2433.33 ... 2025-07-22 17:50:29.589183 2025-07-22 17:50:29.589568
[4 rows x 5 columns]
2025-07-22 17:50:29,640 - IOOppi_data - INFO : save diff data to db: IOOppi_MA_t: no diff data
2025-07-22 17:50:29,646 - IOOppi_data - INFO : save data to db IOOppi_MA_g data:
date value
3589 2025-07-18 2383.33
3590 2025-07-19 2383.33
3591 2025-07-20 2383.33
3592 2025-07-21 2405.00
3593 2025-07-22 2433.33
2025-07-22 17:50:29,715 - IOOppi_data - INFO : save new data to db IOOppi_MA_g: date value ... created_at updated_at
3594 2025-07-19 2383.33 ... 2025-07-22 17:50:29.707514 2025-07-22 17:50:29.707920
3595 2025-07-20 2383.33 ... 2025-07-22 17:50:29.707514 2025-07-22 17:50:29.707920
3596 2025-07-21 2405.00 ... 2025-07-22 17:50:29.707514 2025-07-22 17:50:29.707920
3597 2025-07-22 2433.33 ... 2025-07-22 17:50:29.707514 2025-07-22 17:50:29.707920
[4 rows x 5 columns]
2025-07-22 17:50:29,733 - 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-22 17:50:30,467 - IOOppi_data - INFO : save data to db IOOppi_PTA_t data:
date value
929 2025-07-18 4776.66
930 2025-07-19 4776.66
931 2025-07-20 4776.66
932 2025-07-21 4825.00
933 2025-07-22 4817.00
2025-07-22 17:50:30,506 - IOOppi_data - INFO : save new data to db IOOppi_PTA_t: date value ... created_at updated_at
930 2025-07-19 4776.66 ... 2025-07-22 17:50:30.497283 2025-07-22 17:50:30.497711
931 2025-07-20 4776.66 ... 2025-07-22 17:50:30.497283 2025-07-22 17:50:30.497711
932 2025-07-21 4825.00 ... 2025-07-22 17:50:30.497283 2025-07-22 17:50:30.497711
933 2025-07-22 4817.00 ... 2025-07-22 17:50:30.497283 2025-07-22 17:50:30.497711
[4 rows x 5 columns]
2025-07-22 17:50:30,525 - IOOppi_data - INFO : save diff data to db: IOOppi_PTA_t: no diff data
2025-07-22 17:50:30,530 - IOOppi_data - INFO : save data to db IOOppi_PTA_g data:
date value
929 2025-07-18 4776.66
930 2025-07-19 4776.66
931 2025-07-20 4776.66
932 2025-07-21 4825.00
933 2025-07-22 4817.00
2025-07-22 17:50:30,566 - IOOppi_data - INFO : save new data to db IOOppi_PTA_g: date value ... created_at updated_at
930 2025-07-19 4776.66 ... 2025-07-22 17:50:30.559023 2025-07-22 17:50:30.559403
931 2025-07-20 4776.66 ... 2025-07-22 17:50:30.559023 2025-07-22 17:50:30.559403
932 2025-07-21 4825.00 ... 2025-07-22 17:50:30.559023 2025-07-22 17:50:30.559403
933 2025-07-22 4817.00 ... 2025-07-22 17:50:30.559023 2025-07-22 17:50:30.559403
[4 rows x 5 columns]
2025-07-22 17:50:30,585 - 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-22 17:50:31,226 - IOOppi_data - INFO : save data to db IOOppi_ru_t data:
date value
3808 2025-07-18 14900.00
3809 2025-07-19 14900.00
3810 2025-07-20 14900.00
3811 2025-07-21 14941.67
3812 2025-07-22 15108.33
2025-07-22 17:50:31,297 - IOOppi_data - INFO : save new data to db IOOppi_ru_t: date ... updated_at
3809 2025-07-19 ... 2025-07-22 17:50:31.290596
3810 2025-07-20 ... 2025-07-22 17:50:31.290596
3811 2025-07-21 ... 2025-07-22 17:50:31.290596
3812 2025-07-22 ... 2025-07-22 17:50:31.290596
[4 rows x 5 columns]
2025-07-22 17:50:31,316 - IOOppi_data - INFO : save diff data to db: IOOppi_ru_t: no diff data
2025-07-22 17:50:31,322 - IOOppi_data - INFO : save data to db IOOppi_ru_g data:
date value
3808 2025-07-18 14900.00
3809 2025-07-19 14900.00
3810 2025-07-20 14900.00
3811 2025-07-21 14941.67
3812 2025-07-22 15108.33
2025-07-22 17:50:31,422 - IOOppi_data - INFO : save new data to db IOOppi_ru_g: date ... updated_at
3812 2025-07-19 ... 2025-07-22 17:50:31.415514
3813 2025-07-20 ... 2025-07-22 17:50:31.415514
3814 2025-07-21 ... 2025-07-22 17:50:31.415514
3815 2025-07-22 ... 2025-07-22 17:50:31.415514
[4 rows x 5 columns]
2025-07-22 17:50:31,440 - 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-22 17:50:32,059 - IOOppi_data - INFO : save data to db IOOppi_i_t data:
date value
3140 2025-07-18 787.33
3141 2025-07-19 787.33
3142 2025-07-20 779.22
3143 2025-07-21 799.11
3144 2025-07-22 798.89
2025-07-22 17:50:32,122 - IOOppi_data - INFO : save new data to db IOOppi_i_t: date value ... created_at updated_at
3141 2025-07-19 787.33 ... 2025-07-22 17:50:32.115332 2025-07-22 17:50:32.115722
3142 2025-07-20 779.22 ... 2025-07-22 17:50:32.115332 2025-07-22 17:50:32.115722
3143 2025-07-21 799.11 ... 2025-07-22 17:50:32.115332 2025-07-22 17:50:32.115722
3144 2025-07-22 798.89 ... 2025-07-22 17:50:32.115332 2025-07-22 17:50:32.115722
[4 rows x 5 columns]
2025-07-22 17:50:32,141 - IOOppi_data - INFO : save diff data to db: IOOppi_i_t: no diff data
2025-07-22 17:50:32,147 - IOOppi_data - INFO : save data to db IOOppi_i_g data:
date value
3140 2025-07-18 787.33
3141 2025-07-19 787.33
3142 2025-07-20 779.22
3143 2025-07-21 799.11
3144 2025-07-22 798.89
2025-07-22 17:50:32,213 - IOOppi_data - INFO : save new data to db IOOppi_i_g: date value ... created_at updated_at
3144 2025-07-19 787.33 ... 2025-07-22 17:50:32.205936 2025-07-22 17:50:32.206341
3145 2025-07-20 779.22 ... 2025-07-22 17:50:32.205936 2025-07-22 17:50:32.206341
3146 2025-07-21 799.11 ... 2025-07-22 17:50:32.205936 2025-07-22 17:50:32.206341
3147 2025-07-22 798.89 ... 2025-07-22 17:50:32.205936 2025-07-22 17:50:32.206341
[4 rows x 5 columns]
2025-07-22 17:50:32,232 - 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-22 17:50:32,818 - IOOppi_data - INFO : save data to db IOOppi_FG_t data:
date value
3343 2025-07-18 1142.4
3344 2025-07-19 1142.4
3345 2025-07-20 1142.4
3346 2025-07-21 1174.4
3347 2025-07-22 1174.4
2025-07-22 17:50:32,885 - IOOppi_data - INFO : save new data to db IOOppi_FG_t: date value ... created_at updated_at
3344 2025-07-19 1142.4 ... 2025-07-22 17:50:32.877936 2025-07-22 17:50:32.878332
3345 2025-07-20 1142.4 ... 2025-07-22 17:50:32.877936 2025-07-22 17:50:32.878332
3346 2025-07-21 1174.4 ... 2025-07-22 17:50:32.877936 2025-07-22 17:50:32.878332
3347 2025-07-22 1174.4 ... 2025-07-22 17:50:32.877936 2025-07-22 17:50:32.878332
[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-22 17:50:35,836 - IOOppi_data - INFO : save diff data to db IOOppi_FG_t: date ... updated_at
12 2012-12-19 ... 2025-07-22 17:50:35.828869
21 2013-01-04 ... 2025-07-22 17:50:35.828869
54 2013-02-27 ... 2025-07-22 17:50:35.828869
60 2013-03-07 ... 2025-07-22 17:50:35.828869
61 2013-03-08 ... 2025-07-22 17:50:35.828869
[5 rows x 6 columns]
2025-07-22 17:50:36,013 - IOOppi_data - INFO : save data to db IOOppi_FG_g data:
date value
3343 2025-07-18 1142.4
3344 2025-07-19 1142.4
3345 2025-07-20 1142.4
3346 2025-07-21 1174.4
3347 2025-07-22 1174.4
2025-07-22 17:50:36,081 - IOOppi_data - INFO : save new data to db IOOppi_FG_g: date value ... created_at updated_at
3348 2025-07-19 1142.4 ... 2025-07-22 17:50:36.073328 2025-07-22 17:50:36.073711
3349 2025-07-20 1142.4 ... 2025-07-22 17:50:36.073328 2025-07-22 17:50:36.073711
3350 2025-07-21 1174.4 ... 2025-07-22 17:50:36.073328 2025-07-22 17:50:36.073711
3351 2025-07-22 1174.4 ... 2025-07-22 17:50:36.073328 2025-07-22 17:50:36.073711
[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-22 17:50:38,368 - IOOppi_data - INFO : save diff data to db IOOppi_FG_g: date ... updated_at
12 2012-12-19 ... 2025-07-22 17:50:38.359803
21 2013-01-04 ... 2025-07-22 17:50:38.359803
54 2013-02-27 ... 2025-07-22 17:50:38.359803
60 2013-03-07 ... 2025-07-22 17:50:38.359803
61 2013-03-08 ... 2025-07-22 17:50:38.359803
[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-22 17:50:39,171 - IOOppi_data - INFO : save data to db IOOppi_eb_t data:
date value
1688 2025-07-18 7846.0
1689 2025-07-19 7846.0
1690 2025-07-20 7846.0
1691 2025-07-21 7856.0
1692 2025-07-22 7860.0
2025-07-22 17:50:39,217 - IOOppi_data - INFO : save new data to db IOOppi_eb_t: date value ... created_at updated_at
1689 2025-07-19 7846.0 ... 2025-07-22 17:50:39.210073 2025-07-22 17:50:39.210458
1690 2025-07-20 7846.0 ... 2025-07-22 17:50:39.210073 2025-07-22 17:50:39.210458
1691 2025-07-21 7856.0 ... 2025-07-22 17:50:39.210073 2025-07-22 17:50:39.210458
1692 2025-07-22 7860.0 ... 2025-07-22 17:50:39.210073 2025-07-22 17:50:39.210458
[4 rows x 5 columns]
2025-07-22 17:50:39,236 - IOOppi_data - INFO : save diff data to db: IOOppi_eb_t: no diff data
2025-07-22 17:50:39,242 - IOOppi_data - INFO : save data to db IOOppi_eb_g data:
date value
1688 2025-07-18 7846.0
1689 2025-07-19 7846.0
1690 2025-07-20 7846.0
1691 2025-07-21 7856.0
1692 2025-07-22 7860.0
2025-07-22 17:50:39,288 - IOOppi_data - INFO : save new data to db IOOppi_eb_g: date value ... created_at updated_at
1692 2025-07-19 7846.0 ... 2025-07-22 17:50:39.280589 2025-07-22 17:50:39.280997
1693 2025-07-20 7846.0 ... 2025-07-22 17:50:39.280589 2025-07-22 17:50:39.280997
1694 2025-07-21 7856.0 ... 2025-07-22 17:50:39.280589 2025-07-22 17:50:39.280997
1695 2025-07-22 7860.0 ... 2025-07-22 17:50:39.280589 2025-07-22 17:50:39.280997
[4 rows x 5 columns]
2025-07-22 17:50:39,306 - 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-22 17:50:39,865 - IOOppi_data - INFO : save data to db IOOppi_SR_t data:
date value
3799 2025-07-18 6043.33
3800 2025-07-19 6043.33
3801 2025-07-20 6043.33
3802 2025-07-21 6046.67
3803 2025-07-22 6043.33
2025-07-22 17:50:39,936 - IOOppi_data - INFO : save new data to db IOOppi_SR_t: date value ... created_at updated_at
3800 2025-07-19 6043.33 ... 2025-07-22 17:50:39.929262 2025-07-22 17:50:39.929645
3801 2025-07-20 6043.33 ... 2025-07-22 17:50:39.929262 2025-07-22 17:50:39.929645
3802 2025-07-21 6046.67 ... 2025-07-22 17:50:39.929262 2025-07-22 17:50:39.929645
3803 2025-07-22 6043.33 ... 2025-07-22 17:50:39.929262 2025-07-22 17:50:39.929645
[4 rows x 5 columns]
2025-07-22 17:50:39,955 - IOOppi_data - INFO : save diff data to db: IOOppi_SR_t: no diff data
2025-07-22 17:50:39,961 - IOOppi_data - INFO : save data to db IOOppi_SR_g data:
date value
3799 2025-07-18 6043.33
3800 2025-07-19 6043.33
3801 2025-07-20 6043.33
3802 2025-07-21 6046.67
3803 2025-07-22 6043.33
2025-07-22 17:50:40,033 - IOOppi_data - INFO : save new data to db IOOppi_SR_g: date value ... created_at updated_at
3804 2025-07-19 6043.33 ... 2025-07-22 17:50:40.025990 2025-07-22 17:50:40.026378
3805 2025-07-20 6043.33 ... 2025-07-22 17:50:40.025990 2025-07-22 17:50:40.026378
3806 2025-07-21 6046.67 ... 2025-07-22 17:50:40.025990 2025-07-22 17:50:40.026378
3807 2025-07-22 6043.33 ... 2025-07-22 17:50:40.025990 2025-07-22 17:50:40.026378
[4 rows x 5 columns]
2025-07-22 17:50:40,051 - 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-22 17:50:40,704 - IOOppi_data - INFO : save data to db IOOppi_ss_t data:
date value
1689 2025-07-18 12937.5
1690 2025-07-19 12937.5
1691 2025-07-20 12937.5
1692 2025-07-21 12955.0
1693 2025-07-22 12955.0
2025-07-22 17:50:40,750 - IOOppi_data - INFO : save new data to db IOOppi_ss_t: date value ... created_at updated_at
1690 2025-07-19 12937.5 ... 2025-07-22 17:50:40.742926 2025-07-22 17:50:40.743310
1691 2025-07-20 12937.5 ... 2025-07-22 17:50:40.742926 2025-07-22 17:50:40.743310
1692 2025-07-21 12955.0 ... 2025-07-22 17:50:40.742926 2025-07-22 17:50:40.743310
1693 2025-07-22 12955.0 ... 2025-07-22 17:50:40.742926 2025-07-22 17:50:40.743310
[4 rows x 5 columns]
2025-07-22 17:50:40,769 - IOOppi_data - INFO : save diff data to db: IOOppi_ss_t: no diff data
2025-07-22 17:50:40,774 - IOOppi_data - INFO : save data to db IOOppi_ss_g data:
date value
1689 2025-07-18 12937.5
1690 2025-07-19 12937.5
1691 2025-07-20 12937.5
1692 2025-07-21 12955.0
1693 2025-07-22 12955.0
2025-07-22 17:50:40,820 - IOOppi_data - INFO : save new data to db IOOppi_ss_g: date value ... created_at updated_at
1693 2025-07-19 12937.5 ... 2025-07-22 17:50:40.812703 2025-07-22 17:50:40.813110
1694 2025-07-20 12937.5 ... 2025-07-22 17:50:40.812703 2025-07-22 17:50:40.813110
1695 2025-07-21 12955.0 ... 2025-07-22 17:50:40.812703 2025-07-22 17:50:40.813110
1696 2025-07-22 12955.0 ... 2025-07-22 17:50:40.812703 2025-07-22 17:50:40.813110
[4 rows x 5 columns]
2025-07-22 17:50:40,838 - 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-22 17:50:41,829 - IOOppi_data - INFO : save data to db IOOppi_RS_t data:
date value
3199 2025-07-18 9691.67
3200 2025-07-19 9691.67
3201 2025-07-20 9691.67
3202 2025-07-21 9681.67
3203 2025-07-22 9586.67
2025-07-22 17:50:41,895 - IOOppi_data - INFO : save new data to db IOOppi_RS_t: date value ... created_at updated_at
3200 2025-07-19 9691.67 ... 2025-07-22 17:50:41.887878 2025-07-22 17:50:41.888304
3201 2025-07-20 9691.67 ... 2025-07-22 17:50:41.887878 2025-07-22 17:50:41.888304
3202 2025-07-21 9681.67 ... 2025-07-22 17:50:41.887878 2025-07-22 17:50:41.888304
3203 2025-07-22 9586.67 ... 2025-07-22 17:50:41.887878 2025-07-22 17:50:41.888304
[4 rows x 5 columns]
2025-07-22 17:50:41,914 - IOOppi_data - INFO : save diff data to db: IOOppi_RS_t: no diff data
2025-07-22 17:50:41,920 - IOOppi_data - INFO : save data to db IOOppi_RS_g data:
date value
3199 2025-07-18 9691.67
3200 2025-07-19 9691.67
3201 2025-07-20 9691.67
3202 2025-07-21 9681.67
3203 2025-07-22 9586.67
2025-07-22 17:50:41,987 - IOOppi_data - INFO : save new data to db IOOppi_RS_g: date value ... created_at updated_at
3204 2025-07-19 9691.67 ... 2025-07-22 17:50:41.979444 2025-07-22 17:50:41.979858
3205 2025-07-20 9691.67 ... 2025-07-22 17:50:41.979444 2025-07-22 17:50:41.979858
3206 2025-07-21 9681.67 ... 2025-07-22 17:50:41.979444 2025-07-22 17:50:41.979858
3207 2025-07-22 9586.67 ... 2025-07-22 17:50:41.979444 2025-07-22 17:50:41.979858
[4 rows x 5 columns]
2025-07-22 17:50:42,005 - 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-22 17:50:42,637 - IOOppi_data - INFO : save data to db IOOppi_RM_t data:
date value
3322 2025-07-18 2668.33
3323 2025-07-19 2668.33
3324 2025-07-20 2668.33
3325 2025-07-21 2675.00
3326 2025-07-22 2690.00
2025-07-22 17:50:42,706 - IOOppi_data - INFO : save new data to db IOOppi_RM_t: date value ... created_at updated_at
3323 2025-07-19 2668.33 ... 2025-07-22 17:50:42.699051 2025-07-22 17:50:42.699441
3324 2025-07-20 2668.33 ... 2025-07-22 17:50:42.699051 2025-07-22 17:50:42.699441
3325 2025-07-21 2675.00 ... 2025-07-22 17:50:42.699051 2025-07-22 17:50:42.699441
3326 2025-07-22 2690.00 ... 2025-07-22 17:50:42.699051 2025-07-22 17:50:42.699441
[4 rows x 5 columns]
2025-07-22 17:50:42,726 - IOOppi_data - INFO : save diff data to db: IOOppi_RM_t: no diff data
2025-07-22 17:50:42,732 - IOOppi_data - INFO : save data to db IOOppi_RM_g data:
date value
3322 2025-07-18 2668.33
3323 2025-07-19 2668.33
3324 2025-07-20 2668.33
3325 2025-07-21 2675.00
3326 2025-07-22 2690.00
2025-07-22 17:50:42,807 - IOOppi_data - INFO : save new data to db IOOppi_RM_g: date value ... created_at updated_at
3327 2025-07-19 2668.33 ... 2025-07-22 17:50:42.798722 2025-07-22 17:50:42.799156
3328 2025-07-20 2668.33 ... 2025-07-22 17:50:42.798722 2025-07-22 17:50:42.799156
3329 2025-07-21 2675.00 ... 2025-07-22 17:50:42.798722 2025-07-22 17:50:42.799156
3330 2025-07-22 2690.00 ... 2025-07-22 17:50:42.798722 2025-07-22 17:50:42.799156
[4 rows x 5 columns]
2025-07-22 17:50:42,826 - 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-22 17:50:43,543 - IOOppi_data - INFO : save data to db IOOppi_SA_t data:
date value
1526 2025-07-18 1250.0
1527 2025-07-19 1250.0
1528 2025-07-20 1250.0
1529 2025-07-21 1250.0
1530 2025-07-22 1250.0
2025-07-22 17:50:43,591 - IOOppi_data - INFO : save new data to db IOOppi_SA_t: date value ... created_at updated_at
1527 2025-07-19 1250.0 ... 2025-07-22 17:50:43.582535 2025-07-22 17:50:43.582978
1528 2025-07-20 1250.0 ... 2025-07-22 17:50:43.582535 2025-07-22 17:50:43.582978
1529 2025-07-21 1250.0 ... 2025-07-22 17:50:43.582535 2025-07-22 17:50:43.582978
1530 2025-07-22 1250.0 ... 2025-07-22 17:50:43.582535 2025-07-22 17:50:43.582978
[4 rows x 5 columns]
2025-07-22 17:50:43,609 - IOOppi_data - INFO : save diff data to db: IOOppi_SA_t: no diff data
2025-07-22 17:50:43,616 - IOOppi_data - INFO : save data to db IOOppi_SA_g data:
date value
1526 2025-07-18 1250.0
1527 2025-07-19 1250.0
1528 2025-07-20 1250.0
1529 2025-07-21 1250.0
1530 2025-07-22 1250.0
2025-07-22 17:50:43,662 - IOOppi_data - INFO : save new data to db IOOppi_SA_g: date value ... created_at updated_at
1531 2025-07-19 1250.0 ... 2025-07-22 17:50:43.653392 2025-07-22 17:50:43.653807
1532 2025-07-20 1250.0 ... 2025-07-22 17:50:43.653392 2025-07-22 17:50:43.653807
1533 2025-07-21 1250.0 ... 2025-07-22 17:50:43.653392 2025-07-22 17:50:43.653807
1534 2025-07-22 1250.0 ... 2025-07-22 17:50:43.653392 2025-07-22 17:50:43.653807
[4 rows x 5 columns]
2025-07-22 17:50:43,680 - 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-22 17:50:44,386 - IOOppi_data - INFO : save data to db IOOppi_PF_t data:
date value
1439 2025-07-18 6643.33
1440 2025-07-19 6643.33
1441 2025-07-20 6643.33
1442 2025-07-21 6610.42
1443 2025-07-22 6592.08
2025-07-22 17:50:44,429 - IOOppi_data - INFO : save new data to db IOOppi_PF_t: date value ... created_at updated_at
1440 2025-07-19 6643.33 ... 2025-07-22 17:50:44.421800 2025-07-22 17:50:44.422203
1441 2025-07-20 6643.33 ... 2025-07-22 17:50:44.421800 2025-07-22 17:50:44.422203
1442 2025-07-21 6610.42 ... 2025-07-22 17:50:44.421800 2025-07-22 17:50:44.422203
1443 2025-07-22 6592.08 ... 2025-07-22 17:50:44.421800 2025-07-22 17:50:44.422203
[4 rows x 5 columns]
2025-07-22 17:50:44,448 - IOOppi_data - INFO : save diff data to db: IOOppi_PF_t: no diff data
2025-07-22 17:50:44,453 - IOOppi_data - INFO : save data to db IOOppi_PF_g data:
date value
1439 2025-07-18 6643.33
1440 2025-07-19 6643.33
1441 2025-07-20 6643.33
1442 2025-07-21 6610.42
1443 2025-07-22 6592.08
2025-07-22 17:50:44,497 - IOOppi_data - INFO : save new data to db IOOppi_PF_g: date value ... created_at updated_at
1444 2025-07-19 6643.33 ... 2025-07-22 17:50:44.490004 2025-07-22 17:50:44.490386
1445 2025-07-20 6643.33 ... 2025-07-22 17:50:44.490004 2025-07-22 17:50:44.490386
1446 2025-07-21 6610.42 ... 2025-07-22 17:50:44.490004 2025-07-22 17:50:44.490386
1447 2025-07-22 6592.08 ... 2025-07-22 17:50:44.490004 2025-07-22 17:50:44.490386
[4 rows x 5 columns]
2025-07-22 17:50:44,515 - 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-22 17:50:45,276 - IOOppi_data - INFO : save data to db IOOppi_m_t data:
date value
3812 2025-07-18 2966.0
3813 2025-07-19 2966.0
3814 2025-07-20 2966.0
3815 2025-07-21 2974.0
3816 2025-07-22 2990.0
2025-07-22 17:50:45,347 - IOOppi_data - INFO : save new data to db IOOppi_m_t: date value ... created_at updated_at
3813 2025-07-19 2966.0 ... 2025-07-22 17:50:45.340336 2025-07-22 17:50:45.340741
3814 2025-07-20 2966.0 ... 2025-07-22 17:50:45.340336 2025-07-22 17:50:45.340741
3815 2025-07-21 2974.0 ... 2025-07-22 17:50:45.340336 2025-07-22 17:50:45.340741
3816 2025-07-22 2990.0 ... 2025-07-22 17:50:45.340336 2025-07-22 17:50:45.340741
[4 rows x 5 columns]
2025-07-22 17:50:45,366 - IOOppi_data - INFO : save diff data to db: IOOppi_m_t: no diff data
2025-07-22 17:50:45,372 - IOOppi_data - INFO : save data to db IOOppi_m_g data:
date value
3812 2025-07-18 2966.0
3813 2025-07-19 2966.0
3814 2025-07-20 2966.0
3815 2025-07-21 2974.0
3816 2025-07-22 2990.0
2025-07-22 17:50:45,445 - IOOppi_data - INFO : save new data to db IOOppi_m_g: date value ... created_at updated_at
3816 2025-07-19 2966.0 ... 2025-07-22 17:50:45.438021 2025-07-22 17:50:45.438409
3817 2025-07-20 2966.0 ... 2025-07-22 17:50:45.438021 2025-07-22 17:50:45.438409
3818 2025-07-21 2974.0 ... 2025-07-22 17:50:45.438021 2025-07-22 17:50:45.438409
3819 2025-07-22 2990.0 ... 2025-07-22 17:50:45.438021 2025-07-22 17:50:45.438409
[4 rows x 5 columns]
2025-07-22 17:50:45,464 - 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-22 17:50:46,086 - IOOppi_data - INFO : save data to db IOOppi_y_t data:
date value
3582 2025-07-18 8414.0
3583 2025-07-19 8414.0
3584 2025-07-20 8414.0
3585 2025-07-21 8364.0
3586 2025-07-22 8334.0
2025-07-22 17:50:46,155 - IOOppi_data - INFO : save new data to db IOOppi_y_t: date value ... created_at updated_at
3583 2025-07-19 8414.0 ... 2025-07-22 17:50:46.147863 2025-07-22 17:50:46.148259
3584 2025-07-20 8414.0 ... 2025-07-22 17:50:46.147863 2025-07-22 17:50:46.148259
3585 2025-07-21 8364.0 ... 2025-07-22 17:50:46.147863 2025-07-22 17:50:46.148259
3586 2025-07-22 8334.0 ... 2025-07-22 17:50:46.147863 2025-07-22 17:50:46.148259
[4 rows x 5 columns]
2025-07-22 17:50:46,175 - IOOppi_data - INFO : save diff data to db: IOOppi_y_t: no diff data
2025-07-22 17:50:46,181 - IOOppi_data - INFO : save data to db IOOppi_y_g data:
date value
3582 2025-07-18 8414.0
3583 2025-07-19 8414.0
3584 2025-07-20 8414.0
3585 2025-07-21 8364.0
3586 2025-07-22 8334.0
2025-07-22 17:50:46,253 - IOOppi_data - INFO : save new data to db IOOppi_y_g: date value ... created_at updated_at
3586 2025-07-19 8414.0 ... 2025-07-22 17:50:46.246167 2025-07-22 17:50:46.246550
3587 2025-07-20 8414.0 ... 2025-07-22 17:50:46.246167 2025-07-22 17:50:46.246550
3588 2025-07-21 8364.0 ... 2025-07-22 17:50:46.246167 2025-07-22 17:50:46.246550
3589 2025-07-22 8334.0 ... 2025-07-22 17:50:46.246167 2025-07-22 17:50:46.246550
[4 rows x 5 columns]
2025-07-22 17:50:46,271 - 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-22 17:50:46,864 - IOOppi_data - INFO : save data to db IOOppi_a_t data:
date value
3548 2025-07-18 4295.0
3549 2025-07-19 4295.0
3550 2025-07-20 4295.0
3551 2025-07-21 4295.0
3552 2025-07-22 4295.0
2025-07-22 17:50:46,932 - IOOppi_data - INFO : save new data to db IOOppi_a_t: date value ... created_at updated_at
3549 2025-07-19 4295.0 ... 2025-07-22 17:50:46.924965 2025-07-22 17:50:46.925371
3550 2025-07-20 4295.0 ... 2025-07-22 17:50:46.924965 2025-07-22 17:50:46.925371
3551 2025-07-21 4295.0 ... 2025-07-22 17:50:46.924965 2025-07-22 17:50:46.925371
3552 2025-07-22 4295.0 ... 2025-07-22 17:50:46.924965 2025-07-22 17:50:46.925371
[4 rows x 5 columns]
2025-07-22 17:50:46,951 - IOOppi_data - INFO : save diff data to db: IOOppi_a_t: no diff data
2025-07-22 17:50:46,957 - IOOppi_data - INFO : save data to db IOOppi_a_g data:
date value
3548 2025-07-18 4295.0
3549 2025-07-19 4295.0
3550 2025-07-20 4295.0
3551 2025-07-21 4295.0
3552 2025-07-22 4295.0
2025-07-22 17:50:47,028 - IOOppi_data - INFO : save new data to db IOOppi_a_g: date value ... created_at updated_at
3552 2025-07-19 4295.0 ... 2025-07-22 17:50:47.020219 2025-07-22 17:50:47.020603
3553 2025-07-20 4295.0 ... 2025-07-22 17:50:47.020219 2025-07-22 17:50:47.020603
3554 2025-07-21 4295.0 ... 2025-07-22 17:50:47.020219 2025-07-22 17:50:47.020603
3555 2025-07-22 4295.0 ... 2025-07-22 17:50:47.020219 2025-07-22 17:50:47.020603
[4 rows x 5 columns]
2025-07-22 17:50:47,047 - 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-22 17:50:47,785 - IOOppi_data - INFO : save data to db IOOppi_SF_t data:
date value
2925 2025-07-18 5221.43
2926 2025-07-19 5221.43
2927 2025-07-20 5221.43
2928 2025-07-21 5221.43
2929 2025-07-22 5382.86
2025-07-22 17:50:47,849 - IOOppi_data - INFO : save new data to db IOOppi_SF_t: date value ... created_at updated_at
2926 2025-07-19 5221.43 ... 2025-07-22 17:50:47.841653 2025-07-22 17:50:47.842107
2927 2025-07-20 5221.43 ... 2025-07-22 17:50:47.841653 2025-07-22 17:50:47.842107
2928 2025-07-21 5221.43 ... 2025-07-22 17:50:47.841653 2025-07-22 17:50:47.842107
2929 2025-07-22 5382.86 ... 2025-07-22 17:50:47.841653 2025-07-22 17:50:47.842107
[4 rows x 5 columns]
2025-07-22 17:50:47,868 - IOOppi_data - INFO : save diff data to db: IOOppi_SF_t: no diff data
2025-07-22 17:50:47,874 - IOOppi_data - INFO : save data to db IOOppi_SF_g data:
date value
2925 2025-07-18 5221.43
2926 2025-07-19 5221.43
2927 2025-07-20 5221.43
2928 2025-07-21 5221.43
2929 2025-07-22 5382.86
2025-07-22 17:50:47,937 - IOOppi_data - INFO : save new data to db IOOppi_SF_g: date value ... created_at updated_at
2930 2025-07-19 5221.43 ... 2025-07-22 17:50:47.929714 2025-07-22 17:50:47.930147
2931 2025-07-20 5221.43 ... 2025-07-22 17:50:47.929714 2025-07-22 17:50:47.930147
2932 2025-07-21 5221.43 ... 2025-07-22 17:50:47.929714 2025-07-22 17:50:47.930147
2933 2025-07-22 5382.86 ... 2025-07-22 17:50:47.929714 2025-07-22 17:50:47.930147
[4 rows x 5 columns]
2025-07-22 17:50:47,956 - 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-22 17:50:48,591 - IOOppi_data - INFO : save data to db IOOppi_jd_t data:
date value
3125 2025-07-18 3050.0
3126 2025-07-19 3050.0
3127 2025-07-20 3050.0
3128 2025-07-21 3275.0
3129 2025-07-22 3300.0
2025-07-22 17:50:48,655 - IOOppi_data - INFO : save new data to db IOOppi_jd_t: date value ... created_at updated_at
3126 2025-07-19 3050.0 ... 2025-07-22 17:50:48.648094 2025-07-22 17:50:48.648483
3127 2025-07-20 3050.0 ... 2025-07-22 17:50:48.648094 2025-07-22 17:50:48.648483
3128 2025-07-21 3275.0 ... 2025-07-22 17:50:48.648094 2025-07-22 17:50:48.648483
3129 2025-07-22 3300.0 ... 2025-07-22 17:50:48.648094 2025-07-22 17:50:48.648483
[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-22 17:50:48,800 - IOOppi_data - INFO : save diff data to db IOOppi_jd_t: date ... updated_at
39 2014-01-03 ... 2025-07-22 17:50:48.792269
458 2015-09-21 ... 2025-07-22 17:50:48.792269
549 2016-02-03 ... 2025-07-22 17:50:48.792269
693 2016-09-05 ... 2025-07-22 17:50:48.792269
696 2016-09-08 ... 2025-07-22 17:50:48.792269
[5 rows x 6 columns]
2025-07-22 17:50:48,833 - IOOppi_data - INFO : save data to db IOOppi_jd_g data:
date value
3125 2025-07-18 3050.0
3126 2025-07-19 3050.0
3127 2025-07-20 3050.0
3128 2025-07-21 3275.0
3129 2025-07-22 3300.0
2025-07-22 17:50:48,899 - IOOppi_data - INFO : save new data to db IOOppi_jd_g: date value ... created_at updated_at
3129 2025-07-19 3050.0 ... 2025-07-22 17:50:48.891458 2025-07-22 17:50:48.891882
3130 2025-07-20 3050.0 ... 2025-07-22 17:50:48.891458 2025-07-22 17:50:48.891882
3131 2025-07-21 3275.0 ... 2025-07-22 17:50:48.891458 2025-07-22 17:50:48.891882
3132 2025-07-22 3300.0 ... 2025-07-22 17:50:48.891458 2025-07-22 17:50:48.891882
[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-22 17:50:49,047 - IOOppi_data - INFO : save diff data to db IOOppi_jd_g: date ... updated_at
39 2014-01-03 ... 2025-07-22 17:50:49.039395
458 2015-09-21 ... 2025-07-22 17:50:49.039395
549 2016-02-03 ... 2025-07-22 17:50:49.039395
693 2016-09-05 ... 2025-07-22 17:50:49.039395
696 2016-09-08 ... 2025-07-22 17:50:49.039395
[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-22 17:50:49,932 - IOOppi_data - INFO : save data to db IOOppi_SI_t data:
date value
929 2025-07-18 9500.0
930 2025-07-19 9500.0
931 2025-07-20 9500.0
932 2025-07-21 9620.0
933 2025-07-22 9840.0
2025-07-22 17:50:49,968 - IOOppi_data - INFO : save new data to db IOOppi_SI_t: date value ... created_at updated_at
930 2025-07-19 9500.0 ... 2025-07-22 17:50:49.961415 2025-07-22 17:50:49.961822
931 2025-07-20 9500.0 ... 2025-07-22 17:50:49.961415 2025-07-22 17:50:49.961822
932 2025-07-21 9620.0 ... 2025-07-22 17:50:49.961415 2025-07-22 17:50:49.961822
933 2025-07-22 9840.0 ... 2025-07-22 17:50:49.961415 2025-07-22 17:50:49.961822
[4 rows x 5 columns]
2025-07-22 17:50:49,988 - IOOppi_data - INFO : save diff data to db: IOOppi_SI_t: no diff data
2025-07-22 17:50:49,993 - IOOppi_data - INFO : save data to db IOOppi_SI_g data:
date value
929 2025-07-18 9500.0
930 2025-07-19 9500.0
931 2025-07-20 9500.0
932 2025-07-21 9620.0
933 2025-07-22 9840.0
2025-07-22 17:50:50,030 - IOOppi_data - INFO : save new data to db IOOppi_SI_g: date value ... created_at updated_at
930 2025-07-19 9500.0 ... 2025-07-22 17:50:50.022599 2025-07-22 17:50:50.023008
931 2025-07-20 9500.0 ... 2025-07-22 17:50:50.022599 2025-07-22 17:50:50.023008
932 2025-07-21 9620.0 ... 2025-07-22 17:50:50.022599 2025-07-22 17:50:50.023008
933 2025-07-22 9840.0 ... 2025-07-22 17:50:50.022599 2025-07-22 17:50:50.023008
[4 rows x 5 columns]
2025-07-22 17:50:50,049 - 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-22 17:50:50,732 - IOOppi_data - INFO : save data to db IOOppi_l_t data:
date value
3808 2025-07-18 7378.33
3809 2025-07-19 7378.33
3810 2025-07-20 7378.33
3811 2025-07-21 7383.33
3812 2025-07-22 7388.33
2025-07-22 17:50:50,806 - IOOppi_data - INFO : save new data to db IOOppi_l_t: date value ... created_at updated_at
3809 2025-07-19 7378.33 ... 2025-07-22 17:50:50.798415 2025-07-22 17:50:50.798835
3810 2025-07-20 7378.33 ... 2025-07-22 17:50:50.798415 2025-07-22 17:50:50.798835
3811 2025-07-21 7383.33 ... 2025-07-22 17:50:50.798415 2025-07-22 17:50:50.798835
3812 2025-07-22 7388.33 ... 2025-07-22 17:50:50.798415 2025-07-22 17:50:50.798835
[4 rows x 5 columns]
2025-07-22 17:50:50,824 - IOOppi_data - INFO : save diff data to db: IOOppi_l_t: no diff data
2025-07-22 17:50:50,830 - IOOppi_data - INFO : save data to db IOOppi_l_g data:
date value
3808 2025-07-18 7378.33
3809 2025-07-19 7378.33
3810 2025-07-20 7378.33
3811 2025-07-21 7383.33
3812 2025-07-22 7388.33
2025-07-22 17:50:50,902 - IOOppi_data - INFO : save new data to db IOOppi_l_g: date value ... created_at updated_at
3812 2025-07-19 7378.33 ... 2025-07-22 17:50:50.895134 2025-07-22 17:50:50.895521
3813 2025-07-20 7378.33 ... 2025-07-22 17:50:50.895134 2025-07-22 17:50:50.895521
3814 2025-07-21 7383.33 ... 2025-07-22 17:50:50.895134 2025-07-22 17:50:50.895521
3815 2025-07-22 7388.33 ... 2025-07-22 17:50:50.895134 2025-07-22 17:50:50.895521
[4 rows x 5 columns]
2025-07-22 17:50:50,920 - 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-22 17:50:51,518 - IOOppi_data - INFO : save data to db IOOppi_bu_t data:
date value
3146 2025-07-18 3710.00
3147 2025-07-19 3710.00
3148 2025-07-20 3710.00
3149 2025-07-21 3720.00
3150 2025-07-22 3723.33
2025-07-22 17:50:51,583 - IOOppi_data - INFO : save new data to db IOOppi_bu_t: date value ... created_at updated_at
3148 2025-07-19 3710.00 ... 2025-07-22 17:50:51.575785 2025-07-22 17:50:51.576188
3149 2025-07-20 3710.00 ... 2025-07-22 17:50:51.575785 2025-07-22 17:50:51.576188
3150 2025-07-21 3720.00 ... 2025-07-22 17:50:51.575785 2025-07-22 17:50:51.576188
3151 2025-07-22 3723.33 ... 2025-07-22 17:50:51.575785 2025-07-22 17:50:51.576188
[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-22 17:50:51,618 - IOOppi_data - INFO : save diff data to db IOOppi_bu_t: date ... updated_at
2560 2023-12-09 ... 2025-07-22 17:50:51.611289
[1 rows x 6 columns]
2025-07-22 17:50:51,644 - IOOppi_data - INFO : save data to db IOOppi_bu_g data:
date value
3146 2025-07-18 3710.00
3147 2025-07-19 3710.00
3148 2025-07-20 3710.00
3149 2025-07-21 3720.00
3150 2025-07-22 3723.33
2025-07-22 17:50:51,710 - IOOppi_data - INFO : save new data to db IOOppi_bu_g: date value ... created_at updated_at
3150 2025-07-19 3710.00 ... 2025-07-22 17:50:51.702233 2025-07-22 17:50:51.702624
3151 2025-07-20 3710.00 ... 2025-07-22 17:50:51.702233 2025-07-22 17:50:51.702624
3152 2025-07-21 3720.00 ... 2025-07-22 17:50:51.702233 2025-07-22 17:50:51.702624
3153 2025-07-22 3723.33 ... 2025-07-22 17:50:51.702233 2025-07-22 17:50:51.702624
[4 rows x 5 columns]
2025-07-22 17:50:51,728 - 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-22 17:50:52,452 - IOOppi_data - INFO : save data to db IOOppi_al_t data:
date value
3811 2025-07-18 20720.0
3812 2025-07-19 20720.0
3813 2025-07-20 20720.0
3814 2025-07-21 20720.0
3815 2025-07-22 20950.0
2025-07-22 17:50:52,525 - IOOppi_data - INFO : save new data to db IOOppi_al_t: date value ... created_at updated_at
3812 2025-07-19 20720.0 ... 2025-07-22 17:50:52.518110 2025-07-22 17:50:52.518505
3813 2025-07-20 20720.0 ... 2025-07-22 17:50:52.518110 2025-07-22 17:50:52.518505
3814 2025-07-21 20720.0 ... 2025-07-22 17:50:52.518110 2025-07-22 17:50:52.518505
3815 2025-07-22 20950.0 ... 2025-07-22 17:50:52.518110 2025-07-22 17:50:52.518505
[4 rows x 5 columns]
2025-07-22 17:50:52,544 - IOOppi_data - INFO : save diff data to db: IOOppi_al_t: no diff data
2025-07-22 17:50:52,550 - IOOppi_data - INFO : save data to db IOOppi_al_g data:
date value
3811 2025-07-18 20720.0
3812 2025-07-19 20720.0
3813 2025-07-20 20720.0
3814 2025-07-21 20720.0
3815 2025-07-22 20950.0
2025-07-22 17:50:52,623 - IOOppi_data - INFO : save new data to db IOOppi_al_g: date value ... created_at updated_at
3815 2025-07-19 20720.0 ... 2025-07-22 17:50:52.616428 2025-07-22 17:50:52.616834
3816 2025-07-20 20720.0 ... 2025-07-22 17:50:52.616428 2025-07-22 17:50:52.616834
3817 2025-07-21 20720.0 ... 2025-07-22 17:50:52.616428 2025-07-22 17:50:52.616834
3818 2025-07-22 20950.0 ... 2025-07-22 17:50:52.616428 2025-07-22 17:50:52.616834
[4 rows x 5 columns]
2025-07-22 17:50:52,642 - 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-22 17:50:53,291 - IOOppi_data - INFO : save data to db IOOppi_SM_t data:
date value
2925 2025-07-18 5652.0
2926 2025-07-19 5652.0
2927 2025-07-20 5652.0
2928 2025-07-21 5692.0
2929 2025-07-22 5726.0
2025-07-22 17:50:53,352 - IOOppi_data - INFO : save new data to db IOOppi_SM_t: date value ... created_at updated_at
2926 2025-07-19 5652.0 ... 2025-07-22 17:50:53.345234 2025-07-22 17:50:53.345627
2927 2025-07-20 5652.0 ... 2025-07-22 17:50:53.345234 2025-07-22 17:50:53.345627
2928 2025-07-21 5692.0 ... 2025-07-22 17:50:53.345234 2025-07-22 17:50:53.345627
2929 2025-07-22 5726.0 ... 2025-07-22 17:50:53.345234 2025-07-22 17:50:53.345627
[4 rows x 5 columns]
2025-07-22 17:50:53,371 - IOOppi_data - INFO : save diff data to db: IOOppi_SM_t: no diff data
2025-07-22 17:50:53,380 - IOOppi_data - INFO : save data to db IOOppi_SM_g data:
date value
2925 2025-07-18 5652.0
2926 2025-07-19 5652.0
2927 2025-07-20 5652.0
2928 2025-07-21 5692.0
2929 2025-07-22 5726.0
2025-07-22 17:50:53,445 - IOOppi_data - INFO : save new data to db IOOppi_SM_g: date value ... created_at updated_at
2930 2025-07-19 5652.0 ... 2025-07-22 17:50:53.437871 2025-07-22 17:50:53.438265
2931 2025-07-20 5652.0 ... 2025-07-22 17:50:53.437871 2025-07-22 17:50:53.438265
2932 2025-07-21 5692.0 ... 2025-07-22 17:50:53.437871 2025-07-22 17:50:53.438265
2933 2025-07-22 5726.0 ... 2025-07-22 17:50:53.437871 2025-07-22 17:50:53.438265
[4 rows x 5 columns]
2025-07-22 17:50:53,463 - 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-22 17:50:54,199 - IOOppi_data - INFO : save data to db IOOppi_CY_t data:
date value
2200 2025-07-18 23275.0
2201 2025-07-19 23275.0
2202 2025-07-20 23275.0
2203 2025-07-21 23275.0
2204 2025-07-22 23450.0
2025-07-22 17:50:54,252 - IOOppi_data - INFO : save new data to db IOOppi_CY_t: date value ... created_at updated_at
2201 2025-07-19 23275.0 ... 2025-07-22 17:50:54.244984 2025-07-22 17:50:54.245383
2202 2025-07-20 23275.0 ... 2025-07-22 17:50:54.244984 2025-07-22 17:50:54.245383
2203 2025-07-21 23275.0 ... 2025-07-22 17:50:54.244984 2025-07-22 17:50:54.245383
2204 2025-07-22 23450.0 ... 2025-07-22 17:50:54.244984 2025-07-22 17:50:54.245383
[4 rows x 5 columns]
2025-07-22 17:50:54,270 - IOOppi_data - INFO : save diff data to db: IOOppi_CY_t: no diff data
2025-07-22 17:50:54,276 - IOOppi_data - INFO : save data to db IOOppi_CY_g data:
date value
2200 2025-07-18 23275.0
2201 2025-07-19 23275.0
2202 2025-07-20 23275.0
2203 2025-07-21 23275.0
2204 2025-07-22 23450.0
2025-07-22 17:50:54,329 - IOOppi_data - INFO : save new data to db IOOppi_CY_g: date value ... created_at updated_at
2205 2025-07-19 23275.0 ... 2025-07-22 17:50:54.321986 2025-07-22 17:50:54.322389
2206 2025-07-20 23275.0 ... 2025-07-22 17:50:54.321986 2025-07-22 17:50:54.322389
2207 2025-07-21 23275.0 ... 2025-07-22 17:50:54.321986 2025-07-22 17:50:54.322389
2208 2025-07-22 23450.0 ... 2025-07-22 17:50:54.321986 2025-07-22 17:50:54.322389
[4 rows x 5 columns]
2025-07-22 17:50:54,348 - 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-22 17:50:54,991 - IOOppi_data - INFO : save data to db IOOppi_UR_t data:
date value
1715 2025-07-18 1830.0
1716 2025-07-19 1830.0
1717 2025-07-20 1830.0
1718 2025-07-21 1830.0
1719 2025-07-22 1830.0
2025-07-22 17:50:55,039 - IOOppi_data - INFO : save new data to db IOOppi_UR_t: date value ... created_at updated_at
1716 2025-07-19 1830.0 ... 2025-07-22 17:50:55.031713 2025-07-22 17:50:55.032126
1717 2025-07-20 1830.0 ... 2025-07-22 17:50:55.031713 2025-07-22 17:50:55.032126
1718 2025-07-21 1830.0 ... 2025-07-22 17:50:55.031713 2025-07-22 17:50:55.032126
1719 2025-07-22 1830.0 ... 2025-07-22 17:50:55.031713 2025-07-22 17:50:55.032126
[4 rows x 5 columns]
2025-07-22 17:50:55,057 - IOOppi_data - INFO : save diff data to db: IOOppi_UR_t: no diff data
2025-07-22 17:50:55,062 - IOOppi_data - INFO : save data to db IOOppi_UR_g data:
date value
1715 2025-07-18 1830.0
1716 2025-07-19 1830.0
1717 2025-07-20 1830.0
1718 2025-07-21 1830.0
1719 2025-07-22 1830.0
2025-07-22 17:50:55,108 - IOOppi_data - INFO : save new data to db IOOppi_UR_g: date value ... created_at updated_at
1720 2025-07-19 1830.0 ... 2025-07-22 17:50:55.101328 2025-07-22 17:50:55.101702
1721 2025-07-20 1830.0 ... 2025-07-22 17:50:55.101328 2025-07-22 17:50:55.101702
1722 2025-07-21 1830.0 ... 2025-07-22 17:50:55.101328 2025-07-22 17:50:55.101702
1723 2025-07-22 1830.0 ... 2025-07-22 17:50:55.101328 2025-07-22 17:50:55.101702
[4 rows x 5 columns]
2025-07-22 17:50:55,127 - 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-22 17:50:55,776 - IOOppi_data - INFO : save data to db IOOppi_ni_t data:
date value
2787 2025-07-18 121800.00
2788 2025-07-19 121800.00
2789 2025-07-20 121800.00
2790 2025-07-21 123350.00
2791 2025-07-22 123783.33
2025-07-22 17:50:55,835 - IOOppi_data - INFO : save new data to db IOOppi_ni_t: date ... updated_at
2788 2025-07-19 ... 2025-07-22 17:50:55.829326
2789 2025-07-20 ... 2025-07-22 17:50:55.829326
2790 2025-07-21 ... 2025-07-22 17:50:55.829326
2791 2025-07-22 ... 2025-07-22 17:50:55.829326
[4 rows x 5 columns]
2025-07-22 17:50:55,855 - IOOppi_data - INFO : save diff data to db: IOOppi_ni_t: no diff data
2025-07-22 17:50:55,860 - IOOppi_data - INFO : save data to db IOOppi_ni_g data:
date value
2787 2025-07-18 121800.00
2788 2025-07-19 121800.00
2789 2025-07-20 121800.00
2790 2025-07-21 123350.00
2791 2025-07-22 123783.33
2025-07-22 17:50:55,919 - IOOppi_data - INFO : save new data to db IOOppi_ni_g: date ... updated_at
2791 2025-07-19 ... 2025-07-22 17:50:55.912927
2792 2025-07-20 ... 2025-07-22 17:50:55.912927
2793 2025-07-21 ... 2025-07-22 17:50:55.912927
2794 2025-07-22 ... 2025-07-22 17:50:55.912927
[4 rows x 5 columns]
2025-07-22 17:50:55,937 - 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-22 17:50:56,572 - IOOppi_data - INFO : save data to db IOOppi_v_t data:
date value
3812 2025-07-18 4712.0
3813 2025-07-19 4712.0
3814 2025-07-20 4712.0
3815 2025-07-21 4837.0
3816 2025-07-22 4911.0
2025-07-22 17:50:56,644 - IOOppi_data - INFO : save new data to db IOOppi_v_t: date value ... created_at updated_at
3813 2025-07-19 4712.0 ... 2025-07-22 17:50:56.636777 2025-07-22 17:50:56.637189
3814 2025-07-20 4712.0 ... 2025-07-22 17:50:56.636777 2025-07-22 17:50:56.637189
3815 2025-07-21 4837.0 ... 2025-07-22 17:50:56.636777 2025-07-22 17:50:56.637189
3816 2025-07-22 4911.0 ... 2025-07-22 17:50:56.636777 2025-07-22 17:50:56.637189
[4 rows x 5 columns]
2025-07-22 17:50:56,662 - IOOppi_data - INFO : save diff data to db: IOOppi_v_t: no diff data
2025-07-22 17:50:56,668 - IOOppi_data - INFO : save data to db IOOppi_v_g data:
date value
3812 2025-07-18 4712.0
3813 2025-07-19 4712.0
3814 2025-07-20 4712.0
3815 2025-07-21 4837.0
3816 2025-07-22 4911.0
2025-07-22 17:50:56,740 - IOOppi_data - INFO : save new data to db IOOppi_v_g: date value ... created_at updated_at
3816 2025-07-19 4712.0 ... 2025-07-22 17:50:56.733448 2025-07-22 17:50:56.733854
3817 2025-07-20 4712.0 ... 2025-07-22 17:50:56.733448 2025-07-22 17:50:56.733854
3818 2025-07-21 4837.0 ... 2025-07-22 17:50:56.733448 2025-07-22 17:50:56.733854
3819 2025-07-22 4911.0 ... 2025-07-22 17:50:56.733448 2025-07-22 17:50:56.733854
[4 rows x 5 columns]
2025-07-22 17:50:56,758 - 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-22 17:50:57,461 - IOOppi_data - INFO : save data to db IOOppi_pp_t data:
date value
3051 2025-07-18 7313.33
3052 2025-07-19 7313.33
3053 2025-07-20 7313.33
3054 2025-07-21 7313.33
3055 2025-07-22 7291.67
2025-07-22 17:50:57,525 - IOOppi_data - INFO : save new data to db IOOppi_pp_t: date value ... created_at updated_at
3052 2025-07-19 7313.33 ... 2025-07-22 17:50:57.517481 2025-07-22 17:50:57.517901
3053 2025-07-20 7313.33 ... 2025-07-22 17:50:57.517481 2025-07-22 17:50:57.517901
3054 2025-07-21 7313.33 ... 2025-07-22 17:50:57.517481 2025-07-22 17:50:57.517901
3055 2025-07-22 7291.67 ... 2025-07-22 17:50:57.517481 2025-07-22 17:50:57.517901
[4 rows x 5 columns]
2025-07-22 17:50:57,543 - IOOppi_data - INFO : save diff data to db: IOOppi_pp_t: no diff data
2025-07-22 17:50:57,550 - IOOppi_data - INFO : save data to db IOOppi_pp_g data:
date value
3051 2025-07-18 7313.33
3052 2025-07-19 7313.33
3053 2025-07-20 7313.33
3054 2025-07-21 7313.33
3055 2025-07-22 7291.67
2025-07-22 17:50:57,614 - IOOppi_data - INFO : save new data to db IOOppi_pp_g: date value ... created_at updated_at
3055 2025-07-19 7313.33 ... 2025-07-22 17:50:57.607157 2025-07-22 17:50:57.607544
3056 2025-07-20 7313.33 ... 2025-07-22 17:50:57.607157 2025-07-22 17:50:57.607544
3057 2025-07-21 7313.33 ... 2025-07-22 17:50:57.607157 2025-07-22 17:50:57.607544
3058 2025-07-22 7291.67 ... 2025-07-22 17:50:57.607157 2025-07-22 17:50:57.607544
[4 rows x 5 columns]
2025-07-22 17:50:57,634 - 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-22 17:50:58,309 - IOOppi_data - INFO : save data to db IOOppi_CF_t data:
date value
3813 2025-07-18 15522.67
3814 2025-07-19 15522.67
3815 2025-07-20 15522.67
3816 2025-07-21 15596.33
3817 2025-07-22 15549.00
2025-07-22 17:50:58,380 - IOOppi_data - INFO : save new data to db IOOppi_CF_t: date ... updated_at
3814 2025-07-19 ... 2025-07-22 17:50:58.373646
3815 2025-07-20 ... 2025-07-22 17:50:58.373646
3816 2025-07-21 ... 2025-07-22 17:50:58.373646
3817 2025-07-22 ... 2025-07-22 17:50:58.373646
[4 rows x 5 columns]
2025-07-22 17:50:58,399 - IOOppi_data - INFO : save diff data to db: IOOppi_CF_t: no diff data
2025-07-22 17:50:58,405 - IOOppi_data - INFO : save data to db IOOppi_CF_g data:
date value
3813 2025-07-18 15522.67
3814 2025-07-19 15522.67
3815 2025-07-20 15522.67
3816 2025-07-21 15596.33
3817 2025-07-22 15549.00
2025-07-22 17:50:58,476 - IOOppi_data - INFO : save new data to db IOOppi_CF_g: date ... updated_at
3818 2025-07-19 ... 2025-07-22 17:50:58.470391
3819 2025-07-20 ... 2025-07-22 17:50:58.470391
3820 2025-07-21 ... 2025-07-22 17:50:58.470391
3821 2025-07-22 ... 2025-07-22 17:50:58.470391
[4 rows x 5 columns]
2025-07-22 17:50:58,495 - 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-22 17:50:59,077 - IOOppi_data - INFO : save data to db IOOppi_pb_t data:
date value
3758 2025-07-18 16756.25
3759 2025-07-19 16756.25
3760 2025-07-20 16756.25
3761 2025-07-21 16862.50
3762 2025-07-22 16806.25
2025-07-22 17:50:59,147 - IOOppi_data - INFO : save new data to db IOOppi_pb_t: date ... updated_at
3759 2025-07-19 ... 2025-07-22 17:50:59.141204
3760 2025-07-20 ... 2025-07-22 17:50:59.141204
3761 2025-07-21 ... 2025-07-22 17:50:59.141204
3762 2025-07-22 ... 2025-07-22 17:50:59.141204
[4 rows x 5 columns]
2025-07-22 17:50:59,165 - IOOppi_data - INFO : save diff data to db: IOOppi_pb_t: no diff data
2025-07-22 17:50:59,172 - IOOppi_data - INFO : save data to db IOOppi_pb_g data:
date value
3758 2025-07-18 16756.25
3759 2025-07-19 16756.25
3760 2025-07-20 16756.25
3761 2025-07-21 16862.50
3762 2025-07-22 16806.25
2025-07-22 17:50:59,318 - IOOppi_data - INFO : save new data to db IOOppi_pb_g: date ... updated_at
3762 2025-07-19 ... 2025-07-22 17:50:59.311902
3763 2025-07-20 ... 2025-07-22 17:50:59.311902
3764 2025-07-21 ... 2025-07-22 17:50:59.311902
3765 2025-07-22 ... 2025-07-22 17:50:59.311902
[4 rows x 5 columns]
2025-07-22 17:50:59,337 - 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-22 17:50:59,945 - IOOppi_data - INFO : save data to db IOOppi_hc_t data:
date value
3033 2025-07-18 3380.00
3034 2025-07-19 3380.00
3035 2025-07-20 3380.00
3036 2025-07-21 3406.67
3037 2025-07-22 3446.67
2025-07-22 17:51:00,008 - IOOppi_data - INFO : save new data to db IOOppi_hc_t: date value ... created_at updated_at
3034 2025-07-19 3380.00 ... 2025-07-22 17:51:00.000442 2025-07-22 17:51:00.000881
3035 2025-07-20 3380.00 ... 2025-07-22 17:51:00.000442 2025-07-22 17:51:00.000881
3036 2025-07-21 3406.67 ... 2025-07-22 17:51:00.000442 2025-07-22 17:51:00.000881
3037 2025-07-22 3446.67 ... 2025-07-22 17:51:00.000442 2025-07-22 17:51:00.000881
[4 rows x 5 columns]
2025-07-22 17:51:00,026 - IOOppi_data - INFO : save diff data to db: IOOppi_hc_t: no diff data
2025-07-22 17:51:00,033 - IOOppi_data - INFO : save data to db IOOppi_hc_g data:
date value
3033 2025-07-18 3380.00
3034 2025-07-19 3380.00
3035 2025-07-20 3380.00
3036 2025-07-21 3406.67
3037 2025-07-22 3446.67
2025-07-22 17:51:00,095 - IOOppi_data - INFO : save new data to db IOOppi_hc_g: date value ... created_at updated_at
3037 2025-07-19 3380.00 ... 2025-07-22 17:51:00.088355 2025-07-22 17:51:00.088734
3038 2025-07-20 3380.00 ... 2025-07-22 17:51:00.088355 2025-07-22 17:51:00.088734
3039 2025-07-21 3406.67 ... 2025-07-22 17:51:00.088355 2025-07-22 17:51:00.088734
3040 2025-07-22 3446.67 ... 2025-07-22 17:51:00.088355 2025-07-22 17:51:00.088734
[4 rows x 5 columns]
2025-07-22 17:51:00,114 - 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-22 17:51:00,709 - IOOppi_data - INFO : save data to db IOOppi_fu_t data:
date value
3313 2025-07-18 5325.0
3314 2025-07-19 5325.0
3315 2025-07-20 5325.0
3316 2025-07-21 5312.5
3317 2025-07-22 5312.5
2025-07-22 17:51:00,775 - IOOppi_data - INFO : save new data to db IOOppi_fu_t: date value ... created_at updated_at
3314 2025-07-19 5325.0 ... 2025-07-22 17:51:00.768004 2025-07-22 17:51:00.768386
3315 2025-07-20 5325.0 ... 2025-07-22 17:51:00.768004 2025-07-22 17:51:00.768386
3316 2025-07-21 5312.5 ... 2025-07-22 17:51:00.768004 2025-07-22 17:51:00.768386
3317 2025-07-22 5312.5 ... 2025-07-22 17:51:00.768004 2025-07-22 17:51:00.768386
[4 rows x 5 columns]
2025-07-22 17:51:00,794 - IOOppi_data - INFO : save diff data to db: IOOppi_fu_t: no diff data
2025-07-22 17:51:00,803 - IOOppi_data - INFO : save data to db IOOppi_fu_g data:
date value
3313 2025-07-18 5325.0
3314 2025-07-19 5325.0
3315 2025-07-20 5325.0
3316 2025-07-21 5312.5
3317 2025-07-22 5312.5
2025-07-22 17:51:00,878 - IOOppi_data - INFO : save new data to db IOOppi_fu_g: date value ... created_at updated_at
3801 2025-07-19 5325.0 ... 2025-07-22 17:51:00.870225 2025-07-22 17:51:00.870835
3802 2025-07-20 5325.0 ... 2025-07-22 17:51:00.870225 2025-07-22 17:51:00.870835
3803 2025-07-21 5312.5 ... 2025-07-22 17:51:00.870225 2025-07-22 17:51:00.870835
3804 2025-07-22 5312.5 ... 2025-07-22 17:51:00.870225 2025-07-22 17:51:00.870835
[4 rows x 5 columns]
2025-07-22 17:51:00,897 - 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-22 17:51:02,112 - IOOppi_data - INFO : save data to db IOOppi_lh_t data:
date value
1377 2025-07-18 14500.0
1378 2025-07-19 14500.0
1379 2025-07-20 14500.0
1380 2025-07-21 14480.0
1381 2025-07-22 14450.0
2025-07-22 17:51:02,155 - IOOppi_data - INFO : save new data to db IOOppi_lh_t: date value ... created_at updated_at
1378 2025-07-19 14500.0 ... 2025-07-22 17:51:02.147914 2025-07-22 17:51:02.148327
1379 2025-07-20 14500.0 ... 2025-07-22 17:51:02.147914 2025-07-22 17:51:02.148327
1380 2025-07-21 14480.0 ... 2025-07-22 17:51:02.147914 2025-07-22 17:51:02.148327
1381 2025-07-22 14450.0 ... 2025-07-22 17:51:02.147914 2025-07-22 17:51:02.148327
[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-22 17:51:02,399 - IOOppi_data - INFO : save diff data to db IOOppi_lh_t: date ... updated_at
116 2021-07-05 ... 2025-07-22 17:51:02.391307
117 2021-07-06 ... 2025-07-22 17:51:02.391307
121 2021-07-12 ... 2025-07-22 17:51:02.391307
122 2021-07-13 ... 2025-07-22 17:51:02.391307
194 2021-11-01 ... 2025-07-22 17:51:02.391307
[5 rows x 6 columns]
2025-07-22 17:51:02,438 - IOOppi_data - INFO : save data to db IOOppi_lh_g data:
date value
1377 2025-07-18 14500.0
1378 2025-07-19 14500.0
1379 2025-07-20 14500.0
1380 2025-07-21 14480.0
1381 2025-07-22 14450.0
2025-07-22 17:51:02,483 - IOOppi_data - INFO : save new data to db IOOppi_lh_g: date value ... created_at updated_at
1381 2025-07-19 14500.0 ... 2025-07-22 17:51:02.476256 2025-07-22 17:51:02.476689
1382 2025-07-20 14500.0 ... 2025-07-22 17:51:02.476256 2025-07-22 17:51:02.476689
1383 2025-07-21 14480.0 ... 2025-07-22 17:51:02.476256 2025-07-22 17:51:02.476689
1384 2025-07-22 14450.0 ... 2025-07-22 17:51:02.476256 2025-07-22 17:51:02.476689
[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-22 17:51:02,724 - IOOppi_data - INFO : save diff data to db IOOppi_lh_g: date ... updated_at
116 2021-07-05 ... 2025-07-22 17:51:02.716502
117 2021-07-06 ... 2025-07-22 17:51:02.716502
121 2021-07-12 ... 2025-07-22 17:51:02.716502
122 2021-07-13 ... 2025-07-22 17:51:02.716502
194 2021-11-01 ... 2025-07-22 17:51:02.716502
[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-22 17:51:03,465 - IOOppi_data - INFO : save data to db IOOppi_cu_t data:
date value
3809 2025-07-18 78678.33
3810 2025-07-19 78678.33
3811 2025-07-20 78678.33
3812 2025-07-21 79651.67
3813 2025-07-22 79766.67
2025-07-22 17:51:03,537 - IOOppi_data - INFO : save new data to db IOOppi_cu_t: date ... updated_at
3810 2025-07-19 ... 2025-07-22 17:51:03.530445
3811 2025-07-20 ... 2025-07-22 17:51:03.530445
3812 2025-07-21 ... 2025-07-22 17:51:03.530445
3813 2025-07-22 ... 2025-07-22 17:51:03.530445
[4 rows x 5 columns]
2025-07-22 17:51:03,555 - IOOppi_data - INFO : save diff data to db: IOOppi_cu_t: no diff data
2025-07-22 17:51:03,561 - IOOppi_data - INFO : save data to db IOOppi_cu_g data:
date value
3809 2025-07-18 78678.33
3810 2025-07-19 78678.33
3811 2025-07-20 78678.33
3812 2025-07-21 79651.67
3813 2025-07-22 79766.67
2025-07-22 17:51:03,633 - IOOppi_data - INFO : save new data to db IOOppi_cu_g: date ... updated_at
3813 2025-07-19 ... 2025-07-22 17:51:03.627383
3814 2025-07-20 ... 2025-07-22 17:51:03.627383
3815 2025-07-21 ... 2025-07-22 17:51:03.627383
3816 2025-07-22 ... 2025-07-22 17:51:03.627383
[4 rows x 5 columns]
2025-07-22 17:51:03,652 - 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-22 17:51:04,240 - 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-22 17:51:04,293 - IOOppi_data - INFO : save new data to db: IOOppi_PM_t: no new data
2025-07-22 17:51:04,293 - IOOppi_data - INFO : save diff data to db: IOOppi_PM_t: no diff data
2025-07-22 17:51:04,299 - 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-22 17:51:04,358 - IOOppi_data - INFO : save new data to db: IOOppi_PM_g: no new data
2025-07-22 17:51:04,358 - 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-22 17:51:05,190 - IOOppi_data - INFO : save data to db IOOppi_sn_t data:
date value
2787 2025-07-18 265575.0
2788 2025-07-19 265575.0
2789 2025-07-20 265575.0
2790 2025-07-21 267362.5
2791 2025-07-22 266600.0
2025-07-22 17:51:05,249 - IOOppi_data - INFO : save new data to db IOOppi_sn_t: date ... updated_at
2788 2025-07-19 ... 2025-07-22 17:51:05.242824
2789 2025-07-20 ... 2025-07-22 17:51:05.242824
2790 2025-07-21 ... 2025-07-22 17:51:05.242824
2791 2025-07-22 ... 2025-07-22 17:51:05.242824
[4 rows x 5 columns]
2025-07-22 17:51:05,268 - IOOppi_data - INFO : save diff data to db: IOOppi_sn_t: no diff data
2025-07-22 17:51:05,274 - IOOppi_data - INFO : save data to db IOOppi_sn_g data:
date value
2787 2025-07-18 265575.0
2788 2025-07-19 265575.0
2789 2025-07-20 265575.0
2790 2025-07-21 267362.5
2791 2025-07-22 266600.0
2025-07-22 17:51:05,332 - IOOppi_data - INFO : save new data to db IOOppi_sn_g: date ... updated_at
2791 2025-07-19 ... 2025-07-22 17:51:05.326352
2792 2025-07-20 ... 2025-07-22 17:51:05.326352
2793 2025-07-21 ... 2025-07-22 17:51:05.326352
2794 2025-07-22 ... 2025-07-22 17:51:05.326352
[4 rows x 5 columns]
2025-07-22 17:51:05,350 - 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-22 17:51:06,168 - IOOppi_data - INFO : save data to db IOOppi_zn_t data:
date value
3808 2025-07-18 22306.0
3809 2025-07-19 22306.0
3810 2025-07-20 22306.0
3811 2025-07-21 22814.0
3812 2025-07-22 22770.0
2025-07-22 17:51:06,240 - IOOppi_data - INFO : save new data to db IOOppi_zn_t: date value ... created_at updated_at
3809 2025-07-19 22306.0 ... 2025-07-22 17:51:06.233338 2025-07-22 17:51:06.233724
3810 2025-07-20 22306.0 ... 2025-07-22 17:51:06.233338 2025-07-22 17:51:06.233724
3811 2025-07-21 22814.0 ... 2025-07-22 17:51:06.233338 2025-07-22 17:51:06.233724
3812 2025-07-22 22770.0 ... 2025-07-22 17:51:06.233338 2025-07-22 17:51:06.233724
[4 rows x 5 columns]
2025-07-22 17:51:06,259 - IOOppi_data - INFO : save diff data to db: IOOppi_zn_t: no diff data
2025-07-22 17:51:06,265 - IOOppi_data - INFO : save data to db IOOppi_zn_g data:
date value
3808 2025-07-18 22306.0
3809 2025-07-19 22306.0
3810 2025-07-20 22306.0
3811 2025-07-21 22814.0
3812 2025-07-22 22770.0
2025-07-22 17:51:06,338 - IOOppi_data - INFO : save new data to db IOOppi_zn_g: date value ... created_at updated_at
3812 2025-07-19 22306.0 ... 2025-07-22 17:51:06.331099 2025-07-22 17:51:06.331482
3813 2025-07-20 22306.0 ... 2025-07-22 17:51:06.331099 2025-07-22 17:51:06.331482
3814 2025-07-21 22814.0 ... 2025-07-22 17:51:06.331099 2025-07-22 17:51:06.331482
3815 2025-07-22 22770.0 ... 2025-07-22 17:51:06.331099 2025-07-22 17:51:06.331482
[4 rows x 5 columns]
2025-07-22 17:51:06,357 - 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-22 17:51:07,077 - IOOppi_data - INFO : save data to db IOOppi_wr_t data:
date value
3771 2025-07-18 3372.5
3772 2025-07-19 3372.5
3773 2025-07-20 3372.5
3774 2025-07-21 3372.5
3775 2025-07-22 3497.5
2025-07-22 17:51:07,150 - IOOppi_data - INFO : save new data to db IOOppi_wr_t: date value ... created_at updated_at
3772 2025-07-19 3372.5 ... 2025-07-22 17:51:07.142625 2025-07-22 17:51:07.143049
3773 2025-07-20 3372.5 ... 2025-07-22 17:51:07.142625 2025-07-22 17:51:07.143049
3774 2025-07-21 3372.5 ... 2025-07-22 17:51:07.142625 2025-07-22 17:51:07.143049
3775 2025-07-22 3497.5 ... 2025-07-22 17:51:07.142625 2025-07-22 17:51:07.143049
[4 rows x 5 columns]
2025-07-22 17:51:07,172 - IOOppi_data - INFO : save diff data to db: IOOppi_wr_t: no diff data
2025-07-22 17:51:07,178 - IOOppi_data - INFO : save data to db IOOppi_wr_g data:
date value
3771 2025-07-18 3372.5
3772 2025-07-19 3372.5
3773 2025-07-20 3372.5
3774 2025-07-21 3372.5
3775 2025-07-22 3497.5
2025-07-22 17:51:07,250 - IOOppi_data - INFO : save new data to db IOOppi_wr_g: date value ... created_at updated_at
3775 2025-07-19 3372.5 ... 2025-07-22 17:51:07.243483 2025-07-22 17:51:07.243893
3776 2025-07-20 3372.5 ... 2025-07-22 17:51:07.243483 2025-07-22 17:51:07.243893
3777 2025-07-21 3372.5 ... 2025-07-22 17:51:07.243483 2025-07-22 17:51:07.243893
3778 2025-07-22 3497.5 ... 2025-07-22 17:51:07.243483 2025-07-22 17:51:07.243893
[4 rows x 5 columns]
2025-07-22 17:51:07,268 - 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-22 17:51:07,898 - IOOppi_data - INFO : save data to db IOOppi_pg_t data:
date value
1568 2025-07-18 4757.5
1569 2025-07-19 4757.5
1570 2025-07-20 4757.5
1571 2025-07-21 4807.5
1572 2025-07-22 4782.5
2025-07-22 17:51:07,943 - IOOppi_data - INFO : save new data to db IOOppi_pg_t: date value ... created_at updated_at
1569 2025-07-19 4757.5 ... 2025-07-22 17:51:07.935614 2025-07-22 17:51:07.936066
1570 2025-07-20 4757.5 ... 2025-07-22 17:51:07.935614 2025-07-22 17:51:07.936066
1571 2025-07-21 4807.5 ... 2025-07-22 17:51:07.935614 2025-07-22 17:51:07.936066
1572 2025-07-22 4782.5 ... 2025-07-22 17:51:07.935614 2025-07-22 17:51:07.936066
[4 rows x 5 columns]
2025-07-22 17:51:07,962 - IOOppi_data - INFO : save diff data to db: IOOppi_pg_t: no diff data
2025-07-22 17:51:07,968 - IOOppi_data - INFO : save data to db IOOppi_pg_g data:
date value
1568 2025-07-18 4757.5
1569 2025-07-19 4757.5
1570 2025-07-20 4757.5
1571 2025-07-21 4807.5
1572 2025-07-22 4782.5
2025-07-22 17:51:08,012 - IOOppi_data - INFO : save new data to db IOOppi_pg_g: date value ... created_at updated_at
1572 2025-07-19 4757.5 ... 2025-07-22 17:51:08.005342 2025-07-22 17:51:08.005721
1573 2025-07-20 4757.5 ... 2025-07-22 17:51:08.005342 2025-07-22 17:51:08.005721
1574 2025-07-21 4807.5 ... 2025-07-22 17:51:08.005342 2025-07-22 17:51:08.005721
1575 2025-07-22 4782.5 ... 2025-07-22 17:51:08.005342 2025-07-22 17:51:08.005721
[4 rows x 5 columns]
2025-07-22 17:51:08,031 - 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-22 17:51:08,663 - IOOppi_data - INFO : save data to db IOOppi_cs_t data:
date value
2842 2025-07-18 2330.00
2843 2025-07-19 2330.00
2844 2025-07-20 2330.00
2845 2025-07-21 2332.86
2846 2025-07-22 2338.57
2025-07-22 17:51:08,722 - IOOppi_data - INFO : save new data to db IOOppi_cs_t: date value ... created_at updated_at
2843 2025-07-19 2330.00 ... 2025-07-22 17:51:08.715451 2025-07-22 17:51:08.715854
2844 2025-07-20 2330.00 ... 2025-07-22 17:51:08.715451 2025-07-22 17:51:08.715854
2845 2025-07-21 2332.86 ... 2025-07-22 17:51:08.715451 2025-07-22 17:51:08.715854
2846 2025-07-22 2338.57 ... 2025-07-22 17:51:08.715451 2025-07-22 17:51:08.715854
[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-22 17:51:08,762 - IOOppi_data - INFO : save diff data to db IOOppi_cs_t: date ... updated_at
2842 2025-07-18 ... 2025-07-22 17:51:08.755084
[1 rows x 6 columns]
2025-07-22 17:51:08,786 - IOOppi_data - INFO : save data to db IOOppi_cs_g data:
date value
2842 2025-07-18 2330.00
2843 2025-07-19 2330.00
2844 2025-07-20 2330.00
2845 2025-07-21 2332.86
2846 2025-07-22 2338.57
2025-07-22 17:51:08,849 - IOOppi_data - INFO : save new data to db IOOppi_cs_g: date value ... created_at updated_at
2846 2025-07-19 2330.00 ... 2025-07-22 17:51:08.841188 2025-07-22 17:51:08.841577
2847 2025-07-20 2330.00 ... 2025-07-22 17:51:08.841188 2025-07-22 17:51:08.841577
2848 2025-07-21 2332.86 ... 2025-07-22 17:51:08.841188 2025-07-22 17:51:08.841577
2849 2025-07-22 2338.57 ... 2025-07-22 17:51:08.841188 2025-07-22 17:51:08.841577
[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-22 17:51:08,890 - IOOppi_data - INFO : save diff data to db IOOppi_cs_g: date ... updated_at
2845 2025-07-18 ... 2025-07-22 17:51:08.882342
[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-22 17:51:09,462 - IOOppi_data - INFO : save data to db IOOppi_cs_t data:
date value
2842 2025-07-18 2330.00
2843 2025-07-19 2330.00
2844 2025-07-20 2330.00
2845 2025-07-21 2332.86
2846 2025-07-22 2926.00
2025-07-22 17:51:09,513 - 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-22 17:51:09,535 - IOOppi_data - INFO : save diff data to db IOOppi_cs_t: date ... updated_at
2846 2025-07-22 ... 2025-07-22 17:51:09.528324
[1 rows x 6 columns]
2025-07-22 17:51:09,559 - IOOppi_data - INFO : save data to db IOOppi_cs_g data:
date value
2842 2025-07-18 2330.00
2843 2025-07-19 2330.00
2844 2025-07-20 2330.00
2845 2025-07-21 2332.86
2846 2025-07-22 2926.00
2025-07-22 17:51:09,613 - 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-22 17:51:09,635 - IOOppi_data - INFO : save diff data to db IOOppi_cs_g: date ... updated_at
2849 2025-07-22 ... 2025-07-22 17:51:09.628209
[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-22 17:51:10,159 - IOOppi_data - INFO : save data to db IOOppi_RS_t data:
date value
3199 2025-07-18 9691.67
3200 2025-07-19 9691.67
3201 2025-07-20 9691.67
3202 2025-07-21 9681.67
3203 2025-07-22 9586.67
2025-07-22 17:51:10,215 - IOOppi_data - INFO : save new data to db: IOOppi_RS_t: no new data
2025-07-22 17:51:10,215 - IOOppi_data - INFO : save diff data to db: IOOppi_RS_t: no diff data
2025-07-22 17:51:10,220 - IOOppi_data - INFO : save data to db IOOppi_RS_g data:
date value
3199 2025-07-18 9691.67
3200 2025-07-19 9691.67
3201 2025-07-20 9691.67
3202 2025-07-21 9681.67
3203 2025-07-22 9586.67
2025-07-22 17:51:10,277 - IOOppi_data - INFO : save new data to db: IOOppi_RS_g: no new data
2025-07-22 17:51:10,277 - 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-22 17:51:10,831 - IOOppi_data - INFO : save data to db IOOppi_eg_t data:
date value
1883 2025-07-18 4415.00
1884 2025-07-19 4415.00
1885 2025-07-20 4415.00
1886 2025-07-21 4431.67
1887 2025-07-22 4436.67
2025-07-22 17:51:10,881 - IOOppi_data - INFO : save new data to db IOOppi_eg_t: date value ... created_at updated_at
1884 2025-07-19 4415.00 ... 2025-07-22 17:51:10.873604 2025-07-22 17:51:10.874029
1885 2025-07-20 4415.00 ... 2025-07-22 17:51:10.873604 2025-07-22 17:51:10.874029
1886 2025-07-21 4431.67 ... 2025-07-22 17:51:10.873604 2025-07-22 17:51:10.874029
1887 2025-07-22 4436.67 ... 2025-07-22 17:51:10.873604 2025-07-22 17:51:10.874029
[4 rows x 5 columns]
2025-07-22 17:51:10,900 - IOOppi_data - INFO : save diff data to db: IOOppi_eg_t: no diff data
2025-07-22 17:51:10,906 - IOOppi_data - INFO : save data to db IOOppi_eg_g data:
date value
1883 2025-07-18 4415.00
1884 2025-07-19 4415.00
1885 2025-07-20 4415.00
1886 2025-07-21 4431.67
1887 2025-07-22 4436.67
2025-07-22 17:51:10,955 - IOOppi_data - INFO : save new data to db IOOppi_eg_g: date value ... created_at updated_at
1887 2025-07-19 4415.00 ... 2025-07-22 17:51:10.947643 2025-07-22 17:51:10.948061
1888 2025-07-20 4415.00 ... 2025-07-22 17:51:10.947643 2025-07-22 17:51:10.948061
1889 2025-07-21 4431.67 ... 2025-07-22 17:51:10.947643 2025-07-22 17:51:10.948061
1890 2025-07-22 4436.67 ... 2025-07-22 17:51:10.947643 2025-07-22 17:51:10.948061
[4 rows x 5 columns]
2025-07-22 17:51:10,973 - 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-22 17:51:11,592 - IOOppi_data - INFO : save data to db IOOppi_sp_t data:
date value
1892 2025-07-18 5933.33
1893 2025-07-19 5933.33
1894 2025-07-20 5933.33
1895 2025-07-21 5950.00
1896 2025-07-22 5923.33
2025-07-22 17:51:11,642 - IOOppi_data - INFO : save new data to db IOOppi_sp_t: date value ... created_at updated_at
1893 2025-07-19 5933.33 ... 2025-07-22 17:51:11.634454 2025-07-22 17:51:11.634876
1894 2025-07-20 5933.33 ... 2025-07-22 17:51:11.634454 2025-07-22 17:51:11.634876
1895 2025-07-21 5950.00 ... 2025-07-22 17:51:11.634454 2025-07-22 17:51:11.634876
1896 2025-07-22 5923.33 ... 2025-07-22 17:51:11.634454 2025-07-22 17:51:11.634876
[4 rows x 5 columns]
2025-07-22 17:51:11,661 - IOOppi_data - INFO : save diff data to db: IOOppi_sp_t: no diff data
2025-07-22 17:51:11,667 - IOOppi_data - INFO : save data to db IOOppi_sp_g data:
date value
1892 2025-07-18 5933.33
1893 2025-07-19 5933.33
1894 2025-07-20 5933.33
1895 2025-07-21 5950.00
1896 2025-07-22 5923.33
2025-07-22 17:51:11,724 - IOOppi_data - INFO : save new data to db IOOppi_sp_g: date value ... created_at updated_at
1896 2025-07-19 5933.33 ... 2025-07-22 17:51:11.716636 2025-07-22 17:51:11.717056
1897 2025-07-20 5933.33 ... 2025-07-22 17:51:11.716636 2025-07-22 17:51:11.717056
1898 2025-07-21 5950.00 ... 2025-07-22 17:51:11.716636 2025-07-22 17:51:11.717056
1899 2025-07-22 5923.33 ... 2025-07-22 17:51:11.716636 2025-07-22 17:51:11.717056
[4 rows x 5 columns]
2025-07-22 17:51:11,742 - 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-22 17:51:12,374 - IOOppi_data - INFO : save data to db IOOppi_p_t data:
date value
3560 2025-07-18 9048.0
3561 2025-07-19 9048.0
3562 2025-07-20 9048.0
3563 2025-07-21 9046.0
3564 2025-07-22 8994.0
2025-07-22 17:51:12,443 - IOOppi_data - INFO : save new data to db IOOppi_p_t: date value ... created_at updated_at
3561 2025-07-19 9048.0 ... 2025-07-22 17:51:12.436145 2025-07-22 17:51:12.436528
3562 2025-07-20 9048.0 ... 2025-07-22 17:51:12.436145 2025-07-22 17:51:12.436528
3563 2025-07-21 9046.0 ... 2025-07-22 17:51:12.436145 2025-07-22 17:51:12.436528
3564 2025-07-22 8994.0 ... 2025-07-22 17:51:12.436145 2025-07-22 17:51:12.436528
[4 rows x 5 columns]
2025-07-22 17:51:12,462 - IOOppi_data - INFO : save diff data to db: IOOppi_p_t: no diff data
2025-07-22 17:51:12,467 - IOOppi_data - INFO : save data to db IOOppi_p_g data:
date value
3560 2025-07-18 9048.0
3561 2025-07-19 9048.0
3562 2025-07-20 9048.0
3563 2025-07-21 9046.0
3564 2025-07-22 8994.0
2025-07-22 17:51:12,550 - IOOppi_data - INFO : save new data to db IOOppi_p_g: date value ... created_at updated_at
3564 2025-07-19 9048.0 ... 2025-07-22 17:51:12.541736 2025-07-22 17:51:12.542178
3565 2025-07-20 9048.0 ... 2025-07-22 17:51:12.541736 2025-07-22 17:51:12.542178
3566 2025-07-21 9046.0 ... 2025-07-22 17:51:12.541736 2025-07-22 17:51:12.542178
3567 2025-07-22 8994.0 ... 2025-07-22 17:51:12.541736 2025-07-22 17:51:12.542178
[4 rows x 5 columns]
2025-07-22 17:51:12,568 - IOOppi_data - INFO : save diff data to db: IOOppi_p_g: no diff data