=========================================================================
2025-06-23 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-06-23 17:50:28,692 - IOOppi_data - INFO : save data to db IOOppi_rb_t data:
date value
3339 2025-06-19 3062.33
3340 2025-06-20 3072.67
3341 2025-06-21 3072.67
3342 2025-06-22 3072.67
3343 2025-06-23 3071.00
2025-06-23 17:50:28,771 - IOOppi_data - INFO : save new data to db IOOppi_rb_t: date value ... created_at updated_at
3341 2025-06-21 3072.67 ... 2025-06-23 17:50:28.764081 2025-06-23 17:50:28.764497
3342 2025-06-22 3072.67 ... 2025-06-23 17:50:28.764081 2025-06-23 17:50:28.764497
3343 2025-06-23 3071.00 ... 2025-06-23 17:50:28.764081 2025-06-23 17:50:28.764497
[3 rows x 5 columns]
2025-06-23 17:50:28,803 - IOOppi_data - INFO : save diff data to db: IOOppi_rb_t: no diff data
2025-06-23 17:50:28,809 - IOOppi_data - INFO : save data to db IOOppi_rb_g data:
date value
3339 2025-06-19 3062.33
3340 2025-06-20 3072.67
3341 2025-06-21 3072.67
3342 2025-06-22 3072.67
3343 2025-06-23 3071.00
2025-06-23 17:50:28,885 - IOOppi_data - INFO : save new data to db IOOppi_rb_g: date value ... created_at updated_at
3344 2025-06-21 3072.67 ... 2025-06-23 17:50:28.878050 2025-06-23 17:50:28.878485
3345 2025-06-22 3072.67 ... 2025-06-23 17:50:28.878050 2025-06-23 17:50:28.878485
3346 2025-06-23 3071.00 ... 2025-06-23 17:50:28.878050 2025-06-23 17:50:28.878485
[3 rows x 5 columns]
2025-06-23 17:50:28,906 - 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-06-23 17:50:29,476 - IOOppi_data - INFO : save data to db IOOppi_MA_t data:
date value
3560 2025-06-19 2764.00
3561 2025-06-20 2747.50
3562 2025-06-21 2747.50
3563 2025-06-22 2747.50
3564 2025-06-23 2719.83
2025-06-23 17:50:29,558 - IOOppi_data - INFO : save new data to db IOOppi_MA_t: date value ... created_at updated_at
3562 2025-06-21 2747.50 ... 2025-06-23 17:50:29.550840 2025-06-23 17:50:29.551305
3563 2025-06-22 2747.50 ... 2025-06-23 17:50:29.550840 2025-06-23 17:50:29.551305
3564 2025-06-23 2719.83 ... 2025-06-23 17:50:29.550840 2025-06-23 17:50:29.551305
[3 rows x 5 columns]
2025-06-23 17:50:29,578 - IOOppi_data - INFO : save diff data to db: IOOppi_MA_t: no diff data
2025-06-23 17:50:29,585 - IOOppi_data - INFO : save data to db IOOppi_MA_g data:
date value
3560 2025-06-19 2764.00
3561 2025-06-20 2747.50
3562 2025-06-21 2747.50
3563 2025-06-22 2747.50
3564 2025-06-23 2719.83
2025-06-23 17:50:29,662 - IOOppi_data - INFO : save new data to db IOOppi_MA_g: date value ... created_at updated_at
3566 2025-06-21 2747.50 ... 2025-06-23 17:50:29.654864 2025-06-23 17:50:29.655278
3567 2025-06-22 2747.50 ... 2025-06-23 17:50:29.654864 2025-06-23 17:50:29.655278
3568 2025-06-23 2719.83 ... 2025-06-23 17:50:29.654864 2025-06-23 17:50:29.655278
[3 rows x 5 columns]
2025-06-23 17:50:29,682 - 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-06-23 17:50:30,446 - IOOppi_data - INFO : save data to db IOOppi_PTA_t data:
date value
900 2025-06-19 5246.5
901 2025-06-20 5271.5
902 2025-06-21 5271.5
903 2025-06-22 5271.5
904 2025-06-23 5282.0
2025-06-23 17:50:30,488 - IOOppi_data - INFO : save new data to db IOOppi_PTA_t: date value ... created_at updated_at
902 2025-06-21 5271.5 ... 2025-06-23 17:50:30.480992 2025-06-23 17:50:30.481466
903 2025-06-22 5271.5 ... 2025-06-23 17:50:30.480992 2025-06-23 17:50:30.481466
904 2025-06-23 5282.0 ... 2025-06-23 17:50:30.480992 2025-06-23 17:50:30.481466
[3 rows x 5 columns]
2025-06-23 17:50:30,508 - IOOppi_data - INFO : save diff data to db: IOOppi_PTA_t: no diff data
2025-06-23 17:50:30,513 - IOOppi_data - INFO : save data to db IOOppi_PTA_g data:
date value
900 2025-06-19 5246.5
901 2025-06-20 5271.5
902 2025-06-21 5271.5
903 2025-06-22 5271.5
904 2025-06-23 5282.0
2025-06-23 17:50:30,556 - IOOppi_data - INFO : save new data to db IOOppi_PTA_g: date value ... created_at updated_at
902 2025-06-21 5271.5 ... 2025-06-23 17:50:30.549275 2025-06-23 17:50:30.549663
903 2025-06-22 5271.5 ... 2025-06-23 17:50:30.549275 2025-06-23 17:50:30.549663
904 2025-06-23 5282.0 ... 2025-06-23 17:50:30.549275 2025-06-23 17:50:30.549663
[3 rows x 5 columns]
2025-06-23 17:50:30,576 - 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-06-23 17:50:31,215 - IOOppi_data - INFO : save data to db IOOppi_ru_t data:
date value
3779 2025-06-19 13858.33
3780 2025-06-20 13758.33
3781 2025-06-21 13758.33
3782 2025-06-22 13758.33
3783 2025-06-23 13808.33
2025-06-23 17:50:31,298 - IOOppi_data - INFO : save new data to db IOOppi_ru_t: date ... updated_at
3781 2025-06-21 ... 2025-06-23 17:50:31.291873
3782 2025-06-22 ... 2025-06-23 17:50:31.291873
3783 2025-06-23 ... 2025-06-23 17:50:31.291873
[3 rows x 5 columns]
2025-06-23 17:50:31,321 - IOOppi_data - INFO : save diff data to db: IOOppi_ru_t: no diff data
2025-06-23 17:50:31,328 - IOOppi_data - INFO : save data to db IOOppi_ru_g data:
date value
3779 2025-06-19 13858.33
3780 2025-06-20 13758.33
3781 2025-06-21 13758.33
3782 2025-06-22 13758.33
3783 2025-06-23 13808.33
2025-06-23 17:50:31,406 - IOOppi_data - INFO : save new data to db IOOppi_ru_g: date ... updated_at
3784 2025-06-21 ... 2025-06-23 17:50:31.399739
3785 2025-06-22 ... 2025-06-23 17:50:31.399739
3786 2025-06-23 ... 2025-06-23 17:50:31.399739
[3 rows x 5 columns]
2025-06-23 17:50:31,426 - 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-06-23 17:50:31,960 - IOOppi_data - INFO : save data to db IOOppi_i_t data:
date value
3111 2025-06-19 722.56
3112 2025-06-20 724.67
3113 2025-06-21 724.44
3114 2025-06-22 724.44
3115 2025-06-23 727.44
2025-06-23 17:50:32,032 - IOOppi_data - INFO : save new data to db IOOppi_i_t: date value ... created_at updated_at
3113 2025-06-21 724.44 ... 2025-06-23 17:50:32.024553 2025-06-23 17:50:32.024980
3114 2025-06-22 724.44 ... 2025-06-23 17:50:32.024553 2025-06-23 17:50:32.024980
3115 2025-06-23 727.44 ... 2025-06-23 17:50:32.024553 2025-06-23 17:50:32.024980
[3 rows x 5 columns]
2025-06-23 17:50:32,053 - IOOppi_data - INFO : save diff data to db: IOOppi_i_t: no diff data
2025-06-23 17:50:32,059 - IOOppi_data - INFO : save data to db IOOppi_i_g data:
date value
3111 2025-06-19 722.56
3112 2025-06-20 724.67
3113 2025-06-21 724.44
3114 2025-06-22 724.44
3115 2025-06-23 727.44
2025-06-23 17:50:32,140 - IOOppi_data - INFO : save new data to db IOOppi_i_g: date value ... created_at updated_at
3116 2025-06-21 724.44 ... 2025-06-23 17:50:32.133460 2025-06-23 17:50:32.133870
3117 2025-06-22 724.44 ... 2025-06-23 17:50:32.133460 2025-06-23 17:50:32.133870
3118 2025-06-23 727.44 ... 2025-06-23 17:50:32.133460 2025-06-23 17:50:32.133870
[3 rows x 5 columns]
2025-06-23 17:50:32,160 - 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-06-23 17:50:32,666 - IOOppi_data - INFO : save data to db IOOppi_FG_t data:
date value
3314 2025-06-19 1104.0
3315 2025-06-20 1104.0
3316 2025-06-21 1104.0
3317 2025-06-22 1104.0
3318 2025-06-23 1105.6
2025-06-23 17:50:32,742 - IOOppi_data - INFO : save new data to db IOOppi_FG_t: date value ... created_at updated_at
3316 2025-06-21 1104.0 ... 2025-06-23 17:50:32.734847 2025-06-23 17:50:32.735259
3317 2025-06-22 1104.0 ... 2025-06-23 17:50:32.734847 2025-06-23 17:50:32.735259
3318 2025-06-23 1105.6 ... 2025-06-23 17:50:32.734847 2025-06-23 17:50:32.735259
[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-06-23 17:50:34,981 - IOOppi_data - INFO : save diff data to db IOOppi_FG_t: date ... updated_at
12 2012-12-19 ... 2025-06-23 17:50:34.972733
21 2013-01-04 ... 2025-06-23 17:50:34.972733
54 2013-02-27 ... 2025-06-23 17:50:34.972733
60 2013-03-07 ... 2025-06-23 17:50:34.972733
61 2013-03-08 ... 2025-06-23 17:50:34.972733
[5 rows x 6 columns]
2025-06-23 17:50:35,494 - IOOppi_data - INFO : save data to db IOOppi_FG_g data:
date value
3314 2025-06-19 1104.0
3315 2025-06-20 1104.0
3316 2025-06-21 1104.0
3317 2025-06-22 1104.0
3318 2025-06-23 1105.6
2025-06-23 17:50:35,567 - IOOppi_data - INFO : save new data to db IOOppi_FG_g: date value ... created_at updated_at
3320 2025-06-21 1104.0 ... 2025-06-23 17:50:35.559498 2025-06-23 17:50:35.559935
3321 2025-06-22 1104.0 ... 2025-06-23 17:50:35.559498 2025-06-23 17:50:35.559935
3322 2025-06-23 1105.6 ... 2025-06-23 17:50:35.559498 2025-06-23 17:50:35.559935
[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-06-23 17:50:37,583 - IOOppi_data - INFO : save diff data to db IOOppi_FG_g: date ... updated_at
12 2012-12-19 ... 2025-06-23 17:50:37.575365
21 2013-01-04 ... 2025-06-23 17:50:37.575365
54 2013-02-27 ... 2025-06-23 17:50:37.575365
60 2013-03-07 ... 2025-06-23 17:50:37.575365
61 2013-03-08 ... 2025-06-23 17:50:37.575365
[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-06-23 17:50:38,513 - IOOppi_data - INFO : save data to db IOOppi_eb_t data:
date value
1659 2025-06-19 8220.0
1660 2025-06-20 8226.0
1661 2025-06-21 8226.0
1662 2025-06-22 8226.0
1663 2025-06-23 8244.0
2025-06-23 17:50:38,563 - IOOppi_data - INFO : save new data to db IOOppi_eb_t: date value ... created_at updated_at
1661 2025-06-21 8226.0 ... 2025-06-23 17:50:38.555784 2025-06-23 17:50:38.556182
1662 2025-06-22 8226.0 ... 2025-06-23 17:50:38.555784 2025-06-23 17:50:38.556182
1663 2025-06-23 8244.0 ... 2025-06-23 17:50:38.555784 2025-06-23 17:50:38.556182
[3 rows x 5 columns]
2025-06-23 17:50:38,583 - IOOppi_data - INFO : save diff data to db: IOOppi_eb_t: no diff data
2025-06-23 17:50:38,589 - IOOppi_data - INFO : save data to db IOOppi_eb_g data:
date value
1659 2025-06-19 8220.0
1660 2025-06-20 8226.0
1661 2025-06-21 8226.0
1662 2025-06-22 8226.0
1663 2025-06-23 8244.0
2025-06-23 17:50:38,641 - IOOppi_data - INFO : save new data to db IOOppi_eb_g: date value ... created_at updated_at
1664 2025-06-21 8226.0 ... 2025-06-23 17:50:38.633397 2025-06-23 17:50:38.633812
1665 2025-06-22 8226.0 ... 2025-06-23 17:50:38.633397 2025-06-23 17:50:38.633812
1666 2025-06-23 8244.0 ... 2025-06-23 17:50:38.633397 2025-06-23 17:50:38.633812
[3 rows x 5 columns]
2025-06-23 17:50:38,660 - 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-06-23 17:50:39,205 - IOOppi_data - INFO : save data to db IOOppi_SR_t data:
date value
3770 2025-06-19 6050.0
3771 2025-06-20 6050.0
3772 2025-06-21 6050.0
3773 2025-06-22 6050.0
3774 2025-06-23 6050.0
2025-06-23 17:50:39,283 - IOOppi_data - INFO : save new data to db IOOppi_SR_t: date value ... created_at updated_at
3772 2025-06-21 6050.0 ... 2025-06-23 17:50:39.275959 2025-06-23 17:50:39.276354
3773 2025-06-22 6050.0 ... 2025-06-23 17:50:39.275959 2025-06-23 17:50:39.276354
3774 2025-06-23 6050.0 ... 2025-06-23 17:50:39.275959 2025-06-23 17:50:39.276354
[3 rows x 5 columns]
2025-06-23 17:50:39,303 - IOOppi_data - INFO : save diff data to db: IOOppi_SR_t: no diff data
2025-06-23 17:50:39,309 - IOOppi_data - INFO : save data to db IOOppi_SR_g data:
date value
3770 2025-06-19 6050.0
3771 2025-06-20 6050.0
3772 2025-06-21 6050.0
3773 2025-06-22 6050.0
3774 2025-06-23 6050.0
2025-06-23 17:50:39,386 - IOOppi_data - INFO : save new data to db IOOppi_SR_g: date value ... created_at updated_at
3776 2025-06-21 6050.0 ... 2025-06-23 17:50:39.379244 2025-06-23 17:50:39.379644
3777 2025-06-22 6050.0 ... 2025-06-23 17:50:39.379244 2025-06-23 17:50:39.379644
3778 2025-06-23 6050.0 ... 2025-06-23 17:50:39.379244 2025-06-23 17:50:39.379644
[3 rows x 5 columns]
2025-06-23 17:50:39,406 - 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-06-23 17:50:39,933 - IOOppi_data - INFO : save data to db IOOppi_ss_t data:
date value
1660 2025-06-19 12875.0
1661 2025-06-20 12875.0
1662 2025-06-21 12875.0
1663 2025-06-22 12875.0
1664 2025-06-23 12762.5
2025-06-23 17:50:39,983 - IOOppi_data - INFO : save new data to db IOOppi_ss_t: date value ... created_at updated_at
1662 2025-06-21 12875.0 ... 2025-06-23 17:50:39.976366 2025-06-23 17:50:39.976776
1663 2025-06-22 12875.0 ... 2025-06-23 17:50:39.976366 2025-06-23 17:50:39.976776
1664 2025-06-23 12762.5 ... 2025-06-23 17:50:39.976366 2025-06-23 17:50:39.976776
[3 rows x 5 columns]
2025-06-23 17:50:40,003 - IOOppi_data - INFO : save diff data to db: IOOppi_ss_t: no diff data
2025-06-23 17:50:40,009 - IOOppi_data - INFO : save data to db IOOppi_ss_g data:
date value
1660 2025-06-19 12875.0
1661 2025-06-20 12875.0
1662 2025-06-21 12875.0
1663 2025-06-22 12875.0
1664 2025-06-23 12762.5
2025-06-23 17:50:40,060 - IOOppi_data - INFO : save new data to db IOOppi_ss_g: date value ... created_at updated_at
1665 2025-06-21 12875.0 ... 2025-06-23 17:50:40.053062 2025-06-23 17:50:40.053468
1666 2025-06-22 12875.0 ... 2025-06-23 17:50:40.053062 2025-06-23 17:50:40.053468
1667 2025-06-23 12762.5 ... 2025-06-23 17:50:40.053062 2025-06-23 17:50:40.053468
[3 rows x 5 columns]
2025-06-23 17:50:40,080 - 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-06-23 17:50:40,749 - IOOppi_data - INFO : save data to db IOOppi_RS_t data:
date value
3170 2025-06-19 9833.33
3171 2025-06-20 9875.00
3172 2025-06-21 9875.00
3173 2025-06-22 9875.00
3174 2025-06-23 9878.33
2025-06-23 17:50:40,819 - IOOppi_data - INFO : save new data to db IOOppi_RS_t: date value ... created_at updated_at
3172 2025-06-21 9875.00 ... 2025-06-23 17:50:40.811853 2025-06-23 17:50:40.812293
3173 2025-06-22 9875.00 ... 2025-06-23 17:50:40.811853 2025-06-23 17:50:40.812293
3174 2025-06-23 9878.33 ... 2025-06-23 17:50:40.811853 2025-06-23 17:50:40.812293
[3 rows x 5 columns]
2025-06-23 17:50:40,838 - IOOppi_data - INFO : save diff data to db: IOOppi_RS_t: no diff data
2025-06-23 17:50:40,844 - IOOppi_data - INFO : save data to db IOOppi_RS_g data:
date value
3170 2025-06-19 9833.33
3171 2025-06-20 9875.00
3172 2025-06-21 9875.00
3173 2025-06-22 9875.00
3174 2025-06-23 9878.33
2025-06-23 17:50:40,913 - IOOppi_data - INFO : save new data to db IOOppi_RS_g: date value ... created_at updated_at
3176 2025-06-21 9875.00 ... 2025-06-23 17:50:40.905951 2025-06-23 17:50:40.906338
3177 2025-06-22 9875.00 ... 2025-06-23 17:50:40.905951 2025-06-23 17:50:40.906338
3178 2025-06-23 9878.33 ... 2025-06-23 17:50:40.905951 2025-06-23 17:50:40.906338
[3 rows x 5 columns]
2025-06-23 17:50:40,933 - 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-06-23 17:50:41,505 - IOOppi_data - INFO : save data to db IOOppi_RM_t data:
date value
3293 2025-06-19 2615.00
3294 2025-06-20 2616.67
3295 2025-06-21 2616.67
3296 2025-06-22 2616.67
3297 2025-06-23 2588.33
2025-06-23 17:50:41,576 - IOOppi_data - INFO : save new data to db IOOppi_RM_t: date value ... created_at updated_at
3295 2025-06-21 2616.67 ... 2025-06-23 17:50:41.568683 2025-06-23 17:50:41.569142
3296 2025-06-22 2616.67 ... 2025-06-23 17:50:41.568683 2025-06-23 17:50:41.569142
3297 2025-06-23 2588.33 ... 2025-06-23 17:50:41.568683 2025-06-23 17:50:41.569142
[3 rows x 5 columns]
2025-06-23 17:50:41,595 - IOOppi_data - INFO : save diff data to db: IOOppi_RM_t: no diff data
2025-06-23 17:50:41,601 - IOOppi_data - INFO : save data to db IOOppi_RM_g data:
date value
3293 2025-06-19 2615.00
3294 2025-06-20 2616.67
3295 2025-06-21 2616.67
3296 2025-06-22 2616.67
3297 2025-06-23 2588.33
2025-06-23 17:50:41,673 - IOOppi_data - INFO : save new data to db IOOppi_RM_g: date value ... created_at updated_at
3299 2025-06-21 2616.67 ... 2025-06-23 17:50:41.666181 2025-06-23 17:50:41.666564
3300 2025-06-22 2616.67 ... 2025-06-23 17:50:41.666181 2025-06-23 17:50:41.666564
3301 2025-06-23 2588.33 ... 2025-06-23 17:50:41.666181 2025-06-23 17:50:41.666564
[3 rows x 5 columns]
2025-06-23 17:50:41,692 - 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-06-23 17:50:42,203 - IOOppi_data - INFO : save data to db IOOppi_SA_t data:
date value
1497 2025-06-19 1370.0
1498 2025-06-20 1370.0
1499 2025-06-21 1370.0
1500 2025-06-22 1370.0
1501 2025-06-23 1350.0
2025-06-23 17:50:42,254 - IOOppi_data - INFO : save new data to db IOOppi_SA_t: date value ... created_at updated_at
1499 2025-06-21 1370.0 ... 2025-06-23 17:50:42.247032 2025-06-23 17:50:42.247441
1500 2025-06-22 1370.0 ... 2025-06-23 17:50:42.247032 2025-06-23 17:50:42.247441
1501 2025-06-23 1350.0 ... 2025-06-23 17:50:42.247032 2025-06-23 17:50:42.247441
[3 rows x 5 columns]
2025-06-23 17:50:42,274 - IOOppi_data - INFO : save diff data to db: IOOppi_SA_t: no diff data
2025-06-23 17:50:42,279 - IOOppi_data - INFO : save data to db IOOppi_SA_g data:
date value
1497 2025-06-19 1370.0
1498 2025-06-20 1370.0
1499 2025-06-21 1370.0
1500 2025-06-22 1370.0
1501 2025-06-23 1350.0
2025-06-23 17:50:42,326 - IOOppi_data - INFO : save new data to db IOOppi_SA_g: date value ... created_at updated_at
1503 2025-06-21 1370.0 ... 2025-06-23 17:50:42.318561 2025-06-23 17:50:42.318973
1504 2025-06-22 1370.0 ... 2025-06-23 17:50:42.318561 2025-06-23 17:50:42.318973
1505 2025-06-23 1350.0 ... 2025-06-23 17:50:42.318561 2025-06-23 17:50:42.318973
[3 rows x 5 columns]
2025-06-23 17:50:42,345 - 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-06-23 17:50:42,905 - IOOppi_data - INFO : save data to db IOOppi_PF_t data:
date value
1410 2025-06-19 6803.96
1411 2025-06-20 6866.46
1412 2025-06-21 6866.46
1413 2025-06-22 6866.46
1414 2025-06-23 6926.25
2025-06-23 17:50:42,953 - IOOppi_data - INFO : save new data to db IOOppi_PF_t: date value ... created_at updated_at
1412 2025-06-21 6866.46 ... 2025-06-23 17:50:42.945377 2025-06-23 17:50:42.945799
1413 2025-06-22 6866.46 ... 2025-06-23 17:50:42.945377 2025-06-23 17:50:42.945799
1414 2025-06-23 6926.25 ... 2025-06-23 17:50:42.945377 2025-06-23 17:50:42.945799
[3 rows x 5 columns]
2025-06-23 17:50:42,973 - IOOppi_data - INFO : save diff data to db: IOOppi_PF_t: no diff data
2025-06-23 17:50:42,979 - IOOppi_data - INFO : save data to db IOOppi_PF_g data:
date value
1410 2025-06-19 6803.96
1411 2025-06-20 6866.46
1412 2025-06-21 6866.46
1413 2025-06-22 6866.46
1414 2025-06-23 6926.25
2025-06-23 17:50:43,028 - IOOppi_data - INFO : save new data to db IOOppi_PF_g: date value ... created_at updated_at
1416 2025-06-21 6866.46 ... 2025-06-23 17:50:43.020548 2025-06-23 17:50:43.020991
1417 2025-06-22 6866.46 ... 2025-06-23 17:50:43.020548 2025-06-23 17:50:43.020991
1418 2025-06-23 6926.25 ... 2025-06-23 17:50:43.020548 2025-06-23 17:50:43.020991
[3 rows x 5 columns]
2025-06-23 17:50:43,048 - 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-06-23 17:50:43,598 - IOOppi_data - INFO : save data to db IOOppi_m_t data:
date value
3783 2025-06-19 3016.0
3784 2025-06-20 3024.0
3785 2025-06-21 3024.0
3786 2025-06-22 3024.0
3787 2025-06-23 2986.0
2025-06-23 17:50:43,676 - IOOppi_data - INFO : save new data to db IOOppi_m_t: date value ... created_at updated_at
3785 2025-06-21 3024.0 ... 2025-06-23 17:50:43.668847 2025-06-23 17:50:43.669251
3786 2025-06-22 3024.0 ... 2025-06-23 17:50:43.668847 2025-06-23 17:50:43.669251
3787 2025-06-23 2986.0 ... 2025-06-23 17:50:43.668847 2025-06-23 17:50:43.669251
[3 rows x 5 columns]
2025-06-23 17:50:43,696 - IOOppi_data - INFO : save diff data to db: IOOppi_m_t: no diff data
2025-06-23 17:50:43,702 - IOOppi_data - INFO : save data to db IOOppi_m_g data:
date value
3783 2025-06-19 3016.0
3784 2025-06-20 3024.0
3785 2025-06-21 3024.0
3786 2025-06-22 3024.0
3787 2025-06-23 2986.0
2025-06-23 17:50:43,781 - IOOppi_data - INFO : save new data to db IOOppi_m_g: date value ... created_at updated_at
3788 2025-06-21 3024.0 ... 2025-06-23 17:50:43.773451 2025-06-23 17:50:43.773862
3789 2025-06-22 3024.0 ... 2025-06-23 17:50:43.773451 2025-06-23 17:50:43.773862
3790 2025-06-23 2986.0 ... 2025-06-23 17:50:43.773451 2025-06-23 17:50:43.773862
[3 rows x 5 columns]
2025-06-23 17:50:43,799 - 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-06-23 17:50:44,350 - IOOppi_data - INFO : save data to db IOOppi_y_t data:
date value
3553 2025-06-19 8394.0
3554 2025-06-20 8414.0
3555 2025-06-21 8414.0
3556 2025-06-22 8414.0
3557 2025-06-23 8394.0
2025-06-23 17:50:44,430 - IOOppi_data - INFO : save new data to db IOOppi_y_t: date value ... created_at updated_at
3555 2025-06-21 8414.0 ... 2025-06-23 17:50:44.422476 2025-06-23 17:50:44.422892
3556 2025-06-22 8414.0 ... 2025-06-23 17:50:44.422476 2025-06-23 17:50:44.422892
3557 2025-06-23 8394.0 ... 2025-06-23 17:50:44.422476 2025-06-23 17:50:44.422892
[3 rows x 5 columns]
2025-06-23 17:50:44,450 - IOOppi_data - INFO : save diff data to db: IOOppi_y_t: no diff data
2025-06-23 17:50:44,456 - IOOppi_data - INFO : save data to db IOOppi_y_g data:
date value
3553 2025-06-19 8394.0
3554 2025-06-20 8414.0
3555 2025-06-21 8414.0
3556 2025-06-22 8414.0
3557 2025-06-23 8394.0
2025-06-23 17:50:44,535 - IOOppi_data - INFO : save new data to db IOOppi_y_g: date value ... created_at updated_at
3558 2025-06-21 8414.0 ... 2025-06-23 17:50:44.527834 2025-06-23 17:50:44.528248
3559 2025-06-22 8414.0 ... 2025-06-23 17:50:44.527834 2025-06-23 17:50:44.528248
3560 2025-06-23 8394.0 ... 2025-06-23 17:50:44.527834 2025-06-23 17:50:44.528248
[3 rows x 5 columns]
2025-06-23 17:50:44,555 - 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-06-23 17:50:45,171 - IOOppi_data - INFO : save data to db IOOppi_a_t data:
date value
3519 2025-06-19 4295.0
3520 2025-06-20 4295.0
3521 2025-06-21 4295.0
3522 2025-06-22 4295.0
3523 2025-06-23 4295.0
2025-06-23 17:50:45,250 - IOOppi_data - INFO : save new data to db IOOppi_a_t: date value ... created_at updated_at
3521 2025-06-21 4295.0 ... 2025-06-23 17:50:45.242666 2025-06-23 17:50:45.243090
3522 2025-06-22 4295.0 ... 2025-06-23 17:50:45.242666 2025-06-23 17:50:45.243090
3523 2025-06-23 4295.0 ... 2025-06-23 17:50:45.242666 2025-06-23 17:50:45.243090
[3 rows x 5 columns]
2025-06-23 17:50:45,270 - IOOppi_data - INFO : save diff data to db: IOOppi_a_t: no diff data
2025-06-23 17:50:45,276 - IOOppi_data - INFO : save data to db IOOppi_a_g data:
date value
3519 2025-06-19 4295.0
3520 2025-06-20 4295.0
3521 2025-06-21 4295.0
3522 2025-06-22 4295.0
3523 2025-06-23 4295.0
2025-06-23 17:50:45,351 - IOOppi_data - INFO : save new data to db IOOppi_a_g: date value ... created_at updated_at
3524 2025-06-21 4295.0 ... 2025-06-23 17:50:45.343544 2025-06-23 17:50:45.343966
3525 2025-06-22 4295.0 ... 2025-06-23 17:50:45.343544 2025-06-23 17:50:45.343966
3526 2025-06-23 4295.0 ... 2025-06-23 17:50:45.343544 2025-06-23 17:50:45.343966
[3 rows x 5 columns]
2025-06-23 17:50:45,370 - 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-06-23 17:50:45,942 - IOOppi_data - INFO : save data to db IOOppi_SF_t data:
date value
2896 2025-06-19 5114.29
2897 2025-06-20 5128.57
2898 2025-06-21 5128.57
2899 2025-06-22 5128.57
2900 2025-06-23 5130.00
2025-06-23 17:50:46,011 - IOOppi_data - INFO : save new data to db IOOppi_SF_t: date value ... created_at updated_at
2898 2025-06-21 5128.57 ... 2025-06-23 17:50:46.002360 2025-06-23 17:50:46.002930
2899 2025-06-22 5128.57 ... 2025-06-23 17:50:46.002360 2025-06-23 17:50:46.002930
2900 2025-06-23 5130.00 ... 2025-06-23 17:50:46.002360 2025-06-23 17:50:46.002930
[3 rows x 5 columns]
2025-06-23 17:50:46,031 - IOOppi_data - INFO : save diff data to db: IOOppi_SF_t: no diff data
2025-06-23 17:50:46,037 - IOOppi_data - INFO : save data to db IOOppi_SF_g data:
date value
2896 2025-06-19 5114.29
2897 2025-06-20 5128.57
2898 2025-06-21 5128.57
2899 2025-06-22 5128.57
2900 2025-06-23 5130.00
2025-06-23 17:50:46,103 - IOOppi_data - INFO : save new data to db IOOppi_SF_g: date value ... created_at updated_at
2902 2025-06-21 5128.57 ... 2025-06-23 17:50:46.096 2025-06-23 17:50:46.096402
2903 2025-06-22 5128.57 ... 2025-06-23 17:50:46.096 2025-06-23 17:50:46.096402
2904 2025-06-23 5130.00 ... 2025-06-23 17:50:46.096 2025-06-23 17:50:46.096402
[3 rows x 5 columns]
2025-06-23 17:50:46,123 - 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-06-23 17:50:46,653 - IOOppi_data - INFO : save data to db IOOppi_jd_t data:
date value
3096 2025-06-19 2875.0
3097 2025-06-20 2925.0
3098 2025-06-21 2925.0
3099 2025-06-22 2925.0
3100 2025-06-23 2925.0
2025-06-23 17:50:46,729 - IOOppi_data - INFO : save new data to db IOOppi_jd_t: date value ... created_at updated_at
3098 2025-06-21 2925.0 ... 2025-06-23 17:50:46.721113 2025-06-23 17:50:46.721543
3099 2025-06-22 2925.0 ... 2025-06-23 17:50:46.721113 2025-06-23 17:50:46.721543
3100 2025-06-23 2925.0 ... 2025-06-23 17:50:46.721113 2025-06-23 17:50:46.721543
[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-06-23 17:50:46,899 - IOOppi_data - INFO : save diff data to db IOOppi_jd_t: date ... updated_at
39 2014-01-03 ... 2025-06-23 17:50:46.890795
458 2015-09-21 ... 2025-06-23 17:50:46.890795
549 2016-02-03 ... 2025-06-23 17:50:46.890795
693 2016-09-05 ... 2025-06-23 17:50:46.890795
696 2016-09-08 ... 2025-06-23 17:50:46.890795
[5 rows x 6 columns]
2025-06-23 17:50:46,938 - IOOppi_data - INFO : save data to db IOOppi_jd_g data:
date value
3096 2025-06-19 2875.0
3097 2025-06-20 2925.0
3098 2025-06-21 2925.0
3099 2025-06-22 2925.0
3100 2025-06-23 2925.0
2025-06-23 17:50:47,006 - IOOppi_data - INFO : save new data to db IOOppi_jd_g: date value ... created_at updated_at
3101 2025-06-21 2925.0 ... 2025-06-23 17:50:46.999318 2025-06-23 17:50:46.999710
3102 2025-06-22 2925.0 ... 2025-06-23 17:50:46.999318 2025-06-23 17:50:46.999710
3103 2025-06-23 2925.0 ... 2025-06-23 17:50:46.999318 2025-06-23 17:50:46.999710
[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-06-23 17:50:47,168 - IOOppi_data - INFO : save diff data to db IOOppi_jd_g: date ... updated_at
39 2014-01-03 ... 2025-06-23 17:50:47.160954
458 2015-09-21 ... 2025-06-23 17:50:47.160954
549 2016-02-03 ... 2025-06-23 17:50:47.160954
693 2016-09-05 ... 2025-06-23 17:50:47.160954
696 2016-09-08 ... 2025-06-23 17:50:47.160954
[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-06-23 17:50:47,866 - IOOppi_data - INFO : save data to db IOOppi_SI_t data:
date value
900 2025-06-19 8620.0
901 2025-06-20 8620.0
902 2025-06-21 8620.0
903 2025-06-22 8620.0
904 2025-06-23 8620.0
2025-06-23 17:50:47,909 - IOOppi_data - INFO : save new data to db IOOppi_SI_t: date value ... created_at updated_at
902 2025-06-21 8620.0 ... 2025-06-23 17:50:47.901227 2025-06-23 17:50:47.901644
903 2025-06-22 8620.0 ... 2025-06-23 17:50:47.901227 2025-06-23 17:50:47.901644
904 2025-06-23 8620.0 ... 2025-06-23 17:50:47.901227 2025-06-23 17:50:47.901644
[3 rows x 5 columns]
2025-06-23 17:50:47,929 - IOOppi_data - INFO : save diff data to db: IOOppi_SI_t: no diff data
2025-06-23 17:50:47,934 - IOOppi_data - INFO : save data to db IOOppi_SI_g data:
date value
900 2025-06-19 8620.0
901 2025-06-20 8620.0
902 2025-06-21 8620.0
903 2025-06-22 8620.0
904 2025-06-23 8620.0
2025-06-23 17:50:47,973 - IOOppi_data - INFO : save new data to db IOOppi_SI_g: date value ... created_at updated_at
902 2025-06-21 8620.0 ... 2025-06-23 17:50:47.965595 2025-06-23 17:50:47.966031
903 2025-06-22 8620.0 ... 2025-06-23 17:50:47.965595 2025-06-23 17:50:47.966031
904 2025-06-23 8620.0 ... 2025-06-23 17:50:47.965595 2025-06-23 17:50:47.966031
[3 rows x 5 columns]
2025-06-23 17:50:47,992 - 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-06-23 17:50:48,514 - IOOppi_data - INFO : save data to db IOOppi_l_t data:
date value
3779 2025-06-19 7543.33
3780 2025-06-20 7556.67
3781 2025-06-21 7556.67
3782 2025-06-22 7556.67
3783 2025-06-23 7593.33
2025-06-23 17:50:48,595 - IOOppi_data - INFO : save new data to db IOOppi_l_t: date value ... created_at updated_at
3781 2025-06-21 7556.67 ... 2025-06-23 17:50:48.587812 2025-06-23 17:50:48.588215
3782 2025-06-22 7556.67 ... 2025-06-23 17:50:48.587812 2025-06-23 17:50:48.588215
3783 2025-06-23 7593.33 ... 2025-06-23 17:50:48.587812 2025-06-23 17:50:48.588215
[3 rows x 5 columns]
2025-06-23 17:50:48,614 - IOOppi_data - INFO : save diff data to db: IOOppi_l_t: no diff data
2025-06-23 17:50:48,620 - IOOppi_data - INFO : save data to db IOOppi_l_g data:
date value
3779 2025-06-19 7543.33
3780 2025-06-20 7556.67
3781 2025-06-21 7556.67
3782 2025-06-22 7556.67
3783 2025-06-23 7593.33
2025-06-23 17:50:48,697 - IOOppi_data - INFO : save new data to db IOOppi_l_g: date value ... created_at updated_at
3784 2025-06-21 7556.67 ... 2025-06-23 17:50:48.689776 2025-06-23 17:50:48.690173
3785 2025-06-22 7556.67 ... 2025-06-23 17:50:48.689776 2025-06-23 17:50:48.690173
3786 2025-06-23 7593.33 ... 2025-06-23 17:50:48.689776 2025-06-23 17:50:48.690173
[3 rows x 5 columns]
2025-06-23 17:50:48,716 - 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-06-23 17:50:49,236 - IOOppi_data - INFO : save data to db IOOppi_bu_t data:
date value
3117 2025-06-19 3710.00
3118 2025-06-20 3746.67
3119 2025-06-21 3746.67
3120 2025-06-22 3746.67
3121 2025-06-23 3746.67
2025-06-23 17:50:49,306 - IOOppi_data - INFO : save new data to db IOOppi_bu_t: date value ... created_at updated_at
3120 2025-06-21 3746.67 ... 2025-06-23 17:50:49.298894 2025-06-23 17:50:49.299357
3121 2025-06-22 3746.67 ... 2025-06-23 17:50:49.298894 2025-06-23 17:50:49.299357
3122 2025-06-23 3746.67 ... 2025-06-23 17:50:49.298894 2025-06-23 17:50:49.299357
[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-06-23 17:50:49,344 - IOOppi_data - INFO : save diff data to db IOOppi_bu_t: date ... updated_at
2560 2023-12-09 ... 2025-06-23 17:50:49.336840
[1 rows x 6 columns]
2025-06-23 17:50:49,372 - IOOppi_data - INFO : save data to db IOOppi_bu_g data:
date value
3117 2025-06-19 3710.00
3118 2025-06-20 3746.67
3119 2025-06-21 3746.67
3120 2025-06-22 3746.67
3121 2025-06-23 3746.67
2025-06-23 17:50:49,447 - IOOppi_data - INFO : save new data to db IOOppi_bu_g: date value ... created_at updated_at
3122 2025-06-21 3746.67 ... 2025-06-23 17:50:49.439902 2025-06-23 17:50:49.440304
3123 2025-06-22 3746.67 ... 2025-06-23 17:50:49.439902 2025-06-23 17:50:49.440304
3124 2025-06-23 3746.67 ... 2025-06-23 17:50:49.439902 2025-06-23 17:50:49.440304
[3 rows x 5 columns]
2025-06-23 17:50:49,467 - 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-06-23 17:50:50,108 - IOOppi_data - INFO : save data to db IOOppi_al_t data:
date value
3782 2025-06-19 20786.67
3783 2025-06-20 20786.67
3784 2025-06-21 20736.67
3785 2025-06-22 20736.67
3786 2025-06-23 20663.33
2025-06-23 17:50:50,193 - IOOppi_data - INFO : save new data to db IOOppi_al_t: date ... updated_at
3784 2025-06-21 ... 2025-06-23 17:50:50.186451
3785 2025-06-22 ... 2025-06-23 17:50:50.186451
3786 2025-06-23 ... 2025-06-23 17:50:50.186451
[3 rows x 5 columns]
2025-06-23 17:50:50,213 - IOOppi_data - INFO : save diff data to db: IOOppi_al_t: no diff data
2025-06-23 17:50:50,220 - IOOppi_data - INFO : save data to db IOOppi_al_g data:
date value
3782 2025-06-19 20786.67
3783 2025-06-20 20786.67
3784 2025-06-21 20736.67
3785 2025-06-22 20736.67
3786 2025-06-23 20663.33
2025-06-23 17:50:50,296 - IOOppi_data - INFO : save new data to db IOOppi_al_g: date ... updated_at
3787 2025-06-21 ... 2025-06-23 17:50:50.290073
3788 2025-06-22 ... 2025-06-23 17:50:50.290073
3789 2025-06-23 ... 2025-06-23 17:50:50.290073
[3 rows x 5 columns]
2025-06-23 17:50:50,316 - 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-06-23 17:50:50,863 - IOOppi_data - INFO : save data to db IOOppi_SM_t data:
date value
2896 2025-06-19 5508.0
2897 2025-06-20 5564.0
2898 2025-06-21 5564.0
2899 2025-06-22 5564.0
2900 2025-06-23 5524.0
2025-06-23 17:50:50,935 - IOOppi_data - INFO : save new data to db IOOppi_SM_t: date value ... created_at updated_at
2898 2025-06-21 5564.0 ... 2025-06-23 17:50:50.926336 2025-06-23 17:50:50.926923
2899 2025-06-22 5564.0 ... 2025-06-23 17:50:50.926336 2025-06-23 17:50:50.926923
2900 2025-06-23 5524.0 ... 2025-06-23 17:50:50.926336 2025-06-23 17:50:50.926923
[3 rows x 5 columns]
2025-06-23 17:50:50,954 - IOOppi_data - INFO : save diff data to db: IOOppi_SM_t: no diff data
2025-06-23 17:50:50,961 - IOOppi_data - INFO : save data to db IOOppi_SM_g data:
date value
2896 2025-06-19 5508.0
2897 2025-06-20 5564.0
2898 2025-06-21 5564.0
2899 2025-06-22 5564.0
2900 2025-06-23 5524.0
2025-06-23 17:50:51,027 - IOOppi_data - INFO : save new data to db IOOppi_SM_g: date value ... created_at updated_at
2902 2025-06-21 5564.0 ... 2025-06-23 17:50:51.020106 2025-06-23 17:50:51.020545
2903 2025-06-22 5564.0 ... 2025-06-23 17:50:51.020106 2025-06-23 17:50:51.020545
2904 2025-06-23 5524.0 ... 2025-06-23 17:50:51.020106 2025-06-23 17:50:51.020545
[3 rows x 5 columns]
2025-06-23 17:50:51,048 - 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-06-23 17:50:51,603 - IOOppi_data - INFO : save data to db IOOppi_CY_t data:
date value
2171 2025-06-19 23575.0
2172 2025-06-20 23575.0
2173 2025-06-21 23575.0
2174 2025-06-22 23575.0
2175 2025-06-23 23550.0
2025-06-23 17:50:51,659 - IOOppi_data - INFO : save new data to db IOOppi_CY_t: date value ... created_at updated_at
2173 2025-06-21 23575.0 ... 2025-06-23 17:50:51.651811 2025-06-23 17:50:51.652238
2174 2025-06-22 23575.0 ... 2025-06-23 17:50:51.651811 2025-06-23 17:50:51.652238
2175 2025-06-23 23550.0 ... 2025-06-23 17:50:51.651811 2025-06-23 17:50:51.652238
[3 rows x 5 columns]
2025-06-23 17:50:51,678 - IOOppi_data - INFO : save diff data to db: IOOppi_CY_t: no diff data
2025-06-23 17:50:51,684 - IOOppi_data - INFO : save data to db IOOppi_CY_g data:
date value
2171 2025-06-19 23575.0
2172 2025-06-20 23575.0
2173 2025-06-21 23575.0
2174 2025-06-22 23575.0
2175 2025-06-23 23550.0
2025-06-23 17:50:51,744 - IOOppi_data - INFO : save new data to db IOOppi_CY_g: date value ... created_at updated_at
2177 2025-06-21 23575.0 ... 2025-06-23 17:50:51.737032 2025-06-23 17:50:51.737420
2178 2025-06-22 23575.0 ... 2025-06-23 17:50:51.737032 2025-06-23 17:50:51.737420
2179 2025-06-23 23550.0 ... 2025-06-23 17:50:51.737032 2025-06-23 17:50:51.737420
[3 rows x 5 columns]
2025-06-23 17:50:51,764 - 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-06-23 17:50:52,405 - IOOppi_data - INFO : save data to db IOOppi_UR_t data:
date value
1686 2025-06-19 1842.0
1687 2025-06-20 1834.0
1688 2025-06-21 1834.0
1689 2025-06-22 1834.0
1690 2025-06-23 1824.0
2025-06-23 17:50:52,456 - IOOppi_data - INFO : save new data to db IOOppi_UR_t: date value ... created_at updated_at
1688 2025-06-21 1834.0 ... 2025-06-23 17:50:52.448475 2025-06-23 17:50:52.448894
1689 2025-06-22 1834.0 ... 2025-06-23 17:50:52.448475 2025-06-23 17:50:52.448894
1690 2025-06-23 1824.0 ... 2025-06-23 17:50:52.448475 2025-06-23 17:50:52.448894
[3 rows x 5 columns]
2025-06-23 17:50:52,475 - IOOppi_data - INFO : save diff data to db: IOOppi_UR_t: no diff data
2025-06-23 17:50:52,480 - IOOppi_data - INFO : save data to db IOOppi_UR_g data:
date value
1686 2025-06-19 1842.0
1687 2025-06-20 1834.0
1688 2025-06-21 1834.0
1689 2025-06-22 1834.0
1690 2025-06-23 1824.0
2025-06-23 17:50:52,530 - IOOppi_data - INFO : save new data to db IOOppi_UR_g: date value ... created_at updated_at
1692 2025-06-21 1834.0 ... 2025-06-23 17:50:52.522741 2025-06-23 17:50:52.523163
1693 2025-06-22 1834.0 ... 2025-06-23 17:50:52.522741 2025-06-23 17:50:52.523163
1694 2025-06-23 1824.0 ... 2025-06-23 17:50:52.522741 2025-06-23 17:50:52.523163
[3 rows x 5 columns]
2025-06-23 17:50:52,553 - 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-06-23 17:50:53,183 - IOOppi_data - INFO : save data to db IOOppi_ni_t data:
date value
2758 2025-06-19 120458.33
2759 2025-06-20 120641.67
2760 2025-06-21 120641.67
2761 2025-06-22 120641.67
2762 2025-06-23 119616.67
2025-06-23 17:50:53,248 - IOOppi_data - INFO : save new data to db IOOppi_ni_t: date ... updated_at
2760 2025-06-21 ... 2025-06-23 17:50:53.241934
2761 2025-06-22 ... 2025-06-23 17:50:53.241934
2762 2025-06-23 ... 2025-06-23 17:50:53.241934
[3 rows x 5 columns]
2025-06-23 17:50:53,267 - IOOppi_data - INFO : save diff data to db: IOOppi_ni_t: no diff data
2025-06-23 17:50:53,273 - IOOppi_data - INFO : save data to db IOOppi_ni_g data:
date value
2758 2025-06-19 120458.33
2759 2025-06-20 120641.67
2760 2025-06-21 120641.67
2761 2025-06-22 120641.67
2762 2025-06-23 119616.67
2025-06-23 17:50:53,335 - IOOppi_data - INFO : save new data to db IOOppi_ni_g: date ... updated_at
2763 2025-06-21 ... 2025-06-23 17:50:53.329579
2764 2025-06-22 ... 2025-06-23 17:50:53.329579
2765 2025-06-23 ... 2025-06-23 17:50:53.329579
[3 rows x 5 columns]
2025-06-23 17:50:53,355 - 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-06-23 17:50:53,893 - IOOppi_data - INFO : save data to db IOOppi_v_t data:
date value
3783 2025-06-19 4646.0
3784 2025-06-20 4677.0
3785 2025-06-21 4677.0
3786 2025-06-22 4677.0
3787 2025-06-23 4669.0
2025-06-23 17:50:53,971 - IOOppi_data - INFO : save new data to db IOOppi_v_t: date value ... created_at updated_at
3785 2025-06-21 4677.0 ... 2025-06-23 17:50:53.963360 2025-06-23 17:50:53.963782
3786 2025-06-22 4677.0 ... 2025-06-23 17:50:53.963360 2025-06-23 17:50:53.963782
3787 2025-06-23 4669.0 ... 2025-06-23 17:50:53.963360 2025-06-23 17:50:53.963782
[3 rows x 5 columns]
2025-06-23 17:50:54,061 - IOOppi_data - INFO : save diff data to db: IOOppi_v_t: no diff data
2025-06-23 17:50:54,067 - IOOppi_data - INFO : save data to db IOOppi_v_g data:
date value
3783 2025-06-19 4646.0
3784 2025-06-20 4677.0
3785 2025-06-21 4677.0
3786 2025-06-22 4677.0
3787 2025-06-23 4669.0
2025-06-23 17:50:54,147 - IOOppi_data - INFO : save new data to db IOOppi_v_g: date value ... created_at updated_at
3788 2025-06-21 4677.0 ... 2025-06-23 17:50:54.140416 2025-06-23 17:50:54.140828
3789 2025-06-22 4677.0 ... 2025-06-23 17:50:54.140416 2025-06-23 17:50:54.140828
3790 2025-06-23 4669.0 ... 2025-06-23 17:50:54.140416 2025-06-23 17:50:54.140828
[3 rows x 5 columns]
2025-06-23 17:50:54,166 - 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-06-23 17:50:54,705 - IOOppi_data - INFO : save data to db IOOppi_pp_t data:
date value
3022 2025-06-19 7471.67
3023 2025-06-20 7471.67
3024 2025-06-21 7471.67
3025 2025-06-22 7471.67
3026 2025-06-23 7476.67
2025-06-23 17:50:54,771 - IOOppi_data - INFO : save new data to db IOOppi_pp_t: date value ... created_at updated_at
3024 2025-06-21 7471.67 ... 2025-06-23 17:50:54.764631 2025-06-23 17:50:54.765053
3025 2025-06-22 7471.67 ... 2025-06-23 17:50:54.764631 2025-06-23 17:50:54.765053
3026 2025-06-23 7476.67 ... 2025-06-23 17:50:54.764631 2025-06-23 17:50:54.765053
[3 rows x 5 columns]
2025-06-23 17:50:54,791 - IOOppi_data - INFO : save diff data to db: IOOppi_pp_t: no diff data
2025-06-23 17:50:54,796 - IOOppi_data - INFO : save data to db IOOppi_pp_g data:
date value
3022 2025-06-19 7471.67
3023 2025-06-20 7471.67
3024 2025-06-21 7471.67
3025 2025-06-22 7471.67
3026 2025-06-23 7476.67
2025-06-23 17:50:54,863 - IOOppi_data - INFO : save new data to db IOOppi_pp_g: date value ... created_at updated_at
3027 2025-06-21 7471.67 ... 2025-06-23 17:50:54.856133 2025-06-23 17:50:54.856521
3028 2025-06-22 7471.67 ... 2025-06-23 17:50:54.856133 2025-06-23 17:50:54.856521
3029 2025-06-23 7476.67 ... 2025-06-23 17:50:54.856133 2025-06-23 17:50:54.856521
[3 rows x 5 columns]
2025-06-23 17:50:54,882 - 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-06-23 17:50:55,521 - IOOppi_data - INFO : save data to db IOOppi_CF_t data:
date value
3784 2025-06-19 14882.00
3785 2025-06-20 14869.67
3786 2025-06-21 14869.67
3787 2025-06-22 14869.67
3788 2025-06-23 14881.83
2025-06-23 17:50:55,594 - IOOppi_data - INFO : save new data to db IOOppi_CF_t: date ... updated_at
3786 2025-06-21 ... 2025-06-23 17:50:55.587608
3787 2025-06-22 ... 2025-06-23 17:50:55.587608
3788 2025-06-23 ... 2025-06-23 17:50:55.587608
[3 rows x 5 columns]
2025-06-23 17:50:55,613 - IOOppi_data - INFO : save diff data to db: IOOppi_CF_t: no diff data
2025-06-23 17:50:55,619 - IOOppi_data - INFO : save data to db IOOppi_CF_g data:
date value
3784 2025-06-19 14882.00
3785 2025-06-20 14869.67
3786 2025-06-21 14869.67
3787 2025-06-22 14869.67
3788 2025-06-23 14881.83
2025-06-23 17:50:55,691 - IOOppi_data - INFO : save new data to db IOOppi_CF_g: date ... updated_at
3790 2025-06-21 ... 2025-06-23 17:50:55.685442
3791 2025-06-22 ... 2025-06-23 17:50:55.685442
3792 2025-06-23 ... 2025-06-23 17:50:55.685442
[3 rows x 5 columns]
2025-06-23 17:50:55,712 - 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-06-23 17:50:56,248 - IOOppi_data - INFO : save data to db IOOppi_pb_t data:
date value
3729 2025-06-19 16856.25
3730 2025-06-20 16812.50
3731 2025-06-21 16812.50
3732 2025-06-22 16812.50
3733 2025-06-23 16812.50
2025-06-23 17:50:56,326 - IOOppi_data - INFO : save new data to db IOOppi_pb_t: date value ... created_at updated_at
3731 2025-06-21 16812.5 ... 2025-06-23 17:50:56.318918 2025-06-23 17:50:56.319337
3732 2025-06-22 16812.5 ... 2025-06-23 17:50:56.318918 2025-06-23 17:50:56.319337
3733 2025-06-23 16812.5 ... 2025-06-23 17:50:56.318918 2025-06-23 17:50:56.319337
[3 rows x 5 columns]
2025-06-23 17:50:56,346 - IOOppi_data - INFO : save diff data to db: IOOppi_pb_t: no diff data
2025-06-23 17:50:56,352 - IOOppi_data - INFO : save data to db IOOppi_pb_g data:
date value
3729 2025-06-19 16856.25
3730 2025-06-20 16812.50
3731 2025-06-21 16812.50
3732 2025-06-22 16812.50
3733 2025-06-23 16812.50
2025-06-23 17:50:56,434 - IOOppi_data - INFO : save new data to db IOOppi_pb_g: date value ... created_at updated_at
3734 2025-06-21 16812.5 ... 2025-06-23 17:50:56.426938 2025-06-23 17:50:56.427366
3735 2025-06-22 16812.5 ... 2025-06-23 17:50:56.426938 2025-06-23 17:50:56.427366
3736 2025-06-23 16812.5 ... 2025-06-23 17:50:56.426938 2025-06-23 17:50:56.427366
[3 rows x 5 columns]
2025-06-23 17:50:56,454 - 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-06-23 17:50:57,013 - IOOppi_data - INFO : save data to db IOOppi_hc_t data:
date value
3004 2025-06-19 3173.33
3005 2025-06-20 3190.00
3006 2025-06-21 3190.00
3007 2025-06-22 3190.00
3008 2025-06-23 3190.00
2025-06-23 17:50:57,078 - IOOppi_data - INFO : save new data to db IOOppi_hc_t: date value ... created_at updated_at
3006 2025-06-21 3190.0 ... 2025-06-23 17:50:57.071067 2025-06-23 17:50:57.071500
3007 2025-06-22 3190.0 ... 2025-06-23 17:50:57.071067 2025-06-23 17:50:57.071500
3008 2025-06-23 3190.0 ... 2025-06-23 17:50:57.071067 2025-06-23 17:50:57.071500
[3 rows x 5 columns]
2025-06-23 17:50:57,097 - IOOppi_data - INFO : save diff data to db: IOOppi_hc_t: no diff data
2025-06-23 17:50:57,103 - IOOppi_data - INFO : save data to db IOOppi_hc_g data:
date value
3004 2025-06-19 3173.33
3005 2025-06-20 3190.00
3006 2025-06-21 3190.00
3007 2025-06-22 3190.00
3008 2025-06-23 3190.00
2025-06-23 17:50:57,169 - IOOppi_data - INFO : save new data to db IOOppi_hc_g: date value ... created_at updated_at
3009 2025-06-21 3190.0 ... 2025-06-23 17:50:57.162569 2025-06-23 17:50:57.162985
3010 2025-06-22 3190.0 ... 2025-06-23 17:50:57.162569 2025-06-23 17:50:57.162985
3011 2025-06-23 3190.0 ... 2025-06-23 17:50:57.162569 2025-06-23 17:50:57.162985
[3 rows x 5 columns]
2025-06-23 17:50:57,189 - 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-06-23 17:50:57,744 - IOOppi_data - INFO : save data to db IOOppi_fu_t data:
date value
3284 2025-06-19 5450.0
3285 2025-06-20 5450.0
3286 2025-06-21 5450.0
3287 2025-06-22 5450.0
3288 2025-06-23 5537.5
2025-06-23 17:50:57,812 - IOOppi_data - INFO : save new data to db IOOppi_fu_t: date value ... created_at updated_at
3286 2025-06-21 5450.0 ... 2025-06-23 17:50:57.804997 2025-06-23 17:50:57.805385
3287 2025-06-22 5450.0 ... 2025-06-23 17:50:57.804997 2025-06-23 17:50:57.805385
3288 2025-06-23 5537.5 ... 2025-06-23 17:50:57.804997 2025-06-23 17:50:57.805385
[3 rows x 5 columns]
2025-06-23 17:50:57,831 - IOOppi_data - INFO : save diff data to db: IOOppi_fu_t: no diff data
2025-06-23 17:50:57,837 - IOOppi_data - INFO : save data to db IOOppi_fu_g data:
date value
3284 2025-06-19 5450.0
3285 2025-06-20 5450.0
3286 2025-06-21 5450.0
3287 2025-06-22 5450.0
3288 2025-06-23 5537.5
2025-06-23 17:50:57,913 - IOOppi_data - INFO : save new data to db IOOppi_fu_g: date value ... created_at updated_at
3773 2025-06-21 5450.0 ... 2025-06-23 17:50:57.906150 2025-06-23 17:50:57.906531
3774 2025-06-22 5450.0 ... 2025-06-23 17:50:57.906150 2025-06-23 17:50:57.906531
3775 2025-06-23 5537.5 ... 2025-06-23 17:50:57.906150 2025-06-23 17:50:57.906531
[3 rows x 5 columns]
2025-06-23 17:50:57,932 - 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-06-23 17:50:58,507 - IOOppi_data - INFO : save data to db IOOppi_lh_t data:
date value
1348 2025-06-19 14200.0
1349 2025-06-20 14180.0
1350 2025-06-21 14180.0
1351 2025-06-22 14180.0
1352 2025-06-23 14300.0
2025-06-23 17:50:58,550 - IOOppi_data - INFO : save new data to db IOOppi_lh_t: date value ... created_at updated_at
1350 2025-06-21 14180.0 ... 2025-06-23 17:50:58.542795 2025-06-23 17:50:58.543209
1351 2025-06-22 14180.0 ... 2025-06-23 17:50:58.542795 2025-06-23 17:50:58.543209
1352 2025-06-23 14300.0 ... 2025-06-23 17:50:58.542795 2025-06-23 17:50:58.543209
[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-06-23 17:50:58,812 - IOOppi_data - INFO : save diff data to db IOOppi_lh_t: date ... updated_at
116 2021-07-05 ... 2025-06-23 17:50:58.803626
117 2021-07-06 ... 2025-06-23 17:50:58.803626
121 2021-07-12 ... 2025-06-23 17:50:58.803626
122 2021-07-13 ... 2025-06-23 17:50:58.803626
194 2021-11-01 ... 2025-06-23 17:50:58.803626
[5 rows x 6 columns]
2025-06-23 17:50:58,863 - IOOppi_data - INFO : save data to db IOOppi_lh_g data:
date value
1348 2025-06-19 14200.0
1349 2025-06-20 14180.0
1350 2025-06-21 14180.0
1351 2025-06-22 14180.0
1352 2025-06-23 14300.0
2025-06-23 17:50:58,909 - IOOppi_data - INFO : save new data to db IOOppi_lh_g: date value ... created_at updated_at
1353 2025-06-21 14180.0 ... 2025-06-23 17:50:58.901438 2025-06-23 17:50:58.901855
1354 2025-06-22 14180.0 ... 2025-06-23 17:50:58.901438 2025-06-23 17:50:58.901855
1355 2025-06-23 14300.0 ... 2025-06-23 17:50:58.901438 2025-06-23 17:50:58.901855
[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-06-23 17:50:59,153 - IOOppi_data - INFO : save diff data to db IOOppi_lh_g: date ... updated_at
116 2021-07-05 ... 2025-06-23 17:50:59.144868
117 2021-07-06 ... 2025-06-23 17:50:59.144868
121 2021-07-12 ... 2025-06-23 17:50:59.144868
122 2021-07-13 ... 2025-06-23 17:50:59.144868
194 2021-11-01 ... 2025-06-23 17:50:59.144868
[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-06-23 17:50:59,775 - IOOppi_data - INFO : save data to db IOOppi_cu_t data:
date value
3780 2025-06-19 78721.67
3781 2025-06-20 78436.67
3782 2025-06-21 78436.67
3783 2025-06-22 78436.67
3784 2025-06-23 78388.33
2025-06-23 17:50:59,855 - IOOppi_data - INFO : save new data to db IOOppi_cu_t: date ... updated_at
3782 2025-06-21 ... 2025-06-23 17:50:59.848351
3783 2025-06-22 ... 2025-06-23 17:50:59.848351
3784 2025-06-23 ... 2025-06-23 17:50:59.848351
[3 rows x 5 columns]
2025-06-23 17:50:59,875 - IOOppi_data - INFO : save diff data to db: IOOppi_cu_t: no diff data
2025-06-23 17:50:59,881 - IOOppi_data - INFO : save data to db IOOppi_cu_g data:
date value
3780 2025-06-19 78721.67
3781 2025-06-20 78436.67
3782 2025-06-21 78436.67
3783 2025-06-22 78436.67
3784 2025-06-23 78388.33
2025-06-23 17:50:59,958 - IOOppi_data - INFO : save new data to db IOOppi_cu_g: date ... updated_at
3785 2025-06-21 ... 2025-06-23 17:50:59.952201
3786 2025-06-22 ... 2025-06-23 17:50:59.952201
3787 2025-06-23 ... 2025-06-23 17:50:59.952201
[3 rows x 5 columns]
2025-06-23 17:50:59,978 - 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-06-23 17:51:00,463 - 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-06-23 17:51:00,520 - IOOppi_data - INFO : save new data to db: IOOppi_PM_t: no new data
2025-06-23 17:51:00,520 - IOOppi_data - INFO : save diff data to db: IOOppi_PM_t: no diff data
2025-06-23 17:51:00,526 - 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-06-23 17:51:00,592 - IOOppi_data - INFO : save new data to db: IOOppi_PM_g: no new data
2025-06-23 17:51:00,592 - 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-06-23 17:51:01,348 - IOOppi_data - INFO : save data to db IOOppi_sn_t data:
date value
2758 2025-06-19 264462.5
2759 2025-06-20 263350.0
2760 2025-06-21 263350.0
2761 2025-06-22 263350.0
2762 2025-06-23 261975.0
2025-06-23 17:51:01,413 - IOOppi_data - INFO : save new data to db IOOppi_sn_t: date ... updated_at
2760 2025-06-21 ... 2025-06-23 17:51:01.406611
2761 2025-06-22 ... 2025-06-23 17:51:01.406611
2762 2025-06-23 ... 2025-06-23 17:51:01.406611
[3 rows x 5 columns]
2025-06-23 17:51:01,433 - IOOppi_data - INFO : save diff data to db: IOOppi_sn_t: no diff data
2025-06-23 17:51:01,439 - IOOppi_data - INFO : save data to db IOOppi_sn_g data:
date value
2758 2025-06-19 264462.5
2759 2025-06-20 263350.0
2760 2025-06-21 263350.0
2761 2025-06-22 263350.0
2762 2025-06-23 261975.0
2025-06-23 17:51:01,503 - IOOppi_data - INFO : save new data to db IOOppi_sn_g: date ... updated_at
2763 2025-06-21 ... 2025-06-23 17:51:01.496627
2764 2025-06-22 ... 2025-06-23 17:51:01.496627
2765 2025-06-23 ... 2025-06-23 17:51:01.496627
[3 rows x 5 columns]
2025-06-23 17:51:01,523 - 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-06-23 17:51:02,251 - IOOppi_data - INFO : save data to db IOOppi_zn_t data:
date value
3779 2025-06-19 21974.0
3780 2025-06-20 22032.0
3781 2025-06-21 22032.0
3782 2025-06-22 22032.0
3783 2025-06-23 21922.0
2025-06-23 17:51:02,332 - IOOppi_data - INFO : save new data to db IOOppi_zn_t: date value ... created_at updated_at
3781 2025-06-21 22032.0 ... 2025-06-23 17:51:02.325323 2025-06-23 17:51:02.325747
3782 2025-06-22 22032.0 ... 2025-06-23 17:51:02.325323 2025-06-23 17:51:02.325747
3783 2025-06-23 21922.0 ... 2025-06-23 17:51:02.325323 2025-06-23 17:51:02.325747
[3 rows x 5 columns]
2025-06-23 17:51:02,353 - IOOppi_data - INFO : save diff data to db: IOOppi_zn_t: no diff data
2025-06-23 17:51:02,360 - IOOppi_data - INFO : save data to db IOOppi_zn_g data:
date value
3779 2025-06-19 21974.0
3780 2025-06-20 22032.0
3781 2025-06-21 22032.0
3782 2025-06-22 22032.0
3783 2025-06-23 21922.0
2025-06-23 17:51:02,439 - IOOppi_data - INFO : save new data to db IOOppi_zn_g: date value ... created_at updated_at
3784 2025-06-21 22032.0 ... 2025-06-23 17:51:02.432138 2025-06-23 17:51:02.432541
3785 2025-06-22 22032.0 ... 2025-06-23 17:51:02.432138 2025-06-23 17:51:02.432541
3786 2025-06-23 21922.0 ... 2025-06-23 17:51:02.432138 2025-06-23 17:51:02.432541
[3 rows x 5 columns]
2025-06-23 17:51:02,461 - 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-06-23 17:51:03,112 - IOOppi_data - INFO : save data to db IOOppi_wr_t data:
date value
3742 2025-06-19 3252.5
3743 2025-06-20 3250.0
3744 2025-06-21 3250.0
3745 2025-06-22 3250.0
3746 2025-06-23 3255.0
2025-06-23 17:51:03,190 - IOOppi_data - INFO : save new data to db IOOppi_wr_t: date value ... created_at updated_at
3744 2025-06-21 3250.0 ... 2025-06-23 17:51:03.182684 2025-06-23 17:51:03.183119
3745 2025-06-22 3250.0 ... 2025-06-23 17:51:03.182684 2025-06-23 17:51:03.183119
3746 2025-06-23 3255.0 ... 2025-06-23 17:51:03.182684 2025-06-23 17:51:03.183119
[3 rows x 5 columns]
2025-06-23 17:51:03,210 - IOOppi_data - INFO : save diff data to db: IOOppi_wr_t: no diff data
2025-06-23 17:51:03,216 - IOOppi_data - INFO : save data to db IOOppi_wr_g data:
date value
3742 2025-06-19 3252.5
3743 2025-06-20 3250.0
3744 2025-06-21 3250.0
3745 2025-06-22 3250.0
3746 2025-06-23 3255.0
2025-06-23 17:51:03,293 - IOOppi_data - INFO : save new data to db IOOppi_wr_g: date value ... created_at updated_at
3747 2025-06-21 3250.0 ... 2025-06-23 17:51:03.285587 2025-06-23 17:51:03.285999
3748 2025-06-22 3250.0 ... 2025-06-23 17:51:03.285587 2025-06-23 17:51:03.285999
3749 2025-06-23 3255.0 ... 2025-06-23 17:51:03.285587 2025-06-23 17:51:03.285999
[3 rows x 5 columns]
2025-06-23 17:51:03,312 - 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-06-23 17:51:03,950 - IOOppi_data - INFO : save data to db IOOppi_pg_t data:
date value
1539 2025-06-19 4890.0
1540 2025-06-20 4890.0
1541 2025-06-21 4890.0
1542 2025-06-22 4890.0
1543 2025-06-23 4935.0
2025-06-23 17:51:04,000 - IOOppi_data - INFO : save new data to db IOOppi_pg_t: date value ... created_at updated_at
1541 2025-06-21 4890.0 ... 2025-06-23 17:51:03.993324 2025-06-23 17:51:03.993713
1542 2025-06-22 4890.0 ... 2025-06-23 17:51:03.993324 2025-06-23 17:51:03.993713
1543 2025-06-23 4935.0 ... 2025-06-23 17:51:03.993324 2025-06-23 17:51:03.993713
[3 rows x 5 columns]
2025-06-23 17:51:04,021 - IOOppi_data - INFO : save diff data to db: IOOppi_pg_t: no diff data
2025-06-23 17:51:04,027 - IOOppi_data - INFO : save data to db IOOppi_pg_g data:
date value
1539 2025-06-19 4890.0
1540 2025-06-20 4890.0
1541 2025-06-21 4890.0
1542 2025-06-22 4890.0
1543 2025-06-23 4935.0
2025-06-23 17:51:04,077 - IOOppi_data - INFO : save new data to db IOOppi_pg_g: date value ... created_at updated_at
1544 2025-06-21 4890.0 ... 2025-06-23 17:51:04.069048 2025-06-23 17:51:04.069464
1545 2025-06-22 4890.0 ... 2025-06-23 17:51:04.069048 2025-06-23 17:51:04.069464
1546 2025-06-23 4935.0 ... 2025-06-23 17:51:04.069048 2025-06-23 17:51:04.069464
[3 rows x 5 columns]
2025-06-23 17:51:04,097 - 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-06-23 17:51:04,631 - IOOppi_data - INFO : save data to db IOOppi_cs_t data:
date value
2813 2025-06-19 2338.57
2814 2025-06-20 2342.86
2815 2025-06-21 2342.86
2816 2025-06-22 2342.86
2817 2025-06-23 2345.71
2025-06-23 17:51:04,695 - IOOppi_data - INFO : save new data to db IOOppi_cs_t: date value ... created_at updated_at
2815 2025-06-21 2342.86 ... 2025-06-23 17:51:04.688094 2025-06-23 17:51:04.688476
2816 2025-06-22 2342.86 ... 2025-06-23 17:51:04.688094 2025-06-23 17:51:04.688476
2817 2025-06-23 2345.71 ... 2025-06-23 17:51:04.688094 2025-06-23 17:51:04.688476
[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-06-23 17:51:04,738 - IOOppi_data - INFO : save diff data to db IOOppi_cs_t: date ... updated_at
2814 2025-06-20 ... 2025-06-23 17:51:04.730346
[1 rows x 6 columns]
2025-06-23 17:51:04,763 - IOOppi_data - INFO : save data to db IOOppi_cs_g data:
date value
2813 2025-06-19 2338.57
2814 2025-06-20 2342.86
2815 2025-06-21 2342.86
2816 2025-06-22 2342.86
2817 2025-06-23 2345.71
2025-06-23 17:51:04,828 - IOOppi_data - INFO : save new data to db IOOppi_cs_g: date value ... created_at updated_at
2818 2025-06-21 2342.86 ... 2025-06-23 17:51:04.820534 2025-06-23 17:51:04.820972
2819 2025-06-22 2342.86 ... 2025-06-23 17:51:04.820534 2025-06-23 17:51:04.820972
2820 2025-06-23 2345.71 ... 2025-06-23 17:51:04.820534 2025-06-23 17:51:04.820972
[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-06-23 17:51:04,872 - IOOppi_data - INFO : save diff data to db IOOppi_cs_g: date ... updated_at
2817 2025-06-20 ... 2025-06-23 17:51:04.864403
[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-06-23 17:51:05,414 - IOOppi_data - INFO : save data to db IOOppi_cs_t data:
date value
2813 2025-06-19 2338.57
2814 2025-06-20 2342.86
2815 2025-06-21 2342.86
2816 2025-06-22 2342.86
2817 2025-06-23 2944.00
2025-06-23 17:51:05,468 - 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-06-23 17:51:05,491 - IOOppi_data - INFO : save diff data to db IOOppi_cs_t: date ... updated_at
2817 2025-06-23 ... 2025-06-23 17:51:05.483855
[1 rows x 6 columns]
2025-06-23 17:51:05,516 - IOOppi_data - INFO : save data to db IOOppi_cs_g data:
date value
2813 2025-06-19 2338.57
2814 2025-06-20 2342.86
2815 2025-06-21 2342.86
2816 2025-06-22 2342.86
2817 2025-06-23 2944.00
2025-06-23 17:51:05,569 - 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-06-23 17:51:05,592 - IOOppi_data - INFO : save diff data to db IOOppi_cs_g: date ... updated_at
2820 2025-06-23 ... 2025-06-23 17:51:05.584903
[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-06-23 17:51:06,113 - IOOppi_data - INFO : save data to db IOOppi_RS_t data:
date value
3170 2025-06-19 9833.33
3171 2025-06-20 9875.00
3172 2025-06-21 9875.00
3173 2025-06-22 9875.00
3174 2025-06-23 9878.33
2025-06-23 17:51:06,169 - IOOppi_data - INFO : save new data to db: IOOppi_RS_t: no new data
2025-06-23 17:51:06,169 - IOOppi_data - INFO : save diff data to db: IOOppi_RS_t: no diff data
2025-06-23 17:51:06,174 - IOOppi_data - INFO : save data to db IOOppi_RS_g data:
date value
3170 2025-06-19 9833.33
3171 2025-06-20 9875.00
3172 2025-06-21 9875.00
3173 2025-06-22 9875.00
3174 2025-06-23 9878.33
2025-06-23 17:51:06,232 - IOOppi_data - INFO : save new data to db: IOOppi_RS_g: no new data
2025-06-23 17:51:06,232 - 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-06-23 17:51:06,769 - IOOppi_data - INFO : save data to db IOOppi_eg_t data:
date value
1854 2025-06-19 4553.33
1855 2025-06-20 4553.33
1856 2025-06-21 4558.33
1857 2025-06-22 4558.33
1858 2025-06-23 4550.00
2025-06-23 17:51:06,823 - IOOppi_data - INFO : save new data to db IOOppi_eg_t: date value ... created_at updated_at
1856 2025-06-21 4558.33 ... 2025-06-23 17:51:06.814709 2025-06-23 17:51:06.815153
1857 2025-06-22 4558.33 ... 2025-06-23 17:51:06.814709 2025-06-23 17:51:06.815153
1858 2025-06-23 4550.00 ... 2025-06-23 17:51:06.814709 2025-06-23 17:51:06.815153
[3 rows x 5 columns]
2025-06-23 17:51:06,845 - IOOppi_data - INFO : save diff data to db: IOOppi_eg_t: no diff data
2025-06-23 17:51:06,851 - IOOppi_data - INFO : save data to db IOOppi_eg_g data:
date value
1854 2025-06-19 4553.33
1855 2025-06-20 4553.33
1856 2025-06-21 4558.33
1857 2025-06-22 4558.33
1858 2025-06-23 4550.00
2025-06-23 17:51:06,903 - IOOppi_data - INFO : save new data to db IOOppi_eg_g: date value ... created_at updated_at
1859 2025-06-21 4558.33 ... 2025-06-23 17:51:06.896412 2025-06-23 17:51:06.896828
1860 2025-06-22 4558.33 ... 2025-06-23 17:51:06.896412 2025-06-23 17:51:06.896828
1861 2025-06-23 4550.00 ... 2025-06-23 17:51:06.896412 2025-06-23 17:51:06.896828
[3 rows x 5 columns]
2025-06-23 17:51:06,923 - 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-06-23 17:51:07,467 - IOOppi_data - INFO : save data to db IOOppi_sp_t data:
date value
1863 2025-06-19 6090.00
1864 2025-06-20 6083.33
1865 2025-06-21 6083.33
1866 2025-06-22 6083.33
1867 2025-06-23 6083.33
2025-06-23 17:51:07,520 - IOOppi_data - INFO : save new data to db IOOppi_sp_t: date value ... created_at updated_at
1865 2025-06-21 6083.33 ... 2025-06-23 17:51:07.512165 2025-06-23 17:51:07.512544
1866 2025-06-22 6083.33 ... 2025-06-23 17:51:07.512165 2025-06-23 17:51:07.512544
1867 2025-06-23 6083.33 ... 2025-06-23 17:51:07.512165 2025-06-23 17:51:07.512544
[3 rows x 5 columns]
2025-06-23 17:51:07,543 - IOOppi_data - INFO : save diff data to db: IOOppi_sp_t: no diff data
2025-06-23 17:51:07,548 - IOOppi_data - INFO : save data to db IOOppi_sp_g data:
date value
1863 2025-06-19 6090.00
1864 2025-06-20 6083.33
1865 2025-06-21 6083.33
1866 2025-06-22 6083.33
1867 2025-06-23 6083.33
2025-06-23 17:51:07,599 - IOOppi_data - INFO : save new data to db IOOppi_sp_g: date value ... created_at updated_at
1868 2025-06-21 6083.33 ... 2025-06-23 17:51:07.592323 2025-06-23 17:51:07.592716
1869 2025-06-22 6083.33 ... 2025-06-23 17:51:07.592323 2025-06-23 17:51:07.592716
1870 2025-06-23 6083.33 ... 2025-06-23 17:51:07.592323 2025-06-23 17:51:07.592716
[3 rows x 5 columns]
2025-06-23 17:51:07,619 - 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-06-23 17:51:08,162 - IOOppi_data - INFO : save data to db IOOppi_p_t data:
date value
3531 2025-06-19 8896.0
3532 2025-06-20 8832.0
3533 2025-06-21 8832.0
3534 2025-06-22 8832.0
3535 2025-06-23 8732.0
2025-06-23 17:51:08,234 - IOOppi_data - INFO : save new data to db IOOppi_p_t: date value ... created_at updated_at
3533 2025-06-21 8832.0 ... 2025-06-23 17:51:08.227097 2025-06-23 17:51:08.227477
3534 2025-06-22 8832.0 ... 2025-06-23 17:51:08.227097 2025-06-23 17:51:08.227477
3535 2025-06-23 8732.0 ... 2025-06-23 17:51:08.227097 2025-06-23 17:51:08.227477
[3 rows x 5 columns]
2025-06-23 17:51:08,253 - IOOppi_data - INFO : save diff data to db: IOOppi_p_t: no diff data
2025-06-23 17:51:08,260 - IOOppi_data - INFO : save data to db IOOppi_p_g data:
date value
3531 2025-06-19 8896.0
3532 2025-06-20 8832.0
3533 2025-06-21 8832.0
3534 2025-06-22 8832.0
3535 2025-06-23 8732.0
2025-06-23 17:51:08,334 - IOOppi_data - INFO : save new data to db IOOppi_p_g: date value ... created_at updated_at
3536 2025-06-21 8832.0 ... 2025-06-23 17:51:08.327303 2025-06-23 17:51:08.327692
3537 2025-06-22 8832.0 ... 2025-06-23 17:51:08.327303 2025-06-23 17:51:08.327692
3538 2025-06-23 8732.0 ... 2025-06-23 17:51:08.327303 2025-06-23 17:51:08.327692
[3 rows x 5 columns]
2025-06-23 17:51:08,357 - IOOppi_data - INFO : save diff data to db: IOOppi_p_g: no diff data