=========================================================================
2025-06-27 17:50:26 Fri START TASK.01 IOOppi_data update_data
=========================================================================
/usr/local/lib/python3.10/site-packages/urllib3/connectionpool.py:1056: InsecureRequestWarning: Unverified HTTPS request is being made to host 'www.100ppi.com'. Adding certificate verification is strongly advised. See: https://urllib3.readthedocs.io/en/1.26.x/advanced-usage.html#ssl-warnings
warnings.warn(
2025-06-27 17:50:28,313 - IOOppi_data - INFO : save data to db IOOppi_rb_t data:
date value
3343 2025-06-23 3071.00
3344 2025-06-24 3071.00
3345 2025-06-25 3062.33
3346 2025-06-26 3060.33
3347 2025-06-27 3072.00
2025-06-27 17:50:28,387 - IOOppi_data - INFO : save new data to db IOOppi_rb_t: date value ... created_at updated_at
3347 2025-06-27 3072.0 ... 2025-06-27 17:50:28.379833 2025-06-27 17:50:28.380260
[1 rows x 5 columns]
2025-06-27 17:50:28,407 - IOOppi_data - INFO : save diff data to db: IOOppi_rb_t: no diff data
2025-06-27 17:50:28,412 - IOOppi_data - INFO : save data to db IOOppi_rb_g data:
date value
3343 2025-06-23 3071.00
3344 2025-06-24 3071.00
3345 2025-06-25 3062.33
3346 2025-06-26 3060.33
3347 2025-06-27 3072.00
2025-06-27 17:50:28,480 - IOOppi_data - INFO : save new data to db IOOppi_rb_g: date value ... created_at updated_at
3350 2025-06-27 3072.0 ... 2025-06-27 17:50:28.472919 2025-06-27 17:50:28.473320
[1 rows x 5 columns]
2025-06-27 17:50:28,500 - 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-27 17:50:29,140 - IOOppi_data - INFO : save data to db IOOppi_MA_t data:
date value
3564 2025-06-23 2719.83
3565 2025-06-24 2656.67
3566 2025-06-25 2646.67
3567 2025-06-26 2750.83
3568 2025-06-27 2785.83
2025-06-27 17:50:29,209 - IOOppi_data - INFO : save new data to db IOOppi_MA_t: date value ... created_at updated_at
3568 2025-06-27 2785.83 ... 2025-06-27 17:50:29.202188 2025-06-27 17:50:29.202574
[1 rows x 5 columns]
2025-06-27 17:50:29,229 - IOOppi_data - INFO : save diff data to db: IOOppi_MA_t: no diff data
2025-06-27 17:50:29,235 - IOOppi_data - INFO : save data to db IOOppi_MA_g data:
date value
3564 2025-06-23 2719.83
3565 2025-06-24 2656.67
3566 2025-06-25 2646.67
3567 2025-06-26 2750.83
3568 2025-06-27 2785.83
2025-06-27 17:50:29,307 - IOOppi_data - INFO : save new data to db IOOppi_MA_g: date value ... created_at updated_at
3572 2025-06-27 2785.83 ... 2025-06-27 17:50:29.299930 2025-06-27 17:50:29.300342
[1 rows x 5 columns]
2025-06-27 17:50:29,326 - 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-27 17:50:29,943 - IOOppi_data - INFO : save data to db IOOppi_PTA_t data:
date value
904 2025-06-23 5282.00
905 2025-06-24 5114.00
906 2025-06-25 5114.00
907 2025-06-26 5083.25
908 2025-06-27 5084.75
2025-06-27 17:50:29,980 - IOOppi_data - INFO : save new data to db IOOppi_PTA_t: date value ... created_at updated_at
908 2025-06-27 5084.75 ... 2025-06-27 17:50:29.973633 2025-06-27 17:50:29.974051
[1 rows x 5 columns]
2025-06-27 17:50:30,000 - IOOppi_data - INFO : save diff data to db: IOOppi_PTA_t: no diff data
2025-06-27 17:50:30,005 - IOOppi_data - INFO : save data to db IOOppi_PTA_g data:
date value
904 2025-06-23 5282.00
905 2025-06-24 5114.00
906 2025-06-25 5114.00
907 2025-06-26 5083.25
908 2025-06-27 5084.75
2025-06-27 17:50:30,042 - IOOppi_data - INFO : save new data to db IOOppi_PTA_g: date value ... created_at updated_at
908 2025-06-27 5084.75 ... 2025-06-27 17:50:30.035104 2025-06-27 17:50:30.035482
[1 rows x 5 columns]
2025-06-27 17:50:30,061 - 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-27 17:50:30,671 - IOOppi_data - INFO : save data to db IOOppi_ru_t data:
date value
3783 2025-06-23 13808.33
3784 2025-06-24 13538.33
3785 2025-06-25 13628.33
3786 2025-06-26 13878.33
3787 2025-06-27 13878.33
2025-06-27 17:50:30,748 - IOOppi_data - INFO : save new data to db IOOppi_ru_t: date ... updated_at
3787 2025-06-27 ... 2025-06-27 17:50:30.741654
[1 rows x 5 columns]
2025-06-27 17:50:30,767 - IOOppi_data - INFO : save diff data to db: IOOppi_ru_t: no diff data
2025-06-27 17:50:30,773 - IOOppi_data - INFO : save data to db IOOppi_ru_g data:
date value
3783 2025-06-23 13808.33
3784 2025-06-24 13538.33
3785 2025-06-25 13628.33
3786 2025-06-26 13878.33
3787 2025-06-27 13878.33
2025-06-27 17:50:30,847 - IOOppi_data - INFO : save new data to db IOOppi_ru_g: date ... updated_at
3790 2025-06-27 ... 2025-06-27 17:50:30.840406
[1 rows x 5 columns]
2025-06-27 17:50:30,865 - 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-27 17:50:31,766 - IOOppi_data - INFO : save data to db IOOppi_i_t data:
date value
3115 2025-06-23 727.44
3116 2025-06-24 723.11
3117 2025-06-25 717.44
3118 2025-06-26 715.78
3119 2025-06-27 725.44
2025-06-27 17:50:31,831 - IOOppi_data - INFO : save new data to db IOOppi_i_t: date value ... created_at updated_at
3119 2025-06-27 725.44 ... 2025-06-27 17:50:31.823830 2025-06-27 17:50:31.824237
[1 rows x 5 columns]
2025-06-27 17:50:31,849 - IOOppi_data - INFO : save diff data to db: IOOppi_i_t: no diff data
2025-06-27 17:50:31,855 - IOOppi_data - INFO : save data to db IOOppi_i_g data:
date value
3115 2025-06-23 727.44
3116 2025-06-24 723.11
3117 2025-06-25 717.44
3118 2025-06-26 715.78
3119 2025-06-27 725.44
2025-06-27 17:50:31,920 - IOOppi_data - INFO : save new data to db IOOppi_i_g: date value ... created_at updated_at
3122 2025-06-27 725.44 ... 2025-06-27 17:50:31.912659 2025-06-27 17:50:31.913080
[1 rows x 5 columns]
2025-06-27 17:50:31,939 - 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-27 17:50:32,496 - IOOppi_data - INFO : save data to db IOOppi_FG_t data:
date value
3318 2025-06-23 1105.6
3319 2025-06-24 1105.6
3320 2025-06-25 1105.6
3321 2025-06-26 1105.6
3322 2025-06-27 1105.6
2025-06-27 17:50:32,566 - IOOppi_data - INFO : save new data to db IOOppi_FG_t: date value ... created_at updated_at
3322 2025-06-27 1105.6 ... 2025-06-27 17:50:32.559004 2025-06-27 17:50:32.559402
[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-27 17:50:34,495 - IOOppi_data - INFO : save diff data to db IOOppi_FG_t: date ... updated_at
12 2012-12-19 ... 2025-06-27 17:50:34.488037
21 2013-01-04 ... 2025-06-27 17:50:34.488037
54 2013-02-27 ... 2025-06-27 17:50:34.488037
60 2013-03-07 ... 2025-06-27 17:50:34.488037
61 2013-03-08 ... 2025-06-27 17:50:34.488037
[5 rows x 6 columns]
2025-06-27 17:50:34,653 - IOOppi_data - INFO : save data to db IOOppi_FG_g data:
date value
3318 2025-06-23 1105.6
3319 2025-06-24 1105.6
3320 2025-06-25 1105.6
3321 2025-06-26 1105.6
3322 2025-06-27 1105.6
2025-06-27 17:50:34,723 - IOOppi_data - INFO : save new data to db IOOppi_FG_g: date value ... created_at updated_at
3326 2025-06-27 1105.6 ... 2025-06-27 17:50:34.716205 2025-06-27 17:50:34.716602
[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-27 17:50:36,658 - IOOppi_data - INFO : save diff data to db IOOppi_FG_g: date ... updated_at
12 2012-12-19 ... 2025-06-27 17:50:36.650854
21 2013-01-04 ... 2025-06-27 17:50:36.650854
54 2013-02-27 ... 2025-06-27 17:50:36.650854
60 2013-03-07 ... 2025-06-27 17:50:36.650854
61 2013-03-08 ... 2025-06-27 17:50:36.650854
[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-27 17:50:37,432 - IOOppi_data - INFO : save data to db IOOppi_eb_t data:
date value
1663 2025-06-23 8244.0
1664 2025-06-24 8264.0
1665 2025-06-25 8224.0
1666 2025-06-26 8164.0
1667 2025-06-27 8084.0
2025-06-27 17:50:37,481 - IOOppi_data - INFO : save new data to db IOOppi_eb_t: date value ... created_at updated_at
1667 2025-06-27 8084.0 ... 2025-06-27 17:50:37.473539 2025-06-27 17:50:37.473969
[1 rows x 5 columns]
2025-06-27 17:50:37,501 - IOOppi_data - INFO : save diff data to db: IOOppi_eb_t: no diff data
2025-06-27 17:50:37,507 - IOOppi_data - INFO : save data to db IOOppi_eb_g data:
date value
1663 2025-06-23 8244.0
1664 2025-06-24 8264.0
1665 2025-06-25 8224.0
1666 2025-06-26 8164.0
1667 2025-06-27 8084.0
2025-06-27 17:50:37,558 - IOOppi_data - INFO : save new data to db IOOppi_eb_g: date value ... created_at updated_at
1670 2025-06-27 8084.0 ... 2025-06-27 17:50:37.550239 2025-06-27 17:50:37.550678
[1 rows x 5 columns]
2025-06-27 17:50:37,577 - 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-27 17:50:38,181 - IOOppi_data - INFO : save data to db IOOppi_SR_t data:
date value
3774 2025-06-23 6050.00
3775 2025-06-24 6050.00
3776 2025-06-25 6053.33
3777 2025-06-26 6050.00
3778 2025-06-27 6056.67
2025-06-27 17:50:38,255 - IOOppi_data - INFO : save new data to db IOOppi_SR_t: date value ... created_at updated_at
3778 2025-06-27 6056.67 ... 2025-06-27 17:50:38.248503 2025-06-27 17:50:38.248945
[1 rows x 5 columns]
2025-06-27 17:50:38,275 - IOOppi_data - INFO : save diff data to db: IOOppi_SR_t: no diff data
2025-06-27 17:50:38,281 - IOOppi_data - INFO : save data to db IOOppi_SR_g data:
date value
3774 2025-06-23 6050.00
3775 2025-06-24 6050.00
3776 2025-06-25 6053.33
3777 2025-06-26 6050.00
3778 2025-06-27 6056.67
2025-06-27 17:50:38,353 - IOOppi_data - INFO : save new data to db IOOppi_SR_g: date value ... created_at updated_at
3782 2025-06-27 6056.67 ... 2025-06-27 17:50:38.346361 2025-06-27 17:50:38.346746
[1 rows x 5 columns]
2025-06-27 17:50:38,371 - 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-27 17:50:38,933 - IOOppi_data - INFO : save data to db IOOppi_ss_t data:
date value
1664 2025-06-23 12762.5
1665 2025-06-24 12762.5
1666 2025-06-25 12725.0
1667 2025-06-26 12725.0
1668 2025-06-27 12762.5
2025-06-27 17:50:38,982 - IOOppi_data - INFO : save new data to db IOOppi_ss_t: date value ... created_at updated_at
1668 2025-06-27 12762.5 ... 2025-06-27 17:50:38.974196 2025-06-27 17:50:38.974603
[1 rows x 5 columns]
2025-06-27 17:50:39,002 - IOOppi_data - INFO : save diff data to db: IOOppi_ss_t: no diff data
2025-06-27 17:50:39,008 - IOOppi_data - INFO : save data to db IOOppi_ss_g data:
date value
1664 2025-06-23 12762.5
1665 2025-06-24 12762.5
1666 2025-06-25 12725.0
1667 2025-06-26 12725.0
1668 2025-06-27 12762.5
2025-06-27 17:50:39,056 - IOOppi_data - INFO : save new data to db IOOppi_ss_g: date value ... created_at updated_at
1671 2025-06-27 12762.5 ... 2025-06-27 17:50:39.049205 2025-06-27 17:50:39.049588
[1 rows x 5 columns]
2025-06-27 17:50:39,075 - 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-27 17:50:39,737 - IOOppi_data - INFO : save data to db IOOppi_RS_t data:
date value
3174 2025-06-23 9878.33
3175 2025-06-24 9731.67
3176 2025-06-25 9631.67
3177 2025-06-26 9631.67
3178 2025-06-27 9631.67
2025-06-27 17:50:39,802 - IOOppi_data - INFO : save new data to db IOOppi_RS_t: date value ... created_at updated_at
3178 2025-06-27 9631.67 ... 2025-06-27 17:50:39.794158 2025-06-27 17:50:39.794786
[1 rows x 5 columns]
2025-06-27 17:50:39,821 - IOOppi_data - INFO : save diff data to db: IOOppi_RS_t: no diff data
2025-06-27 17:50:39,826 - IOOppi_data - INFO : save data to db IOOppi_RS_g data:
date value
3174 2025-06-23 9878.33
3175 2025-06-24 9731.67
3176 2025-06-25 9631.67
3177 2025-06-26 9631.67
3178 2025-06-27 9631.67
2025-06-27 17:50:39,891 - IOOppi_data - INFO : save new data to db IOOppi_RS_g: date value ... created_at updated_at
3182 2025-06-27 9631.67 ... 2025-06-27 17:50:39.884673 2025-06-27 17:50:39.885082
[1 rows x 5 columns]
2025-06-27 17:50:39,909 - 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-27 17:50:40,465 - IOOppi_data - INFO : save data to db IOOppi_RM_t data:
date value
3297 2025-06-23 2588.33
3298 2025-06-24 2588.33
3299 2025-06-25 2566.67
3300 2025-06-26 2478.33
3301 2025-06-27 2475.00
2025-06-27 17:50:40,533 - IOOppi_data - INFO : save new data to db IOOppi_RM_t: date value ... created_at updated_at
3301 2025-06-27 2475.0 ... 2025-06-27 17:50:40.525561 2025-06-27 17:50:40.526012
[1 rows x 5 columns]
2025-06-27 17:50:40,552 - IOOppi_data - INFO : save diff data to db: IOOppi_RM_t: no diff data
2025-06-27 17:50:40,558 - IOOppi_data - INFO : save data to db IOOppi_RM_g data:
date value
3297 2025-06-23 2588.33
3298 2025-06-24 2588.33
3299 2025-06-25 2566.67
3300 2025-06-26 2478.33
3301 2025-06-27 2475.00
2025-06-27 17:50:40,631 - IOOppi_data - INFO : save new data to db IOOppi_RM_g: date value ... created_at updated_at
3305 2025-06-27 2475.0 ... 2025-06-27 17:50:40.623408 2025-06-27 17:50:40.623884
[1 rows x 5 columns]
2025-06-27 17:50:40,649 - 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-27 17:50:41,159 - IOOppi_data - INFO : save data to db IOOppi_SA_t data:
date value
1501 2025-06-23 1350.0
1502 2025-06-24 1350.0
1503 2025-06-25 1337.5
1504 2025-06-26 1337.5
1505 2025-06-27 1337.5
2025-06-27 17:50:41,206 - IOOppi_data - INFO : save new data to db IOOppi_SA_t: date value ... created_at updated_at
1505 2025-06-27 1337.5 ... 2025-06-27 17:50:41.199200 2025-06-27 17:50:41.199597
[1 rows x 5 columns]
2025-06-27 17:50:41,225 - IOOppi_data - INFO : save diff data to db: IOOppi_SA_t: no diff data
2025-06-27 17:50:41,230 - IOOppi_data - INFO : save data to db IOOppi_SA_g data:
date value
1501 2025-06-23 1350.0
1502 2025-06-24 1350.0
1503 2025-06-25 1337.5
1504 2025-06-26 1337.5
1505 2025-06-27 1337.5
2025-06-27 17:50:41,275 - IOOppi_data - INFO : save new data to db IOOppi_SA_g: date value ... created_at updated_at
1509 2025-06-27 1337.5 ... 2025-06-27 17:50:41.268324 2025-06-27 17:50:41.268715
[1 rows x 5 columns]
2025-06-27 17:50:41,293 - 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-27 17:50:42,059 - IOOppi_data - INFO : save data to db IOOppi_PF_t data:
date value
1414 2025-06-23 6926.25
1415 2025-06-24 6838.75
1416 2025-06-25 6801.88
1417 2025-06-26 6767.29
1418 2025-06-27 6736.04
2025-06-27 17:50:42,102 - IOOppi_data - INFO : save new data to db IOOppi_PF_t: date value ... created_at updated_at
1418 2025-06-27 6736.04 ... 2025-06-27 17:50:42.094888 2025-06-27 17:50:42.095284
[1 rows x 5 columns]
2025-06-27 17:50:42,120 - IOOppi_data - INFO : save diff data to db: IOOppi_PF_t: no diff data
2025-06-27 17:50:42,125 - IOOppi_data - INFO : save data to db IOOppi_PF_g data:
date value
1414 2025-06-23 6926.25
1415 2025-06-24 6838.75
1416 2025-06-25 6801.88
1417 2025-06-26 6767.29
1418 2025-06-27 6736.04
2025-06-27 17:50:42,170 - IOOppi_data - INFO : save new data to db IOOppi_PF_g: date value ... created_at updated_at
1422 2025-06-27 6736.04 ... 2025-06-27 17:50:42.163514 2025-06-27 17:50:42.163931
[1 rows x 5 columns]
2025-06-27 17:50:42,189 - 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-27 17:50:42,763 - IOOppi_data - INFO : save data to db IOOppi_m_t data:
date value
3787 2025-06-23 2986.0
3788 2025-06-24 2974.0
3789 2025-06-25 2958.0
3790 2025-06-26 2916.0
3791 2025-06-27 2906.0
2025-06-27 17:50:42,842 - IOOppi_data - INFO : save new data to db IOOppi_m_t: date value ... created_at updated_at
3791 2025-06-27 2906.0 ... 2025-06-27 17:50:42.833694 2025-06-27 17:50:42.834183
[1 rows x 5 columns]
2025-06-27 17:50:42,860 - IOOppi_data - INFO : save diff data to db: IOOppi_m_t: no diff data
2025-06-27 17:50:42,869 - IOOppi_data - INFO : save data to db IOOppi_m_g data:
date value
3787 2025-06-23 2986.0
3788 2025-06-24 2974.0
3789 2025-06-25 2958.0
3790 2025-06-26 2916.0
3791 2025-06-27 2906.0
2025-06-27 17:50:42,946 - IOOppi_data - INFO : save new data to db IOOppi_m_g: date value ... created_at updated_at
3794 2025-06-27 2906.0 ... 2025-06-27 17:50:42.938940 2025-06-27 17:50:42.939328
[1 rows x 5 columns]
2025-06-27 17:50:42,964 - 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-27 17:50:43,559 - IOOppi_data - INFO : save data to db IOOppi_y_t data:
date value
3557 2025-06-23 8394.0
3558 2025-06-24 8214.0
3559 2025-06-25 8244.0
3560 2025-06-26 8254.0
3561 2025-06-27 8254.0
2025-06-27 17:50:43,632 - IOOppi_data - INFO : save new data to db IOOppi_y_t: date value ... created_at updated_at
3561 2025-06-27 8254.0 ... 2025-06-27 17:50:43.624698 2025-06-27 17:50:43.625126
[1 rows x 5 columns]
2025-06-27 17:50:43,650 - IOOppi_data - INFO : save diff data to db: IOOppi_y_t: no diff data
2025-06-27 17:50:43,656 - IOOppi_data - INFO : save data to db IOOppi_y_g data:
date value
3557 2025-06-23 8394.0
3558 2025-06-24 8214.0
3559 2025-06-25 8244.0
3560 2025-06-26 8254.0
3561 2025-06-27 8254.0
2025-06-27 17:50:43,726 - IOOppi_data - INFO : save new data to db IOOppi_y_g: date value ... created_at updated_at
3564 2025-06-27 8254.0 ... 2025-06-27 17:50:43.719176 2025-06-27 17:50:43.719560
[1 rows x 5 columns]
2025-06-27 17:50:43,746 - 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-27 17:50:44,312 - IOOppi_data - INFO : save data to db IOOppi_a_t data:
date value
3523 2025-06-23 4295.0
3524 2025-06-24 4295.0
3525 2025-06-25 4295.0
3526 2025-06-26 4295.0
3527 2025-06-27 4295.0
2025-06-27 17:50:44,386 - IOOppi_data - INFO : save new data to db IOOppi_a_t: date value ... created_at updated_at
3527 2025-06-27 4295.0 ... 2025-06-27 17:50:44.378248 2025-06-27 17:50:44.378699
[1 rows x 5 columns]
2025-06-27 17:50:44,406 - IOOppi_data - INFO : save diff data to db: IOOppi_a_t: no diff data
2025-06-27 17:50:44,413 - IOOppi_data - INFO : save data to db IOOppi_a_g data:
date value
3523 2025-06-23 4295.0
3524 2025-06-24 4295.0
3525 2025-06-25 4295.0
3526 2025-06-26 4295.0
3527 2025-06-27 4295.0
2025-06-27 17:50:44,481 - IOOppi_data - INFO : save new data to db IOOppi_a_g: date value ... created_at updated_at
3530 2025-06-27 4295.0 ... 2025-06-27 17:50:44.474403 2025-06-27 17:50:44.474807
[1 rows x 5 columns]
2025-06-27 17:50:44,500 - 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-27 17:50:45,092 - IOOppi_data - INFO : save data to db IOOppi_SF_t data:
date value
2900 2025-06-23 5130.00
2901 2025-06-24 5128.57
2902 2025-06-25 5125.71
2903 2025-06-26 5132.86
2904 2025-06-27 5158.57
2025-06-27 17:50:45,156 - IOOppi_data - INFO : save new data to db IOOppi_SF_t: date value ... created_at updated_at
2904 2025-06-27 5158.57 ... 2025-06-27 17:50:45.149103 2025-06-27 17:50:45.149490
[1 rows x 5 columns]
2025-06-27 17:50:45,175 - IOOppi_data - INFO : save diff data to db: IOOppi_SF_t: no diff data
2025-06-27 17:50:45,181 - IOOppi_data - INFO : save data to db IOOppi_SF_g data:
date value
2900 2025-06-23 5130.00
2901 2025-06-24 5128.57
2902 2025-06-25 5125.71
2903 2025-06-26 5132.86
2904 2025-06-27 5158.57
2025-06-27 17:50:45,244 - IOOppi_data - INFO : save new data to db IOOppi_SF_g: date value ... created_at updated_at
2908 2025-06-27 5158.57 ... 2025-06-27 17:50:45.237283 2025-06-27 17:50:45.237665
[1 rows x 5 columns]
2025-06-27 17:50:45,264 - 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-27 17:50:45,791 - IOOppi_data - INFO : save data to db IOOppi_jd_t data:
date value
3100 2025-06-23 2925.0
3101 2025-06-24 2925.0
3102 2025-06-25 2890.0
3103 2025-06-26 2890.0
3104 2025-06-27 2890.0
2025-06-27 17:50:45,860 - IOOppi_data - INFO : save new data to db IOOppi_jd_t: date value ... created_at updated_at
3104 2025-06-27 2890.0 ... 2025-06-27 17:50:45.852198 2025-06-27 17:50:45.852631
[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-27 17:50:46,013 - IOOppi_data - INFO : save diff data to db IOOppi_jd_t: date ... updated_at
39 2014-01-03 ... 2025-06-27 17:50:46.005406
458 2015-09-21 ... 2025-06-27 17:50:46.005406
549 2016-02-03 ... 2025-06-27 17:50:46.005406
693 2016-09-05 ... 2025-06-27 17:50:46.005406
696 2016-09-08 ... 2025-06-27 17:50:46.005406
[5 rows x 6 columns]
2025-06-27 17:50:46,043 - IOOppi_data - INFO : save data to db IOOppi_jd_g data:
date value
3100 2025-06-23 2925.0
3101 2025-06-24 2925.0
3102 2025-06-25 2890.0
3103 2025-06-26 2890.0
3104 2025-06-27 2890.0
2025-06-27 17:50:46,107 - IOOppi_data - INFO : save new data to db IOOppi_jd_g: date value ... created_at updated_at
3107 2025-06-27 2890.0 ... 2025-06-27 17:50:46.100099 2025-06-27 17:50:46.100486
[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-27 17:50:46,251 - IOOppi_data - INFO : save diff data to db IOOppi_jd_g: date ... updated_at
39 2014-01-03 ... 2025-06-27 17:50:46.243408
458 2015-09-21 ... 2025-06-27 17:50:46.243408
549 2016-02-03 ... 2025-06-27 17:50:46.243408
693 2016-09-05 ... 2025-06-27 17:50:46.243408
696 2016-09-08 ... 2025-06-27 17:50:46.243408
[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-27 17:50:46,896 - IOOppi_data - INFO : save data to db IOOppi_SI_t data:
date value
904 2025-06-23 8620.0
905 2025-06-24 8620.0
906 2025-06-25 8620.0
907 2025-06-26 8620.0
908 2025-06-27 8620.0
2025-06-27 17:50:46,932 - IOOppi_data - INFO : save new data to db IOOppi_SI_t: date value ... created_at updated_at
908 2025-06-27 8620.0 ... 2025-06-27 17:50:46.924851 2025-06-27 17:50:46.925236
[1 rows x 5 columns]
2025-06-27 17:50:46,951 - IOOppi_data - INFO : save diff data to db: IOOppi_SI_t: no diff data
2025-06-27 17:50:46,956 - IOOppi_data - INFO : save data to db IOOppi_SI_g data:
date value
904 2025-06-23 8620.0
905 2025-06-24 8620.0
906 2025-06-25 8620.0
907 2025-06-26 8620.0
908 2025-06-27 8620.0
2025-06-27 17:50:46,993 - IOOppi_data - INFO : save new data to db IOOppi_SI_g: date value ... created_at updated_at
908 2025-06-27 8620.0 ... 2025-06-27 17:50:46.985706 2025-06-27 17:50:46.986122
[1 rows x 5 columns]
2025-06-27 17:50:47,011 - 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-27 17:50:47,689 - IOOppi_data - INFO : save data to db IOOppi_l_t data:
date value
3783 2025-06-23 7593.33
3784 2025-06-24 7571.67
3785 2025-06-25 7548.33
3786 2025-06-26 7511.67
3787 2025-06-27 7511.67
2025-06-27 17:50:47,762 - IOOppi_data - INFO : save new data to db IOOppi_l_t: date value ... created_at updated_at
3787 2025-06-27 7511.67 ... 2025-06-27 17:50:47.755326 2025-06-27 17:50:47.755717
[1 rows x 5 columns]
2025-06-27 17:50:47,781 - IOOppi_data - INFO : save diff data to db: IOOppi_l_t: no diff data
2025-06-27 17:50:47,788 - IOOppi_data - INFO : save data to db IOOppi_l_g data:
date value
3783 2025-06-23 7593.33
3784 2025-06-24 7571.67
3785 2025-06-25 7548.33
3786 2025-06-26 7511.67
3787 2025-06-27 7511.67
2025-06-27 17:50:47,861 - IOOppi_data - INFO : save new data to db IOOppi_l_g: date value ... created_at updated_at
3790 2025-06-27 7511.67 ... 2025-06-27 17:50:47.853986 2025-06-27 17:50:47.854385
[1 rows x 5 columns]
2025-06-27 17:50:47,880 - 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-27 17:50:48,471 - IOOppi_data - INFO : save data to db IOOppi_bu_t data:
date value
3121 2025-06-23 3746.67
3122 2025-06-24 3773.33
3123 2025-06-25 3700.00
3124 2025-06-26 3700.00
3125 2025-06-27 3700.00
2025-06-27 17:50:48,537 - IOOppi_data - INFO : save new data to db IOOppi_bu_t: date value ... created_at updated_at
3126 2025-06-27 3700.0 ... 2025-06-27 17:50:48.530043 2025-06-27 17:50:48.530439
[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-27 17:50:48,573 - IOOppi_data - INFO : save diff data to db IOOppi_bu_t: date ... updated_at
2560 2023-12-09 ... 2025-06-27 17:50:48.565997
[1 rows x 6 columns]
2025-06-27 17:50:48,599 - IOOppi_data - INFO : save data to db IOOppi_bu_g data:
date value
3121 2025-06-23 3746.67
3122 2025-06-24 3773.33
3123 2025-06-25 3700.00
3124 2025-06-26 3700.00
3125 2025-06-27 3700.00
2025-06-27 17:50:48,664 - IOOppi_data - INFO : save new data to db IOOppi_bu_g: date value ... created_at updated_at
3128 2025-06-27 3700.0 ... 2025-06-27 17:50:48.656690 2025-06-27 17:50:48.657114
[1 rows x 5 columns]
2025-06-27 17:50:48,682 - 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-27 17:50:49,287 - IOOppi_data - INFO : save data to db IOOppi_al_t data:
date value
3786 2025-06-23 20663.33
3787 2025-06-24 20663.33
3788 2025-06-25 20550.00
3789 2025-06-26 20550.00
3790 2025-06-27 20903.33
2025-06-27 17:50:49,359 - IOOppi_data - INFO : save new data to db IOOppi_al_t: date ... updated_at
3790 2025-06-27 ... 2025-06-27 17:50:49.352985
[1 rows x 5 columns]
2025-06-27 17:50:49,379 - IOOppi_data - INFO : save diff data to db: IOOppi_al_t: no diff data
2025-06-27 17:50:49,385 - IOOppi_data - INFO : save data to db IOOppi_al_g data:
date value
3786 2025-06-23 20663.33
3787 2025-06-24 20663.33
3788 2025-06-25 20550.00
3789 2025-06-26 20550.00
3790 2025-06-27 20903.33
2025-06-27 17:50:49,459 - IOOppi_data - INFO : save new data to db IOOppi_al_g: date ... updated_at
3793 2025-06-27 ... 2025-06-27 17:50:49.453463
[1 rows x 5 columns]
2025-06-27 17:50:49,478 - 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-27 17:50:50,060 - IOOppi_data - INFO : save data to db IOOppi_SM_t data:
date value
2900 2025-06-23 5524.0
2901 2025-06-24 5518.0
2902 2025-06-25 5520.0
2903 2025-06-26 5562.0
2904 2025-06-27 5572.0
2025-06-27 17:50:50,122 - IOOppi_data - INFO : save new data to db IOOppi_SM_t: date value ... created_at updated_at
2904 2025-06-27 5572.0 ... 2025-06-27 17:50:50.114790 2025-06-27 17:50:50.115198
[1 rows x 5 columns]
2025-06-27 17:50:50,143 - IOOppi_data - INFO : save diff data to db: IOOppi_SM_t: no diff data
2025-06-27 17:50:50,149 - IOOppi_data - INFO : save data to db IOOppi_SM_g data:
date value
2900 2025-06-23 5524.0
2901 2025-06-24 5518.0
2902 2025-06-25 5520.0
2903 2025-06-26 5562.0
2904 2025-06-27 5572.0
2025-06-27 17:50:50,210 - IOOppi_data - INFO : save new data to db IOOppi_SM_g: date value ... created_at updated_at
2908 2025-06-27 5572.0 ... 2025-06-27 17:50:50.203655 2025-06-27 17:50:50.204076
[1 rows x 5 columns]
2025-06-27 17:50:50,229 - 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-27 17:50:50,803 - IOOppi_data - INFO : save data to db IOOppi_CY_t data:
date value
2175 2025-06-23 23550.0
2176 2025-06-24 23200.0
2177 2025-06-25 23200.0
2178 2025-06-26 23200.0
2179 2025-06-27 23200.0
2025-06-27 17:50:50,856 - IOOppi_data - INFO : save new data to db IOOppi_CY_t: date value ... created_at updated_at
2179 2025-06-27 23200.0 ... 2025-06-27 17:50:50.849165 2025-06-27 17:50:50.849560
[1 rows x 5 columns]
2025-06-27 17:50:50,875 - IOOppi_data - INFO : save diff data to db: IOOppi_CY_t: no diff data
2025-06-27 17:50:50,881 - IOOppi_data - INFO : save data to db IOOppi_CY_g data:
date value
2175 2025-06-23 23550.0
2176 2025-06-24 23200.0
2177 2025-06-25 23200.0
2178 2025-06-26 23200.0
2179 2025-06-27 23200.0
2025-06-27 17:50:50,937 - IOOppi_data - INFO : save new data to db IOOppi_CY_g: date value ... created_at updated_at
2183 2025-06-27 23200.0 ... 2025-06-27 17:50:50.929480 2025-06-27 17:50:50.929951
[1 rows x 5 columns]
2025-06-27 17:50:50,956 - 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-27 17:50:51,499 - IOOppi_data - INFO : save data to db IOOppi_UR_t data:
date value
1690 2025-06-23 1824.0
1691 2025-06-24 1804.0
1692 2025-06-25 1804.0
1693 2025-06-26 1822.6
1694 2025-06-27 1827.0
2025-06-27 17:50:51,546 - IOOppi_data - INFO : save new data to db IOOppi_UR_t: date value ... created_at updated_at
1694 2025-06-27 1827.0 ... 2025-06-27 17:50:51.539281 2025-06-27 17:50:51.539667
[1 rows x 5 columns]
2025-06-27 17:50:51,566 - IOOppi_data - INFO : save diff data to db: IOOppi_UR_t: no diff data
2025-06-27 17:50:51,572 - IOOppi_data - INFO : save data to db IOOppi_UR_g data:
date value
1690 2025-06-23 1824.0
1691 2025-06-24 1804.0
1692 2025-06-25 1804.0
1693 2025-06-26 1822.6
1694 2025-06-27 1827.0
2025-06-27 17:50:51,619 - IOOppi_data - INFO : save new data to db IOOppi_UR_g: date value ... created_at updated_at
1698 2025-06-27 1827.0 ... 2025-06-27 17:50:51.612531 2025-06-27 17:50:51.612949
[1 rows x 5 columns]
2025-06-27 17:50:51,637 - 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-27 17:50:52,265 - IOOppi_data - INFO : save data to db IOOppi_ni_t data:
date value
2762 2025-06-23 119616.67
2763 2025-06-24 119050.00
2764 2025-06-25 119733.33
2765 2025-06-26 121966.67
2766 2025-06-27 122433.33
2025-06-27 17:50:52,326 - IOOppi_data - INFO : save new data to db IOOppi_ni_t: date ... updated_at
2766 2025-06-27 ... 2025-06-27 17:50:52.320102
[1 rows x 5 columns]
2025-06-27 17:50:52,344 - IOOppi_data - INFO : save diff data to db: IOOppi_ni_t: no diff data
2025-06-27 17:50:52,350 - IOOppi_data - INFO : save data to db IOOppi_ni_g data:
date value
2762 2025-06-23 119616.67
2763 2025-06-24 119050.00
2764 2025-06-25 119733.33
2765 2025-06-26 121966.67
2766 2025-06-27 122433.33
2025-06-27 17:50:52,410 - IOOppi_data - INFO : save new data to db IOOppi_ni_g: date ... updated_at
2769 2025-06-27 ... 2025-06-27 17:50:52.403937
[1 rows x 5 columns]
2025-06-27 17:50:52,428 - 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-27 17:50:53,089 - IOOppi_data - INFO : save data to db IOOppi_v_t data:
date value
3787 2025-06-23 4669.0
3788 2025-06-24 4635.0
3789 2025-06-25 4661.0
3790 2025-06-26 4655.0
3791 2025-06-27 4673.0
2025-06-27 17:50:53,239 - IOOppi_data - INFO : save new data to db IOOppi_v_t: date value ... created_at updated_at
3791 2025-06-27 4673.0 ... 2025-06-27 17:50:53.232148 2025-06-27 17:50:53.232587
[1 rows x 5 columns]
2025-06-27 17:50:53,258 - IOOppi_data - INFO : save diff data to db: IOOppi_v_t: no diff data
2025-06-27 17:50:53,264 - IOOppi_data - INFO : save data to db IOOppi_v_g data:
date value
3787 2025-06-23 4669.0
3788 2025-06-24 4635.0
3789 2025-06-25 4661.0
3790 2025-06-26 4655.0
3791 2025-06-27 4673.0
2025-06-27 17:50:53,339 - IOOppi_data - INFO : save new data to db IOOppi_v_g: date value ... created_at updated_at
3794 2025-06-27 4673.0 ... 2025-06-27 17:50:53.332044 2025-06-27 17:50:53.332434
[1 rows x 5 columns]
2025-06-27 17:50:53,357 - 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-27 17:50:53,912 - IOOppi_data - INFO : save data to db IOOppi_pp_t data:
date value
3026 2025-06-23 7476.67
3027 2025-06-24 7501.67
3028 2025-06-25 7493.33
3029 2025-06-26 7483.33
3030 2025-06-27 7483.33
2025-06-27 17:50:53,980 - IOOppi_data - INFO : save new data to db IOOppi_pp_t: date value ... created_at updated_at
3030 2025-06-27 7483.33 ... 2025-06-27 17:50:53.972956 2025-06-27 17:50:53.973367
[1 rows x 5 columns]
2025-06-27 17:50:53,999 - IOOppi_data - INFO : save diff data to db: IOOppi_pp_t: no diff data
2025-06-27 17:50:54,006 - IOOppi_data - INFO : save data to db IOOppi_pp_g data:
date value
3026 2025-06-23 7476.67
3027 2025-06-24 7501.67
3028 2025-06-25 7493.33
3029 2025-06-26 7483.33
3030 2025-06-27 7483.33
2025-06-27 17:50:54,073 - IOOppi_data - INFO : save new data to db IOOppi_pp_g: date value ... created_at updated_at
3033 2025-06-27 7483.33 ... 2025-06-27 17:50:54.065951 2025-06-27 17:50:54.066396
[1 rows x 5 columns]
2025-06-27 17:50:54,092 - 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-27 17:50:54,690 - IOOppi_data - INFO : save data to db IOOppi_CF_t data:
date value
3788 2025-06-23 14881.83
3789 2025-06-24 14868.00
3790 2025-06-25 14913.67
3791 2025-06-26 15004.50
3792 2025-06-27 15105.67
2025-06-27 17:50:54,767 - IOOppi_data - INFO : save new data to db IOOppi_CF_t: date ... updated_at
3792 2025-06-27 ... 2025-06-27 17:50:54.759528
[1 rows x 5 columns]
2025-06-27 17:50:54,786 - IOOppi_data - INFO : save diff data to db: IOOppi_CF_t: no diff data
2025-06-27 17:50:54,793 - IOOppi_data - INFO : save data to db IOOppi_CF_g data:
date value
3788 2025-06-23 14881.83
3789 2025-06-24 14868.00
3790 2025-06-25 14913.67
3791 2025-06-26 15004.50
3792 2025-06-27 15105.67
2025-06-27 17:50:54,876 - IOOppi_data - INFO : save new data to db IOOppi_CF_g: date ... updated_at
3796 2025-06-27 ... 2025-06-27 17:50:54.869194
[1 rows x 5 columns]
2025-06-27 17:50:54,895 - 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-27 17:50:55,455 - IOOppi_data - INFO : save data to db IOOppi_pb_t data:
date value
3733 2025-06-23 16812.50
3734 2025-06-24 16850.00
3735 2025-06-25 17031.25
3736 2025-06-26 17075.00
3737 2025-06-27 17072.50
2025-06-27 17:50:55,534 - IOOppi_data - INFO : save new data to db IOOppi_pb_t: date value ... created_at updated_at
3737 2025-06-27 17072.5 ... 2025-06-27 17:50:55.527483 2025-06-27 17:50:55.527916
[1 rows x 5 columns]
2025-06-27 17:50:55,553 - IOOppi_data - INFO : save diff data to db: IOOppi_pb_t: no diff data
2025-06-27 17:50:55,559 - IOOppi_data - INFO : save data to db IOOppi_pb_g data:
date value
3733 2025-06-23 16812.50
3734 2025-06-24 16850.00
3735 2025-06-25 17031.25
3736 2025-06-26 17075.00
3737 2025-06-27 17072.50
2025-06-27 17:50:55,630 - IOOppi_data - INFO : save new data to db IOOppi_pb_g: date value ... created_at updated_at
3740 2025-06-27 17072.5 ... 2025-06-27 17:50:55.623476 2025-06-27 17:50:55.623893
[1 rows x 5 columns]
2025-06-27 17:50:55,649 - 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-27 17:50:56,205 - IOOppi_data - INFO : save data to db IOOppi_hc_t data:
date value
3008 2025-06-23 3190.00
3009 2025-06-24 3190.00
3010 2025-06-25 3180.00
3011 2025-06-26 3200.00
3012 2025-06-27 3206.67
2025-06-27 17:50:56,272 - IOOppi_data - INFO : save new data to db IOOppi_hc_t: date value ... created_at updated_at
3012 2025-06-27 3206.67 ... 2025-06-27 17:50:56.264570 2025-06-27 17:50:56.264993
[1 rows x 5 columns]
2025-06-27 17:50:56,291 - IOOppi_data - INFO : save diff data to db: IOOppi_hc_t: no diff data
2025-06-27 17:50:56,297 - IOOppi_data - INFO : save data to db IOOppi_hc_g data:
date value
3008 2025-06-23 3190.00
3009 2025-06-24 3190.00
3010 2025-06-25 3180.00
3011 2025-06-26 3200.00
3012 2025-06-27 3206.67
2025-06-27 17:50:56,366 - IOOppi_data - INFO : save new data to db IOOppi_hc_g: date value ... created_at updated_at
3015 2025-06-27 3206.67 ... 2025-06-27 17:50:56.358574 2025-06-27 17:50:56.359001
[1 rows x 5 columns]
2025-06-27 17:50:56,385 - 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-27 17:50:56,929 - IOOppi_data - INFO : save data to db IOOppi_fu_t data:
date value
3288 2025-06-23 5537.5
3289 2025-06-24 5550.0
3290 2025-06-25 5525.0
3291 2025-06-26 5525.0
3292 2025-06-27 5525.0
2025-06-27 17:50:56,998 - IOOppi_data - INFO : save new data to db IOOppi_fu_t: date value ... created_at updated_at
3292 2025-06-27 5525.0 ... 2025-06-27 17:50:56.990986 2025-06-27 17:50:56.991390
[1 rows x 5 columns]
2025-06-27 17:50:57,017 - IOOppi_data - INFO : save diff data to db: IOOppi_fu_t: no diff data
2025-06-27 17:50:57,023 - IOOppi_data - INFO : save data to db IOOppi_fu_g data:
date value
3288 2025-06-23 5537.5
3289 2025-06-24 5550.0
3290 2025-06-25 5525.0
3291 2025-06-26 5525.0
3292 2025-06-27 5525.0
2025-06-27 17:50:57,099 - IOOppi_data - INFO : save new data to db IOOppi_fu_g: date value ... created_at updated_at
3779 2025-06-27 5525.0 ... 2025-06-27 17:50:57.092081 2025-06-27 17:50:57.092469
[1 rows x 5 columns]
2025-06-27 17:50:57,117 - 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-27 17:50:57,947 - IOOppi_data - INFO : save data to db IOOppi_lh_t data:
date value
1352 2025-06-23 14300.0
1353 2025-06-24 14280.0
1354 2025-06-25 14320.0
1355 2025-06-26 14330.0
1356 2025-06-27 14420.0
2025-06-27 17:50:57,990 - IOOppi_data - INFO : save new data to db IOOppi_lh_t: date value ... created_at updated_at
1356 2025-06-27 14420.0 ... 2025-06-27 17:50:57.983125 2025-06-27 17:50:57.983547
[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-27 17:50:58,223 - IOOppi_data - INFO : save diff data to db IOOppi_lh_t: date ... updated_at
116 2021-07-05 ... 2025-06-27 17:50:58.215792
117 2021-07-06 ... 2025-06-27 17:50:58.215792
121 2021-07-12 ... 2025-06-27 17:50:58.215792
122 2021-07-13 ... 2025-06-27 17:50:58.215792
194 2021-11-01 ... 2025-06-27 17:50:58.215792
[5 rows x 6 columns]
2025-06-27 17:50:58,260 - IOOppi_data - INFO : save data to db IOOppi_lh_g data:
date value
1352 2025-06-23 14300.0
1353 2025-06-24 14280.0
1354 2025-06-25 14320.0
1355 2025-06-26 14330.0
1356 2025-06-27 14420.0
2025-06-27 17:50:58,302 - IOOppi_data - INFO : save new data to db IOOppi_lh_g: date value ... created_at updated_at
1359 2025-06-27 14420.0 ... 2025-06-27 17:50:58.295140 2025-06-27 17:50:58.295526
[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-27 17:50:58,536 - IOOppi_data - INFO : save diff data to db IOOppi_lh_g: date ... updated_at
116 2021-07-05 ... 2025-06-27 17:50:58.527555
117 2021-07-06 ... 2025-06-27 17:50:58.527555
121 2021-07-12 ... 2025-06-27 17:50:58.527555
122 2021-07-13 ... 2025-06-27 17:50:58.527555
194 2021-11-01 ... 2025-06-27 17:50:58.527555
[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-27 17:50:59,163 - IOOppi_data - INFO : save data to db IOOppi_cu_t data:
date value
3784 2025-06-23 78388.33
3785 2025-06-24 78471.67
3786 2025-06-25 78630.00
3787 2025-06-26 78886.67
3788 2025-06-27 80195.00
2025-06-27 17:50:59,240 - IOOppi_data - INFO : save new data to db IOOppi_cu_t: date value ... created_at updated_at
3788 2025-06-27 80195.0 ... 2025-06-27 17:50:59.232253 2025-06-27 17:50:59.232745
[1 rows x 5 columns]
2025-06-27 17:50:59,259 - IOOppi_data - INFO : save diff data to db: IOOppi_cu_t: no diff data
2025-06-27 17:50:59,266 - IOOppi_data - INFO : save data to db IOOppi_cu_g data:
date value
3784 2025-06-23 78388.33
3785 2025-06-24 78471.67
3786 2025-06-25 78630.00
3787 2025-06-26 78886.67
3788 2025-06-27 80195.00
2025-06-27 17:50:59,339 - IOOppi_data - INFO : save new data to db IOOppi_cu_g: date value ... created_at updated_at
3791 2025-06-27 80195.0 ... 2025-06-27 17:50:59.332466 2025-06-27 17:50:59.332879
[1 rows x 5 columns]
2025-06-27 17:50:59,358 - 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-27 17:50:59,875 - 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-27 17:50:59,928 - IOOppi_data - INFO : save new data to db: IOOppi_PM_t: no new data
2025-06-27 17:50:59,928 - IOOppi_data - INFO : save diff data to db: IOOppi_PM_t: no diff data
2025-06-27 17:50:59,934 - 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-27 17:50:59,999 - IOOppi_data - INFO : save new data to db: IOOppi_PM_g: no new data
2025-06-27 17:50:59,999 - 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-27 17:51:00,620 - IOOppi_data - INFO : save data to db IOOppi_sn_t data:
date value
2762 2025-06-23 261975.0
2763 2025-06-24 263612.5
2764 2025-06-25 262250.0
2765 2025-06-26 265425.0
2766 2025-06-27 269425.0
2025-06-27 17:51:00,682 - IOOppi_data - INFO : save new data to db IOOppi_sn_t: date ... updated_at
2766 2025-06-27 ... 2025-06-27 17:51:00.676190
[1 rows x 5 columns]
2025-06-27 17:51:00,701 - IOOppi_data - INFO : save diff data to db: IOOppi_sn_t: no diff data
2025-06-27 17:51:00,707 - IOOppi_data - INFO : save data to db IOOppi_sn_g data:
date value
2762 2025-06-23 261975.0
2763 2025-06-24 263612.5
2764 2025-06-25 262250.0
2765 2025-06-26 265425.0
2766 2025-06-27 269425.0
2025-06-27 17:51:00,768 - IOOppi_data - INFO : save new data to db IOOppi_sn_g: date ... updated_at
2769 2025-06-27 ... 2025-06-27 17:51:00.761856
[1 rows x 5 columns]
2025-06-27 17:51:00,788 - 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-27 17:51:01,381 - IOOppi_data - INFO : save data to db IOOppi_zn_t data:
date value
3783 2025-06-23 21922.0
3784 2025-06-24 22134.0
3785 2025-06-25 22176.0
3786 2025-06-26 22244.0
3787 2025-06-27 22568.0
2025-06-27 17:51:01,456 - IOOppi_data - INFO : save new data to db IOOppi_zn_t: date value ... created_at updated_at
3787 2025-06-27 22568.0 ... 2025-06-27 17:51:01.449142 2025-06-27 17:51:01.449532
[1 rows x 5 columns]
2025-06-27 17:51:01,476 - IOOppi_data - INFO : save diff data to db: IOOppi_zn_t: no diff data
2025-06-27 17:51:01,483 - IOOppi_data - INFO : save data to db IOOppi_zn_g data:
date value
3783 2025-06-23 21922.0
3784 2025-06-24 22134.0
3785 2025-06-25 22176.0
3786 2025-06-26 22244.0
3787 2025-06-27 22568.0
2025-06-27 17:51:01,559 - IOOppi_data - INFO : save new data to db IOOppi_zn_g: date value ... created_at updated_at
3790 2025-06-27 22568.0 ... 2025-06-27 17:51:01.551693 2025-06-27 17:51:01.552152
[1 rows x 5 columns]
2025-06-27 17:51:01,579 - 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-27 17:51:02,151 - IOOppi_data - INFO : save data to db IOOppi_wr_t data:
date value
3746 2025-06-23 3255.0
3747 2025-06-24 3255.0
3748 2025-06-25 3242.5
3749 2025-06-26 3242.5
3750 2025-06-27 3252.5
2025-06-27 17:51:02,227 - IOOppi_data - INFO : save new data to db IOOppi_wr_t: date value ... created_at updated_at
3750 2025-06-27 3252.5 ... 2025-06-27 17:51:02.218313 2025-06-27 17:51:02.218705
[1 rows x 5 columns]
2025-06-27 17:51:02,247 - IOOppi_data - INFO : save diff data to db: IOOppi_wr_t: no diff data
2025-06-27 17:51:02,254 - IOOppi_data - INFO : save data to db IOOppi_wr_g data:
date value
3746 2025-06-23 3255.0
3747 2025-06-24 3255.0
3748 2025-06-25 3242.5
3749 2025-06-26 3242.5
3750 2025-06-27 3252.5
2025-06-27 17:51:02,330 - IOOppi_data - INFO : save new data to db IOOppi_wr_g: date value ... created_at updated_at
3753 2025-06-27 3252.5 ... 2025-06-27 17:51:02.321649 2025-06-27 17:51:02.322087
[1 rows x 5 columns]
2025-06-27 17:51:02,348 - 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-27 17:51:03,272 - IOOppi_data - INFO : save data to db IOOppi_pg_t data:
date value
1543 2025-06-23 4935.0
1544 2025-06-24 5080.0
1545 2025-06-25 5055.0
1546 2025-06-26 4967.5
1547 2025-06-27 4967.5
2025-06-27 17:51:03,319 - IOOppi_data - INFO : save new data to db IOOppi_pg_t: date value ... created_at updated_at
1547 2025-06-27 4967.5 ... 2025-06-27 17:51:03.311494 2025-06-27 17:51:03.312016
[1 rows x 5 columns]
2025-06-27 17:51:03,339 - IOOppi_data - INFO : save diff data to db: IOOppi_pg_t: no diff data
2025-06-27 17:51:03,344 - IOOppi_data - INFO : save data to db IOOppi_pg_g data:
date value
1543 2025-06-23 4935.0
1544 2025-06-24 5080.0
1545 2025-06-25 5055.0
1546 2025-06-26 4967.5
1547 2025-06-27 4967.5
2025-06-27 17:51:03,392 - IOOppi_data - INFO : save new data to db IOOppi_pg_g: date value ... created_at updated_at
1550 2025-06-27 4967.5 ... 2025-06-27 17:51:03.384850 2025-06-27 17:51:03.385311
[1 rows x 5 columns]
2025-06-27 17:51:03,411 - 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-27 17:51:03,981 - IOOppi_data - INFO : save data to db IOOppi_cs_t data:
date value
2817 2025-06-23 2345.71
2818 2025-06-24 2345.71
2819 2025-06-25 2350.00
2820 2025-06-26 2352.86
2821 2025-06-27 2352.86
2025-06-27 17:51:04,041 - IOOppi_data - INFO : save new data to db IOOppi_cs_t: date value ... created_at updated_at
2821 2025-06-27 2352.86 ... 2025-06-27 17:51:04.034419 2025-06-27 17:51:04.034839
[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-27 17:51:04,083 - IOOppi_data - INFO : save diff data to db IOOppi_cs_t: date ... updated_at
2820 2025-06-26 ... 2025-06-27 17:51:04.075493
[1 rows x 6 columns]
2025-06-27 17:51:04,107 - IOOppi_data - INFO : save data to db IOOppi_cs_g data:
date value
2817 2025-06-23 2345.71
2818 2025-06-24 2345.71
2819 2025-06-25 2350.00
2820 2025-06-26 2352.86
2821 2025-06-27 2352.86
2025-06-27 17:51:04,167 - IOOppi_data - INFO : save new data to db IOOppi_cs_g: date value ... created_at updated_at
2824 2025-06-27 2352.86 ... 2025-06-27 17:51:04.160451 2025-06-27 17:51:04.160864
[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-27 17:51:04,208 - IOOppi_data - INFO : save diff data to db IOOppi_cs_g: date ... updated_at
2823 2025-06-26 ... 2025-06-27 17:51:04.201518
[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-27 17:51:04,801 - IOOppi_data - INFO : save data to db IOOppi_cs_t data:
date value
2817 2025-06-23 2345.71
2818 2025-06-24 2345.71
2819 2025-06-25 2350.00
2820 2025-06-26 2352.86
2821 2025-06-27 2940.00
2025-06-27 17:51:04,854 - 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-27 17:51:04,877 - IOOppi_data - INFO : save diff data to db IOOppi_cs_t: date ... updated_at
2821 2025-06-27 ... 2025-06-27 17:51:04.869669
[1 rows x 6 columns]
2025-06-27 17:51:04,903 - IOOppi_data - INFO : save data to db IOOppi_cs_g data:
date value
2817 2025-06-23 2345.71
2818 2025-06-24 2345.71
2819 2025-06-25 2350.00
2820 2025-06-26 2352.86
2821 2025-06-27 2940.00
2025-06-27 17:51:04,957 - 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-27 17:51:04,979 - IOOppi_data - INFO : save diff data to db IOOppi_cs_g: date ... updated_at
2824 2025-06-27 ... 2025-06-27 17:51:04.971774
[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-27 17:51:05,525 - IOOppi_data - INFO : save data to db IOOppi_RS_t data:
date value
3174 2025-06-23 9878.33
3175 2025-06-24 9731.67
3176 2025-06-25 9631.67
3177 2025-06-26 9631.67
3178 2025-06-27 9631.67
2025-06-27 17:51:05,580 - IOOppi_data - INFO : save new data to db: IOOppi_RS_t: no new data
2025-06-27 17:51:05,580 - IOOppi_data - INFO : save diff data to db: IOOppi_RS_t: no diff data
2025-06-27 17:51:05,586 - IOOppi_data - INFO : save data to db IOOppi_RS_g data:
date value
3174 2025-06-23 9878.33
3175 2025-06-24 9731.67
3176 2025-06-25 9631.67
3177 2025-06-26 9631.67
3178 2025-06-27 9631.67
2025-06-27 17:51:05,643 - IOOppi_data - INFO : save new data to db: IOOppi_RS_g: no new data
2025-06-27 17:51:05,643 - 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-27 17:51:06,283 - IOOppi_data - INFO : save data to db IOOppi_eg_t data:
date value
1858 2025-06-23 4550.00
1859 2025-06-24 4460.00
1860 2025-06-25 4423.33
1861 2025-06-26 4423.33
1862 2025-06-27 4416.67
2025-06-27 17:51:06,332 - IOOppi_data - INFO : save new data to db IOOppi_eg_t: date value ... created_at updated_at
1862 2025-06-27 4416.67 ... 2025-06-27 17:51:06.324730 2025-06-27 17:51:06.325146
[1 rows x 5 columns]
2025-06-27 17:51:06,350 - IOOppi_data - INFO : save diff data to db: IOOppi_eg_t: no diff data
2025-06-27 17:51:06,356 - IOOppi_data - INFO : save data to db IOOppi_eg_g data:
date value
1858 2025-06-23 4550.00
1859 2025-06-24 4460.00
1860 2025-06-25 4423.33
1861 2025-06-26 4423.33
1862 2025-06-27 4416.67
2025-06-27 17:51:06,404 - IOOppi_data - INFO : save new data to db IOOppi_eg_g: date value ... created_at updated_at
1865 2025-06-27 4416.67 ... 2025-06-27 17:51:06.397430 2025-06-27 17:51:06.397829
[1 rows x 5 columns]
2025-06-27 17:51:06,423 - 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-27 17:51:07,048 - IOOppi_data - INFO : save data to db IOOppi_sp_t data:
date value
1867 2025-06-23 6083.33
1868 2025-06-24 6066.67
1869 2025-06-25 6000.00
1870 2025-06-26 5983.33
1871 2025-06-27 5983.33
2025-06-27 17:51:07,096 - IOOppi_data - INFO : save new data to db IOOppi_sp_t: date value ... created_at updated_at
1871 2025-06-27 5983.33 ... 2025-06-27 17:51:07.089063 2025-06-27 17:51:07.089451
[1 rows x 5 columns]
2025-06-27 17:51:07,115 - IOOppi_data - INFO : save diff data to db: IOOppi_sp_t: no diff data
2025-06-27 17:51:07,120 - IOOppi_data - INFO : save data to db IOOppi_sp_g data:
date value
1867 2025-06-23 6083.33
1868 2025-06-24 6066.67
1869 2025-06-25 6000.00
1870 2025-06-26 5983.33
1871 2025-06-27 5983.33
2025-06-27 17:51:07,169 - IOOppi_data - INFO : save new data to db IOOppi_sp_g: date value ... created_at updated_at
1874 2025-06-27 5983.33 ... 2025-06-27 17:51:07.162248 2025-06-27 17:51:07.162626
[1 rows x 5 columns]
2025-06-27 17:51:07,187 - 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-27 17:51:07,969 - IOOppi_data - INFO : save data to db IOOppi_p_t data:
date value
3535 2025-06-23 8732.0
3536 2025-06-24 8602.0
3537 2025-06-25 8560.0
3538 2025-06-26 8560.0
3539 2025-06-27 8586.0
2025-06-27 17:51:08,039 - IOOppi_data - INFO : save new data to db IOOppi_p_t: date value ... created_at updated_at
3539 2025-06-27 8586.0 ... 2025-06-27 17:51:08.031825 2025-06-27 17:51:08.032311
[1 rows x 5 columns]
2025-06-27 17:51:08,057 - IOOppi_data - INFO : save diff data to db: IOOppi_p_t: no diff data
2025-06-27 17:51:08,063 - IOOppi_data - INFO : save data to db IOOppi_p_g data:
date value
3535 2025-06-23 8732.0
3536 2025-06-24 8602.0
3537 2025-06-25 8560.0
3538 2025-06-26 8560.0
3539 2025-06-27 8586.0
2025-06-27 17:51:08,133 - IOOppi_data - INFO : save new data to db IOOppi_p_g: date value ... created_at updated_at
3542 2025-06-27 8586.0 ... 2025-06-27 17:51:08.126255 2025-06-27 17:51:08.126666
[1 rows x 5 columns]
2025-06-27 17:51:08,151 - IOOppi_data - INFO : save diff data to db: IOOppi_p_g: no diff data