=========================================================================
2025-09-22 17:50:26 Mon START TASK.01 IOOppi_data update_data
=========================================================================
/usr/local/lib/python3.10/site-packages/urllib3/connectionpool.py:1056: InsecureRequestWarning: Unverified HTTPS request is being made to host 'www.100ppi.com'. Adding certificate verification is strongly advised. See: https://urllib3.readthedocs.io/en/1.26.x/advanced-usage.html#ssl-warnings
warnings.warn(
2025-09-22 17:50:28,726 - IOOppi_data - INFO : save data to db IOOppi_rb_t data:
date value
3430 2025-09-18 3141.0
3431 2025-09-19 3150.0
3432 2025-09-20 3150.0
3433 2025-09-21 3150.0
3434 2025-09-22 3167.5
2025-09-22 17:50:28,802 - IOOppi_data - INFO : save new data to db IOOppi_rb_t: date value ... created_at updated_at
3432 2025-09-20 3150.0 ... 2025-09-22 17:50:28.794609 2025-09-22 17:50:28.795026
3433 2025-09-21 3150.0 ... 2025-09-22 17:50:28.794609 2025-09-22 17:50:28.795026
3434 2025-09-22 3167.5 ... 2025-09-22 17:50:28.794609 2025-09-22 17:50:28.795026
[3 rows x 5 columns]
2025-09-22 17:50:28,832 - IOOppi_data - INFO : save diff data to db: IOOppi_rb_t: no diff data
2025-09-22 17:50:28,838 - IOOppi_data - INFO : save data to db IOOppi_rb_g data:
date value
3430 2025-09-18 3141.0
3431 2025-09-19 3150.0
3432 2025-09-20 3150.0
3433 2025-09-21 3150.0
3434 2025-09-22 3167.5
2025-09-22 17:50:28,907 - IOOppi_data - INFO : save new data to db IOOppi_rb_g: date value ... created_at updated_at
3435 2025-09-20 3150.0 ... 2025-09-22 17:50:28.900070 2025-09-22 17:50:28.900446
3436 2025-09-21 3150.0 ... 2025-09-22 17:50:28.900070 2025-09-22 17:50:28.900446
3437 2025-09-22 3167.5 ... 2025-09-22 17:50:28.900070 2025-09-22 17:50:28.900446
[3 rows x 5 columns]
2025-09-22 17:50:28,927 - 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-22 17:50:29,673 - IOOppi_data - INFO : save data to db IOOppi_MA_t data:
date value
3651 2025-09-18 2261.67
3652 2025-09-19 2262.00
3653 2025-09-20 2262.00
3654 2025-09-21 2262.00
3655 2025-09-22 2255.00
2025-09-22 17:50:29,745 - IOOppi_data - INFO : save new data to db IOOppi_MA_t: date value ... created_at updated_at
3653 2025-09-20 2262.0 ... 2025-09-22 17:50:29.738198 2025-09-22 17:50:29.738604
3654 2025-09-21 2262.0 ... 2025-09-22 17:50:29.738198 2025-09-22 17:50:29.738604
3655 2025-09-22 2255.0 ... 2025-09-22 17:50:29.738198 2025-09-22 17:50:29.738604
[3 rows x 5 columns]
2025-09-22 17:50:29,766 - IOOppi_data - INFO : save diff data to db: IOOppi_MA_t: no diff data
2025-09-22 17:50:29,772 - IOOppi_data - INFO : save data to db IOOppi_MA_g data:
date value
3651 2025-09-18 2261.67
3652 2025-09-19 2262.00
3653 2025-09-20 2262.00
3654 2025-09-21 2262.00
3655 2025-09-22 2255.00
2025-09-22 17:50:29,842 - IOOppi_data - INFO : save new data to db IOOppi_MA_g: date value ... created_at updated_at
3657 2025-09-20 2262.0 ... 2025-09-22 17:50:29.834509 2025-09-22 17:50:29.834994
3658 2025-09-21 2262.0 ... 2025-09-22 17:50:29.834509 2025-09-22 17:50:29.834994
3659 2025-09-22 2255.0 ... 2025-09-22 17:50:29.834509 2025-09-22 17:50:29.834994
[3 rows x 5 columns]
2025-09-22 17:50:29,863 - 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-22 17:50:30,701 - IOOppi_data - INFO : save data to db IOOppi_PTA_t data:
date value
991 2025-09-18 4644.00
992 2025-09-19 4631.25
993 2025-09-20 4631.25
994 2025-09-21 4631.25
995 2025-09-22 4626.25
2025-09-22 17:50:30,741 - IOOppi_data - INFO : save new data to db IOOppi_PTA_t: date value ... created_at updated_at
993 2025-09-20 4631.25 ... 2025-09-22 17:50:30.733495 2025-09-22 17:50:30.733942
994 2025-09-21 4631.25 ... 2025-09-22 17:50:30.733495 2025-09-22 17:50:30.733942
995 2025-09-22 4626.25 ... 2025-09-22 17:50:30.733495 2025-09-22 17:50:30.733942
[3 rows x 5 columns]
2025-09-22 17:50:30,763 - IOOppi_data - INFO : save diff data to db: IOOppi_PTA_t: no diff data
2025-09-22 17:50:30,768 - IOOppi_data - INFO : save data to db IOOppi_PTA_g data:
date value
991 2025-09-18 4644.00
992 2025-09-19 4631.25
993 2025-09-20 4631.25
994 2025-09-21 4631.25
995 2025-09-22 4626.25
2025-09-22 17:50:30,811 - IOOppi_data - INFO : save new data to db IOOppi_PTA_g: date value ... created_at updated_at
993 2025-09-20 4631.25 ... 2025-09-22 17:50:30.803366 2025-09-22 17:50:30.803817
994 2025-09-21 4631.25 ... 2025-09-22 17:50:30.803366 2025-09-22 17:50:30.803817
995 2025-09-22 4626.25 ... 2025-09-22 17:50:30.803366 2025-09-22 17:50:30.803817
[3 rows x 5 columns]
2025-09-22 17:50:30,832 - 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-22 17:50:31,594 - IOOppi_data - INFO : save data to db IOOppi_ru_t data:
date value
3870 2025-09-18 14850.00
3871 2025-09-19 14858.33
3872 2025-09-20 14858.33
3873 2025-09-21 14858.33
3874 2025-09-22 14908.33
2025-09-22 17:50:31,666 - IOOppi_data - INFO : save new data to db IOOppi_ru_t: date ... updated_at
3872 2025-09-20 ... 2025-09-22 17:50:31.659690
3873 2025-09-21 ... 2025-09-22 17:50:31.659690
3874 2025-09-22 ... 2025-09-22 17:50:31.659690
[3 rows x 5 columns]
2025-09-22 17:50:31,688 - IOOppi_data - INFO : save diff data to db: IOOppi_ru_t: no diff data
2025-09-22 17:50:31,695 - IOOppi_data - INFO : save data to db IOOppi_ru_g data:
date value
3870 2025-09-18 14850.00
3871 2025-09-19 14858.33
3872 2025-09-20 14858.33
3873 2025-09-21 14858.33
3874 2025-09-22 14908.33
2025-09-22 17:50:31,767 - IOOppi_data - INFO : save new data to db IOOppi_ru_g: date ... updated_at
3875 2025-09-20 ... 2025-09-22 17:50:31.760891
3876 2025-09-21 ... 2025-09-22 17:50:31.760891
3877 2025-09-22 ... 2025-09-22 17:50:31.760891
[3 rows x 5 columns]
2025-09-22 17:50:31,787 - 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-22 17:50:32,437 - IOOppi_data - INFO : save data to db IOOppi_i_t data:
date value
3202 2025-09-18 807.56
3203 2025-09-19 807.44
3204 2025-09-20 807.44
3205 2025-09-21 807.44
3206 2025-09-22 819.00
2025-09-22 17:50:32,503 - IOOppi_data - INFO : save new data to db IOOppi_i_t: date value ... created_at updated_at
3204 2025-09-20 807.44 ... 2025-09-22 17:50:32.495781 2025-09-22 17:50:32.496168
3205 2025-09-21 807.44 ... 2025-09-22 17:50:32.495781 2025-09-22 17:50:32.496168
3206 2025-09-22 819.00 ... 2025-09-22 17:50:32.495781 2025-09-22 17:50:32.496168
[3 rows x 5 columns]
2025-09-22 17:50:32,524 - IOOppi_data - INFO : save diff data to db: IOOppi_i_t: no diff data
2025-09-22 17:50:32,529 - IOOppi_data - INFO : save data to db IOOppi_i_g data:
date value
3202 2025-09-18 807.56
3203 2025-09-19 807.44
3204 2025-09-20 807.44
3205 2025-09-21 807.44
3206 2025-09-22 819.00
2025-09-22 17:50:32,593 - IOOppi_data - INFO : save new data to db IOOppi_i_g: date value ... created_at updated_at
3207 2025-09-20 807.44 ... 2025-09-22 17:50:32.586110 2025-09-22 17:50:32.586482
3208 2025-09-21 807.44 ... 2025-09-22 17:50:32.586110 2025-09-22 17:50:32.586482
3209 2025-09-22 819.00 ... 2025-09-22 17:50:32.586110 2025-09-22 17:50:32.586482
[3 rows x 5 columns]
2025-09-22 17:50:32,613 - 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-22 17:50:33,354 - IOOppi_data - INFO : save data to db IOOppi_FG_t data:
date value
3405 2025-09-18 1144.0
3406 2025-09-19 1142.4
3407 2025-09-20 1142.4
3408 2025-09-21 1142.4
3409 2025-09-22 1144.0
2025-09-22 17:50:33,422 - IOOppi_data - INFO : save new data to db IOOppi_FG_t: date value ... created_at updated_at
3407 2025-09-20 1142.4 ... 2025-09-22 17:50:33.415124 2025-09-22 17:50:33.415511
3408 2025-09-21 1142.4 ... 2025-09-22 17:50:33.415124 2025-09-22 17:50:33.415511
3409 2025-09-22 1144.0 ... 2025-09-22 17:50:33.415124 2025-09-22 17:50:33.415511
[3 rows x 5 columns]
/root/project/IOOppi_data/IOOppi_request.py:308: SettingWithCopyWarning:
A value is trying to be set on a copy of a slice from a DataFrame.
Try using .loc[row_indexer,col_indexer] = value instead
See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy
diff_df.loc[:, 'index_code'] = index_code
/root/project/IOOppi_data/IOOppi_request.py:309: SettingWithCopyWarning:
A value is trying to be set on a copy of a slice from a DataFrame.
Try using .loc[row_indexer,col_indexer] = value instead
See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy
diff_df.loc[:, 'created_at'] = datetime.datetime.now()
/root/project/IOOppi_data/IOOppi_request.py:310: SettingWithCopyWarning:
A value is trying to be set on a copy of a slice from a DataFrame.
Try using .loc[row_indexer,col_indexer] = value instead
See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy
diff_df.loc[:, 'updated_at'] = datetime.datetime.now()
2025-09-22 17:50:36,495 - IOOppi_data - INFO : save diff data to db IOOppi_FG_t: date ... updated_at
12 2012-12-19 ... 2025-09-22 17:50:36.487961
21 2013-01-04 ... 2025-09-22 17:50:36.487961
54 2013-02-27 ... 2025-09-22 17:50:36.487961
60 2013-03-07 ... 2025-09-22 17:50:36.487961
61 2013-03-08 ... 2025-09-22 17:50:36.487961
[5 rows x 6 columns]
2025-09-22 17:50:36,717 - IOOppi_data - INFO : save data to db IOOppi_FG_g data:
date value
3405 2025-09-18 1144.0
3406 2025-09-19 1142.4
3407 2025-09-20 1142.4
3408 2025-09-21 1142.4
3409 2025-09-22 1144.0
2025-09-22 17:50:36,785 - IOOppi_data - INFO : save new data to db IOOppi_FG_g: date value ... created_at updated_at
3411 2025-09-20 1142.4 ... 2025-09-22 17:50:36.778219 2025-09-22 17:50:36.778639
3412 2025-09-21 1142.4 ... 2025-09-22 17:50:36.778219 2025-09-22 17:50:36.778639
3413 2025-09-22 1144.0 ... 2025-09-22 17:50:36.778219 2025-09-22 17:50:36.778639
[3 rows x 5 columns]
/root/project/IOOppi_data/IOOppi_request.py:308: SettingWithCopyWarning:
A value is trying to be set on a copy of a slice from a DataFrame.
Try using .loc[row_indexer,col_indexer] = value instead
See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy
diff_df.loc[:, 'index_code'] = index_code
/root/project/IOOppi_data/IOOppi_request.py:309: SettingWithCopyWarning:
A value is trying to be set on a copy of a slice from a DataFrame.
Try using .loc[row_indexer,col_indexer] = value instead
See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy
diff_df.loc[:, 'created_at'] = datetime.datetime.now()
/root/project/IOOppi_data/IOOppi_request.py:310: SettingWithCopyWarning:
A value is trying to be set on a copy of a slice from a DataFrame.
Try using .loc[row_indexer,col_indexer] = value instead
See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy
diff_df.loc[:, 'updated_at'] = datetime.datetime.now()
2025-09-22 17:50:39,412 - IOOppi_data - INFO : save diff data to db IOOppi_FG_g: date ... updated_at
12 2012-12-19 ... 2025-09-22 17:50:39.403806
21 2013-01-04 ... 2025-09-22 17:50:39.403806
54 2013-02-27 ... 2025-09-22 17:50:39.403806
60 2013-03-07 ... 2025-09-22 17:50:39.403806
61 2013-03-08 ... 2025-09-22 17:50:39.403806
[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-22 17:50:40,335 - IOOppi_data - INFO : save data to db IOOppi_eb_t data:
date value
1750 2025-09-18 7328.0
1751 2025-09-19 7314.0
1752 2025-09-20 7314.0
1753 2025-09-21 7314.0
1754 2025-09-22 7184.0
2025-09-22 17:50:40,386 - IOOppi_data - INFO : save new data to db IOOppi_eb_t: date value ... created_at updated_at
1752 2025-09-20 7314.0 ... 2025-09-22 17:50:40.378029 2025-09-22 17:50:40.378438
1753 2025-09-21 7314.0 ... 2025-09-22 17:50:40.378029 2025-09-22 17:50:40.378438
1754 2025-09-22 7184.0 ... 2025-09-22 17:50:40.378029 2025-09-22 17:50:40.378438
[3 rows x 5 columns]
2025-09-22 17:50:40,407 - IOOppi_data - INFO : save diff data to db: IOOppi_eb_t: no diff data
2025-09-22 17:50:40,413 - IOOppi_data - INFO : save data to db IOOppi_eb_g data:
date value
1750 2025-09-18 7328.0
1751 2025-09-19 7314.0
1752 2025-09-20 7314.0
1753 2025-09-21 7314.0
1754 2025-09-22 7184.0
2025-09-22 17:50:40,460 - IOOppi_data - INFO : save new data to db IOOppi_eb_g: date value ... created_at updated_at
1755 2025-09-20 7314.0 ... 2025-09-22 17:50:40.453160 2025-09-22 17:50:40.453541
1756 2025-09-21 7314.0 ... 2025-09-22 17:50:40.453160 2025-09-22 17:50:40.453541
1757 2025-09-22 7184.0 ... 2025-09-22 17:50:40.453160 2025-09-22 17:50:40.453541
[3 rows x 5 columns]
2025-09-22 17:50:40,482 - 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-22 17:50:41,182 - IOOppi_data - INFO : save data to db IOOppi_SR_t data:
date value
3861 2025-09-18 5871.67
3862 2025-09-19 5865.00
3863 2025-09-20 5865.00
3864 2025-09-21 5865.00
3865 2025-09-22 5836.67
2025-09-22 17:50:41,255 - IOOppi_data - INFO : save new data to db IOOppi_SR_t: date value ... created_at updated_at
3863 2025-09-20 5865.00 ... 2025-09-22 17:50:41.247777 2025-09-22 17:50:41.248168
3864 2025-09-21 5865.00 ... 2025-09-22 17:50:41.247777 2025-09-22 17:50:41.248168
3865 2025-09-22 5836.67 ... 2025-09-22 17:50:41.247777 2025-09-22 17:50:41.248168
[3 rows x 5 columns]
2025-09-22 17:50:41,275 - IOOppi_data - INFO : save diff data to db: IOOppi_SR_t: no diff data
2025-09-22 17:50:41,281 - IOOppi_data - INFO : save data to db IOOppi_SR_g data:
date value
3861 2025-09-18 5871.67
3862 2025-09-19 5865.00
3863 2025-09-20 5865.00
3864 2025-09-21 5865.00
3865 2025-09-22 5836.67
2025-09-22 17:50:41,355 - IOOppi_data - INFO : save new data to db IOOppi_SR_g: date value ... created_at updated_at
3867 2025-09-20 5865.00 ... 2025-09-22 17:50:41.347596 2025-09-22 17:50:41.347993
3868 2025-09-21 5865.00 ... 2025-09-22 17:50:41.347596 2025-09-22 17:50:41.347993
3869 2025-09-22 5836.67 ... 2025-09-22 17:50:41.347596 2025-09-22 17:50:41.347993
[3 rows x 5 columns]
2025-09-22 17:50:41,375 - 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-22 17:50:42,023 - IOOppi_data - INFO : save data to db IOOppi_ss_t data:
date value
1751 2025-09-18 13092.5
1752 2025-09-19 13112.5
1753 2025-09-20 13112.5
1754 2025-09-21 13112.5
1755 2025-09-22 13092.5
2025-09-22 17:50:42,071 - IOOppi_data - INFO : save new data to db IOOppi_ss_t: date value ... created_at updated_at
1753 2025-09-20 13112.5 ... 2025-09-22 17:50:42.063767 2025-09-22 17:50:42.064184
1754 2025-09-21 13112.5 ... 2025-09-22 17:50:42.063767 2025-09-22 17:50:42.064184
1755 2025-09-22 13092.5 ... 2025-09-22 17:50:42.063767 2025-09-22 17:50:42.064184
[3 rows x 5 columns]
2025-09-22 17:50:42,091 - IOOppi_data - INFO : save diff data to db: IOOppi_ss_t: no diff data
2025-09-22 17:50:42,097 - IOOppi_data - INFO : save data to db IOOppi_ss_g data:
date value
1751 2025-09-18 13092.5
1752 2025-09-19 13112.5
1753 2025-09-20 13112.5
1754 2025-09-21 13112.5
1755 2025-09-22 13092.5
2025-09-22 17:50:42,146 - IOOppi_data - INFO : save new data to db IOOppi_ss_g: date value ... created_at updated_at
1756 2025-09-20 13112.5 ... 2025-09-22 17:50:42.138356 2025-09-22 17:50:42.138754
1757 2025-09-21 13112.5 ... 2025-09-22 17:50:42.138356 2025-09-22 17:50:42.138754
1758 2025-09-22 13092.5 ... 2025-09-22 17:50:42.138356 2025-09-22 17:50:42.138754
[3 rows x 5 columns]
2025-09-22 17:50:42,166 - 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-22 17:50:42,797 - IOOppi_data - INFO : save data to db IOOppi_RS_t data:
date value
3261 2025-09-18 10106.67
3262 2025-09-19 10203.33
3263 2025-09-20 10203.33
3264 2025-09-21 10203.33
3265 2025-09-22 10278.33
2025-09-22 17:50:42,862 - IOOppi_data - INFO : save new data to db IOOppi_RS_t: date ... updated_at
3263 2025-09-20 ... 2025-09-22 17:50:42.855656
3264 2025-09-21 ... 2025-09-22 17:50:42.855656
3265 2025-09-22 ... 2025-09-22 17:50:42.855656
[3 rows x 5 columns]
2025-09-22 17:50:42,883 - IOOppi_data - INFO : save diff data to db: IOOppi_RS_t: no diff data
2025-09-22 17:50:42,889 - IOOppi_data - INFO : save data to db IOOppi_RS_g data:
date value
3261 2025-09-18 10106.67
3262 2025-09-19 10203.33
3263 2025-09-20 10203.33
3264 2025-09-21 10203.33
3265 2025-09-22 10278.33
2025-09-22 17:50:42,955 - IOOppi_data - INFO : save new data to db IOOppi_RS_g: date ... updated_at
3267 2025-09-20 ... 2025-09-22 17:50:42.948844
3268 2025-09-21 ... 2025-09-22 17:50:42.948844
3269 2025-09-22 ... 2025-09-22 17:50:42.948844
[3 rows x 5 columns]
2025-09-22 17:50:42,975 - 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-22 17:50:43,604 - IOOppi_data - INFO : save data to db IOOppi_RM_t data:
date value
3384 2025-09-18 2606.67
3385 2025-09-19 2633.33
3386 2025-09-20 2633.33
3387 2025-09-21 2633.33
3388 2025-09-22 2633.33
2025-09-22 17:50:43,672 - IOOppi_data - INFO : save new data to db IOOppi_RM_t: date value ... created_at updated_at
3386 2025-09-20 2633.33 ... 2025-09-22 17:50:43.664891 2025-09-22 17:50:43.665289
3387 2025-09-21 2633.33 ... 2025-09-22 17:50:43.664891 2025-09-22 17:50:43.665289
3388 2025-09-22 2633.33 ... 2025-09-22 17:50:43.664891 2025-09-22 17:50:43.665289
[3 rows x 5 columns]
2025-09-22 17:50:43,693 - IOOppi_data - INFO : save diff data to db: IOOppi_RM_t: no diff data
2025-09-22 17:50:43,699 - IOOppi_data - INFO : save data to db IOOppi_RM_g data:
date value
3384 2025-09-18 2606.67
3385 2025-09-19 2633.33
3386 2025-09-20 2633.33
3387 2025-09-21 2633.33
3388 2025-09-22 2633.33
2025-09-22 17:50:43,768 - IOOppi_data - INFO : save new data to db IOOppi_RM_g: date value ... created_at updated_at
3390 2025-09-20 2633.33 ... 2025-09-22 17:50:43.759796 2025-09-22 17:50:43.760235
3391 2025-09-21 2633.33 ... 2025-09-22 17:50:43.759796 2025-09-22 17:50:43.760235
3392 2025-09-22 2633.33 ... 2025-09-22 17:50:43.759796 2025-09-22 17:50:43.760235
[3 rows x 5 columns]
2025-09-22 17:50:43,790 - 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-22 17:50:44,409 - IOOppi_data - INFO : save data to db IOOppi_SA_t data:
date value
1588 2025-09-18 1262.5
1589 2025-09-19 1262.5
1590 2025-09-20 1262.5
1591 2025-09-21 1262.5
1592 2025-09-22 1262.5
2025-09-22 17:50:44,455 - IOOppi_data - INFO : save new data to db IOOppi_SA_t: date value ... created_at updated_at
1590 2025-09-20 1262.5 ... 2025-09-22 17:50:44.447680 2025-09-22 17:50:44.448176
1591 2025-09-21 1262.5 ... 2025-09-22 17:50:44.447680 2025-09-22 17:50:44.448176
1592 2025-09-22 1262.5 ... 2025-09-22 17:50:44.447680 2025-09-22 17:50:44.448176
[3 rows x 5 columns]
2025-09-22 17:50:44,475 - IOOppi_data - INFO : save diff data to db: IOOppi_SA_t: no diff data
2025-09-22 17:50:44,481 - IOOppi_data - INFO : save data to db IOOppi_SA_g data:
date value
1588 2025-09-18 1262.5
1589 2025-09-19 1262.5
1590 2025-09-20 1262.5
1591 2025-09-21 1262.5
1592 2025-09-22 1262.5
2025-09-22 17:50:44,531 - IOOppi_data - INFO : save new data to db IOOppi_SA_g: date value ... created_at updated_at
1594 2025-09-20 1262.5 ... 2025-09-22 17:50:44.523832 2025-09-22 17:50:44.524213
1595 2025-09-21 1262.5 ... 2025-09-22 17:50:44.523832 2025-09-22 17:50:44.524213
1596 2025-09-22 1262.5 ... 2025-09-22 17:50:44.523832 2025-09-22 17:50:44.524213
[3 rows x 5 columns]
2025-09-22 17:50:44,551 - 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-22 17:50:45,203 - IOOppi_data - INFO : save data to db IOOppi_PF_t data:
date value
1501 2025-09-18 6481.88
1502 2025-09-19 6459.17
1503 2025-09-20 6459.17
1504 2025-09-21 6459.17
1505 2025-09-22 6442.08
2025-09-22 17:50:45,248 - IOOppi_data - INFO : save new data to db IOOppi_PF_t: date value ... created_at updated_at
1503 2025-09-20 6459.17 ... 2025-09-22 17:50:45.240905 2025-09-22 17:50:45.241284
1504 2025-09-21 6459.17 ... 2025-09-22 17:50:45.240905 2025-09-22 17:50:45.241284
1505 2025-09-22 6442.08 ... 2025-09-22 17:50:45.240905 2025-09-22 17:50:45.241284
[3 rows x 5 columns]
2025-09-22 17:50:45,268 - IOOppi_data - INFO : save diff data to db: IOOppi_PF_t: no diff data
2025-09-22 17:50:45,274 - IOOppi_data - INFO : save data to db IOOppi_PF_g data:
date value
1501 2025-09-18 6481.88
1502 2025-09-19 6459.17
1503 2025-09-20 6459.17
1504 2025-09-21 6459.17
1505 2025-09-22 6442.08
2025-09-22 17:50:45,320 - IOOppi_data - INFO : save new data to db IOOppi_PF_g: date value ... created_at updated_at
1507 2025-09-20 6459.17 ... 2025-09-22 17:50:45.312823 2025-09-22 17:50:45.313211
1508 2025-09-21 6459.17 ... 2025-09-22 17:50:45.312823 2025-09-22 17:50:45.313211
1509 2025-09-22 6442.08 ... 2025-09-22 17:50:45.312823 2025-09-22 17:50:45.313211
[3 rows x 5 columns]
2025-09-22 17:50:45,340 - 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-22 17:50:46,191 - IOOppi_data - INFO : save data to db IOOppi_m_t data:
date value
3874 2025-09-18 3012.0
3875 2025-09-19 3012.0
3876 2025-09-20 3012.0
3877 2025-09-21 3012.0
3878 2025-09-22 3038.0
2025-09-22 17:50:46,264 - IOOppi_data - INFO : save new data to db IOOppi_m_t: date value ... created_at updated_at
3876 2025-09-20 3012.0 ... 2025-09-22 17:50:46.256365 2025-09-22 17:50:46.256776
3877 2025-09-21 3012.0 ... 2025-09-22 17:50:46.256365 2025-09-22 17:50:46.256776
3878 2025-09-22 3038.0 ... 2025-09-22 17:50:46.256365 2025-09-22 17:50:46.256776
[3 rows x 5 columns]
2025-09-22 17:50:46,284 - IOOppi_data - INFO : save diff data to db: IOOppi_m_t: no diff data
2025-09-22 17:50:46,290 - IOOppi_data - INFO : save data to db IOOppi_m_g data:
date value
3874 2025-09-18 3012.0
3875 2025-09-19 3012.0
3876 2025-09-20 3012.0
3877 2025-09-21 3012.0
3878 2025-09-22 3038.0
2025-09-22 17:50:46,363 - IOOppi_data - INFO : save new data to db IOOppi_m_g: date value ... created_at updated_at
3879 2025-09-20 3012.0 ... 2025-09-22 17:50:46.356059 2025-09-22 17:50:46.356432
3880 2025-09-21 3012.0 ... 2025-09-22 17:50:46.356059 2025-09-22 17:50:46.356432
3881 2025-09-22 3038.0 ... 2025-09-22 17:50:46.356059 2025-09-22 17:50:46.356432
[3 rows x 5 columns]
2025-09-22 17:50:46,383 - 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-22 17:50:47,055 - IOOppi_data - INFO : save data to db IOOppi_y_t data:
date value
3644 2025-09-18 8358.0
3645 2025-09-19 8408.0
3646 2025-09-20 8408.0
3647 2025-09-21 8408.0
3648 2025-09-22 8450.0
2025-09-22 17:50:47,128 - IOOppi_data - INFO : save new data to db IOOppi_y_t: date value ... created_at updated_at
3646 2025-09-20 8408.0 ... 2025-09-22 17:50:47.120482 2025-09-22 17:50:47.120907
3647 2025-09-21 8408.0 ... 2025-09-22 17:50:47.120482 2025-09-22 17:50:47.120907
3648 2025-09-22 8450.0 ... 2025-09-22 17:50:47.120482 2025-09-22 17:50:47.120907
[3 rows x 5 columns]
2025-09-22 17:50:47,148 - IOOppi_data - INFO : save diff data to db: IOOppi_y_t: no diff data
2025-09-22 17:50:47,154 - IOOppi_data - INFO : save data to db IOOppi_y_g data:
date value
3644 2025-09-18 8358.0
3645 2025-09-19 8408.0
3646 2025-09-20 8408.0
3647 2025-09-21 8408.0
3648 2025-09-22 8450.0
2025-09-22 17:50:47,224 - IOOppi_data - INFO : save new data to db IOOppi_y_g: date value ... created_at updated_at
3649 2025-09-20 8408.0 ... 2025-09-22 17:50:47.216887 2025-09-22 17:50:47.217259
3650 2025-09-21 8408.0 ... 2025-09-22 17:50:47.216887 2025-09-22 17:50:47.217259
3651 2025-09-22 8450.0 ... 2025-09-22 17:50:47.216887 2025-09-22 17:50:47.217259
[3 rows x 5 columns]
2025-09-22 17:50:47,245 - 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-22 17:50:47,848 - IOOppi_data - INFO : save data to db IOOppi_a_t data:
date value
3610 2025-09-18 4300.0
3611 2025-09-19 4300.0
3612 2025-09-20 4300.0
3613 2025-09-21 4300.0
3614 2025-09-22 4300.0
2025-09-22 17:50:47,916 - IOOppi_data - INFO : save new data to db IOOppi_a_t: date value ... created_at updated_at
3612 2025-09-20 4300.0 ... 2025-09-22 17:50:47.909108 2025-09-22 17:50:47.909491
3613 2025-09-21 4300.0 ... 2025-09-22 17:50:47.909108 2025-09-22 17:50:47.909491
3614 2025-09-22 4300.0 ... 2025-09-22 17:50:47.909108 2025-09-22 17:50:47.909491
[3 rows x 5 columns]
2025-09-22 17:50:47,936 - IOOppi_data - INFO : save diff data to db: IOOppi_a_t: no diff data
2025-09-22 17:50:47,942 - IOOppi_data - INFO : save data to db IOOppi_a_g data:
date value
3610 2025-09-18 4300.0
3611 2025-09-19 4300.0
3612 2025-09-20 4300.0
3613 2025-09-21 4300.0
3614 2025-09-22 4300.0
2025-09-22 17:50:48,011 - IOOppi_data - INFO : save new data to db IOOppi_a_g: date value ... created_at updated_at
3615 2025-09-20 4300.0 ... 2025-09-22 17:50:48.004525 2025-09-22 17:50:48.004932
3616 2025-09-21 4300.0 ... 2025-09-22 17:50:48.004525 2025-09-22 17:50:48.004932
3617 2025-09-22 4300.0 ... 2025-09-22 17:50:48.004525 2025-09-22 17:50:48.004932
[3 rows x 5 columns]
2025-09-22 17:50:48,031 - 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-22 17:50:48,689 - IOOppi_data - INFO : save data to db IOOppi_SF_t data:
date value
2987 2025-09-18 5318.57
2988 2025-09-19 5338.57
2989 2025-09-20 5338.57
2990 2025-09-21 5338.57
2991 2025-09-22 5351.43
2025-09-22 17:50:48,750 - IOOppi_data - INFO : save new data to db IOOppi_SF_t: date value ... created_at updated_at
2989 2025-09-20 5338.57 ... 2025-09-22 17:50:48.743419 2025-09-22 17:50:48.743828
2990 2025-09-21 5338.57 ... 2025-09-22 17:50:48.743419 2025-09-22 17:50:48.743828
2991 2025-09-22 5351.43 ... 2025-09-22 17:50:48.743419 2025-09-22 17:50:48.743828
[3 rows x 5 columns]
2025-09-22 17:50:48,770 - IOOppi_data - INFO : save diff data to db: IOOppi_SF_t: no diff data
2025-09-22 17:50:48,777 - IOOppi_data - INFO : save data to db IOOppi_SF_g data:
date value
2987 2025-09-18 5318.57
2988 2025-09-19 5338.57
2989 2025-09-20 5338.57
2990 2025-09-21 5338.57
2991 2025-09-22 5351.43
2025-09-22 17:50:48,840 - IOOppi_data - INFO : save new data to db IOOppi_SF_g: date value ... created_at updated_at
2993 2025-09-20 5338.57 ... 2025-09-22 17:50:48.833103 2025-09-22 17:50:48.833481
2994 2025-09-21 5338.57 ... 2025-09-22 17:50:48.833103 2025-09-22 17:50:48.833481
2995 2025-09-22 5351.43 ... 2025-09-22 17:50:48.833103 2025-09-22 17:50:48.833481
[3 rows x 5 columns]
2025-09-22 17:50:48,860 - 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-22 17:50:49,444 - IOOppi_data - INFO : save data to db IOOppi_jd_t data:
date value
3187 2025-09-18 4000.0
3188 2025-09-19 3960.0
3189 2025-09-20 3960.0
3190 2025-09-21 3960.0
3191 2025-09-22 3900.0
2025-09-22 17:50:49,511 - IOOppi_data - INFO : save new data to db IOOppi_jd_t: date value ... created_at updated_at
3189 2025-09-20 3960.0 ... 2025-09-22 17:50:49.503381 2025-09-22 17:50:49.503839
3190 2025-09-21 3960.0 ... 2025-09-22 17:50:49.503381 2025-09-22 17:50:49.503839
3191 2025-09-22 3900.0 ... 2025-09-22 17:50:49.503381 2025-09-22 17:50:49.503839
[3 rows x 5 columns]
/root/project/IOOppi_data/IOOppi_request.py:308: SettingWithCopyWarning:
A value is trying to be set on a copy of a slice from a DataFrame.
Try using .loc[row_indexer,col_indexer] = value instead
See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy
diff_df.loc[:, 'index_code'] = index_code
/root/project/IOOppi_data/IOOppi_request.py:309: SettingWithCopyWarning:
A value is trying to be set on a copy of a slice from a DataFrame.
Try using .loc[row_indexer,col_indexer] = value instead
See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy
diff_df.loc[:, 'created_at'] = datetime.datetime.now()
/root/project/IOOppi_data/IOOppi_request.py:310: SettingWithCopyWarning:
A value is trying to be set on a copy of a slice from a DataFrame.
Try using .loc[row_indexer,col_indexer] = value instead
See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy
diff_df.loc[:, 'updated_at'] = datetime.datetime.now()
2025-09-22 17:50:49,687 - IOOppi_data - INFO : save diff data to db IOOppi_jd_t: date ... updated_at
39 2014-01-03 ... 2025-09-22 17:50:49.679001
458 2015-09-21 ... 2025-09-22 17:50:49.679001
549 2016-02-03 ... 2025-09-22 17:50:49.679001
693 2016-09-05 ... 2025-09-22 17:50:49.679001
696 2016-09-08 ... 2025-09-22 17:50:49.679001
[5 rows x 6 columns]
2025-09-22 17:50:49,723 - IOOppi_data - INFO : save data to db IOOppi_jd_g data:
date value
3187 2025-09-18 4000.0
3188 2025-09-19 3960.0
3189 2025-09-20 3960.0
3190 2025-09-21 3960.0
3191 2025-09-22 3900.0
2025-09-22 17:50:49,792 - IOOppi_data - INFO : save new data to db IOOppi_jd_g: date value ... created_at updated_at
3192 2025-09-20 3960.0 ... 2025-09-22 17:50:49.784641 2025-09-22 17:50:49.785049
3193 2025-09-21 3960.0 ... 2025-09-22 17:50:49.784641 2025-09-22 17:50:49.785049
3194 2025-09-22 3900.0 ... 2025-09-22 17:50:49.784641 2025-09-22 17:50:49.785049
[3 rows x 5 columns]
/root/project/IOOppi_data/IOOppi_request.py:308: SettingWithCopyWarning:
A value is trying to be set on a copy of a slice from a DataFrame.
Try using .loc[row_indexer,col_indexer] = value instead
See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy
diff_df.loc[:, 'index_code'] = index_code
/root/project/IOOppi_data/IOOppi_request.py:309: SettingWithCopyWarning:
A value is trying to be set on a copy of a slice from a DataFrame.
Try using .loc[row_indexer,col_indexer] = value instead
See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy
diff_df.loc[:, 'created_at'] = datetime.datetime.now()
/root/project/IOOppi_data/IOOppi_request.py:310: SettingWithCopyWarning:
A value is trying to be set on a copy of a slice from a DataFrame.
Try using .loc[row_indexer,col_indexer] = value instead
See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy
diff_df.loc[:, 'updated_at'] = datetime.datetime.now()
2025-09-22 17:50:49,962 - IOOppi_data - INFO : save diff data to db IOOppi_jd_g: date ... updated_at
39 2014-01-03 ... 2025-09-22 17:50:49.954972
458 2015-09-21 ... 2025-09-22 17:50:49.954972
549 2016-02-03 ... 2025-09-22 17:50:49.954972
693 2016-09-05 ... 2025-09-22 17:50:49.954972
696 2016-09-08 ... 2025-09-22 17:50:49.954972
[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-22 17:50:50,739 - IOOppi_data - INFO : save data to db IOOppi_SI_t data:
date value
991 2025-09-18 9600.0
992 2025-09-19 9600.0
993 2025-09-20 9600.0
994 2025-09-21 9600.0
995 2025-09-22 9700.0
2025-09-22 17:50:50,779 - IOOppi_data - INFO : save new data to db IOOppi_SI_t: date value ... created_at updated_at
993 2025-09-20 9600.0 ... 2025-09-22 17:50:50.771552 2025-09-22 17:50:50.772036
994 2025-09-21 9600.0 ... 2025-09-22 17:50:50.771552 2025-09-22 17:50:50.772036
995 2025-09-22 9700.0 ... 2025-09-22 17:50:50.771552 2025-09-22 17:50:50.772036
[3 rows x 5 columns]
2025-09-22 17:50:50,801 - IOOppi_data - INFO : save diff data to db: IOOppi_SI_t: no diff data
2025-09-22 17:50:50,807 - IOOppi_data - INFO : save data to db IOOppi_SI_g data:
date value
991 2025-09-18 9600.0
992 2025-09-19 9600.0
993 2025-09-20 9600.0
994 2025-09-21 9600.0
995 2025-09-22 9700.0
2025-09-22 17:50:50,847 - IOOppi_data - INFO : save new data to db IOOppi_SI_g: date value ... created_at updated_at
993 2025-09-20 9600.0 ... 2025-09-22 17:50:50.839158 2025-09-22 17:50:50.839547
994 2025-09-21 9600.0 ... 2025-09-22 17:50:50.839158 2025-09-22 17:50:50.839547
995 2025-09-22 9700.0 ... 2025-09-22 17:50:50.839158 2025-09-22 17:50:50.839547
[3 rows x 5 columns]
2025-09-22 17:50:50,867 - 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-22 17:50:51,768 - IOOppi_data - INFO : save data to db IOOppi_l_t data:
date value
3870 2025-09-18 7395.00
3871 2025-09-19 7386.67
3872 2025-09-20 7386.67
3873 2025-09-21 7386.67
3874 2025-09-22 7355.00
2025-09-22 17:50:51,843 - IOOppi_data - INFO : save new data to db IOOppi_l_t: date value ... created_at updated_at
3872 2025-09-20 7386.67 ... 2025-09-22 17:50:51.835733 2025-09-22 17:50:51.836154
3873 2025-09-21 7386.67 ... 2025-09-22 17:50:51.835733 2025-09-22 17:50:51.836154
3874 2025-09-22 7355.00 ... 2025-09-22 17:50:51.835733 2025-09-22 17:50:51.836154
[3 rows x 5 columns]
2025-09-22 17:50:51,863 - IOOppi_data - INFO : save diff data to db: IOOppi_l_t: no diff data
2025-09-22 17:50:51,869 - IOOppi_data - INFO : save data to db IOOppi_l_g data:
date value
3870 2025-09-18 7395.00
3871 2025-09-19 7386.67
3872 2025-09-20 7386.67
3873 2025-09-21 7386.67
3874 2025-09-22 7355.00
2025-09-22 17:50:51,946 - IOOppi_data - INFO : save new data to db IOOppi_l_g: date value ... created_at updated_at
3875 2025-09-20 7386.67 ... 2025-09-22 17:50:51.938485 2025-09-22 17:50:51.938918
3876 2025-09-21 7386.67 ... 2025-09-22 17:50:51.938485 2025-09-22 17:50:51.938918
3877 2025-09-22 7355.00 ... 2025-09-22 17:50:51.938485 2025-09-22 17:50:51.938918
[3 rows x 5 columns]
2025-09-22 17:50:51,966 - 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-22 17:50:52,634 - IOOppi_data - INFO : save data to db IOOppi_bu_t data:
date value
3208 2025-09-18 3630.00
3209 2025-09-19 3630.00
3210 2025-09-20 3630.00
3211 2025-09-21 3630.00
3212 2025-09-22 3616.67
2025-09-22 17:50:52,699 - IOOppi_data - INFO : save new data to db IOOppi_bu_t: date value ... created_at updated_at
3211 2025-09-20 3630.00 ... 2025-09-22 17:50:52.692429 2025-09-22 17:50:52.692847
3212 2025-09-21 3630.00 ... 2025-09-22 17:50:52.692429 2025-09-22 17:50:52.692847
3213 2025-09-22 3616.67 ... 2025-09-22 17:50:52.692429 2025-09-22 17:50:52.692847
[3 rows x 5 columns]
/root/project/IOOppi_data/IOOppi_request.py:308: SettingWithCopyWarning:
A value is trying to be set on a copy of a slice from a DataFrame.
Try using .loc[row_indexer,col_indexer] = value instead
See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy
diff_df.loc[:, 'index_code'] = index_code
/root/project/IOOppi_data/IOOppi_request.py:309: SettingWithCopyWarning:
A value is trying to be set on a copy of a slice from a DataFrame.
Try using .loc[row_indexer,col_indexer] = value instead
See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy
diff_df.loc[:, 'created_at'] = datetime.datetime.now()
/root/project/IOOppi_data/IOOppi_request.py:310: SettingWithCopyWarning:
A value is trying to be set on a copy of a slice from a DataFrame.
Try using .loc[row_indexer,col_indexer] = value instead
See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy
diff_df.loc[:, 'updated_at'] = datetime.datetime.now()
2025-09-22 17:50:52,737 - IOOppi_data - INFO : save diff data to db IOOppi_bu_t: date ... updated_at
2560 2023-12-09 ... 2025-09-22 17:50:52.730237
[1 rows x 6 columns]
2025-09-22 17:50:52,763 - IOOppi_data - INFO : save data to db IOOppi_bu_g data:
date value
3208 2025-09-18 3630.00
3209 2025-09-19 3630.00
3210 2025-09-20 3630.00
3211 2025-09-21 3630.00
3212 2025-09-22 3616.67
2025-09-22 17:50:52,827 - IOOppi_data - INFO : save new data to db IOOppi_bu_g: date value ... created_at updated_at
3213 2025-09-20 3630.00 ... 2025-09-22 17:50:52.820478 2025-09-22 17:50:52.820883
3214 2025-09-21 3630.00 ... 2025-09-22 17:50:52.820478 2025-09-22 17:50:52.820883
3215 2025-09-22 3616.67 ... 2025-09-22 17:50:52.820478 2025-09-22 17:50:52.820883
[3 rows x 5 columns]
2025-09-22 17:50:52,848 - 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-22 17:50:53,532 - IOOppi_data - INFO : save data to db IOOppi_al_t data:
date value
3873 2025-09-18 20906.67
3874 2025-09-19 20820.00
3875 2025-09-20 20826.67
3876 2025-09-21 20826.67
3877 2025-09-22 20826.67
2025-09-22 17:50:53,608 - IOOppi_data - INFO : save new data to db IOOppi_al_t: date ... updated_at
3875 2025-09-20 ... 2025-09-22 17:50:53.601085
3876 2025-09-21 ... 2025-09-22 17:50:53.601085
3877 2025-09-22 ... 2025-09-22 17:50:53.601085
[3 rows x 5 columns]
2025-09-22 17:50:53,628 - IOOppi_data - INFO : save diff data to db: IOOppi_al_t: no diff data
2025-09-22 17:50:53,634 - IOOppi_data - INFO : save data to db IOOppi_al_g data:
date value
3873 2025-09-18 20906.67
3874 2025-09-19 20820.00
3875 2025-09-20 20826.67
3876 2025-09-21 20826.67
3877 2025-09-22 20826.67
2025-09-22 17:50:53,784 - IOOppi_data - INFO : save new data to db IOOppi_al_g: date ... updated_at
3878 2025-09-20 ... 2025-09-22 17:50:53.777269
3879 2025-09-21 ... 2025-09-22 17:50:53.777269
3880 2025-09-22 ... 2025-09-22 17:50:53.777269
[3 rows x 5 columns]
2025-09-22 17:50:53,804 - 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-22 17:50:54,422 - IOOppi_data - INFO : save data to db IOOppi_SM_t data:
date value
2987 2025-09-18 5766.0
2988 2025-09-19 5760.0
2989 2025-09-20 5760.0
2990 2025-09-21 5760.0
2991 2025-09-22 5746.0
2025-09-22 17:50:54,487 - IOOppi_data - INFO : save new data to db IOOppi_SM_t: date value ... created_at updated_at
2989 2025-09-20 5760.0 ... 2025-09-22 17:50:54.476932 2025-09-22 17:50:54.477312
2990 2025-09-21 5760.0 ... 2025-09-22 17:50:54.476932 2025-09-22 17:50:54.477312
2991 2025-09-22 5746.0 ... 2025-09-22 17:50:54.476932 2025-09-22 17:50:54.477312
[3 rows x 5 columns]
2025-09-22 17:50:54,508 - IOOppi_data - INFO : save diff data to db: IOOppi_SM_t: no diff data
2025-09-22 17:50:54,514 - IOOppi_data - INFO : save data to db IOOppi_SM_g data:
date value
2987 2025-09-18 5766.0
2988 2025-09-19 5760.0
2989 2025-09-20 5760.0
2990 2025-09-21 5760.0
2991 2025-09-22 5746.0
2025-09-22 17:50:54,574 - IOOppi_data - INFO : save new data to db IOOppi_SM_g: date value ... created_at updated_at
2993 2025-09-20 5760.0 ... 2025-09-22 17:50:54.567625 2025-09-22 17:50:54.568002
2994 2025-09-21 5760.0 ... 2025-09-22 17:50:54.567625 2025-09-22 17:50:54.568002
2995 2025-09-22 5746.0 ... 2025-09-22 17:50:54.567625 2025-09-22 17:50:54.568002
[3 rows x 5 columns]
2025-09-22 17:50:54,595 - 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-22 17:50:55,238 - IOOppi_data - INFO : save data to db IOOppi_CY_t data:
date value
2262 2025-09-18 23550.0
2263 2025-09-19 23550.0
2264 2025-09-20 23550.0
2265 2025-09-21 23550.0
2266 2025-09-22 23550.0
2025-09-22 17:50:55,295 - IOOppi_data - INFO : save new data to db IOOppi_CY_t: date value ... created_at updated_at
2264 2025-09-20 23550.0 ... 2025-09-22 17:50:55.287764 2025-09-22 17:50:55.288189
2265 2025-09-21 23550.0 ... 2025-09-22 17:50:55.287764 2025-09-22 17:50:55.288189
2266 2025-09-22 23550.0 ... 2025-09-22 17:50:55.287764 2025-09-22 17:50:55.288189
[3 rows x 5 columns]
2025-09-22 17:50:55,316 - IOOppi_data - INFO : save diff data to db: IOOppi_CY_t: no diff data
2025-09-22 17:50:55,321 - IOOppi_data - INFO : save data to db IOOppi_CY_g data:
date value
2262 2025-09-18 23550.0
2263 2025-09-19 23550.0
2264 2025-09-20 23550.0
2265 2025-09-21 23550.0
2266 2025-09-22 23550.0
2025-09-22 17:50:55,377 - IOOppi_data - INFO : save new data to db IOOppi_CY_g: date value ... created_at updated_at
2268 2025-09-20 23550.0 ... 2025-09-22 17:50:55.369793 2025-09-22 17:50:55.370211
2269 2025-09-21 23550.0 ... 2025-09-22 17:50:55.369793 2025-09-22 17:50:55.370211
2270 2025-09-22 23550.0 ... 2025-09-22 17:50:55.369793 2025-09-22 17:50:55.370211
[3 rows x 5 columns]
2025-09-22 17:50:55,399 - 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-22 17:50:56,031 - IOOppi_data - INFO : save data to db IOOppi_UR_t data:
date value
1777 2025-09-18 1672.5
1778 2025-09-19 1670.0
1779 2025-09-20 1670.0
1780 2025-09-21 1670.0
1781 2025-09-22 1655.0
2025-09-22 17:50:56,088 - IOOppi_data - INFO : save new data to db IOOppi_UR_t: date value ... created_at updated_at
1779 2025-09-20 1670.0 ... 2025-09-22 17:50:56.079778 2025-09-22 17:50:56.080239
1780 2025-09-21 1670.0 ... 2025-09-22 17:50:56.079778 2025-09-22 17:50:56.080239
1781 2025-09-22 1655.0 ... 2025-09-22 17:50:56.079778 2025-09-22 17:50:56.080239
[3 rows x 5 columns]
2025-09-22 17:50:56,110 - IOOppi_data - INFO : save diff data to db: IOOppi_UR_t: no diff data
2025-09-22 17:50:56,117 - IOOppi_data - INFO : save data to db IOOppi_UR_g data:
date value
1777 2025-09-18 1672.5
1778 2025-09-19 1670.0
1779 2025-09-20 1670.0
1780 2025-09-21 1670.0
1781 2025-09-22 1655.0
2025-09-22 17:50:56,169 - IOOppi_data - INFO : save new data to db IOOppi_UR_g: date value ... created_at updated_at
1783 2025-09-20 1670.0 ... 2025-09-22 17:50:56.161296 2025-09-22 17:50:56.161707
1784 2025-09-21 1670.0 ... 2025-09-22 17:50:56.161296 2025-09-22 17:50:56.161707
1785 2025-09-22 1655.0 ... 2025-09-22 17:50:56.161296 2025-09-22 17:50:56.161707
[3 rows x 5 columns]
2025-09-22 17:50:56,189 - 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-22 17:50:56,947 - IOOppi_data - INFO : save data to db IOOppi_ni_t data:
date value
2849 2025-09-18 123016.67
2850 2025-09-19 122950.00
2851 2025-09-20 122950.00
2852 2025-09-21 122950.00
2853 2025-09-22 122750.00
2025-09-22 17:50:57,008 - IOOppi_data - INFO : save new data to db IOOppi_ni_t: date ... updated_at
2851 2025-09-20 ... 2025-09-22 17:50:57.002206
2852 2025-09-21 ... 2025-09-22 17:50:57.002206
2853 2025-09-22 ... 2025-09-22 17:50:57.002206
[3 rows x 5 columns]
2025-09-22 17:50:57,028 - IOOppi_data - INFO : save diff data to db: IOOppi_ni_t: no diff data
2025-09-22 17:50:57,034 - IOOppi_data - INFO : save data to db IOOppi_ni_g data:
date value
2849 2025-09-18 123016.67
2850 2025-09-19 122950.00
2851 2025-09-20 122950.00
2852 2025-09-21 122950.00
2853 2025-09-22 122750.00
2025-09-22 17:50:57,095 - IOOppi_data - INFO : save new data to db IOOppi_ni_g: date ... updated_at
2854 2025-09-20 ... 2025-09-22 17:50:57.088804
2855 2025-09-21 ... 2025-09-22 17:50:57.088804
2856 2025-09-22 ... 2025-09-22 17:50:57.088804
[3 rows x 5 columns]
2025-09-22 17:50:57,116 - 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-22 17:50:57,830 - IOOppi_data - INFO : save data to db IOOppi_v_t data:
date value
3874 2025-09-18 4679.0
3875 2025-09-19 4680.0
3876 2025-09-20 4680.0
3877 2025-09-21 4680.0
3878 2025-09-22 4652.0
2025-09-22 17:50:57,904 - IOOppi_data - INFO : save new data to db IOOppi_v_t: date value ... created_at updated_at
3876 2025-09-20 4680.0 ... 2025-09-22 17:50:57.896835 2025-09-22 17:50:57.897250
3877 2025-09-21 4680.0 ... 2025-09-22 17:50:57.896835 2025-09-22 17:50:57.897250
3878 2025-09-22 4652.0 ... 2025-09-22 17:50:57.896835 2025-09-22 17:50:57.897250
[3 rows x 5 columns]
2025-09-22 17:50:57,925 - IOOppi_data - INFO : save diff data to db: IOOppi_v_t: no diff data
2025-09-22 17:50:57,931 - IOOppi_data - INFO : save data to db IOOppi_v_g data:
date value
3874 2025-09-18 4679.0
3875 2025-09-19 4680.0
3876 2025-09-20 4680.0
3877 2025-09-21 4680.0
3878 2025-09-22 4652.0
2025-09-22 17:50:58,007 - IOOppi_data - INFO : save new data to db IOOppi_v_g: date value ... created_at updated_at
3879 2025-09-20 4680.0 ... 2025-09-22 17:50:57.999961 2025-09-22 17:50:58.000381
3880 2025-09-21 4680.0 ... 2025-09-22 17:50:57.999961 2025-09-22 17:50:58.000381
3881 2025-09-22 4652.0 ... 2025-09-22 17:50:57.999961 2025-09-22 17:50:58.000381
[3 rows x 5 columns]
2025-09-22 17:50:58,028 - 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-22 17:50:58,638 - IOOppi_data - INFO : save data to db IOOppi_pp_t data:
date value
3113 2025-09-18 7071.67
3114 2025-09-19 7020.00
3115 2025-09-20 7020.00
3116 2025-09-21 7020.00
3117 2025-09-22 7020.00
2025-09-22 17:50:58,704 - IOOppi_data - INFO : save new data to db IOOppi_pp_t: date value ... created_at updated_at
3115 2025-09-20 7020.0 ... 2025-09-22 17:50:58.696358 2025-09-22 17:50:58.696804
3116 2025-09-21 7020.0 ... 2025-09-22 17:50:58.696358 2025-09-22 17:50:58.696804
3117 2025-09-22 7020.0 ... 2025-09-22 17:50:58.696358 2025-09-22 17:50:58.696804
[3 rows x 5 columns]
2025-09-22 17:50:58,725 - IOOppi_data - INFO : save diff data to db: IOOppi_pp_t: no diff data
2025-09-22 17:50:58,731 - IOOppi_data - INFO : save data to db IOOppi_pp_g data:
date value
3113 2025-09-18 7071.67
3114 2025-09-19 7020.00
3115 2025-09-20 7020.00
3116 2025-09-21 7020.00
3117 2025-09-22 7020.00
2025-09-22 17:50:58,797 - IOOppi_data - INFO : save new data to db IOOppi_pp_g: date value ... created_at updated_at
3118 2025-09-20 7020.0 ... 2025-09-22 17:50:58.789501 2025-09-22 17:50:58.789928
3119 2025-09-21 7020.0 ... 2025-09-22 17:50:58.789501 2025-09-22 17:50:58.789928
3120 2025-09-22 7020.0 ... 2025-09-22 17:50:58.789501 2025-09-22 17:50:58.789928
[3 rows x 5 columns]
2025-09-22 17:50:58,817 - 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-22 17:50:59,481 - IOOppi_data - INFO : save data to db IOOppi_CF_t data:
date value
3875 2025-09-18 15329.50
3876 2025-09-19 15292.67
3877 2025-09-20 15292.67
3878 2025-09-21 15292.67
3879 2025-09-22 15242.17
2025-09-22 17:50:59,555 - IOOppi_data - INFO : save new data to db IOOppi_CF_t: date ... updated_at
3877 2025-09-20 ... 2025-09-22 17:50:59.548512
3878 2025-09-21 ... 2025-09-22 17:50:59.548512
3879 2025-09-22 ... 2025-09-22 17:50:59.548512
[3 rows x 5 columns]
2025-09-22 17:50:59,581 - IOOppi_data - INFO : save diff data to db: IOOppi_CF_t: no diff data
2025-09-22 17:50:59,587 - IOOppi_data - INFO : save data to db IOOppi_CF_g data:
date value
3875 2025-09-18 15329.50
3876 2025-09-19 15292.67
3877 2025-09-20 15292.67
3878 2025-09-21 15292.67
3879 2025-09-22 15242.17
2025-09-22 17:50:59,664 - IOOppi_data - INFO : save new data to db IOOppi_CF_g: date ... updated_at
3881 2025-09-20 ... 2025-09-22 17:50:59.656785
3882 2025-09-21 ... 2025-09-22 17:50:59.656785
3883 2025-09-22 ... 2025-09-22 17:50:59.656785
[3 rows x 5 columns]
2025-09-22 17:50:59,685 - 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-22 17:51:00,325 - IOOppi_data - INFO : save data to db IOOppi_pb_t data:
date value
3820 2025-09-18 17062.50
3821 2025-09-19 17087.50
3822 2025-09-20 17087.50
3823 2025-09-21 17087.50
3824 2025-09-22 17081.25
2025-09-22 17:51:00,400 - IOOppi_data - INFO : save new data to db IOOppi_pb_t: date ... updated_at
3822 2025-09-20 ... 2025-09-22 17:51:00.393798
3823 2025-09-21 ... 2025-09-22 17:51:00.393798
3824 2025-09-22 ... 2025-09-22 17:51:00.393798
[3 rows x 5 columns]
2025-09-22 17:51:00,421 - IOOppi_data - INFO : save diff data to db: IOOppi_pb_t: no diff data
2025-09-22 17:51:00,428 - IOOppi_data - INFO : save data to db IOOppi_pb_g data:
date value
3820 2025-09-18 17062.50
3821 2025-09-19 17087.50
3822 2025-09-20 17087.50
3823 2025-09-21 17087.50
3824 2025-09-22 17081.25
2025-09-22 17:51:00,501 - IOOppi_data - INFO : save new data to db IOOppi_pb_g: date ... updated_at
3825 2025-09-20 ... 2025-09-22 17:51:00.494694
3826 2025-09-21 ... 2025-09-22 17:51:00.494694
3827 2025-09-22 ... 2025-09-22 17:51:00.494694
[3 rows x 5 columns]
2025-09-22 17:51:00,521 - 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-22 17:51:01,204 - IOOppi_data - INFO : save data to db IOOppi_hc_t data:
date value
3095 2025-09-18 3450.00
3096 2025-09-19 3446.67
3097 2025-09-20 3446.67
3098 2025-09-21 3446.67
3099 2025-09-22 3460.00
2025-09-22 17:51:01,270 - IOOppi_data - INFO : save new data to db IOOppi_hc_t: date value ... created_at updated_at
3097 2025-09-20 3446.67 ... 2025-09-22 17:51:01.263197 2025-09-22 17:51:01.263608
3098 2025-09-21 3446.67 ... 2025-09-22 17:51:01.263197 2025-09-22 17:51:01.263608
3099 2025-09-22 3460.00 ... 2025-09-22 17:51:01.263197 2025-09-22 17:51:01.263608
[3 rows x 5 columns]
2025-09-22 17:51:01,293 - IOOppi_data - INFO : save diff data to db: IOOppi_hc_t: no diff data
2025-09-22 17:51:01,299 - IOOppi_data - INFO : save data to db IOOppi_hc_g data:
date value
3095 2025-09-18 3450.00
3096 2025-09-19 3446.67
3097 2025-09-20 3446.67
3098 2025-09-21 3446.67
3099 2025-09-22 3460.00
2025-09-22 17:51:01,367 - IOOppi_data - INFO : save new data to db IOOppi_hc_g: date value ... created_at updated_at
3100 2025-09-20 3446.67 ... 2025-09-22 17:51:01.359828 2025-09-22 17:51:01.360241
3101 2025-09-21 3446.67 ... 2025-09-22 17:51:01.359828 2025-09-22 17:51:01.360241
3102 2025-09-22 3460.00 ... 2025-09-22 17:51:01.359828 2025-09-22 17:51:01.360241
[3 rows x 5 columns]
2025-09-22 17:51:01,388 - 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-22 17:51:02,280 - IOOppi_data - INFO : save data to db IOOppi_fu_t data:
date value
3375 2025-09-18 5450.0
3376 2025-09-19 5450.0
3377 2025-09-20 5450.0
3378 2025-09-21 5450.0
3379 2025-09-22 5437.5
2025-09-22 17:51:02,347 - IOOppi_data - INFO : save new data to db IOOppi_fu_t: date value ... created_at updated_at
3377 2025-09-20 5450.0 ... 2025-09-22 17:51:02.340420 2025-09-22 17:51:02.340833
3378 2025-09-21 5450.0 ... 2025-09-22 17:51:02.340420 2025-09-22 17:51:02.340833
3379 2025-09-22 5437.5 ... 2025-09-22 17:51:02.340420 2025-09-22 17:51:02.340833
[3 rows x 5 columns]
2025-09-22 17:51:02,369 - IOOppi_data - INFO : save diff data to db: IOOppi_fu_t: no diff data
2025-09-22 17:51:02,375 - IOOppi_data - INFO : save data to db IOOppi_fu_g data:
date value
3375 2025-09-18 5450.0
3376 2025-09-19 5450.0
3377 2025-09-20 5450.0
3378 2025-09-21 5450.0
3379 2025-09-22 5437.5
2025-09-22 17:51:02,448 - IOOppi_data - INFO : save new data to db IOOppi_fu_g: date value ... created_at updated_at
3864 2025-09-20 5450.0 ... 2025-09-22 17:51:02.441012 2025-09-22 17:51:02.441387
3865 2025-09-21 5450.0 ... 2025-09-22 17:51:02.441012 2025-09-22 17:51:02.441387
3866 2025-09-22 5437.5 ... 2025-09-22 17:51:02.441012 2025-09-22 17:51:02.441387
[3 rows x 5 columns]
2025-09-22 17:51:02,468 - 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-22 17:51:03,077 - IOOppi_data - INFO : save data to db IOOppi_lh_t data:
date value
1439 2025-09-18 13300.0
1440 2025-09-19 13230.0
1441 2025-09-20 13230.0
1442 2025-09-21 13230.0
1443 2025-09-22 13130.0
2025-09-22 17:51:03,120 - IOOppi_data - INFO : save new data to db IOOppi_lh_t: date value ... created_at updated_at
1441 2025-09-20 13230.0 ... 2025-09-22 17:51:03.113456 2025-09-22 17:51:03.113926
1442 2025-09-21 13230.0 ... 2025-09-22 17:51:03.113456 2025-09-22 17:51:03.113926
1443 2025-09-22 13130.0 ... 2025-09-22 17:51:03.113456 2025-09-22 17:51:03.113926
[3 rows x 5 columns]
/root/project/IOOppi_data/IOOppi_request.py:308: SettingWithCopyWarning:
A value is trying to be set on a copy of a slice from a DataFrame.
Try using .loc[row_indexer,col_indexer] = value instead
See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy
diff_df.loc[:, 'index_code'] = index_code
/root/project/IOOppi_data/IOOppi_request.py:309: SettingWithCopyWarning:
A value is trying to be set on a copy of a slice from a DataFrame.
Try using .loc[row_indexer,col_indexer] = value instead
See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy
diff_df.loc[:, 'created_at'] = datetime.datetime.now()
/root/project/IOOppi_data/IOOppi_request.py:310: SettingWithCopyWarning:
A value is trying to be set on a copy of a slice from a DataFrame.
Try using .loc[row_indexer,col_indexer] = value instead
See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy
diff_df.loc[:, 'updated_at'] = datetime.datetime.now()
2025-09-22 17:51:03,381 - IOOppi_data - INFO : save diff data to db IOOppi_lh_t: date ... updated_at
116 2021-07-05 ... 2025-09-22 17:51:03.373587
117 2021-07-06 ... 2025-09-22 17:51:03.373587
121 2021-07-12 ... 2025-09-22 17:51:03.373587
122 2021-07-13 ... 2025-09-22 17:51:03.373587
194 2021-11-01 ... 2025-09-22 17:51:03.373587
[5 rows x 6 columns]
2025-09-22 17:51:03,425 - IOOppi_data - INFO : save data to db IOOppi_lh_g data:
date value
1439 2025-09-18 13300.0
1440 2025-09-19 13230.0
1441 2025-09-20 13230.0
1442 2025-09-21 13230.0
1443 2025-09-22 13130.0
2025-09-22 17:51:03,471 - IOOppi_data - INFO : save new data to db IOOppi_lh_g: date value ... created_at updated_at
1444 2025-09-20 13230.0 ... 2025-09-22 17:51:03.463004 2025-09-22 17:51:03.463393
1445 2025-09-21 13230.0 ... 2025-09-22 17:51:03.463004 2025-09-22 17:51:03.463393
1446 2025-09-22 13130.0 ... 2025-09-22 17:51:03.463004 2025-09-22 17:51:03.463393
[3 rows x 5 columns]
/root/project/IOOppi_data/IOOppi_request.py:308: SettingWithCopyWarning:
A value is trying to be set on a copy of a slice from a DataFrame.
Try using .loc[row_indexer,col_indexer] = value instead
See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy
diff_df.loc[:, 'index_code'] = index_code
/root/project/IOOppi_data/IOOppi_request.py:309: SettingWithCopyWarning:
A value is trying to be set on a copy of a slice from a DataFrame.
Try using .loc[row_indexer,col_indexer] = value instead
See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy
diff_df.loc[:, 'created_at'] = datetime.datetime.now()
/root/project/IOOppi_data/IOOppi_request.py:310: SettingWithCopyWarning:
A value is trying to be set on a copy of a slice from a DataFrame.
Try using .loc[row_indexer,col_indexer] = value instead
See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy
diff_df.loc[:, 'updated_at'] = datetime.datetime.now()
2025-09-22 17:51:03,740 - IOOppi_data - INFO : save diff data to db IOOppi_lh_g: date ... updated_at
116 2021-07-05 ... 2025-09-22 17:51:03.732243
117 2021-07-06 ... 2025-09-22 17:51:03.732243
121 2021-07-12 ... 2025-09-22 17:51:03.732243
122 2021-07-13 ... 2025-09-22 17:51:03.732243
194 2021-11-01 ... 2025-09-22 17:51:03.732243
[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-22 17:51:04,462 - IOOppi_data - INFO : save data to db IOOppi_cu_t data:
date value
3871 2025-09-18 80043.33
3872 2025-09-19 80016.67
3873 2025-09-20 80016.67
3874 2025-09-21 80016.67
3875 2025-09-22 80233.33
2025-09-22 17:51:04,534 - IOOppi_data - INFO : save new data to db IOOppi_cu_t: date ... updated_at
3873 2025-09-20 ... 2025-09-22 17:51:04.528486
3874 2025-09-21 ... 2025-09-22 17:51:04.528486
3875 2025-09-22 ... 2025-09-22 17:51:04.528486
[3 rows x 5 columns]
2025-09-22 17:51:04,555 - IOOppi_data - INFO : save diff data to db: IOOppi_cu_t: no diff data
2025-09-22 17:51:04,561 - IOOppi_data - INFO : save data to db IOOppi_cu_g data:
date value
3871 2025-09-18 80043.33
3872 2025-09-19 80016.67
3873 2025-09-20 80016.67
3874 2025-09-21 80016.67
3875 2025-09-22 80233.33
2025-09-22 17:51:04,633 - IOOppi_data - INFO : save new data to db IOOppi_cu_g: date ... updated_at
3876 2025-09-20 ... 2025-09-22 17:51:04.627520
3877 2025-09-21 ... 2025-09-22 17:51:04.627520
3878 2025-09-22 ... 2025-09-22 17:51:04.627520
[3 rows x 5 columns]
2025-09-22 17:51:04,654 - 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-22 17:51:05,189 - 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-22 17:51:05,243 - IOOppi_data - INFO : save new data to db: IOOppi_PM_t: no new data
2025-09-22 17:51:05,243 - IOOppi_data - INFO : save diff data to db: IOOppi_PM_t: no diff data
2025-09-22 17:51:05,248 - 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-22 17:51:05,311 - IOOppi_data - INFO : save new data to db: IOOppi_PM_g: no new data
2025-09-22 17:51:05,311 - 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-22 17:51:05,994 - IOOppi_data - INFO : save data to db IOOppi_sn_t data:
date value
2849 2025-09-18 270362.5
2850 2025-09-19 269350.0
2851 2025-09-20 269350.0
2852 2025-09-21 269350.0
2853 2025-09-22 272325.0
2025-09-22 17:51:06,053 - IOOppi_data - INFO : save new data to db IOOppi_sn_t: date ... updated_at
2851 2025-09-20 ... 2025-09-22 17:51:06.047215
2852 2025-09-21 ... 2025-09-22 17:51:06.047215
2853 2025-09-22 ... 2025-09-22 17:51:06.047215
[3 rows x 5 columns]
2025-09-22 17:51:06,073 - IOOppi_data - INFO : save diff data to db: IOOppi_sn_t: no diff data
2025-09-22 17:51:06,079 - IOOppi_data - INFO : save data to db IOOppi_sn_g data:
date value
2849 2025-09-18 270362.5
2850 2025-09-19 269350.0
2851 2025-09-20 269350.0
2852 2025-09-21 269350.0
2853 2025-09-22 272325.0
2025-09-22 17:51:06,142 - IOOppi_data - INFO : save new data to db IOOppi_sn_g: date ... updated_at
2854 2025-09-20 ... 2025-09-22 17:51:06.135582
2855 2025-09-21 ... 2025-09-22 17:51:06.135582
2856 2025-09-22 ... 2025-09-22 17:51:06.135582
[3 rows x 5 columns]
2025-09-22 17:51:06,162 - 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-22 17:51:06,844 - IOOppi_data - INFO : save data to db IOOppi_zn_t data:
date value
3870 2025-09-18 22006.0
3871 2025-09-19 21988.0
3872 2025-09-20 21988.0
3873 2025-09-21 21988.0
3874 2025-09-22 21942.0
2025-09-22 17:51:06,916 - IOOppi_data - INFO : save new data to db IOOppi_zn_t: date value ... created_at updated_at
3872 2025-09-20 21988.0 ... 2025-09-22 17:51:06.909363 2025-09-22 17:51:06.909789
3873 2025-09-21 21988.0 ... 2025-09-22 17:51:06.909363 2025-09-22 17:51:06.909789
3874 2025-09-22 21942.0 ... 2025-09-22 17:51:06.909363 2025-09-22 17:51:06.909789
[3 rows x 5 columns]
2025-09-22 17:51:06,936 - IOOppi_data - INFO : save diff data to db: IOOppi_zn_t: no diff data
2025-09-22 17:51:06,942 - IOOppi_data - INFO : save data to db IOOppi_zn_g data:
date value
3870 2025-09-18 22006.0
3871 2025-09-19 21988.0
3872 2025-09-20 21988.0
3873 2025-09-21 21988.0
3874 2025-09-22 21942.0
2025-09-22 17:51:07,015 - IOOppi_data - INFO : save new data to db IOOppi_zn_g: date value ... created_at updated_at
3875 2025-09-20 21988.0 ... 2025-09-22 17:51:07.007744 2025-09-22 17:51:07.008125
3876 2025-09-21 21988.0 ... 2025-09-22 17:51:07.007744 2025-09-22 17:51:07.008125
3877 2025-09-22 21942.0 ... 2025-09-22 17:51:07.007744 2025-09-22 17:51:07.008125
[3 rows x 5 columns]
2025-09-22 17:51:07,034 - 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-22 17:51:07,821 - IOOppi_data - INFO : save data to db IOOppi_wr_t data:
date value
3833 2025-09-18 3342.5
3834 2025-09-19 3342.5
3835 2025-09-20 3350.0
3836 2025-09-21 3350.0
3837 2025-09-22 3410.0
2025-09-22 17:51:07,893 - IOOppi_data - INFO : save new data to db IOOppi_wr_t: date value ... created_at updated_at
3835 2025-09-20 3350.0 ... 2025-09-22 17:51:07.885529 2025-09-22 17:51:07.885956
3836 2025-09-21 3350.0 ... 2025-09-22 17:51:07.885529 2025-09-22 17:51:07.885956
3837 2025-09-22 3410.0 ... 2025-09-22 17:51:07.885529 2025-09-22 17:51:07.885956
[3 rows x 5 columns]
2025-09-22 17:51:07,913 - IOOppi_data - INFO : save diff data to db: IOOppi_wr_t: no diff data
2025-09-22 17:51:07,919 - IOOppi_data - INFO : save data to db IOOppi_wr_g data:
date value
3833 2025-09-18 3342.5
3834 2025-09-19 3342.5
3835 2025-09-20 3350.0
3836 2025-09-21 3350.0
3837 2025-09-22 3410.0
2025-09-22 17:51:07,990 - IOOppi_data - INFO : save new data to db IOOppi_wr_g: date value ... created_at updated_at
3838 2025-09-20 3350.0 ... 2025-09-22 17:51:07.983729 2025-09-22 17:51:07.984106
3839 2025-09-21 3350.0 ... 2025-09-22 17:51:07.983729 2025-09-22 17:51:07.984106
3840 2025-09-22 3410.0 ... 2025-09-22 17:51:07.983729 2025-09-22 17:51:07.984106
[3 rows x 5 columns]
2025-09-22 17:51:08,011 - 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-22 17:51:08,644 - IOOppi_data - INFO : save data to db IOOppi_pg_t data:
date value
1630 2025-09-18 4630.0
1631 2025-09-19 4602.5
1632 2025-09-20 4602.5
1633 2025-09-21 4602.5
1634 2025-09-22 4597.5
2025-09-22 17:51:08,690 - IOOppi_data - INFO : save new data to db IOOppi_pg_t: date value ... created_at updated_at
1632 2025-09-20 4602.5 ... 2025-09-22 17:51:08.683196 2025-09-22 17:51:08.683602
1633 2025-09-21 4602.5 ... 2025-09-22 17:51:08.683196 2025-09-22 17:51:08.683602
1634 2025-09-22 4597.5 ... 2025-09-22 17:51:08.683196 2025-09-22 17:51:08.683602
[3 rows x 5 columns]
2025-09-22 17:51:08,712 - IOOppi_data - INFO : save diff data to db: IOOppi_pg_t: no diff data
2025-09-22 17:51:08,717 - IOOppi_data - INFO : save data to db IOOppi_pg_g data:
date value
1630 2025-09-18 4630.0
1631 2025-09-19 4602.5
1632 2025-09-20 4602.5
1633 2025-09-21 4602.5
1634 2025-09-22 4597.5
2025-09-22 17:51:08,764 - IOOppi_data - INFO : save new data to db IOOppi_pg_g: date value ... created_at updated_at
1635 2025-09-20 4602.5 ... 2025-09-22 17:51:08.757005 2025-09-22 17:51:08.757407
1636 2025-09-21 4602.5 ... 2025-09-22 17:51:08.757005 2025-09-22 17:51:08.757407
1637 2025-09-22 4597.5 ... 2025-09-22 17:51:08.757005 2025-09-22 17:51:08.757407
[3 rows x 5 columns]
2025-09-22 17:51:08,784 - 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-22 17:51:09,394 - IOOppi_data - INFO : save data to db IOOppi_cs_t data:
date value
2904 2025-09-18 2287.14
2905 2025-09-19 2287.14
2906 2025-09-20 2287.14
2907 2025-09-21 2287.14
2908 2025-09-22 2288.57
2025-09-22 17:51:09,456 - IOOppi_data - INFO : save new data to db IOOppi_cs_t: date value ... created_at updated_at
2906 2025-09-20 2287.14 ... 2025-09-22 17:51:09.449455 2025-09-22 17:51:09.449867
2907 2025-09-21 2287.14 ... 2025-09-22 17:51:09.449455 2025-09-22 17:51:09.449867
2908 2025-09-22 2288.57 ... 2025-09-22 17:51:09.449455 2025-09-22 17:51:09.449867
[3 rows x 5 columns]
/root/project/IOOppi_data/IOOppi_request.py:308: SettingWithCopyWarning:
A value is trying to be set on a copy of a slice from a DataFrame.
Try using .loc[row_indexer,col_indexer] = value instead
See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy
diff_df.loc[:, 'index_code'] = index_code
/root/project/IOOppi_data/IOOppi_request.py:309: SettingWithCopyWarning:
A value is trying to be set on a copy of a slice from a DataFrame.
Try using .loc[row_indexer,col_indexer] = value instead
See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy
diff_df.loc[:, 'created_at'] = datetime.datetime.now()
/root/project/IOOppi_data/IOOppi_request.py:310: SettingWithCopyWarning:
A value is trying to be set on a copy of a slice from a DataFrame.
Try using .loc[row_indexer,col_indexer] = value instead
See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy
diff_df.loc[:, 'updated_at'] = datetime.datetime.now()
2025-09-22 17:51:09,501 - IOOppi_data - INFO : save diff data to db IOOppi_cs_t: date ... updated_at
2905 2025-09-19 ... 2025-09-22 17:51:09.494226
[1 rows x 6 columns]
2025-09-22 17:51:09,526 - IOOppi_data - INFO : save data to db IOOppi_cs_g data:
date value
2904 2025-09-18 2287.14
2905 2025-09-19 2287.14
2906 2025-09-20 2287.14
2907 2025-09-21 2287.14
2908 2025-09-22 2288.57
2025-09-22 17:51:09,587 - IOOppi_data - INFO : save new data to db IOOppi_cs_g: date value ... created_at updated_at
2909 2025-09-20 2287.14 ... 2025-09-22 17:51:09.580272 2025-09-22 17:51:09.580668
2910 2025-09-21 2287.14 ... 2025-09-22 17:51:09.580272 2025-09-22 17:51:09.580668
2911 2025-09-22 2288.57 ... 2025-09-22 17:51:09.580272 2025-09-22 17:51:09.580668
[3 rows x 5 columns]
/root/project/IOOppi_data/IOOppi_request.py:308: SettingWithCopyWarning:
A value is trying to be set on a copy of a slice from a DataFrame.
Try using .loc[row_indexer,col_indexer] = value instead
See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy
diff_df.loc[:, 'index_code'] = index_code
/root/project/IOOppi_data/IOOppi_request.py:309: SettingWithCopyWarning:
A value is trying to be set on a copy of a slice from a DataFrame.
Try using .loc[row_indexer,col_indexer] = value instead
See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy
diff_df.loc[:, 'created_at'] = datetime.datetime.now()
/root/project/IOOppi_data/IOOppi_request.py:310: SettingWithCopyWarning:
A value is trying to be set on a copy of a slice from a DataFrame.
Try using .loc[row_indexer,col_indexer] = value instead
See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy
diff_df.loc[:, 'updated_at'] = datetime.datetime.now()
2025-09-22 17:51:09,630 - IOOppi_data - INFO : save diff data to db IOOppi_cs_g: date ... updated_at
2908 2025-09-19 ... 2025-09-22 17:51:09.623245
[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-22 17:51:10,283 - IOOppi_data - INFO : save data to db IOOppi_cs_t data:
date value
2904 2025-09-18 2287.14
2905 2025-09-19 2287.14
2906 2025-09-20 2287.14
2907 2025-09-21 2287.14
2908 2025-09-22 2834.00
2025-09-22 17:51:10,335 - 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-22 17:51:10,362 - IOOppi_data - INFO : save diff data to db IOOppi_cs_t: date ... updated_at
2908 2025-09-22 ... 2025-09-22 17:51:10.355298
[1 rows x 6 columns]
2025-09-22 17:51:10,388 - IOOppi_data - INFO : save data to db IOOppi_cs_g data:
date value
2904 2025-09-18 2287.14
2905 2025-09-19 2287.14
2906 2025-09-20 2287.14
2907 2025-09-21 2287.14
2908 2025-09-22 2834.00
2025-09-22 17:51:10,441 - 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-22 17:51:10,465 - IOOppi_data - INFO : save diff data to db IOOppi_cs_g: date ... updated_at
2911 2025-09-22 ... 2025-09-22 17:51:10.458197
[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-22 17:51:11,055 - IOOppi_data - INFO : save data to db IOOppi_RS_t data:
date value
3261 2025-09-18 10106.67
3262 2025-09-19 10203.33
3263 2025-09-20 10203.33
3264 2025-09-21 10203.33
3265 2025-09-22 10278.33
2025-09-22 17:51:11,113 - IOOppi_data - INFO : save new data to db: IOOppi_RS_t: no new data
2025-09-22 17:51:11,114 - IOOppi_data - INFO : save diff data to db: IOOppi_RS_t: no diff data
2025-09-22 17:51:11,119 - IOOppi_data - INFO : save data to db IOOppi_RS_g data:
date value
3261 2025-09-18 10106.67
3262 2025-09-19 10203.33
3263 2025-09-20 10203.33
3264 2025-09-21 10203.33
3265 2025-09-22 10278.33
2025-09-22 17:51:11,183 - IOOppi_data - INFO : save new data to db: IOOppi_RS_g: no new data
2025-09-22 17:51:11,183 - 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-22 17:51:11,823 - IOOppi_data - INFO : save data to db IOOppi_eg_t data:
date value
1945 2025-09-18 4450.00
1946 2025-09-19 4428.33
1947 2025-09-20 4428.33
1948 2025-09-21 4428.33
1949 2025-09-22 4428.33
2025-09-22 17:51:11,874 - IOOppi_data - INFO : save new data to db IOOppi_eg_t: date value ... created_at updated_at
1947 2025-09-20 4428.33 ... 2025-09-22 17:51:11.866705 2025-09-22 17:51:11.867129
1948 2025-09-21 4428.33 ... 2025-09-22 17:51:11.866705 2025-09-22 17:51:11.867129
1949 2025-09-22 4428.33 ... 2025-09-22 17:51:11.866705 2025-09-22 17:51:11.867129
[3 rows x 5 columns]
2025-09-22 17:51:11,895 - IOOppi_data - INFO : save diff data to db: IOOppi_eg_t: no diff data
2025-09-22 17:51:11,900 - IOOppi_data - INFO : save data to db IOOppi_eg_g data:
date value
1945 2025-09-18 4450.00
1946 2025-09-19 4428.33
1947 2025-09-20 4428.33
1948 2025-09-21 4428.33
1949 2025-09-22 4428.33
2025-09-22 17:51:11,951 - IOOppi_data - INFO : save new data to db IOOppi_eg_g: date value ... created_at updated_at
1950 2025-09-20 4428.33 ... 2025-09-22 17:51:11.944231 2025-09-22 17:51:11.944640
1951 2025-09-21 4428.33 ... 2025-09-22 17:51:11.944231 2025-09-22 17:51:11.944640
1952 2025-09-22 4428.33 ... 2025-09-22 17:51:11.944231 2025-09-22 17:51:11.944640
[3 rows x 5 columns]
2025-09-22 17:51:11,971 - 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-22 17:51:12,759 - IOOppi_data - INFO : save data to db IOOppi_sp_t data:
date value
1954 2025-09-18 5716.67
1955 2025-09-19 5700.00
1956 2025-09-20 5700.00
1957 2025-09-21 5700.00
1958 2025-09-22 5700.00
2025-09-22 17:51:12,809 - IOOppi_data - INFO : save new data to db IOOppi_sp_t: date value ... created_at updated_at
1956 2025-09-20 5700.0 ... 2025-09-22 17:51:12.801705 2025-09-22 17:51:12.802118
1957 2025-09-21 5700.0 ... 2025-09-22 17:51:12.801705 2025-09-22 17:51:12.802118
1958 2025-09-22 5700.0 ... 2025-09-22 17:51:12.801705 2025-09-22 17:51:12.802118
[3 rows x 5 columns]
2025-09-22 17:51:12,829 - IOOppi_data - INFO : save diff data to db: IOOppi_sp_t: no diff data
2025-09-22 17:51:12,835 - IOOppi_data - INFO : save data to db IOOppi_sp_g data:
date value
1954 2025-09-18 5716.67
1955 2025-09-19 5700.00
1956 2025-09-20 5700.00
1957 2025-09-21 5700.00
1958 2025-09-22 5700.00
2025-09-22 17:51:12,885 - IOOppi_data - INFO : save new data to db IOOppi_sp_g: date value ... created_at updated_at
1959 2025-09-20 5700.0 ... 2025-09-22 17:51:12.877734 2025-09-22 17:51:12.878115
1960 2025-09-21 5700.0 ... 2025-09-22 17:51:12.877734 2025-09-22 17:51:12.878115
1961 2025-09-22 5700.0 ... 2025-09-22 17:51:12.877734 2025-09-22 17:51:12.878115
[3 rows x 5 columns]
2025-09-22 17:51:12,905 - 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-22 17:51:13,742 - IOOppi_data - INFO : save data to db IOOppi_p_t data:
date value
3622 2025-09-18 9366.0
3623 2025-09-19 9318.0
3624 2025-09-20 9318.0
3625 2025-09-21 9318.0
3626 2025-09-22 9372.0
2025-09-22 17:51:13,815 - IOOppi_data - INFO : save new data to db IOOppi_p_t: date value ... created_at updated_at
3624 2025-09-20 9318.0 ... 2025-09-22 17:51:13.807555 2025-09-22 17:51:13.808002
3625 2025-09-21 9318.0 ... 2025-09-22 17:51:13.807555 2025-09-22 17:51:13.808002
3626 2025-09-22 9372.0 ... 2025-09-22 17:51:13.807555 2025-09-22 17:51:13.808002
[3 rows x 5 columns]
2025-09-22 17:51:13,841 - IOOppi_data - INFO : save diff data to db: IOOppi_p_t: no diff data
2025-09-22 17:51:13,847 - IOOppi_data - INFO : save data to db IOOppi_p_g data:
date value
3622 2025-09-18 9366.0
3623 2025-09-19 9318.0
3624 2025-09-20 9318.0
3625 2025-09-21 9318.0
3626 2025-09-22 9372.0
2025-09-22 17:51:13,918 - IOOppi_data - INFO : save new data to db IOOppi_p_g: date value ... created_at updated_at
3627 2025-09-20 9318.0 ... 2025-09-22 17:51:13.910523 2025-09-22 17:51:13.910932
3628 2025-09-21 9318.0 ... 2025-09-22 17:51:13.910523 2025-09-22 17:51:13.910932
3629 2025-09-22 9372.0 ... 2025-09-22 17:51:13.910523 2025-09-22 17:51:13.910932
[3 rows x 5 columns]
2025-09-22 17:51:13,938 - IOOppi_data - INFO : save diff data to db: IOOppi_p_g: no diff data