=========================================================================
2025-06-13 17:50:26 Fri START TASK.01 IOOppi_data update_data
=========================================================================
/usr/local/lib/python3.10/site-packages/urllib3/connectionpool.py:1056: InsecureRequestWarning: Unverified HTTPS request is being made to host 'www.100ppi.com'. Adding certificate verification is strongly advised. See: https://urllib3.readthedocs.io/en/1.26.x/advanced-usage.html#ssl-warnings
warnings.warn(
2025-06-13 17:50:28,475 - IOOppi_data - INFO : save data to db IOOppi_rb_t data:
date value
3329 2025-06-09 3069.00
3330 2025-06-10 3090.22
3331 2025-06-11 3098.22
3332 2025-06-12 3095.89
3333 2025-06-13 3055.00
2025-06-13 17:50:28,568 - IOOppi_data - INFO : save new data to db IOOppi_rb_t: date value ... created_at updated_at
3332 2025-06-12 3095.89 ... 2025-06-13 17:50:28.559991 2025-06-13 17:50:28.560427
3333 2025-06-13 3055.00 ... 2025-06-13 17:50:28.559991 2025-06-13 17:50:28.560427
[2 rows x 5 columns]
2025-06-13 17:50:28,589 - IOOppi_data - INFO : save diff data to db: IOOppi_rb_t: no diff data
2025-06-13 17:50:28,595 - IOOppi_data - INFO : save data to db IOOppi_rb_g data:
date value
3329 2025-06-09 3069.00
3330 2025-06-10 3090.22
3331 2025-06-11 3098.22
3332 2025-06-12 3095.89
3333 2025-06-13 3055.00
2025-06-13 17:50:28,678 - IOOppi_data - INFO : save new data to db IOOppi_rb_g: date value ... created_at updated_at
3335 2025-06-12 3095.89 ... 2025-06-13 17:50:28.669603 2025-06-13 17:50:28.670227
3336 2025-06-13 3055.00 ... 2025-06-13 17:50:28.669603 2025-06-13 17:50:28.670227
[2 rows x 5 columns]
2025-06-13 17:50:28,698 - IOOppi_data - INFO : save diff data to db: IOOppi_rb_g: no diff data
/usr/local/lib/python3.10/site-packages/urllib3/connectionpool.py:1056: InsecureRequestWarning: Unverified HTTPS request is being made to host 'www.100ppi.com'. Adding certificate verification is strongly advised. See: https://urllib3.readthedocs.io/en/1.26.x/advanced-usage.html#ssl-warnings
warnings.warn(
2025-06-13 17:50:29,223 - IOOppi_data - INFO : save data to db IOOppi_MA_t data:
date value
3550 2025-06-09 2331.0
3551 2025-06-10 2378.0
3552 2025-06-11 2363.0
3553 2025-06-12 2362.0
3554 2025-06-13 2484.0
2025-06-13 17:50:29,297 - IOOppi_data - INFO : save new data to db IOOppi_MA_t: date value ... created_at updated_at
3553 2025-06-12 2362.0 ... 2025-06-13 17:50:29.290092 2025-06-13 17:50:29.290468
3554 2025-06-13 2484.0 ... 2025-06-13 17:50:29.290092 2025-06-13 17:50:29.290468
[2 rows x 5 columns]
2025-06-13 17:50:29,316 - IOOppi_data - INFO : save diff data to db: IOOppi_MA_t: no diff data
2025-06-13 17:50:29,321 - IOOppi_data - INFO : save data to db IOOppi_MA_g data:
date value
3550 2025-06-09 2331.0
3551 2025-06-10 2378.0
3552 2025-06-11 2363.0
3553 2025-06-12 2362.0
3554 2025-06-13 2484.0
2025-06-13 17:50:29,393 - IOOppi_data - INFO : save new data to db IOOppi_MA_g: date value ... created_at updated_at
3557 2025-06-12 2362.0 ... 2025-06-13 17:50:29.386104 2025-06-13 17:50:29.386495
3558 2025-06-13 2484.0 ... 2025-06-13 17:50:29.386104 2025-06-13 17:50:29.386495
[2 rows x 5 columns]
2025-06-13 17:50:29,411 - IOOppi_data - INFO : save diff data to db: IOOppi_MA_g: no diff data
/usr/local/lib/python3.10/site-packages/urllib3/connectionpool.py:1056: InsecureRequestWarning: Unverified HTTPS request is being made to host 'www.100ppi.com'. Adding certificate verification is strongly advised. See: https://urllib3.readthedocs.io/en/1.26.x/advanced-usage.html#ssl-warnings
warnings.warn(
2025-06-13 17:50:30,091 - IOOppi_data - INFO : save data to db IOOppi_PTA_t data:
date value
890 2025-06-09 4884.50
891 2025-06-10 4880.50
892 2025-06-11 4871.75
893 2025-06-12 4880.75
894 2025-06-13 4932.75
2025-06-13 17:50:30,130 - IOOppi_data - INFO : save new data to db IOOppi_PTA_t: date value ... created_at updated_at
893 2025-06-12 4880.75 ... 2025-06-13 17:50:30.123315 2025-06-13 17:50:30.123696
894 2025-06-13 4932.75 ... 2025-06-13 17:50:30.123315 2025-06-13 17:50:30.123696
[2 rows x 5 columns]
2025-06-13 17:50:30,149 - IOOppi_data - INFO : save diff data to db: IOOppi_PTA_t: no diff data
2025-06-13 17:50:30,154 - IOOppi_data - INFO : save data to db IOOppi_PTA_g data:
date value
890 2025-06-09 4884.50
891 2025-06-10 4880.50
892 2025-06-11 4871.75
893 2025-06-12 4880.75
894 2025-06-13 4932.75
2025-06-13 17:50:30,195 - IOOppi_data - INFO : save new data to db IOOppi_PTA_g: date value ... created_at updated_at
893 2025-06-12 4880.75 ... 2025-06-13 17:50:30.187966 2025-06-13 17:50:30.188352
894 2025-06-13 4932.75 ... 2025-06-13 17:50:30.187966 2025-06-13 17:50:30.188352
[2 rows x 5 columns]
2025-06-13 17:50:30,215 - IOOppi_data - INFO : save diff data to db: IOOppi_PTA_g: no diff data
/usr/local/lib/python3.10/site-packages/urllib3/connectionpool.py:1056: InsecureRequestWarning: Unverified HTTPS request is being made to host 'www.100ppi.com'. Adding certificate verification is strongly advised. See: https://urllib3.readthedocs.io/en/1.26.x/advanced-usage.html#ssl-warnings
warnings.warn(
2025-06-13 17:50:30,772 - IOOppi_data - INFO : save data to db IOOppi_ru_t data:
date value
3769 2025-06-09 13573.33
3770 2025-06-10 13670.83
3771 2025-06-11 13758.33
3772 2025-06-12 13458.33
3773 2025-06-13 13758.33
2025-06-13 17:50:30,851 - IOOppi_data - INFO : save new data to db IOOppi_ru_t: date ... updated_at
3772 2025-06-12 ... 2025-06-13 17:50:30.844875
3773 2025-06-13 ... 2025-06-13 17:50:30.844875
[2 rows x 5 columns]
2025-06-13 17:50:30,869 - IOOppi_data - INFO : save diff data to db: IOOppi_ru_t: no diff data
2025-06-13 17:50:30,875 - IOOppi_data - INFO : save data to db IOOppi_ru_g data:
date value
3769 2025-06-09 13573.33
3770 2025-06-10 13670.83
3771 2025-06-11 13758.33
3772 2025-06-12 13458.33
3773 2025-06-13 13758.33
2025-06-13 17:50:30,952 - IOOppi_data - INFO : save new data to db IOOppi_ru_g: date ... updated_at
3775 2025-06-12 ... 2025-06-13 17:50:30.944231
3776 2025-06-13 ... 2025-06-13 17:50:30.944231
[2 rows x 5 columns]
2025-06-13 17:50:30,971 - IOOppi_data - INFO : save diff data to db: IOOppi_ru_g: no diff data
/usr/local/lib/python3.10/site-packages/urllib3/connectionpool.py:1056: InsecureRequestWarning: Unverified HTTPS request is being made to host 'www.100ppi.com'. Adding certificate verification is strongly advised. See: https://urllib3.readthedocs.io/en/1.26.x/advanced-usage.html#ssl-warnings
warnings.warn(
2025-06-13 17:50:31,514 - IOOppi_data - INFO : save data to db IOOppi_i_t data:
date value
3101 2025-06-09 746.11
3102 2025-06-10 740.00
3103 2025-06-11 744.22
3104 2025-06-12 742.11
3105 2025-06-13 737.00
2025-06-13 17:50:31,583 - IOOppi_data - INFO : save new data to db IOOppi_i_t: date value ... created_at updated_at
3104 2025-06-12 742.11 ... 2025-06-13 17:50:31.575826 2025-06-13 17:50:31.576239
3105 2025-06-13 737.00 ... 2025-06-13 17:50:31.575826 2025-06-13 17:50:31.576239
[2 rows x 5 columns]
2025-06-13 17:50:31,603 - IOOppi_data - INFO : save diff data to db: IOOppi_i_t: no diff data
2025-06-13 17:50:31,609 - IOOppi_data - INFO : save data to db IOOppi_i_g data:
date value
3101 2025-06-09 746.11
3102 2025-06-10 740.00
3103 2025-06-11 744.22
3104 2025-06-12 742.11
3105 2025-06-13 737.00
2025-06-13 17:50:31,675 - IOOppi_data - INFO : save new data to db IOOppi_i_g: date value ... created_at updated_at
3107 2025-06-12 742.11 ... 2025-06-13 17:50:31.668240 2025-06-13 17:50:31.668627
3108 2025-06-13 737.00 ... 2025-06-13 17:50:31.668240 2025-06-13 17:50:31.668627
[2 rows x 5 columns]
2025-06-13 17:50:31,694 - IOOppi_data - INFO : save diff data to db: IOOppi_i_g: no diff data
/usr/local/lib/python3.10/site-packages/urllib3/connectionpool.py:1056: InsecureRequestWarning: Unverified HTTPS request is being made to host 'www.100ppi.com'. Adding certificate verification is strongly advised. See: https://urllib3.readthedocs.io/en/1.26.x/advanced-usage.html#ssl-warnings
warnings.warn(
2025-06-13 17:50:32,250 - IOOppi_data - INFO : save data to db IOOppi_FG_t data:
date value
3304 2025-06-09 1120.0
3305 2025-06-10 1120.0
3306 2025-06-11 1104.0
3307 2025-06-12 1104.0
3308 2025-06-13 1104.0
2025-06-13 17:50:32,318 - IOOppi_data - INFO : save new data to db IOOppi_FG_t: date value ... created_at updated_at
3307 2025-06-12 1104.0 ... 2025-06-13 17:50:32.311447 2025-06-13 17:50:32.311859
3308 2025-06-13 1104.0 ... 2025-06-13 17:50:32.311447 2025-06-13 17:50:32.311859
[2 rows x 5 columns]
/root/project/IOOppi_data/IOOppi_request.py:308: SettingWithCopyWarning:
A value is trying to be set on a copy of a slice from a DataFrame.
Try using .loc[row_indexer,col_indexer] = value instead
See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy
diff_df.loc[:, 'index_code'] = index_code
/root/project/IOOppi_data/IOOppi_request.py:309: SettingWithCopyWarning:
A value is trying to be set on a copy of a slice from a DataFrame.
Try using .loc[row_indexer,col_indexer] = value instead
See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy
diff_df.loc[:, 'created_at'] = datetime.datetime.now()
/root/project/IOOppi_data/IOOppi_request.py:310: SettingWithCopyWarning:
A value is trying to be set on a copy of a slice from a DataFrame.
Try using .loc[row_indexer,col_indexer] = value instead
See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy
diff_df.loc[:, 'updated_at'] = datetime.datetime.now()
2025-06-13 17:50:34,308 - IOOppi_data - INFO : save diff data to db IOOppi_FG_t: date ... updated_at
12 2012-12-19 ... 2025-06-13 17:50:34.299456
21 2013-01-04 ... 2025-06-13 17:50:34.299456
54 2013-02-27 ... 2025-06-13 17:50:34.299456
60 2013-03-07 ... 2025-06-13 17:50:34.299456
61 2013-03-08 ... 2025-06-13 17:50:34.299456
[5 rows x 6 columns]
2025-06-13 17:50:34,485 - IOOppi_data - INFO : save data to db IOOppi_FG_g data:
date value
3304 2025-06-09 1120.0
3305 2025-06-10 1120.0
3306 2025-06-11 1104.0
3307 2025-06-12 1104.0
3308 2025-06-13 1104.0
2025-06-13 17:50:34,554 - IOOppi_data - INFO : save new data to db IOOppi_FG_g: date value ... created_at updated_at
3311 2025-06-12 1104.0 ... 2025-06-13 17:50:34.546597 2025-06-13 17:50:34.547012
3312 2025-06-13 1104.0 ... 2025-06-13 17:50:34.546597 2025-06-13 17:50:34.547012
[2 rows x 5 columns]
/root/project/IOOppi_data/IOOppi_request.py:308: SettingWithCopyWarning:
A value is trying to be set on a copy of a slice from a DataFrame.
Try using .loc[row_indexer,col_indexer] = value instead
See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy
diff_df.loc[:, 'index_code'] = index_code
/root/project/IOOppi_data/IOOppi_request.py:309: SettingWithCopyWarning:
A value is trying to be set on a copy of a slice from a DataFrame.
Try using .loc[row_indexer,col_indexer] = value instead
See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy
diff_df.loc[:, 'created_at'] = datetime.datetime.now()
/root/project/IOOppi_data/IOOppi_request.py:310: SettingWithCopyWarning:
A value is trying to be set on a copy of a slice from a DataFrame.
Try using .loc[row_indexer,col_indexer] = value instead
See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy
diff_df.loc[:, 'updated_at'] = datetime.datetime.now()
2025-06-13 17:50:36,455 - IOOppi_data - INFO : save diff data to db IOOppi_FG_g: date ... updated_at
12 2012-12-19 ... 2025-06-13 17:50:36.447924
21 2013-01-04 ... 2025-06-13 17:50:36.447924
54 2013-02-27 ... 2025-06-13 17:50:36.447924
60 2013-03-07 ... 2025-06-13 17:50:36.447924
61 2013-03-08 ... 2025-06-13 17:50:36.447924
[5 rows x 6 columns]
/usr/local/lib/python3.10/site-packages/urllib3/connectionpool.py:1056: InsecureRequestWarning: Unverified HTTPS request is being made to host 'www.100ppi.com'. Adding certificate verification is strongly advised. See: https://urllib3.readthedocs.io/en/1.26.x/advanced-usage.html#ssl-warnings
warnings.warn(
2025-06-13 17:50:37,135 - IOOppi_data - INFO : save data to db IOOppi_eb_t data:
date value
1649 2025-06-09 7870.0
1650 2025-06-10 7886.0
1651 2025-06-11 7886.0
1652 2025-06-12 8002.0
1653 2025-06-13 8068.0
2025-06-13 17:50:37,182 - IOOppi_data - INFO : save new data to db IOOppi_eb_t: date value ... created_at updated_at
1652 2025-06-12 8002.0 ... 2025-06-13 17:50:37.175012 2025-06-13 17:50:37.175397
1653 2025-06-13 8068.0 ... 2025-06-13 17:50:37.175012 2025-06-13 17:50:37.175397
[2 rows x 5 columns]
2025-06-13 17:50:37,200 - IOOppi_data - INFO : save diff data to db: IOOppi_eb_t: no diff data
2025-06-13 17:50:37,206 - IOOppi_data - INFO : save data to db IOOppi_eb_g data:
date value
1649 2025-06-09 7870.0
1650 2025-06-10 7886.0
1651 2025-06-11 7886.0
1652 2025-06-12 8002.0
1653 2025-06-13 8068.0
2025-06-13 17:50:37,252 - IOOppi_data - INFO : save new data to db IOOppi_eb_g: date value ... created_at updated_at
1655 2025-06-12 8002.0 ... 2025-06-13 17:50:37.245614 2025-06-13 17:50:37.246017
1656 2025-06-13 8068.0 ... 2025-06-13 17:50:37.245614 2025-06-13 17:50:37.246017
[2 rows x 5 columns]
2025-06-13 17:50:37,271 - IOOppi_data - INFO : save diff data to db: IOOppi_eb_g: no diff data
/usr/local/lib/python3.10/site-packages/urllib3/connectionpool.py:1056: InsecureRequestWarning: Unverified HTTPS request is being made to host 'www.100ppi.com'. Adding certificate verification is strongly advised. See: https://urllib3.readthedocs.io/en/1.26.x/advanced-usage.html#ssl-warnings
warnings.warn(
2025-06-13 17:50:37,831 - IOOppi_data - INFO : save data to db IOOppi_SR_t data:
date value
3760 2025-06-09 6095.0
3761 2025-06-10 6085.0
3762 2025-06-11 6080.0
3763 2025-06-12 6060.0
3764 2025-06-13 6050.0
2025-06-13 17:50:37,904 - IOOppi_data - INFO : save new data to db IOOppi_SR_t: date value ... created_at updated_at
3763 2025-06-12 6060.0 ... 2025-06-13 17:50:37.896710 2025-06-13 17:50:37.897130
3764 2025-06-13 6050.0 ... 2025-06-13 17:50:37.896710 2025-06-13 17:50:37.897130
[2 rows x 5 columns]
2025-06-13 17:50:37,924 - IOOppi_data - INFO : save diff data to db: IOOppi_SR_t: no diff data
2025-06-13 17:50:37,930 - IOOppi_data - INFO : save data to db IOOppi_SR_g data:
date value
3760 2025-06-09 6095.0
3761 2025-06-10 6085.0
3762 2025-06-11 6080.0
3763 2025-06-12 6060.0
3764 2025-06-13 6050.0
2025-06-13 17:50:38,007 - IOOppi_data - INFO : save new data to db IOOppi_SR_g: date value ... created_at updated_at
3767 2025-06-12 6060.0 ... 2025-06-13 17:50:37.999476 2025-06-13 17:50:37.999931
3768 2025-06-13 6050.0 ... 2025-06-13 17:50:37.999476 2025-06-13 17:50:37.999931
[2 rows x 5 columns]
2025-06-13 17:50:38,026 - IOOppi_data - INFO : save diff data to db: IOOppi_SR_g: no diff data
/usr/local/lib/python3.10/site-packages/urllib3/connectionpool.py:1056: InsecureRequestWarning: Unverified HTTPS request is being made to host 'www.100ppi.com'. Adding certificate verification is strongly advised. See: https://urllib3.readthedocs.io/en/1.26.x/advanced-usage.html#ssl-warnings
warnings.warn(
2025-06-13 17:50:38,583 - IOOppi_data - INFO : save data to db IOOppi_ss_t data:
date value
1650 2025-06-09 13100.0
1651 2025-06-10 13100.0
1652 2025-06-11 13012.5
1653 2025-06-12 13012.5
1654 2025-06-13 12962.5
2025-06-13 17:50:38,632 - IOOppi_data - INFO : save new data to db IOOppi_ss_t: date value ... created_at updated_at
1653 2025-06-12 13012.5 ... 2025-06-13 17:50:38.623983 2025-06-13 17:50:38.624402
1654 2025-06-13 12962.5 ... 2025-06-13 17:50:38.623983 2025-06-13 17:50:38.624402
[2 rows x 5 columns]
2025-06-13 17:50:38,650 - IOOppi_data - INFO : save diff data to db: IOOppi_ss_t: no diff data
2025-06-13 17:50:38,656 - IOOppi_data - INFO : save data to db IOOppi_ss_g data:
date value
1650 2025-06-09 13100.0
1651 2025-06-10 13100.0
1652 2025-06-11 13012.5
1653 2025-06-12 13012.5
1654 2025-06-13 12962.5
2025-06-13 17:50:38,702 - IOOppi_data - INFO : save new data to db IOOppi_ss_g: date value ... created_at updated_at
1656 2025-06-12 13012.5 ... 2025-06-13 17:50:38.695493 2025-06-13 17:50:38.695905
1657 2025-06-13 12962.5 ... 2025-06-13 17:50:38.695493 2025-06-13 17:50:38.695905
[2 rows x 5 columns]
2025-06-13 17:50:38,721 - IOOppi_data - INFO : save diff data to db: IOOppi_ss_g: no diff data
/usr/local/lib/python3.10/site-packages/urllib3/connectionpool.py:1056: InsecureRequestWarning: Unverified HTTPS request is being made to host 'www.100ppi.com'. Adding certificate verification is strongly advised. See: https://urllib3.readthedocs.io/en/1.26.x/advanced-usage.html#ssl-warnings
warnings.warn(
2025-06-13 17:50:39,282 - IOOppi_data - INFO : save data to db IOOppi_RS_t data:
date value
3160 2025-06-09 9331.67
3161 2025-06-10 9345.00
3162 2025-06-11 9303.33
3163 2025-06-12 9333.33
3164 2025-06-13 9473.33
2025-06-13 17:50:39,349 - IOOppi_data - INFO : save new data to db IOOppi_RS_t: date value ... created_at updated_at
3163 2025-06-12 9333.33 ... 2025-06-13 17:50:39.342465 2025-06-13 17:50:39.342875
3164 2025-06-13 9473.33 ... 2025-06-13 17:50:39.342465 2025-06-13 17:50:39.342875
[2 rows x 5 columns]
2025-06-13 17:50:39,368 - IOOppi_data - INFO : save diff data to db: IOOppi_RS_t: no diff data
2025-06-13 17:50:39,374 - IOOppi_data - INFO : save data to db IOOppi_RS_g data:
date value
3160 2025-06-09 9331.67
3161 2025-06-10 9345.00
3162 2025-06-11 9303.33
3163 2025-06-12 9333.33
3164 2025-06-13 9473.33
2025-06-13 17:50:39,439 - IOOppi_data - INFO : save new data to db IOOppi_RS_g: date value ... created_at updated_at
3167 2025-06-12 9333.33 ... 2025-06-13 17:50:39.431831 2025-06-13 17:50:39.432223
3168 2025-06-13 9473.33 ... 2025-06-13 17:50:39.431831 2025-06-13 17:50:39.432223
[2 rows x 5 columns]
2025-06-13 17:50:39,458 - IOOppi_data - INFO : save diff data to db: IOOppi_RS_g: no diff data
/usr/local/lib/python3.10/site-packages/urllib3/connectionpool.py:1056: InsecureRequestWarning: Unverified HTTPS request is being made to host 'www.100ppi.com'. Adding certificate verification is strongly advised. See: https://urllib3.readthedocs.io/en/1.26.x/advanced-usage.html#ssl-warnings
warnings.warn(
2025-06-13 17:50:39,995 - IOOppi_data - INFO : save data to db IOOppi_RM_t data:
date value
3283 2025-06-09 2543.33
3284 2025-06-10 2550.00
3285 2025-06-11 2568.33
3286 2025-06-12 2576.67
3287 2025-06-13 2606.67
2025-06-13 17:50:40,065 - IOOppi_data - INFO : save new data to db IOOppi_RM_t: date value ... created_at updated_at
3286 2025-06-12 2576.67 ... 2025-06-13 17:50:40.057015 2025-06-13 17:50:40.057486
3287 2025-06-13 2606.67 ... 2025-06-13 17:50:40.057015 2025-06-13 17:50:40.057486
[2 rows x 5 columns]
2025-06-13 17:50:40,084 - IOOppi_data - INFO : save diff data to db: IOOppi_RM_t: no diff data
2025-06-13 17:50:40,090 - IOOppi_data - INFO : save data to db IOOppi_RM_g data:
date value
3283 2025-06-09 2543.33
3284 2025-06-10 2550.00
3285 2025-06-11 2568.33
3286 2025-06-12 2576.67
3287 2025-06-13 2606.67
2025-06-13 17:50:40,160 - IOOppi_data - INFO : save new data to db IOOppi_RM_g: date value ... created_at updated_at
3290 2025-06-12 2576.67 ... 2025-06-13 17:50:40.152588 2025-06-13 17:50:40.153051
3291 2025-06-13 2606.67 ... 2025-06-13 17:50:40.152588 2025-06-13 17:50:40.153051
[2 rows x 5 columns]
2025-06-13 17:50:40,178 - IOOppi_data - INFO : save diff data to db: IOOppi_RM_g: no diff data
/usr/local/lib/python3.10/site-packages/urllib3/connectionpool.py:1056: InsecureRequestWarning: Unverified HTTPS request is being made to host 'www.100ppi.com'. Adding certificate verification is strongly advised. See: https://urllib3.readthedocs.io/en/1.26.x/advanced-usage.html#ssl-warnings
warnings.warn(
2025-06-13 17:50:40,712 - IOOppi_data - INFO : save data to db IOOppi_SA_t data:
date value
1487 2025-06-09 1370.0
1488 2025-06-10 1370.0
1489 2025-06-11 1370.0
1490 2025-06-12 1370.0
1491 2025-06-13 1370.0
2025-06-13 17:50:40,755 - IOOppi_data - INFO : save new data to db IOOppi_SA_t: date value ... created_at updated_at
1490 2025-06-12 1370.0 ... 2025-06-13 17:50:40.748220 2025-06-13 17:50:40.748596
1491 2025-06-13 1370.0 ... 2025-06-13 17:50:40.748220 2025-06-13 17:50:40.748596
[2 rows x 5 columns]
2025-06-13 17:50:40,774 - IOOppi_data - INFO : save diff data to db: IOOppi_SA_t: no diff data
2025-06-13 17:50:40,780 - IOOppi_data - INFO : save data to db IOOppi_SA_g data:
date value
1487 2025-06-09 1370.0
1488 2025-06-10 1370.0
1489 2025-06-11 1370.0
1490 2025-06-12 1370.0
1491 2025-06-13 1370.0
2025-06-13 17:50:40,824 - IOOppi_data - INFO : save new data to db IOOppi_SA_g: date value ... created_at updated_at
1494 2025-06-12 1370.0 ... 2025-06-13 17:50:40.817216 2025-06-13 17:50:40.817602
1495 2025-06-13 1370.0 ... 2025-06-13 17:50:40.817216 2025-06-13 17:50:40.817602
[2 rows x 5 columns]
2025-06-13 17:50:40,843 - IOOppi_data - INFO : save diff data to db: IOOppi_SA_g: no diff data
/usr/local/lib/python3.10/site-packages/urllib3/connectionpool.py:1056: InsecureRequestWarning: Unverified HTTPS request is being made to host 'www.100ppi.com'. Adding certificate verification is strongly advised. See: https://urllib3.readthedocs.io/en/1.26.x/advanced-usage.html#ssl-warnings
warnings.warn(
2025-06-13 17:50:41,462 - IOOppi_data - INFO : save data to db IOOppi_PF_t data:
date value
1400 2025-06-09 6518.12
1401 2025-06-10 6522.50
1402 2025-06-11 6510.62
1403 2025-06-12 6535.21
1404 2025-06-13 6640.21
2025-06-13 17:50:41,505 - IOOppi_data - INFO : save new data to db IOOppi_PF_t: date value ... created_at updated_at
1403 2025-06-12 6535.21 ... 2025-06-13 17:50:41.498117 2025-06-13 17:50:41.498501
1404 2025-06-13 6640.21 ... 2025-06-13 17:50:41.498117 2025-06-13 17:50:41.498501
[2 rows x 5 columns]
2025-06-13 17:50:41,524 - IOOppi_data - INFO : save diff data to db: IOOppi_PF_t: no diff data
2025-06-13 17:50:41,529 - IOOppi_data - INFO : save data to db IOOppi_PF_g data:
date value
1400 2025-06-09 6518.12
1401 2025-06-10 6522.50
1402 2025-06-11 6510.62
1403 2025-06-12 6535.21
1404 2025-06-13 6640.21
2025-06-13 17:50:41,574 - IOOppi_data - INFO : save new data to db IOOppi_PF_g: date value ... created_at updated_at
1407 2025-06-12 6535.21 ... 2025-06-13 17:50:41.565821 2025-06-13 17:50:41.566222
1408 2025-06-13 6640.21 ... 2025-06-13 17:50:41.565821 2025-06-13 17:50:41.566222
[2 rows x 5 columns]
2025-06-13 17:50:41,593 - IOOppi_data - INFO : save diff data to db: IOOppi_PF_g: no diff data
/usr/local/lib/python3.10/site-packages/urllib3/connectionpool.py:1056: InsecureRequestWarning: Unverified HTTPS request is being made to host 'www.100ppi.com'. Adding certificate verification is strongly advised. See: https://urllib3.readthedocs.io/en/1.26.x/advanced-usage.html#ssl-warnings
warnings.warn(
2025-06-13 17:50:42,198 - IOOppi_data - INFO : save data to db IOOppi_m_t data:
date value
3773 2025-06-09 2944.0
3774 2025-06-10 2952.0
3775 2025-06-11 2978.0
3776 2025-06-12 2982.0
3777 2025-06-13 2994.0
2025-06-13 17:50:42,275 - IOOppi_data - INFO : save new data to db IOOppi_m_t: date value ... created_at updated_at
3776 2025-06-12 2982.0 ... 2025-06-13 17:50:42.267678 2025-06-13 17:50:42.268110
3777 2025-06-13 2994.0 ... 2025-06-13 17:50:42.267678 2025-06-13 17:50:42.268110
[2 rows x 5 columns]
2025-06-13 17:50:42,293 - IOOppi_data - INFO : save diff data to db: IOOppi_m_t: no diff data
2025-06-13 17:50:42,300 - IOOppi_data - INFO : save data to db IOOppi_m_g data:
date value
3773 2025-06-09 2944.0
3774 2025-06-10 2952.0
3775 2025-06-11 2978.0
3776 2025-06-12 2982.0
3777 2025-06-13 2994.0
2025-06-13 17:50:42,375 - IOOppi_data - INFO : save new data to db IOOppi_m_g: date value ... created_at updated_at
3779 2025-06-12 2982.0 ... 2025-06-13 17:50:42.368419 2025-06-13 17:50:42.368838
3780 2025-06-13 2994.0 ... 2025-06-13 17:50:42.368419 2025-06-13 17:50:42.368838
[2 rows x 5 columns]
2025-06-13 17:50:42,393 - IOOppi_data - INFO : save diff data to db: IOOppi_m_g: no diff data
/usr/local/lib/python3.10/site-packages/urllib3/connectionpool.py:1056: InsecureRequestWarning: Unverified HTTPS request is being made to host 'www.100ppi.com'. Adding certificate verification is strongly advised. See: https://urllib3.readthedocs.io/en/1.26.x/advanced-usage.html#ssl-warnings
warnings.warn(
2025-06-13 17:50:42,959 - IOOppi_data - INFO : save data to db IOOppi_y_t data:
date value
3543 2025-06-09 8024.0
3544 2025-06-10 8024.0
3545 2025-06-11 7964.0
3546 2025-06-12 7954.0
3547 2025-06-13 8064.0
2025-06-13 17:50:43,035 - IOOppi_data - INFO : save new data to db IOOppi_y_t: date value ... created_at updated_at
3546 2025-06-12 7954.0 ... 2025-06-13 17:50:43.027843 2025-06-13 17:50:43.028351
3547 2025-06-13 8064.0 ... 2025-06-13 17:50:43.027843 2025-06-13 17:50:43.028351
[2 rows x 5 columns]
2025-06-13 17:50:43,055 - IOOppi_data - INFO : save diff data to db: IOOppi_y_t: no diff data
2025-06-13 17:50:43,062 - IOOppi_data - INFO : save data to db IOOppi_y_g data:
date value
3543 2025-06-09 8024.0
3544 2025-06-10 8024.0
3545 2025-06-11 7964.0
3546 2025-06-12 7954.0
3547 2025-06-13 8064.0
2025-06-13 17:50:43,136 - IOOppi_data - INFO : save new data to db IOOppi_y_g: date value ... created_at updated_at
3549 2025-06-12 7954.0 ... 2025-06-13 17:50:43.129173 2025-06-13 17:50:43.129560
3550 2025-06-13 8064.0 ... 2025-06-13 17:50:43.129173 2025-06-13 17:50:43.129560
[2 rows x 5 columns]
2025-06-13 17:50:43,155 - IOOppi_data - INFO : save diff data to db: IOOppi_y_g: no diff data
/usr/local/lib/python3.10/site-packages/urllib3/connectionpool.py:1056: InsecureRequestWarning: Unverified HTTPS request is being made to host 'www.100ppi.com'. Adding certificate verification is strongly advised. See: https://urllib3.readthedocs.io/en/1.26.x/advanced-usage.html#ssl-warnings
warnings.warn(
2025-06-13 17:50:43,668 - IOOppi_data - INFO : save data to db IOOppi_a_t data:
date value
3509 2025-06-09 4295.0
3510 2025-06-10 4295.0
3511 2025-06-11 4295.0
3512 2025-06-12 4295.0
3513 2025-06-13 4295.0
2025-06-13 17:50:43,742 - IOOppi_data - INFO : save new data to db IOOppi_a_t: date value ... created_at updated_at
3512 2025-06-12 4295.0 ... 2025-06-13 17:50:43.733783 2025-06-13 17:50:43.734272
3513 2025-06-13 4295.0 ... 2025-06-13 17:50:43.733783 2025-06-13 17:50:43.734272
[2 rows x 5 columns]
2025-06-13 17:50:43,760 - IOOppi_data - INFO : save diff data to db: IOOppi_a_t: no diff data
2025-06-13 17:50:43,766 - IOOppi_data - INFO : save data to db IOOppi_a_g data:
date value
3509 2025-06-09 4295.0
3510 2025-06-10 4295.0
3511 2025-06-11 4295.0
3512 2025-06-12 4295.0
3513 2025-06-13 4295.0
2025-06-13 17:50:43,838 - IOOppi_data - INFO : save new data to db IOOppi_a_g: date value ... created_at updated_at
3515 2025-06-12 4295.0 ... 2025-06-13 17:50:43.830336 2025-06-13 17:50:43.830730
3516 2025-06-13 4295.0 ... 2025-06-13 17:50:43.830336 2025-06-13 17:50:43.830730
[2 rows x 5 columns]
2025-06-13 17:50:43,856 - IOOppi_data - INFO : save diff data to db: IOOppi_a_g: no diff data
/usr/local/lib/python3.10/site-packages/urllib3/connectionpool.py:1056: InsecureRequestWarning: Unverified HTTPS request is being made to host 'www.100ppi.com'. Adding certificate verification is strongly advised. See: https://urllib3.readthedocs.io/en/1.26.x/advanced-usage.html#ssl-warnings
warnings.warn(
2025-06-13 17:50:44,407 - IOOppi_data - INFO : save data to db IOOppi_SF_t data:
date value
2886 2025-06-09 5088.57
2887 2025-06-10 5088.57
2888 2025-06-11 5048.57
2889 2025-06-12 5048.57
2890 2025-06-13 5048.57
2025-06-13 17:50:44,468 - IOOppi_data - INFO : save new data to db IOOppi_SF_t: date value ... created_at updated_at
2889 2025-06-12 5048.57 ... 2025-06-13 17:50:44.461318 2025-06-13 17:50:44.461699
2890 2025-06-13 5048.57 ... 2025-06-13 17:50:44.461318 2025-06-13 17:50:44.461699
[2 rows x 5 columns]
2025-06-13 17:50:44,488 - IOOppi_data - INFO : save diff data to db: IOOppi_SF_t: no diff data
2025-06-13 17:50:44,494 - IOOppi_data - INFO : save data to db IOOppi_SF_g data:
date value
2886 2025-06-09 5088.57
2887 2025-06-10 5088.57
2888 2025-06-11 5048.57
2889 2025-06-12 5048.57
2890 2025-06-13 5048.57
2025-06-13 17:50:44,554 - IOOppi_data - INFO : save new data to db IOOppi_SF_g: date value ... created_at updated_at
2893 2025-06-12 5048.57 ... 2025-06-13 17:50:44.547650 2025-06-13 17:50:44.548059
2894 2025-06-13 5048.57 ... 2025-06-13 17:50:44.547650 2025-06-13 17:50:44.548059
[2 rows x 5 columns]
2025-06-13 17:50:44,573 - IOOppi_data - INFO : save diff data to db: IOOppi_SF_g: no diff data
/usr/local/lib/python3.10/site-packages/urllib3/connectionpool.py:1056: InsecureRequestWarning: Unverified HTTPS request is being made to host 'www.100ppi.com'. Adding certificate verification is strongly advised. See: https://urllib3.readthedocs.io/en/1.26.x/advanced-usage.html#ssl-warnings
warnings.warn(
2025-06-13 17:50:45,179 - IOOppi_data - INFO : save data to db IOOppi_jd_t data:
date value
3086 2025-06-09 2915.0
3087 2025-06-10 2915.0
3088 2025-06-11 2860.0
3089 2025-06-12 2810.0
3090 2025-06-13 2790.0
2025-06-13 17:50:45,250 - IOOppi_data - INFO : save new data to db IOOppi_jd_t: date value ... created_at updated_at
3089 2025-06-12 2810.0 ... 2025-06-13 17:50:45.241454 2025-06-13 17:50:45.242020
3090 2025-06-13 2790.0 ... 2025-06-13 17:50:45.241454 2025-06-13 17:50:45.242020
[2 rows x 5 columns]
/root/project/IOOppi_data/IOOppi_request.py:308: SettingWithCopyWarning:
A value is trying to be set on a copy of a slice from a DataFrame.
Try using .loc[row_indexer,col_indexer] = value instead
See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy
diff_df.loc[:, 'index_code'] = index_code
/root/project/IOOppi_data/IOOppi_request.py:309: SettingWithCopyWarning:
A value is trying to be set on a copy of a slice from a DataFrame.
Try using .loc[row_indexer,col_indexer] = value instead
See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy
diff_df.loc[:, 'created_at'] = datetime.datetime.now()
/root/project/IOOppi_data/IOOppi_request.py:310: SettingWithCopyWarning:
A value is trying to be set on a copy of a slice from a DataFrame.
Try using .loc[row_indexer,col_indexer] = value instead
See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy
diff_df.loc[:, 'updated_at'] = datetime.datetime.now()
2025-06-13 17:50:45,399 - IOOppi_data - INFO : save diff data to db IOOppi_jd_t: date ... updated_at
39 2014-01-03 ... 2025-06-13 17:50:45.391891
458 2015-09-21 ... 2025-06-13 17:50:45.391891
549 2016-02-03 ... 2025-06-13 17:50:45.391891
693 2016-09-05 ... 2025-06-13 17:50:45.391891
696 2016-09-08 ... 2025-06-13 17:50:45.391891
[5 rows x 6 columns]
2025-06-13 17:50:45,429 - IOOppi_data - INFO : save data to db IOOppi_jd_g data:
date value
3086 2025-06-09 2915.0
3087 2025-06-10 2915.0
3088 2025-06-11 2860.0
3089 2025-06-12 2810.0
3090 2025-06-13 2790.0
2025-06-13 17:50:45,496 - IOOppi_data - INFO : save new data to db IOOppi_jd_g: date value ... created_at updated_at
3092 2025-06-12 2810.0 ... 2025-06-13 17:50:45.488681 2025-06-13 17:50:45.489102
3093 2025-06-13 2790.0 ... 2025-06-13 17:50:45.488681 2025-06-13 17:50:45.489102
[2 rows x 5 columns]
/root/project/IOOppi_data/IOOppi_request.py:308: SettingWithCopyWarning:
A value is trying to be set on a copy of a slice from a DataFrame.
Try using .loc[row_indexer,col_indexer] = value instead
See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy
diff_df.loc[:, 'index_code'] = index_code
/root/project/IOOppi_data/IOOppi_request.py:309: SettingWithCopyWarning:
A value is trying to be set on a copy of a slice from a DataFrame.
Try using .loc[row_indexer,col_indexer] = value instead
See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy
diff_df.loc[:, 'created_at'] = datetime.datetime.now()
/root/project/IOOppi_data/IOOppi_request.py:310: SettingWithCopyWarning:
A value is trying to be set on a copy of a slice from a DataFrame.
Try using .loc[row_indexer,col_indexer] = value instead
See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy
diff_df.loc[:, 'updated_at'] = datetime.datetime.now()
2025-06-13 17:50:45,643 - IOOppi_data - INFO : save diff data to db IOOppi_jd_g: date ... updated_at
39 2014-01-03 ... 2025-06-13 17:50:45.635126
458 2015-09-21 ... 2025-06-13 17:50:45.635126
549 2016-02-03 ... 2025-06-13 17:50:45.635126
693 2016-09-05 ... 2025-06-13 17:50:45.635126
696 2016-09-08 ... 2025-06-13 17:50:45.635126
[5 rows x 6 columns]
/usr/local/lib/python3.10/site-packages/urllib3/connectionpool.py:1056: InsecureRequestWarning: Unverified HTTPS request is being made to host 'www.100ppi.com'. Adding certificate verification is strongly advised. See: https://urllib3.readthedocs.io/en/1.26.x/advanced-usage.html#ssl-warnings
warnings.warn(
2025-06-13 17:50:46,219 - IOOppi_data - INFO : save data to db IOOppi_SI_t data:
date value
890 2025-06-09 8620.0
891 2025-06-10 8620.0
892 2025-06-11 8620.0
893 2025-06-12 8620.0
894 2025-06-13 8620.0
2025-06-13 17:50:46,259 - IOOppi_data - INFO : save new data to db IOOppi_SI_t: date value ... created_at updated_at
893 2025-06-12 8620.0 ... 2025-06-13 17:50:46.251031 2025-06-13 17:50:46.251422
894 2025-06-13 8620.0 ... 2025-06-13 17:50:46.251031 2025-06-13 17:50:46.251422
[2 rows x 5 columns]
2025-06-13 17:50:46,278 - IOOppi_data - INFO : save diff data to db: IOOppi_SI_t: no diff data
2025-06-13 17:50:46,284 - IOOppi_data - INFO : save data to db IOOppi_SI_g data:
date value
890 2025-06-09 8620.0
891 2025-06-10 8620.0
892 2025-06-11 8620.0
893 2025-06-12 8620.0
894 2025-06-13 8620.0
2025-06-13 17:50:46,321 - IOOppi_data - INFO : save new data to db IOOppi_SI_g: date value ... created_at updated_at
893 2025-06-12 8620.0 ... 2025-06-13 17:50:46.313609 2025-06-13 17:50:46.314029
894 2025-06-13 8620.0 ... 2025-06-13 17:50:46.313609 2025-06-13 17:50:46.314029
[2 rows x 5 columns]
2025-06-13 17:50:46,339 - IOOppi_data - INFO : save diff data to db: IOOppi_SI_g: no diff data
/usr/local/lib/python3.10/site-packages/urllib3/connectionpool.py:1056: InsecureRequestWarning: Unverified HTTPS request is being made to host 'www.100ppi.com'. Adding certificate verification is strongly advised. See: https://urllib3.readthedocs.io/en/1.26.x/advanced-usage.html#ssl-warnings
warnings.warn(
2025-06-13 17:50:46,892 - IOOppi_data - INFO : save data to db IOOppi_l_t data:
date value
3769 2025-06-09 7346.67
3770 2025-06-10 7361.67
3771 2025-06-11 7366.67
3772 2025-06-12 7388.33
3773 2025-06-13 7396.67
2025-06-13 17:50:46,963 - IOOppi_data - INFO : save new data to db IOOppi_l_t: date value ... created_at updated_at
3772 2025-06-12 7388.33 ... 2025-06-13 17:50:46.956591 2025-06-13 17:50:46.957009
3773 2025-06-13 7396.67 ... 2025-06-13 17:50:46.956591 2025-06-13 17:50:46.957009
[2 rows x 5 columns]
2025-06-13 17:50:46,982 - IOOppi_data - INFO : save diff data to db: IOOppi_l_t: no diff data
2025-06-13 17:50:46,989 - IOOppi_data - INFO : save data to db IOOppi_l_g data:
date value
3769 2025-06-09 7346.67
3770 2025-06-10 7361.67
3771 2025-06-11 7366.67
3772 2025-06-12 7388.33
3773 2025-06-13 7396.67
2025-06-13 17:50:47,065 - IOOppi_data - INFO : save new data to db IOOppi_l_g: date value ... created_at updated_at
3775 2025-06-12 7388.33 ... 2025-06-13 17:50:47.057666 2025-06-13 17:50:47.058114
3776 2025-06-13 7396.67 ... 2025-06-13 17:50:47.057666 2025-06-13 17:50:47.058114
[2 rows x 5 columns]
2025-06-13 17:50:47,084 - IOOppi_data - INFO : save diff data to db: IOOppi_l_g: no diff data
/usr/local/lib/python3.10/site-packages/urllib3/connectionpool.py:1056: InsecureRequestWarning: Unverified HTTPS request is being made to host 'www.100ppi.com'. Adding certificate verification is strongly advised. See: https://urllib3.readthedocs.io/en/1.26.x/advanced-usage.html#ssl-warnings
warnings.warn(
2025-06-13 17:50:47,637 - IOOppi_data - INFO : save data to db IOOppi_bu_t data:
date value
3107 2025-06-09 3630.00
3108 2025-06-10 3623.33
3109 2025-06-11 3630.00
3110 2025-06-12 3620.00
3111 2025-06-13 3696.67
2025-06-13 17:50:47,701 - IOOppi_data - INFO : save new data to db IOOppi_bu_t: date value ... created_at updated_at
3111 2025-06-12 3620.00 ... 2025-06-13 17:50:47.694117 2025-06-13 17:50:47.694501
3112 2025-06-13 3696.67 ... 2025-06-13 17:50:47.694117 2025-06-13 17:50:47.694501
[2 rows x 5 columns]
/root/project/IOOppi_data/IOOppi_request.py:308: SettingWithCopyWarning:
A value is trying to be set on a copy of a slice from a DataFrame.
Try using .loc[row_indexer,col_indexer] = value instead
See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy
diff_df.loc[:, 'index_code'] = index_code
/root/project/IOOppi_data/IOOppi_request.py:309: SettingWithCopyWarning:
A value is trying to be set on a copy of a slice from a DataFrame.
Try using .loc[row_indexer,col_indexer] = value instead
See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy
diff_df.loc[:, 'created_at'] = datetime.datetime.now()
/root/project/IOOppi_data/IOOppi_request.py:310: SettingWithCopyWarning:
A value is trying to be set on a copy of a slice from a DataFrame.
Try using .loc[row_indexer,col_indexer] = value instead
See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy
diff_df.loc[:, 'updated_at'] = datetime.datetime.now()
2025-06-13 17:50:47,736 - IOOppi_data - INFO : save diff data to db IOOppi_bu_t: date ... updated_at
2560 2023-12-09 ... 2025-06-13 17:50:47.729096
[1 rows x 6 columns]
2025-06-13 17:50:47,761 - IOOppi_data - INFO : save data to db IOOppi_bu_g data:
date value
3107 2025-06-09 3630.00
3108 2025-06-10 3623.33
3109 2025-06-11 3630.00
3110 2025-06-12 3620.00
3111 2025-06-13 3696.67
2025-06-13 17:50:47,829 - IOOppi_data - INFO : save new data to db IOOppi_bu_g: date value ... created_at updated_at
3113 2025-06-12 3620.00 ... 2025-06-13 17:50:47.820565 2025-06-13 17:50:47.821003
3114 2025-06-13 3696.67 ... 2025-06-13 17:50:47.820565 2025-06-13 17:50:47.821003
[2 rows x 5 columns]
2025-06-13 17:50:47,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-06-13 17:50:48,426 - IOOppi_data - INFO : save data to db IOOppi_al_t data:
date value
3772 2025-06-09 20246.67
3773 2025-06-10 20193.33
3774 2025-06-11 20193.33
3775 2025-06-12 20420.00
3776 2025-06-13 20740.00
2025-06-13 17:50:48,500 - IOOppi_data - INFO : save new data to db IOOppi_al_t: date value ... created_at updated_at
3775 2025-06-12 20420.0 ... 2025-06-13 17:50:48.492583 2025-06-13 17:50:48.493027
3776 2025-06-13 20740.0 ... 2025-06-13 17:50:48.492583 2025-06-13 17:50:48.493027
[2 rows x 5 columns]
2025-06-13 17:50:48,520 - IOOppi_data - INFO : save diff data to db: IOOppi_al_t: no diff data
2025-06-13 17:50:48,526 - IOOppi_data - INFO : save data to db IOOppi_al_g data:
date value
3772 2025-06-09 20246.67
3773 2025-06-10 20193.33
3774 2025-06-11 20193.33
3775 2025-06-12 20420.00
3776 2025-06-13 20740.00
2025-06-13 17:50:48,600 - IOOppi_data - INFO : save new data to db IOOppi_al_g: date value ... created_at updated_at
3778 2025-06-12 20420.0 ... 2025-06-13 17:50:48.592977 2025-06-13 17:50:48.593366
3779 2025-06-13 20740.0 ... 2025-06-13 17:50:48.592977 2025-06-13 17:50:48.593366
[2 rows x 5 columns]
2025-06-13 17:50:48,619 - IOOppi_data - INFO : save diff data to db: IOOppi_al_g: no diff data
/usr/local/lib/python3.10/site-packages/urllib3/connectionpool.py:1056: InsecureRequestWarning: Unverified HTTPS request is being made to host 'www.100ppi.com'. Adding certificate verification is strongly advised. See: https://urllib3.readthedocs.io/en/1.26.x/advanced-usage.html#ssl-warnings
warnings.warn(
2025-06-13 17:50:49,255 - IOOppi_data - INFO : save data to db IOOppi_SM_t data:
date value
2886 2025-06-09 5530.0
2887 2025-06-10 5536.0
2888 2025-06-11 5526.0
2889 2025-06-12 5470.0
2890 2025-06-13 5476.0
2025-06-13 17:50:49,317 - IOOppi_data - INFO : save new data to db IOOppi_SM_t: date value ... created_at updated_at
2889 2025-06-12 5470.0 ... 2025-06-13 17:50:49.309962 2025-06-13 17:50:49.310373
2890 2025-06-13 5476.0 ... 2025-06-13 17:50:49.309962 2025-06-13 17:50:49.310373
[2 rows x 5 columns]
2025-06-13 17:50:49,336 - IOOppi_data - INFO : save diff data to db: IOOppi_SM_t: no diff data
2025-06-13 17:50:49,342 - IOOppi_data - INFO : save data to db IOOppi_SM_g data:
date value
2886 2025-06-09 5530.0
2887 2025-06-10 5536.0
2888 2025-06-11 5526.0
2889 2025-06-12 5470.0
2890 2025-06-13 5476.0
2025-06-13 17:50:49,405 - IOOppi_data - INFO : save new data to db IOOppi_SM_g: date value ... created_at updated_at
2893 2025-06-12 5470.0 ... 2025-06-13 17:50:49.397649 2025-06-13 17:50:49.398066
2894 2025-06-13 5476.0 ... 2025-06-13 17:50:49.397649 2025-06-13 17:50:49.398066
[2 rows x 5 columns]
2025-06-13 17:50:49,424 - IOOppi_data - INFO : save diff data to db: IOOppi_SM_g: no diff data
/usr/local/lib/python3.10/site-packages/urllib3/connectionpool.py:1056: InsecureRequestWarning: Unverified HTTPS request is being made to host 'www.100ppi.com'. Adding certificate verification is strongly advised. See: https://urllib3.readthedocs.io/en/1.26.x/advanced-usage.html#ssl-warnings
warnings.warn(
2025-06-13 17:50:49,990 - IOOppi_data - INFO : save data to db IOOppi_CY_t data:
date value
2161 2025-06-09 23725.0
2162 2025-06-10 23725.0
2163 2025-06-11 23725.0
2164 2025-06-12 23725.0
2165 2025-06-13 23725.0
2025-06-13 17:50:50,041 - IOOppi_data - INFO : save new data to db IOOppi_CY_t: date value ... created_at updated_at
2164 2025-06-12 23725.0 ... 2025-06-13 17:50:50.034054 2025-06-13 17:50:50.034485
2165 2025-06-13 23725.0 ... 2025-06-13 17:50:50.034054 2025-06-13 17:50:50.034485
[2 rows x 5 columns]
2025-06-13 17:50:50,060 - IOOppi_data - INFO : save diff data to db: IOOppi_CY_t: no diff data
2025-06-13 17:50:50,065 - IOOppi_data - INFO : save data to db IOOppi_CY_g data:
date value
2161 2025-06-09 23725.0
2162 2025-06-10 23725.0
2163 2025-06-11 23725.0
2164 2025-06-12 23725.0
2165 2025-06-13 23725.0
2025-06-13 17:50:50,118 - IOOppi_data - INFO : save new data to db IOOppi_CY_g: date value ... created_at updated_at
2168 2025-06-12 23725.0 ... 2025-06-13 17:50:50.110801 2025-06-13 17:50:50.111199
2169 2025-06-13 23725.0 ... 2025-06-13 17:50:50.110801 2025-06-13 17:50:50.111199
[2 rows x 5 columns]
2025-06-13 17:50:50,137 - IOOppi_data - INFO : save diff data to db: IOOppi_CY_g: no diff data
/usr/local/lib/python3.10/site-packages/urllib3/connectionpool.py:1056: InsecureRequestWarning: Unverified HTTPS request is being made to host 'www.100ppi.com'. Adding certificate verification is strongly advised. See: https://urllib3.readthedocs.io/en/1.26.x/advanced-usage.html#ssl-warnings
warnings.warn(
2025-06-13 17:50:50,737 - IOOppi_data - INFO : save data to db IOOppi_UR_t data:
date value
1676 2025-06-09 1821.67
1677 2025-06-10 1821.67
1678 2025-06-11 1820.00
1679 2025-06-12 1816.67
1680 2025-06-13 1796.00
2025-06-13 17:50:50,784 - IOOppi_data - INFO : save new data to db IOOppi_UR_t: date value ... created_at updated_at
1679 2025-06-12 1816.67 ... 2025-06-13 17:50:50.776643 2025-06-13 17:50:50.777063
1680 2025-06-13 1796.00 ... 2025-06-13 17:50:50.776643 2025-06-13 17:50:50.777063
[2 rows x 5 columns]
2025-06-13 17:50:50,802 - IOOppi_data - INFO : save diff data to db: IOOppi_UR_t: no diff data
2025-06-13 17:50:50,808 - IOOppi_data - INFO : save data to db IOOppi_UR_g data:
date value
1676 2025-06-09 1821.67
1677 2025-06-10 1821.67
1678 2025-06-11 1820.00
1679 2025-06-12 1816.67
1680 2025-06-13 1796.00
2025-06-13 17:50:50,856 - IOOppi_data - INFO : save new data to db IOOppi_UR_g: date value ... created_at updated_at
1683 2025-06-12 1816.67 ... 2025-06-13 17:50:50.849207 2025-06-13 17:50:50.849599
1684 2025-06-13 1796.00 ... 2025-06-13 17:50:50.849207 2025-06-13 17:50:50.849599
[2 rows x 5 columns]
2025-06-13 17:50:50,875 - IOOppi_data - INFO : save diff data to db: IOOppi_UR_g: no diff data
/usr/local/lib/python3.10/site-packages/urllib3/connectionpool.py:1056: InsecureRequestWarning: Unverified HTTPS request is being made to host 'www.100ppi.com'. Adding certificate verification is strongly advised. See: https://urllib3.readthedocs.io/en/1.26.x/advanced-usage.html#ssl-warnings
warnings.warn(
2025-06-13 17:50:51,500 - IOOppi_data - INFO : save data to db IOOppi_ni_t data:
date value
2748 2025-06-09 124133.33
2749 2025-06-10 123000.00
2750 2025-06-11 122883.33
2751 2025-06-12 122066.67
2752 2025-06-13 121800.00
2025-06-13 17:50:51,559 - IOOppi_data - INFO : save new data to db IOOppi_ni_t: date ... updated_at
2751 2025-06-12 ... 2025-06-13 17:50:51.553488
2752 2025-06-13 ... 2025-06-13 17:50:51.553488
[2 rows x 5 columns]
2025-06-13 17:50:51,578 - IOOppi_data - INFO : save diff data to db: IOOppi_ni_t: no diff data
2025-06-13 17:50:51,584 - IOOppi_data - INFO : save data to db IOOppi_ni_g data:
date value
2748 2025-06-09 124133.33
2749 2025-06-10 123000.00
2750 2025-06-11 122883.33
2751 2025-06-12 122066.67
2752 2025-06-13 121800.00
2025-06-13 17:50:51,643 - IOOppi_data - INFO : save new data to db IOOppi_ni_g: date ... updated_at
2754 2025-06-12 ... 2025-06-13 17:50:51.637442
2755 2025-06-13 ... 2025-06-13 17:50:51.637442
[2 rows x 5 columns]
2025-06-13 17:50:51,662 - IOOppi_data - INFO : save diff data to db: IOOppi_ni_g: no diff data
/usr/local/lib/python3.10/site-packages/urllib3/connectionpool.py:1056: InsecureRequestWarning: Unverified HTTPS request is being made to host 'www.100ppi.com'. Adding certificate verification is strongly advised. See: https://urllib3.readthedocs.io/en/1.26.x/advanced-usage.html#ssl-warnings
warnings.warn(
2025-06-13 17:50:52,223 - IOOppi_data - INFO : save data to db IOOppi_v_t data:
date value
3773 2025-06-09 4602.0
3774 2025-06-10 4608.0
3775 2025-06-11 4613.0
3776 2025-06-12 4617.0
3777 2025-06-13 4656.0
2025-06-13 17:50:52,299 - IOOppi_data - INFO : save new data to db IOOppi_v_t: date value ... created_at updated_at
3776 2025-06-12 4617.0 ... 2025-06-13 17:50:52.291489 2025-06-13 17:50:52.292289
3777 2025-06-13 4656.0 ... 2025-06-13 17:50:52.291489 2025-06-13 17:50:52.292289
[2 rows x 5 columns]
2025-06-13 17:50:52,318 - IOOppi_data - INFO : save diff data to db: IOOppi_v_t: no diff data
2025-06-13 17:50:52,324 - IOOppi_data - INFO : save data to db IOOppi_v_g data:
date value
3773 2025-06-09 4602.0
3774 2025-06-10 4608.0
3775 2025-06-11 4613.0
3776 2025-06-12 4617.0
3777 2025-06-13 4656.0
2025-06-13 17:50:52,398 - IOOppi_data - INFO : save new data to db IOOppi_v_g: date value ... created_at updated_at
3779 2025-06-12 4617.0 ... 2025-06-13 17:50:52.391400 2025-06-13 17:50:52.391819
3780 2025-06-13 4656.0 ... 2025-06-13 17:50:52.391400 2025-06-13 17:50:52.391819
[2 rows x 5 columns]
2025-06-13 17:50:52,416 - IOOppi_data - INFO : save diff data to db: IOOppi_v_g: no diff data
/usr/local/lib/python3.10/site-packages/urllib3/connectionpool.py:1056: InsecureRequestWarning: Unverified HTTPS request is being made to host 'www.100ppi.com'. Adding certificate verification is strongly advised. See: https://urllib3.readthedocs.io/en/1.26.x/advanced-usage.html#ssl-warnings
warnings.warn(
2025-06-13 17:50:52,942 - IOOppi_data - INFO : save data to db IOOppi_pp_t data:
date value
3012 2025-06-09 7380.00
3013 2025-06-10 7380.00
3014 2025-06-11 7378.33
3015 2025-06-12 7378.33
3016 2025-06-13 7403.33
2025-06-13 17:50:53,007 - IOOppi_data - INFO : save new data to db IOOppi_pp_t: date value ... created_at updated_at
3015 2025-06-12 7378.33 ... 2025-06-13 17:50:53.000156 2025-06-13 17:50:53.000547
3016 2025-06-13 7403.33 ... 2025-06-13 17:50:53.000156 2025-06-13 17:50:53.000547
[2 rows x 5 columns]
2025-06-13 17:50:53,027 - IOOppi_data - INFO : save diff data to db: IOOppi_pp_t: no diff data
2025-06-13 17:50:53,033 - IOOppi_data - INFO : save data to db IOOppi_pp_g data:
date value
3012 2025-06-09 7380.00
3013 2025-06-10 7380.00
3014 2025-06-11 7378.33
3015 2025-06-12 7378.33
3016 2025-06-13 7403.33
2025-06-13 17:50:53,098 - IOOppi_data - INFO : save new data to db IOOppi_pp_g: date value ... created_at updated_at
3018 2025-06-12 7378.33 ... 2025-06-13 17:50:53.090595 2025-06-13 17:50:53.091025
3019 2025-06-13 7403.33 ... 2025-06-13 17:50:53.090595 2025-06-13 17:50:53.091025
[2 rows x 5 columns]
2025-06-13 17:50:53,116 - IOOppi_data - INFO : save diff data to db: IOOppi_pp_g: no diff data
/usr/local/lib/python3.10/site-packages/urllib3/connectionpool.py:1056: InsecureRequestWarning: Unverified HTTPS request is being made to host 'www.100ppi.com'. Adding certificate verification is strongly advised. See: https://urllib3.readthedocs.io/en/1.26.x/advanced-usage.html#ssl-warnings
warnings.warn(
2025-06-13 17:50:53,697 - IOOppi_data - INFO : save data to db IOOppi_CF_t data:
date value
3774 2025-06-09 14623.00
3775 2025-06-10 14623.00
3776 2025-06-11 14783.00
3777 2025-06-12 14848.67
3778 2025-06-13 14831.17
2025-06-13 17:50:53,771 - IOOppi_data - INFO : save new data to db IOOppi_CF_t: date ... updated_at
3777 2025-06-12 ... 2025-06-13 17:50:53.764735
3778 2025-06-13 ... 2025-06-13 17:50:53.764735
[2 rows x 5 columns]
2025-06-13 17:50:53,790 - IOOppi_data - INFO : save diff data to db: IOOppi_CF_t: no diff data
2025-06-13 17:50:53,796 - IOOppi_data - INFO : save data to db IOOppi_CF_g data:
date value
3774 2025-06-09 14623.00
3775 2025-06-10 14623.00
3776 2025-06-11 14783.00
3777 2025-06-12 14848.67
3778 2025-06-13 14831.17
2025-06-13 17:50:53,870 - IOOppi_data - INFO : save new data to db IOOppi_CF_g: date ... updated_at
3781 2025-06-12 ... 2025-06-13 17:50:53.864132
3782 2025-06-13 ... 2025-06-13 17:50:53.864132
[2 rows x 5 columns]
2025-06-13 17:50:53,889 - IOOppi_data - INFO : save diff data to db: IOOppi_CF_g: no diff data
/usr/local/lib/python3.10/site-packages/urllib3/connectionpool.py:1056: InsecureRequestWarning: Unverified HTTPS request is being made to host 'www.100ppi.com'. Adding certificate verification is strongly advised. See: https://urllib3.readthedocs.io/en/1.26.x/advanced-usage.html#ssl-warnings
warnings.warn(
2025-06-13 17:50:54,444 - IOOppi_data - INFO : save data to db IOOppi_pb_t data:
date value
3719 2025-06-09 16593.75
3720 2025-06-10 16706.25
3721 2025-06-11 16712.50
3722 2025-06-12 16768.75
3723 2025-06-13 16850.00
2025-06-13 17:50:54,519 - IOOppi_data - INFO : save new data to db IOOppi_pb_t: date ... updated_at
3722 2025-06-12 ... 2025-06-13 17:50:54.512959
3723 2025-06-13 ... 2025-06-13 17:50:54.512959
[2 rows x 5 columns]
2025-06-13 17:50:54,537 - IOOppi_data - INFO : save diff data to db: IOOppi_pb_t: no diff data
2025-06-13 17:50:54,543 - IOOppi_data - INFO : save data to db IOOppi_pb_g data:
date value
3719 2025-06-09 16593.75
3720 2025-06-10 16706.25
3721 2025-06-11 16712.50
3722 2025-06-12 16768.75
3723 2025-06-13 16850.00
2025-06-13 17:50:54,614 - IOOppi_data - INFO : save new data to db IOOppi_pb_g: date ... updated_at
3725 2025-06-12 ... 2025-06-13 17:50:54.607834
3726 2025-06-13 ... 2025-06-13 17:50:54.607834
[2 rows x 5 columns]
2025-06-13 17:50:54,633 - IOOppi_data - INFO : save diff data to db: IOOppi_pb_g: no diff data
/usr/local/lib/python3.10/site-packages/urllib3/connectionpool.py:1056: InsecureRequestWarning: Unverified HTTPS request is being made to host 'www.100ppi.com'. Adding certificate verification is strongly advised. See: https://urllib3.readthedocs.io/en/1.26.x/advanced-usage.html#ssl-warnings
warnings.warn(
2025-06-13 17:50:55,202 - IOOppi_data - INFO : save data to db IOOppi_hc_t data:
date value
2994 2025-06-09 3170.00
2995 2025-06-10 3173.33
2996 2025-06-11 3173.33
2997 2025-06-12 3176.67
2998 2025-06-13 3166.67
2025-06-13 17:50:55,264 - IOOppi_data - INFO : save new data to db IOOppi_hc_t: date value ... created_at updated_at
2997 2025-06-12 3176.67 ... 2025-06-13 17:50:55.256859 2025-06-13 17:50:55.257249
2998 2025-06-13 3166.67 ... 2025-06-13 17:50:55.256859 2025-06-13 17:50:55.257249
[2 rows x 5 columns]
2025-06-13 17:50:55,282 - IOOppi_data - INFO : save diff data to db: IOOppi_hc_t: no diff data
2025-06-13 17:50:55,291 - IOOppi_data - INFO : save data to db IOOppi_hc_g data:
date value
2994 2025-06-09 3170.00
2995 2025-06-10 3173.33
2996 2025-06-11 3173.33
2997 2025-06-12 3176.67
2998 2025-06-13 3166.67
2025-06-13 17:50:55,353 - IOOppi_data - INFO : save new data to db IOOppi_hc_g: date value ... created_at updated_at
3000 2025-06-12 3176.67 ... 2025-06-13 17:50:55.346321 2025-06-13 17:50:55.346704
3001 2025-06-13 3166.67 ... 2025-06-13 17:50:55.346321 2025-06-13 17:50:55.346704
[2 rows x 5 columns]
2025-06-13 17:50:55,371 - IOOppi_data - INFO : save diff data to db: IOOppi_hc_g: no diff data
/usr/local/lib/python3.10/site-packages/urllib3/connectionpool.py:1056: InsecureRequestWarning: Unverified HTTPS request is being made to host 'www.100ppi.com'. Adding certificate verification is strongly advised. See: https://urllib3.readthedocs.io/en/1.26.x/advanced-usage.html#ssl-warnings
warnings.warn(
2025-06-13 17:50:55,942 - IOOppi_data - INFO : save data to db IOOppi_fu_t data:
date value
3274 2025-06-09 5275.0
3275 2025-06-10 5275.0
3276 2025-06-11 5275.0
3277 2025-06-12 5287.5
3278 2025-06-13 5350.0
2025-06-13 17:50:56,007 - IOOppi_data - INFO : save new data to db IOOppi_fu_t: date value ... created_at updated_at
3277 2025-06-12 5287.5 ... 2025-06-13 17:50:56.000371 2025-06-13 17:50:56.000779
3278 2025-06-13 5350.0 ... 2025-06-13 17:50:56.000371 2025-06-13 17:50:56.000779
[2 rows x 5 columns]
2025-06-13 17:50:56,026 - IOOppi_data - INFO : save diff data to db: IOOppi_fu_t: no diff data
2025-06-13 17:50:56,032 - IOOppi_data - INFO : save data to db IOOppi_fu_g data:
date value
3274 2025-06-09 5275.0
3275 2025-06-10 5275.0
3276 2025-06-11 5275.0
3277 2025-06-12 5287.5
3278 2025-06-13 5350.0
2025-06-13 17:50:56,105 - IOOppi_data - INFO : save new data to db IOOppi_fu_g: date value ... created_at updated_at
3764 2025-06-12 5287.5 ... 2025-06-13 17:50:56.097879 2025-06-13 17:50:56.098283
3765 2025-06-13 5350.0 ... 2025-06-13 17:50:56.097879 2025-06-13 17:50:56.098283
[2 rows x 5 columns]
2025-06-13 17:50:56,124 - IOOppi_data - INFO : save diff data to db: IOOppi_fu_g: no diff data
/usr/local/lib/python3.10/site-packages/urllib3/connectionpool.py:1056: InsecureRequestWarning: Unverified HTTPS request is being made to host 'www.100ppi.com'. Adding certificate verification is strongly advised. See: https://urllib3.readthedocs.io/en/1.26.x/advanced-usage.html#ssl-warnings
warnings.warn(
2025-06-13 17:50:56,617 - IOOppi_data - INFO : save data to db IOOppi_lh_t data:
date value
1338 2025-06-09 14270.0
1339 2025-06-10 14250.0
1340 2025-06-11 14150.0
1341 2025-06-12 14120.0
1342 2025-06-13 14120.0
2025-06-13 17:50:56,660 - IOOppi_data - INFO : save new data to db IOOppi_lh_t: date value ... created_at updated_at
1341 2025-06-12 14120.0 ... 2025-06-13 17:50:56.653534 2025-06-13 17:50:56.653945
1342 2025-06-13 14120.0 ... 2025-06-13 17:50:56.653534 2025-06-13 17:50:56.653945
[2 rows x 5 columns]
/root/project/IOOppi_data/IOOppi_request.py:308: SettingWithCopyWarning:
A value is trying to be set on a copy of a slice from a DataFrame.
Try using .loc[row_indexer,col_indexer] = value instead
See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy
diff_df.loc[:, 'index_code'] = index_code
/root/project/IOOppi_data/IOOppi_request.py:309: SettingWithCopyWarning:
A value is trying to be set on a copy of a slice from a DataFrame.
Try using .loc[row_indexer,col_indexer] = value instead
See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy
diff_df.loc[:, 'created_at'] = datetime.datetime.now()
/root/project/IOOppi_data/IOOppi_request.py:310: SettingWithCopyWarning:
A value is trying to be set on a copy of a slice from a DataFrame.
Try using .loc[row_indexer,col_indexer] = value instead
See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy
diff_df.loc[:, 'updated_at'] = datetime.datetime.now()
2025-06-13 17:50:56,892 - IOOppi_data - INFO : save diff data to db IOOppi_lh_t: date ... updated_at
116 2021-07-05 ... 2025-06-13 17:50:56.883507
117 2021-07-06 ... 2025-06-13 17:50:56.883507
121 2021-07-12 ... 2025-06-13 17:50:56.883507
122 2021-07-13 ... 2025-06-13 17:50:56.883507
194 2021-11-01 ... 2025-06-13 17:50:56.883507
[5 rows x 6 columns]
2025-06-13 17:50:56,929 - IOOppi_data - INFO : save data to db IOOppi_lh_g data:
date value
1338 2025-06-09 14270.0
1339 2025-06-10 14250.0
1340 2025-06-11 14150.0
1341 2025-06-12 14120.0
1342 2025-06-13 14120.0
2025-06-13 17:50:56,971 - IOOppi_data - INFO : save new data to db IOOppi_lh_g: date value ... created_at updated_at
1344 2025-06-12 14120.0 ... 2025-06-13 17:50:56.964661 2025-06-13 17:50:56.965071
1345 2025-06-13 14120.0 ... 2025-06-13 17:50:56.964661 2025-06-13 17:50:56.965071
[2 rows x 5 columns]
/root/project/IOOppi_data/IOOppi_request.py:308: SettingWithCopyWarning:
A value is trying to be set on a copy of a slice from a DataFrame.
Try using .loc[row_indexer,col_indexer] = value instead
See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy
diff_df.loc[:, 'index_code'] = index_code
/root/project/IOOppi_data/IOOppi_request.py:309: SettingWithCopyWarning:
A value is trying to be set on a copy of a slice from a DataFrame.
Try using .loc[row_indexer,col_indexer] = value instead
See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy
diff_df.loc[:, 'created_at'] = datetime.datetime.now()
/root/project/IOOppi_data/IOOppi_request.py:310: SettingWithCopyWarning:
A value is trying to be set on a copy of a slice from a DataFrame.
Try using .loc[row_indexer,col_indexer] = value instead
See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy
diff_df.loc[:, 'updated_at'] = datetime.datetime.now()
2025-06-13 17:50:57,202 - IOOppi_data - INFO : save diff data to db IOOppi_lh_g: date ... updated_at
116 2021-07-05 ... 2025-06-13 17:50:57.193955
117 2021-07-06 ... 2025-06-13 17:50:57.193955
121 2021-07-12 ... 2025-06-13 17:50:57.193955
122 2021-07-13 ... 2025-06-13 17:50:57.193955
194 2021-11-01 ... 2025-06-13 17:50:57.193955
[5 rows x 6 columns]
/usr/local/lib/python3.10/site-packages/urllib3/connectionpool.py:1056: InsecureRequestWarning: Unverified HTTPS request is being made to host 'www.100ppi.com'. Adding certificate verification is strongly advised. See: https://urllib3.readthedocs.io/en/1.26.x/advanced-usage.html#ssl-warnings
warnings.warn(
2025-06-13 17:50:57,830 - IOOppi_data - INFO : save data to db IOOppi_cu_t data:
date value
3770 2025-06-09 78891.67
3771 2025-06-10 79293.33
3772 2025-06-11 79341.67
3773 2025-06-12 79101.67
3774 2025-06-13 78933.33
2025-06-13 17:50:57,901 - IOOppi_data - INFO : save new data to db IOOppi_cu_t: date ... updated_at
3773 2025-06-12 ... 2025-06-13 17:50:57.895160
3774 2025-06-13 ... 2025-06-13 17:50:57.895160
[2 rows x 5 columns]
2025-06-13 17:50:57,920 - IOOppi_data - INFO : save diff data to db: IOOppi_cu_t: no diff data
2025-06-13 17:50:57,926 - IOOppi_data - INFO : save data to db IOOppi_cu_g data:
date value
3770 2025-06-09 78891.67
3771 2025-06-10 79293.33
3772 2025-06-11 79341.67
3773 2025-06-12 79101.67
3774 2025-06-13 78933.33
2025-06-13 17:50:57,996 - IOOppi_data - INFO : save new data to db IOOppi_cu_g: date ... updated_at
3776 2025-06-12 ... 2025-06-13 17:50:57.990337
3777 2025-06-13 ... 2025-06-13 17:50:57.990337
[2 rows x 5 columns]
2025-06-13 17:50:58,015 - IOOppi_data - INFO : save diff data to db: IOOppi_cu_g: no diff data
/usr/local/lib/python3.10/site-packages/urllib3/connectionpool.py:1056: InsecureRequestWarning: Unverified HTTPS request is being made to host 'www.100ppi.com'. Adding certificate verification is strongly advised. See: https://urllib3.readthedocs.io/en/1.26.x/advanced-usage.html#ssl-warnings
warnings.warn(
2025-06-13 17:50:58,672 - IOOppi_data - INFO : save data to db IOOppi_PM_t data:
date value
2947 2024-06-26 2440.0
2948 2024-06-27 2460.0
2949 2024-06-28 2460.0
2950 2024-06-29 2460.0
2951 2024-06-30 2460.0
2025-06-13 17:50:58,725 - IOOppi_data - INFO : save new data to db: IOOppi_PM_t: no new data
2025-06-13 17:50:58,725 - IOOppi_data - INFO : save diff data to db: IOOppi_PM_t: no diff data
2025-06-13 17:50:58,731 - IOOppi_data - INFO : save data to db IOOppi_PM_g data:
date value
2947 2024-06-26 2440.0
2948 2024-06-27 2460.0
2949 2024-06-28 2460.0
2950 2024-06-29 2460.0
2951 2024-06-30 2460.0
2025-06-13 17:50:58,791 - IOOppi_data - INFO : save new data to db: IOOppi_PM_g: no new data
2025-06-13 17:50:58,791 - IOOppi_data - INFO : save diff data to db: IOOppi_PM_g: no diff data
/usr/local/lib/python3.10/site-packages/urllib3/connectionpool.py:1056: InsecureRequestWarning: Unverified HTTPS request is being made to host 'www.100ppi.com'. Adding certificate verification is strongly advised. See: https://urllib3.readthedocs.io/en/1.26.x/advanced-usage.html#ssl-warnings
warnings.warn(
2025-06-13 17:50:59,378 - IOOppi_data - INFO : save data to db IOOppi_sn_t data:
date value
2748 2025-06-09 263900.0
2749 2025-06-10 264850.0
2750 2025-06-11 265850.0
2751 2025-06-12 265225.0
2752 2025-06-13 265562.5
2025-06-13 17:50:59,439 - IOOppi_data - INFO : save new data to db IOOppi_sn_t: date ... updated_at
2751 2025-06-12 ... 2025-06-13 17:50:59.433276
2752 2025-06-13 ... 2025-06-13 17:50:59.433276
[2 rows x 5 columns]
2025-06-13 17:50:59,458 - IOOppi_data - INFO : save diff data to db: IOOppi_sn_t: no diff data
2025-06-13 17:50:59,465 - IOOppi_data - INFO : save data to db IOOppi_sn_g data:
date value
2748 2025-06-09 263900.0
2749 2025-06-10 264850.0
2750 2025-06-11 265850.0
2751 2025-06-12 265225.0
2752 2025-06-13 265562.5
2025-06-13 17:50:59,526 - IOOppi_data - INFO : save new data to db IOOppi_sn_g: date ... updated_at
2754 2025-06-12 ... 2025-06-13 17:50:59.519897
2755 2025-06-13 ... 2025-06-13 17:50:59.519897
[2 rows x 5 columns]
2025-06-13 17:50:59,545 - IOOppi_data - INFO : save diff data to db: IOOppi_sn_g: no diff data
/usr/local/lib/python3.10/site-packages/urllib3/connectionpool.py:1056: InsecureRequestWarning: Unverified HTTPS request is being made to host 'www.100ppi.com'. Adding certificate verification is strongly advised. See: https://urllib3.readthedocs.io/en/1.26.x/advanced-usage.html#ssl-warnings
warnings.warn(
2025-06-13 17:51:00,116 - IOOppi_data - INFO : save data to db IOOppi_zn_t data:
date value
3769 2025-06-09 22582.0
3770 2025-06-10 22146.0
3771 2025-06-11 22294.0
3772 2025-06-12 22304.0
3773 2025-06-13 22246.0
2025-06-13 17:51:00,189 - IOOppi_data - INFO : save new data to db IOOppi_zn_t: date value ... created_at updated_at
3772 2025-06-12 22304.0 ... 2025-06-13 17:51:00.181721 2025-06-13 17:51:00.182141
3773 2025-06-13 22246.0 ... 2025-06-13 17:51:00.181721 2025-06-13 17:51:00.182141
[2 rows x 5 columns]
2025-06-13 17:51:00,207 - IOOppi_data - INFO : save diff data to db: IOOppi_zn_t: no diff data
2025-06-13 17:51:00,213 - IOOppi_data - INFO : save data to db IOOppi_zn_g data:
date value
3769 2025-06-09 22582.0
3770 2025-06-10 22146.0
3771 2025-06-11 22294.0
3772 2025-06-12 22304.0
3773 2025-06-13 22246.0
2025-06-13 17:51:00,286 - IOOppi_data - INFO : save new data to db IOOppi_zn_g: date value ... created_at updated_at
3775 2025-06-12 22304.0 ... 2025-06-13 17:51:00.279473 2025-06-13 17:51:00.279877
3776 2025-06-13 22246.0 ... 2025-06-13 17:51:00.279473 2025-06-13 17:51:00.279877
[2 rows x 5 columns]
2025-06-13 17:51:00,305 - IOOppi_data - INFO : save diff data to db: IOOppi_zn_g: no diff data
/usr/local/lib/python3.10/site-packages/urllib3/connectionpool.py:1056: InsecureRequestWarning: Unverified HTTPS request is being made to host 'www.100ppi.com'. Adding certificate verification is strongly advised. See: https://urllib3.readthedocs.io/en/1.26.x/advanced-usage.html#ssl-warnings
warnings.warn(
2025-06-13 17:51:00,992 - IOOppi_data - INFO : save data to db IOOppi_wr_t data:
date value
3732 2025-06-09 3260.0
3733 2025-06-10 3267.5
3734 2025-06-11 3267.5
3735 2025-06-12 3257.5
3736 2025-06-13 3237.5
2025-06-13 17:51:01,065 - IOOppi_data - INFO : save new data to db IOOppi_wr_t: date value ... created_at updated_at
3735 2025-06-12 3257.5 ... 2025-06-13 17:51:01.057498 2025-06-13 17:51:01.057973
3736 2025-06-13 3237.5 ... 2025-06-13 17:51:01.057498 2025-06-13 17:51:01.057973
[2 rows x 5 columns]
2025-06-13 17:51:01,086 - IOOppi_data - INFO : save diff data to db: IOOppi_wr_t: no diff data
2025-06-13 17:51:01,093 - IOOppi_data - INFO : save data to db IOOppi_wr_g data:
date value
3732 2025-06-09 3260.0
3733 2025-06-10 3267.5
3734 2025-06-11 3267.5
3735 2025-06-12 3257.5
3736 2025-06-13 3237.5
2025-06-13 17:51:01,170 - IOOppi_data - INFO : save new data to db IOOppi_wr_g: date value ... created_at updated_at
3738 2025-06-12 3257.5 ... 2025-06-13 17:51:01.162151 2025-06-13 17:51:01.162545
3739 2025-06-13 3237.5 ... 2025-06-13 17:51:01.162151 2025-06-13 17:51:01.162545
[2 rows x 5 columns]
2025-06-13 17:51:01,189 - IOOppi_data - INFO : save diff data to db: IOOppi_wr_g: no diff data
/usr/local/lib/python3.10/site-packages/urllib3/connectionpool.py:1056: InsecureRequestWarning: Unverified HTTPS request is being made to host 'www.100ppi.com'. Adding certificate verification is strongly advised. See: https://urllib3.readthedocs.io/en/1.26.x/advanced-usage.html#ssl-warnings
warnings.warn(
2025-06-13 17:51:01,731 - IOOppi_data - INFO : save data to db IOOppi_pg_t data:
date value
1529 2025-06-09 4782.5
1530 2025-06-10 4772.5
1531 2025-06-11 4797.5
1532 2025-06-12 4797.5
1533 2025-06-13 4822.5
2025-06-13 17:51:01,775 - IOOppi_data - INFO : save new data to db IOOppi_pg_t: date value ... created_at updated_at
1532 2025-06-12 4797.5 ... 2025-06-13 17:51:01.767833 2025-06-13 17:51:01.768243
1533 2025-06-13 4822.5 ... 2025-06-13 17:51:01.767833 2025-06-13 17:51:01.768243
[2 rows x 5 columns]
2025-06-13 17:51:01,794 - IOOppi_data - INFO : save diff data to db: IOOppi_pg_t: no diff data
2025-06-13 17:51:01,800 - IOOppi_data - INFO : save data to db IOOppi_pg_g data:
date value
1529 2025-06-09 4782.5
1530 2025-06-10 4772.5
1531 2025-06-11 4797.5
1532 2025-06-12 4797.5
1533 2025-06-13 4822.5
2025-06-13 17:51:01,845 - IOOppi_data - INFO : save new data to db IOOppi_pg_g: date value ... created_at updated_at
1535 2025-06-12 4797.5 ... 2025-06-13 17:51:01.838043 2025-06-13 17:51:01.838447
1536 2025-06-13 4822.5 ... 2025-06-13 17:51:01.838043 2025-06-13 17:51:01.838447
[2 rows x 5 columns]
2025-06-13 17:51:01,865 - IOOppi_data - INFO : save diff data to db: IOOppi_pg_g: no diff data
/usr/local/lib/python3.10/site-packages/urllib3/connectionpool.py:1056: InsecureRequestWarning: Unverified HTTPS request is being made to host 'www.100ppi.com'. Adding certificate verification is strongly advised. See: https://urllib3.readthedocs.io/en/1.26.x/advanced-usage.html#ssl-warnings
warnings.warn(
2025-06-13 17:51:02,402 - IOOppi_data - INFO : save data to db IOOppi_cs_t data:
date value
2803 2025-06-09 2300.00
2804 2025-06-10 2308.57
2805 2025-06-11 2318.57
2806 2025-06-12 2330.00
2807 2025-06-13 2334.29
2025-06-13 17:51:02,463 - IOOppi_data - INFO : save new data to db IOOppi_cs_t: date value ... created_at updated_at
2806 2025-06-12 2330.00 ... 2025-06-13 17:51:02.456148 2025-06-13 17:51:02.456538
2807 2025-06-13 2334.29 ... 2025-06-13 17:51:02.456148 2025-06-13 17:51:02.456538
[2 rows x 5 columns]
/root/project/IOOppi_data/IOOppi_request.py:308: SettingWithCopyWarning:
A value is trying to be set on a copy of a slice from a DataFrame.
Try using .loc[row_indexer,col_indexer] = value instead
See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy
diff_df.loc[:, 'index_code'] = index_code
/root/project/IOOppi_data/IOOppi_request.py:309: SettingWithCopyWarning:
A value is trying to be set on a copy of a slice from a DataFrame.
Try using .loc[row_indexer,col_indexer] = value instead
See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy
diff_df.loc[:, 'created_at'] = datetime.datetime.now()
/root/project/IOOppi_data/IOOppi_request.py:310: SettingWithCopyWarning:
A value is trying to be set on a copy of a slice from a DataFrame.
Try using .loc[row_indexer,col_indexer] = value instead
See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy
diff_df.loc[:, 'updated_at'] = datetime.datetime.now()
2025-06-13 17:51:02,504 - IOOppi_data - INFO : save diff data to db IOOppi_cs_t: date ... updated_at
2805 2025-06-11 ... 2025-06-13 17:51:02.497387
[1 rows x 6 columns]
2025-06-13 17:51:02,529 - IOOppi_data - INFO : save data to db IOOppi_cs_g data:
date value
2803 2025-06-09 2300.00
2804 2025-06-10 2308.57
2805 2025-06-11 2318.57
2806 2025-06-12 2330.00
2807 2025-06-13 2334.29
2025-06-13 17:51:02,590 - IOOppi_data - INFO : save new data to db IOOppi_cs_g: date value ... created_at updated_at
2809 2025-06-12 2330.00 ... 2025-06-13 17:51:02.582661 2025-06-13 17:51:02.583076
2810 2025-06-13 2334.29 ... 2025-06-13 17:51:02.582661 2025-06-13 17:51:02.583076
[2 rows x 5 columns]
/root/project/IOOppi_data/IOOppi_request.py:308: SettingWithCopyWarning:
A value is trying to be set on a copy of a slice from a DataFrame.
Try using .loc[row_indexer,col_indexer] = value instead
See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy
diff_df.loc[:, 'index_code'] = index_code
/root/project/IOOppi_data/IOOppi_request.py:309: SettingWithCopyWarning:
A value is trying to be set on a copy of a slice from a DataFrame.
Try using .loc[row_indexer,col_indexer] = value instead
See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy
diff_df.loc[:, 'created_at'] = datetime.datetime.now()
/root/project/IOOppi_data/IOOppi_request.py:310: SettingWithCopyWarning:
A value is trying to be set on a copy of a slice from a DataFrame.
Try using .loc[row_indexer,col_indexer] = value instead
See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy
diff_df.loc[:, 'updated_at'] = datetime.datetime.now()
2025-06-13 17:51:02,630 - IOOppi_data - INFO : save diff data to db IOOppi_cs_g: date ... updated_at
2808 2025-06-11 ... 2025-06-13 17:51:02.623598
[1 rows x 6 columns]
/usr/local/lib/python3.10/site-packages/urllib3/connectionpool.py:1056: InsecureRequestWarning: Unverified HTTPS request is being made to host 'www.100ppi.com'. Adding certificate verification is strongly advised. See: https://urllib3.readthedocs.io/en/1.26.x/advanced-usage.html#ssl-warnings
warnings.warn(
2025-06-13 17:51:03,321 - IOOppi_data - INFO : save data to db IOOppi_cs_t data:
date value
2803 2025-06-09 2300.00
2804 2025-06-10 2308.57
2805 2025-06-11 2318.57
2806 2025-06-12 2330.00
2807 2025-06-13 2910.00
2025-06-13 17:51:03,372 - IOOppi_data - INFO : save new data to db: IOOppi_cs_t: no new data
/root/project/IOOppi_data/IOOppi_request.py:308: SettingWithCopyWarning:
A value is trying to be set on a copy of a slice from a DataFrame.
Try using .loc[row_indexer,col_indexer] = value instead
See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy
diff_df.loc[:, 'index_code'] = index_code
/root/project/IOOppi_data/IOOppi_request.py:309: SettingWithCopyWarning:
A value is trying to be set on a copy of a slice from a DataFrame.
Try using .loc[row_indexer,col_indexer] = value instead
See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy
diff_df.loc[:, 'created_at'] = datetime.datetime.now()
/root/project/IOOppi_data/IOOppi_request.py:310: SettingWithCopyWarning:
A value is trying to be set on a copy of a slice from a DataFrame.
Try using .loc[row_indexer,col_indexer] = value instead
See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy
diff_df.loc[:, 'updated_at'] = datetime.datetime.now()
2025-06-13 17:51:03,394 - IOOppi_data - INFO : save diff data to db IOOppi_cs_t: date ... updated_at
2807 2025-06-13 ... 2025-06-13 17:51:03.387371
[1 rows x 6 columns]
2025-06-13 17:51:03,420 - IOOppi_data - INFO : save data to db IOOppi_cs_g data:
date value
2803 2025-06-09 2300.00
2804 2025-06-10 2308.57
2805 2025-06-11 2318.57
2806 2025-06-12 2330.00
2807 2025-06-13 2910.00
2025-06-13 17:51:03,474 - IOOppi_data - INFO : save new data to db: IOOppi_cs_g: no new data
/root/project/IOOppi_data/IOOppi_request.py:308: SettingWithCopyWarning:
A value is trying to be set on a copy of a slice from a DataFrame.
Try using .loc[row_indexer,col_indexer] = value instead
See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy
diff_df.loc[:, 'index_code'] = index_code
/root/project/IOOppi_data/IOOppi_request.py:309: SettingWithCopyWarning:
A value is trying to be set on a copy of a slice from a DataFrame.
Try using .loc[row_indexer,col_indexer] = value instead
See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy
diff_df.loc[:, 'created_at'] = datetime.datetime.now()
/root/project/IOOppi_data/IOOppi_request.py:310: SettingWithCopyWarning:
A value is trying to be set on a copy of a slice from a DataFrame.
Try using .loc[row_indexer,col_indexer] = value instead
See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy
diff_df.loc[:, 'updated_at'] = datetime.datetime.now()
2025-06-13 17:51:03,498 - IOOppi_data - INFO : save diff data to db IOOppi_cs_g: date ... updated_at
2810 2025-06-13 ... 2025-06-13 17:51:03.490532
[1 rows x 6 columns]
/usr/local/lib/python3.10/site-packages/urllib3/connectionpool.py:1056: InsecureRequestWarning: Unverified HTTPS request is being made to host 'www.100ppi.com'. Adding certificate verification is strongly advised. See: https://urllib3.readthedocs.io/en/1.26.x/advanced-usage.html#ssl-warnings
warnings.warn(
2025-06-13 17:51:04,029 - IOOppi_data - INFO : save data to db IOOppi_RS_t data:
date value
3160 2025-06-09 9331.67
3161 2025-06-10 9345.00
3162 2025-06-11 9303.33
3163 2025-06-12 9333.33
3164 2025-06-13 9473.33
2025-06-13 17:51:04,086 - IOOppi_data - INFO : save new data to db: IOOppi_RS_t: no new data
2025-06-13 17:51:04,086 - IOOppi_data - INFO : save diff data to db: IOOppi_RS_t: no diff data
2025-06-13 17:51:04,091 - IOOppi_data - INFO : save data to db IOOppi_RS_g data:
date value
3160 2025-06-09 9331.67
3161 2025-06-10 9345.00
3162 2025-06-11 9303.33
3163 2025-06-12 9333.33
3164 2025-06-13 9473.33
2025-06-13 17:51:04,148 - IOOppi_data - INFO : save new data to db: IOOppi_RS_g: no new data
2025-06-13 17:51:04,149 - IOOppi_data - INFO : save diff data to db: IOOppi_RS_g: no diff data
/usr/local/lib/python3.10/site-packages/urllib3/connectionpool.py:1056: InsecureRequestWarning: Unverified HTTPS request is being made to host 'www.100ppi.com'. Adding certificate verification is strongly advised. See: https://urllib3.readthedocs.io/en/1.26.x/advanced-usage.html#ssl-warnings
warnings.warn(
2025-06-13 17:51:04,686 - IOOppi_data - INFO : save data to db IOOppi_eg_t data:
date value
1844 2025-06-09 4498.33
1845 2025-06-10 4490.00
1846 2025-06-11 4490.00
1847 2025-06-12 4488.33
1848 2025-06-13 4535.00
2025-06-13 17:51:04,735 - IOOppi_data - INFO : save new data to db IOOppi_eg_t: date value ... created_at updated_at
1847 2025-06-12 4488.33 ... 2025-06-13 17:51:04.727768 2025-06-13 17:51:04.728213
1848 2025-06-13 4535.00 ... 2025-06-13 17:51:04.727768 2025-06-13 17:51:04.728213
[2 rows x 5 columns]
2025-06-13 17:51:04,754 - IOOppi_data - INFO : save diff data to db: IOOppi_eg_t: no diff data
2025-06-13 17:51:04,759 - IOOppi_data - INFO : save data to db IOOppi_eg_g data:
date value
1844 2025-06-09 4498.33
1845 2025-06-10 4490.00
1846 2025-06-11 4490.00
1847 2025-06-12 4488.33
1848 2025-06-13 4535.00
2025-06-13 17:51:04,809 - IOOppi_data - INFO : save new data to db IOOppi_eg_g: date value ... created_at updated_at
1850 2025-06-12 4488.33 ... 2025-06-13 17:51:04.801597 2025-06-13 17:51:04.802040
1851 2025-06-13 4535.00 ... 2025-06-13 17:51:04.801597 2025-06-13 17:51:04.802040
[2 rows x 5 columns]
2025-06-13 17:51:04,827 - IOOppi_data - INFO : save diff data to db: IOOppi_eg_g: no diff data
/usr/local/lib/python3.10/site-packages/urllib3/connectionpool.py:1056: InsecureRequestWarning: Unverified HTTPS request is being made to host 'www.100ppi.com'. Adding certificate verification is strongly advised. See: https://urllib3.readthedocs.io/en/1.26.x/advanced-usage.html#ssl-warnings
warnings.warn(
2025-06-13 17:51:05,365 - IOOppi_data - INFO : save data to db IOOppi_sp_t data:
date value
1853 2025-06-09 6216.67
1854 2025-06-10 6216.67
1855 2025-06-11 6216.67
1856 2025-06-12 6216.67
1857 2025-06-13 6183.33
2025-06-13 17:51:05,414 - IOOppi_data - INFO : save new data to db IOOppi_sp_t: date value ... created_at updated_at
1856 2025-06-12 6216.67 ... 2025-06-13 17:51:05.407176 2025-06-13 17:51:05.407568
1857 2025-06-13 6183.33 ... 2025-06-13 17:51:05.407176 2025-06-13 17:51:05.407568
[2 rows x 5 columns]
2025-06-13 17:51:05,432 - IOOppi_data - INFO : save diff data to db: IOOppi_sp_t: no diff data
2025-06-13 17:51:05,438 - IOOppi_data - INFO : save data to db IOOppi_sp_g data:
date value
1853 2025-06-09 6216.67
1854 2025-06-10 6216.67
1855 2025-06-11 6216.67
1856 2025-06-12 6216.67
1857 2025-06-13 6183.33
2025-06-13 17:51:05,487 - IOOppi_data - INFO : save new data to db IOOppi_sp_g: date value ... created_at updated_at
1859 2025-06-12 6216.67 ... 2025-06-13 17:51:05.479876 2025-06-13 17:51:05.480279
1860 2025-06-13 6183.33 ... 2025-06-13 17:51:05.479876 2025-06-13 17:51:05.480279
[2 rows x 5 columns]
2025-06-13 17:51:05,506 - IOOppi_data - INFO : save diff data to db: IOOppi_sp_g: no diff data
/usr/local/lib/python3.10/site-packages/urllib3/connectionpool.py:1056: InsecureRequestWarning: Unverified HTTPS request is being made to host 'www.100ppi.com'. Adding certificate verification is strongly advised. See: https://urllib3.readthedocs.io/en/1.26.x/advanced-usage.html#ssl-warnings
warnings.warn(
2025-06-13 17:51:06,158 - IOOppi_data - INFO : save data to db IOOppi_p_t data:
date value
3521 2025-06-09 8644.0
3522 2025-06-10 8630.0
3523 2025-06-11 8452.0
3524 2025-06-12 8424.0
3525 2025-06-13 8528.0
2025-06-13 17:51:06,228 - IOOppi_data - INFO : save new data to db IOOppi_p_t: date value ... created_at updated_at
3524 2025-06-12 8424.0 ... 2025-06-13 17:51:06.220651 2025-06-13 17:51:06.221079
3525 2025-06-13 8528.0 ... 2025-06-13 17:51:06.220651 2025-06-13 17:51:06.221079
[2 rows x 5 columns]
2025-06-13 17:51:06,249 - IOOppi_data - INFO : save diff data to db: IOOppi_p_t: no diff data
2025-06-13 17:51:06,255 - IOOppi_data - INFO : save data to db IOOppi_p_g data:
date value
3521 2025-06-09 8644.0
3522 2025-06-10 8630.0
3523 2025-06-11 8452.0
3524 2025-06-12 8424.0
3525 2025-06-13 8528.0
2025-06-13 17:51:06,324 - IOOppi_data - INFO : save new data to db IOOppi_p_g: date value ... created_at updated_at
3527 2025-06-12 8424.0 ... 2025-06-13 17:51:06.317018 2025-06-13 17:51:06.317408
3528 2025-06-13 8528.0 ... 2025-06-13 17:51:06.317018 2025-06-13 17:51:06.317408
[2 rows x 5 columns]
2025-06-13 17:51:06,342 - IOOppi_data - INFO : save diff data to db: IOOppi_p_g: no diff data