=========================================================================
2025-05-22 17:50:26 Thu 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-05-22 17:50:29,037 - IOOppi_data - INFO : save data to db IOOppi_rb_t data:
date value
3307 2025-05-18 3184.22
3308 2025-05-19 3158.22
3309 2025-05-20 3158.78
3310 2025-05-21 3154.44
3311 2025-05-22 3146.78
2025-05-22 17:50:29,147 - IOOppi_data - INFO : save new data to db IOOppi_rb_t: date value ... created_at updated_at
3311 2025-05-22 3146.78 ... 2025-05-22 17:50:29.139699 2025-05-22 17:50:29.140128
[1 rows x 5 columns]
2025-05-22 17:50:29,168 - IOOppi_data - INFO : save diff data to db: IOOppi_rb_t: no diff data
2025-05-22 17:50:29,173 - IOOppi_data - INFO : save data to db IOOppi_rb_g data:
date value
3307 2025-05-18 3184.22
3308 2025-05-19 3158.22
3309 2025-05-20 3158.78
3310 2025-05-21 3154.44
3311 2025-05-22 3146.78
2025-05-22 17:50:29,245 - IOOppi_data - INFO : save new data to db IOOppi_rb_g: date value ... created_at updated_at
3314 2025-05-22 3146.78 ... 2025-05-22 17:50:29.238227 2025-05-22 17:50:29.238647
[1 rows x 5 columns]
2025-05-22 17:50:29,265 - 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-05-22 17:50:29,822 - IOOppi_data - INFO : save data to db IOOppi_MA_t data:
date value
3528 2025-05-18 2426.25
3529 2025-05-19 2362.50
3530 2025-05-20 2327.50
3531 2025-05-21 2321.25
3532 2025-05-22 2312.50
2025-05-22 17:50:29,897 - IOOppi_data - INFO : save new data to db IOOppi_MA_t: date value ... created_at updated_at
3532 2025-05-22 2312.5 ... 2025-05-22 17:50:29.890426 2025-05-22 17:50:29.890832
[1 rows x 5 columns]
2025-05-22 17:50:29,917 - IOOppi_data - INFO : save diff data to db: IOOppi_MA_t: no diff data
2025-05-22 17:50:29,923 - IOOppi_data - INFO : save data to db IOOppi_MA_g data:
date value
3528 2025-05-18 2426.25
3529 2025-05-19 2362.50
3530 2025-05-20 2327.50
3531 2025-05-21 2321.25
3532 2025-05-22 2312.50
2025-05-22 17:50:29,995 - IOOppi_data - INFO : save new data to db IOOppi_MA_g: date value ... created_at updated_at
3536 2025-05-22 2312.5 ... 2025-05-22 17:50:29.988348 2025-05-22 17:50:29.988720
[1 rows x 5 columns]
2025-05-22 17:50:30,015 - 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-05-22 17:50:30,575 - IOOppi_data - INFO : save data to db IOOppi_PTA_t data:
date value
868 2025-05-18 5007.50
869 2025-05-19 4993.75
870 2025-05-20 5001.25
871 2025-05-21 4986.25
872 2025-05-22 4913.34
2025-05-22 17:50:30,615 - IOOppi_data - INFO : save new data to db IOOppi_PTA_t: date value ... created_at updated_at
872 2025-05-22 4913.34 ... 2025-05-22 17:50:30.608005 2025-05-22 17:50:30.608429
[1 rows x 5 columns]
2025-05-22 17:50:30,635 - IOOppi_data - INFO : save diff data to db: IOOppi_PTA_t: no diff data
2025-05-22 17:50:30,640 - IOOppi_data - INFO : save data to db IOOppi_PTA_g data:
date value
868 2025-05-18 5007.50
869 2025-05-19 4993.75
870 2025-05-20 5001.25
871 2025-05-21 4986.25
872 2025-05-22 4913.34
2025-05-22 17:50:30,679 - IOOppi_data - INFO : save new data to db IOOppi_PTA_g: date value ... created_at updated_at
872 2025-05-22 4913.34 ... 2025-05-22 17:50:30.672167 2025-05-22 17:50:30.672522
[1 rows x 5 columns]
2025-05-22 17:50:30,698 - 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-05-22 17:50:31,226 - IOOppi_data - INFO : save data to db IOOppi_ru_t data:
date value
3747 2025-05-18 14658.33
3748 2025-05-19 14758.33
3749 2025-05-20 14708.33
3750 2025-05-21 14558.33
3751 2025-05-22 14578.33
2025-05-22 17:50:31,304 - IOOppi_data - INFO : save new data to db IOOppi_ru_t: date ... updated_at
3751 2025-05-22 ... 2025-05-22 17:50:31.297891
[1 rows x 5 columns]
2025-05-22 17:50:31,324 - IOOppi_data - INFO : save diff data to db: IOOppi_ru_t: no diff data
2025-05-22 17:50:31,330 - IOOppi_data - INFO : save data to db IOOppi_ru_g data:
date value
3747 2025-05-18 14658.33
3748 2025-05-19 14758.33
3749 2025-05-20 14708.33
3750 2025-05-21 14558.33
3751 2025-05-22 14578.33
2025-05-22 17:50:31,405 - IOOppi_data - INFO : save new data to db IOOppi_ru_g: date ... updated_at
3754 2025-05-22 ... 2025-05-22 17:50:31.398418
[1 rows x 5 columns]
2025-05-22 17:50:31,424 - 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-05-22 17:50:31,930 - IOOppi_data - INFO : save data to db IOOppi_i_t data:
date value
3079 2025-05-18 784.44
3080 2025-05-19 779.44
3081 2025-05-20 779.78
3082 2025-05-21 781.00
3083 2025-05-22 782.56
2025-05-22 17:50:31,996 - IOOppi_data - INFO : save new data to db IOOppi_i_t: date value ... created_at updated_at
3083 2025-05-22 782.56 ... 2025-05-22 17:50:31.989304 2025-05-22 17:50:31.989680
[1 rows x 5 columns]
2025-05-22 17:50:32,015 - IOOppi_data - INFO : save diff data to db: IOOppi_i_t: no diff data
2025-05-22 17:50:32,021 - IOOppi_data - INFO : save data to db IOOppi_i_g data:
date value
3079 2025-05-18 784.44
3080 2025-05-19 779.44
3081 2025-05-20 779.78
3082 2025-05-21 781.00
3083 2025-05-22 782.56
2025-05-22 17:50:32,086 - IOOppi_data - INFO : save new data to db IOOppi_i_g: date value ... created_at updated_at
3086 2025-05-22 782.56 ... 2025-05-22 17:50:32.079239 2025-05-22 17:50:32.079600
[1 rows x 5 columns]
2025-05-22 17:50:32,106 - 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-05-22 17:50:32,770 - IOOppi_data - INFO : save data to db IOOppi_FG_t data:
date value
3282 2025-05-18 1168.0
3283 2025-05-19 1168.0
3284 2025-05-20 1164.0
3285 2025-05-21 1148.0
3286 2025-05-22 1148.0
2025-05-22 17:50:32,839 - IOOppi_data - INFO : save new data to db IOOppi_FG_t: date value ... created_at updated_at
3286 2025-05-22 1148.0 ... 2025-05-22 17:50:32.832262 2025-05-22 17:50:32.832667
[1 rows x 5 columns]
/root/project/IOOppi_data/IOOppi_request.py:308: SettingWithCopyWarning:
A value is trying to be set on a copy of a slice from a DataFrame.
Try using .loc[row_indexer,col_indexer] = value instead
See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy
diff_df.loc[:, 'index_code'] = index_code
/root/project/IOOppi_data/IOOppi_request.py:309: SettingWithCopyWarning:
A value is trying to be set on a copy of a slice from a DataFrame.
Try using .loc[row_indexer,col_indexer] = value instead
See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy
diff_df.loc[:, 'created_at'] = datetime.datetime.now()
/root/project/IOOppi_data/IOOppi_request.py:310: SettingWithCopyWarning:
A value is trying to be set on a copy of a slice from a DataFrame.
Try using .loc[row_indexer,col_indexer] = value instead
See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy
diff_df.loc[:, 'updated_at'] = datetime.datetime.now()
2025-05-22 17:50:36,328 - IOOppi_data - INFO : save diff data to db IOOppi_FG_t: date ... updated_at
12 2012-12-19 ... 2025-05-22 17:50:36.320321
21 2013-01-04 ... 2025-05-22 17:50:36.320321
54 2013-02-27 ... 2025-05-22 17:50:36.320321
60 2013-03-07 ... 2025-05-22 17:50:36.320321
61 2013-03-08 ... 2025-05-22 17:50:36.320321
[5 rows x 6 columns]
2025-05-22 17:50:36,522 - IOOppi_data - INFO : save data to db IOOppi_FG_g data:
date value
3282 2025-05-18 1168.0
3283 2025-05-19 1168.0
3284 2025-05-20 1164.0
3285 2025-05-21 1148.0
3286 2025-05-22 1148.0
2025-05-22 17:50:36,592 - IOOppi_data - INFO : save new data to db IOOppi_FG_g: date value ... created_at updated_at
3290 2025-05-22 1148.0 ... 2025-05-22 17:50:36.585224 2025-05-22 17:50:36.585600
[1 rows x 5 columns]
/root/project/IOOppi_data/IOOppi_request.py:308: SettingWithCopyWarning:
A value is trying to be set on a copy of a slice from a DataFrame.
Try using .loc[row_indexer,col_indexer] = value instead
See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy
diff_df.loc[:, 'index_code'] = index_code
/root/project/IOOppi_data/IOOppi_request.py:309: SettingWithCopyWarning:
A value is trying to be set on a copy of a slice from a DataFrame.
Try using .loc[row_indexer,col_indexer] = value instead
See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy
diff_df.loc[:, 'created_at'] = datetime.datetime.now()
/root/project/IOOppi_data/IOOppi_request.py:310: SettingWithCopyWarning:
A value is trying to be set on a copy of a slice from a DataFrame.
Try using .loc[row_indexer,col_indexer] = value instead
See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy
diff_df.loc[:, 'updated_at'] = datetime.datetime.now()
2025-05-22 17:50:39,764 - IOOppi_data - INFO : save diff data to db IOOppi_FG_g: date ... updated_at
12 2012-12-19 ... 2025-05-22 17:50:39.757039
21 2013-01-04 ... 2025-05-22 17:50:39.757039
54 2013-02-27 ... 2025-05-22 17:50:39.757039
60 2013-03-07 ... 2025-05-22 17:50:39.757039
61 2013-03-08 ... 2025-05-22 17:50:39.757039
[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-05-22 17:50:40,467 - IOOppi_data - INFO : save data to db IOOppi_eb_t data:
date value
1627 2025-05-18 8270.0
1628 2025-05-19 8224.0
1629 2025-05-20 8220.0
1630 2025-05-21 8130.0
1631 2025-05-22 8130.0
2025-05-22 17:50:40,514 - IOOppi_data - INFO : save new data to db IOOppi_eb_t: date value ... created_at updated_at
1631 2025-05-22 8130.0 ... 2025-05-22 17:50:40.507496 2025-05-22 17:50:40.507901
[1 rows x 5 columns]
2025-05-22 17:50:40,536 - IOOppi_data - INFO : save diff data to db: IOOppi_eb_t: no diff data
2025-05-22 17:50:40,541 - IOOppi_data - INFO : save data to db IOOppi_eb_g data:
date value
1627 2025-05-18 8270.0
1628 2025-05-19 8224.0
1629 2025-05-20 8220.0
1630 2025-05-21 8130.0
1631 2025-05-22 8130.0
2025-05-22 17:50:40,591 - IOOppi_data - INFO : save new data to db IOOppi_eb_g: date value ... created_at updated_at
1634 2025-05-22 8130.0 ... 2025-05-22 17:50:40.584633 2025-05-22 17:50:40.585018
[1 rows x 5 columns]
2025-05-22 17:50:40,610 - 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-05-22 17:50:41,118 - IOOppi_data - INFO : save data to db IOOppi_SR_t data:
date value
3738 2025-05-18 6145.0
3739 2025-05-19 6145.0
3740 2025-05-20 6145.0
3741 2025-05-21 6145.0
3742 2025-05-22 6145.0
2025-05-22 17:50:41,191 - IOOppi_data - INFO : save new data to db IOOppi_SR_t: date value ... created_at updated_at
3742 2025-05-22 6145.0 ... 2025-05-22 17:50:41.183825 2025-05-22 17:50:41.184207
[1 rows x 5 columns]
2025-05-22 17:50:41,211 - IOOppi_data - INFO : save diff data to db: IOOppi_SR_t: no diff data
2025-05-22 17:50:41,217 - IOOppi_data - INFO : save data to db IOOppi_SR_g data:
date value
3738 2025-05-18 6145.0
3739 2025-05-19 6145.0
3740 2025-05-20 6145.0
3741 2025-05-21 6145.0
3742 2025-05-22 6145.0
2025-05-22 17:50:41,290 - IOOppi_data - INFO : save new data to db IOOppi_SR_g: date value ... created_at updated_at
3746 2025-05-22 6145.0 ... 2025-05-22 17:50:41.283054 2025-05-22 17:50:41.283424
[1 rows x 5 columns]
2025-05-22 17:50:41,309 - 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-05-22 17:50:41,826 - IOOppi_data - INFO : save data to db IOOppi_ss_t data:
date value
1628 2025-05-18 13300.0
1629 2025-05-19 13287.5
1630 2025-05-20 13287.5
1631 2025-05-21 13237.5
1632 2025-05-22 13237.5
2025-05-22 17:50:41,871 - IOOppi_data - INFO : save new data to db IOOppi_ss_t: date value ... created_at updated_at
1632 2025-05-22 13237.5 ... 2025-05-22 17:50:41.864258 2025-05-22 17:50:41.864635
[1 rows x 5 columns]
2025-05-22 17:50:41,891 - IOOppi_data - INFO : save diff data to db: IOOppi_ss_t: no diff data
2025-05-22 17:50:41,897 - IOOppi_data - INFO : save data to db IOOppi_ss_g data:
date value
1628 2025-05-18 13300.0
1629 2025-05-19 13287.5
1630 2025-05-20 13287.5
1631 2025-05-21 13237.5
1632 2025-05-22 13237.5
2025-05-22 17:50:41,943 - IOOppi_data - INFO : save new data to db IOOppi_ss_g: date value ... created_at updated_at
1635 2025-05-22 13237.5 ... 2025-05-22 17:50:41.936276 2025-05-22 17:50:41.936660
[1 rows x 5 columns]
2025-05-22 17:50:41,962 - 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-05-22 17:50:42,517 - IOOppi_data - INFO : save data to db IOOppi_RS_t data:
date value
3138 2025-05-18 9378.33
3139 2025-05-19 9475.00
3140 2025-05-20 9520.00
3141 2025-05-21 9541.67
3142 2025-05-22 9541.67
2025-05-22 17:50:42,584 - IOOppi_data - INFO : save new data to db IOOppi_RS_t: date value ... created_at updated_at
3142 2025-05-22 9541.67 ... 2025-05-22 17:50:42.577383 2025-05-22 17:50:42.577783
[1 rows x 5 columns]
2025-05-22 17:50:42,604 - IOOppi_data - INFO : save diff data to db: IOOppi_RS_t: no diff data
2025-05-22 17:50:42,610 - IOOppi_data - INFO : save data to db IOOppi_RS_g data:
date value
3138 2025-05-18 9378.33
3139 2025-05-19 9475.00
3140 2025-05-20 9520.00
3141 2025-05-21 9541.67
3142 2025-05-22 9541.67
2025-05-22 17:50:42,674 - IOOppi_data - INFO : save new data to db IOOppi_RS_g: date value ... created_at updated_at
3146 2025-05-22 9541.67 ... 2025-05-22 17:50:42.667177 2025-05-22 17:50:42.667548
[1 rows x 5 columns]
2025-05-22 17:50:42,693 - 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-05-22 17:50:43,353 - IOOppi_data - INFO : save data to db IOOppi_RM_t data:
date value
3261 2025-05-18 2476.67
3262 2025-05-19 2471.67
3263 2025-05-20 2475.00
3264 2025-05-21 2485.00
3265 2025-05-22 2485.00
2025-05-22 17:50:43,423 - IOOppi_data - INFO : save new data to db IOOppi_RM_t: date value ... created_at updated_at
3265 2025-05-22 2485.0 ... 2025-05-22 17:50:43.415417 2025-05-22 17:50:43.415816
[1 rows x 5 columns]
2025-05-22 17:50:43,445 - IOOppi_data - INFO : save diff data to db: IOOppi_RM_t: no diff data
2025-05-22 17:50:43,450 - IOOppi_data - INFO : save data to db IOOppi_RM_g data:
date value
3261 2025-05-18 2476.67
3262 2025-05-19 2471.67
3263 2025-05-20 2475.00
3264 2025-05-21 2485.00
3265 2025-05-22 2485.00
2025-05-22 17:50:43,516 - IOOppi_data - INFO : save new data to db IOOppi_RM_g: date value ... created_at updated_at
3269 2025-05-22 2485.0 ... 2025-05-22 17:50:43.509138 2025-05-22 17:50:43.509509
[1 rows x 5 columns]
2025-05-22 17:50:43,535 - 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-05-22 17:50:44,054 - IOOppi_data - INFO : save data to db IOOppi_SA_t data:
date value
1465 2025-05-18 1462.5
1466 2025-05-19 1462.5
1467 2025-05-20 1462.5
1468 2025-05-21 1462.5
1469 2025-05-22 1462.5
2025-05-22 17:50:44,101 - IOOppi_data - INFO : save new data to db IOOppi_SA_t: date value ... created_at updated_at
1469 2025-05-22 1462.5 ... 2025-05-22 17:50:44.093534 2025-05-22 17:50:44.093943
[1 rows x 5 columns]
2025-05-22 17:50:44,122 - IOOppi_data - INFO : save diff data to db: IOOppi_SA_t: no diff data
2025-05-22 17:50:44,127 - IOOppi_data - INFO : save data to db IOOppi_SA_g data:
date value
1465 2025-05-18 1462.5
1466 2025-05-19 1462.5
1467 2025-05-20 1462.5
1468 2025-05-21 1462.5
1469 2025-05-22 1462.5
2025-05-22 17:50:44,172 - IOOppi_data - INFO : save new data to db IOOppi_SA_g: date value ... created_at updated_at
1473 2025-05-22 1462.5 ... 2025-05-22 17:50:44.165437 2025-05-22 17:50:44.165847
[1 rows x 5 columns]
2025-05-22 17:50:44,193 - 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-05-22 17:50:44,691 - IOOppi_data - INFO : save data to db IOOppi_PF_t data:
date value
1378 2025-05-18 6727.50
1379 2025-05-19 6701.04
1380 2025-05-20 6687.71
1381 2025-05-21 6660.00
1382 2025-05-22 6623.12
2025-05-22 17:50:44,735 - IOOppi_data - INFO : save new data to db IOOppi_PF_t: date value ... created_at updated_at
1382 2025-05-22 6623.12 ... 2025-05-22 17:50:44.728123 2025-05-22 17:50:44.728539
[1 rows x 5 columns]
2025-05-22 17:50:44,754 - IOOppi_data - INFO : save diff data to db: IOOppi_PF_t: no diff data
2025-05-22 17:50:44,760 - IOOppi_data - INFO : save data to db IOOppi_PF_g data:
date value
1378 2025-05-18 6727.50
1379 2025-05-19 6701.04
1380 2025-05-20 6687.71
1381 2025-05-21 6660.00
1382 2025-05-22 6623.12
2025-05-22 17:50:44,805 - IOOppi_data - INFO : save new data to db IOOppi_PF_g: date value ... created_at updated_at
1386 2025-05-22 6623.12 ... 2025-05-22 17:50:44.798543 2025-05-22 17:50:44.798933
[1 rows x 5 columns]
2025-05-22 17:50:44,825 - 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-05-22 17:50:45,352 - IOOppi_data - INFO : save data to db IOOppi_m_t data:
date value
3751 2025-05-18 2988.0
3752 2025-05-19 2972.0
3753 2025-05-20 2966.0
3754 2025-05-21 2986.0
3755 2025-05-22 2998.0
2025-05-22 17:50:45,429 - IOOppi_data - INFO : save new data to db IOOppi_m_t: date value ... created_at updated_at
3755 2025-05-22 2998.0 ... 2025-05-22 17:50:45.422056 2025-05-22 17:50:45.422438
[1 rows x 5 columns]
2025-05-22 17:50:45,449 - IOOppi_data - INFO : save diff data to db: IOOppi_m_t: no diff data
2025-05-22 17:50:45,458 - IOOppi_data - INFO : save data to db IOOppi_m_g data:
date value
3751 2025-05-18 2988.0
3752 2025-05-19 2972.0
3753 2025-05-20 2966.0
3754 2025-05-21 2986.0
3755 2025-05-22 2998.0
2025-05-22 17:50:45,547 - IOOppi_data - INFO : save new data to db IOOppi_m_g: date value ... created_at updated_at
3758 2025-05-22 2998.0 ... 2025-05-22 17:50:45.539881 2025-05-22 17:50:45.540270
[1 rows x 5 columns]
2025-05-22 17:50:45,566 - 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-05-22 17:50:46,098 - IOOppi_data - INFO : save data to db IOOppi_y_t data:
date value
3521 2025-05-18 8024.0
3522 2025-05-19 8044.0
3523 2025-05-20 8074.0
3524 2025-05-21 8074.0
3525 2025-05-22 8074.0
2025-05-22 17:50:46,171 - IOOppi_data - INFO : save new data to db IOOppi_y_t: date value ... created_at updated_at
3525 2025-05-22 8074.0 ... 2025-05-22 17:50:46.164184 2025-05-22 17:50:46.164563
[1 rows x 5 columns]
2025-05-22 17:50:46,193 - IOOppi_data - INFO : save diff data to db: IOOppi_y_t: no diff data
2025-05-22 17:50:46,199 - IOOppi_data - INFO : save data to db IOOppi_y_g data:
date value
3521 2025-05-18 8024.0
3522 2025-05-19 8044.0
3523 2025-05-20 8074.0
3524 2025-05-21 8074.0
3525 2025-05-22 8074.0
2025-05-22 17:50:46,273 - IOOppi_data - INFO : save new data to db IOOppi_y_g: date value ... created_at updated_at
3528 2025-05-22 8074.0 ... 2025-05-22 17:50:46.266113 2025-05-22 17:50:46.266487
[1 rows x 5 columns]
2025-05-22 17:50:46,294 - 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-05-22 17:50:46,822 - IOOppi_data - INFO : save data to db IOOppi_a_t data:
date value
3487 2025-05-18 4255.0
3488 2025-05-19 4255.0
3489 2025-05-20 4255.0
3490 2025-05-21 4255.0
3491 2025-05-22 4255.0
2025-05-22 17:50:46,893 - IOOppi_data - INFO : save new data to db IOOppi_a_t: date value ... created_at updated_at
3491 2025-05-22 4255.0 ... 2025-05-22 17:50:46.885691 2025-05-22 17:50:46.886115
[1 rows x 5 columns]
2025-05-22 17:50:46,912 - IOOppi_data - INFO : save diff data to db: IOOppi_a_t: no diff data
2025-05-22 17:50:46,918 - IOOppi_data - INFO : save data to db IOOppi_a_g data:
date value
3487 2025-05-18 4255.0
3488 2025-05-19 4255.0
3489 2025-05-20 4255.0
3490 2025-05-21 4255.0
3491 2025-05-22 4255.0
2025-05-22 17:50:46,987 - IOOppi_data - INFO : save new data to db IOOppi_a_g: date value ... created_at updated_at
3494 2025-05-22 4255.0 ... 2025-05-22 17:50:46.979931 2025-05-22 17:50:46.980309
[1 rows x 5 columns]
2025-05-22 17:50:47,006 - 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-05-22 17:50:47,553 - IOOppi_data - INFO : save data to db IOOppi_SF_t data:
date value
2864 2025-05-18 5440.00
2865 2025-05-19 5435.71
2866 2025-05-20 5435.71
2867 2025-05-21 5435.71
2868 2025-05-22 5387.14
2025-05-22 17:50:47,616 - IOOppi_data - INFO : save new data to db IOOppi_SF_t: date value ... created_at updated_at
2868 2025-05-22 5387.14 ... 2025-05-22 17:50:47.609468 2025-05-22 17:50:47.609932
[1 rows x 5 columns]
2025-05-22 17:50:47,636 - IOOppi_data - INFO : save diff data to db: IOOppi_SF_t: no diff data
2025-05-22 17:50:47,642 - IOOppi_data - INFO : save data to db IOOppi_SF_g data:
date value
2864 2025-05-18 5440.00
2865 2025-05-19 5435.71
2866 2025-05-20 5435.71
2867 2025-05-21 5435.71
2868 2025-05-22 5387.14
2025-05-22 17:50:47,705 - IOOppi_data - INFO : save new data to db IOOppi_SF_g: date value ... created_at updated_at
2872 2025-05-22 5387.14 ... 2025-05-22 17:50:47.698373 2025-05-22 17:50:47.698787
[1 rows x 5 columns]
2025-05-22 17:50:47,725 - 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-05-22 17:50:48,237 - IOOppi_data - INFO : save data to db IOOppi_jd_t data:
date value
3064 2025-05-18 3375.0
3065 2025-05-19 3290.0
3066 2025-05-20 3190.0
3067 2025-05-21 3190.0
3068 2025-05-22 3160.0
2025-05-22 17:50:48,302 - IOOppi_data - INFO : save new data to db IOOppi_jd_t: date value ... created_at updated_at
3068 2025-05-22 3160.0 ... 2025-05-22 17:50:48.294798 2025-05-22 17:50:48.295212
[1 rows x 5 columns]
/root/project/IOOppi_data/IOOppi_request.py:308: SettingWithCopyWarning:
A value is trying to be set on a copy of a slice from a DataFrame.
Try using .loc[row_indexer,col_indexer] = value instead
See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy
diff_df.loc[:, 'index_code'] = index_code
/root/project/IOOppi_data/IOOppi_request.py:309: SettingWithCopyWarning:
A value is trying to be set on a copy of a slice from a DataFrame.
Try using .loc[row_indexer,col_indexer] = value instead
See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy
diff_df.loc[:, 'created_at'] = datetime.datetime.now()
/root/project/IOOppi_data/IOOppi_request.py:310: SettingWithCopyWarning:
A value is trying to be set on a copy of a slice from a DataFrame.
Try using .loc[row_indexer,col_indexer] = value instead
See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy
diff_df.loc[:, 'updated_at'] = datetime.datetime.now()
2025-05-22 17:50:48,471 - IOOppi_data - INFO : save diff data to db IOOppi_jd_t: date ... updated_at
39 2014-01-03 ... 2025-05-22 17:50:48.462864
458 2015-09-21 ... 2025-05-22 17:50:48.462864
549 2016-02-03 ... 2025-05-22 17:50:48.462864
693 2016-09-05 ... 2025-05-22 17:50:48.462864
696 2016-09-08 ... 2025-05-22 17:50:48.462864
[5 rows x 6 columns]
2025-05-22 17:50:48,505 - IOOppi_data - INFO : save data to db IOOppi_jd_g data:
date value
3064 2025-05-18 3375.0
3065 2025-05-19 3290.0
3066 2025-05-20 3190.0
3067 2025-05-21 3190.0
3068 2025-05-22 3160.0
2025-05-22 17:50:48,571 - IOOppi_data - INFO : save new data to db IOOppi_jd_g: date value ... created_at updated_at
3071 2025-05-22 3160.0 ... 2025-05-22 17:50:48.564401 2025-05-22 17:50:48.564809
[1 rows x 5 columns]
/root/project/IOOppi_data/IOOppi_request.py:308: SettingWithCopyWarning:
A value is trying to be set on a copy of a slice from a DataFrame.
Try using .loc[row_indexer,col_indexer] = value instead
See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy
diff_df.loc[:, 'index_code'] = index_code
/root/project/IOOppi_data/IOOppi_request.py:309: SettingWithCopyWarning:
A value is trying to be set on a copy of a slice from a DataFrame.
Try using .loc[row_indexer,col_indexer] = value instead
See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy
diff_df.loc[:, 'created_at'] = datetime.datetime.now()
/root/project/IOOppi_data/IOOppi_request.py:310: SettingWithCopyWarning:
A value is trying to be set on a copy of a slice from a DataFrame.
Try using .loc[row_indexer,col_indexer] = value instead
See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy
diff_df.loc[:, 'updated_at'] = datetime.datetime.now()
2025-05-22 17:50:48,736 - IOOppi_data - INFO : save diff data to db IOOppi_jd_g: date ... updated_at
39 2014-01-03 ... 2025-05-22 17:50:48.728922
458 2015-09-21 ... 2025-05-22 17:50:48.728922
549 2016-02-03 ... 2025-05-22 17:50:48.728922
693 2016-09-05 ... 2025-05-22 17:50:48.728922
696 2016-09-08 ... 2025-05-22 17:50:48.728922
[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-05-22 17:50:49,301 - IOOppi_data - INFO : save data to db IOOppi_SI_t data:
date value
868 2025-05-18 9480.0
869 2025-05-19 9390.0
870 2025-05-20 9290.0
871 2025-05-21 9210.0
872 2025-05-22 9210.0
2025-05-22 17:50:49,338 - IOOppi_data - INFO : save new data to db IOOppi_SI_t: date value ... created_at updated_at
872 2025-05-22 9210.0 ... 2025-05-22 17:50:49.331232 2025-05-22 17:50:49.331648
[1 rows x 5 columns]
2025-05-22 17:50:49,358 - IOOppi_data - INFO : save diff data to db: IOOppi_SI_t: no diff data
2025-05-22 17:50:49,364 - IOOppi_data - INFO : save data to db IOOppi_SI_g data:
date value
868 2025-05-18 9480.0
869 2025-05-19 9390.0
870 2025-05-20 9290.0
871 2025-05-21 9210.0
872 2025-05-22 9210.0
2025-05-22 17:50:49,402 - IOOppi_data - INFO : save new data to db IOOppi_SI_g: date value ... created_at updated_at
872 2025-05-22 9210.0 ... 2025-05-22 17:50:49.394998 2025-05-22 17:50:49.395380
[1 rows x 5 columns]
2025-05-22 17:50:49,422 - 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-05-22 17:50:49,935 - IOOppi_data - INFO : save data to db IOOppi_l_t data:
date value
3747 2025-05-18 7566.67
3748 2025-05-19 7583.33
3749 2025-05-20 7591.67
3750 2025-05-21 7583.33
3751 2025-05-22 7575.00
2025-05-22 17:50:50,008 - IOOppi_data - INFO : save new data to db IOOppi_l_t: date value ... created_at updated_at
3751 2025-05-22 7575.0 ... 2025-05-22 17:50:50.000685 2025-05-22 17:50:50.001104
[1 rows x 5 columns]
2025-05-22 17:50:50,029 - IOOppi_data - INFO : save diff data to db: IOOppi_l_t: no diff data
2025-05-22 17:50:50,035 - IOOppi_data - INFO : save data to db IOOppi_l_g data:
date value
3747 2025-05-18 7566.67
3748 2025-05-19 7583.33
3749 2025-05-20 7591.67
3750 2025-05-21 7583.33
3751 2025-05-22 7575.00
2025-05-22 17:50:50,107 - IOOppi_data - INFO : save new data to db IOOppi_l_g: date value ... created_at updated_at
3754 2025-05-22 7575.0 ... 2025-05-22 17:50:50.100222 2025-05-22 17:50:50.100597
[1 rows x 5 columns]
2025-05-22 17:50:50,127 - 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-05-22 17:50:50,654 - IOOppi_data - INFO : save data to db IOOppi_bu_t data:
date value
3085 2025-05-18 3600.0
3086 2025-05-19 3582.5
3087 2025-05-20 3590.0
3088 2025-05-21 3582.5
3089 2025-05-22 3570.0
2025-05-22 17:50:50,719 - IOOppi_data - INFO : save new data to db IOOppi_bu_t: date value ... created_at updated_at
3090 2025-05-22 3570.0 ... 2025-05-22 17:50:50.711818 2025-05-22 17:50:50.712209
[1 rows x 5 columns]
/root/project/IOOppi_data/IOOppi_request.py:308: SettingWithCopyWarning:
A value is trying to be set on a copy of a slice from a DataFrame.
Try using .loc[row_indexer,col_indexer] = value instead
See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy
diff_df.loc[:, 'index_code'] = index_code
/root/project/IOOppi_data/IOOppi_request.py:309: SettingWithCopyWarning:
A value is trying to be set on a copy of a slice from a DataFrame.
Try using .loc[row_indexer,col_indexer] = value instead
See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy
diff_df.loc[:, 'created_at'] = datetime.datetime.now()
/root/project/IOOppi_data/IOOppi_request.py:310: SettingWithCopyWarning:
A value is trying to be set on a copy of a slice from a DataFrame.
Try using .loc[row_indexer,col_indexer] = value instead
See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy
diff_df.loc[:, 'updated_at'] = datetime.datetime.now()
2025-05-22 17:50:50,755 - IOOppi_data - INFO : save diff data to db IOOppi_bu_t: date ... updated_at
2560 2023-12-09 ... 2025-05-22 17:50:50.748537
[1 rows x 6 columns]
2025-05-22 17:50:50,780 - IOOppi_data - INFO : save data to db IOOppi_bu_g data:
date value
3085 2025-05-18 3600.0
3086 2025-05-19 3582.5
3087 2025-05-20 3590.0
3088 2025-05-21 3582.5
3089 2025-05-22 3570.0
2025-05-22 17:50:50,845 - IOOppi_data - INFO : save new data to db IOOppi_bu_g: date value ... created_at updated_at
3092 2025-05-22 3570.0 ... 2025-05-22 17:50:50.838331 2025-05-22 17:50:50.838714
[1 rows x 5 columns]
2025-05-22 17:50:50,865 - 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-05-22 17:50:51,423 - IOOppi_data - INFO : save data to db IOOppi_al_t data:
date value
3750 2025-05-18 20290.00
3751 2025-05-19 20290.00
3752 2025-05-20 20226.67
3753 2025-05-21 20226.67
3754 2025-05-22 20326.67
2025-05-22 17:50:51,494 - IOOppi_data - INFO : save new data to db IOOppi_al_t: date ... updated_at
3754 2025-05-22 ... 2025-05-22 17:50:51.488526
[1 rows x 5 columns]
2025-05-22 17:50:51,515 - IOOppi_data - INFO : save diff data to db: IOOppi_al_t: no diff data
2025-05-22 17:50:51,521 - IOOppi_data - INFO : save data to db IOOppi_al_g data:
date value
3750 2025-05-18 20290.00
3751 2025-05-19 20290.00
3752 2025-05-20 20226.67
3753 2025-05-21 20226.67
3754 2025-05-22 20326.67
2025-05-22 17:50:51,608 - IOOppi_data - INFO : save new data to db IOOppi_al_g: date ... updated_at
3757 2025-05-22 ... 2025-05-22 17:50:51.602443
[1 rows x 5 columns]
2025-05-22 17:50:51,632 - 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-05-22 17:50:52,271 - IOOppi_data - INFO : save data to db IOOppi_SM_t data:
date value
2864 2025-05-18 5698.0
2865 2025-05-19 5664.0
2866 2025-05-20 5656.0
2867 2025-05-21 5636.0
2868 2025-05-22 5652.0
2025-05-22 17:50:52,333 - IOOppi_data - INFO : save new data to db IOOppi_SM_t: date value ... created_at updated_at
2868 2025-05-22 5652.0 ... 2025-05-22 17:50:52.325927 2025-05-22 17:50:52.326321
[1 rows x 5 columns]
2025-05-22 17:50:52,353 - IOOppi_data - INFO : save diff data to db: IOOppi_SM_t: no diff data
2025-05-22 17:50:52,359 - IOOppi_data - INFO : save data to db IOOppi_SM_g data:
date value
2864 2025-05-18 5698.0
2865 2025-05-19 5664.0
2866 2025-05-20 5656.0
2867 2025-05-21 5636.0
2868 2025-05-22 5652.0
2025-05-22 17:50:52,422 - IOOppi_data - INFO : save new data to db IOOppi_SM_g: date value ... created_at updated_at
2872 2025-05-22 5652.0 ... 2025-05-22 17:50:52.414859 2025-05-22 17:50:52.415255
[1 rows x 5 columns]
2025-05-22 17:50:52,441 - 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-05-22 17:50:53,015 - IOOppi_data - INFO : save data to db IOOppi_CY_t data:
date value
2139 2025-05-18 23775.0
2140 2025-05-19 23775.0
2141 2025-05-20 23775.0
2142 2025-05-21 23775.0
2143 2025-05-22 23775.0
2025-05-22 17:50:53,066 - IOOppi_data - INFO : save new data to db IOOppi_CY_t: date value ... created_at updated_at
2143 2025-05-22 23775.0 ... 2025-05-22 17:50:53.059163 2025-05-22 17:50:53.059533
[1 rows x 5 columns]
2025-05-22 17:50:53,087 - IOOppi_data - INFO : save diff data to db: IOOppi_CY_t: no diff data
2025-05-22 17:50:53,092 - IOOppi_data - INFO : save data to db IOOppi_CY_g data:
date value
2139 2025-05-18 23775.0
2140 2025-05-19 23775.0
2141 2025-05-20 23775.0
2142 2025-05-21 23775.0
2143 2025-05-22 23775.0
2025-05-22 17:50:53,146 - IOOppi_data - INFO : save new data to db IOOppi_CY_g: date value ... created_at updated_at
2147 2025-05-22 23775.0 ... 2025-05-22 17:50:53.138783 2025-05-22 17:50:53.139185
[1 rows x 5 columns]
2025-05-22 17:50:53,166 - 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-05-22 17:50:53,757 - IOOppi_data - INFO : save data to db IOOppi_UR_t data:
date value
1654 2025-05-18 1946.67
1655 2025-05-19 1945.00
1656 2025-05-20 1930.00
1657 2025-05-21 1926.00
1658 2025-05-22 1912.00
2025-05-22 17:50:53,805 - IOOppi_data - INFO : save new data to db IOOppi_UR_t: date value ... created_at updated_at
1658 2025-05-22 1912.0 ... 2025-05-22 17:50:53.797949 2025-05-22 17:50:53.798337
[1 rows x 5 columns]
2025-05-22 17:50:53,826 - IOOppi_data - INFO : save diff data to db: IOOppi_UR_t: no diff data
2025-05-22 17:50:53,831 - IOOppi_data - INFO : save data to db IOOppi_UR_g data:
date value
1654 2025-05-18 1946.67
1655 2025-05-19 1945.00
1656 2025-05-20 1930.00
1657 2025-05-21 1926.00
1658 2025-05-22 1912.00
2025-05-22 17:50:53,877 - IOOppi_data - INFO : save new data to db IOOppi_UR_g: date value ... created_at updated_at
1662 2025-05-22 1912.0 ... 2025-05-22 17:50:53.870406 2025-05-22 17:50:53.870814
[1 rows x 5 columns]
2025-05-22 17:50:53,897 - 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-05-22 17:50:54,622 - IOOppi_data - INFO : save data to db IOOppi_ni_t data:
date value
2726 2025-05-18 126258.33
2727 2025-05-19 125083.33
2728 2025-05-20 124775.00
2729 2025-05-21 124658.33
2730 2025-05-22 124633.33
2025-05-22 17:50:54,682 - IOOppi_data - INFO : save new data to db IOOppi_ni_t: date ... updated_at
2730 2025-05-22 ... 2025-05-22 17:50:54.675797
[1 rows x 5 columns]
2025-05-22 17:50:54,701 - IOOppi_data - INFO : save diff data to db: IOOppi_ni_t: no diff data
2025-05-22 17:50:54,707 - IOOppi_data - INFO : save data to db IOOppi_ni_g data:
date value
2726 2025-05-18 126258.33
2727 2025-05-19 125083.33
2728 2025-05-20 124775.00
2729 2025-05-21 124658.33
2730 2025-05-22 124633.33
2025-05-22 17:50:54,765 - IOOppi_data - INFO : save new data to db IOOppi_ni_g: date ... updated_at
2733 2025-05-22 ... 2025-05-22 17:50:54.759947
[1 rows x 5 columns]
2025-05-22 17:50:54,786 - 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-05-22 17:50:55,362 - IOOppi_data - INFO : save data to db IOOppi_v_t data:
date value
3751 2025-05-18 4782.0
3752 2025-05-19 4726.0
3753 2025-05-20 4719.0
3754 2025-05-21 4721.0
3755 2025-05-22 4701.0
2025-05-22 17:50:55,439 - IOOppi_data - INFO : save new data to db IOOppi_v_t: date value ... created_at updated_at
3755 2025-05-22 4701.0 ... 2025-05-22 17:50:55.431778 2025-05-22 17:50:55.432181
[1 rows x 5 columns]
2025-05-22 17:50:55,459 - IOOppi_data - INFO : save diff data to db: IOOppi_v_t: no diff data
2025-05-22 17:50:55,465 - IOOppi_data - INFO : save data to db IOOppi_v_g data:
date value
3751 2025-05-18 4782.0
3752 2025-05-19 4726.0
3753 2025-05-20 4719.0
3754 2025-05-21 4721.0
3755 2025-05-22 4701.0
2025-05-22 17:50:55,541 - IOOppi_data - INFO : save new data to db IOOppi_v_g: date value ... created_at updated_at
3758 2025-05-22 4701.0 ... 2025-05-22 17:50:55.533191 2025-05-22 17:50:55.533575
[1 rows x 5 columns]
2025-05-22 17:50:55,562 - 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-05-22 17:50:56,113 - IOOppi_data - INFO : save data to db IOOppi_pp_t data:
date value
2990 2025-05-18 7440.0
2991 2025-05-19 7440.0
2992 2025-05-20 7440.0
2993 2025-05-21 7440.0
2994 2025-05-22 7440.0
2025-05-22 17:50:56,177 - IOOppi_data - INFO : save new data to db IOOppi_pp_t: date value ... created_at updated_at
2994 2025-05-22 7440.0 ... 2025-05-22 17:50:56.170244 2025-05-22 17:50:56.170622
[1 rows x 5 columns]
2025-05-22 17:50:56,198 - IOOppi_data - INFO : save diff data to db: IOOppi_pp_t: no diff data
2025-05-22 17:50:56,204 - IOOppi_data - INFO : save data to db IOOppi_pp_g data:
date value
2990 2025-05-18 7440.0
2991 2025-05-19 7440.0
2992 2025-05-20 7440.0
2993 2025-05-21 7440.0
2994 2025-05-22 7440.0
2025-05-22 17:50:56,268 - IOOppi_data - INFO : save new data to db IOOppi_pp_g: date value ... created_at updated_at
2997 2025-05-22 7440.0 ... 2025-05-22 17:50:56.261018 2025-05-22 17:50:56.261398
[1 rows x 5 columns]
2025-05-22 17:50:56,288 - 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-05-22 17:50:56,871 - IOOppi_data - INFO : save data to db IOOppi_CF_t data:
date value
3752 2025-05-18 14558.17
3753 2025-05-19 14551.17
3754 2025-05-20 14539.17
3755 2025-05-21 14550.83
3756 2025-05-22 14614.33
2025-05-22 17:50:56,944 - IOOppi_data - INFO : save new data to db IOOppi_CF_t: date ... updated_at
3756 2025-05-22 ... 2025-05-22 17:50:56.938331
[1 rows x 5 columns]
2025-05-22 17:50:56,965 - IOOppi_data - INFO : save diff data to db: IOOppi_CF_t: no diff data
2025-05-22 17:50:56,971 - IOOppi_data - INFO : save data to db IOOppi_CF_g data:
date value
3752 2025-05-18 14558.17
3753 2025-05-19 14551.17
3754 2025-05-20 14539.17
3755 2025-05-21 14550.83
3756 2025-05-22 14614.33
2025-05-22 17:50:57,043 - IOOppi_data - INFO : save new data to db IOOppi_CF_g: date ... updated_at
3760 2025-05-22 ... 2025-05-22 17:50:57.037537
[1 rows x 5 columns]
2025-05-22 17:50:57,064 - 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-05-22 17:50:57,615 - IOOppi_data - INFO : save data to db IOOppi_pb_t data:
date value
3697 2025-05-18 16847.50
3698 2025-05-19 16825.00
3699 2025-05-20 16750.00
3700 2025-05-21 16831.25
3701 2025-05-22 16731.25
2025-05-22 17:50:57,686 - IOOppi_data - INFO : save new data to db IOOppi_pb_t: date ... updated_at
3701 2025-05-22 ... 2025-05-22 17:50:57.680335
[1 rows x 5 columns]
2025-05-22 17:50:57,706 - IOOppi_data - INFO : save diff data to db: IOOppi_pb_t: no diff data
2025-05-22 17:50:57,712 - IOOppi_data - INFO : save data to db IOOppi_pb_g data:
date value
3697 2025-05-18 16847.50
3698 2025-05-19 16825.00
3699 2025-05-20 16750.00
3700 2025-05-21 16831.25
3701 2025-05-22 16731.25
2025-05-22 17:50:57,783 - IOOppi_data - INFO : save new data to db IOOppi_pb_g: date ... updated_at
3704 2025-05-22 ... 2025-05-22 17:50:57.777468
[1 rows x 5 columns]
2025-05-22 17:50:57,803 - 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-05-22 17:50:58,355 - IOOppi_data - INFO : save data to db IOOppi_hc_t data:
date value
2972 2025-05-18 3310.00
2973 2025-05-19 3290.00
2974 2025-05-20 3290.00
2975 2025-05-21 3286.67
2976 2025-05-22 3283.33
2025-05-22 17:50:58,491 - IOOppi_data - INFO : save new data to db IOOppi_hc_t: date value ... created_at updated_at
2976 2025-05-22 3283.33 ... 2025-05-22 17:50:58.484437 2025-05-22 17:50:58.484858
[1 rows x 5 columns]
2025-05-22 17:50:58,511 - IOOppi_data - INFO : save diff data to db: IOOppi_hc_t: no diff data
2025-05-22 17:50:58,517 - IOOppi_data - INFO : save data to db IOOppi_hc_g data:
date value
2972 2025-05-18 3310.00
2973 2025-05-19 3290.00
2974 2025-05-20 3290.00
2975 2025-05-21 3286.67
2976 2025-05-22 3283.33
2025-05-22 17:50:58,580 - IOOppi_data - INFO : save new data to db IOOppi_hc_g: date value ... created_at updated_at
2979 2025-05-22 3283.33 ... 2025-05-22 17:50:58.573551 2025-05-22 17:50:58.573957
[1 rows x 5 columns]
2025-05-22 17:50:58,600 - 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-05-22 17:50:59,155 - IOOppi_data - INFO : save data to db IOOppi_fu_t data:
date value
3252 2025-05-18 5445.0
3253 2025-05-19 5462.5
3254 2025-05-20 5462.5
3255 2025-05-21 5437.5
3256 2025-05-22 5437.5
2025-05-22 17:50:59,223 - IOOppi_data - INFO : save new data to db IOOppi_fu_t: date value ... created_at updated_at
3256 2025-05-22 5437.5 ... 2025-05-22 17:50:59.215813 2025-05-22 17:50:59.216215
[1 rows x 5 columns]
2025-05-22 17:50:59,243 - IOOppi_data - INFO : save diff data to db: IOOppi_fu_t: no diff data
2025-05-22 17:50:59,250 - IOOppi_data - INFO : save data to db IOOppi_fu_g data:
date value
3252 2025-05-18 5445.0
3253 2025-05-19 5462.5
3254 2025-05-20 5462.5
3255 2025-05-21 5437.5
3256 2025-05-22 5437.5
2025-05-22 17:50:59,324 - IOOppi_data - INFO : save new data to db IOOppi_fu_g: date value ... created_at updated_at
3743 2025-05-22 5437.5 ... 2025-05-22 17:50:59.316857 2025-05-22 17:50:59.317258
[1 rows x 5 columns]
2025-05-22 17:50:59,343 - 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-05-22 17:51:00,007 - IOOppi_data - INFO : save data to db IOOppi_lh_t data:
date value
1316 2025-05-18 14650.0
1317 2025-05-19 14620.0
1318 2025-05-20 14600.0
1319 2025-05-21 14570.0
1320 2025-05-22 14570.0
2025-05-22 17:51:00,051 - IOOppi_data - INFO : save new data to db IOOppi_lh_t: date value ... created_at updated_at
1320 2025-05-22 14570.0 ... 2025-05-22 17:51:00.043927 2025-05-22 17:51:00.044379
[1 rows x 5 columns]
/root/project/IOOppi_data/IOOppi_request.py:308: SettingWithCopyWarning:
A value is trying to be set on a copy of a slice from a DataFrame.
Try using .loc[row_indexer,col_indexer] = value instead
See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy
diff_df.loc[:, 'index_code'] = index_code
/root/project/IOOppi_data/IOOppi_request.py:309: SettingWithCopyWarning:
A value is trying to be set on a copy of a slice from a DataFrame.
Try using .loc[row_indexer,col_indexer] = value instead
See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy
diff_df.loc[:, 'created_at'] = datetime.datetime.now()
/root/project/IOOppi_data/IOOppi_request.py:310: SettingWithCopyWarning:
A value is trying to be set on a copy of a slice from a DataFrame.
Try using .loc[row_indexer,col_indexer] = value instead
See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy
diff_df.loc[:, 'updated_at'] = datetime.datetime.now()
2025-05-22 17:51:00,317 - IOOppi_data - INFO : save diff data to db IOOppi_lh_t: date ... updated_at
116 2021-07-05 ... 2025-05-22 17:51:00.309006
117 2021-07-06 ... 2025-05-22 17:51:00.309006
121 2021-07-12 ... 2025-05-22 17:51:00.309006
122 2021-07-13 ... 2025-05-22 17:51:00.309006
194 2021-11-01 ... 2025-05-22 17:51:00.309006
[5 rows x 6 columns]
2025-05-22 17:51:00,356 - IOOppi_data - INFO : save data to db IOOppi_lh_g data:
date value
1316 2025-05-18 14650.0
1317 2025-05-19 14620.0
1318 2025-05-20 14600.0
1319 2025-05-21 14570.0
1320 2025-05-22 14570.0
2025-05-22 17:51:00,399 - IOOppi_data - INFO : save new data to db IOOppi_lh_g: date value ... created_at updated_at
1323 2025-05-22 14570.0 ... 2025-05-22 17:51:00.392220 2025-05-22 17:51:00.392607
[1 rows x 5 columns]
/root/project/IOOppi_data/IOOppi_request.py:308: SettingWithCopyWarning:
A value is trying to be set on a copy of a slice from a DataFrame.
Try using .loc[row_indexer,col_indexer] = value instead
See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy
diff_df.loc[:, 'index_code'] = index_code
/root/project/IOOppi_data/IOOppi_request.py:309: SettingWithCopyWarning:
A value is trying to be set on a copy of a slice from a DataFrame.
Try using .loc[row_indexer,col_indexer] = value instead
See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy
diff_df.loc[:, 'created_at'] = datetime.datetime.now()
/root/project/IOOppi_data/IOOppi_request.py:310: SettingWithCopyWarning:
A value is trying to be set on a copy of a slice from a DataFrame.
Try using .loc[row_indexer,col_indexer] = value instead
See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy
diff_df.loc[:, 'updated_at'] = datetime.datetime.now()
2025-05-22 17:51:00,657 - IOOppi_data - INFO : save diff data to db IOOppi_lh_g: date ... updated_at
116 2021-07-05 ... 2025-05-22 17:51:00.649316
117 2021-07-06 ... 2025-05-22 17:51:00.649316
121 2021-07-12 ... 2025-05-22 17:51:00.649316
122 2021-07-13 ... 2025-05-22 17:51:00.649316
194 2021-11-01 ... 2025-05-22 17:51:00.649316
[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-05-22 17:51:01,338 - IOOppi_data - INFO : save data to db IOOppi_cu_t data:
date value
3748 2025-05-18 78818.33
3749 2025-05-19 78113.33
3750 2025-05-20 78343.33
3751 2025-05-21 78493.33
3752 2025-05-22 78143.33
2025-05-22 17:51:01,409 - IOOppi_data - INFO : save new data to db IOOppi_cu_t: date ... updated_at
3752 2025-05-22 ... 2025-05-22 17:51:01.403321
[1 rows x 5 columns]
2025-05-22 17:51:01,431 - IOOppi_data - INFO : save diff data to db: IOOppi_cu_t: no diff data
2025-05-22 17:51:01,437 - IOOppi_data - INFO : save data to db IOOppi_cu_g data:
date value
3748 2025-05-18 78818.33
3749 2025-05-19 78113.33
3750 2025-05-20 78343.33
3751 2025-05-21 78493.33
3752 2025-05-22 78143.33
2025-05-22 17:51:01,509 - IOOppi_data - INFO : save new data to db IOOppi_cu_g: date ... updated_at
3755 2025-05-22 ... 2025-05-22 17:51:01.502782
[1 rows x 5 columns]
2025-05-22 17:51:01,528 - 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-05-22 17:51:02,036 - 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-05-22 17:51:02,089 - IOOppi_data - INFO : save new data to db: IOOppi_PM_t: no new data
2025-05-22 17:51:02,090 - IOOppi_data - INFO : save diff data to db: IOOppi_PM_t: no diff data
2025-05-22 17:51:02,095 - 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-05-22 17:51:02,163 - IOOppi_data - INFO : save new data to db: IOOppi_PM_g: no new data
2025-05-22 17:51:02,163 - 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-05-22 17:51:02,760 - IOOppi_data - INFO : save data to db IOOppi_sn_t data:
date value
2726 2025-05-18 265487.5
2727 2025-05-19 265187.5
2728 2025-05-20 265187.5
2729 2025-05-21 268212.5
2730 2025-05-22 265400.0
2025-05-22 17:51:02,819 - IOOppi_data - INFO : save new data to db IOOppi_sn_t: date ... updated_at
2730 2025-05-22 ... 2025-05-22 17:51:02.813775
[1 rows x 5 columns]
2025-05-22 17:51:02,839 - IOOppi_data - INFO : save diff data to db: IOOppi_sn_t: no diff data
2025-05-22 17:51:02,845 - IOOppi_data - INFO : save data to db IOOppi_sn_g data:
date value
2726 2025-05-18 265487.5
2727 2025-05-19 265187.5
2728 2025-05-20 265187.5
2729 2025-05-21 268212.5
2730 2025-05-22 265400.0
2025-05-22 17:51:02,904 - IOOppi_data - INFO : save new data to db IOOppi_sn_g: date ... updated_at
2733 2025-05-22 ... 2025-05-22 17:51:02.898062
[1 rows x 5 columns]
2025-05-22 17:51:02,923 - 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-05-22 17:51:03,496 - IOOppi_data - INFO : save data to db IOOppi_zn_t data:
date value
3747 2025-05-18 22746.0
3748 2025-05-19 22590.0
3749 2025-05-20 22574.0
3750 2025-05-21 22744.0
3751 2025-05-22 22634.0
2025-05-22 17:51:03,567 - IOOppi_data - INFO : save new data to db IOOppi_zn_t: date value ... created_at updated_at
3751 2025-05-22 22634.0 ... 2025-05-22 17:51:03.560428 2025-05-22 17:51:03.560829
[1 rows x 5 columns]
2025-05-22 17:51:03,587 - IOOppi_data - INFO : save diff data to db: IOOppi_zn_t: no diff data
2025-05-22 17:51:03,593 - IOOppi_data - INFO : save data to db IOOppi_zn_g data:
date value
3747 2025-05-18 22746.0
3748 2025-05-19 22590.0
3749 2025-05-20 22574.0
3750 2025-05-21 22744.0
3751 2025-05-22 22634.0
2025-05-22 17:51:03,668 - IOOppi_data - INFO : save new data to db IOOppi_zn_g: date value ... created_at updated_at
3754 2025-05-22 22634.0 ... 2025-05-22 17:51:03.661009 2025-05-22 17:51:03.661389
[1 rows x 5 columns]
2025-05-22 17:51:03,687 - 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-05-22 17:51:04,223 - IOOppi_data - INFO : save data to db IOOppi_wr_t data:
date value
3710 2025-05-18 3372.5
3711 2025-05-19 3347.5
3712 2025-05-20 3347.5
3713 2025-05-21 3335.0
3714 2025-05-22 3327.5
2025-05-22 17:51:04,295 - IOOppi_data - INFO : save new data to db IOOppi_wr_t: date value ... created_at updated_at
3714 2025-05-22 3327.5 ... 2025-05-22 17:51:04.288236 2025-05-22 17:51:04.288622
[1 rows x 5 columns]
2025-05-22 17:51:04,315 - IOOppi_data - INFO : save diff data to db: IOOppi_wr_t: no diff data
2025-05-22 17:51:04,321 - IOOppi_data - INFO : save data to db IOOppi_wr_g data:
date value
3710 2025-05-18 3372.5
3711 2025-05-19 3347.5
3712 2025-05-20 3347.5
3713 2025-05-21 3335.0
3714 2025-05-22 3327.5
2025-05-22 17:51:04,394 - IOOppi_data - INFO : save new data to db IOOppi_wr_g: date value ... created_at updated_at
3717 2025-05-22 3327.5 ... 2025-05-22 17:51:04.387390 2025-05-22 17:51:04.387796
[1 rows x 5 columns]
2025-05-22 17:51:04,414 - 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-05-22 17:51:05,215 - IOOppi_data - INFO : save data to db IOOppi_pg_t data:
date value
1507 2025-05-18 4780.0
1508 2025-05-19 4740.0
1509 2025-05-20 4702.5
1510 2025-05-21 4715.0
1511 2025-05-22 4742.5
2025-05-22 17:51:05,261 - IOOppi_data - INFO : save new data to db IOOppi_pg_t: date value ... created_at updated_at
1511 2025-05-22 4742.5 ... 2025-05-22 17:51:05.254388 2025-05-22 17:51:05.254797
[1 rows x 5 columns]
2025-05-22 17:51:05,281 - IOOppi_data - INFO : save diff data to db: IOOppi_pg_t: no diff data
2025-05-22 17:51:05,286 - IOOppi_data - INFO : save data to db IOOppi_pg_g data:
date value
1507 2025-05-18 4780.0
1508 2025-05-19 4740.0
1509 2025-05-20 4702.5
1510 2025-05-21 4715.0
1511 2025-05-22 4742.5
2025-05-22 17:51:05,332 - IOOppi_data - INFO : save new data to db IOOppi_pg_g: date value ... created_at updated_at
1514 2025-05-22 4742.5 ... 2025-05-22 17:51:05.324643 2025-05-22 17:51:05.325061
[1 rows x 5 columns]
2025-05-22 17:51:05,352 - 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-05-22 17:51:05,860 - IOOppi_data - INFO : save data to db IOOppi_cs_t data:
date value
2781 2025-05-18 2304.29
2782 2025-05-19 2301.43
2783 2025-05-20 2301.43
2784 2025-05-21 2298.57
2785 2025-05-22 2295.71
2025-05-22 17:51:05,921 - IOOppi_data - INFO : save new data to db IOOppi_cs_t: date value ... created_at updated_at
2785 2025-05-22 2295.71 ... 2025-05-22 17:51:05.914114 2025-05-22 17:51:05.914501
[1 rows x 5 columns]
/root/project/IOOppi_data/IOOppi_request.py:308: SettingWithCopyWarning:
A value is trying to be set on a copy of a slice from a DataFrame.
Try using .loc[row_indexer,col_indexer] = value instead
See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy
diff_df.loc[:, 'index_code'] = index_code
/root/project/IOOppi_data/IOOppi_request.py:309: SettingWithCopyWarning:
A value is trying to be set on a copy of a slice from a DataFrame.
Try using .loc[row_indexer,col_indexer] = value instead
See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy
diff_df.loc[:, 'created_at'] = datetime.datetime.now()
/root/project/IOOppi_data/IOOppi_request.py:310: SettingWithCopyWarning:
A value is trying to be set on a copy of a slice from a DataFrame.
Try using .loc[row_indexer,col_indexer] = value instead
See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy
diff_df.loc[:, 'updated_at'] = datetime.datetime.now()
2025-05-22 17:51:05,965 - IOOppi_data - INFO : save diff data to db IOOppi_cs_t: date ... updated_at
2784 2025-05-21 ... 2025-05-22 17:51:05.957923
[1 rows x 6 columns]
2025-05-22 17:51:05,990 - IOOppi_data - INFO : save data to db IOOppi_cs_g data:
date value
2781 2025-05-18 2304.29
2782 2025-05-19 2301.43
2783 2025-05-20 2301.43
2784 2025-05-21 2298.57
2785 2025-05-22 2295.71
2025-05-22 17:51:06,052 - IOOppi_data - INFO : save new data to db IOOppi_cs_g: date value ... created_at updated_at
2788 2025-05-22 2295.71 ... 2025-05-22 17:51:06.045300 2025-05-22 17:51:06.045739
[1 rows x 5 columns]
/root/project/IOOppi_data/IOOppi_request.py:308: SettingWithCopyWarning:
A value is trying to be set on a copy of a slice from a DataFrame.
Try using .loc[row_indexer,col_indexer] = value instead
See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy
diff_df.loc[:, 'index_code'] = index_code
/root/project/IOOppi_data/IOOppi_request.py:309: SettingWithCopyWarning:
A value is trying to be set on a copy of a slice from a DataFrame.
Try using .loc[row_indexer,col_indexer] = value instead
See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy
diff_df.loc[:, 'created_at'] = datetime.datetime.now()
/root/project/IOOppi_data/IOOppi_request.py:310: SettingWithCopyWarning:
A value is trying to be set on a copy of a slice from a DataFrame.
Try using .loc[row_indexer,col_indexer] = value instead
See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy
diff_df.loc[:, 'updated_at'] = datetime.datetime.now()
2025-05-22 17:51:06,096 - IOOppi_data - INFO : save diff data to db IOOppi_cs_g: date ... updated_at
2787 2025-05-21 ... 2025-05-22 17:51:06.089283
[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-05-22 17:51:06,653 - IOOppi_data - INFO : save data to db IOOppi_cs_t data:
date value
2781 2025-05-18 2304.29
2782 2025-05-19 2301.43
2783 2025-05-20 2301.43
2784 2025-05-21 2298.57
2785 2025-05-22 2922.00
2025-05-22 17:51:06,705 - 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-05-22 17:51:06,728 - IOOppi_data - INFO : save diff data to db IOOppi_cs_t: date ... updated_at
2785 2025-05-22 ... 2025-05-22 17:51:06.721281
[1 rows x 6 columns]
2025-05-22 17:51:06,754 - IOOppi_data - INFO : save data to db IOOppi_cs_g data:
date value
2781 2025-05-18 2304.29
2782 2025-05-19 2301.43
2783 2025-05-20 2301.43
2784 2025-05-21 2298.57
2785 2025-05-22 2922.00
2025-05-22 17:51:06,807 - 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-05-22 17:51:06,830 - IOOppi_data - INFO : save diff data to db IOOppi_cs_g: date ... updated_at
2788 2025-05-22 ... 2025-05-22 17:51:06.823246
[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-05-22 17:51:07,329 - IOOppi_data - INFO : save data to db IOOppi_RS_t data:
date value
3138 2025-05-18 9378.33
3139 2025-05-19 9475.00
3140 2025-05-20 9520.00
3141 2025-05-21 9541.67
3142 2025-05-22 9541.67
2025-05-22 17:51:07,385 - IOOppi_data - INFO : save new data to db: IOOppi_RS_t: no new data
2025-05-22 17:51:07,386 - IOOppi_data - INFO : save diff data to db: IOOppi_RS_t: no diff data
2025-05-22 17:51:07,391 - IOOppi_data - INFO : save data to db IOOppi_RS_g data:
date value
3138 2025-05-18 9378.33
3139 2025-05-19 9475.00
3140 2025-05-20 9520.00
3141 2025-05-21 9541.67
3142 2025-05-22 9541.67
2025-05-22 17:51:07,453 - IOOppi_data - INFO : save new data to db: IOOppi_RS_g: no new data
2025-05-22 17:51:07,453 - 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-05-22 17:51:07,963 - IOOppi_data - INFO : save data to db IOOppi_eg_t data:
date value
1822 2025-05-18 4551.67
1823 2025-05-19 4560.00
1824 2025-05-20 4540.00
1825 2025-05-21 4543.33
1826 2025-05-22 4543.33
2025-05-22 17:51:08,020 - IOOppi_data - INFO : save new data to db IOOppi_eg_t: date value ... created_at updated_at
1826 2025-05-22 4543.33 ... 2025-05-22 17:51:08.012421 2025-05-22 17:51:08.012854
[1 rows x 5 columns]
2025-05-22 17:51:08,040 - IOOppi_data - INFO : save diff data to db: IOOppi_eg_t: no diff data
2025-05-22 17:51:08,046 - IOOppi_data - INFO : save data to db IOOppi_eg_g data:
date value
1822 2025-05-18 4551.67
1823 2025-05-19 4560.00
1824 2025-05-20 4540.00
1825 2025-05-21 4543.33
1826 2025-05-22 4543.33
2025-05-22 17:51:08,094 - IOOppi_data - INFO : save new data to db IOOppi_eg_g: date value ... created_at updated_at
1829 2025-05-22 4543.33 ... 2025-05-22 17:51:08.087611 2025-05-22 17:51:08.088018
[1 rows x 5 columns]
2025-05-22 17:51:08,114 - 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-05-22 17:51:08,650 - IOOppi_data - INFO : save data to db IOOppi_sp_t data:
date value
1831 2025-05-18 6300.0
1832 2025-05-19 6300.0
1833 2025-05-20 6300.0
1834 2025-05-21 6300.0
1835 2025-05-22 6300.0
2025-05-22 17:51:08,698 - IOOppi_data - INFO : save new data to db IOOppi_sp_t: date value ... created_at updated_at
1835 2025-05-22 6300.0 ... 2025-05-22 17:51:08.691378 2025-05-22 17:51:08.691772
[1 rows x 5 columns]
2025-05-22 17:51:08,718 - IOOppi_data - INFO : save diff data to db: IOOppi_sp_t: no diff data
2025-05-22 17:51:08,723 - IOOppi_data - INFO : save data to db IOOppi_sp_g data:
date value
1831 2025-05-18 6300.0
1832 2025-05-19 6300.0
1833 2025-05-20 6300.0
1834 2025-05-21 6300.0
1835 2025-05-22 6300.0
2025-05-22 17:51:08,773 - IOOppi_data - INFO : save new data to db IOOppi_sp_g: date value ... created_at updated_at
1838 2025-05-22 6300.0 ... 2025-05-22 17:51:08.766252 2025-05-22 17:51:08.766647
[1 rows x 5 columns]
2025-05-22 17:51:08,793 - 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-05-22 17:51:09,347 - IOOppi_data - INFO : save data to db IOOppi_p_t data:
date value
3499 2025-05-18 8492.0
3500 2025-05-19 8542.0
3501 2025-05-20 8636.0
3502 2025-05-21 8584.0
3503 2025-05-22 8546.0
2025-05-22 17:51:09,416 - IOOppi_data - INFO : save new data to db IOOppi_p_t: date value ... created_at updated_at
3503 2025-05-22 8546.0 ... 2025-05-22 17:51:09.409079 2025-05-22 17:51:09.409455
[1 rows x 5 columns]
2025-05-22 17:51:09,437 - IOOppi_data - INFO : save diff data to db: IOOppi_p_t: no diff data
2025-05-22 17:51:09,443 - IOOppi_data - INFO : save data to db IOOppi_p_g data:
date value
3499 2025-05-18 8492.0
3500 2025-05-19 8542.0
3501 2025-05-20 8636.0
3502 2025-05-21 8584.0
3503 2025-05-22 8546.0
2025-05-22 17:51:09,512 - IOOppi_data - INFO : save new data to db IOOppi_p_g: date value ... created_at updated_at
3506 2025-05-22 8546.0 ... 2025-05-22 17:51:09.505715 2025-05-22 17:51:09.506112
[1 rows x 5 columns]
2025-05-22 17:51:09,532 - IOOppi_data - INFO : save diff data to db: IOOppi_p_g: no diff data