=========================================================================
2025-06-26 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-06-26 17:50:29,105 - IOOppi_data - INFO : save data to db IOOppi_rb_t data:
date value
3342 2025-06-22 3072.67
3343 2025-06-23 3071.00
3344 2025-06-24 3071.00
3345 2025-06-25 3062.33
3346 2025-06-26 3060.33
2025-06-26 17:50:29,175 - IOOppi_data - INFO : save new data to db IOOppi_rb_t: date value ... created_at updated_at
3346 2025-06-26 3060.33 ... 2025-06-26 17:50:29.167958 2025-06-26 17:50:29.168376
[1 rows x 5 columns]
2025-06-26 17:50:29,195 - IOOppi_data - INFO : save diff data to db: IOOppi_rb_t: no diff data
2025-06-26 17:50:29,201 - IOOppi_data - INFO : save data to db IOOppi_rb_g data:
date value
3342 2025-06-22 3072.67
3343 2025-06-23 3071.00
3344 2025-06-24 3071.00
3345 2025-06-25 3062.33
3346 2025-06-26 3060.33
2025-06-26 17:50:29,269 - IOOppi_data - INFO : save new data to db IOOppi_rb_g: date value ... created_at updated_at
3349 2025-06-26 3060.33 ... 2025-06-26 17:50:29.261822 2025-06-26 17:50:29.262248
[1 rows x 5 columns]
2025-06-26 17:50:29,287 - 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-26 17:50:29,838 - IOOppi_data - INFO : save data to db IOOppi_MA_t data:
date value
3563 2025-06-22 2747.50
3564 2025-06-23 2719.83
3565 2025-06-24 2656.67
3566 2025-06-25 2646.67
3567 2025-06-26 2750.83
2025-06-26 17:50:29,910 - IOOppi_data - INFO : save new data to db IOOppi_MA_t: date value ... created_at updated_at
3567 2025-06-26 2750.83 ... 2025-06-26 17:50:29.902867 2025-06-26 17:50:29.903317
[1 rows x 5 columns]
2025-06-26 17:50:29,929 - IOOppi_data - INFO : save diff data to db: IOOppi_MA_t: no diff data
2025-06-26 17:50:29,935 - IOOppi_data - INFO : save data to db IOOppi_MA_g data:
date value
3563 2025-06-22 2747.50
3564 2025-06-23 2719.83
3565 2025-06-24 2656.67
3566 2025-06-25 2646.67
3567 2025-06-26 2750.83
2025-06-26 17:50:30,008 - IOOppi_data - INFO : save new data to db IOOppi_MA_g: date value ... created_at updated_at
3571 2025-06-26 2750.83 ... 2025-06-26 17:50:30.000124 2025-06-26 17:50:30.000542
[1 rows x 5 columns]
2025-06-26 17:50:30,026 - 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-26 17:50:30,617 - IOOppi_data - INFO : save data to db IOOppi_PTA_t data:
date value
903 2025-06-22 5271.50
904 2025-06-23 5282.00
905 2025-06-24 5114.00
906 2025-06-25 5114.00
907 2025-06-26 5083.25
2025-06-26 17:50:30,654 - IOOppi_data - INFO : save new data to db IOOppi_PTA_t: date value ... created_at updated_at
907 2025-06-26 5083.25 ... 2025-06-26 17:50:30.647245 2025-06-26 17:50:30.647632
[1 rows x 5 columns]
2025-06-26 17:50:30,673 - IOOppi_data - INFO : save diff data to db: IOOppi_PTA_t: no diff data
2025-06-26 17:50:30,678 - IOOppi_data - INFO : save data to db IOOppi_PTA_g data:
date value
903 2025-06-22 5271.50
904 2025-06-23 5282.00
905 2025-06-24 5114.00
906 2025-06-25 5114.00
907 2025-06-26 5083.25
2025-06-26 17:50:30,715 - IOOppi_data - INFO : save new data to db IOOppi_PTA_g: date value ... created_at updated_at
907 2025-06-26 5083.25 ... 2025-06-26 17:50:30.707807 2025-06-26 17:50:30.708224
[1 rows x 5 columns]
2025-06-26 17:50:30,733 - 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-26 17:50:31,318 - IOOppi_data - INFO : save data to db IOOppi_ru_t data:
date value
3782 2025-06-22 13758.33
3783 2025-06-23 13808.33
3784 2025-06-24 13538.33
3785 2025-06-25 13628.33
3786 2025-06-26 13878.33
2025-06-26 17:50:31,389 - IOOppi_data - INFO : save new data to db IOOppi_ru_t: date ... updated_at
3786 2025-06-26 ... 2025-06-26 17:50:31.383227
[1 rows x 5 columns]
2025-06-26 17:50:31,408 - IOOppi_data - INFO : save diff data to db: IOOppi_ru_t: no diff data
2025-06-26 17:50:31,414 - IOOppi_data - INFO : save data to db IOOppi_ru_g data:
date value
3782 2025-06-22 13758.33
3783 2025-06-23 13808.33
3784 2025-06-24 13538.33
3785 2025-06-25 13628.33
3786 2025-06-26 13878.33
2025-06-26 17:50:31,484 - IOOppi_data - INFO : save new data to db IOOppi_ru_g: date ... updated_at
3789 2025-06-26 ... 2025-06-26 17:50:31.478468
[1 rows x 5 columns]
2025-06-26 17:50:31,502 - 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-26 17:50:32,119 - IOOppi_data - INFO : save data to db IOOppi_i_t data:
date value
3114 2025-06-22 724.44
3115 2025-06-23 727.44
3116 2025-06-24 723.11
3117 2025-06-25 717.44
3118 2025-06-26 715.78
2025-06-26 17:50:32,182 - IOOppi_data - INFO : save new data to db IOOppi_i_t: date value ... created_at updated_at
3118 2025-06-26 715.78 ... 2025-06-26 17:50:32.175613 2025-06-26 17:50:32.176036
[1 rows x 5 columns]
2025-06-26 17:50:32,201 - IOOppi_data - INFO : save diff data to db: IOOppi_i_t: no diff data
2025-06-26 17:50:32,207 - IOOppi_data - INFO : save data to db IOOppi_i_g data:
date value
3114 2025-06-22 724.44
3115 2025-06-23 727.44
3116 2025-06-24 723.11
3117 2025-06-25 717.44
3118 2025-06-26 715.78
2025-06-26 17:50:32,271 - IOOppi_data - INFO : save new data to db IOOppi_i_g: date value ... created_at updated_at
3121 2025-06-26 715.78 ... 2025-06-26 17:50:32.264154 2025-06-26 17:50:32.264538
[1 rows x 5 columns]
2025-06-26 17:50:32,289 - 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-26 17:50:32,915 - IOOppi_data - INFO : save data to db IOOppi_FG_t data:
date value
3317 2025-06-22 1104.0
3318 2025-06-23 1105.6
3319 2025-06-24 1105.6
3320 2025-06-25 1105.6
3321 2025-06-26 1105.6
2025-06-26 17:50:32,983 - IOOppi_data - INFO : save new data to db IOOppi_FG_t: date value ... created_at updated_at
3321 2025-06-26 1105.6 ... 2025-06-26 17:50:32.976181 2025-06-26 17:50:32.976604
[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-06-26 17:50:34,854 - IOOppi_data - INFO : save diff data to db IOOppi_FG_t: date ... updated_at
12 2012-12-19 ... 2025-06-26 17:50:34.846185
21 2013-01-04 ... 2025-06-26 17:50:34.846185
54 2013-02-27 ... 2025-06-26 17:50:34.846185
60 2013-03-07 ... 2025-06-26 17:50:34.846185
61 2013-03-08 ... 2025-06-26 17:50:34.846185
[5 rows x 6 columns]
2025-06-26 17:50:35,010 - IOOppi_data - INFO : save data to db IOOppi_FG_g data:
date value
3317 2025-06-22 1104.0
3318 2025-06-23 1105.6
3319 2025-06-24 1105.6
3320 2025-06-25 1105.6
3321 2025-06-26 1105.6
2025-06-26 17:50:35,079 - IOOppi_data - INFO : save new data to db IOOppi_FG_g: date value ... created_at updated_at
3325 2025-06-26 1105.6 ... 2025-06-26 17:50:35.071698 2025-06-26 17:50:35.072144
[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-06-26 17:50:36,966 - IOOppi_data - INFO : save diff data to db IOOppi_FG_g: date ... updated_at
12 2012-12-19 ... 2025-06-26 17:50:36.958151
21 2013-01-04 ... 2025-06-26 17:50:36.958151
54 2013-02-27 ... 2025-06-26 17:50:36.958151
60 2013-03-07 ... 2025-06-26 17:50:36.958151
61 2013-03-08 ... 2025-06-26 17:50:36.958151
[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-26 17:50:37,658 - IOOppi_data - INFO : save data to db IOOppi_eb_t data:
date value
1662 2025-06-22 8226.0
1663 2025-06-23 8244.0
1664 2025-06-24 8264.0
1665 2025-06-25 8224.0
1666 2025-06-26 8164.0
2025-06-26 17:50:37,706 - IOOppi_data - INFO : save new data to db IOOppi_eb_t: date value ... created_at updated_at
1666 2025-06-26 8164.0 ... 2025-06-26 17:50:37.698642 2025-06-26 17:50:37.699073
[1 rows x 5 columns]
2025-06-26 17:50:37,724 - IOOppi_data - INFO : save diff data to db: IOOppi_eb_t: no diff data
2025-06-26 17:50:37,730 - IOOppi_data - INFO : save data to db IOOppi_eb_g data:
date value
1662 2025-06-22 8226.0
1663 2025-06-23 8244.0
1664 2025-06-24 8264.0
1665 2025-06-25 8224.0
1666 2025-06-26 8164.0
2025-06-26 17:50:37,777 - IOOppi_data - INFO : save new data to db IOOppi_eb_g: date value ... created_at updated_at
1669 2025-06-26 8164.0 ... 2025-06-26 17:50:37.770106 2025-06-26 17:50:37.770488
[1 rows x 5 columns]
2025-06-26 17:50:37,795 - 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-26 17:50:38,497 - IOOppi_data - INFO : save data to db IOOppi_SR_t data:
date value
3773 2025-06-22 6050.00
3774 2025-06-23 6050.00
3775 2025-06-24 6050.00
3776 2025-06-25 6053.33
3777 2025-06-26 6050.00
2025-06-26 17:50:38,569 - IOOppi_data - INFO : save new data to db IOOppi_SR_t: date value ... created_at updated_at
3777 2025-06-26 6050.0 ... 2025-06-26 17:50:38.562302 2025-06-26 17:50:38.562689
[1 rows x 5 columns]
2025-06-26 17:50:38,588 - IOOppi_data - INFO : save diff data to db: IOOppi_SR_t: no diff data
2025-06-26 17:50:38,594 - IOOppi_data - INFO : save data to db IOOppi_SR_g data:
date value
3773 2025-06-22 6050.00
3774 2025-06-23 6050.00
3775 2025-06-24 6050.00
3776 2025-06-25 6053.33
3777 2025-06-26 6050.00
2025-06-26 17:50:38,668 - IOOppi_data - INFO : save new data to db IOOppi_SR_g: date value ... created_at updated_at
3781 2025-06-26 6050.0 ... 2025-06-26 17:50:38.660925 2025-06-26 17:50:38.661325
[1 rows x 5 columns]
2025-06-26 17:50:38,686 - 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-26 17:50:39,210 - IOOppi_data - INFO : save data to db IOOppi_ss_t data:
date value
1663 2025-06-22 12875.0
1664 2025-06-23 12762.5
1665 2025-06-24 12762.5
1666 2025-06-25 12725.0
1667 2025-06-26 12725.0
2025-06-26 17:50:39,254 - IOOppi_data - INFO : save new data to db IOOppi_ss_t: date value ... created_at updated_at
1667 2025-06-26 12725.0 ... 2025-06-26 17:50:39.247690 2025-06-26 17:50:39.248107
[1 rows x 5 columns]
2025-06-26 17:50:39,273 - IOOppi_data - INFO : save diff data to db: IOOppi_ss_t: no diff data
2025-06-26 17:50:39,278 - IOOppi_data - INFO : save data to db IOOppi_ss_g data:
date value
1663 2025-06-22 12875.0
1664 2025-06-23 12762.5
1665 2025-06-24 12762.5
1666 2025-06-25 12725.0
1667 2025-06-26 12725.0
2025-06-26 17:50:39,323 - IOOppi_data - INFO : save new data to db IOOppi_ss_g: date value ... created_at updated_at
1670 2025-06-26 12725.0 ... 2025-06-26 17:50:39.316409 2025-06-26 17:50:39.316808
[1 rows x 5 columns]
2025-06-26 17:50:39,341 - 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-26 17:50:39,879 - IOOppi_data - INFO : save data to db IOOppi_RS_t data:
date value
3173 2025-06-22 9875.00
3174 2025-06-23 9878.33
3175 2025-06-24 9731.67
3176 2025-06-25 9631.67
3177 2025-06-26 9631.67
2025-06-26 17:50:39,942 - IOOppi_data - INFO : save new data to db IOOppi_RS_t: date value ... created_at updated_at
3177 2025-06-26 9631.67 ... 2025-06-26 17:50:39.935142 2025-06-26 17:50:39.935526
[1 rows x 5 columns]
2025-06-26 17:50:39,960 - IOOppi_data - INFO : save diff data to db: IOOppi_RS_t: no diff data
2025-06-26 17:50:39,966 - IOOppi_data - INFO : save data to db IOOppi_RS_g data:
date value
3173 2025-06-22 9875.00
3174 2025-06-23 9878.33
3175 2025-06-24 9731.67
3176 2025-06-25 9631.67
3177 2025-06-26 9631.67
2025-06-26 17:50:40,032 - IOOppi_data - INFO : save new data to db IOOppi_RS_g: date value ... created_at updated_at
3181 2025-06-26 9631.67 ... 2025-06-26 17:50:40.024896 2025-06-26 17:50:40.025288
[1 rows x 5 columns]
2025-06-26 17:50:40,050 - 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-26 17:50:40,579 - IOOppi_data - INFO : save data to db IOOppi_RM_t data:
date value
3296 2025-06-22 2616.67
3297 2025-06-23 2588.33
3298 2025-06-24 2588.33
3299 2025-06-25 2566.67
3300 2025-06-26 2478.33
2025-06-26 17:50:40,645 - IOOppi_data - INFO : save new data to db IOOppi_RM_t: date value ... created_at updated_at
3300 2025-06-26 2478.33 ... 2025-06-26 17:50:40.638363 2025-06-26 17:50:40.638770
[1 rows x 5 columns]
2025-06-26 17:50:40,664 - IOOppi_data - INFO : save diff data to db: IOOppi_RM_t: no diff data
2025-06-26 17:50:40,669 - IOOppi_data - INFO : save data to db IOOppi_RM_g data:
date value
3296 2025-06-22 2616.67
3297 2025-06-23 2588.33
3298 2025-06-24 2588.33
3299 2025-06-25 2566.67
3300 2025-06-26 2478.33
2025-06-26 17:50:40,735 - IOOppi_data - INFO : save new data to db IOOppi_RM_g: date value ... created_at updated_at
3304 2025-06-26 2478.33 ... 2025-06-26 17:50:40.727973 2025-06-26 17:50:40.728370
[1 rows x 5 columns]
2025-06-26 17:50:40,754 - 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-26 17:50:41,260 - IOOppi_data - INFO : save data to db IOOppi_SA_t data:
date value
1500 2025-06-22 1370.0
1501 2025-06-23 1350.0
1502 2025-06-24 1350.0
1503 2025-06-25 1337.5
1504 2025-06-26 1337.5
2025-06-26 17:50:41,305 - IOOppi_data - INFO : save new data to db IOOppi_SA_t: date value ... created_at updated_at
1504 2025-06-26 1337.5 ... 2025-06-26 17:50:41.297691 2025-06-26 17:50:41.298154
[1 rows x 5 columns]
2025-06-26 17:50:41,324 - IOOppi_data - INFO : save diff data to db: IOOppi_SA_t: no diff data
2025-06-26 17:50:41,330 - IOOppi_data - INFO : save data to db IOOppi_SA_g data:
date value
1500 2025-06-22 1370.0
1501 2025-06-23 1350.0
1502 2025-06-24 1350.0
1503 2025-06-25 1337.5
1504 2025-06-26 1337.5
2025-06-26 17:50:41,375 - IOOppi_data - INFO : save new data to db IOOppi_SA_g: date value ... created_at updated_at
1508 2025-06-26 1337.5 ... 2025-06-26 17:50:41.368065 2025-06-26 17:50:41.368499
[1 rows x 5 columns]
2025-06-26 17:50:41,394 - 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-26 17:50:42,059 - IOOppi_data - INFO : save data to db IOOppi_PF_t data:
date value
1413 2025-06-22 6866.46
1414 2025-06-23 6926.25
1415 2025-06-24 6838.75
1416 2025-06-25 6801.88
1417 2025-06-26 6767.29
2025-06-26 17:50:42,104 - IOOppi_data - INFO : save new data to db IOOppi_PF_t: date value ... created_at updated_at
1417 2025-06-26 6767.29 ... 2025-06-26 17:50:42.096740 2025-06-26 17:50:42.097190
[1 rows x 5 columns]
2025-06-26 17:50:42,123 - IOOppi_data - INFO : save diff data to db: IOOppi_PF_t: no diff data
2025-06-26 17:50:42,129 - IOOppi_data - INFO : save data to db IOOppi_PF_g data:
date value
1413 2025-06-22 6866.46
1414 2025-06-23 6926.25
1415 2025-06-24 6838.75
1416 2025-06-25 6801.88
1417 2025-06-26 6767.29
2025-06-26 17:50:42,172 - IOOppi_data - INFO : save new data to db IOOppi_PF_g: date value ... created_at updated_at
1421 2025-06-26 6767.29 ... 2025-06-26 17:50:42.165454 2025-06-26 17:50:42.165865
[1 rows x 5 columns]
2025-06-26 17:50:42,191 - 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-26 17:50:42,741 - IOOppi_data - INFO : save data to db IOOppi_m_t data:
date value
3786 2025-06-22 3024.0
3787 2025-06-23 2986.0
3788 2025-06-24 2974.0
3789 2025-06-25 2958.0
3790 2025-06-26 2916.0
2025-06-26 17:50:42,813 - IOOppi_data - INFO : save new data to db IOOppi_m_t: date value ... created_at updated_at
3790 2025-06-26 2916.0 ... 2025-06-26 17:50:42.805216 2025-06-26 17:50:42.805614
[1 rows x 5 columns]
2025-06-26 17:50:42,831 - IOOppi_data - INFO : save diff data to db: IOOppi_m_t: no diff data
2025-06-26 17:50:42,837 - IOOppi_data - INFO : save data to db IOOppi_m_g data:
date value
3786 2025-06-22 3024.0
3787 2025-06-23 2986.0
3788 2025-06-24 2974.0
3789 2025-06-25 2958.0
3790 2025-06-26 2916.0
2025-06-26 17:50:42,911 - IOOppi_data - INFO : save new data to db IOOppi_m_g: date value ... created_at updated_at
3793 2025-06-26 2916.0 ... 2025-06-26 17:50:42.904133 2025-06-26 17:50:42.904529
[1 rows x 5 columns]
2025-06-26 17:50:42,929 - 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-26 17:50:43,601 - IOOppi_data - INFO : save data to db IOOppi_y_t data:
date value
3556 2025-06-22 8414.0
3557 2025-06-23 8394.0
3558 2025-06-24 8214.0
3559 2025-06-25 8244.0
3560 2025-06-26 8254.0
2025-06-26 17:50:43,673 - IOOppi_data - INFO : save new data to db IOOppi_y_t: date value ... created_at updated_at
3560 2025-06-26 8254.0 ... 2025-06-26 17:50:43.665584 2025-06-26 17:50:43.666038
[1 rows x 5 columns]
2025-06-26 17:50:43,691 - IOOppi_data - INFO : save diff data to db: IOOppi_y_t: no diff data
2025-06-26 17:50:43,698 - IOOppi_data - INFO : save data to db IOOppi_y_g data:
date value
3556 2025-06-22 8414.0
3557 2025-06-23 8394.0
3558 2025-06-24 8214.0
3559 2025-06-25 8244.0
3560 2025-06-26 8254.0
2025-06-26 17:50:43,772 - IOOppi_data - INFO : save new data to db IOOppi_y_g: date value ... created_at updated_at
3563 2025-06-26 8254.0 ... 2025-06-26 17:50:43.764433 2025-06-26 17:50:43.764850
[1 rows x 5 columns]
2025-06-26 17:50:43,791 - 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-26 17:50:44,369 - IOOppi_data - INFO : save data to db IOOppi_a_t data:
date value
3522 2025-06-22 4295.0
3523 2025-06-23 4295.0
3524 2025-06-24 4295.0
3525 2025-06-25 4295.0
3526 2025-06-26 4295.0
2025-06-26 17:50:44,440 - IOOppi_data - INFO : save new data to db IOOppi_a_t: date value ... created_at updated_at
3526 2025-06-26 4295.0 ... 2025-06-26 17:50:44.432628 2025-06-26 17:50:44.433070
[1 rows x 5 columns]
2025-06-26 17:50:44,459 - IOOppi_data - INFO : save diff data to db: IOOppi_a_t: no diff data
2025-06-26 17:50:44,465 - IOOppi_data - INFO : save data to db IOOppi_a_g data:
date value
3522 2025-06-22 4295.0
3523 2025-06-23 4295.0
3524 2025-06-24 4295.0
3525 2025-06-25 4295.0
3526 2025-06-26 4295.0
2025-06-26 17:50:44,535 - IOOppi_data - INFO : save new data to db IOOppi_a_g: date value ... created_at updated_at
3529 2025-06-26 4295.0 ... 2025-06-26 17:50:44.528166 2025-06-26 17:50:44.528566
[1 rows x 5 columns]
2025-06-26 17:50:44,554 - 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-26 17:50:45,151 - IOOppi_data - INFO : save data to db IOOppi_SF_t data:
date value
2899 2025-06-22 5128.57
2900 2025-06-23 5130.00
2901 2025-06-24 5128.57
2902 2025-06-25 5125.71
2903 2025-06-26 5132.86
2025-06-26 17:50:45,212 - IOOppi_data - INFO : save new data to db IOOppi_SF_t: date value ... created_at updated_at
2903 2025-06-26 5132.86 ... 2025-06-26 17:50:45.205072 2025-06-26 17:50:45.205463
[1 rows x 5 columns]
2025-06-26 17:50:45,232 - IOOppi_data - INFO : save diff data to db: IOOppi_SF_t: no diff data
2025-06-26 17:50:45,238 - IOOppi_data - INFO : save data to db IOOppi_SF_g data:
date value
2899 2025-06-22 5128.57
2900 2025-06-23 5130.00
2901 2025-06-24 5128.57
2902 2025-06-25 5125.71
2903 2025-06-26 5132.86
2025-06-26 17:50:45,301 - IOOppi_data - INFO : save new data to db IOOppi_SF_g: date value ... created_at updated_at
2907 2025-06-26 5132.86 ... 2025-06-26 17:50:45.293924 2025-06-26 17:50:45.294333
[1 rows x 5 columns]
2025-06-26 17:50:45,320 - 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-26 17:50:45,830 - IOOppi_data - INFO : save data to db IOOppi_jd_t data:
date value
3099 2025-06-22 2925.0
3100 2025-06-23 2925.0
3101 2025-06-24 2925.0
3102 2025-06-25 2890.0
3103 2025-06-26 2890.0
2025-06-26 17:50:45,894 - IOOppi_data - INFO : save new data to db IOOppi_jd_t: date value ... created_at updated_at
3103 2025-06-26 2890.0 ... 2025-06-26 17:50:45.887393 2025-06-26 17:50:45.887809
[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-06-26 17:50:46,037 - IOOppi_data - INFO : save diff data to db IOOppi_jd_t: date ... updated_at
39 2014-01-03 ... 2025-06-26 17:50:46.029977
458 2015-09-21 ... 2025-06-26 17:50:46.029977
549 2016-02-03 ... 2025-06-26 17:50:46.029977
693 2016-09-05 ... 2025-06-26 17:50:46.029977
696 2016-09-08 ... 2025-06-26 17:50:46.029977
[5 rows x 6 columns]
2025-06-26 17:50:46,070 - IOOppi_data - INFO : save data to db IOOppi_jd_g data:
date value
3099 2025-06-22 2925.0
3100 2025-06-23 2925.0
3101 2025-06-24 2925.0
3102 2025-06-25 2890.0
3103 2025-06-26 2890.0
2025-06-26 17:50:46,137 - IOOppi_data - INFO : save new data to db IOOppi_jd_g: date value ... created_at updated_at
3106 2025-06-26 2890.0 ... 2025-06-26 17:50:46.129722 2025-06-26 17:50:46.130148
[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-06-26 17:50:46,280 - IOOppi_data - INFO : save diff data to db IOOppi_jd_g: date ... updated_at
39 2014-01-03 ... 2025-06-26 17:50:46.272442
458 2015-09-21 ... 2025-06-26 17:50:46.272442
549 2016-02-03 ... 2025-06-26 17:50:46.272442
693 2016-09-05 ... 2025-06-26 17:50:46.272442
696 2016-09-08 ... 2025-06-26 17:50:46.272442
[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-26 17:50:46,897 - IOOppi_data - INFO : save data to db IOOppi_SI_t data:
date value
903 2025-06-22 8620.0
904 2025-06-23 8620.0
905 2025-06-24 8620.0
906 2025-06-25 8620.0
907 2025-06-26 8620.0
2025-06-26 17:50:46,935 - IOOppi_data - INFO : save new data to db IOOppi_SI_t: date value ... created_at updated_at
907 2025-06-26 8620.0 ... 2025-06-26 17:50:46.927900 2025-06-26 17:50:46.928320
[1 rows x 5 columns]
2025-06-26 17:50:46,953 - IOOppi_data - INFO : save diff data to db: IOOppi_SI_t: no diff data
2025-06-26 17:50:46,959 - IOOppi_data - INFO : save data to db IOOppi_SI_g data:
date value
903 2025-06-22 8620.0
904 2025-06-23 8620.0
905 2025-06-24 8620.0
906 2025-06-25 8620.0
907 2025-06-26 8620.0
2025-06-26 17:50:46,995 - IOOppi_data - INFO : save new data to db IOOppi_SI_g: date value ... created_at updated_at
907 2025-06-26 8620.0 ... 2025-06-26 17:50:46.988415 2025-06-26 17:50:46.988821
[1 rows x 5 columns]
2025-06-26 17:50:47,014 - 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-26 17:50:47,581 - IOOppi_data - INFO : save data to db IOOppi_l_t data:
date value
3782 2025-06-22 7556.67
3783 2025-06-23 7593.33
3784 2025-06-24 7571.67
3785 2025-06-25 7548.33
3786 2025-06-26 7511.67
2025-06-26 17:50:47,653 - IOOppi_data - INFO : save new data to db IOOppi_l_t: date value ... created_at updated_at
3786 2025-06-26 7511.67 ... 2025-06-26 17:50:47.645959 2025-06-26 17:50:47.646355
[1 rows x 5 columns]
2025-06-26 17:50:47,672 - IOOppi_data - INFO : save diff data to db: IOOppi_l_t: no diff data
2025-06-26 17:50:47,678 - IOOppi_data - INFO : save data to db IOOppi_l_g data:
date value
3782 2025-06-22 7556.67
3783 2025-06-23 7593.33
3784 2025-06-24 7571.67
3785 2025-06-25 7548.33
3786 2025-06-26 7511.67
2025-06-26 17:50:47,752 - IOOppi_data - INFO : save new data to db IOOppi_l_g: date value ... created_at updated_at
3789 2025-06-26 7511.67 ... 2025-06-26 17:50:47.744737 2025-06-26 17:50:47.745171
[1 rows x 5 columns]
2025-06-26 17:50:47,770 - 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-26 17:50:48,337 - IOOppi_data - INFO : save data to db IOOppi_bu_t data:
date value
3120 2025-06-22 3746.67
3121 2025-06-23 3746.67
3122 2025-06-24 3773.33
3123 2025-06-25 3700.00
3124 2025-06-26 3700.00
2025-06-26 17:50:48,403 - IOOppi_data - INFO : save new data to db IOOppi_bu_t: date value ... created_at updated_at
3125 2025-06-26 3700.0 ... 2025-06-26 17:50:48.395417 2025-06-26 17:50:48.395912
[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-06-26 17:50:48,438 - IOOppi_data - INFO : save diff data to db IOOppi_bu_t: date ... updated_at
2560 2023-12-09 ... 2025-06-26 17:50:48.431074
[1 rows x 6 columns]
2025-06-26 17:50:48,462 - IOOppi_data - INFO : save data to db IOOppi_bu_g data:
date value
3120 2025-06-22 3746.67
3121 2025-06-23 3746.67
3122 2025-06-24 3773.33
3123 2025-06-25 3700.00
3124 2025-06-26 3700.00
2025-06-26 17:50:48,528 - IOOppi_data - INFO : save new data to db IOOppi_bu_g: date value ... created_at updated_at
3127 2025-06-26 3700.0 ... 2025-06-26 17:50:48.520478 2025-06-26 17:50:48.520886
[1 rows x 5 columns]
2025-06-26 17:50:48,546 - 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-26 17:50:49,642 - IOOppi_data - INFO : save data to db IOOppi_al_t data:
date value
3785 2025-06-22 20736.67
3786 2025-06-23 20663.33
3787 2025-06-24 20663.33
3788 2025-06-25 20550.00
3789 2025-06-26 20550.00
2025-06-26 17:50:49,714 - IOOppi_data - INFO : save new data to db IOOppi_al_t: date value ... created_at updated_at
3789 2025-06-26 20550.0 ... 2025-06-26 17:50:49.707481 2025-06-26 17:50:49.707899
[1 rows x 5 columns]
2025-06-26 17:50:49,733 - IOOppi_data - INFO : save diff data to db: IOOppi_al_t: no diff data
2025-06-26 17:50:49,739 - IOOppi_data - INFO : save data to db IOOppi_al_g data:
date value
3785 2025-06-22 20736.67
3786 2025-06-23 20663.33
3787 2025-06-24 20663.33
3788 2025-06-25 20550.00
3789 2025-06-26 20550.00
2025-06-26 17:50:49,811 - IOOppi_data - INFO : save new data to db IOOppi_al_g: date value ... created_at updated_at
3792 2025-06-26 20550.0 ... 2025-06-26 17:50:49.804342 2025-06-26 17:50:49.804730
[1 rows x 5 columns]
2025-06-26 17:50:49,830 - 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-26 17:50:50,507 - IOOppi_data - INFO : save data to db IOOppi_SM_t data:
date value
2899 2025-06-22 5564.0
2900 2025-06-23 5524.0
2901 2025-06-24 5518.0
2902 2025-06-25 5520.0
2903 2025-06-26 5562.0
2025-06-26 17:50:50,588 - IOOppi_data - INFO : save new data to db IOOppi_SM_t: date value ... created_at updated_at
2903 2025-06-26 5562.0 ... 2025-06-26 17:50:50.581369 2025-06-26 17:50:50.581778
[1 rows x 5 columns]
2025-06-26 17:50:50,606 - IOOppi_data - INFO : save diff data to db: IOOppi_SM_t: no diff data
2025-06-26 17:50:50,612 - IOOppi_data - INFO : save data to db IOOppi_SM_g data:
date value
2899 2025-06-22 5564.0
2900 2025-06-23 5524.0
2901 2025-06-24 5518.0
2902 2025-06-25 5520.0
2903 2025-06-26 5562.0
2025-06-26 17:50:50,673 - IOOppi_data - INFO : save new data to db IOOppi_SM_g: date value ... created_at updated_at
2907 2025-06-26 5562.0 ... 2025-06-26 17:50:50.666533 2025-06-26 17:50:50.666949
[1 rows x 5 columns]
2025-06-26 17:50:50,691 - 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-26 17:50:51,251 - IOOppi_data - INFO : save data to db IOOppi_CY_t data:
date value
2174 2025-06-22 23575.0
2175 2025-06-23 23550.0
2176 2025-06-24 23200.0
2177 2025-06-25 23200.0
2178 2025-06-26 23200.0
2025-06-26 17:50:51,304 - IOOppi_data - INFO : save new data to db IOOppi_CY_t: date value ... created_at updated_at
2178 2025-06-26 23200.0 ... 2025-06-26 17:50:51.296783 2025-06-26 17:50:51.297186
[1 rows x 5 columns]
2025-06-26 17:50:51,322 - IOOppi_data - INFO : save diff data to db: IOOppi_CY_t: no diff data
2025-06-26 17:50:51,327 - IOOppi_data - INFO : save data to db IOOppi_CY_g data:
date value
2174 2025-06-22 23575.0
2175 2025-06-23 23550.0
2176 2025-06-24 23200.0
2177 2025-06-25 23200.0
2178 2025-06-26 23200.0
2025-06-26 17:50:51,381 - IOOppi_data - INFO : save new data to db IOOppi_CY_g: date value ... created_at updated_at
2182 2025-06-26 23200.0 ... 2025-06-26 17:50:51.373799 2025-06-26 17:50:51.374215
[1 rows x 5 columns]
2025-06-26 17:50:51,399 - IOOppi_data - INFO : save diff data to db: IOOppi_CY_g: no diff data
/usr/local/lib/python3.10/site-packages/urllib3/connectionpool.py:1056: InsecureRequestWarning: Unverified HTTPS request is being made to host 'www.100ppi.com'. Adding certificate verification is strongly advised. See: https://urllib3.readthedocs.io/en/1.26.x/advanced-usage.html#ssl-warnings
warnings.warn(
2025-06-26 17:50:51,931 - IOOppi_data - INFO : save data to db IOOppi_UR_t data:
date value
1689 2025-06-22 1834.0
1690 2025-06-23 1824.0
1691 2025-06-24 1804.0
1692 2025-06-25 1804.0
1693 2025-06-26 1822.6
2025-06-26 17:50:51,976 - IOOppi_data - INFO : save new data to db IOOppi_UR_t: date value ... created_at updated_at
1693 2025-06-26 1822.6 ... 2025-06-26 17:50:51.969508 2025-06-26 17:50:51.969920
[1 rows x 5 columns]
2025-06-26 17:50:51,995 - IOOppi_data - INFO : save diff data to db: IOOppi_UR_t: no diff data
2025-06-26 17:50:52,004 - IOOppi_data - INFO : save data to db IOOppi_UR_g data:
date value
1689 2025-06-22 1834.0
1690 2025-06-23 1824.0
1691 2025-06-24 1804.0
1692 2025-06-25 1804.0
1693 2025-06-26 1822.6
2025-06-26 17:50:52,050 - IOOppi_data - INFO : save new data to db IOOppi_UR_g: date value ... created_at updated_at
1697 2025-06-26 1822.6 ... 2025-06-26 17:50:52.043405 2025-06-26 17:50:52.043815
[1 rows x 5 columns]
2025-06-26 17:50:52,069 - 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-26 17:50:52,680 - IOOppi_data - INFO : save data to db IOOppi_ni_t data:
date value
2761 2025-06-22 120641.67
2762 2025-06-23 119616.67
2763 2025-06-24 119050.00
2764 2025-06-25 119733.33
2765 2025-06-26 121966.67
2025-06-26 17:50:52,741 - IOOppi_data - INFO : save new data to db IOOppi_ni_t: date ... updated_at
2765 2025-06-26 ... 2025-06-26 17:50:52.734492
[1 rows x 5 columns]
2025-06-26 17:50:52,760 - IOOppi_data - INFO : save diff data to db: IOOppi_ni_t: no diff data
2025-06-26 17:50:52,766 - IOOppi_data - INFO : save data to db IOOppi_ni_g data:
date value
2761 2025-06-22 120641.67
2762 2025-06-23 119616.67
2763 2025-06-24 119050.00
2764 2025-06-25 119733.33
2765 2025-06-26 121966.67
2025-06-26 17:50:52,826 - IOOppi_data - INFO : save new data to db IOOppi_ni_g: date ... updated_at
2768 2025-06-26 ... 2025-06-26 17:50:52.820476
[1 rows x 5 columns]
2025-06-26 17:50:52,916 - 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-26 17:50:53,479 - IOOppi_data - INFO : save data to db IOOppi_v_t data:
date value
3786 2025-06-22 4677.0
3787 2025-06-23 4669.0
3788 2025-06-24 4635.0
3789 2025-06-25 4661.0
3790 2025-06-26 4655.0
2025-06-26 17:50:53,553 - IOOppi_data - INFO : save new data to db IOOppi_v_t: date value ... created_at updated_at
3790 2025-06-26 4655.0 ... 2025-06-26 17:50:53.545711 2025-06-26 17:50:53.546142
[1 rows x 5 columns]
2025-06-26 17:50:53,571 - IOOppi_data - INFO : save diff data to db: IOOppi_v_t: no diff data
2025-06-26 17:50:53,577 - IOOppi_data - INFO : save data to db IOOppi_v_g data:
date value
3786 2025-06-22 4677.0
3787 2025-06-23 4669.0
3788 2025-06-24 4635.0
3789 2025-06-25 4661.0
3790 2025-06-26 4655.0
2025-06-26 17:50:53,650 - IOOppi_data - INFO : save new data to db IOOppi_v_g: date value ... created_at updated_at
3793 2025-06-26 4655.0 ... 2025-06-26 17:50:53.643390 2025-06-26 17:50:53.643812
[1 rows x 5 columns]
2025-06-26 17:50:53,669 - 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-26 17:50:54,369 - IOOppi_data - INFO : save data to db IOOppi_pp_t data:
date value
3025 2025-06-22 7471.67
3026 2025-06-23 7476.67
3027 2025-06-24 7501.67
3028 2025-06-25 7493.33
3029 2025-06-26 7483.33
2025-06-26 17:50:54,434 - IOOppi_data - INFO : save new data to db IOOppi_pp_t: date value ... created_at updated_at
3029 2025-06-26 7483.33 ... 2025-06-26 17:50:54.427595 2025-06-26 17:50:54.428025
[1 rows x 5 columns]
2025-06-26 17:50:54,453 - IOOppi_data - INFO : save diff data to db: IOOppi_pp_t: no diff data
2025-06-26 17:50:54,459 - IOOppi_data - INFO : save data to db IOOppi_pp_g data:
date value
3025 2025-06-22 7471.67
3026 2025-06-23 7476.67
3027 2025-06-24 7501.67
3028 2025-06-25 7493.33
3029 2025-06-26 7483.33
2025-06-26 17:50:54,526 - IOOppi_data - INFO : save new data to db IOOppi_pp_g: date value ... created_at updated_at
3032 2025-06-26 7483.33 ... 2025-06-26 17:50:54.518529 2025-06-26 17:50:54.518964
[1 rows x 5 columns]
2025-06-26 17:50:54,544 - 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-26 17:50:55,157 - IOOppi_data - INFO : save data to db IOOppi_CF_t data:
date value
3787 2025-06-22 14869.67
3788 2025-06-23 14881.83
3789 2025-06-24 14868.00
3790 2025-06-25 14913.67
3791 2025-06-26 15004.50
2025-06-26 17:50:55,232 - IOOppi_data - INFO : save new data to db IOOppi_CF_t: date value ... created_at updated_at
3791 2025-06-26 15004.5 ... 2025-06-26 17:50:55.224387 2025-06-26 17:50:55.224809
[1 rows x 5 columns]
2025-06-26 17:50:55,251 - IOOppi_data - INFO : save diff data to db: IOOppi_CF_t: no diff data
2025-06-26 17:50:55,257 - IOOppi_data - INFO : save data to db IOOppi_CF_g data:
date value
3787 2025-06-22 14869.67
3788 2025-06-23 14881.83
3789 2025-06-24 14868.00
3790 2025-06-25 14913.67
3791 2025-06-26 15004.50
2025-06-26 17:50:55,332 - IOOppi_data - INFO : save new data to db IOOppi_CF_g: date value ... created_at updated_at
3795 2025-06-26 15004.5 ... 2025-06-26 17:50:55.324579 2025-06-26 17:50:55.325039
[1 rows x 5 columns]
2025-06-26 17:50:55,351 - 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-26 17:50:55,968 - IOOppi_data - INFO : save data to db IOOppi_pb_t data:
date value
3732 2025-06-22 16812.50
3733 2025-06-23 16812.50
3734 2025-06-24 16850.00
3735 2025-06-25 17031.25
3736 2025-06-26 17075.00
2025-06-26 17:50:56,042 - IOOppi_data - INFO : save new data to db IOOppi_pb_t: date value ... created_at updated_at
3736 2025-06-26 17075.0 ... 2025-06-26 17:50:56.035241 2025-06-26 17:50:56.035634
[1 rows x 5 columns]
2025-06-26 17:50:56,060 - IOOppi_data - INFO : save diff data to db: IOOppi_pb_t: no diff data
2025-06-26 17:50:56,067 - IOOppi_data - INFO : save data to db IOOppi_pb_g data:
date value
3732 2025-06-22 16812.50
3733 2025-06-23 16812.50
3734 2025-06-24 16850.00
3735 2025-06-25 17031.25
3736 2025-06-26 17075.00
2025-06-26 17:50:56,141 - IOOppi_data - INFO : save new data to db IOOppi_pb_g: date value ... created_at updated_at
3739 2025-06-26 17075.0 ... 2025-06-26 17:50:56.134153 2025-06-26 17:50:56.134546
[1 rows x 5 columns]
2025-06-26 17:50:56,160 - 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-26 17:50:56,730 - IOOppi_data - INFO : save data to db IOOppi_hc_t data:
date value
3007 2025-06-22 3190.0
3008 2025-06-23 3190.0
3009 2025-06-24 3190.0
3010 2025-06-25 3180.0
3011 2025-06-26 3200.0
2025-06-26 17:50:56,794 - IOOppi_data - INFO : save new data to db IOOppi_hc_t: date value ... created_at updated_at
3011 2025-06-26 3200.0 ... 2025-06-26 17:50:56.786697 2025-06-26 17:50:56.787171
[1 rows x 5 columns]
2025-06-26 17:50:56,813 - IOOppi_data - INFO : save diff data to db: IOOppi_hc_t: no diff data
2025-06-26 17:50:56,819 - IOOppi_data - INFO : save data to db IOOppi_hc_g data:
date value
3007 2025-06-22 3190.0
3008 2025-06-23 3190.0
3009 2025-06-24 3190.0
3010 2025-06-25 3180.0
3011 2025-06-26 3200.0
2025-06-26 17:50:56,883 - IOOppi_data - INFO : save new data to db IOOppi_hc_g: date value ... created_at updated_at
3014 2025-06-26 3200.0 ... 2025-06-26 17:50:56.876672 2025-06-26 17:50:56.877115
[1 rows x 5 columns]
2025-06-26 17:50:56,902 - 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-26 17:50:57,452 - IOOppi_data - INFO : save data to db IOOppi_fu_t data:
date value
3287 2025-06-22 5450.0
3288 2025-06-23 5537.5
3289 2025-06-24 5550.0
3290 2025-06-25 5525.0
3291 2025-06-26 5525.0
2025-06-26 17:50:57,520 - IOOppi_data - INFO : save new data to db IOOppi_fu_t: date value ... created_at updated_at
3291 2025-06-26 5525.0 ... 2025-06-26 17:50:57.512955 2025-06-26 17:50:57.513370
[1 rows x 5 columns]
2025-06-26 17:50:57,540 - IOOppi_data - INFO : save diff data to db: IOOppi_fu_t: no diff data
2025-06-26 17:50:57,546 - IOOppi_data - INFO : save data to db IOOppi_fu_g data:
date value
3287 2025-06-22 5450.0
3288 2025-06-23 5537.5
3289 2025-06-24 5550.0
3290 2025-06-25 5525.0
3291 2025-06-26 5525.0
2025-06-26 17:50:57,620 - IOOppi_data - INFO : save new data to db IOOppi_fu_g: date value ... created_at updated_at
3778 2025-06-26 5525.0 ... 2025-06-26 17:50:57.613187 2025-06-26 17:50:57.613586
[1 rows x 5 columns]
2025-06-26 17:50:57,639 - 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-26 17:50:58,162 - IOOppi_data - INFO : save data to db IOOppi_lh_t data:
date value
1351 2025-06-22 14180.0
1352 2025-06-23 14300.0
1353 2025-06-24 14280.0
1354 2025-06-25 14320.0
1355 2025-06-26 14330.0
2025-06-26 17:50:58,203 - IOOppi_data - INFO : save new data to db IOOppi_lh_t: date value ... created_at updated_at
1355 2025-06-26 14330.0 ... 2025-06-26 17:50:58.196825 2025-06-26 17:50:58.197221
[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-06-26 17:50:58,434 - IOOppi_data - INFO : save diff data to db IOOppi_lh_t: date ... updated_at
116 2021-07-05 ... 2025-06-26 17:50:58.426469
117 2021-07-06 ... 2025-06-26 17:50:58.426469
121 2021-07-12 ... 2025-06-26 17:50:58.426469
122 2021-07-13 ... 2025-06-26 17:50:58.426469
194 2021-11-01 ... 2025-06-26 17:50:58.426469
[5 rows x 6 columns]
2025-06-26 17:50:58,472 - IOOppi_data - INFO : save data to db IOOppi_lh_g data:
date value
1351 2025-06-22 14180.0
1352 2025-06-23 14300.0
1353 2025-06-24 14280.0
1354 2025-06-25 14320.0
1355 2025-06-26 14330.0
2025-06-26 17:50:58,516 - IOOppi_data - INFO : save new data to db IOOppi_lh_g: date value ... created_at updated_at
1358 2025-06-26 14330.0 ... 2025-06-26 17:50:58.508915 2025-06-26 17:50:58.509329
[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-06-26 17:50:58,752 - IOOppi_data - INFO : save diff data to db IOOppi_lh_g: date ... updated_at
116 2021-07-05 ... 2025-06-26 17:50:58.744779
117 2021-07-06 ... 2025-06-26 17:50:58.744779
121 2021-07-12 ... 2025-06-26 17:50:58.744779
122 2021-07-13 ... 2025-06-26 17:50:58.744779
194 2021-11-01 ... 2025-06-26 17:50:58.744779
[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-26 17:50:59,413 - IOOppi_data - INFO : save data to db IOOppi_cu_t data:
date value
3783 2025-06-22 78436.67
3784 2025-06-23 78388.33
3785 2025-06-24 78471.67
3786 2025-06-25 78630.00
3787 2025-06-26 78886.67
2025-06-26 17:50:59,486 - IOOppi_data - INFO : save new data to db IOOppi_cu_t: date ... updated_at
3787 2025-06-26 ... 2025-06-26 17:50:59.480214
[1 rows x 5 columns]
2025-06-26 17:50:59,505 - IOOppi_data - INFO : save diff data to db: IOOppi_cu_t: no diff data
2025-06-26 17:50:59,510 - IOOppi_data - INFO : save data to db IOOppi_cu_g data:
date value
3783 2025-06-22 78436.67
3784 2025-06-23 78388.33
3785 2025-06-24 78471.67
3786 2025-06-25 78630.00
3787 2025-06-26 78886.67
2025-06-26 17:50:59,582 - IOOppi_data - INFO : save new data to db IOOppi_cu_g: date ... updated_at
3790 2025-06-26 ... 2025-06-26 17:50:59.576367
[1 rows x 5 columns]
2025-06-26 17:50:59,600 - 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-26 17:51:00,100 - 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-26 17:51:00,153 - IOOppi_data - INFO : save new data to db: IOOppi_PM_t: no new data
2025-06-26 17:51:00,153 - IOOppi_data - INFO : save diff data to db: IOOppi_PM_t: no diff data
2025-06-26 17:51:00,159 - 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-26 17:51:00,219 - IOOppi_data - INFO : save new data to db: IOOppi_PM_g: no new data
2025-06-26 17:51:00,219 - 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-26 17:51:00,810 - IOOppi_data - INFO : save data to db IOOppi_sn_t data:
date value
2761 2025-06-22 263350.0
2762 2025-06-23 261975.0
2763 2025-06-24 263612.5
2764 2025-06-25 262250.0
2765 2025-06-26 265425.0
2025-06-26 17:51:00,868 - IOOppi_data - INFO : save new data to db IOOppi_sn_t: date ... updated_at
2765 2025-06-26 ... 2025-06-26 17:51:00.862553
[1 rows x 5 columns]
2025-06-26 17:51:00,886 - IOOppi_data - INFO : save diff data to db: IOOppi_sn_t: no diff data
2025-06-26 17:51:00,892 - IOOppi_data - INFO : save data to db IOOppi_sn_g data:
date value
2761 2025-06-22 263350.0
2762 2025-06-23 261975.0
2763 2025-06-24 263612.5
2764 2025-06-25 262250.0
2765 2025-06-26 265425.0
2025-06-26 17:51:00,952 - IOOppi_data - INFO : save new data to db IOOppi_sn_g: date ... updated_at
2768 2025-06-26 ... 2025-06-26 17:51:00.946012
[1 rows x 5 columns]
2025-06-26 17:51:00,970 - 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-26 17:51:01,555 - IOOppi_data - INFO : save data to db IOOppi_zn_t data:
date value
3782 2025-06-22 22032.0
3783 2025-06-23 21922.0
3784 2025-06-24 22134.0
3785 2025-06-25 22176.0
3786 2025-06-26 22244.0
2025-06-26 17:51:01,631 - IOOppi_data - INFO : save new data to db IOOppi_zn_t: date value ... created_at updated_at
3786 2025-06-26 22244.0 ... 2025-06-26 17:51:01.623673 2025-06-26 17:51:01.624132
[1 rows x 5 columns]
2025-06-26 17:51:01,649 - IOOppi_data - INFO : save diff data to db: IOOppi_zn_t: no diff data
2025-06-26 17:51:01,655 - IOOppi_data - INFO : save data to db IOOppi_zn_g data:
date value
3782 2025-06-22 22032.0
3783 2025-06-23 21922.0
3784 2025-06-24 22134.0
3785 2025-06-25 22176.0
3786 2025-06-26 22244.0
2025-06-26 17:51:01,731 - IOOppi_data - INFO : save new data to db IOOppi_zn_g: date value ... created_at updated_at
3789 2025-06-26 22244.0 ... 2025-06-26 17:51:01.722654 2025-06-26 17:51:01.723101
[1 rows x 5 columns]
2025-06-26 17:51:01,750 - 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-26 17:51:02,356 - IOOppi_data - INFO : save data to db IOOppi_wr_t data:
date value
3745 2025-06-22 3250.0
3746 2025-06-23 3255.0
3747 2025-06-24 3255.0
3748 2025-06-25 3242.5
3749 2025-06-26 3242.5
2025-06-26 17:51:02,431 - IOOppi_data - INFO : save new data to db IOOppi_wr_t: date value ... created_at updated_at
3749 2025-06-26 3242.5 ... 2025-06-26 17:51:02.423346 2025-06-26 17:51:02.423810
[1 rows x 5 columns]
2025-06-26 17:51:02,449 - IOOppi_data - INFO : save diff data to db: IOOppi_wr_t: no diff data
2025-06-26 17:51:02,456 - IOOppi_data - INFO : save data to db IOOppi_wr_g data:
date value
3745 2025-06-22 3250.0
3746 2025-06-23 3255.0
3747 2025-06-24 3255.0
3748 2025-06-25 3242.5
3749 2025-06-26 3242.5
2025-06-26 17:51:02,530 - IOOppi_data - INFO : save new data to db IOOppi_wr_g: date value ... created_at updated_at
3752 2025-06-26 3242.5 ... 2025-06-26 17:51:02.523111 2025-06-26 17:51:02.523513
[1 rows x 5 columns]
2025-06-26 17:51:02,549 - 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-26 17:51:03,120 - IOOppi_data - INFO : save data to db IOOppi_pg_t data:
date value
1542 2025-06-22 4890.0
1543 2025-06-23 4935.0
1544 2025-06-24 5080.0
1545 2025-06-25 5055.0
1546 2025-06-26 4967.5
2025-06-26 17:51:03,166 - IOOppi_data - INFO : save new data to db IOOppi_pg_t: date value ... created_at updated_at
1546 2025-06-26 4967.5 ... 2025-06-26 17:51:03.159374 2025-06-26 17:51:03.159787
[1 rows x 5 columns]
2025-06-26 17:51:03,185 - IOOppi_data - INFO : save diff data to db: IOOppi_pg_t: no diff data
2025-06-26 17:51:03,191 - IOOppi_data - INFO : save data to db IOOppi_pg_g data:
date value
1542 2025-06-22 4890.0
1543 2025-06-23 4935.0
1544 2025-06-24 5080.0
1545 2025-06-25 5055.0
1546 2025-06-26 4967.5
2025-06-26 17:51:03,237 - IOOppi_data - INFO : save new data to db IOOppi_pg_g: date value ... created_at updated_at
1549 2025-06-26 4967.5 ... 2025-06-26 17:51:03.229867 2025-06-26 17:51:03.230275
[1 rows x 5 columns]
2025-06-26 17:51:03,256 - 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-26 17:51:03,798 - IOOppi_data - INFO : save data to db IOOppi_cs_t data:
date value
2816 2025-06-22 2342.86
2817 2025-06-23 2345.71
2818 2025-06-24 2345.71
2819 2025-06-25 2350.00
2820 2025-06-26 2352.86
2025-06-26 17:51:03,860 - IOOppi_data - INFO : save new data to db IOOppi_cs_t: date value ... created_at updated_at
2820 2025-06-26 2352.86 ... 2025-06-26 17:51:03.852897 2025-06-26 17:51:03.853316
[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-06-26 17:51:03,903 - IOOppi_data - INFO : save diff data to db IOOppi_cs_t: date ... updated_at
2819 2025-06-25 ... 2025-06-26 17:51:03.895371
[1 rows x 6 columns]
2025-06-26 17:51:03,927 - IOOppi_data - INFO : save data to db IOOppi_cs_g data:
date value
2816 2025-06-22 2342.86
2817 2025-06-23 2345.71
2818 2025-06-24 2345.71
2819 2025-06-25 2350.00
2820 2025-06-26 2352.86
2025-06-26 17:51:03,988 - IOOppi_data - INFO : save new data to db IOOppi_cs_g: date value ... created_at updated_at
2823 2025-06-26 2352.86 ... 2025-06-26 17:51:03.981363 2025-06-26 17:51:03.981740
[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-06-26 17:51:04,030 - IOOppi_data - INFO : save diff data to db IOOppi_cs_g: date ... updated_at
2822 2025-06-25 ... 2025-06-26 17:51:04.023122
[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-26 17:51:04,636 - IOOppi_data - INFO : save data to db IOOppi_cs_t data:
date value
2816 2025-06-22 2342.86
2817 2025-06-23 2345.71
2818 2025-06-24 2345.71
2819 2025-06-25 2350.00
2820 2025-06-26 2940.00
2025-06-26 17:51:04,690 - 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-26 17:51:04,713 - IOOppi_data - INFO : save diff data to db IOOppi_cs_t: date ... updated_at
2820 2025-06-26 ... 2025-06-26 17:51:04.705651
[1 rows x 6 columns]
2025-06-26 17:51:04,739 - IOOppi_data - INFO : save data to db IOOppi_cs_g data:
date value
2816 2025-06-22 2342.86
2817 2025-06-23 2345.71
2818 2025-06-24 2345.71
2819 2025-06-25 2350.00
2820 2025-06-26 2940.00
2025-06-26 17:51:04,796 - 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-26 17:51:04,820 - IOOppi_data - INFO : save diff data to db IOOppi_cs_g: date ... updated_at
2823 2025-06-26 ... 2025-06-26 17:51:04.812312
[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-26 17:51:05,404 - IOOppi_data - INFO : save data to db IOOppi_RS_t data:
date value
3173 2025-06-22 9875.00
3174 2025-06-23 9878.33
3175 2025-06-24 9731.67
3176 2025-06-25 9631.67
3177 2025-06-26 9631.67
2025-06-26 17:51:05,466 - IOOppi_data - INFO : save new data to db: IOOppi_RS_t: no new data
2025-06-26 17:51:05,466 - IOOppi_data - INFO : save diff data to db: IOOppi_RS_t: no diff data
2025-06-26 17:51:05,472 - IOOppi_data - INFO : save data to db IOOppi_RS_g data:
date value
3173 2025-06-22 9875.00
3174 2025-06-23 9878.33
3175 2025-06-24 9731.67
3176 2025-06-25 9631.67
3177 2025-06-26 9631.67
2025-06-26 17:51:05,529 - IOOppi_data - INFO : save new data to db: IOOppi_RS_g: no new data
2025-06-26 17:51:05,530 - 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-26 17:51:06,126 - IOOppi_data - INFO : save data to db IOOppi_eg_t data:
date value
1857 2025-06-22 4558.33
1858 2025-06-23 4550.00
1859 2025-06-24 4460.00
1860 2025-06-25 4423.33
1861 2025-06-26 4423.33
2025-06-26 17:51:06,176 - IOOppi_data - INFO : save new data to db IOOppi_eg_t: date value ... created_at updated_at
1861 2025-06-26 4423.33 ... 2025-06-26 17:51:06.168951 2025-06-26 17:51:06.169345
[1 rows x 5 columns]
2025-06-26 17:51:06,195 - IOOppi_data - INFO : save diff data to db: IOOppi_eg_t: no diff data
2025-06-26 17:51:06,201 - IOOppi_data - INFO : save data to db IOOppi_eg_g data:
date value
1857 2025-06-22 4558.33
1858 2025-06-23 4550.00
1859 2025-06-24 4460.00
1860 2025-06-25 4423.33
1861 2025-06-26 4423.33
2025-06-26 17:51:06,251 - IOOppi_data - INFO : save new data to db IOOppi_eg_g: date value ... created_at updated_at
1864 2025-06-26 4423.33 ... 2025-06-26 17:51:06.243695 2025-06-26 17:51:06.244191
[1 rows x 5 columns]
2025-06-26 17:51:06,269 - 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-26 17:51:06,842 - IOOppi_data - INFO : save data to db IOOppi_sp_t data:
date value
1866 2025-06-22 6083.33
1867 2025-06-23 6083.33
1868 2025-06-24 6066.67
1869 2025-06-25 6000.00
1870 2025-06-26 5983.33
2025-06-26 17:51:06,891 - IOOppi_data - INFO : save new data to db IOOppi_sp_t: date value ... created_at updated_at
1870 2025-06-26 5983.33 ... 2025-06-26 17:51:06.884387 2025-06-26 17:51:06.884800
[1 rows x 5 columns]
2025-06-26 17:51:06,910 - IOOppi_data - INFO : save diff data to db: IOOppi_sp_t: no diff data
2025-06-26 17:51:06,915 - IOOppi_data - INFO : save data to db IOOppi_sp_g data:
date value
1866 2025-06-22 6083.33
1867 2025-06-23 6083.33
1868 2025-06-24 6066.67
1869 2025-06-25 6000.00
1870 2025-06-26 5983.33
2025-06-26 17:51:06,968 - IOOppi_data - INFO : save new data to db IOOppi_sp_g: date value ... created_at updated_at
1873 2025-06-26 5983.33 ... 2025-06-26 17:51:06.961086 2025-06-26 17:51:06.961471
[1 rows x 5 columns]
2025-06-26 17:51:06,986 - 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-26 17:51:07,579 - IOOppi_data - INFO : save data to db IOOppi_p_t data:
date value
3534 2025-06-22 8832.0
3535 2025-06-23 8732.0
3536 2025-06-24 8602.0
3537 2025-06-25 8560.0
3538 2025-06-26 8560.0
2025-06-26 17:51:07,648 - IOOppi_data - INFO : save new data to db IOOppi_p_t: date value ... created_at updated_at
3538 2025-06-26 8560.0 ... 2025-06-26 17:51:07.641327 2025-06-26 17:51:07.641714
[1 rows x 5 columns]
2025-06-26 17:51:07,667 - IOOppi_data - INFO : save diff data to db: IOOppi_p_t: no diff data
2025-06-26 17:51:07,673 - IOOppi_data - INFO : save data to db IOOppi_p_g data:
date value
3534 2025-06-22 8832.0
3535 2025-06-23 8732.0
3536 2025-06-24 8602.0
3537 2025-06-25 8560.0
3538 2025-06-26 8560.0
2025-06-26 17:51:07,743 - IOOppi_data - INFO : save new data to db IOOppi_p_g: date value ... created_at updated_at
3541 2025-06-26 8560.0 ... 2025-06-26 17:51:07.736516 2025-06-26 17:51:07.736925
[1 rows x 5 columns]
2025-06-26 17:51:07,761 - IOOppi_data - INFO : save diff data to db: IOOppi_p_g: no diff data