=========================================================================
2025-09-16 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-09-16 17:50:43,885 - IOOppi_data - INFO : save data to db IOOppi_rb_t data:
date value
3424 2025-09-12 3124.0
3425 2025-09-13 3124.0
3426 2025-09-14 3124.0
3427 2025-09-15 3134.0
3428 2025-09-16 3148.0
2025-09-16 17:56:27,369 - IOOppi_data - INFO : save new data to db IOOppi_rb_t: date value ... created_at updated_at
3428 2025-09-16 3148.0 ... 2025-09-16 17:56:27.360490 2025-09-16 17:56:27.360989
[1 rows x 5 columns]
2025-09-16 17:56:28,005 - IOOppi_data - INFO : save diff data to db: IOOppi_rb_t: no diff data
2025-09-16 17:56:28,011 - IOOppi_data - INFO : save data to db IOOppi_rb_g data:
date value
3424 2025-09-12 3124.0
3425 2025-09-13 3124.0
3426 2025-09-14 3124.0
3427 2025-09-15 3134.0
3428 2025-09-16 3148.0
2025-09-16 17:59:51,535 - IOOppi_data - INFO : save new data to db IOOppi_rb_g: date value ... created_at updated_at
3431 2025-09-16 3148.0 ... 2025-09-16 17:59:51.527624 2025-09-16 17:59:51.528017
[1 rows x 5 columns]
2025-09-16 18:00:05,263 - 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-09-16 18:00:05,918 - IOOppi_data - INFO : save data to db IOOppi_MA_t data:
date value
3645 2025-09-12 2288.33
3646 2025-09-13 2288.33
3647 2025-09-14 2288.33
3648 2025-09-15 2295.00
3649 2025-09-16 2286.67
2025-09-16 18:00:38,630 - IOOppi_data - INFO : save new data to db IOOppi_MA_t: date value ... created_at updated_at
3649 2025-09-16 2286.67 ... 2025-09-16 18:00:38.622988 2025-09-16 18:00:38.623375
[1 rows x 5 columns]
2025-09-16 18:00:38,857 - IOOppi_data - INFO : save diff data to db: IOOppi_MA_t: no diff data
2025-09-16 18:00:38,863 - IOOppi_data - INFO : save data to db IOOppi_MA_g data:
date value
3645 2025-09-12 2288.33
3646 2025-09-13 2288.33
3647 2025-09-14 2288.33
3648 2025-09-15 2295.00
3649 2025-09-16 2286.67
2025-09-16 18:00:43,147 - IOOppi_data - INFO : save new data to db IOOppi_MA_g: date value ... created_at updated_at
3653 2025-09-16 2286.67 ... 2025-09-16 18:00:43.140641 2025-09-16 18:00:43.141027
[1 rows x 5 columns]
2025-09-16 18:00:43,986 - 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-09-16 18:00:44,603 - IOOppi_data - INFO : save data to db IOOppi_PTA_t data:
date value
985 2025-09-12 4636.66
986 2025-09-13 4636.66
987 2025-09-14 4636.66
988 2025-09-15 4631.66
989 2025-09-16 4633.75
2025-09-16 18:00:46,335 - IOOppi_data - INFO : save new data to db IOOppi_PTA_t: date value ... created_at updated_at
989 2025-09-16 4633.75 ... 2025-09-16 18:00:46.328673 2025-09-16 18:00:46.329061
[1 rows x 5 columns]
2025-09-16 18:00:46,974 - IOOppi_data - INFO : save diff data to db: IOOppi_PTA_t: no diff data
2025-09-16 18:00:46,981 - IOOppi_data - INFO : save data to db IOOppi_PTA_g data:
date value
985 2025-09-12 4636.66
986 2025-09-13 4636.66
987 2025-09-14 4636.66
988 2025-09-15 4631.66
989 2025-09-16 4633.75
2025-09-16 18:01:44,756 - IOOppi_data - INFO : save new data to db IOOppi_PTA_g: date value ... created_at updated_at
989 2025-09-16 4633.75 ... 2025-09-16 18:01:44.748441 2025-09-16 18:01:44.748856
[1 rows x 5 columns]
2025-09-16 18:01:45,189 - 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-09-16 18:01:45,857 - IOOppi_data - INFO : save data to db IOOppi_ru_t data:
date value
3864 2025-09-12 14983.33
3865 2025-09-13 14983.33
3866 2025-09-14 14983.33
3867 2025-09-15 15133.33
3868 2025-09-16 15166.67
2025-09-16 18:01:52,839 - IOOppi_data - INFO : save new data to db IOOppi_ru_t: date ... updated_at
3868 2025-09-16 ... 2025-09-16 18:01:52.832880
[1 rows x 5 columns]
2025-09-16 18:01:52,859 - IOOppi_data - INFO : save diff data to db: IOOppi_ru_t: no diff data
2025-09-16 18:01:52,865 - IOOppi_data - INFO : save data to db IOOppi_ru_g data:
date value
3864 2025-09-12 14983.33
3865 2025-09-13 14983.33
3866 2025-09-14 14983.33
3867 2025-09-15 15133.33
3868 2025-09-16 15166.67
2025-09-16 18:01:56,950 - IOOppi_data - INFO : save new data to db IOOppi_ru_g: date ... updated_at
3871 2025-09-16 ... 2025-09-16 18:01:56.943742
[1 rows x 5 columns]
2025-09-16 18:01:57,174 - 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-09-16 18:01:57,800 - IOOppi_data - INFO : save data to db IOOppi_i_t data:
date value
3196 2025-09-12 808.00
3197 2025-09-13 808.00
3198 2025-09-14 807.89
3199 2025-09-15 807.89
3200 2025-09-16 816.44
2025-09-16 18:02:26,136 - IOOppi_data - INFO : save new data to db IOOppi_i_t: date value ... created_at updated_at
3200 2025-09-16 816.44 ... 2025-09-16 18:02:26.128799 2025-09-16 18:02:26.129187
[1 rows x 5 columns]
2025-09-16 18:02:26,156 - IOOppi_data - INFO : save diff data to db: IOOppi_i_t: no diff data
2025-09-16 18:02:26,161 - IOOppi_data - INFO : save data to db IOOppi_i_g data:
date value
3196 2025-09-12 808.00
3197 2025-09-13 808.00
3198 2025-09-14 807.89
3199 2025-09-15 807.89
3200 2025-09-16 816.44
2025-09-16 18:02:39,427 - IOOppi_data - INFO : save new data to db IOOppi_i_g: date value ... created_at updated_at
3203 2025-09-16 816.44 ... 2025-09-16 18:02:39.420204 2025-09-16 18:02:39.420613
[1 rows x 5 columns]
2025-09-16 18:02:40,472 - 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-09-16 18:02:41,090 - IOOppi_data - INFO : save data to db IOOppi_FG_t data:
date value
3399 2025-09-12 1130.4
3400 2025-09-13 1130.4
3401 2025-09-14 1130.4
3402 2025-09-15 1130.4
3403 2025-09-16 1120.0
2025-09-16 18:03:03,166 - IOOppi_data - INFO : save new data to db IOOppi_FG_t: date value ... created_at updated_at
3403 2025-09-16 1120.0 ... 2025-09-16 18:03:03.158813 2025-09-16 18:03:03.159250
[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-09-16 18:07:48,641 - IOOppi_data - INFO : save diff data to db IOOppi_FG_t: date ... updated_at
12 2012-12-19 ... 2025-09-16 18:07:48.633269
21 2013-01-04 ... 2025-09-16 18:07:48.633269
54 2013-02-27 ... 2025-09-16 18:07:48.633269
60 2013-03-07 ... 2025-09-16 18:07:48.633269
61 2013-03-08 ... 2025-09-16 18:07:48.633269
[5 rows x 6 columns]
2025-09-16 18:07:51,255 - IOOppi_data - INFO : save data to db IOOppi_FG_g data:
date value
3399 2025-09-12 1130.4
3400 2025-09-13 1130.4
3401 2025-09-14 1130.4
3402 2025-09-15 1130.4
3403 2025-09-16 1120.0
2025-09-16 18:08:27,704 - IOOppi_data - INFO : save new data to db IOOppi_FG_g: date value ... created_at updated_at
3407 2025-09-16 1120.0 ... 2025-09-16 18:08:27.697455 2025-09-16 18:08:27.697873
[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-09-16 18:10:52,124 - IOOppi_data - INFO : save diff data to db IOOppi_FG_g: date ... updated_at
12 2012-12-19 ... 2025-09-16 18:10:52.115829
21 2013-01-04 ... 2025-09-16 18:10:52.115829
54 2013-02-27 ... 2025-09-16 18:10:52.115829
60 2013-03-07 ... 2025-09-16 18:10:52.115829
61 2013-03-08 ... 2025-09-16 18:10:52.115829
[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-09-16 18:10:56,394 - IOOppi_data - INFO : save data to db IOOppi_eb_t data:
date value
1744 2025-09-12 7314.0
1745 2025-09-13 7320.0
1746 2025-09-14 7320.0
1747 2025-09-15 7314.0
1748 2025-09-16 7324.0
2025-09-16 18:11:03,607 - IOOppi_data - INFO : save new data to db IOOppi_eb_t: date value ... created_at updated_at
1748 2025-09-16 7324.0 ... 2025-09-16 18:11:03.599540 2025-09-16 18:11:03.599989
[1 rows x 5 columns]
2025-09-16 18:11:03,627 - IOOppi_data - INFO : save diff data to db: IOOppi_eb_t: no diff data
2025-09-16 18:11:03,633 - IOOppi_data - INFO : save data to db IOOppi_eb_g data:
date value
1744 2025-09-12 7314.0
1745 2025-09-13 7320.0
1746 2025-09-14 7320.0
1747 2025-09-15 7314.0
1748 2025-09-16 7324.0
2025-09-16 18:11:20,631 - IOOppi_data - INFO : save new data to db IOOppi_eb_g: date value ... created_at updated_at
1751 2025-09-16 7324.0 ... 2025-09-16 18:11:20.623339 2025-09-16 18:11:20.623769
[1 rows x 5 columns]
2025-09-16 18:11:22,913 - 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-09-16 18:11:23,504 - IOOppi_data - INFO : save data to db IOOppi_SR_t data:
date value
3855 2025-09-12 5855.0
3856 2025-09-13 5855.0
3857 2025-09-14 5855.0
3858 2025-09-15 5850.0
3859 2025-09-16 5865.0
2025-09-16 18:11:54,971 - IOOppi_data - INFO : save new data to db IOOppi_SR_t: date value ... created_at updated_at
3859 2025-09-16 5865.0 ... 2025-09-16 18:11:54.962843 2025-09-16 18:11:54.963282
[1 rows x 5 columns]
2025-09-16 18:11:55,195 - IOOppi_data - INFO : save diff data to db: IOOppi_SR_t: no diff data
2025-09-16 18:11:55,202 - IOOppi_data - INFO : save data to db IOOppi_SR_g data:
date value
3855 2025-09-12 5855.0
3856 2025-09-13 5855.0
3857 2025-09-14 5855.0
3858 2025-09-15 5850.0
3859 2025-09-16 5865.0
2025-09-16 18:12:24,970 - IOOppi_data - INFO : save new data to db IOOppi_SR_g: date value ... created_at updated_at
3863 2025-09-16 5865.0 ... 2025-09-16 18:12:24.962917 2025-09-16 18:12:24.963325
[1 rows x 5 columns]
2025-09-16 18:12:31,975 - 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-09-16 18:12:32,645 - IOOppi_data - INFO : save data to db IOOppi_ss_t data:
date value
1745 2025-09-12 13067.5
1746 2025-09-13 13067.5
1747 2025-09-14 13067.5
1748 2025-09-15 13092.5
1749 2025-09-16 13092.5
2025-09-16 18:12:40,535 - IOOppi_data - INFO : save new data to db IOOppi_ss_t: date value ... created_at updated_at
1749 2025-09-16 13092.5 ... 2025-09-16 18:12:40.527232 2025-09-16 18:12:40.527671
[1 rows x 5 columns]
2025-09-16 18:12:41,785 - IOOppi_data - INFO : save diff data to db: IOOppi_ss_t: no diff data
2025-09-16 18:12:41,792 - IOOppi_data - INFO : save data to db IOOppi_ss_g data:
date value
1745 2025-09-12 13067.5
1746 2025-09-13 13067.5
1747 2025-09-14 13067.5
1748 2025-09-15 13092.5
1749 2025-09-16 13092.5
2025-09-16 18:12:42,276 - IOOppi_data - INFO : save new data to db IOOppi_ss_g: date value ... created_at updated_at
1752 2025-09-16 13092.5 ... 2025-09-16 18:12:42.268631 2025-09-16 18:12:42.269025
[1 rows x 5 columns]
2025-09-16 18:12:42,907 - 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-09-16 18:12:43,571 - IOOppi_data - INFO : save data to db IOOppi_RS_t data:
date value
3255 2025-09-12 10000.00
3256 2025-09-13 10000.00
3257 2025-09-14 10000.00
3258 2025-09-15 10026.67
3259 2025-09-16 10166.67
2025-09-16 18:13:31,001 - IOOppi_data - INFO : save new data to db IOOppi_RS_t: date ... updated_at
3259 2025-09-16 ... 2025-09-16 18:13:30.994765
[1 rows x 5 columns]
2025-09-16 18:13:31,023 - IOOppi_data - INFO : save diff data to db: IOOppi_RS_t: no diff data
2025-09-16 18:13:31,028 - IOOppi_data - INFO : save data to db IOOppi_RS_g data:
date value
3255 2025-09-12 10000.00
3256 2025-09-13 10000.00
3257 2025-09-14 10000.00
3258 2025-09-15 10026.67
3259 2025-09-16 10166.67
2025-09-16 18:13:35,240 - IOOppi_data - INFO : save new data to db IOOppi_RS_g: date ... updated_at
3263 2025-09-16 ... 2025-09-16 18:13:35.234093
[1 rows x 5 columns]
2025-09-16 18:13:35,260 - 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-09-16 18:13:35,844 - IOOppi_data - INFO : save data to db IOOppi_RM_t data:
date value
3378 2025-09-12 2680.0
3379 2025-09-13 2680.0
3380 2025-09-14 2680.0
3381 2025-09-15 2635.0
3382 2025-09-16 2655.0
2025-09-16 18:13:38,267 - IOOppi_data - INFO : save new data to db IOOppi_RM_t: date value ... created_at updated_at
3382 2025-09-16 2655.0 ... 2025-09-16 18:13:38.258953 2025-09-16 18:13:38.259451
[1 rows x 5 columns]
2025-09-16 18:13:38,902 - IOOppi_data - INFO : save diff data to db: IOOppi_RM_t: no diff data
2025-09-16 18:13:38,909 - IOOppi_data - INFO : save data to db IOOppi_RM_g data:
date value
3378 2025-09-12 2680.0
3379 2025-09-13 2680.0
3380 2025-09-14 2680.0
3381 2025-09-15 2635.0
3382 2025-09-16 2655.0
2025-09-16 18:14:35,631 - IOOppi_data - INFO : save new data to db IOOppi_RM_g: date value ... created_at updated_at
3386 2025-09-16 2655.0 ... 2025-09-16 18:14:35.623520 2025-09-16 18:14:35.623953
[1 rows x 5 columns]
2025-09-16 18:14:40,167 - 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-09-16 18:14:41,197 - IOOppi_data - INFO : save data to db IOOppi_SA_t data:
date value
1582 2025-09-12 1262.5
1583 2025-09-13 1262.5
1584 2025-09-14 1262.5
1585 2025-09-15 1262.5
1586 2025-09-16 1262.5
2025-09-16 18:14:44,643 - IOOppi_data - INFO : save new data to db IOOppi_SA_t: date value ... created_at updated_at
1586 2025-09-16 1262.5 ... 2025-09-16 18:14:44.635892 2025-09-16 18:14:44.636318
[1 rows x 5 columns]
2025-09-16 18:14:44,663 - IOOppi_data - INFO : save diff data to db: IOOppi_SA_t: no diff data
2025-09-16 18:14:44,669 - IOOppi_data - INFO : save data to db IOOppi_SA_g data:
date value
1582 2025-09-12 1262.5
1583 2025-09-13 1262.5
1584 2025-09-14 1262.5
1585 2025-09-15 1262.5
1586 2025-09-16 1262.5
2025-09-16 18:15:09,253 - IOOppi_data - INFO : save new data to db IOOppi_SA_g: date value ... created_at updated_at
1590 2025-09-16 1262.5 ... 2025-09-16 18:15:09.245761 2025-09-16 18:15:09.246148
[1 rows x 5 columns]
2025-09-16 18:15:10,296 - 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-09-16 18:15:10,917 - IOOppi_data - INFO : save data to db IOOppi_PF_t data:
date value
1495 2025-09-12 6457.00
1496 2025-09-13 6457.00
1497 2025-09-14 6457.00
1498 2025-09-15 6471.00
1499 2025-09-16 6478.34
2025-09-16 18:15:31,857 - IOOppi_data - INFO : save new data to db IOOppi_PF_t: date value ... created_at updated_at
1499 2025-09-16 6478.34 ... 2025-09-16 18:15:31.849734 2025-09-16 18:15:31.850176
[1 rows x 5 columns]
2025-09-16 18:15:32,491 - IOOppi_data - INFO : save diff data to db: IOOppi_PF_t: no diff data
2025-09-16 18:15:32,497 - IOOppi_data - INFO : save data to db IOOppi_PF_g data:
date value
1495 2025-09-12 6457.00
1496 2025-09-13 6457.00
1497 2025-09-14 6457.00
1498 2025-09-15 6471.00
1499 2025-09-16 6478.34
2025-09-16 18:15:35,649 - IOOppi_data - INFO : save new data to db IOOppi_PF_g: date value ... created_at updated_at
1503 2025-09-16 6478.34 ... 2025-09-16 18:15:35.641316 2025-09-16 18:15:35.641831
[1 rows x 5 columns]
2025-09-16 18:15:39,148 - 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-09-16 18:15:39,743 - IOOppi_data - INFO : save data to db IOOppi_m_t data:
date value
3868 2025-09-12 3060.0
3869 2025-09-13 3060.0
3870 2025-09-14 3060.0
3871 2025-09-15 3058.0
3872 2025-09-16 3056.0
2025-09-16 18:15:48,544 - IOOppi_data - INFO : save new data to db IOOppi_m_t: date value ... created_at updated_at
3872 2025-09-16 3056.0 ... 2025-09-16 18:15:48.536885 2025-09-16 18:15:48.537297
[1 rows x 5 columns]
2025-09-16 18:15:48,771 - IOOppi_data - INFO : save diff data to db: IOOppi_m_t: no diff data
2025-09-16 18:15:48,777 - IOOppi_data - INFO : save data to db IOOppi_m_g data:
date value
3868 2025-09-12 3060.0
3869 2025-09-13 3060.0
3870 2025-09-14 3060.0
3871 2025-09-15 3058.0
3872 2025-09-16 3056.0
2025-09-16 18:15:56,846 - IOOppi_data - INFO : save new data to db IOOppi_m_g: date value ... created_at updated_at
3875 2025-09-16 3056.0 ... 2025-09-16 18:15:56.838799 2025-09-16 18:15:56.839215
[1 rows x 5 columns]
2025-09-16 18:15:57,484 - 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-09-16 18:15:58,068 - IOOppi_data - INFO : save data to db IOOppi_y_t data:
date value
3638 2025-09-12 8398.0
3639 2025-09-13 8398.0
3640 2025-09-14 8398.0
3641 2025-09-15 8448.0
3642 2025-09-16 8508.0
2025-09-16 18:20:24,181 - IOOppi_data - INFO : save new data to db IOOppi_y_t: date value ... created_at updated_at
3642 2025-09-16 8508.0 ... 2025-09-16 18:20:24.174428 2025-09-16 18:20:24.174855
[1 rows x 5 columns]
2025-09-16 18:20:31,193 - IOOppi_data - INFO : save diff data to db: IOOppi_y_t: no diff data
2025-09-16 18:20:31,200 - IOOppi_data - INFO : save data to db IOOppi_y_g data:
date value
3638 2025-09-12 8398.0
3639 2025-09-13 8398.0
3640 2025-09-14 8398.0
3641 2025-09-15 8448.0
3642 2025-09-16 8508.0
2025-09-16 18:21:11,269 - IOOppi_data - INFO : save new data to db IOOppi_y_g: date value ... created_at updated_at
3645 2025-09-16 8508.0 ... 2025-09-16 18:21:11.261976 2025-09-16 18:21:11.262431
[1 rows x 5 columns]
2025-09-16 18:21:11,495 - 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-09-16 18:21:12,096 - IOOppi_data - INFO : save data to db IOOppi_a_t data:
date value
3604 2025-09-12 4305.0
3605 2025-09-13 4305.0
3606 2025-09-14 4305.0
3607 2025-09-15 4305.0
3608 2025-09-16 4305.0
2025-09-16 18:21:34,306 - IOOppi_data - INFO : save new data to db IOOppi_a_t: date value ... created_at updated_at
3608 2025-09-16 4305.0 ... 2025-09-16 18:21:34.299045 2025-09-16 18:21:34.299468
[1 rows x 5 columns]
2025-09-16 18:21:38,226 - IOOppi_data - INFO : save diff data to db: IOOppi_a_t: no diff data
2025-09-16 18:21:38,232 - IOOppi_data - INFO : save data to db IOOppi_a_g data:
date value
3604 2025-09-12 4305.0
3605 2025-09-13 4305.0
3606 2025-09-14 4305.0
3607 2025-09-15 4305.0
3608 2025-09-16 4305.0
2025-09-16 18:21:46,961 - IOOppi_data - INFO : save new data to db IOOppi_a_g: date value ... created_at updated_at
3611 2025-09-16 4305.0 ... 2025-09-16 18:21:46.953362 2025-09-16 18:21:46.953797
[1 rows x 5 columns]
2025-09-16 18:21:47,802 - 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-09-16 18:21:48,413 - IOOppi_data - INFO : save data to db IOOppi_SF_t data:
date value
2981 2025-09-12 5245.71
2982 2025-09-13 5245.71
2983 2025-09-14 5245.71
2984 2025-09-15 5245.71
2985 2025-09-16 5245.71
2025-09-16 18:21:55,766 - IOOppi_data - INFO : save new data to db IOOppi_SF_t: date value ... created_at updated_at
2985 2025-09-16 5245.71 ... 2025-09-16 18:21:55.757795 2025-09-16 18:21:55.758342
[1 rows x 5 columns]
2025-09-16 18:21:56,811 - IOOppi_data - INFO : save diff data to db: IOOppi_SF_t: no diff data
2025-09-16 18:21:56,818 - IOOppi_data - INFO : save data to db IOOppi_SF_g data:
date value
2981 2025-09-12 5245.71
2982 2025-09-13 5245.71
2983 2025-09-14 5245.71
2984 2025-09-15 5245.71
2985 2025-09-16 5245.71
2025-09-16 18:21:58,733 - IOOppi_data - INFO : save new data to db IOOppi_SF_g: date value ... created_at updated_at
2989 2025-09-16 5245.71 ... 2025-09-16 18:21:58.726372 2025-09-16 18:21:58.726787
[1 rows x 5 columns]
2025-09-16 18:21:58,753 - 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-09-16 18:21:59,365 - IOOppi_data - INFO : save data to db IOOppi_jd_t data:
date value
3181 2025-09-12 3675.0
3182 2025-09-13 3675.0
3183 2025-09-14 3675.0
3184 2025-09-15 3840.0
3185 2025-09-16 3935.0
2025-09-16 18:22:00,569 - IOOppi_data - INFO : save new data to db IOOppi_jd_t: date value ... created_at updated_at
3185 2025-09-16 3935.0 ... 2025-09-16 18:22:00.561715 2025-09-16 18:22:00.562128
[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-09-16 18:22:05,616 - IOOppi_data - INFO : save diff data to db IOOppi_jd_t: date ... updated_at
39 2014-01-03 ... 2025-09-16 18:22:05.608147
458 2015-09-21 ... 2025-09-16 18:22:05.608147
549 2016-02-03 ... 2025-09-16 18:22:05.608147
693 2016-09-05 ... 2025-09-16 18:22:05.608147
696 2016-09-08 ... 2025-09-16 18:22:05.608147
[5 rows x 6 columns]
2025-09-16 18:22:07,493 - IOOppi_data - INFO : save data to db IOOppi_jd_g data:
date value
3181 2025-09-12 3675.0
3182 2025-09-13 3675.0
3183 2025-09-14 3675.0
3184 2025-09-15 3840.0
3185 2025-09-16 3935.0
2025-09-16 18:22:07,991 - IOOppi_data - INFO : save new data to db IOOppi_jd_g: date value ... created_at updated_at
3188 2025-09-16 3935.0 ... 2025-09-16 18:22:07.983558 2025-09-16 18:22:07.983979
[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-09-16 18:22:16,293 - IOOppi_data - INFO : save diff data to db IOOppi_jd_g: date ... updated_at
39 2014-01-03 ... 2025-09-16 18:22:16.285001
458 2015-09-21 ... 2025-09-16 18:22:16.285001
549 2016-02-03 ... 2025-09-16 18:22:16.285001
693 2016-09-05 ... 2025-09-16 18:22:16.285001
696 2016-09-08 ... 2025-09-16 18:22:16.285001
[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-09-16 18:22:16,952 - IOOppi_data - INFO : save data to db IOOppi_SI_t data:
date value
985 2025-09-12 9450.0
986 2025-09-13 9450.0
987 2025-09-14 9450.0
988 2025-09-15 9450.0
989 2025-09-16 9560.0
2025-09-16 18:25:52,243 - IOOppi_data - INFO : save new data to db IOOppi_SI_t: date value ... created_at updated_at
989 2025-09-16 9560.0 ... 2025-09-16 18:25:52.235739 2025-09-16 18:25:52.236148
[1 rows x 5 columns]
2025-09-16 18:25:52,469 - IOOppi_data - INFO : save diff data to db: IOOppi_SI_t: no diff data
2025-09-16 18:25:52,475 - IOOppi_data - INFO : save data to db IOOppi_SI_g data:
date value
985 2025-09-12 9450.0
986 2025-09-13 9450.0
987 2025-09-14 9450.0
988 2025-09-15 9450.0
989 2025-09-16 9560.0
2025-09-16 18:25:53,443 - IOOppi_data - INFO : save new data to db IOOppi_SI_g: date value ... created_at updated_at
989 2025-09-16 9560.0 ... 2025-09-16 18:25:53.435959 2025-09-16 18:25:53.436421
[1 rows x 5 columns]
2025-09-16 18:25:55,931 - 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-09-16 18:25:56,540 - IOOppi_data - INFO : save data to db IOOppi_l_t data:
date value
3864 2025-09-12 7380.00
3865 2025-09-13 7380.00
3866 2025-09-14 7380.00
3867 2025-09-15 7378.33
3868 2025-09-16 7395.00
2025-09-16 18:27:02,026 - IOOppi_data - INFO : save new data to db IOOppi_l_t: date value ... created_at updated_at
3868 2025-09-16 7395.0 ... 2025-09-16 18:27:02.018850 2025-09-16 18:27:02.019304
[1 rows x 5 columns]
2025-09-16 18:27:02,482 - IOOppi_data - INFO : save diff data to db: IOOppi_l_t: no diff data
2025-09-16 18:27:02,489 - IOOppi_data - INFO : save data to db IOOppi_l_g data:
date value
3864 2025-09-12 7380.00
3865 2025-09-13 7380.00
3866 2025-09-14 7380.00
3867 2025-09-15 7378.33
3868 2025-09-16 7395.00
2025-09-16 18:27:22,774 - IOOppi_data - INFO : save new data to db IOOppi_l_g: date value ... created_at updated_at
3871 2025-09-16 7395.0 ... 2025-09-16 18:27:22.766595 2025-09-16 18:27:22.767111
[1 rows x 5 columns]
2025-09-16 18:27:26,077 - 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-09-16 18:27:26,761 - IOOppi_data - INFO : save data to db IOOppi_bu_t data:
date value
3202 2025-09-12 3635.00
3203 2025-09-13 3635.00
3204 2025-09-14 3633.33
3205 2025-09-15 3630.00
3206 2025-09-16 3630.00
2025-09-16 18:27:41,719 - IOOppi_data - INFO : save new data to db IOOppi_bu_t: date value ... created_at updated_at
3207 2025-09-16 3630.0 ... 2025-09-16 18:27:41.711957 2025-09-16 18:27:41.712344
[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-09-16 18:27:43,393 - IOOppi_data - INFO : save diff data to db IOOppi_bu_t: date ... updated_at
2560 2023-12-09 ... 2025-09-16 18:27:43.385942
[1 rows x 6 columns]
2025-09-16 18:27:44,651 - IOOppi_data - INFO : save data to db IOOppi_bu_g data:
date value
3202 2025-09-12 3635.00
3203 2025-09-13 3635.00
3204 2025-09-14 3633.33
3205 2025-09-15 3630.00
3206 2025-09-16 3630.00
2025-09-16 18:30:50,170 - IOOppi_data - INFO : save new data to db IOOppi_bu_g: date value ... created_at updated_at
3209 2025-09-16 3630.0 ... 2025-09-16 18:30:50.163164 2025-09-16 18:30:50.163592
[1 rows x 5 columns]
2025-09-16 18:30:50,405 - 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-09-16 18:30:51,012 - IOOppi_data - INFO : save data to db IOOppi_al_t data:
date value
3867 2025-09-12 21056.67
3868 2025-09-13 21056.67
3869 2025-09-14 21056.67
3870 2025-09-15 21056.67
3871 2025-09-16 20960.00
=========================================================================
2025-09-16 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-09-16 18:31:00,237 - IOOppi_data - INFO : save data to db IOOppi_rb_t data:
date value
3424 2025-09-12 3124.0
3425 2025-09-13 3124.0
3426 2025-09-14 3124.0
3427 2025-09-15 3134.0
3428 2025-09-16 3148.0
2025-09-16 18:31:11,409 - IOOppi_data - INFO : save new data to db: IOOppi_rb_t: no new data
2025-09-16 18:31:11,409 - IOOppi_data - INFO : save diff data to db: IOOppi_rb_t: no diff data
2025-09-16 18:31:11,415 - IOOppi_data - INFO : save data to db IOOppi_rb_g data:
date value
3424 2025-09-12 3124.0
3425 2025-09-13 3124.0
3426 2025-09-14 3124.0
3427 2025-09-15 3134.0
3428 2025-09-16 3148.0
2025-09-16 18:31:15,730 - IOOppi_data - INFO : save new data to db IOOppi_al_t: date value ... created_at updated_at
3871 2025-09-16 20960.0 ... 2025-09-16 18:31:15.722933 2025-09-16 18:31:15.723362
[1 rows x 5 columns]
2025-09-16 18:31:15,750 - IOOppi_data - INFO : save diff data to db: IOOppi_al_t: no diff data
2025-09-16 18:31:15,757 - IOOppi_data - INFO : save data to db IOOppi_al_g data:
date value
3867 2025-09-12 21056.67
3868 2025-09-13 21056.67
3869 2025-09-14 21056.67
3870 2025-09-15 21056.67
3871 2025-09-16 20960.00
2025-09-16 18:31:28,085 - IOOppi_data - INFO : save new data to db IOOppi_al_g: date value ... created_at updated_at
3874 2025-09-16 20960.0 ... 2025-09-16 18:31:28.077684 2025-09-16 18:31:28.078120
[1 rows x 5 columns]
2025-09-16 18:31:28,308 - 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-09-16 18:31:28,954 - IOOppi_data - INFO : save data to db IOOppi_SM_t data:
date value
2981 2025-09-12 5666.0
2982 2025-09-13 5666.0
2983 2025-09-14 5666.0
2984 2025-09-15 5678.0
2985 2025-09-16 5752.0
2025-09-16 18:31:48,590 - IOOppi_data - INFO : save new data to db: IOOppi_rb_g: no new data
2025-09-16 18:31:48,590 - 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-09-16 18:31:52,937 - IOOppi_data - INFO : save data to db IOOppi_MA_t data:
date value
3645 2025-09-12 2288.33
3646 2025-09-13 2288.33
3647 2025-09-14 2288.33
3648 2025-09-15 2295.00
3649 2025-09-16 2286.67
2025-09-16 18:32:15,121 - IOOppi_data - INFO : save new data to db: IOOppi_MA_t: no new data
2025-09-16 18:32:15,121 - IOOppi_data - INFO : save diff data to db: IOOppi_MA_t: no diff data
2025-09-16 18:32:15,127 - IOOppi_data - INFO : save data to db IOOppi_MA_g data:
date value
3645 2025-09-12 2288.33
3646 2025-09-13 2288.33
3647 2025-09-14 2288.33
3648 2025-09-15 2295.00
3649 2025-09-16 2286.67
2025-09-16 18:32:17,601 - IOOppi_data - INFO : save new data to db IOOppi_SM_t: date value ... created_at updated_at
2985 2025-09-16 5752.0 ... 2025-09-16 18:32:17.593426 2025-09-16 18:32:17.593836
[1 rows x 5 columns]
2025-09-16 18:32:17,826 - IOOppi_data - INFO : save diff data to db: IOOppi_SM_t: no diff data
2025-09-16 18:32:17,833 - IOOppi_data - INFO : save data to db IOOppi_SM_g data:
date value
2981 2025-09-12 5666.0
2982 2025-09-13 5666.0
2983 2025-09-14 5666.0
2984 2025-09-15 5678.0
2985 2025-09-16 5752.0
2025-09-16 18:32:21,833 - IOOppi_data - INFO : save new data to db IOOppi_SM_g: date value ... created_at updated_at
2986 2025-09-13 5666.0 ... 2025-09-16 18:32:21.825590 2025-09-16 18:32:21.826015
2987 2025-09-14 5666.0 ... 2025-09-16 18:32:21.825590 2025-09-16 18:32:21.826015
2988 2025-09-15 5678.0 ... 2025-09-16 18:32:21.825590 2025-09-16 18:32:21.826015
2989 2025-09-16 5752.0 ... 2025-09-16 18:32:21.825590 2025-09-16 18:32:21.826015
[4 rows x 5 columns]
2025-09-16 18:32:21,854 - 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-09-16 18:32:22,500 - IOOppi_data - INFO : save data to db IOOppi_CY_t data:
date value
2256 2025-09-12 23550.0
2257 2025-09-13 23550.0
2258 2025-09-14 23550.0
2259 2025-09-15 23550.0
2260 2025-09-16 23550.0
2025-09-16 18:33:43,964 - IOOppi_data - INFO : save new data to db IOOppi_CY_t: date value ... created_at updated_at
2257 2025-09-13 23550.0 ... 2025-09-16 18:33:43.956398 2025-09-16 18:33:43.956833
2258 2025-09-14 23550.0 ... 2025-09-16 18:33:43.956398 2025-09-16 18:33:43.956833
2259 2025-09-15 23550.0 ... 2025-09-16 18:33:43.956398 2025-09-16 18:33:43.956833
2260 2025-09-16 23550.0 ... 2025-09-16 18:33:43.956398 2025-09-16 18:33:43.956833
[4 rows x 5 columns]
2025-09-16 18:33:44,195 - IOOppi_data - INFO : save diff data to db: IOOppi_CY_t: no diff data
2025-09-16 18:33:44,201 - IOOppi_data - INFO : save data to db IOOppi_CY_g data:
date value
2256 2025-09-12 23550.0
2257 2025-09-13 23550.0
2258 2025-09-14 23550.0
2259 2025-09-15 23550.0
2260 2025-09-16 23550.0
2025-09-16 18:33:48,447 - IOOppi_data - INFO : save new data to db IOOppi_CY_g: date value ... created_at updated_at
2261 2025-09-13 23550.0 ... 2025-09-16 18:33:48.440357 2025-09-16 18:33:48.440762
2262 2025-09-14 23550.0 ... 2025-09-16 18:33:48.440357 2025-09-16 18:33:48.440762
2263 2025-09-15 23550.0 ... 2025-09-16 18:33:48.440357 2025-09-16 18:33:48.440762
2264 2025-09-16 23550.0 ... 2025-09-16 18:33:48.440357 2025-09-16 18:33:48.440762
[4 rows x 5 columns]
2025-09-16 18:33:48,672 - 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-09-16 18:33:50,748 - IOOppi_data - INFO : save data to db IOOppi_UR_t data:
date value
1771 2025-09-12 1673.75
1772 2025-09-13 1673.75
1773 2025-09-14 1673.75
1774 2025-09-15 1665.00
1775 2025-09-16 1665.00
2025-09-16 18:33:56,269 - IOOppi_data - INFO : save new data to db IOOppi_UR_t: date value ... created_at updated_at
1772 2025-09-13 1673.75 ... 2025-09-16 18:33:56.261633 2025-09-16 18:33:56.262097
1773 2025-09-14 1673.75 ... 2025-09-16 18:33:56.261633 2025-09-16 18:33:56.262097
1774 2025-09-15 1665.00 ... 2025-09-16 18:33:56.261633 2025-09-16 18:33:56.262097
1775 2025-09-16 1665.00 ... 2025-09-16 18:33:56.261633 2025-09-16 18:33:56.262097
[4 rows x 5 columns]
2025-09-16 18:33:56,289 - IOOppi_data - INFO : save diff data to db: IOOppi_UR_t: no diff data
2025-09-16 18:33:56,295 - IOOppi_data - INFO : save data to db IOOppi_UR_g data:
date value
1771 2025-09-12 1673.75
1772 2025-09-13 1673.75
1773 2025-09-14 1673.75
1774 2025-09-15 1665.00
1775 2025-09-16 1665.00
2025-09-16 18:33:57,836 - IOOppi_data - INFO : save new data to db IOOppi_UR_g: date value ... created_at updated_at
1776 2025-09-13 1673.75 ... 2025-09-16 18:33:57.828478 2025-09-16 18:33:57.828883
1777 2025-09-14 1673.75 ... 2025-09-16 18:33:57.828478 2025-09-16 18:33:57.828883
1778 2025-09-15 1665.00 ... 2025-09-16 18:33:57.828478 2025-09-16 18:33:57.828883
1779 2025-09-16 1665.00 ... 2025-09-16 18:33:57.828478 2025-09-16 18:33:57.828883
[4 rows x 5 columns]
2025-09-16 18:33:57,855 - 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-09-16 18:33:58,488 - IOOppi_data - INFO : save data to db IOOppi_ni_t data:
date value
2843 2025-09-12 123316.67
2844 2025-09-13 123316.67
2845 2025-09-14 123316.67
2846 2025-09-15 123533.33
2847 2025-09-16 123750.00
2025-09-16 18:33:59,415 - IOOppi_data - INFO : save new data to db IOOppi_ni_t: date ... updated_at
2844 2025-09-13 ... 2025-09-16 18:33:59.408876
2845 2025-09-14 ... 2025-09-16 18:33:59.408876
2846 2025-09-15 ... 2025-09-16 18:33:59.408876
2847 2025-09-16 ... 2025-09-16 18:33:59.408876
[4 rows x 5 columns]
2025-09-16 18:34:00,257 - IOOppi_data - INFO : save diff data to db: IOOppi_ni_t: no diff data
2025-09-16 18:34:00,263 - IOOppi_data - INFO : save data to db IOOppi_ni_g data:
date value
2843 2025-09-12 123316.67
2844 2025-09-13 123316.67
2845 2025-09-14 123316.67
2846 2025-09-15 123533.33
2847 2025-09-16 123750.00
Traceback (most recent call last):
File "/usr/local/lib/python3.10/site-packages/sqlalchemy/engine/base.py", line 1967, in _exec_single_context
self.dialect.do_execute(
File "/usr/local/lib/python3.10/site-packages/sqlalchemy/engine/default.py", line 951, in do_execute
cursor.execute(statement, parameters)
File "/usr/local/lib/python3.10/site-packages/pymysql/cursors.py", line 158, in execute
result = self._query(query)
File "/usr/local/lib/python3.10/site-packages/pymysql/cursors.py", line 325, in _query
conn.query(q)
File "/usr/local/lib/python3.10/site-packages/pymysql/connections.py", line 549, in query
self._affected_rows = self._read_query_result(unbuffered=unbuffered)
File "/usr/local/lib/python3.10/site-packages/pymysql/connections.py", line 779, in _read_query_result
result.read()
File "/usr/local/lib/python3.10/site-packages/pymysql/connections.py", line 1164, in read
self._read_result_packet(first_packet)
File "/usr/local/lib/python3.10/site-packages/pymysql/connections.py", line 1240, in _read_result_packet
self._read_rowdata_packet()
File "/usr/local/lib/python3.10/site-packages/pymysql/connections.py", line 1274, in _read_rowdata_packet
packet = self.connection._read_packet()
File "/usr/local/lib/python3.10/site-packages/pymysql/connections.py", line 715, in _read_packet
recv_data = self._read_bytes(bytes_to_read)
File "/usr/local/lib/python3.10/site-packages/pymysql/connections.py", line 752, in _read_bytes
raise err.OperationalError(
pymysql.err.OperationalError: (2013, 'Lost connection to MySQL server during query')
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 455, 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 249, in save_data_to_db
df = pd.read_sql(sql, self.engine)
File "/usr/local/lib/python3.10/site-packages/pandas/io/sql.py", line 736, in read_sql
return pandas_sql.read_query(
File "/usr/local/lib/python3.10/site-packages/pandas/io/sql.py", line 1848, in read_query
result = self.execute(sql, params)
File "/usr/local/lib/python3.10/site-packages/pandas/io/sql.py", line 1671, in execute
return self.con.exec_driver_sql(sql, *args)
File "/usr/local/lib/python3.10/site-packages/sqlalchemy/engine/base.py", line 1779, in exec_driver_sql
ret = self._execute_context(
File "/usr/local/lib/python3.10/site-packages/sqlalchemy/engine/base.py", line 1846, in _execute_context
return self._exec_single_context(
File "/usr/local/lib/python3.10/site-packages/sqlalchemy/engine/base.py", line 1986, in _exec_single_context
self._handle_dbapi_exception(
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 1967, in _exec_single_context
self.dialect.do_execute(
File "/usr/local/lib/python3.10/site-packages/sqlalchemy/engine/default.py", line 951, in do_execute
cursor.execute(statement, parameters)
File "/usr/local/lib/python3.10/site-packages/pymysql/cursors.py", line 158, in execute
result = self._query(query)
File "/usr/local/lib/python3.10/site-packages/pymysql/cursors.py", line 325, in _query
conn.query(q)
File "/usr/local/lib/python3.10/site-packages/pymysql/connections.py", line 549, in query
self._affected_rows = self._read_query_result(unbuffered=unbuffered)
File "/usr/local/lib/python3.10/site-packages/pymysql/connections.py", line 779, in _read_query_result
result.read()
File "/usr/local/lib/python3.10/site-packages/pymysql/connections.py", line 1164, in read
self._read_result_packet(first_packet)
File "/usr/local/lib/python3.10/site-packages/pymysql/connections.py", line 1240, in _read_result_packet
self._read_rowdata_packet()
File "/usr/local/lib/python3.10/site-packages/pymysql/connections.py", line 1274, in _read_rowdata_packet
packet = self.connection._read_packet()
File "/usr/local/lib/python3.10/site-packages/pymysql/connections.py", line 715, in _read_packet
recv_data = self._read_bytes(bytes_to_read)
File "/usr/local/lib/python3.10/site-packages/pymysql/connections.py", line 752, in _read_bytes
raise err.OperationalError(
sqlalchemy.exc.OperationalError: (pymysql.err.OperationalError) (2013, 'Lost connection to MySQL server during query')
[SQL: SELECT `IOOppi_data`.date AS date, `IOOppi_data`.value AS value
FROM `IOOppi_data`
WHERE `IOOppi_data`.index_code = 'IOOppi_ni_g']
(Background on this error at: https://sqlalche.me/e/20/e3q8)
2025-09-16 18:36:39,994 - IOOppi_data - INFO : save new data to db: IOOppi_MA_g: no new data
2025-09-16 18:36:39,994 - 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-09-16 18:36:40,556 - IOOppi_data - INFO : save data to db IOOppi_PTA_t data:
date value
985 2025-09-12 4636.66
986 2025-09-13 4636.66
987 2025-09-14 4636.66
988 2025-09-15 4631.66
989 2025-09-16 4633.75
2025-09-16 18:36:43,290 - IOOppi_data - INFO : save new data to db: IOOppi_PTA_t: no new data
2025-09-16 18:36:43,290 - IOOppi_data - INFO : save diff data to db: IOOppi_PTA_t: no diff data
2025-09-16 18:36:43,295 - IOOppi_data - INFO : save data to db IOOppi_PTA_g data:
date value
985 2025-09-12 4636.66
986 2025-09-13 4636.66
987 2025-09-14 4636.66
988 2025-09-15 4631.66
989 2025-09-16 4633.75
2025-09-16 18:36:45,748 - IOOppi_data - INFO : save new data to db: IOOppi_PTA_g: no new data
2025-09-16 18:36:45,748 - 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-09-16 18:36:46,425 - IOOppi_data - INFO : save data to db IOOppi_ru_t data:
date value
3864 2025-09-12 14983.33
3865 2025-09-13 14983.33
3866 2025-09-14 14983.33
3867 2025-09-15 15133.33
3868 2025-09-16 15166.67
2025-09-16 18:36:48,485 - IOOppi_data - INFO : save new data to db: IOOppi_ru_t: no new data
2025-09-16 18:36:48,486 - IOOppi_data - INFO : save diff data to db: IOOppi_ru_t: no diff data
2025-09-16 18:36:48,491 - IOOppi_data - INFO : save data to db IOOppi_ru_g data:
date value
3864 2025-09-12 14983.33
3865 2025-09-13 14983.33
3866 2025-09-14 14983.33
3867 2025-09-15 15133.33
3868 2025-09-16 15166.67
2025-09-16 18:36:49,869 - IOOppi_data - INFO : save new data to db: IOOppi_ru_g: no new data
2025-09-16 18:36:49,869 - 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-09-16 18:36:50,436 - IOOppi_data - INFO : save data to db IOOppi_i_t data:
date value
3196 2025-09-12 808.00
3197 2025-09-13 808.00
3198 2025-09-14 807.89
3199 2025-09-15 807.89
3200 2025-09-16 816.44
2025-09-16 18:36:51,590 - IOOppi_data - INFO : save new data to db: IOOppi_i_t: no new data
2025-09-16 18:36:51,590 - IOOppi_data - INFO : save diff data to db: IOOppi_i_t: no diff data
2025-09-16 18:36:51,596 - IOOppi_data - INFO : save data to db IOOppi_i_g data:
date value
3196 2025-09-12 808.00
3197 2025-09-13 808.00
3198 2025-09-14 807.89
3199 2025-09-15 807.89
3200 2025-09-16 816.44
2025-09-16 18:36:52,500 - IOOppi_data - INFO : save new data to db: IOOppi_i_g: no new data
2025-09-16 18:36:52,500 - 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-09-16 18:36:53,084 - IOOppi_data - INFO : save data to db IOOppi_FG_t data:
date value
3399 2025-09-12 1130.4
3400 2025-09-13 1130.4
3401 2025-09-14 1130.4
3402 2025-09-15 1130.4
3403 2025-09-16 1120.0
2025-09-16 18:37:13,800 - IOOppi_data - INFO : save new data to db: IOOppi_FG_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-09-16 18:41:26,776 - IOOppi_data - INFO : save diff data to db IOOppi_FG_t: date ... updated_at
12 2012-12-19 ... 2025-09-16 18:41:26.765421
21 2013-01-04 ... 2025-09-16 18:41:26.765421
54 2013-02-27 ... 2025-09-16 18:41:26.765421
60 2013-03-07 ... 2025-09-16 18:41:26.765421
61 2013-03-08 ... 2025-09-16 18:41:26.765421
[5 rows x 6 columns]
2025-09-16 18:41:37,262 - IOOppi_data - INFO : save data to db IOOppi_FG_g data:
date value
3399 2025-09-12 1130.4
3400 2025-09-13 1130.4
3401 2025-09-14 1130.4
3402 2025-09-15 1130.4
3403 2025-09-16 1120.0
2025-09-16 18:41:52,067 - IOOppi_data - INFO : save new data to db: IOOppi_FG_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-09-16 18:45:25,232 - IOOppi_data - INFO : save diff data to db IOOppi_FG_g: date ... updated_at
12 2012-12-19 ... 2025-09-16 18:45:25.223942
21 2013-01-04 ... 2025-09-16 18:45:25.223942
54 2013-02-27 ... 2025-09-16 18:45:25.223942
60 2013-03-07 ... 2025-09-16 18:45:25.223942
61 2013-03-08 ... 2025-09-16 18:45:25.223942
[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-09-16 18:45:42,844 - IOOppi_data - INFO : save data to db IOOppi_eb_t data:
date value
1744 2025-09-12 7314.0
1745 2025-09-13 7320.0
1746 2025-09-14 7320.0
1747 2025-09-15 7314.0
1748 2025-09-16 7324.0
2025-09-16 18:45:45,853 - IOOppi_data - INFO : save new data to db: IOOppi_eb_t: no new data
2025-09-16 18:45:45,853 - IOOppi_data - INFO : save diff data to db: IOOppi_eb_t: no diff data
2025-09-16 18:45:45,858 - IOOppi_data - INFO : save data to db IOOppi_eb_g data:
date value
1744 2025-09-12 7314.0
1745 2025-09-13 7320.0
1746 2025-09-14 7320.0
1747 2025-09-15 7314.0
1748 2025-09-16 7324.0
2025-09-16 18:45:47,024 - IOOppi_data - INFO : save new data to db: IOOppi_eb_g: no new data
2025-09-16 18:45:47,024 - 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-09-16 18:45:47,809 - IOOppi_data - INFO : save data to db IOOppi_SR_t data:
date value
3855 2025-09-12 5855.0
3856 2025-09-13 5855.0
3857 2025-09-14 5855.0
3858 2025-09-15 5850.0
3859 2025-09-16 5865.0
2025-09-16 18:45:52,883 - IOOppi_data - INFO : save new data to db: IOOppi_SR_t: no new data
2025-09-16 18:45:52,883 - IOOppi_data - INFO : save diff data to db: IOOppi_SR_t: no diff data
2025-09-16 18:45:52,889 - IOOppi_data - INFO : save data to db IOOppi_SR_g data:
date value
3855 2025-09-12 5855.0
3856 2025-09-13 5855.0
3857 2025-09-14 5855.0
3858 2025-09-15 5850.0
3859 2025-09-16 5865.0
2025-09-16 18:46:01,267 - IOOppi_data - INFO : save new data to db: IOOppi_SR_g: no new data
2025-09-16 18:46:01,267 - 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-09-16 18:46:01,883 - IOOppi_data - INFO : save data to db IOOppi_ss_t data:
date value
1745 2025-09-12 13067.5
1746 2025-09-13 13067.5
1747 2025-09-14 13067.5
1748 2025-09-15 13092.5
1749 2025-09-16 13092.5
2025-09-16 18:46:13,759 - IOOppi_data - INFO : save new data to db: IOOppi_ss_t: no new data
2025-09-16 18:46:13,759 - IOOppi_data - INFO : save diff data to db: IOOppi_ss_t: no diff data
2025-09-16 18:46:13,764 - IOOppi_data - INFO : save data to db IOOppi_ss_g data:
date value
1745 2025-09-12 13067.5
1746 2025-09-13 13067.5
1747 2025-09-14 13067.5
1748 2025-09-15 13092.5
1749 2025-09-16 13092.5
2025-09-16 18:46:27,509 - IOOppi_data - INFO : save new data to db: IOOppi_ss_g: no new data
2025-09-16 18:46:27,509 - 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-09-16 18:46:28,205 - IOOppi_data - INFO : save data to db IOOppi_RS_t data:
date value
3255 2025-09-12 10000.00
3256 2025-09-13 10000.00
3257 2025-09-14 10000.00
3258 2025-09-15 10026.67
3259 2025-09-16 10166.67
2025-09-16 18:46:49,731 - IOOppi_data - INFO : save new data to db: IOOppi_RS_t: no new data
2025-09-16 18:46:49,731 - IOOppi_data - INFO : save diff data to db: IOOppi_RS_t: no diff data
2025-09-16 18:46:49,737 - IOOppi_data - INFO : save data to db IOOppi_RS_g data:
date value
3255 2025-09-12 10000.00
3256 2025-09-13 10000.00
3257 2025-09-14 10000.00
3258 2025-09-15 10026.67
3259 2025-09-16 10166.67
2025-09-16 18:46:59,329 - IOOppi_data - INFO : save new data to db: IOOppi_RS_g: no new data
2025-09-16 18:46:59,329 - 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-09-16 18:46:59,923 - IOOppi_data - INFO : save data to db IOOppi_RM_t data:
date value
3378 2025-09-12 2680.0
3379 2025-09-13 2680.0
3380 2025-09-14 2680.0
3381 2025-09-15 2635.0
3382 2025-09-16 2655.0
2025-09-16 18:47:14,869 - IOOppi_data - INFO : save new data to db: IOOppi_RM_t: no new data
2025-09-16 18:47:14,869 - IOOppi_data - INFO : save diff data to db: IOOppi_RM_t: no diff data
2025-09-16 18:47:14,877 - IOOppi_data - INFO : save data to db IOOppi_RM_g data:
date value
3378 2025-09-12 2680.0
3379 2025-09-13 2680.0
3380 2025-09-14 2680.0
3381 2025-09-15 2635.0
3382 2025-09-16 2655.0
2025-09-16 18:47:31,726 - IOOppi_data - INFO : save new data to db: IOOppi_RM_g: no new data
2025-09-16 18:47:31,726 - 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-09-16 18:47:32,341 - IOOppi_data - INFO : save data to db IOOppi_SA_t data:
date value
1582 2025-09-12 1262.5
1583 2025-09-13 1262.5
1584 2025-09-14 1262.5
1585 2025-09-15 1262.5
1586 2025-09-16 1262.5
2025-09-16 18:47:46,506 - IOOppi_data - INFO : save new data to db: IOOppi_SA_t: no new data
2025-09-16 18:47:46,507 - IOOppi_data - INFO : save diff data to db: IOOppi_SA_t: no diff data
2025-09-16 18:47:46,512 - IOOppi_data - INFO : save data to db IOOppi_SA_g data:
date value
1582 2025-09-12 1262.5
1583 2025-09-13 1262.5
1584 2025-09-14 1262.5
1585 2025-09-15 1262.5
1586 2025-09-16 1262.5
2025-09-16 18:47:52,580 - IOOppi_data - INFO : save new data to db: IOOppi_SA_g: no new data
2025-09-16 18:47:52,580 - 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-09-16 18:47:53,139 - IOOppi_data - INFO : save data to db IOOppi_PF_t data:
date value
1495 2025-09-12 6457.00
1496 2025-09-13 6457.00
1497 2025-09-14 6457.00
1498 2025-09-15 6471.00
1499 2025-09-16 6478.34
2025-09-16 18:47:54,235 - IOOppi_data - INFO : save new data to db: IOOppi_PF_t: no new data
2025-09-16 18:47:54,236 - IOOppi_data - INFO : save diff data to db: IOOppi_PF_t: no diff data
2025-09-16 18:47:54,241 - IOOppi_data - INFO : save data to db IOOppi_PF_g data:
date value
1495 2025-09-12 6457.00
1496 2025-09-13 6457.00
1497 2025-09-14 6457.00
1498 2025-09-15 6471.00
1499 2025-09-16 6478.34
2025-09-16 18:47:57,008 - IOOppi_data - INFO : save new data to db: IOOppi_PF_g: no new data
2025-09-16 18:47:57,008 - 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-09-16 18:47:57,614 - IOOppi_data - INFO : save data to db IOOppi_m_t data:
date value
3868 2025-09-12 3060.0
3869 2025-09-13 3060.0
3870 2025-09-14 3060.0
3871 2025-09-15 3058.0
3872 2025-09-16 3056.0
2025-09-16 18:48:11,635 - IOOppi_data - INFO : save new data to db: IOOppi_m_t: no new data
2025-09-16 18:48:11,635 - IOOppi_data - INFO : save diff data to db: IOOppi_m_t: no diff data
2025-09-16 18:48:11,641 - IOOppi_data - INFO : save data to db IOOppi_m_g data:
date value
3868 2025-09-12 3060.0
3869 2025-09-13 3060.0
3870 2025-09-14 3060.0
3871 2025-09-15 3058.0
3872 2025-09-16 3056.0
=========================================================================
2025-09-16 19:11:27 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-09-16 19:11:39,450 - IOOppi_data - INFO : save data to db IOOppi_rb_t data:
date value
3424 2025-09-12 3124.0
3425 2025-09-13 3124.0
3426 2025-09-14 3124.0
3427 2025-09-15 3134.0
3428 2025-09-16 3148.0
2025-09-16 19:11:43,264 - IOOppi_data - INFO : save new data to db: IOOppi_rb_t: no new data
2025-09-16 19:11:43,264 - IOOppi_data - INFO : save diff data to db: IOOppi_rb_t: no diff data
2025-09-16 19:11:43,269 - IOOppi_data - INFO : save data to db IOOppi_rb_g data:
date value
3424 2025-09-12 3124.0
3425 2025-09-13 3124.0
3426 2025-09-14 3124.0
3427 2025-09-15 3134.0
3428 2025-09-16 3148.0
2025-09-16 19:11:51,295 - IOOppi_data - INFO : save new data to db: IOOppi_rb_g: no new data
2025-09-16 19:11:51,296 - 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-09-16 19:11:52,057 - IOOppi_data - INFO : save data to db IOOppi_MA_t data:
date value
3645 2025-09-12 2288.33
3646 2025-09-13 2288.33
3647 2025-09-14 2288.33
3648 2025-09-15 2295.00
3649 2025-09-16 2286.67
2025-09-16 19:12:00,134 - IOOppi_data - INFO : save new data to db: IOOppi_MA_t: no new data
2025-09-16 19:12:00,134 - IOOppi_data - INFO : save diff data to db: IOOppi_MA_t: no diff data
2025-09-16 19:12:00,140 - IOOppi_data - INFO : save data to db IOOppi_MA_g data:
date value
3645 2025-09-12 2288.33
3646 2025-09-13 2288.33
3647 2025-09-14 2288.33
3648 2025-09-15 2295.00
3649 2025-09-16 2286.67
2025-09-16 19:12:30,211 - IOOppi_data - INFO : save new data to db: IOOppi_MA_g: no new data
2025-09-16 19:12:30,211 - 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-09-16 19:12:30,834 - IOOppi_data - INFO : save data to db IOOppi_PTA_t data:
date value
985 2025-09-12 4636.66
986 2025-09-13 4636.66
987 2025-09-14 4636.66
988 2025-09-15 4631.66
989 2025-09-16 4633.75
2025-09-16 19:12:44,177 - IOOppi_data - INFO : save new data to db: IOOppi_PTA_t: no new data
2025-09-16 19:12:44,177 - IOOppi_data - INFO : save diff data to db: IOOppi_PTA_t: no diff data
2025-09-16 19:12:44,182 - IOOppi_data - INFO : save data to db IOOppi_PTA_g data:
date value
985 2025-09-12 4636.66
986 2025-09-13 4636.66
987 2025-09-14 4636.66
988 2025-09-15 4631.66
989 2025-09-16 4633.75
2025-09-16 19:12:51,143 - IOOppi_data - INFO : save new data to db: IOOppi_PTA_g: no new data
2025-09-16 19:12:51,143 - 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-09-16 19:12:51,786 - IOOppi_data - INFO : save data to db IOOppi_ru_t data:
date value
3864 2025-09-12 14983.33
3865 2025-09-13 14983.33
3866 2025-09-14 14983.33
3867 2025-09-15 15133.33
3868 2025-09-16 15166.67
2025-09-16 19:13:04,732 - IOOppi_data - INFO : save new data to db: IOOppi_ru_t: no new data
2025-09-16 19:13:04,733 - IOOppi_data - INFO : save diff data to db: IOOppi_ru_t: no diff data
2025-09-16 19:13:04,738 - IOOppi_data - INFO : save data to db IOOppi_ru_g data:
date value
3864 2025-09-12 14983.33
3865 2025-09-13 14983.33
3866 2025-09-14 14983.33
3867 2025-09-15 15133.33
3868 2025-09-16 15166.67
2025-09-16 19:13:10,233 - IOOppi_data - INFO : save new data to db: IOOppi_ru_g: no new data
2025-09-16 19:13:10,233 - 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-09-16 19:13:10,863 - IOOppi_data - INFO : save data to db IOOppi_i_t data:
date value
3196 2025-09-12 808.00
3197 2025-09-13 808.00
3198 2025-09-14 807.89
3199 2025-09-15 807.89
3200 2025-09-16 816.44
2025-09-16 19:13:16,428 - IOOppi_data - INFO : save new data to db: IOOppi_i_t: no new data
2025-09-16 19:13:16,428 - IOOppi_data - INFO : save diff data to db: IOOppi_i_t: no diff data
2025-09-16 19:13:16,433 - IOOppi_data - INFO : save data to db IOOppi_i_g data:
date value
3196 2025-09-12 808.00
3197 2025-09-13 808.00
3198 2025-09-14 807.89
3199 2025-09-15 807.89
3200 2025-09-16 816.44
2025-09-16 19:13:21,773 - IOOppi_data - INFO : save new data to db: IOOppi_i_g: no new data
2025-09-16 19:13:21,773 - 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-09-16 19:13:22,350 - IOOppi_data - INFO : save data to db IOOppi_FG_t data:
date value
3399 2025-09-12 1130.4
3400 2025-09-13 1130.4
3401 2025-09-14 1130.4
3402 2025-09-15 1130.4
3403 2025-09-16 1120.0
2025-09-16 19:13:40,781 - IOOppi_data - INFO : save new data to db: IOOppi_FG_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-09-16 19:15:42,471 - IOOppi_data - INFO : save diff data to db IOOppi_FG_t: date ... updated_at
12 2012-12-19 ... 2025-09-16 19:15:42.461983
21 2013-01-04 ... 2025-09-16 19:15:42.461983
54 2013-02-27 ... 2025-09-16 19:15:42.461983
60 2013-03-07 ... 2025-09-16 19:15:42.461983
61 2013-03-08 ... 2025-09-16 19:15:42.461983
[5 rows x 6 columns]
2025-09-16 19:15:56,930 - IOOppi_data - INFO : save data to db IOOppi_FG_g data:
date value
3399 2025-09-12 1130.4
3400 2025-09-13 1130.4
3401 2025-09-14 1130.4
3402 2025-09-15 1130.4
3403 2025-09-16 1120.0
2025-09-16 19:16:17,645 - IOOppi_data - INFO : save new data to db: IOOppi_FG_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-09-16 19:17:11,562 - IOOppi_data - INFO : save diff data to db IOOppi_FG_g: date ... updated_at
12 2012-12-19 ... 2025-09-16 19:17:11.553636
21 2013-01-04 ... 2025-09-16 19:17:11.553636
54 2013-02-27 ... 2025-09-16 19:17:11.553636
60 2013-03-07 ... 2025-09-16 19:17:11.553636
61 2013-03-08 ... 2025-09-16 19:17:11.553636
[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-09-16 19:17:15,967 - IOOppi_data - INFO : save data to db IOOppi_eb_t data:
date value
1744 2025-09-12 7314.0
1745 2025-09-13 7320.0
1746 2025-09-14 7320.0
1747 2025-09-15 7314.0
1748 2025-09-16 7324.0
2025-09-16 19:17:23,980 - IOOppi_data - INFO : save new data to db: IOOppi_eb_t: no new data
2025-09-16 19:17:23,980 - IOOppi_data - INFO : save diff data to db: IOOppi_eb_t: no diff data
2025-09-16 19:17:23,985 - IOOppi_data - INFO : save data to db IOOppi_eb_g data:
date value
1744 2025-09-12 7314.0
1745 2025-09-13 7320.0
1746 2025-09-14 7320.0
1747 2025-09-15 7314.0
1748 2025-09-16 7324.0
2025-09-16 19:17:29,163 - IOOppi_data - INFO : save new data to db: IOOppi_eb_g: no new data
2025-09-16 19:17:29,164 - 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-09-16 19:17:29,761 - IOOppi_data - INFO : save data to db IOOppi_SR_t data:
date value
3855 2025-09-12 5855.0
3856 2025-09-13 5855.0
3857 2025-09-14 5855.0
3858 2025-09-15 5850.0
3859 2025-09-16 5865.0
2025-09-16 19:17:36,943 - IOOppi_data - INFO : save new data to db: IOOppi_SR_t: no new data
2025-09-16 19:17:36,943 - IOOppi_data - INFO : save diff data to db: IOOppi_SR_t: no diff data
2025-09-16 19:17:36,949 - IOOppi_data - INFO : save data to db IOOppi_SR_g data:
date value
3855 2025-09-12 5855.0
3856 2025-09-13 5855.0
3857 2025-09-14 5855.0
3858 2025-09-15 5850.0
3859 2025-09-16 5865.0
2025-09-16 19:17:43,562 - IOOppi_data - INFO : save new data to db: IOOppi_SR_g: no new data
2025-09-16 19:17:43,562 - 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-09-16 19:17:44,239 - IOOppi_data - INFO : save data to db IOOppi_ss_t data:
date value
1745 2025-09-12 13067.5
1746 2025-09-13 13067.5
1747 2025-09-14 13067.5
1748 2025-09-15 13092.5
1749 2025-09-16 13092.5
2025-09-16 19:17:52,974 - IOOppi_data - INFO : save new data to db: IOOppi_ss_t: no new data
2025-09-16 19:17:52,974 - IOOppi_data - INFO : save diff data to db: IOOppi_ss_t: no diff data
2025-09-16 19:17:52,979 - IOOppi_data - INFO : save data to db IOOppi_ss_g data:
date value
1745 2025-09-12 13067.5
1746 2025-09-13 13067.5
1747 2025-09-14 13067.5
1748 2025-09-15 13092.5
1749 2025-09-16 13092.5
2025-09-16 19:18:04,118 - IOOppi_data - INFO : save new data to db: IOOppi_ss_g: no new data
2025-09-16 19:18:04,118 - 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-09-16 19:18:04,772 - IOOppi_data - INFO : save data to db IOOppi_RS_t data:
date value
3255 2025-09-12 10000.00
3256 2025-09-13 10000.00
3257 2025-09-14 10000.00
3258 2025-09-15 10026.67
3259 2025-09-16 10166.67
2025-09-16 19:18:19,908 - IOOppi_data - INFO : save new data to db: IOOppi_RS_t: no new data
2025-09-16 19:18:19,908 - IOOppi_data - INFO : save diff data to db: IOOppi_RS_t: no diff data
2025-09-16 19:18:19,914 - IOOppi_data - INFO : save data to db IOOppi_RS_g data:
date value
3255 2025-09-12 10000.00
3256 2025-09-13 10000.00
3257 2025-09-14 10000.00
3258 2025-09-15 10026.67
3259 2025-09-16 10166.67
2025-09-16 19:18:24,896 - IOOppi_data - INFO : save new data to db: IOOppi_RS_g: no new data
2025-09-16 19:18:24,896 - 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-09-16 19:18:26,525 - IOOppi_data - INFO : save data to db IOOppi_RM_t data:
date value
3378 2025-09-12 2680.0
3379 2025-09-13 2680.0
3380 2025-09-14 2680.0
3381 2025-09-15 2635.0
3382 2025-09-16 2655.0
2025-09-16 19:18:42,109 - IOOppi_data - INFO : save new data to db: IOOppi_RM_t: no new data
2025-09-16 19:18:42,109 - IOOppi_data - INFO : save diff data to db: IOOppi_RM_t: no diff data
2025-09-16 19:18:42,115 - IOOppi_data - INFO : save data to db IOOppi_RM_g data:
date value
3378 2025-09-12 2680.0
3379 2025-09-13 2680.0
3380 2025-09-14 2680.0
3381 2025-09-15 2635.0
3382 2025-09-16 2655.0
2025-09-16 19:19:24,605 - IOOppi_data - INFO : save new data to db: IOOppi_RM_g: no new data
2025-09-16 19:19:24,605 - 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-09-16 19:19:25,199 - IOOppi_data - INFO : save data to db IOOppi_SA_t data:
date value
1582 2025-09-12 1262.5
1583 2025-09-13 1262.5
1584 2025-09-14 1262.5
1585 2025-09-15 1262.5
1586 2025-09-16 1262.5
2025-09-16 19:19:32,225 - IOOppi_data - INFO : save new data to db: IOOppi_SA_t: no new data
2025-09-16 19:19:32,225 - IOOppi_data - INFO : save diff data to db: IOOppi_SA_t: no diff data
2025-09-16 19:19:32,231 - IOOppi_data - INFO : save data to db IOOppi_SA_g data:
date value
1582 2025-09-12 1262.5
1583 2025-09-13 1262.5
1584 2025-09-14 1262.5
1585 2025-09-15 1262.5
1586 2025-09-16 1262.5
2025-09-16 19:19:33,300 - IOOppi_data - INFO : save new data to db: IOOppi_SA_g: no new data
2025-09-16 19:19:33,300 - 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-09-16 19:19:33,889 - IOOppi_data - INFO : save data to db IOOppi_PF_t data:
date value
1495 2025-09-12 6457.00
1496 2025-09-13 6457.00
1497 2025-09-14 6457.00
1498 2025-09-15 6471.00
1499 2025-09-16 6478.34
2025-09-16 19:19:38,580 - IOOppi_data - INFO : save new data to db: IOOppi_PF_t: no new data
2025-09-16 19:19:38,581 - IOOppi_data - INFO : save diff data to db: IOOppi_PF_t: no diff data
2025-09-16 19:19:38,586 - IOOppi_data - INFO : save data to db IOOppi_PF_g data:
date value
1495 2025-09-12 6457.00
1496 2025-09-13 6457.00
1497 2025-09-14 6457.00
1498 2025-09-15 6471.00
1499 2025-09-16 6478.34
2025-09-16 19:19:39,050 - IOOppi_data - INFO : save new data to db: IOOppi_PF_g: no new data
2025-09-16 19:19:39,050 - 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-09-16 19:19:39,618 - IOOppi_data - INFO : save data to db IOOppi_m_t data:
date value
3868 2025-09-12 3060.0
3869 2025-09-13 3060.0
3870 2025-09-14 3060.0
3871 2025-09-15 3058.0
3872 2025-09-16 3056.0
2025-09-16 19:19:41,577 - IOOppi_data - INFO : save new data to db: IOOppi_m_t: no new data
2025-09-16 19:19:41,577 - IOOppi_data - INFO : save diff data to db: IOOppi_m_t: no diff data
2025-09-16 19:19:41,582 - IOOppi_data - INFO : save data to db IOOppi_m_g data:
date value
3868 2025-09-12 3060.0
3869 2025-09-13 3060.0
3870 2025-09-14 3060.0
3871 2025-09-15 3058.0
3872 2025-09-16 3056.0
2025-09-16 19:19:59,705 - IOOppi_data - INFO : save new data to db: IOOppi_m_g: no new data
2025-09-16 19:19:59,705 - 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-09-16 19:20:00,322 - IOOppi_data - INFO : save data to db IOOppi_y_t data:
date value
3638 2025-09-12 8398.0
3639 2025-09-13 8398.0
3640 2025-09-14 8398.0
3641 2025-09-15 8448.0
3642 2025-09-16 8508.0
2025-09-16 19:20:12,449 - IOOppi_data - INFO : save new data to db: IOOppi_y_t: no new data
2025-09-16 19:20:12,449 - IOOppi_data - INFO : save diff data to db: IOOppi_y_t: no diff data
2025-09-16 19:20:12,455 - IOOppi_data - INFO : save data to db IOOppi_y_g data:
date value
3638 2025-09-12 8398.0
3639 2025-09-13 8398.0
3640 2025-09-14 8398.0
3641 2025-09-15 8448.0
3642 2025-09-16 8508.0
2025-09-16 19:20:18,239 - IOOppi_data - INFO : save new data to db: IOOppi_y_g: no new data
2025-09-16 19:20:18,239 - 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-09-16 19:20:19,727 - IOOppi_data - INFO : save data to db IOOppi_a_t data:
date value
3604 2025-09-12 4305.0
3605 2025-09-13 4305.0
3606 2025-09-14 4305.0
3607 2025-09-15 4305.0
3608 2025-09-16 4305.0
2025-09-16 19:20:27,400 - IOOppi_data - INFO : save new data to db: IOOppi_a_t: no new data
2025-09-16 19:20:27,401 - IOOppi_data - INFO : save diff data to db: IOOppi_a_t: no diff data
2025-09-16 19:20:27,406 - IOOppi_data - INFO : save data to db IOOppi_a_g data:
date value
3604 2025-09-12 4305.0
3605 2025-09-13 4305.0
3606 2025-09-14 4305.0
3607 2025-09-15 4305.0
3608 2025-09-16 4305.0
2025-09-16 19:20:32,096 - IOOppi_data - INFO : save new data to db: IOOppi_a_g: no new data
2025-09-16 19:20:32,096 - 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-09-16 19:20:32,729 - IOOppi_data - INFO : save data to db IOOppi_SF_t data:
date value
2981 2025-09-12 5245.71
2982 2025-09-13 5245.71
2983 2025-09-14 5245.71
2984 2025-09-15 5245.71
2985 2025-09-16 5245.71
2025-09-16 19:20:52,068 - IOOppi_data - INFO : save new data to db: IOOppi_SF_t: no new data
2025-09-16 19:20:52,068 - IOOppi_data - INFO : save diff data to db: IOOppi_SF_t: no diff data
2025-09-16 19:20:52,074 - IOOppi_data - INFO : save data to db IOOppi_SF_g data:
date value
2981 2025-09-12 5245.71
2982 2025-09-13 5245.71
2983 2025-09-14 5245.71
2984 2025-09-15 5245.71
2985 2025-09-16 5245.71
2025-09-16 19:20:54,011 - IOOppi_data - INFO : save new data to db: IOOppi_SF_g: no new data
2025-09-16 19:20:54,011 - 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-09-16 19:20:54,775 - IOOppi_data - INFO : save data to db IOOppi_jd_t data:
date value
3181 2025-09-12 3675.0
3182 2025-09-13 3675.0
3183 2025-09-14 3675.0
3184 2025-09-15 3840.0
3185 2025-09-16 3935.0
2025-09-16 19:22:43,564 - IOOppi_data - INFO : save new data to db: IOOppi_jd_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-09-16 19:22:48,976 - IOOppi_data - INFO : save diff data to db IOOppi_jd_t: date ... updated_at
39 2014-01-03 ... 2025-09-16 19:22:48.968469
458 2015-09-21 ... 2025-09-16 19:22:48.968469
549 2016-02-03 ... 2025-09-16 19:22:48.968469
693 2016-09-05 ... 2025-09-16 19:22:48.968469
696 2016-09-08 ... 2025-09-16 19:22:48.968469
[5 rows x 6 columns]
2025-09-16 19:22:49,005 - IOOppi_data - INFO : save data to db IOOppi_jd_g data:
date value
3181 2025-09-12 3675.0
3182 2025-09-13 3675.0
3183 2025-09-14 3675.0
3184 2025-09-15 3840.0
3185 2025-09-16 3935.0
2025-09-16 19:22:53,241 - IOOppi_data - INFO : save new data to db: IOOppi_jd_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-09-16 19:23:00,893 - IOOppi_data - INFO : save diff data to db IOOppi_jd_g: date ... updated_at
39 2014-01-03 ... 2025-09-16 19:23:00.884518
458 2015-09-21 ... 2025-09-16 19:23:00.884518
549 2016-02-03 ... 2025-09-16 19:23:00.884518
693 2016-09-05 ... 2025-09-16 19:23:00.884518
696 2016-09-08 ... 2025-09-16 19:23:00.884518
[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-09-16 19:23:02,674 - IOOppi_data - INFO : save data to db IOOppi_SI_t data:
date value
985 2025-09-12 9450.0
986 2025-09-13 9450.0
987 2025-09-14 9450.0
988 2025-09-15 9450.0
989 2025-09-16 9560.0
2025-09-16 19:23:03,556 - IOOppi_data - INFO : save new data to db: IOOppi_SI_t: no new data
2025-09-16 19:23:03,556 - IOOppi_data - INFO : save diff data to db: IOOppi_SI_t: no diff data
2025-09-16 19:23:03,561 - IOOppi_data - INFO : save data to db IOOppi_SI_g data:
date value
985 2025-09-12 9450.0
986 2025-09-13 9450.0
987 2025-09-14 9450.0
988 2025-09-15 9450.0
989 2025-09-16 9560.0
2025-09-16 19:23:04,275 - IOOppi_data - INFO : save new data to db: IOOppi_SI_g: no new data
2025-09-16 19:23:04,275 - 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-09-16 19:23:04,918 - IOOppi_data - INFO : save data to db IOOppi_l_t data:
date value
3864 2025-09-12 7380.00
3865 2025-09-13 7380.00
3866 2025-09-14 7380.00
3867 2025-09-15 7378.33
3868 2025-09-16 7395.00
2025-09-16 19:23:15,330 - IOOppi_data - INFO : save new data to db: IOOppi_l_t: no new data
2025-09-16 19:23:15,330 - IOOppi_data - INFO : save diff data to db: IOOppi_l_t: no diff data
2025-09-16 19:23:15,336 - IOOppi_data - INFO : save data to db IOOppi_l_g data:
date value
3864 2025-09-12 7380.00
3865 2025-09-13 7380.00
3866 2025-09-14 7380.00
3867 2025-09-15 7378.33
3868 2025-09-16 7395.00
2025-09-16 19:23:23,176 - IOOppi_data - INFO : save new data to db: IOOppi_l_g: no new data
2025-09-16 19:23:23,176 - 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-09-16 19:23:23,883 - IOOppi_data - INFO : save data to db IOOppi_bu_t data:
date value
3202 2025-09-12 3635.00
3203 2025-09-13 3635.00
3204 2025-09-14 3633.33
3205 2025-09-15 3630.00
3206 2025-09-16 3630.00
2025-09-16 19:23:33,203 - IOOppi_data - INFO : save new data to db: IOOppi_bu_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-09-16 19:23:33,220 - IOOppi_data - INFO : save diff data to db IOOppi_bu_t: date ... updated_at
2560 2023-12-09 ... 2025-09-16 19:23:33.213020
[1 rows x 6 columns]
2025-09-16 19:23:34,476 - IOOppi_data - INFO : save data to db IOOppi_bu_g data:
date value
3202 2025-09-12 3635.00
3203 2025-09-13 3635.00
3204 2025-09-14 3633.33
3205 2025-09-15 3630.00
3206 2025-09-16 3630.00
2025-09-16 19:23:46,816 - IOOppi_data - INFO : save new data to db: IOOppi_bu_g: no new data
2025-09-16 19:23:46,816 - 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-09-16 19:23:47,449 - IOOppi_data - INFO : save data to db IOOppi_al_t data:
date value
3867 2025-09-12 21056.67
3868 2025-09-13 21056.67
3869 2025-09-14 21056.67
3870 2025-09-15 21056.67
3871 2025-09-16 20960.00
2025-09-16 19:23:50,686 - IOOppi_data - INFO : save new data to db: IOOppi_al_t: no new data
2025-09-16 19:23:50,686 - IOOppi_data - INFO : save diff data to db: IOOppi_al_t: no diff data
2025-09-16 19:23:50,692 - IOOppi_data - INFO : save data to db IOOppi_al_g data:
date value
3867 2025-09-12 21056.67
3868 2025-09-13 21056.67
3869 2025-09-14 21056.67
3870 2025-09-15 21056.67
3871 2025-09-16 20960.00
2025-09-16 19:23:57,230 - IOOppi_data - INFO : save new data to db: IOOppi_al_g: no new data
2025-09-16 19:23:57,230 - 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-09-16 19:23:57,910 - IOOppi_data - INFO : save data to db IOOppi_SM_t data:
date value
2981 2025-09-12 5666.0
2982 2025-09-13 5666.0
2983 2025-09-14 5666.0
2984 2025-09-15 5678.0
2985 2025-09-16 5752.0
2025-09-16 19:24:00,505 - IOOppi_data - INFO : save new data to db: IOOppi_SM_t: no new data
2025-09-16 19:24:00,505 - IOOppi_data - INFO : save diff data to db: IOOppi_SM_t: no diff data
2025-09-16 19:24:00,510 - IOOppi_data - INFO : save data to db IOOppi_SM_g data:
date value
2981 2025-09-12 5666.0
2982 2025-09-13 5666.0
2983 2025-09-14 5666.0
2984 2025-09-15 5678.0
2985 2025-09-16 5752.0
2025-09-16 19:24:11,788 - IOOppi_data - INFO : save new data to db: IOOppi_SM_g: no new data
2025-09-16 19:24:11,789 - 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-09-16 19:24:12,500 - IOOppi_data - INFO : save data to db IOOppi_CY_t data:
date value
2256 2025-09-12 23550.0
2257 2025-09-13 23550.0
2258 2025-09-14 23550.0
2259 2025-09-15 23550.0
2260 2025-09-16 23550.0
2025-09-16 19:24:22,872 - IOOppi_data - INFO : save new data to db: IOOppi_CY_t: no new data
2025-09-16 19:24:22,872 - IOOppi_data - INFO : save diff data to db: IOOppi_CY_t: no diff data
2025-09-16 19:24:22,878 - IOOppi_data - INFO : save data to db IOOppi_CY_g data:
date value
2256 2025-09-12 23550.0
2257 2025-09-13 23550.0
2258 2025-09-14 23550.0
2259 2025-09-15 23550.0
2260 2025-09-16 23550.0
2025-09-16 19:24:26,251 - IOOppi_data - INFO : save new data to db: IOOppi_CY_g: no new data
2025-09-16 19:24:26,252 - 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-09-16 19:24:27,100 - IOOppi_data - INFO : save data to db IOOppi_UR_t data:
date value
1771 2025-09-12 1673.75
1772 2025-09-13 1673.75
1773 2025-09-14 1673.75
1774 2025-09-15 1665.00
1775 2025-09-16 1665.00
2025-09-16 19:24:28,426 - IOOppi_data - INFO : save new data to db: IOOppi_UR_t: no new data
2025-09-16 19:24:28,426 - IOOppi_data - INFO : save diff data to db: IOOppi_UR_t: no diff data
2025-09-16 19:24:28,431 - IOOppi_data - INFO : save data to db IOOppi_UR_g data:
date value
1771 2025-09-12 1673.75
1772 2025-09-13 1673.75
1773 2025-09-14 1673.75
1774 2025-09-15 1665.00
1775 2025-09-16 1665.00
2025-09-16 19:24:35,429 - IOOppi_data - INFO : save new data to db: IOOppi_UR_g: no new data
2025-09-16 19:24:35,430 - 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-09-16 19:24:36,786 - IOOppi_data - INFO : save data to db IOOppi_ni_t data:
date value
2843 2025-09-12 123316.67
2844 2025-09-13 123316.67
2845 2025-09-14 123316.67
2846 2025-09-15 123533.33
2847 2025-09-16 123750.00
2025-09-16 19:24:56,629 - IOOppi_data - INFO : save new data to db: IOOppi_ni_t: no new data
2025-09-16 19:24:56,629 - IOOppi_data - INFO : save diff data to db: IOOppi_ni_t: no diff data
2025-09-16 19:24:56,634 - IOOppi_data - INFO : save data to db IOOppi_ni_g data:
date value
2843 2025-09-12 123316.67
2844 2025-09-13 123316.67
2845 2025-09-14 123316.67
2846 2025-09-15 123533.33
2847 2025-09-16 123750.00
2025-09-16 19:25:06,883 - IOOppi_data - INFO : save new data to db IOOppi_ni_g: date ... updated_at
2847 2025-09-13 ... 2025-09-16 19:25:06.877113
2848 2025-09-14 ... 2025-09-16 19:25:06.877113
2849 2025-09-15 ... 2025-09-16 19:25:06.877113
2850 2025-09-16 ... 2025-09-16 19:25:06.877113
[4 rows x 5 columns]
2025-09-16 19:25:07,718 - 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-09-16 19:25:08,349 - IOOppi_data - INFO : save data to db IOOppi_v_t data:
date value
3868 2025-09-12 4635.0
3869 2025-09-13 4635.0
3870 2025-09-14 4635.0
3871 2025-09-15 4660.0
3872 2025-09-16 4704.0
2025-09-16 19:25:13,092 - IOOppi_data - INFO : save new data to db IOOppi_v_t: date value ... created_at updated_at
3869 2025-09-13 4635.0 ... 2025-09-16 19:25:13.083716 2025-09-16 19:25:13.084102
3870 2025-09-14 4635.0 ... 2025-09-16 19:25:13.083716 2025-09-16 19:25:13.084102
3871 2025-09-15 4660.0 ... 2025-09-16 19:25:13.083716 2025-09-16 19:25:13.084102
3872 2025-09-16 4704.0 ... 2025-09-16 19:25:13.083716 2025-09-16 19:25:13.084102
[4 rows x 5 columns]
2025-09-16 19:25:13,111 - IOOppi_data - INFO : save diff data to db: IOOppi_v_t: no diff data
2025-09-16 19:25:13,116 - IOOppi_data - INFO : save data to db IOOppi_v_g data:
date value
3868 2025-09-12 4635.0
3869 2025-09-13 4635.0
3870 2025-09-14 4635.0
3871 2025-09-15 4660.0
3872 2025-09-16 4704.0
2025-09-16 19:25:39,492 - IOOppi_data - INFO : save new data to db IOOppi_v_g: date value ... created_at updated_at
3872 2025-09-13 4635.0 ... 2025-09-16 19:25:39.484857 2025-09-16 19:25:39.485268
3873 2025-09-14 4635.0 ... 2025-09-16 19:25:39.484857 2025-09-16 19:25:39.485268
3874 2025-09-15 4660.0 ... 2025-09-16 19:25:39.484857 2025-09-16 19:25:39.485268
3875 2025-09-16 4704.0 ... 2025-09-16 19:25:39.484857 2025-09-16 19:25:39.485268
[4 rows x 5 columns]
2025-09-16 19:25:39,511 - 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-09-16 19:25:40,148 - IOOppi_data - INFO : save data to db IOOppi_pp_t data:
date value
3107 2025-09-12 7106.67
3108 2025-09-13 7106.67
3109 2025-09-14 7106.67
3110 2025-09-15 7106.67
3111 2025-09-16 7100.00
2025-09-16 19:25:45,592 - IOOppi_data - INFO : save new data to db IOOppi_pp_t: date value ... created_at updated_at
3108 2025-09-13 7106.67 ... 2025-09-16 19:25:45.585266 2025-09-16 19:25:45.585671
3109 2025-09-14 7106.67 ... 2025-09-16 19:25:45.585266 2025-09-16 19:25:45.585671
3110 2025-09-15 7106.67 ... 2025-09-16 19:25:45.585266 2025-09-16 19:25:45.585671
3111 2025-09-16 7100.00 ... 2025-09-16 19:25:45.585266 2025-09-16 19:25:45.585671
[4 rows x 5 columns]
2025-09-16 19:25:46,225 - IOOppi_data - INFO : save diff data to db: IOOppi_pp_t: no diff data
2025-09-16 19:25:46,231 - IOOppi_data - INFO : save data to db IOOppi_pp_g data:
date value
3107 2025-09-12 7106.67
3108 2025-09-13 7106.67
3109 2025-09-14 7106.67
3110 2025-09-15 7106.67
3111 2025-09-16 7100.00
2025-09-16 19:25:48,824 - IOOppi_data - INFO : save new data to db IOOppi_pp_g: date value ... created_at updated_at
3111 2025-09-13 7106.67 ... 2025-09-16 19:25:48.814757 2025-09-16 19:25:48.815141
3112 2025-09-14 7106.67 ... 2025-09-16 19:25:48.814757 2025-09-16 19:25:48.815141
3113 2025-09-15 7106.67 ... 2025-09-16 19:25:48.814757 2025-09-16 19:25:48.815141
3114 2025-09-16 7100.00 ... 2025-09-16 19:25:48.814757 2025-09-16 19:25:48.815141
[4 rows x 5 columns]
2025-09-16 19:25:48,842 - 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-09-16 19:25:49,446 - IOOppi_data - INFO : save data to db IOOppi_CF_t data:
date value
3869 2025-09-12 15254.00
3870 2025-09-13 15254.00
3871 2025-09-14 15254.00
3872 2025-09-15 15255.67
3873 2025-09-16 15299.83
2025-09-16 19:33:21,966 - IOOppi_data - INFO : save new data to db IOOppi_CF_t: date ... updated_at
3870 2025-09-13 ... 2025-09-16 19:33:21.959184
3871 2025-09-14 ... 2025-09-16 19:33:21.959184
3872 2025-09-15 ... 2025-09-16 19:33:21.959184
3873 2025-09-16 ... 2025-09-16 19:33:21.959184
[4 rows x 5 columns]
2025-09-16 19:33:23,419 - IOOppi_data - INFO : save diff data to db: IOOppi_CF_t: no diff data
2025-09-16 19:33:23,425 - IOOppi_data - INFO : save data to db IOOppi_CF_g data:
date value
3869 2025-09-12 15254.00
3870 2025-09-13 15254.00
3871 2025-09-14 15254.00
3872 2025-09-15 15255.67
3873 2025-09-16 15299.83
2025-09-16 19:33:36,840 - IOOppi_data - INFO : save new data to db IOOppi_CF_g: date ... updated_at
3874 2025-09-13 ... 2025-09-16 19:33:36.833844
3875 2025-09-14 ... 2025-09-16 19:33:36.833844
3876 2025-09-15 ... 2025-09-16 19:33:36.833844
3877 2025-09-16 ... 2025-09-16 19:33:36.833844
[4 rows x 5 columns]
2025-09-16 19:33:51,238 - 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-09-16 19:33:51,808 - IOOppi_data - INFO : save data to db IOOppi_pb_t data:
date value
3814 2025-09-12 16850.00
3815 2025-09-13 16850.00
3816 2025-09-14 16850.00
3817 2025-09-15 17037.50
3818 2025-09-16 17031.25
2025-09-16 19:34:18,969 - IOOppi_data - INFO : save new data to db IOOppi_pb_t: date ... updated_at
3815 2025-09-13 ... 2025-09-16 19:34:18.962148
3816 2025-09-14 ... 2025-09-16 19:34:18.962148
3817 2025-09-15 ... 2025-09-16 19:34:18.962148
3818 2025-09-16 ... 2025-09-16 19:34:18.962148
[4 rows x 5 columns]
2025-09-16 19:34:20,418 - IOOppi_data - INFO : save diff data to db: IOOppi_pb_t: no diff data
2025-09-16 19:34:20,425 - IOOppi_data - INFO : save data to db IOOppi_pb_g data:
date value
3814 2025-09-12 16850.00
3815 2025-09-13 16850.00
3816 2025-09-14 16850.00
3817 2025-09-15 17037.50
3818 2025-09-16 17031.25
2025-09-16 19:34:28,472 - IOOppi_data - INFO : save new data to db IOOppi_pb_g: date ... updated_at
3818 2025-09-13 ... 2025-09-16 19:34:28.465967
3819 2025-09-14 ... 2025-09-16 19:34:28.465967
3820 2025-09-15 ... 2025-09-16 19:34:28.465967
3821 2025-09-16 ... 2025-09-16 19:34:28.465967
[4 rows x 5 columns]
2025-09-16 19:34:28,492 - 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-09-16 19:34:29,172 - IOOppi_data - INFO : save data to db IOOppi_hc_t data:
date value
3089 2025-09-12 3430.0
3090 2025-09-13 3430.0
3091 2025-09-14 3430.0
3092 2025-09-15 3430.0
3093 2025-09-16 3430.0
2025-09-16 19:34:45,932 - IOOppi_data - INFO : save new data to db IOOppi_hc_t: date value ... created_at updated_at
3090 2025-09-13 3430.0 ... 2025-09-16 19:34:45.925265 2025-09-16 19:34:45.925693
3091 2025-09-14 3430.0 ... 2025-09-16 19:34:45.925265 2025-09-16 19:34:45.925693
3092 2025-09-15 3430.0 ... 2025-09-16 19:34:45.925265 2025-09-16 19:34:45.925693
3093 2025-09-16 3430.0 ... 2025-09-16 19:34:45.925265 2025-09-16 19:34:45.925693
[4 rows x 5 columns]
2025-09-16 19:34:47,176 - IOOppi_data - INFO : save diff data to db: IOOppi_hc_t: no diff data
2025-09-16 19:34:47,183 - IOOppi_data - INFO : save data to db IOOppi_hc_g data:
date value
3089 2025-09-12 3430.0
3090 2025-09-13 3430.0
3091 2025-09-14 3430.0
3092 2025-09-15 3430.0
3093 2025-09-16 3430.0
2025-09-16 19:34:48,919 - IOOppi_data - INFO : save new data to db IOOppi_hc_g: date value ... created_at updated_at
3093 2025-09-13 3430.0 ... 2025-09-16 19:34:48.911132 2025-09-16 19:34:48.911510
3094 2025-09-14 3430.0 ... 2025-09-16 19:34:48.911132 2025-09-16 19:34:48.911510
3095 2025-09-15 3430.0 ... 2025-09-16 19:34:48.911132 2025-09-16 19:34:48.911510
3096 2025-09-16 3430.0 ... 2025-09-16 19:34:48.911132 2025-09-16 19:34:48.911510
[4 rows x 5 columns]
2025-09-16 19:34:48,937 - 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-09-16 19:34:49,576 - IOOppi_data - INFO : save data to db IOOppi_fu_t data:
date value
3369 2025-09-12 5412.5
3370 2025-09-13 5412.5
3371 2025-09-14 5412.5
3372 2025-09-15 5412.5
3373 2025-09-16 5412.5
2025-09-16 19:35:53,154 - IOOppi_data - INFO : save new data to db IOOppi_fu_t: date value ... created_at updated_at
3370 2025-09-13 5412.5 ... 2025-09-16 19:35:53.146188 2025-09-16 19:35:53.146616
3371 2025-09-14 5412.5 ... 2025-09-16 19:35:53.146188 2025-09-16 19:35:53.146616
3372 2025-09-15 5412.5 ... 2025-09-16 19:35:53.146188 2025-09-16 19:35:53.146616
3373 2025-09-16 5412.5 ... 2025-09-16 19:35:53.146188 2025-09-16 19:35:53.146616
[4 rows x 5 columns]
2025-09-16 19:35:55,421 - IOOppi_data - INFO : save diff data to db: IOOppi_fu_t: no diff data
2025-09-16 19:35:55,427 - IOOppi_data - INFO : save data to db IOOppi_fu_g data:
date value
3369 2025-09-12 5412.5
3370 2025-09-13 5412.5
3371 2025-09-14 5412.5
3372 2025-09-15 5412.5
3373 2025-09-16 5412.5
2025-09-16 19:36:06,123 - IOOppi_data - INFO : save new data to db IOOppi_fu_g: date value ... created_at updated_at
3857 2025-09-13 5412.5 ... 2025-09-16 19:36:06.115742 2025-09-16 19:36:06.116206
3858 2025-09-14 5412.5 ... 2025-09-16 19:36:06.115742 2025-09-16 19:36:06.116206
3859 2025-09-15 5412.5 ... 2025-09-16 19:36:06.115742 2025-09-16 19:36:06.116206
3860 2025-09-16 5412.5 ... 2025-09-16 19:36:06.115742 2025-09-16 19:36:06.116206
[4 rows x 5 columns]
2025-09-16 19:36:06,625 - 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-09-16 19:36:07,210 - IOOppi_data - INFO : save data to db IOOppi_lh_t data:
date value
1433 2025-09-12 13480.0
1434 2025-09-13 13480.0
1435 2025-09-14 13480.0
1436 2025-09-15 13450.0
1437 2025-09-16 13400.0
2025-09-16 19:36:09,746 - IOOppi_data - INFO : save new data to db IOOppi_lh_t: date value ... created_at updated_at
1434 2025-09-13 13480.0 ... 2025-09-16 19:36:09.739147 2025-09-16 19:36:09.739525
1435 2025-09-14 13480.0 ... 2025-09-16 19:36:09.739147 2025-09-16 19:36:09.739525
1436 2025-09-15 13450.0 ... 2025-09-16 19:36:09.739147 2025-09-16 19:36:09.739525
1437 2025-09-16 13400.0 ... 2025-09-16 19:36:09.739147 2025-09-16 19:36:09.739525
[4 rows x 5 columns]
/root/project/IOOppi_data/IOOppi_request.py:308: SettingWithCopyWarning:
A value is trying to be set on a copy of a slice from a DataFrame.
Try using .loc[row_indexer,col_indexer] = value instead
See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy
diff_df.loc[:, 'index_code'] = index_code
/root/project/IOOppi_data/IOOppi_request.py:309: SettingWithCopyWarning:
A value is trying to be set on a copy of a slice from a DataFrame.
Try using .loc[row_indexer,col_indexer] = value instead
See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy
diff_df.loc[:, 'created_at'] = datetime.datetime.now()
/root/project/IOOppi_data/IOOppi_request.py:310: SettingWithCopyWarning:
A value is trying to be set on a copy of a slice from a DataFrame.
Try using .loc[row_indexer,col_indexer] = value instead
See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy
diff_df.loc[:, 'updated_at'] = datetime.datetime.now()
2025-09-16 19:38:11,960 - IOOppi_data - INFO : save diff data to db IOOppi_lh_t: date ... updated_at
116 2021-07-05 ... 2025-09-16 19:38:11.952116
117 2021-07-06 ... 2025-09-16 19:38:11.952116
121 2021-07-12 ... 2025-09-16 19:38:11.952116
122 2021-07-13 ... 2025-09-16 19:38:11.952116
194 2021-11-01 ... 2025-09-16 19:38:11.952116
[5 rows x 6 columns]
2025-09-16 19:38:12,608 - IOOppi_data - INFO : save data to db IOOppi_lh_g data:
date value
1433 2025-09-12 13480.0
1434 2025-09-13 13480.0
1435 2025-09-14 13480.0
1436 2025-09-15 13450.0
1437 2025-09-16 13400.0
2025-09-16 19:38:13,895 - IOOppi_data - INFO : save new data to db IOOppi_lh_g: date value ... created_at updated_at
1437 2025-09-13 13480.0 ... 2025-09-16 19:38:13.887177 2025-09-16 19:38:13.887599
1438 2025-09-14 13480.0 ... 2025-09-16 19:38:13.887177 2025-09-16 19:38:13.887599
1439 2025-09-15 13450.0 ... 2025-09-16 19:38:13.887177 2025-09-16 19:38:13.887599
1440 2025-09-16 13400.0 ... 2025-09-16 19:38:13.887177 2025-09-16 19:38:13.887599
[4 rows x 5 columns]
/root/project/IOOppi_data/IOOppi_request.py:308: SettingWithCopyWarning:
A value is trying to be set on a copy of a slice from a DataFrame.
Try using .loc[row_indexer,col_indexer] = value instead
See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy
diff_df.loc[:, 'index_code'] = index_code
/root/project/IOOppi_data/IOOppi_request.py:309: SettingWithCopyWarning:
A value is trying to be set on a copy of a slice from a DataFrame.
Try using .loc[row_indexer,col_indexer] = value instead
See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy
diff_df.loc[:, 'created_at'] = datetime.datetime.now()
/root/project/IOOppi_data/IOOppi_request.py:310: SettingWithCopyWarning:
A value is trying to be set on a copy of a slice from a DataFrame.
Try using .loc[row_indexer,col_indexer] = value instead
See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy
diff_df.loc[:, 'updated_at'] = datetime.datetime.now()
2025-09-16 19:38:22,257 - IOOppi_data - INFO : save diff data to db IOOppi_lh_g: date ... updated_at
116 2021-07-05 ... 2025-09-16 19:38:22.249227
117 2021-07-06 ... 2025-09-16 19:38:22.249227
121 2021-07-12 ... 2025-09-16 19:38:22.249227
122 2021-07-13 ... 2025-09-16 19:38:22.249227
194 2021-11-01 ... 2025-09-16 19:38:22.249227
[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-09-16 19:38:23,976 - IOOppi_data - INFO : save data to db IOOppi_cu_t data:
date value
3865 2025-09-12 80945.00
3866 2025-09-13 80945.00
3867 2025-09-14 80945.00
3868 2025-09-15 81000.00
3869 2025-09-16 81196.67
2025-09-16 19:38:55,968 - IOOppi_data - INFO : save new data to db IOOppi_cu_t: date ... updated_at
3866 2025-09-13 ... 2025-09-16 19:38:55.961914
3867 2025-09-14 ... 2025-09-16 19:38:55.961914
3868 2025-09-15 ... 2025-09-16 19:38:55.961914
3869 2025-09-16 ... 2025-09-16 19:38:55.961914
[4 rows x 5 columns]
2025-09-16 19:38:57,628 - IOOppi_data - INFO : save diff data to db: IOOppi_cu_t: no diff data
2025-09-16 19:38:57,634 - IOOppi_data - INFO : save data to db IOOppi_cu_g data:
date value
3865 2025-09-12 80945.00
3866 2025-09-13 80945.00
3867 2025-09-14 80945.00
3868 2025-09-15 81000.00
3869 2025-09-16 81196.67
2025-09-16 19:39:02,057 - IOOppi_data - INFO : save new data to db IOOppi_cu_g: date ... updated_at
3869 2025-09-13 ... 2025-09-16 19:39:02.050162
3870 2025-09-14 ... 2025-09-16 19:39:02.050162
3871 2025-09-15 ... 2025-09-16 19:39:02.050162
3872 2025-09-16 ... 2025-09-16 19:39:02.050162
[4 rows x 5 columns]
2025-09-16 19:39:15,567 - 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-09-16 19:39:18,346 - 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-09-16 19:39:40,166 - IOOppi_data - INFO : save new data to db: IOOppi_PM_t: no new data
2025-09-16 19:39:40,166 - IOOppi_data - INFO : save diff data to db: IOOppi_PM_t: no diff data
2025-09-16 19:39:40,172 - 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-09-16 19:39:59,573 - IOOppi_data - INFO : save new data to db: IOOppi_PM_g: no new data
2025-09-16 19:39:59,573 - 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-09-16 19:40:00,277 - IOOppi_data - INFO : save data to db IOOppi_sn_t data:
date value
2843 2025-09-12 274212.5
2844 2025-09-13 274212.5
2845 2025-09-14 274212.5
2846 2025-09-15 273537.5
2847 2025-09-16 272712.5
2025-09-16 19:40:04,262 - IOOppi_data - INFO : save new data to db IOOppi_sn_t: date ... updated_at
2844 2025-09-13 ... 2025-09-16 19:40:04.255840
2845 2025-09-14 ... 2025-09-16 19:40:04.255840
2846 2025-09-15 ... 2025-09-16 19:40:04.255840
2847 2025-09-16 ... 2025-09-16 19:40:04.255840
[4 rows x 5 columns]
2025-09-16 19:40:05,917 - IOOppi_data - INFO : save diff data to db: IOOppi_sn_t: no diff data
2025-09-16 19:40:05,923 - IOOppi_data - INFO : save data to db IOOppi_sn_g data:
date value
2843 2025-09-12 274212.5
2844 2025-09-13 274212.5
2845 2025-09-14 274212.5
2846 2025-09-15 273537.5
2847 2025-09-16 272712.5
2025-09-16 19:40:32,922 - IOOppi_data - INFO : save new data to db IOOppi_sn_g: date ... updated_at
2847 2025-09-13 ... 2025-09-16 19:40:32.914952
2848 2025-09-14 ... 2025-09-16 19:40:32.914952
2849 2025-09-15 ... 2025-09-16 19:40:32.914952
2850 2025-09-16 ... 2025-09-16 19:40:32.914952
[4 rows x 5 columns]
2025-09-16 19:40:33,145 - 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-09-16 19:40:33,744 - IOOppi_data - INFO : save data to db IOOppi_zn_t data:
date value
3864 2025-09-12 22212.0
3865 2025-09-13 22212.0
3866 2025-09-14 22212.0
3867 2025-09-15 22212.0
3868 2025-09-16 22218.0
2025-09-16 19:40:57,176 - IOOppi_data - INFO : save new data to db IOOppi_zn_t: date value ... created_at updated_at
3865 2025-09-13 22212.0 ... 2025-09-16 19:40:57.167997 2025-09-16 19:40:57.168415
3866 2025-09-14 22212.0 ... 2025-09-16 19:40:57.167997 2025-09-16 19:40:57.168415
3867 2025-09-15 22212.0 ... 2025-09-16 19:40:57.167997 2025-09-16 19:40:57.168415
3868 2025-09-16 22218.0 ... 2025-09-16 19:40:57.167997 2025-09-16 19:40:57.168415
[4 rows x 5 columns]
2025-09-16 19:40:58,426 - IOOppi_data - INFO : save diff data to db: IOOppi_zn_t: no diff data
2025-09-16 19:40:58,433 - IOOppi_data - INFO : save data to db IOOppi_zn_g data:
date value
3864 2025-09-12 22212.0
3865 2025-09-13 22212.0
3866 2025-09-14 22212.0
3867 2025-09-15 22212.0
3868 2025-09-16 22218.0
2025-09-16 19:41:08,007 - IOOppi_data - INFO : save new data to db IOOppi_zn_g: date value ... created_at updated_at
3868 2025-09-13 22212.0 ... 2025-09-16 19:41:07.999754 2025-09-16 19:41:08.000152
3869 2025-09-14 22212.0 ... 2025-09-16 19:41:07.999754 2025-09-16 19:41:08.000152
3870 2025-09-15 22212.0 ... 2025-09-16 19:41:07.999754 2025-09-16 19:41:08.000152
3871 2025-09-16 22218.0 ... 2025-09-16 19:41:07.999754 2025-09-16 19:41:08.000152
[4 rows x 5 columns]
2025-09-16 19:41:08,026 - 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-09-16 19:41:08,623 - IOOppi_data - INFO : save data to db IOOppi_wr_t data:
date value
3827 2025-09-12 3290.0
3828 2025-09-13 3290.0
3829 2025-09-14 3290.0
3830 2025-09-15 3315.0
3831 2025-09-16 3315.0
2025-09-16 19:41:12,315 - IOOppi_data - INFO : save new data to db IOOppi_wr_t: date value ... created_at updated_at
3828 2025-09-13 3290.0 ... 2025-09-16 19:41:12.307545 2025-09-16 19:41:12.307964
3829 2025-09-14 3290.0 ... 2025-09-16 19:41:12.307545 2025-09-16 19:41:12.307964
3830 2025-09-15 3315.0 ... 2025-09-16 19:41:12.307545 2025-09-16 19:41:12.307964
3831 2025-09-16 3315.0 ... 2025-09-16 19:41:12.307545 2025-09-16 19:41:12.307964
[4 rows x 5 columns]
2025-09-16 19:41:12,334 - IOOppi_data - INFO : save diff data to db: IOOppi_wr_t: no diff data
2025-09-16 19:41:12,340 - IOOppi_data - INFO : save data to db IOOppi_wr_g data:
date value
3827 2025-09-12 3290.0
3828 2025-09-13 3290.0
3829 2025-09-14 3290.0
3830 2025-09-15 3315.0
3831 2025-09-16 3315.0
2025-09-16 19:41:47,574 - IOOppi_data - INFO : save new data to db IOOppi_wr_g: date value ... created_at updated_at
3831 2025-09-13 3290.0 ... 2025-09-16 19:41:47.567032 2025-09-16 19:41:47.567438
3832 2025-09-14 3290.0 ... 2025-09-16 19:41:47.567032 2025-09-16 19:41:47.567438
3833 2025-09-15 3315.0 ... 2025-09-16 19:41:47.567032 2025-09-16 19:41:47.567438
3834 2025-09-16 3315.0 ... 2025-09-16 19:41:47.567032 2025-09-16 19:41:47.567438
[4 rows x 5 columns]
2025-09-16 19:41:47,800 - 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-09-16 19:41:48,463 - IOOppi_data - INFO : save data to db IOOppi_pg_t data:
date value
1624 2025-09-12 4635.0
1625 2025-09-13 4635.0
1626 2025-09-14 4635.0
1627 2025-09-15 4662.5
1628 2025-09-16 4662.5
2025-09-16 19:41:57,380 - IOOppi_data - INFO : save new data to db IOOppi_pg_t: date value ... created_at updated_at
1625 2025-09-13 4635.0 ... 2025-09-16 19:41:57.372270 2025-09-16 19:41:57.372692
1626 2025-09-14 4635.0 ... 2025-09-16 19:41:57.372270 2025-09-16 19:41:57.372692
1627 2025-09-15 4662.5 ... 2025-09-16 19:41:57.372270 2025-09-16 19:41:57.372692
1628 2025-09-16 4662.5 ... 2025-09-16 19:41:57.372270 2025-09-16 19:41:57.372692
[4 rows x 5 columns]
2025-09-16 19:41:59,862 - IOOppi_data - INFO : save diff data to db: IOOppi_pg_t: no diff data
2025-09-16 19:41:59,868 - IOOppi_data - INFO : save data to db IOOppi_pg_g data:
date value
1624 2025-09-12 4635.0
1625 2025-09-13 4635.0
1626 2025-09-14 4635.0
1627 2025-09-15 4662.5
1628 2025-09-16 4662.5
2025-09-16 19:42:01,397 - IOOppi_data - INFO : save new data to db IOOppi_pg_g: date value ... created_at updated_at
1628 2025-09-13 4635.0 ... 2025-09-16 19:42:01.389167 2025-09-16 19:42:01.389584
1629 2025-09-14 4635.0 ... 2025-09-16 19:42:01.389167 2025-09-16 19:42:01.389584
1630 2025-09-15 4662.5 ... 2025-09-16 19:42:01.389167 2025-09-16 19:42:01.389584
1631 2025-09-16 4662.5 ... 2025-09-16 19:42:01.389167 2025-09-16 19:42:01.389584
[4 rows x 5 columns]
2025-09-16 19:42:01,415 - 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-09-16 19:42:02,002 - IOOppi_data - INFO : save data to db IOOppi_cs_t data:
date value
2898 2025-09-12 2302.86
2899 2025-09-13 2302.86
2900 2025-09-14 2302.86
2901 2025-09-15 2300.00
2902 2025-09-16 2294.29
2025-09-16 19:42:10,069 - IOOppi_data - INFO : save new data to db IOOppi_cs_t: date value ... created_at updated_at
2899 2025-09-13 2302.86 ... 2025-09-16 19:42:10.061643 2025-09-16 19:42:10.062055
2900 2025-09-14 2302.86 ... 2025-09-16 19:42:10.061643 2025-09-16 19:42:10.062055
2901 2025-09-15 2300.00 ... 2025-09-16 19:42:10.061643 2025-09-16 19:42:10.062055
2902 2025-09-16 2294.29 ... 2025-09-16 19:42:10.061643 2025-09-16 19:42:10.062055
[4 rows x 5 columns]
/root/project/IOOppi_data/IOOppi_request.py:308: SettingWithCopyWarning:
A value is trying to be set on a copy of a slice from a DataFrame.
Try using .loc[row_indexer,col_indexer] = value instead
See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy
diff_df.loc[:, 'index_code'] = index_code
/root/project/IOOppi_data/IOOppi_request.py:309: SettingWithCopyWarning:
A value is trying to be set on a copy of a slice from a DataFrame.
Try using .loc[row_indexer,col_indexer] = value instead
See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy
diff_df.loc[:, 'created_at'] = datetime.datetime.now()
/root/project/IOOppi_data/IOOppi_request.py:310: SettingWithCopyWarning:
A value is trying to be set on a copy of a slice from a DataFrame.
Try using .loc[row_indexer,col_indexer] = value instead
See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy
diff_df.loc[:, 'updated_at'] = datetime.datetime.now()
2025-09-16 19:42:10,109 - IOOppi_data - INFO : save diff data to db IOOppi_cs_t: date ... updated_at
2898 2025-09-12 ... 2025-09-16 19:42:10.101598
[1 rows x 6 columns]
2025-09-16 19:42:11,770 - IOOppi_data - INFO : save data to db IOOppi_cs_g data:
date value
2898 2025-09-12 2302.86
2899 2025-09-13 2302.86
2900 2025-09-14 2302.86
2901 2025-09-15 2300.00
2902 2025-09-16 2294.29
2025-09-16 19:42:16,430 - IOOppi_data - INFO : save new data to db IOOppi_cs_g: date value ... created_at updated_at
2902 2025-09-13 2302.86 ... 2025-09-16 19:42:16.423176 2025-09-16 19:42:16.423555
2903 2025-09-14 2302.86 ... 2025-09-16 19:42:16.423176 2025-09-16 19:42:16.423555
2904 2025-09-15 2300.00 ... 2025-09-16 19:42:16.423176 2025-09-16 19:42:16.423555
2905 2025-09-16 2294.29 ... 2025-09-16 19:42:16.423176 2025-09-16 19:42:16.423555
[4 rows x 5 columns]
/root/project/IOOppi_data/IOOppi_request.py:308: SettingWithCopyWarning:
A value is trying to be set on a copy of a slice from a DataFrame.
Try using .loc[row_indexer,col_indexer] = value instead
See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy
diff_df.loc[:, 'index_code'] = index_code
/root/project/IOOppi_data/IOOppi_request.py:309: SettingWithCopyWarning:
A value is trying to be set on a copy of a slice from a DataFrame.
Try using .loc[row_indexer,col_indexer] = value instead
See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy
diff_df.loc[:, 'created_at'] = datetime.datetime.now()
/root/project/IOOppi_data/IOOppi_request.py:310: SettingWithCopyWarning:
A value is trying to be set on a copy of a slice from a DataFrame.
Try using .loc[row_indexer,col_indexer] = value instead
See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy
diff_df.loc[:, 'updated_at'] = datetime.datetime.now()
2025-09-16 19:42:18,112 - IOOppi_data - INFO : save diff data to db IOOppi_cs_g: date ... updated_at
2901 2025-09-12 ... 2025-09-16 19:42:18.104352
[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-09-16 19:42:18,720 - IOOppi_data - INFO : save data to db IOOppi_cs_t data:
date value
2898 2025-09-12 2302.86
2899 2025-09-13 2302.86
2900 2025-09-14 2302.86
2901 2025-09-15 2300.00
2902 2025-09-16 2840.00
2025-09-16 19:42:33,684 - 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-09-16 19:42:33,909 - IOOppi_data - INFO : save diff data to db IOOppi_cs_t: date ... updated_at
2902 2025-09-16 ... 2025-09-16 19:42:33.902342
[1 rows x 6 columns]
2025-09-16 19:42:34,954 - IOOppi_data - INFO : save data to db IOOppi_cs_g data:
date value
2898 2025-09-12 2302.86
2899 2025-09-13 2302.86
2900 2025-09-14 2302.86
2901 2025-09-15 2300.00
2902 2025-09-16 2840.00
2025-09-16 19:42:43,331 - 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-09-16 19:42:44,171 - IOOppi_data - INFO : save diff data to db IOOppi_cs_g: date ... updated_at
2905 2025-09-16 ... 2025-09-16 19:42:44.163868
[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-09-16 19:42:48,657 - IOOppi_data - INFO : save data to db IOOppi_RS_t data:
date value
3255 2025-09-12 10000.00
3256 2025-09-13 10000.00
3257 2025-09-14 10000.00
3258 2025-09-15 10026.67
3259 2025-09-16 10166.67
2025-09-16 19:43:03,375 - IOOppi_data - INFO : save new data to db: IOOppi_RS_t: no new data
2025-09-16 19:43:03,375 - IOOppi_data - INFO : save diff data to db: IOOppi_RS_t: no diff data
2025-09-16 19:43:03,381 - IOOppi_data - INFO : save data to db IOOppi_RS_g data:
date value
3255 2025-09-12 10000.00
3256 2025-09-13 10000.00
3257 2025-09-14 10000.00
3258 2025-09-15 10026.67
3259 2025-09-16 10166.67
2025-09-16 19:43:13,721 - IOOppi_data - INFO : save new data to db: IOOppi_RS_g: no new data
2025-09-16 19:43:13,721 - 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-09-16 19:43:14,359 - IOOppi_data - INFO : save data to db IOOppi_eg_t data:
date value
1939 2025-09-12 4466.67
1940 2025-09-13 4466.67
1941 2025-09-14 4466.67
1942 2025-09-15 4458.33
1943 2025-09-16 4458.33
2025-09-16 19:43:21,949 - IOOppi_data - INFO : save new data to db IOOppi_eg_t: date value ... created_at updated_at
1940 2025-09-13 4466.67 ... 2025-09-16 19:43:21.941907 2025-09-16 19:43:21.942317
1941 2025-09-14 4466.67 ... 2025-09-16 19:43:21.941907 2025-09-16 19:43:21.942317
1942 2025-09-15 4458.33 ... 2025-09-16 19:43:21.941907 2025-09-16 19:43:21.942317
1943 2025-09-16 4458.33 ... 2025-09-16 19:43:21.941907 2025-09-16 19:43:21.942317
[4 rows x 5 columns]
2025-09-16 19:43:22,173 - IOOppi_data - INFO : save diff data to db: IOOppi_eg_t: no diff data
2025-09-16 19:43:22,179 - IOOppi_data - INFO : save data to db IOOppi_eg_g data:
date value
1939 2025-09-12 4466.67
1940 2025-09-13 4466.67
1941 2025-09-14 4466.67
1942 2025-09-15 4458.33
1943 2025-09-16 4458.33
2025-09-16 19:43:27,167 - IOOppi_data - INFO : save new data to db IOOppi_eg_g: date value ... created_at updated_at
1943 2025-09-13 4466.67 ... 2025-09-16 19:43:27.159839 2025-09-16 19:43:27.160255
1944 2025-09-14 4466.67 ... 2025-09-16 19:43:27.159839 2025-09-16 19:43:27.160255
1945 2025-09-15 4458.33 ... 2025-09-16 19:43:27.159839 2025-09-16 19:43:27.160255
1946 2025-09-16 4458.33 ... 2025-09-16 19:43:27.159839 2025-09-16 19:43:27.160255
[4 rows x 5 columns]
2025-09-16 19:43:27,392 - 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-09-16 19:43:29,027 - IOOppi_data - INFO : save data to db IOOppi_sp_t data:
date value
1948 2025-09-12 5716.67
1949 2025-09-13 5716.67
1950 2025-09-14 5716.67
1951 2025-09-15 5716.67
1952 2025-09-16 5716.67
2025-09-16 19:43:34,308 - IOOppi_data - INFO : save new data to db IOOppi_sp_t: date value ... created_at updated_at
1949 2025-09-13 5716.67 ... 2025-09-16 19:43:34.300539 2025-09-16 19:43:34.300961
1950 2025-09-14 5716.67 ... 2025-09-16 19:43:34.300539 2025-09-16 19:43:34.300961
1951 2025-09-15 5716.67 ... 2025-09-16 19:43:34.300539 2025-09-16 19:43:34.300961
1952 2025-09-16 5716.67 ... 2025-09-16 19:43:34.300539 2025-09-16 19:43:34.300961
[4 rows x 5 columns]
2025-09-16 19:43:34,325 - IOOppi_data - INFO : save diff data to db: IOOppi_sp_t: no diff data
2025-09-16 19:43:34,330 - IOOppi_data - INFO : save data to db IOOppi_sp_g data:
date value
1948 2025-09-12 5716.67
1949 2025-09-13 5716.67
1950 2025-09-14 5716.67
1951 2025-09-15 5716.67
1952 2025-09-16 5716.67
2025-09-16 19:43:48,379 - IOOppi_data - INFO : save new data to db IOOppi_sp_g: date value ... created_at updated_at
1952 2025-09-13 5716.67 ... 2025-09-16 19:43:48.372350 2025-09-16 19:43:48.372754
1953 2025-09-14 5716.67 ... 2025-09-16 19:43:48.372350 2025-09-16 19:43:48.372754
1954 2025-09-15 5716.67 ... 2025-09-16 19:43:48.372350 2025-09-16 19:43:48.372754
1955 2025-09-16 5716.67 ... 2025-09-16 19:43:48.372350 2025-09-16 19:43:48.372754
[4 rows x 5 columns]
2025-09-16 19:43:48,602 - 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-09-16 19:43:49,373 - IOOppi_data - INFO : save data to db IOOppi_p_t data:
date value
3616 2025-09-12 9354.0
3617 2025-09-13 9354.0
3618 2025-09-14 9354.0
3619 2025-09-15 9400.0
3620 2025-09-16 9516.0
2025-09-16 19:43:54,262 - IOOppi_data - INFO : save new data to db IOOppi_p_t: date value ... created_at updated_at
3617 2025-09-13 9354.0 ... 2025-09-16 19:43:54.254306 2025-09-16 19:43:54.254713
3618 2025-09-14 9354.0 ... 2025-09-16 19:43:54.254306 2025-09-16 19:43:54.254713
3619 2025-09-15 9400.0 ... 2025-09-16 19:43:54.254306 2025-09-16 19:43:54.254713
3620 2025-09-16 9516.0 ... 2025-09-16 19:43:54.254306 2025-09-16 19:43:54.254713
[4 rows x 5 columns]
2025-09-16 19:43:54,280 - IOOppi_data - INFO : save diff data to db: IOOppi_p_t: no diff data
2025-09-16 19:43:54,286 - IOOppi_data - INFO : save data to db IOOppi_p_g data:
date value
3616 2025-09-12 9354.0
3617 2025-09-13 9354.0
3618 2025-09-14 9354.0
3619 2025-09-15 9400.0
3620 2025-09-16 9516.0
2025-09-16 19:44:02,629 - IOOppi_data - INFO : save new data to db IOOppi_p_g: date value ... created_at updated_at
3620 2025-09-13 9354.0 ... 2025-09-16 19:44:02.621510 2025-09-16 19:44:02.621937
3621 2025-09-14 9354.0 ... 2025-09-16 19:44:02.621510 2025-09-16 19:44:02.621937
3622 2025-09-15 9400.0 ... 2025-09-16 19:44:02.621510 2025-09-16 19:44:02.621937
3623 2025-09-16 9516.0 ... 2025-09-16 19:44:02.621510 2025-09-16 19:44:02.621937
[4 rows x 5 columns]
2025-09-16 19:44:03,467 - 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 1967, in _exec_single_context
self.dialect.do_execute(
File "/usr/local/lib/python3.10/site-packages/sqlalchemy/engine/default.py", line 951, in do_execute
cursor.execute(statement, parameters)
File "/usr/local/lib/python3.10/site-packages/pymysql/cursors.py", line 158, in execute
result = self._query(query)
File "/usr/local/lib/python3.10/site-packages/pymysql/cursors.py", line 325, in _query
conn.query(q)
File "/usr/local/lib/python3.10/site-packages/pymysql/connections.py", line 549, in query
self._affected_rows = self._read_query_result(unbuffered=unbuffered)
File "/usr/local/lib/python3.10/site-packages/pymysql/connections.py", line 779, in _read_query_result
result.read()
File "/usr/local/lib/python3.10/site-packages/pymysql/connections.py", line 1164, in read
self._read_result_packet(first_packet)
File "/usr/local/lib/python3.10/site-packages/pymysql/connections.py", line 1240, in _read_result_packet
self._read_rowdata_packet()
File "/usr/local/lib/python3.10/site-packages/pymysql/connections.py", line 1274, in _read_rowdata_packet
packet = self.connection._read_packet()
File "/usr/local/lib/python3.10/site-packages/pymysql/connections.py", line 715, in _read_packet
recv_data = self._read_bytes(bytes_to_read)
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 455, 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 249, in save_data_to_db
df = pd.read_sql(sql, self.engine)
File "/usr/local/lib/python3.10/site-packages/pandas/io/sql.py", line 736, in read_sql
return pandas_sql.read_query(
File "/usr/local/lib/python3.10/site-packages/pandas/io/sql.py", line 1848, in read_query
result = self.execute(sql, params)
File "/usr/local/lib/python3.10/site-packages/pandas/io/sql.py", line 1671, in execute
return self.con.exec_driver_sql(sql, *args)
File "/usr/local/lib/python3.10/site-packages/sqlalchemy/engine/base.py", line 1779, in exec_driver_sql
ret = self._execute_context(
File "/usr/local/lib/python3.10/site-packages/sqlalchemy/engine/base.py", line 1846, in _execute_context
return self._exec_single_context(
File "/usr/local/lib/python3.10/site-packages/sqlalchemy/engine/base.py", line 1986, in _exec_single_context
self._handle_dbapi_exception(
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 1967, in _exec_single_context
self.dialect.do_execute(
File "/usr/local/lib/python3.10/site-packages/sqlalchemy/engine/default.py", line 951, in do_execute
cursor.execute(statement, parameters)
File "/usr/local/lib/python3.10/site-packages/pymysql/cursors.py", line 158, in execute
result = self._query(query)
File "/usr/local/lib/python3.10/site-packages/pymysql/cursors.py", line 325, in _query
conn.query(q)
File "/usr/local/lib/python3.10/site-packages/pymysql/connections.py", line 549, in query
self._affected_rows = self._read_query_result(unbuffered=unbuffered)
File "/usr/local/lib/python3.10/site-packages/pymysql/connections.py", line 779, in _read_query_result
result.read()
File "/usr/local/lib/python3.10/site-packages/pymysql/connections.py", line 1164, in read
self._read_result_packet(first_packet)
File "/usr/local/lib/python3.10/site-packages/pymysql/connections.py", line 1240, in _read_result_packet
self._read_rowdata_packet()
File "/usr/local/lib/python3.10/site-packages/pymysql/connections.py", line 1274, in _read_rowdata_packet
packet = self.connection._read_packet()
File "/usr/local/lib/python3.10/site-packages/pymysql/connections.py", line 715, in _read_packet
recv_data = self._read_bytes(bytes_to_read)
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)')
[SQL: SELECT `IOOppi_data`.date AS date, `IOOppi_data`.value AS value
FROM `IOOppi_data`
WHERE `IOOppi_data`.index_code = 'IOOppi_m_g']
(Background on this error at: https://sqlalche.me/e/20/e3q8)