=========================================================================
2025-07-02 17:50:26 Wed 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-07-02 17:50:29,052 - IOOppi_data - INFO : save data to db IOOppi_rb_t data:
date value
3348 2025-06-28 3072.0
3349 2025-06-29 3072.0
3350 2025-06-30 3072.0
3351 2025-07-01 3069.0
3352 2025-07-02 3087.5
2025-07-02 17:50:29,123 - IOOppi_data - INFO : save new data to db IOOppi_rb_t: date value ... created_at updated_at
3352 2025-07-02 3087.5 ... 2025-07-02 17:50:29.115152 2025-07-02 17:50:29.115574
[1 rows x 5 columns]
2025-07-02 17:50:29,143 - IOOppi_data - INFO : save diff data to db: IOOppi_rb_t: no diff data
2025-07-02 17:50:29,149 - IOOppi_data - INFO : save data to db IOOppi_rb_g data:
date value
3348 2025-06-28 3072.0
3349 2025-06-29 3072.0
3350 2025-06-30 3072.0
3351 2025-07-01 3069.0
3352 2025-07-02 3087.5
2025-07-02 17:50:29,216 - IOOppi_data - INFO : save new data to db IOOppi_rb_g: date value ... created_at updated_at
3355 2025-07-02 3087.5 ... 2025-07-02 17:50:29.208747 2025-07-02 17:50:29.209167
[1 rows x 5 columns]
2025-07-02 17:50:29,234 - 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-07-02 17:50:29,792 - IOOppi_data - INFO : save data to db IOOppi_MA_t data:
date value
3569 2025-06-28 2785.83
3570 2025-06-29 2785.83
3571 2025-06-30 2805.00
3572 2025-07-01 2530.00
3573 2025-07-02 2478.33
2025-07-02 17:50:29,864 - IOOppi_data - INFO : save new data to db IOOppi_MA_t: date value ... created_at updated_at
3573 2025-07-02 2478.33 ... 2025-07-02 17:50:29.856568 2025-07-02 17:50:29.857023
[1 rows x 5 columns]
2025-07-02 17:50:29,883 - IOOppi_data - INFO : save diff data to db: IOOppi_MA_t: no diff data
2025-07-02 17:50:29,889 - IOOppi_data - INFO : save data to db IOOppi_MA_g data:
date value
3569 2025-06-28 2785.83
3570 2025-06-29 2785.83
3571 2025-06-30 2805.00
3572 2025-07-01 2530.00
3573 2025-07-02 2478.33
2025-07-02 17:50:29,963 - IOOppi_data - INFO : save new data to db IOOppi_MA_g: date value ... created_at updated_at
3577 2025-07-02 2478.33 ... 2025-07-02 17:50:29.955613 2025-07-02 17:50:29.956045
[1 rows x 5 columns]
2025-07-02 17:50:29,982 - 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-07-02 17:50:30,535 - IOOppi_data - INFO : save data to db IOOppi_PTA_t data:
date value
909 2025-06-28 5084.75
910 2025-06-29 5084.75
911 2025-06-30 5104.75
912 2025-07-01 5081.66
913 2025-07-02 5031.25
2025-07-02 17:50:30,572 - IOOppi_data - INFO : save new data to db IOOppi_PTA_t: date value ... created_at updated_at
913 2025-07-02 5031.25 ... 2025-07-02 17:50:30.564954 2025-07-02 17:50:30.565365
[1 rows x 5 columns]
2025-07-02 17:50:30,591 - IOOppi_data - INFO : save diff data to db: IOOppi_PTA_t: no diff data
2025-07-02 17:50:30,596 - IOOppi_data - INFO : save data to db IOOppi_PTA_g data:
date value
909 2025-06-28 5084.75
910 2025-06-29 5084.75
911 2025-06-30 5104.75
912 2025-07-01 5081.66
913 2025-07-02 5031.25
2025-07-02 17:50:30,632 - IOOppi_data - INFO : save new data to db IOOppi_PTA_g: date value ... created_at updated_at
913 2025-07-02 5031.25 ... 2025-07-02 17:50:30.625630 2025-07-02 17:50:30.626053
[1 rows x 5 columns]
2025-07-02 17:50:30,652 - 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-07-02 17:50:31,238 - IOOppi_data - INFO : save data to db IOOppi_ru_t data:
date value
3788 2025-06-28 13878.33
3789 2025-06-29 13878.33
3790 2025-06-30 13858.33
3791 2025-07-01 13928.33
3792 2025-07-02 13983.33
2025-07-02 17:50:31,309 - IOOppi_data - INFO : save new data to db IOOppi_ru_t: date ... updated_at
3792 2025-07-02 ... 2025-07-02 17:50:31.303312
[1 rows x 5 columns]
2025-07-02 17:50:31,329 - IOOppi_data - INFO : save diff data to db: IOOppi_ru_t: no diff data
2025-07-02 17:50:31,335 - IOOppi_data - INFO : save data to db IOOppi_ru_g data:
date value
3788 2025-06-28 13878.33
3789 2025-06-29 13878.33
3790 2025-06-30 13858.33
3791 2025-07-01 13928.33
3792 2025-07-02 13983.33
2025-07-02 17:50:31,407 - IOOppi_data - INFO : save new data to db IOOppi_ru_g: date ... updated_at
3795 2025-07-02 ... 2025-07-02 17:50:31.401227
[1 rows x 5 columns]
2025-07-02 17:50:31,427 - 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-07-02 17:50:31,975 - IOOppi_data - INFO : save data to db IOOppi_i_t data:
date value
3120 2025-06-28 725.44
3121 2025-06-29 725.44
3122 2025-06-30 726.56
3123 2025-07-01 723.44
3124 2025-07-02 720.22
2025-07-02 17:50:32,038 - IOOppi_data - INFO : save new data to db IOOppi_i_t: date value ... created_at updated_at
3124 2025-07-02 720.22 ... 2025-07-02 17:50:32.031210 2025-07-02 17:50:32.031597
[1 rows x 5 columns]
2025-07-02 17:50:32,058 - IOOppi_data - INFO : save diff data to db: IOOppi_i_t: no diff data
2025-07-02 17:50:32,064 - IOOppi_data - INFO : save data to db IOOppi_i_g data:
date value
3120 2025-06-28 725.44
3121 2025-06-29 725.44
3122 2025-06-30 726.56
3123 2025-07-01 723.44
3124 2025-07-02 720.22
2025-07-02 17:50:32,128 - IOOppi_data - INFO : save new data to db IOOppi_i_g: date value ... created_at updated_at
3127 2025-07-02 720.22 ... 2025-07-02 17:50:32.121286 2025-07-02 17:50:32.121674
[1 rows x 5 columns]
2025-07-02 17:50:32,147 - 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-07-02 17:50:32,669 - IOOppi_data - INFO : save data to db IOOppi_FG_t data:
date value
3323 2025-06-28 1105.6
3324 2025-06-29 1105.6
3325 2025-06-30 1105.6
3326 2025-07-01 1108.0
3327 2025-07-02 1108.0
2025-07-02 17:50:32,737 - IOOppi_data - INFO : save new data to db IOOppi_FG_t: date value ... created_at updated_at
3327 2025-07-02 1108.0 ... 2025-07-02 17:50:32.730537 2025-07-02 17:50:32.730949
[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-07-02 17:50:34,709 - IOOppi_data - INFO : save diff data to db IOOppi_FG_t: date ... updated_at
12 2012-12-19 ... 2025-07-02 17:50:34.701767
21 2013-01-04 ... 2025-07-02 17:50:34.701767
54 2013-02-27 ... 2025-07-02 17:50:34.701767
60 2013-03-07 ... 2025-07-02 17:50:34.701767
61 2013-03-08 ... 2025-07-02 17:50:34.701767
[5 rows x 6 columns]
2025-07-02 17:50:34,867 - IOOppi_data - INFO : save data to db IOOppi_FG_g data:
date value
3323 2025-06-28 1105.6
3324 2025-06-29 1105.6
3325 2025-06-30 1105.6
3326 2025-07-01 1108.0
3327 2025-07-02 1108.0
2025-07-02 17:50:34,933 - IOOppi_data - INFO : save new data to db IOOppi_FG_g: date value ... created_at updated_at
3331 2025-07-02 1108.0 ... 2025-07-02 17:50:34.926534 2025-07-02 17:50:34.926947
[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-07-02 17:50:36,891 - IOOppi_data - INFO : save diff data to db IOOppi_FG_g: date ... updated_at
12 2012-12-19 ... 2025-07-02 17:50:36.883507
21 2013-01-04 ... 2025-07-02 17:50:36.883507
54 2013-02-27 ... 2025-07-02 17:50:36.883507
60 2013-03-07 ... 2025-07-02 17:50:36.883507
61 2013-03-08 ... 2025-07-02 17:50:36.883507
[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-07-02 17:50:37,599 - IOOppi_data - INFO : save data to db IOOppi_eb_t data:
date value
1668 2025-06-28 8084.0
1669 2025-06-29 8084.0
1670 2025-06-30 8050.0
1671 2025-07-01 8036.0
1672 2025-07-02 8036.0
2025-07-02 17:50:37,645 - IOOppi_data - INFO : save new data to db IOOppi_eb_t: date value ... created_at updated_at
1672 2025-07-02 8036.0 ... 2025-07-02 17:50:37.638066 2025-07-02 17:50:37.638446
[1 rows x 5 columns]
2025-07-02 17:50:37,665 - IOOppi_data - INFO : save diff data to db: IOOppi_eb_t: no diff data
2025-07-02 17:50:37,670 - IOOppi_data - INFO : save data to db IOOppi_eb_g data:
date value
1668 2025-06-28 8084.0
1669 2025-06-29 8084.0
1670 2025-06-30 8050.0
1671 2025-07-01 8036.0
1672 2025-07-02 8036.0
2025-07-02 17:50:37,716 - IOOppi_data - INFO : save new data to db IOOppi_eb_g: date value ... created_at updated_at
1675 2025-07-02 8036.0 ... 2025-07-02 17:50:37.709506 2025-07-02 17:50:37.709927
[1 rows x 5 columns]
2025-07-02 17:50:37,735 - 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-07-02 17:50:38,415 - IOOppi_data - INFO : save data to db IOOppi_SR_t data:
date value
3779 2025-06-28 6056.67
3780 2025-06-29 6056.67
3781 2025-06-30 6053.33
3782 2025-07-01 6060.00
3783 2025-07-02 6050.00
2025-07-02 17:50:38,488 - IOOppi_data - INFO : save new data to db IOOppi_SR_t: date value ... created_at updated_at
3783 2025-07-02 6050.0 ... 2025-07-02 17:50:38.481075 2025-07-02 17:50:38.481472
[1 rows x 5 columns]
2025-07-02 17:50:38,507 - IOOppi_data - INFO : save diff data to db: IOOppi_SR_t: no diff data
2025-07-02 17:50:38,513 - IOOppi_data - INFO : save data to db IOOppi_SR_g data:
date value
3779 2025-06-28 6056.67
3780 2025-06-29 6056.67
3781 2025-06-30 6053.33
3782 2025-07-01 6060.00
3783 2025-07-02 6050.00
2025-07-02 17:50:38,587 - IOOppi_data - INFO : save new data to db IOOppi_SR_g: date value ... created_at updated_at
3787 2025-07-02 6050.0 ... 2025-07-02 17:50:38.580241 2025-07-02 17:50:38.580627
[1 rows x 5 columns]
2025-07-02 17:50:38,607 - 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-07-02 17:50:39,239 - IOOppi_data - INFO : save data to db IOOppi_ss_t data:
date value
1669 2025-06-28 12762.5
1670 2025-06-29 12762.5
1671 2025-06-30 12775.0
1672 2025-07-01 12775.0
1673 2025-07-02 12825.0
2025-07-02 17:50:39,284 - IOOppi_data - INFO : save new data to db IOOppi_ss_t: date value ... created_at updated_at
1673 2025-07-02 12825.0 ... 2025-07-02 17:50:39.277618 2025-07-02 17:50:39.278061
[1 rows x 5 columns]
2025-07-02 17:50:39,303 - IOOppi_data - INFO : save diff data to db: IOOppi_ss_t: no diff data
2025-07-02 17:50:39,309 - IOOppi_data - INFO : save data to db IOOppi_ss_g data:
date value
1669 2025-06-28 12762.5
1670 2025-06-29 12762.5
1671 2025-06-30 12775.0
1672 2025-07-01 12775.0
1673 2025-07-02 12825.0
2025-07-02 17:50:39,356 - IOOppi_data - INFO : save new data to db IOOppi_ss_g: date value ... created_at updated_at
1676 2025-07-02 12825.0 ... 2025-07-02 17:50:39.349427 2025-07-02 17:50:39.349839
[1 rows x 5 columns]
2025-07-02 17:50:39,376 - 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-07-02 17:50:40,029 - IOOppi_data - INFO : save data to db IOOppi_RS_t data:
date value
3179 2025-06-28 9631.67
3180 2025-06-29 9631.67
3181 2025-06-30 9581.67
3182 2025-07-01 9625.00
3183 2025-07-02 9763.33
2025-07-02 17:50:40,102 - IOOppi_data - INFO : save new data to db IOOppi_RS_t: date value ... created_at updated_at
3183 2025-07-02 9763.33 ... 2025-07-02 17:50:40.094805 2025-07-02 17:50:40.095212
[1 rows x 5 columns]
2025-07-02 17:50:40,121 - IOOppi_data - INFO : save diff data to db: IOOppi_RS_t: no diff data
2025-07-02 17:50:40,126 - IOOppi_data - INFO : save data to db IOOppi_RS_g data:
date value
3179 2025-06-28 9631.67
3180 2025-06-29 9631.67
3181 2025-06-30 9581.67
3182 2025-07-01 9625.00
3183 2025-07-02 9763.33
2025-07-02 17:50:40,191 - IOOppi_data - INFO : save new data to db IOOppi_RS_g: date value ... created_at updated_at
3187 2025-07-02 9763.33 ... 2025-07-02 17:50:40.184351 2025-07-02 17:50:40.184768
[1 rows x 5 columns]
2025-07-02 17:50:40,210 - 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-07-02 17:50:40,820 - IOOppi_data - INFO : save data to db IOOppi_RM_t data:
date value
3302 2025-06-28 2475.00
3303 2025-06-29 2475.00
3304 2025-06-30 2500.00
3305 2025-07-01 2516.67
3306 2025-07-02 2506.67
2025-07-02 17:50:40,886 - IOOppi_data - INFO : save new data to db IOOppi_RM_t: date value ... created_at updated_at
3306 2025-07-02 2506.67 ... 2025-07-02 17:50:40.879483 2025-07-02 17:50:40.879895
[1 rows x 5 columns]
2025-07-02 17:50:40,905 - IOOppi_data - INFO : save diff data to db: IOOppi_RM_t: no diff data
2025-07-02 17:50:40,911 - IOOppi_data - INFO : save data to db IOOppi_RM_g data:
date value
3302 2025-06-28 2475.00
3303 2025-06-29 2475.00
3304 2025-06-30 2500.00
3305 2025-07-01 2516.67
3306 2025-07-02 2506.67
2025-07-02 17:50:40,978 - IOOppi_data - INFO : save new data to db IOOppi_RM_g: date value ... created_at updated_at
3310 2025-07-02 2506.67 ... 2025-07-02 17:50:40.970860 2025-07-02 17:50:40.971253
[1 rows x 5 columns]
2025-07-02 17:50:40,997 - 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-07-02 17:50:41,524 - IOOppi_data - INFO : save data to db IOOppi_SA_t data:
date value
1506 2025-06-28 1337.5
1507 2025-06-29 1337.5
1508 2025-06-30 1325.0
1509 2025-07-01 1325.0
1510 2025-07-02 1252.5
2025-07-02 17:50:41,568 - IOOppi_data - INFO : save new data to db IOOppi_SA_t: date value ... created_at updated_at
1510 2025-07-02 1252.5 ... 2025-07-02 17:50:41.561486 2025-07-02 17:50:41.561916
[1 rows x 5 columns]
2025-07-02 17:50:41,588 - IOOppi_data - INFO : save diff data to db: IOOppi_SA_t: no diff data
2025-07-02 17:50:41,593 - IOOppi_data - INFO : save data to db IOOppi_SA_g data:
date value
1506 2025-06-28 1337.5
1507 2025-06-29 1337.5
1508 2025-06-30 1325.0
1509 2025-07-01 1325.0
1510 2025-07-02 1252.5
2025-07-02 17:50:41,637 - IOOppi_data - INFO : save new data to db IOOppi_SA_g: date value ... created_at updated_at
1514 2025-07-02 1252.5 ... 2025-07-02 17:50:41.629988 2025-07-02 17:50:41.630376
[1 rows x 5 columns]
2025-07-02 17:50:41,655 - 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-07-02 17:50:42,198 - IOOppi_data - INFO : save data to db IOOppi_PF_t data:
date value
1419 2025-06-28 6736.04
1420 2025-06-29 6736.04
1421 2025-06-30 6727.92
1422 2025-07-01 6735.00
1423 2025-07-02 6744.17
2025-07-02 17:50:42,241 - IOOppi_data - INFO : save new data to db IOOppi_PF_t: date value ... created_at updated_at
1423 2025-07-02 6744.17 ... 2025-07-02 17:50:42.234413 2025-07-02 17:50:42.234824
[1 rows x 5 columns]
2025-07-02 17:50:42,260 - IOOppi_data - INFO : save diff data to db: IOOppi_PF_t: no diff data
2025-07-02 17:50:42,266 - IOOppi_data - INFO : save data to db IOOppi_PF_g data:
date value
1419 2025-06-28 6736.04
1420 2025-06-29 6736.04
1421 2025-06-30 6727.92
1422 2025-07-01 6735.00
1423 2025-07-02 6744.17
2025-07-02 17:50:42,310 - IOOppi_data - INFO : save new data to db IOOppi_PF_g: date value ... created_at updated_at
1427 2025-07-02 6744.17 ... 2025-07-02 17:50:42.302984 2025-07-02 17:50:42.303395
[1 rows x 5 columns]
2025-07-02 17:50:42,330 - 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-07-02 17:50:42,866 - IOOppi_data - INFO : save data to db IOOppi_m_t data:
date value
3792 2025-06-28 2906.0
3793 2025-06-29 2906.0
3794 2025-06-30 2906.0
3795 2025-07-01 2930.0
3796 2025-07-02 2922.0
2025-07-02 17:50:42,939 - IOOppi_data - INFO : save new data to db IOOppi_m_t: date value ... created_at updated_at
3796 2025-07-02 2922.0 ... 2025-07-02 17:50:42.932052 2025-07-02 17:50:42.932437
[1 rows x 5 columns]
2025-07-02 17:50:42,957 - IOOppi_data - INFO : save diff data to db: IOOppi_m_t: no diff data
2025-07-02 17:50:42,964 - IOOppi_data - INFO : save data to db IOOppi_m_g data:
date value
3792 2025-06-28 2906.0
3793 2025-06-29 2906.0
3794 2025-06-30 2906.0
3795 2025-07-01 2930.0
3796 2025-07-02 2922.0
2025-07-02 17:50:43,037 - IOOppi_data - INFO : save new data to db IOOppi_m_g: date value ... created_at updated_at
3799 2025-07-02 2922.0 ... 2025-07-02 17:50:43.029580 2025-07-02 17:50:43.029993
[1 rows x 5 columns]
2025-07-02 17:50:43,055 - 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-07-02 17:50:43,893 - IOOppi_data - INFO : save data to db IOOppi_y_t data:
date value
3562 2025-06-28 8254.0
3563 2025-06-29 8254.0
3564 2025-06-30 8234.0
3565 2025-07-01 8224.0
3566 2025-07-02 8284.0
2025-07-02 17:50:43,963 - IOOppi_data - INFO : save new data to db IOOppi_y_t: date value ... created_at updated_at
3566 2025-07-02 8284.0 ... 2025-07-02 17:50:43.956281 2025-07-02 17:50:43.956669
[1 rows x 5 columns]
2025-07-02 17:50:43,983 - IOOppi_data - INFO : save diff data to db: IOOppi_y_t: no diff data
2025-07-02 17:50:43,989 - IOOppi_data - INFO : save data to db IOOppi_y_g data:
date value
3562 2025-06-28 8254.0
3563 2025-06-29 8254.0
3564 2025-06-30 8234.0
3565 2025-07-01 8224.0
3566 2025-07-02 8284.0
2025-07-02 17:50:44,062 - IOOppi_data - INFO : save new data to db IOOppi_y_g: date value ... created_at updated_at
3569 2025-07-02 8284.0 ... 2025-07-02 17:50:44.054820 2025-07-02 17:50:44.055239
[1 rows x 5 columns]
2025-07-02 17:50:44,081 - 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-07-02 17:50:44,739 - IOOppi_data - INFO : save data to db IOOppi_a_t data:
date value
3528 2025-06-28 4295.0
3529 2025-06-29 4295.0
3530 2025-06-30 4295.0
3531 2025-07-01 4295.0
3532 2025-07-02 4295.0
2025-07-02 17:50:44,808 - IOOppi_data - INFO : save new data to db IOOppi_a_t: date value ... created_at updated_at
3532 2025-07-02 4295.0 ... 2025-07-02 17:50:44.800909 2025-07-02 17:50:44.801306
[1 rows x 5 columns]
2025-07-02 17:50:44,827 - IOOppi_data - INFO : save diff data to db: IOOppi_a_t: no diff data
2025-07-02 17:50:44,833 - IOOppi_data - INFO : save data to db IOOppi_a_g data:
date value
3528 2025-06-28 4295.0
3529 2025-06-29 4295.0
3530 2025-06-30 4295.0
3531 2025-07-01 4295.0
3532 2025-07-02 4295.0
2025-07-02 17:50:44,904 - IOOppi_data - INFO : save new data to db IOOppi_a_g: date value ... created_at updated_at
3535 2025-07-02 4295.0 ... 2025-07-02 17:50:44.897040 2025-07-02 17:50:44.897428
[1 rows x 5 columns]
2025-07-02 17:50:44,924 - 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-07-02 17:50:45,518 - IOOppi_data - INFO : save data to db IOOppi_SF_t data:
date value
2905 2025-06-28 5158.57
2906 2025-06-29 5158.57
2907 2025-06-30 5158.57
2908 2025-07-01 5158.57
2909 2025-07-02 5122.86
2025-07-02 17:50:45,579 - IOOppi_data - INFO : save new data to db IOOppi_SF_t: date value ... created_at updated_at
2909 2025-07-02 5122.86 ... 2025-07-02 17:50:45.572456 2025-07-02 17:50:45.572872
[1 rows x 5 columns]
2025-07-02 17:50:45,598 - IOOppi_data - INFO : save diff data to db: IOOppi_SF_t: no diff data
2025-07-02 17:50:45,604 - IOOppi_data - INFO : save data to db IOOppi_SF_g data:
date value
2905 2025-06-28 5158.57
2906 2025-06-29 5158.57
2907 2025-06-30 5158.57
2908 2025-07-01 5158.57
2909 2025-07-02 5122.86
2025-07-02 17:50:45,665 - IOOppi_data - INFO : save new data to db IOOppi_SF_g: date value ... created_at updated_at
2913 2025-07-02 5122.86 ... 2025-07-02 17:50:45.658241 2025-07-02 17:50:45.658621
[1 rows x 5 columns]
2025-07-02 17:50:45,684 - 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-07-02 17:50:46,277 - IOOppi_data - INFO : save data to db IOOppi_jd_t data:
date value
3105 2025-06-28 2890.0
3106 2025-06-29 2890.0
3107 2025-06-30 2810.0
3108 2025-07-01 2790.0
3109 2025-07-02 2790.0
2025-07-02 17:50:46,343 - IOOppi_data - INFO : save new data to db IOOppi_jd_t: date value ... created_at updated_at
3109 2025-07-02 2790.0 ... 2025-07-02 17:50:46.335574 2025-07-02 17:50:46.336022
[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-07-02 17:50:46,493 - IOOppi_data - INFO : save diff data to db IOOppi_jd_t: date ... updated_at
39 2014-01-03 ... 2025-07-02 17:50:46.485650
458 2015-09-21 ... 2025-07-02 17:50:46.485650
549 2016-02-03 ... 2025-07-02 17:50:46.485650
693 2016-09-05 ... 2025-07-02 17:50:46.485650
696 2016-09-08 ... 2025-07-02 17:50:46.485650
[5 rows x 6 columns]
2025-07-02 17:50:46,524 - IOOppi_data - INFO : save data to db IOOppi_jd_g data:
date value
3105 2025-06-28 2890.0
3106 2025-06-29 2890.0
3107 2025-06-30 2810.0
3108 2025-07-01 2790.0
3109 2025-07-02 2790.0
2025-07-02 17:50:46,588 - IOOppi_data - INFO : save new data to db IOOppi_jd_g: date value ... created_at updated_at
3112 2025-07-02 2790.0 ... 2025-07-02 17:50:46.581403 2025-07-02 17:50:46.581816
[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-07-02 17:50:46,743 - IOOppi_data - INFO : save diff data to db IOOppi_jd_g: date ... updated_at
39 2014-01-03 ... 2025-07-02 17:50:46.735352
458 2015-09-21 ... 2025-07-02 17:50:46.735352
549 2016-02-03 ... 2025-07-02 17:50:46.735352
693 2016-09-05 ... 2025-07-02 17:50:46.735352
696 2016-09-08 ... 2025-07-02 17:50:46.735352
[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-07-02 17:50:47,371 - IOOppi_data - INFO : save data to db IOOppi_SI_t data:
date value
909 2025-06-28 8640.0
910 2025-06-29 8640.0
911 2025-06-30 8730.0
912 2025-07-01 8730.0
913 2025-07-02 8850.0
2025-07-02 17:50:47,407 - IOOppi_data - INFO : save new data to db IOOppi_SI_t: date value ... created_at updated_at
913 2025-07-02 8850.0 ... 2025-07-02 17:50:47.400700 2025-07-02 17:50:47.401113
[1 rows x 5 columns]
2025-07-02 17:50:47,427 - IOOppi_data - INFO : save diff data to db: IOOppi_SI_t: no diff data
2025-07-02 17:50:47,432 - IOOppi_data - INFO : save data to db IOOppi_SI_g data:
date value
909 2025-06-28 8640.0
910 2025-06-29 8640.0
911 2025-06-30 8730.0
912 2025-07-01 8730.0
913 2025-07-02 8850.0
2025-07-02 17:50:47,468 - IOOppi_data - INFO : save new data to db IOOppi_SI_g: date value ... created_at updated_at
913 2025-07-02 8850.0 ... 2025-07-02 17:50:47.461160 2025-07-02 17:50:47.461535
[1 rows x 5 columns]
2025-07-02 17:50:47,491 - 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-07-02 17:50:48,126 - IOOppi_data - INFO : save data to db IOOppi_l_t data:
date value
3788 2025-06-28 7511.67
3789 2025-06-29 7511.67
3790 2025-06-30 7503.33
3791 2025-07-01 7486.67
3792 2025-07-02 7466.67
2025-07-02 17:50:48,202 - IOOppi_data - INFO : save new data to db IOOppi_l_t: date value ... created_at updated_at
3792 2025-07-02 7466.67 ... 2025-07-02 17:50:48.194143 2025-07-02 17:50:48.194738
[1 rows x 5 columns]
2025-07-02 17:50:48,221 - IOOppi_data - INFO : save diff data to db: IOOppi_l_t: no diff data
2025-07-02 17:50:48,228 - IOOppi_data - INFO : save data to db IOOppi_l_g data:
date value
3788 2025-06-28 7511.67
3789 2025-06-29 7511.67
3790 2025-06-30 7503.33
3791 2025-07-01 7486.67
3792 2025-07-02 7466.67
2025-07-02 17:50:48,302 - IOOppi_data - INFO : save new data to db IOOppi_l_g: date value ... created_at updated_at
3795 2025-07-02 7466.67 ... 2025-07-02 17:50:48.294566 2025-07-02 17:50:48.295055
[1 rows x 5 columns]
2025-07-02 17:50:48,321 - 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-07-02 17:50:49,227 - IOOppi_data - INFO : save data to db IOOppi_bu_t data:
date value
3126 2025-06-28 3700.00
3127 2025-06-29 3700.00
3128 2025-06-30 3673.33
3129 2025-07-01 3670.00
3130 2025-07-02 3670.00
2025-07-02 17:50:49,294 - IOOppi_data - INFO : save new data to db IOOppi_bu_t: date value ... created_at updated_at
3131 2025-07-02 3670.0 ... 2025-07-02 17:50:49.287420 2025-07-02 17:50:49.287845
[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-07-02 17:50:49,331 - IOOppi_data - INFO : save diff data to db IOOppi_bu_t: date ... updated_at
2560 2023-12-09 ... 2025-07-02 17:50:49.323490
[1 rows x 6 columns]
2025-07-02 17:50:49,355 - IOOppi_data - INFO : save data to db IOOppi_bu_g data:
date value
3126 2025-06-28 3700.00
3127 2025-06-29 3700.00
3128 2025-06-30 3673.33
3129 2025-07-01 3670.00
3130 2025-07-02 3670.00
2025-07-02 17:50:49,424 - IOOppi_data - INFO : save new data to db IOOppi_bu_g: date value ... created_at updated_at
3133 2025-07-02 3670.0 ... 2025-07-02 17:50:49.417073 2025-07-02 17:50:49.417465
[1 rows x 5 columns]
2025-07-02 17:50:49,443 - 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-07-02 17:50:50,091 - IOOppi_data - INFO : save data to db IOOppi_al_t data:
date value
3791 2025-06-28 20903.33
3792 2025-06-29 20903.33
3793 2025-06-30 20786.67
3794 2025-07-01 20786.67
3795 2025-07-02 20786.67
2025-07-02 17:50:50,162 - IOOppi_data - INFO : save new data to db IOOppi_al_t: date ... updated_at
3795 2025-07-02 ... 2025-07-02 17:50:50.156478
[1 rows x 5 columns]
2025-07-02 17:50:50,182 - IOOppi_data - INFO : save diff data to db: IOOppi_al_t: no diff data
2025-07-02 17:50:50,188 - IOOppi_data - INFO : save data to db IOOppi_al_g data:
date value
3791 2025-06-28 20903.33
3792 2025-06-29 20903.33
3793 2025-06-30 20786.67
3794 2025-07-01 20786.67
3795 2025-07-02 20786.67
2025-07-02 17:50:50,260 - IOOppi_data - INFO : save new data to db IOOppi_al_g: date ... updated_at
3798 2025-07-02 ... 2025-07-02 17:50:50.254112
[1 rows x 5 columns]
2025-07-02 17:50:50,278 - 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-07-02 17:50:50,920 - IOOppi_data - INFO : save data to db IOOppi_SM_t data:
date value
2905 2025-06-28 5572.0
2906 2025-06-29 5572.0
2907 2025-06-30 5564.0
2908 2025-07-01 5536.0
2909 2025-07-02 5544.0
2025-07-02 17:50:50,981 - IOOppi_data - INFO : save new data to db IOOppi_SM_t: date value ... created_at updated_at
2909 2025-07-02 5544.0 ... 2025-07-02 17:50:50.974344 2025-07-02 17:50:50.974728
[1 rows x 5 columns]
2025-07-02 17:50:51,000 - IOOppi_data - INFO : save diff data to db: IOOppi_SM_t: no diff data
2025-07-02 17:50:51,006 - IOOppi_data - INFO : save data to db IOOppi_SM_g data:
date value
2905 2025-06-28 5572.0
2906 2025-06-29 5572.0
2907 2025-06-30 5564.0
2908 2025-07-01 5536.0
2909 2025-07-02 5544.0
2025-07-02 17:50:51,068 - IOOppi_data - INFO : save new data to db IOOppi_SM_g: date value ... created_at updated_at
2913 2025-07-02 5544.0 ... 2025-07-02 17:50:51.060883 2025-07-02 17:50:51.061281
[1 rows x 5 columns]
2025-07-02 17:50:51,087 - 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-07-02 17:50:51,639 - IOOppi_data - INFO : save data to db IOOppi_CY_t data:
date value
2180 2025-06-28 23200.0
2181 2025-06-29 23200.0
2182 2025-06-30 23200.0
2183 2025-07-01 23200.0
2184 2025-07-02 23200.0
2025-07-02 17:50:51,690 - IOOppi_data - INFO : save new data to db IOOppi_CY_t: date value ... created_at updated_at
2184 2025-07-02 23200.0 ... 2025-07-02 17:50:51.683468 2025-07-02 17:50:51.683875
[1 rows x 5 columns]
2025-07-02 17:50:51,710 - IOOppi_data - INFO : save diff data to db: IOOppi_CY_t: no diff data
2025-07-02 17:50:51,716 - IOOppi_data - INFO : save data to db IOOppi_CY_g data:
date value
2180 2025-06-28 23200.0
2181 2025-06-29 23200.0
2182 2025-06-30 23200.0
2183 2025-07-01 23200.0
2184 2025-07-02 23200.0
2025-07-02 17:50:51,769 - IOOppi_data - INFO : save new data to db IOOppi_CY_g: date value ... created_at updated_at
2188 2025-07-02 23200.0 ... 2025-07-02 17:50:51.761416 2025-07-02 17:50:51.761821
[1 rows x 5 columns]
2025-07-02 17:50:51,788 - 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-07-02 17:50:52,343 - IOOppi_data - INFO : save data to db IOOppi_UR_t data:
date value
1695 2025-06-28 1827.0
1696 2025-06-29 1827.0
1697 2025-06-30 1823.0
1698 2025-07-01 1829.0
1699 2025-07-02 1825.0
2025-07-02 17:50:52,390 - IOOppi_data - INFO : save new data to db IOOppi_UR_t: date value ... created_at updated_at
1699 2025-07-02 1825.0 ... 2025-07-02 17:50:52.383023 2025-07-02 17:50:52.383411
[1 rows x 5 columns]
2025-07-02 17:50:52,409 - IOOppi_data - INFO : save diff data to db: IOOppi_UR_t: no diff data
2025-07-02 17:50:52,415 - IOOppi_data - INFO : save data to db IOOppi_UR_g data:
date value
1695 2025-06-28 1827.0
1696 2025-06-29 1827.0
1697 2025-06-30 1823.0
1698 2025-07-01 1829.0
1699 2025-07-02 1825.0
2025-07-02 17:50:52,463 - IOOppi_data - INFO : save new data to db IOOppi_UR_g: date value ... created_at updated_at
1703 2025-07-02 1825.0 ... 2025-07-02 17:50:52.455741 2025-07-02 17:50:52.456161
[1 rows x 5 columns]
2025-07-02 17:50:52,482 - 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-07-02 17:50:53,092 - IOOppi_data - INFO : save data to db IOOppi_ni_t data:
date value
2767 2025-06-28 122433.33
2768 2025-06-29 122433.33
2769 2025-06-30 122400.00
2770 2025-07-01 121700.00
2771 2025-07-02 122383.33
2025-07-02 17:50:53,151 - IOOppi_data - INFO : save new data to db IOOppi_ni_t: date ... updated_at
2771 2025-07-02 ... 2025-07-02 17:50:53.145258
[1 rows x 5 columns]
2025-07-02 17:50:53,170 - IOOppi_data - INFO : save diff data to db: IOOppi_ni_t: no diff data
2025-07-02 17:50:53,176 - IOOppi_data - INFO : save data to db IOOppi_ni_g data:
date value
2767 2025-06-28 122433.33
2768 2025-06-29 122433.33
2769 2025-06-30 122400.00
2770 2025-07-01 121700.00
2771 2025-07-02 122383.33
2025-07-02 17:50:53,237 - IOOppi_data - INFO : save new data to db IOOppi_ni_g: date ... updated_at
2774 2025-07-02 ... 2025-07-02 17:50:53.230993
[1 rows x 5 columns]
2025-07-02 17:50:53,256 - 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-07-02 17:50:54,055 - IOOppi_data - INFO : save data to db IOOppi_v_t data:
date value
3792 2025-06-28 4673.0
3793 2025-06-29 4673.0
3794 2025-06-30 4658.0
3795 2025-07-01 4597.0
3796 2025-07-02 4654.0
2025-07-02 17:50:54,212 - IOOppi_data - INFO : save new data to db IOOppi_v_t: date value ... created_at updated_at
3796 2025-07-02 4654.0 ... 2025-07-02 17:50:54.204911 2025-07-02 17:50:54.205360
[1 rows x 5 columns]
2025-07-02 17:50:54,232 - IOOppi_data - INFO : save diff data to db: IOOppi_v_t: no diff data
2025-07-02 17:50:54,239 - IOOppi_data - INFO : save data to db IOOppi_v_g data:
date value
3792 2025-06-28 4673.0
3793 2025-06-29 4673.0
3794 2025-06-30 4658.0
3795 2025-07-01 4597.0
3796 2025-07-02 4654.0
2025-07-02 17:50:54,312 - IOOppi_data - INFO : save new data to db IOOppi_v_g: date value ... created_at updated_at
3799 2025-07-02 4654.0 ... 2025-07-02 17:50:54.305486 2025-07-02 17:50:54.305918
[1 rows x 5 columns]
2025-07-02 17:50:54,331 - 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-07-02 17:50:54,884 - IOOppi_data - INFO : save data to db IOOppi_pp_t data:
date value
3031 2025-06-28 7483.33
3032 2025-06-29 7483.33
3033 2025-06-30 7466.67
3034 2025-07-01 7458.33
3035 2025-07-02 7325.00
2025-07-02 17:50:54,949 - IOOppi_data - INFO : save new data to db IOOppi_pp_t: date value ... created_at updated_at
3035 2025-07-02 7325.0 ... 2025-07-02 17:50:54.941844 2025-07-02 17:50:54.942284
[1 rows x 5 columns]
2025-07-02 17:50:54,968 - IOOppi_data - INFO : save diff data to db: IOOppi_pp_t: no diff data
2025-07-02 17:50:54,974 - IOOppi_data - INFO : save data to db IOOppi_pp_g data:
date value
3031 2025-06-28 7483.33
3032 2025-06-29 7483.33
3033 2025-06-30 7466.67
3034 2025-07-01 7458.33
3035 2025-07-02 7325.00
2025-07-02 17:50:55,040 - IOOppi_data - INFO : save new data to db IOOppi_pp_g: date value ... created_at updated_at
3038 2025-07-02 7325.0 ... 2025-07-02 17:50:55.032957 2025-07-02 17:50:55.033419
[1 rows x 5 columns]
2025-07-02 17:50:55,060 - 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-07-02 17:50:55,751 - IOOppi_data - INFO : save data to db IOOppi_CF_t data:
date value
3793 2025-06-28 15105.67
3794 2025-06-29 15105.67
3795 2025-06-30 15159.83
3796 2025-07-01 15210.00
3797 2025-07-02 15160.33
2025-07-02 17:50:55,822 - IOOppi_data - INFO : save new data to db IOOppi_CF_t: date ... updated_at
3797 2025-07-02 ... 2025-07-02 17:50:55.816076
[1 rows x 5 columns]
2025-07-02 17:50:55,841 - IOOppi_data - INFO : save diff data to db: IOOppi_CF_t: no diff data
2025-07-02 17:50:55,847 - IOOppi_data - INFO : save data to db IOOppi_CF_g data:
date value
3793 2025-06-28 15105.67
3794 2025-06-29 15105.67
3795 2025-06-30 15159.83
3796 2025-07-01 15210.00
3797 2025-07-02 15160.33
2025-07-02 17:50:55,919 - IOOppi_data - INFO : save new data to db IOOppi_CF_g: date ... updated_at
3801 2025-07-02 ... 2025-07-02 17:50:55.912588
[1 rows x 5 columns]
2025-07-02 17:50:55,937 - 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-07-02 17:50:56,522 - IOOppi_data - INFO : save data to db IOOppi_pb_t data:
date value
3738 2025-06-28 17072.50
3739 2025-06-29 17072.50
3740 2025-06-30 17043.75
3741 2025-07-01 17018.75
3742 2025-07-02 17010.00
2025-07-02 17:50:56,593 - IOOppi_data - INFO : save new data to db IOOppi_pb_t: date value ... created_at updated_at
3742 2025-07-02 17010.0 ... 2025-07-02 17:50:56.586389 2025-07-02 17:50:56.586790
[1 rows x 5 columns]
2025-07-02 17:50:56,612 - IOOppi_data - INFO : save diff data to db: IOOppi_pb_t: no diff data
2025-07-02 17:50:56,618 - IOOppi_data - INFO : save data to db IOOppi_pb_g data:
date value
3738 2025-06-28 17072.50
3739 2025-06-29 17072.50
3740 2025-06-30 17043.75
3741 2025-07-01 17018.75
3742 2025-07-02 17010.00
2025-07-02 17:50:56,689 - IOOppi_data - INFO : save new data to db IOOppi_pb_g: date value ... created_at updated_at
3745 2025-07-02 17010.0 ... 2025-07-02 17:50:56.681856 2025-07-02 17:50:56.682251
[1 rows x 5 columns]
2025-07-02 17:50:56,707 - 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-07-02 17:50:57,244 - IOOppi_data - INFO : save data to db IOOppi_hc_t data:
date value
3013 2025-06-28 3206.67
3014 2025-06-29 3206.67
3015 2025-06-30 3210.00
3016 2025-07-01 3206.67
3017 2025-07-02 3216.67
2025-07-02 17:50:57,309 - IOOppi_data - INFO : save new data to db IOOppi_hc_t: date value ... created_at updated_at
3017 2025-07-02 3216.67 ... 2025-07-02 17:50:57.301835 2025-07-02 17:50:57.302249
[1 rows x 5 columns]
2025-07-02 17:50:57,328 - IOOppi_data - INFO : save diff data to db: IOOppi_hc_t: no diff data
2025-07-02 17:50:57,334 - IOOppi_data - INFO : save data to db IOOppi_hc_g data:
date value
3013 2025-06-28 3206.67
3014 2025-06-29 3206.67
3015 2025-06-30 3210.00
3016 2025-07-01 3206.67
3017 2025-07-02 3216.67
2025-07-02 17:50:57,397 - IOOppi_data - INFO : save new data to db IOOppi_hc_g: date value ... created_at updated_at
3020 2025-07-02 3216.67 ... 2025-07-02 17:50:57.390380 2025-07-02 17:50:57.390791
[1 rows x 5 columns]
2025-07-02 17:50:57,416 - 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-07-02 17:50:57,982 - IOOppi_data - INFO : save data to db IOOppi_fu_t data:
date value
3293 2025-06-28 5512.5
3294 2025-06-29 5512.5
3295 2025-06-30 5462.5
3296 2025-07-01 5437.5
3297 2025-07-02 5425.0
2025-07-02 17:50:58,051 - IOOppi_data - INFO : save new data to db IOOppi_fu_t: date value ... created_at updated_at
3297 2025-07-02 5425.0 ... 2025-07-02 17:50:58.043804 2025-07-02 17:50:58.044223
[1 rows x 5 columns]
2025-07-02 17:50:58,071 - IOOppi_data - INFO : save diff data to db: IOOppi_fu_t: no diff data
2025-07-02 17:50:58,077 - IOOppi_data - INFO : save data to db IOOppi_fu_g data:
date value
3293 2025-06-28 5512.5
3294 2025-06-29 5512.5
3295 2025-06-30 5462.5
3296 2025-07-01 5437.5
3297 2025-07-02 5425.0
2025-07-02 17:50:58,150 - IOOppi_data - INFO : save new data to db IOOppi_fu_g: date value ... created_at updated_at
3784 2025-07-02 5425.0 ... 2025-07-02 17:50:58.143125 2025-07-02 17:50:58.143547
[1 rows x 5 columns]
2025-07-02 17:50:58,169 - 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-07-02 17:50:58,700 - IOOppi_data - INFO : save data to db IOOppi_lh_t data:
date value
1357 2025-06-28 14420.0
1358 2025-06-29 14420.0
1359 2025-06-30 14480.0
1360 2025-07-01 14620.0
1361 2025-07-02 14750.0
2025-07-02 17:50:58,743 - IOOppi_data - INFO : save new data to db IOOppi_lh_t: date value ... created_at updated_at
1361 2025-07-02 14750.0 ... 2025-07-02 17:50:58.736222 2025-07-02 17:50:58.736617
[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-07-02 17:50:58,980 - IOOppi_data - INFO : save diff data to db IOOppi_lh_t: date ... updated_at
116 2021-07-05 ... 2025-07-02 17:50:58.972273
117 2021-07-06 ... 2025-07-02 17:50:58.972273
121 2021-07-12 ... 2025-07-02 17:50:58.972273
122 2021-07-13 ... 2025-07-02 17:50:58.972273
194 2021-11-01 ... 2025-07-02 17:50:58.972273
[5 rows x 6 columns]
2025-07-02 17:50:59,016 - IOOppi_data - INFO : save data to db IOOppi_lh_g data:
date value
1357 2025-06-28 14420.0
1358 2025-06-29 14420.0
1359 2025-06-30 14480.0
1360 2025-07-01 14620.0
1361 2025-07-02 14750.0
2025-07-02 17:50:59,059 - IOOppi_data - INFO : save new data to db IOOppi_lh_g: date value ... created_at updated_at
1364 2025-07-02 14750.0 ... 2025-07-02 17:50:59.052138 2025-07-02 17:50:59.052520
[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-07-02 17:50:59,297 - IOOppi_data - INFO : save diff data to db IOOppi_lh_g: date ... updated_at
116 2021-07-05 ... 2025-07-02 17:50:59.288946
117 2021-07-06 ... 2025-07-02 17:50:59.288946
121 2021-07-12 ... 2025-07-02 17:50:59.288946
122 2021-07-13 ... 2025-07-02 17:50:59.288946
194 2021-11-01 ... 2025-07-02 17:50:59.288946
[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-07-02 17:51:00,071 - IOOppi_data - INFO : save data to db IOOppi_cu_t data:
date value
3789 2025-06-28 80195.00
3790 2025-06-29 80195.00
3791 2025-06-30 80001.67
3792 2025-07-01 80235.00
3793 2025-07-02 80983.33
2025-07-02 17:51:00,145 - IOOppi_data - INFO : save new data to db IOOppi_cu_t: date ... updated_at
3793 2025-07-02 ... 2025-07-02 17:51:00.139617
[1 rows x 5 columns]
2025-07-02 17:51:00,164 - IOOppi_data - INFO : save diff data to db: IOOppi_cu_t: no diff data
2025-07-02 17:51:00,170 - IOOppi_data - INFO : save data to db IOOppi_cu_g data:
date value
3789 2025-06-28 80195.00
3790 2025-06-29 80195.00
3791 2025-06-30 80001.67
3792 2025-07-01 80235.00
3793 2025-07-02 80983.33
2025-07-02 17:51:00,242 - IOOppi_data - INFO : save new data to db IOOppi_cu_g: date ... updated_at
3796 2025-07-02 ... 2025-07-02 17:51:00.235814
[1 rows x 5 columns]
2025-07-02 17:51:00,261 - 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-07-02 17:51:00,824 - 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-07-02 17:51:00,878 - IOOppi_data - INFO : save new data to db: IOOppi_PM_t: no new data
2025-07-02 17:51:00,878 - IOOppi_data - INFO : save diff data to db: IOOppi_PM_t: no diff data
2025-07-02 17:51:00,883 - 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-07-02 17:51:00,944 - IOOppi_data - INFO : save new data to db: IOOppi_PM_g: no new data
2025-07-02 17:51:00,944 - 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-07-02 17:51:01,555 - IOOppi_data - INFO : save data to db IOOppi_sn_t data:
date value
2767 2025-06-28 269425.0
2768 2025-06-29 269425.0
2769 2025-06-30 267487.5
2770 2025-07-01 266637.5
2771 2025-07-02 268537.5
2025-07-02 17:51:01,615 - IOOppi_data - INFO : save new data to db IOOppi_sn_t: date ... updated_at
2771 2025-07-02 ... 2025-07-02 17:51:01.608843
[1 rows x 5 columns]
2025-07-02 17:51:01,635 - IOOppi_data - INFO : save diff data to db: IOOppi_sn_t: no diff data
2025-07-02 17:51:01,641 - IOOppi_data - INFO : save data to db IOOppi_sn_g data:
date value
2767 2025-06-28 269425.0
2768 2025-06-29 269425.0
2769 2025-06-30 267487.5
2770 2025-07-01 266637.5
2771 2025-07-02 268537.5
2025-07-02 17:51:01,701 - IOOppi_data - INFO : save new data to db IOOppi_sn_g: date ... updated_at
2774 2025-07-02 ... 2025-07-02 17:51:01.695122
[1 rows x 5 columns]
2025-07-02 17:51:01,720 - 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-07-02 17:51:02,287 - IOOppi_data - INFO : save data to db IOOppi_zn_t data:
date value
3788 2025-06-28 22568.0
3789 2025-06-29 22568.0
3790 2025-06-30 22486.0
3791 2025-07-01 22258.0
3792 2025-07-02 22270.0
2025-07-02 17:51:02,359 - IOOppi_data - INFO : save new data to db IOOppi_zn_t: date value ... created_at updated_at
3792 2025-07-02 22270.0 ... 2025-07-02 17:51:02.351883 2025-07-02 17:51:02.352297
[1 rows x 5 columns]
2025-07-02 17:51:02,378 - IOOppi_data - INFO : save diff data to db: IOOppi_zn_t: no diff data
2025-07-02 17:51:02,385 - IOOppi_data - INFO : save data to db IOOppi_zn_g data:
date value
3788 2025-06-28 22568.0
3789 2025-06-29 22568.0
3790 2025-06-30 22486.0
3791 2025-07-01 22258.0
3792 2025-07-02 22270.0
2025-07-02 17:51:02,457 - IOOppi_data - INFO : save new data to db IOOppi_zn_g: date value ... created_at updated_at
3795 2025-07-02 22270.0 ... 2025-07-02 17:51:02.450770 2025-07-02 17:51:02.451171
[1 rows x 5 columns]
2025-07-02 17:51:02,477 - 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-07-02 17:51:03,060 - IOOppi_data - INFO : save data to db IOOppi_wr_t data:
date value
3751 2025-06-28 3252.5
3752 2025-06-29 3252.5
3753 2025-06-30 3260.0
3754 2025-07-01 3252.5
3755 2025-07-02 3252.5
2025-07-02 17:51:03,133 - IOOppi_data - INFO : save new data to db IOOppi_wr_t: date value ... created_at updated_at
3755 2025-07-02 3252.5 ... 2025-07-02 17:51:03.126561 2025-07-02 17:51:03.126978
[1 rows x 5 columns]
2025-07-02 17:51:03,152 - IOOppi_data - INFO : save diff data to db: IOOppi_wr_t: no diff data
2025-07-02 17:51:03,158 - IOOppi_data - INFO : save data to db IOOppi_wr_g data:
date value
3751 2025-06-28 3252.5
3752 2025-06-29 3252.5
3753 2025-06-30 3260.0
3754 2025-07-01 3252.5
3755 2025-07-02 3252.5
2025-07-02 17:51:03,231 - IOOppi_data - INFO : save new data to db IOOppi_wr_g: date value ... created_at updated_at
3758 2025-07-02 3252.5 ... 2025-07-02 17:51:03.223796 2025-07-02 17:51:03.224193
[1 rows x 5 columns]
2025-07-02 17:51:03,250 - 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-07-02 17:51:03,822 - IOOppi_data - INFO : save data to db IOOppi_pg_t data:
date value
1548 2025-06-28 4967.5
1549 2025-06-29 4967.5
1550 2025-06-30 4922.5
1551 2025-07-01 4922.5
1552 2025-07-02 4947.5
2025-07-02 17:51:03,866 - IOOppi_data - INFO : save new data to db IOOppi_pg_t: date value ... created_at updated_at
1552 2025-07-02 4947.5 ... 2025-07-02 17:51:03.859249 2025-07-02 17:51:03.859625
[1 rows x 5 columns]
2025-07-02 17:51:03,885 - IOOppi_data - INFO : save diff data to db: IOOppi_pg_t: no diff data
2025-07-02 17:51:03,890 - IOOppi_data - INFO : save data to db IOOppi_pg_g data:
date value
1548 2025-06-28 4967.5
1549 2025-06-29 4967.5
1550 2025-06-30 4922.5
1551 2025-07-01 4922.5
1552 2025-07-02 4947.5
2025-07-02 17:51:03,936 - IOOppi_data - INFO : save new data to db IOOppi_pg_g: date value ... created_at updated_at
1555 2025-07-02 4947.5 ... 2025-07-02 17:51:03.929066 2025-07-02 17:51:03.929448
[1 rows x 5 columns]
2025-07-02 17:51:03,955 - 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-07-02 17:51:04,731 - IOOppi_data - INFO : save data to db IOOppi_cs_t data:
date value
2822 2025-06-28 2352.86
2823 2025-06-29 2352.86
2824 2025-06-30 2357.14
2825 2025-07-01 2365.71
2826 2025-07-02 2367.14
2025-07-02 17:51:04,791 - IOOppi_data - INFO : save new data to db IOOppi_cs_t: date value ... created_at updated_at
2826 2025-07-02 2367.14 ... 2025-07-02 17:51:04.784725 2025-07-02 17:51:04.785145
[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-07-02 17:51:04,833 - IOOppi_data - INFO : save diff data to db IOOppi_cs_t: date ... updated_at
2825 2025-07-01 ... 2025-07-02 17:51:04.826194
[1 rows x 6 columns]
2025-07-02 17:51:04,858 - IOOppi_data - INFO : save data to db IOOppi_cs_g data:
date value
2822 2025-06-28 2352.86
2823 2025-06-29 2352.86
2824 2025-06-30 2357.14
2825 2025-07-01 2365.71
2826 2025-07-02 2367.14
2025-07-02 17:51:04,919 - IOOppi_data - INFO : save new data to db IOOppi_cs_g: date value ... created_at updated_at
2829 2025-07-02 2367.14 ... 2025-07-02 17:51:04.912331 2025-07-02 17:51:04.912714
[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-07-02 17:51:04,960 - IOOppi_data - INFO : save diff data to db IOOppi_cs_g: date ... updated_at
2828 2025-07-01 ... 2025-07-02 17:51:04.953675
[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-07-02 17:51:05,630 - IOOppi_data - INFO : save data to db IOOppi_cs_t data:
date value
2822 2025-06-28 2352.86
2823 2025-06-29 2352.86
2824 2025-06-30 2357.14
2825 2025-07-01 2365.71
2826 2025-07-02 2944.00
2025-07-02 17:51:05,681 - 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-07-02 17:51:05,704 - IOOppi_data - INFO : save diff data to db IOOppi_cs_t: date ... updated_at
2826 2025-07-02 ... 2025-07-02 17:51:05.696734
[1 rows x 6 columns]
2025-07-02 17:51:05,729 - IOOppi_data - INFO : save data to db IOOppi_cs_g data:
date value
2822 2025-06-28 2352.86
2823 2025-06-29 2352.86
2824 2025-06-30 2357.14
2825 2025-07-01 2365.71
2826 2025-07-02 2944.00
2025-07-02 17:51:05,783 - 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-07-02 17:51:05,807 - IOOppi_data - INFO : save diff data to db IOOppi_cs_g: date ... updated_at
2829 2025-07-02 ... 2025-07-02 17:51:05.799034
[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-07-02 17:51:06,343 - IOOppi_data - INFO : save data to db IOOppi_RS_t data:
date value
3179 2025-06-28 9631.67
3180 2025-06-29 9631.67
3181 2025-06-30 9581.67
3182 2025-07-01 9625.00
3183 2025-07-02 9763.33
2025-07-02 17:51:06,399 - IOOppi_data - INFO : save new data to db: IOOppi_RS_t: no new data
2025-07-02 17:51:06,399 - IOOppi_data - INFO : save diff data to db: IOOppi_RS_t: no diff data
2025-07-02 17:51:06,404 - IOOppi_data - INFO : save data to db IOOppi_RS_g data:
date value
3179 2025-06-28 9631.67
3180 2025-06-29 9631.67
3181 2025-06-30 9581.67
3182 2025-07-01 9625.00
3183 2025-07-02 9763.33
2025-07-02 17:51:06,462 - IOOppi_data - INFO : save new data to db: IOOppi_RS_g: no new data
2025-07-02 17:51:06,462 - 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-07-02 17:51:07,028 - IOOppi_data - INFO : save data to db IOOppi_eg_t data:
date value
1863 2025-06-28 4416.67
1864 2025-06-29 4416.67
1865 2025-06-30 4413.33
1866 2025-07-01 4396.67
1867 2025-07-02 4400.00
2025-07-02 17:51:07,076 - IOOppi_data - INFO : save new data to db IOOppi_eg_t: date value ... created_at updated_at
1867 2025-07-02 4400.0 ... 2025-07-02 17:51:07.069631 2025-07-02 17:51:07.070060
[1 rows x 5 columns]
2025-07-02 17:51:07,095 - IOOppi_data - INFO : save diff data to db: IOOppi_eg_t: no diff data
2025-07-02 17:51:07,101 - IOOppi_data - INFO : save data to db IOOppi_eg_g data:
date value
1863 2025-06-28 4416.67
1864 2025-06-29 4416.67
1865 2025-06-30 4413.33
1866 2025-07-01 4396.67
1867 2025-07-02 4400.00
2025-07-02 17:51:07,149 - IOOppi_data - INFO : save new data to db IOOppi_eg_g: date value ... created_at updated_at
1870 2025-07-02 4400.0 ... 2025-07-02 17:51:07.142509 2025-07-02 17:51:07.142920
[1 rows x 5 columns]
2025-07-02 17:51:07,169 - 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-07-02 17:51:07,788 - IOOppi_data - INFO : save data to db IOOppi_sp_t data:
date value
1872 2025-06-28 5983.33
1873 2025-06-29 5983.33
1874 2025-06-30 5950.00
1875 2025-07-01 5950.00
1876 2025-07-02 5950.00
2025-07-02 17:51:07,838 - IOOppi_data - INFO : save new data to db IOOppi_sp_t: date value ... created_at updated_at
1876 2025-07-02 5950.0 ... 2025-07-02 17:51:07.831022 2025-07-02 17:51:07.831417
[1 rows x 5 columns]
2025-07-02 17:51:07,859 - IOOppi_data - INFO : save diff data to db: IOOppi_sp_t: no diff data
2025-07-02 17:51:07,864 - IOOppi_data - INFO : save data to db IOOppi_sp_g data:
date value
1872 2025-06-28 5983.33
1873 2025-06-29 5983.33
1874 2025-06-30 5950.00
1875 2025-07-01 5950.00
1876 2025-07-02 5950.00
2025-07-02 17:51:07,917 - IOOppi_data - INFO : save new data to db IOOppi_sp_g: date value ... created_at updated_at
1879 2025-07-02 5950.0 ... 2025-07-02 17:51:07.908487 2025-07-02 17:51:07.909111
[1 rows x 5 columns]
2025-07-02 17:51:07,936 - 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-07-02 17:51:08,513 - IOOppi_data - INFO : save data to db IOOppi_p_t data:
date value
3540 2025-06-28 8586.0
3541 2025-06-29 8586.0
3542 2025-06-30 8570.0
3543 2025-07-01 8600.0
3544 2025-07-02 8638.0
2025-07-02 17:51:08,583 - IOOppi_data - INFO : save new data to db IOOppi_p_t: date value ... created_at updated_at
3544 2025-07-02 8638.0 ... 2025-07-02 17:51:08.576199 2025-07-02 17:51:08.576584
[1 rows x 5 columns]
2025-07-02 17:51:08,602 - IOOppi_data - INFO : save diff data to db: IOOppi_p_t: no diff data
2025-07-02 17:51:08,608 - IOOppi_data - INFO : save data to db IOOppi_p_g data:
date value
3540 2025-06-28 8586.0
3541 2025-06-29 8586.0
3542 2025-06-30 8570.0
3543 2025-07-01 8600.0
3544 2025-07-02 8638.0
2025-07-02 17:51:08,678 - IOOppi_data - INFO : save new data to db IOOppi_p_g: date value ... created_at updated_at
3547 2025-07-02 8638.0 ... 2025-07-02 17:51:08.671271 2025-07-02 17:51:08.671655
[1 rows x 5 columns]
2025-07-02 17:51:08,696 - IOOppi_data - INFO : save diff data to db: IOOppi_p_g: no diff data