=========================================================================
2025-05-26 17:50:26 Mon START TASK.01 IOOppi_data update_data
=========================================================================
/usr/local/lib/python3.10/site-packages/urllib3/connectionpool.py:1056: InsecureRequestWarning: Unverified HTTPS request is being made to host 'www.100ppi.com'. Adding certificate verification is strongly advised. See: https://urllib3.readthedocs.io/en/1.26.x/advanced-usage.html#ssl-warnings
warnings.warn(
2025-05-26 17:50:28,371 - IOOppi_data - INFO : save data to db IOOppi_rb_t data:
date value
3311 2025-05-22 3146.78
3312 2025-05-23 3138.56
3313 2025-05-24 3138.56
3314 2025-05-25 3138.56
3315 2025-05-26 3115.67
2025-05-26 17:50:28,467 - IOOppi_data - INFO : save new data to db IOOppi_rb_t: date value ... created_at updated_at
3313 2025-05-24 3138.56 ... 2025-05-26 17:50:28.459580 2025-05-26 17:50:28.460032
3314 2025-05-25 3138.56 ... 2025-05-26 17:50:28.459580 2025-05-26 17:50:28.460032
3315 2025-05-26 3115.67 ... 2025-05-26 17:50:28.459580 2025-05-26 17:50:28.460032
[3 rows x 5 columns]
2025-05-26 17:50:28,488 - IOOppi_data - INFO : save diff data to db: IOOppi_rb_t: no diff data
2025-05-26 17:50:28,493 - IOOppi_data - INFO : save data to db IOOppi_rb_g data:
date value
3311 2025-05-22 3146.78
3312 2025-05-23 3138.56
3313 2025-05-24 3138.56
3314 2025-05-25 3138.56
3315 2025-05-26 3115.67
2025-05-26 17:50:28,559 - IOOppi_data - INFO : save new data to db IOOppi_rb_g: date value ... created_at updated_at
3316 2025-05-24 3138.56 ... 2025-05-26 17:50:28.552181 2025-05-26 17:50:28.552556
3317 2025-05-25 3138.56 ... 2025-05-26 17:50:28.552181 2025-05-26 17:50:28.552556
3318 2025-05-26 3115.67 ... 2025-05-26 17:50:28.552181 2025-05-26 17:50:28.552556
[3 rows x 5 columns]
2025-05-26 17:50:28,578 - 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-05-26 17:50:29,562 - IOOppi_data - INFO : save data to db IOOppi_MA_t data:
date value
3532 2025-05-22 2312.5
3533 2025-05-23 2300.0
3534 2025-05-24 2300.0
3535 2025-05-25 2300.0
3536 2025-05-26 2300.0
2025-05-26 17:50:29,637 - IOOppi_data - INFO : save new data to db IOOppi_MA_t: date value ... created_at updated_at
3534 2025-05-24 2300.0 ... 2025-05-26 17:50:29.628971 2025-05-26 17:50:29.629390
3535 2025-05-25 2300.0 ... 2025-05-26 17:50:29.628971 2025-05-26 17:50:29.629390
3536 2025-05-26 2300.0 ... 2025-05-26 17:50:29.628971 2025-05-26 17:50:29.629390
[3 rows x 5 columns]
2025-05-26 17:50:29,657 - IOOppi_data - INFO : save diff data to db: IOOppi_MA_t: no diff data
2025-05-26 17:50:29,663 - IOOppi_data - INFO : save data to db IOOppi_MA_g data:
date value
3532 2025-05-22 2312.5
3533 2025-05-23 2300.0
3534 2025-05-24 2300.0
3535 2025-05-25 2300.0
3536 2025-05-26 2300.0
2025-05-26 17:50:29,736 - IOOppi_data - INFO : save new data to db IOOppi_MA_g: date value ... created_at updated_at
3538 2025-05-24 2300.0 ... 2025-05-26 17:50:29.728623 2025-05-26 17:50:29.729040
3539 2025-05-25 2300.0 ... 2025-05-26 17:50:29.728623 2025-05-26 17:50:29.729040
3540 2025-05-26 2300.0 ... 2025-05-26 17:50:29.728623 2025-05-26 17:50:29.729040
[3 rows x 5 columns]
2025-05-26 17:50:29,757 - 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-05-26 17:50:30,312 - IOOppi_data - INFO : save data to db IOOppi_PTA_t data:
date value
872 2025-05-22 4913.34
873 2025-05-23 4915.00
874 2025-05-24 4915.00
875 2025-05-25 4915.00
876 2025-05-26 4917.50
2025-05-26 17:50:30,349 - IOOppi_data - INFO : save new data to db IOOppi_PTA_t: date value ... created_at updated_at
874 2025-05-24 4915.0 ... 2025-05-26 17:50:30.342073 2025-05-26 17:50:30.342496
875 2025-05-25 4915.0 ... 2025-05-26 17:50:30.342073 2025-05-26 17:50:30.342496
876 2025-05-26 4917.5 ... 2025-05-26 17:50:30.342073 2025-05-26 17:50:30.342496
[3 rows x 5 columns]
2025-05-26 17:50:30,368 - IOOppi_data - INFO : save diff data to db: IOOppi_PTA_t: no diff data
2025-05-26 17:50:30,373 - IOOppi_data - INFO : save data to db IOOppi_PTA_g data:
date value
872 2025-05-22 4913.34
873 2025-05-23 4915.00
874 2025-05-24 4915.00
875 2025-05-25 4915.00
876 2025-05-26 4917.50
2025-05-26 17:50:30,414 - IOOppi_data - INFO : save new data to db IOOppi_PTA_g: date value ... created_at updated_at
874 2025-05-24 4915.0 ... 2025-05-26 17:50:30.404029 2025-05-26 17:50:30.404658
875 2025-05-25 4915.0 ... 2025-05-26 17:50:30.404029 2025-05-26 17:50:30.404658
876 2025-05-26 4917.5 ... 2025-05-26 17:50:30.404029 2025-05-26 17:50:30.404658
[3 rows x 5 columns]
2025-05-26 17:50:30,434 - 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-05-26 17:50:31,038 - IOOppi_data - INFO : save data to db IOOppi_ru_t data:
date value
3751 2025-05-22 14578.33
3752 2025-05-23 14308.33
3753 2025-05-24 14308.33
3754 2025-05-25 14308.33
3755 2025-05-26 14158.33
2025-05-26 17:50:31,110 - IOOppi_data - INFO : save new data to db IOOppi_ru_t: date ... updated_at
3753 2025-05-24 ... 2025-05-26 17:50:31.103526
3754 2025-05-25 ... 2025-05-26 17:50:31.103526
3755 2025-05-26 ... 2025-05-26 17:50:31.103526
[3 rows x 5 columns]
2025-05-26 17:50:31,130 - IOOppi_data - INFO : save diff data to db: IOOppi_ru_t: no diff data
2025-05-26 17:50:31,137 - IOOppi_data - INFO : save data to db IOOppi_ru_g data:
date value
3751 2025-05-22 14578.33
3752 2025-05-23 14308.33
3753 2025-05-24 14308.33
3754 2025-05-25 14308.33
3755 2025-05-26 14158.33
2025-05-26 17:50:31,209 - IOOppi_data - INFO : save new data to db IOOppi_ru_g: date ... updated_at
3756 2025-05-24 ... 2025-05-26 17:50:31.202653
3757 2025-05-25 ... 2025-05-26 17:50:31.202653
3758 2025-05-26 ... 2025-05-26 17:50:31.202653
[3 rows x 5 columns]
2025-05-26 17:50:31,229 - 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-05-26 17:50:31,761 - IOOppi_data - INFO : save data to db IOOppi_i_t data:
date value
3083 2025-05-22 782.56
3084 2025-05-23 777.56
3085 2025-05-24 777.56
3086 2025-05-25 772.56
3087 2025-05-26 769.67
2025-05-26 17:50:31,829 - IOOppi_data - INFO : save new data to db IOOppi_i_t: date value ... created_at updated_at
3085 2025-05-24 777.56 ... 2025-05-26 17:50:31.821498 2025-05-26 17:50:31.821905
3086 2025-05-25 772.56 ... 2025-05-26 17:50:31.821498 2025-05-26 17:50:31.821905
3087 2025-05-26 769.67 ... 2025-05-26 17:50:31.821498 2025-05-26 17:50:31.821905
[3 rows x 5 columns]
2025-05-26 17:50:31,848 - IOOppi_data - INFO : save diff data to db: IOOppi_i_t: no diff data
2025-05-26 17:50:31,853 - IOOppi_data - INFO : save data to db IOOppi_i_g data:
date value
3083 2025-05-22 782.56
3084 2025-05-23 777.56
3085 2025-05-24 777.56
3086 2025-05-25 772.56
3087 2025-05-26 769.67
2025-05-26 17:50:31,918 - IOOppi_data - INFO : save new data to db IOOppi_i_g: date value ... created_at updated_at
3088 2025-05-24 777.56 ... 2025-05-26 17:50:31.910373 2025-05-26 17:50:31.910802
3089 2025-05-25 772.56 ... 2025-05-26 17:50:31.910373 2025-05-26 17:50:31.910802
3090 2025-05-26 769.67 ... 2025-05-26 17:50:31.910373 2025-05-26 17:50:31.910802
[3 rows x 5 columns]
2025-05-26 17:50:31,937 - 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-05-26 17:50:32,476 - IOOppi_data - INFO : save data to db IOOppi_FG_t data:
date value
3286 2025-05-22 1148.0
3287 2025-05-23 1152.0
3288 2025-05-24 1152.0
3289 2025-05-25 1152.0
3290 2025-05-26 1152.0
2025-05-26 17:50:32,542 - IOOppi_data - INFO : save new data to db IOOppi_FG_t: date value ... created_at updated_at
3288 2025-05-24 1152.0 ... 2025-05-26 17:50:32.534511 2025-05-26 17:50:32.534950
3289 2025-05-25 1152.0 ... 2025-05-26 17:50:32.534511 2025-05-26 17:50:32.534950
3290 2025-05-26 1152.0 ... 2025-05-26 17:50:32.534511 2025-05-26 17:50:32.534950
[3 rows x 5 columns]
/root/project/IOOppi_data/IOOppi_request.py:308: SettingWithCopyWarning:
A value is trying to be set on a copy of a slice from a DataFrame.
Try using .loc[row_indexer,col_indexer] = value instead
See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy
diff_df.loc[:, 'index_code'] = index_code
/root/project/IOOppi_data/IOOppi_request.py:309: SettingWithCopyWarning:
A value is trying to be set on a copy of a slice from a DataFrame.
Try using .loc[row_indexer,col_indexer] = value instead
See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy
diff_df.loc[:, 'created_at'] = datetime.datetime.now()
/root/project/IOOppi_data/IOOppi_request.py:310: SettingWithCopyWarning:
A value is trying to be set on a copy of a slice from a DataFrame.
Try using .loc[row_indexer,col_indexer] = value instead
See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy
diff_df.loc[:, 'updated_at'] = datetime.datetime.now()
2025-05-26 17:50:34,563 - IOOppi_data - INFO : save diff data to db IOOppi_FG_t: date ... updated_at
12 2012-12-19 ... 2025-05-26 17:50:34.556099
21 2013-01-04 ... 2025-05-26 17:50:34.556099
54 2013-02-27 ... 2025-05-26 17:50:34.556099
60 2013-03-07 ... 2025-05-26 17:50:34.556099
61 2013-03-08 ... 2025-05-26 17:50:34.556099
[5 rows x 6 columns]
2025-05-26 17:50:34,725 - IOOppi_data - INFO : save data to db IOOppi_FG_g data:
date value
3286 2025-05-22 1148.0
3287 2025-05-23 1152.0
3288 2025-05-24 1152.0
3289 2025-05-25 1152.0
3290 2025-05-26 1152.0
2025-05-26 17:50:34,791 - IOOppi_data - INFO : save new data to db IOOppi_FG_g: date value ... created_at updated_at
3292 2025-05-24 1152.0 ... 2025-05-26 17:50:34.784021 2025-05-26 17:50:34.784440
3293 2025-05-25 1152.0 ... 2025-05-26 17:50:34.784021 2025-05-26 17:50:34.784440
3294 2025-05-26 1152.0 ... 2025-05-26 17:50:34.784021 2025-05-26 17:50:34.784440
[3 rows x 5 columns]
/root/project/IOOppi_data/IOOppi_request.py:308: SettingWithCopyWarning:
A value is trying to be set on a copy of a slice from a DataFrame.
Try using .loc[row_indexer,col_indexer] = value instead
See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy
diff_df.loc[:, 'index_code'] = index_code
/root/project/IOOppi_data/IOOppi_request.py:309: SettingWithCopyWarning:
A value is trying to be set on a copy of a slice from a DataFrame.
Try using .loc[row_indexer,col_indexer] = value instead
See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy
diff_df.loc[:, 'created_at'] = datetime.datetime.now()
/root/project/IOOppi_data/IOOppi_request.py:310: SettingWithCopyWarning:
A value is trying to be set on a copy of a slice from a DataFrame.
Try using .loc[row_indexer,col_indexer] = value instead
See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy
diff_df.loc[:, 'updated_at'] = datetime.datetime.now()
2025-05-26 17:50:36,812 - IOOppi_data - INFO : save diff data to db IOOppi_FG_g: date ... updated_at
12 2012-12-19 ... 2025-05-26 17:50:36.804372
21 2013-01-04 ... 2025-05-26 17:50:36.804372
54 2013-02-27 ... 2025-05-26 17:50:36.804372
60 2013-03-07 ... 2025-05-26 17:50:36.804372
61 2013-03-08 ... 2025-05-26 17:50:36.804372
[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-05-26 17:50:37,654 - IOOppi_data - INFO : save data to db IOOppi_eb_t data:
date value
1631 2025-05-22 8130.0
1632 2025-05-23 8130.0
1633 2025-05-24 8130.0
1634 2025-05-25 8130.0
1635 2025-05-26 8110.0
2025-05-26 17:50:37,699 - IOOppi_data - INFO : save new data to db IOOppi_eb_t: date value ... created_at updated_at
1633 2025-05-24 8130.0 ... 2025-05-26 17:50:37.692277 2025-05-26 17:50:37.692654
1634 2025-05-25 8130.0 ... 2025-05-26 17:50:37.692277 2025-05-26 17:50:37.692654
1635 2025-05-26 8110.0 ... 2025-05-26 17:50:37.692277 2025-05-26 17:50:37.692654
[3 rows x 5 columns]
2025-05-26 17:50:37,719 - IOOppi_data - INFO : save diff data to db: IOOppi_eb_t: no diff data
2025-05-26 17:50:37,724 - IOOppi_data - INFO : save data to db IOOppi_eb_g data:
date value
1631 2025-05-22 8130.0
1632 2025-05-23 8130.0
1633 2025-05-24 8130.0
1634 2025-05-25 8130.0
1635 2025-05-26 8110.0
2025-05-26 17:50:37,770 - IOOppi_data - INFO : save new data to db IOOppi_eb_g: date value ... created_at updated_at
1636 2025-05-24 8130.0 ... 2025-05-26 17:50:37.762866 2025-05-26 17:50:37.763249
1637 2025-05-25 8130.0 ... 2025-05-26 17:50:37.762866 2025-05-26 17:50:37.763249
1638 2025-05-26 8110.0 ... 2025-05-26 17:50:37.762866 2025-05-26 17:50:37.763249
[3 rows x 5 columns]
2025-05-26 17:50:37,789 - 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-05-26 17:50:38,407 - IOOppi_data - INFO : save data to db IOOppi_SR_t data:
date value
3742 2025-05-22 6145.0
3743 2025-05-23 6145.0
3744 2025-05-24 6145.0
3745 2025-05-25 6145.0
3746 2025-05-26 6145.0
2025-05-26 17:50:38,488 - IOOppi_data - INFO : save new data to db IOOppi_SR_t: date value ... created_at updated_at
3744 2025-05-24 6145.0 ... 2025-05-26 17:50:38.481087 2025-05-26 17:50:38.481477
3745 2025-05-25 6145.0 ... 2025-05-26 17:50:38.481087 2025-05-26 17:50:38.481477
3746 2025-05-26 6145.0 ... 2025-05-26 17:50:38.481087 2025-05-26 17:50:38.481477
[3 rows x 5 columns]
2025-05-26 17:50:38,508 - IOOppi_data - INFO : save diff data to db: IOOppi_SR_t: no diff data
2025-05-26 17:50:38,514 - IOOppi_data - INFO : save data to db IOOppi_SR_g data:
date value
3742 2025-05-22 6145.0
3743 2025-05-23 6145.0
3744 2025-05-24 6145.0
3745 2025-05-25 6145.0
3746 2025-05-26 6145.0
2025-05-26 17:50:38,588 - IOOppi_data - INFO : save new data to db IOOppi_SR_g: date value ... created_at updated_at
3748 2025-05-24 6145.0 ... 2025-05-26 17:50:38.580514 2025-05-26 17:50:38.580957
3749 2025-05-25 6145.0 ... 2025-05-26 17:50:38.580514 2025-05-26 17:50:38.580957
3750 2025-05-26 6145.0 ... 2025-05-26 17:50:38.580514 2025-05-26 17:50:38.580957
[3 rows x 5 columns]
2025-05-26 17:50:38,608 - 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-05-26 17:50:39,150 - IOOppi_data - INFO : save data to db IOOppi_ss_t data:
date value
1632 2025-05-22 13237.5
1633 2025-05-23 13225.0
1634 2025-05-24 13225.0
1635 2025-05-25 13225.0
1636 2025-05-26 13225.0
2025-05-26 17:50:39,196 - IOOppi_data - INFO : save new data to db IOOppi_ss_t: date value ... created_at updated_at
1634 2025-05-24 13225.0 ... 2025-05-26 17:50:39.188735 2025-05-26 17:50:39.189145
1635 2025-05-25 13225.0 ... 2025-05-26 17:50:39.188735 2025-05-26 17:50:39.189145
1636 2025-05-26 13225.0 ... 2025-05-26 17:50:39.188735 2025-05-26 17:50:39.189145
[3 rows x 5 columns]
2025-05-26 17:50:39,215 - IOOppi_data - INFO : save diff data to db: IOOppi_ss_t: no diff data
2025-05-26 17:50:39,221 - IOOppi_data - INFO : save data to db IOOppi_ss_g data:
date value
1632 2025-05-22 13237.5
1633 2025-05-23 13225.0
1634 2025-05-24 13225.0
1635 2025-05-25 13225.0
1636 2025-05-26 13225.0
2025-05-26 17:50:39,268 - IOOppi_data - INFO : save new data to db IOOppi_ss_g: date value ... created_at updated_at
1637 2025-05-24 13225.0 ... 2025-05-26 17:50:39.260635 2025-05-26 17:50:39.261068
1638 2025-05-25 13225.0 ... 2025-05-26 17:50:39.260635 2025-05-26 17:50:39.261068
1639 2025-05-26 13225.0 ... 2025-05-26 17:50:39.260635 2025-05-26 17:50:39.261068
[3 rows x 5 columns]
2025-05-26 17:50:39,287 - 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-05-26 17:50:39,872 - IOOppi_data - INFO : save data to db IOOppi_RS_t data:
date value
3142 2025-05-22 9541.67
3143 2025-05-23 9513.33
3144 2025-05-24 9513.33
3145 2025-05-25 9513.33
3146 2025-05-26 9493.33
2025-05-26 17:50:39,943 - IOOppi_data - INFO : save new data to db IOOppi_RS_t: date value ... created_at updated_at
3144 2025-05-24 9513.33 ... 2025-05-26 17:50:39.934376 2025-05-26 17:50:39.934908
3145 2025-05-25 9513.33 ... 2025-05-26 17:50:39.934376 2025-05-26 17:50:39.934908
3146 2025-05-26 9493.33 ... 2025-05-26 17:50:39.934376 2025-05-26 17:50:39.934908
[3 rows x 5 columns]
2025-05-26 17:50:39,963 - IOOppi_data - INFO : save diff data to db: IOOppi_RS_t: no diff data
2025-05-26 17:50:39,969 - IOOppi_data - INFO : save data to db IOOppi_RS_g data:
date value
3142 2025-05-22 9541.67
3143 2025-05-23 9513.33
3144 2025-05-24 9513.33
3145 2025-05-25 9513.33
3146 2025-05-26 9493.33
2025-05-26 17:50:40,033 - IOOppi_data - INFO : save new data to db IOOppi_RS_g: date value ... created_at updated_at
3148 2025-05-24 9513.33 ... 2025-05-26 17:50:40.025557 2025-05-26 17:50:40.025962
3149 2025-05-25 9513.33 ... 2025-05-26 17:50:40.025557 2025-05-26 17:50:40.025962
3150 2025-05-26 9493.33 ... 2025-05-26 17:50:40.025557 2025-05-26 17:50:40.025962
[3 rows x 5 columns]
2025-05-26 17:50:40,051 - 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-05-26 17:50:40,590 - IOOppi_data - INFO : save data to db IOOppi_RM_t data:
date value
3265 2025-05-22 2485.00
3266 2025-05-23 2521.67
3267 2025-05-24 2521.67
3268 2025-05-25 2521.67
3269 2025-05-26 2515.00
2025-05-26 17:50:40,656 - IOOppi_data - INFO : save new data to db IOOppi_RM_t: date value ... created_at updated_at
3267 2025-05-24 2521.67 ... 2025-05-26 17:50:40.648775 2025-05-26 17:50:40.649172
3268 2025-05-25 2521.67 ... 2025-05-26 17:50:40.648775 2025-05-26 17:50:40.649172
3269 2025-05-26 2515.00 ... 2025-05-26 17:50:40.648775 2025-05-26 17:50:40.649172
[3 rows x 5 columns]
2025-05-26 17:50:40,675 - IOOppi_data - INFO : save diff data to db: IOOppi_RM_t: no diff data
2025-05-26 17:50:40,681 - IOOppi_data - INFO : save data to db IOOppi_RM_g data:
date value
3265 2025-05-22 2485.00
3266 2025-05-23 2521.67
3267 2025-05-24 2521.67
3268 2025-05-25 2521.67
3269 2025-05-26 2515.00
2025-05-26 17:50:40,746 - IOOppi_data - INFO : save new data to db IOOppi_RM_g: date value ... created_at updated_at
3271 2025-05-24 2521.67 ... 2025-05-26 17:50:40.739334 2025-05-26 17:50:40.739717
3272 2025-05-25 2521.67 ... 2025-05-26 17:50:40.739334 2025-05-26 17:50:40.739717
3273 2025-05-26 2515.00 ... 2025-05-26 17:50:40.739334 2025-05-26 17:50:40.739717
[3 rows x 5 columns]
2025-05-26 17:50:40,766 - 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-05-26 17:50:41,255 - IOOppi_data - INFO : save data to db IOOppi_SA_t data:
date value
1469 2025-05-22 1462.5
1470 2025-05-23 1462.5
1471 2025-05-24 1462.5
1472 2025-05-25 1462.5
1473 2025-05-26 1462.5
2025-05-26 17:50:41,304 - IOOppi_data - INFO : save new data to db IOOppi_SA_t: date value ... created_at updated_at
1471 2025-05-24 1462.5 ... 2025-05-26 17:50:41.293182 2025-05-26 17:50:41.293824
1472 2025-05-25 1462.5 ... 2025-05-26 17:50:41.293182 2025-05-26 17:50:41.293824
1473 2025-05-26 1462.5 ... 2025-05-26 17:50:41.293182 2025-05-26 17:50:41.293824
[3 rows x 5 columns]
2025-05-26 17:50:41,326 - IOOppi_data - INFO : save diff data to db: IOOppi_SA_t: no diff data
2025-05-26 17:50:41,333 - IOOppi_data - INFO : save data to db IOOppi_SA_g data:
date value
1469 2025-05-22 1462.5
1470 2025-05-23 1462.5
1471 2025-05-24 1462.5
1472 2025-05-25 1462.5
1473 2025-05-26 1462.5
2025-05-26 17:50:41,379 - IOOppi_data - INFO : save new data to db IOOppi_SA_g: date value ... created_at updated_at
1475 2025-05-24 1462.5 ... 2025-05-26 17:50:41.371644 2025-05-26 17:50:41.372064
1476 2025-05-25 1462.5 ... 2025-05-26 17:50:41.371644 2025-05-26 17:50:41.372064
1477 2025-05-26 1462.5 ... 2025-05-26 17:50:41.371644 2025-05-26 17:50:41.372064
[3 rows x 5 columns]
2025-05-26 17:50:41,398 - 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-05-26 17:50:42,066 - IOOppi_data - INFO : save data to db IOOppi_PF_t data:
date value
1382 2025-05-22 6623.12
1383 2025-05-23 6597.08
1384 2025-05-24 6597.08
1385 2025-05-25 6597.08
1386 2025-05-26 6572.50
2025-05-26 17:50:42,109 - IOOppi_data - INFO : save new data to db IOOppi_PF_t: date value ... created_at updated_at
1384 2025-05-24 6597.08 ... 2025-05-26 17:50:42.101600 2025-05-26 17:50:42.102024
1385 2025-05-25 6597.08 ... 2025-05-26 17:50:42.101600 2025-05-26 17:50:42.102024
1386 2025-05-26 6572.50 ... 2025-05-26 17:50:42.101600 2025-05-26 17:50:42.102024
[3 rows x 5 columns]
2025-05-26 17:50:42,129 - IOOppi_data - INFO : save diff data to db: IOOppi_PF_t: no diff data
2025-05-26 17:50:42,135 - IOOppi_data - INFO : save data to db IOOppi_PF_g data:
date value
1382 2025-05-22 6623.12
1383 2025-05-23 6597.08
1384 2025-05-24 6597.08
1385 2025-05-25 6597.08
1386 2025-05-26 6572.50
2025-05-26 17:50:42,178 - IOOppi_data - INFO : save new data to db IOOppi_PF_g: date value ... created_at updated_at
1388 2025-05-24 6597.08 ... 2025-05-26 17:50:42.170998 2025-05-26 17:50:42.171377
1389 2025-05-25 6597.08 ... 2025-05-26 17:50:42.170998 2025-05-26 17:50:42.171377
1390 2025-05-26 6572.50 ... 2025-05-26 17:50:42.170998 2025-05-26 17:50:42.171377
[3 rows x 5 columns]
2025-05-26 17:50:42,197 - 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-05-26 17:50:42,776 - IOOppi_data - INFO : save data to db IOOppi_m_t data:
date value
3755 2025-05-22 2998.0
3756 2025-05-23 3024.0
3757 2025-05-24 3024.0
3758 2025-05-25 3024.0
3759 2025-05-26 2982.0
2025-05-26 17:50:42,848 - IOOppi_data - INFO : save new data to db IOOppi_m_t: date value ... created_at updated_at
3757 2025-05-24 3024.0 ... 2025-05-26 17:50:42.841087 2025-05-26 17:50:42.841498
3758 2025-05-25 3024.0 ... 2025-05-26 17:50:42.841087 2025-05-26 17:50:42.841498
3759 2025-05-26 2982.0 ... 2025-05-26 17:50:42.841087 2025-05-26 17:50:42.841498
[3 rows x 5 columns]
2025-05-26 17:50:42,868 - IOOppi_data - INFO : save diff data to db: IOOppi_m_t: no diff data
2025-05-26 17:50:42,874 - IOOppi_data - INFO : save data to db IOOppi_m_g data:
date value
3755 2025-05-22 2998.0
3756 2025-05-23 3024.0
3757 2025-05-24 3024.0
3758 2025-05-25 3024.0
3759 2025-05-26 2982.0
2025-05-26 17:50:42,947 - IOOppi_data - INFO : save new data to db IOOppi_m_g: date value ... created_at updated_at
3760 2025-05-24 3024.0 ... 2025-05-26 17:50:42.939855 2025-05-26 17:50:42.940247
3761 2025-05-25 3024.0 ... 2025-05-26 17:50:42.939855 2025-05-26 17:50:42.940247
3762 2025-05-26 2982.0 ... 2025-05-26 17:50:42.939855 2025-05-26 17:50:42.940247
[3 rows x 5 columns]
2025-05-26 17:50:42,966 - 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-05-26 17:50:43,524 - IOOppi_data - INFO : save data to db IOOppi_y_t data:
date value
3525 2025-05-22 8074.0
3526 2025-05-23 8034.0
3527 2025-05-24 8034.0
3528 2025-05-25 8034.0
3529 2025-05-26 7964.0
2025-05-26 17:50:43,593 - IOOppi_data - INFO : save new data to db IOOppi_y_t: date value ... created_at updated_at
3527 2025-05-24 8034.0 ... 2025-05-26 17:50:43.585795 2025-05-26 17:50:43.586182
3528 2025-05-25 8034.0 ... 2025-05-26 17:50:43.585795 2025-05-26 17:50:43.586182
3529 2025-05-26 7964.0 ... 2025-05-26 17:50:43.585795 2025-05-26 17:50:43.586182
[3 rows x 5 columns]
2025-05-26 17:50:43,613 - IOOppi_data - INFO : save diff data to db: IOOppi_y_t: no diff data
2025-05-26 17:50:43,619 - IOOppi_data - INFO : save data to db IOOppi_y_g data:
date value
3525 2025-05-22 8074.0
3526 2025-05-23 8034.0
3527 2025-05-24 8034.0
3528 2025-05-25 8034.0
3529 2025-05-26 7964.0
2025-05-26 17:50:43,690 - IOOppi_data - INFO : save new data to db IOOppi_y_g: date value ... created_at updated_at
3530 2025-05-24 8034.0 ... 2025-05-26 17:50:43.682873 2025-05-26 17:50:43.683267
3531 2025-05-25 8034.0 ... 2025-05-26 17:50:43.682873 2025-05-26 17:50:43.683267
3532 2025-05-26 7964.0 ... 2025-05-26 17:50:43.682873 2025-05-26 17:50:43.683267
[3 rows x 5 columns]
2025-05-26 17:50:43,709 - 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-05-26 17:50:44,260 - IOOppi_data - INFO : save data to db IOOppi_a_t data:
date value
3491 2025-05-22 4255.0
3492 2025-05-23 4255.0
3493 2025-05-24 4255.0
3494 2025-05-25 4255.0
3495 2025-05-26 4255.0
2025-05-26 17:50:44,330 - IOOppi_data - INFO : save new data to db IOOppi_a_t: date value ... created_at updated_at
3493 2025-05-24 4255.0 ... 2025-05-26 17:50:44.322804 2025-05-26 17:50:44.323205
3494 2025-05-25 4255.0 ... 2025-05-26 17:50:44.322804 2025-05-26 17:50:44.323205
3495 2025-05-26 4255.0 ... 2025-05-26 17:50:44.322804 2025-05-26 17:50:44.323205
[3 rows x 5 columns]
2025-05-26 17:50:44,350 - IOOppi_data - INFO : save diff data to db: IOOppi_a_t: no diff data
2025-05-26 17:50:44,357 - IOOppi_data - INFO : save data to db IOOppi_a_g data:
date value
3491 2025-05-22 4255.0
3492 2025-05-23 4255.0
3493 2025-05-24 4255.0
3494 2025-05-25 4255.0
3495 2025-05-26 4255.0
2025-05-26 17:50:44,434 - IOOppi_data - INFO : save new data to db IOOppi_a_g: date value ... created_at updated_at
3496 2025-05-24 4255.0 ... 2025-05-26 17:50:44.426556 2025-05-26 17:50:44.426961
3497 2025-05-25 4255.0 ... 2025-05-26 17:50:44.426556 2025-05-26 17:50:44.426961
3498 2025-05-26 4255.0 ... 2025-05-26 17:50:44.426556 2025-05-26 17:50:44.426961
[3 rows x 5 columns]
2025-05-26 17:50:44,453 - 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-05-26 17:50:44,997 - IOOppi_data - INFO : save data to db IOOppi_SF_t data:
date value
2868 2025-05-22 5387.14
2869 2025-05-23 5387.14
2870 2025-05-24 5387.14
2871 2025-05-25 5387.14
2872 2025-05-26 5380.00
2025-05-26 17:50:45,059 - IOOppi_data - INFO : save new data to db IOOppi_SF_t: date value ... created_at updated_at
2870 2025-05-24 5387.14 ... 2025-05-26 17:50:45.052562 2025-05-26 17:50:45.052974
2871 2025-05-25 5387.14 ... 2025-05-26 17:50:45.052562 2025-05-26 17:50:45.052974
2872 2025-05-26 5380.00 ... 2025-05-26 17:50:45.052562 2025-05-26 17:50:45.052974
[3 rows x 5 columns]
2025-05-26 17:50:45,079 - IOOppi_data - INFO : save diff data to db: IOOppi_SF_t: no diff data
2025-05-26 17:50:45,084 - IOOppi_data - INFO : save data to db IOOppi_SF_g data:
date value
2868 2025-05-22 5387.14
2869 2025-05-23 5387.14
2870 2025-05-24 5387.14
2871 2025-05-25 5387.14
2872 2025-05-26 5380.00
2025-05-26 17:50:45,146 - IOOppi_data - INFO : save new data to db IOOppi_SF_g: date value ... created_at updated_at
2874 2025-05-24 5387.14 ... 2025-05-26 17:50:45.138664 2025-05-26 17:50:45.139097
2875 2025-05-25 5387.14 ... 2025-05-26 17:50:45.138664 2025-05-26 17:50:45.139097
2876 2025-05-26 5380.00 ... 2025-05-26 17:50:45.138664 2025-05-26 17:50:45.139097
[3 rows x 5 columns]
2025-05-26 17:50:45,165 - 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-05-26 17:50:45,683 - IOOppi_data - INFO : save data to db IOOppi_jd_t data:
date value
3068 2025-05-22 3160.0
3069 2025-05-23 3075.0
3070 2025-05-24 3075.0
3071 2025-05-25 3075.0
3072 2025-05-26 3050.0
2025-05-26 17:50:45,746 - IOOppi_data - INFO : save new data to db IOOppi_jd_t: date value ... created_at updated_at
3070 2025-05-24 3075.0 ... 2025-05-26 17:50:45.739247 2025-05-26 17:50:45.739643
3071 2025-05-25 3075.0 ... 2025-05-26 17:50:45.739247 2025-05-26 17:50:45.739643
3072 2025-05-26 3050.0 ... 2025-05-26 17:50:45.739247 2025-05-26 17:50:45.739643
[3 rows x 5 columns]
/root/project/IOOppi_data/IOOppi_request.py:308: SettingWithCopyWarning:
A value is trying to be set on a copy of a slice from a DataFrame.
Try using .loc[row_indexer,col_indexer] = value instead
See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy
diff_df.loc[:, 'index_code'] = index_code
/root/project/IOOppi_data/IOOppi_request.py:309: SettingWithCopyWarning:
A value is trying to be set on a copy of a slice from a DataFrame.
Try using .loc[row_indexer,col_indexer] = value instead
See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy
diff_df.loc[:, 'created_at'] = datetime.datetime.now()
/root/project/IOOppi_data/IOOppi_request.py:310: SettingWithCopyWarning:
A value is trying to be set on a copy of a slice from a DataFrame.
Try using .loc[row_indexer,col_indexer] = value instead
See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy
diff_df.loc[:, 'updated_at'] = datetime.datetime.now()
2025-05-26 17:50:45,898 - IOOppi_data - INFO : save diff data to db IOOppi_jd_t: date ... updated_at
39 2014-01-03 ... 2025-05-26 17:50:45.890166
458 2015-09-21 ... 2025-05-26 17:50:45.890166
549 2016-02-03 ... 2025-05-26 17:50:45.890166
693 2016-09-05 ... 2025-05-26 17:50:45.890166
696 2016-09-08 ... 2025-05-26 17:50:45.890166
[5 rows x 6 columns]
2025-05-26 17:50:45,928 - IOOppi_data - INFO : save data to db IOOppi_jd_g data:
date value
3068 2025-05-22 3160.0
3069 2025-05-23 3075.0
3070 2025-05-24 3075.0
3071 2025-05-25 3075.0
3072 2025-05-26 3050.0
2025-05-26 17:50:45,995 - IOOppi_data - INFO : save new data to db IOOppi_jd_g: date value ... created_at updated_at
3073 2025-05-24 3075.0 ... 2025-05-26 17:50:45.988468 2025-05-26 17:50:45.988870
3074 2025-05-25 3075.0 ... 2025-05-26 17:50:45.988468 2025-05-26 17:50:45.988870
3075 2025-05-26 3050.0 ... 2025-05-26 17:50:45.988468 2025-05-26 17:50:45.988870
[3 rows x 5 columns]
/root/project/IOOppi_data/IOOppi_request.py:308: SettingWithCopyWarning:
A value is trying to be set on a copy of a slice from a DataFrame.
Try using .loc[row_indexer,col_indexer] = value instead
See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy
diff_df.loc[:, 'index_code'] = index_code
/root/project/IOOppi_data/IOOppi_request.py:309: SettingWithCopyWarning:
A value is trying to be set on a copy of a slice from a DataFrame.
Try using .loc[row_indexer,col_indexer] = value instead
See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy
diff_df.loc[:, 'created_at'] = datetime.datetime.now()
/root/project/IOOppi_data/IOOppi_request.py:310: SettingWithCopyWarning:
A value is trying to be set on a copy of a slice from a DataFrame.
Try using .loc[row_indexer,col_indexer] = value instead
See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy
diff_df.loc[:, 'updated_at'] = datetime.datetime.now()
2025-05-26 17:50:46,149 - IOOppi_data - INFO : save diff data to db IOOppi_jd_g: date ... updated_at
39 2014-01-03 ... 2025-05-26 17:50:46.141771
458 2015-09-21 ... 2025-05-26 17:50:46.141771
549 2016-02-03 ... 2025-05-26 17:50:46.141771
693 2016-09-05 ... 2025-05-26 17:50:46.141771
696 2016-09-08 ... 2025-05-26 17:50:46.141771
[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-05-26 17:50:46,757 - IOOppi_data - INFO : save data to db IOOppi_SI_t data:
date value
872 2025-05-22 9210.0
873 2025-05-23 9180.0
874 2025-05-24 9180.0
875 2025-05-25 9180.0
876 2025-05-26 9180.0
2025-05-26 17:50:46,794 - IOOppi_data - INFO : save new data to db IOOppi_SI_t: date value ... created_at updated_at
874 2025-05-24 9180.0 ... 2025-05-26 17:50:46.786718 2025-05-26 17:50:46.787132
875 2025-05-25 9180.0 ... 2025-05-26 17:50:46.786718 2025-05-26 17:50:46.787132
876 2025-05-26 9180.0 ... 2025-05-26 17:50:46.786718 2025-05-26 17:50:46.787132
[3 rows x 5 columns]
2025-05-26 17:50:46,814 - IOOppi_data - INFO : save diff data to db: IOOppi_SI_t: no diff data
2025-05-26 17:50:46,820 - IOOppi_data - INFO : save data to db IOOppi_SI_g data:
date value
872 2025-05-22 9210.0
873 2025-05-23 9180.0
874 2025-05-24 9180.0
875 2025-05-25 9180.0
876 2025-05-26 9180.0
2025-05-26 17:50:46,857 - IOOppi_data - INFO : save new data to db IOOppi_SI_g: date value ... created_at updated_at
874 2025-05-24 9180.0 ... 2025-05-26 17:50:46.849573 2025-05-26 17:50:46.850023
875 2025-05-25 9180.0 ... 2025-05-26 17:50:46.849573 2025-05-26 17:50:46.850023
876 2025-05-26 9180.0 ... 2025-05-26 17:50:46.849573 2025-05-26 17:50:46.850023
[3 rows x 5 columns]
2025-05-26 17:50:46,877 - 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-05-26 17:50:47,664 - IOOppi_data - INFO : save data to db IOOppi_l_t data:
date value
3751 2025-05-22 7575.00
3752 2025-05-23 7558.33
3753 2025-05-24 7558.33
3754 2025-05-25 7558.33
3755 2025-05-26 7496.67
2025-05-26 17:50:47,738 - IOOppi_data - INFO : save new data to db IOOppi_l_t: date value ... created_at updated_at
3753 2025-05-24 7558.33 ... 2025-05-26 17:50:47.730704 2025-05-26 17:50:47.731131
3754 2025-05-25 7558.33 ... 2025-05-26 17:50:47.730704 2025-05-26 17:50:47.731131
3755 2025-05-26 7496.67 ... 2025-05-26 17:50:47.730704 2025-05-26 17:50:47.731131
[3 rows x 5 columns]
2025-05-26 17:50:47,757 - IOOppi_data - INFO : save diff data to db: IOOppi_l_t: no diff data
2025-05-26 17:50:47,764 - IOOppi_data - INFO : save data to db IOOppi_l_g data:
date value
3751 2025-05-22 7575.00
3752 2025-05-23 7558.33
3753 2025-05-24 7558.33
3754 2025-05-25 7558.33
3755 2025-05-26 7496.67
2025-05-26 17:50:47,838 - IOOppi_data - INFO : save new data to db IOOppi_l_g: date value ... created_at updated_at
3756 2025-05-24 7558.33 ... 2025-05-26 17:50:47.830620 2025-05-26 17:50:47.831055
3757 2025-05-25 7558.33 ... 2025-05-26 17:50:47.830620 2025-05-26 17:50:47.831055
3758 2025-05-26 7496.67 ... 2025-05-26 17:50:47.830620 2025-05-26 17:50:47.831055
[3 rows x 5 columns]
2025-05-26 17:50:47,857 - 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-05-26 17:50:48,484 - IOOppi_data - INFO : save data to db IOOppi_bu_t data:
date value
3089 2025-05-22 3570.0
3090 2025-05-23 3570.0
3091 2025-05-24 3570.0
3092 2025-05-25 3570.0
3093 2025-05-26 3570.0
2025-05-26 17:50:48,551 - IOOppi_data - INFO : save new data to db IOOppi_bu_t: date value ... created_at updated_at
3092 2025-05-24 3570.0 ... 2025-05-26 17:50:48.543462 2025-05-26 17:50:48.543900
3093 2025-05-25 3570.0 ... 2025-05-26 17:50:48.543462 2025-05-26 17:50:48.543900
3094 2025-05-26 3570.0 ... 2025-05-26 17:50:48.543462 2025-05-26 17:50:48.543900
[3 rows x 5 columns]
/root/project/IOOppi_data/IOOppi_request.py:308: SettingWithCopyWarning:
A value is trying to be set on a copy of a slice from a DataFrame.
Try using .loc[row_indexer,col_indexer] = value instead
See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy
diff_df.loc[:, 'index_code'] = index_code
/root/project/IOOppi_data/IOOppi_request.py:309: SettingWithCopyWarning:
A value is trying to be set on a copy of a slice from a DataFrame.
Try using .loc[row_indexer,col_indexer] = value instead
See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy
diff_df.loc[:, 'created_at'] = datetime.datetime.now()
/root/project/IOOppi_data/IOOppi_request.py:310: SettingWithCopyWarning:
A value is trying to be set on a copy of a slice from a DataFrame.
Try using .loc[row_indexer,col_indexer] = value instead
See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy
diff_df.loc[:, 'updated_at'] = datetime.datetime.now()
2025-05-26 17:50:48,588 - IOOppi_data - INFO : save diff data to db IOOppi_bu_t: date ... updated_at
2560 2023-12-09 ... 2025-05-26 17:50:48.580541
[1 rows x 6 columns]
2025-05-26 17:50:48,613 - IOOppi_data - INFO : save data to db IOOppi_bu_g data:
date value
3089 2025-05-22 3570.0
3090 2025-05-23 3570.0
3091 2025-05-24 3570.0
3092 2025-05-25 3570.0
3093 2025-05-26 3570.0
2025-05-26 17:50:48,680 - IOOppi_data - INFO : save new data to db IOOppi_bu_g: date value ... created_at updated_at
3094 2025-05-24 3570.0 ... 2025-05-26 17:50:48.672182 2025-05-26 17:50:48.672572
3095 2025-05-25 3570.0 ... 2025-05-26 17:50:48.672182 2025-05-26 17:50:48.672572
3096 2025-05-26 3570.0 ... 2025-05-26 17:50:48.672182 2025-05-26 17:50:48.672572
[3 rows x 5 columns]
2025-05-26 17:50:48,700 - 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-05-26 17:50:49,263 - IOOppi_data - INFO : save data to db IOOppi_al_t data:
date value
3754 2025-05-22 20326.67
3755 2025-05-23 20390.00
3756 2025-05-24 20390.00
3757 2025-05-25 20390.00
3758 2025-05-26 20366.67
2025-05-26 17:50:49,334 - IOOppi_data - INFO : save new data to db IOOppi_al_t: date ... updated_at
3756 2025-05-24 ... 2025-05-26 17:50:49.328511
3757 2025-05-25 ... 2025-05-26 17:50:49.328511
3758 2025-05-26 ... 2025-05-26 17:50:49.328511
[3 rows x 5 columns]
2025-05-26 17:50:49,354 - IOOppi_data - INFO : save diff data to db: IOOppi_al_t: no diff data
2025-05-26 17:50:49,360 - IOOppi_data - INFO : save data to db IOOppi_al_g data:
date value
3754 2025-05-22 20326.67
3755 2025-05-23 20390.00
3756 2025-05-24 20390.00
3757 2025-05-25 20390.00
3758 2025-05-26 20366.67
2025-05-26 17:50:49,431 - IOOppi_data - INFO : save new data to db IOOppi_al_g: date ... updated_at
3759 2025-05-24 ... 2025-05-26 17:50:49.425539
3760 2025-05-25 ... 2025-05-26 17:50:49.425539
3761 2025-05-26 ... 2025-05-26 17:50:49.425539
[3 rows x 5 columns]
2025-05-26 17:50:49,450 - 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-05-26 17:50:50,018 - IOOppi_data - INFO : save data to db IOOppi_SM_t data:
date value
2868 2025-05-22 5652.0
2869 2025-05-23 5642.0
2870 2025-05-24 5642.0
2871 2025-05-25 5642.0
2872 2025-05-26 5614.0
2025-05-26 17:50:50,083 - IOOppi_data - INFO : save new data to db IOOppi_SM_t: date value ... created_at updated_at
2870 2025-05-24 5642.0 ... 2025-05-26 17:50:50.075391 2025-05-26 17:50:50.075902
2871 2025-05-25 5642.0 ... 2025-05-26 17:50:50.075391 2025-05-26 17:50:50.075902
2872 2025-05-26 5614.0 ... 2025-05-26 17:50:50.075391 2025-05-26 17:50:50.075902
[3 rows x 5 columns]
2025-05-26 17:50:50,103 - IOOppi_data - INFO : save diff data to db: IOOppi_SM_t: no diff data
2025-05-26 17:50:50,109 - IOOppi_data - INFO : save data to db IOOppi_SM_g data:
date value
2868 2025-05-22 5652.0
2869 2025-05-23 5642.0
2870 2025-05-24 5642.0
2871 2025-05-25 5642.0
2872 2025-05-26 5614.0
2025-05-26 17:50:50,178 - IOOppi_data - INFO : save new data to db IOOppi_SM_g: date value ... created_at updated_at
2874 2025-05-24 5642.0 ... 2025-05-26 17:50:50.169423 2025-05-26 17:50:50.169838
2875 2025-05-25 5642.0 ... 2025-05-26 17:50:50.169423 2025-05-26 17:50:50.169838
2876 2025-05-26 5614.0 ... 2025-05-26 17:50:50.169423 2025-05-26 17:50:50.169838
[3 rows x 5 columns]
2025-05-26 17:50:50,198 - 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-05-26 17:50:50,856 - IOOppi_data - INFO : save data to db IOOppi_CY_t data:
date value
2143 2025-05-22 23775.0
2144 2025-05-23 23775.0
2145 2025-05-24 23775.0
2146 2025-05-25 23775.0
2147 2025-05-26 23775.0
2025-05-26 17:50:50,911 - IOOppi_data - INFO : save new data to db IOOppi_CY_t: date value ... created_at updated_at
2145 2025-05-24 23775.0 ... 2025-05-26 17:50:50.902176 2025-05-26 17:50:50.902577
2146 2025-05-25 23775.0 ... 2025-05-26 17:50:50.902176 2025-05-26 17:50:50.902577
2147 2025-05-26 23775.0 ... 2025-05-26 17:50:50.902176 2025-05-26 17:50:50.902577
[3 rows x 5 columns]
2025-05-26 17:50:50,931 - IOOppi_data - INFO : save diff data to db: IOOppi_CY_t: no diff data
2025-05-26 17:50:50,937 - IOOppi_data - INFO : save data to db IOOppi_CY_g data:
date value
2143 2025-05-22 23775.0
2144 2025-05-23 23775.0
2145 2025-05-24 23775.0
2146 2025-05-25 23775.0
2147 2025-05-26 23775.0
2025-05-26 17:50:50,992 - IOOppi_data - INFO : save new data to db IOOppi_CY_g: date value ... created_at updated_at
2149 2025-05-24 23775.0 ... 2025-05-26 17:50:50.983700 2025-05-26 17:50:50.984166
2150 2025-05-25 23775.0 ... 2025-05-26 17:50:50.983700 2025-05-26 17:50:50.984166
2151 2025-05-26 23775.0 ... 2025-05-26 17:50:50.983700 2025-05-26 17:50:50.984166
[3 rows x 5 columns]
2025-05-26 17:50:51,012 - 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-05-26 17:50:51,572 - IOOppi_data - INFO : save data to db IOOppi_UR_t data:
date value
1658 2025-05-22 1912.0
1659 2025-05-23 1912.0
1660 2025-05-24 1912.0
1661 2025-05-25 1912.0
1662 2025-05-26 1900.0
2025-05-26 17:50:51,620 - IOOppi_data - INFO : save new data to db IOOppi_UR_t: date value ... created_at updated_at
1660 2025-05-24 1912.0 ... 2025-05-26 17:50:51.612380 2025-05-26 17:50:51.612806
1661 2025-05-25 1912.0 ... 2025-05-26 17:50:51.612380 2025-05-26 17:50:51.612806
1662 2025-05-26 1900.0 ... 2025-05-26 17:50:51.612380 2025-05-26 17:50:51.612806
[3 rows x 5 columns]
2025-05-26 17:50:51,643 - IOOppi_data - INFO : save diff data to db: IOOppi_UR_t: no diff data
2025-05-26 17:50:51,649 - IOOppi_data - INFO : save data to db IOOppi_UR_g data:
date value
1658 2025-05-22 1912.0
1659 2025-05-23 1912.0
1660 2025-05-24 1912.0
1661 2025-05-25 1912.0
1662 2025-05-26 1900.0
2025-05-26 17:50:51,698 - IOOppi_data - INFO : save new data to db IOOppi_UR_g: date value ... created_at updated_at
1664 2025-05-24 1912.0 ... 2025-05-26 17:50:51.689210 2025-05-26 17:50:51.689608
1665 2025-05-25 1912.0 ... 2025-05-26 17:50:51.689210 2025-05-26 17:50:51.689608
1666 2025-05-26 1900.0 ... 2025-05-26 17:50:51.689210 2025-05-26 17:50:51.689608
[3 rows x 5 columns]
2025-05-26 17:50:51,718 - 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-05-26 17:50:52,334 - IOOppi_data - INFO : save data to db IOOppi_ni_t data:
date value
2730 2025-05-22 124633.33
2731 2025-05-23 124358.33
2732 2025-05-24 124358.33
2733 2025-05-25 124358.33
2734 2025-05-26 124200.00
2025-05-26 17:50:52,410 - IOOppi_data - INFO : save new data to db IOOppi_ni_t: date ... updated_at
2732 2025-05-24 ... 2025-05-26 17:50:52.399206
2733 2025-05-25 ... 2025-05-26 17:50:52.399206
2734 2025-05-26 ... 2025-05-26 17:50:52.399206
[3 rows x 5 columns]
2025-05-26 17:50:52,431 - IOOppi_data - INFO : save diff data to db: IOOppi_ni_t: no diff data
2025-05-26 17:50:52,438 - IOOppi_data - INFO : save data to db IOOppi_ni_g data:
date value
2730 2025-05-22 124633.33
2731 2025-05-23 124358.33
2732 2025-05-24 124358.33
2733 2025-05-25 124358.33
2734 2025-05-26 124200.00
2025-05-26 17:50:52,500 - IOOppi_data - INFO : save new data to db IOOppi_ni_g: date ... updated_at
2735 2025-05-24 ... 2025-05-26 17:50:52.493229
2736 2025-05-25 ... 2025-05-26 17:50:52.493229
2737 2025-05-26 ... 2025-05-26 17:50:52.493229
[3 rows x 5 columns]
2025-05-26 17:50:52,519 - 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-05-26 17:50:53,278 - IOOppi_data - INFO : save data to db IOOppi_v_t data:
date value
3755 2025-05-22 4701.0
3756 2025-05-23 4681.0
3757 2025-05-24 4681.0
3758 2025-05-25 4681.0
3759 2025-05-26 4673.0
2025-05-26 17:50:53,353 - IOOppi_data - INFO : save new data to db IOOppi_v_t: date value ... created_at updated_at
3757 2025-05-24 4681.0 ... 2025-05-26 17:50:53.344482 2025-05-26 17:50:53.344988
3758 2025-05-25 4681.0 ... 2025-05-26 17:50:53.344482 2025-05-26 17:50:53.344988
3759 2025-05-26 4673.0 ... 2025-05-26 17:50:53.344482 2025-05-26 17:50:53.344988
[3 rows x 5 columns]
2025-05-26 17:50:53,372 - IOOppi_data - INFO : save diff data to db: IOOppi_v_t: no diff data
2025-05-26 17:50:53,379 - IOOppi_data - INFO : save data to db IOOppi_v_g data:
date value
3755 2025-05-22 4701.0
3756 2025-05-23 4681.0
3757 2025-05-24 4681.0
3758 2025-05-25 4681.0
3759 2025-05-26 4673.0
2025-05-26 17:50:53,452 - IOOppi_data - INFO : save new data to db IOOppi_v_g: date value ... created_at updated_at
3760 2025-05-24 4681.0 ... 2025-05-26 17:50:53.444573 2025-05-26 17:50:53.445029
3761 2025-05-25 4681.0 ... 2025-05-26 17:50:53.444573 2025-05-26 17:50:53.445029
3762 2025-05-26 4673.0 ... 2025-05-26 17:50:53.444573 2025-05-26 17:50:53.445029
[3 rows x 5 columns]
2025-05-26 17:50:53,471 - 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-05-26 17:50:54,173 - IOOppi_data - INFO : save data to db IOOppi_pp_t data:
date value
2994 2025-05-22 7440.00
2995 2025-05-23 7426.67
2996 2025-05-24 7426.67
2997 2025-05-25 7426.67
2998 2025-05-26 7426.67
2025-05-26 17:50:54,235 - IOOppi_data - INFO : save new data to db IOOppi_pp_t: date value ... created_at updated_at
2996 2025-05-24 7426.67 ... 2025-05-26 17:50:54.228031 2025-05-26 17:50:54.228413
2997 2025-05-25 7426.67 ... 2025-05-26 17:50:54.228031 2025-05-26 17:50:54.228413
2998 2025-05-26 7426.67 ... 2025-05-26 17:50:54.228031 2025-05-26 17:50:54.228413
[3 rows x 5 columns]
2025-05-26 17:50:54,254 - IOOppi_data - INFO : save diff data to db: IOOppi_pp_t: no diff data
2025-05-26 17:50:54,260 - IOOppi_data - INFO : save data to db IOOppi_pp_g data:
date value
2994 2025-05-22 7440.00
2995 2025-05-23 7426.67
2996 2025-05-24 7426.67
2997 2025-05-25 7426.67
2998 2025-05-26 7426.67
2025-05-26 17:50:54,323 - IOOppi_data - INFO : save new data to db IOOppi_pp_g: date value ... created_at updated_at
2999 2025-05-24 7426.67 ... 2025-05-26 17:50:54.315712 2025-05-26 17:50:54.316114
3000 2025-05-25 7426.67 ... 2025-05-26 17:50:54.315712 2025-05-26 17:50:54.316114
3001 2025-05-26 7426.67 ... 2025-05-26 17:50:54.315712 2025-05-26 17:50:54.316114
[3 rows x 5 columns]
2025-05-26 17:50:54,342 - 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-05-26 17:50:54,918 - IOOppi_data - INFO : save data to db IOOppi_CF_t data:
date value
3756 2025-05-22 14614.33
3757 2025-05-23 14604.00
3758 2025-05-24 14604.00
3759 2025-05-25 14604.00
3760 2025-05-26 14605.00
2025-05-26 17:50:55,001 - IOOppi_data - INFO : save new data to db IOOppi_CF_t: date value ... created_at updated_at
3758 2025-05-24 14604.0 ... 2025-05-26 17:50:54.993311 2025-05-26 17:50:54.993930
3759 2025-05-25 14604.0 ... 2025-05-26 17:50:54.993311 2025-05-26 17:50:54.993930
3760 2025-05-26 14605.0 ... 2025-05-26 17:50:54.993311 2025-05-26 17:50:54.993930
[3 rows x 5 columns]
2025-05-26 17:50:55,021 - IOOppi_data - INFO : save diff data to db: IOOppi_CF_t: no diff data
2025-05-26 17:50:55,027 - IOOppi_data - INFO : save data to db IOOppi_CF_g data:
date value
3756 2025-05-22 14614.33
3757 2025-05-23 14604.00
3758 2025-05-24 14604.00
3759 2025-05-25 14604.00
3760 2025-05-26 14605.00
2025-05-26 17:50:55,100 - IOOppi_data - INFO : save new data to db IOOppi_CF_g: date value ... created_at updated_at
3762 2025-05-24 14604.0 ... 2025-05-26 17:50:55.092773 2025-05-26 17:50:55.093164
3763 2025-05-25 14604.0 ... 2025-05-26 17:50:55.092773 2025-05-26 17:50:55.093164
3764 2025-05-26 14605.0 ... 2025-05-26 17:50:55.092773 2025-05-26 17:50:55.093164
[3 rows x 5 columns]
2025-05-26 17:50:55,120 - 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-05-26 17:50:55,724 - IOOppi_data - INFO : save data to db IOOppi_pb_t data:
date value
3701 2025-05-22 16731.25
3702 2025-05-23 16743.75
3703 2025-05-24 16743.75
3704 2025-05-25 16743.75
3705 2025-05-26 16768.75
2025-05-26 17:50:55,795 - IOOppi_data - INFO : save new data to db IOOppi_pb_t: date ... updated_at
3703 2025-05-24 ... 2025-05-26 17:50:55.788824
3704 2025-05-25 ... 2025-05-26 17:50:55.788824
3705 2025-05-26 ... 2025-05-26 17:50:55.788824
[3 rows x 5 columns]
2025-05-26 17:50:55,814 - IOOppi_data - INFO : save diff data to db: IOOppi_pb_t: no diff data
2025-05-26 17:50:55,820 - IOOppi_data - INFO : save data to db IOOppi_pb_g data:
date value
3701 2025-05-22 16731.25
3702 2025-05-23 16743.75
3703 2025-05-24 16743.75
3704 2025-05-25 16743.75
3705 2025-05-26 16768.75
2025-05-26 17:50:55,894 - IOOppi_data - INFO : save new data to db IOOppi_pb_g: date ... updated_at
3706 2025-05-24 ... 2025-05-26 17:50:55.887582
3707 2025-05-25 ... 2025-05-26 17:50:55.887582
3708 2025-05-26 ... 2025-05-26 17:50:55.887582
[3 rows x 5 columns]
2025-05-26 17:50:55,913 - 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-05-26 17:50:56,459 - IOOppi_data - INFO : save data to db IOOppi_hc_t data:
date value
2976 2025-05-22 3283.33
2977 2025-05-23 3266.67
2978 2025-05-24 3266.67
2979 2025-05-25 3266.67
2980 2025-05-26 3256.67
2025-05-26 17:50:56,593 - IOOppi_data - INFO : save new data to db IOOppi_hc_t: date value ... created_at updated_at
2978 2025-05-24 3266.67 ... 2025-05-26 17:50:56.585874 2025-05-26 17:50:56.586265
2979 2025-05-25 3266.67 ... 2025-05-26 17:50:56.585874 2025-05-26 17:50:56.586265
2980 2025-05-26 3256.67 ... 2025-05-26 17:50:56.585874 2025-05-26 17:50:56.586265
[3 rows x 5 columns]
2025-05-26 17:50:56,612 - IOOppi_data - INFO : save diff data to db: IOOppi_hc_t: no diff data
2025-05-26 17:50:56,618 - IOOppi_data - INFO : save data to db IOOppi_hc_g data:
date value
2976 2025-05-22 3283.33
2977 2025-05-23 3266.67
2978 2025-05-24 3266.67
2979 2025-05-25 3266.67
2980 2025-05-26 3256.67
2025-05-26 17:50:56,680 - IOOppi_data - INFO : save new data to db IOOppi_hc_g: date value ... created_at updated_at
2981 2025-05-24 3266.67 ... 2025-05-26 17:50:56.673009 2025-05-26 17:50:56.673396
2982 2025-05-25 3266.67 ... 2025-05-26 17:50:56.673009 2025-05-26 17:50:56.673396
2983 2025-05-26 3256.67 ... 2025-05-26 17:50:56.673009 2025-05-26 17:50:56.673396
[3 rows x 5 columns]
2025-05-26 17:50:56,699 - 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-05-26 17:50:57,263 - IOOppi_data - INFO : save data to db IOOppi_fu_t data:
date value
3256 2025-05-22 5437.5
3257 2025-05-23 5337.5
3258 2025-05-24 5337.5
3259 2025-05-25 5337.5
3260 2025-05-26 5325.0
2025-05-26 17:50:57,341 - IOOppi_data - INFO : save new data to db IOOppi_fu_t: date value ... created_at updated_at
3258 2025-05-24 5337.5 ... 2025-05-26 17:50:57.332339 2025-05-26 17:50:57.332911
3259 2025-05-25 5337.5 ... 2025-05-26 17:50:57.332339 2025-05-26 17:50:57.332911
3260 2025-05-26 5325.0 ... 2025-05-26 17:50:57.332339 2025-05-26 17:50:57.332911
[3 rows x 5 columns]
2025-05-26 17:50:57,361 - IOOppi_data - INFO : save diff data to db: IOOppi_fu_t: no diff data
2025-05-26 17:50:57,367 - IOOppi_data - INFO : save data to db IOOppi_fu_g data:
date value
3256 2025-05-22 5437.5
3257 2025-05-23 5337.5
3258 2025-05-24 5337.5
3259 2025-05-25 5337.5
3260 2025-05-26 5325.0
2025-05-26 17:50:57,442 - IOOppi_data - INFO : save new data to db IOOppi_fu_g: date value ... created_at updated_at
3745 2025-05-24 5337.5 ... 2025-05-26 17:50:57.434177 2025-05-26 17:50:57.434657
3746 2025-05-25 5337.5 ... 2025-05-26 17:50:57.434177 2025-05-26 17:50:57.434657
3747 2025-05-26 5325.0 ... 2025-05-26 17:50:57.434177 2025-05-26 17:50:57.434657
[3 rows x 5 columns]
2025-05-26 17:50:57,462 - 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-05-26 17:50:58,216 - IOOppi_data - INFO : save data to db IOOppi_lh_t data:
date value
1320 2025-05-22 14570.0
1321 2025-05-23 14530.0
1322 2025-05-24 14530.0
1323 2025-05-25 14530.0
1324 2025-05-26 14520.0
2025-05-26 17:50:58,258 - IOOppi_data - INFO : save new data to db IOOppi_lh_t: date value ... created_at updated_at
1322 2025-05-24 14530.0 ... 2025-05-26 17:50:58.250806 2025-05-26 17:50:58.251195
1323 2025-05-25 14530.0 ... 2025-05-26 17:50:58.250806 2025-05-26 17:50:58.251195
1324 2025-05-26 14520.0 ... 2025-05-26 17:50:58.250806 2025-05-26 17:50:58.251195
[3 rows x 5 columns]
/root/project/IOOppi_data/IOOppi_request.py:308: SettingWithCopyWarning:
A value is trying to be set on a copy of a slice from a DataFrame.
Try using .loc[row_indexer,col_indexer] = value instead
See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy
diff_df.loc[:, 'index_code'] = index_code
/root/project/IOOppi_data/IOOppi_request.py:309: SettingWithCopyWarning:
A value is trying to be set on a copy of a slice from a DataFrame.
Try using .loc[row_indexer,col_indexer] = value instead
See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy
diff_df.loc[:, 'created_at'] = datetime.datetime.now()
/root/project/IOOppi_data/IOOppi_request.py:310: SettingWithCopyWarning:
A value is trying to be set on a copy of a slice from a DataFrame.
Try using .loc[row_indexer,col_indexer] = value instead
See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy
diff_df.loc[:, 'updated_at'] = datetime.datetime.now()
2025-05-26 17:50:58,499 - IOOppi_data - INFO : save diff data to db IOOppi_lh_t: date ... updated_at
116 2021-07-05 ... 2025-05-26 17:50:58.491230
117 2021-07-06 ... 2025-05-26 17:50:58.491230
121 2021-07-12 ... 2025-05-26 17:50:58.491230
122 2021-07-13 ... 2025-05-26 17:50:58.491230
194 2021-11-01 ... 2025-05-26 17:50:58.491230
[5 rows x 6 columns]
2025-05-26 17:50:58,536 - IOOppi_data - INFO : save data to db IOOppi_lh_g data:
date value
1320 2025-05-22 14570.0
1321 2025-05-23 14530.0
1322 2025-05-24 14530.0
1323 2025-05-25 14530.0
1324 2025-05-26 14520.0
2025-05-26 17:50:58,578 - IOOppi_data - INFO : save new data to db IOOppi_lh_g: date value ... created_at updated_at
1325 2025-05-24 14530.0 ... 2025-05-26 17:50:58.570871 2025-05-26 17:50:58.571253
1326 2025-05-25 14530.0 ... 2025-05-26 17:50:58.570871 2025-05-26 17:50:58.571253
1327 2025-05-26 14520.0 ... 2025-05-26 17:50:58.570871 2025-05-26 17:50:58.571253
[3 rows x 5 columns]
/root/project/IOOppi_data/IOOppi_request.py:308: SettingWithCopyWarning:
A value is trying to be set on a copy of a slice from a DataFrame.
Try using .loc[row_indexer,col_indexer] = value instead
See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy
diff_df.loc[:, 'index_code'] = index_code
/root/project/IOOppi_data/IOOppi_request.py:309: SettingWithCopyWarning:
A value is trying to be set on a copy of a slice from a DataFrame.
Try using .loc[row_indexer,col_indexer] = value instead
See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy
diff_df.loc[:, 'created_at'] = datetime.datetime.now()
/root/project/IOOppi_data/IOOppi_request.py:310: SettingWithCopyWarning:
A value is trying to be set on a copy of a slice from a DataFrame.
Try using .loc[row_indexer,col_indexer] = value instead
See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy
diff_df.loc[:, 'updated_at'] = datetime.datetime.now()
2025-05-26 17:50:58,818 - IOOppi_data - INFO : save diff data to db IOOppi_lh_g: date ... updated_at
116 2021-07-05 ... 2025-05-26 17:50:58.810432
117 2021-07-06 ... 2025-05-26 17:50:58.810432
121 2021-07-12 ... 2025-05-26 17:50:58.810432
122 2021-07-13 ... 2025-05-26 17:50:58.810432
194 2021-11-01 ... 2025-05-26 17:50:58.810432
[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-05-26 17:50:59,483 - IOOppi_data - INFO : save data to db IOOppi_cu_t data:
date value
3752 2025-05-22 78143.33
3753 2025-05-23 78110.00
3754 2025-05-24 78110.00
3755 2025-05-25 78110.00
3756 2025-05-26 78588.33
2025-05-26 17:50:59,559 - IOOppi_data - INFO : save new data to db IOOppi_cu_t: date ... updated_at
3754 2025-05-24 ... 2025-05-26 17:50:59.550064
3755 2025-05-25 ... 2025-05-26 17:50:59.550064
3756 2025-05-26 ... 2025-05-26 17:50:59.550064
[3 rows x 5 columns]
2025-05-26 17:50:59,580 - IOOppi_data - INFO : save diff data to db: IOOppi_cu_t: no diff data
2025-05-26 17:50:59,586 - IOOppi_data - INFO : save data to db IOOppi_cu_g data:
date value
3752 2025-05-22 78143.33
3753 2025-05-23 78110.00
3754 2025-05-24 78110.00
3755 2025-05-25 78110.00
3756 2025-05-26 78588.33
2025-05-26 17:50:59,659 - IOOppi_data - INFO : save new data to db IOOppi_cu_g: date ... updated_at
3757 2025-05-24 ... 2025-05-26 17:50:59.652856
3758 2025-05-25 ... 2025-05-26 17:50:59.652856
3759 2025-05-26 ... 2025-05-26 17:50:59.652856
[3 rows x 5 columns]
2025-05-26 17:50:59,678 - 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-05-26 17:51:00,239 - 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-05-26 17:51:00,292 - IOOppi_data - INFO : save new data to db: IOOppi_PM_t: no new data
2025-05-26 17:51:00,293 - IOOppi_data - INFO : save diff data to db: IOOppi_PM_t: no diff data
2025-05-26 17:51:00,298 - 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-05-26 17:51:00,358 - IOOppi_data - INFO : save new data to db: IOOppi_PM_g: no new data
2025-05-26 17:51:00,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-05-26 17:51:01,032 - IOOppi_data - INFO : save data to db IOOppi_sn_t data:
date value
2730 2025-05-22 265400.0
2731 2025-05-23 265337.5
2732 2025-05-24 265337.5
2733 2025-05-25 265337.5
2734 2025-05-26 264400.0
2025-05-26 17:51:01,109 - IOOppi_data - INFO : save new data to db IOOppi_sn_t: date ... updated_at
2732 2025-05-24 ... 2025-05-26 17:51:01.102458
2733 2025-05-25 ... 2025-05-26 17:51:01.102458
2734 2025-05-26 ... 2025-05-26 17:51:01.102458
[3 rows x 5 columns]
2025-05-26 17:51:01,130 - IOOppi_data - INFO : save diff data to db: IOOppi_sn_t: no diff data
2025-05-26 17:51:01,136 - IOOppi_data - INFO : save data to db IOOppi_sn_g data:
date value
2730 2025-05-22 265400.0
2731 2025-05-23 265337.5
2732 2025-05-24 265337.5
2733 2025-05-25 265337.5
2734 2025-05-26 264400.0
2025-05-26 17:51:01,196 - IOOppi_data - INFO : save new data to db IOOppi_sn_g: date ... updated_at
2735 2025-05-24 ... 2025-05-26 17:51:01.190039
2736 2025-05-25 ... 2025-05-26 17:51:01.190039
2737 2025-05-26 ... 2025-05-26 17:51:01.190039
[3 rows x 5 columns]
2025-05-26 17:51:01,217 - 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-05-26 17:51:01,780 - IOOppi_data - INFO : save data to db IOOppi_zn_t data:
date value
3751 2025-05-22 22634.0
3752 2025-05-23 22692.0
3753 2025-05-24 22692.0
3754 2025-05-25 22692.0
3755 2025-05-26 22556.0
2025-05-26 17:51:01,854 - IOOppi_data - INFO : save new data to db IOOppi_zn_t: date value ... created_at updated_at
3753 2025-05-24 22692.0 ... 2025-05-26 17:51:01.846447 2025-05-26 17:51:01.846881
3754 2025-05-25 22692.0 ... 2025-05-26 17:51:01.846447 2025-05-26 17:51:01.846881
3755 2025-05-26 22556.0 ... 2025-05-26 17:51:01.846447 2025-05-26 17:51:01.846881
[3 rows x 5 columns]
2025-05-26 17:51:01,874 - IOOppi_data - INFO : save diff data to db: IOOppi_zn_t: no diff data
2025-05-26 17:51:01,885 - IOOppi_data - INFO : save data to db IOOppi_zn_g data:
date value
3751 2025-05-22 22634.0
3752 2025-05-23 22692.0
3753 2025-05-24 22692.0
3754 2025-05-25 22692.0
3755 2025-05-26 22556.0
2025-05-26 17:51:01,987 - IOOppi_data - INFO : save new data to db IOOppi_zn_g: date value ... created_at updated_at
3756 2025-05-24 22692.0 ... 2025-05-26 17:51:01.980053 2025-05-26 17:51:01.980444
3757 2025-05-25 22692.0 ... 2025-05-26 17:51:01.980053 2025-05-26 17:51:01.980444
3758 2025-05-26 22556.0 ... 2025-05-26 17:51:01.980053 2025-05-26 17:51:01.980444
[3 rows x 5 columns]
2025-05-26 17:51:02,008 - 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-05-26 17:51:02,587 - IOOppi_data - INFO : save data to db IOOppi_wr_t data:
date value
3714 2025-05-22 3327.5
3715 2025-05-23 3327.5
3716 2025-05-24 3327.5
3717 2025-05-25 3327.5
3718 2025-05-26 3295.0
2025-05-26 17:51:02,664 - IOOppi_data - INFO : save new data to db IOOppi_wr_t: date value ... created_at updated_at
3716 2025-05-24 3327.5 ... 2025-05-26 17:51:02.655229 2025-05-26 17:51:02.655714
3717 2025-05-25 3327.5 ... 2025-05-26 17:51:02.655229 2025-05-26 17:51:02.655714
3718 2025-05-26 3295.0 ... 2025-05-26 17:51:02.655229 2025-05-26 17:51:02.655714
[3 rows x 5 columns]
2025-05-26 17:51:02,684 - IOOppi_data - INFO : save diff data to db: IOOppi_wr_t: no diff data
2025-05-26 17:51:02,691 - IOOppi_data - INFO : save data to db IOOppi_wr_g data:
date value
3714 2025-05-22 3327.5
3715 2025-05-23 3327.5
3716 2025-05-24 3327.5
3717 2025-05-25 3327.5
3718 2025-05-26 3295.0
2025-05-26 17:51:02,766 - IOOppi_data - INFO : save new data to db IOOppi_wr_g: date value ... created_at updated_at
3719 2025-05-24 3327.5 ... 2025-05-26 17:51:02.758568 2025-05-26 17:51:02.758994
3720 2025-05-25 3327.5 ... 2025-05-26 17:51:02.758568 2025-05-26 17:51:02.758994
3721 2025-05-26 3295.0 ... 2025-05-26 17:51:02.758568 2025-05-26 17:51:02.758994
[3 rows x 5 columns]
2025-05-26 17:51:02,785 - 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-05-26 17:51:03,496 - IOOppi_data - INFO : save data to db IOOppi_pg_t data:
date value
1511 2025-05-22 4742.5
1512 2025-05-23 4742.5
1513 2025-05-24 4742.5
1514 2025-05-25 4742.5
1515 2025-05-26 4730.0
2025-05-26 17:51:03,541 - IOOppi_data - INFO : save new data to db IOOppi_pg_t: date value ... created_at updated_at
1513 2025-05-24 4742.5 ... 2025-05-26 17:51:03.533726 2025-05-26 17:51:03.534144
1514 2025-05-25 4742.5 ... 2025-05-26 17:51:03.533726 2025-05-26 17:51:03.534144
1515 2025-05-26 4730.0 ... 2025-05-26 17:51:03.533726 2025-05-26 17:51:03.534144
[3 rows x 5 columns]
2025-05-26 17:51:03,560 - IOOppi_data - INFO : save diff data to db: IOOppi_pg_t: no diff data
2025-05-26 17:51:03,566 - IOOppi_data - INFO : save data to db IOOppi_pg_g data:
date value
1511 2025-05-22 4742.5
1512 2025-05-23 4742.5
1513 2025-05-24 4742.5
1514 2025-05-25 4742.5
1515 2025-05-26 4730.0
2025-05-26 17:51:03,613 - IOOppi_data - INFO : save new data to db IOOppi_pg_g: date value ... created_at updated_at
1516 2025-05-24 4742.5 ... 2025-05-26 17:51:03.606085 2025-05-26 17:51:03.606491
1517 2025-05-25 4742.5 ... 2025-05-26 17:51:03.606085 2025-05-26 17:51:03.606491
1518 2025-05-26 4730.0 ... 2025-05-26 17:51:03.606085 2025-05-26 17:51:03.606491
[3 rows x 5 columns]
2025-05-26 17:51:03,633 - 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-05-26 17:51:04,223 - IOOppi_data - INFO : save data to db IOOppi_cs_t data:
date value
2785 2025-05-22 2295.71
2786 2025-05-23 2295.71
2787 2025-05-24 2295.71
2788 2025-05-25 2295.71
2789 2025-05-26 2295.71
2025-05-26 17:51:04,285 - IOOppi_data - INFO : save new data to db IOOppi_cs_t: date value ... created_at updated_at
2787 2025-05-24 2295.71 ... 2025-05-26 17:51:04.277371 2025-05-26 17:51:04.277776
2788 2025-05-25 2295.71 ... 2025-05-26 17:51:04.277371 2025-05-26 17:51:04.277776
2789 2025-05-26 2295.71 ... 2025-05-26 17:51:04.277371 2025-05-26 17:51:04.277776
[3 rows x 5 columns]
/root/project/IOOppi_data/IOOppi_request.py:308: SettingWithCopyWarning:
A value is trying to be set on a copy of a slice from a DataFrame.
Try using .loc[row_indexer,col_indexer] = value instead
See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy
diff_df.loc[:, 'index_code'] = index_code
/root/project/IOOppi_data/IOOppi_request.py:309: SettingWithCopyWarning:
A value is trying to be set on a copy of a slice from a DataFrame.
Try using .loc[row_indexer,col_indexer] = value instead
See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy
diff_df.loc[:, 'created_at'] = datetime.datetime.now()
/root/project/IOOppi_data/IOOppi_request.py:310: SettingWithCopyWarning:
A value is trying to be set on a copy of a slice from a DataFrame.
Try using .loc[row_indexer,col_indexer] = value instead
See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy
diff_df.loc[:, 'updated_at'] = datetime.datetime.now()
2025-05-26 17:51:04,327 - IOOppi_data - INFO : save diff data to db IOOppi_cs_t: date ... updated_at
2786 2025-05-23 ... 2025-05-26 17:51:04.319639
[1 rows x 6 columns]
2025-05-26 17:51:04,351 - IOOppi_data - INFO : save data to db IOOppi_cs_g data:
date value
2785 2025-05-22 2295.71
2786 2025-05-23 2295.71
2787 2025-05-24 2295.71
2788 2025-05-25 2295.71
2789 2025-05-26 2295.71
2025-05-26 17:51:04,412 - IOOppi_data - INFO : save new data to db IOOppi_cs_g: date value ... created_at updated_at
2790 2025-05-24 2295.71 ... 2025-05-26 17:51:04.405447 2025-05-26 17:51:04.405842
2791 2025-05-25 2295.71 ... 2025-05-26 17:51:04.405447 2025-05-26 17:51:04.405842
2792 2025-05-26 2295.71 ... 2025-05-26 17:51:04.405447 2025-05-26 17:51:04.405842
[3 rows x 5 columns]
/root/project/IOOppi_data/IOOppi_request.py:308: SettingWithCopyWarning:
A value is trying to be set on a copy of a slice from a DataFrame.
Try using .loc[row_indexer,col_indexer] = value instead
See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy
diff_df.loc[:, 'index_code'] = index_code
/root/project/IOOppi_data/IOOppi_request.py:309: SettingWithCopyWarning:
A value is trying to be set on a copy of a slice from a DataFrame.
Try using .loc[row_indexer,col_indexer] = value instead
See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy
diff_df.loc[:, 'created_at'] = datetime.datetime.now()
/root/project/IOOppi_data/IOOppi_request.py:310: SettingWithCopyWarning:
A value is trying to be set on a copy of a slice from a DataFrame.
Try using .loc[row_indexer,col_indexer] = value instead
See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy
diff_df.loc[:, 'updated_at'] = datetime.datetime.now()
2025-05-26 17:51:04,454 - IOOppi_data - INFO : save diff data to db IOOppi_cs_g: date ... updated_at
2789 2025-05-23 ... 2025-05-26 17:51:04.447320
[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-05-26 17:51:05,047 - IOOppi_data - INFO : save data to db IOOppi_cs_t data:
date value
2785 2025-05-22 2295.71
2786 2025-05-23 2295.71
2787 2025-05-24 2295.71
2788 2025-05-25 2295.71
2789 2025-05-26 2912.00
2025-05-26 17:51:05,100 - 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-05-26 17:51:05,125 - IOOppi_data - INFO : save diff data to db IOOppi_cs_t: date ... updated_at
2789 2025-05-26 ... 2025-05-26 17:51:05.117991
[1 rows x 6 columns]
2025-05-26 17:51:05,151 - IOOppi_data - INFO : save data to db IOOppi_cs_g data:
date value
2785 2025-05-22 2295.71
2786 2025-05-23 2295.71
2787 2025-05-24 2295.71
2788 2025-05-25 2295.71
2789 2025-05-26 2912.00
2025-05-26 17:51:05,204 - 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-05-26 17:51:05,228 - IOOppi_data - INFO : save diff data to db IOOppi_cs_g: date ... updated_at
2792 2025-05-26 ... 2025-05-26 17:51:05.220950
[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-05-26 17:51:05,736 - IOOppi_data - INFO : save data to db IOOppi_RS_t data:
date value
3142 2025-05-22 9541.67
3143 2025-05-23 9513.33
3144 2025-05-24 9513.33
3145 2025-05-25 9513.33
3146 2025-05-26 9493.33
2025-05-26 17:51:05,792 - IOOppi_data - INFO : save new data to db: IOOppi_RS_t: no new data
2025-05-26 17:51:05,792 - IOOppi_data - INFO : save diff data to db: IOOppi_RS_t: no diff data
2025-05-26 17:51:05,797 - IOOppi_data - INFO : save data to db IOOppi_RS_g data:
date value
3142 2025-05-22 9541.67
3143 2025-05-23 9513.33
3144 2025-05-24 9513.33
3145 2025-05-25 9513.33
3146 2025-05-26 9493.33
2025-05-26 17:51:05,855 - IOOppi_data - INFO : save new data to db: IOOppi_RS_g: no new data
2025-05-26 17:51:05,855 - 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-05-26 17:51:06,408 - IOOppi_data - INFO : save data to db IOOppi_eg_t data:
date value
1826 2025-05-22 4543.33
1827 2025-05-23 4543.33
1828 2025-05-24 4543.33
1829 2025-05-25 4543.33
1830 2025-05-26 4548.33
2025-05-26 17:51:06,456 - IOOppi_data - INFO : save new data to db IOOppi_eg_t: date value ... created_at updated_at
1828 2025-05-24 4543.33 ... 2025-05-26 17:51:06.449169 2025-05-26 17:51:06.449550
1829 2025-05-25 4543.33 ... 2025-05-26 17:51:06.449169 2025-05-26 17:51:06.449550
1830 2025-05-26 4548.33 ... 2025-05-26 17:51:06.449169 2025-05-26 17:51:06.449550
[3 rows x 5 columns]
2025-05-26 17:51:06,476 - IOOppi_data - INFO : save diff data to db: IOOppi_eg_t: no diff data
2025-05-26 17:51:06,481 - IOOppi_data - INFO : save data to db IOOppi_eg_g data:
date value
1826 2025-05-22 4543.33
1827 2025-05-23 4543.33
1828 2025-05-24 4543.33
1829 2025-05-25 4543.33
1830 2025-05-26 4548.33
2025-05-26 17:51:06,530 - IOOppi_data - INFO : save new data to db IOOppi_eg_g: date value ... created_at updated_at
1831 2025-05-24 4543.33 ... 2025-05-26 17:51:06.522739 2025-05-26 17:51:06.523153
1832 2025-05-25 4543.33 ... 2025-05-26 17:51:06.522739 2025-05-26 17:51:06.523153
1833 2025-05-26 4548.33 ... 2025-05-26 17:51:06.522739 2025-05-26 17:51:06.523153
[3 rows x 5 columns]
2025-05-26 17:51:06,549 - 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-05-26 17:51:07,069 - IOOppi_data - INFO : save data to db IOOppi_sp_t data:
date value
1835 2025-05-22 6300.0
1836 2025-05-23 6300.0
1837 2025-05-24 6300.0
1838 2025-05-25 6300.0
1839 2025-05-26 6300.0
2025-05-26 17:51:07,127 - IOOppi_data - INFO : save new data to db IOOppi_sp_t: date value ... created_at updated_at
1837 2025-05-24 6300.0 ... 2025-05-26 17:51:07.120143 2025-05-26 17:51:07.120519
1838 2025-05-25 6300.0 ... 2025-05-26 17:51:07.120143 2025-05-26 17:51:07.120519
1839 2025-05-26 6300.0 ... 2025-05-26 17:51:07.120143 2025-05-26 17:51:07.120519
[3 rows x 5 columns]
2025-05-26 17:51:07,146 - IOOppi_data - INFO : save diff data to db: IOOppi_sp_t: no diff data
2025-05-26 17:51:07,152 - IOOppi_data - INFO : save data to db IOOppi_sp_g data:
date value
1835 2025-05-22 6300.0
1836 2025-05-23 6300.0
1837 2025-05-24 6300.0
1838 2025-05-25 6300.0
1839 2025-05-26 6300.0
2025-05-26 17:51:07,201 - IOOppi_data - INFO : save new data to db IOOppi_sp_g: date value ... created_at updated_at
1840 2025-05-24 6300.0 ... 2025-05-26 17:51:07.193675 2025-05-26 17:51:07.194094
1841 2025-05-25 6300.0 ... 2025-05-26 17:51:07.193675 2025-05-26 17:51:07.194094
1842 2025-05-26 6300.0 ... 2025-05-26 17:51:07.193675 2025-05-26 17:51:07.194094
[3 rows x 5 columns]
2025-05-26 17:51:07,219 - 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-05-26 17:51:07,780 - IOOppi_data - INFO : save data to db IOOppi_p_t data:
date value
3503 2025-05-22 8546.0
3504 2025-05-23 8510.0
3505 2025-05-24 8510.0
3506 2025-05-25 8510.0
3507 2025-05-26 8468.0
2025-05-26 17:51:07,849 - IOOppi_data - INFO : save new data to db IOOppi_p_t: date value ... created_at updated_at
3505 2025-05-24 8510.0 ... 2025-05-26 17:51:07.842367 2025-05-26 17:51:07.842773
3506 2025-05-25 8510.0 ... 2025-05-26 17:51:07.842367 2025-05-26 17:51:07.842773
3507 2025-05-26 8468.0 ... 2025-05-26 17:51:07.842367 2025-05-26 17:51:07.842773
[3 rows x 5 columns]
2025-05-26 17:51:07,869 - IOOppi_data - INFO : save diff data to db: IOOppi_p_t: no diff data
2025-05-26 17:51:07,875 - IOOppi_data - INFO : save data to db IOOppi_p_g data:
date value
3503 2025-05-22 8546.0
3504 2025-05-23 8510.0
3505 2025-05-24 8510.0
3506 2025-05-25 8510.0
3507 2025-05-26 8468.0
2025-05-26 17:51:07,946 - IOOppi_data - INFO : save new data to db IOOppi_p_g: date value ... created_at updated_at
3508 2025-05-24 8510.0 ... 2025-05-26 17:51:07.937919 2025-05-26 17:51:07.938381
3509 2025-05-25 8510.0 ... 2025-05-26 17:51:07.937919 2025-05-26 17:51:07.938381
3510 2025-05-26 8468.0 ... 2025-05-26 17:51:07.937919 2025-05-26 17:51:07.938381
[3 rows x 5 columns]
2025-05-26 17:51:07,967 - IOOppi_data - INFO : save diff data to db: IOOppi_p_g: no diff data