=========================================================================
2025-06-30 17:50:26 Mon START TASK.01 IOOppi_data update_data
=========================================================================
/usr/local/lib/python3.10/site-packages/urllib3/connectionpool.py:1056: InsecureRequestWarning: Unverified HTTPS request is being made to host 'www.100ppi.com'. Adding certificate verification is strongly advised. See: https://urllib3.readthedocs.io/en/1.26.x/advanced-usage.html#ssl-warnings
warnings.warn(
2025-06-30 17:50:28,372 - IOOppi_data - INFO : save data to db IOOppi_rb_t data:
date value
3346 2025-06-26 3060.33
3347 2025-06-27 3072.00
3348 2025-06-28 3072.00
3349 2025-06-29 3072.00
3350 2025-06-30 3072.00
2025-06-30 17:50:28,452 - IOOppi_data - INFO : save new data to db IOOppi_rb_t: date value ... created_at updated_at
3348 2025-06-28 3072.0 ... 2025-06-30 17:50:28.444296 2025-06-30 17:50:28.444711
3349 2025-06-29 3072.0 ... 2025-06-30 17:50:28.444296 2025-06-30 17:50:28.444711
3350 2025-06-30 3072.0 ... 2025-06-30 17:50:28.444296 2025-06-30 17:50:28.444711
[3 rows x 5 columns]
2025-06-30 17:50:28,472 - IOOppi_data - INFO : save diff data to db: IOOppi_rb_t: no diff data
2025-06-30 17:50:28,478 - IOOppi_data - INFO : save data to db IOOppi_rb_g data:
date value
3346 2025-06-26 3060.33
3347 2025-06-27 3072.00
3348 2025-06-28 3072.00
3349 2025-06-29 3072.00
3350 2025-06-30 3072.00
2025-06-30 17:50:28,549 - IOOppi_data - INFO : save new data to db IOOppi_rb_g: date value ... created_at updated_at
3351 2025-06-28 3072.0 ... 2025-06-30 17:50:28.542341 2025-06-30 17:50:28.542728
3352 2025-06-29 3072.0 ... 2025-06-30 17:50:28.542341 2025-06-30 17:50:28.542728
3353 2025-06-30 3072.0 ... 2025-06-30 17:50:28.542341 2025-06-30 17:50:28.542728
[3 rows x 5 columns]
2025-06-30 17:50:28,568 - 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-30 17:50:29,155 - IOOppi_data - INFO : save data to db IOOppi_MA_t data:
date value
3567 2025-06-26 2750.83
3568 2025-06-27 2785.83
3569 2025-06-28 2785.83
3570 2025-06-29 2785.83
3571 2025-06-30 2805.00
2025-06-30 17:50:29,231 - IOOppi_data - INFO : save new data to db IOOppi_MA_t: date value ... created_at updated_at
3569 2025-06-28 2785.83 ... 2025-06-30 17:50:29.223886 2025-06-30 17:50:29.224284
3570 2025-06-29 2785.83 ... 2025-06-30 17:50:29.223886 2025-06-30 17:50:29.224284
3571 2025-06-30 2805.00 ... 2025-06-30 17:50:29.223886 2025-06-30 17:50:29.224284
[3 rows x 5 columns]
2025-06-30 17:50:29,249 - IOOppi_data - INFO : save diff data to db: IOOppi_MA_t: no diff data
2025-06-30 17:50:29,255 - IOOppi_data - INFO : save data to db IOOppi_MA_g data:
date value
3567 2025-06-26 2750.83
3568 2025-06-27 2785.83
3569 2025-06-28 2785.83
3570 2025-06-29 2785.83
3571 2025-06-30 2805.00
2025-06-30 17:50:29,330 - IOOppi_data - INFO : save new data to db IOOppi_MA_g: date value ... created_at updated_at
3573 2025-06-28 2785.83 ... 2025-06-30 17:50:29.322500 2025-06-30 17:50:29.322920
3574 2025-06-29 2785.83 ... 2025-06-30 17:50:29.322500 2025-06-30 17:50:29.322920
3575 2025-06-30 2805.00 ... 2025-06-30 17:50:29.322500 2025-06-30 17:50:29.322920
[3 rows x 5 columns]
2025-06-30 17:50:29,348 - 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-30 17:50:29,895 - IOOppi_data - INFO : save data to db IOOppi_PTA_t data:
date value
907 2025-06-26 5083.25
908 2025-06-27 5084.75
909 2025-06-28 5084.75
910 2025-06-29 5084.75
911 2025-06-30 5104.75
2025-06-30 17:50:29,937 - IOOppi_data - INFO : save new data to db IOOppi_PTA_t: date value ... created_at updated_at
909 2025-06-28 5084.75 ... 2025-06-30 17:50:29.929594 2025-06-30 17:50:29.930016
910 2025-06-29 5084.75 ... 2025-06-30 17:50:29.929594 2025-06-30 17:50:29.930016
911 2025-06-30 5104.75 ... 2025-06-30 17:50:29.929594 2025-06-30 17:50:29.930016
[3 rows x 5 columns]
2025-06-30 17:50:29,956 - IOOppi_data - INFO : save diff data to db: IOOppi_PTA_t: no diff data
2025-06-30 17:50:29,962 - IOOppi_data - INFO : save data to db IOOppi_PTA_g data:
date value
907 2025-06-26 5083.25
908 2025-06-27 5084.75
909 2025-06-28 5084.75
910 2025-06-29 5084.75
911 2025-06-30 5104.75
2025-06-30 17:50:30,004 - IOOppi_data - INFO : save new data to db IOOppi_PTA_g: date value ... created_at updated_at
909 2025-06-28 5084.75 ... 2025-06-30 17:50:29.996846 2025-06-30 17:50:29.997224
910 2025-06-29 5084.75 ... 2025-06-30 17:50:29.996846 2025-06-30 17:50:29.997224
911 2025-06-30 5104.75 ... 2025-06-30 17:50:29.996846 2025-06-30 17:50:29.997224
[3 rows x 5 columns]
2025-06-30 17:50:30,023 - 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-30 17:50:30,598 - IOOppi_data - INFO : save data to db IOOppi_ru_t data:
date value
3786 2025-06-26 13878.33
3787 2025-06-27 13878.33
3788 2025-06-28 13878.33
3789 2025-06-29 13878.33
3790 2025-06-30 13858.33
2025-06-30 17:50:30,678 - IOOppi_data - INFO : save new data to db IOOppi_ru_t: date ... updated_at
3788 2025-06-28 ... 2025-06-30 17:50:30.671348
3789 2025-06-29 ... 2025-06-30 17:50:30.671348
3790 2025-06-30 ... 2025-06-30 17:50:30.671348
[3 rows x 5 columns]
2025-06-30 17:50:30,697 - IOOppi_data - INFO : save diff data to db: IOOppi_ru_t: no diff data
2025-06-30 17:50:30,703 - IOOppi_data - INFO : save data to db IOOppi_ru_g data:
date value
3786 2025-06-26 13878.33
3787 2025-06-27 13878.33
3788 2025-06-28 13878.33
3789 2025-06-29 13878.33
3790 2025-06-30 13858.33
2025-06-30 17:50:30,778 - IOOppi_data - INFO : save new data to db IOOppi_ru_g: date ... updated_at
3791 2025-06-28 ... 2025-06-30 17:50:30.771803
3792 2025-06-29 ... 2025-06-30 17:50:30.771803
3793 2025-06-30 ... 2025-06-30 17:50:30.771803
[3 rows x 5 columns]
2025-06-30 17:50:30,797 - 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-30 17:50:31,348 - IOOppi_data - INFO : save data to db IOOppi_i_t data:
date value
3118 2025-06-26 715.78
3119 2025-06-27 725.44
3120 2025-06-28 725.44
3121 2025-06-29 725.44
3122 2025-06-30 726.56
2025-06-30 17:50:31,422 - IOOppi_data - INFO : save new data to db IOOppi_i_t: date value ... created_at updated_at
3120 2025-06-28 725.44 ... 2025-06-30 17:50:31.414407 2025-06-30 17:50:31.415072
3121 2025-06-29 725.44 ... 2025-06-30 17:50:31.414407 2025-06-30 17:50:31.415072
3122 2025-06-30 726.56 ... 2025-06-30 17:50:31.414407 2025-06-30 17:50:31.415072
[3 rows x 5 columns]
2025-06-30 17:50:31,441 - IOOppi_data - INFO : save diff data to db: IOOppi_i_t: no diff data
2025-06-30 17:50:31,448 - IOOppi_data - INFO : save data to db IOOppi_i_g data:
date value
3118 2025-06-26 715.78
3119 2025-06-27 725.44
3120 2025-06-28 725.44
3121 2025-06-29 725.44
3122 2025-06-30 726.56
2025-06-30 17:50:31,517 - IOOppi_data - INFO : save new data to db IOOppi_i_g: date value ... created_at updated_at
3123 2025-06-28 725.44 ... 2025-06-30 17:50:31.509217 2025-06-30 17:50:31.509606
3124 2025-06-29 725.44 ... 2025-06-30 17:50:31.509217 2025-06-30 17:50:31.509606
3125 2025-06-30 726.56 ... 2025-06-30 17:50:31.509217 2025-06-30 17:50:31.509606
[3 rows x 5 columns]
2025-06-30 17:50:31,535 - 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-30 17:50:32,065 - IOOppi_data - INFO : save data to db IOOppi_FG_t data:
date value
3321 2025-06-26 1105.6
3322 2025-06-27 1105.6
3323 2025-06-28 1105.6
3324 2025-06-29 1105.6
3325 2025-06-30 1105.6
2025-06-30 17:50:32,135 - IOOppi_data - INFO : save new data to db IOOppi_FG_t: date value ... created_at updated_at
3323 2025-06-28 1105.6 ... 2025-06-30 17:50:32.128022 2025-06-30 17:50:32.128416
3324 2025-06-29 1105.6 ... 2025-06-30 17:50:32.128022 2025-06-30 17:50:32.128416
3325 2025-06-30 1105.6 ... 2025-06-30 17:50:32.128022 2025-06-30 17:50:32.128416
[3 rows x 5 columns]
/root/project/IOOppi_data/IOOppi_request.py:308: SettingWithCopyWarning:
A value is trying to be set on a copy of a slice from a DataFrame.
Try using .loc[row_indexer,col_indexer] = value instead
See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy
diff_df.loc[:, 'index_code'] = index_code
/root/project/IOOppi_data/IOOppi_request.py:309: SettingWithCopyWarning:
A value is trying to be set on a copy of a slice from a DataFrame.
Try using .loc[row_indexer,col_indexer] = value instead
See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy
diff_df.loc[:, 'created_at'] = datetime.datetime.now()
/root/project/IOOppi_data/IOOppi_request.py:310: SettingWithCopyWarning:
A value is trying to be set on a copy of a slice from a DataFrame.
Try using .loc[row_indexer,col_indexer] = value instead
See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy
diff_df.loc[:, 'updated_at'] = datetime.datetime.now()
2025-06-30 17:50:34,149 - IOOppi_data - INFO : save diff data to db IOOppi_FG_t: date ... updated_at
12 2012-12-19 ... 2025-06-30 17:50:34.141102
21 2013-01-04 ... 2025-06-30 17:50:34.141102
54 2013-02-27 ... 2025-06-30 17:50:34.141102
60 2013-03-07 ... 2025-06-30 17:50:34.141102
61 2013-03-08 ... 2025-06-30 17:50:34.141102
[5 rows x 6 columns]
2025-06-30 17:50:34,322 - IOOppi_data - INFO : save data to db IOOppi_FG_g data:
date value
3321 2025-06-26 1105.6
3322 2025-06-27 1105.6
3323 2025-06-28 1105.6
3324 2025-06-29 1105.6
3325 2025-06-30 1105.6
2025-06-30 17:50:34,401 - IOOppi_data - INFO : save new data to db IOOppi_FG_g: date value ... created_at updated_at
3327 2025-06-28 1105.6 ... 2025-06-30 17:50:34.393507 2025-06-30 17:50:34.393919
3328 2025-06-29 1105.6 ... 2025-06-30 17:50:34.393507 2025-06-30 17:50:34.393919
3329 2025-06-30 1105.6 ... 2025-06-30 17:50:34.393507 2025-06-30 17:50:34.393919
[3 rows x 5 columns]
/root/project/IOOppi_data/IOOppi_request.py:308: SettingWithCopyWarning:
A value is trying to be set on a copy of a slice from a DataFrame.
Try using .loc[row_indexer,col_indexer] = value instead
See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy
diff_df.loc[:, 'index_code'] = index_code
/root/project/IOOppi_data/IOOppi_request.py:309: SettingWithCopyWarning:
A value is trying to be set on a copy of a slice from a DataFrame.
Try using .loc[row_indexer,col_indexer] = value instead
See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy
diff_df.loc[:, 'created_at'] = datetime.datetime.now()
/root/project/IOOppi_data/IOOppi_request.py:310: SettingWithCopyWarning:
A value is trying to be set on a copy of a slice from a DataFrame.
Try using .loc[row_indexer,col_indexer] = value instead
See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy
diff_df.loc[:, 'updated_at'] = datetime.datetime.now()
2025-06-30 17:50:36,314 - IOOppi_data - INFO : save diff data to db IOOppi_FG_g: date ... updated_at
12 2012-12-19 ... 2025-06-30 17:50:36.306173
21 2013-01-04 ... 2025-06-30 17:50:36.306173
54 2013-02-27 ... 2025-06-30 17:50:36.306173
60 2013-03-07 ... 2025-06-30 17:50:36.306173
61 2013-03-08 ... 2025-06-30 17:50:36.306173
[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-30 17:50:37,023 - IOOppi_data - INFO : save data to db IOOppi_eb_t data:
date value
1666 2025-06-26 8164.0
1667 2025-06-27 8084.0
1668 2025-06-28 8084.0
1669 2025-06-29 8084.0
1670 2025-06-30 8050.0
2025-06-30 17:50:37,073 - IOOppi_data - INFO : save new data to db IOOppi_eb_t: date value ... created_at updated_at
1668 2025-06-28 8084.0 ... 2025-06-30 17:50:37.065541 2025-06-30 17:50:37.066004
1669 2025-06-29 8084.0 ... 2025-06-30 17:50:37.065541 2025-06-30 17:50:37.066004
1670 2025-06-30 8050.0 ... 2025-06-30 17:50:37.065541 2025-06-30 17:50:37.066004
[3 rows x 5 columns]
2025-06-30 17:50:37,092 - IOOppi_data - INFO : save diff data to db: IOOppi_eb_t: no diff data
2025-06-30 17:50:37,098 - IOOppi_data - INFO : save data to db IOOppi_eb_g data:
date value
1666 2025-06-26 8164.0
1667 2025-06-27 8084.0
1668 2025-06-28 8084.0
1669 2025-06-29 8084.0
1670 2025-06-30 8050.0
2025-06-30 17:50:37,147 - IOOppi_data - INFO : save new data to db IOOppi_eb_g: date value ... created_at updated_at
1671 2025-06-28 8084.0 ... 2025-06-30 17:50:37.139985 2025-06-30 17:50:37.140413
1672 2025-06-29 8084.0 ... 2025-06-30 17:50:37.139985 2025-06-30 17:50:37.140413
1673 2025-06-30 8050.0 ... 2025-06-30 17:50:37.139985 2025-06-30 17:50:37.140413
[3 rows x 5 columns]
2025-06-30 17:50:37,165 - 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-30 17:50:37,697 - IOOppi_data - INFO : save data to db IOOppi_SR_t data:
date value
3777 2025-06-26 6050.00
3778 2025-06-27 6056.67
3779 2025-06-28 6056.67
3780 2025-06-29 6056.67
3781 2025-06-30 6053.33
2025-06-30 17:50:37,783 - IOOppi_data - INFO : save new data to db IOOppi_SR_t: date value ... created_at updated_at
3779 2025-06-28 6056.67 ... 2025-06-30 17:50:37.772518 2025-06-30 17:50:37.773161
3780 2025-06-29 6056.67 ... 2025-06-30 17:50:37.772518 2025-06-30 17:50:37.773161
3781 2025-06-30 6053.33 ... 2025-06-30 17:50:37.772518 2025-06-30 17:50:37.773161
[3 rows x 5 columns]
2025-06-30 17:50:37,806 - IOOppi_data - INFO : save diff data to db: IOOppi_SR_t: no diff data
2025-06-30 17:50:37,814 - IOOppi_data - INFO : save data to db IOOppi_SR_g data:
date value
3777 2025-06-26 6050.00
3778 2025-06-27 6056.67
3779 2025-06-28 6056.67
3780 2025-06-29 6056.67
3781 2025-06-30 6053.33
2025-06-30 17:50:37,888 - IOOppi_data - INFO : save new data to db IOOppi_SR_g: date value ... created_at updated_at
3783 2025-06-28 6056.67 ... 2025-06-30 17:50:37.880858 2025-06-30 17:50:37.881265
3784 2025-06-29 6056.67 ... 2025-06-30 17:50:37.880858 2025-06-30 17:50:37.881265
3785 2025-06-30 6053.33 ... 2025-06-30 17:50:37.880858 2025-06-30 17:50:37.881265
[3 rows x 5 columns]
2025-06-30 17:50:37,907 - 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-30 17:50:38,545 - IOOppi_data - INFO : save data to db IOOppi_ss_t data:
date value
1667 2025-06-26 12725.0
1668 2025-06-27 12762.5
1669 2025-06-28 12762.5
1670 2025-06-29 12762.5
1671 2025-06-30 12775.0
2025-06-30 17:50:38,591 - IOOppi_data - INFO : save new data to db IOOppi_ss_t: date value ... created_at updated_at
1669 2025-06-28 12762.5 ... 2025-06-30 17:50:38.584077 2025-06-30 17:50:38.584463
1670 2025-06-29 12762.5 ... 2025-06-30 17:50:38.584077 2025-06-30 17:50:38.584463
1671 2025-06-30 12775.0 ... 2025-06-30 17:50:38.584077 2025-06-30 17:50:38.584463
[3 rows x 5 columns]
2025-06-30 17:50:38,611 - IOOppi_data - INFO : save diff data to db: IOOppi_ss_t: no diff data
2025-06-30 17:50:38,616 - IOOppi_data - INFO : save data to db IOOppi_ss_g data:
date value
1667 2025-06-26 12725.0
1668 2025-06-27 12762.5
1669 2025-06-28 12762.5
1670 2025-06-29 12762.5
1671 2025-06-30 12775.0
2025-06-30 17:50:38,665 - IOOppi_data - INFO : save new data to db IOOppi_ss_g: date value ... created_at updated_at
1672 2025-06-28 12762.5 ... 2025-06-30 17:50:38.657590 2025-06-30 17:50:38.658054
1673 2025-06-29 12762.5 ... 2025-06-30 17:50:38.657590 2025-06-30 17:50:38.658054
1674 2025-06-30 12775.0 ... 2025-06-30 17:50:38.657590 2025-06-30 17:50:38.658054
[3 rows x 5 columns]
2025-06-30 17:50:38,684 - 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-30 17:50:39,499 - IOOppi_data - INFO : save data to db IOOppi_RS_t data:
date value
3177 2025-06-26 9631.67
3178 2025-06-27 9631.67
3179 2025-06-28 9631.67
3180 2025-06-29 9631.67
3181 2025-06-30 9581.67
2025-06-30 17:50:39,569 - IOOppi_data - INFO : save new data to db IOOppi_RS_t: date value ... created_at updated_at
3179 2025-06-28 9631.67 ... 2025-06-30 17:50:39.562109 2025-06-30 17:50:39.562499
3180 2025-06-29 9631.67 ... 2025-06-30 17:50:39.562109 2025-06-30 17:50:39.562499
3181 2025-06-30 9581.67 ... 2025-06-30 17:50:39.562109 2025-06-30 17:50:39.562499
[3 rows x 5 columns]
2025-06-30 17:50:39,589 - IOOppi_data - INFO : save diff data to db: IOOppi_RS_t: no diff data
2025-06-30 17:50:39,595 - IOOppi_data - INFO : save data to db IOOppi_RS_g data:
date value
3177 2025-06-26 9631.67
3178 2025-06-27 9631.67
3179 2025-06-28 9631.67
3180 2025-06-29 9631.67
3181 2025-06-30 9581.67
2025-06-30 17:50:39,664 - IOOppi_data - INFO : save new data to db IOOppi_RS_g: date value ... created_at updated_at
3183 2025-06-28 9631.67 ... 2025-06-30 17:50:39.656326 2025-06-30 17:50:39.656714
3184 2025-06-29 9631.67 ... 2025-06-30 17:50:39.656326 2025-06-30 17:50:39.656714
3185 2025-06-30 9581.67 ... 2025-06-30 17:50:39.656326 2025-06-30 17:50:39.656714
[3 rows x 5 columns]
2025-06-30 17:50:39,683 - 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-30 17:50:40,388 - IOOppi_data - INFO : save data to db IOOppi_RM_t data:
date value
3300 2025-06-26 2478.33
3301 2025-06-27 2475.00
3302 2025-06-28 2475.00
3303 2025-06-29 2475.00
3304 2025-06-30 2500.00
2025-06-30 17:50:40,457 - IOOppi_data - INFO : save new data to db IOOppi_RM_t: date value ... created_at updated_at
3302 2025-06-28 2475.0 ... 2025-06-30 17:50:40.449072 2025-06-30 17:50:40.449504
3303 2025-06-29 2475.0 ... 2025-06-30 17:50:40.449072 2025-06-30 17:50:40.449504
3304 2025-06-30 2500.0 ... 2025-06-30 17:50:40.449072 2025-06-30 17:50:40.449504
[3 rows x 5 columns]
2025-06-30 17:50:40,476 - IOOppi_data - INFO : save diff data to db: IOOppi_RM_t: no diff data
2025-06-30 17:50:40,482 - IOOppi_data - INFO : save data to db IOOppi_RM_g data:
date value
3300 2025-06-26 2478.33
3301 2025-06-27 2475.00
3302 2025-06-28 2475.00
3303 2025-06-29 2475.00
3304 2025-06-30 2500.00
2025-06-30 17:50:40,548 - IOOppi_data - INFO : save new data to db IOOppi_RM_g: date value ... created_at updated_at
3306 2025-06-28 2475.0 ... 2025-06-30 17:50:40.541409 2025-06-30 17:50:40.541817
3307 2025-06-29 2475.0 ... 2025-06-30 17:50:40.541409 2025-06-30 17:50:40.541817
3308 2025-06-30 2500.0 ... 2025-06-30 17:50:40.541409 2025-06-30 17:50:40.541817
[3 rows x 5 columns]
2025-06-30 17:50:40,567 - 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-30 17:50:41,120 - IOOppi_data - INFO : save data to db IOOppi_SA_t data:
date value
1504 2025-06-26 1337.5
1505 2025-06-27 1337.5
1506 2025-06-28 1337.5
1507 2025-06-29 1337.5
1508 2025-06-30 1325.0
2025-06-30 17:50:41,165 - IOOppi_data - INFO : save new data to db IOOppi_SA_t: date value ... created_at updated_at
1506 2025-06-28 1337.5 ... 2025-06-30 17:50:41.157355 2025-06-30 17:50:41.157744
1507 2025-06-29 1337.5 ... 2025-06-30 17:50:41.157355 2025-06-30 17:50:41.157744
1508 2025-06-30 1325.0 ... 2025-06-30 17:50:41.157355 2025-06-30 17:50:41.157744
[3 rows x 5 columns]
2025-06-30 17:50:41,184 - IOOppi_data - INFO : save diff data to db: IOOppi_SA_t: no diff data
2025-06-30 17:50:41,189 - IOOppi_data - INFO : save data to db IOOppi_SA_g data:
date value
1504 2025-06-26 1337.5
1505 2025-06-27 1337.5
1506 2025-06-28 1337.5
1507 2025-06-29 1337.5
1508 2025-06-30 1325.0
2025-06-30 17:50:41,235 - IOOppi_data - INFO : save new data to db IOOppi_SA_g: date value ... created_at updated_at
1510 2025-06-28 1337.5 ... 2025-06-30 17:50:41.227379 2025-06-30 17:50:41.227797
1511 2025-06-29 1337.5 ... 2025-06-30 17:50:41.227379 2025-06-30 17:50:41.227797
1512 2025-06-30 1325.0 ... 2025-06-30 17:50:41.227379 2025-06-30 17:50:41.227797
[3 rows x 5 columns]
2025-06-30 17:50:41,254 - 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-30 17:50:41,842 - IOOppi_data - INFO : save data to db IOOppi_PF_t data:
date value
1417 2025-06-26 6767.29
1418 2025-06-27 6736.04
1419 2025-06-28 6736.04
1420 2025-06-29 6736.04
1421 2025-06-30 6727.92
2025-06-30 17:50:41,886 - IOOppi_data - INFO : save new data to db IOOppi_PF_t: date value ... created_at updated_at
1419 2025-06-28 6736.04 ... 2025-06-30 17:50:41.878901 2025-06-30 17:50:41.879312
1420 2025-06-29 6736.04 ... 2025-06-30 17:50:41.878901 2025-06-30 17:50:41.879312
1421 2025-06-30 6727.92 ... 2025-06-30 17:50:41.878901 2025-06-30 17:50:41.879312
[3 rows x 5 columns]
2025-06-30 17:50:41,905 - IOOppi_data - INFO : save diff data to db: IOOppi_PF_t: no diff data
2025-06-30 17:50:41,911 - IOOppi_data - INFO : save data to db IOOppi_PF_g data:
date value
1417 2025-06-26 6767.29
1418 2025-06-27 6736.04
1419 2025-06-28 6736.04
1420 2025-06-29 6736.04
1421 2025-06-30 6727.92
2025-06-30 17:50:41,956 - IOOppi_data - INFO : save new data to db IOOppi_PF_g: date value ... created_at updated_at
1423 2025-06-28 6736.04 ... 2025-06-30 17:50:41.948549 2025-06-30 17:50:41.948971
1424 2025-06-29 6736.04 ... 2025-06-30 17:50:41.948549 2025-06-30 17:50:41.948971
1425 2025-06-30 6727.92 ... 2025-06-30 17:50:41.948549 2025-06-30 17:50:41.948971
[3 rows x 5 columns]
2025-06-30 17:50:41,974 - 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-30 17:50:42,564 - IOOppi_data - INFO : save data to db IOOppi_m_t data:
date value
3790 2025-06-26 2916.0
3791 2025-06-27 2906.0
3792 2025-06-28 2906.0
3793 2025-06-29 2906.0
3794 2025-06-30 2906.0
2025-06-30 17:50:42,640 - IOOppi_data - INFO : save new data to db IOOppi_m_t: date value ... created_at updated_at
3792 2025-06-28 2906.0 ... 2025-06-30 17:50:42.633059 2025-06-30 17:50:42.633478
3793 2025-06-29 2906.0 ... 2025-06-30 17:50:42.633059 2025-06-30 17:50:42.633478
3794 2025-06-30 2906.0 ... 2025-06-30 17:50:42.633059 2025-06-30 17:50:42.633478
[3 rows x 5 columns]
2025-06-30 17:50:42,661 - IOOppi_data - INFO : save diff data to db: IOOppi_m_t: no diff data
2025-06-30 17:50:42,667 - IOOppi_data - INFO : save data to db IOOppi_m_g data:
date value
3790 2025-06-26 2916.0
3791 2025-06-27 2906.0
3792 2025-06-28 2906.0
3793 2025-06-29 2906.0
3794 2025-06-30 2906.0
2025-06-30 17:50:42,743 - IOOppi_data - INFO : save new data to db IOOppi_m_g: date value ... created_at updated_at
3795 2025-06-28 2906.0 ... 2025-06-30 17:50:42.736090 2025-06-30 17:50:42.736477
3796 2025-06-29 2906.0 ... 2025-06-30 17:50:42.736090 2025-06-30 17:50:42.736477
3797 2025-06-30 2906.0 ... 2025-06-30 17:50:42.736090 2025-06-30 17:50:42.736477
[3 rows x 5 columns]
2025-06-30 17:50:42,761 - 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-30 17:50:43,379 - IOOppi_data - INFO : save data to db IOOppi_y_t data:
date value
3560 2025-06-26 8254.0
3561 2025-06-27 8254.0
3562 2025-06-28 8254.0
3563 2025-06-29 8254.0
3564 2025-06-30 8234.0
2025-06-30 17:50:43,450 - IOOppi_data - INFO : save new data to db IOOppi_y_t: date value ... created_at updated_at
3562 2025-06-28 8254.0 ... 2025-06-30 17:50:43.443446 2025-06-30 17:50:43.443862
3563 2025-06-29 8254.0 ... 2025-06-30 17:50:43.443446 2025-06-30 17:50:43.443862
3564 2025-06-30 8234.0 ... 2025-06-30 17:50:43.443446 2025-06-30 17:50:43.443862
[3 rows x 5 columns]
2025-06-30 17:50:43,469 - IOOppi_data - INFO : save diff data to db: IOOppi_y_t: no diff data
2025-06-30 17:50:43,476 - IOOppi_data - INFO : save data to db IOOppi_y_g data:
date value
3560 2025-06-26 8254.0
3561 2025-06-27 8254.0
3562 2025-06-28 8254.0
3563 2025-06-29 8254.0
3564 2025-06-30 8234.0
2025-06-30 17:50:43,551 - IOOppi_data - INFO : save new data to db IOOppi_y_g: date value ... created_at updated_at
3565 2025-06-28 8254.0 ... 2025-06-30 17:50:43.543909 2025-06-30 17:50:43.544301
3566 2025-06-29 8254.0 ... 2025-06-30 17:50:43.543909 2025-06-30 17:50:43.544301
3567 2025-06-30 8234.0 ... 2025-06-30 17:50:43.543909 2025-06-30 17:50:43.544301
[3 rows x 5 columns]
2025-06-30 17:50:43,570 - 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-30 17:50:44,254 - IOOppi_data - INFO : save data to db IOOppi_a_t data:
date value
3526 2025-06-26 4295.0
3527 2025-06-27 4295.0
3528 2025-06-28 4295.0
3529 2025-06-29 4295.0
3530 2025-06-30 4295.0
2025-06-30 17:50:44,323 - IOOppi_data - INFO : save new data to db IOOppi_a_t: date value ... created_at updated_at
3528 2025-06-28 4295.0 ... 2025-06-30 17:50:44.316334 2025-06-30 17:50:44.316711
3529 2025-06-29 4295.0 ... 2025-06-30 17:50:44.316334 2025-06-30 17:50:44.316711
3530 2025-06-30 4295.0 ... 2025-06-30 17:50:44.316334 2025-06-30 17:50:44.316711
[3 rows x 5 columns]
2025-06-30 17:50:44,342 - IOOppi_data - INFO : save diff data to db: IOOppi_a_t: no diff data
2025-06-30 17:50:44,348 - IOOppi_data - INFO : save data to db IOOppi_a_g data:
date value
3526 2025-06-26 4295.0
3527 2025-06-27 4295.0
3528 2025-06-28 4295.0
3529 2025-06-29 4295.0
3530 2025-06-30 4295.0
2025-06-30 17:50:44,417 - IOOppi_data - INFO : save new data to db IOOppi_a_g: date value ... created_at updated_at
3531 2025-06-28 4295.0 ... 2025-06-30 17:50:44.410108 2025-06-30 17:50:44.410490
3532 2025-06-29 4295.0 ... 2025-06-30 17:50:44.410108 2025-06-30 17:50:44.410490
3533 2025-06-30 4295.0 ... 2025-06-30 17:50:44.410108 2025-06-30 17:50:44.410490
[3 rows x 5 columns]
2025-06-30 17:50:44,435 - 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-30 17:50:45,066 - IOOppi_data - INFO : save data to db IOOppi_SF_t data:
date value
2903 2025-06-26 5132.86
2904 2025-06-27 5158.57
2905 2025-06-28 5158.57
2906 2025-06-29 5158.57
2907 2025-06-30 5158.57
2025-06-30 17:50:45,131 - IOOppi_data - INFO : save new data to db IOOppi_SF_t: date value ... created_at updated_at
2905 2025-06-28 5158.57 ... 2025-06-30 17:50:45.120061 2025-06-30 17:50:45.120455
2906 2025-06-29 5158.57 ... 2025-06-30 17:50:45.120061 2025-06-30 17:50:45.120455
2907 2025-06-30 5158.57 ... 2025-06-30 17:50:45.120061 2025-06-30 17:50:45.120455
[3 rows x 5 columns]
2025-06-30 17:50:45,150 - IOOppi_data - INFO : save diff data to db: IOOppi_SF_t: no diff data
2025-06-30 17:50:45,156 - IOOppi_data - INFO : save data to db IOOppi_SF_g data:
date value
2903 2025-06-26 5132.86
2904 2025-06-27 5158.57
2905 2025-06-28 5158.57
2906 2025-06-29 5158.57
2907 2025-06-30 5158.57
2025-06-30 17:50:45,218 - IOOppi_data - INFO : save new data to db IOOppi_SF_g: date value ... created_at updated_at
2909 2025-06-28 5158.57 ... 2025-06-30 17:50:45.210821 2025-06-30 17:50:45.211221
2910 2025-06-29 5158.57 ... 2025-06-30 17:50:45.210821 2025-06-30 17:50:45.211221
2911 2025-06-30 5158.57 ... 2025-06-30 17:50:45.210821 2025-06-30 17:50:45.211221
[3 rows x 5 columns]
2025-06-30 17:50:45,238 - 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-30 17:50:46,039 - IOOppi_data - INFO : save data to db IOOppi_jd_t data:
date value
3103 2025-06-26 2890.0
3104 2025-06-27 2890.0
3105 2025-06-28 2890.0
3106 2025-06-29 2890.0
3107 2025-06-30 2810.0
2025-06-30 17:50:46,103 - IOOppi_data - INFO : save new data to db IOOppi_jd_t: date value ... created_at updated_at
3105 2025-06-28 2890.0 ... 2025-06-30 17:50:46.096140 2025-06-30 17:50:46.096532
3106 2025-06-29 2890.0 ... 2025-06-30 17:50:46.096140 2025-06-30 17:50:46.096532
3107 2025-06-30 2810.0 ... 2025-06-30 17:50:46.096140 2025-06-30 17:50:46.096532
[3 rows x 5 columns]
/root/project/IOOppi_data/IOOppi_request.py:308: SettingWithCopyWarning:
A value is trying to be set on a copy of a slice from a DataFrame.
Try using .loc[row_indexer,col_indexer] = value instead
See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy
diff_df.loc[:, 'index_code'] = index_code
/root/project/IOOppi_data/IOOppi_request.py:309: SettingWithCopyWarning:
A value is trying to be set on a copy of a slice from a DataFrame.
Try using .loc[row_indexer,col_indexer] = value instead
See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy
diff_df.loc[:, 'created_at'] = datetime.datetime.now()
/root/project/IOOppi_data/IOOppi_request.py:310: SettingWithCopyWarning:
A value is trying to be set on a copy of a slice from a DataFrame.
Try using .loc[row_indexer,col_indexer] = value instead
See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy
diff_df.loc[:, 'updated_at'] = datetime.datetime.now()
2025-06-30 17:50:46,250 - IOOppi_data - INFO : save diff data to db IOOppi_jd_t: date ... updated_at
39 2014-01-03 ... 2025-06-30 17:50:46.242725
458 2015-09-21 ... 2025-06-30 17:50:46.242725
549 2016-02-03 ... 2025-06-30 17:50:46.242725
693 2016-09-05 ... 2025-06-30 17:50:46.242725
696 2016-09-08 ... 2025-06-30 17:50:46.242725
[5 rows x 6 columns]
2025-06-30 17:50:46,282 - IOOppi_data - INFO : save data to db IOOppi_jd_g data:
date value
3103 2025-06-26 2890.0
3104 2025-06-27 2890.0
3105 2025-06-28 2890.0
3106 2025-06-29 2890.0
3107 2025-06-30 2810.0
2025-06-30 17:50:46,348 - IOOppi_data - INFO : save new data to db IOOppi_jd_g: date value ... created_at updated_at
3108 2025-06-28 2890.0 ... 2025-06-30 17:50:46.340725 2025-06-30 17:50:46.341137
3109 2025-06-29 2890.0 ... 2025-06-30 17:50:46.340725 2025-06-30 17:50:46.341137
3110 2025-06-30 2810.0 ... 2025-06-30 17:50:46.340725 2025-06-30 17:50:46.341137
[3 rows x 5 columns]
/root/project/IOOppi_data/IOOppi_request.py:308: SettingWithCopyWarning:
A value is trying to be set on a copy of a slice from a DataFrame.
Try using .loc[row_indexer,col_indexer] = value instead
See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy
diff_df.loc[:, 'index_code'] = index_code
/root/project/IOOppi_data/IOOppi_request.py:309: SettingWithCopyWarning:
A value is trying to be set on a copy of a slice from a DataFrame.
Try using .loc[row_indexer,col_indexer] = value instead
See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy
diff_df.loc[:, 'created_at'] = datetime.datetime.now()
/root/project/IOOppi_data/IOOppi_request.py:310: SettingWithCopyWarning:
A value is trying to be set on a copy of a slice from a DataFrame.
Try using .loc[row_indexer,col_indexer] = value instead
See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy
diff_df.loc[:, 'updated_at'] = datetime.datetime.now()
2025-06-30 17:50:46,494 - IOOppi_data - INFO : save diff data to db IOOppi_jd_g: date ... updated_at
39 2014-01-03 ... 2025-06-30 17:50:46.486271
458 2015-09-21 ... 2025-06-30 17:50:46.486271
549 2016-02-03 ... 2025-06-30 17:50:46.486271
693 2016-09-05 ... 2025-06-30 17:50:46.486271
696 2016-09-08 ... 2025-06-30 17:50:46.486271
[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-30 17:50:47,116 - IOOppi_data - INFO : save data to db IOOppi_SI_t data:
date value
907 2025-06-26 8620.0
908 2025-06-27 8620.0
909 2025-06-28 8640.0
910 2025-06-29 8640.0
911 2025-06-30 8730.0
2025-06-30 17:50:47,154 - IOOppi_data - INFO : save new data to db IOOppi_SI_t: date value ... created_at updated_at
909 2025-06-28 8640.0 ... 2025-06-30 17:50:47.145241 2025-06-30 17:50:47.145667
910 2025-06-29 8640.0 ... 2025-06-30 17:50:47.145241 2025-06-30 17:50:47.145667
911 2025-06-30 8730.0 ... 2025-06-30 17:50:47.145241 2025-06-30 17:50:47.145667
[3 rows x 5 columns]
2025-06-30 17:50:47,174 - IOOppi_data - INFO : save diff data to db: IOOppi_SI_t: no diff data
2025-06-30 17:50:47,180 - IOOppi_data - INFO : save data to db IOOppi_SI_g data:
date value
907 2025-06-26 8620.0
908 2025-06-27 8620.0
909 2025-06-28 8640.0
910 2025-06-29 8640.0
911 2025-06-30 8730.0
2025-06-30 17:50:47,216 - IOOppi_data - INFO : save new data to db IOOppi_SI_g: date value ... created_at updated_at
909 2025-06-28 8640.0 ... 2025-06-30 17:50:47.208691 2025-06-30 17:50:47.209097
910 2025-06-29 8640.0 ... 2025-06-30 17:50:47.208691 2025-06-30 17:50:47.209097
911 2025-06-30 8730.0 ... 2025-06-30 17:50:47.208691 2025-06-30 17:50:47.209097
[3 rows x 5 columns]
2025-06-30 17:50:47,237 - 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-30 17:50:47,800 - IOOppi_data - INFO : save data to db IOOppi_l_t data:
date value
3786 2025-06-26 7511.67
3787 2025-06-27 7511.67
3788 2025-06-28 7511.67
3789 2025-06-29 7511.67
3790 2025-06-30 7503.33
2025-06-30 17:50:47,873 - IOOppi_data - INFO : save new data to db IOOppi_l_t: date value ... created_at updated_at
3788 2025-06-28 7511.67 ... 2025-06-30 17:50:47.866008 2025-06-30 17:50:47.866398
3789 2025-06-29 7511.67 ... 2025-06-30 17:50:47.866008 2025-06-30 17:50:47.866398
3790 2025-06-30 7503.33 ... 2025-06-30 17:50:47.866008 2025-06-30 17:50:47.866398
[3 rows x 5 columns]
2025-06-30 17:50:47,892 - IOOppi_data - INFO : save diff data to db: IOOppi_l_t: no diff data
2025-06-30 17:50:47,898 - IOOppi_data - INFO : save data to db IOOppi_l_g data:
date value
3786 2025-06-26 7511.67
3787 2025-06-27 7511.67
3788 2025-06-28 7511.67
3789 2025-06-29 7511.67
3790 2025-06-30 7503.33
2025-06-30 17:50:47,972 - IOOppi_data - INFO : save new data to db IOOppi_l_g: date value ... created_at updated_at
3791 2025-06-28 7511.67 ... 2025-06-30 17:50:47.964971 2025-06-30 17:50:47.965430
3792 2025-06-29 7511.67 ... 2025-06-30 17:50:47.964971 2025-06-30 17:50:47.965430
3793 2025-06-30 7503.33 ... 2025-06-30 17:50:47.964971 2025-06-30 17:50:47.965430
[3 rows x 5 columns]
2025-06-30 17:50:47,990 - 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-30 17:50:48,618 - IOOppi_data - INFO : save data to db IOOppi_bu_t data:
date value
3124 2025-06-26 3700.00
3125 2025-06-27 3700.00
3126 2025-06-28 3700.00
3127 2025-06-29 3700.00
3128 2025-06-30 3673.33
2025-06-30 17:50:48,682 - IOOppi_data - INFO : save new data to db IOOppi_bu_t: date value ... created_at updated_at
3127 2025-06-28 3700.00 ... 2025-06-30 17:50:48.674645 2025-06-30 17:50:48.675063
3128 2025-06-29 3700.00 ... 2025-06-30 17:50:48.674645 2025-06-30 17:50:48.675063
3129 2025-06-30 3673.33 ... 2025-06-30 17:50:48.674645 2025-06-30 17:50:48.675063
[3 rows x 5 columns]
/root/project/IOOppi_data/IOOppi_request.py:308: SettingWithCopyWarning:
A value is trying to be set on a copy of a slice from a DataFrame.
Try using .loc[row_indexer,col_indexer] = value instead
See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy
diff_df.loc[:, 'index_code'] = index_code
/root/project/IOOppi_data/IOOppi_request.py:309: SettingWithCopyWarning:
A value is trying to be set on a copy of a slice from a DataFrame.
Try using .loc[row_indexer,col_indexer] = value instead
See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy
diff_df.loc[:, 'created_at'] = datetime.datetime.now()
/root/project/IOOppi_data/IOOppi_request.py:310: SettingWithCopyWarning:
A value is trying to be set on a copy of a slice from a DataFrame.
Try using .loc[row_indexer,col_indexer] = value instead
See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy
diff_df.loc[:, 'updated_at'] = datetime.datetime.now()
2025-06-30 17:50:48,717 - IOOppi_data - INFO : save diff data to db IOOppi_bu_t: date ... updated_at
2560 2023-12-09 ... 2025-06-30 17:50:48.710409
[1 rows x 6 columns]
2025-06-30 17:50:48,741 - IOOppi_data - INFO : save data to db IOOppi_bu_g data:
date value
3124 2025-06-26 3700.00
3125 2025-06-27 3700.00
3126 2025-06-28 3700.00
3127 2025-06-29 3700.00
3128 2025-06-30 3673.33
2025-06-30 17:50:48,806 - IOOppi_data - INFO : save new data to db IOOppi_bu_g: date value ... created_at updated_at
3129 2025-06-28 3700.00 ... 2025-06-30 17:50:48.798804 2025-06-30 17:50:48.799192
3130 2025-06-29 3700.00 ... 2025-06-30 17:50:48.798804 2025-06-30 17:50:48.799192
3131 2025-06-30 3673.33 ... 2025-06-30 17:50:48.798804 2025-06-30 17:50:48.799192
[3 rows x 5 columns]
2025-06-30 17:50:48,824 - 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-30 17:50:49,532 - IOOppi_data - INFO : save data to db IOOppi_al_t data:
date value
3789 2025-06-26 20550.00
3790 2025-06-27 20903.33
3791 2025-06-28 20903.33
3792 2025-06-29 20903.33
3793 2025-06-30 20786.67
2025-06-30 17:50:49,604 - IOOppi_data - INFO : save new data to db IOOppi_al_t: date ... updated_at
3791 2025-06-28 ... 2025-06-30 17:50:49.598114
3792 2025-06-29 ... 2025-06-30 17:50:49.598114
3793 2025-06-30 ... 2025-06-30 17:50:49.598114
[3 rows x 5 columns]
2025-06-30 17:50:49,623 - IOOppi_data - INFO : save diff data to db: IOOppi_al_t: no diff data
2025-06-30 17:50:49,629 - IOOppi_data - INFO : save data to db IOOppi_al_g data:
date value
3789 2025-06-26 20550.00
3790 2025-06-27 20903.33
3791 2025-06-28 20903.33
3792 2025-06-29 20903.33
3793 2025-06-30 20786.67
2025-06-30 17:50:49,781 - IOOppi_data - INFO : save new data to db IOOppi_al_g: date ... updated_at
3794 2025-06-28 ... 2025-06-30 17:50:49.774492
3795 2025-06-29 ... 2025-06-30 17:50:49.774492
3796 2025-06-30 ... 2025-06-30 17:50:49.774492
[3 rows x 5 columns]
2025-06-30 17:50:49,799 - 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-30 17:50:50,421 - IOOppi_data - INFO : save data to db IOOppi_SM_t data:
date value
2903 2025-06-26 5562.0
2904 2025-06-27 5572.0
2905 2025-06-28 5572.0
2906 2025-06-29 5572.0
2907 2025-06-30 5564.0
2025-06-30 17:50:50,483 - IOOppi_data - INFO : save new data to db IOOppi_SM_t: date value ... created_at updated_at
2905 2025-06-28 5572.0 ... 2025-06-30 17:50:50.475556 2025-06-30 17:50:50.475982
2906 2025-06-29 5572.0 ... 2025-06-30 17:50:50.475556 2025-06-30 17:50:50.475982
2907 2025-06-30 5564.0 ... 2025-06-30 17:50:50.475556 2025-06-30 17:50:50.475982
[3 rows x 5 columns]
2025-06-30 17:50:50,502 - IOOppi_data - INFO : save diff data to db: IOOppi_SM_t: no diff data
2025-06-30 17:50:50,508 - IOOppi_data - INFO : save data to db IOOppi_SM_g data:
date value
2903 2025-06-26 5562.0
2904 2025-06-27 5572.0
2905 2025-06-28 5572.0
2906 2025-06-29 5572.0
2907 2025-06-30 5564.0
2025-06-30 17:50:50,570 - IOOppi_data - INFO : save new data to db IOOppi_SM_g: date value ... created_at updated_at
2909 2025-06-28 5572.0 ... 2025-06-30 17:50:50.562636 2025-06-30 17:50:50.563084
2910 2025-06-29 5572.0 ... 2025-06-30 17:50:50.562636 2025-06-30 17:50:50.563084
2911 2025-06-30 5564.0 ... 2025-06-30 17:50:50.562636 2025-06-30 17:50:50.563084
[3 rows x 5 columns]
2025-06-30 17:50:50,588 - 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-30 17:50:51,234 - IOOppi_data - INFO : save data to db IOOppi_CY_t data:
date value
2178 2025-06-26 23200.0
2179 2025-06-27 23200.0
2180 2025-06-28 23200.0
2181 2025-06-29 23200.0
2182 2025-06-30 23200.0
2025-06-30 17:50:51,289 - IOOppi_data - INFO : save new data to db IOOppi_CY_t: date value ... created_at updated_at
2180 2025-06-28 23200.0 ... 2025-06-30 17:50:51.281154 2025-06-30 17:50:51.281542
2181 2025-06-29 23200.0 ... 2025-06-30 17:50:51.281154 2025-06-30 17:50:51.281542
2182 2025-06-30 23200.0 ... 2025-06-30 17:50:51.281154 2025-06-30 17:50:51.281542
[3 rows x 5 columns]
2025-06-30 17:50:51,307 - IOOppi_data - INFO : save diff data to db: IOOppi_CY_t: no diff data
2025-06-30 17:50:51,313 - IOOppi_data - INFO : save data to db IOOppi_CY_g data:
date value
2178 2025-06-26 23200.0
2179 2025-06-27 23200.0
2180 2025-06-28 23200.0
2181 2025-06-29 23200.0
2182 2025-06-30 23200.0
2025-06-30 17:50:51,365 - IOOppi_data - INFO : save new data to db IOOppi_CY_g: date value ... created_at updated_at
2184 2025-06-28 23200.0 ... 2025-06-30 17:50:51.358267 2025-06-30 17:50:51.358642
2185 2025-06-29 23200.0 ... 2025-06-30 17:50:51.358267 2025-06-30 17:50:51.358642
2186 2025-06-30 23200.0 ... 2025-06-30 17:50:51.358267 2025-06-30 17:50:51.358642
[3 rows x 5 columns]
2025-06-30 17:50:51,383 - 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-30 17:50:51,950 - IOOppi_data - INFO : save data to db IOOppi_UR_t data:
date value
1693 2025-06-26 1822.6
1694 2025-06-27 1827.0
1695 2025-06-28 1827.0
1696 2025-06-29 1827.0
1697 2025-06-30 1823.0
2025-06-30 17:50:51,998 - IOOppi_data - INFO : save new data to db IOOppi_UR_t: date value ... created_at updated_at
1695 2025-06-28 1827.0 ... 2025-06-30 17:50:51.990449 2025-06-30 17:50:51.990876
1696 2025-06-29 1827.0 ... 2025-06-30 17:50:51.990449 2025-06-30 17:50:51.990876
1697 2025-06-30 1823.0 ... 2025-06-30 17:50:51.990449 2025-06-30 17:50:51.990876
[3 rows x 5 columns]
2025-06-30 17:50:52,017 - IOOppi_data - INFO : save diff data to db: IOOppi_UR_t: no diff data
2025-06-30 17:50:52,022 - IOOppi_data - INFO : save data to db IOOppi_UR_g data:
date value
1693 2025-06-26 1822.6
1694 2025-06-27 1827.0
1695 2025-06-28 1827.0
1696 2025-06-29 1827.0
1697 2025-06-30 1823.0
2025-06-30 17:50:52,069 - IOOppi_data - INFO : save new data to db IOOppi_UR_g: date value ... created_at updated_at
1699 2025-06-28 1827.0 ... 2025-06-30 17:50:52.062199 2025-06-30 17:50:52.062580
1700 2025-06-29 1827.0 ... 2025-06-30 17:50:52.062199 2025-06-30 17:50:52.062580
1701 2025-06-30 1823.0 ... 2025-06-30 17:50:52.062199 2025-06-30 17:50:52.062580
[3 rows x 5 columns]
2025-06-30 17:50:52,087 - 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-30 17:50:52,754 - IOOppi_data - INFO : save data to db IOOppi_ni_t data:
date value
2765 2025-06-26 121966.67
2766 2025-06-27 122433.33
2767 2025-06-28 122433.33
2768 2025-06-29 122433.33
2769 2025-06-30 122400.00
2025-06-30 17:50:52,816 - IOOppi_data - INFO : save new data to db IOOppi_ni_t: date ... updated_at
2767 2025-06-28 ... 2025-06-30 17:50:52.810184
2768 2025-06-29 ... 2025-06-30 17:50:52.810184
2769 2025-06-30 ... 2025-06-30 17:50:52.810184
[3 rows x 5 columns]
2025-06-30 17:50:52,835 - IOOppi_data - INFO : save diff data to db: IOOppi_ni_t: no diff data
2025-06-30 17:50:52,841 - IOOppi_data - INFO : save data to db IOOppi_ni_g data:
date value
2765 2025-06-26 121966.67
2766 2025-06-27 122433.33
2767 2025-06-28 122433.33
2768 2025-06-29 122433.33
2769 2025-06-30 122400.00
2025-06-30 17:50:52,902 - IOOppi_data - INFO : save new data to db IOOppi_ni_g: date ... updated_at
2770 2025-06-28 ... 2025-06-30 17:50:52.895997
2771 2025-06-29 ... 2025-06-30 17:50:52.895997
2772 2025-06-30 ... 2025-06-30 17:50:52.895997
[3 rows x 5 columns]
2025-06-30 17:50:52,921 - 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-30 17:50:53,654 - IOOppi_data - INFO : save data to db IOOppi_v_t data:
date value
3790 2025-06-26 4655.0
3791 2025-06-27 4673.0
3792 2025-06-28 4673.0
3793 2025-06-29 4673.0
3794 2025-06-30 4658.0
2025-06-30 17:50:53,731 - IOOppi_data - INFO : save new data to db IOOppi_v_t: date value ... created_at updated_at
3792 2025-06-28 4673.0 ... 2025-06-30 17:50:53.723775 2025-06-30 17:50:53.724179
3793 2025-06-29 4673.0 ... 2025-06-30 17:50:53.723775 2025-06-30 17:50:53.724179
3794 2025-06-30 4658.0 ... 2025-06-30 17:50:53.723775 2025-06-30 17:50:53.724179
[3 rows x 5 columns]
2025-06-30 17:50:53,749 - IOOppi_data - INFO : save diff data to db: IOOppi_v_t: no diff data
2025-06-30 17:50:53,755 - IOOppi_data - INFO : save data to db IOOppi_v_g data:
date value
3790 2025-06-26 4655.0
3791 2025-06-27 4673.0
3792 2025-06-28 4673.0
3793 2025-06-29 4673.0
3794 2025-06-30 4658.0
2025-06-30 17:50:53,834 - IOOppi_data - INFO : save new data to db IOOppi_v_g: date value ... created_at updated_at
3795 2025-06-28 4673.0 ... 2025-06-30 17:50:53.826781 2025-06-30 17:50:53.827245
3796 2025-06-29 4673.0 ... 2025-06-30 17:50:53.826781 2025-06-30 17:50:53.827245
3797 2025-06-30 4658.0 ... 2025-06-30 17:50:53.826781 2025-06-30 17:50:53.827245
[3 rows x 5 columns]
2025-06-30 17:50:53,853 - 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-30 17:50:54,526 - IOOppi_data - INFO : save data to db IOOppi_pp_t data:
date value
3029 2025-06-26 7483.33
3030 2025-06-27 7483.33
3031 2025-06-28 7483.33
3032 2025-06-29 7483.33
3033 2025-06-30 7466.67
2025-06-30 17:50:54,590 - IOOppi_data - INFO : save new data to db IOOppi_pp_t: date value ... created_at updated_at
3031 2025-06-28 7483.33 ... 2025-06-30 17:50:54.583362 2025-06-30 17:50:54.583741
3032 2025-06-29 7483.33 ... 2025-06-30 17:50:54.583362 2025-06-30 17:50:54.583741
3033 2025-06-30 7466.67 ... 2025-06-30 17:50:54.583362 2025-06-30 17:50:54.583741
[3 rows x 5 columns]
2025-06-30 17:50:54,609 - IOOppi_data - INFO : save diff data to db: IOOppi_pp_t: no diff data
2025-06-30 17:50:54,615 - IOOppi_data - INFO : save data to db IOOppi_pp_g data:
date value
3029 2025-06-26 7483.33
3030 2025-06-27 7483.33
3031 2025-06-28 7483.33
3032 2025-06-29 7483.33
3033 2025-06-30 7466.67
2025-06-30 17:50:54,678 - IOOppi_data - INFO : save new data to db IOOppi_pp_g: date value ... created_at updated_at
3034 2025-06-28 7483.33 ... 2025-06-30 17:50:54.671065 2025-06-30 17:50:54.671453
3035 2025-06-29 7483.33 ... 2025-06-30 17:50:54.671065 2025-06-30 17:50:54.671453
3036 2025-06-30 7466.67 ... 2025-06-30 17:50:54.671065 2025-06-30 17:50:54.671453
[3 rows x 5 columns]
2025-06-30 17:50:54,696 - 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-30 17:50:55,412 - IOOppi_data - INFO : save data to db IOOppi_CF_t data:
date value
3791 2025-06-26 15004.50
3792 2025-06-27 15105.67
3793 2025-06-28 15105.67
3794 2025-06-29 15105.67
3795 2025-06-30 15159.83
2025-06-30 17:50:55,486 - IOOppi_data - INFO : save new data to db IOOppi_CF_t: date ... updated_at
3793 2025-06-28 ... 2025-06-30 17:50:55.479346
3794 2025-06-29 ... 2025-06-30 17:50:55.479346
3795 2025-06-30 ... 2025-06-30 17:50:55.479346
[3 rows x 5 columns]
2025-06-30 17:50:55,505 - IOOppi_data - INFO : save diff data to db: IOOppi_CF_t: no diff data
2025-06-30 17:50:55,511 - IOOppi_data - INFO : save data to db IOOppi_CF_g data:
date value
3791 2025-06-26 15004.50
3792 2025-06-27 15105.67
3793 2025-06-28 15105.67
3794 2025-06-29 15105.67
3795 2025-06-30 15159.83
2025-06-30 17:50:55,589 - IOOppi_data - INFO : save new data to db IOOppi_CF_g: date ... updated_at
3797 2025-06-28 ... 2025-06-30 17:50:55.582633
3798 2025-06-29 ... 2025-06-30 17:50:55.582633
3799 2025-06-30 ... 2025-06-30 17:50:55.582633
[3 rows x 5 columns]
2025-06-30 17:50:55,608 - 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-30 17:50:56,199 - IOOppi_data - INFO : save data to db IOOppi_pb_t data:
date value
3736 2025-06-26 17075.00
3737 2025-06-27 17072.50
3738 2025-06-28 17072.50
3739 2025-06-29 17072.50
3740 2025-06-30 17043.75
2025-06-30 17:50:56,271 - IOOppi_data - INFO : save new data to db IOOppi_pb_t: date ... updated_at
3738 2025-06-28 ... 2025-06-30 17:50:56.264405
3739 2025-06-29 ... 2025-06-30 17:50:56.264405
3740 2025-06-30 ... 2025-06-30 17:50:56.264405
[3 rows x 5 columns]
2025-06-30 17:50:56,289 - IOOppi_data - INFO : save diff data to db: IOOppi_pb_t: no diff data
2025-06-30 17:50:56,296 - IOOppi_data - INFO : save data to db IOOppi_pb_g data:
date value
3736 2025-06-26 17075.00
3737 2025-06-27 17072.50
3738 2025-06-28 17072.50
3739 2025-06-29 17072.50
3740 2025-06-30 17043.75
2025-06-30 17:50:56,369 - IOOppi_data - INFO : save new data to db IOOppi_pb_g: date ... updated_at
3741 2025-06-28 ... 2025-06-30 17:50:56.362869
3742 2025-06-29 ... 2025-06-30 17:50:56.362869
3743 2025-06-30 ... 2025-06-30 17:50:56.362869
[3 rows x 5 columns]
2025-06-30 17:50:56,388 - 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-30 17:50:56,969 - IOOppi_data - INFO : save data to db IOOppi_hc_t data:
date value
3011 2025-06-26 3200.00
3012 2025-06-27 3206.67
3013 2025-06-28 3206.67
3014 2025-06-29 3206.67
3015 2025-06-30 3210.00
2025-06-30 17:50:57,039 - IOOppi_data - INFO : save new data to db IOOppi_hc_t: date value ... created_at updated_at
3013 2025-06-28 3206.67 ... 2025-06-30 17:50:57.031936 2025-06-30 17:50:57.032367
3014 2025-06-29 3206.67 ... 2025-06-30 17:50:57.031936 2025-06-30 17:50:57.032367
3015 2025-06-30 3210.00 ... 2025-06-30 17:50:57.031936 2025-06-30 17:50:57.032367
[3 rows x 5 columns]
2025-06-30 17:50:57,058 - IOOppi_data - INFO : save diff data to db: IOOppi_hc_t: no diff data
2025-06-30 17:50:57,064 - IOOppi_data - INFO : save data to db IOOppi_hc_g data:
date value
3011 2025-06-26 3200.00
3012 2025-06-27 3206.67
3013 2025-06-28 3206.67
3014 2025-06-29 3206.67
3015 2025-06-30 3210.00
2025-06-30 17:50:57,130 - IOOppi_data - INFO : save new data to db IOOppi_hc_g: date value ... created_at updated_at
3016 2025-06-28 3206.67 ... 2025-06-30 17:50:57.122436 2025-06-30 17:50:57.122863
3017 2025-06-29 3206.67 ... 2025-06-30 17:50:57.122436 2025-06-30 17:50:57.122863
3018 2025-06-30 3210.00 ... 2025-06-30 17:50:57.122436 2025-06-30 17:50:57.122863
[3 rows x 5 columns]
2025-06-30 17:50:57,148 - 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-30 17:50:57,744 - IOOppi_data - INFO : save data to db IOOppi_fu_t data:
date value
3291 2025-06-26 5525.0
3292 2025-06-27 5525.0
3293 2025-06-28 5512.5
3294 2025-06-29 5512.5
3295 2025-06-30 5462.5
2025-06-30 17:50:57,811 - IOOppi_data - INFO : save new data to db IOOppi_fu_t: date value ... created_at updated_at
3293 2025-06-28 5512.5 ... 2025-06-30 17:50:57.803663 2025-06-30 17:50:57.804083
3294 2025-06-29 5512.5 ... 2025-06-30 17:50:57.803663 2025-06-30 17:50:57.804083
3295 2025-06-30 5462.5 ... 2025-06-30 17:50:57.803663 2025-06-30 17:50:57.804083
[3 rows x 5 columns]
2025-06-30 17:50:57,831 - IOOppi_data - INFO : save diff data to db: IOOppi_fu_t: no diff data
2025-06-30 17:50:57,837 - IOOppi_data - INFO : save data to db IOOppi_fu_g data:
date value
3291 2025-06-26 5525.0
3292 2025-06-27 5525.0
3293 2025-06-28 5512.5
3294 2025-06-29 5512.5
3295 2025-06-30 5462.5
2025-06-30 17:50:57,910 - IOOppi_data - INFO : save new data to db IOOppi_fu_g: date value ... created_at updated_at
3780 2025-06-28 5512.5 ... 2025-06-30 17:50:57.902839 2025-06-30 17:50:57.903234
3781 2025-06-29 5512.5 ... 2025-06-30 17:50:57.902839 2025-06-30 17:50:57.903234
3782 2025-06-30 5462.5 ... 2025-06-30 17:50:57.902839 2025-06-30 17:50:57.903234
[3 rows x 5 columns]
2025-06-30 17:50:57,930 - 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-30 17:50:58,468 - IOOppi_data - INFO : save data to db IOOppi_lh_t data:
date value
1355 2025-06-26 14330.0
1356 2025-06-27 14420.0
1357 2025-06-28 14420.0
1358 2025-06-29 14420.0
1359 2025-06-30 14480.0
2025-06-30 17:50:58,510 - IOOppi_data - INFO : save new data to db IOOppi_lh_t: date value ... created_at updated_at
1357 2025-06-28 14420.0 ... 2025-06-30 17:50:58.503160 2025-06-30 17:50:58.503546
1358 2025-06-29 14420.0 ... 2025-06-30 17:50:58.503160 2025-06-30 17:50:58.503546
1359 2025-06-30 14480.0 ... 2025-06-30 17:50:58.503160 2025-06-30 17:50:58.503546
[3 rows x 5 columns]
/root/project/IOOppi_data/IOOppi_request.py:308: SettingWithCopyWarning:
A value is trying to be set on a copy of a slice from a DataFrame.
Try using .loc[row_indexer,col_indexer] = value instead
See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy
diff_df.loc[:, 'index_code'] = index_code
/root/project/IOOppi_data/IOOppi_request.py:309: SettingWithCopyWarning:
A value is trying to be set on a copy of a slice from a DataFrame.
Try using .loc[row_indexer,col_indexer] = value instead
See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy
diff_df.loc[:, 'created_at'] = datetime.datetime.now()
/root/project/IOOppi_data/IOOppi_request.py:310: SettingWithCopyWarning:
A value is trying to be set on a copy of a slice from a DataFrame.
Try using .loc[row_indexer,col_indexer] = value instead
See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy
diff_df.loc[:, 'updated_at'] = datetime.datetime.now()
2025-06-30 17:50:58,747 - IOOppi_data - INFO : save diff data to db IOOppi_lh_t: date ... updated_at
116 2021-07-05 ... 2025-06-30 17:50:58.738563
117 2021-07-06 ... 2025-06-30 17:50:58.738563
121 2021-07-12 ... 2025-06-30 17:50:58.738563
122 2021-07-13 ... 2025-06-30 17:50:58.738563
194 2021-11-01 ... 2025-06-30 17:50:58.738563
[5 rows x 6 columns]
2025-06-30 17:50:58,786 - IOOppi_data - INFO : save data to db IOOppi_lh_g data:
date value
1355 2025-06-26 14330.0
1356 2025-06-27 14420.0
1357 2025-06-28 14420.0
1358 2025-06-29 14420.0
1359 2025-06-30 14480.0
2025-06-30 17:50:58,830 - IOOppi_data - INFO : save new data to db IOOppi_lh_g: date value ... created_at updated_at
1360 2025-06-28 14420.0 ... 2025-06-30 17:50:58.822562 2025-06-30 17:50:58.823001
1361 2025-06-29 14420.0 ... 2025-06-30 17:50:58.822562 2025-06-30 17:50:58.823001
1362 2025-06-30 14480.0 ... 2025-06-30 17:50:58.822562 2025-06-30 17:50:58.823001
[3 rows x 5 columns]
/root/project/IOOppi_data/IOOppi_request.py:308: SettingWithCopyWarning:
A value is trying to be set on a copy of a slice from a DataFrame.
Try using .loc[row_indexer,col_indexer] = value instead
See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy
diff_df.loc[:, 'index_code'] = index_code
/root/project/IOOppi_data/IOOppi_request.py:309: SettingWithCopyWarning:
A value is trying to be set on a copy of a slice from a DataFrame.
Try using .loc[row_indexer,col_indexer] = value instead
See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy
diff_df.loc[:, 'created_at'] = datetime.datetime.now()
/root/project/IOOppi_data/IOOppi_request.py:310: SettingWithCopyWarning:
A value is trying to be set on a copy of a slice from a DataFrame.
Try using .loc[row_indexer,col_indexer] = value instead
See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy
diff_df.loc[:, 'updated_at'] = datetime.datetime.now()
2025-06-30 17:50:59,062 - IOOppi_data - INFO : save diff data to db IOOppi_lh_g: date ... updated_at
116 2021-07-05 ... 2025-06-30 17:50:59.053471
117 2021-07-06 ... 2025-06-30 17:50:59.053471
121 2021-07-12 ... 2025-06-30 17:50:59.053471
122 2021-07-13 ... 2025-06-30 17:50:59.053471
194 2021-11-01 ... 2025-06-30 17:50:59.053471
[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-30 17:50:59,720 - IOOppi_data - INFO : save data to db IOOppi_cu_t data:
date value
3787 2025-06-26 78886.67
3788 2025-06-27 80195.00
3789 2025-06-28 80195.00
3790 2025-06-29 80195.00
3791 2025-06-30 80001.67
2025-06-30 17:50:59,795 - IOOppi_data - INFO : save new data to db IOOppi_cu_t: date ... updated_at
3789 2025-06-28 ... 2025-06-30 17:50:59.788533
3790 2025-06-29 ... 2025-06-30 17:50:59.788533
3791 2025-06-30 ... 2025-06-30 17:50:59.788533
[3 rows x 5 columns]
2025-06-30 17:50:59,815 - IOOppi_data - INFO : save diff data to db: IOOppi_cu_t: no diff data
2025-06-30 17:50:59,824 - IOOppi_data - INFO : save data to db IOOppi_cu_g data:
date value
3787 2025-06-26 78886.67
3788 2025-06-27 80195.00
3789 2025-06-28 80195.00
3790 2025-06-29 80195.00
3791 2025-06-30 80001.67
2025-06-30 17:50:59,899 - IOOppi_data - INFO : save new data to db IOOppi_cu_g: date ... updated_at
3792 2025-06-28 ... 2025-06-30 17:50:59.893195
3793 2025-06-29 ... 2025-06-30 17:50:59.893195
3794 2025-06-30 ... 2025-06-30 17:50:59.893195
[3 rows x 5 columns]
2025-06-30 17:50:59,918 - 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-30 17:51:00,428 - 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-30 17:51:00,481 - IOOppi_data - INFO : save new data to db: IOOppi_PM_t: no new data
2025-06-30 17:51:00,481 - IOOppi_data - INFO : save diff data to db: IOOppi_PM_t: no diff data
2025-06-30 17:51:00,486 - 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-30 17:51:00,546 - IOOppi_data - INFO : save new data to db: IOOppi_PM_g: no new data
2025-06-30 17:51:00,546 - 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-30 17:51:01,272 - IOOppi_data - INFO : save data to db IOOppi_sn_t data:
date value
2765 2025-06-26 265425.0
2766 2025-06-27 269425.0
2767 2025-06-28 269425.0
2768 2025-06-29 269425.0
2769 2025-06-30 267487.5
2025-06-30 17:51:01,337 - IOOppi_data - INFO : save new data to db IOOppi_sn_t: date ... updated_at
2767 2025-06-28 ... 2025-06-30 17:51:01.330768
2768 2025-06-29 ... 2025-06-30 17:51:01.330768
2769 2025-06-30 ... 2025-06-30 17:51:01.330768
[3 rows x 5 columns]
2025-06-30 17:51:01,357 - IOOppi_data - INFO : save diff data to db: IOOppi_sn_t: no diff data
2025-06-30 17:51:01,363 - IOOppi_data - INFO : save data to db IOOppi_sn_g data:
date value
2765 2025-06-26 265425.0
2766 2025-06-27 269425.0
2767 2025-06-28 269425.0
2768 2025-06-29 269425.0
2769 2025-06-30 267487.5
2025-06-30 17:51:01,424 - IOOppi_data - INFO : save new data to db IOOppi_sn_g: date ... updated_at
2770 2025-06-28 ... 2025-06-30 17:51:01.418140
2771 2025-06-29 ... 2025-06-30 17:51:01.418140
2772 2025-06-30 ... 2025-06-30 17:51:01.418140
[3 rows x 5 columns]
2025-06-30 17:51:01,444 - 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-30 17:51:02,055 - IOOppi_data - INFO : save data to db IOOppi_zn_t data:
date value
3786 2025-06-26 22244.0
3787 2025-06-27 22568.0
3788 2025-06-28 22568.0
3789 2025-06-29 22568.0
3790 2025-06-30 22486.0
2025-06-30 17:51:02,130 - IOOppi_data - INFO : save new data to db IOOppi_zn_t: date value ... created_at updated_at
3788 2025-06-28 22568.0 ... 2025-06-30 17:51:02.122601 2025-06-30 17:51:02.123068
3789 2025-06-29 22568.0 ... 2025-06-30 17:51:02.122601 2025-06-30 17:51:02.123068
3790 2025-06-30 22486.0 ... 2025-06-30 17:51:02.122601 2025-06-30 17:51:02.123068
[3 rows x 5 columns]
2025-06-30 17:51:02,151 - IOOppi_data - INFO : save diff data to db: IOOppi_zn_t: no diff data
2025-06-30 17:51:02,158 - IOOppi_data - INFO : save data to db IOOppi_zn_g data:
date value
3786 2025-06-26 22244.0
3787 2025-06-27 22568.0
3788 2025-06-28 22568.0
3789 2025-06-29 22568.0
3790 2025-06-30 22486.0
2025-06-30 17:51:02,236 - IOOppi_data - INFO : save new data to db IOOppi_zn_g: date value ... created_at updated_at
3791 2025-06-28 22568.0 ... 2025-06-30 17:51:02.228325 2025-06-30 17:51:02.228748
3792 2025-06-29 22568.0 ... 2025-06-30 17:51:02.228325 2025-06-30 17:51:02.228748
3793 2025-06-30 22486.0 ... 2025-06-30 17:51:02.228325 2025-06-30 17:51:02.228748
[3 rows x 5 columns]
2025-06-30 17:51:02,255 - 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-30 17:51:02,934 - IOOppi_data - INFO : save data to db IOOppi_wr_t data:
date value
3749 2025-06-26 3242.5
3750 2025-06-27 3252.5
3751 2025-06-28 3252.5
3752 2025-06-29 3252.5
3753 2025-06-30 3260.0
2025-06-30 17:51:03,008 - IOOppi_data - INFO : save new data to db IOOppi_wr_t: date value ... created_at updated_at
3751 2025-06-28 3252.5 ... 2025-06-30 17:51:03.000463 2025-06-30 17:51:03.000887
3752 2025-06-29 3252.5 ... 2025-06-30 17:51:03.000463 2025-06-30 17:51:03.000887
3753 2025-06-30 3260.0 ... 2025-06-30 17:51:03.000463 2025-06-30 17:51:03.000887
[3 rows x 5 columns]
2025-06-30 17:51:03,027 - IOOppi_data - INFO : save diff data to db: IOOppi_wr_t: no diff data
2025-06-30 17:51:03,033 - IOOppi_data - INFO : save data to db IOOppi_wr_g data:
date value
3749 2025-06-26 3242.5
3750 2025-06-27 3252.5
3751 2025-06-28 3252.5
3752 2025-06-29 3252.5
3753 2025-06-30 3260.0
2025-06-30 17:51:03,106 - IOOppi_data - INFO : save new data to db IOOppi_wr_g: date value ... created_at updated_at
3754 2025-06-28 3252.5 ... 2025-06-30 17:51:03.098795 2025-06-30 17:51:03.099200
3755 2025-06-29 3252.5 ... 2025-06-30 17:51:03.098795 2025-06-30 17:51:03.099200
3756 2025-06-30 3260.0 ... 2025-06-30 17:51:03.098795 2025-06-30 17:51:03.099200
[3 rows x 5 columns]
2025-06-30 17:51:03,124 - 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-30 17:51:03,715 - IOOppi_data - INFO : save data to db IOOppi_pg_t data:
date value
1546 2025-06-26 4967.5
1547 2025-06-27 4967.5
1548 2025-06-28 4967.5
1549 2025-06-29 4967.5
1550 2025-06-30 4922.5
2025-06-30 17:51:03,773 - IOOppi_data - INFO : save new data to db IOOppi_pg_t: date value ... created_at updated_at
1548 2025-06-28 4967.5 ... 2025-06-30 17:51:03.763362 2025-06-30 17:51:03.763958
1549 2025-06-29 4967.5 ... 2025-06-30 17:51:03.763362 2025-06-30 17:51:03.763958
1550 2025-06-30 4922.5 ... 2025-06-30 17:51:03.763362 2025-06-30 17:51:03.763958
[3 rows x 5 columns]
2025-06-30 17:51:03,791 - IOOppi_data - INFO : save diff data to db: IOOppi_pg_t: no diff data
2025-06-30 17:51:03,797 - IOOppi_data - INFO : save data to db IOOppi_pg_g data:
date value
1546 2025-06-26 4967.5
1547 2025-06-27 4967.5
1548 2025-06-28 4967.5
1549 2025-06-29 4967.5
1550 2025-06-30 4922.5
2025-06-30 17:51:03,843 - IOOppi_data - INFO : save new data to db IOOppi_pg_g: date value ... created_at updated_at
1551 2025-06-28 4967.5 ... 2025-06-30 17:51:03.835470 2025-06-30 17:51:03.835875
1552 2025-06-29 4967.5 ... 2025-06-30 17:51:03.835470 2025-06-30 17:51:03.835875
1553 2025-06-30 4922.5 ... 2025-06-30 17:51:03.835470 2025-06-30 17:51:03.835875
[3 rows x 5 columns]
2025-06-30 17:51:03,861 - 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-30 17:51:04,466 - IOOppi_data - INFO : save data to db IOOppi_cs_t data:
date value
2820 2025-06-26 2352.86
2821 2025-06-27 2352.86
2822 2025-06-28 2352.86
2823 2025-06-29 2352.86
2824 2025-06-30 2357.14
2025-06-30 17:51:04,527 - IOOppi_data - INFO : save new data to db IOOppi_cs_t: date value ... created_at updated_at
2822 2025-06-28 2352.86 ... 2025-06-30 17:51:04.519641 2025-06-30 17:51:04.520058
2823 2025-06-29 2352.86 ... 2025-06-30 17:51:04.519641 2025-06-30 17:51:04.520058
2824 2025-06-30 2357.14 ... 2025-06-30 17:51:04.519641 2025-06-30 17:51:04.520058
[3 rows x 5 columns]
/root/project/IOOppi_data/IOOppi_request.py:308: SettingWithCopyWarning:
A value is trying to be set on a copy of a slice from a DataFrame.
Try using .loc[row_indexer,col_indexer] = value instead
See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy
diff_df.loc[:, 'index_code'] = index_code
/root/project/IOOppi_data/IOOppi_request.py:309: SettingWithCopyWarning:
A value is trying to be set on a copy of a slice from a DataFrame.
Try using .loc[row_indexer,col_indexer] = value instead
See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy
diff_df.loc[:, 'created_at'] = datetime.datetime.now()
/root/project/IOOppi_data/IOOppi_request.py:310: SettingWithCopyWarning:
A value is trying to be set on a copy of a slice from a DataFrame.
Try using .loc[row_indexer,col_indexer] = value instead
See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy
diff_df.loc[:, 'updated_at'] = datetime.datetime.now()
2025-06-30 17:51:04,568 - IOOppi_data - INFO : save diff data to db IOOppi_cs_t: date ... updated_at
2821 2025-06-27 ... 2025-06-30 17:51:04.560960
[1 rows x 6 columns]
2025-06-30 17:51:04,593 - IOOppi_data - INFO : save data to db IOOppi_cs_g data:
date value
2820 2025-06-26 2352.86
2821 2025-06-27 2352.86
2822 2025-06-28 2352.86
2823 2025-06-29 2352.86
2824 2025-06-30 2357.14
2025-06-30 17:51:04,654 - IOOppi_data - INFO : save new data to db IOOppi_cs_g: date value ... created_at updated_at
2825 2025-06-28 2352.86 ... 2025-06-30 17:51:04.647519 2025-06-30 17:51:04.647929
2826 2025-06-29 2352.86 ... 2025-06-30 17:51:04.647519 2025-06-30 17:51:04.647929
2827 2025-06-30 2357.14 ... 2025-06-30 17:51:04.647519 2025-06-30 17:51:04.647929
[3 rows x 5 columns]
/root/project/IOOppi_data/IOOppi_request.py:308: SettingWithCopyWarning:
A value is trying to be set on a copy of a slice from a DataFrame.
Try using .loc[row_indexer,col_indexer] = value instead
See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy
diff_df.loc[:, 'index_code'] = index_code
/root/project/IOOppi_data/IOOppi_request.py:309: SettingWithCopyWarning:
A value is trying to be set on a copy of a slice from a DataFrame.
Try using .loc[row_indexer,col_indexer] = value instead
See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy
diff_df.loc[:, 'created_at'] = datetime.datetime.now()
/root/project/IOOppi_data/IOOppi_request.py:310: SettingWithCopyWarning:
A value is trying to be set on a copy of a slice from a DataFrame.
Try using .loc[row_indexer,col_indexer] = value instead
See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy
diff_df.loc[:, 'updated_at'] = datetime.datetime.now()
2025-06-30 17:51:04,695 - IOOppi_data - INFO : save diff data to db IOOppi_cs_g: date ... updated_at
2824 2025-06-27 ... 2025-06-30 17:51:04.687693
[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-30 17:51:05,501 - IOOppi_data - INFO : save data to db IOOppi_cs_t data:
date value
2820 2025-06-26 2352.86
2821 2025-06-27 2352.86
2822 2025-06-28 2352.86
2823 2025-06-29 2352.86
2824 2025-06-30 2940.00
2025-06-30 17:51:05,552 - 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-30 17:51:05,575 - IOOppi_data - INFO : save diff data to db IOOppi_cs_t: date ... updated_at
2824 2025-06-30 ... 2025-06-30 17:51:05.567668
[1 rows x 6 columns]
2025-06-30 17:51:05,598 - IOOppi_data - INFO : save data to db IOOppi_cs_g data:
date value
2820 2025-06-26 2352.86
2821 2025-06-27 2352.86
2822 2025-06-28 2352.86
2823 2025-06-29 2352.86
2824 2025-06-30 2940.00
2025-06-30 17:51:05,651 - 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-30 17:51:05,674 - IOOppi_data - INFO : save diff data to db IOOppi_cs_g: date ... updated_at
2827 2025-06-30 ... 2025-06-30 17:51:05.667033
[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-30 17:51:06,365 - IOOppi_data - INFO : save data to db IOOppi_RS_t data:
date value
3177 2025-06-26 9631.67
3178 2025-06-27 9631.67
3179 2025-06-28 9631.67
3180 2025-06-29 9631.67
3181 2025-06-30 9581.67
2025-06-30 17:51:06,421 - IOOppi_data - INFO : save new data to db: IOOppi_RS_t: no new data
2025-06-30 17:51:06,421 - IOOppi_data - INFO : save diff data to db: IOOppi_RS_t: no diff data
2025-06-30 17:51:06,426 - IOOppi_data - INFO : save data to db IOOppi_RS_g data:
date value
3177 2025-06-26 9631.67
3178 2025-06-27 9631.67
3179 2025-06-28 9631.67
3180 2025-06-29 9631.67
3181 2025-06-30 9581.67
2025-06-30 17:51:06,483 - IOOppi_data - INFO : save new data to db: IOOppi_RS_g: no new data
2025-06-30 17:51:06,484 - 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-30 17:51:07,124 - IOOppi_data - INFO : save data to db IOOppi_eg_t data:
date value
1861 2025-06-26 4423.33
1862 2025-06-27 4416.67
1863 2025-06-28 4416.67
1864 2025-06-29 4416.67
1865 2025-06-30 4413.33
2025-06-30 17:51:07,174 - IOOppi_data - INFO : save new data to db IOOppi_eg_t: date value ... created_at updated_at
1863 2025-06-28 4416.67 ... 2025-06-30 17:51:07.166266 2025-06-30 17:51:07.166661
1864 2025-06-29 4416.67 ... 2025-06-30 17:51:07.166266 2025-06-30 17:51:07.166661
1865 2025-06-30 4413.33 ... 2025-06-30 17:51:07.166266 2025-06-30 17:51:07.166661
[3 rows x 5 columns]
2025-06-30 17:51:07,192 - IOOppi_data - INFO : save diff data to db: IOOppi_eg_t: no diff data
2025-06-30 17:51:07,198 - IOOppi_data - INFO : save data to db IOOppi_eg_g data:
date value
1861 2025-06-26 4423.33
1862 2025-06-27 4416.67
1863 2025-06-28 4416.67
1864 2025-06-29 4416.67
1865 2025-06-30 4413.33
2025-06-30 17:51:07,248 - IOOppi_data - INFO : save new data to db IOOppi_eg_g: date value ... created_at updated_at
1866 2025-06-28 4416.67 ... 2025-06-30 17:51:07.240411 2025-06-30 17:51:07.240805
1867 2025-06-29 4416.67 ... 2025-06-30 17:51:07.240411 2025-06-30 17:51:07.240805
1868 2025-06-30 4413.33 ... 2025-06-30 17:51:07.240411 2025-06-30 17:51:07.240805
[3 rows x 5 columns]
2025-06-30 17:51:07,266 - 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-30 17:51:07,848 - IOOppi_data - INFO : save data to db IOOppi_sp_t data:
date value
1870 2025-06-26 5983.33
1871 2025-06-27 5983.33
1872 2025-06-28 5983.33
1873 2025-06-29 5983.33
1874 2025-06-30 5950.00
2025-06-30 17:51:07,895 - IOOppi_data - INFO : save new data to db IOOppi_sp_t: date value ... created_at updated_at
1872 2025-06-28 5983.33 ... 2025-06-30 17:51:07.888576 2025-06-30 17:51:07.888983
1873 2025-06-29 5983.33 ... 2025-06-30 17:51:07.888576 2025-06-30 17:51:07.888983
1874 2025-06-30 5950.00 ... 2025-06-30 17:51:07.888576 2025-06-30 17:51:07.888983
[3 rows x 5 columns]
2025-06-30 17:51:07,914 - IOOppi_data - INFO : save diff data to db: IOOppi_sp_t: no diff data
2025-06-30 17:51:07,919 - IOOppi_data - INFO : save data to db IOOppi_sp_g data:
date value
1870 2025-06-26 5983.33
1871 2025-06-27 5983.33
1872 2025-06-28 5983.33
1873 2025-06-29 5983.33
1874 2025-06-30 5950.00
2025-06-30 17:51:07,967 - IOOppi_data - INFO : save new data to db IOOppi_sp_g: date value ... created_at updated_at
1875 2025-06-28 5983.33 ... 2025-06-30 17:51:07.960286 2025-06-30 17:51:07.960658
1876 2025-06-29 5983.33 ... 2025-06-30 17:51:07.960286 2025-06-30 17:51:07.960658
1877 2025-06-30 5950.00 ... 2025-06-30 17:51:07.960286 2025-06-30 17:51:07.960658
[3 rows x 5 columns]
2025-06-30 17:51:07,985 - 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-30 17:51:08,799 - IOOppi_data - INFO : save data to db IOOppi_p_t data:
date value
3538 2025-06-26 8560.0
3539 2025-06-27 8586.0
3540 2025-06-28 8586.0
3541 2025-06-29 8586.0
3542 2025-06-30 8570.0
2025-06-30 17:51:08,869 - IOOppi_data - INFO : save new data to db IOOppi_p_t: date value ... created_at updated_at
3540 2025-06-28 8586.0 ... 2025-06-30 17:51:08.862097 2025-06-30 17:51:08.862482
3541 2025-06-29 8586.0 ... 2025-06-30 17:51:08.862097 2025-06-30 17:51:08.862482
3542 2025-06-30 8570.0 ... 2025-06-30 17:51:08.862097 2025-06-30 17:51:08.862482
[3 rows x 5 columns]
2025-06-30 17:51:08,888 - IOOppi_data - INFO : save diff data to db: IOOppi_p_t: no diff data
2025-06-30 17:51:08,895 - IOOppi_data - INFO : save data to db IOOppi_p_g data:
date value
3538 2025-06-26 8560.0
3539 2025-06-27 8586.0
3540 2025-06-28 8586.0
3541 2025-06-29 8586.0
3542 2025-06-30 8570.0
2025-06-30 17:51:08,967 - IOOppi_data - INFO : save new data to db IOOppi_p_g: date value ... created_at updated_at
3543 2025-06-28 8586.0 ... 2025-06-30 17:51:08.959837 2025-06-30 17:51:08.960261
3544 2025-06-29 8586.0 ... 2025-06-30 17:51:08.959837 2025-06-30 17:51:08.960261
3545 2025-06-30 8570.0 ... 2025-06-30 17:51:08.959837 2025-06-30 17:51:08.960261
[3 rows x 5 columns]
2025-06-30 17:51:08,987 - IOOppi_data - INFO : save diff data to db: IOOppi_p_g: no diff data