=========================================================================
2025-08-19 17:50:26 Tue START TASK.01 IOOppi_data update_data
=========================================================================
/usr/local/lib/python3.10/site-packages/urllib3/connectionpool.py:1056: InsecureRequestWarning: Unverified HTTPS request is being made to host 'www.100ppi.com'. Adding certificate verification is strongly advised. See: https://urllib3.readthedocs.io/en/1.26.x/advanced-usage.html#ssl-warnings
warnings.warn(
2025-08-19 17:50:28,817 - IOOppi_data - INFO : save data to db IOOppi_rb_t data:
date value
3396 2025-08-15 3272.0
3397 2025-08-16 3272.0
3398 2025-08-17 3272.0
3399 2025-08-18 3267.0
3400 2025-08-19 3246.0
2025-08-19 17:50:28,886 - IOOppi_data - INFO : save new data to db IOOppi_rb_t: date value ... created_at updated_at
3400 2025-08-19 3246.0 ... 2025-08-19 17:50:28.878651 2025-08-19 17:50:28.879067
[1 rows x 5 columns]
=========================================================================
2025-08-19 18:30:57 Tue START TASK.01 IOOppi_data update_data
=========================================================================
/usr/local/lib/python3.10/site-packages/urllib3/connectionpool.py:1056: InsecureRequestWarning: Unverified HTTPS request is being made to host 'www.100ppi.com'. Adding certificate verification is strongly advised. See: https://urllib3.readthedocs.io/en/1.26.x/advanced-usage.html#ssl-warnings
warnings.warn(
2025-08-19 18:30:59,934 - IOOppi_data - INFO : save data to db IOOppi_rb_t data:
date value
3396 2025-08-15 3272.0
3397 2025-08-16 3272.0
3398 2025-08-17 3272.0
3399 2025-08-18 3267.0
3400 2025-08-19 3246.0
2025-08-19 18:31:00,004 - IOOppi_data - INFO : save new data to db IOOppi_rb_t: date value ... created_at updated_at
3400 2025-08-19 3246.0 ... 2025-08-19 18:30:59.997037 2025-08-19 18:30:59.997481
[1 rows x 5 columns]
=========================================================================
2025-08-19 19:11:28 Tue START TASK.01 IOOppi_data update_data
=========================================================================
/usr/local/lib/python3.10/site-packages/urllib3/connectionpool.py:1056: InsecureRequestWarning: Unverified HTTPS request is being made to host 'www.100ppi.com'. Adding certificate verification is strongly advised. See: https://urllib3.readthedocs.io/en/1.26.x/advanced-usage.html#ssl-warnings
warnings.warn(
2025-08-19 19:11:30,756 - IOOppi_data - INFO : save data to db IOOppi_rb_t data:
date value
3396 2025-08-15 3272.0
3397 2025-08-16 3272.0
3398 2025-08-17 3272.0
3399 2025-08-18 3267.0
3400 2025-08-19 3246.0
2025-08-19 19:11:30,826 - IOOppi_data - INFO : save new data to db IOOppi_rb_t: date value ... created_at updated_at
3400 2025-08-19 3246.0 ... 2025-08-19 19:11:30.819264 2025-08-19 19:11:30.819688
[1 rows x 5 columns]
=========================================================================
2025-08-19 19:52:00 Tue START TASK.01 IOOppi_data update_data
=========================================================================
/usr/local/lib/python3.10/site-packages/urllib3/connectionpool.py:1056: InsecureRequestWarning: Unverified HTTPS request is being made to host 'www.100ppi.com'. Adding certificate verification is strongly advised. See: https://urllib3.readthedocs.io/en/1.26.x/advanced-usage.html#ssl-warnings
warnings.warn(
2025-08-19 19:52:02,140 - IOOppi_data - INFO : save data to db IOOppi_rb_t data:
date value
3396 2025-08-15 3272.0
3397 2025-08-16 3272.0
3398 2025-08-17 3272.0
3399 2025-08-18 3267.0
3400 2025-08-19 3246.0
2025-08-19 19:52:02,220 - IOOppi_data - INFO : save new data to db IOOppi_rb_t: date value ... created_at updated_at
3400 2025-08-19 3246.0 ... 2025-08-19 19:52:02.212237 2025-08-19 19:52:02.212683
[1 rows x 5 columns]
2025-08-20 11:21:29,694 - IOOppi_data - INFO : save diff data to db: IOOppi_rb_t: no diff data
2025-08-20 11:21:29,701 - IOOppi_data - INFO : save data to db IOOppi_rb_g data:
date value
3396 2025-08-15 3272.0
3397 2025-08-16 3272.0
3398 2025-08-17 3272.0
3399 2025-08-18 3267.0
3400 2025-08-19 3246.0
2025-08-20 11:21:29,768 - IOOppi_data - INFO : save new data to db IOOppi_rb_g: date value ... created_at updated_at
3403 2025-08-19 3246.0 ... 2025-08-20 11:21:29.760800 2025-08-20 11:21:29.761274
[1 rows x 5 columns]
2025-08-20 11:21:29,787 - 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-08-20 11:21:30,420 - IOOppi_data - INFO : save data to db IOOppi_MA_t data:
date value
3617 2025-08-15 2338.33
3618 2025-08-16 2338.33
3619 2025-08-17 2338.33
3620 2025-08-18 2318.67
3621 2025-08-19 2301.67
2025-08-20 11:21:30,495 - IOOppi_data - INFO : save new data to db IOOppi_MA_t: date value ... created_at updated_at
3621 2025-08-19 2301.67 ... 2025-08-20 11:21:30.487065 2025-08-20 11:21:30.487490
[1 rows x 5 columns]
2025-08-20 11:21:30,515 - IOOppi_data - INFO : save diff data to db: IOOppi_MA_t: no diff data
2025-08-20 11:21:30,522 - IOOppi_data - INFO : save data to db IOOppi_MA_g data:
date value
3617 2025-08-15 2338.33
3618 2025-08-16 2338.33
3619 2025-08-17 2338.33
3620 2025-08-18 2318.67
3621 2025-08-19 2301.67
2025-08-20 11:21:30,594 - IOOppi_data - INFO : save new data to db IOOppi_MA_g: date value ... created_at updated_at
3625 2025-08-19 2301.67 ... 2025-08-20 11:21:30.585501 2025-08-20 11:21:30.585919
[1 rows x 5 columns]
2025-08-20 11:21:30,614 - 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-08-20 11:21:31,200 - IOOppi_data - INFO : save data to db IOOppi_PTA_t data:
date value
957 2025-08-15 4726.88
958 2025-08-16 4726.88
959 2025-08-17 4726.88
960 2025-08-18 4720.25
961 2025-08-19 4726.00
2025-08-20 11:21:31,238 - IOOppi_data - INFO : save new data to db IOOppi_PTA_t: date value ... created_at updated_at
961 2025-08-19 4726.0 ... 2025-08-20 11:21:31.231115 2025-08-20 11:21:31.231551
[1 rows x 5 columns]
2025-08-20 11:21:31,258 - IOOppi_data - INFO : save diff data to db: IOOppi_PTA_t: no diff data
2025-08-20 11:21:31,263 - IOOppi_data - INFO : save data to db IOOppi_PTA_g data:
date value
957 2025-08-15 4726.88
958 2025-08-16 4726.88
959 2025-08-17 4726.88
960 2025-08-18 4720.25
961 2025-08-19 4726.00
2025-08-20 11:21:31,301 - IOOppi_data - INFO : save new data to db IOOppi_PTA_g: date value ... created_at updated_at
961 2025-08-19 4726.0 ... 2025-08-20 11:21:31.293937 2025-08-20 11:21:31.294346
[1 rows x 5 columns]
2025-08-20 11:21:31,321 - 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-08-20 11:21:31,899 - IOOppi_data - INFO : save data to db IOOppi_ru_t data:
date value
3836 2025-08-15 14900.00
3837 2025-08-16 14900.00
3838 2025-08-17 14900.00
3839 2025-08-18 14891.67
3840 2025-08-19 14958.33
2025-08-20 11:21:31,973 - IOOppi_data - INFO : save new data to db IOOppi_ru_t: date ... updated_at
3840 2025-08-19 ... 2025-08-20 11:21:31.967012
[1 rows x 5 columns]
2025-08-20 11:21:31,994 - IOOppi_data - INFO : save diff data to db: IOOppi_ru_t: no diff data
2025-08-20 11:21:32,000 - IOOppi_data - INFO : save data to db IOOppi_ru_g data:
date value
3836 2025-08-15 14900.00
3837 2025-08-16 14900.00
3838 2025-08-17 14900.00
3839 2025-08-18 14891.67
3840 2025-08-19 14958.33
2025-08-20 11:21:32,082 - IOOppi_data - INFO : save new data to db IOOppi_ru_g: date ... updated_at
3843 2025-08-19 ... 2025-08-20 11:21:32.075391
[1 rows x 5 columns]
2025-08-20 11:21:32,102 - 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-08-20 11:21:32,768 - IOOppi_data - INFO : save data to db IOOppi_i_t data:
date value
3168 2025-08-15 786.67
3169 2025-08-16 787.00
3170 2025-08-17 787.00
3171 2025-08-18 789.78
3172 2025-08-19 780.78
2025-08-20 11:21:32,866 - IOOppi_data - INFO : save new data to db IOOppi_i_t: date value ... created_at updated_at
3172 2025-08-19 780.78 ... 2025-08-20 11:21:32.855806 2025-08-20 11:21:32.856371
[1 rows x 5 columns]
2025-08-20 11:21:32,888 - IOOppi_data - INFO : save diff data to db: IOOppi_i_t: no diff data
2025-08-20 11:21:32,897 - IOOppi_data - INFO : save data to db IOOppi_i_g data:
date value
3168 2025-08-15 786.67
3169 2025-08-16 787.00
3170 2025-08-17 787.00
3171 2025-08-18 789.78
3172 2025-08-19 780.78
2025-08-20 11:21:32,996 - IOOppi_data - INFO : save new data to db IOOppi_i_g: date value ... created_at updated_at
3175 2025-08-19 780.78 ... 2025-08-20 11:21:32.985275 2025-08-20 11:21:32.985879
[1 rows x 5 columns]
2025-08-20 11:21:33,015 - 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-08-20 11:21:33,636 - IOOppi_data - INFO : save data to db IOOppi_FG_t data:
date value
3371 2025-08-15 1158.4
3372 2025-08-16 1142.4
3373 2025-08-17 1142.4
3374 2025-08-18 1142.4
3375 2025-08-19 1142.4
2025-08-20 11:21:33,720 - IOOppi_data - INFO : save new data to db IOOppi_FG_t: date value ... created_at updated_at
3375 2025-08-19 1142.4 ... 2025-08-20 11:21:33.712443 2025-08-20 11:21:33.712895
[1 rows x 5 columns]
/root/project/IOOppi_data/IOOppi_request.py:308: SettingWithCopyWarning:
A value is trying to be set on a copy of a slice from a DataFrame.
Try using .loc[row_indexer,col_indexer] = value instead
See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy
diff_df.loc[:, 'index_code'] = index_code
/root/project/IOOppi_data/IOOppi_request.py:309: SettingWithCopyWarning:
A value is trying to be set on a copy of a slice from a DataFrame.
Try using .loc[row_indexer,col_indexer] = value instead
See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy
diff_df.loc[:, 'created_at'] = datetime.datetime.now()
/root/project/IOOppi_data/IOOppi_request.py:310: SettingWithCopyWarning:
A value is trying to be set on a copy of a slice from a DataFrame.
Try using .loc[row_indexer,col_indexer] = value instead
See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy
diff_df.loc[:, 'updated_at'] = datetime.datetime.now()
2025-08-20 11:21:35,699 - IOOppi_data - INFO : save diff data to db IOOppi_FG_t: date ... updated_at
12 2012-12-19 ... 2025-08-20 11:21:35.691479
21 2013-01-04 ... 2025-08-20 11:21:35.691479
54 2013-02-27 ... 2025-08-20 11:21:35.691479
60 2013-03-07 ... 2025-08-20 11:21:35.691479
61 2013-03-08 ... 2025-08-20 11:21:35.691479
[5 rows x 6 columns]
2025-08-20 11:21:35,856 - IOOppi_data - INFO : save data to db IOOppi_FG_g data:
date value
3371 2025-08-15 1158.4
3372 2025-08-16 1142.4
3373 2025-08-17 1142.4
3374 2025-08-18 1142.4
3375 2025-08-19 1142.4
2025-08-20 11:21:35,923 - IOOppi_data - INFO : save new data to db IOOppi_FG_g: date value ... created_at updated_at
3379 2025-08-19 1142.4 ... 2025-08-20 11:21:35.916447 2025-08-20 11:21:35.916864
[1 rows x 5 columns]
/root/project/IOOppi_data/IOOppi_request.py:308: SettingWithCopyWarning:
A value is trying to be set on a copy of a slice from a DataFrame.
Try using .loc[row_indexer,col_indexer] = value instead
See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy
diff_df.loc[:, 'index_code'] = index_code
/root/project/IOOppi_data/IOOppi_request.py:309: SettingWithCopyWarning:
A value is trying to be set on a copy of a slice from a DataFrame.
Try using .loc[row_indexer,col_indexer] = value instead
See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy
diff_df.loc[:, 'created_at'] = datetime.datetime.now()
/root/project/IOOppi_data/IOOppi_request.py:310: SettingWithCopyWarning:
A value is trying to be set on a copy of a slice from a DataFrame.
Try using .loc[row_indexer,col_indexer] = value instead
See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy
diff_df.loc[:, 'updated_at'] = datetime.datetime.now()
2025-08-20 11:21:37,880 - IOOppi_data - INFO : save diff data to db IOOppi_FG_g: date ... updated_at
12 2012-12-19 ... 2025-08-20 11:21:37.871942
21 2013-01-04 ... 2025-08-20 11:21:37.871942
54 2013-02-27 ... 2025-08-20 11:21:37.871942
60 2013-03-07 ... 2025-08-20 11:21:37.871942
61 2013-03-08 ... 2025-08-20 11:21:37.871942
[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-08-20 11:21:38,657 - IOOppi_data - INFO : save data to db IOOppi_eb_t data:
date value
1716 2025-08-15 7596.0
1717 2025-08-16 7596.0
1718 2025-08-17 7596.0
1719 2025-08-18 7568.0
1720 2025-08-19 7572.0
2025-08-20 11:21:38,703 - IOOppi_data - INFO : save new data to db IOOppi_eb_t: date value ... created_at updated_at
1720 2025-08-19 7572.0 ... 2025-08-20 11:21:38.696352 2025-08-20 11:21:38.696772
[1 rows x 5 columns]
2025-08-20 11:21:38,723 - IOOppi_data - INFO : save diff data to db: IOOppi_eb_t: no diff data
2025-08-20 11:21:38,729 - IOOppi_data - INFO : save data to db IOOppi_eb_g data:
date value
1716 2025-08-15 7596.0
1717 2025-08-16 7596.0
1718 2025-08-17 7596.0
1719 2025-08-18 7568.0
1720 2025-08-19 7572.0
2025-08-20 11:21:38,776 - IOOppi_data - INFO : save new data to db IOOppi_eb_g: date value ... created_at updated_at
1723 2025-08-19 7572.0 ... 2025-08-20 11:21:38.769125 2025-08-20 11:21:38.769512
[1 rows x 5 columns]
2025-08-20 11:21:38,795 - 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-08-20 11:21:39,513 - IOOppi_data - INFO : save data to db IOOppi_SR_t data:
date value
3827 2025-08-15 5951.67
3828 2025-08-16 5951.67
3829 2025-08-17 5951.67
3830 2025-08-18 5950.00
3831 2025-08-19 5951.67
2025-08-20 11:21:39,586 - IOOppi_data - INFO : save new data to db IOOppi_SR_t: date value ... created_at updated_at
3831 2025-08-19 5951.67 ... 2025-08-20 11:21:39.579446 2025-08-20 11:21:39.579877
[1 rows x 5 columns]
2025-08-20 11:21:39,606 - IOOppi_data - INFO : save diff data to db: IOOppi_SR_t: no diff data
2025-08-20 11:21:39,613 - IOOppi_data - INFO : save data to db IOOppi_SR_g data:
date value
3827 2025-08-15 5951.67
3828 2025-08-16 5951.67
3829 2025-08-17 5951.67
3830 2025-08-18 5950.00
3831 2025-08-19 5951.67
2025-08-20 11:21:39,686 - IOOppi_data - INFO : save new data to db IOOppi_SR_g: date value ... created_at updated_at
3835 2025-08-19 5951.67 ... 2025-08-20 11:21:39.679006 2025-08-20 11:21:39.679396
[1 rows x 5 columns]
2025-08-20 11:21:39,706 - 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-08-20 11:21:40,447 - IOOppi_data - INFO : save data to db IOOppi_ss_t data:
date value
1717 2025-08-15 13237.5
1718 2025-08-16 13237.5
1719 2025-08-17 13237.5
1720 2025-08-18 13237.5
1721 2025-08-19 13237.5
2025-08-20 11:21:40,501 - IOOppi_data - INFO : save new data to db IOOppi_ss_t: date value ... created_at updated_at
1721 2025-08-19 13237.5 ... 2025-08-20 11:21:40.491338 2025-08-20 11:21:40.491936
[1 rows x 5 columns]
2025-08-20 11:21:40,521 - IOOppi_data - INFO : save diff data to db: IOOppi_ss_t: no diff data
2025-08-20 11:21:40,527 - IOOppi_data - INFO : save data to db IOOppi_ss_g data:
date value
1717 2025-08-15 13237.5
1718 2025-08-16 13237.5
1719 2025-08-17 13237.5
1720 2025-08-18 13237.5
1721 2025-08-19 13237.5
2025-08-20 11:21:40,573 - IOOppi_data - INFO : save new data to db IOOppi_ss_g: date value ... created_at updated_at
1724 2025-08-19 13237.5 ... 2025-08-20 11:21:40.566118 2025-08-20 11:21:40.566489
[1 rows x 5 columns]
2025-08-20 11:21:40,591 - 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-08-20 11:21:41,279 - IOOppi_data - INFO : save data to db IOOppi_RS_t data:
date value
3227 2025-08-15 9876.67
3228 2025-08-16 9876.67
3229 2025-08-17 9876.67
3230 2025-08-18 9948.33
3231 2025-08-19 9966.67
2025-08-20 11:21:41,345 - IOOppi_data - INFO : save new data to db IOOppi_RS_t: date value ... created_at updated_at
3231 2025-08-19 9966.67 ... 2025-08-20 11:21:41.337595 2025-08-20 11:21:41.338012
[1 rows x 5 columns]
2025-08-20 11:21:41,364 - IOOppi_data - INFO : save diff data to db: IOOppi_RS_t: no diff data
2025-08-20 11:21:41,370 - IOOppi_data - INFO : save data to db IOOppi_RS_g data:
date value
3227 2025-08-15 9876.67
3228 2025-08-16 9876.67
3229 2025-08-17 9876.67
3230 2025-08-18 9948.33
3231 2025-08-19 9966.67
2025-08-20 11:21:41,436 - IOOppi_data - INFO : save new data to db IOOppi_RS_g: date value ... created_at updated_at
3235 2025-08-19 9966.67 ... 2025-08-20 11:21:41.428869 2025-08-20 11:21:41.429259
[1 rows x 5 columns]
2025-08-20 11:21:41,454 - 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-08-20 11:21:42,231 - IOOppi_data - INFO : save data to db IOOppi_RM_t data:
date value
3350 2025-08-15 2648.33
3351 2025-08-16 2648.33
3352 2025-08-17 2648.33
3353 2025-08-18 2661.67
3354 2025-08-19 2671.67
2025-08-20 11:21:42,298 - IOOppi_data - INFO : save new data to db IOOppi_RM_t: date value ... created_at updated_at
3354 2025-08-19 2671.67 ... 2025-08-20 11:21:42.290827 2025-08-20 11:21:42.291221
[1 rows x 5 columns]
2025-08-20 11:21:42,319 - IOOppi_data - INFO : save diff data to db: IOOppi_RM_t: no diff data
2025-08-20 11:21:42,325 - IOOppi_data - INFO : save data to db IOOppi_RM_g data:
date value
3350 2025-08-15 2648.33
3351 2025-08-16 2648.33
3352 2025-08-17 2648.33
3353 2025-08-18 2661.67
3354 2025-08-19 2671.67
2025-08-20 11:21:42,395 - IOOppi_data - INFO : save new data to db IOOppi_RM_g: date value ... created_at updated_at
3358 2025-08-19 2671.67 ... 2025-08-20 11:21:42.387702 2025-08-20 11:21:42.388120
[1 rows x 5 columns]
2025-08-20 11:21:42,415 - 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-08-20 11:21:43,018 - IOOppi_data - INFO : save data to db IOOppi_SA_t data:
date value
1554 2025-08-15 1290.0
1555 2025-08-16 1290.0
1556 2025-08-17 1290.0
1557 2025-08-18 1290.0
1558 2025-08-19 1290.0
2025-08-20 11:21:43,063 - IOOppi_data - INFO : save new data to db IOOppi_SA_t: date value ... created_at updated_at
1558 2025-08-19 1290.0 ... 2025-08-20 11:21:43.055747 2025-08-20 11:21:43.056145
[1 rows x 5 columns]
2025-08-20 11:21:43,084 - IOOppi_data - INFO : save diff data to db: IOOppi_SA_t: no diff data
2025-08-20 11:21:43,090 - IOOppi_data - INFO : save data to db IOOppi_SA_g data:
date value
1554 2025-08-15 1290.0
1555 2025-08-16 1290.0
1556 2025-08-17 1290.0
1557 2025-08-18 1290.0
1558 2025-08-19 1290.0
2025-08-20 11:21:43,135 - IOOppi_data - INFO : save new data to db IOOppi_SA_g: date value ... created_at updated_at
1562 2025-08-19 1290.0 ... 2025-08-20 11:21:43.127985 2025-08-20 11:21:43.128393
[1 rows x 5 columns]
2025-08-20 11:21:43,154 - 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-08-20 11:21:43,801 - IOOppi_data - INFO : save data to db IOOppi_PF_t data:
date value
1467 2025-08-15 6471.25
1468 2025-08-16 6471.25
1469 2025-08-17 6471.25
1470 2025-08-18 6472.50
1471 2025-08-19 6485.00
2025-08-20 11:21:43,846 - IOOppi_data - INFO : save new data to db IOOppi_PF_t: date value ... created_at updated_at
1471 2025-08-19 6485.0 ... 2025-08-20 11:21:43.838910 2025-08-20 11:21:43.839332
[1 rows x 5 columns]
2025-08-20 11:21:43,866 - IOOppi_data - INFO : save diff data to db: IOOppi_PF_t: no diff data
2025-08-20 11:21:43,872 - IOOppi_data - INFO : save data to db IOOppi_PF_g data:
date value
1467 2025-08-15 6471.25
1468 2025-08-16 6471.25
1469 2025-08-17 6471.25
1470 2025-08-18 6472.50
1471 2025-08-19 6485.00
2025-08-20 11:21:43,918 - IOOppi_data - INFO : save new data to db IOOppi_PF_g: date value ... created_at updated_at
1475 2025-08-19 6485.0 ... 2025-08-20 11:21:43.910326 2025-08-20 11:21:43.910779
[1 rows x 5 columns]
2025-08-20 11:21:43,939 - 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-08-20 11:21:44,520 - IOOppi_data - INFO : save data to db IOOppi_m_t data:
date value
3840 2025-08-15 3092.0
3841 2025-08-16 3092.0
3842 2025-08-17 3092.0
3843 2025-08-18 3114.0
3844 2025-08-19 3122.0
2025-08-20 11:21:44,595 - IOOppi_data - INFO : save new data to db IOOppi_m_t: date value ... created_at updated_at
3844 2025-08-19 3122.0 ... 2025-08-20 11:21:44.586715 2025-08-20 11:21:44.587127
[1 rows x 5 columns]
2025-08-20 11:21:44,615 - IOOppi_data - INFO : save diff data to db: IOOppi_m_t: no diff data
2025-08-20 11:21:44,622 - IOOppi_data - INFO : save data to db IOOppi_m_g data:
date value
3840 2025-08-15 3092.0
3841 2025-08-16 3092.0
3842 2025-08-17 3092.0
3843 2025-08-18 3114.0
3844 2025-08-19 3122.0
2025-08-20 11:21:44,695 - IOOppi_data - INFO : save new data to db IOOppi_m_g: date value ... created_at updated_at
3847 2025-08-19 3122.0 ... 2025-08-20 11:21:44.687848 2025-08-20 11:21:44.688278
[1 rows x 5 columns]
2025-08-20 11:21:44,715 - 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-08-20 11:21:45,427 - IOOppi_data - INFO : save data to db IOOppi_y_t data:
date value
3610 2025-08-15 8608.0
3611 2025-08-16 8608.0
3612 2025-08-17 8608.0
3613 2025-08-18 8598.0
3614 2025-08-19 8598.0
2025-08-20 11:21:45,501 - IOOppi_data - INFO : save new data to db IOOppi_y_t: date value ... created_at updated_at
3614 2025-08-19 8598.0 ... 2025-08-20 11:21:45.493065 2025-08-20 11:21:45.493524
[1 rows x 5 columns]
2025-08-20 11:21:45,520 - IOOppi_data - INFO : save diff data to db: IOOppi_y_t: no diff data
2025-08-20 11:21:45,526 - IOOppi_data - INFO : save data to db IOOppi_y_g data:
date value
3610 2025-08-15 8608.0
3611 2025-08-16 8608.0
3612 2025-08-17 8608.0
3613 2025-08-18 8598.0
3614 2025-08-19 8598.0
2025-08-20 11:21:45,598 - IOOppi_data - INFO : save new data to db IOOppi_y_g: date value ... created_at updated_at
3617 2025-08-19 8598.0 ... 2025-08-20 11:21:45.590946 2025-08-20 11:21:45.591351
[1 rows x 5 columns]
2025-08-20 11:21:45,617 - 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-08-20 11:21:46,198 - IOOppi_data - INFO : save data to db IOOppi_a_t data:
date value
3576 2025-08-15 4300.0
3577 2025-08-16 4300.0
3578 2025-08-17 4300.0
3579 2025-08-18 4300.0
3580 2025-08-19 4300.0
2025-08-20 11:21:46,268 - IOOppi_data - INFO : save new data to db IOOppi_a_t: date value ... created_at updated_at
3580 2025-08-19 4300.0 ... 2025-08-20 11:21:46.260842 2025-08-20 11:21:46.261275
[1 rows x 5 columns]
2025-08-20 11:21:46,288 - IOOppi_data - INFO : save diff data to db: IOOppi_a_t: no diff data
2025-08-20 11:21:46,295 - IOOppi_data - INFO : save data to db IOOppi_a_g data:
date value
3576 2025-08-15 4300.0
3577 2025-08-16 4300.0
3578 2025-08-17 4300.0
3579 2025-08-18 4300.0
3580 2025-08-19 4300.0
2025-08-20 11:21:46,367 - IOOppi_data - INFO : save new data to db IOOppi_a_g: date value ... created_at updated_at
3583 2025-08-19 4300.0 ... 2025-08-20 11:21:46.359606 2025-08-20 11:21:46.360010
[1 rows x 5 columns]
2025-08-20 11:21:46,390 - 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-08-20 11:21:47,022 - IOOppi_data - INFO : save data to db IOOppi_SF_t data:
date value
2953 2025-08-15 5504.29
2954 2025-08-16 5504.29
2955 2025-08-17 5504.29
2956 2025-08-18 5502.86
2957 2025-08-19 5398.57
2025-08-20 11:21:47,083 - IOOppi_data - INFO : save new data to db IOOppi_SF_t: date value ... created_at updated_at
2957 2025-08-19 5398.57 ... 2025-08-20 11:21:47.076047 2025-08-20 11:21:47.076431
[1 rows x 5 columns]
2025-08-20 11:21:47,103 - IOOppi_data - INFO : save diff data to db: IOOppi_SF_t: no diff data
2025-08-20 11:21:47,108 - IOOppi_data - INFO : save data to db IOOppi_SF_g data:
date value
2953 2025-08-15 5504.29
2954 2025-08-16 5504.29
2955 2025-08-17 5504.29
2956 2025-08-18 5502.86
2957 2025-08-19 5398.57
2025-08-20 11:21:47,170 - IOOppi_data - INFO : save new data to db IOOppi_SF_g: date value ... created_at updated_at
2961 2025-08-19 5398.57 ... 2025-08-20 11:21:47.162882 2025-08-20 11:21:47.163267
[1 rows x 5 columns]
2025-08-20 11:21:47,189 - 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-08-20 11:21:47,728 - IOOppi_data - INFO : save data to db IOOppi_jd_t data:
date value
3153 2025-08-15 3210.0
3154 2025-08-16 3215.0
3155 2025-08-17 3215.0
3156 2025-08-18 3350.0
3157 2025-08-19 3365.0
2025-08-20 11:21:47,792 - IOOppi_data - INFO : save new data to db IOOppi_jd_t: date value ... created_at updated_at
3157 2025-08-19 3365.0 ... 2025-08-20 11:21:47.784510 2025-08-20 11:21:47.784933
[1 rows x 5 columns]
/root/project/IOOppi_data/IOOppi_request.py:308: SettingWithCopyWarning:
A value is trying to be set on a copy of a slice from a DataFrame.
Try using .loc[row_indexer,col_indexer] = value instead
See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy
diff_df.loc[:, 'index_code'] = index_code
/root/project/IOOppi_data/IOOppi_request.py:309: SettingWithCopyWarning:
A value is trying to be set on a copy of a slice from a DataFrame.
Try using .loc[row_indexer,col_indexer] = value instead
See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy
diff_df.loc[:, 'created_at'] = datetime.datetime.now()
/root/project/IOOppi_data/IOOppi_request.py:310: SettingWithCopyWarning:
A value is trying to be set on a copy of a slice from a DataFrame.
Try using .loc[row_indexer,col_indexer] = value instead
See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy
diff_df.loc[:, 'updated_at'] = datetime.datetime.now()
2025-08-20 11:21:47,941 - IOOppi_data - INFO : save diff data to db IOOppi_jd_t: date ... updated_at
39 2014-01-03 ... 2025-08-20 11:21:47.933558
458 2015-09-21 ... 2025-08-20 11:21:47.933558
549 2016-02-03 ... 2025-08-20 11:21:47.933558
693 2016-09-05 ... 2025-08-20 11:21:47.933558
696 2016-09-08 ... 2025-08-20 11:21:47.933558
[5 rows x 6 columns]
2025-08-20 11:21:47,977 - IOOppi_data - INFO : save data to db IOOppi_jd_g data:
date value
3153 2025-08-15 3210.0
3154 2025-08-16 3215.0
3155 2025-08-17 3215.0
3156 2025-08-18 3350.0
3157 2025-08-19 3365.0
2025-08-20 11:21:48,043 - IOOppi_data - INFO : save new data to db IOOppi_jd_g: date value ... created_at updated_at
3160 2025-08-19 3365.0 ... 2025-08-20 11:21:48.036421 2025-08-20 11:21:48.036838
[1 rows x 5 columns]
/root/project/IOOppi_data/IOOppi_request.py:308: SettingWithCopyWarning:
A value is trying to be set on a copy of a slice from a DataFrame.
Try using .loc[row_indexer,col_indexer] = value instead
See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy
diff_df.loc[:, 'index_code'] = index_code
/root/project/IOOppi_data/IOOppi_request.py:309: SettingWithCopyWarning:
A value is trying to be set on a copy of a slice from a DataFrame.
Try using .loc[row_indexer,col_indexer] = value instead
See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy
diff_df.loc[:, 'created_at'] = datetime.datetime.now()
/root/project/IOOppi_data/IOOppi_request.py:310: SettingWithCopyWarning:
A value is trying to be set on a copy of a slice from a DataFrame.
Try using .loc[row_indexer,col_indexer] = value instead
See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy
diff_df.loc[:, 'updated_at'] = datetime.datetime.now()
2025-08-20 11:21:48,195 - IOOppi_data - INFO : save diff data to db IOOppi_jd_g: date ... updated_at
39 2014-01-03 ... 2025-08-20 11:21:48.186651
458 2015-09-21 ... 2025-08-20 11:21:48.186651
549 2016-02-03 ... 2025-08-20 11:21:48.186651
693 2016-09-05 ... 2025-08-20 11:21:48.186651
696 2016-09-08 ... 2025-08-20 11:21:48.186651
[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-08-20 11:21:49,006 - IOOppi_data - INFO : save data to db IOOppi_SI_t data:
date value
957 2025-08-15 9610.0
958 2025-08-16 9610.0
959 2025-08-17 9610.0
960 2025-08-18 9610.0
961 2025-08-19 9610.0
2025-08-20 11:21:49,045 - IOOppi_data - INFO : save new data to db IOOppi_SI_t: date value ... created_at updated_at
961 2025-08-19 9610.0 ... 2025-08-20 11:21:49.037316 2025-08-20 11:21:49.037734
[1 rows x 5 columns]
2025-08-20 11:21:49,067 - IOOppi_data - INFO : save diff data to db: IOOppi_SI_t: no diff data
2025-08-20 11:21:49,072 - IOOppi_data - INFO : save data to db IOOppi_SI_g data:
date value
957 2025-08-15 9610.0
958 2025-08-16 9610.0
959 2025-08-17 9610.0
960 2025-08-18 9610.0
961 2025-08-19 9610.0
2025-08-20 11:21:49,109 - IOOppi_data - INFO : save new data to db IOOppi_SI_g: date value ... created_at updated_at
961 2025-08-19 9610.0 ... 2025-08-20 11:21:49.102260 2025-08-20 11:21:49.102670
[1 rows x 5 columns]
2025-08-20 11:21:49,129 - 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-08-20 11:21:49,785 - IOOppi_data - INFO : save data to db IOOppi_l_t data:
date value
3836 2025-08-15 7448.33
3837 2025-08-16 7448.33
3838 2025-08-17 7448.33
3839 2025-08-18 7448.33
3840 2025-08-19 7438.33
2025-08-20 11:21:49,860 - IOOppi_data - INFO : save new data to db IOOppi_l_t: date value ... created_at updated_at
3840 2025-08-19 7438.33 ... 2025-08-20 11:21:49.852242 2025-08-20 11:21:49.852682
[1 rows x 5 columns]
2025-08-20 11:21:49,879 - IOOppi_data - INFO : save diff data to db: IOOppi_l_t: no diff data
2025-08-20 11:21:49,886 - IOOppi_data - INFO : save data to db IOOppi_l_g data:
date value
3836 2025-08-15 7448.33
3837 2025-08-16 7448.33
3838 2025-08-17 7448.33
3839 2025-08-18 7448.33
3840 2025-08-19 7438.33
2025-08-20 11:21:49,961 - IOOppi_data - INFO : save new data to db IOOppi_l_g: date value ... created_at updated_at
3843 2025-08-19 7438.33 ... 2025-08-20 11:21:49.953630 2025-08-20 11:21:49.954055
[1 rows x 5 columns]
2025-08-20 11:21:49,980 - 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-08-20 11:21:50,650 - IOOppi_data - INFO : save data to db IOOppi_bu_t data:
date value
3174 2025-08-15 3670.0
3175 2025-08-16 3670.0
3176 2025-08-17 3670.0
3177 2025-08-18 3680.0
3178 2025-08-19 3670.0
2025-08-20 11:21:50,715 - IOOppi_data - INFO : save new data to db IOOppi_bu_t: date value ... created_at updated_at
3179 2025-08-19 3670.0 ... 2025-08-20 11:21:50.708134 2025-08-20 11:21:50.708519
[1 rows x 5 columns]
/root/project/IOOppi_data/IOOppi_request.py:308: SettingWithCopyWarning:
A value is trying to be set on a copy of a slice from a DataFrame.
Try using .loc[row_indexer,col_indexer] = value instead
See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy
diff_df.loc[:, 'index_code'] = index_code
/root/project/IOOppi_data/IOOppi_request.py:309: SettingWithCopyWarning:
A value is trying to be set on a copy of a slice from a DataFrame.
Try using .loc[row_indexer,col_indexer] = value instead
See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy
diff_df.loc[:, 'created_at'] = datetime.datetime.now()
/root/project/IOOppi_data/IOOppi_request.py:310: SettingWithCopyWarning:
A value is trying to be set on a copy of a slice from a DataFrame.
Try using .loc[row_indexer,col_indexer] = value instead
See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy
diff_df.loc[:, 'updated_at'] = datetime.datetime.now()
2025-08-20 11:21:50,751 - IOOppi_data - INFO : save diff data to db IOOppi_bu_t: date ... updated_at
2560 2023-12-09 ... 2025-08-20 11:21:50.743991
[1 rows x 6 columns]
2025-08-20 11:21:50,776 - IOOppi_data - INFO : save data to db IOOppi_bu_g data:
date value
3174 2025-08-15 3670.0
3175 2025-08-16 3670.0
3176 2025-08-17 3670.0
3177 2025-08-18 3680.0
3178 2025-08-19 3670.0
2025-08-20 11:21:50,840 - IOOppi_data - INFO : save new data to db IOOppi_bu_g: date value ... created_at updated_at
3181 2025-08-19 3670.0 ... 2025-08-20 11:21:50.833441 2025-08-20 11:21:50.833855
[1 rows x 5 columns]
2025-08-20 11:21:50,859 - 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-08-20 11:21:51,538 - IOOppi_data - INFO : save data to db IOOppi_al_t data:
date value
3839 2025-08-15 20726.67
3840 2025-08-16 20726.67
3841 2025-08-17 20726.67
3842 2025-08-18 20726.67
3843 2025-08-19 20726.67
2025-08-20 11:21:51,611 - IOOppi_data - INFO : save new data to db IOOppi_al_t: date ... updated_at
3843 2025-08-19 ... 2025-08-20 11:21:51.604766
[1 rows x 5 columns]
2025-08-20 11:21:51,631 - IOOppi_data - INFO : save diff data to db: IOOppi_al_t: no diff data
2025-08-20 11:21:51,637 - IOOppi_data - INFO : save data to db IOOppi_al_g data:
date value
3839 2025-08-15 20726.67
3840 2025-08-16 20726.67
3841 2025-08-17 20726.67
3842 2025-08-18 20726.67
3843 2025-08-19 20726.67
2025-08-20 11:21:51,711 - IOOppi_data - INFO : save new data to db IOOppi_al_g: date ... updated_at
3846 2025-08-19 ... 2025-08-20 11:21:51.704359
[1 rows x 5 columns]
2025-08-20 11:21:51,731 - 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-08-20 11:21:52,367 - IOOppi_data - INFO : save data to db IOOppi_SM_t data:
date value
2953 2025-08-15 5870.0
2954 2025-08-16 5870.0
2955 2025-08-17 5870.0
2956 2025-08-18 5874.0
2957 2025-08-19 5840.0
2025-08-20 11:21:52,429 - IOOppi_data - INFO : save new data to db IOOppi_SM_t: date value ... created_at updated_at
2957 2025-08-19 5840.0 ... 2025-08-20 11:21:52.421489 2025-08-20 11:21:52.421908
[1 rows x 5 columns]
2025-08-20 11:21:52,447 - IOOppi_data - INFO : save diff data to db: IOOppi_SM_t: no diff data
2025-08-20 11:21:52,453 - IOOppi_data - INFO : save data to db IOOppi_SM_g data:
date value
2953 2025-08-15 5870.0
2954 2025-08-16 5870.0
2955 2025-08-17 5870.0
2956 2025-08-18 5874.0
2957 2025-08-19 5840.0
2025-08-20 11:21:52,517 - IOOppi_data - INFO : save new data to db IOOppi_SM_g: date value ... created_at updated_at
2961 2025-08-19 5840.0 ... 2025-08-20 11:21:52.509586 2025-08-20 11:21:52.510019
[1 rows x 5 columns]
2025-08-20 11:21:52,540 - 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-08-20 11:21:53,450 - IOOppi_data - INFO : save data to db IOOppi_CY_t data:
date value
2228 2025-08-15 23600.0
2229 2025-08-16 23600.0
2230 2025-08-17 23600.0
2231 2025-08-18 23600.0
2232 2025-08-19 23550.0
2025-08-20 11:21:53,505 - IOOppi_data - INFO : save new data to db IOOppi_CY_t: date value ... created_at updated_at
2232 2025-08-19 23550.0 ... 2025-08-20 11:21:53.497754 2025-08-20 11:21:53.498202
[1 rows x 5 columns]
2025-08-20 11:21:53,525 - IOOppi_data - INFO : save diff data to db: IOOppi_CY_t: no diff data
2025-08-20 11:21:53,531 - IOOppi_data - INFO : save data to db IOOppi_CY_g data:
date value
2228 2025-08-15 23600.0
2229 2025-08-16 23600.0
2230 2025-08-17 23600.0
2231 2025-08-18 23600.0
2232 2025-08-19 23550.0
2025-08-20 11:21:53,585 - IOOppi_data - INFO : save new data to db IOOppi_CY_g: date value ... created_at updated_at
2236 2025-08-19 23550.0 ... 2025-08-20 11:21:53.577989 2025-08-20 11:21:53.578380
[1 rows x 5 columns]
2025-08-20 11:21:53,604 - 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-08-20 11:21:54,267 - IOOppi_data - INFO : save data to db IOOppi_UR_t data:
date value
1743 2025-08-15 1762.50
1744 2025-08-16 1762.50
1745 2025-08-17 1762.50
1746 2025-08-18 1766.25
1747 2025-08-19 1766.25
2025-08-20 11:21:54,314 - IOOppi_data - INFO : save new data to db IOOppi_UR_t: date value ... created_at updated_at
1747 2025-08-19 1766.25 ... 2025-08-20 11:21:54.307426 2025-08-20 11:21:54.307847
[1 rows x 5 columns]
2025-08-20 11:21:54,334 - IOOppi_data - INFO : save diff data to db: IOOppi_UR_t: no diff data
2025-08-20 11:21:54,339 - IOOppi_data - INFO : save data to db IOOppi_UR_g data:
date value
1743 2025-08-15 1762.50
1744 2025-08-16 1762.50
1745 2025-08-17 1762.50
1746 2025-08-18 1766.25
1747 2025-08-19 1766.25
2025-08-20 11:21:54,468 - IOOppi_data - INFO : save new data to db IOOppi_UR_g: date value ... created_at updated_at
1751 2025-08-19 1766.25 ... 2025-08-20 11:21:54.461228 2025-08-20 11:21:54.461629
[1 rows x 5 columns]
2025-08-20 11:21:54,488 - 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-08-20 11:21:55,210 - IOOppi_data - INFO : save data to db IOOppi_ni_t data:
date value
2815 2025-08-15 121850.00
2816 2025-08-16 121850.00
2817 2025-08-17 121850.00
2818 2025-08-18 121850.00
2819 2025-08-19 121933.33
2025-08-20 11:21:55,269 - IOOppi_data - INFO : save new data to db IOOppi_ni_t: date ... updated_at
2819 2025-08-19 ... 2025-08-20 11:21:55.263461
[1 rows x 5 columns]
2025-08-20 11:21:55,288 - IOOppi_data - INFO : save diff data to db: IOOppi_ni_t: no diff data
2025-08-20 11:21:55,294 - IOOppi_data - INFO : save data to db IOOppi_ni_g data:
date value
2815 2025-08-15 121850.00
2816 2025-08-16 121850.00
2817 2025-08-17 121850.00
2818 2025-08-18 121850.00
2819 2025-08-19 121933.33
2025-08-20 11:21:55,354 - IOOppi_data - INFO : save new data to db IOOppi_ni_g: date ... updated_at
2822 2025-08-19 ... 2025-08-20 11:21:55.348033
[1 rows x 5 columns]
2025-08-20 11:21:55,373 - 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-08-20 11:21:56,041 - IOOppi_data - INFO : save data to db IOOppi_v_t data:
date value
3840 2025-08-15 4813.0
3841 2025-08-16 4813.0
3842 2025-08-17 4813.0
3843 2025-08-18 4738.0
3844 2025-08-19 4714.0
2025-08-20 11:21:56,115 - IOOppi_data - INFO : save new data to db IOOppi_v_t: date value ... created_at updated_at
3844 2025-08-19 4714.0 ... 2025-08-20 11:21:56.108228 2025-08-20 11:21:56.108635
[1 rows x 5 columns]
2025-08-20 11:21:56,135 - IOOppi_data - INFO : save diff data to db: IOOppi_v_t: no diff data
2025-08-20 11:21:56,141 - IOOppi_data - INFO : save data to db IOOppi_v_g data:
date value
3840 2025-08-15 4813.0
3841 2025-08-16 4813.0
3842 2025-08-17 4813.0
3843 2025-08-18 4738.0
3844 2025-08-19 4714.0
2025-08-20 11:21:56,214 - IOOppi_data - INFO : save new data to db IOOppi_v_g: date value ... created_at updated_at
3847 2025-08-19 4714.0 ... 2025-08-20 11:21:56.207045 2025-08-20 11:21:56.207450
[1 rows x 5 columns]
2025-08-20 11:21:56,234 - 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-08-20 11:21:56,867 - IOOppi_data - INFO : save data to db IOOppi_pp_t data:
date value
3079 2025-08-15 7246.67
3080 2025-08-16 7246.67
3081 2025-08-17 7246.67
3082 2025-08-18 7230.00
3083 2025-08-19 7218.33
2025-08-20 11:21:56,932 - IOOppi_data - INFO : save new data to db IOOppi_pp_t: date value ... created_at updated_at
3083 2025-08-19 7218.33 ... 2025-08-20 11:21:56.924447 2025-08-20 11:21:56.924902
[1 rows x 5 columns]
2025-08-20 11:21:56,951 - IOOppi_data - INFO : save diff data to db: IOOppi_pp_t: no diff data
2025-08-20 11:21:56,957 - IOOppi_data - INFO : save data to db IOOppi_pp_g data:
date value
3079 2025-08-15 7246.67
3080 2025-08-16 7246.67
3081 2025-08-17 7246.67
3082 2025-08-18 7230.00
3083 2025-08-19 7218.33
2025-08-20 11:21:57,022 - IOOppi_data - INFO : save new data to db IOOppi_pp_g: date value ... created_at updated_at
3086 2025-08-19 7218.33 ... 2025-08-20 11:21:57.015122 2025-08-20 11:21:57.015509
[1 rows x 5 columns]
2025-08-20 11:21:57,041 - 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-08-20 11:21:57,765 - IOOppi_data - INFO : save data to db IOOppi_CF_t data:
date value
3841 2025-08-15 15221.67
3842 2025-08-16 15221.67
3843 2025-08-17 15221.67
3844 2025-08-18 15235.00
3845 2025-08-19 15244.50
2025-08-20 11:21:57,837 - IOOppi_data - INFO : save new data to db IOOppi_CF_t: date value ... created_at updated_at
3845 2025-08-19 15244.5 ... 2025-08-20 11:21:57.829868 2025-08-20 11:21:57.830253
[1 rows x 5 columns]
2025-08-20 11:21:57,856 - IOOppi_data - INFO : save diff data to db: IOOppi_CF_t: no diff data
2025-08-20 11:21:57,862 - IOOppi_data - INFO : save data to db IOOppi_CF_g data:
date value
3841 2025-08-15 15221.67
3842 2025-08-16 15221.67
3843 2025-08-17 15221.67
3844 2025-08-18 15235.00
3845 2025-08-19 15244.50
2025-08-20 11:21:57,936 - IOOppi_data - INFO : save new data to db IOOppi_CF_g: date value ... created_at updated_at
3849 2025-08-19 15244.5 ... 2025-08-20 11:21:57.928865 2025-08-20 11:21:57.929256
[1 rows x 5 columns]
2025-08-20 11:21:57,956 - 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-08-20 11:21:58,677 - IOOppi_data - INFO : save data to db IOOppi_pb_t data:
date value
3786 2025-08-15 16756.25
3787 2025-08-16 16756.25
3788 2025-08-17 16756.25
3789 2025-08-18 16743.75
3790 2025-08-19 16756.25
2025-08-20 11:21:58,750 - IOOppi_data - INFO : save new data to db IOOppi_pb_t: date ... updated_at
3790 2025-08-19 ... 2025-08-20 11:21:58.743491
[1 rows x 5 columns]
2025-08-20 11:21:58,769 - IOOppi_data - INFO : save diff data to db: IOOppi_pb_t: no diff data
2025-08-20 11:21:58,776 - IOOppi_data - INFO : save data to db IOOppi_pb_g data:
date value
3786 2025-08-15 16756.25
3787 2025-08-16 16756.25
3788 2025-08-17 16756.25
3789 2025-08-18 16743.75
3790 2025-08-19 16756.25
2025-08-20 11:21:58,849 - IOOppi_data - INFO : save new data to db IOOppi_pb_g: date ... updated_at
3793 2025-08-19 ... 2025-08-20 11:21:58.843075
[1 rows x 5 columns]
2025-08-20 11:21:58,868 - 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-08-20 11:21:59,501 - IOOppi_data - INFO : save data to db IOOppi_hc_t data:
date value
3061 2025-08-15 3480.00
3062 2025-08-16 3480.00
3063 2025-08-17 3480.00
3064 2025-08-18 3510.00
3065 2025-08-19 3483.33
2025-08-20 11:21:59,570 - IOOppi_data - INFO : save new data to db IOOppi_hc_t: date value ... created_at updated_at
3065 2025-08-19 3483.33 ... 2025-08-20 11:21:59.561539 2025-08-20 11:21:59.561983
[1 rows x 5 columns]
2025-08-20 11:21:59,589 - IOOppi_data - INFO : save diff data to db: IOOppi_hc_t: no diff data
2025-08-20 11:21:59,596 - IOOppi_data - INFO : save data to db IOOppi_hc_g data:
date value
3061 2025-08-15 3480.00
3062 2025-08-16 3480.00
3063 2025-08-17 3480.00
3064 2025-08-18 3510.00
3065 2025-08-19 3483.33
2025-08-20 11:21:59,663 - IOOppi_data - INFO : save new data to db IOOppi_hc_g: date value ... created_at updated_at
3068 2025-08-19 3483.33 ... 2025-08-20 11:21:59.655732 2025-08-20 11:21:59.656166
[1 rows x 5 columns]
2025-08-20 11:21:59,681 - 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-08-20 11:22:00,289 - IOOppi_data - INFO : save data to db IOOppi_fu_t data:
date value
3341 2025-08-15 5337.5
3342 2025-08-16 5337.5
3343 2025-08-17 5337.5
3344 2025-08-18 5300.0
3345 2025-08-19 5275.0
2025-08-20 11:22:00,356 - IOOppi_data - INFO : save new data to db IOOppi_fu_t: date value ... created_at updated_at
3345 2025-08-19 5275.0 ... 2025-08-20 11:22:00.348712 2025-08-20 11:22:00.349249
[1 rows x 5 columns]
2025-08-20 11:22:00,375 - IOOppi_data - INFO : save diff data to db: IOOppi_fu_t: no diff data
2025-08-20 11:22:00,382 - IOOppi_data - INFO : save data to db IOOppi_fu_g data:
date value
3341 2025-08-15 5337.5
3342 2025-08-16 5337.5
3343 2025-08-17 5337.5
3344 2025-08-18 5300.0
3345 2025-08-19 5275.0
2025-08-20 11:22:00,458 - IOOppi_data - INFO : save new data to db IOOppi_fu_g: date value ... created_at updated_at
3832 2025-08-19 5275.0 ... 2025-08-20 11:22:00.451284 2025-08-20 11:22:00.451715
[1 rows x 5 columns]
2025-08-20 11:22:00,478 - 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-08-20 11:22:01,135 - IOOppi_data - INFO : save data to db IOOppi_lh_t data:
date value
1405 2025-08-15 13870.0
1406 2025-08-16 13870.0
1407 2025-08-17 13870.0
1408 2025-08-18 13850.0
1409 2025-08-19 13850.0
2025-08-20 11:22:01,178 - IOOppi_data - INFO : save new data to db IOOppi_lh_t: date value ... created_at updated_at
1409 2025-08-19 13850.0 ... 2025-08-20 11:22:01.171 2025-08-20 11:22:01.171390
[1 rows x 5 columns]
/root/project/IOOppi_data/IOOppi_request.py:308: SettingWithCopyWarning:
A value is trying to be set on a copy of a slice from a DataFrame.
Try using .loc[row_indexer,col_indexer] = value instead
See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy
diff_df.loc[:, 'index_code'] = index_code
/root/project/IOOppi_data/IOOppi_request.py:309: SettingWithCopyWarning:
A value is trying to be set on a copy of a slice from a DataFrame.
Try using .loc[row_indexer,col_indexer] = value instead
See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy
diff_df.loc[:, 'created_at'] = datetime.datetime.now()
/root/project/IOOppi_data/IOOppi_request.py:310: SettingWithCopyWarning:
A value is trying to be set on a copy of a slice from a DataFrame.
Try using .loc[row_indexer,col_indexer] = value instead
See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy
diff_df.loc[:, 'updated_at'] = datetime.datetime.now()
2025-08-20 11:22:01,420 - IOOppi_data - INFO : save diff data to db IOOppi_lh_t: date ... updated_at
116 2021-07-05 ... 2025-08-20 11:22:01.409588
117 2021-07-06 ... 2025-08-20 11:22:01.409588
121 2021-07-12 ... 2025-08-20 11:22:01.409588
122 2021-07-13 ... 2025-08-20 11:22:01.409588
194 2021-11-01 ... 2025-08-20 11:22:01.409588
[5 rows x 6 columns]
2025-08-20 11:22:01,461 - IOOppi_data - INFO : save data to db IOOppi_lh_g data:
date value
1405 2025-08-15 13870.0
1406 2025-08-16 13870.0
1407 2025-08-17 13870.0
1408 2025-08-18 13850.0
1409 2025-08-19 13850.0
2025-08-20 11:22:01,504 - IOOppi_data - INFO : save new data to db IOOppi_lh_g: date value ... created_at updated_at
1412 2025-08-19 13850.0 ... 2025-08-20 11:22:01.497482 2025-08-20 11:22:01.497898
[1 rows x 5 columns]
/root/project/IOOppi_data/IOOppi_request.py:308: SettingWithCopyWarning:
A value is trying to be set on a copy of a slice from a DataFrame.
Try using .loc[row_indexer,col_indexer] = value instead
See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy
diff_df.loc[:, 'index_code'] = index_code
/root/project/IOOppi_data/IOOppi_request.py:309: SettingWithCopyWarning:
A value is trying to be set on a copy of a slice from a DataFrame.
Try using .loc[row_indexer,col_indexer] = value instead
See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy
diff_df.loc[:, 'created_at'] = datetime.datetime.now()
/root/project/IOOppi_data/IOOppi_request.py:310: SettingWithCopyWarning:
A value is trying to be set on a copy of a slice from a DataFrame.
Try using .loc[row_indexer,col_indexer] = value instead
See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy
diff_df.loc[:, 'updated_at'] = datetime.datetime.now()
2025-08-20 11:22:01,746 - IOOppi_data - INFO : save diff data to db IOOppi_lh_g: date ... updated_at
116 2021-07-05 ... 2025-08-20 11:22:01.738379
117 2021-07-06 ... 2025-08-20 11:22:01.738379
121 2021-07-12 ... 2025-08-20 11:22:01.738379
122 2021-07-13 ... 2025-08-20 11:22:01.738379
194 2021-11-01 ... 2025-08-20 11:22:01.738379
[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-08-20 11:22:02,488 - IOOppi_data - INFO : save data to db IOOppi_cu_t data:
date value
3837 2025-08-15 79285.00
3838 2025-08-16 79285.00
3839 2025-08-17 79285.00
3840 2025-08-18 79310.00
3841 2025-08-19 79103.33
2025-08-20 11:22:02,563 - IOOppi_data - INFO : save new data to db IOOppi_cu_t: date ... updated_at
3841 2025-08-19 ... 2025-08-20 11:22:02.556795
[1 rows x 5 columns]
2025-08-20 11:22:02,582 - IOOppi_data - INFO : save diff data to db: IOOppi_cu_t: no diff data
2025-08-20 11:22:02,590 - IOOppi_data - INFO : save data to db IOOppi_cu_g data:
date value
3837 2025-08-15 79285.00
3838 2025-08-16 79285.00
3839 2025-08-17 79285.00
3840 2025-08-18 79310.00
3841 2025-08-19 79103.33
2025-08-20 11:22:02,664 - IOOppi_data - INFO : save new data to db IOOppi_cu_g: date ... updated_at
3844 2025-08-19 ... 2025-08-20 11:22:02.657514
[1 rows x 5 columns]
2025-08-20 11:22:02,683 - 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-08-20 11:22:03,289 - 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-08-20 11:22:03,342 - IOOppi_data - INFO : save new data to db: IOOppi_PM_t: no new data
2025-08-20 11:22:03,342 - IOOppi_data - INFO : save diff data to db: IOOppi_PM_t: no diff data
2025-08-20 11:22:03,347 - 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-08-20 11:22:03,414 - IOOppi_data - INFO : save new data to db: IOOppi_PM_g: no new data
2025-08-20 11:22:03,415 - 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-08-20 11:22:04,147 - IOOppi_data - INFO : save data to db IOOppi_sn_t data:
date value
2815 2025-08-15 266137.5
2816 2025-08-16 266137.5
2817 2025-08-17 266137.5
2818 2025-08-18 267100.0
2819 2025-08-19 266237.5
2025-08-20 11:22:04,206 - IOOppi_data - INFO : save new data to db IOOppi_sn_t: date ... updated_at
2819 2025-08-19 ... 2025-08-20 11:22:04.200012
[1 rows x 5 columns]
2025-08-20 11:22:04,224 - IOOppi_data - INFO : save diff data to db: IOOppi_sn_t: no diff data
2025-08-20 11:22:04,230 - IOOppi_data - INFO : save data to db IOOppi_sn_g data:
date value
2815 2025-08-15 266137.5
2816 2025-08-16 266137.5
2817 2025-08-17 266137.5
2818 2025-08-18 267100.0
2819 2025-08-19 266237.5
2025-08-20 11:22:04,290 - IOOppi_data - INFO : save new data to db IOOppi_sn_g: date ... updated_at
2822 2025-08-19 ... 2025-08-20 11:22:04.284182
[1 rows x 5 columns]
2025-08-20 11:22:04,308 - 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-08-20 11:22:05,012 - IOOppi_data - INFO : save data to db IOOppi_zn_t data:
date value
3836 2025-08-15 22438.0
3837 2025-08-16 22438.0
3838 2025-08-17 22438.0
3839 2025-08-18 22288.0
3840 2025-08-19 22178.0
2025-08-20 11:22:05,084 - IOOppi_data - INFO : save new data to db IOOppi_zn_t: date value ... created_at updated_at
3840 2025-08-19 22178.0 ... 2025-08-20 11:22:05.077805 2025-08-20 11:22:05.078197
[1 rows x 5 columns]
2025-08-20 11:22:05,104 - IOOppi_data - INFO : save diff data to db: IOOppi_zn_t: no diff data
2025-08-20 11:22:05,110 - IOOppi_data - INFO : save data to db IOOppi_zn_g data:
date value
3836 2025-08-15 22438.0
3837 2025-08-16 22438.0
3838 2025-08-17 22438.0
3839 2025-08-18 22288.0
3840 2025-08-19 22178.0
2025-08-20 11:22:05,181 - IOOppi_data - INFO : save new data to db IOOppi_zn_g: date value ... created_at updated_at
3843 2025-08-19 22178.0 ... 2025-08-20 11:22:05.174939 2025-08-20 11:22:05.175317
[1 rows x 5 columns]
2025-08-20 11:22:05,201 - 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-08-20 11:22:05,835 - IOOppi_data - INFO : save data to db IOOppi_wr_t data:
date value
3799 2025-08-15 3442.5
3800 2025-08-16 3410.0
3801 2025-08-17 3410.0
3802 2025-08-18 3415.0
3803 2025-08-19 3405.0
2025-08-20 11:22:05,907 - IOOppi_data - INFO : save new data to db IOOppi_wr_t: date value ... created_at updated_at
3803 2025-08-19 3405.0 ... 2025-08-20 11:22:05.900008 2025-08-20 11:22:05.900392
[1 rows x 5 columns]
2025-08-20 11:22:05,926 - IOOppi_data - INFO : save diff data to db: IOOppi_wr_t: no diff data
2025-08-20 11:22:05,932 - IOOppi_data - INFO : save data to db IOOppi_wr_g data:
date value
3799 2025-08-15 3442.5
3800 2025-08-16 3410.0
3801 2025-08-17 3410.0
3802 2025-08-18 3415.0
3803 2025-08-19 3405.0
2025-08-20 11:22:06,005 - IOOppi_data - INFO : save new data to db IOOppi_wr_g: date value ... created_at updated_at
3806 2025-08-19 3405.0 ... 2025-08-20 11:22:05.997879 2025-08-20 11:22:05.998265
[1 rows x 5 columns]
2025-08-20 11:22:06,023 - 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-08-20 11:22:06,608 - IOOppi_data - INFO : save data to db IOOppi_pg_t data:
date value
1596 2025-08-15 4680.0
1597 2025-08-16 4680.0
1598 2025-08-17 4680.0
1599 2025-08-18 4670.0
1600 2025-08-19 4660.0
2025-08-20 11:22:06,656 - IOOppi_data - INFO : save new data to db IOOppi_pg_t: date value ... created_at updated_at
1600 2025-08-19 4660.0 ... 2025-08-20 11:22:06.648108 2025-08-20 11:22:06.648532
[1 rows x 5 columns]
2025-08-20 11:22:06,675 - IOOppi_data - INFO : save diff data to db: IOOppi_pg_t: no diff data
2025-08-20 11:22:06,681 - IOOppi_data - INFO : save data to db IOOppi_pg_g data:
date value
1596 2025-08-15 4680.0
1597 2025-08-16 4680.0
1598 2025-08-17 4680.0
1599 2025-08-18 4670.0
1600 2025-08-19 4660.0
2025-08-20 11:22:06,729 - IOOppi_data - INFO : save new data to db IOOppi_pg_g: date value ... created_at updated_at
1603 2025-08-19 4660.0 ... 2025-08-20 11:22:06.722143 2025-08-20 11:22:06.722531
[1 rows x 5 columns]
2025-08-20 11:22:06,748 - 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-08-20 11:22:07,414 - IOOppi_data - INFO : save data to db IOOppi_cs_t data:
date value
2870 2025-08-15 2318.57
2871 2025-08-16 2318.57
2872 2025-08-17 2318.57
2873 2025-08-18 2317.14
2874 2025-08-19 2315.71
2025-08-20 11:22:07,475 - IOOppi_data - INFO : save new data to db IOOppi_cs_t: date value ... created_at updated_at
2874 2025-08-19 2315.71 ... 2025-08-20 11:22:07.468434 2025-08-20 11:22:07.468847
[1 rows x 5 columns]
/root/project/IOOppi_data/IOOppi_request.py:308: SettingWithCopyWarning:
A value is trying to be set on a copy of a slice from a DataFrame.
Try using .loc[row_indexer,col_indexer] = value instead
See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy
diff_df.loc[:, 'index_code'] = index_code
/root/project/IOOppi_data/IOOppi_request.py:309: SettingWithCopyWarning:
A value is trying to be set on a copy of a slice from a DataFrame.
Try using .loc[row_indexer,col_indexer] = value instead
See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy
diff_df.loc[:, 'created_at'] = datetime.datetime.now()
/root/project/IOOppi_data/IOOppi_request.py:310: SettingWithCopyWarning:
A value is trying to be set on a copy of a slice from a DataFrame.
Try using .loc[row_indexer,col_indexer] = value instead
See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy
diff_df.loc[:, 'updated_at'] = datetime.datetime.now()
2025-08-20 11:22:07,519 - IOOppi_data - INFO : save diff data to db IOOppi_cs_t: date ... updated_at
2873 2025-08-18 ... 2025-08-20 11:22:07.512225
[1 rows x 6 columns]
2025-08-20 11:22:07,550 - IOOppi_data - INFO : save data to db IOOppi_cs_g data:
date value
2870 2025-08-15 2318.57
2871 2025-08-16 2318.57
2872 2025-08-17 2318.57
2873 2025-08-18 2317.14
2874 2025-08-19 2315.71
2025-08-20 11:22:07,615 - IOOppi_data - INFO : save new data to db IOOppi_cs_g: date value ... created_at updated_at
2877 2025-08-19 2315.71 ... 2025-08-20 11:22:07.605258 2025-08-20 11:22:07.605698
[1 rows x 5 columns]
/root/project/IOOppi_data/IOOppi_request.py:308: SettingWithCopyWarning:
A value is trying to be set on a copy of a slice from a DataFrame.
Try using .loc[row_indexer,col_indexer] = value instead
See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy
diff_df.loc[:, 'index_code'] = index_code
/root/project/IOOppi_data/IOOppi_request.py:309: SettingWithCopyWarning:
A value is trying to be set on a copy of a slice from a DataFrame.
Try using .loc[row_indexer,col_indexer] = value instead
See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy
diff_df.loc[:, 'created_at'] = datetime.datetime.now()
/root/project/IOOppi_data/IOOppi_request.py:310: SettingWithCopyWarning:
A value is trying to be set on a copy of a slice from a DataFrame.
Try using .loc[row_indexer,col_indexer] = value instead
See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy
diff_df.loc[:, 'updated_at'] = datetime.datetime.now()
2025-08-20 11:22:07,657 - IOOppi_data - INFO : save diff data to db IOOppi_cs_g: date ... updated_at
2876 2025-08-18 ... 2025-08-20 11:22:07.650654
[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-08-20 11:22:08,316 - IOOppi_data - INFO : save data to db IOOppi_cs_t data:
date value
2870 2025-08-15 2318.57
2871 2025-08-16 2318.57
2872 2025-08-17 2318.57
2873 2025-08-18 2317.14
2874 2025-08-19 2920.00
2025-08-20 11:22:08,369 - 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-08-20 11:22:08,392 - IOOppi_data - INFO : save diff data to db IOOppi_cs_t: date ... updated_at
2874 2025-08-19 ... 2025-08-20 11:22:08.385181
[1 rows x 6 columns]
2025-08-20 11:22:08,417 - IOOppi_data - INFO : save data to db IOOppi_cs_g data:
date value
2870 2025-08-15 2318.57
2871 2025-08-16 2318.57
2872 2025-08-17 2318.57
2873 2025-08-18 2317.14
2874 2025-08-19 2920.00
2025-08-20 11:22:08,470 - 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-08-20 11:22:08,493 - IOOppi_data - INFO : save diff data to db IOOppi_cs_g: date ... updated_at
2877 2025-08-19 ... 2025-08-20 11:22:08.486060
[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-08-20 11:22:09,131 - IOOppi_data - INFO : save data to db IOOppi_RS_t data:
date value
3227 2025-08-15 9876.67
3228 2025-08-16 9876.67
3229 2025-08-17 9876.67
3230 2025-08-18 9948.33
3231 2025-08-19 9966.67
2025-08-20 11:22:09,189 - IOOppi_data - INFO : save new data to db: IOOppi_RS_t: no new data
2025-08-20 11:22:09,189 - IOOppi_data - INFO : save diff data to db: IOOppi_RS_t: no diff data
2025-08-20 11:22:09,195 - IOOppi_data - INFO : save data to db IOOppi_RS_g data:
date value
3227 2025-08-15 9876.67
3228 2025-08-16 9876.67
3229 2025-08-17 9876.67
3230 2025-08-18 9948.33
3231 2025-08-19 9966.67
2025-08-20 11:22:09,254 - IOOppi_data - INFO : save new data to db: IOOppi_RS_g: no new data
2025-08-20 11:22:09,254 - 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-08-20 11:22:10,274 - IOOppi_data - INFO : save data to db IOOppi_eg_t data:
date value
1911 2025-08-15 4466.67
1912 2025-08-16 4466.67
1913 2025-08-17 4466.67
1914 2025-08-18 4458.33
1915 2025-08-19 4458.33
2025-08-20 11:22:10,323 - IOOppi_data - INFO : save new data to db IOOppi_eg_t: date value ... created_at updated_at
1915 2025-08-19 4458.33 ... 2025-08-20 11:22:10.316201 2025-08-20 11:22:10.316609
[1 rows x 5 columns]
2025-08-20 11:22:10,342 - IOOppi_data - INFO : save diff data to db: IOOppi_eg_t: no diff data
2025-08-20 11:22:10,349 - IOOppi_data - INFO : save data to db IOOppi_eg_g data:
date value
1911 2025-08-15 4466.67
1912 2025-08-16 4466.67
1913 2025-08-17 4466.67
1914 2025-08-18 4458.33
1915 2025-08-19 4458.33
2025-08-20 11:22:10,405 - IOOppi_data - INFO : save new data to db IOOppi_eg_g: date value ... created_at updated_at
1918 2025-08-19 4458.33 ... 2025-08-20 11:22:10.397010 2025-08-20 11:22:10.397437
[1 rows x 5 columns]
2025-08-20 11:22:10,425 - 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-08-20 11:22:11,056 - IOOppi_data - INFO : save data to db IOOppi_sp_t data:
date value
1920 2025-08-15 5876.67
1921 2025-08-16 5876.67
1922 2025-08-17 5876.67
1923 2025-08-18 5876.67
1924 2025-08-19 5850.00
2025-08-20 11:22:11,105 - IOOppi_data - INFO : save new data to db IOOppi_sp_t: date value ... created_at updated_at
1924 2025-08-19 5850.0 ... 2025-08-20 11:22:11.098162 2025-08-20 11:22:11.098541
[1 rows x 5 columns]
2025-08-20 11:22:11,124 - IOOppi_data - INFO : save diff data to db: IOOppi_sp_t: no diff data
2025-08-20 11:22:11,130 - IOOppi_data - INFO : save data to db IOOppi_sp_g data:
date value
1920 2025-08-15 5876.67
1921 2025-08-16 5876.67
1922 2025-08-17 5876.67
1923 2025-08-18 5876.67
1924 2025-08-19 5850.00
2025-08-20 11:22:11,178 - IOOppi_data - INFO : save new data to db IOOppi_sp_g: date value ... created_at updated_at
1927 2025-08-19 5850.0 ... 2025-08-20 11:22:11.171644 2025-08-20 11:22:11.172029
[1 rows x 5 columns]
2025-08-20 11:22:11,198 - 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-08-20 11:22:11,826 - IOOppi_data - INFO : save data to db IOOppi_p_t data:
date value
3588 2025-08-15 9428.0
3589 2025-08-16 9428.0
3590 2025-08-17 9428.0
3591 2025-08-18 9626.0
3592 2025-08-19 9690.0
2025-08-20 11:22:11,899 - IOOppi_data - INFO : save new data to db IOOppi_p_t: date value ... created_at updated_at
3592 2025-08-19 9690.0 ... 2025-08-20 11:22:11.891471 2025-08-20 11:22:11.891903
[1 rows x 5 columns]
2025-08-20 11:22:11,918 - IOOppi_data - INFO : save diff data to db: IOOppi_p_t: no diff data
2025-08-20 11:22:11,924 - IOOppi_data - INFO : save data to db IOOppi_p_g data:
date value
3588 2025-08-15 9428.0
3589 2025-08-16 9428.0
3590 2025-08-17 9428.0
3591 2025-08-18 9626.0
3592 2025-08-19 9690.0
2025-08-20 11:22:11,997 - IOOppi_data - INFO : save new data to db IOOppi_p_g: date value ... created_at updated_at
3595 2025-08-19 9690.0 ... 2025-08-20 11:22:11.989278 2025-08-20 11:22:11.989754
[1 rows x 5 columns]
2025-08-20 11:22:12,016 - IOOppi_data - INFO : save diff data to db: IOOppi_p_g: no diff data
Traceback (most recent call last):
File "/usr/local/lib/python3.10/site-packages/pymysql/connections.py", line 736, in _read_bytes
data = self._rfile.read(num_bytes)
File "/usr/local/lib/python3.10/socket.py", line 705, in readinto
return self._sock.recv_into(b)
ConnectionResetError: [Errno 104] Connection reset by peer
During handling of the above exception, another exception occurred:
Traceback (most recent call last):
File "/usr/local/lib/python3.10/site-packages/sqlalchemy/engine/base.py", line 1145, in _commit_impl
self.engine.dialect.do_commit(self.connection)
File "/usr/local/lib/python3.10/site-packages/sqlalchemy/engine/default.py", line 714, in do_commit
dbapi_connection.commit()
File "/usr/local/lib/python3.10/site-packages/pymysql/connections.py", line 472, in commit
self._read_ok_packet()
File "/usr/local/lib/python3.10/site-packages/pymysql/connections.py", line 442, in _read_ok_packet
pkt = self._read_packet()
File "/usr/local/lib/python3.10/site-packages/pymysql/connections.py", line 696, in _read_packet
packet_header = self._read_bytes(4)
File "/usr/local/lib/python3.10/site-packages/pymysql/connections.py", line 742, in _read_bytes
raise err.OperationalError(
pymysql.err.OperationalError: (2013, 'Lost connection to MySQL server during query ([Errno 104] Connection reset by peer)')
The above exception was the direct cause of the following exception:
Traceback (most recent call last):
File "/root/project/IOOppi_data/update_data.py", line 16, in
client.update_data_all()
File "/root/project/IOOppi_data/IOOppi_request.py", line 525, in update_data_all
self.update_time_period_data(cmd_id)
File "/root/project/IOOppi_data/IOOppi_request.py", line 450, in update_time_period_data
self.save_data(index_code, content_df)
File "/root/project/IOOppi_data/IOOppi_request.py", line 235, in save_data
self.save_data_to_db(index_code, df)
File "/root/project/IOOppi_data/IOOppi_request.py", line 270, in save_data_to_db
self.save_new_data_to_db(index_code, add_data_df)
File "/root/project/IOOppi_data/IOOppi_request.py", line 285, in save_new_data_to_db
new_data_df.to_sql(self.data_class.__tablename__, self.engine, index=False, if_exists='append')
File "/usr/local/lib/python3.10/site-packages/pandas/util/_decorators.py", line 333, in wrapper
return func(*args, **kwargs)
File "/usr/local/lib/python3.10/site-packages/pandas/core/generic.py", line 3106, in to_sql
return sql.to_sql(
File "/usr/local/lib/python3.10/site-packages/pandas/io/sql.py", line 843, in to_sql
with pandasSQL_builder(con, schema=schema, need_transaction=True) as pandas_sql:
File "/usr/local/lib/python3.10/site-packages/pandas/io/sql.py", line 1657, in __exit__
self.exit_stack.close()
File "/usr/local/lib/python3.10/contextlib.py", line 584, in close
self.__exit__(None, None, None)
File "/usr/local/lib/python3.10/contextlib.py", line 576, in __exit__
raise exc_details[1]
File "/usr/local/lib/python3.10/contextlib.py", line 561, in __exit__
if cb(*exc_details):
File "/usr/local/lib/python3.10/site-packages/sqlalchemy/engine/util.py", line 147, in __exit__
with util.safe_reraise():
File "/usr/local/lib/python3.10/site-packages/sqlalchemy/util/langhelpers.py", line 224, in __exit__
raise exc_value.with_traceback(exc_tb)
File "/usr/local/lib/python3.10/site-packages/sqlalchemy/engine/util.py", line 145, in __exit__
self.commit()
File "/usr/local/lib/python3.10/site-packages/sqlalchemy/engine/base.py", line 2632, in commit
self._do_commit()
File "/usr/local/lib/python3.10/site-packages/sqlalchemy/engine/base.py", line 2737, in _do_commit
self._connection_commit_impl()
File "/usr/local/lib/python3.10/site-packages/sqlalchemy/engine/base.py", line 2708, in _connection_commit_impl
self.connection._commit_impl()
File "/usr/local/lib/python3.10/site-packages/sqlalchemy/engine/base.py", line 1147, in _commit_impl
self._handle_dbapi_exception(e, None, None, None, None)
File "/usr/local/lib/python3.10/site-packages/sqlalchemy/engine/base.py", line 2355, in _handle_dbapi_exception
raise sqlalchemy_exception.with_traceback(exc_info[2]) from e
File "/usr/local/lib/python3.10/site-packages/sqlalchemy/engine/base.py", line 1145, in _commit_impl
self.engine.dialect.do_commit(self.connection)
File "/usr/local/lib/python3.10/site-packages/sqlalchemy/engine/default.py", line 714, in do_commit
dbapi_connection.commit()
File "/usr/local/lib/python3.10/site-packages/pymysql/connections.py", line 472, in commit
self._read_ok_packet()
File "/usr/local/lib/python3.10/site-packages/pymysql/connections.py", line 442, in _read_ok_packet
pkt = self._read_packet()
File "/usr/local/lib/python3.10/site-packages/pymysql/connections.py", line 696, in _read_packet
packet_header = self._read_bytes(4)
File "/usr/local/lib/python3.10/site-packages/pymysql/connections.py", line 742, in _read_bytes
raise err.OperationalError(
sqlalchemy.exc.OperationalError: (pymysql.err.OperationalError) (2013, 'Lost connection to MySQL server during query ([Errno 104] Connection reset by peer)')
(Background on this error at: https://sqlalche.me/e/20/e3q8)
Traceback (most recent call last):
File "/usr/local/lib/python3.10/site-packages/pymysql/connections.py", line 736, in _read_bytes
data = self._rfile.read(num_bytes)
File "/usr/local/lib/python3.10/socket.py", line 705, in readinto
return self._sock.recv_into(b)
ConnectionResetError: [Errno 104] Connection reset by peer
During handling of the above exception, another exception occurred:
Traceback (most recent call last):
File "/usr/local/lib/python3.10/site-packages/sqlalchemy/engine/base.py", line 1145, in _commit_impl
self.engine.dialect.do_commit(self.connection)
File "/usr/local/lib/python3.10/site-packages/sqlalchemy/engine/default.py", line 714, in do_commit
dbapi_connection.commit()
File "/usr/local/lib/python3.10/site-packages/pymysql/connections.py", line 472, in commit
self._read_ok_packet()
File "/usr/local/lib/python3.10/site-packages/pymysql/connections.py", line 442, in _read_ok_packet
pkt = self._read_packet()
File "/usr/local/lib/python3.10/site-packages/pymysql/connections.py", line 696, in _read_packet
packet_header = self._read_bytes(4)
File "/usr/local/lib/python3.10/site-packages/pymysql/connections.py", line 742, in _read_bytes
raise err.OperationalError(
pymysql.err.OperationalError: (2013, 'Lost connection to MySQL server during query ([Errno 104] Connection reset by peer)')
The above exception was the direct cause of the following exception:
Traceback (most recent call last):
File "/root/project/IOOppi_data/update_data.py", line 16, in
client.update_data_all()
File "/root/project/IOOppi_data/IOOppi_request.py", line 525, in update_data_all
self.update_time_period_data(cmd_id)
File "/root/project/IOOppi_data/IOOppi_request.py", line 450, in update_time_period_data
self.save_data(index_code, content_df)
File "/root/project/IOOppi_data/IOOppi_request.py", line 235, in save_data
self.save_data_to_db(index_code, df)
File "/root/project/IOOppi_data/IOOppi_request.py", line 270, in save_data_to_db
self.save_new_data_to_db(index_code, add_data_df)
File "/root/project/IOOppi_data/IOOppi_request.py", line 285, in save_new_data_to_db
new_data_df.to_sql(self.data_class.__tablename__, self.engine, index=False, if_exists='append')
File "/usr/local/lib/python3.10/site-packages/pandas/util/_decorators.py", line 333, in wrapper
return func(*args, **kwargs)
File "/usr/local/lib/python3.10/site-packages/pandas/core/generic.py", line 3106, in to_sql
return sql.to_sql(
File "/usr/local/lib/python3.10/site-packages/pandas/io/sql.py", line 843, in to_sql
with pandasSQL_builder(con, schema=schema, need_transaction=True) as pandas_sql:
File "/usr/local/lib/python3.10/site-packages/pandas/io/sql.py", line 1657, in __exit__
self.exit_stack.close()
File "/usr/local/lib/python3.10/contextlib.py", line 584, in close
self.__exit__(None, None, None)
File "/usr/local/lib/python3.10/contextlib.py", line 576, in __exit__
raise exc_details[1]
File "/usr/local/lib/python3.10/contextlib.py", line 561, in __exit__
if cb(*exc_details):
File "/usr/local/lib/python3.10/site-packages/sqlalchemy/engine/util.py", line 147, in __exit__
with util.safe_reraise():
File "/usr/local/lib/python3.10/site-packages/sqlalchemy/util/langhelpers.py", line 224, in __exit__
raise exc_value.with_traceback(exc_tb)
File "/usr/local/lib/python3.10/site-packages/sqlalchemy/engine/util.py", line 145, in __exit__
self.commit()
File "/usr/local/lib/python3.10/site-packages/sqlalchemy/engine/base.py", line 2632, in commit
self._do_commit()
File "/usr/local/lib/python3.10/site-packages/sqlalchemy/engine/base.py", line 2737, in _do_commit
self._connection_commit_impl()
File "/usr/local/lib/python3.10/site-packages/sqlalchemy/engine/base.py", line 2708, in _connection_commit_impl
self.connection._commit_impl()
File "/usr/local/lib/python3.10/site-packages/sqlalchemy/engine/base.py", line 1147, in _commit_impl
self._handle_dbapi_exception(e, None, None, None, None)
File "/usr/local/lib/python3.10/site-packages/sqlalchemy/engine/base.py", line 2355, in _handle_dbapi_exception
raise sqlalchemy_exception.with_traceback(exc_info[2]) from e
File "/usr/local/lib/python3.10/site-packages/sqlalchemy/engine/base.py", line 1145, in _commit_impl
self.engine.dialect.do_commit(self.connection)
File "/usr/local/lib/python3.10/site-packages/sqlalchemy/engine/default.py", line 714, in do_commit
dbapi_connection.commit()
File "/usr/local/lib/python3.10/site-packages/pymysql/connections.py", line 472, in commit
self._read_ok_packet()
File "/usr/local/lib/python3.10/site-packages/pymysql/connections.py", line 442, in _read_ok_packet
pkt = self._read_packet()
File "/usr/local/lib/python3.10/site-packages/pymysql/connections.py", line 696, in _read_packet
packet_header = self._read_bytes(4)
File "/usr/local/lib/python3.10/site-packages/pymysql/connections.py", line 742, in _read_bytes
raise err.OperationalError(
sqlalchemy.exc.OperationalError: (pymysql.err.OperationalError) (2013, 'Lost connection to MySQL server during query ([Errno 104] Connection reset by peer)')
(Background on this error at: https://sqlalche.me/e/20/e3q8)
Traceback (most recent call last):
File "/usr/local/lib/python3.10/site-packages/pymysql/connections.py", line 736, in _read_bytes
data = self._rfile.read(num_bytes)
File "/usr/local/lib/python3.10/socket.py", line 705, in readinto
return self._sock.recv_into(b)
ConnectionResetError: [Errno 104] Connection reset by peer
During handling of the above exception, another exception occurred:
Traceback (most recent call last):
File "/usr/local/lib/python3.10/site-packages/sqlalchemy/engine/base.py", line 1145, in _commit_impl
self.engine.dialect.do_commit(self.connection)
File "/usr/local/lib/python3.10/site-packages/sqlalchemy/engine/default.py", line 714, in do_commit
dbapi_connection.commit()
File "/usr/local/lib/python3.10/site-packages/pymysql/connections.py", line 472, in commit
self._read_ok_packet()
File "/usr/local/lib/python3.10/site-packages/pymysql/connections.py", line 442, in _read_ok_packet
pkt = self._read_packet()
File "/usr/local/lib/python3.10/site-packages/pymysql/connections.py", line 696, in _read_packet
packet_header = self._read_bytes(4)
File "/usr/local/lib/python3.10/site-packages/pymysql/connections.py", line 742, in _read_bytes
raise err.OperationalError(
pymysql.err.OperationalError: (2013, 'Lost connection to MySQL server during query ([Errno 104] Connection reset by peer)')
The above exception was the direct cause of the following exception:
Traceback (most recent call last):
File "/root/project/IOOppi_data/update_data.py", line 16, in
client.update_data_all()
File "/root/project/IOOppi_data/IOOppi_request.py", line 525, in update_data_all
self.update_time_period_data(cmd_id)
File "/root/project/IOOppi_data/IOOppi_request.py", line 450, in update_time_period_data
self.save_data(index_code, content_df)
File "/root/project/IOOppi_data/IOOppi_request.py", line 235, in save_data
self.save_data_to_db(index_code, df)
File "/root/project/IOOppi_data/IOOppi_request.py", line 270, in save_data_to_db
self.save_new_data_to_db(index_code, add_data_df)
File "/root/project/IOOppi_data/IOOppi_request.py", line 285, in save_new_data_to_db
new_data_df.to_sql(self.data_class.__tablename__, self.engine, index=False, if_exists='append')
File "/usr/local/lib/python3.10/site-packages/pandas/util/_decorators.py", line 333, in wrapper
return func(*args, **kwargs)
File "/usr/local/lib/python3.10/site-packages/pandas/core/generic.py", line 3106, in to_sql
return sql.to_sql(
File "/usr/local/lib/python3.10/site-packages/pandas/io/sql.py", line 843, in to_sql
with pandasSQL_builder(con, schema=schema, need_transaction=True) as pandas_sql:
File "/usr/local/lib/python3.10/site-packages/pandas/io/sql.py", line 1657, in __exit__
self.exit_stack.close()
File "/usr/local/lib/python3.10/contextlib.py", line 584, in close
self.__exit__(None, None, None)
File "/usr/local/lib/python3.10/contextlib.py", line 576, in __exit__
raise exc_details[1]
File "/usr/local/lib/python3.10/contextlib.py", line 561, in __exit__
if cb(*exc_details):
File "/usr/local/lib/python3.10/site-packages/sqlalchemy/engine/util.py", line 147, in __exit__
with util.safe_reraise():
File "/usr/local/lib/python3.10/site-packages/sqlalchemy/util/langhelpers.py", line 224, in __exit__
raise exc_value.with_traceback(exc_tb)
File "/usr/local/lib/python3.10/site-packages/sqlalchemy/engine/util.py", line 145, in __exit__
self.commit()
File "/usr/local/lib/python3.10/site-packages/sqlalchemy/engine/base.py", line 2632, in commit
self._do_commit()
File "/usr/local/lib/python3.10/site-packages/sqlalchemy/engine/base.py", line 2737, in _do_commit
self._connection_commit_impl()
File "/usr/local/lib/python3.10/site-packages/sqlalchemy/engine/base.py", line 2708, in _connection_commit_impl
self.connection._commit_impl()
File "/usr/local/lib/python3.10/site-packages/sqlalchemy/engine/base.py", line 1147, in _commit_impl
self._handle_dbapi_exception(e, None, None, None, None)
File "/usr/local/lib/python3.10/site-packages/sqlalchemy/engine/base.py", line 2355, in _handle_dbapi_exception
raise sqlalchemy_exception.with_traceback(exc_info[2]) from e
File "/usr/local/lib/python3.10/site-packages/sqlalchemy/engine/base.py", line 1145, in _commit_impl
self.engine.dialect.do_commit(self.connection)
File "/usr/local/lib/python3.10/site-packages/sqlalchemy/engine/default.py", line 714, in do_commit
dbapi_connection.commit()
File "/usr/local/lib/python3.10/site-packages/pymysql/connections.py", line 472, in commit
self._read_ok_packet()
File "/usr/local/lib/python3.10/site-packages/pymysql/connections.py", line 442, in _read_ok_packet
pkt = self._read_packet()
File "/usr/local/lib/python3.10/site-packages/pymysql/connections.py", line 696, in _read_packet
packet_header = self._read_bytes(4)
File "/usr/local/lib/python3.10/site-packages/pymysql/connections.py", line 742, in _read_bytes
raise err.OperationalError(
sqlalchemy.exc.OperationalError: (pymysql.err.OperationalError) (2013, 'Lost connection to MySQL server during query ([Errno 104] Connection reset by peer)')
(Background on this error at: https://sqlalche.me/e/20/e3q8)