=========================================================================
2025-06-04 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-06-04 17:50:28,449 - IOOppi_data - INFO : save data to db IOOppi_rb_t data:
date value
3320 2025-05-31 3062.22
3321 2025-06-01 3062.22
3322 2025-06-02 3062.22
3323 2025-06-03 3050.89
3324 2025-06-04 3057.33
2025-06-04 17:50:28,521 - IOOppi_data - INFO : save new data to db IOOppi_rb_t: date value ... created_at updated_at
3324 2025-06-04 3057.33 ... 2025-06-04 17:50:28.513436 2025-06-04 17:50:28.513886
[1 rows x 5 columns]
2025-06-04 17:50:28,544 - IOOppi_data - INFO : save diff data to db: IOOppi_rb_t: no diff data
2025-06-04 17:50:28,550 - IOOppi_data - INFO : save data to db IOOppi_rb_g data:
date value
3320 2025-05-31 3062.22
3321 2025-06-01 3062.22
3322 2025-06-02 3062.22
3323 2025-06-03 3050.89
3324 2025-06-04 3057.33
2025-06-04 17:50:28,617 - IOOppi_data - INFO : save new data to db IOOppi_rb_g: date value ... created_at updated_at
3327 2025-06-04 3057.33 ... 2025-06-04 17:50:28.609830 2025-06-04 17:50:28.610256
[1 rows x 5 columns]
2025-06-04 17:50:28,638 - 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-04 17:50:29,177 - IOOppi_data - INFO : save data to db IOOppi_MA_t data:
date value
3541 2025-05-31 2250.0
3542 2025-06-01 2250.0
3543 2025-06-02 2250.0
3544 2025-06-03 2293.0
3545 2025-06-04 2293.0
2025-06-04 17:50:29,244 - IOOppi_data - INFO : save new data to db IOOppi_MA_t: date value ... created_at updated_at
3545 2025-06-04 2293.0 ... 2025-06-04 17:50:29.237588 2025-06-04 17:50:29.237998
[1 rows x 5 columns]
2025-06-04 17:50:29,263 - IOOppi_data - INFO : save diff data to db: IOOppi_MA_t: no diff data
2025-06-04 17:50:29,269 - IOOppi_data - INFO : save data to db IOOppi_MA_g data:
date value
3541 2025-05-31 2250.0
3542 2025-06-01 2250.0
3543 2025-06-02 2250.0
3544 2025-06-03 2293.0
3545 2025-06-04 2293.0
2025-06-04 17:50:29,337 - IOOppi_data - INFO : save new data to db IOOppi_MA_g: date value ... created_at updated_at
3549 2025-06-04 2293.0 ... 2025-06-04 17:50:29.330534 2025-06-04 17:50:29.330926
[1 rows x 5 columns]
2025-06-04 17:50:29,356 - 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-04 17:50:29,893 - IOOppi_data - INFO : save data to db IOOppi_PTA_t data:
date value
881 2025-05-31 4965.62
882 2025-06-01 4965.62
883 2025-06-02 4965.62
884 2025-06-03 4948.75
885 2025-06-04 4896.50
2025-06-04 17:50:29,930 - IOOppi_data - INFO : save new data to db IOOppi_PTA_t: date value ... created_at updated_at
885 2025-06-04 4896.5 ... 2025-06-04 17:50:29.923297 2025-06-04 17:50:29.923684
[1 rows x 5 columns]
2025-06-04 17:50:29,950 - IOOppi_data - INFO : save diff data to db: IOOppi_PTA_t: no diff data
2025-06-04 17:50:29,955 - IOOppi_data - INFO : save data to db IOOppi_PTA_g data:
date value
881 2025-05-31 4965.62
882 2025-06-01 4965.62
883 2025-06-02 4965.62
884 2025-06-03 4948.75
885 2025-06-04 4896.50
2025-06-04 17:50:29,991 - IOOppi_data - INFO : save new data to db IOOppi_PTA_g: date value ... created_at updated_at
885 2025-06-04 4896.5 ... 2025-06-04 17:50:29.984273 2025-06-04 17:50:29.984640
[1 rows x 5 columns]
2025-06-04 17:50:30,010 - 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-04 17:50:30,577 - IOOppi_data - INFO : save data to db IOOppi_ru_t data:
date value
3760 2025-05-31 13308.33
3761 2025-06-01 13308.33
3762 2025-06-02 13308.33
3763 2025-06-03 13308.33
3764 2025-06-04 13558.33
2025-06-04 17:50:30,649 - IOOppi_data - INFO : save new data to db IOOppi_ru_t: date ... updated_at
3764 2025-06-04 ... 2025-06-04 17:50:30.642491
[1 rows x 5 columns]
2025-06-04 17:50:30,668 - IOOppi_data - INFO : save diff data to db: IOOppi_ru_t: no diff data
2025-06-04 17:50:30,673 - IOOppi_data - INFO : save data to db IOOppi_ru_g data:
date value
3760 2025-05-31 13308.33
3761 2025-06-01 13308.33
3762 2025-06-02 13308.33
3763 2025-06-03 13308.33
3764 2025-06-04 13558.33
2025-06-04 17:50:30,745 - IOOppi_data - INFO : save new data to db IOOppi_ru_g: date ... updated_at
3767 2025-06-04 ... 2025-06-04 17:50:30.739133
[1 rows x 5 columns]
2025-06-04 17:50:30,765 - 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-04 17:50:31,278 - IOOppi_data - INFO : save data to db IOOppi_i_t data:
date value
3092 2025-05-31 750.33
3093 2025-06-01 750.33
3094 2025-06-02 750.33
3095 2025-06-03 750.33
3096 2025-06-04 752.11
2025-06-04 17:50:31,343 - IOOppi_data - INFO : save new data to db IOOppi_i_t: date value ... created_at updated_at
3096 2025-06-04 752.11 ... 2025-06-04 17:50:31.335820 2025-06-04 17:50:31.336215
[1 rows x 5 columns]
2025-06-04 17:50:31,362 - IOOppi_data - INFO : save diff data to db: IOOppi_i_t: no diff data
2025-06-04 17:50:31,368 - IOOppi_data - INFO : save data to db IOOppi_i_g data:
date value
3092 2025-05-31 750.33
3093 2025-06-01 750.33
3094 2025-06-02 750.33
3095 2025-06-03 750.33
3096 2025-06-04 752.11
2025-06-04 17:50:31,435 - IOOppi_data - INFO : save new data to db IOOppi_i_g: date value ... created_at updated_at
3099 2025-06-04 752.11 ... 2025-06-04 17:50:31.427718 2025-06-04 17:50:31.428192
[1 rows x 5 columns]
2025-06-04 17:50:31,455 - 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-04 17:50:31,960 - IOOppi_data - INFO : save data to db IOOppi_FG_t data:
date value
3295 2025-05-31 1150.4
3296 2025-06-01 1150.4
3297 2025-06-02 1150.4
3298 2025-06-03 1136.0
3299 2025-06-04 1136.0
2025-06-04 17:50:32,025 - IOOppi_data - INFO : save new data to db IOOppi_FG_t: date value ... created_at updated_at
3299 2025-06-04 1136.0 ... 2025-06-04 17:50:32.018620 2025-06-04 17:50:32.019033
[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-04 17:50:34,115 - IOOppi_data - INFO : save diff data to db IOOppi_FG_t: date ... updated_at
12 2012-12-19 ... 2025-06-04 17:50:34.105907
21 2013-01-04 ... 2025-06-04 17:50:34.105907
54 2013-02-27 ... 2025-06-04 17:50:34.105907
60 2013-03-07 ... 2025-06-04 17:50:34.105907
61 2013-03-08 ... 2025-06-04 17:50:34.105907
[5 rows x 6 columns]
2025-06-04 17:50:34,279 - IOOppi_data - INFO : save data to db IOOppi_FG_g data:
date value
3295 2025-05-31 1150.4
3296 2025-06-01 1150.4
3297 2025-06-02 1150.4
3298 2025-06-03 1136.0
3299 2025-06-04 1136.0
2025-06-04 17:50:34,345 - IOOppi_data - INFO : save new data to db IOOppi_FG_g: date value ... created_at updated_at
3303 2025-06-04 1136.0 ... 2025-06-04 17:50:34.337984 2025-06-04 17:50:34.338378
[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-04 17:50:36,415 - IOOppi_data - INFO : save diff data to db IOOppi_FG_g: date ... updated_at
12 2012-12-19 ... 2025-06-04 17:50:36.407609
21 2013-01-04 ... 2025-06-04 17:50:36.407609
54 2013-02-27 ... 2025-06-04 17:50:36.407609
60 2013-03-07 ... 2025-06-04 17:50:36.407609
61 2013-03-08 ... 2025-06-04 17:50:36.407609
[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-04 17:50:37,096 - IOOppi_data - INFO : save data to db IOOppi_eb_t data:
date value
1640 2025-05-31 8104.0
1641 2025-06-01 8104.0
1642 2025-06-02 8104.0
1643 2025-06-03 8040.0
1644 2025-06-04 8040.0
2025-06-04 17:50:37,142 - IOOppi_data - INFO : save new data to db IOOppi_eb_t: date value ... created_at updated_at
1644 2025-06-04 8040.0 ... 2025-06-04 17:50:37.135779 2025-06-04 17:50:37.136172
[1 rows x 5 columns]
2025-06-04 17:50:37,162 - IOOppi_data - INFO : save diff data to db: IOOppi_eb_t: no diff data
2025-06-04 17:50:37,168 - IOOppi_data - INFO : save data to db IOOppi_eb_g data:
date value
1640 2025-05-31 8104.0
1641 2025-06-01 8104.0
1642 2025-06-02 8104.0
1643 2025-06-03 8040.0
1644 2025-06-04 8040.0
2025-06-04 17:50:37,213 - IOOppi_data - INFO : save new data to db IOOppi_eb_g: date value ... created_at updated_at
1647 2025-06-04 8040.0 ... 2025-06-04 17:50:37.206595 2025-06-04 17:50:37.207020
[1 rows x 5 columns]
2025-06-04 17:50:37,233 - 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-04 17:50:37,756 - IOOppi_data - INFO : save data to db IOOppi_SR_t data:
date value
3751 2025-05-31 6130.0
3752 2025-06-01 6130.0
3753 2025-06-02 6130.0
3754 2025-06-03 6130.0
3755 2025-06-04 6095.0
2025-06-04 17:50:37,829 - IOOppi_data - INFO : save new data to db IOOppi_SR_t: date value ... created_at updated_at
3755 2025-06-04 6095.0 ... 2025-06-04 17:50:37.822394 2025-06-04 17:50:37.822804
[1 rows x 5 columns]
2025-06-04 17:50:37,849 - IOOppi_data - INFO : save diff data to db: IOOppi_SR_t: no diff data
2025-06-04 17:50:37,855 - IOOppi_data - INFO : save data to db IOOppi_SR_g data:
date value
3751 2025-05-31 6130.0
3752 2025-06-01 6130.0
3753 2025-06-02 6130.0
3754 2025-06-03 6130.0
3755 2025-06-04 6095.0
2025-06-04 17:50:37,926 - IOOppi_data - INFO : save new data to db IOOppi_SR_g: date value ... created_at updated_at
3759 2025-06-04 6095.0 ... 2025-06-04 17:50:37.919469 2025-06-04 17:50:37.919876
[1 rows x 5 columns]
2025-06-04 17:50:37,946 - 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-04 17:50:38,547 - IOOppi_data - INFO : save data to db IOOppi_ss_t data:
date value
1641 2025-05-31 13175.0
1642 2025-06-01 13175.0
1643 2025-06-02 13175.0
1644 2025-06-03 13125.0
1645 2025-06-04 13125.0
2025-06-04 17:50:38,593 - IOOppi_data - INFO : save new data to db IOOppi_ss_t: date value ... created_at updated_at
1645 2025-06-04 13125.0 ... 2025-06-04 17:50:38.586052 2025-06-04 17:50:38.586429
[1 rows x 5 columns]
2025-06-04 17:50:38,613 - IOOppi_data - INFO : save diff data to db: IOOppi_ss_t: no diff data
2025-06-04 17:50:38,618 - IOOppi_data - INFO : save data to db IOOppi_ss_g data:
date value
1641 2025-05-31 13175.0
1642 2025-06-01 13175.0
1643 2025-06-02 13175.0
1644 2025-06-03 13125.0
1645 2025-06-04 13125.0
2025-06-04 17:50:38,664 - IOOppi_data - INFO : save new data to db IOOppi_ss_g: date value ... created_at updated_at
1648 2025-06-04 13125.0 ... 2025-06-04 17:50:38.657100 2025-06-04 17:50:38.657474
[1 rows x 5 columns]
2025-06-04 17:50:38,684 - IOOppi_data - INFO : save diff data to db: IOOppi_ss_g: no diff data
/usr/local/lib/python3.10/site-packages/urllib3/connectionpool.py:1056: InsecureRequestWarning: Unverified HTTPS request is being made to host 'www.100ppi.com'. Adding certificate verification is strongly advised. See: https://urllib3.readthedocs.io/en/1.26.x/advanced-usage.html#ssl-warnings
warnings.warn(
2025-06-04 17:50:39,255 - IOOppi_data - INFO : save data to db IOOppi_RS_t data:
date value
3151 2025-05-31 9456.67
3152 2025-06-01 9456.67
3153 2025-06-02 9456.67
3154 2025-06-03 9408.33
3155 2025-06-04 9238.33
2025-06-04 17:50:39,319 - IOOppi_data - INFO : save new data to db IOOppi_RS_t: date value ... created_at updated_at
3155 2025-06-04 9238.33 ... 2025-06-04 17:50:39.312231 2025-06-04 17:50:39.312613
[1 rows x 5 columns]
2025-06-04 17:50:39,339 - IOOppi_data - INFO : save diff data to db: IOOppi_RS_t: no diff data
2025-06-04 17:50:39,345 - IOOppi_data - INFO : save data to db IOOppi_RS_g data:
date value
3151 2025-05-31 9456.67
3152 2025-06-01 9456.67
3153 2025-06-02 9456.67
3154 2025-06-03 9408.33
3155 2025-06-04 9238.33
2025-06-04 17:50:39,408 - IOOppi_data - INFO : save new data to db IOOppi_RS_g: date value ... created_at updated_at
3159 2025-06-04 9238.33 ... 2025-06-04 17:50:39.401804 2025-06-04 17:50:39.402191
[1 rows x 5 columns]
2025-06-04 17:50:39,428 - 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-04 17:50:40,015 - IOOppi_data - INFO : save data to db IOOppi_RM_t data:
date value
3274 2025-05-31 2565.00
3275 2025-06-01 2565.00
3276 2025-06-02 2565.00
3277 2025-06-03 2548.33
3278 2025-06-04 2495.00
2025-06-04 17:50:40,092 - IOOppi_data - INFO : save new data to db IOOppi_RM_t: date value ... created_at updated_at
3278 2025-06-04 2495.0 ... 2025-06-04 17:50:40.084786 2025-06-04 17:50:40.085201
[1 rows x 5 columns]
2025-06-04 17:50:40,112 - IOOppi_data - INFO : save diff data to db: IOOppi_RM_t: no diff data
2025-06-04 17:50:40,118 - IOOppi_data - INFO : save data to db IOOppi_RM_g data:
date value
3274 2025-05-31 2565.00
3275 2025-06-01 2565.00
3276 2025-06-02 2565.00
3277 2025-06-03 2548.33
3278 2025-06-04 2495.00
2025-06-04 17:50:40,184 - IOOppi_data - INFO : save new data to db IOOppi_RM_g: date value ... created_at updated_at
3282 2025-06-04 2495.0 ... 2025-06-04 17:50:40.176966 2025-06-04 17:50:40.177395
[1 rows x 5 columns]
2025-06-04 17:50:40,203 - 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-04 17:50:40,669 - IOOppi_data - INFO : save data to db IOOppi_SA_t data:
date value
1478 2025-05-31 1450.0
1479 2025-06-01 1450.0
1480 2025-06-02 1450.0
1481 2025-06-03 1430.0
1482 2025-06-04 1375.0
2025-06-04 17:50:40,712 - IOOppi_data - INFO : save new data to db IOOppi_SA_t: date value ... created_at updated_at
1482 2025-06-04 1375.0 ... 2025-06-04 17:50:40.705251 2025-06-04 17:50:40.705630
[1 rows x 5 columns]
2025-06-04 17:50:40,731 - IOOppi_data - INFO : save diff data to db: IOOppi_SA_t: no diff data
2025-06-04 17:50:40,737 - IOOppi_data - INFO : save data to db IOOppi_SA_g data:
date value
1478 2025-05-31 1450.0
1479 2025-06-01 1450.0
1480 2025-06-02 1450.0
1481 2025-06-03 1430.0
1482 2025-06-04 1375.0
2025-06-04 17:50:40,780 - IOOppi_data - INFO : save new data to db IOOppi_SA_g: date value ... created_at updated_at
1486 2025-06-04 1375.0 ... 2025-06-04 17:50:40.773247 2025-06-04 17:50:40.773613
[1 rows x 5 columns]
2025-06-04 17:50:40,799 - 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-04 17:50:41,359 - IOOppi_data - INFO : save data to db IOOppi_PF_t data:
date value
1391 2025-05-31 6511.46
1392 2025-06-01 6511.46
1393 2025-06-02 6511.46
1394 2025-06-03 6513.75
1395 2025-06-04 6519.17
2025-06-04 17:50:41,402 - IOOppi_data - INFO : save new data to db IOOppi_PF_t: date value ... created_at updated_at
1395 2025-06-04 6519.17 ... 2025-06-04 17:50:41.395183 2025-06-04 17:50:41.395615
[1 rows x 5 columns]
2025-06-04 17:50:41,421 - IOOppi_data - INFO : save diff data to db: IOOppi_PF_t: no diff data
2025-06-04 17:50:41,426 - IOOppi_data - INFO : save data to db IOOppi_PF_g data:
date value
1391 2025-05-31 6511.46
1392 2025-06-01 6511.46
1393 2025-06-02 6511.46
1394 2025-06-03 6513.75
1395 2025-06-04 6519.17
2025-06-04 17:50:41,469 - IOOppi_data - INFO : save new data to db IOOppi_PF_g: date value ... created_at updated_at
1399 2025-06-04 6519.17 ... 2025-06-04 17:50:41.461987 2025-06-04 17:50:41.462355
[1 rows x 5 columns]
2025-06-04 17:50:41,489 - 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-04 17:50:42,044 - IOOppi_data - INFO : save data to db IOOppi_m_t data:
date value
3764 2025-05-31 2956.0
3765 2025-06-01 2956.0
3766 2025-06-02 2956.0
3767 2025-06-03 2900.0
3768 2025-06-04 2892.0
2025-06-04 17:50:42,116 - IOOppi_data - INFO : save new data to db IOOppi_m_t: date value ... created_at updated_at
3768 2025-06-04 2892.0 ... 2025-06-04 17:50:42.109021 2025-06-04 17:50:42.109411
[1 rows x 5 columns]
2025-06-04 17:50:42,136 - IOOppi_data - INFO : save diff data to db: IOOppi_m_t: no diff data
2025-06-04 17:50:42,141 - IOOppi_data - INFO : save data to db IOOppi_m_g data:
date value
3764 2025-05-31 2956.0
3765 2025-06-01 2956.0
3766 2025-06-02 2956.0
3767 2025-06-03 2900.0
3768 2025-06-04 2892.0
2025-06-04 17:50:42,213 - IOOppi_data - INFO : save new data to db IOOppi_m_g: date value ... created_at updated_at
3771 2025-06-04 2892.0 ... 2025-06-04 17:50:42.205974 2025-06-04 17:50:42.206366
[1 rows x 5 columns]
2025-06-04 17:50:42,234 - 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-04 17:50:42,802 - IOOppi_data - INFO : save data to db IOOppi_y_t data:
date value
3534 2025-05-31 7904.0
3535 2025-06-01 7904.0
3536 2025-06-02 7904.0
3537 2025-06-03 7954.0
3538 2025-06-04 7954.0
2025-06-04 17:50:42,873 - IOOppi_data - INFO : save new data to db IOOppi_y_t: date value ... created_at updated_at
3538 2025-06-04 7954.0 ... 2025-06-04 17:50:42.865679 2025-06-04 17:50:42.866101
[1 rows x 5 columns]
2025-06-04 17:50:42,894 - IOOppi_data - INFO : save diff data to db: IOOppi_y_t: no diff data
2025-06-04 17:50:42,900 - IOOppi_data - INFO : save data to db IOOppi_y_g data:
date value
3534 2025-05-31 7904.0
3535 2025-06-01 7904.0
3536 2025-06-02 7904.0
3537 2025-06-03 7954.0
3538 2025-06-04 7954.0
2025-06-04 17:50:42,972 - IOOppi_data - INFO : save new data to db IOOppi_y_g: date value ... created_at updated_at
3541 2025-06-04 7954.0 ... 2025-06-04 17:50:42.964632 2025-06-04 17:50:42.965071
[1 rows x 5 columns]
2025-06-04 17:50:42,991 - 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-04 17:50:43,537 - IOOppi_data - INFO : save data to db IOOppi_a_t data:
date value
3500 2025-05-31 4255.0
3501 2025-06-01 4255.0
3502 2025-06-02 4255.0
3503 2025-06-03 4255.0
3504 2025-06-04 4255.0
2025-06-04 17:50:43,606 - IOOppi_data - INFO : save new data to db IOOppi_a_t: date value ... created_at updated_at
3504 2025-06-04 4255.0 ... 2025-06-04 17:50:43.598697 2025-06-04 17:50:43.599116
[1 rows x 5 columns]
2025-06-04 17:50:43,625 - IOOppi_data - INFO : save diff data to db: IOOppi_a_t: no diff data
2025-06-04 17:50:43,631 - IOOppi_data - INFO : save data to db IOOppi_a_g data:
date value
3500 2025-05-31 4255.0
3501 2025-06-01 4255.0
3502 2025-06-02 4255.0
3503 2025-06-03 4255.0
3504 2025-06-04 4255.0
2025-06-04 17:50:43,700 - IOOppi_data - INFO : save new data to db IOOppi_a_g: date value ... created_at updated_at
3507 2025-06-04 4255.0 ... 2025-06-04 17:50:43.693124 2025-06-04 17:50:43.693503
[1 rows x 5 columns]
2025-06-04 17:50:43,721 - 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-04 17:50:44,267 - IOOppi_data - INFO : save data to db IOOppi_SF_t data:
date value
2877 2025-05-31 5298.57
2878 2025-06-01 5298.57
2879 2025-06-02 5298.57
2880 2025-06-03 5298.57
2881 2025-06-04 5152.86
2025-06-04 17:50:44,329 - IOOppi_data - INFO : save new data to db IOOppi_SF_t: date value ... created_at updated_at
2881 2025-06-04 5152.86 ... 2025-06-04 17:50:44.322545 2025-06-04 17:50:44.322955
[1 rows x 5 columns]
2025-06-04 17:50:44,350 - IOOppi_data - INFO : save diff data to db: IOOppi_SF_t: no diff data
2025-06-04 17:50:44,355 - IOOppi_data - INFO : save data to db IOOppi_SF_g data:
date value
2877 2025-05-31 5298.57
2878 2025-06-01 5298.57
2879 2025-06-02 5298.57
2880 2025-06-03 5298.57
2881 2025-06-04 5152.86
2025-06-04 17:50:44,416 - IOOppi_data - INFO : save new data to db IOOppi_SF_g: date value ... created_at updated_at
2885 2025-06-04 5152.86 ... 2025-06-04 17:50:44.409810 2025-06-04 17:50:44.410199
[1 rows x 5 columns]
2025-06-04 17:50:44,436 - 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-04 17:50:44,926 - IOOppi_data - INFO : save data to db IOOppi_jd_t data:
date value
3077 2025-05-31 3015.0
3078 2025-06-01 3015.0
3079 2025-06-02 3015.0
3080 2025-06-03 2975.0
3081 2025-06-04 2975.0
2025-06-04 17:50:44,991 - IOOppi_data - INFO : save new data to db IOOppi_jd_t: date value ... created_at updated_at
3081 2025-06-04 2975.0 ... 2025-06-04 17:50:44.984043 2025-06-04 17:50:44.984434
[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-04 17:50:45,155 - IOOppi_data - INFO : save diff data to db IOOppi_jd_t: date ... updated_at
39 2014-01-03 ... 2025-06-04 17:50:45.147383
458 2015-09-21 ... 2025-06-04 17:50:45.147383
549 2016-02-03 ... 2025-06-04 17:50:45.147383
693 2016-09-05 ... 2025-06-04 17:50:45.147383
696 2016-09-08 ... 2025-06-04 17:50:45.147383
[5 rows x 6 columns]
2025-06-04 17:50:45,187 - IOOppi_data - INFO : save data to db IOOppi_jd_g data:
date value
3077 2025-05-31 3015.0
3078 2025-06-01 3015.0
3079 2025-06-02 3015.0
3080 2025-06-03 2975.0
3081 2025-06-04 2975.0
2025-06-04 17:50:45,251 - IOOppi_data - INFO : save new data to db IOOppi_jd_g: date value ... created_at updated_at
3084 2025-06-04 2975.0 ... 2025-06-04 17:50:45.243848 2025-06-04 17:50:45.244239
[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-04 17:50:45,410 - IOOppi_data - INFO : save diff data to db IOOppi_jd_g: date ... updated_at
39 2014-01-03 ... 2025-06-04 17:50:45.402257
458 2015-09-21 ... 2025-06-04 17:50:45.402257
549 2016-02-03 ... 2025-06-04 17:50:45.402257
693 2016-09-05 ... 2025-06-04 17:50:45.402257
696 2016-09-08 ... 2025-06-04 17:50:45.402257
[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-04 17:50:45,993 - IOOppi_data - INFO : save data to db IOOppi_SI_t data:
date value
881 2025-05-31 8780.0
882 2025-06-01 8780.0
883 2025-06-02 8780.0
884 2025-06-03 8700.0
885 2025-06-04 8640.0
2025-06-04 17:50:46,029 - IOOppi_data - INFO : save new data to db IOOppi_SI_t: date value ... created_at updated_at
885 2025-06-04 8640.0 ... 2025-06-04 17:50:46.022290 2025-06-04 17:50:46.022669
[1 rows x 5 columns]
2025-06-04 17:50:46,049 - IOOppi_data - INFO : save diff data to db: IOOppi_SI_t: no diff data
2025-06-04 17:50:46,054 - IOOppi_data - INFO : save data to db IOOppi_SI_g data:
date value
881 2025-05-31 8780.0
882 2025-06-01 8780.0
883 2025-06-02 8780.0
884 2025-06-03 8700.0
885 2025-06-04 8640.0
2025-06-04 17:50:46,089 - IOOppi_data - INFO : save new data to db IOOppi_SI_g: date value ... created_at updated_at
885 2025-06-04 8640.0 ... 2025-06-04 17:50:46.082719 2025-06-04 17:50:46.083125
[1 rows x 5 columns]
2025-06-04 17:50:46,109 - 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-04 17:50:46,630 - IOOppi_data - INFO : save data to db IOOppi_l_t data:
date value
3760 2025-05-31 7368.33
3761 2025-06-01 7368.33
3762 2025-06-02 7368.33
3763 2025-06-03 7356.67
3764 2025-06-04 7346.67
2025-06-04 17:50:46,704 - IOOppi_data - INFO : save new data to db IOOppi_l_t: date value ... created_at updated_at
3764 2025-06-04 7346.67 ... 2025-06-04 17:50:46.695613 2025-06-04 17:50:46.696030
[1 rows x 5 columns]
2025-06-04 17:50:46,724 - IOOppi_data - INFO : save diff data to db: IOOppi_l_t: no diff data
2025-06-04 17:50:46,730 - IOOppi_data - INFO : save data to db IOOppi_l_g data:
date value
3760 2025-05-31 7368.33
3761 2025-06-01 7368.33
3762 2025-06-02 7368.33
3763 2025-06-03 7356.67
3764 2025-06-04 7346.67
2025-06-04 17:50:46,802 - IOOppi_data - INFO : save new data to db IOOppi_l_g: date value ... created_at updated_at
3767 2025-06-04 7346.67 ... 2025-06-04 17:50:46.795786 2025-06-04 17:50:46.796183
[1 rows x 5 columns]
2025-06-04 17:50:46,822 - 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-04 17:50:47,377 - IOOppi_data - INFO : save data to db IOOppi_bu_t data:
date value
3098 2025-05-31 3625.00
3099 2025-06-01 3625.00
3100 2025-06-02 3625.00
3101 2025-06-03 3623.33
3102 2025-06-04 3630.00
2025-06-04 17:50:47,442 - IOOppi_data - INFO : save new data to db IOOppi_bu_t: date value ... created_at updated_at
3103 2025-06-04 3630.0 ... 2025-06-04 17:50:47.435405 2025-06-04 17:50:47.435816
[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-04 17:50:47,479 - IOOppi_data - INFO : save diff data to db IOOppi_bu_t: date ... updated_at
2560 2023-12-09 ... 2025-06-04 17:50:47.471882
[1 rows x 6 columns]
2025-06-04 17:50:47,504 - IOOppi_data - INFO : save data to db IOOppi_bu_g data:
date value
3098 2025-05-31 3625.00
3099 2025-06-01 3625.00
3100 2025-06-02 3625.00
3101 2025-06-03 3623.33
3102 2025-06-04 3630.00
2025-06-04 17:50:47,569 - IOOppi_data - INFO : save new data to db IOOppi_bu_g: date value ... created_at updated_at
3105 2025-06-04 3630.0 ... 2025-06-04 17:50:47.562131 2025-06-04 17:50:47.562517
[1 rows x 5 columns]
2025-06-04 17:50:47,589 - 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-04 17:50:48,141 - IOOppi_data - INFO : save data to db IOOppi_al_t data:
date value
3763 2025-05-31 20303.33
3764 2025-06-01 20303.33
3765 2025-06-02 20303.33
3766 2025-06-03 20136.67
3767 2025-06-04 20136.67
2025-06-04 17:50:48,212 - IOOppi_data - INFO : save new data to db IOOppi_al_t: date ... updated_at
3767 2025-06-04 ... 2025-06-04 17:50:48.206553
[1 rows x 5 columns]
2025-06-04 17:50:48,232 - IOOppi_data - INFO : save diff data to db: IOOppi_al_t: no diff data
2025-06-04 17:50:48,238 - IOOppi_data - INFO : save data to db IOOppi_al_g data:
date value
3763 2025-05-31 20303.33
3764 2025-06-01 20303.33
3765 2025-06-02 20303.33
3766 2025-06-03 20136.67
3767 2025-06-04 20136.67
2025-06-04 17:50:48,308 - IOOppi_data - INFO : save new data to db IOOppi_al_g: date ... updated_at
3770 2025-06-04 ... 2025-06-04 17:50:48.302347
[1 rows x 5 columns]
2025-06-04 17:50:48,329 - 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-04 17:50:48,894 - IOOppi_data - INFO : save data to db IOOppi_SM_t data:
date value
2877 2025-05-31 5520.0
2878 2025-06-01 5520.0
2879 2025-06-02 5520.0
2880 2025-06-03 5476.0
2881 2025-06-04 5510.0
2025-06-04 17:50:48,955 - IOOppi_data - INFO : save new data to db IOOppi_SM_t: date value ... created_at updated_at
2881 2025-06-04 5510.0 ... 2025-06-04 17:50:48.948572 2025-06-04 17:50:48.948980
[1 rows x 5 columns]
2025-06-04 17:50:48,975 - IOOppi_data - INFO : save diff data to db: IOOppi_SM_t: no diff data
2025-06-04 17:50:48,981 - IOOppi_data - INFO : save data to db IOOppi_SM_g data:
date value
2877 2025-05-31 5520.0
2878 2025-06-01 5520.0
2879 2025-06-02 5520.0
2880 2025-06-03 5476.0
2881 2025-06-04 5510.0
2025-06-04 17:50:49,043 - IOOppi_data - INFO : save new data to db IOOppi_SM_g: date value ... created_at updated_at
2885 2025-06-04 5510.0 ... 2025-06-04 17:50:49.035852 2025-06-04 17:50:49.036239
[1 rows x 5 columns]
2025-06-04 17:50:49,062 - 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-04 17:50:49,584 - IOOppi_data - INFO : save data to db IOOppi_CY_t data:
date value
2152 2025-05-31 23800.0
2153 2025-06-01 23800.0
2154 2025-06-02 23800.0
2155 2025-06-03 23800.0
2156 2025-06-04 23800.0
2025-06-04 17:50:49,636 - IOOppi_data - INFO : save new data to db IOOppi_CY_t: date value ... created_at updated_at
2156 2025-06-04 23800.0 ... 2025-06-04 17:50:49.629643 2025-06-04 17:50:49.630055
[1 rows x 5 columns]
2025-06-04 17:50:49,656 - IOOppi_data - INFO : save diff data to db: IOOppi_CY_t: no diff data
2025-06-04 17:50:49,662 - IOOppi_data - INFO : save data to db IOOppi_CY_g data:
date value
2152 2025-05-31 23800.0
2153 2025-06-01 23800.0
2154 2025-06-02 23800.0
2155 2025-06-03 23800.0
2156 2025-06-04 23800.0
2025-06-04 17:50:49,713 - IOOppi_data - INFO : save new data to db IOOppi_CY_g: date value ... created_at updated_at
2160 2025-06-04 23800.0 ... 2025-06-04 17:50:49.706368 2025-06-04 17:50:49.706722
[1 rows x 5 columns]
2025-06-04 17:50:49,732 - 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-04 17:50:50,257 - IOOppi_data - INFO : save data to db IOOppi_UR_t data:
date value
1667 2025-05-31 1892.0
1668 2025-06-01 1892.0
1669 2025-06-02 1892.0
1670 2025-06-03 1896.0
1671 2025-06-04 1898.0
2025-06-04 17:50:50,302 - IOOppi_data - INFO : save new data to db IOOppi_UR_t: date value ... created_at updated_at
1671 2025-06-04 1898.0 ... 2025-06-04 17:50:50.295944 2025-06-04 17:50:50.296328
[1 rows x 5 columns]
2025-06-04 17:50:50,322 - IOOppi_data - INFO : save diff data to db: IOOppi_UR_t: no diff data
2025-06-04 17:50:50,328 - IOOppi_data - INFO : save data to db IOOppi_UR_g data:
date value
1667 2025-05-31 1892.0
1668 2025-06-01 1892.0
1669 2025-06-02 1892.0
1670 2025-06-03 1896.0
1671 2025-06-04 1898.0
2025-06-04 17:50:50,376 - IOOppi_data - INFO : save new data to db IOOppi_UR_g: date value ... created_at updated_at
1675 2025-06-04 1898.0 ... 2025-06-04 17:50:50.368683 2025-06-04 17:50:50.369162
[1 rows x 5 columns]
2025-06-04 17:50:50,395 - 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-04 17:50:50,959 - IOOppi_data - INFO : save data to db IOOppi_ni_t data:
date value
2739 2025-05-31 122425.00
2740 2025-06-01 122425.00
2741 2025-06-02 122425.00
2742 2025-06-03 122950.00
2743 2025-06-04 123641.67
2025-06-04 17:50:51,018 - IOOppi_data - INFO : save new data to db IOOppi_ni_t: date ... updated_at
2743 2025-06-04 ... 2025-06-04 17:50:51.011553
[1 rows x 5 columns]
2025-06-04 17:50:51,037 - IOOppi_data - INFO : save diff data to db: IOOppi_ni_t: no diff data
2025-06-04 17:50:51,043 - IOOppi_data - INFO : save data to db IOOppi_ni_g data:
date value
2739 2025-05-31 122425.00
2740 2025-06-01 122425.00
2741 2025-06-02 122425.00
2742 2025-06-03 122950.00
2743 2025-06-04 123641.67
2025-06-04 17:50:51,104 - IOOppi_data - INFO : save new data to db IOOppi_ni_g: date ... updated_at
2746 2025-06-04 ... 2025-06-04 17:50:51.097570
[1 rows x 5 columns]
2025-06-04 17:50:51,123 - 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-04 17:50:51,663 - IOOppi_data - INFO : save data to db IOOppi_v_t data:
date value
3764 2025-05-31 4597.0
3765 2025-06-01 4597.0
3766 2025-06-02 4597.0
3767 2025-06-03 4582.0
3768 2025-06-04 4589.0
2025-06-04 17:50:51,738 - IOOppi_data - INFO : save new data to db IOOppi_v_t: date value ... created_at updated_at
3768 2025-06-04 4589.0 ... 2025-06-04 17:50:51.731025 2025-06-04 17:50:51.731416
[1 rows x 5 columns]
2025-06-04 17:50:51,759 - IOOppi_data - INFO : save diff data to db: IOOppi_v_t: no diff data
2025-06-04 17:50:51,765 - IOOppi_data - INFO : save data to db IOOppi_v_g data:
date value
3764 2025-05-31 4597.0
3765 2025-06-01 4597.0
3766 2025-06-02 4597.0
3767 2025-06-03 4582.0
3768 2025-06-04 4589.0
2025-06-04 17:50:51,852 - IOOppi_data - INFO : save new data to db IOOppi_v_g: date value ... created_at updated_at
3771 2025-06-04 4589.0 ... 2025-06-04 17:50:51.844773 2025-06-04 17:50:51.845190
[1 rows x 5 columns]
2025-06-04 17:50:51,872 - 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-04 17:50:52,416 - IOOppi_data - INFO : save data to db IOOppi_pp_t data:
date value
3003 2025-05-31 7393.33
3004 2025-06-01 7393.33
3005 2025-06-02 7393.33
3006 2025-06-03 7393.33
3007 2025-06-04 7393.33
2025-06-04 17:50:52,485 - IOOppi_data - INFO : save new data to db IOOppi_pp_t: date value ... created_at updated_at
3007 2025-06-04 7393.33 ... 2025-06-04 17:50:52.478459 2025-06-04 17:50:52.478895
[1 rows x 5 columns]
2025-06-04 17:50:52,505 - IOOppi_data - INFO : save diff data to db: IOOppi_pp_t: no diff data
2025-06-04 17:50:52,511 - IOOppi_data - INFO : save data to db IOOppi_pp_g data:
date value
3003 2025-05-31 7393.33
3004 2025-06-01 7393.33
3005 2025-06-02 7393.33
3006 2025-06-03 7393.33
3007 2025-06-04 7393.33
2025-06-04 17:50:52,574 - IOOppi_data - INFO : save new data to db IOOppi_pp_g: date value ... created_at updated_at
3010 2025-06-04 7393.33 ... 2025-06-04 17:50:52.567239 2025-06-04 17:50:52.567618
[1 rows x 5 columns]
2025-06-04 17:50:52,594 - 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-04 17:50:53,170 - IOOppi_data - INFO : save data to db IOOppi_CF_t data:
date value
3765 2025-05-31 14580.33
3766 2025-06-01 14580.33
3767 2025-06-02 14580.33
3768 2025-06-03 14558.33
3769 2025-06-04 14553.00
2025-06-04 17:50:53,246 - IOOppi_data - INFO : save new data to db IOOppi_CF_t: date value ... created_at updated_at
3769 2025-06-04 14553.0 ... 2025-06-04 17:50:53.239485 2025-06-04 17:50:53.239896
[1 rows x 5 columns]
2025-06-04 17:50:53,266 - IOOppi_data - INFO : save diff data to db: IOOppi_CF_t: no diff data
2025-06-04 17:50:53,272 - IOOppi_data - INFO : save data to db IOOppi_CF_g data:
date value
3765 2025-05-31 14580.33
3766 2025-06-01 14580.33
3767 2025-06-02 14580.33
3768 2025-06-03 14558.33
3769 2025-06-04 14553.00
2025-06-04 17:50:53,345 - IOOppi_data - INFO : save new data to db IOOppi_CF_g: date value ... created_at updated_at
3773 2025-06-04 14553.0 ... 2025-06-04 17:50:53.338391 2025-06-04 17:50:53.338798
[1 rows x 5 columns]
2025-06-04 17:50:53,365 - 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-04 17:50:54,017 - IOOppi_data - INFO : save data to db IOOppi_pb_t data:
date value
3710 2025-05-31 16487.5
3711 2025-06-01 16487.5
3712 2025-06-02 16487.5
3713 2025-06-03 16462.5
3714 2025-06-04 16525.0
2025-06-04 17:50:54,090 - IOOppi_data - INFO : save new data to db IOOppi_pb_t: date value ... created_at updated_at
3714 2025-06-04 16525.0 ... 2025-06-04 17:50:54.083161 2025-06-04 17:50:54.083556
[1 rows x 5 columns]
2025-06-04 17:50:54,110 - IOOppi_data - INFO : save diff data to db: IOOppi_pb_t: no diff data
2025-06-04 17:50:54,115 - IOOppi_data - INFO : save data to db IOOppi_pb_g data:
date value
3710 2025-05-31 16487.5
3711 2025-06-01 16487.5
3712 2025-06-02 16487.5
3713 2025-06-03 16462.5
3714 2025-06-04 16525.0
2025-06-04 17:50:54,186 - IOOppi_data - INFO : save new data to db IOOppi_pb_g: date value ... created_at updated_at
3717 2025-06-04 16525.0 ... 2025-06-04 17:50:54.179275 2025-06-04 17:50:54.179649
[1 rows x 5 columns]
2025-06-04 17:50:54,205 - 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-04 17:50:54,765 - IOOppi_data - INFO : save data to db IOOppi_hc_t data:
date value
2985 2025-05-31 3196.67
2986 2025-06-01 3196.67
2987 2025-06-02 3196.67
2988 2025-06-03 3183.33
2989 2025-06-04 3183.33
2025-06-04 17:50:54,827 - IOOppi_data - INFO : save new data to db IOOppi_hc_t: date value ... created_at updated_at
2989 2025-06-04 3183.33 ... 2025-06-04 17:50:54.819953 2025-06-04 17:50:54.820343
[1 rows x 5 columns]
2025-06-04 17:50:54,847 - IOOppi_data - INFO : save diff data to db: IOOppi_hc_t: no diff data
2025-06-04 17:50:54,852 - IOOppi_data - INFO : save data to db IOOppi_hc_g data:
date value
2985 2025-05-31 3196.67
2986 2025-06-01 3196.67
2987 2025-06-02 3196.67
2988 2025-06-03 3183.33
2989 2025-06-04 3183.33
2025-06-04 17:50:54,915 - IOOppi_data - INFO : save new data to db IOOppi_hc_g: date value ... created_at updated_at
2992 2025-06-04 3183.33 ... 2025-06-04 17:50:54.908161 2025-06-04 17:50:54.908538
[1 rows x 5 columns]
2025-06-04 17:50:55,003 - 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-04 17:50:55,526 - IOOppi_data - INFO : save data to db IOOppi_fu_t data:
date value
3265 2025-05-31 5337.5
3266 2025-06-01 5337.5
3267 2025-06-02 5337.5
3268 2025-06-03 5337.5
3269 2025-06-04 5337.5
2025-06-04 17:50:55,593 - IOOppi_data - INFO : save new data to db IOOppi_fu_t: date value ... created_at updated_at
3269 2025-06-04 5337.5 ... 2025-06-04 17:50:55.585738 2025-06-04 17:50:55.586162
[1 rows x 5 columns]
2025-06-04 17:50:55,613 - IOOppi_data - INFO : save diff data to db: IOOppi_fu_t: no diff data
2025-06-04 17:50:55,619 - IOOppi_data - INFO : save data to db IOOppi_fu_g data:
date value
3265 2025-05-31 5337.5
3266 2025-06-01 5337.5
3267 2025-06-02 5337.5
3268 2025-06-03 5337.5
3269 2025-06-04 5337.5
2025-06-04 17:50:55,693 - IOOppi_data - INFO : save new data to db IOOppi_fu_g: date value ... created_at updated_at
3756 2025-06-04 5337.5 ... 2025-06-04 17:50:55.685908 2025-06-04 17:50:55.686296
[1 rows x 5 columns]
2025-06-04 17:50:55,712 - 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-04 17:50:56,218 - IOOppi_data - INFO : save data to db IOOppi_lh_t data:
date value
1329 2025-05-31 14530.0
1330 2025-06-01 14530.0
1331 2025-06-02 14530.0
1332 2025-06-03 14450.0
1333 2025-06-04 14470.0
2025-06-04 17:50:56,260 - IOOppi_data - INFO : save new data to db IOOppi_lh_t: date value ... created_at updated_at
1333 2025-06-04 14470.0 ... 2025-06-04 17:50:56.253100 2025-06-04 17:50:56.253487
[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-04 17:50:56,512 - IOOppi_data - INFO : save diff data to db IOOppi_lh_t: date ... updated_at
116 2021-07-05 ... 2025-06-04 17:50:56.504233
117 2021-07-06 ... 2025-06-04 17:50:56.504233
121 2021-07-12 ... 2025-06-04 17:50:56.504233
122 2021-07-13 ... 2025-06-04 17:50:56.504233
194 2021-11-01 ... 2025-06-04 17:50:56.504233
[5 rows x 6 columns]
2025-06-04 17:50:56,550 - IOOppi_data - INFO : save data to db IOOppi_lh_g data:
date value
1329 2025-05-31 14530.0
1330 2025-06-01 14530.0
1331 2025-06-02 14530.0
1332 2025-06-03 14450.0
1333 2025-06-04 14470.0
2025-06-04 17:50:56,593 - IOOppi_data - INFO : save new data to db IOOppi_lh_g: date value ... created_at updated_at
1336 2025-06-04 14470.0 ... 2025-06-04 17:50:56.586162 2025-06-04 17:50:56.586575
[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-04 17:50:56,847 - IOOppi_data - INFO : save diff data to db IOOppi_lh_g: date ... updated_at
116 2021-07-05 ... 2025-06-04 17:50:56.838834
117 2021-07-06 ... 2025-06-04 17:50:56.838834
121 2021-07-12 ... 2025-06-04 17:50:56.838834
122 2021-07-13 ... 2025-06-04 17:50:56.838834
194 2021-11-01 ... 2025-06-04 17:50:56.838834
[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-04 17:50:57,537 - IOOppi_data - INFO : save data to db IOOppi_cu_t data:
date value
3761 2025-05-31 78286.67
3762 2025-06-01 78286.67
3763 2025-06-02 78286.67
3764 2025-06-03 78483.33
3765 2025-06-04 78535.00
2025-06-04 17:50:57,611 - IOOppi_data - INFO : save new data to db IOOppi_cu_t: date value ... created_at updated_at
3765 2025-06-04 78535.0 ... 2025-06-04 17:50:57.603873 2025-06-04 17:50:57.604301
[1 rows x 5 columns]
2025-06-04 17:50:57,632 - IOOppi_data - INFO : save diff data to db: IOOppi_cu_t: no diff data
2025-06-04 17:50:57,638 - IOOppi_data - INFO : save data to db IOOppi_cu_g data:
date value
3761 2025-05-31 78286.67
3762 2025-06-01 78286.67
3763 2025-06-02 78286.67
3764 2025-06-03 78483.33
3765 2025-06-04 78535.00
2025-06-04 17:50:57,709 - IOOppi_data - INFO : save new data to db IOOppi_cu_g: date value ... created_at updated_at
3768 2025-06-04 78535.0 ... 2025-06-04 17:50:57.702652 2025-06-04 17:50:57.703066
[1 rows x 5 columns]
2025-06-04 17:50:57,729 - 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-04 17:50:58,219 - 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-04 17:50:58,274 - IOOppi_data - INFO : save new data to db: IOOppi_PM_t: no new data
2025-06-04 17:50:58,274 - IOOppi_data - INFO : save diff data to db: IOOppi_PM_t: no diff data
2025-06-04 17:50:58,280 - 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-04 17:50:58,339 - IOOppi_data - INFO : save new data to db: IOOppi_PM_g: no new data
2025-06-04 17:50:58,339 - 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-04 17:50:58,932 - IOOppi_data - INFO : save data to db IOOppi_sn_t data:
date value
2739 2025-05-31 251325.0
2740 2025-06-01 251325.0
2741 2025-06-02 251325.0
2742 2025-06-03 250337.5
2743 2025-06-04 255450.0
2025-06-04 17:50:58,990 - IOOppi_data - INFO : save new data to db IOOppi_sn_t: date ... updated_at
2743 2025-06-04 ... 2025-06-04 17:50:58.984050
[1 rows x 5 columns]
2025-06-04 17:50:59,010 - IOOppi_data - INFO : save diff data to db: IOOppi_sn_t: no diff data
2025-06-04 17:50:59,016 - IOOppi_data - INFO : save data to db IOOppi_sn_g data:
date value
2739 2025-05-31 251325.0
2740 2025-06-01 251325.0
2741 2025-06-02 251325.0
2742 2025-06-03 250337.5
2743 2025-06-04 255450.0
2025-06-04 17:50:59,076 - IOOppi_data - INFO : save new data to db IOOppi_sn_g: date ... updated_at
2746 2025-06-04 ... 2025-06-04 17:50:59.069687
[1 rows x 5 columns]
2025-06-04 17:50:59,095 - 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-04 17:50:59,753 - IOOppi_data - INFO : save data to db IOOppi_zn_t data:
date value
3760 2025-05-31 22738.0
3761 2025-06-01 22738.0
3762 2025-06-02 22738.0
3763 2025-06-03 22714.0
3764 2025-06-04 22886.0
2025-06-04 17:50:59,824 - IOOppi_data - INFO : save new data to db IOOppi_zn_t: date value ... created_at updated_at
3764 2025-06-04 22886.0 ... 2025-06-04 17:50:59.817252 2025-06-04 17:50:59.817637
[1 rows x 5 columns]
2025-06-04 17:50:59,844 - IOOppi_data - INFO : save diff data to db: IOOppi_zn_t: no diff data
2025-06-04 17:50:59,849 - IOOppi_data - INFO : save data to db IOOppi_zn_g data:
date value
3760 2025-05-31 22738.0
3761 2025-06-01 22738.0
3762 2025-06-02 22738.0
3763 2025-06-03 22714.0
3764 2025-06-04 22886.0
2025-06-04 17:50:59,923 - IOOppi_data - INFO : save new data to db IOOppi_zn_g: date value ... created_at updated_at
3767 2025-06-04 22886.0 ... 2025-06-04 17:50:59.915870 2025-06-04 17:50:59.916262
[1 rows x 5 columns]
2025-06-04 17:50:59,942 - 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-04 17:51:00,477 - IOOppi_data - INFO : save data to db IOOppi_wr_t data:
date value
3723 2025-05-31 3260.0
3724 2025-06-01 3260.0
3725 2025-06-02 3260.0
3726 2025-06-03 3260.0
3727 2025-06-04 3237.5
2025-06-04 17:51:00,548 - IOOppi_data - INFO : save new data to db IOOppi_wr_t: date value ... created_at updated_at
3727 2025-06-04 3237.5 ... 2025-06-04 17:51:00.541331 2025-06-04 17:51:00.541714
[1 rows x 5 columns]
2025-06-04 17:51:00,569 - IOOppi_data - INFO : save diff data to db: IOOppi_wr_t: no diff data
2025-06-04 17:51:00,574 - IOOppi_data - INFO : save data to db IOOppi_wr_g data:
date value
3723 2025-05-31 3260.0
3724 2025-06-01 3260.0
3725 2025-06-02 3260.0
3726 2025-06-03 3260.0
3727 2025-06-04 3237.5
2025-06-04 17:51:00,646 - IOOppi_data - INFO : save new data to db IOOppi_wr_g: date value ... created_at updated_at
3730 2025-06-04 3237.5 ... 2025-06-04 17:51:00.639249 2025-06-04 17:51:00.639630
[1 rows x 5 columns]
2025-06-04 17:51:00,666 - 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-04 17:51:01,195 - IOOppi_data - INFO : save data to db IOOppi_pg_t data:
date value
1520 2025-05-31 4750.0
1521 2025-06-01 4750.0
1522 2025-06-02 4750.0
1523 2025-06-03 4757.5
1524 2025-06-04 4765.0
2025-06-04 17:51:01,255 - IOOppi_data - INFO : save new data to db IOOppi_pg_t: date value ... created_at updated_at
1524 2025-06-04 4765.0 ... 2025-06-04 17:51:01.247460 2025-06-04 17:51:01.248064
[1 rows x 5 columns]
2025-06-04 17:51:01,275 - IOOppi_data - INFO : save diff data to db: IOOppi_pg_t: no diff data
2025-06-04 17:51:01,281 - IOOppi_data - INFO : save data to db IOOppi_pg_g data:
date value
1520 2025-05-31 4750.0
1521 2025-06-01 4750.0
1522 2025-06-02 4750.0
1523 2025-06-03 4757.5
1524 2025-06-04 4765.0
2025-06-04 17:51:01,325 - IOOppi_data - INFO : save new data to db IOOppi_pg_g: date value ... created_at updated_at
1527 2025-06-04 4765.0 ... 2025-06-04 17:51:01.318549 2025-06-04 17:51:01.318953
[1 rows x 5 columns]
2025-06-04 17:51:01,345 - 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-04 17:51:01,878 - IOOppi_data - INFO : save data to db IOOppi_cs_t data:
date value
2794 2025-05-31 2294.29
2795 2025-06-01 2294.29
2796 2025-06-02 2294.29
2797 2025-06-03 2297.14
2798 2025-06-04 2297.14
2025-06-04 17:51:01,944 - IOOppi_data - INFO : save new data to db IOOppi_cs_t: date value ... created_at updated_at
2798 2025-06-04 2297.14 ... 2025-06-04 17:51:01.936576 2025-06-04 17:51:01.937002
[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-04 17:51:01,990 - IOOppi_data - INFO : save diff data to db IOOppi_cs_t: date ... updated_at
2797 2025-06-03 ... 2025-06-04 17:51:01.982670
[1 rows x 6 columns]
2025-06-04 17:51:02,016 - IOOppi_data - INFO : save data to db IOOppi_cs_g data:
date value
2794 2025-05-31 2294.29
2795 2025-06-01 2294.29
2796 2025-06-02 2294.29
2797 2025-06-03 2297.14
2798 2025-06-04 2297.14
2025-06-04 17:51:02,081 - IOOppi_data - INFO : save new data to db IOOppi_cs_g: date value ... created_at updated_at
2801 2025-06-04 2297.14 ... 2025-06-04 17:51:02.073547 2025-06-04 17:51:02.074026
[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-04 17:51:02,125 - IOOppi_data - INFO : save diff data to db IOOppi_cs_g: date ... updated_at
2800 2025-06-03 ... 2025-06-04 17:51:02.118214
[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-04 17:51:02,712 - IOOppi_data - INFO : save data to db IOOppi_cs_t data:
date value
2794 2025-05-31 2294.29
2795 2025-06-01 2294.29
2796 2025-06-02 2294.29
2797 2025-06-03 2297.14
2798 2025-06-04 2898.00
2025-06-04 17:51:02,764 - 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-04 17:51:02,787 - IOOppi_data - INFO : save diff data to db IOOppi_cs_t: date ... updated_at
2798 2025-06-04 ... 2025-06-04 17:51:02.780157
[1 rows x 6 columns]
2025-06-04 17:51:02,814 - IOOppi_data - INFO : save data to db IOOppi_cs_g data:
date value
2794 2025-05-31 2294.29
2795 2025-06-01 2294.29
2796 2025-06-02 2294.29
2797 2025-06-03 2297.14
2798 2025-06-04 2898.00
2025-06-04 17:51:02,867 - 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-04 17:51:02,890 - IOOppi_data - INFO : save diff data to db IOOppi_cs_g: date ... updated_at
2801 2025-06-04 ... 2025-06-04 17:51:02.883028
[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-04 17:51:03,407 - IOOppi_data - INFO : save data to db IOOppi_RS_t data:
date value
3151 2025-05-31 9456.67
3152 2025-06-01 9456.67
3153 2025-06-02 9456.67
3154 2025-06-03 9408.33
3155 2025-06-04 9238.33
2025-06-04 17:51:03,463 - IOOppi_data - INFO : save new data to db: IOOppi_RS_t: no new data
2025-06-04 17:51:03,463 - IOOppi_data - INFO : save diff data to db: IOOppi_RS_t: no diff data
2025-06-04 17:51:03,469 - IOOppi_data - INFO : save data to db IOOppi_RS_g data:
date value
3151 2025-05-31 9456.67
3152 2025-06-01 9456.67
3153 2025-06-02 9456.67
3154 2025-06-03 9408.33
3155 2025-06-04 9238.33
2025-06-04 17:51:03,527 - IOOppi_data - INFO : save new data to db: IOOppi_RS_g: no new data
2025-06-04 17:51:03,527 - 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-04 17:51:04,058 - IOOppi_data - INFO : save data to db IOOppi_eg_t data:
date value
1835 2025-05-31 4521.67
1836 2025-06-01 4521.67
1837 2025-06-02 4521.67
1838 2025-06-03 4518.33
1839 2025-06-04 4518.33
2025-06-04 17:51:04,106 - IOOppi_data - INFO : save new data to db IOOppi_eg_t: date value ... created_at updated_at
1839 2025-06-04 4518.33 ... 2025-06-04 17:51:04.099313 2025-06-04 17:51:04.099693
[1 rows x 5 columns]
2025-06-04 17:51:04,125 - IOOppi_data - INFO : save diff data to db: IOOppi_eg_t: no diff data
2025-06-04 17:51:04,130 - IOOppi_data - INFO : save data to db IOOppi_eg_g data:
date value
1835 2025-05-31 4521.67
1836 2025-06-01 4521.67
1837 2025-06-02 4521.67
1838 2025-06-03 4518.33
1839 2025-06-04 4518.33
2025-06-04 17:51:04,179 - IOOppi_data - INFO : save new data to db IOOppi_eg_g: date value ... created_at updated_at
1842 2025-06-04 4518.33 ... 2025-06-04 17:51:04.171986 2025-06-04 17:51:04.172364
[1 rows x 5 columns]
2025-06-04 17:51:04,198 - 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-04 17:51:04,934 - IOOppi_data - INFO : save data to db IOOppi_sp_t data:
date value
1844 2025-05-31 6216.67
1845 2025-06-01 6216.67
1846 2025-06-02 6216.67
1847 2025-06-03 6216.67
1848 2025-06-04 6216.67
2025-06-04 17:51:04,983 - IOOppi_data - INFO : save new data to db IOOppi_sp_t: date value ... created_at updated_at
1848 2025-06-04 6216.67 ... 2025-06-04 17:51:04.976129 2025-06-04 17:51:04.976510
[1 rows x 5 columns]
2025-06-04 17:51:05,003 - IOOppi_data - INFO : save diff data to db: IOOppi_sp_t: no diff data
2025-06-04 17:51:05,009 - IOOppi_data - INFO : save data to db IOOppi_sp_g data:
date value
1844 2025-05-31 6216.67
1845 2025-06-01 6216.67
1846 2025-06-02 6216.67
1847 2025-06-03 6216.67
1848 2025-06-04 6216.67
2025-06-04 17:51:05,057 - IOOppi_data - INFO : save new data to db IOOppi_sp_g: date value ... created_at updated_at
1851 2025-06-04 6216.67 ... 2025-06-04 17:51:05.050580 2025-06-04 17:51:05.050994
[1 rows x 5 columns]
2025-06-04 17:51:05,076 - 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-04 17:51:05,610 - IOOppi_data - INFO : save data to db IOOppi_p_t data:
date value
3512 2025-05-31 8542.0
3513 2025-06-01 8542.0
3514 2025-06-02 8542.0
3515 2025-06-03 8636.0
3516 2025-06-04 8540.0
2025-06-04 17:51:05,678 - IOOppi_data - INFO : save new data to db IOOppi_p_t: date value ... created_at updated_at
3516 2025-06-04 8540.0 ... 2025-06-04 17:51:05.671655 2025-06-04 17:51:05.672063
[1 rows x 5 columns]
2025-06-04 17:51:05,699 - IOOppi_data - INFO : save diff data to db: IOOppi_p_t: no diff data
2025-06-04 17:51:05,704 - IOOppi_data - INFO : save data to db IOOppi_p_g data:
date value
3512 2025-05-31 8542.0
3513 2025-06-01 8542.0
3514 2025-06-02 8542.0
3515 2025-06-03 8636.0
3516 2025-06-04 8540.0
2025-06-04 17:51:05,773 - IOOppi_data - INFO : save new data to db IOOppi_p_g: date value ... created_at updated_at
3519 2025-06-04 8540.0 ... 2025-06-04 17:51:05.766316 2025-06-04 17:51:05.766688
[1 rows x 5 columns]
2025-06-04 17:51:05,792 - IOOppi_data - INFO : save diff data to db: IOOppi_p_g: no diff data